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

 | MONTHLY SHIFT ROTATION
 | Date | Month | Year | Day/Night | KEY
 |  | May | 2022 |  |  | DAY DUTY
 |  |  |  | Total Shift |  | NIGHT DUTY
 |  |  |  |  |  | DAY OFF
 | Female Required: 3
 | SR | BADGE NO | EMPLOYEE NAME | SHIFT
 | 1 |  |  | Shift A |  | Block B Access Control Day | Block B Access Control Day | Block C Access Control Night | Block B Access Control Day | Block B Access Control Day | Block B Access Control Day |  | Block B Access Control Day | Block B Access Control Day | Block B Access Control Day | Block B Access Control Day | Block B Access Control Day | Block B Access Control Day |  | Block B Access Control Day | Block B Access Control Day | Block B Access Control Day | Block B Access Control Day | Block B Access Control Day | Block B Access Control Day |  | Block B Access Control Day | Block B Access Control Day | Block B Access Control Day | Block B Access Control Day | Block B Access Control Day | Block B Access Control Day |  | Block B Access Control Day | Block B Access Control Day
 | 2 |  |  | Shift B | Block C Access Control Day |  | Block C Access Control Day | Block C Access Control Day | Block C Access Control Day | Block C Access Control Day | Block C Access Control Day | Block C Access Control Day |  | Block C Access Control Day | Block C Access Control Day | Block C Access Control Day | Block C Access Control Day | Block C Access Control Day | Block C Access Control Day |  | Block C Access Control Day | Block C Access Control Day | Block C Access Control Day | Block C Access Control Day | Block C Access Control Day | Block C Access Control Day |  | Block C Access Control Day | Block C Access Control Day | Block C Access Control Day | Block C Access Control Day | Block C Access Control Day | Block C Access Control Day |  | Block C Access Control Day
 | 3 |  |  | Shift C | Block C Access Control Night | Block C Access Control Night |  | Block C Access Control Night | Block C Access Control Night | Block C Access Control Day | Block C Access Control Night | Block C Access Control Night | Block C Access Control Night |  | Block C Access Control Night | Block C Access Control Night | Block C Access Control Night | Block C Access Control Night | Block C Access Control Night | Block C Access Control Night |  | Block C Access Control Night | Block C Access Control Night | Block C Access Control Night | Block C Access Control Night | Block C Access Control Night | Block C Access Control Night |  | Block C Access Control Night | Block C Access Control Night | Block C Access Control Night | Block C Access Control Night | Block C Access Control Night | Block C Access Control Night
 | 4 |  |  | Shift D | Block B Access Control Day |  | Block B Access Control Day |  |  |  |  | Block B Access Control Day |  |  |  |  |  |  | Block B Access Control Day |  | Block C Access Control Night |  |  |  |  | Block B Access Control Day |  |  |  |  |  |  | Block B Access Control Day |  | Block C Access Control Night
 | 5 |  |  | Shift E |  | Block C Access Control Day |  |  |  | Block C Access Control Night |  |  | Block C Access Control Day | Block C Access Control Night |  |  |  |  |  | Block C Access Control Day |  |  |  |  |  |  | Block C Access Control Day | Block C Access Control Night |  |  |  |  |  | Block C Access Control Day
 |  | Month | Month # | Year |  | Locations
 |  | Jan | 1 | 2022 | 1 | Block B Access Control Day
 |  | Feb | 2 | 2023 | 2 | Block C Access Control Day
 |  | Mar | 3 | 2024 | 3 | Block C Access Control Night
 |  | Apr | 4 | 2025 | 4 | Block B 3rd Floor Day
 |  | May | 5 | 2026 | 5 | Block C 1st Floor Day
 |  | Jun | 6 | 2027 | 6 | Block C 1st Floor Night
 |  | Jul | 7 | 2028 | 7 | CCTV Operator Day
 |  | Aug | 8 | 2029 | 8 | CCTV Operator Night
 |  | Sep | 9 | 2030 | 9 | Simulator Access Control Night
 |  | Oct | 10 | 2031 | 10 | Supervisor Contingency Post Day
 |  | Nov | 11 | 2032 | 11 | Supervisor Contingency Post Night
 |  | Dec | 12 | 2033 | 12 | Tamouth Access Control Day
 |  |  |  |  | 13 | Tamouth Access Control Night
 |  |  |  |  | 14 | Patrols All Floors Day
 |  |  |  |  | 15 | Patrols All Floors Night
 |  |  |  |  | 16 | Injazat Access Control Day
 |  |  |  |  | 17 | Injazat Access Control Night