Spreadsheet: 690686d1597236906-textjoin-or-match-index-roster-test
Sheet: Roster

2019-2020 | 2020-04-05 00:00:00 | 2020-04-06 00:00:00 | 2020-04-07 00:00:00 | 2020-04-08 00:00:00 | 2020-04-09 00:00:00 | 2020-04-10 00:00:00 | 2020-04-11 00:00:00 | 2020-04-12 00:00:00 | 2020-04-13 00:00:00 | 2020-04-14 00:00:00 | 2020-04-15 00:00:00 | 2020-04-16 00:00:00 | 2020-04-17 00:00:00 | 2020-04-18 00:00:00 | 2020-04-19 00:00:00 | 2020-04-20 00:00:00 | 2020-04-21 00:00:00 | 2020-04-22 00:00:00 | 2020-04-23 00:00:00 | 2020-04-24 00:00:00 | 2020-04-25 00:00:00 | 2020-04-26 00:00:00 | 2020-04-27 00:00:00 | 2020-04-28 00:00:00 | 2020-04-29 00:00:00 | 2020-04-30 00:00:00 | 2020-05-01 00:00:00 | 2020-05-02 00:00:00
 | SUN | 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
person1
person2 |  | E | L | L | L | [NAME] | [NAME] | [NAME] | [NAME] | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E
person3 | E | E | L | L | L | [NAME] | [NAME] | [NAME] | [NAME] | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E
person4 |  | E | L | L | L | [NAME] | [NAME] | [NAME] | [NAME] | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E
person5 |  | E | L | L | L | [NAME] | [NAME] | [NAME] | [NAME] | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E
person6 | E | E | L | L | L | [NAME] | [NAME] | [NAME] | [NAME] | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E
person7 |  | E | L | L | L | [NAME] | [NAME] | [NAME] | [NAME] | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E
person8 |  | E | L | L | L | [NAME] | [NAME] | [NAME] | [NAME] | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E
person9 |  | E | L | L | L | [NAME] | [NAME] | [NAME] | [NAME] | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E
person10 |  | E | L | L | L | [NAME] | [NAME] | [NAME] | [NAME] | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E
person11 |  | E | L | L | L | [NAME] | [NAME] | [NAME] | [NAME] | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E
person12 |  | E | L | L | L | [NAME] | [NAME] | [NAME] | [NAME] | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E
[NAME] |  | E | L | L | L | [NAME] | [NAME] | [NAME] | [NAME] | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E
A/L
Other
SICK
person1
person2 | SRD | SRD | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E | E | E | L | L | L | SRD | SRD
person3 | SRD | SRD | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E | E | E | L | L | L | SRD | SRD
person4 | SRD | SRD | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E | E | E | L | L | L | SRD | SRD
person5 | SRD | SRD | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E | E | E | L | L | L | SRD | SRD
person6 | SRD | SRD | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E | E | E | L | L | L | SRD | SRD
person7 | SRD | SRD | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E | E | E | L | L | L | SRD | SRD
person8 | SRD | SRD | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E | E | E | L | L | L | SRD | SRD
person9 | SRD | SRD | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E | E | E | L | L | L | SRD | SRD
person10 | SRD | SRD | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E | E | E | L | L | L | SRD | SRD
person11 | SRD | SRD | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E | E | E | L | L | L | SRD | SRD
person12 | SRD | SRD | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E | E | E | L | L | L | SRD | SRD
[NAME] | SRD | SRD | E | E | E | O | O | O | O | O | O | O | L | L | L | L | SRD | SRD | SRD | E | E | E | E | L | L | L | SRD | SRD
A/L |  |  |  |  |  |  |  | O
SICK |  |  |  |  |  |  |  | O
other |  |  |  |  |  |  |  | O
 |  |  |  |  |  |  |  | O