Spreadsheet: 120090d1314971593-vlookup-loop-until-data-found-tracker-example
Sheet: Summary

ID | Employee | Team | Type | Total Infraction Count | CA Intraction Count | Current Infraction | Comments
92497 | XXXXX | XXXXX | XXXXX | 1 |  | 1 | 0
92120 | XXXXX | XXXXX | XXXXX |  |  |  | 0
46495 | XXXXX | XXXXX | XXXXX | 0.25 |  | 0.25 | 0
11742 | XXXXX | XXXXX | XXXXX | 1 |  | 1 | Level 1 delivered 10/26/10
98480 | XXXXX | XXXXX | XXXXX | 0.25 |  | 0.25 | 0
86763 | XXXXX | XXXXX | XXXXX | 10.25 | 3.25 | 7 | 0
32982 | XXXXX | XXXXX | XXXXX | 2 |  | 2 | 0
98491 | XXXXX | XXXXX | XXXXX | 4 |  | 4 | 0
25834 | XXXXX | XXXXX | XXXXX | 4.5 | 3 | 1.5 | Level 1 delivered 10/26/10
91468 | XXXXX | XXXXX | XXXXX |  |  |  | 0
18308 | XXXXX | XXXXX | XXXXX | 3 |  | 3 | Level 1 delivered 10/26/10
22270 | XXXXX | XXXXX | XXXXX | 4 |  | 4 | Level 1 delivered 10/26/10
25847 | XXXXX | XXXXX | XXXXX | 6.25 | 3.75 | 2.5 | 0
25772 | XXXXX | XXXXX | XXXXX | 2 |  | 2 | Level 1 delivered 10/26/10
25773 | XXXXX | XXXXX | XXXXX | 2.25 |  | 2.25 | Level 1 delivered 10/26/10
25841 | XXXXX | XXXXX | XXXXX | 4.5 | 4.25 | 0.25 | Level 1 delivered 10/26/10
11730 | XXXXX | XXXXX | XXXXX |  |  |  | #N/A
86777 | XXXXX | XXXXX | XXXXX | 11.75 | 8.75 | 3 | 0
46574 | XXXXX | XXXXX | XXXXX |  |  |  | 0
11734 | XXXXX | XXXXX | XXXXX | 5 | 3.25 | 1.75 | Level 1 delivered 10/26/10
46494 | XXXXX | XXXXX | XXXXX | 1.25 |  | 1.25 | 0
91467 | XXXXX | XXXXX | XXXXX |  |  |  | 0
25842 | XXXXX | XXXXX | XXXXX | 1.75 |  | 1.75 | 0
46494 | XXXXX | XXXXX | XXXXX | 1.25 |  | 1.25 | 0
46491 | XXXXX | XXXXX | XXXXX |  |  |  | 0
98492 | XXXXX | XXXXX | XXXXX |  |  |  | 0
11738 | XXXXX | XXXXX | XXXXX |  |  |  | Level 1 delivered 10/26/10
25872 | XXXXX | XXXXX | XXXXX | 7.75 | 7.75 |  | Level 2 delivered 03/07/11
18380 | XXXXX | XXXXX | XXXXX | 3.75 |  | 3.75 | Level 1 delivered 10/26/10
98485 | XXXXX | XXXXX | XXXXX | 7.25 | 7.25 |  | 0
11740 | XXXXX | XXXXX | XXXXX |  |  |  | Level 1 delivered 10/26/10
97324 | XXXXX | XXXXX | XXXXX | 2.75 |  | 2.75 | 0
32837 | XXXXX | XXXXX | XXXXX |  |  |  | 0
18310 | XXXXX | XXXXX | XXXXX | 1.5 |  | 1.5 | Level 1 delivered 10/26/10
46482 | XXXXX | XXXXX | XXXXX | 0.25 |  | 0.25 | 0
25840 | XXXXX | XXXXX | XXXXX | 0.75 |  | 0.75 | Level 1 delivered 10/26/10
86186 | XXXXX | XXXXX | XXXXX | 4.75 | 3.25 | 1.5 | Level 1 delivered 02/22/11
32957 | XXXXX | XXXXX | XXXXX | 3 | 3 |  | 0
92832 | XXXXX | XXXXX | XXXXX |  |  |  | 0
86676 | XXXXX | XXXXX | XXXXX | 2 |  | 2 | 0
19011 | XXXXX | XXXXX | XXXXX | 0.75 |  | 0.75 | Level 1 delivered 10/26/10
32589 | XXXXX | XXXXX | XXXXX | 1.5 |  | 1.5 | 0
98484 | XXXXX | XXXXX | XXXXX | 4 | 3 | 1 | 0
92856 | XXXXX | XXXXX | XXXXX | 0.75 |  | 0.75 | 0
22207 | XXXXX | XXXXX | XXXXX |  |  |  | Level 1 delivered 10/26/10
55272 | XXXXX | XXXXX | XXXXX | 1.25 |  | 1.25 | 0
99407 | XXXXX | XXXXX | XXXXX | 1.5 |  | 1.5 | 0
18311 | XXXXX | XXXXX | XXXXX |  |  |  | Level 1 delivered 10/26/10
25856 | XXXXX | XXXXX | XXXXX | 6.75 | 6.75 |  | 0
33271 | XXXXX | XXXXX | XXXXX | 0.25 |  | 0.25 | 0
99434 | XXXXX | XXXXX | XXXXX | 2.5 |  | 2.5 | 0
33216 | XXXXX | XXXXX | XXXXX | 1.25 |  | 1.25 | 0
11736 | XXXXX | XXXXX | XXXXX |  |  |  | Level 1 delivered 10/26/10
22274 | XXXXX | XXXXX | XXXXX | 1.25 |  | 1.25 | Level 1 delivered 10/26/10
33214 | XXXXX | XXXXX | XXXXX | 1 |  | 1 | 0
32836 | XXXXX | XXXXX | XXXXX | 3 |  | 3 | 0
22209 | XXXXX | XXXXX | XXXXX | 2.75 |  | 2.75 | Level 1 delivered 10/26/10
86198 | XXXXX | XXXXX | XXXXX | 2.75 |  | 2.75 | 0
98478 | XXXXX | XXXXX | XXXXX |  |  |  | 0
25829 | XXXXX | XXXXX | XXXXX | 2.75 |  | 2.75 | Level 1 delivered 10/26/10
25839 | XXXXX | XXXXX | XXXXX | 3.5 | 3 | 0.5 | Level 1 delivered 10/26/10
32975 | XXXXX | XXXXX | XXXXX | 1.75 |  | 1.75 | 0
25827 | XXXXX | XXXXX | XXXXX | 2 |  | 2 | Level 1 delivered 10/26/10
32692 | XXXXX | XXXXX | XXXXX | 0.75 |  | 0.75 | 0
32830 | XXXXX | XXXXX | XXXXX | 4 | 3.75 | 0.25 | 0
46473 | XXXXX | XXXXX | XXXXX |  |  |  | 0
98497 | XXXXX | XXXXX | XXXXX | 13 | 12 | 1 | 0
25849 | XXXXX | XXXXX | XXXXX | 2.75 |  | 2.75 | 0
32587 | XXXXX | XXXXX | XXXXX | 0.5 |  | 0.5 | 0
25843 | XXXXX | XXXXX | XXXXX | 4.5 | 3.5 | 1 | 0
32843 | XXXXX | XXXXX | XXXXX | 2.75 |  | 2.75 | 0
25852 | XXXXX | XXXXX | XXXXX | 9.25 | 9.25 |  | 0
99413 | XXXXX | XXXXX | XXXXX | 3 | 3 |  | Level 3 delivered 11/01/10 non-attendance
22293 | XXXXX | XXXXX | XXXXX | 2.5 |  | 2.5 | Level 1 delivered 10/26/10
409573 | XXXXX | XXXXX | XXXXX |  |  |  | 0
91463 | XXXXX | XXXXX | XXXXX |  |  |  | 0
86764 | XXXXX | XXXXX | XXXXX | 1.75 |  | 1.75 | 0
99439 | XXXXX | XXXXX | XXXXX | 4.5 | 4 | 0.5 | Level 1 delivered 07/12/11
22302 | XXXXX | XXXXX | XXXXX |  |  |  | Level 1 delivered 10/26/10
11726 | XXXXX | XXXXX | XXXXX | 2.5 |  | 2.5 | #N/A
46490 | XXXXX | XXXXX | XXXXX | 0.25 |  | 0.25 | 0
86682 | XXXXX | XXXXX | XXXXX | 2.25 | 2.25 |  | 0
97276 | XXXXX | XXXXX | XXXXX | 3.5 |  | 3.5 | 0
46488 | XXXXX | XXXXX | XXXXX |  |  |  | 0
98489 | XXXXX | XXXXX | XXXXX | 1.5 |  | 1.5 | 0
11727 | XXXXX | XXXXX | XXXXX | 2 | 0.5 | 1.5 | #N/A
99416 | XXXXX | XXXXX | XXXXX | 2.75 |  | 2.75 | 0
25831 | XXXXX | XXXXX | XXXXX | 1 |  | 1 | Level 1 delivered 10/26/10
91464 | XXXXX | XXXXX | XXXXX | 1 |  | 1 | 0
32831 | XXXXX | XXXXX | XXXXX |  |  |  | 0
11729 | XXXXX | XXXXX | XXXXX |  |  |  | #N/A
46465 | XXXXX | XXXXX | XXXXX |  |  |  | 0
46472 | XXXXX | XXXXX | XXXXX |  |  |  | 0
98487 | XXXXX | XXXXX | XXXXX | 3.25 | 3 | 0.25 | 0
11753 | XXXXX | XXXXX | XXXXX |  |  |  | Level 1 delivered 10/26/10
86680 | XXXXX | XXXXX | XXXXX |  |  |  | 0
97326 | XXXXX | XXXXX | XXXXX |  |  |  | 0
46485 | XXXXX | XXXXX | XXXXX |  |  |  | 0
86732 | XXXXX | XXXXX | XXXXX |  |  |  | 0
46469 | XXXXX | XXXXX | XXXXX |  |  |  | 0
86684 | XXXXX | XXXXX | XXXXX | 2 |  | 2 | 0
11754 | XXXXX | XXXXX | XXXXX | 7.75 | 7 | 0.75 | Level 1 delivered 10/26/10
46466 | XXXXX | XXXXX | XXXXX |  |  |  | 0
 |  |  | Level 1
 |  |  | Level 2
 |  |  | Level 3