RANGE NAMES - A Risky Practice in Spreadsheet Development?

Ruth McKeever, Kevin McDaid

2011

Abstract

The use of range names to improve spreadsheet development is advocated by both academics and practitioners, however there is a clear absence of supporting scientific evidence. This paper describes the latest in a series of experiments that examine the impact of range name structures on spreadsheet reliability, and formula development time. The aim of this paper is to compare the reliability of simple spreadsheet formulas developed by intermediate users through both cell references and range names. The results are consistent with the findings of previous experiments that, contrary to widespread opinion, the use of range names does not improve the quality of spreadsheets.

References

  1. Baker, K. R., Foster-Johnson, L., Lawson, B. & Powell, S. G. 2006. A Survey of MBA Spreadsheet Users.
  2. Baker, K. R., Foster-Johnson, L., Lawson, B. & Powell, S. G. 2006. A Survey of MBA Spreadsheet Users.
  3. Bishop, B. & McDaid, D. K. 2007. An Empirical Study of End-User Behaviour in Spreadsheet Debugging. PPIG. Salford 2007.
  4. Bishop, B. & McDaid, D. K. 2007. An Empirical Study of End-User Behaviour in Spreadsheet Debugging. PPIG. Salford 2007.
  5. Blood, A. T. 2006. Elements of Good Spreadsheet Design: Spreadsheet Design Notes [Online]. Available: http://www.xl-logic.com/modules.php?name=Content &pa=showpage&pid=2 [Accessed May 2009].
  6. Blood, A. T. 2006. Elements of Good Spreadsheet Design: Spreadsheet Design Notes [Online]. Available: http://www.xl-logic.com/modules.php?name=Content &pa=showpage&pid=2 [Accessed May 2009].
  7. Burnett, M., Cook, C. & Rothermel, G. 2004. End-User Software Engineering. Communications of the ACM, 47, 53-58.
  8. Burnett, M., Cook, C. & Rothermel, G. 2004. End-User Software Engineering. Communications of the ACM, 47, 53-58.
  9. Croll, G. J. 2005. The Importance and Criticality of Spreadsheets in the City of London. EuSpRIG.
  10. Croll, G. J. 2005. The Importance and Criticality of Spreadsheets in the City of London. EuSpRIG.
  11. Howe, H. & Simkin, M. G. 2006. Factors Affecting the Ability to Detect Spreadsheet Errors. Decision Sciences Journal of Innovative Education, 4, 101-122.
  12. Howe, H. & Simkin, M. G. 2006. Factors Affecting the Ability to Detect Spreadsheet Errors. Decision Sciences Journal of Innovative Education, 4, 101-122.
  13. Jones, D. M. 2008. The New C Standard (Identifiers) An Economic and Cultural Commentary.
  14. Jones, D. M. 2008. The New C Standard (Identifiers) An Economic and Cultural Commentary.
  15. Keller, D. 1990. A Guide to Natural Naming. SIGPLAN notices, 25, 95-102.
  16. Keller, D. 1990. A Guide to Natural Naming. SIGPLAN notices, 25, 95-102.
  17. McKeever, R. & McDaid, K. 2010. How do Range Names Hinder Novice Debugging Performance? EuSpRIG. London.
  18. McKeever, R. & McDaid, K. 2010. How do Range Names Hinder Novice Debugging Performance? EuSpRIG. London.
  19. McKeever, R., McDaid, K. & Bishop, B. 2009. An Exploratory Analysis of the Impact of Named Ranges on the Debugging Performance of Novice Users. EuSpRIG. Paris, France.
  20. McKeever, R., McDaid, K. & Bishop, B. 2009. An Exploratory Analysis of the Impact of Named Ranges on the Debugging Performance of Novice Users. EuSpRIG. Paris, France.
  21. O'Beirne, P. 2005. Spreadsheet Check and Control: 47 key practices to detect and prevent errors, Gorey, Systems Publishing.
  22. O'Beirne, P. 2005. Spreadsheet Check and Control: 47 key practices to detect and prevent errors, Gorey, Systems Publishing.
  23. Panko, R. R. & Ordway, N. 2005. Sarbanes-Oxley: What About all the Spreadsheets? Controlling for Errors and Fraud in Financial Reporting. EuSpRIG.
  24. Panko, R. R. & Ordway, N. 2005. Sarbanes-Oxley: What About all the Spreadsheets? Controlling for Errors and Fraud in Financial Reporting. EuSpRIG.
  25. Pearson, C. H. 2009. Defined Names [Online]. Available: http://www.cpearson.com/Excel/named.htm [Accessed November 25 2008].
  26. Pearson, C. H. 2009. Defined Names [Online]. Available: http://www.cpearson.com/Excel/named.htm [Accessed November 25 2008].
  27. Powell, S. G., Baker, K. R. & Lawson, B. 2007. Errors in Operational Spreadsheets [Online]. Available: http://mba.tuck.dartmouth.edu/pages/faculty/steve.po well/publications.html [Accessed].
  28. Powell, S. G., Baker, K. R. & Lawson, B. 2007. Errors in Operational Spreadsheets [Online]. Available: http://mba.tuck.dartmouth.edu/pages/faculty/steve.po well/publications.html [Accessed].
  29. Purser, M. & Chadwick, D. 2006. Does an awareness of differing types of spreadsheet errors aid end-users in identifying spreadsheets errors? EuSpRIG.
  30. Purser, M. & Chadwick, D. 2006. Does an awareness of differing types of spreadsheet errors aid end-users in identifying spreadsheets errors? EuSpRIG.
  31. Scaffidi, C., Shaw, M. & Myers, B. 2005. The “55M EndUser Programmers” Estimate Revisited. Pittsburgh,: Institute for Software Research Human-Computer Interaction Institute.
  32. Scaffidi, C., Shaw, M. & Myers, B. 2005. The “55M EndUser Programmers” Estimate Revisited. Pittsburgh,: Institute for Software Research Human-Computer Interaction Institute.
