3 ms·
I think spreadsheet usage can be done in good ways, but not when it is done in Excel, because Excel is a typical MS lock in product. Things that should be obvi
by zelphirkalt 7y ago
I think spreadsheet usage can be done in good ways, but not when it is done in Excel, because Excel is a typical MS lock in product.
Things that should be obvious to do when having something important in a spreadsheet:
* Use well labeled (row name, column name, cell above, below, left of it, whatever) cells for in-between results.
* Have some checking for mistakes formulas for cells to show you a warning when there seems to be some calculation or entry mistake - like assertions in normal programming.
* Use plain text formats and use version control. Do not run around with 10 copies of the file named after what the index of the copy is.
* Have explanations of the formulas and the reasoning behind them somewhere, maybe even best inside the spreadsheet.
* Make only use of macros in there is no other way. Macros simply break things, at least in Excel. Only a few days ago I witnessed a case, where someone simply could not run some macro, even after reinstalling Excel, using an MS cleaning tool for "completely" removing Excel and various other attempts. And it only happened on that person's machine. The macro is not as reliable as plain text formulas.
* Have your data elsewhere as well. Do not use a spreadsheet as your single database.
And those are only the few things that come to my mind, although I am not a daily spreadsheet user. More frequent users might have many more guidelines.
I also recommend people to take a look at Emacs Org mode spreadsheets in combination with various other Org mode functionality. Those can be quite neat.