Data Collection Materials

Cross-Campus Dialysis Resource Tracking Dashboard

Stevens, Jacob S.

We developed a data-driven approach to analyze and guide our response to the COVID-19 surge using web-based spreadsheets to track continuous renal replacement therapy (CRRT) and hemodialysis (HD) censuses and dialysis supplies. Each site enters the details of their own CRRT and HD programs, which then automatically populated the Enterprise-wide RRT Dashboards. The CRRT dashboard also includes the current count of cartridges and bags of therapy fluid available at each site and at the central warehouse. The projected number of days of supply remaining for each site and for the entire enterprise based on the size of the CRRT census was automatically calculated and color-coded. The dashboard allowed for identification of hospitals that were disproportionally affected, and aided in enterprise-level decisions to shift resources between hospitals or from central storage. Similarly, the HD dashboard allowed for quick, visual reporting of the status of working machines, census sizes, nurses, and HD technicians at each site. Both tools were critical in decision-making that occurred nightly on the cross-campus conference calls, and allowed for the equitable sharing of resources across a large, complex healthcare system.


  • thumnail for Cross-Campus CRRT and HD Tracking for AC - 2020.08.05.xlsx Cross-Campus CRRT and HD Tracking for AC - 2020.08.05.xlsx application/vnd.openxmlformats-officedocument.spreadsheetml.sheet 448 KB Download File

More About This Work

Academic Units
Columbia University Division of Nephrology Tracking Tools
Published Here
August 10, 2020