I need six webpages designed to be added to an existing website. They should be set-up in the base format already existing on the website and in a way that they can be seamlessly added into the site links bars.
The purpose of these pages will be to add free “Financial Calculators” that will calculate property values based on the the user’s inputs.
The users will need to have a unique username (preferably email address) and password and be logged in to utilize the financial tools. All user data will need to be stored in a MySQL database. There is no need to store the user inputs from the financaial calculators.
Following is the basic page structure envisioned for this section of the site.
Page 1 – Terms and Conditions of Use
I will add the text for this page later, but it must have an acceptance box in order to move forward.
Page 2 – Login and User Registration Input Page in which previously registered users simply log in. Those not registered must signs-up for a username and password. All data should be stored in a MySql DB. I do not feel the need to approve users.
The DB should store required information and be useable by me for future mailings. The required data is as follows:
Email (Key - Username) (Required)
First Name (Required)
Last Name (Required)
Title (not required)
Company (not required)
Address 1 (Required)
Address 2 (not required)
Profession/Use: (Drop Down Menu) Buyer, Seller, Investor, Realtor, Lending Institution, Mortgage Broker, Appraiser, Review Appraiser, CPA, Attorney, Other
If Profession/Use = Other Above, Please Describe: (Required if other is selected above)
I would also like the IP address of the visitor logged and saved to the DB at the time of registration
Page 3 – An HTML page that links to each of three pages with the Financial Calculators on them. I would like this page to be search engine friendly and fully indexable so I can optimize keyword text.
Pages 4-6 – Preferably built as HTML pages that I can edit. These pages need to have calculating cells that utilize the math in the three spreadsheets in the uploaded XL file, with one of the three pages for each spreadsheet. The spreadsheets are very similar to each other, so once one is done, the others should be easy.
I would also like these pages to be search engine friendly and fully indexable so I can optimize with keyword text.
But they must also require that the user be logged-in in order to be able to utilize the math functions.
I have shaded the user inputs in Red. The remaining cells are calculated from the user inputs and the results of other calculations.
Thank you for your attention to this project!