Test-Driven Development: Can It Work for Spreadsheet Engineering?
It is widely accepted that the absence of a structured approach to spreadsheet engineering is a key factor in the high level of spreadsheet errors. In this paper we propose and investigate the application of Test-Driven Development to the creation of spreadsheets. Through a pair of case studies we demonstrate that Test-Driven Development can be applied to the development of spreadsheets. A supporting tool under development by the authors is also documented along with proposed research to determine the effectiveness of the methodology and the associated tool.
KeywordsStructure Approach Test Drive Spreadsheet Program National Development Plan Agile Development
- 1.Beck, K.: Test Driven Development: By Example. Addison-Wesley, Reading (2003)Google Scholar
- 2.Burnett, M., Cook, C., Rothermel, G.: End User Software Engineering. Communications of the ACM 47(9) (September 2004)Google Scholar
- 3.Panko, R.: What We Know About Spreadsheet Errors. Journal of End User Computing 10(2), 15–21 (Spring 1998)Google Scholar