Spreadsheet: 153164d1335790236-rota-patterns-vba-or-v-look-up-formula-may-2012-excel-forum-
Sheet: May 2012

Alarm No. | Grade | Emp No | Deal Limit | Name | 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
 |  |  |  |  | 2012-04-30 00:00:00 | 2012-05-01 00:00:00 | 2012-05-02 00:00:00 | 2012-05-03 00:00:00 | 2012-05-04 00:00:00 | 2012-05-05 00:00:00 | 2012-05-06 00:00:00 |  |  | 2012-05-07 00:00:00 | 2012-05-08 00:00:00 | 2012-05-09 00:00:00 | 2012-05-10 00:00:00 | 2012-05-11 00:00:00 | 2012-05-12 00:00:00 | 2012-05-13 00:00:00 |  |  | 2012-05-14 00:00:00 | 2012-05-15 00:00:00 | 2012-05-16 00:00:00 | 2012-05-17 00:00:00 | 2012-05-18 00:00:00 | 2012-05-19 00:00:00 | 2012-05-20 00:00:00 |  |  | 2012-05-21 00:00:00 | 2012-05-22 00:00:00 | 2012-05-23 00:00:00 | 2012-05-24 00:00:00 | 2012-05-25 00:00:00 | 2012-05-26 00:00:00 | 2012-05-27 00:00:00
