Abstract
This paper proposes a set of metrics for the assessment of the complexity of models defining the business logic of spreadsheets. This set can be considered the first step in the direction of building a quality standard for spreadsheet models, that is still to be defined.
The computation of concrete metric values has further been integrated under a well-established model-driven spreadsheet development environment, providing a framework for the analysis of spreadsheet models under spreadsheets themselves.
This work is part funded by ERDF - European Regional Development Fund through the COMPETE Programme (operational programme for competitiveness) and by National Funds through the FCT - Fundação para a Ciência e a Tecnologia (Portuguese Foundation for Science and Technology) within projects FCOMP-01-0124-FEDER-010048, FCOMP-01-0124-FEDER-020484, and FCOMP-01-0124-FEDER-022701. The three first authors were funded by FCT grants SFRH/BPD/73358/2010, SFRH/BPD/46987/2008, and BI2-2012_PTDC/EIA-CCO/108613/2008_UMINHO, respectively.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Bregar, A.: Complexity metrics for spreadsheet models. In: Proceedings of the 2004 European Spreadsheet Risks Interest Group (EuSpRIG) CoRR abs/0802.3895, pp. 85–93 (2004)
Correia, J.P., Ferreira, M.A.: Measuring maintainability of spreadsheets in the wild. In: Proceedings of the 27th IEEE International Conference on Software Maintenance, ICSM 2011, pp. 516–519. IEEE (2011)
Cunha, J., Erwig, M., Saraiva, J.: Automatically inferring classsheet models from spreadsheets. In: Proceedings of the 2010 IEEE Symposium on Visual Languages and Human-Centric Computing, VLHCC 2010, pp. 93–100. IEEE Computer Society (2010)
Cunha, J., Fernandes, J.P., Mendes, J., Pacheco, H., Saraiva, J.: Bidirectional transformation of model-driven spreadsheets. In: Hu, Z., de Lara, J. (eds.) ICMT 2012. LNCS, vol. 7307, pp. 105–120. Springer, Heidelberg (2012)
Cunha, J., Fernandes, J.P., Mendes, J., Saraiva, J.: Embedding and evolution of spreadsheet models in spreadsheet systems. In: Proceedings of the 2011 IEEE Symposium on Visual Languages and Human-Centric Computing, VLHCC 2011, pp. 186–201. IEEE Computer Society (2011)
Cunha, J., Fernandes, J.P., Mendes, J., Saraiva, J.: MDSheet: A Framework for Model-driven Spreadsheet Engineering. In: Proceedings of the 34rd International Conference on Software Engineering, ICSE 2012, pp. 1412–1415. ACM (2012)
Cunha, J., Fernandes, J.P., Peixoto, C., Saraiva, J.: A quality model for spreadsheets. In: Proceedings of the 8th International Conference on the Quality of Information and Communications Technology, Quality in ICT Evolution Track, QUATIC 2012, pp. 231–236 (2012)
Cunha, J., Fernandes, J.P., Saraiva, J.: From Relational ClassSheets to UML+OCL. In: Proceedings of the Software Engineering Track at the 27th Annual ACM Symposium on Applied Computing, SAC 2012, pp. 1151–1158. ACM (2012)
Engels, G., Erwig, M.: ClassSheets: automatic generation of spreadsheet applications from object-oriented specifications. In: Proceedings of the 20th IEEE/ACM International Conference on Automated Software Engineering, pp. 124–133. ACM (2005)
Genero, M., Jiménez, L., Piattini, M.: Measuring the quality of entity relationship diagrams. In: Laender, A.H.F., Liddle, S.W., Storey, V.C. (eds.) ER 2000. LNCS, vol. 1920, pp. 513–526. Springer, Heidelberg (2000)
Heitlager, I., Kuipers, T., Visser, J.: A practical model for measuring maintainability. In: Proceedings of the International Conference on Quality of Information and Communications Technology, QUATIC 2007, pp. 30–39. IEEE Computer Society (2007)
Hodnigg, K., Mittermeir, R.T.: Metrics-based spreadsheet visualization: Support for focused maintenance. CoRR abs/0809.3009 (2008)
Panko, R.: Facing the problem of spreadsheet errors. Decision Line 37(5) (2006)
Panko, R.: Spreadsheet errors: What we know. what we think we can do. In: Proceedings of the 2000 European Spreadsheet Risks Interest Group (EuSpRIG) (2000)
Peyton Jones, S.: Haskell 98: Language and libraries. Journal of Functional Programming 13(1), 1–255 (2003)
Powell, S.G., Baker, K.R., Lawson, B.: A critical review of the literature on spreadsheet errors. Decision Support Systems 46(1), 128–138 (2008)
Rajalingham, K., Chadwick, D.R., Knight, B.: Classification of spreadsheet errors. In: Proceedings of the 2001 European Spreadsheet Risks Interest Group (EuSpRIG), Amsterdam (2001)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Cunha, J., Fernandes, J.P., Mendes, J., Saraiva, J. (2013). Complexity Metrics for ClassSheet Models. In: Murgante, B., et al. Computational Science and Its Applications – ICCSA 2013. ICCSA 2013. Lecture Notes in Computer Science, vol 7972. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-39643-4_33
Download citation
DOI: https://doi.org/10.1007/978-3-642-39643-4_33
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-39642-7
Online ISBN: 978-3-642-39643-4
eBook Packages: Computer ScienceComputer Science (R0)