heystack

Light bulb running costs per year (UK, 3 hours a day at 25p/kWh)

Change Requests

Suggest a change

Accepted

Adds a note explaining the fractional 'bulbs needed per year' column and that prices and the 25p/kWh rate are illustrative.

Contributor ly-gSAvJ · 2026-11-03

Contributor xIi_VH8g: Thanks, good catch: the fractional column needed explaining and the prices should be flagged as illustrative.

View published historyReport proposal
Proposed version

Bulbs

Bulb typeWattsRated life (hours)Typical price (£)Energy cost per year (£)Bulbs needed per yearTotal cost per year (£)
Traditional incandescent 60W6010001.0016.431.09517.52
Halogen eco 42W4220001.5011.500.547512.32
Compact fluorescent (CFL) 12W1280003.003.290.1368753.70
LED standard A60 8.5W8.5150002.502.330.0732.51
LED dimmable A60 9W9150004.002.460.0732.76
LED filament 7W7150004.501.920.0732.24
LED ultra-efficient (energy class A) 4W4500008.001.090.02191.27
Smart Wi-Fi LED 9W92500012.002.460.04382.99

Notes: "Bulbs needed per year" is the share of a bulb's rated life used in a year (1,095 hours of use divided by rated life), so a value below 1 means one bulb lasts more than a year. Real bulbs are bought whole, so a long-life bulb costs its full price up front. Prices and the 25p/kWh rate are illustrative; replace them with your own tariff and local prices.

Rejected

test

Contributor G8TWo0xr · 2026-11-01

Contributor xIi_VH8g: Declining: this only adds an empty row (labelled 'test'), and inserting it would misalign the Smart Wi-Fi LED row with its B9/C9 formulas.

Report proposal
Proposed version
ABCDEFG
1Bulb typeWattsRated life (hours)Typical price (£)Energy cost per year (£)Bulbs needed per yearTotal cost per year (£)
2Traditional incandescent 60W6010001.0016.431.09517.52
3Halogen eco 42W4220001.5011.500.547512.32
4Compact fluorescent (CFL) 12W1280003.003.290.1368753.70
5LED standard A60 8.5W8.5150002.502.330.0732.51
6LED dimmable A60 9W9150004.002.460.0732.76
7LED filament 7W7150004.501.920.0732.24
8LED ultra-efficient (energy class A) 4W4500008.001.090.02191.27
9
10Smart Wi-Fi LED 9W92500012.000.00#DIV/0!0.00
11
12
13
14
15
16
17

Bulbs

Bulb typeWattsRated life (hours)Typical price (£)Energy cost per year (£)Bulbs needed per yearTotal cost per year (£)
Traditional incandescent 60W6010001.0016.431.09517.52
Halogen eco 42W4220001.5011.500.547512.32
Compact fluorescent (CFL) 12W1280003.003.290.1368753.70
LED standard A60 8.5W8.5150002.502.330.0732.51
LED dimmable A60 9W9150004.002.460.0732.76
LED filament 7W7150004.501.920.0732.24
LED ultra-efficient (energy class A) 4W4500008.001.090.02191.27
Smart Wi-Fi LED 9W92500012.000.00#DIV/0!0.00

Discussion 0

0/5,000

No discussion yet. Start it — no sign-up needed.