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.

$13.59 on Etsy

From our listing records. Etsy shows the current price and your local currency at checkout.

Buy on Etsy

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

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
What you get: three Excel files for cable sizing, off-grid solar and battery sizing, and a 3-phase panel schedule

How it works

  1. Three tools that work together: panel schedule, cable sizing, and solar plus battery sizing, shown side by side
    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.
  2. IEC cable sizing and voltage drop calculator: Cable Schedule sheet with project defaults and circuit rows
    Size the cables The Cable Schedule takes up to 50 circuits and checks each one for current capacity and voltage drop.
  3. Off-grid solar and battery sizing calculator: Loads and System Design sheets with daily energy and PV array size
    Plan solar and batteries The solar workbook goes from a daily load table to the PV array, battery bank, charge controller and inverter.
  4. 3-phase panel load schedule and phase balance workbook: Panel Schedule sheet for an example office board
    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:

Guide: How to size a cable to IEC 60364: a worked example with derating and voltage drop