{"id":"https://openalex.org/W1986951253","doi":null,"title":"Detecting and refactoring code smells in spreadsheet formula","display_name":"Detecting and refactoring code smells in spreadsheet formula","alternate_titles":[],"publication_year":2013,"publication_date":"2013-12-31","ids":{"openalex":"https://openalex.org/W1986951253","mag":"1986951253"},"language":"en","primary_location":{"id":"pmh:oai:tudelft.nl:uuid:0677c4b7-6925-411a-848b-7995d61b6dd1","doi":null,"is_oa":true,"landing_page_url":"http://resolver.tudelft.nl/uuid:0677c4b7-6925-411a-848b-7995d61b6dd1","pdf_url":null,"source":{"id":"https://openalex.org/S4306400906","display_name":"Research Repository (Delft University of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I98358874","host_organization_name":"Delft University of Technology","host_organization_lineage":["https://openalex.org/I98358874"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"report"},"parent_works":[],"lineage":["https://openalex.org/W1986951253"],"child_works_count":0,"type":"report","is_traditional":false,"indexed_in":[],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://resolver.tudelft.nl/uuid:0677c4b7-6925-411a-848b-7995d61b6dd1","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5034150823","display_name":"Felienne Hermans","orcid":"https://orcid.org/0000-0003-0722-0156","observed_orcids":["https://orcid.org/0000-0003-0722-0156"]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Felienne Hermans","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5052107936","display_name":"Martin Pinzger","orcid":"https://orcid.org/0000-0002-5536-3859","observed_orcids":["https://orcid.org/0000-0002-5536-3859"]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Martin Pinzger","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5090401584","display_name":"Arie van Deursen","orcid":"https://orcid.org/0000-0003-4850-3312","observed_orcids":["https://orcid.org/0000-0003-4850-3312"]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Arie van Deursen","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":1,"reviewed_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.61080002784729,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.61080002784729,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10260","display_name":"Software Engineering Research","score":0.38530001044273376,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10799","display_name":"Data Visualization and Analytics","score":0.0006000000284984708,"subfield":{"id":"https://openalex.org/subfields/1704","display_name":"Computer Graphics and Computer-Aided Design"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/spreadsheet-formulas","display_name":"spreadsheet formulas","score":0.8119999766349792},{"id":"https://openalex.org/keywords/code-smells","display_name":"code smells","score":0.9929999709129333},{"id":"https://openalex.org/keywords/refactoring","display_name":"refactoring","score":0.8579999804496765},{"id":"https://openalex.org/keywords/spreadsheet-errors","display_name":"spreadsheet errors","score":0.6129999756813049}],"concepts":[{"id":"https://openalex.org/C152752567","wikidata":"https://www.wikidata.org/wiki/Q116877","display_name":"Code refactoring","level":3,"score":0.9709581136703491},{"id":"https://openalex.org/C133237599","wikidata":"https://www.wikidata.org/wiki/Q2295111","display_name":"Code smell","level":5,"score":0.8468813896179199},{"id":"https://openalex.org/C160713754","wikidata":"https://www.wikidata.org/wiki/Q1389965","display_name":"Maintainability","level":2,"score":0.7482140064239502},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7288033366203308},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.6139931082725525},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.5529961585998535},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.5419429540634155},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.48390206694602966},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.44129323959350586},{"id":"https://openalex.org/C10272871","wikidata":"https://www.wikidata.org/wiki/Q929972","display_name":"Software inspection","level":5,"score":0.43657606840133667},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.3275599479675293},{"id":"https://openalex.org/C529173508","wikidata":"https://www.wikidata.org/wiki/Q638608","display_name":"Software development","level":3,"score":0.2674573063850403},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.25561630725860596},{"id":"https://openalex.org/C117447612","wikidata":"https://www.wikidata.org/wiki/Q1412670","display_name":"Software quality","level":4,"score":0.2188204824924469},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:tudelft.nl:uuid:0677c4b7-6925-411a-848b-7995d61b6dd1","doi":null,"is_oa":true,"landing_page_url":"http://resolver.tudelft.nl/uuid:0677c4b7-6925-411a-848b-7995d61b6dd1","pdf_url":null,"source":{"id":"https://openalex.org/S4306400906","display_name":"Research Repository (Delft University of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I98358874","host_organization_name":"Delft University of Technology","host_organization_lineage":["https://openalex.org/I98358874"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"report"},{"id":"mag:1986951253","doi":null,"is_oa":false,"landing_page_url":"http://resolver.tudelft.nl/uuid:0677c4b7-6925-411a-848b-7995d61b6dd1","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null}],"best_oa_location":{"id":"pmh:oai:tudelft.nl:uuid:0677c4b7-6925-411a-848b-7995d61b6dd1","doi":null,"is_oa":true,"landing_page_url":"http://resolver.tudelft.nl/uuid:0677c4b7-6925-411a-848b-7995d61b6dd1","pdf_url":null,"source":{"id":"https://openalex.org/S4306400906","display_name":"Research Repository (Delft University of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I98358874","host_organization_name":"Delft University of Technology","host_organization_lineage":["https://openalex.org/I98358874"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"report"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W1986951253.pdf","grobid_xml":"https://content.openalex.org/works/W1986951253.grobid-xml"},"referenced_works_count":26,"referenced_works":["https://openalex.org/W148417311","https://openalex.org/W1497777582","https://openalex.org/W1511796393","https://openalex.org/W1515921409","https://openalex.org/W1531418056","https://openalex.org/W1573404916","https://openalex.org/W1933103375","https://openalex.org/W1970665021","https://openalex.org/W1973619038","https://openalex.org/W1973994007","https://openalex.org/W1974655094","https://openalex.org/W1979714549","https://openalex.org/W2010598806","https://openalex.org/W2026539153","https://openalex.org/W2088117279","https://openalex.org/W2093987194","https://openalex.org/W2096832718","https://openalex.org/W2097435116","https://openalex.org/W2112338634","https://openalex.org/W2126634149","https://openalex.org/W2129246310","https://openalex.org/W2138086333","https://openalex.org/W2138756793","https://openalex.org/W2151295763","https://openalex.org/W2159433976","https://openalex.org/W4230945824"],"related_works":["https://openalex.org/W2144849164","https://openalex.org/W1497777582","https://openalex.org/W3166878122","https://openalex.org/W2151867683","https://openalex.org/W2026539153","https://openalex.org/W2154523049","https://openalex.org/W2578408223","https://openalex.org/W1915158990","https://openalex.org/W1531418056","https://openalex.org/W2895064676"],"abstract_inverted_index":{"Preprint":[0],"of":[1,57,116,151],"article":[2],"published":[3],"in:":[4],"Empirical":[5],"Software":[6],"Engineering,":[7],"February":[8],"2014,":[9],"Springer":[10],"Science+Business":[11],"Media":[12],"New":[13],"York,":[14],"doi:10.1007/s10664-013-9296-2":[15],"Spreadsheets":[16],"are":[17,31,158],"used":[18],"extensively":[19],"in":[20,73,94,102,168,173],"business":[21],"processes":[22],"around":[23],"the":[24,87,108,114,117,129,133,147],"world":[25],"and":[26,38,75,90,98,127,145,166,171],"just":[27],"like":[28],"software,":[29],"spreadsheets":[30,74,144],"changed":[32],"throughout":[33],"their":[34],"lifetime":[35],"causing":[36],"understandability":[37],"maintainability":[39],"issues.":[40],"This":[41],"paper":[42],"adapts":[43],"known":[44],"code":[45],"smells":[46,157],"to":[47,69,78,82,112],"spreadsheet":[48,110,130,169],"formulas.":[49],"To":[50],"that":[51,155,160,172],"end":[52],"we":[53,61,106,121,137],"present":[54],"a":[55,66,76,95],"list":[56],"metrics":[58],"by":[59],"which":[60],"can":[62,162,177],"detect":[63],"smelly":[64],"formulas;":[65],"visualization":[67,89],"technique":[68],"highlight":[70],"these":[71,152],"formulas":[72,170],"method":[77],"automatically":[79],"suggest":[80],"refactorings":[81],"resolve":[83],"smells.":[84,119,135],"We":[85],"implemented":[86],"metrics,":[88],"refactoring":[91,139],"suggestions":[92,140],"techniques":[93],"prototype":[96],"tool":[97],"evaluated":[99],"our":[100],"approach":[101],"three":[103],"studies.":[104],"Firstly,":[105],"analyze":[107,122],"EUSES":[109],"corpus,":[111],"study":[113,146],"occurrence":[115],"formula":[118,156],"Secondly,":[120],"ten":[123,143],"real":[124,164],"life":[125],"spreadsheets,":[126],"interview":[128],"owners":[131],"about":[132],"identified":[134],"Finally,":[136],"generate":[138],"for":[141],"those":[142],"implications.":[148],"The":[149],"results":[150],"evaluations":[153],"indicate":[154],"common,":[159],"they":[161,176],"reveal":[163],"errors":[165],"weaknesses":[167],"simple":[174],"cases":[175],"be":[178],"refactored.":[179]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W1986951253","counts_by_year":[{"year":2014,"cited_by_count":1}],"updated_date":"2026-11-21T10:27:49.728292","created_date":"2016-06-24T00:00:00"}
