| ! Copy to Excel--A1--- | B1 | C1 | D1 |
|---|---|---|---|
| http://members.thai.net/physicsmatayom/index.htm | RLC_paralell1 | D2 | |
| Variables | Value | excel-code | D3 |
| Input R(Ohm)= | 100 | =100 | D4 |
| Input L(H)= | 0.1 | =0.1 | D5 |
| Input C(F)= | 0.0001 | =0.0001 | D6 |
| Input f(Hz)= | 50 | =50 | D7 |
| Input Vrms(V)= | 220 | =220 | D8 |
| XC(ohm)=1/(2*p*f*C) | 31.83 | =1/(2*PI()*$B$7*$B$6) | D9 |
| XL(Ohm)=2*p*f*L | 31.42 | =2*PI()*$B$7*$B$5 | D10 |
| IR,rms=VR,rms,+X-axis-Phase_vector | 2.2 | =$B$8/$B$4 | D11 |
| IC,rms=VC,rms,+Y-axis-Phase_vector | 6.91 | =$C$8/$C$9 | D12 |
| IL,rms=VL,rms,-Y-axis-Phase_vector | 7 | =$C$8/$C$10 | D13 |
| Irms=SQRT(IR2+(IC-IL)2) | 2.2 | =SQRT($C$11^2-($C$12-$C$13)^2) | D14 |
| tanf=(IC-IL)/IR | -0.04 | =($B$12-$B$13)/$B$11 | D15 |
| f=phase(deg)=atan(phase)*180/pi() | -2.38 | =ATAN($C$15)*180/PI() | D16 |
| Z(ohm)=Vrms/Irms | 99.91 | =$C$8/$C$14 | D17 |
| 1/Z=SQRT((1/R)2+(1/XC-1/XL)2) | 0.01 | =SQRT(1/$C$4^2-(1/$C$9-1/$C$10)^ 2) | D18 |
| Z=1/SQRT((1/R)2+(1/XC-1/XL)2) | 100.09 | =1/$C$18 | D19 |
| Power factor=cosf | 1 | =COS($C$15*PI()/180) | D20 |
| Peffective(W)=Irms*Vrms*cosf | 484 | =$C$14*$C$8*$C$20 | D21 |
| fresonance(Hz)=1/(2*p*sqrt(L*C)) | 50.33 | =1/(2*PI()*SQRT($C$5*$C$6)) | ! ---D22---end copy to excel |