Difference between revisions of "MIT The World of spreadsheets and simple graphing"

From Help Wiki
(The Bad)
(The World of Spreadsheets)
Line 38: Line 38:
 
*** ''x32 bit: Each document limited to 2GB''
 
*** ''x32 bit: Each document limited to 2GB''
 
*** ''x64 bit: Each document limited by system physical memory
 
*** ''x64 bit: Each document limited by system physical memory
 
+
* [https://products.office.com/en-ca/home Microsoft Excel Online in Office 365]
 +
** ''Multi-editor environment''
 +
** [https://support.office.com/en-us/article/Data-Model-specification-and-limits-19AA79F8-E6E8-45A8-9BE2-B58778FD68EF ''Size Limit:''] ''250 MB''
  
  
  
 
[[Category:2015-2016]]
 
[[Category:2015-2016]]

Revision as of 10:00, 12 October 2015

Spreadsheets

give a simple explanation


The Good, The Bad, and the Ugly

The Good

  • Spreadsheet's is a low entry point for an application framework, in the same way that WordPress is a website framework
    • You don't have to be a developer/programmer

The Bad

  • Spreadsheets are used to make applications
    • You don't have to be a developer/programmer
    • Complex spreadsheets suffer from errors; become difficult to troubleshoot

The Ugly


The World of Spreadsheets

  • Gnumeric most powerful spreadsheet program
    • Single editor environment
    • Size Limit: Max rows: 16,777,216; Max Columns: 16,384; Max Cells: 274,877,906,944
    • Project doesn't provide Windows binaries; lag for latest version to be ported to Windows or Macintosh
  • Libre Calc
    • Single editor environment
    • Size Limit: each sheet can have a maximum of 1,048,576 rows and a maximum of 1024 columns.
      • Each document has a size limit of 4 GB
  • Google Sheets
  • Microsoft Excel
    • Single editor environment
    • x32 bit vs. x64 bit
    • Size Limit: 1,048,576 rows by 16,384 columns
      • x32 bit: Each document limited to 2GB
      • x64 bit: Each document limited by system physical memory
  • Microsoft Excel Online in Office 365