I have attached a spreadsheet (OpenOffice format) that provides all the formulas and calculations that need to be done. They are on the "Calculator" tab.
I basically just want to just turn this from a spreadsheet into a calculator viewable in the browser.
The only difference is that the values given in the "Spot" tab of the attached spreadsheet should be values that can be entered by the user on the calculator screen. Also, the label "Base Adjustment" and the value of the base adjustment will not be visible on the page like it is on the spreadsheet.
The "Reset" button on the Calculator tab, simply empties all values in the "DWT" column, then resets all the "adjustment" percentages back to those found on the "default adjustments" tabs of the spreadsheet.
The PHP/mySQL work is needed to do two things:
1) create a simple single-user password protected login screen required to access the calculator
2) create a backend area that allows an administrator (also just one login) to edit and change the "base adjustment" field as well as change the default adjustment levels
This is just the first version of the program. I am looking for someone who can continue to work on it after this first phase, adding more features and expanding the program.