I would like to have an interactive calculator on my website based on an excel grid.
There are only two rows in which to show, however many of the calculations refer to hidden rows/columns.
The calculations contain the following functions: SUM; IF; ROUNDDOWN
Row 5: A5 through K5 (the interactive cells that website visitors can manipulate) continuing P5 through U5 (display only)
I would like the formatting along this row to remain the same
I would like the input values to be set to 0 as default, except cell B5 which is to be left blank
Row 6: A6 through K6, continuing P6 through U6 (all display only)
Rows 1 & 2 can also be included but are not critical as these can be designed externally
I would like to be able to manipulate the grid in the future, should prices change for example.
I would like a SUBMIT button that sends the results of a calculation. I would like this form to also contain fields for the "Name" and "E-mail" of the submitter, plus a check-box of service they are interested in: "White Service", "Blue Service", "Gold Service", "Platinum Service")