Hi,
I need to create an energy cost calculator for a client site. The user inputs the hours/day he uses a lamp, the days/wk the lamp is used and the cost per kilowatt hour of the lamp.
I've made those three drop down menus. However, to calculate the annual cost, there is no formula, just a number of values that I've been given. For example, if the user inputs 4 hours/day, 5 days/wk and $.06/kwh, then the calculation should equal 0.06. It just takes the value of the previous 3 and gives a number.
I'm thinking that I should set up an array with all the values and then call the array in the annual cost field.
Is that the correct way to do it or is there an easier way?
Thanks
I need to create an energy cost calculator for a client site. The user inputs the hours/day he uses a lamp, the days/wk the lamp is used and the cost per kilowatt hour of the lamp.
I've made those three drop down menus. However, to calculate the annual cost, there is no formula, just a number of values that I've been given. For example, if the user inputs 4 hours/day, 5 days/wk and $.06/kwh, then the calculation should equal 0.06. It just takes the value of the previous 3 and gives a number.
I'm thinking that I should set up an array with all the values and then call the array in the annual cost field.
Is that the correct way to do it or is there an easier way?
Thanks