{"id":"https://openalex.org/W2554473058","doi":"https://doi.org/10.1109/vlhcc.2016.7739679","title":"Finding errors in the Enron spreadsheet corpus","display_name":"Finding errors in the Enron spreadsheet corpus","publication_year":2016,"publication_date":"2016-09-01","ids":{"openalex":"https://openalex.org/W2554473058","doi":"https://doi.org/10.1109/vlhcc.2016.7739679","mag":"2554473058"},"language":"en","primary_location":{"id":"doi:10.1109/vlhcc.2016.7739679","is_oa":false,"landing_page_url":"https://doi.org/10.1109/vlhcc.2016.7739679","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2016 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)","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/A5090974146","display_name":"Thomas Schmitz","orcid":"https://orcid.org/0000-0001-9605-1117"},"institutions":[{"id":"https://openalex.org/I200332995","display_name":"TU Dortmund University","ror":"https://ror.org/01k97gp34","country_code":"DE","type":"education","lineage":["https://openalex.org/I200332995"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Thomas Schmitz","raw_affiliation_strings":["TU Dortmund, Germany"],"affiliations":[{"raw_affiliation_string":"TU Dortmund, Germany","institution_ids":["https://openalex.org/I200332995"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5005545405","display_name":"Dietmar Jannach","orcid":"https://orcid.org/0000-0002-4698-8507"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Dietmar Jannach","raw_affiliation_strings":["Technische Universitat Dortmund, Dortmund, Nordrhein-Westfalen, DE"],"affiliations":[{"raw_affiliation_string":"Technische Universitat Dortmund, Dortmund, Nordrhein-Westfalen, DE","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5090974146"],"corresponding_institution_ids":["https://openalex.org/I200332995"],"apc_list":null,"apc_paid":null,"fwci":5.4198,"has_fulltext":false,"cited_by_count":19,"citation_normalized_percentile":{"value":0.96233058,"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":"157","last_page":"161"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":1.0,"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":1.0,"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/T11875","display_name":"Statistics Education and Methodologies","score":0.9814000129699707,"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.8297852277755737},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.7582140564918518},{"id":"https://openalex.org/keywords/identification","display_name":"Identification (biology)","score":0.7107306718826294},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.5942491292953491},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.42323359847068787},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.40063944458961487},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.3365047872066498},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.29290252923965454},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.09537610411643982}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8297852277755737},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.7582140564918518},{"id":"https://openalex.org/C116834253","wikidata":"https://www.wikidata.org/wiki/Q2039217","display_name":"Identification (biology)","level":2,"score":0.7107306718826294},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.5942491292953491},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.42323359847068787},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.40063944458961487},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.3365047872066498},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.29290252923965454},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.09537610411643982},{"id":"https://openalex.org/C59822182","wikidata":"https://www.wikidata.org/wiki/Q441","display_name":"Botany","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/vlhcc.2016.7739679","is_oa":false,"landing_page_url":"https://doi.org/10.1109/vlhcc.2016.7739679","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2016 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320321181","display_name":"Austrian Science Fund","ror":"https://ror.org/013tf3c58"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":18,"referenced_works":["https://openalex.org/W324914531","https://openalex.org/W1648616135","https://openalex.org/W1966514306","https://openalex.org/W1980990846","https://openalex.org/W2000784509","https://openalex.org/W2022114557","https://openalex.org/W2038340833","https://openalex.org/W2038436770","https://openalex.org/W2086674260","https://openalex.org/W2095955261","https://openalex.org/W2112338634","https://openalex.org/W2118596993","https://openalex.org/W2135473121","https://openalex.org/W2152376725","https://openalex.org/W2169917840","https://openalex.org/W4230392236","https://openalex.org/W6636946909","https://openalex.org/W6964970211"],"related_works":["https://openalex.org/W2280422768","https://openalex.org/W3143197806","https://openalex.org/W4252555497","https://openalex.org/W3121175838","https://openalex.org/W3016293053","https://openalex.org/W1690653314","https://openalex.org/W2401723157","https://openalex.org/W2784269775","https://openalex.org/W2952904874","https://openalex.org/W324626582"],"abstract_inverted_index":{"Spreadsheet":[0],"environments":[1],"like":[2],"MS":[3],"Excel":[4],"are":[5,27],"the":[6,36,46,56,83,99,106,131,143],"most":[7],"widespread":[8],"type":[9],"of":[10,58,65,98,110,123,126,133,146],"end-user":[11],"software":[12,104],"development":[13],"tools":[14],"and":[15,60,75,102],"spreadsheet-based":[16],"applications":[17],"can":[18],"be":[19],"found":[20],"almost":[21],"everywhere":[22],"in":[23,35],"organizations.":[24],"Since":[25],"spreadsheets":[26,109],"prone":[28],"to":[29,39,77,130],"error,":[30],"several":[31],"approaches":[32],"were":[33,49,61],"proposed":[34,47],"research":[37],"literature":[38],"help":[40,94],"users":[41],"locate":[42],"formula":[43,80,138],"errors.":[44,139,149],"However,":[45],"methods":[48],"often":[50],"designed":[51],"based":[52,90],"on":[53,91],"assumptions":[54],"about":[55],"nature":[57],"errors":[59,81],"evaluated":[62],"with":[63],"mutations":[64],"correct":[66],"spreadsheets.":[67],"In":[68],"this":[69],"work":[70],"we":[71,112],"propose":[72],"a":[73,124],"method":[74],"tool":[76],"identify":[78,96,108],"realworld":[79],"within":[82],"Enron":[84],"spreadsheet":[85,101,148],"corpus.":[86],"Our":[87],"approach":[88],"is":[89],"heuristics":[92],"that":[93,114],"us":[95],"versions":[97],"same":[100],"our":[103],"helps":[105],"user":[107],"which":[111],"assume":[113],"they":[115],"contain":[116],"error":[117],"corrections.":[118],"An":[119],"initial":[120],"manual":[121],"inspection":[122],"subset":[125],"such":[127],"candidates":[128],"led":[129],"identification":[132],"more":[134],"than":[135],"two":[136],"dozen":[137],"We":[140],"publicly":[141],"share":[142],"new":[144],"collection":[145],"real-world":[147]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":6},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":1}],"updated_date":"2025-11-25T21:42:39.735039","created_date":"2025-10-10T00:00:00"}