Structured Spreadsheet Modeling and Implementation
This addresses the issue of spreadsheet errors for end-users, though it appears incremental as it adapts existing techniques to a specific domain.
The paper tackles the problem of developing error-free spreadsheets by introducing a methodology that separates modeling from implementation, applying strict rules from Information Systems and Software Engineering to make spreadsheets easier to understand, audit, and maintain.
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.