Abstract:Spreadsheets are very common for information processing to support decision making by both professional developers and non-technical end users. Moreover, business intelligence and artificial intelligence are increasingly popular in the industry nowadays, where spreadsheets have been used as, or integrated into, intelligent or expert systems in various application domains. However, it has been repeatedly reported that faults often exist in operational spreadsheets, which could severely compromise the quality of conclusions and decisions based on the spreadsheets. With a view to systematically examining this problem via survey of existing work, we have conducted a comprehensive literature review on the quality issues and related techniques of spreadsheets over a 35.5-year period (from January 1987 to June 2022) for target journals and a 10.5-year period (from January 2012 to June 2022) for target conferences. Among other findings, two major ones are: (a) Spreadsheet quality is best addressed throughout the whole spreadsheet life cycle, rather than just focusing on a few specific stages of the life cycle. (b) Relatively more studies focus on spreadsheet testing and debugging (related to fault detection and removal) when compared with spreadsheet specification, modeling, and design (related to development). As prevention is better than cure, more research should be performed on the early stages of the spreadsheet life cycle. Enlightened by our comprehensive review, we have identified the major research gaps as well as highlighted key research directions for future work in the area.

A Paradigm for Spreadsheet Engineering Methodologies

Spreadsheets Grow Up: Three Spreadsheet Engineering Methodologies for Large Financial Planning Models

Comparison of Spreadsheets with other Development Tools (limitations, solutions, workarounds and alternatives)

Spreadsheet Development Methodologies using Resolver: Moving spreadsheets into the 21st Century

Integrating Spreadsheet Engineering in a Management Science Course: A Hierarchical Approach

Multidisciplinary Engineering Models: Methodology and Case Study in Spreadsheet Analytics

A Use Case-Engineering Resources Taxonomy for Analytical Spreadsheet Models

Characteristics of Spreadsheets Developed with the SSMI Methodology

Requirements for Automated Assessment of Spreadsheet Maintainability

A Spreadsheet Auditing Tool Evaluated in an Industrial Context

Spreadsheet quality assurance: a literature review

A Structured Approach to the development of Solutions in Excel

Spreadsheet Errors: What We Know. What We Think We Can Do

Consensus-Free Spreadsheet Integration

The Semantic Spreadsheet

Automating Spreadsheet Discovery & Risk Assessment

From Good Practices to Effective Policies for Preventing Errors in Spreadsheets

Documenting Spreadsheets with Pseudo-Code: an Exercise with Cash-Flow and Loans

Developing a Repeating Model Using the Structured Spreadsheet Modelling and Implementation Methodology

Towards the Design and Implementation of Aspect-Oriented Programming for Spreadsheets

The Paradox of Spreadsheet Self-Efficacy: Social Incentives for Informal Knowledge Sharing in End-User Programming