i-nth logo

Authors

Yirsaw Ayalew, Markus Clermont, & Roland Mittermeir

Abstract

The paper presents two complementary strategies for identifying errors in spreadsheet programs. The strategies presented are grounded on the assumption that spreadsheets are software, albeit of a different nature than conventional procedural software.

Correspondingly, strategies for identifying errors have to take into account the inherent properties of spreadsheets as much as they have to recognize that the conceptual models of "spreadsheet programmers" differ from the conceptual models of conventional programmers.

Nevertheless, nobody can and will write a spreadsheet, without having such a conceptual model in mind, be it of numeric nature or be it of geometrical nature focused on some layout.

Sample

Conventional program vs. spreadsheet development process
Conventional program vs. spreadsheet development process

As spreadsheet systems are easy to use, do not require much training in formal methods of designing and programming, and show – in contrast to conventional programs – the results of the effort while the development effort is still in progress, they are also written in a style different from conventional software.

There is a notion of immediate feedback once the contents of a cell is specified. This easy way to quick feedback leads to a development style of trial & error, cutting & pasting, copying & modifying; a mixture that has to be horrifying for an orderly software methodologist.

Publication

2000, EuSpRIG

Full article

Detecting errors in spreadsheets