{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tool","behind_the_scenes","Images"],"not_rendered":{"charts":0,"images":22,"macros":1,"external_links":0,"defined_names":14,"comments":2,"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":"Tool","index":0,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[32,0,32,2],[31,0,31,2],[33,0,33,2],[13,0,14,2],[13,3,14,6],[0,7,0,11],[0,0,0,6],[13,7,14,10],[1,7,1,11],[2,7,2,11],[3,7,3,11],[4,7,4,11],[4,0,4,5],[5,7,5,11],[8,0,8,7]]}
["Voltages",null,null,null,null,null,null,"**Hysteresis may be Susceptible to Minor Tolerance Errors**"]
["Vcc (V)","Vdiv (V)","Vpu (V)","Vh (V)","Vl (V)","Vhyst_int (mV)","Vin,max (V)","**R3 cannot be zero or have a negative value.**"]
[5,5,3.3,16.024999999999999,15.975,0,32,"**Inputs can only be numbers, no text. (e.g. no 'k' for 1000)**"]
[null,null,null,null,null,null,null,"**Check input parameters for incorrect voltage values**"]
["Modes",null,null,null,null,null,null,"**Consider Modifying RB, RA, or Increasing Total Hysteresis**"]
["Output\nStage","Resistor \nRange","Comparator\nConfiguration","Input Voltge Range","Resistor Configuration","Drop Input Voltge",null,{"$f":"_xlfn.CONCAT(\"**Maximum voltage is greater than Vcc/2\",IF(D7=\"LOW\",\"\nConsider Changing the Input Voltage Range**\",\"\nConsider Droping the Input Voltage**\"))","v":"**Maximum voltage is greater than Vcc/2\nConsider Droping the Input Voltage**"}]
["OD","MΩ","NON","HIGH","RA",true,null,null,"INPUT",null,"OUTPUT"]
[]
["Resistors"]
["R1 (Ω)","R2 (Ω)","R3 (Ω)","R4 (Ω)","R5 (Ω)","RA (Ω)","RB (Ω)",{"$f":"IF(C7=\"INV\",\"RA + RB (Ω)\",\"Req (Ω)\")","v":"Req (Ω)"}]
[{"$f":"IF(AND(D7=\"HIGH\",C7=\"NON\"),IF(AND($C$7=\"NON\",NOT($F$7),NOT(E7=\"RA, RB\")),0,behind_the_scenes!$E$28),IF(Tool!$C$7=\"INV\", behind_the_scenes!$B$5*$B$11*$D$11/($B$11+$D$11), behind_the_scenes!$B$2))","v":473.2979614406147},{"$f":"IF($B$7=\"MΩ\", 1000000, IF($B$7=\"10kΩ\", 10000, 100000))","v":1000000},100000,{"$f":"IF(AND($C$7=\"NON\",NOT($F$7),$D$7=\"HIGH\"),IF(E7=\"RA, RB\",behind_the_scenes!G28,behind_the_scenes!$I$22),IF($D$7=\"LOW\",IF($C$7=\"INV\", behind_the_scenes!$I$5, behind_the_scenes!$E$2),IF($C$7=\"INV\",behind_the_scenes!$I$5,behind_the_scenes!$G$28)))","v":2998770.1135433512},{"$f":"IF($B$7=\"MΩ\", 1000000, IF($B$7=\"10kΩ\", 10000, 100000))","v":1000000},{"$f":"IF(AND($C$7=\"NON\",NOT($F$7)),behind_the_scenes!$D$22,behind_the_scenes!$C$28)","v":10000},{"$f":"IF(AND($C$7=\"NON\",NOT($F$7)),behind_the_scenes!$H$22,behind_the_scenes!$D$28)","v":847.45762711864404},{"$f":"IF(AND($C$7=\"NON\",NOT($F$7)),behind_the_scenes!$J$22,behind_the_scenes!$H$28)","v":1254.5479614406147}]
[null,null,null,null,null,10000,1000]
[]
["INPUT\nSUBSTITUTION",null,null,"SCHEMATIC",null,null,null,"TRANSFER CURVE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["References"]
["Inverting Comparator Example Solution"]
["Non-Inverting Comparator Example Solution"]

{"sheet":"behind_the_scenes","index":1,"n_rows":84,"n_cols":26,"rows_kept":84,"cut":false,"hidden":true,"merged":[]}
["Vth","R1 (Ώ)","R2 (Ώ)","R3 (Ώ)","R4 (Ώ)","R5 (Ώ)","X^2 (Vpu or Vcc)","X",1,"Root","Non-inverting solution",null,"OD and PP NON-INV","Ra","Rb","R1","RB/RA","Req",null,"R4","R5",null,"Vh,new","Vl,new","Total Hyst"]
[{"$f":"(behind_the_scenes!$A$28-0.5*Tool!$F$3/1000)*behind_the_scenes!$C$2/(behind_the_scenes!$C$2+behind_the_scenes!$B$2)","v":1.2503844577275407},{"$f":"$J$2","v":1254.5479614406147},{"$f":"Tool!$B$11","v":1000000},{"$f":"IF(Tool!$A$7=\"OD\",Tool!$C$11,0)","v":100000},{"$f":"$F$2*(Tool!$B$3-behind_the_scenes!$A$2)/behind_the_scenes!$A$2","v":2998770.1135433516},{"$f":"IF(Tool!$C$7=\"NON\",Tool!$E$11, 0)","v":1000000},{"$f":"IF(Tool!$A$7=\"OD\",Tool!$C$3,Tool!$A$3)","v":3.3},{"$f":"$G$2*Tool!$B$11+(behind_the_scenes!$B$28+0.5*Tool!$F$3/1000)*($D$2+Tool!$B$11)-(behind_the_scenes!$A$28-0.5*Tool!$F$3/1000)*Tool!$B$11","v":3420898.4375},{"$f":"((behind_the_scenes!$B$28+0.5*Tool!$F$3/1000)-(behind_the_scenes!$A$28-0.5*Tool!$F$3/1000))*(Tool!$B$11^2+$D$2*Tool!$B$11)","v":-4296875000},{"$f":"(-$H$2+SQRT($H$2*$H$2-4*$G$2*$I$2))/(2*$G$2)","v":1254.5479614406147},null,null,"With R1, Set RA and RB",{"$f":"Tool!$F$12","v":10000},{"$f":"Tool!$G$12","v":1000},{"$f":"$J$2-behind_the_scenes!$N$2*behind_the_scenes!$O$2/(behind_the_scenes!$N$2+behind_the_scenes!$O$2)","v":345.45705234970558},{"$f":"behind_the_scenes!$O$2/behind_the_scenes!$N$2","v":0.1},{"$f":"$J$2","v":1254.5479614406147},"With R1",{"$f":"behind_the_scenes!$U$2*Tool!$B$3*(Tool!$B$11+$J$2)*(behind_the_scenes!$N$2+behind_the_scenes!$O$2)/(Tool!$B$11*behind_the_scenes!$O$2*Tool!$D$3)-behind_the_scenes!$U$2","v":2436443.0663263174},{"$f":"IF(Tool!$B$7=\"MΩ\", 1000000, IF(Tool!$B$7=\"10kΩ\", 10000, 100000))","v":1000000},"With R1",{"$f":"Tool!$D$3*behind_the_scenes!$Q$3/(behind_the_scenes!$Q$3+1)","v":1.2519531249999998},{"$f":"Tool!$E$3*behind_the_scenes!$Q$3/(behind_the_scenes!$Q$3+1)","v":1.2480468749999998},{"$f":"behind_the_scenes!$W$2-behind_the_scenes!$X$2","v":3.90625E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Without R1, Set Rb/Ra",{"$f":"behind_the_scenes!$R$3*(behind_the_scenes!$Q$3+1)/behind_the_scenes!$Q$3","v":16058.213906439869},{"$f":"behind_the_scenes!$N$3*behind_the_scenes!$Q$3","v":1360.8655852915142},0,{"$f":"Tool!$A$3*behind_the_scenes!$I$28/(Tool!$G$3-Tool!$A$3*behind_the_scenes!$I$28)","v":8.4745762711864403E-2},{"$f":"$J$2","v":1254.5479614406147},"Without R1",{"$f":"behind_the_scenes!$U$3*Tool!$B$3*(Tool!$B$11+$J$2)*(behind_the_scenes!$N$3+behind_the_scenes!$O$3)/(Tool!$B$11*behind_the_scenes!$O$3*Tool!$D$3)-behind_the_scenes!$U$3","v":2998770.1135433516},{"$f":"IF(Tool!$B$7=\"MΩ\", 1000000, IF(Tool!$B$7=\"10kΩ\", 10000, 100000))","v":1000000},"Without R1, Set Rb/Ra",{"$f":"Tool!$D$3*behind_the_scenes!$O$2/(behind_the_scenes!$N$2+behind_the_scenes!$O$2)","v":1.4568181818181816},{"$f":"Tool!$E$3*behind_the_scenes!$O$2/(behind_the_scenes!$N$2+behind_the_scenes!$O$2)","v":1.4522727272727274},{"$f":"behind_the_scenes!$W$3-behind_the_scenes!$X$3","v":4.5454545454541861E-3}]
[null,"A","B","C","D","X^2","X",1,"root",null,"Inverting Solution",null,"Set RB",{"$f":"$O$4/$Q$4","v":11800},{"$f":"Tool!$G$12","v":1000},{"$f":"$R$4-$O$4/($Q$4+1)","v":332.6729614406147},{"$f":"Tool!$A$3*behind_the_scenes!$I$28/(Tool!$G$3-Tool!$A$3*behind_the_scenes!$I$28)","v":8.4745762711864403E-2},{"$f":"$J$2","v":1254.5479614406147},"Set RB",{"$f":"behind_the_scenes!$U$4*Tool!$B$3*(Tool!$B$11+$J$2)*(behind_the_scenes!$N$4+behind_the_scenes!$O$4)/(Tool!$B$11*behind_the_scenes!$O$4*Tool!$D$3)-behind_the_scenes!$U$4","v":2998770.1135433516},{"$f":"IF(Tool!$B$7=\"MΩ\", 1000000, IF(Tool!$B$7=\"10kΩ\", 10000, 100000))","v":1000000},"Set RB",{"$f":"Tool!$D$3*behind_the_scenes!$O$4/(behind_the_scenes!$N$4+behind_the_scenes!$O$4)","v":1.2519531249999998},{"$f":"Tool!$E$3*behind_the_scenes!$O$4/(behind_the_scenes!$O$4+behind_the_scenes!$N$4)","v":1.248046875},{"$f":"behind_the_scenes!$W$4-behind_the_scenes!$X$4","v":3.906249999999778E-3}]
[null,{"$f":"Tool!$B$3/(behind_the_scenes!$B$28+0.5*Tool!$F$3/1000)-1","v":3.0062597809076692},{"$f":"Tool!$B$3-(behind_the_scenes!$A$28 - 0.5*Tool!$F$3/1000)","v":3.748046875},{"$f":"(behind_the_scenes!$A$28-0.5*Tool!$F$3/1000)/Tool!$B$11","v":1.2519531249999997E-6},{"$f":"$G$2-(behind_the_scenes!$A$28-0.5*Tool!$F$3/1000)","v":2.0480468749999998},{"$f":"behind_the_scenes!$C$5/behind_the_scenes!$B$5-behind_the_scenes!$D$5*Tool!$B$11","v":-5.2056220718377233E-3},{"$f":"(behind_the_scenes!$C$5/behind_the_scenes!$B$5)*(Tool!$B$11+$D$2)-behind_the_scenes!$D$5*$D$2*Tool!$B$11+behind_the_scenes!$E$5*Tool!$B$11","v":3294273.8157209782},{"$f":"(behind_the_scenes!$C$5/behind_the_scenes!$B$5)*Tool!$B$11*$D$2","v":124674750292.81619},{"$f":"(-behind_the_scenes!$G$5-SQRT(behind_the_scenes!$G$5*behind_the_scenes!$G$5-4*behind_the_scenes!$F$5*behind_the_scenes!$H$5))/(2*behind_the_scenes!$F$5)","v":632867843.63475156},null,null,null,"Set RA",{"$f":"Tool!$F$12","v":10000},{"$f":"$N$5*$Q$5","v":847.45762711864404},{"$f":"$R$5-$N$5/(1+1/$Q$5)","v":473.2979614406147},{"$f":"Tool!$A$3*behind_the_scenes!$I$28/(Tool!$G$3-Tool!$A$3*behind_the_scenes!$I$28)","v":8.4745762711864403E-2},{"$f":"$J$2","v":1254.5479614406147},"Set RA",{"$f":"behind_the_scenes!$U$5*Tool!$B$3*(Tool!$B$11+$J$2)*(behind_the_scenes!$N$5+behind_the_scenes!$O$5)/(Tool!$B$11*behind_the_scenes!$O$5*Tool!$D$3)-behind_the_scenes!$U$5","v":2998770.1135433512},{"$f":"IF(Tool!$B$7=\"MΩ\", 1000000, IF(Tool!$B$7=\"10kΩ\", 10000, 100000))","v":1000000},"Set RA",{"$f":"Tool!$D$3*behind_the_scenes!$O$5/(behind_the_scenes!$N$5+behind_the_scenes!$O$5)","v":1.2519531249999998},{"$f":"Tool!$E$3*behind_the_scenes!$O$5/(behind_the_scenes!$O$5+behind_the_scenes!$N$5)","v":1.248046875},{"$f":"behind_the_scenes!$W$5-behind_the_scenes!$X$5","v":3.906249999999778E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,"PP and OD INV","Ra","Rb","RB/RA","RA + RB",null,null,null,null,null,"Vh,new","Vl,new","Total Hyst"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Set RA and RA+RB",{"$f":"Tool!$F$12","v":10000},{"$f":"$Q$7-$N$7","v":-10000},{"$f":"$O$7/$N$7","v":-1},{"$f":"Tool!$H$12","v":0},null,null,null,null,"Set RA and Req",{"$f":"Tool!$D$3*behind_the_scenes!$O$7/(behind_the_scenes!$N$7+behind_the_scenes!$O$7)","v":{"$error":"#DIV/0!"}},{"$f":"Tool!$E$3*behind_the_scenes!$O$7/(behind_the_scenes!$N$7+behind_the_scenes!$O$7)","v":{"$error":"#DIV/0!"}},{"$f":"$W$7-$X$7","v":{"$error":"#DIV/0!"}}]
[null,"Power \nOptions","Out Stage\nOptions","Comp\nmode\noptions","Image\nCombo","Input\nImpedance\nOptions","Select Input INV","Input IMG","RB/RA Preset Alternative Text",null,null,null,"Set RB",{"$f":"$Q$8-$O$8","v":-1000},{"$f":"Tool!$G$12","v":1000},{"$f":"$O$8/$N$8","v":-1},{"$f":"Tool!$H$12","v":0},null,null,null,null,"Set RB and Req",{"$f":"Tool!$D$3*behind_the_scenes!$O$8/(behind_the_scenes!$N$8+behind_the_scenes!$O$8)","v":{"$error":"#DIV/0!"}},{"$f":"Tool!$E$3*behind_the_scenes!$O$8/(behind_the_scenes!$N$8+behind_the_scenes!$O$8)","v":{"$error":"#DIV/0!"}},{"$f":"$W$8-$X$8","v":{"$error":"#DIV/0!"}}]
[null,"MΩ","PP","INV",{"$f":"Tool!$A$7&Tool!$C$7","v":"ODNON"},"LOW",{"$f":"IF(Tool!F7,\"FIND ALL\",\"\")","v":"FIND ALL"},{"$f":"Tool!$D$7","v":"HIGH"},{"$f":"\"FIND ALL\"","v":"FIND ALL"},null,null,null,"Set RA and RB",{"$f":"Tool!$F$12","v":10000},{"$f":"Tool!$G$12","v":1000},{"$f":"$O$9/$N$9","v":0.1},{"$f":"$O$9+$N$9","v":11000},null,null,null,null,"Set RA and RB",{"$f":"Tool!$D$3*behind_the_scenes!$O$9/(behind_the_scenes!$N$9+behind_the_scenes!$O$9)","v":1.4568181818181816},{"$f":"Tool!$E$3*behind_the_scenes!$O$9/(behind_the_scenes!$N$9+behind_the_scenes!$O$9)","v":1.4522727272727274},{"$f":"$W$9-$X$9","v":4.5454545454541861E-3}]
[null,"100kΩ","OD","NON",null,"HIGH",{"$f":"IF(Tool!F7,\"\",\"RA, RB\")","v":""},null,null,null,null,null,"Set RB/RA",{"$f":"IF(Tool!$B$7=\"MΩ\", 1000000, IF(Tool!$B$7=\"10kΩ\", 10000, 100000))/(P10+1)","v":921875},{"$f":"$N$10*$P$10","v":78125},{"$f":"Tool!$A$3*behind_the_scenes!$I$28/(Tool!$G$3-Tool!$A$3*behind_the_scenes!$I$28)","v":8.4745762711864403E-2},{"$f":"$O$10+$N$10","v":1000000},null,null,null,null,"Set RB/RA",{"$f":"Tool!$D$3*behind_the_scenes!$O$10/(behind_the_scenes!$N$10+behind_the_scenes!$O$10)","v":1.251953125},{"$f":"Tool!$E$3*behind_the_scenes!$O$10/(behind_the_scenes!$N$10+behind_the_scenes!$O$10)","v":1.248046875},{"$f":"$W$10-$X$10","v":3.90625E-3},"RB/RA set such that Req = dynamic selection value. EX: 10k, 100k, 1M"]
[null,"10kΩ",null,null,null,null,{"$f":"IF(Tool!$C$7=\"INV\",IF(Tool!F7,\"\",\"RA+RB, RA\"),IF(NOT(Tool!F7),\"\",\"RA\"))","v":"RA"}]
[null,null,null,null,null,null,{"$f":"IF(Tool!$C$7=\"INV\",IF(Tool!$F$7,\"\",\"RA+RB, RB\"),\"RB\")","v":"RB"}]
[]
[]
[]
["OD-NON EXTRA"]
["In this section, we calculate RA and RB directly by using the thevanin relationship in the cookbook equations for the non-inverting configuration"]
["Find R4 WRT:",null,null,"Vh","Vl"]
["RA Calculated",{"$f":"$C$19*Tool!$B$3*(Tool!$B$11+$J$22)*($D$22+Tool!$G$12)/(Tool!$B$11*Tool!$G$12*Tool!$D$3)-$C$19","v":4444387.2181800893},{"$f":"IF(Tool!$B$7=\"MΩ\", 1000000, IF(Tool!$B$7=\"10kΩ\", 10000, 100000))","v":1000000},{"$f":"Tool!$D$3*Tool!$G$12/(Tool!$G$12+$D$22)+Tool!F3/1000","v":0.93116048239187454},{"$f":"Tool!$E$3*Tool!$G$12/(Tool!$G$12+$D$22)-Tool!F3/1000","v":0.92825514547333532}]
["RB Calculated",{"$f":"$C$20*Tool!$B$3*(Tool!$B$11+$J$22)*($H$22+Tool!$F$12)/(Tool!$B$11*Tool!$D$3*$H$22)-$C$20","v":-772727.2727272606},{"$f":"IF(Tool!$B$7=\"MΩ\", 1000000, IF(Tool!$B$7=\"10kΩ\", 10000, 100000))","v":1000000},{"$f":"Tool!$D$3*$H$22/(Tool!$F$12+$H$22)+Tool!F3/1000","v":22.306232204997212},{"$f":"Tool!$E$3*$H$22/(Tool!$F$12+$H$22)-Tool!F3/1000","v":22.23663397658849}]
["X^2","X",1,"RA","X^2","X",1,"RB","R4","Req"]
[{"$f":"$G$2*Tool!$G$12*(Tool!$G$12+$C$2)","v":3303300000},{"$f":"$C$2*Tool!$G$12*(Tool!$G$12+$C$2+$D$2)*(Tool!$E$3-Tool!$D$3)+Tool!$G$12^2*($D$2*Tool!$E$3+$C$2*$G$2)","v":-50152499999998.828},{"$f":"$C$2*Tool!$G$12^2*($C$2+$D$2)*(Tool!$E$3-Tool!$D$3)","v":-5.4999999999998824E+16},{"$f":"(-$B$22+SQRT($B$22^2-4*$A$22*$C$22))/(2*$A$22)","v":16209.707996667272},{"$f":"$C$2*($C$2+$D$2+Tool!$F$12)*(Tool!$E$3-Tool!$D$3)+Tool!$F$12*($D$2*Tool!$E$3+($C$2+Tool!$F$12)*$G$2)","v":-6194999999.9988174},{"$f":"$C$2*Tool!$F$12*((behind_the_scenes!$C$2+behind_the_scenes!$D$2)*(Tool!$E$3-Tool!$D$3)+behind_the_scenes!$G$2*Tool!$F$12)","v":-219999999999988.28},0,{"$f":"(-F22)/(E22)","v":-35512.510088786163},{"$f":"IF(Tool!$E$7=\"RB\",behind_the_scenes!$B$19,behind_the_scenes!$B$20)","v":-772727.2727272606},{"$f":"IF(Tool!$E$7=\"RB\",Tool!$G$12*behind_the_scenes!$D$22/(behind_the_scenes!$D$22+Tool!$G$12),IF(Tool!$E$7=\"RA\",Tool!$F$12*behind_the_scenes!$H$22/(behind_the_scenes!$H$22+Tool!$F$12),$J$2))","v":13919.645681745531}]
[null,null,"Rb/Ra",{"$f":"Tool!$G$12/behind_the_scenes!$D$22","v":6.1691425916222599E-2},{"$f":"$C$2*($C$2+Tool!$F$12)*(Tool!$E$3-Tool!$D$3)+Tool!$F$12*(($C$2+Tool!$F$12)*$G$2)","v":-17169999999.998924},null,"Rb/Ra",{"$f":"$H$22/Tool!$F$12","v":-3.5512510088786162}]
[null,null,"RB",{"$f":"Tool!$G$12","v":1000},{"$f":"Tool!$F$12*(($C$2+Tool!$F$12)*$G$2)","v":33330000000},null,"RA",{"$f":"Tool!$F$12","v":10000}]
[]
["In this section we use the thevanin equations by building off of the previously used equations directly. This allows us to set a limit such that the thevanin voltage avoids going beyond a percentage of Vcc"]
["Vh and Vl respectively",null,"RA Used","RB Used","R1 Used NON only","RB/RA","R4 NEW","Req or RA+RB","Vinmax % limit WRT Vcc"]
[{"$f":"IF(Tool!$D$7=\"LOW\",Tool!$D$3,IF(AND(Tool!$C$7=\"NON\",OR(Tool!$E$7=\"FIND ALL\",Tool!$E$7=\"RB\",Tool!$E$7=\"RA\")),Tool!$D$3*$F$28/($F$28+1),Tool!$D$3*$D$28/($C$28+$D$28)))","v":1.2519531249999998},{"$f":"IF(Tool!$D$7=\"LOW\",Tool!$E$3,IF(AND(Tool!$C$7=\"NON\",OR(Tool!E7=\"FIND ALL\",Tool!E7=\"RB\",Tool!E7=\"RA\")),Tool!$E$3*$F$28/($F$28+1),Tool!$E$3*$D$28/($C$28+$D$28)))","v":1.2480468749999998},{"$f":"IF(Tool!$C$7=\"INV\",IF(Tool!$E$7=\"RA+RB, RA\",$N$7,IF(Tool!$E$7=\"RA+RB, RB\",$N$8,IF(Tool!$E$7=\"RA, RB\",$N$9,$N$10))),IF(Tool!$E$7=\"RA, RB\",$N$2,IF(Tool!$E$7=\"FIND ALL\",$N$3,IF(Tool!$E$7=\"RB\",$N$4,$N$5))))","v":10000},{"$f":"IF(Tool!$C$7=\"INV\",IF(Tool!$E$7=\"RA+RB, RA\",$O$7,IF(Tool!$E$7=\"RA+RB, RB\",$O$8,IF(Tool!$E$7=\"RA, RB\",$O$9,$O$10))),IF(Tool!$E$7=\"RA, RB\",$O$2,IF(Tool!$E$7=\"FIND ALL\",$O$3,IF(Tool!$E$7=\"RB\",$O$4,$O$5))))","v":847.45762711864404},{"$f":"IF(Tool!$E$7=\"RA, RB\",$P$2,IF(Tool!$E$7=\"FIND ALL\",$P$3,IF(Tool!$E$7=\"RB\",$P$4,$P$5)))","v":473.2979614406147},{"$f":"IF(Tool!$C$7=\"INV\",IF(Tool!$E$7=\"RA+RB, RA\",$P$7,IF(Tool!$E$7=\"RA+RB, RB\",$P$8,IF(Tool!$E$7=\"RA, RB\",$P$9,$P$10))),IF(Tool!$E$7=\"RA, RB\",$Q$2,IF(Tool!$E$7=\"FIND ALL\",$Q$3,IF(Tool!$E$7=\"RB\",$Q$4,$Q$5))))","v":8.4745762711864403E-2},{"$f":"IF(Tool!$E$7=behind_the_scenes!$G$9,behind_the_scenes!$T$3,IF(Tool!$E$7=behind_the_scenes!$G$10,behind_the_scenes!$T$2,IF(Tool!$E$7=behind_the_scenes!$G$11,behind_the_scenes!$T$5,behind_the_scenes!$T$4)))","v":2998770.1135433512},{"$f":"IF(Tool!$C$7=\"INV\",IF(Tool!$E$7=\"RA+RB, RA\",$Q$7,IF(Tool!$E$7=\"RA+RB, RB\",$Q$8,IF(Tool!$E$7=\"RA, RB\",$Q$9,$Q$10))),IF(Tool!$E$7=\"RA, RB\",$R$2,IF(Tool!$E$7=\"FIND ALL\",$R$3,IF(Tool!$E$7=\"RB\",$R$4,$R$5))))","v":1254.5479614406147},0.5]
[null,"(mV)","Have the vl and vh values reference the appropriate values above"]
["Vh-Vl[th]=",{"$f":"IF(AND(Tool!D7=\"HIGH\",NOT(Tool!F7)),IF(Tool!E7=\"RA\",(behind_the_scenes!$D$19-behind_the_scenes!$E$19)*1000,(behind_the_scenes!$D$20-behind_the_scenes!$E$20)*1000),($A$28-$B$28)*1000)","v":3.90625}]
["This portion of the calculations derive the output such that RA and RB are preset values (t = 0) to avoid circular references "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Factor Rb"]
["Factor Ra"]
[]
[null,null,null,null,null,{"$f":"$C$2^2*Tool!$F$12*Tool!$E$3-behind_the_scenes!$C$2^2*Tool!$F$12*Tool!$D$3+behind_the_scenes!$C$2*behind_the_scenes!$G$2*Tool!$F$12^2-behind_the_scenes!$C$2*behind_the_scenes!$D$2*Tool!$D$3*Tool!$F$12+behind_the_scenes!$C$2*behind_the_scenes!$D$2*Tool!$E$3*Tool!$F$12","v":-219999999999998},"Vh","Vl","RA"]
[null,null,null,null,null,{"$f":"-F44/E44","v":{"$error":"#DIV/0!"}},"D","E","G12"]
[null,null,null,null,null,null,"RB","R2","R3"]
[null,null,null,null,null,null,"H12","C","D"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"** Equation Above Is longer than Shown"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"**Equation above is longer than shown in the image"]

{"sheet":"Images","index":2,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["TYPE_CONFIG","HYST_IM","COMP_CONFIG","SCHEMATIC_IM","IN_CONFIG","INPUT_IM"]
["INV",null,"PPNON",null,"LOW"]
["NON",null,"PPINV",null,"HIGH"]
[null,null,"ODNON"]
[null,null,"ODINV"]