Related Experiment Video
Updated: Oct 29, 2025
Generation of Comprehensive Thoracic Oncology Database - Tool for Translational Research
Published on: January 22, 2011
Development of a customised data management system for a COVID-19-adapted colorectal cancer pathway
Janice Miller1,2, Frances Gunn1, Malcolm G Dunlop1,3
1Department of Colorectal Surgery, Western General Hospital, Edinburgh, UK.
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.
More Related Videos
06:46Competing-Risk Nomogram for Predicting Cancer-Specific Survival in Multiple Primary Colorectal Cancer Patients after Surgery
Published on: September 27, 2024
07:13Comparison of Predictive Performance of Three Lymph Node Staging Systems in Colorectal Signet Ring Cell Carcinoma Based on Machine Learning Model
Published on: April 18, 2025
Related Concept Videos
01:15Methods of Documentation VI: Case Management Model
For example, a patient with a chronic...
01:27Nursing Clinical Information System
A Nursing Clinical Information System (NCIS) is a specialized type of healthcare information system tailored to meet the unique needs of nursing practice. It incorporates the principles of nursing informatics to streamline information management and improve the quality of care delivery.
Critical attributes of NCIS include: