Spreadsheet bibliography

Title Fault localization in the light of faulty user input
Authors Birgit Hofer & Franz Wotawa
Year 2015
Type Proceedings
Publication Software Quality, Reliability and Security
Series August, pages 282-291
Abstract

Spreadsheets may be large, containing several thousand formulas, and thus they may be hard to comprehend and analyze. Unfortunately, they are also prone to errors.

Identifying the cells which are responsible for an observed error is time-consuming, tedious, and frustrating. Spectrum-based Fault Localization (SFL) helps users to faster identify those cells that have to be modified in order to eliminate any observed misbehavior. SFL requires information about the correctness of certain cell values, and users might wrongly classify such cell values. A misclassification may influence the outcome of SFL substantially.

In this paper, we investigate the influence of incorrect user information on the quality of SFL. In particular, we present a theoretical analysis of the impact of a misclassification on the Ochiai similarity coefficient and an empirical evaluation based on 33 spreadsheets with 218 faulty versions.

Full version Not available
Also see Slides
Sample
To err is human
To err is human
Spreadsheet errors are surprisingly common, even for spreadsheets of a trivial size.
Example spreadsheet including an error
Example spreadsheet including an error
In this example, input cells are shaded in light blue, correct output values are given in green font, and faulty cells are shaded in red.