Title :
Measuring maintainability of spreadsheets in the wild
Author :
Correia, José Pedro ; Ferreira, Miguel Alexandre
Author_Institution :
Software Improvement Group, Amsterdam, Netherlands
Abstract :
Several studies have shown how spreadsheets are pervasive in many organizations as a form of end-user programming. Despite their importance and long lifespan, they are seldom developed with maintenance concerns in mind, and organizations have no efficient way of estimating the risk they present. In this paper we take a first step towards automated assessment of spreadsheet maintainability. We use the Goal Question Metric approach to select metrics relevant for maintainability and apply the selected metrics to a spreadsheet corpus in order to study their behavior "in the wild". We observe that the majority of the metrics behave in the same way as similar ones for traditional software systems, which means that existing methodologies to assess maintainability can be applied to spreadsheets as well. This opens the possibility of creating instruments for organizations that rely on spreadsheets to start actively managing their maintainability.
Keywords :
personal computing; software maintenance; spreadsheet programs; end-user programming; goal question metric; organization; spreadsheet corpus; spreadsheet maintainability; ISO standards; Measurement; Organizations; Reliability; Software systems; Spreadsheet programs;
Conference_Titel :
Software Maintenance (ICSM), 2011 27th IEEE International Conference on
Conference_Location :
Williamsburg, VI
Print_ISBN :
978-1-4577-0663-9
Electronic_ISBN :
1063-6773
DOI :
10.1109/ICSM.2011.6080821