groar's lighting thread

[groar]

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.