Spreadsheet: 61828d1262746092-index-match-function-new-example
Sheet: Test

Company Number | Department Number | Unit | Work Location Code | Supervisor | Employee Full Name | Base Role | New Hire? | Term? | Effective Date | Overtime | Normal Hours Worked
1 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 18 | Accounting | No |  | 2009-12-20 00:00:00 |  | 40
2 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 0 | Accounting | No |  | 2009-12-05 00:00:00 | 2 | 60
3 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 19 | Accounting | No |  | 2009-12-21 00:00:00 |  | 65
4 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 4 | Accounting | No |  | 2009-12-06 00:00:00 | 6 | 70
5 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 16 | Accounting | No |  | 2009-12-18 00:00:00 |  | 70
6 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 1 | Accounting | No |  | 2009-12-05 00:00:00 | 2.8 | 71
7 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 3 | Accounting | No |  | 2009-12-05 00:00:00 |  | 75
8 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 15 | Accounting | No |  | 2009-12-17 00:00:00 |  | 79.2
9 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 2 | Accounting | No |  | 2009-12-05 00:00:00 |  | 80
10 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 5 | Accounting | No |  | 2009-12-07 00:00:00 | 1 | 80
11 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 6 | Accounting | No |  | 2009-12-08 00:00:00 | 8 | 80
12 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 7 | Accounting | No |  | 2009-12-09 00:00:00 |  | 80
13 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 8 | Accounting | No |  | 2009-12-10 00:00:00 |  | 80
14 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 9 | Accounting | No |  | 2009-12-11 00:00:00 |  | 80
15 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 10 | Accounting | No |  | 2009-12-12 00:00:00 |  | 80
16 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 11 | Accounting | No |  | 2009-12-13 00:00:00 |  | 80
17 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 12 | Accounting | No |  | 2009-12-14 00:00:00 | 2 | 80
18 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 13 | Accounting | No |  | 2009-12-15 00:00:00 |  | 80
19 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 14 | Accounting | No |  | 2009-12-16 00:00:00 | 4 | 80
20 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 17 | Accounting | No |  | 2009-12-19 00:00:00 | 10 | 80
21 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 20 | Accounting | No |  | 2009-12-22 00:00:00 |  | 80
22 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 21 | Accounting | No |  | 2009-12-23 00:00:00 | 3 | 80
23 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 22 | Accounting | No |  | 2009-12-24 00:00:00 |  | 80
24 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 23 | Accounting | No |  | 2009-12-25 00:00:00 | 1 | 80
25 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 24 | Accounting | No |  | 2009-12-26 00:00:00 |  | 80
26 | 9895 | Accounting | 505 | Example Supervisor | Example Employee 25 | Accounting | No |  | 2009-12-27 00:00:00 |  | 80
Hours worked for pay period 12/4-12/17/2009