Spreadsheet: 867497d1714375557-weekend-rota-planning-generate-values-based-on-criteria-date-shift-pattern-weekend-rota-planing-aligw-2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apple | [NAME] | Pear | Grape | Plum
 |  |  |  | 2024-05-01 00:00:00 |  |  |  |  |  |  |  |  |  | 2024-05-01 00:00:00 | 1 | 0 | 0 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | 2024-05-01 00:00:00
 |  |  | Name |  |  |  |  |  |  |  |  |  |  | 2024-05-02 00:00:00 | 1 | 1 | 1 | 0 | 1 |  |  |  |  |  |  |  |  |  | Name
 |  |  | Apple |  |  |  |  |  |  |  |  |  |  | 2024-05-03 00:00:00 | 1 | 0 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  | Apple |  | 18:00 | 06:00 | 18:00 | 06:00 | 18:00 |  |  |  |  |  |  | 06:00 | 18:00
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 2024-05-04 00:00:00 | 0 | 1 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  | [NAME] |  |  | 06:00 | 18:00 |  |  | 06:00 | 18:00
 |  |  | Pear |  |  |  |  |  |  |  |  |  |  | 2024-05-05 00:00:00 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | Pear |  |  | 06:00 | 18:00 | 06:00 | 18:00
 |  |  | Grape |  |  |  |  |  |  |  |  |  |  | 2024-05-06 00:00:00 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | Grape | 06:00 | 18:00 |  |  | 06:00 | 18:00
 |  |  | Plum |  |  |  |  |  |  |  |  |  |  | 2024-05-07 00:00:00 | 1 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | Plum | 06:00 | 18:00 | 06:00 | 18:00 | 06:00 | 18:00 | 06:00 | 18:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-08 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-09 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-10 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-11 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-12 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-13 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-14 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-15 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-16 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-17 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-18 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-19 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-20 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-21 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-22 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-23 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-24 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-25 00:00:00 | 0 | 0 | 0 | 0 | 0 |  |  |  | DROP(REDUCE(0,INDEX(l,,1),LAMBDA(x,y,VSTACK(x,FILTER(DROP(l,,1),INDEX(l,,1)=y)))),1),
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-26 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-27 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-28 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-29 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-30 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-31 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-01 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-02 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-03 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-04 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-05 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-06 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-07 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-08 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-09 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-10 00:00:00 | 1 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-11 00:00:00 | 0 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-12 00:00:00 | 0 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-13 00:00:00 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-14 00:00:00 | 1 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-15 00:00:00 | 1 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-16 00:00:00 | 1 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-17 00:00:00 | 1 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-18 00:00:00 | 1 | 0 | 0 | 0 | 0