Electrical Load Schedule Template (Excel)
Free download · Excel (.xlsx)
The electrical load schedule is the foundation document for every electrical design — it drives cable sizing, switchboard selection, transformer capacity, and generator requirements. This Excel template provides a comprehensive load schedule with columns for Equipment Tag, Description, Area/Zone, Rated Power (kW), Voltage (V), Phases, Power Factor, Full Load Current (A), Quantity, Connected Load (kW), Demand Factor, Maximum Demand (kW), Operating Hours per day, Annual Energy (kWh), Feeder Reference, Switchboard Reference, Priority (essential/non-essential), and Notes. Auto-sums connected load, maximum demand, and annual energy per area and per switchboard. Includes a summary dashboard sheet showing total connected kW, total demand kW, overall diversity factor, and energy cost estimate. Compatible with IEC 60364, NEC Article 220, AS/NZS 3000, and BS 7671 load assessment methodologies.
What's Included
How to Print
- ●Open in Microsoft Excel 2016+, Google Sheets, or LibreOffice Calc
- ●Add your company logo and project details to the header
- ●Copy data rows to add more circuits or equipment
- ●Print on A4 or A3 landscape for site records
- ●Keep completed records for design verification and audit trail
Try the Interactive Calculator
Need precise calculations beyond quick reference? Try our free online calculator with full clause references and professional report output.
Open CalculatorRelated Downloads
Max Demand Record
Download a free maximum demand assessment record template Excel per AS/NZS 3000, BS 7671, and NEC Art 220. Columns for load groups, demand factors, diversity, phase assignment, and transformer sizing. No signup required.
Motor Load List
Free motor load list template Excel download for electrical engineering. Columns for tag, description, kW, voltage, FLA, efficiency, PF, starting method, diversity factor, demand kVA.
Switchboard Schedule
Free switchboard schedule template Excel download. Pre-formatted for circuit details, protection devices, cable sizes. Professional engineering layout.
Cable Schedule
Free cable schedule template Excel download for electrical engineering. Columns for tag, from/to, voltage, phases, load, cable size, installation method, voltage drop, protective device.
Frequently Asked Questions
What is the difference between a load schedule and a cable schedule?
A load schedule lists all electrical equipment with their power ratings and demand factors — it determines WHAT needs to be supplied. A cable schedule lists the cables connecting equipment to switchboards — it determines HOW power is delivered. The load schedule feeds the cable schedule.
How do I determine demand factors for each load?
Demand factors come from the applicable standard: NEC Article 220 Tables 220.42/220.44, AS/NZS 3000 Table C1, BS 7671 Appendix 1. For specialist equipment, use manufacturer data or site-measured data from similar installations.
Why does this template include annual energy?
Annual energy consumption (kWh) is essential for transformer loss evaluation, generator fuel estimation, energy cost budgeting, and sustainability reporting. Operating hours multiplied by maximum demand gives a conservative energy estimate.