Cable Sizing Calculator Excel, IEC Voltage Drop Spreadsheet, Metric Cable Schedule
Item highlights
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
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
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 typeDigital download
-
Digital file type(s)1 ZIP
If something goes wrong with an order, we've got your back on all eligible purchases. View programme terms
Meet your seller
More from this shop
-
Digital download
Off Grid Solar Calculator Excel, Panel and Battery Sizing Spreadsheet, Inverter Sizing
Sale Price £4.00
Original Price £5.34
-
Digital download
3 Phase Panel Schedule Excel, Load Schedule and Phase Balancing Spreadsheet
Sale Price £4.00
Original Price £5.34
-
Digital download
2027 Monthly Calendar Printable, 12 Landscape Pages With Notes Column, Letter and A4
Sale Price £2.10
Original Price £2.81
-
Digital download
Reading Journal Printable, Book Review Pages, Reading Log and TBR List, Letter and A4
Sale Price £2.10
Original Price £2.81
-
Digital download
Academic Planner 2026 2027 for Engineering Students, 18 Month Digital, Lab Reports, Engineering Paper
Sale Price £2.95
Original Price £3.94
-
Digital download
Academic Planner 2026 2027 Digital for STEM Students, 18 Month, Lab and Exam Tracker
Sale Price £2.95
Original Price £3.94
-
Digital download
Electrician Price Book ︱ Electrical ︱Excel ︱Spreadsheet ︱Instant Download
£9.37
-
Digital download
Electrical Project Cost Estimate Template | Google Sheets Template
Sale Price £9.85
Original Price £13.14
-
Digital download
Electrical Estimate Proposal Template in Excel. Electrical Contractor Quote Form. Electrical Bid Form. Electrical Proposal Form. MS Excel.
Sale Price £3.92
Original Price £7.85
-
Digital download
Electrical Contractor Chart of Accounts for QuickBooks Online | COA Template | CSV Import + Bonus QBO Setup Guide
Sale Price £6.00
Original Price £7.50
-
Digital download
Electrical Estimate Template | Electrical Contractor Quote | Electrician Company Spreadsheet (Excel & Google Sheets)
£3.98
-
Digital download
Electrical Plumbing Cost Calculator – Google Sheets Estimate Template
Sale Price £10.55
Original Price £14.08
-
Digital download
Electrical Estimate Template, Editable Google Sheets, Easy to Use Digital Download for Contractors & Electricians
Sale Price £4.69
Original Price £9.38
-
Digital download
Editable Electrical Proposal Template: Auto-Calculating in Excel, Word, PDF
£6.55
-
Digital download
cost calculator, ready built spread sheet for calculating costs ideal for makers and small business, suitable for excel and google sheets
£6.60
-
Digital download
Electrical Rough-In Inspection Checklist Template – Word & PDF, A4 + US Letter
Sale Price £4.89
Original Price £8.91
-
Digital download
Soap Recipe Cost Calculator Excel
£4.69
-
Digital download
Electrical Estimate Template: Contractor Google Sheets (Digital Download)
Sale Price £4.68
Original Price £9.36
Shoppers with similar taste loved these
-
Digital download
Modern Mall Revit Project | Commercial BIM Model, Architectural Plans (RVT 2019)
Sale Price £14.07
Original Price £28.14
-
Digital download
Classic Villa Revit Project | Architecture + 3D Complete House Design
Sale Price £8.91
Original Price £17.82
-
Digital download
Modern Hospital Revit BIM Project | Complete Architectural Model (Digital Download)
Sale Price £11.26
Original Price £22.51
-
Digital download
Revit MEP HVAC Library – 500MB+ Air Conditioning & Ventilation Families (Digital Download)
Sale Price £6.10
Original Price £12.19
-
Digital download
Infrastructure Revit Library - 400 MB BIM Families collection | Cranes, Excavators, Barriers & Tanks
Sale Price £3.28
Original Price £6.56
-
Digital download
Hospital & Clinic Furniture Revit Families + AutoCAD Blocks | Medical Equipment BIM Library | Healthcare CAD Bundle
Sale Price £6.57
Original Price £13.14
-
Digital download
Commercial Building Revit Project | Modern Shopping Center BIM Model | Architectural Design | RVT.19
Sale Price £16.42
Original Price £32.83
-
Digital download
Complete Hospital Revit BIM Project | Architecture + Structure + MEP + Fire Fighting
Sale Price £25.33
Original Price £50.66
-
Digital download
School Revit Project | Educational Building Model + Floor Plans + BIM Training Pack
Sale Price £11.26
Original Price £22.51
-
Digital download
Hotel Revit Project | Architectural BIM Model | Complete 3D Building Design | RVT File 2014
Sale Price £23.45
Original Price £46.91
-
Unifi G6 / G5 Turret Ultra Arm Wall Mount (PN 220010)
£21.57
£51.54+ incl. postage
-
UniFi Bullet 4 inch Round Electrical Box Mount - G6 G5 G4 G3 Pro AI Bullet - Ubiquiti Junction Box Plate, UACC-GB-Plate alternative
£9.38
£29.97+ incl. postage