Test-Driven development: can it work for spreadsheet engineering?

  • Authors:
  • Alan Rust;Brian Bishop;Kevin McDaid

  • Affiliations:
  • Department of Computing and Mathematics, Dundalk Institute of Technology, Dundalk, Co. Louth, Ireland;Department of Computing and Mathematics, Dundalk Institute of Technology, Dundalk, Co. Louth, Ireland;Department of Computing and Mathematics, Dundalk Institute of Technology, Dundalk, Co. Louth, Ireland

  • Venue:
  • XP'06 Proceedings of the 7th international conference on Extreme Programming and Agile Processes in Software Engineering
  • Year:
  • 2006

Quantified Score

Hi-index 0.00

Visualization

Abstract

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.