Spreadsheet bibliography

Title Spreadsheets on trial: A survey of research on spreadsheet risks
Authors Raymond R. Panko & Richard P. Halverson
Year 1996
Type Proceedings
Publication 29th Annual Hawaii International Conference on System Sciences
Series January, pages 326-335
Abstract

Even the earliest writers in end user computing remarked on the potential dangers of end user spreadsheet development. Until recently, there was only anecdotal evidence to support their concerns. Now, there is considerable evidence from experiments, field audits, and surveys of end users and organizations that early concerns were well-founded.

This paper presents a framework for risks in spreadsheeting and organizes selected research findings in terms of this framework.

Full version Available
Sample
Spreadsheet research risks cube
Spreadsheet research risks cube

This paper offers a taxonomy for understanding issues in spreadsheet risks.

The risks are represented in three dimensions:

  • Dependent variables. These are the issues to be addressed by research.
  • Stages in the systems development life cycle. Error rates vary considerably by stage. Some stages have not been studied at all in experiments and field audits, notably the requirements and design stages.
  • Research methodology. Each methodology has strengths and weaknesses. Unfortunately, research in most areas is dominated by a single methodology.