Skip to main content
SpringerLink
Log in
Book cover

International Conference on Business Information Systems

BIS 2015: Business Information Systems pp 50–61Cite as

An Empirical Study on Spreadsheet Shortcomings from an Information Systems Perspective

  • Conference paper
  • First Online:

Part of the book series: Lecture Notes in Business Information Processing ((LNBIP,volume 208))

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.

This is a preview of subscription content, log in via an institution.

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Notes

  1. 1.

    https://www.useslate.com.

  2. 2.

    http://www.think-cell.com.

  3. 3.

    https://docs.google.com/spreadsheets/.

References

  1. Abraham, R., Burnett, M., Erwig, M.: Spreadsheet Programming. Wiley Encyclopedia of Computer Science and Engineering (2008)

    Google Scholar 

  2. Ayalew, Y., Mittermeir, R.: Spreadsheet debugging (2008). arXiv:0801.4280

  3. Basel Committee on Banking Supervision: Basel II (2004)

    Google Scholar 

  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. 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)

    Article  Google Scholar 

  6. Chan, Y.E., Storey, V.C.: The use of spreadsheets in organizations: determinants and consequences. Inf. Manage. 31, 119–134 (1996)

    Article  Google Scholar 

  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. 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. Grossman, T.A., Mehrotra, V., Özlük, Ö.: Spreadsheet information systems are essential to business. Working paper (2005)

    Google Scholar 

  10. MetricStream GRC Blog: The true cost of spreadsheets in risk and compliance management (2014)

    Google Scholar 

  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. Panko, R.R.: Facing the problem of spreadsheet errors. Decis. Line 37(5), 8–10 (2006)

    Google Scholar 

  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. 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. Pemberton, J.D., Robson, A.J.: Spreadsheets in business. Ind. Manage. Data Syst. 100(8), 379–388 (2000)

    Article  Google Scholar 

  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)

    Article  Google Scholar 

  17. Powell, S.G., Baker, K.R., Lawson, B.: Impact of errors in operational spreadsheets. Decis. Support Syst. 47(2), 126–132 (2009)

    Article  Google Scholar 

  18. Rajalingham, K., Chadwick, D.R., Knight, B.: Classification of Spreadsheet Errors. (2008). arXiv:0805.4224

  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)

    Article  Google Scholar 

  20. Senn, J.A.: Information Technology: Principles, Practices, and Opportunities, 3rd edn. Pearson Prentice Hall, Upper Saddle River (2004)

    Google Scholar 

  21. United States Congress: Sarbanes-Oxley Act (2002)

    Google Scholar 

  22. Yin, R.K.: Case Study Research: Design and Methods, 5th edn. Sage Publications, Thousand Oaks (2014)

    Google Scholar 

Download references

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

  1. Technical University of Munich, Boltzmannstr. 3, 85748, Garching, Germany

    Thomas Reschenhofer & Florian Matthes

Authors
  1. Thomas Reschenhofer
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Florian Matthes
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Thomas Reschenhofer .

Editor information

Editors and Affiliations

  1. Department of Information Systems, Poznań University of Economics, Poznań, Poland

    Witold Abramowicz

Rights and permissions

Reprints 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)

Publish with us

Policies and ethics

Search

Navigation