Lighting Calculator.

If you are simply looking to calculate estimated savings, you don't need to fill out the top table. Although, if you don't fill out the top table, you won't be shown the payback time because that calculation is related to the total cost of the materials and labor needed to upgrade the lighting system.

The "Hourly Labor Cost" and "Profit Percentage" fields are used for the calculations in the top table. The "Cost of 1 KiloWatt Hour" field is used for the bottom 2 tables. The calculations are all done with JavaScript, so there is no need to refresh or "submit" form data manually to see updated calculations for any changes you have made. Simply add, delete or edit the data you have entered and then select any of the 3 "Calculate" buttons. In order to change the names of any of the 3 tables, edit the text in the "Title" field and then select the "Update" button at the top of the page.

If you want to add more rows to a table, simply select the number of rows you want in the table from the drop-down menu located directly above the table you want to add rows to. In order to delete a row of data, remove all characters (spaces too) from the "Item Description" column of the row you want to delete, and then press the "Update" button at the top of the page.

In the top "Pricing Table", for each item, enter a description of the item, the quantity, how much each items costs YOU, the amount of any rebate available and how much time you estimate it will take to install the item. The "Install Time" is entered in fractions of an hour, so a half an hour would be entered as ".5", 15 minutes would be ".25", 10 minutes would be ".17", etc. After you have entered all the data, or at anytime while entering data, you can select any of the 3 "Calculate" buttons, and the calculations will be performed and the results displayed.

The other 2 tables, "Existing Lighting Schedule" and "Proposed Lighting Schedule" are used to calculate the difference between the system that exists now and the system as it will be when all the items are upgraded. In each table, enter the information for each type of item used for lighting. If you have 30 4 foot 2 lamp fixtures that have 2 34 watt lamps in them and they are on 24 hours a day, you would enter that information in one row. If you have another 20 4 foot 2 lamp fixtures that have 2 34 watt lamps in them that are on 8 hours a day, enter that information in another row. Do this for all equipment that is going to be changed. Select any of the 3 "Calculate" buttons to calculate the results of the data you have entered.

You can change the number of rows at any time without losing data. If you select fewer rows than the number of rows that already exist, the program will remove only rows that are empty.

After you have all the information added and all the calculations are displayed, you can print a copy of the page. Simply select one of the two "Print Preview" options from the top of the page. The "Full print preview" will show ALL columns of data, including "Profit..." data and "Per Item Cost" data. If you are a contractor and will be adding "Profit Percentage" to the materials, you may want to use the "Customer print preview" option. The "Customer print preview" option will exclude the "Per Item Cost" column and all columns having to do with "Profit..." After making a print preview selection, you will see your data on a table, from that page you can print the information. You will probably want to print the data in "Landscape" mode, this will make the data easier to read. Also, make sure the "Shrink to fit" option is selected in the print dialog box.

I hope you find this calculator useful.

Peace.