Structured Spreadsheet Modeling and Implementation

2015/03/10 by Mireault, Paul
#FOS: Computer and information sciences #H.1 #H.4.1 #Software Engineering (cs.SE)

paper · doi:10.48550/arxiv.1503.03122

Abstract

Developing an error-free spreadsheet has been a problem since the beginning of end-user computing. In this paper, we present a methodology that separates the modeling from the implementation. Using proven techniques from Information Systems and Software Engineering, we present strict, but simple, rules governing the implementation from the model. The resulting spreadsheet should be easier to understand, audit and maintain.

Related

• Tabula: A Language to Model Spreadsheet Tables
• Exploiting Domain-Specific Structures For End-User Programming Support Tools
• A Methodology to Improve Dependability in Spreadsheets
• Spreadsheet Guardian: An Approach to Protecting Semantic Correctness throughout the Evolution of Spreadsheets
• An Empirical Study on End-users Productivity Using Model-based\n Spreadsheets