Standard

Detecting and Predicting Evolution in Spreadsheets : A Case Study in an Energy Network Company. / Jansen, Bas; Hermans, Felienne; Tazelaar, Edwin.

Software Maintenance and Evolution (ICSME), 2018 IEEE International Conference on. 2018.

Research output: Chapter in Book/Conference proceedings/Edited volumeConference contributionScientificpeer-review

Harvard

Jansen, B, Hermans, F & Tazelaar, E 2018, Detecting and Predicting Evolution in Spreadsheets: A Case Study in an Energy Network Company. in Software Maintenance and Evolution (ICSME), 2018 IEEE International Conference on. https://doi.org/10.1109/ICSME.2018.00074

APA

Jansen, B., Hermans, F., & Tazelaar, E. (2018). Detecting and Predicting Evolution in Spreadsheets: A Case Study in an Energy Network Company. In Software Maintenance and Evolution (ICSME), 2018 IEEE International Conference on https://doi.org/10.1109/ICSME.2018.00074

Vancouver

Jansen B, Hermans F, Tazelaar E. Detecting and Predicting Evolution in Spreadsheets: A Case Study in an Energy Network Company. In Software Maintenance and Evolution (ICSME), 2018 IEEE International Conference on. 2018 https://doi.org/10.1109/ICSME.2018.00074

Author

Jansen, Bas ; Hermans, Felienne ; Tazelaar, Edwin. / Detecting and Predicting Evolution in Spreadsheets : A Case Study in an Energy Network Company. Software Maintenance and Evolution (ICSME), 2018 IEEE International Conference on. 2018.

BibTeX

@inproceedings{2f0a39ead3084b65bcb1b9d6a1549e9f,
title = "Detecting and Predicting Evolution in Spreadsheets: A Case Study in an Energy Network Company",
abstract = "The use of spreadsheets in industry is widespread and the information that they provide is often used for decisions. Research has shown that spreadsheets are error-prone, leading to the risk that decisions are made on incorrect information. Software Evolution is a well-researched topic and the results have proven to support developers in creating better software. Could this also be applied to spreadsheets? Unfortunately, the research on spreadsheet evolution is still limited. Therefore, the aim of this paper is to obtain a better understanding of how spreadsheets evolve over time and if the results of such a study provide similar benefits for spreadsheets as it does for source code. In this study, we cooperated with Alliander, a large energy network company in the Netherlands. We conducted two case studies on two different set of spreadsheets that both were already maintained for a period of three years. To have a better understanding of the spreadsheets itself and the context in which they evolved, we also interviewed the creators of the spreadsheets. We focus on the changes that are made over time in the formulas. Changes in these formulas change the behavior of the spreadsheet and could possibly introduce errors. To effectively analyze these changes we developed an algorithm that is able to detect and visualize these changes. Results indicate that studying the evolution of a spreadsheet helps to identify areas in the spreadsheet that are error-prone, likely to change or that could benefit from refactoring. Furthermore, by analyzing the frequency in which formulas are changed from version to version, it is possible to predict which formulas need to be changed when a new version of the spreadsheet is created.",
author = "Bas Jansen and Felienne Hermans and Edwin Tazelaar",
year = "2018",
doi = "10.1109/ICSME.2018.00074",
language = "English",
booktitle = "Software Maintenance and Evolution (ICSME), 2018 IEEE International Conference on",

}

RIS

TY - GEN

T1 - Detecting and Predicting Evolution in Spreadsheets

T2 - A Case Study in an Energy Network Company

AU - Jansen, Bas

AU - Hermans, Felienne

AU - Tazelaar, Edwin

PY - 2018

Y1 - 2018

N2 - The use of spreadsheets in industry is widespread and the information that they provide is often used for decisions. Research has shown that spreadsheets are error-prone, leading to the risk that decisions are made on incorrect information. Software Evolution is a well-researched topic and the results have proven to support developers in creating better software. Could this also be applied to spreadsheets? Unfortunately, the research on spreadsheet evolution is still limited. Therefore, the aim of this paper is to obtain a better understanding of how spreadsheets evolve over time and if the results of such a study provide similar benefits for spreadsheets as it does for source code. In this study, we cooperated with Alliander, a large energy network company in the Netherlands. We conducted two case studies on two different set of spreadsheets that both were already maintained for a period of three years. To have a better understanding of the spreadsheets itself and the context in which they evolved, we also interviewed the creators of the spreadsheets. We focus on the changes that are made over time in the formulas. Changes in these formulas change the behavior of the spreadsheet and could possibly introduce errors. To effectively analyze these changes we developed an algorithm that is able to detect and visualize these changes. Results indicate that studying the evolution of a spreadsheet helps to identify areas in the spreadsheet that are error-prone, likely to change or that could benefit from refactoring. Furthermore, by analyzing the frequency in which formulas are changed from version to version, it is possible to predict which formulas need to be changed when a new version of the spreadsheet is created.

AB - The use of spreadsheets in industry is widespread and the information that they provide is often used for decisions. Research has shown that spreadsheets are error-prone, leading to the risk that decisions are made on incorrect information. Software Evolution is a well-researched topic and the results have proven to support developers in creating better software. Could this also be applied to spreadsheets? Unfortunately, the research on spreadsheet evolution is still limited. Therefore, the aim of this paper is to obtain a better understanding of how spreadsheets evolve over time and if the results of such a study provide similar benefits for spreadsheets as it does for source code. In this study, we cooperated with Alliander, a large energy network company in the Netherlands. We conducted two case studies on two different set of spreadsheets that both were already maintained for a period of three years. To have a better understanding of the spreadsheets itself and the context in which they evolved, we also interviewed the creators of the spreadsheets. We focus on the changes that are made over time in the formulas. Changes in these formulas change the behavior of the spreadsheet and could possibly introduce errors. To effectively analyze these changes we developed an algorithm that is able to detect and visualize these changes. Results indicate that studying the evolution of a spreadsheet helps to identify areas in the spreadsheet that are error-prone, likely to change or that could benefit from refactoring. Furthermore, by analyzing the frequency in which formulas are changed from version to version, it is possible to predict which formulas need to be changed when a new version of the spreadsheet is created.

U2 - 10.1109/ICSME.2018.00074

DO - 10.1109/ICSME.2018.00074

M3 - Conference contribution

BT - Software Maintenance and Evolution (ICSME), 2018 IEEE International Conference on

ER -

ID: 46005693