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

Revision as of 09:39, 12 October 2015

give a simple explanation

Spreadsheet's is a low entry point for an application framework, in the same way that WordPress is a website framework

Spreadsheets are used to make applications
- Complex spreadsheets suffer from errors; become difficult to troubleshoot

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
- Multi-editor environment
- Size Limit Up to 2 million cells
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

@@ Line 1: / Line 1: @@
 == Spreadsheets ==
+''give a simple explanation''
 * [https://en.wikipedia.org/wiki/Spreadsheet As explained by Wikipedia]
+* Best application for data gathering/collection
+=== 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
+====The Bad ====
+* Spreadsheets are used to make applications
+** Complex spreadsheets suffer from errors; become difficult to troubleshoot
+==== The Ugly ====
+* [http://www.jstatsoft.org/article/view/v034i04 '''On the Numerical Accuracy of Spreadsheets''']
-''simple explanation''
-''what are they good for''
 === The World of Spreadsheets ===