Supporting Spreadsheet Maintenance with Dependency Notification

Conference Paper (2017)
Author(s)

S. Roy (TU Delft - Software Engineering)

Félienne Hermans (TU Delft - Software Engineering)

A Deursen (TU Delft - Software Technology)

Research Group
Software Engineering
Copyright
© 2017 S. Roy, F.F.J. Hermans, A. van Deursen
More Info
expand_more
Publication Year
2017
Language
English
Copyright
© 2017 S. Roy, F.F.J. Hermans, A. van Deursen
Research Group
Software Engineering
Pages (from-to)
88-93
ISBN (electronic)
978-90-386-4317-5
Reuse Rights

Other than for strictly personal use, it is not permitted to download, forward or distribute the text or part of it, without the consent of the author(s) and/or copyright holder(s), unless the work is under an open content license such as Creative Commons.

Abstract

Spreadsheets in the industry are used by multiple employees in organizations, and they remain in use for several years. Maintenance of existing spreadsheets is thus common. One of the issues in maintaining spreadsheets is the fact that formulas create cell dependencies, and these dependencies are invisible to users. To address this, dependence tracing techniques have been developed, both commercially and in research. However, these techniques are effort consuming, and are designed as separate activities that force the users to leave the context of editing spreadsheets. As such, these techniques are not suitably supportive for usual spreadsheet maintenance tasks. In this extended abstract, we present our work in progress on a novel approach for notifying users of cell dependencies, integrated into the context of editing spreadsheets. We present a preliminary evaluation of the approach in the form of an exploratory user-study with seven employees of a financial modeling company. Results show that the approach has the potential to support industrial spreadsheet users in the context of spreadsheet maintenance, as indicated by the responses of six out of seven participants.

Files

AragornExtendedAbstract.pdf
(pdf | 0.26 Mb)
License info not available