Comment by throwaway2037
4 hours ago
Assume that later models of the 747 were managed in Excel. No trolling: What is wrong with that? You can write insanely powerful software using (1) formulas on the sheet (which are essentially functional programming) and (2) imperative logic in VBA (HTTP calls, database calls, file system, etc.). For years, I used this model and wrote pretty powerful software. Sometimes, I miss it for the encapsulated system. These days, in "biz dev" (internal software), it seems like the Excel model was replaced with an Electron front-end (HTML/CSS/JS) with Java back-end.
There's nothing particularly wrong with it, Excel works great. But almost any complex Excel file is riddled with obscure bugs and the nature of the tool makes it impractical to apply some of the most effective quality control techniques. Like you can't easily do code reviews or write an automated test suite.
I second this! Excel is a front end everybody knows and everybody can run. I always got laughed at when I say the biggest competitor of small apps (things like gym diary, meal planner etc.) is excel. Now that it even support python…