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