• Corpus ID: 15658150

Spreadsheets in Clinical Medicine - A Public Health Warning

@inproceedings{Croll2006SpreadsheetsIC,
  title={Spreadsheets in Clinical Medicine - A Public Health Warning},
  author={G. J. Croll and Raymond J. Butler},
  year={2006}
}
There is overwhelming evidence that the continued and widespread use of untested spreadsheets in business gives rise to regular, significant and unexpected financial losses. Whilst this is worrying, it is perhaps a relatively minor concern compared with the risks arising from the use of poorly constructed and/or untested spreadsheets in medicine, a practice that is already occurring. This article is intended as a warning that the use of poorly constructed and/or untested spreadsheets in… 

Spreadsheet Error Types and Their Prevalence in a Healthcare Context

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. Ho

Reducing Spreadsheet Risk with FormulaDataSleuth

TLDR
FormulaDataSleuth provides a means of checking spreadsheet formulas and data as they are developed or used, enabling the users to identify actual or potential errors quickly and thereby halt their propagation.

Spreadsheets and the Financial Collapse

TLDR
There is a link between the use of spreadsheets and the recent collapse of the global financial system, and governments and regulating authorities are provided with some simple recommendations to reduce the risks of continued overdependence on unreliable spreadsheets.

Spreadsheet Error Categorization and Audit Documentation

Background Studies suggest that spreadsheet development and usage is error-prone and spreadsheet errors are “common and non-trivial” (Panko 2000). Overviews published by Kruck (2006) and Panko

The Role of Spreadsheets in Clinical Decision Support: A Survey of the Medical Algorithms Company User Community

Conference paper published in Proceedings of the EuSpRIG 2017 Conference "Spreadsheet Risk Management

ASP, The Art and Science of Practice: Increasing Productivity and Minimizing Errors in Operations Research Spreadsheet Models

TLDR
This work examines some problem areas for spreadsheet design and programming and suggests techniques intended to increase productivity and reduce the risk of errors, especially in situations in which someone other than the original author is using or maintaining the spreadsheets.

The Lookup Technique to Replace Nested-IF Formulas in Spreadsheet Programming

TLDR
The "lookup technique" is investigated as an alternative to nested-IF formulas, its benefits for testing and auditing, and its limitations are described.

References

SHOWING 1-10 OF 24 REFERENCES

Risk Assessment For Spreadsheet Developments: Choosing Which Models to Audit

TLDR
Risk assessment based on the "SpACE" audit methodology used by H M Customs & Excise's tax inspectors is described, which allows the auditor to target resources on the spreadsheets posing the highest risk of error, and justify the deployment of those resources to managers and clients.

Applying 'evidence-based medicine' theory to interventional radiology. Part 2: a spreadsheet for swift assessment of procedural benefit and harm.

AIM To design a spreadsheet program to analyse interventional radiology (IR) data rapidly produced in local research or reported in the literature using 'evidence-based medicine' (EBM) parameters of

A typical model audit approach

Spreadsheet audit and review procedures are an essential part of almost all City of London financial transactions. Structured processes are used to discover errors in large financial spreadsheets

Reducing Overconfidence in Spreadsheet Development

TLDR
Two experiments in overconfidence in spreadsheet development are described, including a pilot study to determine the existence of overconfidence, and a manipulation to reduce overconfidence and errors.

The Importance and Criticality of Spreadsheets in the City of London

TLDR
The author suggests that the City of London is presently exposed to significant reputational risk through the continued uncontrolled use of critical spreadsheets in the financial markets and elsewhere.

To err is human. Building a safer health system

TLDR
The IOM report “To Err is Human” proposes an approach for reducing medical errors and improving patient safety by designing processes that are able to ensure that patients are safe from accidental injury.

Spreadsheet Errors: What We Know. What We Think We Can Do

TLDR
To date, only one technique, cell-by-cell code inspection, has been demonstrated to be effective, and the degree to which other techniques can reduce spreadsheet errors needs to be determined.

Interpretation as a factor in understanding flawed spreadsheets

TLDR
The problems of mechanical production and the problems of translation of problem to spreadsheet representation are considered.

Spreadsheet Engineering: A Research Framework

TLDR
Spreadsheet engineering adapts the lessons of software engineering to spreadsheets, providing eight principles as a framework for organizing spreadsheet programming recommendations to overcome the heterogeneity of spreadsheet users.

Spreadsheet calculations of absorbed dose to water for photons and electrons according to established dosimetry protocols.

  • M. CederbaumA. Kuten
  • Physics, Medicine
    Medical dosimetry : official journal of the American Association of Medical Dosimetrists
  • 1999