Skip to main content
NEWIEC 60364, NEC

Lighting & Small Power Schedule Template (Excel)

Free download · Excel (.xlsx)

Plan lighting and small power circuits with this Excel template. Captures circuit reference, area/room, luminaire type and wattage, quantity, total load, control type (switch/PIR/DALI/timer), emergency classification, phase assignment, socket outlet details, total circuit load, cable type and size, protection device rating, and switchboard reference. Essential for detailed design of commercial and industrial lighting installations.

What's Included

Front:Circuit Ref, Area/Room, Luminaire Type/Wattage/Qty, Total Load W, Control Type, Emergency Y/N, Phase Assignment.
Back:Socket Outlet Qty/Rating/Load Allowance W, Total Circuit Load W, Cable Type/Size, Protection Device A, Switchboard Ref.
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 a lighting and small power schedule?

A lighting and small power schedule lists every lighting and socket outlet circuit in an installation, documenting luminaire types, loads, controls, and circuit details. It is used for detailed design, load balancing across phases, and compliance with IEC 60364 and NEC requirements.

What should a lighting schedule include?

Key fields include circuit reference, area/room served, luminaire type and wattage, quantity, total load, control method (switch/PIR/DALI/timer), emergency classification, phase assignment, socket outlet quantity and rating, cable type and size, and protection device rating.

How do you calculate lighting load for circuit design?

Sum the wattage of all luminaires on the circuit including control gear losses (typically 10–15% for LED drivers). Add socket outlet load allowance — BS 7671 uses 100W per socket for design purposes. The total determines cable size and protection device rating. Balance loads across phases to within 10%.