groar's lighting thread

groar · 09-20-08, 04:19 PM

Since years, we are replacing bulbs by CFL. A few months ago we tried a few LED. I was then curious to know how much we were saving by year.

I developed a little spread sheet, accessible here :
http://www.groar.org/EcoRenovator/lighting/

Warning, I developed it under OpenOffice and the xls format is from an export, so I don't know if it works.

To use it :

In F1 enter cost of 1 kWh
For each location (row from 5 to 19), enter :
- number of bulbs (column B)
- number of Watts of each bulb (column C)
- number of Watt of equivalent standard bulb (column D)
- number of Watt of previous bulb if any (column E - optional)
- number of hours the bulb is light on by day (column F)

Results :

For each location :
- Total cost by year (column G)
- Total saving by year (column H)
Total cost by year (G21)
Total saving by year (H21)
Percentage of saving (H22)

Sorry, as I don't have cost of CFL of LED, I can't calculate time of return on investment and didn't developed this feature.

You may conclude that lighting saving isn't worth the investment, but remember that if everybody implement that then this is a lot of saving and delayed new power plant constructions, giving more chance to renewable plants.

In a few days I should add some pictures in this thread.

Have fun,

Denis.

09-20-08, 04:19 PM	#1
groar X-Frenchy: very Join Date: Sep 2008 Location: Toulouse, France Posts: 153 Thanks: 0 Thanked 2 Times in 2 Posts	groar's lighting thread Since years, we are replacing bulbs by CFL. A few months ago we tried a few LED. I was then curious to know how much we were saving by year. I developed a little spread sheet, accessible here : http://www.groar.org/EcoRenovator/lighting/ Warning, I developed it under OpenOffice and the xls format is from an export, so I don't know if it works. To use it : In F1 enter cost of 1 kWh For each location (row from 5 to 19), enter : number of bulbs (column B) number of Watts of each bulb (column C) number of Watt of equivalent standard bulb (column D) number of Watt of previous bulb if any (column E - optional) number of hours the bulb is light on by day (column F) Results : For each location : Total cost by year (column G) Total saving by year (column H) Total cost by year (G21) Total saving by year (H21) Percentage of saving (H22) Sorry, as I don't have cost of CFL of LED, I can't calculate time of return on investment and didn't developed this feature. You may conclude that lighting saving isn't worth the investment, but remember that if everybody implement that then this is a lot of saving and delayed new power plant constructions, giving more chance to renewable plants. In a few days I should add some pictures in this thread. Have fun, Denis. __________________ Earth absorbs 1.8 t CO2/head/yr, while a French generates 6.2 t CO2/yr To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. kg saved 06/08-08/09: 1816.9+382.9 (ecodriving / 1420mi not driven) = 2199.8 To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. (2.66 kg/l diesel) kg saved by 3kWc photo-voltaic solar panels : 187 kg/yr To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. (59.1 g/kWh) Radioactive wastes saved by 3kWc photo-voltaic solar panels : Long life (>100,000 years) : 2.85 g/yr (0.9 mg/kWh) Short life (<300 years) : 31.7 g/yr (10.0 mg/kWh) Based upon "official" French figures... Last edited by groar; 09-20-08 at 04:22 PM..