GoalDebug: A Spreadsheet Debugger for End Users

	This Article
	Subscribers, please Login Purchase article: $19 PDF IEEE Xplore Subscribers RSS feed
	Share
	Email this Article to a friend
	Bibliographic References
	ASCII Text BibTex RefWorks Procite/RefMan/Endnote
	Add to:
	Digg Furl Spurl Blink Simpy Google Del.icio.us Y!MyWeb
	Search
	Similar Articles Articles by Robin Abraham Articles by Martin Erwig

29th International Conference on Software Engineering (ICSE'07)

Minneapolis, Minnesota

May 20-May 26

ISBN: 0-7695-2828-7

	ASCII Text	x
	Robin Abraham, Martin Erwig, "GoalDebug: A Spreadsheet Debugger for End Users," Software Engineering, International Conference on, pp. 251-260, 29th International Conference on Software Engineering (ICSE'07), 2007.

	BibTex	x
	@article{ 10.1109/ICSE.2007.39, author = {Robin Abraham and Martin Erwig}, title = {GoalDebug: A Spreadsheet Debugger for End Users}, journal ={Software Engineering, International Conference on}, volume = {0}, year = {2007}, issn = {0270-5257}, pages = {251-260}, doi = {http://doi.ieeecomputersociety.org/10.1109/ICSE.2007.39}, publisher = {IEEE Computer Society}, address = {Los Alamitos, CA, USA}, }

	RefWorks Procite/RefMan/Endnote	x
	TY - CONF JO - Software Engineering, International Conference on TI - GoalDebug: A Spreadsheet Debugger for End Users SN - 0270-5257 SP251 EP260 A1 - Robin Abraham, A1 - Martin Erwig, PY - 2007 KW - null VL - 0 JA - Software Engineering, International Conference on ER -

Robin Abraham, Oregon State University, USA

Martin Erwig, Oregon State University, USA

DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICSE.2007.39

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.

Citation:

Robin Abraham, Martin Erwig, "GoalDebug: A Spreadsheet Debugger for End Users," icse, pp.251-260, 29th International Conference on Software Engineering (ICSE'07), 2007

Peer Review Notice | Give Us Feedback

Usage of this product signifies your acceptance of the Terms of Use.