• Corpus ID: 8187152

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

@article{McKeever2011EffectOR,
  title={Effect of Range Naming Conventions on Reliability and Development Time for Simple Spreadsheet Formulas},
  author={Ruth McKeever and Kevin McDaid},
  journal={ArXiv},
  year={2011},
  volume={abs/1111.6872}
}
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. [] Key Result 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.

Tables from this paper

Investigating Effects of Common Spreadsheet Design Practices on Correctness and Maintainability
TLDR
Analysis of the obtained spreadsheets indicates that the correctness of "bottom-line" results is not affected by the observance of the three Best Practices, however, initially correct spreadsheets with high observances of these Best Practices tend to be the ones whose later modifications yield the most correct results.
A Structured Approach to the development of Solutions in Excel
TLDR
This paper considers the use of controversial or lesser-used techniques to create a coherent solution strategy in which the problem is solved by a sequence of formulas resembling the steps of a programmed language.
Structured Spreadsheet Modeling and Implementation
TLDR
This paper presents a methodology that separates the modeling from the implementation, using proven techniques from Information Systems and Software Engineering, and presents strict, but simple, rules governing the implementation from the model.
Enron's Spreadsheets and Related Emails: A Dataset and Analysis
TLDR
An analysis of a new dataset, extracted from the Enron email archive, containing over 15,000 spreadsheets used within the Enrock Corporation, shows that the spreadsheets are substantially more smelly than the EUSES corpus, especially in terms of long calculation chains.
Characteristics of Spreadsheets Developed with the SSMI Methodology
TLDR
The major characteristics of the spreadsheets developed using the SSMI methodology are described and how they contribute to reduce many error causing factors are shown.
Google Sheets v Microsoft Excel: A Comparison of the Behaviour and Performance of Spreadsheet Users
TLDR
A paradigm shift has occurred in the way users utilise the collaborative sharing and communication of their work in both an educational and business environment and Cloud based spreadsheet technologies have only started to be investigated in relation to user behaviour and performance.

References

SHOWING 1-10 OF 35 REFERENCES
An Exploratory Analysis of the Impact of Named Ranges on the Debugging Performance of Novice Users
TLDR
It is suggested that novice users debug on average significantly fewer errors if the spreadsheet contains named ranges, and this paper describes an exploratory empirical study of the effect of named ranges on spreadsheet debugging performance.
The Lookup Technique to Replace Nested-IF Formulas in Spreadsheet Programming
TLDR
The "lookup technique" is investigated as an alternative to nested-IF formulas, its benefits for testing and auditing, and its limitations are described.
Naming in programming
TLDR
Examples of good naming in the language Logo, a language in which naming (with the TO construct) is a central metaphor for the programmer's activity, are given.
A guide to natural naming
TLDR
The naming scheme described in this paper is a set of hints and guidelines on how to select names in a procedural programming language that is perceived as a real aid in finding good names, not as a restricting set of rules.
Does an awareness of differing types of spreadsheet errors aid end-users in identifying spreadsheets errors?
TLDR
A valid, and simplified, revision of previous spreadsheet error classifications is established and it is shown that spreadsheet error-type awareness significantly improves the user’s ability to identify, the more surreptitious, qualitative error.
An Empirical Study of End-User Behaviour in Spreadsheet Debugging
TLDR
The current ongoing experiment designed to record and analyse the behaviour of industry professionals in the debugging of spreadsheets will enhance the understanding of software debugging in general, and the spreadsheet debugging process in particular.
Spreadsheet End-User Behaviour Analysis
TLDR
The design and application of a novel data acquisition tool, which can be used for the unobtrusive recording of end-users mouse, keyboard and Excel specific actions during the debugging of Excel spreadsheets, and developed a "spreadsheet cell coverage feedback" debugging tool.
End-user software engineering
TLDR
This work has been investigating ways to address the problem of dependability in end-user programming by developing a software engineering paradigm viable for end- user programming, an approach it is called end-users software engineering.
In Excel, Cell Names Spell Speed, Safety: Give a Cell a Name, and Your Work Will Go Faster and Be More Error-Free
TLDR
This tutorial helps you to learn how to use a naming system called "named ranges" to make formulas easier to write and to read.
...
...