Product metrics for spreadsheets—A systematic review

Birgit Hofer, Dietmar Jannach, Patrick Koch, Konstantin Schekotihin, Franz Wotawa*

*Korrespondierende/r Autor/in für diese Arbeit

Publikation: Beitrag in einer FachzeitschriftArtikel

Abstract

Software product metrics allow practitioners to improve their products and to optimize development processes based on quantifiable characteristics of source code. To facilitate similar benefits for spreadsheet programs, researchers proposed various product metrics for spreadsheets over the last decades. However, to our knowledge, no comprehensive overview of those efforts is currently available. In this paper, we close this gap by conducting a literature review of research works that either inherently or explicitly define product metrics for spreadsheets. We scanned five major digital libraries for scientific papers that define or use spreadsheet product metrics. Based on the identified 37 papers, we created a novel catalog of product metrics for spreadsheets. The catalog can be used by practitioners and researchers as a central reference for spreadsheet product metrics. In the paper, we (i) describe the proposed metrics in detail, (ii) report how often and for what purposes the metrics are used, (iii) identify significant discrepancies in the naming and definition of the metrics, and (iv) investigate how the appropriateness of the metrics was evaluated.

Originalspracheenglisch
Aufsatznummer110910
FachzeitschriftJournal of Systems and Software
Jahrgang175
DOIs
PublikationsstatusVeröffentlicht - Mai 2021

ASJC Scopus subject areas

  • Software
  • Information systems
  • !!Hardware and Architecture

Fingerprint

Untersuchen Sie die Forschungsthemen von „Product metrics for spreadsheets—A systematic review“. Zusammen bilden sie einen einzigartigen Fingerprint.

Dieses zitieren