Quality Control in Spreadsheets: A Software Engineering-Based Approach to Spreadsheet Development

Authors:
Kamalasen Rajalingham;David Chadwick;Brian Knight;Dilwyn Edwards
Affiliations:
-;-;-;-
Venue:
HICSS '00 Proceedings of the 33rd Hawaii International Conference on System Sciences-Volume 4 - Volume 4
Year:
2000

Citing 0
Cited 11

A generalised spreadsheet verification methodology

ACSC '02 Proceedings of the twenty-fifth Australasian conference on Computer science - Volume 4
Inferring templates from spreadsheets

Proceedings of the 28th international conference on Software engineering
Type inference for spreadsheets

Proceedings of the 8th ACM SIGPLAN international conference on Principles and practice of declarative programming
The role of spreadsheet knowledge in user-developed application success

Decision Support Systems
UCheck: A spreadsheet type checker for end users

Journal of Visual Languages and Computing
GoalDebug: A Spreadsheet Debugger for End Users

ICSE '07 Proceedings of the 29th international conference on Software Engineering
The fourth workshop on end-user software engineering

Companion of the 30th international conference on Software engineering
Test-driven development: can it work for spreadsheets?

Proceedings of the 4th international workshop on End-user software engineering
Automatic detection of dimension errors in spreadsheets

Journal of Visual Languages and Computing
Reasoning about spreadsheets with labels and dimensions

Journal of Visual Languages and Computing
Systematic evolution of model-based spreadsheet applications

Journal of Visual Languages and Computing

Quantified Score

Hi-index	0.00

Visualization

Abstract

This paper presents work conducted towards the development of an effective software engineering-based methodology for integrity control in the process of spreadsheet development. Various approaches and concepts within the discipline of software engineering are investigated. The proposed methodology consists of a set of coherent stages incorporating relevant software engineering techniques and principles. The framework for spreadsheet quality control is mainly aimed at addressing the widespread problem of spreadsheet errors. This paper elaborately discusses the application of relevant software engineering techniques and principles in the construction of spreadsheet models, accompanied and supported by appropriate examples. The principles and techniques of tree-based formula representation, unique definition of spreadsheet elements and separation of data and operations, are among the main features explored.