Excel is remarkable, yes, but I'd argue that given its nature pretty much every reasonably complex workbook can be expected to have at least one bug. Having worked with them a lot in many different contexts, I've seen just how easily errors are introduced and I think they should never be used for research or finance where the cost of errors is high. At it's core the issue is that it's really hard to create variations and tests which can tell you if something is wrong... Much harder than it is to do this in a normal programming paradigm. Yes, the barrier to entry is lower, but the trade-off is much increased error rate and ongoing brittleness. Even if it's "right" at one point there's no guarantee it will be right in the future. What if someone copies/pastes data into a crucial worksheet and misses a column? It's so incredibly easy to screw up!
No comments yet.