Spreadsheet Errors

In recent years, a number of studies have looked at spreadsheet errors. In general, spreadsheet error rates look like error rates in normal program development and in code inspection.

Tables showing errors in spreadsheet development and auditing are available at the Spreadsheet Research (SSR) website,  http://panko.shidler.hawaii.edu/ssr

The tables have data from several systematic field audits involving a large number of spreadsheets.

The most significant thing about the studies listed in the table is that every study that has looked at spreadsheet errors has found them and has found them at disturbing rates.
 

Copyright 1997-2008