Spreadsheet: 776947d1650014041-shift-pattern-dropdown-list-and-auto-populate-calendar-scheduler-draft
Sheet: Monthly Sched

 | MONTHLY SHIFT ROTATION
 | Date |  |  |  |  |  |  |  | KEY
 | 2022-05-01 00:00:00 |  |  |  |  |  |  |  | D | DAY DUTY |  |  | N | NIGHT DUTY |  |  | H | HOLIDAY |  |  | O | OFF |  | S | SICK |  | V | VACATION
 | DAY SHIFT
 | Female Required = 2
 | SR |  | [NAME] | POST | ASSIGNMENT | EMPLOYEE NAME | BADGE NO. | SHIFT
 | 1 |  | ERC | Main Gate |  | Mark |  |  | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D
 | 2 |  | Masdar Building | Block C 1st floor |  | Asmaa |  |  | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D
 | 3 |  | Masdar Building | Tamouth |  | Jessica |  |  |  | D | D | D | O | D | D |  | D | D | D | O | D | D |  | D | D | D | O | D | D |  | D | D | D | O | D | D |  | D
 |  |  |  |  |  |  |  | Day Duty
 |  |  |  |  |  |  |  | Day Off
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Vacation
 |  |  |  |  |  |  |  | Holiday
 |  |  |  |  |  |  |  | Total
 | Male Required = 15
 | SR |  | [NAME] | POST | ASSIGNMENT | EMPLOYEE NAME | BADGE NO. | EMPLOYEE NAME
 | 1 |  | Masdar Building | Simulator |  | Kris |  |  | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D
 | 2 |  | Masdar Building | Tamouth |  | [NAME] |  |  | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D
 | 3 |  | Masdar Building | Service Area |  | Christine |  |  | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D
 | 4 |  | Masdar Building | Block B Searches |  | Anna |  |  | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D
 | 5 |  | Masdar Building | Block B 3rd floor |  | [NAME] |  |  | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D
 | 6 |  | Masdar Building | Block C General M |  | [NAME] |  |  | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D
 | 7 |  | Masdar Building | Block C 1st floor |  | Asmaa |  |  | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O
 | 8 |  | Masdar Building | Supervisor |  | Scott |  |  | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D
 | 9 |  | Masdar Building | Control Room |  | [NAME] |  |  | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D
 | 10 |  | ERC | Main Gate |  | Mark |  |  | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D
 | 11 |  | ERC | EOC Reception |  | Naseef |  |  | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D
 | 12 |  | ERC | Supervisor |  | Scott |  |  | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D
 | 13 |  | ERC | Patrols |  | Troy |  |  | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D
 | 14 |  | ERC | Supervisor |  | Scott |  |  | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O
 | 15 |  | Injazat | Entrance |  | Abdul |  |  | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D
 | 16 |  | Masdar Building | Simulator |  | [NAME] |  |  | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D
 | 17 |  | Masdar Building | Simulator |  | [NAME] |  |  | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D
 | 18 |  | Masdar Building | Simulator |  | [NAME] |  |  | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D
 |  |  |  |  |  |  |  | Day Duty
 |  |  |  |  |  |  |  | Day Off
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Vacation
 |  |  |  |  |  |  |  | Holiday
 |  |  |  |  |  |  |  | Total
 | Emirati Required = 1
 | SR |  | [NAME] | POST | ASSIGNMENT |  | BADGE NO. | EMPLOYEE NAME
 | 1 |  | Masdar Building | Control Room E |  | [NAME] |  |  | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D
 | 2 |  | Masdar Building | Control Room E |  | [NAME] |  |  | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D | D | O | D | D | D | D | D
 |  |  |  |  |  |  |  | On Duty
 |  |  |  |  |  |  |  | Day Off
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Vacation
 |  |  |  |  |  |  |  | Holiday
 | Total
 | NIGHT SHIFT
 | Female Required = 1
 | SR |  | [NAME] | POST | ASSIGNMENT |  | BADGE NO. | EMPLOYEE NAME
 | 1 |  | Masdar Building | Block C General F |  |  |  |  | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N
 | 2 |  | Masdar Building | Block C General F |  |  |  |  | N |  |  |  |  |  |  | N |  |  |  |  |  |  | N |  |  |  |  |  |  | N |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  | Day Duty
 |  |  |  |  |  |  |  | Day Off
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Vacation
 |  |  |  |  |  |  |  | Holiday
 |  |  |  |  |  |  |  | Total
 | Male Required = 13
 | SR |  | [NAME] | POST | ASSIGNMENT |  | BADGE NO. | EMPLOYEE NAME
 | 1 |  | Masdar Building | Simulator |  |  |  |  | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N
 | 2 |  | Masdar Building | Block C General M |  |  |  |  | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N
 | 3 |  | Masdar Building | Block C 1st floor M |  |  |  |  | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N
 | 4 |  | Masdar Building | Supervisor |  |  |  |  | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N
 | 5 |  | Masdar Building | Control Room |  |  |  |  | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N
 | 6 |  | Masdar Building | Control Room |  |  |  |  | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N
 | 7 |  | Masdar Building | Patrols |  |  |  |  | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O
 | 8 |  | ERC | Main Gate |  |  |  |  | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N
 | 9 |  | ERC | EOC Reception |  |  |  |  | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N
 | 10 |  | ERC | Supervisor |  |  |  |  | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N
 | 11 |  | ERC | Control Room |  |  |  |  | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N
 | 12 |  | ERC | Control Room |  |  |  |  | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N
 | 13 |  | Injazat | Entrance |  |  |  |  | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N
 | 14 |  |  |  |  |  |  |  | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O
 | 15 |  |  |  |  |  |  |  | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N
 | 16 |  |  |  |  |  |  |  | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N | N | O | N | N | N | N | N
 |  |  |  |  |  |  |  | Day Duty
 |  |  |  |  |  |  |  | Day Off
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Vacation
 |  |  |  |  |  |  |  | Holiday
 |  |  |  |  |  |  |  | Total
 | Female required |  | 3 | Number of shift pattern | 7 |  | Reliever not yet included
 | Female reliever |  | 1 | Time of shift | 5:00AM - 5:00PM |  | 1 hr break
 | Male required |  | 28 |  | 5:00PM - 5:00 AM |  | 1 hr break
 | Male reliever |  | 6
 | Emirati required |  | 1
 | Emirati reliever |  | 1
 | Total