rlc parallel1

Sheet1

B1
C1
D1
E1
RLC_parallel1_Variables
Value
excel-code
D3
check_ans
Input R(Ohm)=
100.00
=100
D4
FALSE
Input L(H)=
1.00E-01
=0.1
D5
FALSE
Input C(F)=
1.00E-04
=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)
31.83
=1/(2*PI()*$B$6* $B$5)
D9
FALSE
31.42
=2*PI()*$B$6*$B$4
D10
FALSE
IR,rms=VR,rms,+X-axis-Phase_vector
2.20
=$B$7/$B$3
D11
FALSE
IC,rms=VC,rms,+Y-axis-Phase_vector
6.91
=$B$7/$B$8
D12
FALSE
IL,rms=VL,rms,-Y-axis-Phase_vector
7.00
=$B$7/$B$9
D13
FALSE
Irms=SQRT(IR^2+(IC-IL)^2)
2.20
=SQRT($B$10^2-( $B$11-$B$12)^2)
D14
FALSE
tan(phase)=(IC-IL)/IR
-0.04
=($B$11-$B$12)/ $B$13
D15
FALSE
phase(deg)=atan(phase)*180/pi()
-2.38
=ATAN($B$14)*180/PI()
D16
FALSE
Z(ohm)=Vrms/Irms
100.09
=$B$7/$B$13
D17
FALSE
1/Z=SQRT((1/R)^2+(1/XC-1/XL)^2)
0.01
=SQRT(1/$B$3^2-(1/$B$8-1/$B$9)^ 2)
D18
FALSE
Z=1/SQRT((1/R)^2+(1/XC-1/XL)^2)
100.09
=1/$B$17
D19
FALSE
Power factor=cos(phase)
1.00
=COS($B$13*PI()/180)
D20
FALSE
Peffective(W)=Irms*Vrms*cos(phase)
483.23
=$B$13*$B$7*$B$19
D21
FALSE
fresonance(Hz)=1/(2*pi*sqrt(L*C))
50.33
=1/(2*PI()*SQRT($B$4*$B$5))
D22
FALSE
rlc_parallel_phase_vector11.gif
PHYSICSMATAYOM_LINK

Sheet2

Sheet3