Re: Excel for dodgy databases
"Excel is a wonderful tool for a knowledgeable user."
- Excel's power requires quite some training and a LOT of experience and failures to properly master.
- Excel's basic design means that potential issues scale polynomially with size and exponentially with complexity. Anything more complex than standard rows/columns is a bugger to debug, and any sheet doing anything at all complex is a nightmare to debug (or even to realise that something is wrong)
- Excel's basic simplicity and ubiquity mean that anyone who has ever used it thinks they're a master at it.
All the above combined are a recipe for trouble