Effect of Range Naming Conventions on Reliability and Development Time for Simple Spreadsheet Formulas

Practitioners often argue that range names make spreadsheets easier to understand and use, akin to the role of good variable names in traditional programming languages, yet there is no supporting scientific evidence. The authors previously published experiments that disproved this theory in relation to debugging, and now turn their focus to development. This paper presents the results of two iterations of a new experiment, which measure the effect of range names on the correctness of, and the time it takes to develop, simple summation formulas. Our findings, supported by statistically significant results, show that formulas developed by non-experts using range names are more likely to contain errors and take longer to develop. Taking these findings with the findings from previous experiments, we conclude that range names do not improve the quality of spreadsheets developed by novice and intermediate users. This paper is important in that it finds that the choice of naming convention can have a significant impact on novice and intermediate users' performance in formula development, with less structured naming conventions resulting in poorer performance by users.

[1]  Mark G. Simkin,et al.  Factors Affecting the Ability to Detect Spreadsheet Errors , 2006 .

[2]  Michael Purser,et al.  Does an awareness of differing types of spreadsheet errors aid end-users in identifying spreadsheets errors? , 2008, ArXiv.

[3]  Raymond R. Panko,et al.  Reducing Overconfidence in Spreadsheet Development , 2008, ArXiv.

[4]  Thomas A. Grossman,et al.  The Lookup Technique to Replace Nested-IF Formulas in Spreadsheet Programming , 2009, ArXiv.

[5]  Dennis F. Galletta,et al.  An empirical study of spreadsheet error-finding performance , 1993 .

[6]  Philip L. Bewig.  In Excel, Cell Names Spell Speed, Safety: Give a Cell a Name, and Your Work Will Go Faster and Be More Error-Free , 2003 .

[7]  Neil C. Rowe.  Naming in programming , 1985 .

[8]  Gregg Rothermel,et al.  End-user software engineering , 2004, Commun. ACM.

[9]  Daniel Keller.  A guide to natural naming , 1990, SIGP.

[10]  Kevin McDaid,et al.  Spreadsheet End-User Behaviour Analysis , 2008, ArXiv.

[11]  Raymond R. Panko,et al.  Spreadsheets on trial: a survey of research on spreadsheet risks , 1996, Proceedings of HICSS-29: 29th Hawaii International Conference on System Sciences.

[12]  Grenville J. Croll.  The Importance and Criticality of Spreadsheets in the City of London , 2007, ArXiv.

[13]  Kevin McDaid,et al.  An Empirical Study of End-User Behaviour in Spreadsheet Debugging , 2008 .

[14]  Kevin McDaid,et al.  An Exploratory Analysis of the Impact of Named Ranges on the Debugging Performance of Novice Users , 2009, ArXiv.