Spreadsheet development and 'what-if' analysis: Quantitative versus qualitative errors

Accounting, Management and Information Technologies

Volumn 9, Issue 3, 1999, Pages 141-160

  Teo, Thompson S H ^a   Tan, Margaret ^a  

^a NATIONAL UNIVERSITY OF SINGAPORE   (Singapore)

Author keywords

'What if' analysis; End user computing; Error; Modeling; Spreadsheet

Indexed keywords

EID: 0042132682     PISSN: 09598022     EISSN: None     Source Type: Journal    
DOI: 10.1016/S0959-8022(99)00006-5     Document Type: Article

References (23)

1. AMA (1988). Report on end-user and departmental computing. New York: American Management Association.
2. Brown, P. S., & Gould, J. D. (1987). An experimental study of people creating spreadsheets. ACM Transactions on Office Information Systems, 5, 258-272.
3. Cale, E. G. Jr. (1994). Quality issues for end-user developed software. Journal of Systems Management, 45, 36-39.
4. Cragg, P. G., & King, M. (1993). Spreadsheet modelling abuse: an opportunity for OR? Journal of the Operational Research Society, 44, 743-752.
5. Crawford, M. D. (1994). Re: Microsoft and Lotus spreadsheet errors. The Risks Digest, 16.
6. Davies, N., & Ikin, C. (1987). Auditing spreadsheets. Australian Accountant, December, 54-56.
7. Ditlea, S. (1987). Spreadsheets can be hazardous to your health. Personal Computing, January, 60-69.
8. Floyd, B. D., Walls, J., & Marr, K. (1995). Managing spreadsheet model development. Journal of Systems Management 46 (1), 38-43, 68.
9. Galletta, D. F., Abraham, D., El Louadi, M., Leske, W., Pollalis, Y. A., & Sampler, J. L. (1993). An empirical study of spreadsheet error-finding performance. Accounting, Management and Information Technologies, 3, 79-95.
10. Galletta, D. F., Hartzel, K. S., Johnson, S., Joseph, J., & Rustagi, S. (1996-1997). Spreadsheet presentation and error detection: An experimental study. Journal of Management Information Systems, 13 (Winter), 45-63.
11. Goss, E., Dillon, T., & Kendrick, J. (1989). Bittersweet spreadsheets: application development needs control. The Woman CPA, July, 20-24.
12. Hall, M. J. J. (1996). A risk and control oriented study of the practices of spreadsheet application developers. In Proceedings of the 29th Hawaii International Conference on System Sciences (pp. 364-373). Maui, Hawaii, 4-7 January. IEEE Computer Society Press.
13. Janvrin, D., & Morrison, J. (1996). Factors influencing risks and outcomes in end-user development. In Proceedings of the 29th Hawaii International Conference on System Sciences (pp. 346-355). Maui, Hawaii, 4-7 January. IEEE Computer Society Press.
14. Lerch, F. J. (1988). Computerized financial planning: discovering cognitive difficulties in model building. Unpublished Ph.D. dissertation, University of Michigan, Ann Arbor.
15. Kee, R. C., & Mason, J. O. Jr. (1988). Preventing errors in spreadsheets. Internal Auditor, February, 42-47.
16. Olson, J. R., & Nilsen, E. (1987-1988). Analysis of the cognition involved in spreadsheet interaction. Human Computer Interaction, 3, 309-349.
17. Panko, R. R. (1988). End user computing: management, applications, and technology (1st ed). New York: John Wiley.
18. Panko, R. R. (1996). Hitting the wall: Errors in developing and debugging in a 'simple' spreadsheet problem. In Proceedings of the 29th Hawaii International Conference on System Sciences (pp. 356-363). Maui, Hawaii, 4-7 January. IEEE Computer Society Press.
19. Panko, R. R., & Halverson, R. P., Jr. (1995). Patterns of errors in spreadsheet development I: quantitative errors. Working Paper, Department of Decision Sciences, College of Business Administration, University of Hawaii.
20. Panko, R. R., & Halverson, R. P., Jr. (1996). Spreadsheets on trial: A survey of research on spreadsheet risks. In: Proceedings of the 29th Hawaii International Conference on System Sciences (pp. 326-335). Maui, Hawaii, 4-7 January. IEEE Computer Society Press.
21. Panko, R. R., & Halverson, R. P. Jr. (1997). Are two heads better than one? (at reducing errors in spreadsheet modeling?). Office Systems Research Journal, 15 (1), 21-32.
22. Panko, R. R., & Sprague, R. H. Jr. (1996). Hitting the wall: Errors in developing and code inspecting a 'simple' spreadsheet model. Decision Support Systems, 22, 337-353.
23. Schultheis, R., & Sumner, M. (1994). The relationship of application risks to application controls: A study of microcomputer-based spreadsheet applications. Journal of End User Computing, 6, 11-18.