3 ms·
Excel sheets aren't very maintainable. You get a big grid, plus named ranges. There aren't good tools for generalisation or abstraction, so big sheets have all
by twic 9y ago
Excel sheets aren't very maintainable. You get a big grid, plus named ranges. There aren't good tools for generalisation or abstraction, so big sheets have all the usual problems of bad software: hard to understand, hard to change, full of inconsistencies, etc. There are also no good options for source control, modular reuse, etc.
I work on a desk which has a lot of vital calculations in Excel spreadsheets. They work, and we make money, but it takes a lot of human effort (expensive trader effort!) to keep them working properly. If we want to scale up - more people, more products, etc - we need to move more and more of those calculations into software.
Improvements to or replacements for the spreadsheet as tools for non-programmers would certainly be helpful. But better tools and techniques for programmers to port functionality from spreadsheets to 'real' software would also be helpful.
- roenxi 9y agoExcel spreadsheets aren't maintainable, but in context there are some subtleties. If the process is upgraded to a full-blown piece of 'real' software, now you need a full-blown software dev to maintain it. A better result from more resources isn't a clean improvement, it is just a change. Straddling the line between 'technically best outcome' and 'cheapest workable outcome' is what businesses strive to do. In most mature businesses change should be approached extremely cautiously; everybody loves changing things and the costs are frequently big.
- vorotato 9y agoIf your risk is less than it costs to build the software then that's totally acceptable, but what is unacceptable is billion dollar businesses using spreadsheets to manage critical business operations.