Abstract
The use of spreadsheets to support business processes is widespread in industry. Due to their criticality in the context of those business processes, spreadsheet shortcomings can significantly hamper an organization’s business operation. However, it is still unclear, what actual and typical shortcomings of spreadsheets applied as information systems are. Therefore, in this paper we present the results of an empirical study on spreadsheet shortcomings from an information systems perspective. In this sense, we focus particularly on how spreadsheets perform in their respective business context. The result of our work is a list of 20 shortcomings which typically occur in practice.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Abraham, R., Burnett, M., Erwig, M.: Spreadsheet Programming. Wiley Encyclopedia of Computer Science and Engineering (2008)
Ayalew, Y., Mittermeir, R.: Spreadsheet debugging (2008). arXiv:0801.4280
Basel Committee on Banking Supervision: Basel II (2004)
Bradley, L., McDaid, K.: Using Bayesian statistical methods to determine the level of error in large spreadsheets. In: Proceedings of the International Conference on Software Engineering, pp. 351–354 (2009)
Caulkins, J.P., Morrison, E.L., Weidemann, T.: Spreadsheet errors and decision making: evidence from field interviews. J. Organ. End User Comput. 19(3), 1–23 (2007)
Chan, Y.E., Storey, V.C.: The use of spreadsheets in organizations: determinants and consequences. Inf. Manage. 31, 119–134 (1996)
Cunha, J., Fernandes, J.P., Mendes, J., Pereira, R., Saraiva, J.: Embedding model-driven spreadsheet queries in spreadsheet systems. In: Proceedings of the Symposium on Visual Languages and Human-Centric Computing (2014)
Gable, G.G., Yap, C.M., Eng, M.N.: Spreadsheet investment, criticality, and control. In: Hawaii International Conference on System Sciences (1991)
Grossman, T.A., Mehrotra, V., Ă–zlĂĽk, Ă–.: Spreadsheet information systems are essential to business. Working paper (2005)
MetricStream GRC Blog: The true cost of spreadsheets in risk and compliance management (2014)
Nardi, B.A., Miller, J.R.: An ethnographic study of distributed problem solving in spreadsheet development. In: Proceedings of the Conference on Computer-Supported Cooperative Work, pp. 197–208 (1990)
Panko, R.R.: Facing the problem of spreadsheet errors. Decis. Line 37(5), 8–10 (2006)
Panko, R.R., Halverson Jr., R.: Two corpuses of spreadsheet errors. In: Proceedings of the Hawaii International Conference on System Sciences, pp. 1–8 (2000)
Panko, R.R., Port, D.N.: End user computing: the dark matter (and dark energy) of corporate IT. J. Organ. End User Comput. 25(3), 4603–4612 (2012)
Pemberton, J.D., Robson, A.J.: Spreadsheets in business. Ind. Manage. Data Syst. 100(8), 379–388 (2000)
Powell, S.G., Baker, K.R., Lawson, B.: A critical review of the literature on spreadsheet errors. Decis. Support Syst. 46(1), 128–138 (2008)
Powell, S.G., Baker, K.R., Lawson, B.: Impact of errors in operational spreadsheets. Decis. Support Syst. 47(2), 126–132 (2009)
Rajalingham, K., Chadwick, D.R., Knight, B.: Classification of Spreadsheet Errors. (2008). arXiv:0805.4224
Rothermel, G., Burnett, M., Li, L., Dupuis, C., Sheretov, A.: A methodology for testing spreadsheets. ACM Trans. Software Eng. Methodol. 10(1), 110–147 (2001)
Senn, J.A.: Information Technology: Principles, Practices, and Opportunities, 3rd edn. Pearson Prentice Hall, Upper Saddle River (2004)
United States Congress: Sarbanes-Oxley Act (2002)
Yin, R.K.: Case Study Research: Design and Methods, 5th edn. Sage Publications, Thousand Oaks (2014)
Acknowledgment
This research has been sponsored in part by the German Federal Ministry of Education and Research (BMBF) with grant number TUM: 01IS12057.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 Springer International Publishing Switzerland
About this paper
Cite this paper
Reschenhofer, T., Matthes, F. (2015). An Empirical Study on Spreadsheet Shortcomings from an Information Systems Perspective. In: Abramowicz, W. (eds) Business Information Systems. BIS 2015. Lecture Notes in Business Information Processing, vol 208. Springer, Cham. https://doi.org/10.1007/978-3-319-19027-3_5
Download citation
DOI: https://doi.org/10.1007/978-3-319-19027-3_5
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-19026-6
Online ISBN: 978-3-319-19027-3
eBook Packages: Computer ScienceComputer Science (R0)