A critical review of the literature on spreadsheet errors

Decision Support Systems

Volumn 46, Issue 1, 2008, Pages 128-138

  Powell, Stephen G ^a   Baker, Kenneth R ^a   Lawson, Barry ^a  

^a DARTMOUTH COLLEGE   (United States)

Author keywords

Decision support; End user computing; Error classification; Spreadsheets

Indexed keywords

DECISION SUPPORT SYSTEMS; ERRORS;

CRITICAL REVIEWS; DECISION SUPPORT; END-USER COMPUTING; ERROR CLASSIFICATION; FUTURE RESEARCH DIRECTIONS; SPREADSHEET ERRORS;

SPREADSHEETS;

EID: 56049089143     PISSN: 01679236     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.dss.2008.06.001     Document Type: Article

References (41)

1. Ayalew Y., Clermont M., and Mittermier R. Detecting errors in spreadsheets. Proceedings of the European Spreadsheet Risks Interest Group Annual Conference University of Greenwich, London (2000) 51-62
2. Brown P., and Gould J. An experimental study of people creating spreadsheets. ACM Transactions on Office Information Systems 5 (1987) 258-272
3. Butler R. Is this spreadsheet a tax evader?. Proceedings of the 33rd Hawaii International Conference on System Sciences (2000) 1-6
4. R. Butler, Risk assessment for spreadsheet developments: choosing which models to audit, H. M. Customs and Excise UK (2000).
5. J. Caulkins, E. Morrison, T. Weidemann, Spreadsheet errors and decision making: evidence from field interviews, Journal of End User Computing (to appear) (2006).
6. Clermont M. A spreadsheet auditing tool evaluated in an industrial context. Proceedings of the European Spreadsheet Risks Interest Group Conference Cardiff Wales (2002) 35-46
7. Cragg P., and King M. Spreadsheet modelling abuse: an opportunity for OR?. Journal of Operational Research Society 44 8 (1993) 743-752
8. Davies N., and Ikin C. Auditing spreadsheets. Australian Accountant 57 11 (1987) 54-56
9. Ditlea S. Spreadsheets can be hazardous to your health. Personal Computing (1987) 60-69
10. Freeman D. How to make spreadsheets error-proof. Journal of Accountancy 181 5 (1996) 75-77
11. Galletta F., Abraham D., El Louadi M., Leske W., Pollalis Y., and Sampler J. An empirical study of spreadsheet error-finding performance. Accounting, Management & Information Technology 3 2 (1993) 79-95
12. Galletta F., Hartzel K., Johnson S., Joseph J., and Rustagi S. Spreadsheet presentation and error detection: an experimental study. Journal of Management Information Systems 13 3 (1997) 45-63
13. H. M. Customs and excise computer audit service. Methodology for the audit of spreadsheet models (2001)
14. Howe H., and Simkin M.G. Factors affecting the ability to detect spreadsheet errors. Decision Sciences Journal of Innovative Education 4 1 (2006) 101-122
15. Janvrin D., and Morrison J. Factors influencing risks and outcomes in end-user development. Proceedings of the 29th Annual Hawaii International Conference on System Sciences (1996) 349-355
16. Kreie J., Cronin T., Pendley J., and Renwick J. Applications development by end-users: can quality be improved?. Decision Support Systems, 29 (2000) 143-152
17. Kruck S. Testing spreadsheet accuracy theory. Information and Software Technology 48 (2006) 204-213
18. Kruck S., and Sheetz S. Spreadsheet accuracy theory. Journal of Information Systems Education 12 (2001) 93-108
19. Lawrence R., and Lee J. Financial modelling of project financing transactions. Institute of Actuaries of Australia Financial Services 19 (2004)
20. F. Lerch, Computerized financial planning: discovering cognitive difficulties in knowledge building, Unpublished Ph.D. dissertation, University of Michigan, Ann Arbor, MI (1988).
21. McGill T., and Klobas J. The role of spreadsheet knowledge in user-developed application success. Decision Support Systems 39 (2005) 355-369
22. Nardi B., and Miller J. Twinkling lights and nested loops: distributed problem solving and spreadsheet development. International Journal of Man-Machine Studies 34 (1991) 161-184
23. Olson J., and Nilsen J.E. Analysis of the cognition involved in spreadsheet software interaction. Human-Computer Interaction 3 4 (1987-88) 309-349
24. Panko R. What we know about spreadsheet errors. Journal of End-User Computing 10 (1998) 15-21
25. Panko R. What we know about spreadsheet errors (2006). http://panko.cba.hawaii.edu/ssr/Mypapers/whatknow.htm http://panko.cba.hawaii.edu/ssr/Mypapers/whatknow.htm, accessed September 2
26. Panko R., and Halverson R. Spreadsheets on trial: a survey of research on spreadsheet risks. Proceedings of the 29th Annual Hawaii International Conference on Systems Sciences (1996) 326-335
27. Panko R., and Halverson R. Are two heads better than one (at reducing errors in spreadsheet modeling?). Office Systems Research Journal 15 1 (1997) 21-32
28. Panko R., and Halverson R. Two corpuses of spreadsheet errors. Proceedings of the 33rd Annual Hawaii International Conference on Systems Sciences (2000) 1-8
29. Panko R., and Sprague R. Hitting the wall: errors in developing and code inspecting a 'simple' spreadsheet model. Decision Support Systems 22 (1998) 337-353
30. Powell S., Baker K., and Lawson B. Errors in operational spreadsheets. Spreadsheet Engineering Research Project working paper (2006)
31. Powell S., Baker K., and Lawson B. An auditing protocol for spreadsheet models. Spreadsheet Engineering Research Project working paper (2006)
32. Purser M., and Chadwick D. Does an awareness of differing types of spreadsheet errors aid end-users in identifying spreadsheet errors?. Proceedings of the European Spreadsheet Risk Interest Group Annual Conference, Cambridge, UK (2006) 185-204
33. Rajalingham K., Chadwick D., and Knight B. Classification of spreadsheet errors. Proceedings of the European Spreadsheet Risks Interest Group Annual Conference, Greenwich, England (2000) 23-34
34. Reason J. Human Error (1990), Cambridge University Press, Cambridge, UK
35. Reinhardt T., and Pillay N. Analysis of spreadsheet errors made by computer literacy students. Proceedings of the IEEE International Conference on Advanced Learning Technologies (2004) 852-853
36. Ronen B., Palley M., and Lucas H. Spreadsheet analysis and design. Communications of the ACM 32 1 (1989) 84-93
37. Saariluoma P., and Sajaniemi J. Transforming verbal descriptions into mathematical formulas in spreadsheet calculation. International Journal of Human-Computer Studies 41 (1994) 915-948
38. Sommerville K. Software Engineering. 7th Edition (2004), Addison Wesley
39. Teo T., and Lee-Partridge J. Effects of error factors and prior incremental practice on spreadsheet error detection: an experimental study. Omega - The International Journal of Management Science 29 (2001) 445-456
40. Teo T., and Tan M. Quantitative and qualitative errors in spreadsheet development. Proceedings of the 30th Hawaii International Conference on Systems Sciences (1997) 149-155
41. Van Someren M., Barnard Y., and Sandberg J. The Think Aloud Method: A Practical Guide to Modeling Cognitive Processes (1994), Academic Press, New York