Abstract
This paper describes a new approach to the provision of a software engineering discipline for the spreadsheet life-cycle: from requirements, to design, implementation and subsequent maintenance. This approach addresses the widespread problem of spreadsheet errors, which are analysed in detail and the outcome of which is a more comprehensive classification of errors than presented before. It is accompanied and supported by appropriate examples.
This new approach differs from other approaches in that it is based on an analysis of spreadsheet structure. The elements of this approach are explained and illustrated with examples. It’s potential for integrity control is also discussed, especially based on the types of errors it will detect, reduce or prevent.
Chapter PDF
References
Chadwick, D., Knight, J. and Clipsham, P. (1997, December) Information Integrity In End-user Systems. Proceedings of the IFIP TC-I1 Working Group 11.5 First Working Conference on Integrity and Internal Control in Information Systems,Zurich, Switzerland.
DiAntonio, A. E. (1986) Spreadsheet Applications. Prentice-Hall.
Ditlea, S. (1987, January) Spreadsheets Can be Hazardous to Your Health. Personal Computing Vol 11, p60–69.
Hendry, D. G. and Green, T. R. G. (1994, January) Creating, comprehending and explaining spreadsheets: a cognitive interpretation of what discretionary users think of the spreadsheet model. International Journal of Human-Computer Studies Vol 40, p1033–1065.
KPMG (1997) Executive Summary: Financial Model Review Survey. KPMG Management Consulting, London.
Microsoft Corporation (1994). Microsoft EXCEL users Guide.
Panko, R. R. and Halverson, R. P., Jr. (1996, January) Spreadsheets on Trial: A Framework for Research on Spreadsheet Risks. Proceedings of the Twenty-Ninth Hawaii International Conference on System Sciences, Maui, Hawaii.
Panko, R. R. (forthcoming) What We Know About Spreadsheet Errors. Conditionally Accepted for Publication in the Journal of End User Computing’s Special issue on Scaling Up End User Development, Spring 1998.
Ward, M. (1997) Fatal Addition. New Scientist 16th August.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1998 Springer Science+Business Media Dordrecht
About this chapter
Cite this chapter
Rajalingham, K., Chadwick, D. (1998). Integrity Control of Spreadsheets: Organisation & Tools. In: Jajodia, S., List, W., McGregor, G.W., Strous, L.A.M. (eds) Integrity and Internal Control in Information Systems. IICIS 1998. IFIP — The International Federation for Information Processing, vol 9. Springer, Boston, MA. https://doi.org/10.1007/978-0-387-35396-8_8
Download citation
DOI: https://doi.org/10.1007/978-0-387-35396-8_8
Publisher Name: Springer, Boston, MA
Print ISBN: 978-1-4757-5533-6
Online ISBN: 978-0-387-35396-8
eBook Packages: Springer Book Archive