Spreadsheet: 73521d1274191136-choose-a-value-in-the-dropdown-and-make-formula-lookup-in-the-relevant-table-kpi-trial
Sheet: Stafflist

 |  |  |  | H - HOLIDAY |  |  | S - SICK |  | U - UNPAID LEAVE |  |  |  | O - 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
 |  | DaySHift1 [NAME] |  |  |  | H
 |  | DaySHift1 name3 |  |  | H | S |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S
 |  | DaySHift1 name4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  |  | H
 |  | DaySHift1 name5 |  |  |  | H |  | O |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
 |  | DaySHift1 name6 |  |  |  | S |  |  |  | O |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | U |  | H
 |  | DaySHift1 name7 |  |  |  |  | H |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | U
 |  | DaySHift1 name8 |  |  |  | S |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S
 |  | DaySHift1 name9 |  |  |  |  | S | O |  |  |  | S
 |  | DaySHift1 name10 |  |  |  | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H | S | S
 |  | DaySHift1 name11 |  |  |  | H
 |  | DaySHift1 name12 |  |  |  |  | H |  |  |  |  |  | S | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | S
 |  | DaySHift1 name13 |  |  |  | H | S |  |  |  |  | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  | U | U
 |  | DaySHift1 name14 |  |  |  |  |  |  |  | O |  |  | S | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | H |  | U
 |  | DaySHift1 name15 |  |  |  |  |  | O
 |  | DaySHift1 [NAME] |  |  |  | H |  |  |  |  |  | H
 |  | DaySHift1 name17 |  |  |  |  | H |  |  |  |  |  |  | S
 |  | DaySHift1 name18 |  |  |  |  |  |  |  |  |  | U | H
 |  | DaySHift1 name19 |  |  |  |  |  |  |  |  |  |  | U
 |  | DaySHift1 name20 |  |  |  |  |  |  |  |  |  |  |  | H
 |  | DaySHift1 name21
 |  | DaySHift1 name22 |  |  |  |  |  |  |  |  |  | U |  | U
 |  | DaySHift1 name23
 |  | DaySHift1 name24
 |  | DaySHift1 name25
 |  | DaySHift1 [NAME]
 |  | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | U |  | H
 |  | NigHtSHift1 name7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | U
 |  | NigHtSHift1 name8 |  |  |  |  |  |  |  | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S
 |  | NigHtSHift1 name9 |  |  | H | S | S
 |  | NigHtSHift1 name10 |  |  |  |  |  | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H | S | S
 |  | NigHtSHift1 name11 |  |  |  |  | S
 |  | NigHtSHift1 name12 |  |  |  |  | U |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | S
 |  | NigHtSHift1 name13 |  |  | H |  |  | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  | U | U
 |  | NigHtSHift1 name14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | H |  | U
 |  | NigHtSHift1 name15 |  |  |  |  |  |  | O
 |  | NigHtSHift1 [NAME] |  |  | H |  | U
 |  | NigHtSHift1 name17
 |  | NigHtSHift1 name18 |  |  |  |  |  | O
 |  | NigHtSHift1 name19
 |  | NigHtSHift1 name20
 |  | NigHtSHift1 name21
 |  | NigHtSHift1 name22
 |  | NigHtSHift1 name23
 |  | NigHtSHift1 name24
 |  | NigHtSHift1 name25
 |  | NigHtSHift1 name26
 |  | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  |  | H
 |  | DaySHift2 name 5 |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
 |  | DaySHift2 name 6 |  |  |  |  |  | H | H | H |  |  |  | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | U |  | H
 |  | DaySHift2 name 7 |  |  |  |  |  |  |  |  | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | U
 |  | DaySHift2 name 8 |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S
 |  | DaySHift2 name 9 |  |  |  |  |  | S |  |  | H |  | O
 |  | DaySHift2 name 10 |  |  |  |  |  |  | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H | S | S
 |  | DaySHift2 name 11 |  |  |  |  |  |  |  | H | S
 |  | DaySHift2 name 12 |  |  |  |  |  | S | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | S
 |  | DaySHift2 name 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  | U | U
 |  | DaySHift2 name 14 |  |  |  |  |  |  |  |  |  |  |  | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | H |  | U
 |  | DaySHift2 name 15 |  |  |  |  |  | H | S |  | U
 |  | DaySHift2 name 16 |  |  |  |  |  |  |  | S
 |  | DaySHift2 name 17 |  |  |  |  |  |  |  | S
 |  | DaySHift2 name 18 |  |  |  |  |  | H | S |  | H
 |  | DaySHift2 name 19 |  |  |  |  |  |  |  | S
 |  | DaySHift2 name 20 |  |  |  |  |  | S | U |  | U
 |  | DaySHift2 name 21
 |  | DaySHift2 name 22
 |  | DaySHift2 name 23 |  |  |  |  |  |  | U |  | 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 name5 |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
 |  | NigHSHift2 name6 |  |  |  |  |  | H | U |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | U |  | H
 |  | NigHSHift2 name7 |  |  |  |  |  |  |  |  |  |  | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | U
 |  | NigHSHift2 name8 |  |  |  |  |  |  |  | S | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S
 |  | NigHSHift2 name9 |  |  |  |  |  |  |  | S
 |  | NigHSHift2 [NAME] |  |  |  |  |  | S | U |  | S |  |  | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H | S | S
 |  | NigHSHift2 name11
 |  | NigHSHift2 name12 |  |  |  |  |  |  |  | H | H | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | S
 |  | NigHSHift2 name13 |  |  |  |  |  | H |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  | U | U
 |  | NigHSHift2 name14 |  |  |  |  |  |  | H | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | H |  | U
 |  | NigHSHift2 [NAME] |  |  |  |  |  | S |  | U | U
 |  | NigHSHift2 [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | O
 |  | NigHSHift2 name17 |  |  |  |  |  |  | S
 |  | NigHSHift2 name18 |  |  |  |  |  | H
 |  | NigHSHift2 name19 |  |  |  |  |  |  | S
 |  | NigHSHift2 [NAME] |  |  |  |  |  | U
 |  | NigHSHift2 [NAME]
 |  | NigHSHift2 [NAME]
 |  | NigHSHift2 name23
 |  | NigHSHift2 [NAME]
 |  | NigHSHift2 name25
 |  | NigHSHift2 [NAME]
 |  | NigHSHift2 name27
 |  | NigHSHift2 [NAME]
 |  | NigHSHift2 name29
 |  | NigHSHift2 name30
 |  | NigHSHift2 name31
 | 8 HrS early | [NAME] name1 |  |  | H | H | S | U
 |  | [NAME] |  |  |  |  | S | U
 |  | [NAME] |  |  |  | H
 |  | [NAME]
 |  | [NAME]
 | 8 HrS late | LateS name1 |  |  |  |  | S | U
 |  | LateS [NAME] |  |  |  | H
 |  | LateS name3 |  |  |  | H | S | U
 |  | LateS name4
 |  | LateS [NAME]
 |  |  |  | MONTHS
 |  |  |  | May
 |  |  |  | June
 |  |  |  | July
 |  |  |  | AuguSt
 |  |  |  | September
 |  |  |  | October
 |  |  |  | November
 |  |  |  | December