Report this item to Etsy

Cable Sizing Calculator Excel, IEC Voltage Drop Spreadsheet, Metric Cable Schedule

Item highlights

  • Digital download
  • Digital file type(s): 1 ZIP
View more
Etsy's Purchase Protection

If something goes wrong with an order, we've got your back for all eligible purchases. View programme terms

NowPrice:£4.00

Original Price: £5.34

Loading

25% off

You can only make an offer when buying a single item.

Delivery

Instant download

Your files will be available to download once payment is confirmed. Here's how.

Instant download items don't accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Seller's description

Specifications

May include: An Excel template titled IEC Cable Sizing + Voltage Drop Calculator by tobulab. The interface displays a cable schedule table with columns for reference, description, phases, load, power factor, length, and installation method.

Size low-voltage cables the IEC / metric way, for up to 50 circuits at once.

Most cable calculators on Etsy follow the US NEC and AWG. This one follows the IEC 60364-5-52 method used in the UK, Europe, Australia, the Middle East and Asia: mm² sizes, reference installation methods A1 to F and D1/D2, copper or aluminium, PVC or XLPE insulation.

Current ratings are calculated with the IEC 60287 thermal method (our own heat-balance model with safe-side margins, explained in the file), not copied from any standard's table. Verify them against your local wiring rules.

WHAT IT DOES
- Design current from kW and power factor (or enter amps directly), 1-phase or 3-phase, 50 or 60 Hz
- Picks the next standard breaker rating, or uses yours
- Applies ambient temperature, grouping and soil resistivity factors
- Finds the smallest cable that carries the current AND keeps voltage drop under your limit
- Checks Ib <= In <= Iz on every circuit and shows a clear OK / FAIL status with the reason
- Tells you what set the size: current, voltage drop or minimum size
- Your own table: type a size and its rating from your national wiring rules on any row, and that row uses your value (flagged "user table")

WHAT'S INSIDE (1 Excel file + 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

WORKS WITH
A script opened this file in Microsoft Excel for Mac 16.114.3 and ran a full recalculation. Every cell matched the values stored in the file, with no error cells. That test did not type new data. Excel for Windows, older Excel versions and Google Sheets have not been tried. The formula tests ran in LibreOffice. No macros. Formula cells are protected without a password, so you can't break them by accident, and you can still unlock them.

GOOD TO KNOW
- Digital download. Nothing is shipped.
- Current ratings calculated with the IEC 60287 thermal method; verify against your local wiring rules. Your national tables (for example IEC 60364-5-52, BS 7671 or AS/NZS 3008) will give somewhat different values; you can type theirs in per circuit.
- Not covered: short-circuit/adiabatic check, earth-fault loop impedance, harmonics (use the extra derating factor), parallel cables, cables over 300 mm².
- This is an estimation aid. Check every result against the wiring rules where you work and have a qualified engineer review the design. Not affiliated with or endorsed by IEC.

HOW THIS WAS MADE
The workbook was designed and built with the help of AI tools. Scripts recalculated the file in LibreOffice and compared it with a separate Python calculation of the same method, across 19 test circuits including edge cases. Scripts also tested the current-rating model (heat balance, physics sanity checks).

For your own use and your company's projects. Please do not resell or share the file.

  • Designed by
  • Item type
    Digital download
  • Digital file type(s)
    1 ZIP
Shop with confidence
Etsy Purchase Protection

If something goes wrong with an order, we've got your back on all eligible purchases. View programme terms

Meet your seller

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on 25 Oct, 2026