Spreadsheet: 83308d1283307784-excel-2007-lookup-to-return-a-value-class-10-xxx-gradebook
Sheet: WO

RNK | LAST | FIRST | SSN | GAT COMP DATE | APFT | SCORE | # OF TRIES | LAND NAV POINTS | LAND NAV TIME | SCORE | # OF TRIES | M9     (BRM 10) | SCORE | # OF TRIES | M16 (BRM 11) | SCORE | # OF TRIES | TACTICS | # OF TRIES | LEADERSHIP | AVERAGE | Notes |  |  |  | APFT |  | LAND NAV |  |  | M9 |  | M16 |  | LEADERSHIP
DATES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RAW SCORE | SCORE | POINTS | TIME | SCORE | HITS | SCORE | HITS | SCORE | RANKING | SCORE
 |  |  |  |  |  |  |  | 4 | 01:01:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  | 0 | 70 | 0 | 70 | 1 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180 | 60 |  |  |  | 16 | 72 | 23 | 71 |  | 99
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 | 61 | 2 | 04:00:00 | 70 | 17 | 74 | 24 | 72 | 2 | 98
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 189 | 63 | 2 | 03:00:00 | 70 | 18 | 76 | 25 | 73 |  | 97
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 | 64 | 2 | 02:30:00 | 70 | 19 | 78 | 26 | 74 | 3 | 96
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 195 | 65 | 2 | 02:00:00 | 70 | 20 | 80 | 27 | 75 |  | 95
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 198 | 66 | 2 | 01:30:00 | 70 | 21 | 82 | 28 | 76 | 4 | 94
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 201 | 67 | 2 | 01:00:00 | 70 | 22 | 84 | 29 | 78 |  | 93
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 204 | 68 | 3 | 04:00:00 | 70 | 23 | 86 | 30 | 80 | 5 | 92
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 207 | 69 | 3 | 03:30:00 | 71 | 24 | 88 | 31 | 82 |  | 91
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 210 | 70 | 3 | 03:00:00 | 73 | 25 | 90 | 32 | 84 | 6 | 90
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 213 | 71 | 3 | 02:30:00 | 76 | 26 | 92 | 33 | 86 |  | 89
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 216 | 72 | 3 | 02:00:00 | 79 | 27 | 94 | 34 | 88 | 7 | 88
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 219 | 73 | 3 | 01:30:00 | 82 | 28 | 96 | 35 | 90 |  | 87
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 222 | 74 | 3 | 01:00:00 | 85 | 29 | 98 | 36 | 92 | 8 | 86
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 225 | 75 | 4 | 04:00:00 | 70 | 30 | 100 | 37 | 94 |  | 85
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 228 | 76 | 4 | 03:30:00 | 86 |  |  | 38 | 96 | BASE | 84
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 231 | 77 | 4 | 03:00:00 | 88 |  |  | 39 | 98 |  | 83
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 234 | 78 | 4 | 02:30:00 | 91 |  |  | 40 | 100 |  | 82
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 237 | 79 | 4 | 02:00:00 | 94 |  |  |  |  |  | 81
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 240 | 80 | 4 | 01:30:00 | 97 |  |  |  |  |  | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 243 | 81 | 4 | 01:00:00 | 100 |  |  |  |  |  | 79
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 246 | 82 |  |  |  |  |  |  |  |  | 78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 249 | 83 |  |  |  |  |  |  |  |  | 77
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 252 | 84 |  |  |  |  |  |  |  |  | 76
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 255 | 85 |  |  |  |  |  |  |  |  | 75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 258 | 86 |  |  |  |  |  |  |  |  | 74
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 261 | 87 |  |  |  |  |  |  |  |  | 73
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 264 | 88 |  |  |  |  |  |  |  |  | 72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 267 | 89 |  |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 270 | 90 |  |  |  |  |  |  |  |  | 70
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 273 | 91
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 276 | 92
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 279 | 93
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 282 | 94
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 285 | 95
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 288 | 96
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 291 | 97
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 294 | 98
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 297 | 99
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300 | 100
AVERAGE SCORES