{"id":"https://openalex.org/W2113234297","doi":"https://doi.org/10.4018/joeuc.2009070102","title":"Errors in Operational Spreadsheets","display_name":"Errors in Operational Spreadsheets","publication_year":2009,"publication_date":"2009-07-01","ids":{"openalex":"https://openalex.org/W2113234297","doi":"https://doi.org/10.4018/joeuc.2009070102","mag":"2113234297"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.4018/joeuc.2009070102","pdf_url":null,"source":{"id":"https://openalex.org/S80285584","display_name":"Journal of Organizational and End User Computing","issn_l":"1546-2234","issn":["1546-2234","1546-5012"],"is_oa":true,"is_in_doaj":false,"is_indexed_in_scopus":true,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"journal-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/A5102088496","display_name":"Stephen G. Powell","orcid":null},"institutions":[{"id":"https://openalex.org/I107672454","display_name":"Dartmouth College","ror":"https://ror.org/049s0rh22","country_code":"US","type":"funder","lineage":["https://openalex.org/I107672454"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Stephen G. Powell","raw_affiliation_strings":["[Dartmouth College, USA]"],"affiliations":[{"raw_affiliation_string":"[Dartmouth College, USA]","institution_ids":["https://openalex.org/I107672454"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5054398717","display_name":"Kenneth R. Baker","orcid":"https://orcid.org/0000-0003-3124-3454"},"institutions":[{"id":"https://openalex.org/I107672454","display_name":"Dartmouth College","ror":"https://ror.org/049s0rh22","country_code":"US","type":"funder","lineage":["https://openalex.org/I107672454"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kenneth R. Baker","raw_affiliation_strings":["[Dartmouth College, USA]"],"affiliations":[{"raw_affiliation_string":"[Dartmouth College, USA]","institution_ids":["https://openalex.org/I107672454"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5086718855","display_name":"Barry Lawson","orcid":null},"institutions":[{"id":"https://openalex.org/I107672454","display_name":"Dartmouth College","ror":"https://ror.org/049s0rh22","country_code":"US","type":"funder","lineage":["https://openalex.org/I107672454"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Barry Lawson","raw_affiliation_strings":["[Dartmouth College, USA]"],"affiliations":[{"raw_affiliation_string":"[Dartmouth College, USA]","institution_ids":["https://openalex.org/I107672454"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":14.622,"has_fulltext":true,"fulltext_origin":"ngrams","cited_by_count":71,"citation_normalized_percentile":{"value":0.98689,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":97},"biblio":{"volume":"21","issue":"3","first_page":"24","last_page":"36"},"is_retracted":false,"is_paratext":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"}}],"keywords":[{"id":"https://openalex.org/keywords/word-error-rate","display_name":"Word error rate","score":0.53871423}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.77570903},{"id":"https://openalex.org/C199521495","wikidata":"https://www.wikidata.org/wiki/Q181487","display_name":"Audit","level":2,"score":0.63708675},{"id":"https://openalex.org/C2780385302","wikidata":"https://www.wikidata.org/wiki/Q367158","display_name":"Protocol (science)","level":3,"score":0.5797557},{"id":"https://openalex.org/C40969351","wikidata":"https://www.wikidata.org/wiki/Q3516228","display_name":"Word error rate","level":2,"score":0.53871423},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3317461},{"id":"https://openalex.org/C121955636","wikidata":"https://www.wikidata.org/wiki/Q4116214","display_name":"Accounting","level":1,"score":0.15170312},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.10076079},{"id":"https://openalex.org/C71924100","wikidata":"https://www.wikidata.org/wiki/Q11190","display_name":"Medicine","level":0,"score":0.0},{"id":"https://openalex.org/C204787440","wikidata":"https://www.wikidata.org/wiki/Q188504","display_name":"Alternative medicine","level":2,"score":0.0},{"id":"https://openalex.org/C142724271","wikidata":"https://www.wikidata.org/wiki/Q7208","display_name":"Pathology","level":1,"score":0.0},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.4018/joeuc.2009070102","pdf_url":null,"source":{"id":"https://openalex.org/S80285584","display_name":"Journal of Organizational and End User Computing","issn_l":"1546-2234","issn":["1546-2234","1546-5012"],"is_oa":true,"is_in_doaj":false,"is_indexed_in_scopus":true,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","score":0.46,"display_name":"Peace, justice, and strong institutions"}],"grants":[],"datasets":[],"versions":[],"referenced_works_count":8,"referenced_works":["https://openalex.org/W1571097741","https://openalex.org/W1693845937","https://openalex.org/W2038436770","https://openalex.org/W2112338634","https://openalex.org/W2133487099","https://openalex.org/W2150704968","https://openalex.org/W2150950289","https://openalex.org/W2159338092"],"related_works":["https://openalex.org/W4391913857","https://openalex.org/W2748952813","https://openalex.org/W2530322880","https://openalex.org/W2478288626","https://openalex.org/W2390279801","https://openalex.org/W2382290278","https://openalex.org/W2376932109","https://openalex.org/W2358668433","https://openalex.org/W2350741829","https://openalex.org/W2001405890"],"abstract_inverted_index":{"Spreadsheets":[0],"are":[1,62,111,143],"used":[2],"in":[3,17,40,90,131],"almost":[4],"all":[5,38,136],"businesses,":[6],"for":[7],"applications":[8],"ranging":[9],"from":[10,154],"the":[11,14,18,95,149],"mundane":[12],"to":[13,76,123,133,156],"mission-critical.":[15],"Errors":[16],"data,":[19],"formulas,":[20],"or":[21],"manipulation":[22],"of":[23,37,60,68,80,109,135],"spreadsheets":[24,41],"could":[25],"be":[26],"costly,":[27],"even":[28],"devastating.":[29],"The":[30],"received":[31],"wisdom":[32],"is":[33,47,54,94],"that":[34,148],"about":[35,88],"5%":[36],"formulas":[39],"contain":[42],"errors,":[43],"and":[44,65,106,120],"this":[45,52],"rate":[46,151],"consistent":[48],"across":[49],"spreadsheets.":[50,71,127],"However,":[51],"estimate":[53],"based":[55],"on":[56,140],"five":[57],"studies,":[58],"some":[59],"which":[61],"quite":[63],"informal,":[64],"a":[66,116],"total":[67],"only":[69],"43":[70],"Our":[72],"research":[73],"was":[74],"designed":[75],"deepen":[77],"our":[78],"understanding":[79],"spreadsheet":[81,117,155],"errors.":[82],"Specifically,":[83],"we":[84],"address":[85],"three":[86],"questions":[87],"errors":[89,110,130,142],"operational":[91,126],"spreadsheets:":[92],"what":[93,107],"average":[96],"cell":[97],"error":[98,150],"rate,":[99],"how":[100,141],"does":[101],"it":[102,122],"differ":[103],"among":[104],"spreadsheets,":[105],"types":[108],"most":[112],"prevalent?":[113],"We":[114,128,145],"created":[115],"auditing":[118],"protocol":[119],"applied":[121],"50":[124],"diverse":[125],"found":[129,147],"0.9%":[132],"1.8%":[134],"formula":[137],"cells,":[138],"depending":[139],"defined.":[144],"also":[146],"differed":[152],"widely":[153],"spreadsheet.":[157]},"abstract_inverted_index_v3":null,"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2113234297","counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":5},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":8},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":6}],"updated_date":"2025-03-23T10:20:33.408204","created_date":"2016-06-24"}