What We Know About Spreadsheet Errors Export

@article{panko1998:errors, abstract = {http://panko.shidler.hawaii.edu/SSR/Mypapers/whatknow.htm Although spreadsheet programs are used for small "scratchpad" applications, they are also used to develop many large applications. In recent years, we have learned a good deal about the errors that people make when they develop spreadsheets. In general, errors seem to occur in a few percent of all cells, meaning that for large spreadsheets, the issue is how many errors there are, not whether an error exists. These error rates, although troubling, are in line with those in programming and other human cognitive domains. In programming, we have learned to follow strict development disciplines to eliminate most errors. Surveys of spreadsheet developers indicate that spreadsheet creation, in contrast, is informal, and few organizations have comprehensive policies for spreadsheet development. Although prescriptive articles have focused on such disciplines as modularization and having assumptions sections, these may be far less important than other innovations, especially cell-by-cell code inspection after the development phase.}, author = {Panko, Raymond R.}, citeulike-article-id = {5781754}, comment = {http://panko.shidler.hawaii.edu/SSR/Mypapers/whatknow.htm}, journal = {Journal of End User Computing}, keywords = {end\_user\_programmers, error\_rates, spreadsheet\_creation, spreadsheet\_errors, spreadsheet\_programs, testing}, number = {2}, posted-at = {2009-09-14 19:47:32}, priority = {2}, title = {What We Know About Spreadsheet Errors}, volume = {10}, year = {1998} }

TY - JOUR ID - panko1998:errors L3 - citeulike-article-id:5781754 N2 - http://panko.shidler.hawaii.edu/SSR/Mypapers/whatknow.htm Although spreadsheet programs are used for small "scratchpad" applications, they are also used to develop many large applications. In recent years, we have learned a good deal about the errors that people make when they develop spreadsheets. In general, errors seem to occur in a few percent of all cells, meaning that for large spreadsheets, the issue is how many errors there are, not whether an error exists. These error rates, although troubling, are in line with those in programming and other human cognitive domains. In programming, we have learned to follow strict development disciplines to eliminate most errors. Surveys of spreadsheet developers indicate that spreadsheet creation, in contrast, is informal, and few organizations have comprehensive policies for spreadsheet development. Although prescriptive articles have focused on such disciplines as modularization and having assumptions sections, these may be far less important than other innovations, especially cell-by-cell code inspection after the development phase. IS - 2 JF - Journal of End User Computing TI - What We Know About Spreadsheet Errors VL - 10 KW - end_user_programmers KW - error_rates KW - spreadsheet_creation KW - spreadsheet_errors KW - spreadsheet_programs KW - testing N1 - http://panko.shidler.hawaii.edu/SSR/Mypapers/whatknow.htm AU - Panko, Raymond PY - 1998/// ER -