{"id":"https://openalex.org/W2200894932","doi":"https://doi.org/10.1109/vlhcc.2015.7357210","title":"Detecting problematic lookup functions in spreadsheets","display_name":"Detecting problematic lookup functions in spreadsheets","publication_year":2015,"publication_date":"2015-10-01","ids":{"openalex":"https://openalex.org/W2200894932","doi":"https://doi.org/10.1109/vlhcc.2015.7357210","mag":"2200894932"},"language":"en","primary_location":{"id":"doi:10.1109/vlhcc.2015.7357210","is_oa":false,"landing_page_url":"https://doi.org/10.1109/vlhcc.2015.7357210","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 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/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"],"affiliations":[{"raw_affiliation_string":"Delft University of Technology","institution_ids":["https://openalex.org/I98358874"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5047667810","display_name":"Efthimia Aivaloglou","orcid":"https://orcid.org/0000-0002-6531-2166"},"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":"Efthimia Aivaloglou","raw_affiliation_strings":["Delft University of Technology"],"affiliations":[{"raw_affiliation_string":"Delft University of Technology","institution_ids":["https://openalex.org/I98358874"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5057383263","display_name":"Bas Jansen","orcid":"https://orcid.org/0000-0002-8298-1388"},"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":"Bas Jansen","raw_affiliation_strings":["Delft University of Technology"],"affiliations":[{"raw_affiliation_string":"Delft University of Technology","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":2.2228,"has_fulltext":false,"cited_by_count":8,"citation_normalized_percentile":{"value":0.88014808,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"153","last_page":"157"},"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/T11875","display_name":"Statistics Education and Methodologies","score":0.9652000069618225,"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"}},{"id":"https://openalex.org/T10260","display_name":"Software Engineering Research","score":0.9645000100135803,"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/computer-science","display_name":"Computer science","score":0.8208550214767456},{"id":"https://openalex.org/keywords/lookup-table","display_name":"Lookup table","score":0.7440505623817444},{"id":"https://openalex.org/keywords/function","display_name":"Function (biology)","score":0.577593982219696},{"id":"https://openalex.org/keywords/range","display_name":"Range (aeronautics)","score":0.5547109842300415},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.44675353169441223},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3808388113975525},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3449811339378357},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2838967442512512}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8208550214767456},{"id":"https://openalex.org/C134835016","wikidata":"https://www.wikidata.org/wiki/Q690265","display_name":"Lookup table","level":2,"score":0.7440505623817444},{"id":"https://openalex.org/C14036430","wikidata":"https://www.wikidata.org/wiki/Q3736076","display_name":"Function (biology)","level":2,"score":0.577593982219696},{"id":"https://openalex.org/C204323151","wikidata":"https://www.wikidata.org/wiki/Q905424","display_name":"Range (aeronautics)","level":2,"score":0.5547109842300415},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.44675353169441223},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3808388113975525},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3449811339378357},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2838967442512512},{"id":"https://openalex.org/C126042441","wikidata":"https://www.wikidata.org/wiki/Q1324888","display_name":"Frame (networking)","level":2,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C78458016","wikidata":"https://www.wikidata.org/wiki/Q840400","display_name":"Evolutionary biology","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/vlhcc.2015.7357210","is_oa":false,"landing_page_url":"https://doi.org/10.1109/vlhcc.2015.7357210","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)","raw_type":"proceedings-article"},{"id":"pmh:oai:tudelft.nl:uuid:4ad537a6-2fcb-4294-adf1-1b8c17cae41d","is_oa":false,"landing_page_url":"http://resolver.tudelft.nl/uuid:4ad537a6-2fcb-4294-adf1-1b8c17cae41d","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":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.41999998688697815}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":18,"referenced_works":["https://openalex.org/W40493055","https://openalex.org/W1515921409","https://openalex.org/W1531418056","https://openalex.org/W1579695396","https://openalex.org/W1808011207","https://openalex.org/W1958332869","https://openalex.org/W2025677988","https://openalex.org/W2026539153","https://openalex.org/W2038340833","https://openalex.org/W2054520963","https://openalex.org/W2080982416","https://openalex.org/W2144849164","https://openalex.org/W2151867683","https://openalex.org/W2153887189","https://openalex.org/W2156400118","https://openalex.org/W2787379525","https://openalex.org/W6601684420","https://openalex.org/W6681259122"],"related_works":["https://openalex.org/W2798215405","https://openalex.org/W2990962948","https://openalex.org/W2084169748","https://openalex.org/W2127529229","https://openalex.org/W2355515259","https://openalex.org/W2124289628","https://openalex.org/W1822998120","https://openalex.org/W2181722423","https://openalex.org/W2165625444","https://openalex.org/W2524480813"],"abstract_inverted_index":{"Spreadsheets":[0],"are":[1,12,43,84,151],"used":[2,46,152],"heavily":[3],"in":[4,72,109,173],"many":[5],"business":[6],"domains":[7],"around":[8],"the":[9,90,93,104,117,136,174],"world.":[10],"They":[11],"easy":[13],"to":[14,22,35,87,179],"use":[15,105,135],"and":[16,23,25,31,40,50,57,75,154,176],"as":[17],"such":[18],"enable":[19],"end-user":[20],"programmers":[21],"build":[24],"maintain":[26],"all":[27],"sorts":[28],"of":[29,106,130,132,148,157],"reports":[30,49],"analyses.":[32],"In":[33,99],"addition":[34],"using":[36],"spreadsheets":[37,42],"for":[38,47,69],"modeling":[39],"calculation,":[41],"often":[44],"also":[45],"creating":[48,58],"dashboards:":[51],"combining":[52],"data":[53],"from":[54],"different":[55],"sources":[56],"overviews.":[59],"For":[60],"this,":[61],"lookup":[62,107,114,133],"functions":[63,83,108,115],"can":[64],"be":[65,144],"used:":[66],"they":[67,162],"search":[68,163],"a":[70,73,77,128],"value":[71],"range":[74],"return":[76],"corresponding":[78],"row":[79],"or":[80],"column.":[81],"Lookup":[82],"common:":[85],"according":[86],"recent":[88],"research":[89],"VLOOKUP":[91],"is":[92,160,169],"fifth":[94],"most":[95],"common":[96],"Excel":[97],"function.":[98],"this":[100,168],"paper":[101],"we":[102],"investigate":[103],"more":[110],"detail.":[111],"We":[112],"analyze":[113],"within":[116],"newly":[118],"released":[119],"Enron":[120],"spreadsheet":[121],"corpus.":[122],"The":[123],"results":[124],"show":[125],"that":[126],"1)":[127],"minority":[129],"43%":[131],"formulas":[134],"default":[137],"setting":[138],"where":[139],"an":[140],"approximate":[141,149,158],"match":[142],"may":[143],"returned,":[145],"2)":[146],"77%":[147],"matches":[150],"unnecessary":[153],"3)":[155],"23%":[156],"lookups":[159],"problematic:":[161],"over":[164],"unsorted":[165],"ranges,":[166],"while":[167],"specifically":[170],"advised":[171],"against":[172],"specification,":[175],"might":[177],"lead":[178],"wrong":[180],"results.":[181]},"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2016,"cited_by_count":4}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}