I have an Excel file which is used to calculate a price quote (on new roofing for houses). The Excel file contains all formulas for doing this calculation. It's pretty basic math but uses several cells.
I would like you to "convert" this Excel file to an online HTML form where the clients can get a price quote right away AND send their contact information along with it to me as well as to themself.
(Also there must be normal fields for contact info.)
It should look a lot like this: [url removed, login to view]
After clicking "Calculate/send" the email with informations should be sent to me as well as the client. The price should be revealed on this confirmation page as well - so the client is not able to see any prices before sending.
We need to show some texts in the confirmation page based on which choices the client have made in the contact form!
We need some checks/tests to make sure the clients fill in the right info. Using some free jQuery script for this is just fine!
I need you to make extensive use of comments in the code since I might change the prices/factors later on and need to be able to edit these myself at that point.
You need to deliver on time - no excuses, no delays. :-)
I would like you to show me a couple of examples of your previous work that proves that you can handle this task.
VERY IMPORTANT: You need to be able to figure out by yourself how the calculations are made by looking at the Excel data! The cells should tell you how it's done, so it should be possible to read this directly from the file. It's not complicated, there are just several fields used in the calculation.
Take a look at how the "dumb" form is looking now:
[url removed, login to view]
(This is only a mail form, no calculations are done.)
The different choices in that dropdown is going to affect the final price.
So we need a form looking somewhat like the above but "intelligent" = doing the actual math.
Take a look at the attached file which shows how the math is done. As you can see the Excel file corrosponds ALMOST 1:1 with the contact form above (there are some minor changes - the Excel file shows the final fields).
This is the explanation of what the Excel file contains:
Coloumn B: The actual questions we need answered. Most of them are resulting in drop down menus.
Coloumn C: The choices. This is the options that are selectable in the above contact form and also should be in the contact form you are making.
Coloumn D: This is where the client is typing his answer in the Excel file. 1 means YES. 2 means NO. Only one of the fields is for inputting numbers: Question 5 (it's how many squarefeet) and should contain a number (integer)
Coloumn E-K: is for the (intermediate) calculations. This is where you need to pay extra attention since this is where you can see how the math is done = how the price quote is calculated. (This should NOT be shown to the client on the HTML form, this is just for doing the calculation.)
Coloumn L: This is the texts that needs to be shown on the confirmation page and email IF the corrosponding option have been choosen in the dropdown! (Example: If the option which corresponds to D9 have been chosen (1) the text from L9 needs to be shown on the confirmation page as well as the emails the client recieves (this is the same data/info).)
L 97: This is where the final, total price is calculated!