Print Email Facebook Twitter Measuring Spreadsheet Formula Understandability Title Measuring Spreadsheet Formula Understandability Author Hermans, F.F.J. Pinzger, M. Van Deursen, A. Faculty Electrical Engineering, Mathematics and Computer Science Department Software Computer Technology Date 2012-12-31 Abstract Spreadsheets are widely used in industry, because they are flexible and easy to use. Often they are used for business-critical applications. It is however difficult for spreadsheet users to correctly assess the quality of spreadsheets, especially with respect to the understandability. Understandability of spreadsheets is important, since spreadsheets often have a long lifespan, during which they are used by several users. In this paper, we establish a set of spreadsheet understandability metrics. We start by studying related work and interviewing 40 spreadsheet professionals to obtain a set of characteristics that might contribute to understandability problems in spreadsheets. Based on those characteristics we subsequently determine a number of understandability metrics. To evaluate the usefulness of our metrics, we conducted a series of experiments in which professional spreadsheet users performed a number of short maintenance tasks on a set of spreadsheets from the EUSES spreadsheet corpus. The results of these tests clearly indicate that the number of ranges, the nesting depth and the presence of conditional operations in formulas significantly increase the difficulty of understanding a spreadsheet. To reference this document use: http://resolver.tudelft.nl/uuid:06ac39c1-024d-4c4d-9f17-6ca21194fcf4 Publisher Delft University of Technology, Software Engineering Research Group ISSN 1872-5392 Source Technical Report Series TUD-SERG-2012-005 Part of collection Institutional Repository Document type report Rights (c) 2012 The Author(s) Files PDF TUD-SERG-2012-005.pdf 448.25 KB Close viewer /islandora/object/uuid:06ac39c1-024d-4c4d-9f17-6ca21194fcf4/datastream/OBJ/view