Spreadsheet: 482588d1475124088-extracting-the-statistics-from-spreadsheet-nightmare-extracting-the-statistics-from-spreadsheet-nightmare
Sheet: Training Register

Seniority | Initial | Surname | Trade | Team | 2016-04-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Triangulation of evidence |  | 2016-04-01 00:00:00
5 | B | asdf | Support Staff | Red |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
3 | C | asdf | GP | Green |  |  |  |  |  |  |  |  |  | A
3 | F | dfa | GP | Green
3 | G | fdasefrt | PHARM | Blue
3 | H | vads | Support Staff | Blue
3 | T | vads | Support Staff | Blue
3 | D | asdf | Support Staff | Blue
3 | F | vads | Support Staff | Blue
3 | G | bfaer | Support Staff | Blue |  |  | A
3 | H | bvfa | RN | Yellow
3 | T | czab | Support Staff | Yellow
3 | Y | bfaa | ENP | Yellow
3 | N | bfad | EMT | Yellow |  |  |  |  |  |  | A
3 | R | [NAME] | GP | Yellow |  |  | A |  | A | A |  |  |  |  |  |  |  |  |  | A
3 | A | afg | GP | Yellow
3 | A | bfa | Support Staff | Red
3 | S | afb | GP | Red |  |  |  |  | a |  | A |  |  | A |  |  | A
3 | D | afba | GP | Red |  |  | A
10 | A | avfdag | EMT | Green |  |  | A |  |  |  |  |  |  |  |  |  |  | A
10 | V | [NAME] | EMT | Green |  |  |  |  |  |  |  |  |  |  |  | A | A |  |  | A
10 | N | afgbgas | EMT | Green |  |  |  |  | A |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  | A
10 | B | afbdaba | EMT | Green
10 | C | afbaae | HCA | Green
10 | F | fbaafdhg | EMT | Green |  |  |  |  |  |  |  |  | A |  |  |  | A | A |  | A |  |  |  |  | A
10 | G | bfadab | EMT | Green
10 | H | bfaaerg | EMT | Blue
10 | T | bfdaadfg | EMT | Blue
10 | D | bfdaadfg | EMT | Blue |  |  | A | A |  |  | A |  |  | A |  |  |  |  |  | A
10 | F | btgrnwy, | EMT | Blue |  |  | A
10 | G | hjrhgrs | EMT | Yellow |  |  |  |  |  | A
10 | H | asfdhjmkuyil | RN | Yellow
10 | T | gdmha | EMT | Yellow |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
10 | Y | fdnmh | EMT | Yellow | A |  |  | A | A |  |  | A |  |  |  |  |  | A |  | A
10 | N | ,jhfstrf | EMT | Yellow |  |  |  | A |  | A |  |  |  |  |  |  |  |  |  | A
10 | R | gfbas | EMT | Yellow
10 | A | afdgbbn | RN | Yellow |  |  |  |  |  |  |  |  |  |  |  |  | A | A |  | A
10 | A | afgnh | HCA | Yellow |  |  |  |  |  |  |  | A |  |  |  | A | A
10 | S | gnfsa | EMT | Yellow |  |  |  |  |  |  |  |  |  |  |  |  |  | A
10 | D | [NAME] | EMT | Yellow |  |  |  |  |  |  |  |  |  |  |  |  | A | A
10 | A | bgsa | EMT | Red |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
10 | V | fadm | EMT | Red
10 | N | hdaabvf | EMT | Red
10 | B | fdabk | PHARM TECH | Red
10 | C | bgsaa | EMT | Red |  |  | A | A | A |  | A | A
10 | F | afnmhts | EMT | Red |  |  | A
11 | G | bfdaajh | EMT | Green | a |  |  | A |  |  |  | A |  |  |  |  | A
11 | H | jttrsjjk | EMT | Green
11 | T | rashjha | EMT | Green |  |  | a |  |  |  |  | A
11 | D | ahtmjyt | EMT | Green |  |  |  |  | A |  |  | A |  |  |  | A |  |  |  |  |  |  |  |  | A
11 | F | srthahte | EMT | Green |  |  |  |  |  |  | A |  |  |  |  |  |  | A |  | A
11 | G | ahtjmytuk | EMT | Green
11 | H | nshrtae | EMT | Green |  |  |  |  |  |  |  | A
11 | T | ahbngn | EMT | Green |  |  |  |  |  |  |  | A |  |  |  | A
11 | Y | asdf | EMT | Green |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
11 | N | asdf | EMT | Green
11 | R | dfa | EMT | Green |  |  |  |  |  |  | A | A | A |  |  |  |  |  |  | A
11 | A | fdasefrt | EMT | Green |  |  |  |  |  |  |  |  |  |  |  | A |  |  |  | A
11 | A | vads | EMT | Blue
11 | S | vads | EMT | Blue
11 | D | asdf | HCA | Blue |  |  | A
11 | A | vads | EMT | Blue |  |  |  |  | A
11 | V | bfaer | EMT | Blue
11 | N | bvfa | EMT | Yellow | A |  |  | A | A | A |  |  | A
11 | B | czab | HCA | Yellow | A |  | A | A | A | A |  | A | A |  |  |  |  |  |  | A |  |  |  |  | A | A
11 | C | bfaa | EMT | Yellow |  |  |  |  |  | A |  | A | A |  |  | A |  |  |  |  |  |  |  |  | A
11 | F | bfad | EMT | Yellow |  |  |  |  |  |  |  |  | A |  |  |  | A | A |  | A |  |  |  |  | A
11 | G | [NAME] | EMT | Red |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
11 | H | afg | Dental Nurse | Red
11 | T | bfa | EMT | Red |  |  |  |  |  |  |  | A | A |  |  | A |  | A
11 | D | afb | EMT | Red |  | A | A
11 | F | afba | EMT | Red
11 | G | avfdag | EMT | Red |  |  |  |  |  |  |  | A
11 | H | [NAME] | EMT | Red |  |  | A
11 | T | afgbgas | EMT | Red |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
11 | Y | afbdaba | EMT | Red |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
4 | N | afbaae | Support Staff | Yellow
4 | R | fbaafdhg | Support Staff | Red
1 | A | bfadab | GP | Blue |  |  | a
1 | A | bfaaerg | Support Staff | Blue
2 | S | bfdaadfg | EMT | Green
2 | D | bfdaadfg | Support Staff | Blue
2 | A | btgrnwy, | Support Staff | Blue
2 | V | hjrhgrs | Support Staff | Blue
2 | N | asfdhjmkuyil | Support Staff | Blue
2 | B | gdmha | Support Staff | Yellow
2 | C | fdnmh | Dentist | Red
2 | F | ,jhfstrf | Dentist | Red
2 | G | gfbas | Support Staff | Red
2 | H | afdgbbn | PHYSIO | Red |  |  |  |  | A
2 | T | afgnh | ENP | Red
12 | D | gnfsa | EMT | Green | A |  |  | A |  |  |  |  |  |  |  | A | A |  |  | A |  |  |  |  | A | A
12 | F | [NAME] | EMT | Green |  |  |  |  |  |  |  |  | A |  |  |  | A |  |  |  |  |  |  |  | A
12 | G | bgsa | EMT | Green | A |  | A
12 | H | fadm | EMT | Green
12 | T | hdaabvf | EMT | Green |  |  | A |  |  |  |  | A
12 | Y | fdabk | EMT | Green |  |  |  |  |  |  |  |  | A
12 | N | bgsaa | EMT | Green
12 | R | afnmhts | EMT | Green |  |  |  |  |  |  |  |  | A |  |  | A | A |  |  |  |  |  |  |  | A
12 | A | bfdaajh | EMT | Green
12 | A | jttrsjjk | EMT | Green |  |  |  |  | A | A |  |  |  |  |  |  |  | A |  |  |  |  |  |  | A
12 | S | rashjha | EMT | Green |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A |  |  |  |  | A
12 | D | ahtmjyt | EMT | Green
12 | A | srthahte | EMT | Green |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
12 | V | ahtjmytuk | EMT | Green
12 | N | nshrtae | EMT | Green |  |  |  | A | A
12 | G | ahbngn | EMT | Green
12 | H | asdf | EMT | Green |  |  |  |  |  |  |  | A | A
12 | T | asdf | EMT | Green |  |  |  | A | A |  |  | A |  |  |  |  | A | A |  |  |  |  |  |  | A
12 | D | dfa | EMT | Green |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  | A
12 | F | fdasefrt | EMT | Green |  |  |  |  |  |  |  |  | A |  |  |  |  | A
12 | G | vads | EMT | Blue |  |  |  |  |  |  |  |  |  |  |  |  |  | A
12 | H | vads | EMT | Blue |  |  |  |  | A |  |  | A
12 | T | asdf | EMT | Blue |  |  |  |  |  |  | A
12 | Y | vads | EMT | Blue |  |  |  |  |  |  |  |  |  |  |  |  |  | A
12 | N | bfaer | EMT | Yellow |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
12 | R | bvfa | EMT | Yellow |  |  |  |  |  |  | A
12 | A | czab | EMT | Yellow |  |  |  |  |  | A |  | A | A
12 | A | bfaa | EMT | Yellow
12 | S | bfad | EMT | Yellow |  |  | A | A |  | A |  | A |  |  |  |  |  |  |  |  |  |  |  |  | A | A
12 | D | [NAME] | EMT | Yellow | A |  | A | A |  | A |  |  | A
12 | A | afg | EMT | Yellow |  |  | A |  | A |  |  | A
12 | V | bfa | EMT | Yellow
12 | N | afb | EMT | Yellow |  |  | A | A |  |  |  |  |  | A |  |  |  | A |  | A
12 | B | afba | EMT | Yellow |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  | A
12 | C | avfdag | EMT | Yellow
12 | F | [NAME] | EMT | Yellow
12 | G | afgbgas | EMT | Yellow
12 | H | afbdaba | EMT | Yellow | A |  | A | A
12 | T | afbaae | EMT | Yellow
12 | D | fbaafdhg | EMT | Yellow
12 | F | bfadab | EMT | Yellow | A |  | A | A | A | A |  | A | A |  |  | A
12 | G | bfaaerg | EMT | Red |  |  | A | A | A |  | A
12 | H | bfdaadfg | EMT | Red
12 | T | bfdaadfg | EMT | Red |  |  | A |  |  |  | A
12 | Y | btgrnwy, | EMT | Red |  |  | A |  |  |  |  |  |  |  |  | A |  | A |  |  |  |  |  |  | A
12 | N | hjrhgrs | EMT | Red |  |  | A |  |  |  |  | A | A |  |  | A
12 | R | asfdhjmkuyil | EMT | Red | A |  | A |  |  | A | A | A |  |  |  | A | A | A
12 | A | gdmha | EMT | Red |  |  |  |  | A
12 | A | fdnmh | EMT | Red |  |  | A
12 | S | ,jhfstrf | EMT | Red |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
12 | D | gfbas | EMT | Red
12 | A | afdgbbn | EMT | Red |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
12 | V | afgnh | EMT | Red |  |  | A
12 | N | gnfsa | EMT | Red |  |  |  |  |  |  | A
12 | B | [NAME] | EMT | Red |  | A | A | A | A |  | A
12 | C | bgsa | EMT | Red |  |  |  |  |  |  |  | A | A |  |  | A
12 | F | fadm | EMT | Red |  | A |  | A | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
12 | G | hdaabvf | EMT | Red |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
12 | H | fdabk | EMT | Red |  |  |  |  | A |  |  | A | A |  |  |  |  | A |  |  |  |  |  |  | A
12 | T | bgsaa | EMT | Red |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
12 | D | afnmhts | EMT | Red
12 | F | bfdaajh | EMT | Red
12 | G | jttrsjjk | EMT | Red |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
12 | H | rashjha | EMT | Red |  |  | A
9 | T | ahtmjyt | EMT | Green |  |  | A | A |  |  |  |  |  | A |  | A |  | A |  | A
9 | Y | srthahte | EMT | Green |  |  |  |  |  |  |  |  |  |  |  | A |  |  |  | A
9 | N | ahtjmytuk | RN | Green |  |  |  |  | A |  |  |  |  |  |  | A
9 | R | nshrtae | EMT | Green
9 | A | ahbngn | EMT | Green |  |  |  |  |  |  |  |  |  |  |  | A
9 | A | asdf | EMT | Green |  |  |  |  |  |  |  | A |  |  |  |  |  | A
9 | S | asdf | RN | Green |  |  |  |  |  |  |  |  |  |  |  | A |  | A |  | A
9 | D | dfa | EMT | Green
9 | A | fdasefrt | EMT | Blue
9 | V | vads | EMT | Blue
9 | N | vads | HCA | Yellow |  |  | A | A | A | A | A | A | A |  |  | A |  | A |  | A |  |  |  |  |  | A
9 | G | asdf | EMT | Yellow |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a
9 | H | vads | EMT | Yellow
9 | T | bfaer | EMT | Yellow |  |  |  |  |  |  |  | A
9 | D | bvfa | RN | Yellow
9 | F | czab | EMT | Yellow
9 | G | bfaa | EMT | Yellow | A |  |  |  |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  | A
9 | H | bfad | EMT | Yellow |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  | A
9 | T | [NAME] | EMT | Yellow
9 | Y | afg | EMT | Yellow
9 | N | bfa | EMT | Red |  |  |  |  |  |  |  |  |  |  |  |  |  | A |  | A
9 | R | afb | HCA | Red |  |  |  |  |  |  |  |  |  |  |  |  |  | A
9 | A | afba | RN | Red |  |  |  |  |  |  | A
9 | A | avfdag | EMT | Red
8 | S | [NAME] | EMT | Green
8 | D | afgbgas | EMT | Blue
8 | A | afbdaba | EMT | Blue
8 | V | afbaae | EMT | Blue
8 | N | fbaafdhg | EMT | Blue
8 | B | bfadab | EMT | Yellow |  |  |  |  |  |  |  | A
8 | C | bfaaerg | EMT | Yellow
8 | F | bfdaadfg | EMT | Red
8 | G | bfdaadfg | EMT | Red |  |  | A |  | A
8 | H | btgrnwy, | EMT | Red
8 | T | hjrhgrs | EMT | Red |  |  | A |  |  |  |  |  |  |  |  |  | A
6 | D | asfdhjmkuyil | EMT | Blue
7 | F | gdmha | EMT | Green |  |  | A |  | A
7 | G | fdnmh | EMT | Blue
7 | H | ,jhfstrf | EMT | Blue
7 | T | gfbas | EMT | Blue
7 | Y | afdgbbn | EMT | Yellow |  |  | a |  |  |  |  | A
7 | N | afgnh | EMT | Red
 | R | gnfsa
 | A | [NAME]