Spreadsheet: 36037d1233782943-strange-thing-only-on-one-computer-running-this-xls-final-schedule-jw-test
Sheet: FINAL SCHEDULE

 | FINAL DAY Schedule |  |  |  |  |  |  |  |  |  | As of: |  |  | 2009-02-04 13:17:05 |  |  |  |  |  |  |  | START DATE: |  |  | 2009-03-22 00:00:00 |  |  | Sun |  | END DATE: |  |  | 2009-05-02 00:00:00 |  |  | Sat
 |  |  |  | AT WORK CODES: |  |  |  |  |  |  |  | OFF WORK CODES: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCHEDULING RULES
 |  |  |  | D =  Day shift Patient Care |  |  |  |  |  |  |  | a =  available to be scheduled that shift if needed |  |  |  |  |  |  |  |  |  |  |  |  | Full Time Employees must work a Minimum of 4 Weekend (WE) Shifts in each 6 Week Schedule
 |  |  |  | N =  Night shift- Patient Care |  |  |  |  |  |  |  | x =  Employee requests to not work shift if possible |  |  |  |  |  |  |  |  |  |  |  |  |  | (PF Lab and [NAME] do not have weekend requirements)
 |  |  |  | O = Orientation-  Orientee |  |  |  |  |  |  |  | r =  Employee is Requesting Vacation or PTO-   (Not yet approved) |  |  |  |  |  |  |  |  |  |  |  |  | If Vacation or PTO is NOT Approved,  enter "r" until [NAME] is received
 |  |  |  | P = PF Lab or O2 shift |  |  |  |  |  |  |  | v =  Vacation time off (Approved) |  |  |  |  |  |  |  |  |  |  |  |  |  | Scheduler will note Approved Vacation and PTO on Final Schedule
 |  |  |  | Q = Management day  (CS Only) |  |  |  |  |  |  |  | t =   Work Sponsored Paid Time Off  (Approved) |  |  |  |  |  |  |  |  |  |  |  |  | Pulmonary Function Lab:  one D Shift per Each Week is required by one of the 2 PF Lab staff
 |  |  |  |  |  | DAY Week 1 |  |  |  |  |  |  |  | DAY Week 2 |  |  |  |  |  |  |  | DAY Week 3 |  |  |  |  |  |  |  | DAY Week 4 |  |  |  |  |  |  |  | DAY Week 5 |  |  |  |  |  |  |  | DAY Week 6 |  |  |  |  |  |  |  |  | Date/Time Submitted | EDIT Date/Time
 |  |  |  |  |  | 2009-03-22 00:00:00 | 2009-03-23 00:00:00 | 2009-03-24 00:00:00 | 2009-03-25 00:00:00 | 2009-03-26 00:00:00 | 2009-03-27 00:00:00 | 2009-03-28 00:00:00 | # | 2009-03-29 00:00:00 | 2009-03-30 00:00:00 | 2009-03-31 00:00:00 | 2009-04-01 00:00:00 | 2009-04-02 00:00:00 | 2009-04-03 00:00:00 | 2009-04-04 00:00:00 | # | 2009-04-05 00:00:00 | 2009-04-06 00:00:00 | 2009-04-07 00:00:00 | 2009-04-08 00:00:00 | 2009-04-09 00:00:00 | 2009-04-10 00:00:00 | 2009-04-11 00:00:00 | # | 2009-04-12 00:00:00 | 2009-04-13 00:00:00 | 2009-04-14 00:00:00 | 2009-04-15 00:00:00 | 2009-04-16 00:00:00 | 2009-04-17 00:00:00 | 2009-04-18 00:00:00 | # | 2009-04-19 00:00:00 | 2009-04-20 00:00:00 | 2009-04-21 00:00:00 | 2009-04-22 00:00:00 | 2009-04-23 00:00:00 | 2009-04-24 00:00:00 | 2009-04-25 00:00:00 | # | 2009-04-26 00:00:00 | 2009-04-27 00:00:00 | 2009-04-28 00:00:00 | 2009-04-29 00:00:00 | 2009-04-30 00:00:00 | 2009-05-01 00:00:00 | 2009-05-02 00:00:00 | #
 |  |  | # WE Work | Min | WE | 2009-03-22 00:00:00 | 2009-03-23 00:00:00 | 2009-03-24 00:00:00 | 2009-03-25 00:00:00 | 2009-03-26 00:00:00 | 2009-03-27 00:00:00 | 2009-03-28 00:00:00 | Shifts | 2009-03-29 00:00:00 | 2009-03-30 00:00:00 | 2009-03-31 00:00:00 | 2009-04-01 00:00:00 | 2009-04-02 00:00:00 | 2009-04-03 00:00:00 | 2009-04-04 00:00:00 | Shifts | 2009-04-05 00:00:00 | 2009-04-06 00:00:00 | 2009-04-07 00:00:00 | 2009-04-08 00:00:00 | 2009-04-09 00:00:00 | 2009-04-10 00:00:00 | 2009-04-11 00:00:00 | Shifts | 2009-04-12 00:00:00 | 2009-04-13 00:00:00 | 2009-04-14 00:00:00 | 2009-04-15 00:00:00 | 2009-04-16 00:00:00 | 2009-04-17 00:00:00 | 2009-04-18 00:00:00 | Shifts | 2009-04-19 00:00:00 | 2009-04-20 00:00:00 | 2009-04-21 00:00:00 | 2009-04-22 00:00:00 | 2009-04-23 00:00:00 | 2009-04-24 00:00:00 | 2009-04-25 00:00:00 | Shifts | 2009-04-26 00:00:00 | 2009-04-27 00:00:00 | 2009-04-28 00:00:00 | 2009-04-29 00:00:00 | 2009-04-30 00:00:00 | 2009-05-01 00:00:00 | 2009-05-02 00:00:00 | Shifts
 |  |  | Act | WE | Under | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | SUPERVISORY
 | Able |  | 1 | 4 | -3 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | a | a | 0 | t | x | D | D | v | v | v | 2 | x | x | D | D | v | v | D | 3 | a | x | D | D | D | a | a | 3 |  | 2009-02-01 13:21:03
 | [NAME] |  | 3 | 4 | -1 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 | D | D | Q | a | a | a | D | 4 | D | D | a | D |  |  |  | 3
 | [NAME] |  | 5 | 4 |  | D | x | x | x | D | D | x | 3 | x | x | x | D | D | D | x | 3 | a | x | D | D | D | a | x | 3 | D | x | x | x | D | D | x | 3 | D | x | x | x | D | D | x | 3 | D | x | x | x | D | a | D | 3
 | Diggs |  | 2 | 4 | -2 | a | a | D | D | a | D | a | 3 | a | D | D | a | a | D | a | 3 | a | D | D | a | a |  | D | 3 | a | D | a | D | a | D | D | 4 | a | D | D | a | a | D | a | 3 | a | D | D | a | a | D | a | 3
 | Actual # At Work |  |  |  |  | 1 | 0 | 1 | 1 | 1 | 2 | 0 | 6 | 0 | 1 | 1 | 1 | 1 | 2 | 0 | 6 | 0 | 1 | 2 | 1 | 1 | 0 | 1 | 6 | 1 | 1 | 1 | 2 | 1 | 2 | 1 | 9 | 2 | 2 | 3 | 1 | 1 | 2 | 2 | 13 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 12
 | Actual # Patient Care |  | 11 | 16 | -5 | 1 | 0 | 1 | 1 | 1 | 2 | 0 | 6 | 0 | 1 | 1 | 1 | 1 | 2 | 0 | 6 | 0 | 1 | 2 | 1 | 1 | 0 | 1 | 6 | 1 | 1 | 1 | 2 | 1 | 2 | 1 | 9 | 2 | 2 | 2 | 1 | 1 | 2 | 2 | 12 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 12
 | Min # Patient Care |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 7 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 7 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 7 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 7 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 7 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 7
 | # ( Short )  Over |  |  |  |  | 0 | -1 | 0 | 0 | 0 | 1 | -1 | -1 | -1 | 0 | 0 | 0 | 0 | 1 | -1 | -1 | -1 | 0 | 1 | 0 | 0 | -1 | 0 | -1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 2 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 5 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 5
 | NON-SUPERVISORY RT STAFF
 | Everertt |  | 5 | 4 |  | D | D | a | a | D | a | a | 3 | D | a | D | a | D | a | a | 3 | x | D | a | a | D | D | a | 3 | D | D | a | a | D | a | a | 3 | D | D | a | a | D | a | a | 3 | D | D | a | a | D | a | a | 3
 | Fletcher |  | 6 | 4 |  | a | a | D | a | a | D | D | 3 | a | D | D | a | a | x | D | 3 | a | D | a | a | a | D | D | 3 | a | a | D | a | a | D | D | 3 | a | a | D | a | a | D | D | 3 | a | a | D | a | a | D | D | 3
 | [NAME] |  | 6 | 4 |  | D | a | a | D | D | O | a | 3 | x | D | x |  | D | a | D | 3 | D | a | a | D | D | a | a | 3 | D | a | a | D | D | O | a | 3 | D | a | a | D | D | O | a | 3 | D | a | a | D | D | O | a | 3
 | Hall |  | 2 | 4 | -2 | a | D | D | a | r | D | a | 3 | a | a | D | a | a | D | D | 3 | a | D | D | a | a | a | D | 3 | a | D | D | a | a | D | a | 3 | a | D | D | a | a | D | a | 3 | a | D | D | a | a | D | a | 3
 | Illini |  | 6 | 4 |  | D | v | v | v | v | v | v | 1 | D | a | a | D | D | a | a | 3 | D | a | a | D | a | D | a | 3 | D | v | v | v | v | v | v | 1 | D | v | v | v | v | v | v | 1 | D | v | v | v | v | v | v | 1
 | [NAME] |  | 7 | 4 |  | x | D | D | D | x | a | D | 4 | D | D | a | a | x | D | a | 3 | D | a | D | a | x | a | D | 3 | x | D | D | D | x | a | D | 4 | x | D | D | D | x | a | D | 4 | x | D | D | D | x | a | D | 4
 | Koombs |  | 5 | 4 |  | r | r | r | D | D | x | D | 3 | x | x | x | D | a | D | D | 3 | x | x | D | D | D | x | a | 3 | r | r | r | D | D | x | D | 3 | r | r | r | D | D | x | D | 3 | r | r | r | D | D | x | D | 3
 | Lewis |  |  |  |  | a | a | x | x | x | x | x | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Mondee |  |  |  |  | x | x | a | a | a | a | a | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | # NS Employee At Work |  |  |  |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 21 | 3 | 3 | 3 | 2 | 3 | 3 | 4 | 21 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 21 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 21 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 21 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 21
 | # NS on Patient Care |  | 37 | 28 | 9 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 20 | 3 | 3 | 3 | 2 | 3 | 3 | 4 | 21 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 21 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 20 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 20 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 20
 | # EMPLOYEE @Work |  |  |  |  | 4 | 3 | 4 | 4 | 4 | 5 | 3 | 26 | 3 | 5 | 5 | 4 | 5 | 7 | 4 | 28 | 3 | 5 | 6 | 5 | 5 | 5 | 4 | 28 | 4 | 5 | 5 | 6 | 5 | 7 | 4 | 30 | 5 | 6 | 7 | 5 | 5 | 7 | 5 | 34 | 5 | 6 | 6 | 6 | 6 | 6 | 4 | 33
 | #[NAME] PATIENT CARE |  | 48 | 44 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 3 | 27 | 3 | 4 | 4 | 3 | 5 | 5 | 4 | 28 | 3 | 4 | 5 | 4 | 4 | 4 | 4 | 28 | 4 | 4 | 4 | 5 | 4 | 5 | 4 | 30 | 5 | 5 | 5 | 4 | 4 | 5 | 5 | 33 | 5 | 5 | 5 | 5 | 5 | 4 | 4 | 33
 | MIN # PATIENT CARE |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 35 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 35 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 35 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 35 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 35 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 35
 | EMPLOYEE STAFFING (SHORT)OVER- BEFORE PF LAB |  |  |  |  | -1 | -2 | -1 | -1 | -1 | -1 | -2 | -8 | -2 | -1 | -1 | -2 | 0 | 0 | -1 | -7 | -2 | -1 | 0 | -1 | -1 | -1 | -1 | -7 | -1 | -1 | -1 | 0 | -1 | 0 | -1 | -5 | 0 | 0 | 0 | -1 | -1 | 0 | 0 | -2 | 0 | 0 | 0 | 0 | 0 | -1 | -1 | -2
 | PF LAB
 | Normano |  |  |  |  | x | x | P | P | x | P | x | 3 | x | x | P | P | x | P | x | 3 | x | x | P | P | x | P | x | 3 | x | x | P | P | x | P | x | 3 | x | x | P | P | x | P | x | 3 | x | x | P | P | x | P | x | 3
 | Page |  |  |  |  | x | P | x | x | P | D | x | 3 | x | P | x | x | D | P | x | 3 | x | P | x | x | P | D | x | 3 | x | P | x | x | P | D | x | 3 | x | P | x | x | P | D | x | 3 | x | P | x | x | P | D | x | 3
 | # PF Lab- At Work |  |  |  |  | 0 | 1 | 1 | 1 | 1 | 2 | 0 | 6 | 0 | 1 | 1 | 1 | 1 | 2 | 0 | 6 | 0 | 1 | 1 | 1 | 1 | 2 | 0 | 6 | 0 | 1 | 1 | 1 | 1 | 2 | 0 | 6 | 0 | 1 | 1 | 1 | 1 | 2 | 0 | 6 | 0 | 1 | 1 | 1 | 1 | 2 | 0 | 6
 | # PFLab- Patient Care |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1
 | EMPLOYEE STAFFING (SHORT)OVER-   AFTER PF LAB |  |  |  |  | -1 | -2 | -1 | -1 | -1 | 0 | -2 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1
 | NON-EMPLOYEES
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | # Per Diem Workers |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | NET PATIENT CARE (SHORT)OVER |  |  |  |  | -1 | -2 | -1 | -1 | -1 | 0 | -2 | -8 | -2 | -1 | -1 | -2 | 0 | 0 | -1 | -7 | -2 | -1 | 0 | -1 | -1 | -1 | -1 | -7 | -1 | -1 | -1 | 0 | -1 | 0 | -1 | -5 | 0 | 0 | 0 | -1 | -1 | 0 | 0 | -2 | 0 | 0 | 0 | 0 | 0 | -1 | -1 | -2