“All in all, the research done to date in spreadsheet development presents a very disturbing picture. Every study that has attempted to\u00a0measure errors, without exception, has found them at rates that would be unacceptable in any organization. These error rates, furthermore,\u00a0are completely consistent with error rates found in other human activities. With such high cell error rates, most large spreadsheets will have\u00a0multiple errors, and even relatively small “scratch pad” spreadsheets will have a significant probability of error.<\/p>\n
“Despite the evidence,\u00a0individual developers and organizations appear to be in a state of denial. They do not regularly implement even fairly simple controls to\u00a0reduce errors, much less such bitter pills as comprehensive code inspection. One corporate officer probably summarized the situation by\u00a0saying that he agreed with the error rate numbers but felt that comprehensive code inspection is simply impractical. In other words, he was\u00a0saying that the company should continue to base critical decisions on bad numbers.”<\/p>\n
-Raymond Panko, “All in all, the research done to date in spreadsheet development presents a very disturbing picture. Every study that has attempted to\u00a0measure errors, without exception, has found them at rates that would be unacceptable in any organization. These error rates, furthermore,\u00a0are completely consistent with error rates found in other human activities. With such high cell … <\/p>\n
\n“What We Know About Spreadsheet Errors”<\/a>\u00a0(via Eve<\/a>)<\/p>\n","protected":false},"excerpt":{"rendered":"