Light bulb running costs per year (UK, 3 hours a day at 25p/kWh)
Change Requests
Suggest a changeAccepted
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 proposalProposed version
Bulbs
| Bulb type | Watts | Rated life (hours) | Typical price (£) | Energy cost per year (£) | Bulbs needed per year | Total cost per year (£) |
|---|---|---|---|---|---|---|
| Traditional incandescent 60W | 60 | 1000 | 1.00 | 16.43 | 1.095 | 17.52 |
| Halogen eco 42W | 42 | 2000 | 1.50 | 11.50 | 0.5475 | 12.32 |
| Compact fluorescent (CFL) 12W | 12 | 8000 | 3.00 | 3.29 | 0.136875 | 3.70 |
| LED standard A60 8.5W | 8.5 | 15000 | 2.50 | 2.33 | 0.073 | 2.51 |
| LED dimmable A60 9W | 9 | 15000 | 4.00 | 2.46 | 0.073 | 2.76 |
| LED filament 7W | 7 | 15000 | 4.50 | 1.92 | 0.073 | 2.24 |
| LED ultra-efficient (energy class A) 4W | 4 | 50000 | 8.00 | 1.09 | 0.0219 | 1.27 |
| Smart Wi-Fi LED 9W | 9 | 25000 | 12.00 | 2.46 | 0.0438 | 2.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 proposalProposed version
| Bulb type | Watts | Rated life (hours) | Typical price (£) | Energy cost per year (£) | Bulbs needed per year | Total cost per year (£) | |
| Traditional incandescent 60W | 60 | 1000 | 1.00 | 16.43 | 1.095 | 17.52 | |
| Halogen eco 42W | 42 | 2000 | 1.50 | 11.50 | 0.5475 | 12.32 | |
| Compact fluorescent (CFL) 12W | 12 | 8000 | 3.00 | 3.29 | 0.136875 | 3.70 | |
| LED standard A60 8.5W | 8.5 | 15000 | 2.50 | 2.33 | 0.073 | 2.51 | |
| LED dimmable A60 9W | 9 | 15000 | 4.00 | 2.46 | 0.073 | 2.76 | |
| LED filament 7W | 7 | 15000 | 4.50 | 1.92 | 0.073 | 2.24 | |
| LED ultra-efficient (energy class A) 4W | 4 | 50000 | 8.00 | 1.09 | 0.0219 | 1.27 | |
| Smart Wi-Fi LED 9W | 9 | 25000 | 12.00 | 0.00 | #DIV/0! | 0.00 | |
Bulbs
| Bulb type | Watts | Rated life (hours) | Typical price (£) | Energy cost per year (£) | Bulbs needed per year | Total cost per year (£) |
|---|---|---|---|---|---|---|
| Traditional incandescent 60W | 60 | 1000 | 1.00 | 16.43 | 1.095 | 17.52 |
| Halogen eco 42W | 42 | 2000 | 1.50 | 11.50 | 0.5475 | 12.32 |
| Compact fluorescent (CFL) 12W | 12 | 8000 | 3.00 | 3.29 | 0.136875 | 3.70 |
| LED standard A60 8.5W | 8.5 | 15000 | 2.50 | 2.33 | 0.073 | 2.51 |
| LED dimmable A60 9W | 9 | 15000 | 4.00 | 2.46 | 0.073 | 2.76 |
| LED filament 7W | 7 | 15000 | 4.50 | 1.92 | 0.073 | 2.24 |
| LED ultra-efficient (energy class A) 4W | 4 | 50000 | 8.00 | 1.09 | 0.0219 | 1.27 |
| Smart Wi-Fi LED 9W | 9 | 25000 | 12.00 | 0.00 | #DIV/0! | 0.00 |
Discussion 0
No discussion yet. Start it — no sign-up needed.