Spreadsheet: 09c7ed24-c377-476e-9125-c97541e190e3
Sheet: Sheet1

Bus admittance matrix Ybus | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Power-flow solutions by Gauss-Seidel method | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Final calculations | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28
Bus | 1 | 2 | 3 |  |  |  | Iteration m | (P_2 - jQ_2)/V_2(m-1)* | SUM(Y_2k . V_k) | V_2 | | V_2 | [NAME] | SUM(Y_3k . V_k) | (P_3 - jQ_3)/V_3(m-1)* | Q_3 | V_3 calculated | V_3 corrected | | V_3 | d_3 |  | SUM(Y_2k . V_k) | SUM(Y_3k . V_k) | P_2 | Q_2 | P_3 | Q_3 | P_1 | Q_1
1 | -12.5j | 10j | 2.5j |  |  |  | 0 |  |  | 1 | 1 | 0 |  |  |  | 1 | 1 | 1 | 0 |  | -2.01635329340484+0.771516730408409j | 1.01634682550586-0.24700678778787j | -2.00000611456336 | -0.500002795235045 | 0.999999646664384 | 0.306551675252686 | 1.000006467898976 | 0.193451119982359
2 | 10j | -15j | 5j |  |  |  | 1 | -2+0.5j | 15j | 0.966666666666667-0.133333333333333j | 0.97581874455363 | -7.853313301978197 | 0.666666666666665-0.16666666666667j | 1-0.16666666666667j | 0.16666666666667 | 1+4.44444444444447E-002j | 0.999013806466209+4.44006136207206E-002j | 1 | 2.54480437981311
3 | 2.5j | 5j | -7.5j |  |  |  | 2 | -1.96032672112019+0.787631271878645j | -0.222003068103603+14.995069032331j | 0.947162517363493-0.115888243534439j | 0.9542258219561273 | -6.975643410188747 | 0.[PHONE]-0.2567909616791j | 1.01220304738806-0.252357307120857j | 0.297050870389163 | 0.998422652525111+5.77015772954487E-002j | 0.998334171543876+5.76964637374129E-002j | 1 | 3.30760070082151
 |  |  |  |  |  |  | 3 | -2.01678889254387+0.774652827667899j | -0.288482318687064+14.9916708577194j | 0.947801202003433-0.115220438257121j | 0.9547789628554431 | -6.931210672905101 | 1.[PHONE]-0.24850027656191j | 1.01600613631742-0.248085297724401j | 0.306291991376932 | 0.998278841032208+5.86538593375756E-002j | 0.998278381990072+5.86538323665613E-002j | 1 | 3.36254694223169
Input data |  |  |  |  |  |  | 4 | -2.01622027483256+0.772640699485469j | -0.293269161832806+14.9913919099504j | 0.947916747364327-0.114863407533317j | 0.9548506492242282 | -6.909106931988892 | 1.[PHONE]-0.24750412810391j | 1.01625965019295-0.24738433433868j | 0.306565956176626 | 0.998262409488041+5.89256816701813E-002j | 0.998262372473888+5.89256794853007E-002j | 1 | 3.378149621461231
Type | Bus | V_i (p.u.) | d_i (deg) | P_i (p.u.) | Q_i (p.u.) |  | 5 | -2.01636680435665+0.771804870015954j | -0.294628397426503+14.9913118623694j | 0.94796713282356-0.11478256046201j | 0.9548909472290206 | -6.90392745726918 | 1.01585539844981-0.24713212943636j | 1.01632678643009-0.247104304229476j | 0.306562675458131 | 0.998258662446304+5.89885312160047E-002j | 0.998258660467703+5.89885310990863E-002j | 1 | 3.381757028691005
Swing | 1 | 1 | 0 |  |  |  | 6 | -2.01635146940304+0.771590025775246j | -0.294942655495431+14.9912933023385j | 0.947980218437553-0.114760587593841j | 0.9549012970007918 | -6.902524225594109 | 1.01621692121235-0.24703886132001j | 1.01634182038071-0.247031480849628j | 0.306553826245132 | 0.998257676404985+5.90051843215343E-002j | 0.998257676266078+5.90051843133238E-002j | 1 | 3.382712852466204
Load | 2 |  |  | -2 | -0.5 |  | 7 | -2.01634851123299+0.771532280650901j | -0.295025921566619+14.9912883813304j | 0.[PHONE]-0.114754839311091j | 0.9549041022718404 | -6.902156424851641 | 1.01631307890538-0.24701387176908j | 1.01634578834026-0.247011938374246j | 0.306551234178542 | 0.[PHONE]+5.90095455713079E-002j | 0.998257418470574+5.90095455707448E-002j | 1 | 3.382963170276724
Const V | 3 | 1 |  | 1 |  |  | 8 | -2.01634754036921+0.771517070488395j | -0.295047727853724+14.9912870923529j | 0.[PHONE]-0.114753320834366j | 0.9549048411445271 | -6.902059282134762 | 1.01633819595242-0.24700729790781j | 1.01634682550616-0.247006787792848j | 0.306550522642185 | 0.998257350455247+5.90106961779101E-002j | 0.998257350454583+5.90106961778708E-002j | 1 | 3.383029210291279