{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Op Amp Gain & BW"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Op Amp Gain & BW","index":0,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,"Op Amp Gain and Bandwidth"]
[null,"Electronic Design with Excel"]
[]
[]
[null,null,null,null,null,null,null,null,"Enter"]
[null,null,null,null,null,null,null,null,"Calc"]
[]
[null,"ALT-F11 to see VBA Function."]
[]
[null,"fu",1000000,"Unity Gain Bandwidth or Gain Bandwidth Product (GBP)"]
[]
[null,"K non =  R2/R1+1"]
[null,"K inv = -R2/R1"]
[null,"fbw = fu / K_op_non"]
[]
[null,"Non-Inverting Amplifier"]
[null,"R1","R2","K non",null,"fbw"]
[null,1000000000,1000,{"$f":"K_op_non(B18,C18)","v":1.0000009999999999},null,{"$f":"$C$10/K_op_non(B18,C18)","v":999999.00000100012}]
[null,1000,1000,{"$f":"K_op_non(B19,C19)","v":2},null,{"$f":"$C$10/K_op_non(B19,C19)","v":500000}]
[null,1000,9000,{"$f":"K_op_non(B20,C20)","v":10},null,{"$f":"$C$10/K_op_non(B20,C20)","v":100000}]
[null,1000,99000,{"$f":"K_op_non(B21,C21)","v":100},null,{"$f":"$C$10/K_op_non(B21,C21)","v":10000}]
[null,1000,999000,{"$f":"K_op_non(B22,C22)","v":1000},null,{"$f":"$C$10/K_op_non(B22,C22)","v":1000}]
[]
[]
[null,"Inverting Amplifier"]
[null,"R1","R2","K inv",null,"K non","fbw"]
[null,1000,1000,{"$f":"K_op_inv(B27,C27)","v":-1},null,{"$f":"K_op_non(B27,C27)","v":2},{"$f":"$C$10/K_op_non(B27,C27)","v":500000}]
[null,1000,2000,{"$f":"K_op_inv(B28,C28)","v":-2},null,{"$f":"K_op_non(B28,C28)","v":3},{"$f":"$C$10/K_op_non(B28,C28)","v":333333.33333333331}]
[null,1000,10000,{"$f":"K_op_inv(B29,C29)","v":-10},null,{"$f":"K_op_non(B29,C29)","v":11},{"$f":"$C$10/K_op_non(B29,C29)","v":90909.090909090912}]
[null,1000,100000,{"$f":"K_op_inv(B30,C30)","v":-100},null,{"$f":"K_op_non(B30,C30)","v":101},{"$f":"$C$10/K_op_non(B30,C30)","v":9900.9900990099013}]
[null,1000,1000000,{"$f":"K_op_inv(B31,C31)","v":-1000},null,{"$f":"K_op_non(B31,C31)","v":1001},{"$f":"$C$10/K_op_non(B31,C31)","v":999.00099900099895}]