Spreadsheet: 130392d1322239949-array-formula-to-pull-multiple-numbers-based-on-test-dummy-ot-more-than-1-code-v2
Sheet: Q4 - Nov 1 to Dec 31 2011

Replacements /  Calls Backs | FC ~ OT - Fire Call MT ~ OT - Meeting TAP ~ TAPP 'C' WSIB ~ Replacement - WSIB B ~ Replacement - Bereavement  S ~ Replacement - Sick M ~ Replacement - Manpower PL ~ Replacement - Parental Leave ED ~ Replacement - Education SUSP ~ Replacement - Suspension
Acting | AC ~ Acting Captain APC ~ Acting Platoon Chief ACST ~ Acting Captain on STAT APCST ~ Acting Platoon Chief on STAT
Tech | AE ~ OT - TECH - Auto Extrication HT ~ OT - TECH - Hazmat RT ~ OT - TECH - Rope OTT ~ OT - TECH - Other, Not listed MSAT ~ OT - TECH - MSA ACAE ~ OT - TECH - Auto Extrication ACHT ~ OT - TECH - Acting - Hazmat ACRT ~ OT - TECH - Acting - Rope ACMSAT ~ OT
OT | ST ~ OT - Straight Time OTH ~ OT - Other Reason OTAC ~ OT - Acting Captain OTAPC ~ OT - Acting Platoon Chief STAT ~ OT - STAT Holiday Late Submissions ~ Enter the hours on the actual date the hours were worked and add the current Pay Period (P#)  at the e | Pay Period 20 September 21, 2011 - October 4, 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Period 21 October 5, 2011 - October 18, 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Period 22 October 19, 2011 - November 1, 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Period 23 November 2, 2011 - November 15, 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Period 24 November 16, 2011 to November 29, 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Period 25 November 30, 2011 to December 13, 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Period 26 December 14, 2011 to December 27, 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Period 27 December 28, 2011 to December 31, 2011
Seniority | EMPLOYEE | 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 | 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 | 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 | 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 | SUN | MON | TUE
 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
EMP# | Employee 1
EMP# | Employee 2
EMP# | Employee 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 ACSTAT
EMP# | Employee 4 |  |  |  |  |  |  |  |  |  |  |  | 10 S |  |  |  |  |  |  |  | 10 STAT |  |  |  |  |  | 14 LTD
EMP# | Employee 5 |  |  |  |  |  |  |  |  |  |  | 10 STAT
EMP# | Employee 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 S
EMP# | Employee 7 |  |  |  |  |  |  |  |  |  |  | 2.5 M  14 ACST |  | 1.5 OTH | 1.25 OTH
EMP# | Employee 8 |  |  |  |  |  |  |  |  |  |  |  |  | 10 M | 10 M |  |  |  |  |  | 8 STAT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 ED
EMP# | Employee 9
Totals |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 10 | 11 | 11 | 0 | 0 | 0 | 0 | 0 | 28 | 0 | 0 | 0 | 0 | 0 | 14 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0