Detecting and predicting evolution in spreadsheets-a case study in an energy network company

Bas Jansen, Felienne Hermans, Edwin Tazelaar

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

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.

Original languageEnglish
Title of host publicationProceedings - 2018 IEEE International Conference on Software Maintenance and Evolution, ICSME 2018
PublisherInstitute of Electrical and Electronics Engineers Inc.
Pages645-654
Number of pages10
ISBN (Electronic)9781538678701
DOIs
Publication statusPublished - 9 Nov 2018
Externally publishedYes
Event34th IEEE International Conference on Software Maintenance and Evolution, ICSME 2018 - Madrid, Spain
Duration: 23 Sep 201829 Sep 2018

Publication series

NameProceedings - 2018 IEEE International Conference on Software Maintenance and Evolution, ICSME 2018

Conference

Conference34th IEEE International Conference on Software Maintenance and Evolution, ICSME 2018
CountrySpain
CityMadrid
Period23/09/1829/09/18

Keywords

  • End User Programming
  • Software Evolution
  • Spreadsheet Evolution
  • Version

Fingerprint

Dive into the research topics of 'Detecting and predicting evolution in spreadsheets-a case study in an energy network company'. Together they form a unique fingerprint.

Cite this