New Microsoft Excel Worksheet.xlsx

R1 R2 R3 R4 R5 R6 Total

1.250 E+3 R5//R6 3.500 E+3 R4+Rb 4.700 E+3 R2+R3 4.700 E+3 Ra//Rc 6.800 E+3 Ra//Rc+R1 9.800 E+3 5.475 E+3 Component Total R1 R2 R3 R4 R5 R6 R5//R6 R4+R5//R6 R2+R3 (R2+R3)//(R4+R5//R6)

Voltage 120.000 E+0 27.400 E+0 39.520 E+0 53.060 E+0 49.960 E+0 42.670 E+0 42.670 E+0 42.670 E+0 92.610 E+0 92.610 E+0 92.610 E+0

Resistances 4.014 E+3 Rb 8.714 E+3 Ra 8.200 E+3 Rc 4.225 E+3 5.475 E+3 Total

Current 21.920 E-3 21.920 E-3 11.290 E-3 11.290 E-3 10.630 E-3 6.275 E-3 4.354 E-3 10.630 E-3 10.630 E-3 11.290 E-3 21.920 E-3

Resistance 5.475 E+3 1.250 E+3 3.500 E+3 4.700 E+3 4.700 E+3 6.800 E+3 9.800 E+3 4.014 E+3 8.714 E+3 8.200 E+3 4.225 E+3

Current

Power 2.630 E+0 600.600 E-3 446.200 E-3 599.000 E-3 531.100 E-3 267.800 E-3 185.800 E-3 453.600 E-3 984.400 E-3 1.046 E+0 2.030 E+0

Series Parrallel

Current is constant Sum V Voltage is constant Sum I

Voltage Current * Ressistance Current Voltage / Ressistance Power Voltage * Current Component Voltage Current Total 15.000 E+0 40.030 E-3 R1 4.003 E+0 40.030 E-3 R2 11.000 E+0 28.210 E-3 R3 2.958 E+0 11.830 E-3 R4 8.038 E+0 8.038 E-3 R5 455.000 E-3 3.792 E-3 R6 7.584 E+0 3.792 E-3 RD = R5+R6 8.038 E+0 3.792 E-3 RC = R4//RD 8.038 E+0 11.830 E-3 RB = R3+RC 11.000 E+0 11.830 E-3 RA = R2//RB 11.000 E+0 40.030 E-3

Resistance ### ### ### ### 1.000 E+3 ### 2.000 E+3 2.120 E+3 ### ### ###

Power

Given Already Calculated Calculated

15.000 E+0

8.039 E+0 11.830 E-3 11.000 E+0 40.040 E-3

1.200 E+3 3.300 E+3 1.000 E+3 2.200 E+3

R1 R2 R3 R4

7.260 E+9 ### 2.640 E+9 8.712 E+9 3.960 E+9 19.800 E+9 ### ###

5.84 5.875 E-3

11.220 E+9 11.350 E+9 ###