|
|
|
|
|
|
|
physicsmatayom
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
B1
|
C1
|
D1
|
E1
|
|
RLC_series1
|
Value
|
excel-code
|
D3
|
check_ans
|
|
Input R(Ohm),+X_axis_phasevector=
|
100.00
|
=100
|
D4
|
FALSE
|
|
Input L(mH,millihenry)=
|
100
|
=0.1
|
D5
|
FALSE
|
|
Input C(mFd,microfarad)=
|
200
|
=0.0001
|
D6
|
FALSE
|
|
Input f(Hz)=
|
50.00
|
=50
|
D7
|
FALSE
|
|
Input Vrms(V)=
|
220.00
|
=220
|
D8
|
FALSE
|
|
XC(ohm)=1/(2*pi*f*C) ,-X_axis_phase_vector
|
15.92
|
=1/(2*PI()*$B$10*$B$9*0.000001)
|
D9
|
FALSE
|
|
XL(Ohm)=2*pi*f*L,+Y_axis_phase_vector
|
31.42
|
=2*PI()*$B$10*$B$8*0.001
|
D10
|
FALSE
|
|
X(reactance)=(XL-XC)
|
15.50
|
=$B$13-$B$12
|
D11
|
FALSE
|
|
Z=SQRT(R^2+(XL-/XC)^2)
|
101.19
|
=SQRT($B$7^2+$B$14^2)
|
D12
|
FALSE
|
|
tan(phase)=(XL-XC)/R
|
0.16
|
=$B$14/$B$7
|
D15
|
FALSE
|
|
phase(deg)=atan(phase)*180/pi()
|
8.81
|
=ATAN($B$16)*180/PI()
|
D16
|
FALSE
|
|
Power factor=cos(phase)
|
0.99
|
=COS($B$17*PI()/180)
|
D17
|
FALSE
|
|
Irms(A)=Vrms/Z
|
2.17
|
=$B$11/$B$15
|
D18
|
FALSE
|
|
Peffective(W)=Irms*Vrms*cosf
|
472.64
|
=$B$19*$B$11*$B$18
|
D19
|
FALSE
|
|
fresonance(Hz)=1/(2*p*sqrt(L*C))
|
35.59
|
=1/(2*PI()*SQRT($B$8*0.001*$B$9* 0.000001))
|
D20
|
FALSE
|
|
v=Vm*sin(wt)
|
|
voltage lead I by phase (phi)
|
D21
|
|
|
i=Im*sin(wt-Phase)
|
|
i lag v by phase(phi)
|
D22
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
rlc_series_phase_vector11.gif
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
rlc_parallel_phase_vector11.gif
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|