• Corpus ID: 7009221

When, why and how to test spreadsheets

@article{Pryor2008WhenWA,
  title={When, why and how to test spreadsheets},
  author={Louise Pryor},
  journal={ArXiv},
  year={2008},
  volume={abs/0807.3187}
}
  • L. Pryor
  • Published 20 July 2008
  • Computer Science
  • ArXiv
Testing is a vital part of software development, and spreadsheets are like any other software in this respect. This paper discusses the testing of spreadsheets in the light of one practitioner’s experience. It considers the concept of software testing and how it differs from reviewing, and describes when it might take place. Different types of testing are described, and some techniques for performing them presented. Some of the commonly encountered problems are discussed. 

Investigating the Potential of Test-Driven Development for Spreadsheet Engineering

Through a pair of case studies it is demonstrated that Test-Driven Development can be applied to the development of spreadsheets and a supporting tool under development by the authors is documented along with proposed research to determine the effectiveness of the methodology and the associated tool.

Spreadsheet Testing in Practice

A mixed methods study investigates whether spreadsheet users also test, or how do they test and to what extent, and indicates that ensuring correctness is an important concern, and a major fraction of users do test their spreadsheets.

Spreadsheet testing in practice

A mixed methods study investigates whether spreadsheet users also test, or how do they test and to what extent, and indicates that ensuring correctness is an important concern, and a major fraction of users do test their spreadsheets.

How can non-technical end users effectively test their spreadsheets?

Purpose – An alarming number of spreadsheet faults have been reported in the literature, indicating that effective and easy-to-apply spreadsheet testing techniques are not available for

The Reification of an Incorrect and Inappropriate Spreadsheet Model

A case study is described through which it was able to observe at close hand the reification of a demonstrably incorrect and inappropriate spreadsheet model within a small non profit organisation.

Towards a Spreadsheet Engineering

The need to rigorously lay the foundations of a spreadsheet engineering discipline is proposed, since multiple research teams would be required to tackle such a big task.

Inclusion Analysis

Inclusion analysis is the name given by Operis to a black box testing technique that it has found to make the checking of key financial ratios calculated by spreadsheet models quicker, easier and

A Practical Approach to Managing Spreadsheet Risk in a Global Business

A case-study is presented explaining the practical and pragmatic approach that was recently taken to control spreadsheet risk at one of Protiviti's clients - a global energy firm.

Evolution of model-driven spreadsheets

The strategy described is based on a model-driven approach, and is achieved by embedding spreadsheet models within spreadsheets themselves, which facilitates the establishment and maintenance of a consistency relationship between models and instances throughout the spreadsheet development life cycle.

Exploring Spreadsheet Use and Practices in a Technologically Constrained Setting

Findings indicate that the proliferation of spreadsheets in the organization has provided an enabling environment for business automation and there is ample room for improvement in many areas such as implementation of comprehensive policies and regulations governing spreadsheet development processes and adoption.

References

SHOWING 1-8 OF 8 REFERENCES

Test Driven Development: A Practical Guide

Test-Driven Development: A Practical Guide presents TDD from the perspective of the working programmer: real projects, real challenges, real solutions, ...real code. Dave Astels explains TDD through

Principles of software engineering management

This most recent book of Mr. Gilb's may be destined to become part of APL's folklore; if it were to adopt these methods in a similarly serious-minded vein the authors might easily discover a lot about ourselves and just possibly find a new way of getting their message into wider environments.

Believing your results

  • 2004

Believing your results. http://www.louisepryor.com/papers/confident.pdf. XLSior is available from http://www.xlsior.com

  • 2004

Sample workbook at http

  • Sample workbook at http
  • 2004

XLSior is available from http://www.xlsior

  • XLSior is available from http://www.xlsior

Sample workbook at

  • 2004