Duty Manager
Late Duty Manager
 |  |  |  | 04/SS |  |  |  |  |  |  |  |  | 04/SS |  |  |  |  |  |  |  |  | 04/SS |  |  |  |  |  |  |  |  | 04/SS
 |  |  |  | Early |  |  |  |  |  |  |  |  | Early |  |  |  |  |  |  |  |  | Early |  |  |  |  |  |  |  |  | Early
 |  |  |  | Early |  |  |  |  |  |  |  |  | Early |  |  |  |  |  |  |  |  | Early |  |  |  |  |  |  |  |  | Early
 |  |  |  | Middle |  |  |  |  |  |  |  |  | Middle |  |  |  |  |  |  |  |  | Middle |  |  |  |  |  |  |  |  | Middle |  |  |  |  |  |  |  |  |  | Early Shifts | Middle Shifts | Late Shifts | Saturdays Off | Sundays Off
 |  |  |  | Late |  |  |  |  |  |  |  |  | Late |  |  |  |  |  |  |  |  | Late |  |  |  |  |  |  |  |  | Late
 |  |  |  | Night |  |  |  |  |  |  |  |  | Night |  |  |  |  |  |  |  |  | Night |  |  |  |  |  |  |  |  | Night
 |  |  |  | [NAME] | F18 | F18 | F18 | F18 | F18 | OFF | OFF |  | [NAME] | F18 | F18 | F18 | F18 | F18 | OFF | OFF |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | Stuart | F18 | F18 | F18 | F18 | F18 | OFF | OFF |  | Stuart | F18 | F18 | F18 | F18 | F18 | OFF | OFF |  | Stuart |  |  |  |  |  |  |  |  | Stuart
 |  |  |  | Grant | F18 | F18 | F18 | F18 | F18 | OFF | OFF |  | Grant | F18 | F18 | F18 | F18 | F18 | OFF | OFF |  | Grant |  |  |  |  |  |  |  |  | Grant
 |  |  |  | [NAME] | TBC | EBS | OFF | TBC | TBC | OFF | TBC |  | [NAME] | TBC | TBC | OFF | TBC | TBC | E35 | OFF |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [NAME] | ESS | ESS | ESS | ESS | OFF | ESS | ESS |  | [NAME] | BK | H | H | H | H | H | OFF |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | Stuart | OFF | EBR | EBR | OFF | EBR | EBR | EBR |  | Stuart | EBR | OFF | EBR | OFF | EBR | EBR | EBR |  | Stuart |  |  |  |  |  |  |  |  | Stuart |  |  |  |  |  |  |  |  | Stuart
 |  |  |  | [NAME] | EOC | EOC/LOC | EOC | EOC | EOC | EOC | OFF |  | [NAME] | EOC | EOC | EOC | EOC | EOC/LOC | OFF | EOC |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [NAME] | EBS | OFF | EBS | EBS | OFF | EBS | EBS |  | [NAME] | EBS | OFF | EBS | EBS | EBS | OFF | EBS |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [NAME] | LBR | OFF | OFF | E18 | E18 | L18 | E18 |  | [NAME] | L18 | OFF | OFF | E18 | E18 | L18 | E18 |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | Sid | SICK | SICK | SICK | OFF | OFF | OFF | OFF |  | Sid | SICK | SICK | SICK | OFF | OFF | OFF | OFF |  | Sid |  |  |  |  |  |  |  |  | Sid |  |  |  |  |  |  |  |  | Sid
 |  |  |  | [NAME] | OFF | OFF | H | H | H | H | E35 |  | [NAME] | BK | E35 | E35 | E35 | E35 | E35 | OFF |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [NAME] | OFF | OFF | LBR | LBR | LBR | LBR | LBR |  | [NAME] | LBR | OFF | LBR | LBR | OFF | LBR | LBR |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [NAME] | E35 | E18 | E18 | OFF | L18 | H | OFF |  | [NAME] | BK | OFF | OFF | H | H | ESS | L18 |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [NAME] | EBS | EBS | EBS | EBS | EBS | OFF | H |  | [NAME] | H | EBS | ESS | ESS | OFF | EBS | ESS |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [NAME] | EBR | LBR | OFF | EBR | ESS | OFF | EOC |  | [NAME] | ESS | EBR | OFF | EBR | ESS | EOC | OFF |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [NAME] | E18 | E18 | E18 | OFF | E35 | E18 | OFF |  | [NAME] | E18 | E18 | E18 | H | H | OFF | OFF |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | Scott | EGR | EGR | EGR | EGR | EGR | EGR | OFF |  | Scott | EGR | EGR | EGR | EGR | OFF | EGR | EGR |  | Scott |  |  |  |  |  |  |  |  | Scott |  |  |  |  |  |  |  |  | Scott
 |  |  |  | Mark | OFF | E35 | E35 | E35 | OFF | E35 | EGR |  | Mark | E35 | ESS/LBR | OFF | OFF | EGR | E18 | E35 |  | Mark |  |  |  |  |  |  |  |  | Mark |  |  |  |  |  |  |  |  | Mark
 |  |  |  | George | OFF | L35 | L35 | L35 | L35 | L35 | L35 |  | George | BK | L35 | L35 | L35 | L35 | L35 | L35 |  | George |  |  |  |  |  |  |  |  | George |  |  |  |  |  |  |  |  | George
 |  |  |  | [NAME] | LOC | LSS | LOC | LOC | LOC | EOC | OFF |  | [NAME] | LOC | LOC | LOC | LOC | L18 | EOC | OFF |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [NAME] | H | H | H | H | H | OFF | OFF |  | [NAME] | BK | OFF | EOC | EBR | KK | MBR | ESS |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [NAME] | E18 | EBR | OFF | OFF | M18 | KK | E18 |  | [NAME] | BK | E18 | KK | OFF | E18 | E18 | E18 |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | Georgiana | OFF | OFF | EGR/LGR | OFF | OFF | EGR/LGR | OFF |  | Georgiana | OFF | OFF | EGR/LGR | OFF | OFF | EGR/LGR | OFF |  | Georgiana |  |  |  |  |  |  |  |  | Georgiana |  |  |  |  |  |  |  |  | Georgiana
 |  |  |  | [NAME] | OFF | H | H | ESS (K) | LSS | OFF | LSS |  | [NAME] | BK | OFF | ESS (K) | ESS (K) | LSS | LSS | OFF |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [NAME] | EBR | OFF | EBR (K) | EBR | EBR | OFF | EBR (K) |  | [NAME] | EBR (K) | EBR | EBR | OFF | EBR | OFF | EBR (K) |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | Gloria | LBS | LBS | LBS | LBS | EBS | H | OFF |  | Gloria | BK | H | LBS | EOC | LBS | LBS | LBS |  | Gloria |  |  |  |  |  |  |  |  | Gloria |  |  |  |  |  |  |  |  | Gloria
 |  |  |  | [NAME] | EGR | OFF | OFF | EGR | EOC | E18 | EGR |  | [NAME] | EGR | EGR | E35 | EGR | E35 | OFF | OFF |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | Jordan | OFF | OFF | EOC | MOC | MOC | OFF | EOC |  | Jordan | OFF | OFF | EBS | MOC | MOC | OFF | EOC |  | Jordan |  |  |  |  |  |  |  |  | Jordan |  |  |  |  |  |  |  |  | Jordan
 |  |  |  | [NAME] | L18 | L18 | L18 | L18 | OFF | LOC | L18 |  | [NAME] | L35 | L18 | L18 | L18 | H | H | OFF |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [NAME] | OFF | OFF | MBR | E35 | E35 | E35 | OFF |  | [NAME] | EBS | EOC | OFF | OFF | MBR | EBR | OFF |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [NAME] | LGR | LGR | OFF | LGR | LGR | OFF | LOC |  | [NAME] | LGR | LGR | OFF | LGR | LGR | OFF | LGR |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | Yvette | ESS (K) | KK | OFF | E18 | E18 | MBR | OFF |  | Yvette | E18 | KK | E18 | E18 | H | OFF | OFF |  | Yvette |  |  |  |  |  |  |  |  | Yvette |  |  |  |  |  |  |  |  | Yvette
 |  |  |  | Leanne | OFF | OFF | MOC | KK | ESS (K) | EBS | EBS |  | Leanne | BK | MOC | MOC | OFF | EBS | EBS | KK |  | Leanne |  |  |  |  |  |  |  |  | Leanne |  |  |  |  |  |  |  |  | Leanne
 |  |  |  | [NAME] | EOC | EOC | KK | EOC | OFF | MOC | OFF |  | [NAME] | EOC | OFF | OFF | EBS | EOC | KK | EBS |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [NAME] | LSS | OFF | LSS | LSS | OFF | LSS | LGR |  | [NAME] | LSS | LSS | LSS | LSS | OFF | OFF | LSS |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | Fred | KK | ESS | OFF | MBR | MBR | EBR (K) | OFF |  | Fred | MBR | E35 | OFF | KK | ESS (K) | ESS | OFF |  | Fred |  |  |  |  |  |  |  |  | Fred |  |  |  |  |  |  |  |  | Fred
 |  |  |  | [NAME] | L35 | MOC | OFF | OFF | LBS | LBS | LBS |  | [NAME] | LBS | LBS | OFF | LBS | OFF | LOC | LOC |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [NAME] | MBR | MBR | OFF | OFF | KK | ESS | ESS |  | [NAME] | ESS | ESS (K) | MBR | MBR | H | OFF | OFF |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | Ian | E35 | E35 | E35 | OFF | OFF | M18 | KK |  | Ian | KK | MBR | OFF | E35 | OFF | H | E35 |  | Ian |  |  |  |  |  |  |  |  | Ian |  |  |  |  |  |  |  |  | Ian
 |  |  |  | [NAME] | MOC | EGR | ESS | OFF | EGR | OFF | E35 |  | [NAME] | MOC | EBS | OFF | OFF | EGR | MOC | EGR |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | Rachel | N | N | N | N | N | OFF | OFF |  | Rachel | BK | OFF | OFF | N | N | N | N |  | Rachel |  |  |  |  |  |  |  |  | Rachel |  |  |  |  |  |  |  |  | Rachel
 |  |  |  | [NAME] | N | OFF | OFF | OFF | H | N | N |  | [NAME] | N | N | N | N | OFF | OFF | OFF |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | TOTAL EBR |  |  |  |  |  |  |  |  | Branches
 |  |  |  | TOTAL ESS |  |  |  |  |  |  |  |  | 04/SS
 |  |  |  | TOTAL EOC |  |  |  |  |  |  |  |  | 08/BR
 |  |  |  | TOTAL EBS |  |  |  |  |  |  |  |  | 18/PC
 |  |  |  | TOTAL E18 |  |  |  |  |  |  |  |  | 35/PC
 |  |  |  | TOTAL E35 |  |  |  |  |  |  |  |  | 05/OC
 |  |  |  | TOTAL EGR |  |  |  |  |  |  |  |  | 06/BS
 |  |  |  |  |  |  |  |  |  |  |  |  | 09/GR
 |  |  |  | TOTAL LBR
 |  |  |  | TOTAL LSS
 |  |  |  | TOTAL LOC
 |  |  |  | TOTAL LBS
 |  |  |  | TOTAL L18
 |  |  |  | TOTAL L35
 |  |  |  | TOTAL LGR
 |  |  |  | TOTAL E
 |  |  |  | TOTAL M
 |  |  |  | TOTAL L
 |  |  |  | TOTAL KK
 |  |  |  | TOTAL N
 |  |  |  | TOTAL OFF
 |  |  |  | TOTAL H
 |  |  |  | TOTAL BK
 |  |  |  | TOTAL S
 |  |  |  |  | OVERTIME AVAILABLE |  |  |  |  |  |  |  |  | OVERTIME AVAILABLE |  |  |  |  |  |  |  |  | OVERTIME AVAILABLE |  |  |  |  |  |  |  |  | OVERTIME AVAILABLE
 |  |  |  |  | MON |  |  | FRI |  |  |  |  |  | MON | E35 |  | FRI | LBR (G4 OR G3) |  |  |  |  | MON |  |  | FRI |  |  |  |  |  | MON |  |  | FRI |  |  |  |  |  | Do you like this new style of Rota? Click here to vote Yes or No and to suggest any further changes.
 |  |  |  |  | TUE |  |  | SAT |  |  |  |  |  | TUE |  |  | SAT |  |  |  |  |  | TUE |  |  | SAT |  |  |  |  |  | TUE |  |  | SAT
 |  |  |  |  | WED |  |  | SUN |  |  |  |  |  | WED |  |  | SUN |  |  |  |  |  | WED |  |  | SUN |  |  |  |  |  | WED |  |  | SUN
 |  |  |  |  | THU |  |  |  |  |  |  |  |  | THU |  |  |  |  |  |  |  |  | THU |  |  | CONTACT VENU ASAP FOR O/T |  |  |  |  |  | THU |  |  | CONTACT VENU ASAP FOR O/T
 |  |  |  |  | COURSES / WORKSHOPS / MEETINGS |  |  |  |  |  |  |  |  | COURSES / WORKSHOPS / MEETINGS |  |  |  |  |  |  |  |  | COURSES / WORKSHOPS / MEETINGS |  |  |  |  |  |  |  |  | COURSES / WORKSHOPS / MEETINGS
 |  |  |  |  | INFORMATION |  |  |  |  |  |  |  |  | INFORMATION |  |  |  |  |  |  |  |  | INFORMATION |  |  |  |  |  |  |  |  | INFORMATION