IEC cable sizing and voltage drop calculator: the Cable Schedule sheet with project defaults and circuit rows, labelled 50 circuits, Cu and Al, PVC and XLPE, methods A1 to F, no macros
  • IEC cable sizing and voltage drop calculator: the Cable Schedule sheet with project defaults and circuit rows, labelled 50 circuits, Cu and Al, PVC and XLPE, methods A1 to F, no macros
  • Results columns of the cable schedule showing design current, breaker rating, correction factors, cable size, voltage drop and an OK status per circuit
  • Worked Example sheet taking one circuit through the cable sizing method step by step, with yellow input cells
  • Data sheet with current-carrying capacity tables calculated by the IEC 60287 thermal model, plus grouping and soil factors
  • What you get: one Excel file with Start Here, Cable Schedule, Worked Example and Data sheets, and the apps it works in

IEC Cable Sizing + Voltage Drop Calculator

This workbook is for electrical engineers and designers who size cables in mm², not AWG, and follow the IEC 60364-5-52 method rather than the US NEC. Instead of working one circuit at a time, you fill a schedule of up to 50 circuits. For each row it finds the design current, picks the next standard breaker, applies ambient, grouping and soil factors, and selects the smallest cable that passes both current capacity and your voltage drop limit. Every row shows OK or FAIL with the reason and tells you whether current, voltage drop or minimum size set the result. Current ratings come from an IEC 60287 thermal model laid out on an open Data sheet, and you can type your national table's value on any row instead. Treat it as an estimation aid and check results against your local wiring rules.

$5.69 on Etsy

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

Buy on Etsy

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

What's included

  • IEC-Cable-Sizing-Voltage-Drop-Calculator.xlsx: one Excel file with four sheets
  • IEC-Cable-Sizing-Voltage-Drop-Calculator-Example-Printout.pdf: a printable PDF of the example
  • Start Here: how to use it, colour key, method notes and limits
  • Cable Schedule: project defaults + up to 50 circuits
  • Worked Example: one circuit, every step shown with the formula in words
  • Data: the calculated ratings (1.5-300 mm², 72 cable/method combinations), grouping and soil factors, and how they were calculated
What you get: one Excel file with Start Here, Cable Schedule, Worked Example and Data sheets, and the apps it works in

How it works

  1. Results columns of the cable schedule showing design current, breaker rating, correction factors, cable size, voltage drop and an OK status per circuit
    Read the result for each circuit The results columns of the Cable Schedule: design current, breaker, correction factors, required and selected size, voltage drop and a status such as "OK - size set by current".
  2. Worked Example sheet taking one circuit through the cable sizing method step by step, with yellow input cells
    Follow one circuit step by step The Worked Example sheet walks one circuit through the method one line at a time. Change the yellow input cells to try your own circuit.
  3. Data sheet with current-carrying capacity tables calculated by the IEC 60287 thermal model, plus grouping and soil factors
    Check the ratings behind it The open Data sheet lists the current ratings, grouping and soil factors from the IEC 60287 heat-balance model, with notes on how they were calculated.
  4. What you get: one Excel file with Start Here, Cable Schedule, Worked Example and Data sheets, and the apps it works in
    Start from the Start Here sheet One .xlsx with Start Here, Cable Schedule, Worked Example and Data sheets. It has no macros, and a script recalculated it in LibreOffice Calc.

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

Is this BS 7671 / AS/NZS 3008?

No. It follows the IEC 60364-5-52 sizing method, with current ratings calculated by the IEC 60287 thermal method (generic cable dimensions). National tables differ: use it for estimates, check against your own rules, or type your table's rating into the "Your table" columns.

Can I use my own table?

Yes. On any circuit row, type the size and its rating from your table in the two "Your table" columns; the row then uses your value. Breaker ratings are in an editable list. You can also unprotect the Data sheet (no password).

Does it do short-circuit or earth-fault checks?

No, only current capacity and voltage drop. See "Not covered".

Imperial / AWG?

No, metric (mm²) only.

Refunds?

Digital files can't be returned once downloaded. If a file is broken, message us and we will fix it.

Estimation aid. Check against your local code and equipment datasheets.

Related

Also included in this bundle:

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