Spreadsheet: 102420d1300366995-help-with-extracting-a-list-of-staff-allocated-to-a-specific-shift-copy-of-example-roster-sheet
Sheet: Sheet1

April/May 2011
Nurse | EFT | 2011-04-04 00:00:00
Clinical Manager
[NAME]
ANUM
[NAME] | 0.5 |  | A |  |  |  |  | A |  | M |  |  | A |  | M |  | M |  |  | A | A |  |  | A |  |  | M
[NAME] | 1 | M | M | M | M | ADO |  |  | A/L | A/L | A/L | A/L | A/L |  |  | A/L | A/L | A/L | A/L | A/L |  |  | A/L | A/L | A/L |  |  | A | A
[NAME] | 0.6 |  |  |  | A | A | M |  |  |  |  | M |  | A | A |  |  |  | A | M | M |  |  |  |  | A | A | M | M
[NAME] | 1 | A/L | A/L | A/L | A/L | ADO |  |  | A/L | A/L | A/L | A/L | A/L |  |  | A/L | A/L | A/L | A/L | A/L |  |  | A/L | A/L | A/L | A/L | A/L
[NAME] | 1 | A |  | A |  | M | A | M | STUDY |  | A | A | M | M |  | M | A | A | M |  |  | A | A | M | M | M | ADO
Registered Nurse Div 1
[NAME] |  | STUDY | STUDY | A | M | M |  |  | A | A | A | M | ADO |  |  | A | L | A | A | M |  |  | A | A | L | A | M
Peta | 0.8 | A/L | A/L | A/L | A/L |  |  |  | A/L | A/L | A/L | A/L |  |  |  | A/L | A/L | A/L | A/L |  |  |  | A/L | A/L | A/L | A/L
George |  | L | A |  |  | A | M | A | A | A | M | M |  |  | A | A | A | A | M | X |  | M |  |  | A | L | A | A
[NAME] |  | A | L |  |  | A | A | L | A | A |  |  | A | A | M | M | A |  |  | A | A | A | A | L |  |  | X | A | A
[NAME] |  | ECT |  | ECT | A | ECT |  |  | ECT | A | ECT | A | ECT | M |  | ECT | X | ECT |  | ECT | A |  | ECT | M | ECT | A | ECT
[NAME] |  | M | M | M | M |  |  | A | M | M | M |  | A | A |  |  | X | L | A | A | M |  |  |  | A | M | L | A | M
[NAME] |  | W/C | W/C | W/C | W/C | W/C |  |  | W/C | W/C | W/C | W/C | W/C |  |  | W/C | W/C | W/C | W/C | W/C |  |  | W/C | W/C | W/C | W/C | W/C
[NAME] |  | A | M | M | STUDY | STUDY | M |  | A | M | M |  |  | M | M | A | M | M |  | M |  |  |  | ADO | A | M | M | M
Santos | 0.7 | M | M | M |  |  |  | M | M | M |  |  |  |  | M | M | M | M |  |  |  | M | M | M |  |  |  |  | M
[NAME] |  | A/L | A/L | A/L | A/L | A/L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M |  | M | STUDY | M |  | M
Peta |  | A | A | A | A | M |  |  |  | X | A | M | M | M |  | L | A | M | M | M |  |  |  | A | M | A | A | M
Post Graduate Nurses
[NAME] |  | M |  | X | A |  | A | M | A/L | A/L | SD | A | M |  |  | A/L | A/L |  |  | L | A | A |  | A | SD | M | M | M
Graduate Nurses
Rowena |  | M | STUDY | STUDY |  |  | M | M | A/L | A/L | A/L | A/L | A/L |  |  | A | M | M | M |  |  | A | A | M | M | X |  |  | A
[NAME] |  |  | STUDY | STUDY |  | A | A | A | M |  | L | A | A | L | A | M |  |  | A | A | M | M | M | X |  | M | A
Enrolled Nurses Div 2
Gregory |  |  | A | A | L | A | M | M |  | L | A | A | M |  |  |  |  |  | X | M | M | M | M | A | M |  | A | M | M
[NAME] |  |  | M | M | M | M |  |  | M | M | M | M | M |  |  |  | M | M | M | M |  |  | M | M | A
Anna | 0.9 | M | M | M |  |  |  | M | L | A | A |  |  | M | A | M | M | M |  |  | A | A | A | A | M |  |  |  | M
Ricky | 0.6 |  |  |  | M |  | L |  | A | M | M |  |  |  | M | M | A | A |  |  |  |  |  | M | A | M
[NAME] | 0.6 | A/L | A/L | A/L |  |  |  |  | A/L | A/L | A/L |  |  |  |  | A/L | A/L | A/L |  |  |  |  | L |  |  |  |  | A | A
Jessica | 0.6 |  |  |  | A | M |  |  |  |  |  | M | A | M | M |  |  |  | L |  | M | M |  |  |  | A | M | M
Maria | 0.5 |  |  |  | A | A | M |  |  |  |  | L |  |  | A |  |  |  | A |  | A | L | A |  |  |  |  |  | L
Rita | 0.6 |  |  |  |  | L | A | A | M |  |  |  | A | A |  |  |  |  |  | A | L | A |  |  |  |  | A | L | A
Gertrude | 0.6 | A | A | A |  |  |  |  | A |  |  |  | L | A | L | A |  | A | A |  |  |  |  |  |  | A |  | A
Night Staff
Fred | 0.8 |  |  |  |  | N | N | N |  |  | N | N | N | N |  |  |  |  |  | N | N | N |  |  |  | N | N | N
Harriet | 1 | N | N | N | N | O | O | O |  |  |  | X | N | N | N | N | N | N | N | O | O | O | O | O |  | N | N | N | N
[NAME] | 1 | N |  |  | X | N | N |  | N | N | N | N |  |  |  |  |  | N | N | N |  | N | N | N | N |  |  |  | N
[NAME] |  | A/L | A/L | A/L | A/L | A/L |  |  |  | N |  |  | N | N | N | N | X |  |  | N | N
[NAME] |  |  |  |  | N | N | N | N | N |  | X | N |  |  | N |  | N | N | N |  |  |  |  | N | N | N | N | N
[NAME] |  | N | N | N | N |  |  | N | N | N | N |  |  |  |  | N | N |  |  |  | N | N | N | N |  |  |  | X | N
 |  | 900
 | M
 | A
 | N