Spreadsheet: 36568d1234449921-how-to-do-two-logical-tests-for-a-conditional-statement-roi-with-energy-calculator
Sheet: Mt. Morris Rm. 1

 | ECOlighting Solutions |  | Telephone: [PHONE]
 | 2000 Commerce Pkwy |  | Fax: [PHONE]
 | Lancaster, NY 14086 |  | E-Mail: [EMAIL]
Base information
Customer | [NAME]
Project Name | Mt. Morris Rm. 1 |  |  | [NAME]. | 021009A
Address |  |  |  | Type of Old Technology | 100 W Halogen
Contact | [NAME] |  | ` | Type of LED | LED Retro
Phone |  |  |  | Voltage | 115
Technical Information | 100 W Halogen | LED Retro
Old Technology / LED, lifetime in hours | 5000 | 120000 |  | Qty Lights / Daily usage | 42 | 17
Old Technology/ LED, lifetime in years | 0.8058017727639001 | 19.3392425463336 |  | Usage in / day's per month / day's per year | 30 | 360
Install. costs for the first installation | 100 W Halogen | LED Retro |  |  | 100 W Halogen | LED Retro
Costs each (Entire Fixture) | 250 | 625
Install Costs (Per Fixture) | 20 | 20
 |  |  | Cost for the Lights |  | 26250
Lifetime Maintenance Cost (After Installation) | 100 W Halogen | LED Retro
Lifetime changes | 23 |  |  |  | 100 W Halogen | LED Retro
Bulb Cost | 15 | 0 | Bulb Savings (Lifetime) |  | 0 | 14490
Labor Rate | 16 | 0 | [NAME] (Lifetime) |  | 0 | 15456
Service cost including; Labor, and bulb | 31 | 0 | Bulb and [NAME] (lifetime) |  | 0 | 29946
Power consumption costs | 100 W Halogen | LED Retro |  |  | 100 W Halogen | LED Retro
Bulb consumption (wattage) | 225 | 75 | Total power consumption in watts per day |  | 160650 | 53550
Ballast consumption (wattage) | 0 | 0 | Power cost per day |  | 19.278 | 6.426
Consumption total (wattage) | 225 | 75 | Power cost per month |  | 578.3399999999999 | 192.78
Cost's per kWh | 0.12 | 0.12 | Power cost per year |  | 6940.08 | 2313.36
Project [NAME] (sq. ft.) |  |  |  | Annual Power Savings | 4626.719999999999
 |  |  |  | Lifetime Power Savings | 89477.26027397258
Results
 |  |  |  | Results
 |  |  |  | Bulb Cost (Lifetime) |  | 14490
 |  |  |  | Lifetime Power Savings |  | 89477.26027397258
 |  |  |  | Combined Lifetime savings (bulb and power) |  | 103967.2602739726
 |  |  |  | Combined Annual savings (bulb and power) |  | 5256.719999999999
 |  |  |  | Break even after (Years) |  | 4.993608181527645
 |  |  |  | Potential Federal Incentives |  | 0
 |  |  |  | Potential NYSERDA Incentives |  | 4626.72
 |  |  |  | Break Even After Incentives (Years) |  | 2.65595784463709
Energy Calculations
 |  |  |  |  | Old Technology | New Technology
 |  |  |  | Total Annual Coal Consumption (lbs.) | 47019.51219512195 | 15673.17073170732
* In this scenario we plan on getting rid of the mounted |  |  |  | Total Annual CO2 emissions (lbs.) | 130068.666 | 43356.222
par 38 fixtures and re-engineering the hanging high bay |  |  |  | Total Annual SO2 emissions (lbs) | 751.842 | 250.614
fixtures.  For the purposes of this comparison each hang- |  |  |  | Total Acres of Trees needed to fix this much CO2 (acres) | 17.73744252011455 | 5.912480840038183
ing high bay is going to absorb the power used by each |  |  |  | Total annual energy consumption in kWh (lbs.) | 57834 | 19278
mounted fixture to use a total of 225 watts.
 |  |  |  | *Figures based on electricity coming from coal burning