{"id":"https://openalex.org/W2006499508","doi":"https://doi.org/10.1145/2568225.2568316","title":"Is spreadsheet ambiguity harmful? detecting and repairing spreadsheet smells due to ambiguous computation","display_name":"Is spreadsheet ambiguity harmful? detecting and repairing spreadsheet smells due to ambiguous computation","publication_year":2014,"publication_date":"2014-05-20","ids":{"openalex":"https://openalex.org/W2006499508","doi":"https://doi.org/10.1145/2568225.2568316","mag":"2006499508"},"language":"en","primary_location":{"id":"doi:10.1145/2568225.2568316","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2568225.2568316","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 36th International Conference on Software Engineering","raw_type":"proceedings-article"},"type":"conference-paper","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/A5023724495","display_name":"Wensheng Dou","orcid":"https://orcid.org/0000-0002-3323-0449"},"institutions":[{"id":"https://openalex.org/I19820366","display_name":"Chinese Academy of Sciences","ror":"https://ror.org/034t30j35","country_code":"CN","type":"government","lineage":["https://openalex.org/I19820366"]},{"id":"https://openalex.org/I4210128818","display_name":"Institute of Software","ror":"https://ror.org/033dfsn42","country_code":"CN","type":"facility","lineage":["https://openalex.org/I19820366","https://openalex.org/I4210128818"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Wensheng Dou","raw_affiliation_strings":["Institute of Software at Chinese Academy of Sciences, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute of Software at Chinese Academy of Sciences, China","institution_ids":["https://openalex.org/I19820366","https://openalex.org/I4210128818"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034057959","display_name":"Shing-Chi Cheung","orcid":"https://orcid.org/0000-0002-3508-7172"},"institutions":[{"id":"https://openalex.org/I200769079","display_name":"Hong Kong University of Science and Technology","ror":"https://ror.org/00q4vv597","country_code":"HK","type":"education","lineage":["https://openalex.org/I200769079"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Shing-Chi Cheung","raw_affiliation_strings":["Hong Kong University of Science and Technology, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Hong Kong University of Science and Technology, China","institution_ids":["https://openalex.org/I200769079"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5037779332","display_name":"Jun Wei","orcid":"https://orcid.org/0000-0002-1028-8509"},"institutions":[{"id":"https://openalex.org/I19820366","display_name":"Chinese Academy of Sciences","ror":"https://ror.org/034t30j35","country_code":"CN","type":"government","lineage":["https://openalex.org/I19820366"]},{"id":"https://openalex.org/I4210128818","display_name":"Institute of Software","ror":"https://ror.org/033dfsn42","country_code":"CN","type":"facility","lineage":["https://openalex.org/I19820366","https://openalex.org/I4210128818"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jun Wei","raw_affiliation_strings":["Institute of Software at Chinese Academy of Sciences, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute of Software at Chinese Academy of Sciences, China","institution_ids":["https://openalex.org/I19820366","https://openalex.org/I4210128818"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":4.5068,"has_fulltext":false,"cited_by_count":47,"citation_normalized_percentile":{"value":0.9625641,"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":"848","last_page":"858"},"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.9998999834060669,"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.9998999834060669,"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/T11704","display_name":"Mobile Crowdsensing and Crowdsourcing","score":0.9301000237464905,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"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/T11875","display_name":"Statistics Education and Methodologies","score":0.9186999797821045,"subfield":{"id":"https://openalex.org/subfields/2613","display_name":"Statistics and Probability"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"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.8142886161804199},{"id":"https://openalex.org/keywords/ambiguity","display_name":"Ambiguity","score":0.7510054111480713},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.7173225283622742},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.717303991317749},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.4519871473312378},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.36288100481033325},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.3201838731765747}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8142886161804199},{"id":"https://openalex.org/C2780522230","wikidata":"https://www.wikidata.org/wiki/Q1140419","display_name":"Ambiguity","level":2,"score":0.7510054111480713},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.7173225283622742},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.717303991317749},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4519871473312378},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.36288100481033325},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3201838731765747}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/2568225.2568316","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2568225.2568316","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 36th International Conference on Software Engineering","raw_type":"proceedings-article"},{"id":"pmh:oai:repository.hkust.edu.hk:1783.1-66737","is_oa":false,"landing_page_url":"http://lbdiscover.ust.hk/uresolver?url_ver=Z39.88-2004&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rfr_id=info:sid/HKUST:SPI&rft.genre=article&rft.issn=&rft.volume=&rft.issue=&rft.date=2014&rft.spage=848&rft.aulast=Dou&rft.aufirst=Wensheng%7C&rft.atitle=Is%20Spreadsheet%20Ambiguity%20Harmful%3F%20Detecting%20and%20Repairing%20Spreadsheet%20Smells%20due%20to%20Ambiguous%20Computation&rft.title=ICSE%202014%3A%20Proceedings%20of%20the%2036th%20International%20Conference%20on%20Software%20Engineering","pdf_url":null,"source":{"id":"https://openalex.org/S4306401796","display_name":"Rare & Special e-Zone (The Hong Kong University of Science and Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I200769079","host_organization_name":"Hong Kong University of Science and Technology","host_organization_lineage":["https://openalex.org/I200769079"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Conference paper"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":38,"referenced_works":["https://openalex.org/W1515921409","https://openalex.org/W1531418056","https://openalex.org/W1571097741","https://openalex.org/W1933103375","https://openalex.org/W1958332869","https://openalex.org/W1970665021","https://openalex.org/W1974365737","https://openalex.org/W2010598806","https://openalex.org/W2044123923","https://openalex.org/W2060404275","https://openalex.org/W2080982416","https://openalex.org/W2083808198","https://openalex.org/W2095955261","https://openalex.org/W2097435116","https://openalex.org/W2109156518","https://openalex.org/W2117032538","https://openalex.org/W2129386590","https://openalex.org/W2132525863","https://openalex.org/W2134734244","https://openalex.org/W2135473121","https://openalex.org/W2136834093","https://openalex.org/W2138546883","https://openalex.org/W2142126234","https://openalex.org/W2142504747","https://openalex.org/W2149557049","https://openalex.org/W2150704968","https://openalex.org/W2152376725","https://openalex.org/W2153723363","https://openalex.org/W2156400118","https://openalex.org/W2162960800","https://openalex.org/W2164611950","https://openalex.org/W2169917840","https://openalex.org/W2584459836","https://openalex.org/W2917077002","https://openalex.org/W4243832068","https://openalex.org/W4388469698","https://openalex.org/W6634346572","https://openalex.org/W6676412903"],"related_works":["https://openalex.org/W2353179089","https://openalex.org/W2923538289","https://openalex.org/W2353125546","https://openalex.org/W2470643824","https://openalex.org/W2349635380","https://openalex.org/W2353819554","https://openalex.org/W2378011361","https://openalex.org/W2001280137","https://openalex.org/W2788308474","https://openalex.org/W2991618286"],"abstract_inverted_index":{"Spreadsheets":[0],"are":[1,23,61,75],"widely":[2],"used":[3],"by":[4,94],"end":[5],"users":[6],"for":[7,110],"numerical":[8],"computation":[9,16,66,92],"in":[10,26],"their":[11,96],"business.":[12],"Spreadsheet":[13],"cells":[14,54],"whose":[15],"is":[17,108],"subject":[18],"to":[19,41,63],"the":[20,56],"same":[21,57],"semantics":[22],"often":[24],"clustered":[25],"a":[27,32,83],"row":[28],"or":[29,45],"column.":[30],"When":[31],"spreadsheet":[33,115],"evolves,":[34],"these":[35],"cell":[36],"clusters":[37,50],"can":[38],"degenerate":[39],"due":[40],"ad":[42],"hoc":[43],"modifications":[44],"undisciplined":[46],"copy-and-pastes.":[47],"Such":[48],"degenerated":[49],"no":[51],"longer":[52],"keep":[53],"prescribing":[55],"computational":[58,98],"semantics,":[59],"and":[60,77,89,112],"said":[62],"exhibit":[64],"ambiguous":[65,91],"smells.":[67],"Our":[68],"empirical":[69],"study":[70,102],"finds":[71],"that":[72,86,106],"such":[73],"smells":[74,93],"common":[76],"likely":[78],"harmful.":[79],"We":[80],"propose":[81],"AmCheck,":[82],"novel":[84],"technique":[85],"automatically":[87],"detects":[88],"repairs":[90],"recovering":[95],"intended":[97],"semantics.":[99],"A":[100],"case":[101],"using":[103],"AmCheck":[104],"suggests":[105],"it":[107],"useful":[109],"discovering":[111],"repairing":[113],"real":[114],"problems.":[116]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":7},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":6},{"year":2017,"cited_by_count":6},{"year":2016,"cited_by_count":9},{"year":2015,"cited_by_count":4},{"year":2014,"cited_by_count":1}],"updated_date":"2026-07-30T17:31:21.811387","created_date":"2025-10-10T00:00:00"}