{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Radio"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"comments":1,"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":"Radio","index":0,"n_rows":40,"n_cols":22,"rows_kept":40,"cut":false,"hidden":false,"merged":[[8,16,8,17],[2,14,2,17],[2,19,2,21],[3,14,3,17],[3,19,3,21],[14,20,14,21],[16,16,16,17],[9,6,9,8],[9,16,9,17],[12,10,12,11],[17,16,17,17],[19,1,19,3],[19,5,19,8],[23,16,23,17],[25,16,25,17],[27,2,27,5],[27,9,27,11],[34,9,34,11],[34,13,34,14],[28,2,28,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[31,13,31,14],[30,13,30,14],[1,2,2,9],[4,7,5,10],[1,11,2,12],[5,1,6,3],[22,5,23,8],[17,1,17,3],[13,10,13,11],[14,1,14,3],[14,10,14,11],[12,1,12,3],[8,1,8,3],[8,6,8,8],[8,10,8,11],[4,1,4,4],[31,20,32,21],[33,20,36,21],[39,2,39,4],[5,4,6,4],[35,2,35,5],[35,13,35,14],[36,2,36,4],[37,2,37,4],[38,2,38,4],[31,16,31,17],[32,13,32,14],[32,16,32,17],[33,13,33,14]]}
[]
[null,null,"Designed  By  Alex  Saunders    Use smillies to lock / unlock  sheet to edit.",null,null,null,null,null,null,null,null,"Unlocked"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You Can Enter Values As Formula    ie.    =2.7*Micro",null,null,null,null,"Total  Capaticity  Calculator"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR Simply as normal 0.0000027 either way its the same.",null,null,null,null,"1 - 3 series  &   4 - 5 parallel"]
[null,"Beware Some Values Can Be Rounded ",null,null,null,null,null,"This Colours Cells Only Can Be Changed",null,null,null,null,null,null,"Frequancy Hz","Henries","Capacitance","Resistance",null,"Series","Number Of"]
[null,"Sheet Decimal Point Value Here >",null,null,12,null,null,null,null,null,null,null,null,null,{"$f":"2*Mega","v":2000000},{"$f":"10*Pico","v":9.9999999999999994E-12},5.0000000000000002E-5,7.3332600000000001,null,"1/c","Capacitors","Farrad Value"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V7>0,ROUND(1/V7,6),\"\")","v":50000000000},"Serial 1",{"$f":"20*Pico","v":1.9999999999999999E-11}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Serial 2"]
[null,"Ohms Law Extra ",null,null,null,null,"Total  Resistance  Calculator",null,null,null,"Half-Wave Dipole Length",null,null,null,null,null,"Capacitor Reactance XC",null,null,"","Serial 3"]
[null,"V = I x R","I = V / R","R = V / I",null,null,"1 - 3 parallel   &   4 - 5 series",null,null,null,"Freq MHz >",443,null,null,null,null,"Formula Is   = 1 / (2Pi * f * C)",null,null,"c/1 Total","Parallel 4"]
[null,"Voltage","Current","Resistance",null,null,"Parallel","Number Of",null,null,"Feet","Inches",null,null,null,null,"Frequancy","Capacitance",null,{"$f":"IFERROR(ROUND(1/(SUM(T7:T9)),E6),\"\")","v":1.9999999999999999E-11},"Parallel 5"]
[null,"V = Volts","I = Amps","R = Ohms",null,null,"1/r","Resistors","Ohms Value",null,{"$f":"TRUNC((5904/L10)/12)","v":1},{"$f":"ROUND((5904/L10)-(K12*12),1)","v":1.3},null,null,null,null,{"$f":"O6","v":2000000},{"$f":"Q6","v":5.0000000000000002E-5},null,"Total  ","True Value =",{"$f":"ROUND(IF(T11=\"\",V10+V11,T11+V10+V11),E6)","v":1.9999999999999999E-11}]
[null,"Use the calculator to set Resistance ",null,null,null,null,{"$f":"IF(I13>0,ROUND(1/I13,6),\"\")","v":4.5455000000000002E-2},"Parallel 1",22,null,{"$f":"IF(L10>149.97,\"Ariel Length Cm =  \",\"Ariel Length Metres =  \")","v":"Ariel Length Cm =  "},null,null,null,null,null,"Xc  Answer  =",{"$f":"ROUND(1/(ppy*O6*Q6),E6)","v":1.5915494310000001E-3},null,"Value As >>>","Nano",{"$f":"ROUND(IF(U13=\"Nano\",V12*1000000000,IF(U13=\"Pico\",V12*1000000000000,V12*1000000)),E6)","v":0.02}]
[null,6,null,7.3332600000000001,null,null,4.5455000000000002E-2,"Parallel 2",22,null,{"$f":"ROUND(IF(K13=\"Ariel Length Metres =  \",((5904/L10)*2.54)/100,(5904/L10)*2.54),2)","v":33.85}]
[null,"↑ Leave Desired Value Above Empty ↑",null,null,null,null,4.5455000000000002E-2,"Parallel 3",22,null,"Allow extra  to trim  to resonace",null,null,null,null,null,null,null,null,null,"You Can Use These Names"]
[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":"818.19 mA"},null,null,null,"r/1 Total","Series 4",null,null,null,null,null,null,null,null,null,null,null,null,"Range","Times"]
[null,null,null,null,null,null,{"$f":"IFERROR(ROUND(1/(SUM(G13:G15)),E6),\"\")","v":7.3332600007330004},"Series 5",null,null,null,null,null,null,null,null,"Inductive Reactance XL",null,null,null,"Names","Values"]
[null,"> >>>  Power  <<< <",null,null,null,null,"Total  ","True Value =",{"$f":"ROUND(IF(G17=\"\",I16+I17,G17+I16+I17),E6)","v":7.3332600007330004},null,"RMS ","Power",null,null,null,null,"Formula is  -2Pi * f * L",null,null,null,"Tera","1000000000000"]
[null,null,null,null,null,null,null,null,null,null,"Value RMS","= Peek",null,null,null,null,"Frequancy","Henries",null,null,"Giga",{"$f":"1000000000","v":1000000000}]
[null,"Energy Formulas Power In Watts",null,null,null,"Z  Impeedance Matching",null,null,null,null,100,{"$f":"ROUND(K20/0.707,E6)","v":141.44271570014101},null,null,null,null,{"$f":"O6","v":2000000},{"$f":"P6","v":9.9999999999999994E-12},null,null,"Mega",{"$f":"1000000","v":1000000}]
[null,"V * I",null,null,null,"V1","R1","V2","R2",null,"Value Peek","= Rms",null,null,null,null,"XL  Answer  =",{"$f":"ROUND(ppy*O6*P6,E6)","v":1.25663706E-4},null,null,"Kilo",{"$f":"1000","v":1000}]
[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":4.909140000491},null,5,0.5,13.33,8,null,240,{"$f":"ROUND(K22*0.707,E6)","v":169.68},null,null,null,null,null,null,null,null,"-------------",0]
[null,"( V / R ) * V",null,null,null,{"$f":"IFERROR(ROUND((G22*I22*(F22-H22))/(G22*H22-I22*F22),E6),\"Re-try\")","v":0.99955002249900005},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Centi",0.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choose Type Here   ↓↓↓",null,null,null,"Milli",{"$f":"0.001","v":1E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Impedance  Z","a XC Circuit",null,null,"Micro",{"$f":"0.000001","v":9.9999999999999995E-7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R25=\"a XL Circuit\",\"Formula Is  = Sqrt( R ² + Xl ²\",\"Formula Is  = Sqrt( R ² + XC ²\")","v":"Formula Is  = Sqrt( R ² + XC ²"},null,null,null,"Nano",{"$f":"0.000000001","v":1.0000000000000001E-9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R is Ohms",{"$f":"IF(R25=\"a XL Circuit\",\"Xl is Reactance\",\"XC is Reactance\")","v":"XC is Reactance"},null,null,"Pico",{"$f":"0.000000000001","v":9.9999999999999998E-13}]
[null,null,"Voltage  Across   (Series  Risistors)",null,null,null,"R total =",{"$f":"ROUND(SUM(C31:G31),E6)","v":7.3332600007330004},null,"Visual Resistor Layout Diagram",null,null,null,null,null,null,{"$f":"R6","v":7.3332600000000001},{"$f":"IF(R25=\"a XL Circuit\",\"Xl = cell R21\",\"XC = cell R13\")","v":"XC = cell R13"},null,null,"Py",{"$f":"ROUND(PI(),E6)","v":3.1415926535900001}]
[null,null,"Total Value From Cell G17",null,null,"From I16","From I17","Total",null,{"$f":"IF(J34=1,\"R1\",IF(J34=2,\"R2\",IF(J34=4,\"R3\",IF(J34=3,\"R1 R2\",IF(J34=6,\"R2 R3\",IF(J34=7,\"R1 R2 R3\",IF(J34=5,\"R1 R3\",\"None\")))))))","v":"R1 R2 R3"},{"$f":"IF(I16>0,\"R4\",IF(I17>0,\"R5\",\"\"))","v":""},{"$f":"IF(L32>0,\"R5\",\"\")","v":""},null,null,null,null,"Z  Answer  =",{"$f":"IF(R6=0,\"Check Values\",IF(R25=\"a XL Circuit\",ROUND(SQRT((R6*R6)+(R21*R21)),E6),ROUND(SQRT((R6*R6)+(R13*R13)),E6)))","v":7.333260172708},null,null,"Ppy",{"$f":"ROUND(2*PI(),E6)","v":6.2831853071800001}]
[null,"Total Volts",{"$f":"J29&\" Parallel\"","v":"R1 R2 R3 Parallel"},null,null,"R4","R5","Amps",null,{"$f":"IF(I13>0,1,0)","v":1},{"$f":"IF(I14>0,2,0)","v":2},{"$f":"IF(I15>0,4,0)","v":4},null,null,null,null,null,null,null,null,"eg.  =2*Mega","eg.  =4.7*micro"]
[null,{"$f":"IF(B14=\"\",C16,B14)","v":6},{"$f":"G17","v":7.3332600007330004},null,null,{"$f":"I16","v":0},{"$f":"I17","v":0},{"$f":"IFERROR(ROUND(B31/SUM(C31:G31),E6),0)","v":0.81818999999999997},null,{"$f":"IF(AND(I13>0,I14=0),0,I13)","v":22},null,null,null,"Formula Explanation",null,null,null,null,null,null,{"$f":"2*V20","v":2000000},{"$f":"4.7*V25","v":4.6999999999999999E-6}]
[null,"Voltage Across",{"$f":"IFERROR(ROUND(B31*(C31/SUM(C31:G31)),E6),0)","v":6},null,null,{"$f":"IFERROR(ROUND(B31*(F31/SUM(C31:G31)),E6),0)","v":0},{"$f":"IFERROR(ROUND(B31*(G31/SUM(C31:G31)),E6),0)","v":0},{"$f":"E6&\" D Places\"","v":"12 D Places"},null,{"$f":"IF(I14>0,I14,IF(I13>0,I13,IF(AND(I13=0,I15>0),I15,0)))","v":22},{"$f":"IF(I16>0,I16,I17)","v":0},{"$f":"IF(AND(I16>0,I17>0),I17,0)","v":0},null,"Phase Angle  Volts To Current",null,null,"Phase Angle  Volts To Current",null,null,null,"A Name Example"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I13=0,I14=0),0,I15)","v":22},null,null,null,"Formula = Tan-1 (Xl / R )",null,null,"Formula = Tan-1 (Xl / R )"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J30:L30)","v":7},null,null,null,"Atan uses radians so we use ",null,null,"R is Ohms",{"$f":"IF(Q33=\"Formula = Tan-1 (Xl / R )\",\"Xl is Reactance\",\"XC is Reactance\")","v":"Xl is Reactance"},null,null,"ie  in the cells as required for XC Reactance enter the values for Cell Q6 =4.7*Micro and Cell O6  =2*Mega"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J31+J33=0,\"Only  Serial  Resistors \",\"Parallel   Resistors  In   The Circuit\")","v":"Parallel   Resistors  In   The Circuit"},null,null,null,"*180/Pi() converts it into Degrees °  ",null,null,{"$f":"R6","v":7.3332600000000001},{"$f":"IF(Q33=\"Formula = Tan-1 (Xl / R )\",R21,R13)","v":1.25663706E-4}]
[null,null,"Current  Across   (Parallel  Risistors)",null,null,null,"R total =",{"$f":"ROUND(I18,E6)","v":7.3332600007330004},null,null,null,null,null,"eg.  =(ATAN(1.2 / 20))*180/PI()",null,null,"Phase Angle °   =",{"$f":"IFERROR(ROUND((ATAN(R35/R6))*180/PI(),E6),\"check values\")","v":9.8182799899999991E-4}]
[null,null,"Voltage Value From  G13",null,null,"From G14","From G15","Total",null,null,null,null,null,"Phase Angle °  =",{"$f":"ROUND((ATAN(1.2/20))*180/Py,E6)","v":3.4336303624500002}]
[null,"Total Volts","R1",null,null,"R2","R3","Amps",null,null,null,null,null,null,null,null,null,null,null,null,"The Answer =",{"$f":"ROUND(1/(ppy*(2*Mega)*(4.7*Micro)),E6)","v":1.6931376925000002E-2}]
[null,{"$f":"C32","v":6},{"$f":"I13","v":22},null,null,{"$f":"I14","v":22},{"$f":"I15","v":22},{"$f":"IF(B39=0,0,IFERROR(ROUND(B31/SUM(C31:G31),E6),0))","v":0.81818999999999997}]
[null,"Current Across",{"$f":"IFERROR(ROUND(H39*(I13/SUM(I13:I15)*100)%,E6),0)","v":0.27272999999999997},null,null,{"$f":"IFERROR(ROUND(H39*(I14/SUM(I13:I15)*100)%,E6),0)","v":0.27272999999999997},{"$f":"IFERROR(ROUND(H39*(I15/SUM(I13:I15)*100)%,E6),0)","v":0.27272999999999997},{"$f":"E6&\" D Places\"","v":"12 D Places"}]