EXCEL AT TRIAGING: USING MICROSOFT’S WEB QUERY FUNCTIONALITY TO STREAMLINE THE TRIAGING PROCESS

Chirag R. Patel, DO, FHM, FACP*1;Daniel Rene Diaz, MD1;Sharon Santoso, MD1;Hilary Sasso-Schleh2 and Dustin Chase, MD1, (1)The Ohio State University Wexner Medical Center, Columbus, OH, (2)The Ohio State University, Columbus, OH

Meeting: Hospital Medicine 2017, May 1-4, 2017; Las Vegas, Nev.

Abstract number: 237

Categories: Innovations Abstracts, Technology in Hospital Medicine

Keywords: , ,

Background:

Triaging patients from the emergency room, an outside hospital or a service-line within your institution can be a challenging endeavor regardless of the size of your group. The Ohio State University Wexner Medical Center Division of Hospital Medicine (DoHM) faculty are the primary attendings for 21 unique service-lines each day across five hospitals. The triaging responsibilities of these services fall to a Hospitalist within the Division on a rotating basis each day. These service lines are associated with various census caps, geographic locales and clinical conditions. Given the sheer number and inherent intricacy associated with the individual service-lines there exists an opportunity for streamlining of a complex process.

Purpose:

Our institution continues to have growth in the number of new available beds creating the necessities of service-line census growth and new service creation. The DoHM is a primary recipient of these new opportunities. As such, the ever-growing nature of our clinical responsibilities and group necessitates workflow efficiencies and safeguards whenever possible.

The gateway to our services is the triaging process. A triage worksheet was created to assist in this process. The worksheet, maintained on internal institutional servers, is employed to allow the triaging Hospitalist to remain organized in this complex process while maintaining a secured informational record to ensure a patient is not lost to care assignment and follow up. Given the size of our group, number of daily service-lines and volume of patients triaged, having faculty contact information readily available was one key element in maximizing efficiency in this process.

Description:

The triage worksheet utilizes the ability of Microsoft ExcelTM to obtain data from outside sources to reflect shift assignments in real-time.  By establishing our scheduling portal as a data source and utilizing Excel’s web query function, it is possible to pull this data into the worksheet with subsequent automated cross-linking of our internal contact information database containing pager and cell phone numbers of the 84 DoHM faculty members.  By refreshing this data in real-time, we are able to create an automatically updating triage worksheet that can accurately reflect who is on service dynamically 24-hours a day with their contact information immediately available.

Conclusions:

Overall, our faculty have reported positive results with improved workflow efficiency, effectiveness and accuracy since the incorporation of Excel’s web query function into our triage worksheet. An added bonus of this process has been the improved provider satisfaction with an otherwise arduous and tedious task. In an era of ever-increasing competing demands on Hospital Medicine providers, as our experience shows, utilization of technology to streamline workflow is a necessity that can be done without being burdensome.

To cite this abstract:

Patel, CR; Diaz, DR; Santoso, S; Sasso-Schleh, H; Chase, D . EXCEL AT TRIAGING: USING MICROSOFT’S WEB QUERY FUNCTIONALITY TO STREAMLINE THE TRIAGING PROCESS. Abstract published at Hospital Medicine 2017, May 1-4, 2017; Las Vegas, Nev. Abstract 237. Journal of Hospital Medicine. 2017; 12 (suppl 2). https://www.shmabstracts.com/abstract/excel-at-triaging-using-microsofts-web-query-functionality-to-streamline-the-triaging-process/. Accessed September 23, 2019.

« Back to Hospital Medicine 2017, May 1-4, 2017; Las Vegas, Nev.