{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,2,21]],"date-time":"2025-02-21T00:17:21Z","timestamp":1740097041676,"version":"3.37.3"},"publisher-location":"Cham","reference-count":37,"publisher":"Springer International Publishing","isbn-type":[{"type":"print","value":"9783319091556"},{"type":"electronic","value":"9783319091563"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2014]]},"DOI":"10.1007\/978-3-319-09156-3_39","type":"book-chapter","created":{"date-parts":[[2014,7,2]],"date-time":"2014-07-02T07:15:22Z","timestamp":1404285322000},"page":"556-571","source":"Crossref","is-referenced-by-count":1,"title":["Refactoring Smelly Spreadsheet Models"],"prefix":"10.1007","author":[{"given":"Pedro","family":"Martins","sequence":"first","affiliation":[]},{"given":"Rui","family":"Pereira","sequence":"additional","affiliation":[]}],"member":"297","reference":[{"key":"39_CR1","doi-asserted-by":"publisher","first-page":"8","DOI":"10.1145\/2328876.2328878","volume-title":"Proceedings of the Fifth Workshop on Refactoring Tools, WRT 2012","author":"T. Arendt","year":"2012","unstructured":"Arendt, T., Taentzer, G.: Integration of smells and refactorings within the eclipse modeling framework. In: Proceedings of the Fifth Workshop on Refactoring Tools, WRT 2012, pp. 8\u201315. ACM, New York (2012)"},{"key":"39_CR2","first-page":"399","volume-title":"Proceedings of the 2012 IEEE International Conference on Software Maintenance, ICSM 2012","author":"S. Badame","year":"2012","unstructured":"Badame, S., Dig, D.: Refactoring meets spreadsheet formulas. In: Proceedings of the 2012 IEEE International Conference on Software Maintenance, ICSM 2012, pp. 399\u2013409. IEEE Computer Society, Washington, DC (2012)"},{"key":"39_CR3","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"crossref","first-page":"282","DOI":"10.1007\/978-3-642-21530-8_27","volume-title":"IS-EUD 2011","author":"L. Beckwith","year":"2011","unstructured":"Beckwith, L., Cunha, J., Fernandes, J.P., Saraiva, J.: End-users productivity in model-based spreadsheets: An empirical study. In: Piccinno, A. (ed.) IS-EUD 2011. LNCS, vol.\u00a06654, pp. 282\u2013288. Springer, Heidelberg (2011)"},{"key":"39_CR4","doi-asserted-by":"crossref","unstructured":"Belo, O., Cunha, J., Fernandes, J.P., Mendes, J., Pereira, R., Saraiva, J.: Querysheet: A bidirectional query environment for model-driven spreadsheets. In: VL\/HCC, pp. 199\u2013200 (2013)","DOI":"10.1109\/VLHCC.2013.6645267"},{"key":"39_CR5","doi-asserted-by":"crossref","unstructured":"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. IEEE Computer Society (2010)","DOI":"10.1109\/VLHCC.2010.22"},{"key":"39_CR6","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"105","DOI":"10.1007\/978-3-642-30476-7_7","volume-title":"Theory and Practice of Model Transformations","author":"J. Cunha","year":"2012","unstructured":"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.\u00a07307, pp. 105\u2013120. Springer, Heidelberg (2012)"},{"key":"39_CR7","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"202","DOI":"10.1007\/978-3-642-31128-4_15","volume-title":"Computational Science and Its Applications \u2013 ICCSA 2012","author":"J. Cunha","year":"2012","unstructured":"Cunha, J., Fernandes, J.P., Ribeiro, H., Saraiva, J.: Towards a Catalog of Spreadsheet Smells. In: Murgante, B., Gervasi, O., Misra, S., Nedjah, N., Rocha, A.M.A.C., Taniar, D., Apduhan, B.O. (eds.) ICCSA 2012, Part IV. LNCS, vol.\u00a07336, pp. 202\u2013216. Springer, Heidelberg (2012)"},{"key":"39_CR8","doi-asserted-by":"publisher","first-page":"243","DOI":"10.1109\/VLHCC.2012.6344535","volume-title":"Proceedings of the 2012 IEEE Symposium on Visual Languages and Human-Centric Computing, VLHCC 2012","author":"J. Cunha","year":"2012","unstructured":"Cunha, J., Fernandes, J.P., Mendes, J., Martins, P., Saraiva, J.: Smellsheet detective: A tool for detecting bad smells in spreadsheets. In: Proceedings of the 2012 IEEE Symposium on Visual Languages and Human-Centric Computing, VLHCC 2012, pp. 243\u2013244. IEEE Computer Society, Washington, DC (2012)"},{"key":"39_CR9","doi-asserted-by":"crossref","unstructured":"Cunha, J., Fernandes, J.P., Mendes, J., Pereira, R., Saraiva, J.: Querying model-driven spreadsheets. In: 2013 IEEE Symposium on Visual Languages and Human-Centric Computing (VL\/HCC), pp. 83\u201386 (2013)","DOI":"10.1109\/VLHCC.2013.6645247"},{"key":"39_CR10","doi-asserted-by":"crossref","unstructured":"Cunha, J., Fernandes, J.P., Mendes, J., Saraiva, J.: Embedding and evolution of spreadsheet models in spreadsheet systems. In: 2011 IEEE Symposium on Visual Languages and Human-Centric Computing, VLHCC 2011, pp. 186\u2013201 (2011)","DOI":"10.1109\/VLHCC.2011.6070396"},{"key":"39_CR11","doi-asserted-by":"crossref","unstructured":"Cunha, J., Fernandes, J.P., Mendes, J., Saraiva, J.: A bidirectional model-driven spreadsheet environment. In: 34rd International Conference on Software Engineering, ICSE 2012, pp. 1443\u20131444 (June 2012)","DOI":"10.1109\/ICSE.2012.6227073"},{"key":"39_CR12","doi-asserted-by":"crossref","unstructured":"Cunha, J., Fernandes, J.P., Mendes, J., Saraiva, J.: Extension and implementation of classsheet models. In: 2012 IEEE Symposium on Visual Languages and Human-Centric Computing, VLHCC 2012, pp. 19\u201322 (2012)","DOI":"10.1109\/VLHCC.2012.6344473"},{"key":"39_CR13","doi-asserted-by":"crossref","unstructured":"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\u20131415. ACM (2012)","DOI":"10.1109\/ICSE.2012.6227239"},{"key":"39_CR14","doi-asserted-by":"crossref","unstructured":"Cunha, J., Fernandes, J.P., Mendes, J., Saraiva, J.: Towards an evaluation of bidirectional model-driven spreadsheets. In: User Evaluation for Software Engineering Researchers, USER 2012, pp. 25\u201328. ACM Digital Library (2012)","DOI":"10.1109\/USER.2012.6226577"},{"key":"39_CR15","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"459","DOI":"10.1007\/978-3-642-39643-4_33","volume-title":"Computational Science and Its Applications \u2013 ICCSA 2013","author":"J. Cunha","year":"2013","unstructured":"Cunha, J., Fernandes, J.P., Mendes, J., Saraiva, J.: Complexity Metrics for Classsheet Models. In: Murgante, B., Misra, S., Carlini, M., Torre, C.M., Nguyen, H.-Q., Taniar, D., Apduhan, B.O., Gervasi, O. (eds.) ICCSA 2013, Part II. LNCS, vol.\u00a07972, pp. 459\u2013474. Springer, Heidelberg (2013)"},{"key":"39_CR16","doi-asserted-by":"crossref","unstructured":"Cunha, J., Fernandes, J.P., Peixoto, C., Saraiva, J.: A quality model for spreadsheets. In: 8th Int. Conf. on the Quality of Information and Communications Technology, Quality in ICT Evolution Track, QUATIC 2012, pp. 231\u2013236 (2012)","DOI":"10.1109\/QUATIC.2012.16"},{"key":"39_CR17","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"419","DOI":"10.1007\/978-3-319-07731-4_42","volume-title":"Human Interface and the Management of Information. Information and Knowledge Design and Evaluation","author":"J. Cunha","year":"2014","unstructured":"Cunha, J., Fernandes, J.P., Pereira, R., Saraiva, J.: Graphical querying of model-driven spreadsheets. In: Yamamoto, S. (ed.) HCI 2014, Part I. LNCS, vol.\u00a08521, pp. 419\u2013430. Springer, Heidelberg (2014)"},{"key":"39_CR18","doi-asserted-by":"crossref","unstructured":"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\u20131158. ACM (2012)","DOI":"10.1145\/2245276.2231957"},{"key":"39_CR19","doi-asserted-by":"crossref","unstructured":"Cunha, J., Saraiva, J., Visser, J.: Discovery-based edit assistance for spreadsheets. In: 2009 IEEE Symposium on Visual Languages and Human-Centric Computing (VL\/HCC), pp. 233\u2013237 (2009)","DOI":"10.1109\/VLHCC.2009.5295255"},{"key":"39_CR20","doi-asserted-by":"crossref","unstructured":"Cunha, J., Saraiva, J., Visser, J.: From spreadsheets to relational databases and back. In: Proceedings of the 2009 ACM SIGPLAN Workshop on Partial Evaluation and Program Manipulation, PEPM 2009, pp. 179\u2013188. ACM (2009)","DOI":"10.1145\/1480945.1480972"},{"key":"39_CR21","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"117","DOI":"10.1007\/978-3-642-33182-4_10","volume-title":"Programming Languages","author":"J. Cunha","year":"2012","unstructured":"Cunha, J., Saraiva, J., Visser, J.: Model-based programming environments for spreadsheets. In: de Carvalho Junior, F.H., Barbosa, L.S. (eds.) SBLP 2012. LNCS, vol.\u00a07554, pp. 117\u2013133. Springer, Heidelberg (2012)"},{"key":"39_CR22","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"186","DOI":"10.1007\/978-3-642-19811-3_14","volume-title":"Fundamental Approaches to Software Engineering","author":"J. Cunha","year":"2011","unstructured":"Cunha, J., Visser, J., Alves, T., Saraiva, J.: Type-safe evolution of spreadsheets. In: Giannakopoulou, D., Orejas, F. (eds.) FASE 2011. LNCS, vol.\u00a06603, pp. 186\u2013201. Springer, Heidelberg (2011)"},{"key":"39_CR23","doi-asserted-by":"crossref","unstructured":"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. ACM (2005)","DOI":"10.1145\/1101908.1101929"},{"key":"39_CR24","doi-asserted-by":"crossref","unstructured":"Erwig, M.: Software Engineering for Spreadsheets. IEEE Software\u00a029(5) (2009)","DOI":"10.1109\/MS.2009.140"},{"key":"39_CR25","unstructured":"Fowler, M.: Refactoring: Improving the Design of Existing Code. Addison-Wesley (August1999)"},{"key":"39_CR26","unstructured":"Hermans, F., Dig, D.: Bumblebee: A transformation environment for spreadsheet formulas. Tech. rep. (2013), \n                    \n                      http:\/\/dx.doi.org\/10.6084\/m9.figshare.813347"},{"key":"39_CR27","doi-asserted-by":"crossref","unstructured":"Hermans, F., Pinzger, M., van Deursen, A.: Detecting and visualizing inter-worksheet smells in spreadsheets. In: Glinz, M., Murphy, G.C., Pezz\u00e8, M. (eds.) ICSE, pp. 441\u2013451. IEEE (2012)","DOI":"10.1109\/ICSE.2012.6227171"},{"key":"39_CR28","doi-asserted-by":"crossref","unstructured":"Hermans, F., Pinzger, M., Deursen, A.: Detecting and refactoring code smells in spreadsheet formulas. Empirical Software Engineering, 1\u201327 (2014)","DOI":"10.1007\/s10664-013-9296-2"},{"key":"39_CR29","doi-asserted-by":"crossref","unstructured":"McCabe, T.J.: A complexity measure. IEEE Trans. Software Eng.\u00a02(4) (1976)","DOI":"10.1109\/TSE.1976.233837"},{"key":"39_CR30","doi-asserted-by":"crossref","unstructured":"Mitchell, N., Runciman, C.: Uniform boilerplate and list processing. In: ACM SIGPLAN Workshop on Haskell Workshop, Haskell 2007, pp. 49\u201360. ACM (2007)","DOI":"10.1145\/1291201.1291208"},{"key":"39_CR31","doi-asserted-by":"crossref","DOI":"10.7551\/mitpress\/1020.001.0001","volume-title":"A Small Matter of Programming: Perspectives on End User Computing","author":"B.A. Nardi","year":"1993","unstructured":"Nardi, B.A.: A Small Matter of Programming: Perspectives on End User Computing, 1st edn. MIT Press, Cambridge (1993)","edition":"1"},{"key":"39_CR32","unstructured":"Panko, R.: Facing the problem of spreadsheet errors. Decision Line\u00a037(5) (2006)"},{"key":"39_CR33","unstructured":"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)"},{"key":"39_CR34","unstructured":"Pereira, R.: Querying for Model-Driven Spreadsheets. Master\u2019s thesis, University of Minho (2013)"},{"issue":"1","key":"39_CR35","first-page":"1","volume":"13","author":"S. Peyton Jones","year":"2003","unstructured":"Peyton Jones, S.: Haskell 98: Language and libraries. Journal of Functional Programming\u00a013(1), 1\u2013255 (2003)","journal-title":"Journal of Functional Programming"},{"issue":"1","key":"39_CR36","doi-asserted-by":"publisher","first-page":"128","DOI":"10.1016\/j.dss.2008.06.001","volume":"46","author":"S.G. Powell","year":"2008","unstructured":"Powell, S.G., Baker, K.R., Lawson, B.: A critical review of the literature on spreadsheet errors. Decision Support Systems\u00a046(1), 128\u2013138 (2008)","journal-title":"Decision Support Systems"},{"key":"39_CR37","unstructured":"Rajalingham, K., Chadwick, D.R., Knight, B.: Classification of spreadsheet errors. In: Proceedings of the 2001 European Spreadsheet Risks Interest Group (EuSpRIG), Amsterdam (2001)"}],"container-title":["Lecture Notes in Computer Science","Computational Science and Its Applications \u2013 ICCSA 2014"],"original-title":[],"link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-319-09156-3_39","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2019,5,27]],"date-time":"2019-05-27T01:49:32Z","timestamp":1558921772000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/978-3-319-09156-3_39"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2014]]},"ISBN":["9783319091556","9783319091563"],"references-count":37,"URL":"https:\/\/doi.org\/10.1007\/978-3-319-09156-3_39","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2014]]}}}