Creator of Knowledge
Information Resources Management Association
Advancing the Concepts & Practices of Information Resources Management in Modern Organizations

Spreadsheet Error Types and Their Prevalence in a Healthcare Context

Spreadsheet Error Types and Their Prevalence in a Healthcare Context
View Sample PDF
Author(s): Elaine Dobell (Saolta University Health Care Group, Galway, Ireland & University of Limerick, Limerick, Ireland), Sebastian Herold (Department of Mathematics and Computer Science, Karlstad University, Karlstad, Sweden) and Jim Buckley (CSIS / Lero – The Irish Software Research Centre, University of Limerick, Limerick, Ireland)
Copyright: 2018
Volume: 30
Issue: 2
Pages: 23
Source title: Journal of Organizational and End User Computing (JOEUC)
Editor(s)-in-Chief: Sang-Bing Tsai (University of Electronic Science and Technology of China Zhongshan Institute, China and Research Center for Environment and Sustainable Development, Civil Aviation University of China, China)
DOI: 10.4018/JOEUC.2018040102


View Spreadsheet Error Types and Their Prevalence in a Healthcare Context on the publisher's website for pricing and purchasing information.


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 ‘bottom-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.

Related Content

Lele Qin, Guojuan Zhang, Li You. © 2022. 18 pages.
Yanmei Zhao, Yixin Zhou. © 2022. 17 pages.
Zheng Cai. © 2022. 15 pages.
Yu-Hsi Yuan, Yi-Cheng Yeh, Chia-Huei Wu, Cheng-Yong Liu, Hsin-Hao Chen, Chien-Wen Chen. © 2022. 15 pages.
Jianzu Wu, Kunxin Zhang. © 2022. 13 pages.
Yunhong Xu, Guangyu Wu, Yu Chen. © 2022. 17 pages.
Qihua Liu, Li Wang, Jingyi Zhou, Wei Wu, Yiran Li. © 2022. 26 pages.
Body Bottom