E5 - Sheet1 A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18...

This preview shows page 1 - 3 out of 3 pages.

Sheet1 Page 1 R (ohm) alpha (Hz) 125 125 500 0.2 100 100 28 28 s1 i0 (A) w0 (Hz) -50 -6000 24 100 s2 -4800 v0 w (Hz) -200 -1344 0 96 A1 A a -8 24 24 A2 B b 24 -4800 -14 t (ms) i(t), R = 125 (A) i(t), R = 100 (A) i(t), R = 28 (A) 0 16 24 24 0.5 13.9136187366 20.5465555692 22.1642309073 1 12.0397026779 17.3728784263 20.4018726631 1.5 10.3576894057 14.4598940039 18.7139928923 2 8.8489817606 11.7897228443 17.1012172719 2.5 7.4967606124 9.3456093969 15.5637687282 3 6.2858154549 7.1118549185 14.101504745 3.5 5.2023911248 5.073754246 12.7139527913 4 4.2340491142 3.217536221 11.400343886 4.5 3.3695420837 1.5303075639 10.1596443224 5 2.5987003235 0 8.9905855844 5.5 1.912329023 -1.3846795449 7.8916924885 6 1.3021153204 -2.6342958533 6.8613095915 6.5 0.7605442037 -3.7587295927 5.8976259101 7 0.2808224168 -4.7672189164 4.998697998 7.5 -0.1431903868 -5.6683986329 4.1624714325 8 -0.5170439364 -6.4703370833 3.3868007638 8.5 -0.8457537038 -7.1805708567 2.6694679813 9 -1.1338518957 -7.806137467 2.0081995549 9.5 -1.3854335904 -8.3536061066 1.4006821074 10 -1.60419848 -8.8291065881 0.8445767784 10.5 -1.7934886369 -9.2383565765 0.3375323376 11 -1.9563226823 -9.5866872105 -0.1228028938 11.5 -2.0954267011 -9.8790672046 -0.5387702538 12 -2.2132622098 -10.1201255203 -0.9126910237 12.5 -2.3120514612 -10.314172687 -1.2468577298 13 -2.3938003369 -10.4652208525 -1.5435264027 13.5 -2.4603190591 -10.5770026344 -1.8049097413 14 -2.5132409273 -10.6529888423 -2.0331711245 14.5 -2.5540392703 -10.6964051371 -2.2304194186 15 -2.5840427811 -10.7102476871 -2.3987045277 15.5 -2.6044493905 -10.6972978809 -2.5400136374 16 -2.6163388175 -10.6601361501 -2.6562681015 16.5 -2.6206839221 -10.6011549559 -2.7493209276 17 -2.6183609765 -10.5225709854 -2.8209548122 L (mH) C (mF) di/dt 0+ A B C D 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
Sheet1 Page 1 R (ohm) alpha (Hz) 125 =A2/(2*C$2/1000) 500 0.2 100 =A3/(2*C$2/1000) 28 =A4/(2*C$2/1000) s1 i0 (A) w0 (Hz) =-B$2+SQRT(B$2^2-B$6^2) =(-1/(C$2/1000))*(A2*A$6+A$8) 24 =SQRT(1/(C2/1000*D2/1000)) s2 =(-1/(C$2/1000))*(A3*A$6+A$8) v0 w (Hz) =-B$2-SQRT(B$2^2-B$6^2) =(-1/(C$2/1000))*(A4*A$6+A$8) 0 =SQRT(B6^2-A4^2) A1 A a =(D5-C7*A6)/(C5-C7) =A6 =A6 A2 B b =A6-E2 =D6+B3*F2 =(D7+B4*G2)/B8 t (ms) i(t), R = 125 (A) i(t), R = 100 (A) i(t), R = 28 (A) =(ROW()-ROW(A$14))*0.5 =$A$10*EXP($C$5*A14/1000)+$A$12*EXP($C$7*A14/1000) =EXP(-$B$3*A14/1000)*($B$10+$B$12*A14/1000) =EXP(-$B$3*A14/1000)*($C$10*COS($B$8*A14/1000)+$C$12*SIN($B$8*A14/1000)) =(ROW()-ROW(A$14))*0.5 =$A$10*EXP($C$5*A15/1000)+$A$12*EXP($C$7*A15/1000) =EXP(-$B$3*A15/1000)*($B$10+$B$12*A15/1000) =EXP(-$B$3*A15/1000)*($C$10*COS($B$8*A15/1000)+$C$12*SIN($B$8*A15/1000)) =(ROW()-ROW(A$14))*0.5 =$A$10*EXP($C$5*A16/1000)+$A$12*EXP($C$7*A16/1000) =EXP(-$B$3*A16/1000)*($B$10+$B$12*A16/1000) =EXP(-$B$3*A16/1000)*($C$10*COS($B$8*A16/1000)+$C$12*SIN($B$8*A16/1000)) =(ROW()-ROW(A$14))*0.5 =$A$10*EXP($C$5*A17/1000)+$A$12*EXP($C$7*A17/1000) =EXP(-$B$3*A17/1000)*($B$10+$B$12*A17/1000) =EXP(-$B$3*A17/1000)*($C$10*COS($B$8*A17/1000)+$C$12*SIN($B$8*A17/1000)) =(ROW()-ROW(A$14))*0.5 =$A$10*EXP($C$5*A18/1000)+$A$12*EXP($C$7*A18/1000) =EXP(-$B$3*A18/1000)*($B$10+$B$12*A18/1000) =EXP(-$B$3*A18/1000)*($C$10*COS($B$8*A18/1000)+$C$12*SIN($B$8*A18/1000)) =(ROW()-ROW(A$14))*0.5 =$A$10*EXP($C$5*A19/1000)+$A$12*EXP($C$7*A19/1000) =EXP(-$B$3*A19/1000)*($B$10+$B$12*A19/1000) =EXP(-$B$3*A19/1000)*($C$10*COS($B$8*A19/1000)+$C$12*SIN($B$8*A19/1000)) =(ROW()-ROW(A$14))*0.5 =$A$10*EXP($C$5*A20/1000)+$A$12*EXP($C$7*A20/1000) =EXP(-$B$3*A20/1000)*($B$10+$B$12*A20/1000) =EXP(-$B$3*A20/1000)*($C$10*COS($B$8*A20/1000)+$C$12*SIN($B$8*A20/1000)) =(ROW()-ROW(A$14))*0.5 =$A$10*EXP($C$5*A21/1000)+$A$12*EXP($C$7*A21/1000) =EXP(-$B$3*A21/1000)*($B$10+$B$12*A21/1000) =EXP(-$B$3*A21/1000)*($C$10*COS($B$8*A21/1000)+$C$12*SIN($B$8*A21/1000)) =(ROW()-ROW(A$14))*0.5 =$A$10*EXP($C$5*A22/1000)+$A$12*EXP($C$7*A22/1000) =EXP(-$B$3*A22/1000)*($B$10+$B$12*A22/1000) =EXP(-$B$3*A22/1000)*($C$10*COS($B$8*A22/1000)+$C$12*SIN($B$8*A22/1000)) =(ROW()-ROW(A$14))*0.5 =$A$10*EXP($C$5*A23/1000)+$A$12*EXP($C$7*A23/1000) =EXP(-$B$3*A23/1000)*($B$10+$B$12*A23/1000) =EXP(-$B$3*A23/1000)*($C$10*COS($B$8*A23/1000)+$C$12*SIN($B$8*A23/1000)) =(ROW()-ROW(A$14))*0.5 =$A$10*EXP($C$5*A24/1000)+$A$12*EXP($C$7*A24/1000) =EXP(-$B$3*A24/1000)*($B$10+$B$12*A24/1000) =EXP(-$B$3*A24/1000)*($C$10*COS($B$8*A24/1000)+$C$12*SIN($B$8*A24/1000)) =(ROW()-ROW(A$14))*0.5 =$A$10*EXP($C$5*A25/1000)+$A$12*EXP($C$7*A25/1000) =EXP(-$B$3*A25/1000)*($B$10+$B$12*A25/1000) =EXP(-$B$3*A25/1000)*($C$10*COS($B$8*A25/1000)+$C$12*SIN($B$8*A25/1000)) =(ROW()-ROW(A$14))*0.5 =$A$10*EXP($C$5*A26/1000)+$A$12*EXP($C$7*A26/1000) =EXP(-$B$3*A26/1000)*($B$10+$B$12*A26/1000) =EXP(-$B$3*A26/1000)*($C$10*COS($B$8*A26/1000)+$C$12*SIN($B$8*A26/1000)) =(ROW()-ROW(A$14))*0.5 =$A$10*EXP($C$5*A27/1000)+$A$12*EXP($C$7*A27/1000) =EXP(-$B$3*A27/1000)*($B$10+$B$12*A27/1000) =EXP(-$B$3*A27/1000)*($C$10*COS($B$8*A27/1000)+$C$12*SIN($B$8*A27/1000)) =(ROW()-ROW(A$14))*0.5 =$A$10*EXP($C$5*A28/1000)+$A$12*EXP($C$7*A28/1000) =EXP(-$B$3*A28/1000)*($B$10+$B$12*A28/1000) =EXP(-$B$3*A28/1000)*($C$10*COS($B$8*A28/1000)+$C$12*SIN($B$8*A28/1000)) =(ROW()-ROW(A$14))*0.5 =$A$10*EXP($C$5*A29/1000)+$A$12*EXP($C$7*A29/1000) =EXP(-$B$3*A29/1000)*($B$10+$B$12*A29/1000) =EXP(-$B$3*A29/1000)*($C$10*COS($B$8*A29/1000)+$C$12*SIN($B$8*A29/1000)) =(ROW()-ROW(A$14))*0.5 =$A$10*EXP($C$5*A30/1000)+$A$12*EXP($C$7*A30/1000) =EXP(-$B$3*A30/1000)*($B$10+$B$12*A30/1000)

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture