Avoiding, finding and fixing spreadsheet errors – A survey of automated approaches for spreadsheet QA

• Spreadsheet applications are often developed by end users and are prone to errors.
• Our work provides a systematic review of automated approaches for spreadsheet QA.
• We propose a classification scheme to categorize the various approaches.
• We critically reflect on the current research practice in the field.

Spreadsheet programs can be found everywhere in organizations and they are used for a variety of purposes, including financial calculations, planning, data aggregation and decision making tasks. A number of research surveys have however shown that such programs are particularly prone to errors. Some reasons for the error-proneness of spreadsheets are that spreadsheets are developed by end users and that standard software quality assurance processes are mostly not applied. Correspondingly, during the last two decades, researchers have proposed a number of techniques and automated tools aimed at supporting the end user in the development of error-free spreadsheets. In this paper, we provide a review of the research literature and develop a classification of automated spreadsheet quality assurance (QA) approaches, which range from spreadsheet visualization, static analysis and quality reports, over testing and support to model-based spreadsheet development. Based on this review, we outline possible opportunities for future work in the area of automated spreadsheet QA.