Spreadsheet: 777018d1650076939-shift-pattern-dropdown-list-and-auto-populate-calendar-scheduler-draft-missja-
Sheet: Monthly Sched

 | MONTHLY SHIFT ROTATION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month | Month # | Year
 | Date |  |  | Month | Year |  |  |  | KEY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan | 1 | 2022
 |  |  |  | Jun | 2022 |  |  |  | D | DAY DUTY |  |  | N | NIGHT DUTY |  |  | H | HOLIDAY |  |  | O | OFF |  | S | SICK |  | V | VACATION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb | 2 | 2023
 | DAY SHIFT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar | 3 | 2024
 | Female Required = 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr | 4 | 2025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May | 5 | 2026
 | SR |  | [NAME] | POST | ASSIGNMENT | EMPLOYEE NAME | BADGE NO. | SHIFT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jun | 6 | 2027
 | 1 |  | ERC | Main Gate |  | Mark |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul | 7 | 2028
 | 2 |  | Masdar Building | Block C 1st floor |  | Asmaa |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug | 8 | 2029
 | 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 |  |  |  |  |  | Sep | 9 | 2030
 |  |  |  |  |  |  |  | Day Duty |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct | 10 | 2031
 |  |  |  |  |  |  |  | Day Off |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov | 11 | 2032
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec | 12
 |  |  |  |  |  |  |  | Vacation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan
 |  |  |  |  |  |  |  | Holiday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb
 |  |  |  |  |  |  |  | Total
 | Male Required = 15
 | SR |  | [NAME] | POST | ASSIGNMENT | EMPLOYEE NAME | BADGE NO. | EMPLOYEE NAME
 | 1 |  | Masdar Building | Simulator |  | Kris
 | 2 |  | Masdar Building | Tamouth |  | [NAME]
 | 3 |  | Masdar Building | Service Area |  | Christine
 | 4 |  | Masdar Building | Block B Searches |  | Anna
 | 5 |  | Masdar Building | Block B 3rd floor |  | [NAME]
 | 6 |  | Masdar Building | Block C General M |  | [NAME]
 | 7 |  | Masdar Building | Block C 1st floor |  | Asmaa
 | 8 |  | Masdar Building | Supervisor |  | Scott
 | 9 |  | Masdar Building | Control Room |  | [NAME]
 | 10 |  | ERC | Main Gate |  | Mark
 | 11 |  | ERC | EOC Reception |  | Naseef
 | 12 |  | ERC | Supervisor |  | Scott
 | 13 |  | ERC | Patrols |  | Troy
 | 14 |  | ERC | Supervisor |  | Scott
 | 15 |  | Injazat | Entrance |  | Abdul
 | 16 |  | Masdar Building | Simulator |  | [NAME]
 | 17 |  | Masdar Building | Simulator |  | [NAME]
 | 18 |  | Masdar Building | Simulator |  | [NAME]
 |  |  |  |  |  |  |  | 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]
 | 2 |  | Masdar Building | Control Room E |  | [NAME]
 |  |  |  |  |  |  |  | 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