Self-scheduling with Microsoft Excel.
Excessive time was being spent by the emergency department (ED) staff, head nurse, and unit secretary on a complex 6-week manual self-scheduling system. This issue, plus inevitable errors and staff dissatisfaction, resulted in a manager-lead initiative to automate elements of the scheduling process...
| Publicado en: | Nursing Economic$ Vol. 17; no. 4; pp. 201 - 207 |
|---|---|
| Autores principales: | , |
| Formato: | forms tables/charts Journal Article |
| Publicado: |
Jannetti Publications, Inc.
Jul/Aug99
|
| Acceso en línea: | Ver este registro en EBSCOhost |
| fields | @attributes: recordID: 1 pdfLink: plink: https://search.ebscohost.com/login.aspx?direct=true&db=ccm&AN=107210182&site=ehost-live header: @attributes: shortDbName: ccm uiTerm: 107210182 longDbName: CINAHL Complete uiTag: AN controlInfo: bkinfo: dissinfo: jinfo: jid: 07461739 22R jtl: Nursing Economic$ issn: 07461739 maglogo: N pubinfo: dt: Jul/Aug99 vid: 17 iid: 4 pid: 4135 pub: Jannetti Publications, Inc. place: Pitman, New Jersey artinfo: ui: 107210182 107210182 1999062310 NLM10711163 107210182 ppf: 201 ppct: 6 formats: fmt: @attributes: type: P tig: atl: Self-scheduling with Microsoft Excel. aug: au: Irvin SA Brown HN affil: Corporate Educator, Novant Health, Winston-Salem, NC sug: subj: Personnel Staffing and Scheduling Software Emergency Nursing Time Factors Emergency Service Employee Attitudes Evaluation ab: Excessive time was being spent by the emergency department (ED) staff, head nurse, and unit secretary on a complex 6-week manual self-scheduling system. This issue, plus inevitable errors and staff dissatisfaction, resulted in a manager-lead initiative to automate elements of the scheduling process using Microsoft Excel. The implementation of this initiative included: common coding of all 8-hour and 12-hour shifts, with each 4-hour period represented by a cell; the creation of a 6-week master schedule using the 'count-if' function of Excel based on current staffing guidelines; staff time-off requests then entered by the department secretary; the head nurse, with staff input, then fine-tuned the schedule to provide even unit coverage. Outcomes of these changes included an increase in staff satisfaction, time saved by the head nurse, and staff work time saved because there was less arguing about the schedule. Uultimately, this automated self-scheduling method was expanded to the entire 700-bed hospital. pubtype: Academic Journal doctype: forms tables/charts Journal Article ougenre: Article language: English refInfo: holdings: @attributes: islocal: N |
|---|