• Corpus ID: 8187152

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

  title={Effect of Range Naming Conventions on Reliability and Development Time for Simple Spreadsheet Formulas},
  author={Ruth McKeever and Kevin McDaid},
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

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

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

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

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

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

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.



An Exploratory Analysis of the Impact of Named Ranges on the Debugging Performance of Novice Users

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

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

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

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?

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

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

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

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

This tutorial helps you to learn how to use a naming system called "named ranges" to make formulas easier to write and to read.