Spreadsheet: 73376d1274032751-how-to-expand-arrays-in-the-formula-packaging-1-
Sheet: Stafflist

 |  |  |  | H - HOLIDAY |  |  | S - SICK |  | UNPD - UNPAID LEAVE |  |  |  | O/T - OVERTIME |  |  |  | -   ON |  | -   OFF
 | DS1 | NAMES |  |  | 2010-05-01 00:00:00 | 2010-05-02 00:00:00 | 2010-05-03 00:00:00 | 2010-05-04 00:00:00 | 2010-05-05 00:00:00 | 2010-05-06 00:00:00 | 2010-05-07 00:00:00 | 2010-05-08 00:00:00 | 2010-05-09 00:00:00 | 2010-05-10 00:00:00 | 2010-05-11 00:00:00 | 2010-05-12 00:00:00 | 2010-05-13 00:00:00 | 2010-05-14 00:00:00 | 2010-05-15 00:00:00 | 2010-05-16 00:00:00 | 2010-05-17 00:00:00 | 2010-05-18 00:00:00 | 2010-05-19 00:00:00 | 2010-05-20 00:00:00 | 2010-05-21 00:00:00 | 2010-05-22 00:00:00 | 2010-05-23 00:00:00 | 2010-05-24 00:00:00 | 2010-05-25 00:00:00 | 2010-05-26 00:00:00 | 2010-05-27 00:00:00 | 2010-05-28 00:00:00 | 2010-05-29 00:00:00 | 2010-05-30 00:00:00 | 2010-05-31 00:00:00
 |  | DayShift1 name1 |  |  | h
 |  | [NAME] |  |  |  | H
 |  | DayShift1 name3 |  |  | h | S |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S
 |  | DayShift1 name4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  |  | H
 |  | [NAME] |  |  |  | H |  | O/T |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
 |  | DayShift1 name6 |  |  |  | S |  |  |  | O/T |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | UNPD |  | H
 |  | DayShift1 name7 |  |  |  |  | H |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | UNPD
 |  | DayShift1 name8 |  |  |  | S |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S
 |  | DayShift1 name9 |  |  |  |  | S | O/T |  |  |  | S
 |  | [NAME] |  |  |  | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H | S | S
 |  | DayShift1 name11 |  |  |  | H
 |  | DayShift1 name12 |  |  |  |  | H |  |  |  |  |  | S | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | S
 |  | DayShift1 name13 |  |  |  | H | S |  |  |  |  | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  | UNPD | UNPD
 |  | DayShift1 name14 |  |  |  |  |  |  |  | O/T |  |  | S | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | H |  | UNPD
 |  | DayShift1 name15 |  |  |  |  |  | O/T
 |  | [NAME] |  |  |  | H |  |  |  |  |  | H
 |  | DayShift1 name17 |  |  |  |  | H |  |  |  |  |  |  | S
 |  | DayShift1 name18 |  |  |  |  |  |  |  |  |  | UNPD | H
 |  | DayShift1 name19 |  |  |  |  |  |  |  |  |  |  | UNPD
 |  | DayShift1 name20 |  |  |  |  |  |  |  |  |  |  |  | H
 |  | DayShift1 name21
 |  | DayShift1 name22 |  |  |  |  |  |  |  |  |  | UNPD |  | UNPD
 |  | DayShift1 name23
 |  | DayShift1 name24
 |  | DayShift1 name25
 |  | DayShift1 name26
 |  | DayShift1 name27
 |  | DayShift1 name28
 |  | DayShift1 name29
 |  | DayShift1 name30
 |  | DayShift1 name31
 | NS1 | NightShift1 name1
 |  | NightShift1 [NAME] |  |  |  | S
 |  | NightShift1 name3 |  |  |  | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S
 |  | NightShift1 name4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  |  | H
 |  | NightShift1 name5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
 |  | NightShift1 name6 |  |  |  | S | H | O/T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | UNPD |  | H
 |  | NightShift1 name7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | UNPD
 |  | NightShift1 name8 |  |  |  |  |  |  |  | O/T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S
 |  | NightShift1 name9 |  |  | H | S | S
 |  | NightShift1 name10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H | S | S
 |  | NightShift1 name11 |  |  |  |  | S
 |  | NightShift1 name12 |  |  |  |  | UNPD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | S
 |  | NightShift1 name13 |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  | UNPD | UNPD
 |  | NightShift1 name14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | H |  | UNPD
 |  | NightShift1 name15 |  |  |  |  |  |  | O/T
 |  | NightShift1 [NAME] |  |  | H |  | UNPD
 |  | NightShift1 name17
 |  | NightShift1 name18
 |  | NightShift1 name19
 |  | NightShift1 name20
 |  | NightShift1 name21
 |  | NightShift1 name22
 |  | NightShift1 name23
 |  | NightShift1 name24
 |  | NightShift1 name25
 |  | NightShift1 [NAME]
 |  | NightShift1 name27
 |  | NightShift1 name28
 |  | NightShift1 name29
 |  | NightShift1 name30
 |  | NightShift1 name31
 | DS2 | DayShift2 name 1
 |  | DayShift2 name 2 |  |  |  |  |  |  |  |  | H
 |  | DayShift2 name 3 |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S
 |  | DayShift2 name 4 |  |  |  |  |  |  |  |  |  | O/T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  |  | H
 |  | DayShift2 name 5 |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
 |  | DayShift2 name 6 |  |  |  |  |  | H | H | H |  |  |  | O/T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | UNPD |  | H
 |  | DayShift2 name 7 |  |  |  |  |  |  |  |  | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | UNPD
 |  | DayShift2 name 8 |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S
 |  | DayShift2 name 9 |  |  |  |  |  | S |  |  | H |  | O/T
 |  | DayShift2 name 10 |  |  |  |  |  |  | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H | S | S
 |  | DayShift2 name 11 |  |  |  |  |  |  |  | H | S
 |  | DayShift2 name 12 |  |  |  |  |  | S | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | S
 |  | DayShift2 name 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  | UNPD | UNPD
 |  | DayShift2 name 14 |  |  |  |  |  |  |  |  |  |  |  | O/T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | H |  | UNPD
 |  | DayShift2 name 15 |  |  |  |  |  | H | S |  | UNPD
 |  | DayShift2 name 16 |  |  |  |  |  |  |  | S
 |  | DayShift2 name 17 |  |  |  |  |  |  |  | S
 |  | DayShift2 name 18 |  |  |  |  |  | H | S |  | H
 |  | DayShift2 name 19 |  |  |  |  |  |  |  | S
 |  | DayShift2 name 20 |  |  |  |  |  | S | UNPD |  | UNPD
 |  | DayShift2 name 21
 |  | DayShift2 name 22
 |  | DayShift2 name 23 |  |  |  |  |  |  | UNPD |  | S
 |  | DayShift2 name 24
 |  | DayShift2 name 25
 |  | DayShift2 name 26
 |  | DayShift2 name 27
 |  | DayShift2 name 28
 |  | DayShift2 name 29
 |  | DayShift2 name 30
 |  | DayShift2 name 31
 | NS2 | NighShift2 name1
 |  | NighShift2 [NAME]
 |  | NighShift2 name3 |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S
 |  | NighShift2 name4 |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  |  | H
 |  | NighShift2 [NAME] |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
 |  | NighShift2 name6 |  |  |  |  |  | H | UNPD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | UNPD |  | H
 |  | NighShift2 name7 |  |  |  |  |  |  |  |  |  |  | O/T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | UNPD
 |  | NighShift2 name8 |  |  |  |  |  |  |  | S | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S
 |  | NighShift2 name9 |  |  |  |  |  |  |  | S
 |  | NighShift2 [NAME] |  |  |  |  |  | S | UNPD |  | S |  |  | O/T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H | S | S
 |  | NighShift2 name11
 |  | NighShift2 name12 |  |  |  |  |  |  |  | H | H | O/T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | S
 |  | NighShift2 name13 |  |  |  |  |  | H |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  | UNPD | UNPD
 |  | NighShift2 name14 |  |  |  |  |  |  | H | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | H |  | UNPD
 |  | NighShift2 [NAME] |  |  |  |  |  | S |  | UNPD | UNPD
 |  | NighShift2 [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | O/T
 |  | NighShift2 name17 |  |  |  |  |  |  | S
 |  | NighShift2 name18 |  |  |  |  |  | H
 |  | NighShift2 name19 |  |  |  |  |  |  | S
 |  | NighShift2 [NAME] |  |  |  |  |  | UNPD
 |  | NighShift2 [NAME]
 |  | NighShift2 name22
 |  | NighShift2 name23
 |  | NighShift2 [NAME]
 |  | NighShift2 name25
 |  | NighShift2 [NAME]
 |  | NighShift2 name27
 |  | NighShift2 [NAME]
 |  | NighShift2 name29
 |  | NighShift2 name30
 |  | NighShift2 name31
 | 8 Hrs early | Earlies name1 |  |  | H | H | S | UNPD
 |  | Earlies [NAME] |  |  |  |  | S | UNPD
 |  | Earlies name3 |  |  |  | H
 |  | Earlies name4
 |  | Earlies name5
 | 8 Hrs late | Lates name1 |  |  |  |  | S | UNPD
 |  | Lates name2 |  |  |  | H
 |  | Lates name3 |  |  |  | H | S | UNPD
 |  | Lates name4
 |  | [NAME]
 |  |  |  | MONTHS
 |  |  |  | May
 |  |  |  | June
 |  |  |  | July
 |  |  |  | August
 |  |  |  | September
 |  |  |  | October
 |  |  |  | November
 |  |  |  | December