Breakeven Analysis Calculator
| Category: Appropriate Technology | 0 Comments
In response to an energy conservation challenge initiatied by BC Hydro, our home has set a goal to use 15% less power this year. Using less electricity is going to be a challenge as we have already done all the easy things like change our lightbulbs to CFLs and fanatically turning off lights when not in use. The best candidate for upgrade are 3 fixtures from IKEA that use 4 20W Halogen bulbs each that are often on.
I think I found some bulbs that are compatible with my fixtures from LED Liquidators. I’m still waiting a response from them. I found a useful tidbit of information comparing the approximate lumens from LED bulbs to traditional halogen bulbs:
| 12 White LEDs | = | 7 W |
| 24 White LEDs | = | 14 W |
I wanted to figure out how long it would take to breakeven on upgrading all 12 lightbulbs to LEDs. Plus I thought it would be good to calculate what sort of energy savings I could expect from the purchase. To solve the problem, I created a little Excel speadsheet to crunch the numbers. Please download and test away. The BOLD values are editable. If anyone finds any flaws in my logic please leave a comment and I will update the spreadsheet.















