The use of Charts, Pivot Tables, and Array Formulas in two Popular Spreadsheet Corpora

Bas Jansen, Felienne Hermans

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

38 Downloads (Pure)

Abstract

The use of spreadsheets in industry is widespread. Companies base decisions on information coming from spreadsheets. Unfortunately, spreadsheets are error-prone and this increases the risk that companies base their decisions on inaccurate information, which can lead to incorrect decisions and loss of money. In general, spreadsheet research is aimed to reduce the error-proneness of spreadsheets. Most research is concentrated on the use of formulas. However, there are other constructions in spreadsheets, like charts, pivot tables, and array formulas, that are also used to present decision support information to the user. There is almost no research about how these constructions are used. To improve spreadsheet quality it is important to understand how spreadsheets are used and to obtain a complete understanding, the use of charts, pivot tables, and array formulas should be included in research. In this paper, we analyze two popular spreadsheet corpora: Enron and EUSES on the use of the aforementioned constructions.
Original languageEnglish
Title of host publicationProceedings of the 5th International Workshop on Software Engineering Methods in Spreadsheets
EditorsBirgit Hofer, Jorge Mendes
Number of pages4
Publication statusPublished - 2018
EventSEMS'18: 5th International Workshop on Software Engineering Methods in Spreadsheets - Lisbon, Portugal
Duration: 1 Oct 20181 Oct 2018
Conference number: 5

Workshop

WorkshopSEMS'18: 5th International Workshop on Software Engineering Methods in Spreadsheets
Abbreviated titleSEMS'18
Country/TerritoryPortugal
CityLisbon
Period1/10/181/10/18

Fingerprint

Dive into the research topics of 'The use of Charts, Pivot Tables, and Array Formulas in two Popular Spreadsheet Corpora'. Together they form a unique fingerprint.

Cite this