RT Journal Article
SR Electronic
T1 Development of a customised data management system for a COVID-19-adapted colorectal cancer pathway
JF BMJ Health & Care Informatics
JO BMJ Health Care Inform
FD BMJ Publishing Group Ltd
SP e100307
DO 10.1136/bmjhci-2020-100307
VO 28
IS 1
A1 Janice Miller
A1 Frances Gunn
A1 Malcolm G Dunlop
A1 Farhat VN Din
A1 Yasuko Maeda
YR 2021
UL http://informatics.bmj.com/content/28/1/e100307.abstract
AB Objectives A customised data management system was required for a rapidly implemented COVID-19-adapted colorectal cancer pathway in order to mitigate the risks of delayed and missed diagnoses during the pandemic. We assessed its performance and robustness.Methods A system was developed using Microsoft Excel (2007) to retain the spreadsheets’ intuitiveness of direct data entry. Visual Basic for Applications (VBA) was used to construct a user-friendly interface to enhance efficiency of data entry and segregate the data for operational tasks.Results Large data segregation was possible using VBA macros. Data validation and conditional formatting minimised data entry errors. Computation by the COUNT function facilitated live data monitoring.Conclusion It is possible to rapidly implement a makeshift database system with clinicians’ regular input. Large-volume data management using a spreadsheet system is possible with appropriate data definition and VBA-programmed data segregation. The described concept is applicable to any data management system construction requiring speed and flexibility in a resource-limited situation.Data are available upon reasonable request. Availability of data and material: A data cleaned file is available as a reference. Code availability: Available if contacted.