129 karma · joined April 29, 2016
--If you want to re-use a formula, you basically have to copy-paste it. Generally there isn't much modularity. Programmers are well aware of the dangers of this.
--It's also not a friendly platform for writing regression tests (possible with VB, but who does that?).
--The two-dimensional nature of the spreadsheets and lack of loops means you often need to do hacky stuff to emulate multidimensional arrays or loops. Easy to make mistakes here.
Yes, it's true Excel is used for a lot of big important things, but I'd agree with GP it's not very good at them. Moreover, I think most people who use Excel for big important things, would agree it's not good for it--they get stuck in that situation when a small spreadsheet grows big over the years. Lack of version control, limited modularity, and no ability to unit test make large spreadsheets error-prone, and Excel tends to barf on you when you push it too hard (seems to be a number of crash bugs and performance bugs that never get fixed).
Excel is incredibly productive for quick analysis and making charts. But it's really not a development platform and it's really not for heavy lifting.
With large programs, there can be a really long distance between where something is created/modified and where it's used. If there's a bug you catch that occurs where the object is used, reversible debuggers help you trace back to where it's created, or who modified it last.
If you're at a place that's hard to put a useful breakpoint (e.g. a widely used function), and need to answer a what-if question, being able to manipulate state from the debugger is super useful. You might not be able to easily insert code to the program to create that state without messing up everything else (again, example is a widely used function, where inserting code could mess up other users of the function).
Anyway, it's standard in scientific writing to use "we" instead of "I". https://en.wikipedia.org/wiki/We#The_author.27s_.22we.22
For an exposition on some heuristics mathematicians use, https://terrytao.wordpress.com/2015/01/04/254a-supplement-4-... is a good read (although it's aimed at readers already having some background in number theory).