An Empirical Study on Spreadsheet Shortcomings from an Information Systems Perspective

  • Thomas Reschenhofer
  • Florian Matthes
Conference paper
Part of the Lecture Notes in Business Information Processing book series (LNBIP, volume 208)


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.


Spreadsheet Case study Shortcomings Business process support Decision support system 



This research has been sponsored in part by the German Federal Ministry of Education and Research (BMBF) with grant number TUM: 01IS12057.


  1. 1.
    Abraham, R., Burnett, M., Erwig, M.: Spreadsheet Programming. Wiley Encyclopedia of Computer Science and Engineering (2008)Google Scholar
  2. 2.
    Ayalew, Y., Mittermeir, R.: Spreadsheet debugging (2008). arXiv:0801.4280
  3. 3.
    Basel Committee on Banking Supervision: Basel II (2004)Google Scholar
  4. 4.
    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)Google Scholar
  5. 5.
    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)CrossRefGoogle Scholar
  6. 6.
    Chan, Y.E., Storey, V.C.: The use of spreadsheets in organizations: determinants and consequences. Inf. Manage. 31, 119–134 (1996)CrossRefGoogle Scholar
  7. 7.
    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)Google Scholar
  8. 8.
    Gable, G.G., Yap, C.M., Eng, M.N.: Spreadsheet investment, criticality, and control. In: Hawaii International Conference on System Sciences (1991)Google Scholar
  9. 9.
    Grossman, T.A., Mehrotra, V., Özlük, Ö.: Spreadsheet information systems are essential to business. Working paper (2005)Google Scholar
  10. 10.
    MetricStream GRC Blog: The true cost of spreadsheets in risk and compliance management (2014)Google Scholar
  11. 11.
    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)Google Scholar
  12. 12.
    Panko, R.R.: Facing the problem of spreadsheet errors. Decis. Line 37(5), 8–10 (2006)Google Scholar
  13. 13.
    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)Google Scholar
  14. 14.
    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)Google Scholar
  15. 15.
    Pemberton, J.D., Robson, A.J.: Spreadsheets in business. Ind. Manage. Data Syst. 100(8), 379–388 (2000)CrossRefGoogle Scholar
  16. 16.
    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)CrossRefGoogle Scholar
  17. 17.
    Powell, S.G., Baker, K.R., Lawson, B.: Impact of errors in operational spreadsheets. Decis. Support Syst. 47(2), 126–132 (2009)CrossRefGoogle Scholar
  18. 18.
    Rajalingham, K., Chadwick, D.R., Knight, B.: Classification of Spreadsheet Errors. (2008). arXiv:0805.4224
  19. 19.
    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)CrossRefGoogle Scholar
  20. 20.
    Senn, J.A.: Information Technology: Principles, Practices, and Opportunities, 3rd edn. Pearson Prentice Hall, Upper Saddle River (2004)Google Scholar
  21. 21.
    United States Congress: Sarbanes-Oxley Act (2002)Google Scholar
  22. 22.
    Yin, R.K.: Case Study Research: Design and Methods, 5th edn. Sage Publications, Thousand Oaks (2014)Google Scholar

Copyright information

© Springer International Publishing Switzerland 2015

Authors and Affiliations

  1. 1.Technical University of MunichGarchingGermany

Personalised recommendations