News for hackers. Stuff that matters.
Re:The Excel Depression by Toenex on Friday April 19, 2013 @05:08AM (#5575626)
beyond, perhaps, the difficulty of reviewing Excel code

This has always been one of my concerns when Excel is used much beyond 'electronic squared paper'. The interwoven data and code nature of the tool makes testing and verification more difficult - certainly not impossible but going against the grain of the tool. Excel is used by a diverse range of people, many of whom have limited software skills and could do with a tool that enforced the right behaviour.

Also I think this shows the need for openness when people make such important claims based on data. Particularly in this case where all the data and calculations could easily be zipped up and put on a website.

Re:The Excel Depression by james1071 on Saturday April 20, 2013 @05:06AM (#5580843)
Agree-the fundamental problem is that formulae are copied from cell to cell.

It is so easy to make a mistake on a big spreadsheet.

A much better approach would be to write user defined functions.