19th MONO 3GDS HA Tracking

	B	C	D	F	G	H	J	K	L	N	O	P	Q
1
2	HA Tracker
3	HA Tracker
4
5	ALPHA	HA-Certified	1	BRAVO	HA-Certified	0	CHARLIE	HA-Certified	0	SUPPORT	HA-Certified	0
6	ALPHA	Non-HA	93	BRAVO	Non-HA	92	CHARLIE	Non-HA	85	SUPPORT	Non-HA	104
7	PLT 1	HA-Certified	1	PLT 4	HA-Certified	0	PLT 7	HA-Certified	0	PIONEER	HA-Certified	0
8		Non-HA	30		Non-HA	30		Non-HA	29		Non-HA	17
9	PLT 2	HA-Certified	0	PLT 5	HA-Certified	0	PLT 8	HA-Certified	0	RECON	HA-Certified	0
10		Non-HA	30		Non-HA	31		Non-HA	28		Non-HA	24
11	PLT 3	HA-Certified	0	PLT 6	HA-Certified	0	PLT 9	HA-Certified	0	MORTAR	HA-Certified	0
12		Non-HA	33		Non-HA	31		Non-HA	28		Non-HA	25
13										SIGNAL	HA-Certified	0
14											Non-HA	38
15
16	1. failure of sub ha need to highlight the X in yellow & change range of initial and sub HA to after fail
17	2. fill up green columns only
18	3. if red = fail initial
19	4. if yellow = fail subsequent
20	5. add new weeks only after friday
21	6. weeks just added would be seen as "fail sub" because not completely filled in thus if they are failed sub closer to the end of the week, can tell if they are about to pass or fail to notify them
22
23													2
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48