{"id":"https://openalex.org/W2782596258","doi":"https://doi.org/10.4018/joeuc.2018040102","title":"Spreadsheet Error Types and Their Prevalence in a Healthcare Context","display_name":"Spreadsheet Error Types and Their Prevalence in a Healthcare Context","publication_year":2018,"publication_date":"2018-01-11","ids":{"openalex":"https://openalex.org/W2782596258","doi":"https://doi.org/10.4018/joeuc.2018040102","mag":"2782596258"},"language":"en","primary_location":{"id":"doi:10.4018/joeuc.2018040102","is_oa":false,"landing_page_url":"https://doi.org/10.4018/joeuc.2018040102","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,"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"},"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/A5052157396","display_name":"Elaine Dobell","orcid":null},"institutions":[{"id":"https://openalex.org/I230495080","display_name":"University of Limerick","ror":"https://ror.org/00a0n9e72","country_code":"IE","type":"education","lineage":["https://openalex.org/I230495080"]},{"id":"https://openalex.org/I4210128306","display_name":"Saolta University Health Care Group","ror":"https://ror.org/03w2xw870","country_code":"IE","type":"healthcare","lineage":["https://openalex.org/I2800263200","https://openalex.org/I37076085","https://openalex.org/I4210128306","https://openalex.org/I4210136517"]}],"countries":["IE"],"is_corresponding":false,"raw_author_name":"Elaine Dobell","raw_affiliation_strings":["Saolta University Health Care Group, Galway, Ireland & University of Limerick, Limerick, Ireland"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Saolta University Health Care Group, Galway, Ireland & University of Limerick, Limerick, Ireland","institution_ids":["https://openalex.org/I230495080","https://openalex.org/I4210128306"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5001875840","display_name":"Sebastian Herold","orcid":"https://orcid.org/0000-0002-3180-9182"},"institutions":[{"id":"https://openalex.org/I43968019","display_name":"Karlstad University","ror":"https://ror.org/05s754026","country_code":"SE","type":"education","lineage":["https://openalex.org/I43968019"]}],"countries":["SE"],"is_corresponding":false,"raw_author_name":"Sebastian Herold","raw_affiliation_strings":["Department of Mathematics and Computer Science, Karlstad University, Karlstad, Sweden"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Mathematics and Computer Science, Karlstad University, Karlstad, Sweden","institution_ids":["https://openalex.org/I43968019"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5084329596","display_name":"Jim Buckley","orcid":"https://orcid.org/0000-0001-6928-6746"},"institutions":[{"id":"https://openalex.org/I230495080","display_name":"University of Limerick","ror":"https://ror.org/00a0n9e72","country_code":"IE","type":"education","lineage":["https://openalex.org/I230495080"]}],"countries":["IE"],"is_corresponding":false,"raw_author_name":"Jim Buckley","raw_affiliation_strings":["CSIS / Lero \u2013 The Irish Software Research Centre, University of Limerick, Limerick, Ireland"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"CSIS / Lero \u2013 The Irish Software Research Centre, University of Limerick, Limerick, Ireland","institution_ids":["https://openalex.org/I230495080"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.7927,"has_fulltext":false,"cited_by_count":15,"citation_normalized_percentile":{"value":0.89820743,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":"30","issue":"2","first_page":"20","last_page":"42"},"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6867853999137878},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.640354335308075},{"id":"https://openalex.org/keywords/audit","display_name":"Audit","score":0.6177653074264526},{"id":"https://openalex.org/keywords/health-care","display_name":"Health care","score":0.6047144532203674},{"id":"https://openalex.org/keywords/word-error-rate","display_name":"Word error rate","score":0.5198074579238892},{"id":"https://openalex.org/keywords/knowledge-management","display_name":"Knowledge management","score":0.3259602189064026},{"id":"https://openalex.org/keywords/accounting","display_name":"Accounting","score":0.24036115407943726},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.16154524683952332},{"id":"https://openalex.org/keywords/business","display_name":"Business","score":0.147050142288208}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6867853999137878},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.640354335308075},{"id":"https://openalex.org/C199521495","wikidata":"https://www.wikidata.org/wiki/Q181487","display_name":"Audit","level":2,"score":0.6177653074264526},{"id":"https://openalex.org/C160735492","wikidata":"https://www.wikidata.org/wiki/Q31207","display_name":"Health care","level":2,"score":0.6047144532203674},{"id":"https://openalex.org/C40969351","wikidata":"https://www.wikidata.org/wiki/Q3516228","display_name":"Word error rate","level":2,"score":0.5198074579238892},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.3259602189064026},{"id":"https://openalex.org/C121955636","wikidata":"https://www.wikidata.org/wiki/Q4116214","display_name":"Accounting","level":1,"score":0.24036115407943726},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.16154524683952332},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.147050142288208},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","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/C50522688","wikidata":"https://www.wikidata.org/wiki/Q189833","display_name":"Economic growth","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.4018/joeuc.2018040102","is_oa":false,"landing_page_url":"https://doi.org/10.4018/joeuc.2018040102","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,"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"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":37,"referenced_works":["https://openalex.org/W75601072","https://openalex.org/W572990348","https://openalex.org/W1514269045","https://openalex.org/W1578962373","https://openalex.org/W1579827372","https://openalex.org/W1594220124","https://openalex.org/W1658908529","https://openalex.org/W1677831939","https://openalex.org/W1974365737","https://openalex.org/W1987842730","https://openalex.org/W2037363397","https://openalex.org/W2038436770","https://openalex.org/W2052437048","https://openalex.org/W2058797051","https://openalex.org/W2074863738","https://openalex.org/W2097864578","https://openalex.org/W2108546879","https://openalex.org/W2112338634","https://openalex.org/W2112360310","https://openalex.org/W2113234297","https://openalex.org/W2121305681","https://openalex.org/W2133487099","https://openalex.org/W2133766618","https://openalex.org/W2133801508","https://openalex.org/W2146691185","https://openalex.org/W2150704968","https://openalex.org/W2154781260","https://openalex.org/W2159338092","https://openalex.org/W2460260222","https://openalex.org/W2754390843","https://openalex.org/W2810502739","https://openalex.org/W3124066374","https://openalex.org/W4210651582","https://openalex.org/W6630480585","https://openalex.org/W6634346572","https://openalex.org/W6635916446","https://openalex.org/W7023602391"],"related_works":["https://openalex.org/W2404937507","https://openalex.org/W3121186197","https://openalex.org/W2373849942","https://openalex.org/W151161666","https://openalex.org/W2030757640","https://openalex.org/W2118407572","https://openalex.org/W2071653420","https://openalex.org/W2260291664","https://openalex.org/W2360464208","https://openalex.org/W4366384404"],"abstract_inverted_index":{"Spreadsheets":[0],"are":[1,26],"commonly":[2],"used":[3],"to":[4,78],"inform":[5],"decision":[6],"making":[7],"across":[8],"many":[9],"business":[10],"sectors,":[11],"despite":[12],"the":[13,19,43,80,99,106,122,125],"fact":[14],"that":[15,24,94],"research":[16,133],"performed":[17,77],"in":[18,39,87],"financial":[20],"sector":[21],"has":[22],"shown":[23],"they":[25],"quite":[27],"error-prone.":[28],"However,":[29],"few":[30],"studies":[31],"have":[32],"investigated":[33],"spreadsheet":[34,54,84,136,149],"errors":[35,104,128],"and":[36,62,105,124,138,142,144,147,151],"their":[37],"impact":[38,120],"other":[40],"domains,":[41],"like":[42],"healthcare":[44,90],"sector.":[45],"This":[46],"article":[47],"derives":[48],"a":[49,71,115],"lifecycle-stage":[50],"classification":[51],"scheme":[52],"of":[53,82,98,121,127],"error":[55,85],"types":[56,86],"based":[57],"on":[58,68],"an":[59,88],"aggregation":[60],"of,":[61,64],"extension":[63],"existing":[65],"classifications.":[66],"Based":[67],"these":[69,83],"classifications,":[70],"case":[72],"study":[73],"is":[74],"then":[75],"presented,":[76],"investigate":[79],"prevalence":[81],"Irish":[89],"setting.":[91],"Results":[92],"reveal":[93],"more":[95],"than":[96],"90%":[97],"spreadsheets":[100,123],"studied":[101],"contained":[102],"\u2018bottom-line'":[103],"average":[107],"cell-error":[108],"rate":[109],"was":[110,113],"13%.":[111],"There":[112],"also":[114],"correlation":[116],"between":[117],"increased":[118],"perceived":[119],"number":[126],"identified.":[129],"Recommendations":[130],"from":[131],"this":[132],"include":[134],"providing":[135],"training":[137],"guidelines":[139],"for":[140],"developers":[141],"users,":[143],"systematically":[145],"managing":[146],"auditing":[148],"development":[150],"use.":[152]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":5},{"year":2019,"cited_by_count":1}],"updated_date":"2026-07-22T07:51:19.307946","created_date":"2025-10-10T00:00:00"}