Spreadsheet: 60921d1261501304-excel-2007-vlookup-range-grades
Sheet: WO

RNK | SSN | NAME | LAW | APFT | SCORE | LAND NAV POINTS | LAND NAV TIME | SCORE | M9 | SCORE | M16 | SCORE | LEADERSHIP | OVERALL LEADERSHIP | TACTICS |  | APFT |  | LAND NAV |  |  | M9 |  | M16 |  | LEADERSHIP
 |  |  |  | 257 |  |  |  |  |  |  |  |  |  |  | 70 |  | RAW SCORE | SCORE | PTS | TIME | SCORE | HITS | SCORE | HITS | SCORE | RANKING | SCORE
 |  |  |  | 266 |  |  |  |  |  |  |  |  |  |  | 88 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 1 | 80
 |  |  |  | 243 |  |  |  |  |  |  |  |  |  |  | 82 |  | 210 | 1 | 3 | 03:00:00 | 1 | 16 | 1 | 23 | 1 |  | 79
 |  |  |  | 272 |  |  |  |  |  |  |  |  |  |  | 92 |  | 211 | 2 | 3 | 02:30:00 | 2 | 17 | 1 | 24 | 2 | 2 | 78
 |  |  |  | 213 |  |  |  |  |  |  |  |  |  |  | 90 |  | 214 | 3 | 3 | 02:00:00 | 3 | 18 | 2 | 25 | 3 | 3 | 77
 |  |  |  | 262 |  |  |  |  |  |  |  |  |  |  | 70 |  | 216 | 4 | 3 | 01:30:00 | 4 | 19 | 3 | 26 | 3 | 4 | 76
 |  |  |  | 238 |  |  |  |  |  |  |  |  |  |  | 70 |  | 219 | 5 | 3 | 01:00:00 | 5 | 20 | 3 | 27 | 4 | 5 | 75
 |  |  |  | 293 |  |  |  |  |  |  |  |  |  |  | 92 |  | 222 | 6 | 4 | 03:00:00 | 6 | 21 | 4 | 28 | 5 | 6 | 74
 |  |  |  | 239 |  |  |  |  |  |  |  |  |  |  | 98 |  | 224 | 7 | 4 | 02:30:00 | 7 | 22 | 5 | 29 | 6 | 7 | 73
 |  |  |  | 262 |  |  |  |  |  |  |  |  |  |  | 94 |  | 227 | 8 | 4 | 02:00:00 | 8 | 23 | 5 | 30 | 7 |  | 72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90 |  | 230 | 9 | 4 | 01:30:00 | 9 | 24 | 6 | 31 | 8 | 8 | 71
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 232 | 10 | 4 | 01:00:00 | 10 | 25 | 7 | 32 | 8 |  | 70
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 235 | 11 |  |  |  | 26 | 7 | 33 | 9 | BASE | 69
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 238 | 12 |  |  |  | 27 | 8 | 34 | 10 | STUDENTS | 68
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 240 | 13 |  |  |  | 28 | 9 | 35 | 11 | THAT | 67
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 243 | 14 |  |  |  | 29 | 9 | 36 | 12 | NEED | 66
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 246 | 15 |  |  |  | 30 | 10 | 37 | 13 | IMPROVEMENT | 65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 248 | 16 |  |  |  |  |  | 38 | 13 |  | 64
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 251 | 17 |  |  |  |  |  | 39 | 14 |  | 63
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 254 | 18 |  |  |  |  |  | 40 | 15 |  | 62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 256 | 19 |  |  |  |  |  |  |  |  | 61
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 259 | 20 |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 262 | 21 | 3 | 03:00:00 |  |  |  |  |  |  | 59
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 264 | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 267 | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 270 | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 272 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 275 | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 278 | 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 280 | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 283 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 286 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 288 | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 291 | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 294 | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 296 | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 299 | 35