Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Experiment Videos

Self-scheduling with Microsoft Excel.

S A Irvin1, H N Brown

  • 1Novant Health, Winston-Salem, NC, USA.

Nursing Economic$
|March 11, 2000
PubMed
Summary
This summary is machine-generated.

Automating the emergency department (ED) scheduling process with Microsoft Excel significantly improved staff satisfaction and saved valuable time. This Excel-based system streamlined shift management, reducing errors and conflict for healthcare professionals.

Related Concept Videos

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

Search for Lorentz and CPT violation effects in Muon spin precession.

Physical review letters·2008
Same author

Measurement of the negative muon anomalous magnetic moment to 0.7 ppm.

Physical review letters·2004
Same author

Measurement of the positive muon anomalous magnetic moment to 0.7 ppm.

Physical review letters·2002
Same author

Precise measurement of the positive muon anomalous magnetic moment.

Physical review letters·2001
Same author

Connecting across the miles: interdisciplinary collaboration in the evaluation of critical thinking.

NursingConnections·2000
Same author

Mental disorders and syndromes found among Asians residing in the United States.

Issues in mental health nursing·2000
Same journal

Nursing Surveillance from Invisible to Measurable to Indispensable: The CONCERN Early Warning System Trial.

Nursing economic$·2026
Same journal

Evaluating the cost-effectiveness of pediatric concurrent versus standard hospice care.

Nursing economic$·2023
Same journal

Cost-Effectiveness of Advanced Practice Nurses Compared to Physician-Led Care for Chronic Diseases: A Systematic Review.

Nursing economic$·2021
Same journal

The perspectives of nurse practitioners and physicians on increasing the number of registered nurses in primary care.

Nursing economic$·2021
Same journal

From Single-Payer to All-Payer: Why Vermont's Reform Efforts Matter to U.S. Nurses and Their Patients.

Nursing economic$·2018
Same journal

Leveraging National Reports to Transform Ambulatory Care Practice.

Nursing economic$·2018
See all related articles

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.

Related Experiment Videos

  • 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.