Can Named Ranges Improve the Debugging Performance of Novice Spreadsheet Users?

Ruth McKeever; Kevin McDaid; Brian Bishop

This paper analyses the suitability of certain refactoring methods, in particular those concerning naming, to spreadsheet development, and the effect they can have on both spreadsheet quality and the behaviour of novice end-users. Spreadsheets are normally developed by the end user, and are rarely designed beforehand. They are extremely error prone and often business critical. While naming of ranges in spreadsheets is a recommended best practice, there is little supporting research. This paper describes an experiment to investigate the impact of range names on the debugging performance of novice spreadsheet users.

Type of Publication: Paper
Conference: PPIG 2009 - 21st Annual Workshop
Publication Year: 2009
Paper #: 15
TitleCan Named Ranges Improve the Debugging Performance of Novice Spreadsheet Users?
Publication TypePaper
AuthorsMcKeever, R, McDaid, K, Bishop, B
PPIG Workshop: 
2009-06-21st