We've created a commission calculator to help our resellers work out what commissions they will receive on a deal.
We built it in Excel 2010 but want to move it to a web based platform that will allow us better version control (as the prices in the background change regularly).
Plus not all of our resellers have MS Excel 2010 which is require in order for them to see some of the elements of our calculator.
So I wanted to understand if this would be possible using Google Docs? Below are the main elements that we have currently:
- Conditional formatting that dynamically removes options from one drop down box, based on user selection from a subsequent drop down box.
- The other features are simple calculations based on what figures are entered into each box and requires a number of sheets to hold these base figures.
- We also need to be able to allow them to make a selection from a range of options.