The calculation of the savings all depends on the accuracy of the information that you put into it.
Lighting energy savings calculator excel.
We will divide by 1 000 to convert watts saved to kilowatts saved so the energy calculation is easier.
The calculator below will provide an estimated roi based on energy costs.
In addition to saving you money led light bulbs also help you save the planet because they use less energy and are often recyclable.
Read more about the benefits of swapping out your light bulbs for led ones in our article why now is the time to switch to led light bulbs.
If your current light uses a ballast then click the last check box.
On having to change your light bulbs less often.
Calculate the amount of lighting payback and savings that you ll have electrically by making a lighting upgrade.
Calculate total annual energy savings.
Here is an excel template automagically set for you to calculate your own personal savings when retrofitting to led lamps from halogen lamps.
Energy savings calculator a fast and easy way to calculate your energy savings.
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.
First click on the excel image below.
Total energy savings is figured out in total kilowatt hours or kwh the measurement your utility company uses to track your energy consumption.
Understanding and calculating the return on investment for lighting retrofit projects and lighting upgrades is critical to your success.