Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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:

  1. Conditional formatting that dynamically removes options from one drop down box, based on user selection from a subsequent drop down box.
  2. 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.
  3. We also need to be able to allow them to make a selection from a range of options.
share|improve this question
1  
Have you tried creating a google account, uploading it to google-drive to see the conversion result first? Ad 1) dropboxes: that's a no-can-do Ad 2) excel == google-spreadsheets Ad 3) doable –  Jacob Jan Tuinstra Jan 24 '13 at 11:30
    
Yes I have tried importing it but it does not support the .xlsm file type. –  bbacarat Jan 24 '13 at 11:53
    
Have you tried converting it, in Excel, to a xlsx file? –  Jacob Jan Tuinstra Jan 24 '13 at 11:55
    
Yeah, get the error message: "The following features cannot be saved in macro-free workbooks: VB project" –  bbacarat Jan 24 '13 at 11:58
    
The xlsm format is macro enabled xls file. That's not converted in google-drive. –  Jacob Jan Tuinstra Jan 24 '13 at 11:59

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.