Our company needs an online calculator that calculates and displays an entire spreadsheet worth of information based on entering 1. A Total Sales Price. 2. 3 different interest rates.
Details: We already have a fully calculated excel spreadsheet that we'd like to somehow implement on our site as a visual, but we want it to look like it's part of our site and not an excel spreadsheet.
There are four variables that we want user's to be able to enter. 1. Total Sales Price of A House They're interested in. 2. Interest Rate 1 3. Interest Rate 2 4. Interest Rate 3.
Once user's have entered the first variable, the next three variables will come from drop down menus (pre-selected variables). All four variables must be entered in order to proceed or else a warning message will tell user's they can't proceed...
When they've entered all four variables this will take them to the next screen where the results of their criteria will be displayed in a spreadsheet format.
This spreadsheet will have about 14 columns and about 30 rows, including a Main Heading, a description that's concatenated that will include the variables they entered, plus a print option, as well as an "email to a friend" option.
The attached spreadsheet is what we'd like to base this web spreadsheet/display on. The finished web spreadsheet will use the calculations in the attached spreadsheet but will have a look that's consistent with the website.