Spreadsheet: 743738d1628691185-help-pls-hard-excel-countif-for-multiple-criteria-rollbook-example
Sheet: ROLLBOOK

 |  |  |  |  |  | AUGUST
NUMBER | RANK | NAME | TE | HOTELS/SECTION | TYPE | 2021-08-10 00:00:00 | 2021-08-11 00:00:00 | 2021-08-12 00:00:00 | 2021-08-13 00:00:00 | 2021-08-14 00:00:00 | 2021-08-15 00:00:00 | 2021-08-16 00:00:00 | 2021-08-17 00:00:00 | 2021-08-18 00:00:00 | 2021-08-19 00:00:00 | 2021-08-20 00:00:00 | 2021-08-21 00:00:00 | 2021-08-22 00:00:00 | 2021-08-23 00:00:00 | 2021-08-24 00:00:00 | 2021-08-25 00:00:00 | 2021-08-26 00:00:00 | 2021-08-27 00:00:00 | 2021-08-28 00:00:00 | 2021-08-29 00:00:00 | 2021-08-30 00:00:00 | 2021-08-31 00:00:00 | MARKINGS
801 | PTE(P) |  | TE 2 |  | REGULAR | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM-LOND-LI
 | LAC |  | TE 2 |  | REGULAR | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM-LOND-LO
 | SMN |  | TE 2 |  | REGULAR | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM-LOND-LI
 | PTE |  | TE 2 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM-LOND-LO
 | AC |  | TE 2 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R-LOND-LI
 | PTE TRN |  | TE 2 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R-LOND-LO
 | PTE REC |  | TE 2 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM-MANCH-LI
 | OCDT |  | TE 2 |  | RESERVE | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM-MANCH-LO
 | ADM |  | TE 2 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM-MANCH-LI
 | GEN |  | TE 2 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM-MANCH-LO
 | ACM |  | TE 2 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R-MANCH-LI
 | VADM |  | TE 2 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R-MANCH-LO
 | LTGEN |  | TE 2 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM-SCOT-LI
 | AM |  | TE 2 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM-SCOT-LO
 | RADM |  | TE 2 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM-SCOT-LI
 | MAJGEN |  | TE 2 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM-SCOT-LO
 | AVM |  | TE 2 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R-SCOT-LI
 | CDRE |  | TE 2 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R-SCOT-LO
 | BRIG |  | TE 2 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM-LEEDS-LI
 | AIRCDRE |  | TE 2 |  | RESERVE | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM-LEEDS-LO
 | CAPT(RAN) |  | TE 2 |  | REGULAR | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R-LEEDS-LI
 | COL |  | TE 2 |  | REGULAR | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R-LEEDS-LO
 | GPCAPT |  | TE 2 |  | RESERVE | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI
 | CMDR |  | TE 2 |  | REGULAR | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI
 | LTCOL |  | TE 2 |  | REGULAR | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI
 | WGCDR |  | TE 2 |  | REGULAR | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI
 | LCDR |  | TE 2 |  | REGULAR | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI
 | MAJ |  | TE 2 |  | REGULAR | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI
 | SQNLDR |  | TE 2 |  | REGULAR | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI
 | LEUT |  | TE 2 |  | REGULAR | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI
 | CAPT |  | TE 2 |  | REGULAR | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI
 | FLTLT |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | SBLT |  | TE 2 |  | RESERVE | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | LT |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | FLGOFF |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | ASLT |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | 2LT |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | PLTOFF |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | WO-N |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | RSM-A |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | WOFF-AF |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | WO |  | TE 2 |  | RESERVE | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | WO1 |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | WOFF |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | CPO |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | WO2 |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | FSGT |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | SSGT |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | PO |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | SGT |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | SGT |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | LS |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | CPL |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | CPL |  | TE 2 |  | RESERVE | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | [NAME] |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | AB |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | PTE(P) |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | LAC |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | SMN |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | PTE |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | AC |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | PTE TRN |  | TE 2 |  | RESERVE | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | PTE REC |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | OCDT |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | ADM |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | GEN |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | ACM |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | VADM |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | LTGEN |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | AM |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | RADM |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | MAJGEN |  | TE 2 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | AVM |  | TE 2 |  | REGULAR | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO
 | CDRE |  | TE 2 |  | REGULAR | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO
 | BRIG |  | TE 2 |  | REGULAR | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO
 | AIRCDRE |  | TE 2 |  | REGULAR | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO
 | CAPT(RAN) |  | TE 2 |  | REGULAR | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO
 | COL |  | TE 2 |  | REGULAR | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO
 | GPCAPT |  | TE 2 |  | REGULAR | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO
 | CMDR |  | TE 2 |  | REGULAR | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO
 | LTCOL |  | TE 2 |  | REGULAR | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO | PM-LOND-LO
 | WGCDR |  | [NAME] |  | REGULAR | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI
 | LCDR |  | [NAME] |  | RESERVE | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI
 | MAJ |  | [NAME] |  | REGULAR | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI
 | SQNLDR |  | [NAME] |  | REGULAR | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI
 | LEUT |  | [NAME] |  | REGULAR | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI
 | CAPT |  | [NAME] |  | REGULAR | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI
 | FLTLT |  | [NAME] |  | REGULAR | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI
 | SBLT |  | [NAME] |  | REGULAR | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI
 | LT |  | [NAME] |  | REGULAR | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI
 | FLGOFF |  | [NAME] |  | REGULAR | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI
 | ASLT |  | [NAME] |  | REGULAR | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI
 | 2LT |  | [NAME] |  | REGULAR | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI
 | PLTOFF |  | [NAME] |  | REGULAR | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI
 | WO-N |  | [NAME] |  | REGULAR | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI
 | RSM-A |  | [NAME] |  | REGULAR | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI
 | WOFF-AF |  | [NAME] |  | REGULAR | AM-MANCH-LI | AM-MANCH-LI | AM-MANCH-LI | AM-MANCH-LI | AM-MANCH-LI | AM-MANCH-LI
 | WO |  | [NAME] |  | REGULAR | AM-MANCH-LI | AM-MANCH-LI | AM-MANCH-LI | AM-MANCH-LI | AM-MANCH-LI | AM-MANCH-LI
 | WO1 |  | [NAME] |  | REGULAR | AM-MANCH-LI | AM-MANCH-LI | AM-MANCH-LI | AM-MANCH-LI | AM-MANCH-LI | AM-MANCH-LI
 | WOFF |  | [NAME] |  | REGULAR | AM-MANCH-LI | AM-MANCH-LI | AM-MANCH-LI | AM-MANCH-LI | AM-MANCH-LI | AM-MANCH-LI
 | CPO |  | [NAME] |  | REGULAR | AM-MANCH-LI | AM-MANCH-LI | AM-MANCH-LI | AM-MANCH-LI | AM-MANCH-LI | AM-MANCH-LI
 | WO2 |  | [NAME] |  | REGULAR | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI
 | FSGT |  | [NAME] |  | REGULAR | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI
 | SSGT |  | [NAME] |  | REGULAR | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI | PM-LOND-LI
 | PO |  | TE 1 |  | REGULAR | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI
 | SGT |  | TE 1 |  | REGULAR | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI
 | SGT |  | TE 1 |  | REGULAR | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI | R-LOND-LI
 | LS |  | TE 1 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO
 | CPL |  | TE 1 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO
 | CPL |  | TE 1 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO
 | [NAME] |  | TE 1 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO
 | AB |  | TE 1 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO
 | PTE(P) |  | TE 1 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO
 | LAC |  | TE 1 |  | RESERVE | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO
 | SMN |  | TE 1 |  | RESERVE | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO
 | PTE |  | TE 1 |  | RESERVE | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO
 | AC |  | TE 1 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO
 | PTE TRN |  | TE 1 |  | RESERVE | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO
 | PTE REC |  | TE 1 |  | RESERVE | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO
 | OCDT |  | TE 1 |  | RESERVE | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO
 | ADM |  | TE 1 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO
 | GEN |  | TE 1 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO
 | ACM |  | TE 1 |  | REGULAR | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO
 | VADM |  | TE 1 |  | RESERVE | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO | AM-MANCH-LO
 | LTGEN |  | TE 1 |  | RESERVE | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI
 | AM |  | TE 1 |  | REGULAR | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI
 | RADM |  | TE 1 |  | REGULAR | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI
 | MAJGEN |  | TE 1 |  | REGULAR | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI
 | AVM |  | TE 1 |  | RESERVE | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI
 | CDRE |  | TE 1 |  | RESERVE | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI
 | BRIG |  | TE 1 |  | REGULAR | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI
 | AIRCDRE |  | TE 1 |  | REGULAR | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI
 | CAPT(RAN) |  | TE 1 |  | RESERVE | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI
 | COL |  | TE 1 |  | REGULAR | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI
 | GPCAPT |  | TE 1 |  | REGULAR | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI | AM-SCOT-LI
 | CMDR |  | TE 1 |  | RESERVE | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | LTCOL |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | WGCDR |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | LCDR |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | MAJ |  | TE 1 |  | RESERVE | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | SQNLDR |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | LEUT |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | CAPT |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | FLTLT |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | SBLT |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | LT |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | FLGOFF |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | ASLT |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | 2LT |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | PLTOFF |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | WO-N |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | RSM-A |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | WOFF-AF |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | WO |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | WO1 |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | WOFF |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | CPO |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | WO2 |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | FSGT |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | SSGT |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | PO |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | SGT |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | SGT |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | LS |  | TE 1 |  | REGULAR | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | CPL |  | TE 1 |  | RESERVE | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | CPL |  | TE 1 |  | RESERVE | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | [NAME] |  | TE 1 |  | RESERVE | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | AB |  | TE 1 |  | RESERVE | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | PTE(P) |  | TE 1 |  | RESERVE | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | LAC |  | TE 1 |  | RESERVE | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | SMN |  | TE 1 |  | RESERVE | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | PTE |  | TE 1 |  | RESERVE | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | AC |  | TE 1 |  | RESERVE | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | PTE TRN |  | TE 1 |  | RESERVE | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | PTE REC |  | TE 1 |  | RESERVE | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI
 | OCDT |  | TE 1 |  | RESERVE | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI | R-SCOT-LI