3-Phase Panel Schedule + Load Balancing Calculator
Balancing a three-phase distribution board by hand means moving circuits between L1, L2 and L3 and redoing the sums each time. This workbook does that arithmetic. Enter up to 60 outgoing circuits with kW, power factor and demand factor; single-phase loads sit on one line and 3-phase loads split equally. You get per-phase connected and demand load, phase imbalance %, neutral current, a main breaker with spare capacity and a feeder cable size. It then suggests up to three circuit moves from the most loaded phase to the least loaded one, keeping each only if it lowers the imbalance. In the worked example, a 21-circuit office board at 400 V goes from 54 % to 2 % imbalance in three moves. A Balance sheet shows every step, so you can check the logic or explain it to a client.
From our listing records. Etsy shows the current price and your local currency at checkout.
Buy on EtsyScripts recalculated this file in Excel for Mac 16.114.3 and LibreOffice. Excel for Windows, older Excel versions and Google Sheets have not been tried.
Instant download from Etsy · nothing shipped
What's included
- 3-Phase-Panel-Load-Schedule-Phase-Balance.xlsx: one Excel file
- 3-Phase-Panel-Load-Schedule-Phase-Balance-Example-Printout.pdf: a printable PDF of the example
- Sheets: Start Here, Panel Schedule, Summary, Balance, Lists (breaker ratings you can edit)
- Worked example: a 21-circuit office board at 400 V

How it works

Enter one row per circuit The Panel Schedule sheet: panel data at the top, then each circuit with its phase, load in kW, power factor and demand factor. 
Review the suggested moves Up to three circuit moves applied in order, with the imbalance and main breaker after the kept moves. You decide which moves to make on site. 
Read the main breaker and feeder The Summary sheet gives connected and demand load per phase, demand current, phase imbalance, neutral current, main breaker and feeder size. 
Check the logic behind each move The Balance sheet shows the most and least loaded phase, the score for each movable circuit, and the imbalance before and after every step.
Compatibility and file formats
Scripts recalculated this file in Excel for Mac 16.114.3 and LibreOffice. Excel for Windows, older Excel versions and Google Sheets have not been tried.
Instant download from Etsy · nothing shipped.
Video
Questions
- NEC 220 load calculation?
No. This is an IEC-style board schedule (L1/L2/L3, kW and demand factors), not the NEC 220 dwelling method.
- R/Y/B instead of L1/L2/L3?
The labels are fixed as L1/L2/L3 (R/Y/B in many countries). Read L1 = R, L2 = Y, L3 = B.
- Two-pole (line-to-line) single-phase loads?
Not modelled in this version. Splitting them as two half-loads understates the line current (by about 13 %), so check such loads separately.
Estimation aid. Check against your local code and equipment datasheets.
Related
Also included in this bundle:
-
Electrical Design Calculator Bundle (3 workbooks)
Cable sizing, solar sizing and 3-phase panel balancing workbooks that work together
$13.59 on Etsy

