Spreadsheet Engineering: A Research Framework

Abstract

Spreadsheet engineering adapts the lessons of software engineering to spreadsheets, providing eight principles as a framework for organizing spreadsheet programming recommendations. Spreadsheets raise issues inadequately addressed by software engineering. Spreadsheets are a powerful modeling language, allowing strategic rapid model change, and enabling exploratory modeling. Spreadsheets users learn slowly with experience because they focus on the problem domain not programming. The heterogeneity of spreadsheet users requires a taxonomy to guide recommendations. Deployment of best practices is difficult and merits research.

12 Pages

References in corpus (1)

• Applying the CobiT Control Framework to Spreadsheet Developments

Cited by in corpus (13)

• The Importance and Criticality of Spreadsheets in the City of London
• A Paradigm for Spreadsheet Engineering Methodologies
• Spreadsheets Grow Up: Three Spreadsheet Engineering Methodologies for Large Financial Planning Models
• Investigating the Potential of Test-Driven Development for Spreadsheet Engineering
• Spreadsheets - the Good, the Bad and the Downright Ugly
• A Typical Model Audit Approach: Spreadsheet Audit Methodologies in the City of London
• Research Strategy and Scoping Survey on Spreadsheet Practices
• An Investigation of the Incidence and Effect of Spreadsheet Errors Caused by the Hard Coding of Input Data Values into Formulas
• Towards a Spreadsheet Engineering
• Spreadsheets in Clinical Medicine
• Excel Modelling - Transparency, Auditing and Business Use
• Defending the future: An MSc module in End User Computing Risk Management
• Semi-structured data extraction and modelling: the WIA Project