A Structured Methodology for Spreadsheet Modelling
Abstract
In this paper, we discuss the problem of the software engineering of a class of business spreadsheet models. A methodology for structured software development is proposed, which is based on structured analysis of data, represented as Jackson diagrams. It is shown that this analysis allows a straightforward modularisation, and that individual modules may be represented with indentation in the block-structured form of structured programs. The benefits of structured format are discussed, in terms of comprehensibility, ease of maintenance, and reduction in errors. The capability of the methodology to provide a modular overview in the model is described, and examples are given. The potential for a reverse-engineering tool, to transform existing spreadsheet models is discussed.
- Publication:
-
arXiv e-prints
- Pub Date:
- May 2008
- DOI:
- 10.48550/arXiv.0805.4218
- arXiv:
- arXiv:0805.4218
- Bibcode:
- 2008arXiv0805.4218K
- Keywords:
-
- Computer Science - Software Engineering;
- D.1.7;
- D.2.1;
- D.2.11;
- D.3.2;
- D.3.3;
- H.4.1;
- K.6.4;
- K.8.1
- E-Print:
- 8 Pages, 7 Figures