It will also approximate payback time when you would break even on the investment in new lighting.
Lighting energy savings calculator excel.
Understanding and calculating the return on investment for lighting retrofit projects and lighting upgrades is critical to your success.
The calculation of the savings all depends on the accuracy of the information that you put into it.
Here is an excel template automagically set for you to calculate your own personal savings when retrofitting to led lamps from halogen lamps.
In addition to saving you money led light bulbs also help you save the planet because they use less energy and are often recyclable.
Commercial lighting energy savings calculator.
Calculate the amount of lighting payback and savings that you ll have electrically by making a lighting upgrade.
On having to change your light bulbs less often.
Then put in the quantity of lamps you are replacing the amount of the lamps wattage and then the amount of watts that you re changing the lamps to.
Total energy savings is figured out in total kilowatt hours or kwh the measurement your utility company uses to track your energy consumption.
The calculator below will provide an estimated roi based on energy costs.
First click on the excel image below.
Energy savings calculator a fast and easy way to calculate your energy savings.
Calculate total annual energy savings.
We will divide by 1 000 to convert watts saved to kilowatts saved so the energy calculation is easier.