{"text_format":"1","workbook":"xlsx","n_sheets":42,"sheets":["Index","Coulomb","Farad","Voltage Ripple Capacitor","VA (volt-amper)","Decibel","RF Free-space Path Loss","Volt Amper to Farad","Resistor Equivalence","AC Power Factor","AC Inductive Reactance X(L)","AC Capacitive Reactance X(C)","AC Voltage Phase Shift","AC Impedance","Back EMF of Inductor","Inductor Stored Energy","Coupling Capacitor","RMS to DC Converter","Coil Design","Ideal Transformer","Mutual inductance","Sinusoidal Waveform","Passive RC Filter","Passive LC Filter","Varicap Junction Capacitance","RC Charge Time","RL Charge Time","LC Resonance Frequency","AVR PWM","Maximum Power Transfer","Kirchhoff MATRIX","Thévenin`s theorem","Rect. Conductor Magnetic Field","AWG","Colpitts Oscilator","NPN Common Emitter","NPN Common Collector","NE555 Astable","Thermal Resistance","Thermal Noise","Heat Sink Calculator","Buck Converter Power Dissipated"],"not_rendered":{"charts":2,"images":21,"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":"Index","index":0,"n_rows":41,"n_cols":1,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Coulomb"]
["Farad"]
["Voltage Ripple Capacitor"]
["VA (volt-amper)"]
["Decibel"]
["RF Free-space Path Loss"]
["Volt Amper to Farad"]
["Resistor Equivalence"]
["AC Power Factor"]
["AC Inductive Reactance X(L)"]
["AC Capacitive Reactance X(C)"]
["AC Voltage Phase Shift"]
["AC Impedance"]
["Back EMF of Inductor"]
["Inductor Stored Energy"]
["Coupling Capacitor"]
["RMS to DC Converter"]
["Coil Design"]
["Ideal Transformer"]
["Mutual inductance"]
["Sinusoidal Waveform"]
["Passive RC Filter"]
["Passive LC Filter"]
["Varicap Junction Capacitance"]
["RC Charge Time"]
["RL Charge Time"]
["LC Resonance Frequency"]
["AVR PWM"]
["Maximum Power Transfer"]
["Kirchhoff MATRIX"]
["Thévenin`s theorem"]
["Rect. Conductor Magnetic Field"]
["AWG"]
["Colpitts Oscilator"]
["NPN Common Emitter"]
["NPN Common Collector"]
["NE555 Astable"]
["Thermal Resistance"]
["Thermal Noise"]
["Heat Sink Calculator"]
["Buck Converter Power Dissipated"]

{"sheet":"Coulomb","index":1,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Index"]
[]
[null,"Formulas:"]
[]
[]
[]
[]
[null,"Slove coulomb:"]
[null,null,"A=",5.0,"Amper"]
[null,null,"s=",{"$f":"1/480000","v":0.000002083333333},"Seconds"]
[null,null,"C=",{"$f":"D9*D10","v":0.00001041666667},"Coulomb"]
[]
[null,"Slove amper"]
[null,null,"C=",72.0,"Coulomb"]
[null,null,"s=",3600.0,"Seconds"]
[null,null,"A=",{"$f":"D14/D15","v":0.02},"Amper"]
[]
[null,"Slove seconds"]
[null,null,"C=",25200.0,"Coulomb"]
[null,null,"A=",0.4,"Amper"]
[null,null,"s=",{"$f":"D19/D20","v":63000},"Seconds"]
[]
[null,"References:"]
[null,null,"http://en.wikipedia.org/wiki/Coulomb"]

{"sheet":"Farad","index":2,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[]
[null,"Slove Farad:"]
[null,null,"C=",25200.0,"Coulomb"]
[null,null,"V=",12.0,"Volt"]
[null,null,"F=",{"$f":"D10/D11","v":2100},"Farad"]
[]
[]
[]
[]
[]
[]
[null,"References:"]
[null,null,"http://en.wikipedia.org/wiki/Farad"]

{"sheet":"Voltage Ripple Capacitor","index":3,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[]
[]
[null,"Slove Farad:"]
[null,null,"V=",1.0,"Volts"]
[null,null,"I=",4.0,"Amper"]
[null,null,"f=",10000.0,"Hz"]
[null,null,"t=",{"$f":"1/D13","v":0.0001},"Seconds"]
[null,null,"Q=",{"$f":"D12*D14","v":0.0004},"Coulomb"]
[null,null,"F=",{"$f":"D15/D11","v":0.0004},"Farad"]
[]
[]
[]
[null,"References:"]
[null,null,"https://pt.wikipedia.org/wiki/Ripple"]

{"sheet":"VA (volt-amper)","index":4,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Index"]
[]
[]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[null,"Single phase amps to VA:"]
[null,null,"A",20.0,"Amps"]
[null,null,"V",230.0,"Volts"]
[null,null,"VA",{"$f":"D11*D12","v":4600},"Volt-Amp"]
[]
[null,"Single phase VA to amps:","VA",3000.0,"Volt-Amp"]
[null,null,"V",230.0,"Volt"]
[null,null,"A",{"$f":"D15/D16","v":13.04347826},"Amps"]
[]
[null,"3 phase amps to VA:"]
[null,null,"A",1.08695652173913,"Amps"]
[null,null,"V",230.0,"Volts"]
[null,null,"VA",{"$f":"3*D20*D21","v":750},"Volt-Amp"]
[]
[null,"References:"]
[]
[null,null,"https://www.rapidtables.com/calc/electric/va-to-amps-calculator.html"]
[null,null,"https://pt.wikipedia.org/wiki/Voltampere"]

{"sheet":"Decibel","index":5,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Index"]
[]
[]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[null,"Slove Amplitude Gain:"]
[null,null,"V",20.0,"Volt"]
[null,null,"Vref",10.0,"Volt"]
[null,null,"VA",{"$f":"20*LOG(D11/D12)","v":6.020599913},"dBV"]
[]
[null,"Slove Power Gain:","W",20.0,"Watt"]
[null,null,"Wref",10.0,"Watt"]
[null,null,"A",{"$f":"10*LOG(D15/D16)","v":3.010299957},"dBW"]
[]
[null,"Slove RF Signal Srength"]
[null,null,"W",6.0E-4,"Watt"]
[null,null,"Wref",0.001,"Watt"]
[null,null,"VA",{"$f":"10*LOG(D20/D21)","v":-2.218487496},"dBm"]
[]
[]
[null,"Slove dBm to Watt:"]
[null,null,"dBm",-44.0,"dBm"]
[null,null,"W",{"$f":"10^(D26/10)*0.001","v":0.00000003981071706},"Watt"]
[]
[]
[]
[]
[]
[]
[]
[null,"References:"]

{"sheet":"RF Free-space Path Loss","index":6,"n_rows":45,"n_cols":18,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Index"]
[]
[]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"dB vs Power, Vrms and Vpp with impedance of 50 Ohms",null,null,null,null,null,"Distance (Metter) vs Attenuation (dB) and Power (W)"]
[null,null,null,null,null,null,null,"dB","Power","Vrms","Vpp",null,null,"Distance","Attenuation","Power","Vrms","Vpp"]
[null,"Slove Free-space path loss:","Power TX:",4.0,"Watt",null,null,0.0,{"$f":"10^(H23/10)","v":1},{"$f":"SQRT(I23/50)","v":0.1414213562},{"$f":"SQRT(2)*J23","v":0.2},"EXCELENT SIGNAL",null,0.1,-12.0,{"$f":"10^(O23/10)/$N$23","v":0.6309573445},{"$f":"SQRT(P23/50)","v":0.1123349763},{"$f":"SQRT(2)*P23","v":0.8923084338}]
[null,null,"Antenna Gain TX:",{"$f":"5/2.15","v":2.325581395},"dBi",null,null,-1.0,0.7943282347,0.1260419164,0.1782501876,null,null,{"$f":"N23*2","v":0.2},{"$f":"O23-6","v":-18},0.1584893192,0.05630085599,0.2241377448]
[null,null,"Antenna Gain RX:",2.325581395,"dBi",null,null,-2.0,0.6309573445,0.1123349763,0.1588656469,null,null,0.4,-24,0.03981071706,0.02821727026,0.05630085599]
[null,null,"Power Loss:",0.0,"dB",null,null,-3.0,0.5011872336,0.100118653,0.1415891569,null,null,0.8,-30,0.01,0.01414213562,0.01414213562]
[null,null,"Frequency:",2.4E9,"Hertz",null,null,-4.0,0.3981071706,0.08923084338,0.1261914689,null,null,1.6,-36,0.002511886432,0.007087857831,0.003552343859]
[null,null,"Distance:",35.0,"Metter",null,null,-5.0,0.316227766,0.07952707288,0.112468265,null,null,3.2,-42,0.0006309573445,0.003552343859,0.0008923084338]
[null,null,"Impedance:",50.0,"Ohm",null,null,-6.0,0.2511886432,0.07087857831,0.1002374467,null,null,6.4,-48,0.0001584893192,0.001780389391,0.0002241377448]
[null,null,"Speed of Ligth=",2.99792458E8,"Metter/s",null,null,-7.0,0.1995262315,0.06317059941,0.08933671843,null,null,12.8,-54,0.00003981071706,0.0008923084338,0.00005630085599]
[null,null,"Wavelength=",{"$f":"D30/D27","v":0.1249135242},"Lambda",null,null,-8.0,0.1584893192,0.05630085599,0.07962143411,null,null,25.6,-60,0.00001,0.0004472135955,0.00001414213562]
[null,null,"Power RX=",{"$f":"(10^(D24/10)*10^(D25/10)*10^(D26/10))*(D23/(4*PI()*D28^2))*((D31^2)/(4*PI()))","v":0.0000009415413029},"Watt",null,null,-9.0,0.1258925412,0.05017819072,0.07096267785,null,null,51.2,-66,0.000002511886432,0.0002241377448,0.000003552343859]
[null,null,"Vrms RX=",{"$f":"SQRT(D32/D29)","v":0.000137225457},"Volt RMS",null,null,-10.0,0.1,0.04472135955,0.0632455532,null,null,102.4,-72,0.0000006309573445,0.0001123349763,0.0000008923084338]
[null,null,"Vpp RX=",{"$f":"SQRT(2)*D33","v":0.0001940661024},"Volt Peak to Peak",null,null,-20.0,0.01,0.01414213562,0.02,null,null,204.8,-78,0.0000001584893192,0.00005630085599,0.0000002241377448]
[null,null,"FSPL=",{"$f":"10*LOG(D32)","v":-60.26160624},"dB",null,null,-30.0,0.001,0.004472135955,0.00632455532,"GOOD SIGNAL",null,409.6,-84,0.00000003981071706,0.00002821727026,0.00000005630085599]
[null,null,null,null,null,null,null,-40.0,0.0001,0.001414213562,0.002,null,null,819.2,-90,0.00000001,0.00001414213562,0.00000001414213562]
[null,null,null,null,null,null,null,-50.0,0.00001,0.0004472135955,0.000632455532,null,null,1638.4,-96,0.000000002511886432,0.000007087857831,0.000000003552343859]
[null,null,null,null,null,null,null,-60.0,0.000001,0.0001414213562,0.0002,"MEDIUM SIGNAL",null,3276.8,-102,0.0000000006309573445,0.000003552343859,0.0000000008923084338]
[null,"References:",null,null,null,null,null,-70.0,0.0000001,0.00004472135955,0.0000632455532,null,null,6553.6,-108,0.0000000001584893192,0.000001780389391,0.0000000002241377448]
[null,null,"https://en.wikipedia.org/wiki/Free-space_path_loss",null,null,null,null,-80.0,0.00000001,0.00001414213562,0.00002,null,null,13107.2,-114,0,0.0000008923084338,0]
[null,null,"https://en.wikipedia.org/wiki/Directivity",null,null,null,null,-90.0,0.000000001,0.000004472135955,0.00000632455532,null,null,26214.4,-120,0,0.0000004472135955,0]
[null,null,"https://www.pasternack.com/t-calculator-friis.aspx",null,null,null,null,-100.0,0.0000000001,0.000001414213562,0.000002,null,null,52428.8,-126,0,0.0000002241377448,0]
[null,null,null,null,null,null,null,-110.0,0,0.0000004472135955,0.000000632455532,null,null,104857.6,-132,0,0.0000001123349763,0]
[null,null,null,null,null,null,null,-120.0,0,0.0000001414213562,0.0000002,"BAD SIGNAL",null,209715.2,-138,0,0.00000005630085599,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,419430.4,-144,0,0.00000002821727026,0]

{"sheet":"Volt Amper to Farad","index":7,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[]
[null,"Slove Farad:"]
[null,null,"Volts=",12.0,"Volt"]
[null,null,"Ampers=",8.0,"Amper"]
[null,null,"Time=",3600.0,"Seconds"]
[null,null,"Coulombs=",{"$f":"D11*D12","v":28800},"Coulomb"]
[null,null,"Farad=",{"$f":"D13/D10","v":2400},"Farad"]
[]
[null,"References:"]
[null,null,"http://en.wikipedia.org/wiki/Farad"]

{"sheet":"Resistor Equivalence","index":8,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:"]

{"sheet":"AC Power Factor","index":9,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[]
[null,"Slove AC Real Power","V",220.0,"Volt"]
[null,null,"I",5.0,"Amper"]
[null,null,"Phi",50.0,"Angle º"]
[null,null,"Cos(Phi)",{"$f":"COS(D11*PI()/180)","v":0.6427876097},"Cos Phi"]
[null,null,"P",{"$f":"D9*D10*D12","v":707.0663707},"W"]
[]
[]
[null,"Slove AC Reactive Power","V",220.0,"Volt"]
[null,null,"I",5.0,"Amper"]
[null,null,"Phi",50.0,"Angle º"]
[null,null,"Sin(Phi)",{"$f":"SIN(D18*PI()/180)","v":0.7660444431},"Sin Phi"]
[null,null,"Q",{"$f":"D16*D17*D19","v":842.6488874},"VAr",null,null,"Q - Reactive Power (Volt-Amper)"]
[null,null,null,null,null,null,null,"S - Apparent Power (Volt-Amper)"]
[null,null,null,null,null,null,null,"P - Real Power (Wat)"]
[null,"Slove AC Apparent Power","V",220.0,"Volt",null,null,"PF - Power Factor"]
[null,null,"I",5.0,"Amper"]
[null,null,"S",{"$f":"D23*D24","v":1100},"VA"]
[]
[]
[]
[null,"References:"]
[null,null,"https://en.wikipedia.org/wiki/Power_factor"]
[null,null,"https://www.electronics-tutorials.ws/accircuits/power-triangle.html"]

{"sheet":"AC Inductive Reactance X(L)","index":10,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"254nh"]
[null,null,null,null,null,null,null,null,null,null,null,null,"63nh"]
[null,"Slove inductance:"]
[null,null,"F=",3000.0,"Hertz",{"$f":"D10*1000","v":10.61032954},"m"]
[null,null,"Xl=",200.0,"Ohms",{"$f":"F8*1000","v":10610.32954},"u"]
[null,null,"L=",{"$f":"D9/(2*PI()*D8)","v":0.01061032954},"Henry",10610329.54,"n"]
[]
[null,"Slove reactance:"]
[null,null,"F=",147000.0,"Hertz"]
[null,null,"L=",4.7E-5,"Henry",null,null,null,"VS",0.27]
[null,null,"Xl=",{"$f":"2*PI()*D13*D14","v":43.41052729},"Ohms",null,null,null,"RS",50.0]
[null,null,null,null,null,null,43.0,"RL","IS",{"$f":"(J14-J17)/J15","v":0.00276}]
[null,"Slove frequency:",null,null,null,null,0.0032,"RC","VL",0.132]
[null,null,"L=",3.18309886183791E-5,"Henry",null,{"$f":"40/(G16+G17)","v":0.9301633367},"I","RL",{"$f":"J17/J16","v":47.82608696}]
[null,null,"Xl=",100.0,"Ohms",null,"VL",{"$f":"G16*G18","v":39.99702348},"IL",{"$f":"J17/J18","v":0.00276}]
[null,null,"F=",{"$f":"D19/(2*PI()*D18)","v":500000},"Hertz",null,"VC",{"$f":"G17*G18","v":0.002976522677}]
[]
[null,"References:"]
[null,null,"https://pt.wikipedia.org/wiki/Reatância"]
[null,null,"https://pt.wikipedia.org/wiki/Impedância_elétrica"]

{"sheet":"AC Capacitive Reactance X(C)","index":11,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[null,"Slove capacitance:"]
[null,null,"F=",10.0,"Hertz"]
[null,null,"X(C)=",795.0,"Ohms"]
[null,null,"C=",{"$f":"1/(2*PI()*D9*D10)","v":0.0000200194897},"Farad",{"$f":"D11*1000","v":0.0200194897},"m"]
[null,null,null,null,null,{"$f":"F11*1000","v":20.0194897},"u"]
[null,"Slove reactance:",null,null,null,20019.4897,"n"]
[null,null,"F=",20000.0,"Hertz",20019489.7,"p"]
[null,null,"C=",7.95E-10,"Farad"]
[null,null,"X(C)=",{"$f":"1/(2*PI()*D14*D15)","v":10009.74485},"Ohms"]
[]
[null,"Slove frequency:",null,null,null,null,{"$f":"1/(1/30000+1/24)","v":23.98081535}]
[null,null,"X(C)=",15000.0,"Hertz",null,{"$f":"G18*3","v":71.94244604}]
[null,null,"C=",4.7E-10,"Farad"]
[null,null,"F=",{"$f":"1/(2*PI()*D19*D20)","v":22575.16923},"Ohms",{"$f":"1/(1/10000+1/735)","v":684.6762925}]
[]
[null,"References:"]
[null,null,"http://en.wikipedia.org/wiki/Capacitor"]
[null,null,"http://www.allaboutcircuits.com/vol_2/chpt_4/2.html"]
[null,null,"https://pt.wikipedia.org/wiki/Reatância"]
[null,null,"https://pt.wikipedia.org/wiki/Impedância_elétrica"]

{"sheet":"AC Voltage Phase Shift","index":12,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[null,"Slove Phase:"]
[null,null,"X",90000.0,"Ohms"]
[null,null,"R",2000.0,"Ohms"]
[null,null,"º",{"$f":"D9/D10","v":45},"Angle"]
[]
[null,"Note:"]
[null,null,"Maximum Phase Shift By a Single CR or LR circuit is 90º degress"]
[null,"References:"]
[null,null,"https://www.oreilly.com/library/view/complete-electronics-self-teaching/9781118282328/c06_level1_6.xhtml"]

{"sheet":"AC Impedance","index":13,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:"]
[]
[]
[]
[]
[null,"Slove RLC impedance:"]
[null,null,"R=",100000.0,"Ohms"]
[null,null,"X >=",1000000.0,"Ohms"]
[null,null,"X <=",1000.0,"Ohms"]
[null,null,"Z=",{"$f":"SQRT(D8^2+(D9-D10)^2)","v":1003992.53},"Ohms"]
[null,null,"cos Φ=",{"$f":"D8/D11","v":0.09960233471},"Cosine Phi"]
[null,null,"Φº=",{"$f":"ACOS(D12)*180/PI()","v":84.28372839},"Angle"]
[]
[null,"References:"]
[null,null,"https://pt.wikipedia.org/wiki/Fasor"]
[null,null,"https://pt.wikipedia.org/wiki/Imped%C3%A2ncia_el%C3%A9trica"]
[null,null,"http://eletronicanoel.blogspot.pt/2012/06/curso-de-eletronica-circuitos-rc-parte.html"]
[null,null,"http://www.electronics-tutorials.ws/accircuits/phasors.html"]

{"sheet":"Back EMF of Inductor","index":14,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[]
[]
[null,"Back EMF Generated:"]
[null,null,"VCC",25.0,"Volt"]
[null,null,"L=",0.1,"Henry"]
[null,null,"di=",5.0,"Amper"]
[null,null,"dt=",0.025,"Second"]
[null,null,"v=",{"$f":"-D12*(D13/D14)","v":-20},"Volt"]
[]
[]
[null,"Instantanious Energy Stored:"]
[null,null,"L=",0.01,"Henry"]
[null,null,"i=",5.0,"Amper"]
[null,null,"f=",1.0,"Hertz"]
[null,null,"t=",{"$f":"1/D21","v":1},"Second"]
[null,null,"E=",{"$f":"(1/2)*D19*D20^2","v":0.125},"Joule"]
[null,null,"Q=",{"$f":"D20*D22","v":5},"Coulomb"]
[null,null,"V=",{"$f":"D23/D24","v":0.025},"Volt"]
[]
[null,"References:"]
[null,null,"https://www.electronics-tutorials.ws/inductor/inductor.html"]

{"sheet":"Inductor Stored Energy","index":15,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[]
[]
[null,"Inductor Stored Energy:"]
[null,null,"L=",0.1,"Henry"]
[null,null,"I=",0.5,"Amper"]
[null,null,"t=",{"$f":"1/2","v":0.5},"Second"]
[null,null,"E=",{"$f":"(1/2)*(D11*D12^2)","v":0.0125},"Joule"]
[null,null,"W=",{"$f":"D14*D13","v":0.00625},"Watt",null,{"$f":"D15/20","v":0.0003125}]
[]
[]
[null,"References:"]

{"sheet":"Coupling Capacitor","index":16,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[]
[null,"Slove Capacitance:"]
[null,null,"f=",1.0E8,"Hertz",null,"m",{"$f":"D12*1000","v":0.0000000530516477}]
[null,null,"Zin=",600.0,"Ohms (Impedance)",null,"u",{"$f":"H10*1000","v":0.0000530516477}]
[null,null,"C=",{"$f":"1/(D10*2*PI()*D11/100*5)","v":0},"Farad",null,"n",0.0530516477]
[null,null,null,null,null,null,"p",53.0516477]
[null,"References:"]
[null,null,"https://www.reddit.com/r/electronics/comments/1z1gox/how_do_you_choose_coupling_capacitor_size/"]

{"sheet":"RMS to DC Converter","index":17,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[]
[null,"Slove RMS","DC",67.8822509939086,"Volts"]
[null,null,"AC",{"$f":"D9/SQRT(2)","v":48},"RMS"]
[]
[null,"Slove DC","AC",48.0,"RMS"]
[null,null,"DC",{"$f":"D12*SQRT(2)","v":67.88225099},"Volts"]
[]
[]
[null,"References:",null,null,null,null,null,"A",48.0,"amplitude"]
[null,null,"https://en.wikipedia.org/wiki/Root_mean_square",null,null,null,null,"f",60.0,"frequency"]
[null,null,null,null,null,null,null,"w",{"$f":"2*PI()*I17","v":376.9911184},"angular frequency"]
[null,null,null,null,null,null,null,"t",240.0,"time"]
[null,null,null,null,null,null,null,"y",{"$f":"I16*SIN(RADIANS(I18+I19))","v":-46.76808878},"displacement"]

{"sheet":"Coil Design","index":18,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Resolve coil indutance:"]
[null,null,"n=",25.0,"Number of turns"]
[null,null,"d=",15.0,"Inner coil diameter (mm)"]
[null,null,"l=",30.0,"Coil lenght (mm)",null,null,"Material","Magnetic Permeability","min","max","med"]
[null,null,"u=",{"$f":"J19","v":0.0063},"Magnetic permeability (H/m)",null,null,"Air","4 x PI x 10-7",{"$f":"4*PI()*10^-7","v":0.000001256637061},{"$f":"J17","v":0.000001256637061},{"$f":"(J17+K17)/2","v":0.000001256637061}]
[null,null,"L=",{"$f":"(D17*(D14^2*PI()*(D15/1000/2)^2))/(D16/1000)","v":0.02319378951},"Coil indutance (H)",null,null,"Iron (99.95% pure Fe annealed in H)","2.5×10−1",{"$f":"2.5*10^-1","v":0.25},0.25,0.25]
[null,null,"L=",{"$f":"D18*10^9","v":23193789.51},"Coil indutance (nH)",null,null,"Iron (99.8% pure)"," 6.3×10−3",{"$f":"6.3*10^-3","v":0.0063},0.0063,0.0063]
[null,null,null,null,null,null,null,"Ferrite (cobalt nickel zinc)"," 5.03×10−5 – 1.57×10−4",{"$f":"5.03*10^-5","v":0.0000503},{"$f":"1.57*10^-4","v":0.000157},0.00010365]
[null,null,null,null,null,null,null,"Ferritic stainless steel (annealed)","1.26×10−3 – 2.26×10−3",{"$f":"1.26*10^-3","v":0.00126},{"$f":"2.26*10^-3","v":0.00226},0.00176]
[null,null,null,null,null,null,null,"Ferrite (nickel zinc)","1.26×10−5 – 2.89×10−3",{"$f":"1.26*10^-5","v":0.0000126},{"$f":"2.89*10^-3","v":0.00289},0.0014513]
[null,null,null,null,null,null,null,"Ferrite (manganese zinc)","4.4×10−4 – 2.51×10−2",{"$f":"4.4*10^-4","v":0.00044},{"$f":"2.51*10^-2","v":0.0251},0.01277]
[null,"Relative permeability:"," u=",{"$f":"1.25663753*10^-6","v":0.00000125663753},"Magnetic permeability (H/m)",null,null,"Ferrite (magnesium manganese zinc","4.4×10−4 – 6.28×10−4",0.00044,{"$f":"6.28*10^-4","v":0.000628},0.000534]
[null,null," uo=",{"$f":"4*PI()*10^-7","v":0.000001256637061},"Free Space Permeability"]
[null,null," ur=",{"$f":"D24/D25","v":1.000000373},"Relative Permeability"]
[]
[]
[]
[]
[null,"Absolute permeability:","ur",2000.0,"Relative permeability"]
[null,null,"uo",{"$f":"4*PI()*10^-7","v":0.000001256637061},"Free Space Permeabiliy"]
[null,null,"u",{"$f":"D32*D31","v":0.002513274123},"Magnetic permeability (H/m)"]
[]
[]
[null,"References:"]
[null,null,"https://www.newtoncbraga.com.br/index.php/eletronica/52-artigos-diversos/4151-art572"]
[null,null,"https://en.wikipedia.org/wiki/Permeability_(electromagnetism)"]

{"sheet":"Ideal Transformer","index":19,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Index"]
[]
[]
[null,"Slove Ideal Transformer:","Frequency",50.0,"Hz"]
[null,null,"Primary RMS",230.0,"Volt RMS"]
[null,null,"Secondary RMS",12.0,"Volt RMS"]
[null,null,"Scondary Current",1.0,"Amper"]
[null,null," Tansformer Ratio",{"$f":"D5/D6","v":19.16666667},"Ratio"]
[null,null,"Primary Current",{"$f":"D7/D8","v":0.05217391304},"Amper"]
[null,null,"Primary Inductance",{"$f":"(D5/D9)/(2*PI()*D4)","v":14.03216082},"Henry"]
[null,null,"Secondary Inductance",{"$f":"(D6/D7)/(2*PI()*D4)","v":0.03819718634},"Henry"]
[null,null,"Primary Vpp",{"$f":"D5*SQRT(2)","v":325.2691193},"Volt Peak to Peak"]
[null,null,"Secondary Vpp",16.97056275,"Volt Peak to Peak"]
[]
[]
[]
[]
[null,"References:"]
[null,null,"https://www.jcalc.net/transformer-calculator"]
[null,null,"https://www.electronics-tutorials.ws/transformer/transformer-basics.html"]

{"sheet":"Mutual inductance","index":20,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Index"]
[]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[]
[]
[null,"Calculate Transformer:"]
[null,null,"Primary=",230.0,"Volts"]
[null,null,"Secondary=",48.0,"Volts"]
[null,null,"Frequency=",60.0,"Hertz"]
[null,null,"Primary=",0.52,"Ampers"]
[null,null,"Coefficient=",1.0,"Coupling"]
[null,null,"Primary=",{"$f":"D12/D15","v":442.3076923},"Ohms"]
[null,null,"Primary=",{"$f":"D17/(2*PI()*D14)","v":1.173257593},"Henry"]
[null,null,"Transformer=",{"$f":"D16*(D12/D13)","v":4.791666667},"Ratio"]
[null,null,"Secondary=",{"$f":"D18/(D19^2)","v":0.05109991484},"Henry"]
[]
[]
[]
[null,"Calculate Primary Current:"]
[null,null,"Primary=",230.0,"Volts"]
[null,null,"Secondary=",48.0,"Volts"]
[null,null,"Secondary=",3.0,"Amperes"]
[null,null,"Power=",{"$f":"D27*D26","v":144},"Watts"]
[null,null,"Primary=",{"$f":"D28/D25","v":0.6260869565},"Amperes"]
[]
[]
[null,null,"N1=",100.0,"Turns"]
[null,null,"Primary=",0.63,"Amps"]
[null,null,"Secondary=",3.0,"Amps"]
[null,null,"Transformer=",{"$f":"D34/D33","v":4.761904762},"Ratio"]
[null,null,"N2=",{"$f":"D32/D35","v":21},"Turns"]
[]
[]
[]
[]
[null,"References:"]
[null,null,"http://electronics.stackexchange.com/questions/24864/transformer-design-how-do-i-set-an-n1-n2-ratio-by-means-of-selecting-winding-in"]
[null,null,"http://en.wikipedia.org/wiki/Inductance"]
[null,null,"https://www.electronics-tutorials.ws/inductor/mutual-inductance.html"]
[null,null,"http://www.tpub.com/neets/book2/5h.htm"]

{"sheet":"Sinusoidal Waveform","index":21,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:"]
[]
[]
[]
[]
[null,"Slove Amplitude"]
[null,null,"A=",12.0,"Maximum amplitude"]
[null,null,"F=",33.0,"Frequency (Hertz)"]
[null,null,"t=",0.123,"Time (Seconds)"]
[null,null,"Φ=",{"$f":"RADIANS(45)","v":0.7853981634},"Phase (radians)"]
[null,null,"ω=",{"$f":"2*PI()*D9","v":207.3451151},"Angular frequency (rads/s)"]
[null,null,"At=",{"$f":"D8*SIN(D12*D10+D11)","v":10.98289407},"Amplitude in time"]
[null,null,"It=",{"$f":"D13/'AC Impedance'!D11","v":0.00001093921891}]
[]
[]
[]
[]
[]
[null,"References:"]
[null,null,"http://www.electronics-tutorials.ws/accircuits/sinusoidal-waveform.html"]
[null,null,null,null,null,null,null,null,null,"GRAUS",45.0]
[null,null,null,null,null,null,null,null,null,"RADIANOS",{"$f":"RADIANS(K22)","v":0.7853981634}]
[null,null,null,null,null,null,null,null,null,"GRAUS",{"$f":"K23*180/PI()","v":45}]
[]
[null,null,null,null,null,null,null,null,null,"COS",{"$f":"COS(K23)","v":0.7071067812}]
[null,null,null,null,null,null,null,null,null,"ACOS",{"$f":"ACOS(K26)","v":0.7853981634}]

{"sheet":"Passive RC Filter","index":22,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[null,"Slove capacitance:"]
[null,null,"F=",20000.0,"Hertz"]
[null,null,"R=",1000.0,"Ohms",{"$f":"D14*1000","v":0.000007957747155},"m"]
[null,null,"Db",-3.0,"Decibel",{"$f":"F10*1000","v":0.007957747155},"u"]
[null,null,"fc (point)=",{"$f":"10^(D11/20)*100","v":70.79457844},"Percent",7.957747155,"n"]
[null,null,"fc (point)=",{"$f":"10^(D11/10)*D9","v":10023.74467},"Hertz"]
[null,null,"C=",{"$f":"1/(2*PI()*D9*D10)","v":0.000000007957747155},"Farad",{"$f":"F12*1000","v":7957.747155},"p"]
[]
[]
[null,"Slove resistence:"]
[null,null,"F=",20000.0,"Hertz"]
[null,null,"C=",7.95774715459477E-9,"Farad"]
[null,null,"Db",-3.0,"Decibel"]
[null,null,"fc (point)=",{"$f":"10^(D20/20)*100","v":70.79457844},"Percent"]
[null,null,"fc (point)=",{"$f":"10^(D20/10)*D18","v":10023.74467},"Hertz"]
[null,null,"R=",{"$f":"1/(2*PI()*D18*D19)","v":1000},"Ohms"]
[]
[]
[null,"Slove frequencie:"]
[null,null,"R=",1000.0,"Ohms"]
[null,null,"C=",7.95774715459477E-9,"Farad"]
[null,null,"F=",{"$f":"1/(2*PI()*D27*D28)","v":20000},"Hertz"]
[null,null,"fc (point)=",{"$f":"D29*10^(-3/20)","v":14158.91569},"Hertz"]
[]
[null,null,null,null,null,null,null,{"$f":"1/(1/400+1/100)","v":80}]
[null,"References:"]
[null,null,"https://www.electronics-tutorials.ws/filter/decibels.html"]
[null,null,"http://www.electronics-tutorials.ws/filter/filter_4.html"]
[null,null,"http://www.learningaboutelectronics.com/Articles/Low-pass-filter-calculator.php#answer1"]
[null,null,"https://excelribbon.tips.net/T012486_Deriving_Antilogs.html"]

{"sheet":"Passive LC Filter","index":23,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:"]
[]
[null,null,null,null,null,null,"LOW PASS"]
[]
[]
[]
[null,"Slove inductance:"]
[null,null,"f=",2.5E7,"Hertz"]
[null,null,"C=",6.0E-12,"Farad"]
[null,null,"fc -6Db=",{"$f":"D9*10^(-6/10)","v":6279716.079},"Hertz"]
[null,null,"L=",{"$f":"(1/(D9*2*PI()*SQRT(D10)))^2","v":0.000006754745576},"Henry",{"$f":"D12*1000*1000","v":6.754745576}]
[]
[null,null,null,null,null,null,"HIGH PASS"]
[null,"Slove capacitance:"]
[null,null,"f=",2.5E7,"Hertz"]
[null,null,"L=",6.75474557615585E-6,"Henry"]
[null,null,"fc -6Db=",{"$f":"D16*10^(-6/10)","v":6279716.079},"Hertz"]
[null,null,"C=",{"$f":"(1/(D16*2*PI()*SQRT(D17)))^2","v":0},"Farad"]
[]
[]
[null,"Slove frequencie:"]
[null,null,"L=",6.75474557615585E-6,"Henry"]
[null,null,"C=",6.0E-12,"Farad"]
[null,null,"fc -6DB=",{"$f":"1/(2*PI()*SQRT(D23*D24))","v":25000000},"Hertz"]
[null,null,"f=",{"$f":"D25/10^(-6/10)","v":99526792.64},"Hertz"]
[]
[null,"References:"]
[null,null,"http://www.electronics-tutorials.ws/filter/filter_4.html"]
[null,null,"https://electronicbase.net/lc-filter-calculator/"]

{"sheet":"Varicap Junction Capacitance","index":24,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formula:"]
[]
[]
[]
[]
[]
[]
[]
[null,"Slove capacitance:"]
[null,null,"CJO=",692.0,null,"zero-bias junction capacitance"]
[null,null,"VR=",12.0,null,"reverse bias voltage"]
[null,null,"VJ=",2.5,null,"junction potential"]
[null,null,"m=",1.0,null,"grading coefficient"]
[null,null,"CJ=",{"$f":"D11/((1+D12/D13)^D14)","v":119.3103448},null,"junction capacitance"]
[]
[null,"References:"]
[null,null,"http://www.engr.uky.edu/~radun/EE603/LectureNotes/DiodeChar/NonIdealDiode"]
[null,null,"http://electronics-diy.com/varicaps.php"]
[null,null,"http://en.wikipedia.org/wiki/Varicap"]
[]
[null,"Notes:"]
[null,null,"Normal diodes can be used as varactor diodes"]

{"sheet":"RC Charge Time","index":25,"n_rows":59,"n_cols":7,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[]
[null,"Slove resistance:","t5=",0.008,"Time constant at ~100% of charge (seconds)"]
[null,null,"C=",1.0E-6,"Capacitance (farad)"]
[null,null,"t=",{"$f":"D12*D10","v":0.0016},"Time constant at ~63% of charge (seconds)"]
[null,null,"R=",{"$f":"D9/(D10*5)","v":1600},"Resistance (ohms)"]
[]
[null,"Slove voltage:"]
[null,null,"VCC=",12.0,"Source voltage (volts)"]
[null,null,"t=",0.0166,"Time (seconds)"]
[null,null,"R=",16.0,"Resistance (ohms)"]
[null,null,"C=",1.0E-4,"Capacitance (farads)"]
[null,null,"T=",{"$f":"D17*D18","v":0.0016},"Time Constant (táu)"]
[null,null,"VC(t)=",{"$f":"12*(1-2.718^(-D16/D19))","v":11.99962516},"Charge voltage (voltage on capacitor)"]
[null,null,"VR(t)=",{"$f":"D15*2.718^(-D16/D19)","v":0.0003748376249},"Dischage voltage (voltage on resistor)"]
[]
[]
[null,"Analyze charge /discharge:","VCC",10.0,"Sorce voltage (volts)"]
[null,null,"R",2000.0,"Resistance (ohms)"]
[null,null,"C",0.001,"Cpacitance (farad)"]
[null,null,"t",{"$f":"D25*D26","v":2},"Time constant at ~63% of charge (seconds)"]
[null,null,"t5",{"$f":"D27*5","v":10},"Time constant at ~100% of charge (seconds)"]
[]
[null,null,"t5 %","time","logarithm","C","R"]
[null,null,0.0,{"$f":"$D$28/100*C31","v":0},{"$f":"EXP(-D31/$D$27)","v":1},{"$f":"$D$24*(1-E31)","v":0},{"$f":"$D$24*(E31)","v":10}]
[null,null,5.0,0.5,0.7788007831,2.211992169,7.788007831]
[null,null,10.0,1,0.6065306597,3.934693403,6.065306597]
[null,null,15.0,1.5,0.4723665527,5.276334473,4.723665527]
[null,null,20.0,2,0.3678794412,6.321205588,3.678794412]
[null,null,25.0,2.5,0.2865047969,7.134952031,2.865047969]
[null,null,30.0,3,0.2231301601,7.768698399,2.231301601]
[null,null,35.0,3.5,0.1737739435,8.262260565,1.737739435]
[null,null,40.0,4,0.1353352832,8.646647168,1.353352832]
[null,null,45.0,4.5,0.1053992246,8.946007754,1.053992246]
[null,null,50.0,5,0.08208499862,9.179150014,0.8208499862]
[null,null,55.0,5.5,0.06392786121,9.360721388,0.6392786121]
[null,null,60.0,6,0.04978706837,9.502129316,0.4978706837]
[null,null,65.0,6.5,0.03877420783,9.612257922,0.3877420783]
[null,null,70.0,7,0.03019738342,9.698026166,0.3019738342]
[null,null,75.0,7.5,0.02351774586,9.764822541,0.2351774586]
[null,null,80.0,8,0.01831563889,9.816843611,0.1831563889]
[null,null,85.0,8.5,0.01426423391,9.857357661,0.1426423391]
[null,null,90.0,9,0.01110899654,9.888910035,0.1110899654]
[null,null,95.0,9.5,0.008651695203,9.913483048,0.08651695203]
[null,null,100.0,10,0.006737946999,9.93262053,0.06737946999]
[]
[]
[]
[null,"References:"]
[null,null,"http://en.wikipedia.org/wiki/RC_time_constant"]
[null,null,"http://www.eletronica24h.com.br/Curso%20CA/aparte1/aulas/aula003.html"]
[null,null,"http://www.electronics-tutorials.ws/rc/rc_1.html"]
[null,null,"http://macao.communications.museum/por/Exhibition/secondfloor/moreinfo/2_3_5_ChargingCapacitor.html"]

{"sheet":"RL Charge Time","index":26,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[]
[null,"Slove charge current:","V=",6.0,"Volts"]
[null,null,"R=",10.0,"Ohms"]
[null,null,"L=",10.0,"Henry"]
[null,null,"t=",{"$f":"0.001*502","v":0.502},"Time (seconds)"]
[null,null,"T=",{"$f":"D11/D10","v":1},"Time constant (táu)"]
[null,null,"i=",{"$f":"(D9/D10)*(1-2.718^(D12/D13))","v":-0.3911616169},"Ampers"]
[]
[]
[null,"Slove Sotred Power:","A=",0.5,"Ampers"]
[null,null,"L=",0.5,"Henry"]
[null,null,"t=",0.008,"Time (seconds)"]
[null,null,"J=",{"$f":"D18*D17^2/2","v":0.0625},"Joules"]
[null,null,"P=",{"$f":"D20/D19","v":7.8125},"Watts"]
[]
[]
[null,"References:"]
[]
[null,null,"http://macao.communications.museum/por/Exhibition/secondfloor/moreinfo/2_3_6_ResistanceInductance.html"]

{"sheet":"LC Resonance Frequency","index":27,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:",null,null,null,{"$f":"1/(1/47+1/4.7)","v":4.272727273}]
[]
[]
[]
[]
[]
[null,"Slove frequency:",null,null,null,null,null,"Nano Henry","Capacitor","Resonant Freq."]
[null,null,"L=",0.1,"Henry",null,null,85.78,"4,03n","8,56MHz"]
[null,null,"C=",0.1,"Farad",null,null,89.91,"3,89n","8,51MHz"]
[null,null,"F=",{"$f":"1/(2*PI()*SQRT(D9*D10))","v":1.591549431},"Hertz",null,null,79.04,"960p","18,27MHz"]
[]
[null,"Slove inductance:"]
[null,null,"C=",0.1,"Farad"]
[null,null,"F=",1.59154943091895,"Hertz"]
[null,null,"L=",{"$f":"(1/(D15*2*PI()*SQRT(D14)))^2","v":0.1},"Henry",{"$f":"D16*1000*1000","v":100000}]
[]
[null,"Slove capacitance:"]
[null,null,"L=",0.1,"Henry"]
[null,null,"F=",1.59154943091895,"Hertz"]
[null,null,"C=",{"$f":"(1/(D20*2*PI()*SQRT(D19)))^2","v":0.1},"Farad",{"$f":"D21*1000*1000*1000*1000","v":100000000000}]
[]
[null,"References:"]
[null,null,"http://www.ekswai.com/en_lc.htm"]
[null,null,"http://en.wikipedia.org/wiki/LC_circuit"]

{"sheet":"AVR PWM","index":28,"n_rows":43,"n_cols":5,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Index"]
[]
[]
[null," Period to duty cycle and Hertz"]
[null,null,"TIME ON=",1.04166666666667E-5,"seconds"]
[null,null,"TIME OFF=",1.04166666666667E-5,"seconds"]
[null,null,"PERIOD=",{"$f":"D6+D5","v":0.00002083333333},"seconds"]
[null,null,"DUTY CYCLE=",{"$f":"D5/D7*100","v":50},"%"]
[null,null,"FREQ=",{"$f":"1/D7","v":48000},"Hertz"]
[]
[]
[null,"Duty cycle to OCR","DUTY CYCLE=",25.0,"%"]
[null,null,"TOP=",256.0]
[null,null,"OCR=",{"$f":"D13/100*D12","v":64}]
[]
[]
[null,"Clear Timer on Compare Match (CTC) Mode","CLOCK=",8000000.0,"Hertz"]
[null,null,"PRESCALER=",8.0,"1,8,64,256,1024"]
[null,null,"OCRn=",3.0]
[null,null,"FREQ=",{"$f":"D17/(2*D18*(1+D19))","v":125000}]
[]
[]
[null,"Fast PWM Mode","CLOCK=",8000000.0,"Hertz"]
[null,null,"PRESCALER=",1.0]
[null,null,"TOP=",256.0]
[null,null,"FREQ=",{"$f":"D23/(D24*D25)","v":31250},"Hertz"]
[]
[]
[null,"Phase Correct PWM Mode","CLOCK=",8000000.0,"Hertz"]
[null,null,"PRESCALER=",1024.0,"1,8,64,256,1024"]
[null,null,"FREQ=",{"$f":"D29/(D30*510)","v":15.31862745},"Hertz"]
[]
[]
[]
[]
[]
[]
[]
[null,"References:"]
[]
[null,null,"https://sites.google.com/site/qeewiki/books/avr-guide/pwm-on-the-atmega328"]
[null,null,"http://maxembedded.com/2012/01/avr-timers-pwm-mode-part-ii/"]
[null,null,"http://www.avrbeginners.net/architecture/timers/timers.html"]

{"sheet":"Maximum Power Transfer","index":29,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Index"]
[]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[]
[]
[null,"Slove Maximum Power Transfer:"]
[null,null,"Vs=",12.0,"Volts"]
[null,null,"Rl=",4.0,"Ohms"]
[null,null,"Rs=",4.0,"Ohms"]
[null,null,"I=",{"$f":"D12/(D13+D14)","v":1.5},"Ampers"]
[null,null,"P=",{"$f":"D15^2*D13","v":9},"Watts"]
[]
[null,"References:"]
[null,null,"https://en.wikipedia.org/wiki/Maximum_power_transfer_theorem"]
[null,null,"https://www.electronics-tutorials.ws/dccircuits/dcp_9.html"]
[null,null,"http://www.etelg.com.br/downloads/eletronica/cursos/Aulas/Aula014.html"]

{"sheet":"Kirchhoff MATRIX","index":30,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[null,"Slove frequency:",null,"a","b","c","d","e"]
[null,null,"A=",4.0,-2.0,0.0,-2.0,null,null,"X=",5.0]
[null,null,null,-2.0,4.0,-2.0,0.0,null,null,null,0.0]
[null,null,null,0.0,-2.0,6.0,-2.0,null,null,null,0.0]
[null,null,null,-2.0,0.0,-2.0,6.0,null,null,null,0.0]
[null,null,null,null,null,null,null,null,null,null,0.0]
[]
[null,null,null,"USE CRL+SHIFT+ENTER"]
[null,null,"B=",{"$f":"MMULT(MINVERSE(D9:G12),K9:K12)","v":2.954545455},"ia"]
[null,null,null,2.045454545454545,"ib"]
[null,null,null,1.136363636363636,"ic"]
[null,null,null,1.3636363636363633,"id"]
[null,null,null,null,"ie"]
[]
[]
[null,"References:"]
[null,null,"http://www.excel-easy.com/examples/system-of-linear-equations.html"]
[null,null,"https://def.fe.up.pt/eletricidade/circuitos_cc.html"]

{"sheet":"Thévenin`s theorem","index":31,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Index"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[null,"Slove frequency:"]
[null,null,"VCC",15.0,"Volts"]
[null,null,"R4",2000.0,"Ohms"]
[null,null,"R3+R2",2000.0,"Ohms"]
[null,null,"R1",1000.0,"Ohms"]
[null,null,"Rth",{"$f":"1/(1/D21+1/D22)+D23","v":2000},"Ohms"]
[null,null,"Vth",{"$f":"D22/(D22+D21)*D20","v":7.5},"Volts"]
[null,null,"Iab=",{"$f":"D25/D24","v":0.00375},"Ampers"]
[]
[]
[null,"References:"]
[null,null,"https://en.wikipedia.org/wiki/Thévenin's_theorem"]
[null,null,"https://pt.wikipedia.org/wiki/Divisor_de_tensão"]
[null,null,"http://www.corradi.junior.nom.br/teoremanortonthevenin.pdf"]
[null,null,"https://itligado.files.wordpress.com/2013/04/3-thevenin-norton-exercicios-1.pdf"]

{"sheet":"Rect. Conductor Magnetic Field","index":32,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Index"]
[]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Slove magnetic field:"]
[null,null,"r",0.005,"Meters (Distance from conductor)"]
[null,null,"I",12.5,"Ampers"]
[null,null,"B",{"$f":"(4*PI()*10^-7*D15)/(2*PI()*D14)","v":0.0005},"Tesela (Magnetic field intensity)"]
[]
[null,"Slove current:"]
[null,null,"B",5.0E-5,"Tesela (Magnetic field intensity)"]
[null,null,"r",0.05,"Meters (Distance from conductor)"]
[null,null,"I",{"$f":"D19*((2*PI()*D20)/(4*PI()*10^-7))","v":12.5},"Ampers"]
[]
[]
[null,"References:"]
[null,null,"https://pt.khanacademy.org/science/physics/magnetic-forces-and-magnetic-fields/magnetic-field-current-carrying-wire/a/what-are-magnetic-fields"]
[null,null,"http://fisicaevestibular.com.br/novo/eletricidade/eletromagnetismo/campo-magnetico-originado-por-um-condutor-retilineo-extenso-percorrido-por-corrente-eletrica/"]
[]
[null,"Notes:","1 Gauss == 10^-4 Tesla in CGS units"]

{"sheet":"AWG","index":33,"n_rows":61,"n_cols":13,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Index"]
[]
[]
[null,null,"AWG gauge","Conductor\nDiameter\nin mm","Conductor\ncross section\nin mm2","Ohms\nper Km","Maximum amps\nfor chassis wiring","Maximum amps\nfor power transmission","Maximum frequency\nfor 100% skin depth\nfor solid conductor copper\n in Hz","Breaking force\nSoft Annealed\nCu 37000 PSI\n in Kg"]
[null,null,"4/0",11.684,{"$f":"PI()*(D5/2)^2","v":107.2193026},0.16072,380.0,302.0,125.0,2775.9853044]
[null,null,"3/0",10.40384,85.01140826,0.202704,328.0,239.0,160.0,2204.4589182]
[null,null,"2/0",9.26592,67.43214488,0.255512,283.0,190.0,200.0,1750.8665482]
[null,null,"1/0",8.25246,53.48804656,0.322424,245.0,150.0,250.0,1387.9926522]
[null,null,1.0,7.34822,42.40862404,0.406392,211.0,119.0,325.0,1102.2294591]
[null,null,2.0,6.54304,33.62397329,0.512664,181.0,94.0,410.0,875.4332741]
[null,null,3.0,5.82676,26.66515679,0.64616,158.0,75.0,500.0,693.9963261]
[null,null,4.0,5.18922,21.14920505,0.81508,135.0,60.0,650.0,548.8467677]
[null,null,5.0,4.62026,16.76573945,1.027624,118.0,47.0,810.0,435.4486752]
[null,null,6.0,4.1148,13.29803108,1.295928,101.0,37.0,1100.0,344.7302012]
[null,null,7.0,3.66522,10.55091142,1.634096,89.0,30.0,1300.0,274.42338385]
[null,null,8.0,3.2639,8.366880572,2.060496,73.0,24.0,1650.0,217.7243376]
[null,null,9.0,2.90576,6.631463194,2.598088,64.0,19.0,2050.0,172.3651006]
[null,null,10.0,2.58826,5.261452847,3.276392,55.0,15.0,2600.0,142.42800418]
[null,null,11.0,2.30378,4.16842401,4.1328,47.0,12.0,3200.0,112.94450013]
[null,null,12.0,2.05232,3.308110716,5.20864,41.0,9.3,4150.0,89.35769689]
[null,null,13.0,1.8288,2.626771572,6.56984,35.0,7.4,5300.0,68.0388555]
[null,null,14.0,1.62814,2.081964757,8.282,32.0,5.9,6700.0,53.97749203,null,{"$f":"F41","v":555.61},"ohm/km"]
[null,null,15.0,1.45034,1.652074132,10.44352,28.0,4.7,8250.0,42.63768278,null,5.1,"wire ohm"]
[null,null,16.0,1.29032,1.307629589,13.17248,22.0,3.7,11000.0,34.01942775,null,1.8,"coil length cm"]
[null,null,17.0,1.15062,1.039809351,16.60992,19.0,2.9,13000.0,26.76194983,null,{"$f":"L22/1000/100","v":0.0055561},"ohm/cm"]
[null,null,18.0,1.02362,0.8229385497,20.9428,16.0,2.3,17000.0,21.31884139,null,{"$f":"L23/L25","v":917.9100448},"wire length cm"]
[null,null,19.0,0.91186,0.6530496661,26.40728,14.0,1.8,21000.0,16.78291769,null,{"$f":"L26/L24","v":509.9500249},"number of turns"]
[null,null,20.0,0.8128,0.5188684586,33.292,11.0,1.5,27000.0,13.15417873]
[null,null,21.0,0.7239,0.4115731499,41.984,9.0,1.2,33000.0,10.43262451]
[null,null,22.0,0.64516,0.3269073972,52.9392,7.0,0.92,42000.0,8.16466266]
[null,null,23.0,0.57404,0.258805912,66.7808,4.7,0.729,53000.0,6.577089365]
[null,null,24.0,0.51054,0.2047148886,84.1976,3.5,0.577,68000.0,5.216312255]
[null,null,25.0,0.45466,0.1623541434,106.1736,2.7,0.457,85000.0,4.08233133]
[null,null,26.0,0.40386,0.1281007178,133.8568,2.2,0.361,107000.0,3.265865064]
[null,null,27.0,0.36068,0.1021724961,168.8216,1.7,0.288,130000.0,2.494758035]
[null,null,28.0,0.32004,0.08044487938,212.872,1.4,0.226,170000.0,2.041165665]
[null,null,29.0,0.28702,0.06470147801,268.4024,1.2,0.182,210000.0,1.632932532]
[null,null,30.0,0.254,0.05067074791,338.496,0.86,0.142,270000.0,1.2473790175]
[null,null,31.0,0.22606,0.04013629942,426.728,0.7,0.113,340000.0,1.0205828325]
[null,null,32.0,0.2032,0.03242927866,538.248,0.53,0.091,430000.0,0.816466266]
[null,null,"Metric 2.0",0.2,0.03141592654,555.61,0.51,0.088,440000.0,0.0]
[null,null,33.0,0.18034,0.02554312402,678.632,0.43,0.072,540000.0,0.589670081]
[null,null,"Metric 1.8",0.18,0.02544690049,680.55,0.43,0.072,540000.0,0.0]
[null,null,34.0,0.16002,0.02011121985,855.752,0.33,0.056,690000.0,0.498951607]
[null,null,"Metric 1.6",0.16002,0.02011121985,855.752,0.33,0.056,690000.0,0.0]
[null,null,35.0,0.14224,0.01589034654,1079.12,0.27,0.044,870000.0,0.4173049804]
[null,null,"Metric 1.4",0.14,0.015393804,1114.0,0.26,0.043,900000.0,0.0]
[null,null,36.0,0.127,0.01266768698,1360.0,0.21,0.035,1100000.0,0.3265865064]
[null,null,"Metric 1.25",0.125,0.0122718463,1404.0,0.2,0.034,1150000.0,0.0]
[null,null,37.0,0.1143,0.01026082645,1715.0,0.17,0.0289,1350000.0,0.2585476509]
[null,null,"Metric 1.12",0.112,0.009852034562,1750.0,0.163,0.0277,1400000.0,0.0]
[null,null,38.0,0.1016,0.008107319666,2163.0,0.13,0.0228,1750000.0,0.2041165665]
[null,null,"Metric 1",0.1,0.007853981634,2198.0,0.126,0.0225,1750000.0,0.0]
[null,null,39.0,0.0889,0.006207166619,2728.0,0.11,0.0175,2250000.0,0.1632932532]
[null,null,40.0,0.07874,0.004869458874,3440.0,0.09,0.0137,2900000.0,0.1315417873]
[]
[]
[null,null,"References:"]
[null,null,null,"https://www.powerstream.com/Wire_Size.htm"]
[null,null,null,"https://en.wikipedia.org/wiki/Skin_effect"]
[null,null,null,"https://en.wikipedia.org/wiki/American_wire_gauge#Tables_of_AWG_wire_sizes"]

{"sheet":"Colpitts Oscilator","index":34,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Index"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"http://www.newtoncbraga.com.br/index.php/matematica-para-eletronica/439-oscilador-de-colpitts-calculo-m008.html"]

{"sheet":"NPN Common Emitter","index":35,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Index"]
[]
[]
[null,null,"VCC",15.0,"Volts"]
[null,null,"VCE",10.0,"Volts"]
[null,null,"VC",4.0,"Volts"]
[null,null,"Hfe",296.0,"Beta"]
[null,null,"IC",0.01,"Ampers"]
[null,null,"VE",{"$f":"D4-D5-D6","v":1},"Volts"]
[null,null,"IB",{"$f":"D8/D7","v":0.00003378378378},"Ampers"]
[null,null,"IRB1",{"$f":"D10*10","v":0.0003378378378},"Ampers"]
[null,null,"IRB2",{"$f":"D11-D10","v":0.0003040540541},"Ampers"]
[null,null,"RB1",{"$f":"(D4-D9+0.8)/D11","v":43808},"Ohms"]
[null,null,"RB2",{"$f":"(D9+0.8)/D12","v":5920},"Ohms"]
[null,null,"RC",{"$f":"D6/D8","v":400},"Ohms"]
[null,null,"RE",{"$f":"D9/D8","v":100},"Ohms"]
[null,null,"BC",{"$f":"D16/10","v":10},"Ohms"]
[null,null,"Re",{"$f":"0.025/D8*D7","v":740},"Ohms"]
[null,null,"Zin",{"$f":"1/(1/D13+1/D14+1/((0.025/D8)*D7))","v":648.0473373},"Ohms"]
[null,null,"Zout",{"$f":"1/(1/D15+1/D16+1/D17)","v":8.888888889},"Ohms"]
[]
[null,null,"VT",{"$f":"(D8/0.025)","v":0.4},"gm"]
[null,null,"A",{"$f":"D22*D7","v":118.4}]

{"sheet":"NPN Common Collector","index":36,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Index"]
[]
[]
[null,null,"VCC",15.0,"Volts"]
[null,null,"VCE",10.0,"Volts"]
[null,null,"VC",4.0]
[null,null,"Hfe",296.0,"Beta"]
[null,null,"IC",0.01,"Ampers"]
[null,null,"VE",{"$f":"D4-D5-D6","v":1},"Volts"]
[null,null,"IB",{"$f":"D8/D7","v":0.00003378378378},"Ampers"]
[null,null,"VB",{"$f":"D9+0.8","v":1.8}]
[null,null,"RB",{"$f":"(D4-D11)/D10","v":390720},"Ohms"]
[null,null,"RC",{"$f":"D6/D8","v":400},"Ohms"]
[null,null,"RE",{"$f":"D9/D8","v":100},"Ohms"]
[null,null,"BC",{"$f":"D14/10","v":10},"Ohms"]
[null,null,"Zin",{"$f":"1/(1/D12+1/((0.025/D8)*D7))","v":738.6011342},"Ohms"]
[null,null,"zout",{"$f":"1/(1/D13+1/D14+1/D15)","v":8.888888889},"Ohms"]

{"sheet":"NE555 Astable","index":37,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Index"]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[]
[null,"Slove Frequency","R1",140000.0,"Ohms"]
[null,null,"R2",75000.0,"Ohms"]
[null,null,"C",8.2E-10,"Farad"]
[null,null,"Frequency",{"$f":"1.44/((D9+2*D10)*D11)","v":6055.508831},"Hz"]
[null,null,"T1 (High Time)",{"$f":"0.694*(D9+D10)*D11","v":0.0001223522},"Seconds",{"$f":"D13*1000*1000","v":122.3522}]
[null,null,"T0 (Low Time)",{"$f":"0.694*D10*D11","v":0.000042681},"Seconds"]
[null,null,"T (Total Time)",{"$f":"D14+D13","v":0.0001650332},"Seconds"]
[null,null,"Mark Space",{"$f":"D13/D14","v":2.866666667},"Ratio"]
[null,null,"Duty Cycle",{"$f":"D13/D15*100","v":74.13793103},"Percentage"]
[]
[]
[null,"Slove R2:"]
[null,null,"Frequency",140000.0,"Hz"]
[null,null,"R1",500.0,"Ohms"]
[null,null,"C",1.0E-10,"Farad"]
[null,null,"R2",{"$f":"(1.44-D21*D22*D23)/(D21*D23)/2","v":51178.57143},"Ohms"]
[null,null,"T1 (High Time)",{"$f":"0.694*(D22+D24)*D23","v":0.000003586492857},"Seconds"]
[null,null,"T0 (Low Time)",{"$f":"0.694*D24*D23","v":0.000003551792857},"Seconds"]
[null,null,"T (Total Time)",{"$f":"D26+D25","v":0.000007138285714},"Seconds"]
[null,null,"Mark Space",{"$f":"D25/D26","v":1.009769714},"Ratio"]
[null,null,"Duty Cycle",{"$f":"D25/D27*100","v":50.24305556},"Percentage"]
[]
[]
[null,"References:"]
[null,null,"https://www.allaboutcircuits.com/tools/555-timer-astable-circuit/"]

{"sheet":"Thermal Resistance","index":38,"n_rows":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Index"]
[]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Slove power dissipation:","Tj",125.0,"ºC"]
[null,null,"Θja",30.0,"ºC/W"]
[null,null,"Ta",35.0,"ºC"]
[null,null,"Pd",{"$f":"(D15-D17)/D16","v":3},"W",null,null,"TO-220, TO-263 - junction to case thermal resistance 0,89 ºC/W"]
[]
[]
[null,"Slove Junction temperature","Pd",6.0,"W"]
[null,null,"Θjc ",0.89,"ºC/W"]
[null,null,"Θcs ",0.5,"ºC/W"]
[null,null,"Θsa ",13.61,"ºC/W"]
[null,null,"Ta",35.0,"ºC"]
[null,null,"Θja ",{"$f":"D22+D23+D24","v":15},"ºC/W"]
[null,null,"Tj",{"$f":"D21*D26+D25","v":125},"ºC"]
[]
[null,"Slove Power Dissipation","Tj",125.0,"ºC"]
[null,null,"Θjc ",0.89,"ºC/W"]
[null,null,"Θcs ",0.5,"ºC/W"]
[null,null,"Θsa ",15.5,"ºC/W"]
[null,null,"Ta",35.0,"ºC"]
[null,null,"Θja ",{"$f":"D30+D31+D32","v":16.89},"ºC/W"]
[null,null,"Pd",{"$f":"(D29-D33)/D34","v":5.328596803},"W"]
[]
[]
[null,"Slove heat sink thermal resistance","Tj",125.0,"ºC"]
[null,null,"Pd",6.0,"W"]
[null,null,"Θjc ",0.89,"ºC/W"]
[null,null,"Θcs",0.5,"ºC/W"]
[null,null,"Ta",35.0,"ºC"]
[null,null,"Θsa ",{"$f":"(D38-D39*D40-D39*D41-D42)/D39","v":13.61},"ºC/W"]
[]
[]
[null,"Slove insulator thermal resistance","Θjc ",0.89,"ºC/W"]
[null,null,"Θsa ",15.5,"ºC/W"]
[null,null,"Θja",16.89,"ºC/W"]
[null,null,"Θcs",{"$f":"D48-D46-D47","v":0.5},"ºC/W"]
[]
[]
[null,"References","https://en.wikipedia.org/wiki/Junction_temperature"]
[null,null,"https://www.re-innovation.co.uk/docs/heatsink-calculations/"]
[null,null,"https://www.designworldonline.com/how-to-select-a-suitable-heat-sink/"]
[null,null,"https://www.cuidevices.com/product/resource/calculators/heat-sink-calculator"]

{"sheet":"Thermal Noise","index":39,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Index"]
[]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Slove Thermal Noise:","T=",23.0,"Celcius"]
[null,null,"R=",1000.0,"Ohms"]
[null,null,"B=",1.0E8,"Hertz"]
[null,null,"K=",{"$f":"D15+273.15","v":296.15},"Kelvin"]
[null,null,"V=",{"$f":"SQRT(4* (1.380649*10^-23)*D16*D18*D17)","v":0.00004044152328},"RMS Volt"]
[null,null,"dBV=",{"$f":"20*LOG(D19)","v":-87.86344989},"dBV"]
[]
[null,"References:"]
[null,null,"https://en.wikipedia.org/wiki/Johnson%E2%80%93Nyquist_noise"]

{"sheet":"Heat Sink Calculator","index":40,"n_rows":46,"n_cols":5,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Index"]
[]
[null,"Formulas:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Slove volume:","Power",6.0,"Watt"]
[null,null,"Volumetric thermal resistance",50.0,"Rv"]
[null,null,"Thermal junction",125.0,"ºC"]
[null,null,"Ambient temperature",35.0,"ºC"]
[null,null,"Heat sink  volume",{"$f":"(D15*D16)/(D17-D18)","v":3.333333333},"cm3"]
[]
[]
[null,"Slove power:","Heat sink  volume",3.33333333333333,"cm3"]
[null,null,"Volumetric thermal resistance",50.0,"Rv"]
[null,null,"Thermal junction",125.0,"ºC"]
[null,null,"Ambient temperature",35.0,"ºC"]
[null,null,"Power",{"$f":"D22/D23*(D24-D25)","v":6},"Watt"]
[]
[]
[null,"Slove Volume:","Base thickness",0.2,"cm"]
[null,null,"Base width",1.4,"cm"]
[null,null,"Base length",1.4,"cm"]
[null,null,"Fin thickness",0.4,"cm"]
[null,null,"Fin width",0.2,"cm"]
[null,null,"Fin lenght",0.2,"cm"]
[null,null,"Fins count",16.0,"number"]
[null,null,"Base volume",{"$f":"(D29*D30*D31)","v":0.392},"cm3"]
[null,null,"Fin volume",{"$f":"(D32*D33*D34)","v":0.016},"cm3"]
[null,null,"Total volume",{"$f":"D36+(D37*D35)","v":0.648},"cm3"]
[null,null,"Thermal Resistance",{"$f":"(D33/(237*D34*D32)/D35)","v":0.0006592827004},"ºC/W"]
[]
[]
[]
[]
[null,"References:"]
[null,null,"https://celsiainc.com/resources/calculators/heat-sink-size-calculator/"]
[null,null,"https://www.google.com/search?q=heat+sink+formula&oq=heat+sink+formula&aqs=chrome.0.35i39j0i22i30l5.18254j0j7&sourceid=chrome&ie=UTF-8"]

{"sheet":"Buck Converter Power Dissipated","index":41,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Index"]
[]
[null,"Formulas:"]
[]
[]
[]
[]
[null,"Slove volume:","Voltage",5.0,"V"]
[null,null,"Current",5.0,"I"]
[null,null,"Efeciency",85.0,"%"]
[null,null,"Power",{"$f":"D8*D9","v":25},"Watt"]
[null,null,"Power Draw",{"$f":"(D8*D9)/100*D10","v":21.25},"Watt"]
[null,null,"Power Lost",{"$f":"(D8*D9)/100*(100-D10)","v":3.75},"Watt"]
[]
[]
[]
[]
[null,"References:"]
[null,null,"https://www.edaboard.com/threads/what-is-the-formula-to-calculate-power-dissipation-in-a-switching-regulator.286300/"]