Skip to main content
NEWAS/NZS 3000 / BS 7671 / NEC Art 220

Maximum Demand Assessment Record (Excel)

Free download · Excel (.xlsx)

Maximum demand calculations determine the supply capacity for a building or facility — get it wrong and you either oversize (wasted capital) or undersize (nuisance tripping and overloaded cables). This Excel template provides a structured maximum demand record with columns for Circuit/Load Group, Load Type, Connected Load (kW/kVA), Power Factor, Demand Factor, After-Diversity Load, Diversity Source (standard clause reference), Phase Assignment (L1/L2/L3), Running Load Current, Starting Load Current, Total Maximum Demand (kVA), Main Supply Rating (A), Transformer Rating, Spare Capacity (%), and Standard Reference. Auto-sums per phase for load balancing verification. Applicable to AS/NZS 3000 Section 2, BS 7671 Appendix 1, and NEC Article 220 methodologies. Use alongside ECalPro's maximum demand calculator for standard-specific diversity factor lookup.

What's Included

Front:Circuit/load group, load type, connected load (kW/kVA), power factor, demand factor, after-diversity load, diversity source, phase assignment (L1/L2/L3).
Back:Running and starting load currents, total max demand (kVA), main supply rating, transformer rating, spare capacity %, standard reference. Auto-sum per phase.
Size:Excel (.xlsx)
Format:PDF, print-ready

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 Calculator

Frequently Asked Questions

What is the difference between demand factor and diversity factor?

Demand factor is the ratio of maximum demand to connected load for a single load type (e.g., 0.65 for lighting). Diversity factor accounts for the probability that not all load groups operate simultaneously. Both are applied to reduce connected load to actual maximum demand.

Which standard's demand factors should I use?

Use the standard applicable to your jurisdiction: AS/NZS 3000 Section 2 for Australia/NZ, BS 7671 Appendix 1 for the UK, NEC Article 220 for the US. The Standard Reference column lets you cite the specific clause for each demand factor applied.

How do I account for future load growth?

Add a spare capacity row (typically 20-30% for commercial, 10-20% for residential). The Spare Capacity % column in this template auto-calculates based on the transformer or supply rating versus calculated maximum demand.