Spreadsheet: 137286d1327036945-countif-formula-is-too-long-trainingtable
Sheet: template

 | L E G E N D |  | V - Vacation |  |  |  | D - Development |  |  | T -Training |  |  |  | P - Prep or Dry-Run |  |  | M - Maintenance |  |  | X - Execution |  |  | A - Administration |  |  | O - Other
 |  | M | [NAME] | W | Th | F | M | [NAME] | W | Th | F | M | [NAME] | W | Th | F | M | [NAME] | W | Th | F | M | [NAME] | W | Th | F
 | January | 2 | 3 | 4 | 5 | 6 | 9 | 10 | 11 | 12 | 13 | 16 | 17 | 18 | 19 | 20 | 23 | 24 | 25 | 26 | 27 | 30 | 31 |  |  |  |  | Resource allocation summary
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V | D | T | P | M | X | A | O
 | [NAME] | Holiday | 101D | 102D | 101D |  | 101D | 102D | 106D | 101D |  | V | V | V | V | 200D | V | 204D |  | O | O
 |  |  | 201D | 202D | 201D |  |  |  |  |  |  |  |  |  |  |  |  | 450D
 | [NAME] |  | 140A | 140A | 140A | V | 150D | 150D | 150D | 150D |  | 450D | 450D | 450D | 450D | 101M | 450D | 450D | 450D | 450D | 450D | 150P | 150P
 |  |  | 140A | 140A | 140A |  | 150D | 150D | 150D | 150D |  | 450D | 450D | 450D | 450D | 101M | 450D | 450D | 450D | 450D | 450D | 150P | 150P
 | Lili |  | 101M | 102D | 102D | 102D | 102D | 102D | 102D | 102D | 102D | 104P | 104P | 104P | 102D | 102D | 104P | 104P | 104P | 120D | 102D | O | O
 |  |  | 101M | 102D | 102D | 102D | 102D | 102D | 102D | 102D | 102D | 104P | 104P | 104P | 102D | 102D | 104P | 104P | 104P | 120D | 102D
 | Gopal |  | V | V | V | V | O | O |  |  | 102D | 102D | 102D | 102D | 102D | 102D | 102D | 102D | 102D | 101M | 102D | 104X | 108X
 |  |  |  |  |  |  |  |  |  |  | 102D | 102D | 102D | 102D | 104P | 104P | 102D | 102D | 102D | 101M | 102D | 104X | 108X
 | Sonia |  | 204D | 204D | 204D | 204D | 101M | 101M | 101M | 101M | 101M | V | V | V | V | V |  |  | O | O
 |  |  | 204D | 204D | 204D | 204D | 101M | 101M | 101M | 101M | 101M
 | Mr. [NAME] |  | V | V | V | V | V |  | 103T |  | 103T |  | O | O |  |  | 140A | 140A | 140A |  |  | 108M | 108M
 |  |  |  |  |  |  |  |  | 101M |  | 102D |  |  |  |  |  | 140A | 140A | 140A |  |  | 108M | 108M
 | Mr. [NAME] |  |  |  |  | 103T | 103P | 103D | 103T | 103T | 103T |  | 103T | 103T | 103T |  |  | 103T | 103T | 103T | 103T
 |  |  |  |  |  | 103T | 103P | 103D | 103T | 103T | 103T |  | 103T | 103T | 103T |  |  | 103T | 103T | 103T | 103T
 | Adam |  | V | V |  |  | O | O |  |  |  | 150D | 150D | 150D | 150D | 150M | 112P | 150D | 150D | 210P |  | 198P | 196P
 |  |  |  |  |  |  |  |  |  |  |  | 150D | 150D | 150D | 150D | 150M | 112P | 150D | 150D | 210P |  | 198P | 196P
 | Eve |  | O | O |  |  |  |  | 180P | 180P | 180P | O | 300P | 300P | O |  |  | 140T | 140T | 140T | 140T | V
 |  |  |  |  |  |  |  |  | 168P | 168P | 168P |  | 300P | 300P |  |  |  | 140T | 140T | 140T | 140T
 | Nicola |  | 103D | 103D | 103D | 103D | 140A | 140A | 140A |  |  | 112P | 112P |  |  |  |  | 104X | 108X |  |  | O | O
 |  |  | 103D | 103D | 103D | 103D | 140A | 140A | 140A |  |  | 112P | 112P |  |  |  |  | 104X | 108X
 | [NAME] |  | V | 104P | 104P | 104P | 104P | 104P | V | 104P | 104P | 258D | 258D | 258D | 258D | 258D | 104P |  |  | 104P |  | 102P | 102P
 |  |  |  | 104P | 104P | 104P | 104P | 104P |  | 104P | 104P | 258D | 258D | 258D | 258D | 258D | 104P |  |  | 104P |  | 102P | 102P