RANGE NAMES - A Risky Practice in Spreadsheet Development?

Ruth McKeever; Kevin McDaid

Research.Publish.Connect.

Title:
ISBN:
Year:
Acronym:
Subject:

Advanced Search Proceedings Search

If you're looking for an exact phrase use quotation marks on text fields.

Title:
Author:
Affiliation:
Subject:

Advanced Search Papers Search

If you're looking for an exact phrase use quotation marks on text fields.

Name:
Affiliation:
Country:
Conference:
Subject:

Advanced Search Authors Search

If you're looking for an exact phrase use quotation marks on text fields.

Name:
Country:
Subject:

Advanced Search Affiliations Search

If you're looking for an exact phrase use quotation marks on text fields.

Proceedings

Proceedings Search

Title:
ISBN:
Year:
Acronym:
Subject:

Advanced Search Proceedings Search

If you're looking for an exact phrase use quotation marks on text fields.

Papers

Papers Search

Title:
Author:
Affiliation:
Subject:

Advanced Search Papers Search

If you're looking for an exact phrase use quotation marks on text fields.

Authors

Authors Search

Name:
Affiliation:
Country:
Conference:
Subject:

Advanced Search Authors Search

If you're looking for an exact phrase use quotation marks on text fields.

Advanced Search

Paper

RANGE NAMES - A Risky Practice in Spreadsheet Development?

Topics: Information Quality

In Proceedings of the 6th International Conference on Software and Database Technologies - Volume 1: ICSOFT, 269-274, 2011 , Seville, Spain

Authors: Ruth McKeever and Kevin McDaid

Affiliation: Dundalk Institute of Technology, Ireland

Keyword(s): Spreadsheets.

Related Ontology Subjects/Areas/Topics: Data Engineering ; Data Management and Quality ; Information Quality

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.

CC BY-NC-ND 4.0

Guest: Register as new SciTePress user now for free.

SciTePress user: please login.

My Papers

You are not signed in, therefore limits apply to your IP address 3.17.6.75

In the current month:

Recent papers: 100 available of 100 total

2⁺ years older papers: 200 available of 200 total

Paper citation in several formats:

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; ISSN 2184-2833, SciTePress, pages 269-274. DOI: 10.5220/0003510202690274

@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},
issn={2184-2833},
}

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
IS - 2184-2833
AU - McKeever, R.
AU - McDaid, K.
PY - 2011
SP - 269
EP - 274
DO - 10.5220/0003510202690274
PB - SciTePress