The Configurator – A Gear Ratio Calculator for Website
I would like my website (which is hosted via a Linux server) to offer visitors access to a gear ratio calculator, similar to one found at [url removed, login to view], but more attractive/modern.
I have several Excel spreadsheets containing relevant data and mathematical formulas.
The "ratio selector" spreadsheet I have, for example, indicates that the gear calculator should offer radio buttons for ratio inputs -- there are only so many options a user can input and some are standard for particular vehicles.
The other 2 spreadsheets I have (for 5 speed transmission and 6 speed transmission) reflect options and standard outputs/features for the particular vehicles identified -- ex. GT40, Pantera, etc. The options (on right side of sheet) reflect standard options for those vehicles.
The following is the sequence of steps a consumer would theoretically follow in order to utilize the configurator:
A consumer would visit my website, register (or not) as a member in order to have access to gear ratio calculator. Consumer launches the "Configurator" and will then need to...
1. Select 5 speed or 6 speed transmission (would like this calculator to eventually offer 4 speed option also, but don't have numbers for that yet)
2. If 5 speed is selected, then the choices on the 5 speed spreadsheet apply -- items listed under GT40, Pantera, M1 are standard, but other options exist and other vehicles could apply (Quaife site's calculator lists other vehicles, we could offer "other").
3. Next item should force consumer to input their "Tire diameter" (ratio selector sheet)
4. Then the "shift rpm" is input by consumer.
5. Next, the consumer can select, via radio buttons, gear ratios (ie. 1st gear, 2nd gear, etc.)
-- the gear ratio options are listed on the 5 speed and 6 speed spreadsheets: see "1st gear" listing where 4 options are offered (on left side of sheet) for 1st gear, 9 options for 5th gear, etc. Right side of sheet lists 'standards' for GT40, Pantera, M1. On 6 speed sheet, similar, but right side of sheet reflects standard options for Saleen and Shelby vehicles.
6. The consumer should then select "Final Drive" (or R&P), which could be renamed "Ring & Pinion" and, via radio buttons, offer ALL of the options posted on 5 speed sheet as "R&P" and include the numbers posted as "future" -- 11 options. For the 6 speed sheet the options offered via radio buttons should be pulled from the 6 speed sheet's "CWP" row and the row below that -- 11 options total.
7. The outputs generated as a result of the aforementioned selections should be displayed and also reflected in a graph (as seen on ratio selector spreadsheet. MPH and RPM (bottom of 6 speed sheet) outputs are convenient 'at a glance' for consumer.
8. Consumer can print, save, reset, or "submit quote request."
9. If consumer submits a quote request then I will have another form launch which will require them to select axle location, bellhousing info, side covers, etc. -- the other items on 5 speed and 6 speed spreadsheets not used for calculator.
I will attempt to attach all relevant files to this project request.
8 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Dear Customer! Please provide details in PMB (calculation formulas, etc.) to let me estimate exact price and timeframe for development of this AJAX calculator. Best Regards, Zeke