2 ms·
How can you achieve anything equivalent to unit testing? How can you do any kind of change control (unless you treat every edit to the sheet as a change)? Excel
by lmm 6y ago
How can you achieve anything equivalent to unit testing? How can you do any kind of change control (unless you treat every edit to the sheet as a change)? Excel does some things well but for anything that needs to work robustly as part of a process (as opposed to one-time exploratory data analysis) it lacks things that were basic in 1996. It's an "unsafe at any speed" situation: it may work as long as you do everything right, but it's missing basic safeguards as soon as you make a single mistake; I'd put it in the same category as using a memory-unsafe language.