4 Replies Latest reply: Aug 10, 2013 6:59 PM by MyndSurfers
MyndSurfers Level 1 (0 points)

How do I convert a Numbers spreadsheet into a live, calculating websheet?

 

A software addon for Excel achieves what I want to do: Spreadsheet Converter. However, the cost of implementing the solution on my Mac/in my house/at my office will be about $US 700 - $1500 (See considered options below).

 

However, Spreadsheetconverter requires:

  • Excel
  • On a PC.

 

Furthermore, there are standard and (more expensive) Pro versions, and the latter is what I will require due to my need for graphics and engineering/statistical functions.

 

The Spreadsheetconverter appears an excellent product. I have had one NeoOffice-generated spreadsheet I created kindly converted by the developers as a sample trial, and I was very pleased with the result. However, the developers have stated they have no plans to adapt Spreadsheet Converter for use on the Mac version of Excel. I think the product works by using addons or extensions to the core Excel product. These addons don't function in a Mac Excel context.

I am considering several options:

  1. Install a Windows emulator on my Mac, such as Parallels, VMWare, or hopefully just Crossover. Buy Windows Excel. Buy Spreadsheetconverter. Cost:  $US 500 - $700.
  2. By a second-hand PC, Buy a Windows  version of Excel, Buy Spreadsheetconverter. $US 500 for software + PC  cost. Cost: $US 700 - $1500.

 

Since these  two options are expensive, irritating, and might not work, my preferred solution is: an App that converts a Numbers spreadsheet into an interactive webpage. Is there anyone working on such a project? I'd be happy to Beta test.

 

About SpreadsheetConverter

 

Convert Excel into live and calculating web pages - SpreadsheetConverter. (n.d.). Retrieved March 17, 2013, from http://www.spreadsheetconverter.com/

 

Body Mass Index Calculator - Example. (n.d.). Retrieved March 17, 2013, from  http://www.spreadsheetconverter.com/calculate/html/health/BMI_body_mass_index_ca lculator/BMI_body_mass_index_calculator.htm

 

 

 


Numbers, OS X Mountain Lion (10.8.3)
  • Wayne Contello Level 6 (17,571 points)

    It's neat.  I am not aware of any efforts to make a Numbers to web page translator.  You can make suggestions to Apple by selecting the menu item "Number > Provide Numbers Feedback"

  • mlapchick Level 1 (5 points)

    MyndSurfers,

     

    Did you ever find a solution for this? It kills me to create detailed spreadsheets in Numbers only to have to pay my developers to do it all over again.

     

    I'd pay dearly for such a solution.

     

    Thanks,

     

     

    Mike

  • Wayne Contello Level 6 (17,571 points)
  • MyndSurfers Level 1 (0 points)

    No solution yet. However, I have 'discovered' Google Sheets. So far, I am so impressed with Google Sheets that I am now teaching my Operations Management students spreadsheeting through Google Sheets.

     

    I am increeasingly wary of Numbers. I acces my Numbers files from two iMacs, and my iPad. However, they don't always styay in sync. Furthermore, I now have one Numbers sheet that cannot be opened. It opens partly, then when I begin to use it, it crashes. So I've become very, very wary about committing mission critical data to Numbers, such as students gradebooks and attendance records! A pity - worked brilliantly last semester

     

    I haven't fully figured out the share and protect features of Google sheets. These are cruical to implementing what I/you need to do. However, the features I find valuable are:

     

    • Data validation
    • Conditional formatting.
    • The ability to publish a sheet to a web page in read-only format ... and the web-version updtes as the creator of the original spreadsheet makes changes.

     

    I suspect there is/will be a solution to my issues with Google sheets. At the moment, I make my Google sheet version read only, and guide my students to download or copy their own version to their own spreadsheet platform.

     

    Perhaps Apple Numbers will match and raise Google Sheets!

     

    Here's an example ... created initially from a NeoOffice version uploaded but since forked...:

     

    Mellalieu, P. J. (2013a). A Decision Support System for Decision Modeling under Conditions of Uncertainty and Risk [Google Sheets Fork]. Retrieved from https://docs.google.com/spreadsheet/ccc?key=0AjwyjX8GotyadDgxa0VxekEwUXV0TUw4TVd fa2UtSGc&usp=sharing

     

    Here is the web (and embeddable) version of the Google Sheet.

    Mellalieu, P. J. (2013c, August 1). A Decision Support System for Decision Modeling under Conditions of Uncertainty and Risk [Google Sheets Fork Web Display]. Retrieved July 31, 2013, from https://docs.google.com/spreadsheet/pub?hl=en&key=0AjwyjX8GotyadDgxa0VxekEwUXV0T Uw4TVdfa2UtSGc&hl=en&gid=0

     

    You might find this helpful, too ... your feedback welcome.

     

    Mellalieu, P. J. (2013d, August 2). Guidance on best practice for spreadsheet design. Innovation & chaos ... in search of optimality. Retrieved August 1, 2013, from http://pogus.tumblr.com/post/57098889972/guidance-on-best-practice-for-spreadshe et-design

     

    Mellalieu, P. J. (2013b). Spreadsheet documentation template. Retrieved from https://docs.google.com/spreadsheet/ccc?key=0AjwyjX8GotyadFNEdGRqckdBeG15cE5Id1E tQ05wcUE&usp=sharing