Standard

The Effect of Delocalized Plans on Spreadsheet Comprehension : A Controlled Experiment. / Jansen, Bas; Hermans, Felienne.

2017 IEEE 25th International Conference on Program Comprehension (ICPC): Proceedings. ed. / R. Bilof. Piscataway, NJ : IEEE, 2017. p. 286-296 7961525.

Research output: Chapter in Book/Report/Conference proceedingConference contributionScientificpeer-review

Harvard

Jansen, B & Hermans, F 2017, The Effect of Delocalized Plans on Spreadsheet Comprehension: A Controlled Experiment. in R Bilof (ed.), 2017 IEEE 25th International Conference on Program Comprehension (ICPC): Proceedings., 7961525, IEEE, Piscataway, NJ, pp. 286-296, ICPC 2017, Buenos Aires, Argentina, 22/05/17. https://doi.org/10.1109/ICPC.2017.40

APA

Jansen, B., & Hermans, F. (2017). The Effect of Delocalized Plans on Spreadsheet Comprehension: A Controlled Experiment. In R. Bilof (Ed.), 2017 IEEE 25th International Conference on Program Comprehension (ICPC): Proceedings (pp. 286-296). [7961525] Piscataway, NJ: IEEE. https://doi.org/10.1109/ICPC.2017.40

Vancouver

Jansen B, Hermans F. The Effect of Delocalized Plans on Spreadsheet Comprehension: A Controlled Experiment. In Bilof R, editor, 2017 IEEE 25th International Conference on Program Comprehension (ICPC): Proceedings. Piscataway, NJ: IEEE. 2017. p. 286-296. 7961525 https://doi.org/10.1109/ICPC.2017.40

Author

Jansen, Bas ; Hermans, Felienne. / The Effect of Delocalized Plans on Spreadsheet Comprehension : A Controlled Experiment. 2017 IEEE 25th International Conference on Program Comprehension (ICPC): Proceedings. editor / R. Bilof. Piscataway, NJ : IEEE, 2017. pp. 286-296

BibTeX

@inproceedings{1dbbe87c6bec4becabcc9cb14238ed05,
title = "The Effect of Delocalized Plans on Spreadsheet Comprehension: A Controlled Experiment",
abstract = "Spreadsheets are widely used in industry. Spreadsheets also suffer from typical software engineering issues. Previous research shows that they contain code smells, lack documentation and tests, and have a long live span during which they are transferred multiple times among users. These transfers highlight the importance of spreadsheet comprehension. Therefore, in this paper, we analyze the effect of the organization of formulas on spreadsheet comprehension. To that end, we conduct a controlled experiment with 107 spreadsheet users, divided into two groups. One group receives a model where the formulas are organized such that all related components are grouped closely together, while the other group receives a model where the components are spread far and wide across the spreadsheet. All subjects perform the same set of comprehension tasks on their spreadsheet. The results indicate that the way formulas are located relative to each other in a spreadsheet, influences the performance of the subjects in their ability to comprehend and adapt the spreadsheet. Especially for the comprehension tasks, the subjects perform better on the model where the formulas were grouped closely together. For the adaptation tasks, we found that the length of the calculation chain influences the performance of the subjects more than the location of the formulas itself.",
keywords = "comprehension, controlled experiment, delocalized plans, end user programming, Feature Envy, locality, maintenance, spreadsheets",
author = "Bas Jansen and Felienne Hermans",
year = "2017",
month = "6",
day = "28",
doi = "10.1109/ICPC.2017.40",
language = "English",
isbn = "978-1-5386-0536-3",
pages = "286--296",
editor = "R. Bilof",
booktitle = "2017 IEEE 25th International Conference on Program Comprehension (ICPC)",
publisher = "IEEE",
address = "United States",

}

RIS

TY - GEN

T1 - The Effect of Delocalized Plans on Spreadsheet Comprehension

T2 - A Controlled Experiment

AU - Jansen, Bas

AU - Hermans, Felienne

PY - 2017/6/28

Y1 - 2017/6/28

N2 - Spreadsheets are widely used in industry. Spreadsheets also suffer from typical software engineering issues. Previous research shows that they contain code smells, lack documentation and tests, and have a long live span during which they are transferred multiple times among users. These transfers highlight the importance of spreadsheet comprehension. Therefore, in this paper, we analyze the effect of the organization of formulas on spreadsheet comprehension. To that end, we conduct a controlled experiment with 107 spreadsheet users, divided into two groups. One group receives a model where the formulas are organized such that all related components are grouped closely together, while the other group receives a model where the components are spread far and wide across the spreadsheet. All subjects perform the same set of comprehension tasks on their spreadsheet. The results indicate that the way formulas are located relative to each other in a spreadsheet, influences the performance of the subjects in their ability to comprehend and adapt the spreadsheet. Especially for the comprehension tasks, the subjects perform better on the model where the formulas were grouped closely together. For the adaptation tasks, we found that the length of the calculation chain influences the performance of the subjects more than the location of the formulas itself.

AB - Spreadsheets are widely used in industry. Spreadsheets also suffer from typical software engineering issues. Previous research shows that they contain code smells, lack documentation and tests, and have a long live span during which they are transferred multiple times among users. These transfers highlight the importance of spreadsheet comprehension. Therefore, in this paper, we analyze the effect of the organization of formulas on spreadsheet comprehension. To that end, we conduct a controlled experiment with 107 spreadsheet users, divided into two groups. One group receives a model where the formulas are organized such that all related components are grouped closely together, while the other group receives a model where the components are spread far and wide across the spreadsheet. All subjects perform the same set of comprehension tasks on their spreadsheet. The results indicate that the way formulas are located relative to each other in a spreadsheet, influences the performance of the subjects in their ability to comprehend and adapt the spreadsheet. Especially for the comprehension tasks, the subjects perform better on the model where the formulas were grouped closely together. For the adaptation tasks, we found that the length of the calculation chain influences the performance of the subjects more than the location of the formulas itself.

KW - comprehension

KW - controlled experiment

KW - delocalized plans

KW - end user programming

KW - Feature Envy

KW - locality

KW - maintenance

KW - spreadsheets

UR - http://www.scopus.com/inward/record.url?scp=85025116103&partnerID=8YFLogxK

U2 - 10.1109/ICPC.2017.40

DO - 10.1109/ICPC.2017.40

M3 - Conference contribution

SN - 978-1-5386-0536-3

SP - 286

EP - 296

BT - 2017 IEEE 25th International Conference on Program Comprehension (ICPC)

A2 - Bilof, R.

PB - IEEE

CY - Piscataway, NJ

ER -

ID: 45795549