{"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":[[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],[5,7,5,11],[8,0,8,7],[4,2,4,4],[32,0,32,2],[31,0,31,2],[33,0,33,2],[13,0,14,2],[13,3,14,6]]}
["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.**"]
[3.3,3.3,3.3,4.2,2,0,18.5,"**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**"]
[null,null,"Modes",null,null,null,null,"**Consider Modifying RB, RA, or Increasing Total Hysteresis**"]
[null,null,"Output\nStage","Resistor \nRange","Comparator\nConfiguration",null,null,{"$f":"IF(G3<D3,\"Maximum Input Is less than High Threshold\",_xlfn.CONCAT(\"**Maximum voltage is greater than Vcc/2\",IF(behind_the_scenes!B34=\"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**"}]
[null,null,"OD","100kΩ","NON",null,null,null,"INPUT",null,"OUTPUT"]
[]
["Resistors"]
["R1 (Ω)","R2 (Ω)","R3 (Ω)","R4 (Ω)","R5 (Ω)","RA (Ω)","RB (Ω)"]
[{"$f":"IF(AND(behind_the_scenes!B34=\"HIGH\",E7=\"NON\"),IF(AND($E$7=\"NON\",NOT(behind_the_scenes!$D$34),NOT(behind_the_scenes!C34=\"RA, RB\")),0,behind_the_scenes!$E$28),IF(Tool!$E$7=\"INV\", behind_the_scenes!$B$5*$B$11*$D$11/($B$11+$D$11), behind_the_scenes!$B$2))","v":0},{"$f":"IF($D$7=\"MΩ\", 1000000, IF($D$7=\"10kΩ\", 10000, 100000))","v":100000},10000,{"$f":"IF(AND($E$7=\"NON\",NOT(behind_the_scenes!$D$34),behind_the_scenes!$B$34=\"HIGH\"),IF(behind_the_scenes!C34=\"RA, RB\",behind_the_scenes!G28,behind_the_scenes!$I$22),IF(behind_the_scenes!$B$34=\"LOW\",IF($E$7=\"INV\", behind_the_scenes!$I$5, behind_the_scenes!$E$2),IF($E$7=\"INV\",behind_the_scenes!$I$5,behind_the_scenes!$G$28)))","v":837963.60937827604},{"$f":"IF($D$7=\"MΩ\", 1000000, IF($D$7=\"10kΩ\", 10000, 100000))","v":100000},{"$f":"IF(AND($E$7=\"NON\",NOT(behind_the_scenes!$D$34)),behind_the_scenes!$D$22,behind_the_scenes!$C$28)","v":72559.74526932076},{"$f":"IF(AND($E$7=\"NON\",NOT(behind_the_scenes!$D$34)),behind_the_scenes!$H$22,behind_the_scenes!$D$28)","v":7105.2569551560373}]
[]
[]
["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":0.35182601617000758},{"$f":"$J$2","v":6471.5448483448235},{"$f":"Tool!$B$11","v":100000},{"$f":"IF(Tool!$C$7=\"OD\",Tool!$C$11,0)","v":10000},{"$f":"$F$2*(Tool!$B$3-behind_the_scenes!$A$2)/behind_the_scenes!$A$2","v":837963.60937827593},{"$f":"IF(Tool!$E$7=\"NON\",Tool!$E$11, 0)","v":100000},{"$f":"IF(Tool!$C$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":312162.16216216213},{"$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":-2158378378.3783779},{"$f":"(-$H$2+SQRT($H$2*$H$2-4*$G$2*$I$2))/(2*$G$2)","v":6471.5448483448235},null,null,"With R1, Set RA and RB",{"$f":"Tool!$F$12","v":0},{"$f":"Tool!$G$12","v":0},{"$f":"$J$2-behind_the_scenes!$N$2*behind_the_scenes!$O$2/(behind_the_scenes!$N$2+behind_the_scenes!$O$2)","v":{"$error":"#DIV/0!"}},{"$f":"behind_the_scenes!$O$2/behind_the_scenes!$N$2","v":{"$error":"#DIV/0!"}},{"$f":"$J$2","v":6471.5448483448235},"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":{"$error":"#DIV/0!"}},{"$f":"IF(Tool!$D$7=\"MΩ\", 1000000, IF(Tool!$D$7=\"10kΩ\", 10000, 100000))","v":100000},"With R1",{"$f":"Tool!$D$3*behind_the_scenes!$Q$3/(behind_the_scenes!$Q$3+1)","v":0.37459459459459454},{"$f":"Tool!$E$3*behind_the_scenes!$Q$3/(behind_the_scenes!$Q$3+1)","v":0.17837837837837836},{"$f":"behind_the_scenes!$W$2-behind_the_scenes!$X$2","v":0.19621621621621618}]
[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":72559.74526932076},{"$f":"behind_the_scenes!$N$3*behind_the_scenes!$Q$3","v":7105.2569551560373},0,{"$f":"Tool!$A$3*behind_the_scenes!$I$28/(Tool!$G$3-Tool!$A$3*behind_the_scenes!$I$28)","v":9.7922848664688408E-2},{"$f":"$J$2","v":6471.5448483448235},"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":837963.60937827604},{"$f":"IF(Tool!$D$7=\"MΩ\", 1000000, IF(Tool!$D$7=\"10kΩ\", 10000, 100000))","v":100000},"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":{"$error":"#DIV/0!"}},{"$f":"Tool!$E$3*behind_the_scenes!$O$2/(behind_the_scenes!$N$2+behind_the_scenes!$O$2)","v":{"$error":"#DIV/0!"}},{"$f":"behind_the_scenes!$W$3-behind_the_scenes!$X$3","v":{"$error":"#DIV/0!"}}]
[null,"A","B","C","D","X^2","X",1,"root",null,"Inverting Solution",null,"Set RB",{"$f":"$O$4/$Q$4","v":0},{"$f":"Tool!$G$12","v":0},{"$f":"$R$4-$O$4/($Q$4+1)","v":6471.5448483448235},{"$f":"Tool!$A$3*behind_the_scenes!$I$28/(Tool!$G$3-Tool!$A$3*behind_the_scenes!$I$28)","v":9.7922848664688408E-2},{"$f":"$J$2","v":6471.5448483448235},"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":{"$error":"#DIV/0!"}},{"$f":"IF(Tool!$D$7=\"MΩ\", 1000000, IF(Tool!$D$7=\"10kΩ\", 10000, 100000))","v":100000},"Set RB",{"$f":"Tool!$D$3*behind_the_scenes!$O$4/(behind_the_scenes!$N$4+behind_the_scenes!$O$4)","v":{"$error":"#DIV/0!"}},{"$f":"Tool!$E$3*behind_the_scenes!$O$4/(behind_the_scenes!$O$4+behind_the_scenes!$N$4)","v":{"$error":"#DIV/0!"}},{"$f":"behind_the_scenes!$W$4-behind_the_scenes!$X$4","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Tool!$B$3/(behind_the_scenes!$B$28+0.5*Tool!$F$3/1000)-1","v":17.5},{"$f":"Tool!$B$3-(behind_the_scenes!$A$28 - 0.5*Tool!$F$3/1000)","v":2.9254054054054053},{"$f":"(behind_the_scenes!$A$28-0.5*Tool!$F$3/1000)/Tool!$B$11","v":3.7459459459459453E-6},{"$f":"$G$2-(behind_the_scenes!$A$28-0.5*Tool!$F$3/1000)","v":2.9254054054054053},{"$f":"behind_the_scenes!$C$5/behind_the_scenes!$B$5-behind_the_scenes!$D$5*Tool!$B$11","v":-0.20742857142857138},{"$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":307182.85714285716},{"$f":"(behind_the_scenes!$C$5/behind_the_scenes!$B$5)*Tool!$B$11*$D$2","v":167166023.16602316},{"$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":1481453.0816813014},null,null,null,"Set RA",{"$f":"Tool!$F$12","v":0},{"$f":"$N$5*$Q$5","v":0},{"$f":"$R$5-$N$5/(1+1/$Q$5)","v":6471.5448483448235},{"$f":"Tool!$A$3*behind_the_scenes!$I$28/(Tool!$G$3-Tool!$A$3*behind_the_scenes!$I$28)","v":9.7922848664688408E-2},{"$f":"$J$2","v":6471.5448483448235},"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":{"$error":"#DIV/0!"}},{"$f":"IF(Tool!$D$7=\"MΩ\", 1000000, IF(Tool!$D$7=\"10kΩ\", 10000, 100000))","v":100000},"Set RA",{"$f":"Tool!$D$3*behind_the_scenes!$O$5/(behind_the_scenes!$N$5+behind_the_scenes!$O$5)","v":{"$error":"#DIV/0!"}},{"$f":"Tool!$E$3*behind_the_scenes!$O$5/(behind_the_scenes!$O$5+behind_the_scenes!$N$5)","v":{"$error":"#DIV/0!"}},{"$f":"behind_the_scenes!$W$5-behind_the_scenes!$X$5","v":{"$error":"#DIV/0!"}}]
[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":0},{"$f":"$Q$7-$N$7","v":0},{"$f":"$O$7/$N$7","v":{"$error":"#DIV/0!"}},{"$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":0},{"$f":"Tool!$G$12","v":0},{"$f":"$O$8/$N$8","v":{"$error":"#DIV/0!"}},{"$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!$C$7&Tool!$E$7","v":"ODNON"},"LOW",{"$f":"IF(behind_the_scenes!D34,\"FIND ALL\",\"\")","v":"FIND ALL"},{"$f":"behind_the_scenes!$B$34","v":"HIGH"},{"$f":"\"FIND ALL\"","v":"FIND ALL"},null,null,null,"Set RA and RB",{"$f":"Tool!$F$12","v":0},{"$f":"Tool!$G$12","v":0},{"$f":"$O$9/$N$9","v":{"$error":"#DIV/0!"}},{"$f":"$O$9+$N$9","v":0},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":{"$error":"#DIV/0!"}},{"$f":"Tool!$E$3*behind_the_scenes!$O$9/(behind_the_scenes!$N$9+behind_the_scenes!$O$9)","v":{"$error":"#DIV/0!"}},{"$f":"$W$9-$X$9","v":{"$error":"#DIV/0!"}}]
[null,"100kΩ","OD","NON",null,"HIGH",{"$f":"IF(behind_the_scenes!D34,\"\",\"RA, RB\")","v":""},null,null,null,null,null,"Set RB/RA",{"$f":"IF(Tool!$D$7=\"MΩ\", 1000000, IF(Tool!$D$7=\"10kΩ\", 10000, 100000))/(P10+1)","v":91081.08108108108},{"$f":"$N$10*$P$10","v":8918.9189189189165},{"$f":"Tool!$A$3*behind_the_scenes!$I$28/(Tool!$G$3-Tool!$A$3*behind_the_scenes!$I$28)","v":9.7922848664688408E-2},{"$f":"$O$10+$N$10","v":100000},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":0.37459459459459454},{"$f":"Tool!$E$3*behind_the_scenes!$O$10/(behind_the_scenes!$N$10+behind_the_scenes!$O$10)","v":0.17837837837837833},{"$f":"$W$10-$X$10","v":0.19621621621621621},"RB/RA set such that Req = dynamic selection value. EX: 10k, 100k, 1M"]
[null,"10kΩ",null,null,null,null,{"$f":"IF(Tool!$E$7=\"INV\",IF(behind_the_scenes!D34,\"\",\"RA+RB, RA\"),IF(NOT(behind_the_scenes!D34),\"\",\"RA\"))","v":"RA"}]
[null,null,null,null,null,null,{"$f":"IF(Tool!$E$7=\"INV\",IF(behind_the_scenes!$D$34,\"\",\"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":{"$error":"#DIV/0!"}},{"$f":"IF(Tool!$D$7=\"MΩ\", 1000000, IF(Tool!$D$7=\"10kΩ\", 10000, 100000))","v":100000},{"$f":"Tool!$D$3*Tool!$G$12/(Tool!$G$12+$D$22)+Tool!F3/1000","v":{"$error":"#DIV/0!"}},{"$f":"Tool!$E$3*Tool!$G$12/(Tool!$G$12+$D$22)-Tool!F3/1000","v":{"$error":"#DIV/0!"}}]
["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":{"$error":"#DIV/0!"}},{"$f":"IF(Tool!$D$7=\"MΩ\", 1000000, IF(Tool!$D$7=\"10kΩ\", 10000, 100000))","v":100000},{"$f":"Tool!$D$3*$H$22/(Tool!$F$12+$H$22)+Tool!F3/1000","v":{"$error":"#DIV/0!"}},{"$f":"Tool!$E$3*$H$22/(Tool!$F$12+$H$22)-Tool!F3/1000","v":{"$error":"#DIV/0!"}}]
["X^2","X",1,"RA","X^2","X",1,"RB","R4","Req"]
[{"$f":"$G$2*Tool!$G$12*(Tool!$G$12+$C$2)","v":0},{"$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":0},{"$f":"$C$2*Tool!$G$12^2*($C$2+$D$2)*(Tool!$E$3-Tool!$D$3)","v":0},{"$f":"(-$B$22+SQRT($B$22^2-4*$A$22*$C$22))/(2*$A$22)","v":{"$error":"#DIV/0!"}},{"$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":-24200000000.000004},{"$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":0},0,{"$f":"(-F22)/(E22)","v":0},{"$f":"IF(behind_the_scenes!$C$34=\"RB\",behind_the_scenes!$B$19,behind_the_scenes!$B$20)","v":{"$error":"#DIV/0!"}},{"$f":"IF(behind_the_scenes!$C$34=\"RB\",Tool!$G$12*behind_the_scenes!$D$22/(behind_the_scenes!$D$22+Tool!$G$12),IF(behind_the_scenes!$C$34=\"RA\",Tool!$F$12*behind_the_scenes!$H$22/(behind_the_scenes!$H$22+Tool!$F$12),$J$2))","v":6471.5448483448235}]
[null,null,"Rb/Ra",{"$f":"Tool!$G$12/behind_the_scenes!$D$22","v":{"$error":"#DIV/0!"}},{"$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":-22000000000},null,"Rb/Ra",{"$f":"$H$22/Tool!$F$12","v":{"$error":"#DIV/0!"}}]
[null,null,"RB",{"$f":"Tool!$G$12","v":0},{"$f":"Tool!$F$12*(($C$2+Tool!$F$12)*$G$2)","v":0},null,"RA",{"$f":"Tool!$F$12","v":0}]
[]
["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(behind_the_scenes!$B$34=\"LOW\",Tool!$D$3,IF(AND(Tool!$E$7=\"NON\",OR(behind_the_scenes!$C$34=\"FIND ALL\",behind_the_scenes!$C$34=\"RB\",behind_the_scenes!$C$34=\"RA\")),Tool!$D$3*$F$28/($F$28+1),Tool!$D$3*$D$28/($C$28+$D$28)))","v":0.37459459459459454},{"$f":"IF(behind_the_scenes!$B$34=\"LOW\",Tool!$E$3,IF(AND(Tool!$E$7=\"NON\",OR(behind_the_scenes!C34=\"FIND ALL\",behind_the_scenes!C34=\"RB\",behind_the_scenes!C34=\"RA\")),Tool!$E$3*$F$28/($F$28+1),Tool!$E$3*$D$28/($C$28+$D$28)))","v":0.17837837837837836},{"$f":"IF(Tool!$E$7=\"INV\",IF(behind_the_scenes!$C$34=\"RA+RB, RA\",$N$7,IF(behind_the_scenes!$C$34=\"RA+RB, RB\",$N$8,IF(behind_the_scenes!$C$34=\"RA, RB\",$N$9,$N$10))),IF(behind_the_scenes!$C$34=\"RA, RB\",$N$2,IF(behind_the_scenes!$C$34=\"FIND ALL\",$N$3,IF(behind_the_scenes!$C$34=\"RB\",$N$4,$N$5))))","v":72559.74526932076},{"$f":"IF(Tool!$E$7=\"INV\",IF(behind_the_scenes!$C$34=\"RA+RB, RA\",$O$7,IF(behind_the_scenes!$C$34=\"RA+RB, RB\",$O$8,IF(behind_the_scenes!$C$34=\"RA, RB\",$O$9,$O$10))),IF(behind_the_scenes!$C$34=\"RA, RB\",$O$2,IF(behind_the_scenes!$C$34=\"FIND ALL\",$O$3,IF(behind_the_scenes!$C$34=\"RB\",$O$4,$O$5))))","v":7105.2569551560373},{"$f":"IF(behind_the_scenes!$C$34=\"RA, RB\",$P$2,IF(behind_the_scenes!$C$34=\"FIND ALL\",$P$3,IF(behind_the_scenes!$C$34=\"RB\",$P$4,$P$5)))","v":0},{"$f":"IF(Tool!$E$7=\"INV\",IF(behind_the_scenes!$C$34=\"RA+RB, RA\",$P$7,IF(behind_the_scenes!$C$34=\"RA+RB, RB\",$P$8,IF(behind_the_scenes!$C$34=\"RA, RB\",$P$9,$P$10))),IF(behind_the_scenes!$C$34=\"RA, RB\",$Q$2,IF(behind_the_scenes!$C$34=\"FIND ALL\",$Q$3,IF(behind_the_scenes!$C$34=\"RB\",$Q$4,$Q$5))))","v":9.7922848664688408E-2},{"$f":"IF(behind_the_scenes!$C$34=behind_the_scenes!$G$9,behind_the_scenes!$T$3,IF(behind_the_scenes!$C$34=behind_the_scenes!$G$10,behind_the_scenes!$T$2,IF(behind_the_scenes!$C$34=behind_the_scenes!$G$11,behind_the_scenes!$T$5,behind_the_scenes!$T$4)))","v":837963.60937827604},{"$f":"IF(Tool!$E$7=\"INV\",IF(behind_the_scenes!$C$34=\"RA+RB, RA\",$Q$7,IF(behind_the_scenes!$C$34=\"RA+RB, RB\",$Q$8,IF(behind_the_scenes!$C$34=\"RA, RB\",$Q$9,$Q$10))),IF(behind_the_scenes!$C$34=\"RA, RB\",$R$2,IF(behind_the_scenes!$C$34=\"FIND ALL\",$R$3,IF(behind_the_scenes!$C$34=\"RB\",$R$4,$R$5))))","v":6471.5448483448235},0.5]
[null,"(mV)","Have the vl and vh values reference the appropriate values above"]
["Vh-Vl[th]=",{"$f":"IF(AND(behind_the_scenes!B34=\"HIGH\",NOT(behind_the_scenes!D34)),IF(behind_the_scenes!C34=\"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":196.2162162162162}]
["This portion of the calculations derive the output such that RA and RB are preset values (t = 0) to avoid circular references "]
[]
[null,"Input Voltge Range","Resistor Configuration","Drop Input Voltge"]
[null,{"$f":"IF(Tool!G3>Tool!A3/2,\"HIGH\",\"LOW\")","v":"HIGH"},"FIND ALL",true]
[]
[]
[]
[]
[]
[]
["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":0},"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"]