How does a watt rating become kWh?
A watt is a unit of power. A kilowatt-hour is energy: using 1 kW steadily for 1 hour consumes 1 kWh. For a group of identical lights operating together, multiply the number of lights by each light’s input watts and operating hours, then divide by 1000 to convert watt-hours to kilowatt-hours.
For a specified number of days:
Energy (kWh) = light count × input power per light (W) × hours per day × days ÷ 1000.
This assumes each light uses the entered power whenever it is on, with the same daily duration throughout the period. Use the whole luminaire’s input power, including its required driver, at the setting being modelled. A light-output percentage is not an input-power measurement. Do not replace measured or stated operating watts with a dimming percentage.
Simple mode covers one uniform group in each scenario. The mixed-group mode separately accounts for different powers, tariff periods and standby states. Zero operating hours means no operating energy for that row; leaving the hours blank means there is insufficient information to calculate it.
What changes the energy total?
Count, power, hours and days each scale the energy directly when the others stay fixed. Ten lights used for 5 hours consume the same operating energy as five otherwise identical lights used for 10 hours. That equality says nothing about whether either arrangement provides suitable lighting.
A specified 300-day period is 300 days. Calling it a year would change the meaning of the budget. The supported range of 1–366 days keeps each estimate within a clearly stated planning period; it does not assume that lights operate every day of a calendar year.
Which price belongs in the cost calculation?
Usage cost (AUD) = energy (kWh) × usage rate (AUD/kWh).
A rate of 30 c/kWh is AUD0.30/kWh: divide cents by 100 before multiplying. Changing the rate unit preserves that price. It does not select a tariff or add tax. Keep the tax basis of the rate consistent with the cost you want to estimate and with any scenario being compared.
Victorian Energy Compare’s bill guidance distinguishes electricity usage in kWh, usage charges in cents/kWh and a separate daily supply charge. It also explains why the amount due can include balances beyond current usage. Dividing the total amount due by kWh therefore does not reliably isolate a usage rate.
Simple mode uses one constant rate per scenario. If your lighting runs across different time-of-use prices, a single unweighted average price can misstate the cost. Mixed-group mode matches each state’s energy to its applicable rate in AUD/kWh. Fixed supply charges, demand charges, credits, installation costs and solar or battery effects remain outside both modes; standby is included only when explicitly entered as a state.
An unknown rate still permits a useful energy estimate. No rate gives no cost; a deliberately entered zero rate gives zero usage cost under that price assumption. Those are different cases.
A household energy example
Assume, for an artificial example, ten lights each use 9 W for 5 hours per day over 365 days, at 30 c/kWh. These are invented assumptions, not typical usage, a product rating or an Australian tariff recommendation.
10 × 9 × 5 × 365 ÷ 1000 = 164.25 kWh.
At AUD0.30/kWh, 164.25 × 0.30 = AUD49.275, displayed as AUD49.28. The estimate is the lighting’s usage cost for those 365 days, excluding the other charges described above.
The calculation retains the entered decimal precision until display. Energy is shown to two decimal places and money is rounded to the nearest cent, with a half-cent rounded away from zero. A nonzero magnitude below 0.01 is identified with “<0.01”, and its sign is retained, so it is distinguishable from a true zero. Differences use unrounded amounts; subtracting separately rounded displayed costs can sometimes differ by a cent.
How should you read an A-minus-B comparison?
Both scenarios use the same specified number of days. Their light counts, power, daily hours and rates may differ, so check which assumptions explain the difference before treating it as a replacement benefit.
For another artificial example, compare 20 lights at 50 W each with 20 lights at 12 W each. Both run 10 hours per day for 300 days, with an assumed rate of AUD0.30/kWh.
For A, the combined input is 1000 W, or 1 kW. Multiplying by 10 hours and 300 days gives 3000 kWh. B uses 240 W, or 0.24 kW, giving 720 kWh. The AUD684 difference is conditional on those inputs over 300 days; it is not automatically an annual saving or an investment return.
A positive A-minus-B cost means A costs more under the supplied conditions. A negative value means B costs more. Neither direction demonstrates equivalent light output or task performance. The Lighting Product Comparison can help record corresponding lumens, watts and other specifications; YourHome’s lighting guidance also explains why wattage alone cannot describe the amount of light produced.
Split tariff periods and standby without counting the same hours twice
Mixed-group mode sums Σ(count × W × daily hours × days ÷ 1,000) and then sums each row’s unrounded kWh multiplied by its applicable AUD/kWh rate. A group ID identifies the same physical set of lights across its different operating states. Its count stays constant and the daily state hours total no more than 24. Different IDs identify different lights and may operate at the same time. The tool cannot detect that two IDs accidentally describe the same lamps, so the non-overlap declaration matters.
For an artificial 200-day example, ten lights draw 9 W while on and 0.5 W in standby:
These are invented loads and rates. Enter 0.40, not 40, in the AUD/kWh state-rate column. In mixed-group mode, all rows describe one representative day repeated for the specified period. For a changing weekday/weekend or seasonal schedule, use day-type mode instead. Unknown standby watts are not zero. An explicit zero-W state is valid, and a blank state rate preserves energy but leaves the combined cost unavailable.
Account for different day types and seasons
Day-type mode sums the same state calculation separately for mutually exclusive sets of days. Repeat a day-type ID for its groups and states, with the same day count on every row. Count that day type’s days once: the unique day-type counts must add up exactly to the specified period. A weekday that is also a closed day belongs in only one type. Seasonal weekday/weekend patterns need separate IDs such as summer-weekday and winter-weekday when their hours or rates differ.
For an artificial 365-day schedule, ten lights each draw 10 W during the entered operating hours:
For the weekdays, 10 × 10 × 8 × 260 ÷ 1,000 = 208 kWh. The weekends add 10 × 10 × 2 × 104 ÷ 1,000 = 20.8 kWh. The entered closed-day operating state adds zero. This example covers only those operating states: it supplies no standby-power data. Unentered hours or groups are omitted consumption, not evidence that their electricity use is zero. Include every relevant standby state for a complete usage estimate.
A physical group must keep one light count across all day types. Within each type, its states must not overlap and may total no more than 24 hours. These checks catch inconsistent entries; they cannot verify your real calendar or operating schedule. A result is an annual total only when the supplied day types actually cover a complete year. The tool never scales a shorter period into a year automatically.
Actual power at a dimmed setting must be measured or supported by matching data. Measured dimming interpolation can provide a conditional input estimate within supplied measurements; it does not establish the actual daily duration. For a whole-year cost plan including maintenance and replacements, use ownership cost with its separate constant-cost assumptions.
FAQs
Why is energy available but cost missing?
Energy needs count, power, hours and days. Cost also needs a valid rate. A missing or invalid price does not invalidate an otherwise valid energy quantity. A comparison only shows a cost difference when both costs can be calculated for the current inputs.
Can a lower usage cost prove an upgrade pays for itself?
No. A payback calculation also needs a comparable investment and the relevant net savings over a clearly defined period. This estimate includes neither installation and maintenance costs nor a product-life guarantee. It supplies a conditional operating-cost comparison, not an investment conclusion.
Can I use the same calculation for plant lights, photographic lights and LED strip?
Yes, when the input is the complete system’s electrical power for each actual operating state. A DLI supplement plan can supply planned lamp hours, but PPFD and DLI do not reveal electrical watts. For photographic continuous lighting, use the luminaire’s input at the stated setting; a flash energy rating in watt-seconds is not steady input watts. For strip, include the measured or specified matching driver/control input rather than assuming the strip’s per-metre watts already include all losses. Keep standby or separate operating states in distinct, non-overlapping rows.