{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Resistors","Various","Capacitors"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"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":"Resistors","index":0,"n_rows":26,"n_cols":17,"rows_kept":26,"cut":false,"hidden":false,"merged":[[20,1,20,3],[18,6,18,8],[25,6,25,8],[1,2,2,9],[4,6,5,9],[5,1,6,3],[18,1,18,3],[14,1,14,3],[12,1,12,3],[8,1,8,3],[7,6,7,8],[4,1,4,4],[8,6,8,8],[22,11,22,13],[5,4,6,4],[18,11,18,14],[19,11,19,13],[20,11,20,13],[21,11,21,13],[7,11,7,14],[8,11,8,13],[9,11,9,13],[10,11,10,13],[11,11,11,13]]}
[]
[null,null,"Designed  By  Alex  Saunders    Use smillies to lock / unlock  sheet to edit."]
[]
[]
[null,"Beware Some Values Can Be Rounded ",null,null,null,null,"This Colours Cells Only Can Be Changed"]
[null,"Sheet Decimal Point Value Here >",null,null,9]
[]
[null,null,null,null,null,null,"Total  Resistance  Calculator",null,null,null,null,"Voltage  Across   (Series  Risistors)",null,null,null,"R total =",{"$f":"ROUND(SUM(L11:P11),E6)","v":56.406024365}]
[null,"Ohms Law Extra ",null,null,null,null,"1 - 3 parallel   &   4 - 5 series",null,null,null,null,"Total Value From Cell G17",null,null,"From I16","From I17","Total"]
[null,"V = I x R","I = V / R","R = V / I",null,null,"Parallel","Number Of",null,null,"Total Volts",{"$f":"S29&\" Parallel\"","v":" Parallel"},null,null,"R4","R5","Amps"]
[null,"Voltage","Current","Resistance",null,null,"1/r","Resistors","Ohms Value",null,{"$f":"IF(B14=\"\",C16,B14)","v":240},{"$f":"G16","v":12.406024365},null,null,{"$f":"I15","v":22},{"$f":"I16","v":22},{"$f":"IFERROR(ROUND(K11/SUM(L11:P11),E6),0)","v":4.2548646659999996}]
[null,"V = Volts","I = Amps","R = Ohms",null,null,{"$f":"IF(I12>0,ROUND(1/I12,6),\"\")","v":3.0303E-2},"Parallel 1",33,null,"Voltage Across",{"$f":"IFERROR(ROUND(K11*(L11/SUM(L11:P11)),E6),0)","v":52.785954711999999},null,null,{"$f":"IFERROR(ROUND(K11*(O11/SUM(L11:P11)),E6),0)","v":93.607022643999997},{"$f":"IFERROR(ROUND(K11*(P11/SUM(L11:P11)),E6),0)","v":93.607022643999997},{"$f":"E6&\" D Places\"","v":"9 D Places"}]
[null,"Use the calculator to set Resistance ",null,null,null,null,0.02,"Parallel 2",50]
[null,240,null,56.406024365,null,null,3.0303E-2,"Parallel 3",33]
[null,"↑ Leave Desired Value Above Empty ↑",null,null,null,null,"r/1 Total","Series 4",22]
[null,"ANSWER >>>",{"$f":"IF(B14=0,IF(OR(C14=0,D14=0),0,IF(AND((C14*D14)<1,(C14*D14)>0.001),MROUND(((C14*D14)*1000),0.001)&\" mV\",IF((C14*D14)<0.001,MROUND(((C14*D14)*1000000),0.001)&\" uV\",MROUND((C14*D14),0.001)&\" Volts\"))),(IF(C14=0,IF(OR(B14=0,D14=0),0,IF(AND((B14/D14)<1,(B14/D14)>0.001),MROUND(((B14/D14)*1000),0.001)&\" mA\",IF((B14/D14)<0.001,MROUND(((B14/D14)*1000000),0.001)&\" uA\",MROUND((B14/D14),0.001)&\" Amps\"))),IF(D14=0,IF(OR(B14=0,C14=0),0,IF(AND((B14/C14)<1,(B14/C14)>0.001),MROUND(((B14/C14)*1000),0.001)&\" mΩ\",IF((B14/C14)<0.001,MROUND(((B14/C14)*1000000),0.001)&\" uΩ\",MROUND((B14/C14),0.001)&\" Ohms\"))),\"Leave Desired Quantity Empty\"))))","v":"4.255 Amps"},null,null,null,{"$f":"IFERROR(ROUND(1/(SUM(G12:G14)),E6),\"\")","v":12.406024365},"Series 5",22]
[null,null,null,null,null,null,"Total  ","True Value =",{"$f":"ROUND(IF(G16=\"\",I15+I16,G16+I15+I16),E6)","v":56.406024365}]
[]
[null,"> >>>  Power  <<< <",null,null,null,null,"Visual Resistor Layout Diagram",null,null,null,null,"Current  Across   (Parallel  Resistors)",null,null,null,"R total =",{"$f":"ROUND(I17,E6)","v":56.406024365}]
[null,null,null,null,null,null,{"$f":"IF(G25=1,\"R1\",IF(G25=2,\"R2\",IF(G25=4,\"R3\",IF(G25=3,\"R1 R2\",IF(G25=6,\"R2 R3\",IF(G25=7,\"R1 R2 R3\",IF(G25=5,\"R1 R3\",\"None\")))))))","v":"None"},{"$f":"IF(I15>0,\"R4\",IF(I16>0,\"R5\",\"\"))","v":"R4"},{"$f":"IF(U32>0,\"R5\",\"\")","v":""},null,null,"Voltage Value From  G13",null,null,"From G14","From G15","Total"]
[null,"Energy Formulas Power In Watts",null,null,null,null,{"$f":"IF(I12>0,1,0)","v":1},{"$f":"IF(I13>0,2,0)","v":2},{"$f":"IF(I14>0,4,0)","v":4},null,"Total Volts","R1",null,null,"R2","R3","Amps"]
[null,"V * I",null,null,null,null,{"$f":"IF(AND($I$12>0,$I$13=0),0,$I$12)","v":33},null,null,null,{"$f":"L12","v":52.785954711999999},{"$f":"I12","v":33},null,null,{"$f":"I13","v":50},{"$f":"I14","v":33},{"$f":"IF(K22=0,0,IFERROR(ROUND(K11/SUM(L11:P11),E6),0))","v":4.2548646659999996}]
[null,"( I * I ) * R","=",{"$f":"ROUND(IF(D14=\"\",B14*C14,IF(C14=0,B14*(B14/D14),IF(B14=0,(C14*C14)*D14,0))),E6)","v":1021.167519754},null,null,{"$f":"IF(I13>0,I13,IF(I12>0,I12,IF(AND(I12=0,I14>0),I14,0)))","v":50},{"$f":"IF(I15>0,I15,I16)","v":22},{"$f":"IF(AND(I15>0,I16>0),I16,0)","v":22},null,"Current Across",{"$f":"IFERROR(ROUND(Q22*(I12/SUM(I12:I14)*100)%,E6),0)","v":1.2104356380000001},null,null,{"$f":"IFERROR(ROUND(Q22*(I13/SUM(I12:I14)*100)%,E6),0)","v":1.8339933909999999},{"$f":"IFERROR(ROUND(Q22*(I14/SUM(I12:I14)*100)%,E6),0)","v":1.2104356380000001},{"$f":"E6&\" D Places\"","v":"9 D Places"}]
[null,"( V / R ) * V",null,null,null,null,{"$f":"IF(AND(I12=0,I13=0),0,I14)","v":33}]
[null,null,null,null,null,null,{"$f":"SUM(S30:U30)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(G22+G24=0,\"Only  Serial  Resistors \",\"Parallel   Resistors  In   The Circuit\")","v":"Parallel   Resistors  In   The Circuit"}]

{"sheet":"Various","index":1,"n_rows":27,"n_cols":23,"rows_kept":27,"cut":false,"hidden":false,"merged":[[3,21,3,22],[20,21,21,22],[22,21,25,22],[1,3,1,21],[10,5,11,13],[3,5,5,13],[7,5,8,5],[7,6,9,6],[7,7,8,7],[7,8,9,8],[7,9,8,9],[7,10,9,10],[7,11,8,11],[7,12,9,12],[7,13,8,13],[23,1,23,2],[3,1,3,2],[7,1,7,2],[8,1,8,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2]]}
[]
[null,null,null,"Designed  By  Alex  Saunders    Use smillies to lock / unlock  sheet to edit."]
[]
[null,"Half-Wave Antenna",null,null,null,"Resistor Color Code Values",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You Can Use These Names"]
[null,"Freq MHz >",145,null,null,null,null,null,null,null,null,null,null,null,null,null,"Color","Value","Toll %","Multi","Total Val","Range/Cell","Times"]
[null,"Feet","Inches",null,null,null,null,null,null,null,null,null,null,null,null,null,"None",null,null,null,null,"Named Value","Values"]
[null,{"$f":"TRUNC((5904/C5)/12)","v":3},{"$f":"ROUND((5904/C5)-(B7*12),1)","v":4.7},null,null,{"$f":"IF(F8=\"\",0,VLOOKUP(F8,Q6:R19,2,0)*100)","v":900},null,{"$f":"VLOOKUP(H8,Q7:R16,2,0)*10","v":20},null,{"$f":"VLOOKUP(J8,Q7:R16,2,0)","v":0},null,{"$f":"VLOOKUP(L8,Q7:T18,4,0)","v":0.1},null,{"$f":"VLOOKUP(N8,Q7:S18,3,0)","v":5},null,null,"Black",0,0,1,"Ohm","Tera","1000000000000"]
[null,{"$f":"IF(C5>149.97,\"Ariel Length Cm =  \",\"Ariel Length Metres =  \")","v":"Ariel Length Metres =  "},null,null,null,"White",null,"Red",null,"Black",null,"Red",null,"Gold",null,null,"Brown",1,1,10,"Ohm","Giga",{"$f":"1000000000","v":1000000000}]
[null,{"$f":"ROUND(IF(B8=\"Ariel Length Metres =  \",((5904/C5)*2.54)/100,(5904/C5)*2.54),2)","v":1.03},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red",2,2,0.1,"K Ohm","Mega",{"$f":"1000000","v":1000000}]
[null,null,null,null,null,"Value 3",null,"Value 2",null,"Value 1",null,"Multiplier",null,"Tolarance",{"$f":"VLOOKUP(L8,Q7:U19,5,0)","v":"K Ohm"},null,"Orange",3,null,1,"K Ohm","Kilo",{"$f":"1000","v":1000}]
[null,null,null,null,null,{"$f":"SUM(F7:J7)*L7&\" \" &O10&\" \"&N7&\"% Tollerance\"","v":"92 K Ohm 5% Tollerance"},null,null,null,null,null,null,null,null,null,null,"Yellow",4,null,10,"K Ohm","Not Used",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Green",5,0.5,0.1,"M Ohm","Centi",0.01]
[null,"RMS ","Power",null,null,null,null,null,null,null,null,null,null,null,null,null,"Blue",6,0.25,1,"M Ohm","Milli",{"$f":"0.001","v":1E-3}]
[null,"Value RMS","= Peek",null,null,null,null,null,null,null,null,null,null,null,null,null,"Violet",7,0.1,10,"M Ohm","Micro",{"$f":"0.000001","v":9.9999999999999995E-7}]
[null,50,{"$f":"ROUND(B15/0.707,Resistors!E6)","v":70.721357850000004},null,null,null,null,null,null,null,null,null,null,null,null,null,"Grey",8,0.05,0.1,"G Ohm","Nano",{"$f":"0.000000001","v":1.0000000000000001E-9}]
[null,"Value Peek","= Rms",null,null,null,null,null,null,null,null,null,null,null,null,null,"White",9,null,1," G Ohm","Pico",{"$f":"0.000000000001","v":9.9999999999999998E-13}]
[null,50,{"$f":"ROUND(B17*0.707,Resistors!E6)","v":35.35},null,null,null,null,null,null,null,null,null,null,null,null,null,"Gold",null,5,0.1,"Ohms","Py",3.1419999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Silver",null,10,0.01,"Ohms","Ppy",6.2839999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"eg.  =2*Mega","eg.  =4.7*micro"]
[null,"Phase Angle  Volts To Current",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"2*Mega","v":2000000},{"$f":"4.7*Micro","v":4.6999999999999999E-6}]
[null,"Formula = Tan-1 (Xl / R )",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A Name Example"]
[null,"Atan uses radians so we use "]
[null,"*180/Pi() converts it into Degrees °  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Example of Use:  in  XL Inductance -  enter the values for Cell C6 =4.7*Micro and Cell B6  =2*Mega"]
[null,"eg.  =(ATAN(XL / R))*180/PI()"]
[null,"Phase Angle °  =",{"$f":"ROUND((ATAN(Capacitors!C23/Capacitors!E8))*180/Py,Resistors!E6)","v":84.534359503000005}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The Answer =",{"$f":"ROUND(Ppy*Capacitors!B8*Capacitors!C8,Resistors!E6)","v":590.69600000000003}]

{"sheet":"Capacitors","index":2,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[4,7,4,9],[5,1,5,4],[5,7,5,9],[10,1,10,2],[1,2,2,6],[4,1,4,4],[18,1,18,2],[19,1,19,2],[10,4,10,5],[12,4,12,5],[18,4,18,5],[19,4,19,5],[11,1,11,2]]}
[]
[null,null,"Designed  By  Alex  Saunders   Use smillies to lock / unlock  sheet to edit."]
[]
[]
[null,"You Can Enter Values As Formula    ie.    =2.7*Micro",null,null,null,null,null,"Total  Capacity  Calculator"]
[null,"OR Simply as normal 0.0000027 either way its the same.",null,null,null,null,null,"1 - 3 series  &   4 - 5 parallel"]
[null,"Frequency Hz","Henries","Capacitance","Resistance",null,null,"Series","Number Of"]
[null,{"$f":"2*Mega","v":2000000},{"$f":"47*Micro","v":4.6999999999999997E-5},53.333333332999999,56.406024365,null,null,"1/C","Capacitors","Micro Farad"]
[null,null,null,null,null,null,null,{"$f":"IF(J9>0,ROUND(1/(J9),Resistors!E6),\"\")","v":0.1},"Serial 1",10]
[null,null,null,null,null,null,null,{"$f":"IF(J10>0,ROUND(1/(J10),Resistors!E6),\"\")","v":0.1},"Serial 2",10]
[null,"Capacitor Reactance XC",null,null,"Choose Type Here   ↓↓↓",null,null,{"$f":"IF(J11>0,ROUND(1/(J11),Resistors!E6),\"\")","v":0.1},"Serial 3",10]
[null,"Formula Is   = 1 / (2Pi * f * C)",null,null,"Impedance  Z","a XL Circuit",null,"c/1 Total","Parallel 4",30]
[null,"Frequency","Capacitance",null,{"$f":"IF(F12=\"a XL Circuit\",\"Formula Is  = Sqrt( R ² + Xl ²\",\"Formula Is  = Sqrt( R ² + XC ²\")","v":"Formula Is  = Sqrt( R ² + Xl ²"},null,null,{"$f":"1/(SUM(H9:H11))","v":3.333333333333333},"Parallel 5",20]
[null,{"$f":"B8","v":2000000},{"$f":"ROUND(D8/1000000,Resistors!E6)","v":5.3332999999999999E-5},null,"R is Ohms",{"$f":"IF(F12=\"a XL Circuit\",\"Xl is Reactance\",\"XC is Reactance\")","v":"Xl is Reactance"},null,"Total  ","True Value =",{"$f":"ROUND(IF(H13=\"\",J12+J13,H13+J12+J13),Resistors!E6)","v":53.333333332999999}]
[null,"Xc  Answer  =",{"$f":"ROUND(1/(Ppy*B8*D8),Resistors!E6)","v":1.0000000000000001E-9},null,{"$f":"E8","v":56.406024365},{"$f":"IF($F$12=\"a XL Circuit\",\"Xl = cell C21\",\"XC = cell C13\")","v":"Xl = cell C21"}]
[null,null,null,null,"Z  Answer  =",{"$f":"IF(E8=0,\"Check Values\",IF(F12=\"a XL Circuit\",ROUND(SQRT((E8*E8)+(C23*C23)),Resistors!E6),ROUND(SQRT((E8*E8)+(C15*C15)),Resistors!E6)))","v":593.38301627299995}]
[]
[]
[null,"Inductive Reactance XL",null,null,"Phase Angle  Volts To Current"]
[null,"Formula is  -2Pi * f * L",null,null,"Formula = Tan-1 (Xl / R )"]
[null,"Frequency","Henries",null,"R is Ohms",{"$f":"IF(E20=\"Formula = Tan-1 (Xl / R )\",\"Xl is Reactance\",\"XC is Reactance\")","v":"Xl is Reactance"}]
[null,{"$f":"B8","v":2000000},{"$f":"C8","v":4.6999999999999997E-5},null,{"$f":"E8","v":56.406024365},{"$f":"IF($E$20=\"Formula = Tan-1 (Xl / R )\",$C$23,$C$15)","v":590.69600000000003}]
[null,"XL  Answer  =",{"$f":"ROUND(Ppy*B8*C8,Resistors!E6)","v":590.69600000000003},null,"Phase Angle °   =",{"$f":"IFERROR(ROUND((ATAN($C$23/$E$8))*180/Py,Resistors!$E$6),\"check values\")","v":84.534359503000005}]