{"id":"https://openalex.org/W1497777582","doi":"https://doi.org/10.1109/icsm.2012.6405300","title":"Detecting code smells in spreadsheet formulas","display_name":"Detecting code smells in spreadsheet formulas","publication_year":2012,"publication_date":"2012-09-01","ids":{"openalex":"https://openalex.org/W1497777582","doi":"https://doi.org/10.1109/icsm.2012.6405300","mag":"1497777582"},"language":"en","primary_location":{"id":"doi:10.1109/icsm.2012.6405300","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icsm.2012.6405300","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2012 28th IEEE International Conference on Software Maintenance (ICSM)","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://repository.tudelft.nl/file/File_565ad6fe-2b4e-4dc7-b1b3-a80e7e6f3a1b","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"},"institutions":[{"id":"https://openalex.org/I98358874","display_name":"Delft University of Technology","ror":"https://ror.org/02e2c7k09","country_code":"NL","type":"education","lineage":["https://openalex.org/I98358874"]}],"countries":["NL"],"is_corresponding":true,"raw_author_name":"Felienne Hermans","raw_affiliation_strings":["Delft University of Technology, Delft, the Netherlands"],"affiliations":[{"raw_affiliation_string":"Delft University of Technology, Delft, the Netherlands","institution_ids":["https://openalex.org/I98358874"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5052107936","display_name":"Martin Pinzger","orcid":"https://orcid.org/0000-0002-5536-3859"},"institutions":[{"id":"https://openalex.org/I98358874","display_name":"Delft University of Technology","ror":"https://ror.org/02e2c7k09","country_code":"NL","type":"education","lineage":["https://openalex.org/I98358874"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Martin Pinzger","raw_affiliation_strings":["Delft University of Technology, Delft, the Netherlands"],"affiliations":[{"raw_affiliation_string":"Delft University of Technology, Delft, the Netherlands","institution_ids":["https://openalex.org/I98358874"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5090401584","display_name":"Arie van Deursen","orcid":"https://orcid.org/0000-0003-4850-3312"},"institutions":[{"id":"https://openalex.org/I98358874","display_name":"Delft University of Technology","ror":"https://ror.org/02e2c7k09","country_code":"NL","type":"education","lineage":["https://openalex.org/I98358874"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Arie van Deursen","raw_affiliation_strings":["Delft University of Technology, Delft, the Netherlands"],"affiliations":[{"raw_affiliation_string":"Delft University of Technology, Delft, the Netherlands","institution_ids":["https://openalex.org/I98358874"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5034150823"],"corresponding_institution_ids":["https://openalex.org/I98358874"],"apc_list":null,"apc_paid":null,"fwci":1.1756,"has_fulltext":true,"cited_by_count":6,"citation_normalized_percentile":{"value":0.7954279,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"409","last_page":"418"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9876000285148621,"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.9876000285148621,"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/T11719","display_name":"Data Quality and Management","score":0.9689000248908997,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10260","display_name":"Software Engineering Research","score":0.9623000025749207,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/code-smell","display_name":"Code smell","score":0.8667818307876587},{"id":"https://openalex.org/keywords/maintainability","display_name":"Maintainability","score":0.7512655258178711},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7468751072883606},{"id":"https://openalex.org/keywords/visualization","display_name":"Visualization","score":0.6380361318588257},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.5527052283287048},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.5117413997650146},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.4991624355316162},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.4565422832965851},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.3283712565898895},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.32451754808425903},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3233606815338135},{"id":"https://openalex.org/keywords/software-quality","display_name":"Software quality","score":0.24989676475524902},{"id":"https://openalex.org/keywords/software-development","display_name":"Software development","score":0.22054925560951233}],"concepts":[{"id":"https://openalex.org/C133237599","wikidata":"https://www.wikidata.org/wiki/Q2295111","display_name":"Code smell","level":5,"score":0.8667818307876587},{"id":"https://openalex.org/C160713754","wikidata":"https://www.wikidata.org/wiki/Q1389965","display_name":"Maintainability","level":2,"score":0.7512655258178711},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7468751072883606},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.6380361318588257},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.5527052283287048},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.5117413997650146},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.4991624355316162},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4565422832965851},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.3283712565898895},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.32451754808425903},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3233606815338135},{"id":"https://openalex.org/C117447612","wikidata":"https://www.wikidata.org/wiki/Q1412670","display_name":"Software quality","level":4,"score":0.24989676475524902},{"id":"https://openalex.org/C529173508","wikidata":"https://www.wikidata.org/wiki/Q638608","display_name":"Software development","level":3,"score":0.22054925560951233},{"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":4,"locations":[{"id":"doi:10.1109/icsm.2012.6405300","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icsm.2012.6405300","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2012 28th IEEE International Conference on Software Maintenance (ICSM)","raw_type":"proceedings-article"},{"id":"pmh:tud:oai:tudelft.nl:uuid:a6bd3669-55a9-45e0-9a1e-b7f64365bb51","is_oa":true,"landing_page_url":"http://resolver.tudelft.nl/uuid:a6bd3669-55a9-45e0-9a1e-b7f64365bb51","pdf_url":"https://repository.tudelft.nl/file/File_565ad6fe-2b4e-4dc7-b1b3-a80e7e6f3a1b","source":{"id":"https://openalex.org/S4306401843","display_name":"Data Archiving and Networked Services (DANS)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1322597698","host_organization_name":"Royal Netherlands Academy of Arts and Sciences","host_organization_lineage":["https://openalex.org/I1322597698"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Technical Report Series TUD-SERG-2011-030","raw_type":"info:eu-repo/semantics/report"},{"id":"pmh:oai:tudelft.nl:uuid:4c1546a6-b5ec-43e2-9acc-3065e0164c0d","is_oa":false,"landing_page_url":"http://resolver.tudelft.nl/uuid:4c1546a6-b5ec-43e2-9acc-3065e0164c0d","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,"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":"conference paper"},{"id":"mag:1497777582","is_oa":false,"landing_page_url":"https://repository.tudelft.nl/islandora/object/uuid%3Aa6bd3669-55a9-45e0-9a1e-b7f64365bb51","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":null}],"best_oa_location":{"id":"pmh:tud:oai:tudelft.nl:uuid:a6bd3669-55a9-45e0-9a1e-b7f64365bb51","is_oa":true,"landing_page_url":"http://resolver.tudelft.nl/uuid:a6bd3669-55a9-45e0-9a1e-b7f64365bb51","pdf_url":"https://repository.tudelft.nl/file/File_565ad6fe-2b4e-4dc7-b1b3-a80e7e6f3a1b","source":{"id":"https://openalex.org/S4306401843","display_name":"Data Archiving and Networked Services (DANS)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1322597698","host_organization_name":"Royal Netherlands Academy of Arts and Sciences","host_organization_lineage":["https://openalex.org/I1322597698"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Technical Report Series TUD-SERG-2011-030","raw_type":"info:eu-repo/semantics/report"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W1497777582.pdf","grobid_xml":"https://content.openalex.org/works/W1497777582.grobid-xml"},"referenced_works_count":20,"referenced_works":["https://openalex.org/W1515921409","https://openalex.org/W1531418056","https://openalex.org/W2010598806","https://openalex.org/W2026539153","https://openalex.org/W2088117279","https://openalex.org/W2093987194","https://openalex.org/W2097435116","https://openalex.org/W2112338634","https://openalex.org/W2126634149","https://openalex.org/W2151295763","https://openalex.org/W2168075363","https://openalex.org/W2169917840","https://openalex.org/W4230945824","https://openalex.org/W4242277969","https://openalex.org/W6630382925","https://openalex.org/W6634479942","https://openalex.org/W6635916446","https://openalex.org/W6640276229","https://openalex.org/W6642922620","https://openalex.org/W6680389700"],"related_works":["https://openalex.org/W2080982416","https://openalex.org/W2144849164","https://openalex.org/W1986951253","https://openalex.org/W1531418056","https://openalex.org/W3166878122","https://openalex.org/W2026539153","https://openalex.org/W2151867683","https://openalex.org/W3135526658","https://openalex.org/W2101526741","https://openalex.org/W2099535882","https://openalex.org/W2884919545","https://openalex.org/W2756039569","https://openalex.org/W2192907926","https://openalex.org/W3135402948","https://openalex.org/W39048145","https://openalex.org/W2466744397","https://openalex.org/W3166181464","https://openalex.org/W2759794714","https://openalex.org/W2886571402","https://openalex.org/W2036570657"],"abstract_inverted_index":{"Spreadsheets":[0],"are":[1,15,116],"used":[2],"extensively":[3],"in":[4,56,65,73,127],"business":[5],"processes":[6],"around":[7],"the":[8,60,79,85,88,100,104],"world":[9],"and":[10,48,62,98,118,125],"just":[11],"like":[12],"software,":[13],"spreadsheets":[14],"changed":[16],"throughout":[17],"their":[18],"lifetime":[19],"causing":[20],"maintainability":[21],"issues.":[22],"This":[23],"paper":[24],"adapts":[25],"known":[26],"code":[27],"smells":[28,115],"to":[29,52,69,83],"spreadsheet":[30,81,101,128],"formulas.":[31,129],"To":[32],"that":[33,113,119],"end":[34],"we":[35,43,77,92],"present":[36],"a":[37,49,66],"list":[38],"of":[39,87,109],"metrics":[40,61],"by":[41],"which":[42],"can":[44,121],"detect":[45],"smelly":[46],"formulas":[47,55],"visualization":[50,63],"technique":[51,64],"highlight":[53],"these":[54,110],"spreadsheets.":[57],"We":[58],"implemented":[59],"prototype":[67],"tool":[68],"evaluate":[70],"our":[71],"approach":[72],"two":[74],"ways.":[75],"Firstly,":[76],"analyze":[78,93],"EUSES":[80],"corpus,":[82],"study":[84],"occurrence":[86],"formula":[89,114],"smells.":[90,106],"Secondly,":[91],"ten":[94],"real":[95,123],"life":[96],"spreadsheets,":[97],"interview":[99],"owners":[102],"about":[103],"identified":[105],"The":[107],"results":[108],"evaluations":[111],"indicate":[112],"common":[117],"they":[120],"reveal":[122],"errors":[124],"weaknesses":[126]},"counts_by_year":[{"year":2018,"cited_by_count":1},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}