Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard1
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
Spreadsheet Error Types and Their Prevalence in a Healthcare Context
Saolta University Health Care Group, Ireland & University of Limerick, Ireland.
Karlstad University, Faculty of Health, Science and Technology (starting 2013), Department of Mathematics and Computer Science. (Software Engineering (SERG))ORCID iD: 0000-0002-3180-9182
University of Limerick, Ireland.
2018 (English)In: Journal of Organizational and End User Computing, ISSN 1546-2234, E-ISSN 1546-5012, Vol. 30, no 2, p. 20-42Article in journal (Refereed) Published
Abstract [en]

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.

Place, publisher, year, edition, pages
IGI Global, 2018. Vol. 30, no 2, p. 20-42
Keywords [en]
spreadsheet errors, audits, categorization, case study, healthcare
National Category
Software Engineering
Research subject
Computer Science
Identifiers
URN: urn:nbn:se:kau:diva-47815DOI: 10.4018/JOEUC.2018040102ISI: 000423761000002OAI: oai:DiVA.org:kau-47815DiVA, id: diva2:1070607
Available from: 2017-02-01 Created: 2017-02-01 Last updated: 2018-04-03Bibliographically approved

Open Access in DiVA

No full text in DiVA

Other links

Publisher's full text

Search in DiVA

By author/editor
Herold, Sebastian
By organisation
Department of Mathematics and Computer Science
In the same journal
Journal of Organizational and End User Computing
Software Engineering

Search outside of DiVA

GoogleGoogle Scholar

doi
urn-nbn

Altmetric score

doi
urn-nbn
Total: 317 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard1
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf