{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,1,27]],"date-time":"2026-01-27T16:25:53Z","timestamp":1769531153059,"version":"3.49.0"},"reference-count":47,"publisher":"IGI Global","issue":"2","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2018,4]]},"abstract":"<jats:p>Spreadsheets are commonly used to inform decision making across many business sectors, despite the fact that research performed in the financial sector has shown that they are quite error-prone. However, few studies have investigated spreadsheet errors and their impact in other domains, like the healthcare sector. This article derives a lifecycle-stage classification scheme of spreadsheet error types based on an aggregation of, and extension of, existing classifications. Based on these classifications, a case study is then presented, performed to investigate the prevalence of these spreadsheet error types in an Irish healthcare setting. Results reveal that more than 90% of the spreadsheets studied contained \u2018bottom-line' errors and the average cell-error rate was 13%. There was also a correlation between increased perceived impact of the spreadsheets and the number of errors identified. Recommendations from this research include providing spreadsheet training and guidelines for developers and users, and systematically managing and auditing spreadsheet development and use.<\/jats:p>","DOI":"10.4018\/joeuc.2018040102","type":"journal-article","created":{"date-parts":[[2018,1,11]],"date-time":"2018-01-11T21:12:37Z","timestamp":1515705157000},"page":"20-42","source":"Crossref","is-referenced-by-count":13,"title":["Spreadsheet Error Types and Their Prevalence in a Healthcare Context"],"prefix":"10.4018","volume":"30","author":[{"given":"Elaine","family":"Dobell","sequence":"first","affiliation":[{"name":"Saolta University Health Care Group, Galway, Ireland & University of Limerick, Limerick, Ireland"}]},{"given":"Sebastian","family":"Herold","sequence":"additional","affiliation":[{"name":"Department of Mathematics and Computer Science, Karlstad University, Karlstad, Sweden"}]},{"given":"Jim","family":"Buckley","sequence":"additional","affiliation":[{"name":"CSIS \/ Lero \u2013 The Irish Software Research Centre, University of Limerick, Limerick, Ireland"}]}],"member":"2432","reference":[{"key":"JOEUC.2018040102-0","doi-asserted-by":"publisher","DOI":"10.1109\/ASE.2003.1240305"},{"key":"JOEUC.2018040102-1","unstructured":"Arnott, M. (2011). Introduction to Spreadsheet Risk Management. Retrieved December 14, 2015, from http:\/\/chandoo.org\/wp\/2011\/12\/07\/spreadsheet-risk-management-introduction\/"},{"key":"JOEUC.2018040102-2","unstructured":"Ayalew, Y., Clermont, M., & Mittermeir, R. T. (2000). Detecting Errors in Spreadsheets. Paper presented at the EuSpRIG Conference 2000."},{"key":"JOEUC.2018040102-3","unstructured":"Baxter, R. (2012). Spreadsheet risk: The devil is in the data. Retrieved December 14, 2015, from http:\/\/www.financialdirector.co.uk\/financial-director\/feature\/2163414\/spreadsheet-risk-devil"},{"key":"JOEUC.2018040102-4","unstructured":"Bewig, P. L. (2005). How do you know your spreadsheet is right? Paper presented at the EuSpRIG Conference 2005."},{"key":"JOEUC.2018040102-5","first-page":"3","article-title":"Research design and issues of validity","author":"M. B.Brewer","year":"2000","journal-title":"Handbook of research methods in social and personality psychology"},{"key":"JOEUC.2018040102-6","unstructured":"Burdick, T. (2008). Improving Spreatsheet Audits in Six Steps. Retrieved December 14, 2015, from https:\/\/iaonline.theiia.org\/improving-spreadsheet-audits-in-six-steps"},{"key":"JOEUC.2018040102-7","unstructured":"Campbell, M. P. (2010). Spreadsheet Issues: Pitfalls, Best Practices, and Practical Tips. Actuarial Practice Forum, February 2010 Issue."},{"issue":"3","key":"JOEUC.2018040102-8","first-page":"26","article-title":"Are Spreadsheet Error Undermining Decision-Making in Your Organization?","volume":"24","author":"J. P.Caulkins","year":"2006","journal-title":"Nonprofit World"},{"key":"JOEUC.2018040102-9","unstructured":"Croll, G. J., & Butler, R. J. (2006). Spreadsheets in Clinical Medicine-A Public Health Warning. Paper presented at the EuSpRIG Conference 2006."},{"key":"JOEUC.2018040102-10","unstructured":"Dobell, E., Herold, S., & Buckley, J. (2016). Spreadsheet Error Categorization and Audit Documentation. Retrieved October 27, 2016 from http:\/\/lero.ie\/sites\/default\/files\/TR_2015_02_Buckley%20J_Spreadsheet%20Error%20Categorization%20and%20Audit%20Documentation.pdf"},{"key":"JOEUC.2018040102-11","author":"E.Ferguson","year":"2011","journal-title":"Minimising Spreadsheet Errors"},{"key":"JOEUC.2018040102-12","doi-asserted-by":"publisher","DOI":"10.1109\/HICSS.1996.495417"},{"key":"JOEUC.2018040102-13","author":"B.Glaser","year":"1967","journal-title":"The Discovery of Grounded Theory: Strategies for Qualitative Research"},{"key":"JOEUC.2018040102-14","doi-asserted-by":"publisher","DOI":"10.1111\/j.1540-4609.2006.00104.x"},{"key":"JOEUC.2018040102-15","doi-asserted-by":"publisher","DOI":"10.1016\/j.infsof.2005.04.005"},{"key":"JOEUC.2018040102-16","doi-asserted-by":"publisher","DOI":"10.4018\/joeuc.2015010102"},{"key":"JOEUC.2018040102-17","doi-asserted-by":"publisher","DOI":"10.2307\/2010991"},{"issue":"1","key":"JOEUC.2018040102-18","first-page":"128","article-title":"Spreadsheet Error Detection: An Empirical Examination in the Context of Greece. Business","volume":"10","author":"D.Maditinos","year":"2012","journal-title":"Management in Education"},{"key":"JOEUC.2018040102-19","author":"M. L.Mitchell","year":"2004","journal-title":"Research Design Explained"},{"key":"JOEUC.2018040102-20","author":"P.O\u2019Beirne","year":"2005","journal-title":"Spreadsheet Check and Control: 47 Key Practices to Detect and Prevent Errors. Gorey, Co. Wexford"},{"key":"JOEUC.2018040102-21","unstructured":"O\u2019Beirne, P., Hermans, F., & Cheng, T. (2013). EuSpRIG Horror Stories. Retrieved December 14, 2015, from http:\/\/www.eusprig.org\/horror-stories.htm"},{"key":"JOEUC.2018040102-22","unstructured":"O\u2019Brien, M. P., Shaft, T. M., & Buckley, J. (2001). An open-source analysis schema for identifying software comprehension processes. Psychology of Programming workshop PPIG 2001."},{"key":"JOEUC.2018040102-23","doi-asserted-by":"publisher","DOI":"10.4018\/joeuc.1998040102"},{"key":"JOEUC.2018040102-24","unstructured":"Panko, R. R. (2000). Spreadsheet Errors: What We Know. What We Think We Can Do. Paper presented at the EuSpRIG Conference 2000."},{"key":"JOEUC.2018040102-25","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2010.02.009"},{"key":"JOEUC.2018040102-26","doi-asserted-by":"publisher","DOI":"10.1109\/HICSS.1996.495416"},{"key":"JOEUC.2018040102-27","doi-asserted-by":"publisher","DOI":"10.1108\/02635570010353938"},{"key":"JOEUC.2018040102-28","doi-asserted-by":"publisher","DOI":"10.1016\/j.im.2008.03.004"},{"key":"JOEUC.2018040102-29","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2008.06.001"},{"key":"JOEUC.2018040102-30","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2009.02.002"},{"key":"JOEUC.2018040102-31","doi-asserted-by":"publisher","DOI":"10.4018\/joeuc.2009070102"},{"key":"JOEUC.2018040102-32","unstructured":"Price Waterhouse Coopers, P. W. C. (2004). The Use of Spreadsheets: Considerations for Section 404 of the Sarbanes-Oxley Act, Whitepaper published in July 2004. Retrieved 4th June 2016 from: http:\/\/www.spreadsheetcontrols.org\/index.php?option=com_content&view=article&id=73:pwc-the-use-of-spreadsheets-considerations-for-section-404-of-the-sarbanes-oxley-act&catid=36:sarbanes&Itemid=58"},{"key":"JOEUC.2018040102-33","unstructured":"Pryor, L. (2003). Correctness is not enough. Paper presented at the EuSpRIG Conference 2003."},{"key":"JOEUC.2018040102-34","unstructured":"Purser, M., & Chadwick, D. R. (2006). Does an awareness of differing types of spreadsheet error aid end-users in identifying spreadsheets errors? Paper presented at the EuSpRIG Conference 2006."},{"key":"JOEUC.2018040102-35","unstructured":"Rajalingham, K. (2005). A Revised Classification of Spreadsheet Errors. Paper presented at the EuSpRIG Conference 2005."},{"key":"JOEUC.2018040102-36","unstructured":"Rajalingham, K., Chadwick, D. R., & Knight, B. (2000). Classification of Spreadsheet Errors. Paper presented at the EuSpRIG Conference 2000."},{"key":"JOEUC.2018040102-37","author":"N.Read","year":"1999","journal-title":"Spreadsheet Modelling Best Practice"},{"key":"JOEUC.2018040102-38","doi-asserted-by":"publisher","DOI":"10.1017\/CBO9781139062367"},{"key":"JOEUC.2018040102-39","doi-asserted-by":"publisher","DOI":"10.1145\/63238.63244"},{"key":"JOEUC.2018040102-40","doi-asserted-by":"publisher","DOI":"10.1006\/ijhc.1994.1086"},{"key":"JOEUC.2018040102-41","year":"2013","journal-title":"Best Practice Spreadsheet Modeling Standards: Spreadsheet Standards Review Board"},{"key":"JOEUC.2018040102-42","author":"A.Strauss","year":"1998","journal-title":"Basics of Qualitative Research Techniques and Procedures for Developing Grounded Theory"},{"key":"JOEUC.2018040102-43","doi-asserted-by":"crossref","unstructured":"Teo, T. S. H., & Lee-Partridge, J. E. (2001). Effects of error factors and prior incremental practice on spreadsheet error detection: an experimental study. Omega \u2013 The International Journal of Management Science, 29(5), 445-456.","DOI":"10.1016\/S0305-0483(01)00037-8"},{"key":"JOEUC.2018040102-44","doi-asserted-by":"publisher","DOI":"10.1109\/HICSS.1997.661583"},{"key":"JOEUC.2018040102-45","doi-asserted-by":"publisher","DOI":"10.1016\/j.compedu.2008.05.006"},{"key":"JOEUC.2018040102-46","author":"R. K.Yin","year":"2003","journal-title":"Case Study Research: Design and Methods"}],"container-title":["Journal of Organizational and End User Computing"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=197349","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,5,6]],"date-time":"2022-05-06T11:46:18Z","timestamp":1651837578000},"score":1,"resource":{"primary":{"URL":"http:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/JOEUC.2018040102"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2018,4]]},"references-count":47,"journal-issue":{"issue":"2"},"URL":"https:\/\/doi.org\/10.4018\/joeuc.2018040102","relation":{},"ISSN":["1546-2234","1546-5012"],"issn-type":[{"value":"1546-2234","type":"print"},{"value":"1546-5012","type":"electronic"}],"subject":[],"published":{"date-parts":[[2018,4]]}}}