re: Formula 1 chief appalled to find team using Excel to manage 20,000 car parts

quote:

---

Mine?!

No sir. My work is not littered with errors.

---

Would you be willing to bet money that no one could find a single error in your Excel work?

Is all user input sanitized?

Do your formulas/macros/scripts/code handle edge cases?

Do you have a test framework to ensure that given sets of inputs match the resulting outputs? Is that even possible to automate or must it be done manually periodically?