Lighting Energy Savings Calculator Excel

If your current light uses a ballast then click the last check box.

Lighting energy savings calculator excel. Commercial lighting energy savings calculator. Calculate the amount of lighting payback and savings that you ll have electrically by making a lighting upgrade. 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. Understanding and calculating the return on investment for lighting retrofit projects and lighting upgrades is critical to your success.

On having to change your light bulbs less often. We will divide by 1 000 to convert watts saved to kilowatts saved so the energy calculation is easier. In addition to saving you money led light bulbs also help you save the planet because they use less energy and are often recyclable. Calculate total annual 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. The calculator below will provide an estimated roi based on energy costs. Here is an excel template automagically set for you to calculate your own personal savings when retrofitting to led lamps from halogen lamps. The calculation of the savings all depends on the accuracy of the information that you put into it.

First click on the excel image below. It will also approximate payback time when you would break even on the investment in new lighting.