| Property | Value |
|---|
|
?:abstract
|
-
PurposeThe COVID-19 pandemic posed an unprecedented challenge to healthcare systems around the world. To mitigate the risks of those referred with possible colorectal cancer during the pandemic we implemented a clinical pathway which required a customised data management system for robust operation. Here, we describe the principal concepts and evaluation of the performance of a spreadsheet-based data management system. MethodsA system was developed using Microsoft Excel(R) 2007 aiming to retain the spreadsheets inherent intuitiveness of direct data entry. Data was itemised limiting entry errors. Visual Basic for Applications (VBA) was used to construct a user-friendly interface to enhance efficiency of data entry and segregate the data required for operational tasks. This was done with built-in loop-back data entry. Finally data derivation and analysis was performed to facilitate pathway monitoring. ResultsFor a pathway which required rapid implementation and development of a customised data management system, the use of a spreadsheet was advantageous due to its user-friendly direct data entry capability. Its function was enhanced by UserForm and large data handling by data segregation using VBA macros. Data validation and conditional formatting minimised data entry errors. Computation by the COUNT function facilitated live data monitoring on a dashboard. During the three months the pathway ran for, the system processed 36 nodal data points for each of the included 837 patients. Data monitoring confirmed its accuracy. ConclusionLarge volume data management using a spreadsheet system is possible with appropriate data definition and VBA programmed data segregation. Clinicians regular input and optimisation made the system adaptable for rapid implementation.
|
|
is
?:annotates
of
|
|
|
?:creator
|
|
|
?:doi
|
|
|
?:doi
|
-
10.1101/2020.10.05.20206920
|
|
?:license
|
|
|
?:publication_isRelatedTo_Disease
|
|
|
?:source
|
|
|
?:title
|
-
Development of a customised data management system for a COVID-19-adapted colorectal cancer pathway
|
|
?:type
|
|
|
?:who_covidence_id
|
|
|
?:year
|
|
![[This page as RDF]](https://research.tib.eu/covid-19/static/rdf-icon.gif){kind=icon}