A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2021; you can also visit <a rel="external noopener" href="https://informatics.bmj.com/content/bmjhci/28/1/e100307.full.pdf">the original URL</a>. The file type is <code>application/pdf</code>.
<a target="_blank" rel="noopener" href="https://fatcat.wiki/container/3rpcnwhn4vg6xpwkrsvh6dljrq" style="color: black;">BMJ Health & Care Informatics</a>
ObjectivesA 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.MethodsA 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<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1136/bmjhci-2020-100307">doi:10.1136/bmjhci-2020-100307</a> <a target="_blank" rel="external noopener" href="https://www.ncbi.nlm.nih.gov/pubmed/34244178">pmid:34244178</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/zbysizbrqvcexacxmssrndzrvm">fatcat:zbysizbrqvcexacxmssrndzrvm</a> </span>
more »... d segregate the data for operational tasks.ResultsLarge 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.ConclusionIt 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.
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20210709174635/https://informatics.bmj.com/content/bmjhci/28/1/e100307.full.pdf" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="https://blobs.fatcat.wiki/thumbnail/pdf/6b/76/6b764e2daa009b52a34a7a4e8dd616cfb848dd09.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1136/bmjhci-2020-100307"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="unlock alternate icon" style="background-color: #fb971f;"></i> bmj.org </button> </a>