Using spreadsheets to create a patient centered inpatient scheduling program
The objective of this presentation is to demonstrate a patient centered inpatient scheduling system in the acute rehabilitation setting. By the end of the presentation the participant should be able to complete the following: identify the advantages of using spreadsheets with VBA macros to customize a workbook for specific needs, follow a patient centered scheduling model, design a methodical approach to implementing such a model.
A systematic approach was used to create and implement the scheduling system. This included software design, recruitment of a patient centered inpatient scheduler, and development of a communication structure.
Overall customer satisfaction (likelihood to recommend) increased 7% and three hour compliance increased over 20% following implementation of this scheduling model.
Using a workbook/spreadsheets to construct the model made implementation easier since it did not require use or knowledge of new software. Upon use of the new patient centered scheduling program the hospital was able to increase therapy productivity and engagement, three hour compliance and customer satisfaction.
Learning Areas:Communication and informatics
Identify the advantages of using spreadsheets with macros to customize a workbook for specific needs
Keyword(s): Patient Satisfaction, Performance Measurement
Qualified on the content I am responsible for because: I developed the Inpatient Scheduling system, the process and the VBA macros it uses.
Any relevant financial relationships? No
I agree to comply with the American Public Health Association Conflict of Interest and Commercial Support Guidelines, and to disclose to the participants any off-label or experimental uses of a commercial product or service discussed in my presentation.