Self-scheduling with Microsoft Excel

Area of Science:

• Healthcare Management
• Nursing Administration
• Health Informatics

Background:

• Manual self-scheduling systems in emergency departments (EDs) are time-consuming and prone to errors.
• Existing scheduling processes led to staff dissatisfaction and inefficient use of resources.
• A need for a more efficient and accurate scheduling solution was identified.

Purpose of the Study:

• To automate and optimize the complex 6-week manual self-scheduling system in an ED.
• To improve staff satisfaction and reduce administrative burden through technological integration.
• To create a more equitable and efficient unit coverage model.

Main Methods:

• Implementation of a Microsoft Excel-based automated scheduling system.
• Standardized coding for 8-hour and 12-hour shifts, with 4-hour cell representation.
• Utilized Excel's "count-if" function for master schedule creation based on staffing guidelines.
• Incorporated staff time-off requests and head nurse finalization with staff input.

Main Results:

• Increased staff satisfaction with the scheduling process.
• Significant time savings for the head nurse and unit secretary.
• Reduced arguments and improved work time allocation for staff.
• Successful expansion of the automated system to a 700-bed hospital.

Conclusions:

• Automated scheduling using Microsoft Excel is a viable solution for improving ED operations.
• Technological integration can enhance staff satisfaction and operational efficiency in healthcare settings.
• The developed system demonstrated scalability and effectiveness across a large hospital network.