Spreadsheet: 162809d1340087838-only-list-values-not-blanks-automated-rota-draft2
Sheet: All Info

2012
Day | [NAME] | Extra Out | Extra In | Shift | [NAME] | Extra Out | Extra In | Shift | [NAME] | Extra Out | Extra In | Shift | [NAME] | Extra Out | Extra In | Shift | [NAME] | Extra Out | Extra In | Shift | Caroline Jones | Extra Out | Extra In | Shift | [NAME] | Extra Out | Extra In | Shift | [NAME] | Extra Out | Extra In | Shift | Frances Lewis | Extra Out | Extra In | Shift | [NAME] | Extra Out | Extra In | Shift |  | Extra Out | Extra In | Shift | Extra Out | Extra In | Shift | Extra Out | Extra In | Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B | C | FST Early | FST Late 1 | FST Late 2 | FST other
2012-01-01 00:00:00 | 0 |  |  | 0 | 0 |  |  | 0 | 0 | H |  | E | E |  |  | E | 0 | H |  | L | 0 | H |  | L | 0 |  |  | 0 | L |  |  | L | 0 | H |  | E | L |  |  | L | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-01 00:00:00 | 0 | E | L | 0 | L | E | 0
2012-01-02 00:00:00 | 0 | H |  | L | L |  |  | L | 0 | H |  | E | E |  |  | E | 0 |  |  | 0 | 0 |  |  | 0 | 0 | H |  | E | L |  |  | L | 0 |  |  | 0 | L |  |  | L | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-02 00:00:00 | L | E | 0 | E | L | 0 | 0
2012-01-03 00:00:00 | 0 | H |  | L | L |  |  | L | E |  |  | E | E |  |  | E | 0 | H |  | S | S |  |  | S | 0 | H |  | E | L |  |  | L | 0 |  |  | 0 | L |  |  | L | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-03 00:00:00 | L | E | S | E | L | 0 | 0
2012-01-04 00:00:00 | 0 | H |  | L | L |  |  | L | 0 |  |  | 0 | 0 |  |  | 0 | 0 | H |  | E | E |  |  | E | 0 | H |  | E | 0 |  |  | 0 | 0 | H |  | L | 0 |  |  | 0 | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-04 00:00:00 | L | 0 | E | E | 0 | L | 0
2012-01-05 00:00:00 | 0 | H |  | L | L |  |  | L | 0 |  |  | 0 | 0 |  |  | 0 | E |  |  | E | E |  |  | E | 0 | H |  | E | 0 |  |  | 0 | 0 | H |  | L | 0 |  |  | 0 | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-05 00:00:00 | L | 0 | E | E | 0 | L | 0
2012-01-06 00:00:00 | 0 |  |  | 0 | 0 |  |  | 0 | L |  |  | L | 0 | T |  | L | 0 | T |  | E | E |  |  | E | 0 | H |  | E | 0 |  |  | 0 | 0 | H |  | L | 0 | T |  | E | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-06 00:00:00 | 0 | L | E | E | 0 | L | 0
2012-01-07 00:00:00 | E |  |  | E | 0 | H |  | E | L |  |  | L | 0 | T |  | L | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | L |  |  | L | 0 | H |  | E | 0 | T |  | E | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-07 00:00:00 | E | L | 0 | 0 | L | E | 0
2012-01-08 00:00:00 | E |  |  | E | 0 | H |  | E | L |  |  | L | 0 | T |  | L | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 | T |  | E | 0 | H |  | L | 0 | T |  | E | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-08 00:00:00 | E | L | 0 | 0 | E | L | 0
2012-01-09 00:00:00 | E |  |  | E | 0 | H |  | E | 0 |  |  | 0 | Ov |  | Ov | 0 | 0 | T |  | L | 0 | H |  | L | 0 | H |  | E | 0 | T |  | L | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-09 00:00:00 | E | 0 | L | E | L | 0 | 0
2012-01-10 00:00:00 | E |  |  | E | 0 | H |  | E | S |  |  | S | S |  |  | S | L |  |  | L | 0 | H |  | L | E |  |  | E | L |  |  | L | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-10 00:00:00 | E | S | L | E | L | 0 | 0
2012-01-11 00:00:00 | 0 |  |  | 0 | 0 |  |  | 0 | E |  |  | E | E |  |  | E | L |  |  | L | 0 | H |  | L | E |  |  | E | L |  |  | L | 0 |  |  | 0 | L |  |  | L | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-11 00:00:00 | 0 | E | L | E | L | 0 | 0
2012-01-12 00:00:00 | 0 |  |  | 0 | 0 |  |  | 0 | E |  |  | E | 0 | H |  | E | L |  |  | L | 0 | H |  | L | E |  |  | E | 0 |  |  | 0 | L |  |  | L | L |  |  | L | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-12 00:00:00 | 0 | E | L | E | 0 | L | 0
2012-01-13 00:00:00 | L |  |  | L | L |  |  | L | E |  |  | E | 0 | H |  | E | 0 |  |  | 0 | 0 |  |  | 0 | E |  |  | E | 0 |  |  | 0 | L |  |  | L | L |  |  | L | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-13 00:00:00 | L | E | 0 | E | 0 | L | 0
2012-01-14 00:00:00 | L |  |  | L | L |  |  | L | 0 |  |  | 0 | 0 |  |  | 0 | E |  |  | E | E |  |  | E | 0 |  |  | 0 | 0 | H |  | L | E |  |  | E | 0 |  |  | 0 | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-14 00:00:00 | L | 0 | E | 0 | L | E | 0
2012-01-15 00:00:00 | L |  |  | L | L |  |  | L | 0 |  |  | 0 | 0 |  |  | 0 | E |  |  | E | E |  |  | E | 0 |  |  | 0 | 0 | H |  | E | L |  |  | L | 0 |  |  | 0 | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-15 00:00:00 | L | 0 | E | 0 | E | L | 0
2012-01-16 00:00:00 | 0 |  |  | 0 | 0 |  |  | 0 | 0 | H |  | L | L |  |  | L | E |  |  | E | E |  |  | E | E |  |  | E | 0 | H |  | L | 0 |  |  | 0 | 0 | H |  | E | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-16 00:00:00 | 0 | L | E | E | L | 0 | 0
2012-01-17 00:00:00 | S |  |  | S | S |  |  | S | 0 | H |  | L | L |  |  | L | E |  |  | E | E |  |  | E | E |  |  | E | 0 | H |  | L | 0 |  |  | 0 | 0 | H |  | E | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-17 00:00:00 | S | L | E | E | L | 0 | 0
2012-01-18 00:00:00 | E |  |  | E | E |  |  | E | 0 | H |  | L | L |  |  | L | 0 |  |  | 0 | 0 |  |  | 0 | E |  |  | E | 0 |  |  | 0 | L |  |  | L | 0 | H |  | E | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-18 00:00:00 | E | L | 0 | E | 0 | L | 0
2012-01-19 00:00:00 | E |  |  | E | E |  |  | E | 0 | H |  | L | L |  |  | L | 0 |  |  | 0 | 0 |  |  | 0 | E |  |  | E | 0 |  |  | 0 | L |  |  | L | 0 | H |  | E | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-19 00:00:00 | E | L | 0 | E | 0 | L | 0
2012-01-20 00:00:00 | E |  |  | E | E |  |  | E | 0 |  |  | 0 | 0 |  |  | 0 | L |  |  | L | L |  |  | L | E |  |  | E | 0 |  |  | 0 | L |  |  | L | 0 |  |  | 0 | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-20 00:00:00 | E | 0 | L | E | 0 | L | 0
2012-01-21 00:00:00 | 0 |  |  | 0 | 0 |  |  | 0 | E |  |  | E | E |  |  | E | L |  |  | L | L |  |  | L | 0 |  |  | 0 | L |  |  | L | E |  |  | E | L |  |  | L | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-21 00:00:00 | 0 | E | L | 0 | L | E | 0
2012-01-22 00:00:00 | 0 |  |  | 0 | 0 |  |  | 0 | E |  |  | E | E |  |  | E | L |  |  | L | L |  |  | L | 0 |  |  | 0 | E |  |  | E | L |  |  | L | L |  |  | L | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-22 00:00:00 | 0 | E | L | 0 | E | L | 0
2012-01-23 00:00:00 | L |  |  | L | L |  |  | L | E |  |  | E | E |  |  | E | 0 |  |  | 0 | 0 |  |  | 0 | E |  |  | E | L |  |  | L | 0 |  |  | 0 | L |  |  | L | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-23 00:00:00 | L | E | 0 | E | L | 0 | 0
2012-01-24 00:00:00 | L |  |  | L | L |  |  | L | E |  |  | E | E |  |  | E | S |  |  | S | S |  |  | S | E |  |  | E | L |  |  | L | 0 |  |  | 0 | L |  |  | L | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-24 00:00:00 | L | E | S | E | L | 0 | 0
2012-01-25 00:00:00 | L |  |  | L | L |  |  | L | 0 |  |  | 0 | 0 |  |  | 0 | E |  |  | E | E |  |  | E | E |  |  | E | L |  |  | L | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-25 00:00:00 | L | 0 | E | E | L | 0 | 0
2012-01-26 00:00:00 | L |  |  | L | L |  |  | L | 0 |  |  | 0 | 0 |  |  | 0 | E |  |  | E | E |  |  | E | E |  |  | E | 0 |  |  | 0 | L |  |  | L | 0 |  |  | 0 | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-26 00:00:00 | L | 0 | E | E | 0 | L | 0
2012-01-27 00:00:00 | 0 |  |  | 0 | 0 |  |  | 0 | L |  |  | L | L |  |  | L | E |  |  | E | E |  |  | E | E |  |  | E | 0 |  |  | 0 | L |  |  | L | E |  |  | E | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-27 00:00:00 | 0 | L | E | E | 0 | L | 0
2012-01-28 00:00:00 | E |  |  | E | E |  |  | E | L |  |  | L | L |  |  | L | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | E |  |  | E | E |  |  | E | E |  |  | E | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-28 00:00:00 | E | L | 0 | 0 | E | E | 0
2012-01-29 00:00:00 | E |  |  | E | E |  |  | E | L |  |  | L | L |  |  | L | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | L |  |  | L | L |  |  | L | E |  |  | E | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-29 00:00:00 | E | L | 0 | 0 | L | L | 0
2012-01-30 00:00:00 | E |  |  | E | E |  |  | E | 0 |  |  | 0 | 0 |  |  | 0 | L |  |  | L | L |  |  | L | E |  |  | E | L |  |  | L | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-30 00:00:00 | E | 0 | L | E | L | 0 | 0
2012-01-31 00:00:00 | E |  |  | E | E |  |  | E | S |  |  | S | S |  |  | S | L |  |  | L | L |  |  | L | E |  |  | E | L |  |  | L | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 2012-01-31 00:00:00 | E | S | L | E | L | 0 | 0
 | A |  |  |  | A |  |  |  | B |  |  |  | B |  |  |  | C |  |  |  | C |  |  |  | FST Early |  |  |  | FST Late 1 |  |  |  | FST Late 2 |  |  |  | FST Other