Spreadsheet: 130402d1322245751-array-formula-to-pull-multiple-numbers-based-on-test-dummy-ot-more-than-1-code-v3
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 |  |  |  |  |  |  |  |  |  |  | 2.75 OTH 5 STAT P21 |  |  |  | 10 AC
EMP# | Employee 2 |  |  |  |  |  |  |  |  |  |  | 1.75 OTH P21
EMP# | Employee 3 |  |  |  |  |  |  |  |  |  |  | 1.75 OTH
EMP# | Employee 4
EMP# | Employee 5
EMP# | Employee 6
EMP# | Employee 7
EMP# | Employee 8
EMP# | Employee 9
Totals |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | #N/A | 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 | 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