• chris.smith 91049 (1/21/2014).............. The takeaway from that research is "Spreadsheets WILL have errors and they're hard to find" and the more complex the sheet, the more those errors will compound.

    Chris, all applications will have errors, I haven't found one app that hasn't but still live in hope.

    I have heard that MS Access:

    * has been used for years to provide the fuel calculations for an air fleet of a world leading airline.

    * used to track the sales of $1 billion because it was more flexible than Oracle financials

    Yes, neither of these is best practice and I know that a lot of IT pressure was made to get these changed. But the different IT departments could only promise a deadline that was months/year away which was unrealistic for the business operation and profit margin.

    I would prefer that the logic was in sprocs and constraints but it is only a preference and not the only way of meeting business requirements.