Authors
Robin Abraham & Martin Erwig
Abstract
We present a spreadsheet debugger targeted at end users. Whenever the computed output of a cell is incorrect, the user can supply an expected value for a cell, which is employed by the system to generate a list of change suggestions for formulas that, when applied, would result in the user-specified output. The change suggestions are ranked using a set of heuristics.
In previous work, we had presented the system as a proof of concept. In this paper, we describe a systematic evaluation of the effectiveness of inferred change suggestions and the employed ranking heuristics.
Based on the results of the evaluation we have extended both, the change inference process and the ranking of suggestions. An evaluation of the improved system shows that change inference process and the ranking heuristics have both been substantially improved and that the system performs effectively.
Sample
The full suite of mutation operators we have developed is shown in this table.
These operators can be used to model deviations from the correct spreadsheet.
Publication
2007, 29th IEEE International Conference on Software Engineering, May, pages 251-260
