{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,1,20]],"date-time":"2026-01-20T05:34:54Z","timestamp":1768887294838,"version":"3.49.0"},"reference-count":36,"publisher":"Springer Science and Business Media LLC","issue":"2","license":[{"start":{"date-parts":[[2014,2,7]],"date-time":"2014-02-07T00:00:00Z","timestamp":1391731200000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Empir Software Eng"],"published-print":{"date-parts":[[2015,4]]},"DOI":"10.1007\/s10664-013-9296-2","type":"journal-article","created":{"date-parts":[[2014,2,6]],"date-time":"2014-02-06T02:06:57Z","timestamp":1391652417000},"page":"549-575","source":"Crossref","is-referenced-by-count":44,"title":["Detecting and refactoring code smells in spreadsheet formulas"],"prefix":"10.1007","volume":"20","author":[{"given":"Felienne","family":"Hermans","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Martin","family":"Pinzger","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Arie","family":"van Deursen","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2014,2,7]]},"reference":[{"key":"9296_CR1","doi-asserted-by":"crossref","unstructured":"Abraham R, Erwig M (2005) How to communicate unit error messages in spreadsheets. In: Proceedings of WEUSE \u201905, pp 1\u20135","DOI":"10.1145\/1083231.1083243"},{"key":"9296_CR2","doi-asserted-by":"crossref","unstructured":"Abraham R, Erwig M (2006) Inferring templates from spreadsheets. In: Proceedings of ICSE \u201906, pp 182\u2013191","DOI":"10.1145\/1134285.1134312"},{"key":"9296_CR3","doi-asserted-by":"crossref","first-page":"71","DOI":"10.1016\/j.jvlc.2006.06.001","volume":"18","author":"R Abraham","year":"2007","unstructured":"Abraham R, Erwig M (2007) Ucheck: a spreadsheet type checker for end users. J Vis Lang Comput 18:71\u201395. doi: 10.1016\/j.jvlc.2006.06.001","journal-title":"J Vis Lang Comput"},{"key":"9296_CR4","doi-asserted-by":"crossref","unstructured":"Alves TL, Ypma C, Visser J (2010) Deriving metric thresholds from benchmark data. In: Proceedings of ICSM \u201910. IEEE Computer Society, pp 1\u201310","DOI":"10.1109\/ICSM.2010.5609747"},{"key":"9296_CR5","unstructured":"Ayalew Y, Clermont M, Mittermeir RT (2000) Detecting errors in spreadsheets. In: Proceedings of EuSpRIG \u201900, pp 51\u201362"},{"key":"9296_CR6","doi-asserted-by":"crossref","unstructured":"Badame S, Dig D (2012) Refactoring meets spreadsheet formulas. In: Proceedings of ICSM \u201912, pp 399\u2013409","DOI":"10.1109\/ICSM.2012.6405299"},{"key":"9296_CR7","unstructured":"Bregar A (2004) Complexity metrics for spreadsheet models. In: Proceedings of EuSpRIG \u201904, p 9"},{"key":"9296_CR8","doi-asserted-by":"crossref","first-page":"269","DOI":"10.1016\/j.jvlc.2009.04.002","volume":"20","author":"C Chambers","year":"2009","unstructured":"Chambers C, Erwig M (2009) Automatic detection of dimension errors in spreadsheets. J Vis Lang Comput 20:269\u2013283","journal-title":"J Vis Lang Comput"},{"key":"9296_CR9","doi-asserted-by":"crossref","unstructured":"Cunha J, Fernandes JP, Mendes J, Hugo Pacheco JS (2012) Towards a catalog of spreadsheet smells. In: Proceeding of ICCSA\u201912. LNCS","DOI":"10.1007\/978-3-642-31128-4_15"},{"key":"9296_CR10","doi-asserted-by":"crossref","unstructured":"Cunha J, Fernandes JP, Peixoto C, Saraiva J (2012) A quality model for spreadsheets. In: Proceedings of QUATIC \u201912, pp 231\u2013236","DOI":"10.1109\/QUATIC.2012.16"},{"key":"9296_CR11","doi-asserted-by":"crossref","unstructured":"Cunha J, Saraiva J, Visser J (2009) Discovery-based edit assistance for spreadsheets. In: Proceedings of VL\/HCC \u201909, pp 233\u2013237. IEEE","DOI":"10.1109\/VLHCC.2009.5295255"},{"key":"9296_CR12","doi-asserted-by":"crossref","first-page":"25","DOI":"10.1109\/MS.2009.140","volume":"26","author":"M Erwig","year":"2009","unstructured":"Erwig M (2009) Software engineering for spreadsheets. IEEE Softw 26:25\u201330. doi: 10.1109\/MS.2009.140","journal-title":"IEEE Softw"},{"key":"9296_CR13","doi-asserted-by":"crossref","unstructured":"Fisher M, Rothermel G (2005) The EUSES spreadsheet corpus: a shared resource for supporting experimentation with spreadsheet dependability mechanisms. In: Proceedings of WEUSE \u201905, pp 47\u201351","DOI":"10.1145\/1083231.1083242"},{"key":"9296_CR14","unstructured":"Fowler M (1999) Refactoring: improving the design of existing code. Addison-Wesley Longman Publishing Co., Inc., Boston"},{"issue":"6","key":"9296_CR15","doi-asserted-by":"crossref","first-page":"1033","DOI":"10.1006\/ijhc.1994.1047","volume":"40","author":"DG Hendry","year":"1994","unstructured":"Hendry DG, Green TRG (1994) Creating, comprehending and explaining spreadsheets: a cognitive interpretation of what discretionary users think of the spreadsheet model. Int J Human-Computer Stud 40(6):1033\u20131065","journal-title":"Int J Human-Computer Stud"},{"key":"9296_CR16","doi-asserted-by":"crossref","unstructured":"Hermans F, Pinzger M, van Deursen A (2010) Automatically extracting class diagrams from spreadsheets. In: Proceedings of ECOOP \u201910, pp 52\u201375","DOI":"10.1007\/978-3-642-14107-2_4"},{"key":"9296_CR17","unstructured":"Hermans F, Pinzger M, van Deursen A (2011) Breviz: spreadsheet visualization and quality analysis. In: Proceedings of EuSpRIG \u201911, pp 63\u201372"},{"key":"9296_CR18","doi-asserted-by":"crossref","unstructured":"Hermans F, Pinzger M, van Deursen A (2012a) Detecting and visualizing inter-worksheet smells in spreadsheets. In: Proceedings of ICSE \u201912, pp 441\u2013451","DOI":"10.1109\/ICSE.2012.6227171"},{"key":"9296_CR19","doi-asserted-by":"crossref","unstructured":"Hermans F, Pinzger M, van Deursen A (2012b) Detecting code smells in spreadsheet formulas. In: Proceedings of ICSM \u201912, pp 409\u2013418","DOI":"10.1109\/ICSM.2012.6405300"},{"key":"9296_CR20","unstructured":"Hermans F, Pinzger M, van Deursen A (2012c) Measuring spreadsheet formula understandability. In: Proceedings of EuSpRIG \u201912"},{"key":"9296_CR21","unstructured":"Hodnigg K, Mittermeir R (2008) Metrics-based spreadsheet visualization: support for focused maintenance. In: Proceedings of EuSpRIG \u201908, p 16"},{"key":"9296_CR22","unstructured":"Hole S, McPhee D, Lohfink A (2009) Mining spreadsheet complexity data to classify end user developers. In: Proceedings of ICDM \u201909. CSREA Press, pp 573\u2013579"},{"key":"9296_CR23","doi-asserted-by":"crossref","unstructured":"Kamiya T, Kusumoto S, Inoue K (2002) Ccfinder: a multilinguistic token-based code clone detection system for large scale source code. TSE 28(7):654\u2013670","DOI":"10.1109\/TSE.2002.1019480"},{"key":"9296_CR24","volume-title":"Object-oriented metrics in practice","author":"M Lanza","year":"2005","unstructured":"Lanza M, Marinescu R, Ducasse S (2005) Object-oriented metrics in practice. Springer-Verlag, New York, Inc., Secaucus"},{"key":"9296_CR25","doi-asserted-by":"crossref","unstructured":"Marinescu R (2001) Detecting design flaws via metrics in object-oriented systems. In: Proceedings of TOOLS \u201901. IEEE Computer Society, pp 173\u2013182","DOI":"10.1109\/TOOLS.2001.941671"},{"issue":"1","key":"9296_CR26","doi-asserted-by":"crossref","first-page":"20","DOI":"10.1109\/TSE.2009.50","volume":"36","author":"N Moha","year":"2010","unstructured":"Moha N, Gueheneuc YG, Duchien L, Le Meur AF (2010) Decor: a method for the specification and detection of code and design smells. TSE 36(1):20\u201336","journal-title":"TSE"},{"key":"9296_CR27","unstructured":"Nardi B, Miller J (1990) The spreadsheet interface: a basis for end user programming. In: Proceeding of the IFIP conference on human-computer interaction (INTERACT). North-Holland, pp 977\u2013983"},{"key":"9296_CR28","doi-asserted-by":"crossref","unstructured":"Olbrich S, Cruzes DS, Basili V, Zazworka N (2009) The evolution and impact of code smells: a case study of two open source systems. In: Proceedings of ESEM \u201909, pp 390\u2013400","DOI":"10.1109\/ESEM.2009.5314231"},{"key":"9296_CR29","unstructured":"Panko R (2006) Facing the problem of spreadsheet errors. Decis Line 37(5):8\u201310"},{"issue":"2","key":"9296_CR30","doi-asserted-by":"crossref","first-page":"15","DOI":"10.4018\/joeuc.1998040102","volume":"10","author":"RR Panko","year":"1998","unstructured":"Panko RR (1998) What we know about spreadsheet errors. J End User Comput 10(2):15\u201321","journal-title":"J End User Comput"},{"key":"9296_CR31","unstructured":"Powell S, Baker K, Lawson B (2009) Errors in operational spreadsheets: a review of the state of the art. In: Proceedings of HICCS \u201909. IEEE Computer Society, pp 1\u20138"},{"key":"9296_CR32","first-page":"141","volume":"2","author":"J Raffensperger","year":"2009","unstructured":"Raffensperger J (2009) New guidelines for spreadsheets. Int J Bus Econ 2:141\u2013154","journal-title":"Int J Bus Econ"},{"key":"9296_CR33","doi-asserted-by":"crossref","unstructured":"Rajalingham K, Chadwick D, Knight B, Edwards D (2000) Quality control in spreadsheets: a software engineering-based approach to spreadsheet development. In: Proceedings HICSS \u201900, pp 133\u2013143","DOI":"10.1109\/HICSS.2000.926736"},{"key":"9296_CR34","doi-asserted-by":"crossref","unstructured":"Wettel R, Lanza M (2008) Visually localizing design problems with disharmony maps. In: Proceedings of SoftVis \u201908, pp 155\u2013164","DOI":"10.1145\/1409720.1409745"},{"key":"9296_CR35","doi-asserted-by":"crossref","unstructured":"Wettel R, Lanza M, Robbes R (2011) Software systems as cities: a controlled experiment. In: Proceedings of ICSE \u201911, pp 551\u2013560","DOI":"10.1145\/1985793.1985868"},{"key":"9296_CR36","unstructured":"Winston W (2001) Executive education opportunities. OR\/MS Today 28(4)"}],"container-title":["Empirical Software Engineering"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s10664-013-9296-2.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/article\/10.1007\/s10664-013-9296-2\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s10664-013-9296-2","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2019,8,7]],"date-time":"2019-08-07T06:54:40Z","timestamp":1565160880000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/s10664-013-9296-2"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2014,2,7]]},"references-count":36,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2015,4]]}},"alternative-id":["9296"],"URL":"https:\/\/doi.org\/10.1007\/s10664-013-9296-2","relation":{},"ISSN":["1382-3256","1573-7616"],"issn-type":[{"value":"1382-3256","type":"print"},{"value":"1573-7616","type":"electronic"}],"subject":[],"published":{"date-parts":[[2014,2,7]]}}}