DocumentCode :
2333478
Title :
Measuring maintainability of spreadsheets in the wild
Author :
Correia, José Pedro ; Ferreira, Miguel Alexandre
Author_Institution :
Software Improvement Group, Amsterdam, Netherlands
fYear :
2011
fDate :
25-30 Sept. 2011
Firstpage :
516
Lastpage :
519
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;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Software Maintenance (ICSM), 2011 27th IEEE International Conference on
Conference_Location :
Williamsburg, VI
ISSN :
1063-6773
Print_ISBN :
978-1-4577-0663-9
Electronic_ISBN :
1063-6773
Type :
conf
DOI :
10.1109/ICSM.2011.6080821
Filename :
6080821
Link To Document :
بازگشت