• Corpus ID: 17163153

A Structured Methodology for Spreadsheet Modelling

  title={A Structured Methodology for Spreadsheet Modelling},
  author={Brian Knight and David R. Chadwick and Kamalasen Rajalingham},
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… 

Figures from this paper

An Evaluation of a Structured Spreadsheet Development Methodology
An empirical evaluation of the quality of a structured methodology for the development of spreadsheet models, proposed in numerous previous papers by Rajalingham K, Knight B and Chadwick D et al, and an improved version of their methodology, supported by appropriate examples are presented.
A Semantic Meta Model of Spreadsheets
This paper proposes a meta model which defines how the semantic models of today’s spreadsheets can be described, and builds on the foundations of related approaches to model-driven spreadsheet development, and also captures semantic patterns of spreadsheets typically occurring in practice.
Analyzing and Visualizing Spreadsheets
This dissertation aims at developing methods to support spreadsheet users to understand, update and improve spreadsheets and found that methods from software engineering can be applied to spreadsheets very well, and that these methods support end-users in working with spreadsheets.
Gathering domain knowledge from spreadsheets
  • F. Hermans
  • Computer Science, Business
    ESEC/FSE Doctoral Symposium '09
  • 2009
This research will investigate how software engineering techniques, like reverse engineering and data mining, can be applied to spreadsheets to develop means to formalize spreadsheets.
A Spreadsheet Auditing Tool Evaluated in an Industrial Context
The evaluated auditing tool offers the auditor a new view on the formula structure of the spreadsheet by grouping similar formulas into equivalence classes, and the auditing approach helps to find irregularities in the geometrical pattern of similar formulas.
Automatically Extracting Class Diagrams from Spreadsheets
This work creates a library of common spreadsheet usage patterns that are localized in the spreadsheet using a two- dimensional parsing algorithm and transformed and enriched with information from the library to automatically extract information and transform it into class diagrams.
Multi-Paradigm Spreadsheet for End Users
This work introduces a multi-paradigm spreadsheet that allows end users to analyze their problems and design for the solutions, and supports object-oriented programming, flowchart, XML, and spreadsheet.
Research on Enterprise Spreadsheet Model Based-on Semantic
This paper presents a semantic based enterprise spreadsheet model to improve the spreadsheet template modifiability, data presentation ability and domain applicability, and the principle is to
Spreadsheet Auditing Software
This paper documents and tests office software tools designed to assist in the audit of spreadsheets to identify the success of software tools in detecting different types of errors, to identify how the software tools assist the auditor and to determine the usefulness of the tools.
Structured Spreadsheet Modelling and Implementation with Multiple Dimensions - Part 1: Modelling
This chapter focuses on the time dimension, which is an integral part of many models the authors use every day and which many financial and accounting spreadsheets have columns representing months or years.


On the criteria to be used in decomposing systems into modules
This paper discusses modularization as a mechanism for improving the flexibility and comprehensibility of a system while allowing the shortening of its development time. The effectiveness of a
Structured programming
The first monograph has suggested that in analysing a problem and groping towards a solution, a programmer should take advantage of abstract concepts such as sets, sequences, and mappings; and judiciously postpone decisions on representation until he is constructing the more detailed code of the program.
Principles of program design
This book is about programming for data processing applications, and its purpose is to present a coherent method and procedure for designing systems, programs, and components that are transparently simple and self-evidently correct.
The entity-relationship model: toward a unified view of data
A data model, called the entity-relationship model, is proposed that incorporates some of the important semantic information in the real world and can be used as a basis for unification of different views of data: the network model, the relational model, and the entity set model.
Stop that Subversive Spreadsheet!
This paper documents the formation of the European Spreadsheet Risks Interest Group (EuSpRIG www.eusprig.org) and outlines some of the research undertaken and reported upon by interested parties in
Structured requirements definition
Stop the Subversive Spreadsheet " , Internal Auditing and Business Risk magazine, Institute of Internal Auditors United Kingdom
  • Stop the Subversive Spreadsheet " , Internal Auditing and Business Risk magazine, Institute of Internal Auditors United Kingdom
  • 2000
IBM Systems Journal
  • IBM Systems Journal
  • 1974