{"id":"https://openalex.org/W1531418056","doi":"https://doi.org/10.1109/icse.2012.6227171","title":"Detecting and visualizing inter-worksheet smells in spreadsheets","display_name":"Detecting and visualizing inter-worksheet smells in spreadsheets","publication_year":2012,"publication_date":"2012-06-01","ids":{"openalex":"https://openalex.org/W1531418056","doi":"https://doi.org/10.1109/icse.2012.6227171","mag":"1531418056"},"language":"en","primary_location":{"id":"doi:10.1109/icse.2012.6227171","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icse.2012.6227171","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2012 34th International Conference on Software Engineering (ICSE)","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"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":["Software Engineering Research Group, Delft University of Technology, Delft, Netherlands"],"affiliations":[{"raw_affiliation_string":"Software Engineering Research Group, Delft University of Technology, Delft, 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":["Software Engineering Research Group, Delft University of Technology, Delft, Netherlands"],"affiliations":[{"raw_affiliation_string":"Software Engineering Research Group, Delft University of Technology, Delft, 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":["Software Engineering Research Group, Delft University of Technology, Delft, Netherlands"],"affiliations":[{"raw_affiliation_string":"Software Engineering Research Group, Delft University of Technology, Delft, 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":11.7992,"has_fulltext":false,"cited_by_count":72,"citation_normalized_percentile":{"value":0.98899048,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"441","last_page":"451"},"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.9423999786376953,"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.9423999786376953,"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.021900000050663948,"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.006200000178068876,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/computer-science","display_name":"Computer science","score":0.7635650038719177},{"id":"https://openalex.org/keywords/code-smell","display_name":"Code smell","score":0.7564747333526611},{"id":"https://openalex.org/keywords/usability","display_name":"Usability","score":0.6232633590698242},{"id":"https://openalex.org/keywords/maintainability","display_name":"Maintainability","score":0.5816590785980225},{"id":"https://openalex.org/keywords/worksheet","display_name":"Worksheet","score":0.49827146530151367},{"id":"https://openalex.org/keywords/strengths-and-weaknesses","display_name":"Strengths and weaknesses","score":0.4904119670391083},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.48250365257263184},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.48183953762054443},{"id":"https://openalex.org/keywords/software-quality","display_name":"Software quality","score":0.4182093143463135},{"id":"https://openalex.org/keywords/quality","display_name":"Quality (philosophy)","score":0.4146324098110199},{"id":"https://openalex.org/keywords/software-development","display_name":"Software development","score":0.23863977193832397},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.22110259532928467},{"id":"https://openalex.org/keywords/human\u2013computer-interaction","display_name":"Human\u2013computer interaction","score":0.2072167694568634}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7635650038719177},{"id":"https://openalex.org/C133237599","wikidata":"https://www.wikidata.org/wiki/Q2295111","display_name":"Code smell","level":5,"score":0.7564747333526611},{"id":"https://openalex.org/C170130773","wikidata":"https://www.wikidata.org/wiki/Q216378","display_name":"Usability","level":2,"score":0.6232633590698242},{"id":"https://openalex.org/C160713754","wikidata":"https://www.wikidata.org/wiki/Q1389965","display_name":"Maintainability","level":2,"score":0.5816590785980225},{"id":"https://openalex.org/C176734034","wikidata":"https://www.wikidata.org/wiki/Q259432","display_name":"Worksheet","level":2,"score":0.49827146530151367},{"id":"https://openalex.org/C63882131","wikidata":"https://www.wikidata.org/wiki/Q17122954","display_name":"Strengths and weaknesses","level":2,"score":0.4904119670391083},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.48250365257263184},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.48183953762054443},{"id":"https://openalex.org/C117447612","wikidata":"https://www.wikidata.org/wiki/Q1412670","display_name":"Software quality","level":4,"score":0.4182093143463135},{"id":"https://openalex.org/C2779530757","wikidata":"https://www.wikidata.org/wiki/Q1207505","display_name":"Quality (philosophy)","level":2,"score":0.4146324098110199},{"id":"https://openalex.org/C529173508","wikidata":"https://www.wikidata.org/wiki/Q638608","display_name":"Software development","level":3,"score":0.23863977193832397},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.22110259532928467},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.2072167694568634},{"id":"https://openalex.org/C145420912","wikidata":"https://www.wikidata.org/wiki/Q853077","display_name":"Mathematics education","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1109/icse.2012.6227171","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icse.2012.6227171","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2012 34th International Conference on Software Engineering (ICSE)","raw_type":"proceedings-article"},{"id":"pmh:oai:tudelft.nl:uuid:3dec0b24-47c8-43ad-a8e4-be5fb2cc7e4d","is_oa":false,"landing_page_url":"http://resolver.tudelft.nl/uuid:3dec0b24-47c8-43ad-a8e4-be5fb2cc7e4d","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":"pmh:oai:tudelft.nl:uuid:ef3a8486-f88e-4d05-a749-1d288363b8b1","is_oa":false,"landing_page_url":"http://resolver.tudelft.nl/uuid:ef3a8486-f88e-4d05-a749-1d288363b8b1","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":"report"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.6000000238418579,"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":28,"referenced_works":["https://openalex.org/W148417311","https://openalex.org/W1511796393","https://openalex.org/W1534729839","https://openalex.org/W1659044373","https://openalex.org/W1889354467","https://openalex.org/W1970665021","https://openalex.org/W1974645280","https://openalex.org/W1974655094","https://openalex.org/W2088117279","https://openalex.org/W2093495548","https://openalex.org/W2093987194","https://openalex.org/W2096832718","https://openalex.org/W2105237266","https://openalex.org/W2112338634","https://openalex.org/W2138086333","https://openalex.org/W2153887189","https://openalex.org/W2159433976","https://openalex.org/W2169082151","https://openalex.org/W2169917840","https://openalex.org/W3204635089","https://openalex.org/W4230945824","https://openalex.org/W6606062131","https://openalex.org/W6630382925","https://openalex.org/W6635916446","https://openalex.org/W6637107664","https://openalex.org/W6639525157","https://openalex.org/W6642922620","https://openalex.org/W6680389700"],"related_works":["https://openalex.org/W2001730430","https://openalex.org/W3046890777","https://openalex.org/W1974189775","https://openalex.org/W4244517042","https://openalex.org/W2306701168","https://openalex.org/W2219145617","https://openalex.org/W4236840126","https://openalex.org/W1648987790","https://openalex.org/W1514851312","https://openalex.org/W4233305372"],"abstract_inverted_index":{"Spreadsheets":[0],"are":[1,26,47,156],"often":[2],"used":[3],"in":[4,69,121,131,147],"business,":[5],"for":[6,12,32,62],"simple":[7],"tasks,":[8],"as":[9,11,17],"well":[10],"mission":[13],"critical":[14],"tasks":[15],"such":[16],"finance":[18],"or":[19,39,51],"forecasting.":[20],"Similar":[21],"to":[22,36,86,95,100,104,160],"software,":[23],"some":[24],"spreadsheets":[25,46],"of":[27,118,137],"better":[28],"quality":[29],"than":[30],"others,":[31],"instance":[33],"with":[34,43,107],"respect":[35],"usability,":[37],"maintainability":[38],"reliability.":[40],"In":[41,53],"contrast":[42],"software":[44],"however,":[45],"rarely":[48],"checked,":[49],"tested":[50],"certified.":[52],"this":[54],"paper,":[55],"we":[56,76,115,126],"aim":[57],"at":[58],"developing":[59],"an":[60,93,132,157],"approach":[61,94],"detecting":[63],"smells":[64,80,85,103,120,142],"that":[65,74,141,152],"indicate":[66,140],"weak":[67],"points":[68],"a":[70,148],"spreadsheet's":[71,149],"design.":[72],"To":[73,111],"end":[75],"first":[77],"study":[78],"code":[79,84],"and":[81,99,151],"transform":[82],"these":[83,119],"their":[87],"spreadsheet":[88,105],"counterparts.":[89],"We":[90],"then":[91],"present":[92],"detect":[96],"the":[97,122,138],"smells,":[98],"communicate":[101],"located":[102],"users":[106],"data":[108,153],"flow":[109,154],"diagrams.":[110],"evaluate":[112],"our":[113],"apporach,":[114],"analyzed":[116],"occurrences":[117],"Euses":[123],"corpus.":[124],"Furthermore":[125],"conducted":[127],"ten":[128],"case":[129],"studies":[130],"industrial":[133],"setting.":[134],"The":[135],"results":[136],"evaluation":[139],"can":[143],"indeed":[144],"reveal":[145],"weaknesses":[146],"design,":[150],"diagrams":[155],"appropriate":[158],"way":[159],"show":[161],"those":[162],"weaknesses.":[163]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":5},{"year":2018,"cited_by_count":6},{"year":2017,"cited_by_count":6},{"year":2016,"cited_by_count":12},{"year":2015,"cited_by_count":10},{"year":2014,"cited_by_count":12},{"year":2013,"cited_by_count":5},{"year":2012,"cited_by_count":3}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}