News for hackers. Stuff that matters.
Re:Finance Pros Say You’ll Have to Pry Excel Out of Their Co... by twic on Thursday November 30, 2017 @06:11PM (#15820515)
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.

Re:Finance Pros Say You’ll Have to Pry Excel Out of Their Co... by roenxi on Thursday November 30, 2017 @08:31PM (#15821255)
Excel 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.

Re:Finance Pros Say You’ll Have to Pry Excel Out of Their Co... by vorotato on Friday December 01, 2017 @08:51AM (#15823770)
If 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.