Find Jobs
Hire Freelancers

HTML form with JavaScript calculation (as seen in Excel fil)

$50-90 USD

Cancelled
Posted almost 13 years ago

$50-90 USD

Paid on delivery
THE JOB: ======== Bevare! The description is long and detailed - but that is just to avoid misunderstanding! :-) The actual task is pretty basic if you know Javascript and basic Excel/math. 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: [login to view URL] I would like you to make this as a complete contact form in HTML and JavaScript where the calculations are carried out online. It needs to be fully functional and error proof! 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. So the right way of solving this is using the same intermediate calculations as I use in the Excel - in that way I will understand what is going on in the javascript code too! :-) YOU: ===== 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. THE DETAILS: ============ Take a look at how the "dumb" form is looking now: [login to view URL] (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!
Project ID: 1100021

About the project

3 proposals
Remote project
Active 13 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
3 freelancers are bidding on average $93 USD for this job
User Avatar
I can do my best
$90 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Details in the PM.
$100 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
you have pmb. thanks
$90 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of DENMARK
Saeby, Denmark
5.0
1
Payment method verified
Member since Jun 16, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.