Spreadsheet: 93410d1292988464-excel-2007-track-annual-training-annualtraining
Sheet: S4

 |  |  |  |  | RIFLE RANGE |  | PHYSICAL FITNESS TEST |  | COMBAT FITNESS TEST |  | GAS CHAMBER | [NAME] | MCMAP TRAINING |  | SWIM QUAL
SECTION | RANK | LNAME | FNAME | MI | DATE | SCORE | DATE | SCORE | DATE | SCORE | DATE | DATE | DATE | BELT | DATE | CLASS
MT | 2ndlt | JONES | [NAME] | T | 2010-06-04 00:00:00 | 301 | 2010-02-26 00:00:00 | 260 | 2009-10-30 00:00:00 | 266 | 2010-01-29 00:00:00 |  | 2009-05-20 00:00:00 | TAN
MT | cpl | SMITH | TOM | T | 2010-01-22 00:00:00 | 297 | 2010-02-26 00:00:00 | 205 | 2010-10-22 00:00:00 | 266 | 2010-02-11 00:00:00 |  | 2009-04-02 00:00:00 | TAN
MT | cpl | EVANS | [NAME] | T | 2010-08-27 00:00:00 | 266 | 2010-02-26 00:00:00 | 284 | 2010-11-10 00:00:00 | 291 | 2010-10-29 00:00:00 |  | 2009-06-10 00:00:00 | black
MT | sgt | RODRIGUEZ | TOM | T | 1999-11-01 00:00:00 | 343 | 2010-04-29 00:00:00 | 255 | 2010-10-06 00:00:00 | 288 | 2009-12-17 00:00:00 |  | 2002-09-17 00:00:00 | TAN
MT | maj | STEVENS | [NAME] | T | 1999-11-02 00:00:00 | 289 | 2010-04-30 00:00:00 | 255 | 2010-10-07 00:00:00 | 288 | 2009-12-18 00:00:00 |  | 2010-11-17 00:00:00 | TAN
MT | [NAME] | GOMEZ | TOM | T | 2010-08-27 00:00:00 | 289 | 2010-06-25 00:00:00 | 184 | 2009-09-28 00:00:00 | W | 2010-03-19 00:00:00 |  | 2009-06-19 00:00:00 | GRAY
MT | ssgt | WERTH | [NAME] | T | 2010-01-22 00:00:00 | 313 | 2010-02-26 00:00:00 | 241 | 2010-11-10 00:00:00 | 249 | 2010-02-11 00:00:00 |  | 2009-09-16 00:00:00 | BROWN
MT | [NAME] | HATMAKER | TOM | T | 2010-08-27 00:00:00 | 272 | 2010-04-07 00:00:00 | 216 | 2010-10-06 00:00:00 | 253 | 2010-10-29 00:00:00 |  | 2008-03-19 00:00:00 | GRAY
MT | [NAME] | ORAGAMI | [NAME] | T | 2010-08-27 00:00:00 | 322 | 2010-02-26 00:00:00 | 265 | 2010-10-06 00:00:00 | 298 | 2010-01-29 00:00:00 |  | 2009-04-15 00:00:00 | TAN
MT | gysgt | KTM | TOM | T | 2010-08-28 00:00:00 | 322 |  |  | 2010-10-07 00:00:00 |  | 2010-01-30 00:00:00 |  | 2009-04-16 00:00:00 | TAN
MT | [NAME] | SUZUKI | [NAME] | T | 2009-08-28 00:00:00 | 315 | 2009-06-29 00:00:00 | 0 | 2010-10-22 00:00:00 | 279 | 2010-10-29 00:00:00 |  | 2008-12-23 00:00:00 | GREEN
MT | [NAME] | HONDA | TOM | T | 2000-11-01 00:00:00 | S30 | 2010-06-29 00:00:00 | 164 | 2009-12-16 00:00:00 | 232 | 2009-11-02 00:00:00 |  | 2003-12-04 00:00:00 | GREEN
MT | [NAME] | YAMAHA | [NAME] | T | 2010-09-03 00:00:00 | 312 | 2010-02-26 00:00:00 | 230 | 2010-10-22 00:00:00 | 288 | 2010-03-19 00:00:00 |  | 2004-07-30 00:00:00 | TAN
 |  |  | Completed
 |  |  | Needed
