2007/Nov/18

rlc

    RLC
  1. http://www.editgrid.com/user/physicsmatayom
  2. http://www2.se-ed.net/sathapornprom/rlcparalell1.htm



RLC_parallele1
! Copy to Excel--A1--- B1 C1 D1
http://sathaporn.exteen.com RLC_parallel1   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


edit @ 26 Dec 2007 19:56:35 by physicsmatayom