Electrical Design Calculator Bundle (3 workbooks)
If your work covers distribution boards, cables and solar, this bundle gives you our three IEC / metric design workbooks in one download. They are built to be used in order: balance the board and get its main breaker and feeder, size that feeder and every final circuit for current and voltage drop, then plan an off-grid or hybrid solar system for the same loads. The cable workbook handles up to 50 circuits, the panel schedule up to 60, and the solar workbook runs from a daily load table to PV strings, battery bank, controller and inverter. Each file has a Start Here sheet, a worked example and a printable PDF of that example. Scripts compared the formulas with a separate Python calculation across 34 test cases. These are estimation aids: check every result against the rules where you work.
From our listing records. Etsy shows the current price and your local currency at checkout.
Buy on EtsyScripts recalculated these files 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
- IEC-Cable-Sizing-Voltage-Drop-Calculator.xlsx: up to 50 circuits, methods A1 to F and D1/D2, Cu or Al, PVC or XLPE
- Off-Grid-Solar-Battery-Sizing-Calculator.xlsx: daily loads, PV strings, battery bank, controller, inverter and payback
- 3-Phase-Panel-Load-Schedule-Phase-Balance.xlsx: up to 60 circuits, imbalance %, main breaker and suggested moves
- A printable example PDF for each workbook (3 PDFs)
- Each file has a Start Here sheet and a worked example

How it works

Use the three tools in order Panel schedule first for the main breaker and feeder current, then cable sizing for the feeder and final circuits, then solar and battery sizing for the same loads. 
Size the cables The Cable Schedule takes up to 50 circuits and checks each one for current capacity and voltage drop. 
Plan solar and batteries The solar workbook goes from a daily load table to the PV array, battery bank, charge controller and inverter. 
Balance the board The panel schedule gives per-phase demand, imbalance % and the main breaker, and suggests moves to even out L1, L2 and L3.
Compatibility and file formats
Scripts recalculated these files 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
Estimation aid. Check against your local code and equipment datasheets.
Related
This bundle contains:
-
IEC Cable Sizing + Voltage Drop Calculator
Size up to 50 IEC circuits for current and voltage drop, with OK / FAIL on every row
$5.69 on Etsy -
Off-Grid Solar + Battery Sizing Calculator
Go from a daily load list to PV array, battery bank, controller and inverter, with string checks
$5.69 on Etsy -
3-Phase Panel Schedule + Load Balancing Calculator
Schedule up to 60 circuits and get suggested moves that even out L1, L2 and L3
$5.69 on Etsy
Guide: How to size a cable to IEC 60364: a worked example with derating and voltage drop



