Detecting Errors in Spreadsheets

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 the inherent properties of spreadsheets as much into account 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 a layout focussed, geometrical nature.

• Type: Journal
• Year: 2008
• Where: CORR
• Authors: Yirsaw Ayalew, Markus Clermont, Roland T. Mittermeir
• Keywords: Conceptual Model, CORR 2008, Education, Spreadsheet, Strategies