Spreadsheets in Clinical Medicine

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 clinical medicine cannot be tolerated. It supports this warning by reporting on potentially serious weaknesses found while testing a limited number of publicly available clinical spreadsheets.

[1]  A. Kuten,et al.  Spreadsheet calculations of absorbed dose to water for photons and electrons according to established dosimetry protocols. , 1999, Medical dosimetry : official journal of the American Association of Medical Dosimetrists.

[2]  P. MacEneaney,et al.  Applying 'evidence-based medicine' theory to interventional radiology. Part 2: a spreadsheet for swift assessment of procedural benefit and harm. , 2000, Clinical radiology.

[3]  Jack W. Smith,et al.  Automated Medical Algorithms: Issues for Medical Errors , 2001 .

[4]  Grenville J. Croll A typical model audit approach , 2003 .

[5]  Dirk Verellen,et al.  A simple theoretical verification of monitor unit calculation for intensity modulated beams using dynamic mini-multileaf collimation. , 2004, Radiotherapy and oncology : journal of the European Society for Therapeutic Radiology and Oncology.

[6]  C. Marano,et al.  To err is human. Building a safer health system , 2005 .

[7]  Dil Sen The Medical Algorithms Project www.medal.org , 2005 .

[8]  Thomas A. Grossman Spreadsheet Engineering: A Research Framework , 2007, ArXiv.

[9]  Grenville J. Croll The Importance and Criticality of Spreadsheets in the City of London , 2007, ArXiv.

[10]  Raymond J. Butler Risk Assessment For Spreadsheet Developments: Choosing Which Models to Audit , 2008, ArXiv.

[11]  Raymond R. Panko,et al.  Spreadsheet Errors: What We Know. What We Think We Can Do , 2008, ArXiv.

[12]  Raymond R. Panko,et al.  Reducing Overconfidence in Spreadsheet Development , 2008, ArXiv.

[13]  Ann Monday,et al.  Interpretation as a factor in understanding flawed spreadsheets , 2008, ArXiv.