Officers |  |  |  |  |  |  | [NAME] DOWN |  |  |  |  |  |  | TOTAL
SNCO |  |  |  |  |  |  | RANK | TAN | GRAY | GREEN | BROWN | BLACK | N/A | MARINES
NCO'S |  |  |  |  |  |  | OFFICERS
[NAME] AND BELOW |  |  |  |  |  |  | SNCO's
TOTAL |  |  |  |  |  |  | NCO's
 |  |  |  |  |  |  | NON-NCO's
SECTION | RANK | LNAME | FNAME | MI | Test | DATE | SCORE |  | RANK | (All)
MT | 2ndlt | JONES | [NAME] | T | Rifle Range | 2010-06-04 00:00:00 | 301
MT | cpl | SMITH | TOM | T | Rifle Range | 2010-01-22 00:00:00 | 297 |  | Count of SCORE | Column Labels
MT | cpl | EVANS | [NAME] | T | Rifle Range | 2010-08-27 00:00:00 | 266 |  | Row Labels | Rifle Range | Grand Total
MT | sgt | RODRIGUEZ | TOM | T | Rifle Range | 1999-11-01 00:00:00 | 343 |  | EVANS | 1 | 1
MT | maj | STEVENS | [NAME] | T | Rifle Range | 1999-11-02 00:00:00 | 289 |  | 2010-08-27 00:00:00 | 1 | 1
MT | [NAME] | GOMEZ | TOM | T | Rifle Range | 2010-08-27 00:00:00 | 289 |  | GOMEZ | 1 | 1
MT | ssgt | WERTH | [NAME] | T | Rifle Range | 2010-01-22 00:00:00 | 313 |  | 2010-08-27 00:00:00 | 1 | 1
MT | [NAME] | HATMAKER | TOM | T | Rifle Range | 2010-08-27 00:00:00 | 272 |  | HATMAKER | 1 | 1
MT | [NAME] | ORAGAMI | [NAME] | T | Rifle Range | 2010-08-27 00:00:00 | 322 |  | 2010-08-27 00:00:00 | 1 | 1
MT | gysgt | KTM | TOM | T | Rifle Range | 2010-08-28 00:00:00 | 322 |  | HONDA | 1 | 1
MT | [NAME] | SUZUKI | [NAME] | T | Rifle Range | 2009-08-28 00:00:00 | 315 |  | 2000-11-01 00:00:00 | 1 | 1
MT | [NAME] | HONDA | TOM | T | Rifle Range | 2000-11-01 00:00:00 | S30 |  | JONES | 1 | 1 |  |  |  |  | `
MT | [NAME] | YAMAHA | [NAME] | T | Rifle Range | 2010-09-03 00:00:00 | 312 |  | 2010-06-04 00:00:00 | 1 | 1
MT | 2ndlt | JONES | [NAME] | T | Phisical Fitness | 2010-02-26 00:00:00 | 260 |  | KTM | 1 | 1
MT | cpl | SMITH | TOM | T | Phisical Fitness | 2010-02-26 00:00:00 | 205 |  | 2010-08-28 00:00:00 | 1 | 1
MT | cpl | EVANS | [NAME] | T | Phisical Fitness | 2010-02-26 00:00:00 | 284 |  | ORAGAMI | 1 | 1
MT | sgt | RODRIGUEZ | TOM | T | Phisical Fitness | 2010-04-29 00:00:00 | 255 |  | 2010-08-27 00:00:00 | 1 | 1
MT | maj | STEVENS | [NAME] | T | Phisical Fitness | 2010-04-30 00:00:00 | 255 |  | RODRIGUEZ | 1 | 1
MT | [NAME] | GOMEZ | TOM | T | Phisical Fitness | 2010-06-25 00:00:00 | 184 |  | 1999-11-01 00:00:00 | 1 | 1
MT | ssgt | WERTH | [NAME] | T | Phisical Fitness | 2010-02-26 00:00:00 | 241 |  | SMITH | 1 | 1
MT | [NAME] | HATMAKER | TOM | T | Phisical Fitness | 2010-04-07 00:00:00 | 216 |  | 2010-01-22 00:00:00 | 1 | 1
MT | [NAME] | ORAGAMI | [NAME] | T | Phisical Fitness | 2010-02-26 00:00:00 | 265 |  | STEVENS | 1 | 1
MT | gysgt | KTM | TOM | T | Phisical Fitness |  |  |  | 1999-11-02 00:00:00 | 1 | 1
MT | [NAME] | SUZUKI | [NAME] | T | Phisical Fitness | 2009-06-29 00:00:00 | 0 |  | SUZUKI | 1 | 1
MT | [NAME] | HONDA | TOM | T | Phisical Fitness | 2010-06-29 00:00:00 | 164 |  | 2009-08-28 00:00:00 | 1 | 1
MT | [NAME] | YAMAHA | [NAME] | T | Phisical Fitness | 2010-02-26 00:00:00 | 230 |  | WERTH | 1 | 1
MT | 2ndlt | JONES | [NAME] | T | Combat Fitness | 2009-10-30 00:00:00 | 266 |  | 2010-01-22 00:00:00 | 1 | 1
MT | cpl | SMITH | TOM | T | Combat Fitness | 2010-10-22 00:00:00 | 266 |  | YAMAHA | 1 | 1
MT | cpl | EVANS | [NAME] | T | Combat Fitness | 2010-11-10 00:00:00 | 291 |  | 2010-09-03 00:00:00 | 1 | 1
MT | sgt | RODRIGUEZ | TOM | T | Combat Fitness | 2010-10-06 00:00:00 | 288 |  | Grand Total | 13 | 13
MT | maj | STEVENS | [NAME] | T | Combat Fitness | 2010-10-07 00:00:00 | 288
MT | [NAME] | GOMEZ | TOM | T | Combat Fitness | 2009-09-28 00:00:00 | W
MT | ssgt | WERTH | [NAME] | T | Combat Fitness | 2010-11-10 00:00:00 | 249
MT | [NAME] | HATMAKER | TOM | T | Combat Fitness | 2010-10-06 00:00:00 | 253
MT | [NAME] | ORAGAMI | [NAME] | T | Combat Fitness | 2010-10-06 00:00:00 | 298
MT | gysgt | KTM | TOM | T | Combat Fitness | 2010-10-07 00:00:00
MT | [NAME] | SUZUKI | [NAME] | T | Combat Fitness | 2010-10-22 00:00:00 | 279
MT | [NAME] | HONDA | TOM | T | Combat Fitness | 2009-12-16 00:00:00 | 232
MT | [NAME] | YAMAHA | [NAME] | T | Combat Fitness | 2010-10-22 00:00:00 | 288
MT | 2ndlt | JONES | [NAME] | T | Gas Chamber | 2010-01-29 00:00:00
MT | cpl | SMITH | TOM | T | Gas Chamber | 2010-02-11 00:00:00
MT | cpl | EVANS | [NAME] | T | Gas Chamber | 2010-10-29 00:00:00
MT | sgt | RODRIGUEZ | TOM | T | Gas Chamber | 2009-12-17 00:00:00
MT | maj | STEVENS | [NAME] | T | Gas Chamber | 2009-12-18 00:00:00
MT | [NAME] | GOMEZ | TOM | T | Gas Chamber | 2010-03-19 00:00:00
MT | ssgt | WERTH | [NAME] | T | Gas Chamber | 2010-02-11 00:00:00
MT | [NAME] | HATMAKER | TOM | T | Gas Chamber | 2010-10-29 00:00:00
MT | [NAME] | ORAGAMI | [NAME] | T | Gas Chamber | 2010-01-29 00:00:00
MT | gysgt | KTM | TOM | T | Gas Chamber | 2010-01-30 00:00:00
MT | [NAME] | SUZUKI | [NAME] | T | Gas Chamber | 2010-10-29 00:00:00
MT | [NAME] | HONDA | TOM | T | Gas Chamber | 2009-11-02 00:00:00
MT | [NAME] | YAMAHA | [NAME] | T | Gas Chamber | 2010-03-19 00:00:00