How to communicate unit error messages in spreadsheets

How to communicate unit error messages in spreadsheets (2005)

Cached

Download Links

Other Repositories/Bibliography

DBLP

by Robin Abraham , Martin Erwig

Venue:	In WEUSE I: Proceedings of the first workshop on End-user software engineering
Citations:	6 - 3 self

Versions

Version History

Metadata Version 1

Datum	Value	Source
TITLE	How to communicate unit error messages in spreadsheets	INFERENCE
AUTHOR NAME	Robin Abraham	SVM HeaderParse 0.2
AUTHOR AFFIL	School of Electrical Engineering and Computer Science; Oregon State University	SVM HeaderParse 0.2
AUTHOR NAME	Martin Erwig	SVM HeaderParse 0.2
AUTHOR AFFIL	School of Electrical Engineering and Computer Science; Oregon State University	SVM HeaderParse 0.2
ABSTRACT	In previous work we have designed and implemented an automatic reasoning system for spreadsheets, called UCheck, that infers unit information for cells in a spreadsheet. Based on this unit information, UCheck can identify cells in the spreadsheet that contain erroneous formulas. However, the information about an erroneous cell is reported to the user currently in a rather crude way by simply coloring the cell, which does not tell anything about the nature of error and thus offers no help to the user as to how to fix it. In this paper we describe an extension of UCheck, called UFix, which improves the error messages reported to the spreadsheet user dramatically. The approach essentially consists of three steps: First, we identify different categories of spreadsheet errors from an end-user’s perspective. Second, we map units that indicate erroneous formulas to these error categories. Finally, we create customized error messages from the unit information and the identified error category. In many cases, these error messages also provide suggestions on how to fix the reported errors.	SVM HeaderParse 0.2
YEAR	2005	INFERENCE
VENUE	In WEUSE I: Proceedings of the first workshop on End-user software engineering	INFERENCE
VENUE TYPE	CONFERENCE	INFERENCE
PAGES	1--5	INFERENCE
VOLUME	3	INFERENCE
CITATIONS	7 found	ParsCit 1.0