Wednesday, January 8, 2014

Addiction to Spreadsheets

"Addiction is the persistent use of a substance where that use is detrimental to the user."

This article I am reading on http://www.burns-stat.com/documents/tutorials/spreadsheet-addiction/ is about addictions to spreadsheets.

The hard way looks easy, the easy way looks hard.

Some financial companies have spreadsheet computations that take a very long time (even all night).  If these computations were replaced using code, this time could be cut drastically, maybe even to a few minutes.

Strength of spreadsheets? A cell can be both a formula and a value.Some cells have hidden meaning - you don't know if it is a pure number of a number that is derived due to a formula in the cell.

This article talks about the strengths of switching from Excel to R.

Excel is a spreadsheet.  R is a programming language.  

No comments:

Post a Comment