Download


Paper Citation


in Harvard Style

McKeever R. and McDaid K. (2011). RANGE NAMES - A Risky Practice in Spreadsheet Development? . In Proceedings of the 6th International Conference on Software and Database Technologies - Volume 1: ICSOFT, ISBN 978-989-8425-76-8, pages 269-274. DOI: 10.5220/0003510202690274


in Harvard Style

McKeever R. and McDaid K. (2011). RANGE NAMES - A Risky Practice in Spreadsheet Development? . In Proceedings of the 6th International Conference on Software and Database Technologies - Volume 1: ICSOFT, ISBN 978-989-8425-76-8, pages 269-274. DOI: 10.5220/0003510202690274


in Bibtex Style

@conference{icsoft11,
author={Ruth McKeever and Kevin McDaid},
title={RANGE NAMES - A Risky Practice in Spreadsheet Development?},
booktitle={Proceedings of the 6th International Conference on Software and Database Technologies - Volume 1: ICSOFT,},
year={2011},
pages={269-274},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003510202690274},
isbn={978-989-8425-76-8},
}


in Bibtex Style

@conference{icsoft11,
author={Ruth McKeever and Kevin McDaid},
title={RANGE NAMES - A Risky Practice in Spreadsheet Development?},
booktitle={Proceedings of the 6th International Conference on Software and Database Technologies - Volume 1: ICSOFT,},
year={2011},
pages={269-274},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003510202690274},
isbn={978-989-8425-76-8},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 6th International Conference on Software and Database Technologies - Volume 1: ICSOFT,
TI - RANGE NAMES - A Risky Practice in Spreadsheet Development?
SN - 978-989-8425-76-8
AU - McKeever R.
AU - McDaid K.
PY - 2011
SP - 269
EP - 274
DO - 10.5220/0003510202690274


in EndNote Style

TY - CONF
JO - Proceedings of the 6th International Conference on Software and Database Technologies - Volume 1: ICSOFT,
TI - RANGE NAMES - A Risky Practice in Spreadsheet Development?
SN - 978-989-8425-76-8
AU - McKeever R.
AU - McDaid K.
PY - 2011
SP - 269
EP - 274
DO - 10.5220/0003510202690274