Electrical • Cables Microsoft Excel (.xlsx)
Cable Sizing & Voltage Drop (IEC)
Conductor selection for current capacity and voltage drop with adiabatic check.
Download Excel Workbook (.xlsx)
Version 0.1
What this workbook is
A real, downloadable Microsoft Excel workbook — not a rendered demo. Every sheet is built around a single engineering method: inputs in one place, calculated results and a PASS / WARN / FAIL check sheet, with the method, sources and assumptions recorded next to the numbers. Open it in Excel, Sheets or LibreOffice, change the inputs, and the workbook recalculates.
- Light cells are user-entered inputs on the Inputs sheet.
- Dark cells are calculated automatically and are not editable.
- The method and sources for every calculation are listed below and inside the workbook.
What you enter
- ✓Load kW / pf / phase
- ✓Length
- ✓Ampacity & factors (user)
- ✓Voltage drop limit
What it calculates
- ✓Design current Ib
- ✓Required / selected S
- ✓Voltage drop %
- ✓Adiabatic check
Method
Ib from P=√3VI·pf; apply IEC 60364-5-52 / BS 7671 correction factors (user tables); Vd = mV/A/m×Ib×L/1000; k²S² ≥ I²t
Sources
- [1] IEC 60364-5-52 / BS 7671 (method; tables user-supplied)
Inside the workbook
CoverTitle, scope and revision block
SummaryCore inputs and headline results
InputsYour project values (light cells)
CalculationsStep-by-step working sheet (dark cells)
OutputsReadback of results for reporting
ChecksPASS / WARN / FAIL against stated limits
ReferenceSources for each calculation
Notes & AssumptionsScope, exclusions and stated limits