>Why don't they invest in building a sane web application (or similar) that can do all the validation and calculations in a much better looking interface that i

>Why don't they invest in building a sane web application (or similar) that can do all the validation and calculations in a much better looking interface that is suited for the job / application? Inertia, training cost, and risk of failure. 1 year ago I made a very extensive spreadsheet to analyze planned production and forecasts at a factory. It took about 6 months after the logic was thoroughly vetted to transition it into an IT supported auto-update to a database as the primary project for 1 IT analyst. No pretty front end to modify production parameters or anything like that. If we transitioned any earlier, it would have been the typical "our user keeps changing the scope and logic of the application we're trying to build for them". This was probably the best way things could have reasonably gone. No long term spreadsheet usage, spreadsheet had good documentation, used tables, names ranges to make the formulas easy to read, etc. Excel can do a decent job at figuring out the required logic. But it is used as an everything tool where task specific applications would be best. And people only know enough to be dangerous