UMB Data Catalog

A project of the Health Sciences and Human Services Library
UMB Dataset

Tools for Rapid Analysis of Blood Usage and Inventory During the COVID-19 Pandemic

UID: 113
* Corresponding Author
Description
The COVID-19 pandemic severely affected blood collection activities due to social distancing requirements, deferral of blood drives, and other measures to prevent spread of infection. Medical facilities also experienced changes in blood usage patterns with the cancellation of elective surgeries. To evaluate fluctuating blood inventory levels, the University of Maryland Medical Center (UMMC) built an R-based workflow to facilitate rapid and repeatable analysis and visualization of blood usage data extracted from the Cerner Laboratory Information System (LIS). The generation of daily reports by blood product and hospital unit promoted informed decision-making with regard to changing ordering practices to avoid wastage. This dataset consists of 5 R Markdown workflow files and one README file. The workflows will continue to be updated in the GitHub repository as additional R Markdown documents are written to assist in identifying large users, optimize data cleaning and product identification, establish safe inventory levels based on historical and recent usage, and establish web‐based functionality via the shiny pack.
Subject Domain
Keywords

Access

Instructions
Free to All
Access via GitHub

R Markdown files

Associated Publications
Data Type
Software Used
Cerner Laboratory
Epic EMR
R Markdown
RcppRoll
Tidyverse
Viridis
Dataset Format(s)
R Markdown