Currently Being ModeratedMay 10, 2013 7:58 PM (in response to MyndSurfers)
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"
Currently Being ModeratedAug 8, 2013 9:40 AM (in response to 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.
Currently Being ModeratedAug 8, 2013 12:27 PM (in response to mlapchick)
Currently Being ModeratedAug 10, 2013 6:59 PM (in response to mlapchick)
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