A Structured Methodology for Spreadsheet Modelling
| dc.creator | Knight, Brian | |
| dc.creator | Chadwick, David | |
| dc.creator | Rajalingham, Kamalesen | |
| dc.date | 2008-05-27 | |
| dc.date.accessioned | 2026-07-07T09:41:15Z | |
| dc.date.available | 2026-07-07T09:41:15Z | |
| dc.description | 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. | |
| dc.description | 8 Pages, 7 Figures | |
| dc.identifier | https://arxiv.org/abs/0805.4218 | |
| dc.identifier | http://arxiv.org/abs/0805.4218 | |
| dc.identifier | Proc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2000 43-50 ISBN:1 86166 158 4 | |
| dc.identifier.uri | http://salesiana.dossiersoluciones.com/handle/123456789/161765 | |
| dc.subject | Software Engineering | |
| dc.subject | D.1.7; D.2.1; D.2.11; D.3.2; D.3.3; H.4.1; K.6.4; K.8.1 | |
| dc.title | A Structured Methodology for Spreadsheet Modelling | |
| dc.type | text |