Annual Lighting kWh Formulas Table

Formula table for turning lighting watts, fitting count and operating hours into annual kWh estimates.

Connected load to annual kWhEnergy estimates stay readable when the same lighting group carries load, schedule and annual kWh together.
Table PDFAnnual Lighting kWh Formulas Table

Download the table with the page URL and retrieval date for offline lighting checks.

Energy formulaCalculation basisExample resultBoundary
Watts to kWConnected watts / 1,000.240 W becomes 0.24 kW.Only the named lighting group is counted.
Daily kWhConnected kW x hours per day.0.24 kW x 6 h = 1.44 kWh/day.The hour value must match the named zone and control state.
Annual kWhConnected kW x annual operating hours.0.24 kW x 1,200 h = 288 kWh/year.Annual hours need their own schedule line.
Fitting group loadFitting count x input watts per fitting.12 fittings x 18 W = 216 W.Watts do not show whether the task plane receives enough light.
Replacement comparisonExisting annual kWh minus proposed annual kWh.520 kWh - 310 kWh = 210 kWh change.The comparison does not include tariff, demand or maintenance items.
Control caseFull-load kWh and reduced-output case kept as separate rows.Full-output case remains visible beside the reduced case.Do not hide the fallback condition inside one optimistic number.

Related pages