Analyzing and Visualizing Spreadsheets

Doctoral Thesis (2013)
Author(s)

F.F.J. Hermans

Contributor(s)

A. van Deursen – Promotor

Copyright
© 2013 Hermans, F.F.J.
More Info
expand_more
Publication Year
2013
Copyright
© 2013 Hermans, F.F.J.
Related content
Page Views
551
Collections
Institutional Repository
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 are used extensively in industry: they are the number one tool for financial analysis and are also prevalent in other domains, such as logistics and planning. Their flexibility and immediate feedback make them easy to use for non-programmers. But as easy as spreadsheets are to build, so difficult can they be to analyze and adapt. This dissertation aims at developing methods to support spreadsheet users to understand, update and improve spreadsheets. We took our inspiration for such methods from software engineering, as this field is specialized in the analysis of data and calculations. In this dissertation, we have looked at four different aspects of spreadsheets: metadata, structure, formulas and data. We found that methods from software engineering can be applied to spreadsheets very well, and that these methods support end-users in working with spreadsheets.

Files

Dissertation.pdf
(pdf | 2.64 Mb)
License info not available