Spreadsheet: 743717d1628684364-help-pls-hard-excel-countif-for-multiple-criteria-rollbook-example
Sheet: ROLLBOOK

 |  |  |  |  |  | AUGUST
NUMBER | RANK | NAME | TE | HOTELS/SECTION | TYPE | 10/08/2021 | 11/08/2021 | 12/08/2021 | 13/08/2021 | 14/08/2021 | 15/08/2021 | 16/08/2021 | 17/08/2021 | 18/08/2021 | 19/08/2021 | 20/08/2021 | 21/08/2021 | 22/08/2021 | 23/08/2021 | 24/08/2021 | 25/08/2021 | 26/08/2021 | 27/08/2021 | 28/08/2021 | 29/08/2021 | 30/08/2021 | 31/08/2021 | 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