Comment by zdw
15 hours ago
Excel spreadsheets have little to no validation logic that you're actually getting a good result, unless you have a secondary check (most spreadsheets are structured as "single entry" accounting, so lack the checks)
A prime example of this was the Reinhart/Rogoff paper advocating austerity that was widely quoted, and then it was discovered that the spreadsheet used had errors that invalidated the conclusions:
https://en.wikipedia.org/wiki/Growth_in_a_Time_of_Debt#Metho...
Just because technology is in use and "works" doesn't mean it's always correct.
You are taking my comment way too literatlly.
The point is not that people will be using specifically Excel, but that most business only pay for software because it is the tool that gives them the most power to automate their processes. They don't need high availablility, they don't need standards compliance, they don't extensive automated tests, they won't need cloud engineeers and SRE... all you need is some tool that can get the results your are looking for right now.
Academia already works like this. Software wrtiten for academic purposes is notoriously "bad" because it is not engineerd, but that doesn't matter because it is good enough to deliver the results that researchers need. Corporate IT will also start looking like this even at mid-sized companies.
An academic paper needs to deliver its output once, for the research. Maybe someone will try to replicate it later but that's someone elses problem (and fairly often proves the output of the former to be wrong)
Some stuff in companies might be similar, but there's a lot of things that people use every day, in a lot of different ways, and the software needs to work correctly regardless. You can't just drop it like a hot potato once you've built processes around it.
As always, the first 80% takes 20% of the time/effort, the last 20% takes the other 80%.
I don't disagree with anything you say here - using a tool that lacks guardrails is fine for a lot of tasks, but if that's the only tool and used where those guardrails go from "nice to haves" to something more critical is where the problem is.
I've been in ops for a long time and have encountered far too many "our IP addressing plan is just a spreadsheet with manual reconciliation".
I truly wonder if Excel and all it's predecessors and direct clones (Google Sheets, etc.) are holding back industry from making something truly better and more reliable.
> holding back industry from making something truly better and more reliable.
What "industry"?
If you are talking about the software industry, then I'd say you are creating a circular reasoning. If you are talking about all the other things that we actually need to do and which only incidentally have become too reliant on software to do it, then see back my original point: people don't need "better and more reliable" software to keep running their businesses.
7 replies →