{"id":"https://openalex.org/W2113234297","doi":"https://doi.org/10.4018/joeuc.2009070102","title":"Errors in Operational Spreadsheets","display_name":"Errors in Operational Spreadsheets","alternate_titles":[],"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":{"id":"doi:10.4018/joeuc.2009070102","doi":"https://doi.org/10.4018/joeuc.2009070102","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":false,"is_in_doaj":false,"is_core":true,"listed_in":["abdc-b","cwts-core","dongbi-b","erih-plus","fnege-4","jufo-1","norway-1","oarl","poland-40","russia-white-list-1"],"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":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Organizational and End User Computing","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W2113234297"],"child_works_count":0,"type":"article","is_traditional":true,"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":"https://orcid.org/0000-0002-8776-9845","observed_orcids":["https://orcid.org/0000-0002-8776-9845"]},"institutions":[{"id":"https://openalex.org/I107672454","display_name":"Dartmouth College","ror":"https://ror.org/049s0rh22","country_code":"US","type":"education","lineage":["https://openalex.org/I107672454"]}],"countries":["US"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Stephen G. Powell","raw_affiliation_strings":["Dartmouth College, USA"],"raw_orcid":null,"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","observed_orcids":["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":"education","lineage":["https://openalex.org/I107672454"]}],"countries":["US"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Kenneth R. Baker","raw_affiliation_strings":["Dartmouth College, USA"],"raw_orcid":null,"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,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I107672454","display_name":"Dartmouth College","ror":"https://ror.org/049s0rh22","country_code":"US","type":"education","lineage":["https://openalex.org/I107672454"]}],"countries":["US"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Barry Lawson","raw_affiliation_strings":["Dartmouth College, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Dartmouth College, USA","institution_ids":["https://openalex.org/I107672454"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I107672454"],"apc_list":{"value":4000,"currency":"USD","value_usd":4000},"apc_paid":null,"fwci":16.9786,"has_fulltext":false,"cited_by_count":90,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.99196622,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":86,"max":99},"biblio":{"volume":"21","issue":"3","first_page":"24","last_page":"36"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9994999766349792,"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.9994999766349792,"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/T10799","display_name":"Data Visualization and Analytics","score":0.0,"subfield":{"id":"https://openalex.org/subfields/1704","display_name":"Computer Graphics and Computer-Aided Design"},"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/T11734","display_name":"Decision Support System Applications","score":0.0,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/spreadsheet-errors","display_name":"spreadsheet errors","score":0.9909999966621399},{"id":"https://openalex.org/keywords/spreadsheet-auditing","display_name":"spreadsheet auditing","score":0.703000009059906},{"id":"https://openalex.org/keywords/formula-errors","display_name":"formula errors","score":0.7289999723434448},{"id":"https://openalex.org/keywords/error-prevalence","display_name":"error prevalence","score":0.75},{"id":"https://openalex.org/keywords/data-errors","display_name":"data errors","score":0.3230000138282776}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7757090330123901},{"id":"https://openalex.org/C199521495","wikidata":"https://www.wikidata.org/wiki/Q181487","display_name":"Audit","level":2,"score":0.6370867490768433},{"id":"https://openalex.org/C2780385302","wikidata":"https://www.wikidata.org/wiki/Q367158","display_name":"Protocol (science)","level":3,"score":0.5797557234764099},{"id":"https://openalex.org/C40969351","wikidata":"https://www.wikidata.org/wiki/Q3516228","display_name":"Word error rate","level":2,"score":0.5387142300605774},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.33174610137939453},{"id":"https://openalex.org/C121955636","wikidata":"https://www.wikidata.org/wiki/Q4116214","display_name":"Accounting","level":1,"score":0.1517031192779541},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.10076078772544861},{"id":"https://openalex.org/C71924100","wikidata":"https://www.wikidata.org/wiki/Q11190","display_name":"Medicine","level":0,"score":0.0},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"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/C204787440","wikidata":"https://www.wikidata.org/wiki/Q188504","display_name":"Alternative medicine","level":2,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.4018/joeuc.2009070102","doi":"https://doi.org/10.4018/joeuc.2009070102","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":false,"is_in_doaj":false,"is_core":true,"listed_in":["abdc-b","cwts-core","dongbi-b","erih-plus","fnege-4","jufo-1","norway-1","oarl","poland-40","russia-white-list-1"],"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":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Organizational and End User Computing","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:joeuc0:v:21:y:2009:i:3:p:24-36","doi":null,"is_oa":false,"landing_page_url":"http://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/joeuc.2009070102","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"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/W2138086333","https://openalex.org/W2121305681","https://openalex.org/W2782596258","https://openalex.org/W2133487099","https://openalex.org/W2995297220","https://openalex.org/W2150704968","https://openalex.org/W2112338634","https://openalex.org/W7099178134","https://openalex.org/W16688517","https://openalex.org/W1584834562"],"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]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2113234297","counts_by_year":[{"year":2026,"cited_by_count":4},{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":5},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":6},{"year":2016,"cited_by_count":4},{"year":2015,"cited_by_count":9},{"year":2014,"cited_by_count":3},{"year":2013,"cited_by_count":4},{"year":2012,"cited_by_count":6}],"updated_date":"2026-11-21T10:27:49.728292","created_date":"2016-06-24T00:00:00"}
