Spreadsheet: 851092d1701342833-identify-last-valid-cost-via-formula-xverweis-causing-performance-issues-testsample-aligw
Sheet: Colleagues

# | Valid | Fullname | Firstname | Lastname | Rate (TnM/h) offsite | Rate (TnM/h) onsite | Rate (FP/m) | OrderType
1 | 2024-01-01 00:00:00 |  | Person | A1 | 10 |  |  | TnM
2 | 2024-03-01 00:00:00 |  | Person | A1 | 70 |  |  | TnM
3 | 2024-01-01 00:00:00 |  | Person | A2 | 11 |  |  | TnM
4 | 2024-01-01 00:00:00 |  | Person | A3 | 12 |  |  | TnM
5 | 2024-01-01 00:00:00 |  | Person | A4 | 13 |  |  | TnM
6 | 2024-01-01 00:00:00 |  | Person | A5 | 14 |  |  | TnM
7 | 2024-01-01 00:00:00 |  | Person | A6 | 15 |  |  | TnM
8 | 2024-01-01 00:00:00 |  | Person | A7 | 16 |  |  | TnM
9 | 2024-01-01 00:00:00 |  | Person | A8 | 17 |  |  | TnM
10 | 2024-01-01 00:00:00 |  | Person | A9 | 18 |  |  | TnM
11 | 2024-01-01 00:00:00 |  | Person | A10 | 19 |  |  | TnM
12 | 2024-01-01 00:00:00 |  | Person | A11 | 20 |  |  | TnM
13 | 2024-01-01 00:00:00 |  | Person | A12 | 21 |  |  | TnM
14 | 2024-01-01 00:00:00 |  | Person | A13 | 22 |  |  | TnM
15 | 2024-01-01 00:00:00 |  | Person | A14 | 23 |  |  | TnM
16 | 2024-01-01 00:00:00 |  | Person | A15 | 24 |  |  | TnM
17 | 2024-01-01 00:00:00 |  | Person | A16 | 25 |  |  | TnM
18 | 2024-01-01 00:00:00 |  | Person | A17 | 26 |  |  | TnM
19 | 2024-01-01 00:00:00 |  | Person | A18 | 27 |  |  | TnM
20 | 2024-01-01 00:00:00 |  | Person | A19 | 28 |  |  | TnM
21 | 2024-01-01 00:00:00 |  | Person | A20 |  |  |  | TnM
22 | 2024-01-01 00:00:00 |  | Person | A21 |  |  |  | TnM
23 | 2024-01-01 00:00:00 |  | Person | A22 |  |  | 100 | FP
24 | 2024-01-01 00:00:00 |  | Person | A23 |  |  | 100 | FP
25 | 2024-01-01 00:00:00 |  | Person | A24 |  |  | 100 | FP
26 | 2024-01-01 00:00:00 |  | Person | A25 |  |  | 100 | FP
27 | 2024-01-01 00:00:00 |  | Person | A26 |  |  | 100 | FP
28 | 2024-01-01 00:00:00 |  | Person | A27 |  |  | 100 | FP
29 | 2024-01-01 00:00:00 |  | Person | A28 |  |  | 100 | FP
30 | 2024-01-01 00:00:00 |  | Person | A29 |  |  | 100 | FP
31 | 2024-01-01 00:00:00 |  | Person | A30 |  |  | 100 | FP
32 | 2024-01-01 00:00:00 |  | Person | A31 |  |  | 100 | FP
33 | 2024-01-01 00:00:00 |  | Person | A32 |  |  | 100 | FP
34 | 2024-01-01 00:00:00 |  | Person | A33 |  |  | 100 | FP
35 | 2024-01-01 00:00:00 |  | Person | A34 |  |  | 100 | FP
36 | 2024-01-01 00:00:00 |  | Person | [NAME] |  |  | 100 | FP
37 | 2024-01-01 00:00:00 |  | Person | A36 |  |  | 100 | FP
38 | 2024-01-01 00:00:00 |  | Person | A37 |  |  | 100 | FP
39 | 2024-01-01 00:00:00 |  | Person | A38 |  |  | 100 | FP
40 | 2024-01-01 00:00:00 |  | Person | A39 |  |  | 100 | FP
41 | 2024-01-01 00:00:00 |  | Person | A40 |  |  | 100 | FP
42 | 2024-01-01 00:00:00 |  | Person | A41 |  |  | 100 | FP
43 | 2024-01-01 00:00:00 |  | Person | A42 |  |  | 100 | FP
44 | 2024-01-01 00:00:00 |  | Person | A43 |  |  | 100 | FP
45 | 2024-01-01 00:00:00 |  | Person | [NAME] |  |  | 100 | FP
46 | 2024-01-01 00:00:00 |  | Person | A45 |  |  | 100 | FP
47 | 2024-01-01 00:00:00 |  | Person | A46 |  |  | 100 | FP
48 | 2024-01-01 00:00:00 |  | Person | A47 |  |  | 100 | FP
49 | 2024-01-01 00:00:00 |  | Person | A48 |  |  | 100 | FP
50 | 2024-01-01 00:00:00 |  | Person | A49 |  |  | 100 | FP
51 | 2024-01-01 00:00:00 |  | Person | [NAME] |  |  | 100 | FP
52 | 2024-01-01 00:00:00 |  | Person | A51 | 29 |  |  | TnM
53 | 2024-01-01 00:00:00 |  | Person | A52 | 30 |  |  | TnM
54 | 2024-01-01 00:00:00 |  | Person | A53 | 31 |  |  | TnM
55 | 2024-01-01 00:00:00 |  | Person | [NAME] | 32 |  |  | TnM
56 | 2024-01-01 00:00:00 |  | Person | A55 | 33 |  |  | TnM
57 | 2024-01-01 00:00:00 |  | Person | [NAME] | 34 |  |  | TnM
58 | 2024-01-01 00:00:00 |  | Person | A57 | 35 |  |  | TnM
59 | 2024-01-01 00:00:00 |  | Person | A58 | 36 |  |  | TnM
60 | 2024-01-01 00:00:00 |  | Person | A59 |  |  | 100 | FP