Comment Re:What he's really saying is (Score 1) 422
Spreadsheets are definitely valuable in analysis and design phases. That can sometimes be very complex work, especially before all the constraints and contingencies of the project are identified. But as a general rule, even simple spreadsheets have no place in production work.
A spreadsheet is a great way to test the usefulness of different ways of handling complex data. They are also relatively easy to modify as a project's specifications evolve. Which they always do.
However an important part of implementing a project-- moving it from design into production-- is building software that is more robust than spreadsheets can be for use in the daily grind. That will sometimes be a database, but even a sequence of Perl or Python scripts is more robust over time than any spreadsheet. You have no control over the skills and knowledge of some temp whose been hired to fill in for that admin assistant who is in hospital for an appendectomy. That temp needs to be working in a highly constrained environment where he cannot do any unintentional damage, and no spreadsheet can supply that kind of environment.