Hide dupilcate range, but leaving original

[picklefactory]

Hi folks
I'm frying my brain on this current project. I have an order scheduling wb that imports data from customers portal, sorts it and highlights where our production is vs customer schedule. I've got most of it working now, with one exception that is beating me.
There are 10 part numbers where the customer has more variants than we do. For example, from the sheet, 9522627V, we only produce that part, but they ship it to 2 different customers and have a different letter on the end to differentiate. We cannot use that additional variant as it is not in our system, but just to make my life difficult, they only show total stock of BOTH variants against one of the part numbers, but they show required orders for both. I have managed to consolidate their variants into one variant for us, via formulas, but now I have duplicate rows of data in my sheet. Is it possible to find duplicates in the part number column, and then hide the duplicate row? There will only be one duplicate row for any of the pain in the rump parts. I can't simply delete the row, as that would remove the formulas and mess up the next update, but is it possible to hide any duplicate row, so it just doesn't appear on the printout? The office works from a hard copy, so it doesn't matter if it stays on the Excel sheet, as long as I can hide it for printing only. Sorry for the massive formulas in the HTML
Wadda reckon folks? Is that feasible?
Thanks

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
37	5010641278	Hoops	T630	0	150	150	764	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
38	5010641279	Hoops	T630	30	208	208	0	0	0			10							30		30
39	7420892771	Cannons	55	48	23	23	76	0	0								48				48
40	7484580457	0	0	28	885	585	0	300	0							3	15		6	15	21	18
41	1395298	Cab Bkts	55	12	161	161	100	0	0	0	12	0	0	0	0	12	0	0	0	0	12	12
42	1395298	Cab Bkts	55	12	161	161	100	0	0	0	12	0	0	0	0	12	0	0	0	0	12	12
43	1395299	Cab Bkts	55	12	177	177	0	0	0	0	12	0	0	0	0	12	0	0	0	0	12	12
44	1395299	Cab Bkts	55	12	177	177	0	0	0	0	12	0	0	0	0	12	0	0	0	0	12	12
45	1395300	Cab Bkts	55	44	53	29	148	24	0	0	9	0	0	0	12	0	12	24	24	12	36	24
46	1395300	Cab Bkts	55	44	53	29	148	24	0	0	9	0	0	0	12	0	12	24	24	12	36	24
47	1395301	Cab Bkts	55	40	51	51	134	0	0	0	12	0	0	0	0	12	0	36	12	24	36	12
48	1395301	Cab Bkts	55	40	51	51	134	0	0	0	12	0	0	0	0	12	0	36	12	24	36	12
49	51.08140-0222	MAN Bananas	400	80	457	457	244	0	0							80				80
50	9522627V	Shark Fins	Mynx		0	0	0	0	0	0	0	0	0	0	0	0	70	0	0	0	0	70
51	9522627V	Shark Fins	Mynx	70	246	70	186	176	0	0	0	0	0	0	0	0	70	0	0	0	0	70
52	9522628V	Shark Fins	Mynx		0	0	0	0	0	0	0	0	0	0	0	6	70	70	0	0	0	0
53	9522628V	Shark Fins	Mynx	70	69	69	388	0	0	0	0	0	0	0	0	6	70	70	0	0	0	0
54	Afru 634	AFRU634	M630	400	534	131	1974	403	0	0	200	200	0	200	0	200	200	200	200	200	400	200
TEST2

Cell Formulas
Range	Formula
A37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!A35="","",TEST!A35),VLOOKUP(TEST!A35,TEST!$Z$2:$AA$21,2)))
A38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!A36="","",TEST!A36),VLOOKUP(TEST!A36,TEST!$Z$2:$AA$21,2)))
A39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!A37="","",TEST!A37),VLOOKUP(TEST!A37,TEST!$Z$2:$AA$21,2)))
A40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!A38="","",TEST!A38),VLOOKUP(TEST!A38,TEST!$Z$2:$AA$21,2)))
A41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!A39="","",TEST!A39),VLOOKUP(TEST!A39,TEST!$Z$2:$AA$21,2)))
A42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!A40="","",TEST!A40),VLOOKUP(TEST!A40,TEST!$Z$2:$AA$21,2)))
A43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!A41="","",TEST!A41),VLOOKUP(TEST!A41,TEST!$Z$2:$AA$21,2)))
A44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!A42="","",TEST!A42),VLOOKUP(TEST!A42,TEST!$Z$2:$AA$21,2)))
A45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!A43="","",TEST!A43),VLOOKUP(TEST!A43,TEST!$Z$2:$AA$21,2)))
A46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!A44="","",TEST!A44),VLOOKUP(TEST!A44,TEST!$Z$2:$AA$21,2)))
A47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!A45="","",TEST!A45),VLOOKUP(TEST!A45,TEST!$Z$2:$AA$21,2)))
A48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!A46="","",TEST!A46),VLOOKUP(TEST!A46,TEST!$Z$2:$AA$21,2)))
A49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!A47="","",TEST!A47),VLOOKUP(TEST!A47,TEST!$Z$2:$AA$21,2)))
A50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!A48="","",TEST!A48),VLOOKUP(TEST!A48,TEST!$Z$2:$AA$21,2)))
A51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!A49="","",TEST!A49),VLOOKUP(TEST!A49,TEST!$Z$2:$AA$21,2)))
A52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!A50="","",TEST!A50),VLOOKUP(TEST!A50,TEST!$Z$2:$AA$21,2)))
A53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!A51="","",TEST!A51),VLOOKUP(TEST!A51,TEST!$Z$2:$AA$21,2)))
A54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!A52="","",TEST!A52),VLOOKUP(TEST!A52,TEST!$Z$2:$AA$21,2)))
B37	=IF(A37="","",VLOOKUP(A37,TEST3!$D$2:$F$51,2))
B38	=IF(A38="","",VLOOKUP(A38,TEST3!$D$2:$F$51,2))
B39	=IF(A39="","",VLOOKUP(A39,TEST3!$D$2:$F$51,2))
B40	=IF(A40="","",VLOOKUP(A40,TEST3!$D$2:$F$51,2))
B41	=IF(A41="","",VLOOKUP(A41,TEST3!$D$2:$F$51,2))
B42	=IF(A42="","",VLOOKUP(A42,TEST3!$D$2:$F$51,2))
B43	=IF(A43="","",VLOOKUP(A43,TEST3!$D$2:$F$51,2))
B44	=IF(A44="","",VLOOKUP(A44,TEST3!$D$2:$F$51,2))
B45	=IF(A45="","",VLOOKUP(A45,TEST3!$D$2:$F$51,2))
B46	=IF(A46="","",VLOOKUP(A46,TEST3!$D$2:$F$51,2))
B47	=IF(A47="","",VLOOKUP(A47,TEST3!$D$2:$F$51,2))
B48	=IF(A48="","",VLOOKUP(A48,TEST3!$D$2:$F$51,2))
B49	=IF(A49="","",VLOOKUP(A49,TEST3!$D$2:$F$51,2))
B50	=IF(A50="","",VLOOKUP(A50,TEST3!$D$2:$F$51,2))
B51	=IF(A51="","",VLOOKUP(A51,TEST3!$D$2:$F$51,2))
B52	=IF(A52="","",VLOOKUP(A52,TEST3!$D$2:$F$51,2))
B53	=IF(A53="","",VLOOKUP(A53,TEST3!$D$2:$F$51,2))
B54	=IF(A54="","",VLOOKUP(A54,TEST3!$D$2:$F$51,2))
C37	=IF(A37="","",VLOOKUP(A37,TEST3!$D$2:$F$51,3))
C38	=IF(A38="","",VLOOKUP(A38,TEST3!$D$2:$F$51,3))
C39	=IF(A39="","",VLOOKUP(A39,TEST3!$D$2:$F$51,3))
C40	=IF(A40="","",VLOOKUP(A40,TEST3!$D$2:$F$51,3))
C41	=IF(A41="","",VLOOKUP(A41,TEST3!$D$2:$F$51,3))
C42	=IF(A42="","",VLOOKUP(A42,TEST3!$D$2:$F$51,3))
C43	=IF(A43="","",VLOOKUP(A43,TEST3!$D$2:$F$51,3))
C44	=IF(A44="","",VLOOKUP(A44,TEST3!$D$2:$F$51,3))
C45	=IF(A45="","",VLOOKUP(A45,TEST3!$D$2:$F$51,3))
C46	=IF(A46="","",VLOOKUP(A46,TEST3!$D$2:$F$51,3))
C47	=IF(A47="","",VLOOKUP(A47,TEST3!$D$2:$F$51,3))
C48	=IF(A48="","",VLOOKUP(A48,TEST3!$D$2:$F$51,3))
C49	=IF(A49="","",VLOOKUP(A49,TEST3!$D$2:$F$51,3))
C50	=IF(A50="","",VLOOKUP(A50,TEST3!$D$2:$F$51,3))
C51	=IF(A51="","",VLOOKUP(A51,TEST3!$D$2:$F$51,3))
C52	=IF(A52="","",VLOOKUP(A52,TEST3!$D$2:$F$51,3))
C53	=IF(A53="","",VLOOKUP(A53,TEST3!$D$2:$F$51,3))
C54	=IF(A54="","",VLOOKUP(A54,TEST3!$D$2:$F$51,3))
D37	=IF(TEST!B35="","",TEST!B35)
D38	=IF(TEST!B36="","",TEST!B36)
D39	=IF(TEST!B37="","",TEST!B37)
D40	=IF(TEST!B38="","",TEST!B38)
D41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!A39="","",TEST!A39),VLOOKUP(A41,TEST!$AA$27:$AS$36,2)))
D42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!A40="","",TEST!A40),VLOOKUP(A42,TEST!$AA$27:$AS$36,2)))
D43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!A41="","",TEST!A41),VLOOKUP(A43,TEST!$AA$27:$AS$36,2)))
D44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!A42="","",TEST!A42),VLOOKUP(A44,TEST!$AA$27:$AS$36,2)))
D45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!A43="","",TEST!A43),VLOOKUP(A45,TEST!$AA$27:$AS$36,2)))
D46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!A44="","",TEST!A44),VLOOKUP(A46,TEST!$AA$27:$AS$36,2)))
D47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!A45="","",TEST!A45),VLOOKUP(A47,TEST!$AA$27:$AS$36,2)))
D48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!A46="","",TEST!A46),VLOOKUP(A48,TEST!$AA$27:$AS$36,2)))
D49	=IF(TEST!B47="","",TEST!B47)
D50	=IF(TEST!B48="","",TEST!B48)
D51	=IF(TEST!B49="","",TEST!B49)
D52	=IF(TEST!B50="","",TEST!B50)
D53	=IF(TEST!B51="","",TEST!B51)
D54	=IF(TEST!B52="","",TEST!B52)
E37	=IF(A37="","",IF(OR(A37=TEST3!$C$2,A37=TEST3!$C$3,A37,TEST3!$C$4,A37=TEST3!$C$5,A37=TEST3!$C$5),F37+H37+I37,F37+I37))
E38	=IF(A38="","",IF(OR(A38=TEST3!$C$2,A38=TEST3!$C$3,A38,TEST3!$C$4,A38=TEST3!$C$5,A38=TEST3!$C$5),F38+H38+I38,F38+I38))
E39	=IF(A39="","",IF(OR(A39=TEST3!$C$2,A39=TEST3!$C$3,A39,TEST3!$C$4,A39=TEST3!$C$5,A39=TEST3!$C$5),F39+H39+I39,F39+I39))
E40	=IF(A40="","",IF(OR(A40=TEST3!$C$2,A40=TEST3!$C$3,A40,TEST3!$C$4,A40=TEST3!$C$5,A40=TEST3!$C$5),F40+H40+I40,F40+I40))
E41	=IF(A41="","",IF(OR(A41=TEST3!$C$2,A41=TEST3!$C$3,A41,TEST3!$C$4,A41=TEST3!$C$5,A41=TEST3!$C$5),F41+H41+I41,F41+I41))
E42	=IF(A42="","",IF(OR(A42=TEST3!$C$2,A42=TEST3!$C$3,A42,TEST3!$C$4,A42=TEST3!$C$5,A42=TEST3!$C$5),F42+H42+I42,F42+I42))
E43	=IF(A43="","",IF(OR(A43=TEST3!$C$2,A43=TEST3!$C$3,A43,TEST3!$C$4,A43=TEST3!$C$5,A43=TEST3!$C$5),F43+H43+I43,F43+I43))
E44	=IF(A44="","",IF(OR(A44=TEST3!$C$2,A44=TEST3!$C$3,A44,TEST3!$C$4,A44=TEST3!$C$5,A44=TEST3!$C$5),F44+H44+I44,F44+I44))
E45	=IF(A45="","",IF(OR(A45=TEST3!$C$2,A45=TEST3!$C$3,A45,TEST3!$C$4,A45=TEST3!$C$5,A45=TEST3!$C$5),F45+H45+I45,F45+I45))
E46	=IF(A46="","",IF(OR(A46=TEST3!$C$2,A46=TEST3!$C$3,A46,TEST3!$C$4,A46=TEST3!$C$5,A46=TEST3!$C$5),F46+H46+I46,F46+I46))
E47	=IF(A47="","",IF(OR(A47=TEST3!$C$2,A47=TEST3!$C$3,A47,TEST3!$C$4,A47=TEST3!$C$5,A47=TEST3!$C$5),F47+H47+I47,F47+I47))
E48	=IF(A48="","",IF(OR(A48=TEST3!$C$2,A48=TEST3!$C$3,A48,TEST3!$C$4,A48=TEST3!$C$5,A48=TEST3!$C$5),F48+H48+I48,F48+I48))
E49	=IF(A49="","",IF(OR(A49=TEST3!$C$2,A49=TEST3!$C$3,A49,TEST3!$C$4,A49=TEST3!$C$5,A49=TEST3!$C$5),F49+H49+I49,F49+I49))
E50	=IF(A50="","",IF(OR(A50=TEST3!$C$2,A50=TEST3!$C$3,A50,TEST3!$C$4,A50=TEST3!$C$5,A50=TEST3!$C$5),F50+H50+I50,F50+I50))
E51	=IF(A51="","",IF(OR(A51=TEST3!$C$2,A51=TEST3!$C$3,A51,TEST3!$C$4,A51=TEST3!$C$5,A51=TEST3!$C$5),F51+H51+I51,F51+I51))
E52	=IF(A52="","",IF(OR(A52=TEST3!$C$2,A52=TEST3!$C$3,A52,TEST3!$C$4,A52=TEST3!$C$5,A52=TEST3!$C$5),F52+H52+I52,F52+I52))
E53	=IF(A53="","",IF(OR(A53=TEST3!$C$2,A53=TEST3!$C$3,A53,TEST3!$C$4,A53=TEST3!$C$5,A53=TEST3!$C$5),F53+H53+I53,F53+I53))
E54	=IF(A54="","",IF(OR(A54=TEST3!$C$2,A54=TEST3!$C$3,A54,TEST3!$C$4,A54=TEST3!$C$5,A54=TEST3!$C$5),F54+H54+I54,F54+I54))
F37	=IF(TEST!C35="","",TEST!C35)
F38	=IF(TEST!C36="","",TEST!C36)
F39	=IF(TEST!C37="","",TEST!C37)
F40	=IF(TEST!C38="","",TEST!C38)
F41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!A39="","",TEST!A39),VLOOKUP(A41,TEST!$AA$27:$AS$36,3)))
F42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!A40="","",TEST!A40),VLOOKUP(A42,TEST!$AA$27:$AS$36,3)))
F43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!A41="","",TEST!A41),VLOOKUP(A43,TEST!$AA$27:$AS$36,3)))
F44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!A42="","",TEST!A42),VLOOKUP(A44,TEST!$AA$27:$AS$36,3)))
F45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!A43="","",TEST!A43),VLOOKUP(A45,TEST!$AA$27:$AS$36,3)))
F46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!A44="","",TEST!A44),VLOOKUP(A46,TEST!$AA$27:$AS$36,3)))
F47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!A45="","",TEST!A45),VLOOKUP(A47,TEST!$AA$27:$AS$36,3)))
F48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!A46="","",TEST!A46),VLOOKUP(A48,TEST!$AA$27:$AS$36,3)))
F49	=IF(TEST!C47="","",TEST!C47)
F50	=IF(TEST!C48="","",TEST!C48)
F51	=IF(TEST!C49="","",TEST!C49)
F52	=IF(TEST!C50="","",TEST!C50)
F53	=IF(TEST!C51="","",TEST!C51)
F54	=IF(TEST!C52="","",TEST!C52)
G37	=IF(TEST!D35="","",TEST!D35)
G38	=IF(TEST!D36="","",TEST!D36)
G39	=IF(TEST!D37="","",TEST!D37)
G40	=IF(TEST!D38="","",TEST!D38)
G41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!A39="","",TEST!A39),VLOOKUP(A41,TEST!$AA$27:$AS$36,4)))
G42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!A40="","",TEST!A40),VLOOKUP(A42,TEST!$AA$27:$AS$36,4)))
G43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!A41="","",TEST!A41),VLOOKUP(A43,TEST!$AA$27:$AS$36,4)))
G44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!A42="","",TEST!A42),VLOOKUP(A44,TEST!$AA$27:$AS$36,4)))
G45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!A43="","",TEST!A43),VLOOKUP(A45,TEST!$AA$27:$AS$36,4)))
G46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!A44="","",TEST!A44),VLOOKUP(A46,TEST!$AA$27:$AS$36,4)))
G47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!A45="","",TEST!A45),VLOOKUP(A47,TEST!$AA$27:$AS$36,4)))
G48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!A46="","",TEST!A46),VLOOKUP(A48,TEST!$AA$27:$AS$36,4)))
G49	=IF(TEST!D47="","",TEST!D47)
G50	=IF(TEST!D48="","",TEST!D48)
G51	=IF(TEST!D49="","",TEST!D49)
G52	=IF(TEST!D50="","",TEST!D50)
G53	=IF(TEST!D51="","",TEST!D51)
G54	=IF(TEST!D52="","",TEST!D52)
H37	=IF(TEST!E35="","",TEST!E35)
H38	=IF(TEST!E36="","",TEST!E36)
H39	=IF(TEST!E37="","",TEST!E37)
H40	=IF(TEST!E38="","",TEST!E38)
H41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!A39="","",TEST!A39),VLOOKUP(A41,TEST!$AA$27:$AS$36,5)))
H42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!A40="","",TEST!A40),VLOOKUP(A42,TEST!$AA$27:$AS$36,5)))
H43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!A41="","",TEST!A41),VLOOKUP(A43,TEST!$AA$27:$AS$36,5)))
H44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!A42="","",TEST!A42),VLOOKUP(A44,TEST!$AA$27:$AS$36,5)))
H45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!A43="","",TEST!A43),VLOOKUP(A45,TEST!$AA$27:$AS$36,5)))
H46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!A44="","",TEST!A44),VLOOKUP(A46,TEST!$AA$27:$AS$36,5)))
H47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!A45="","",TEST!A45),VLOOKUP(A47,TEST!$AA$27:$AS$36,5)))
H48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!A46="","",TEST!A46),VLOOKUP(A48,TEST!$AA$27:$AS$36,5)))
H49	=IF(TEST!E47="","",TEST!E47)
H50	=IF(TEST!E48="","",TEST!E48)
H51	=IF(TEST!E49="","",TEST!E49)
H52	=IF(TEST!E50="","",TEST!E50)
H53	=IF(TEST!E51="","",TEST!E51)
H54	=IF(TEST!E52="","",TEST!E52)
I37	=IF(TEST!F35="","",TEST!F35)
I38	=IF(TEST!F36="","",TEST!F36)
I39	=IF(TEST!F37="","",TEST!F37)
I40	=IF(TEST!F38="","",TEST!F38)
I41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!A39="","",TEST!A39),VLOOKUP(A41,TEST!$AA$27:$AS$36,6)))
I42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!A40="","",TEST!A40),VLOOKUP(A42,TEST!$AA$27:$AS$36,6)))
I43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!A41="","",TEST!A41),VLOOKUP(A43,TEST!$AA$27:$AS$36,6)))
I44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!A42="","",TEST!A42),VLOOKUP(A44,TEST!$AA$27:$AS$36,6)))
I45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!A43="","",TEST!A43),VLOOKUP(A45,TEST!$AA$27:$AS$36,6)))
I46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!A44="","",TEST!A44),VLOOKUP(A46,TEST!$AA$27:$AS$36,6)))
I47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!A45="","",TEST!A45),VLOOKUP(A47,TEST!$AA$27:$AS$36,6)))
I48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!A46="","",TEST!A46),VLOOKUP(A48,TEST!$AA$27:$AS$36,6)))
I49	=IF(TEST!F47="","",TEST!F47)
I50	=IF(TEST!F48="","",TEST!F48)
I51	=IF(TEST!F49="","",TEST!F49)
I52	=IF(TEST!F50="","",TEST!F50)
I53	=IF(TEST!F51="","",TEST!F51)
I54	=IF(TEST!F52="","",TEST!F52)
J37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!G35="","",TEST!G35),VLOOKUP(A37,TEST!$AA$27:$AS$36,7)))
J38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!G36="","",TEST!G36),VLOOKUP(A38,TEST!$AA$27:$AS$36,7)))
J39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!G37="","",TEST!G37),VLOOKUP(A39,TEST!$AA$27:$AS$36,7)))
J40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!G38="","",TEST!G38),VLOOKUP(A40,TEST!$AA$27:$AS$36,7)))
J41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!G39="","",TEST!G39),VLOOKUP(A41,TEST!$AA$27:$AS$36,7)))
J42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!G40="","",TEST!G40),VLOOKUP(A42,TEST!$AA$27:$AS$36,7)))
J43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!G41="","",TEST!G41),VLOOKUP(A43,TEST!$AA$27:$AS$36,7)))
J44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!G42="","",TEST!G42),VLOOKUP(A44,TEST!$AA$27:$AS$36,7)))
J45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!G43="","",TEST!G43),VLOOKUP(A45,TEST!$AA$27:$AS$36,7)))
J46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!G44="","",TEST!G44),VLOOKUP(A46,TEST!$AA$27:$AS$36,7)))
J47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!G45="","",TEST!G45),VLOOKUP(A47,TEST!$AA$27:$AS$36,7)))
J48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!G46="","",TEST!G46),VLOOKUP(A48,TEST!$AA$27:$AS$36,7)))
J49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!G47="","",TEST!G47),VLOOKUP(A49,TEST!$AA$27:$AS$36,7)))
J50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!G48="","",TEST!G48),VLOOKUP(A50,TEST!$AA$27:$AS$36,7)))
J51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!G49="","",TEST!G49),VLOOKUP(A51,TEST!$AA$27:$AS$36,7)))
J52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!G50="","",TEST!G50),VLOOKUP(A52,TEST!$AA$27:$AS$36,7)))
J53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!G51="","",TEST!G51),VLOOKUP(A53,TEST!$AA$27:$AS$36,7)))
J54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!G52="","",TEST!G52),VLOOKUP(A54,TEST!$AA$27:$AS$36,7)))
K37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!H35="","",TEST!H35),VLOOKUP(A37,TEST!$AA$27:$AS$36,8)))
K38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!H36="","",TEST!H36),VLOOKUP(A38,TEST!$AA$27:$AS$36,8)))
K39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!H37="","",TEST!H37),VLOOKUP(A39,TEST!$AA$27:$AS$36,8)))
K40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!H38="","",TEST!H38),VLOOKUP(A40,TEST!$AA$27:$AS$36,8)))
K41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!H39="","",TEST!H39),VLOOKUP(A41,TEST!$AA$27:$AS$36,8)))
K42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!H40="","",TEST!H40),VLOOKUP(A42,TEST!$AA$27:$AS$36,8)))
K43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!H41="","",TEST!H41),VLOOKUP(A43,TEST!$AA$27:$AS$36,8)))
K44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!H42="","",TEST!H42),VLOOKUP(A44,TEST!$AA$27:$AS$36,8)))
K45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!H43="","",TEST!H43),VLOOKUP(A45,TEST!$AA$27:$AS$36,8)))
K46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!H44="","",TEST!H44),VLOOKUP(A46,TEST!$AA$27:$AS$36,8)))
K47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!H45="","",TEST!H45),VLOOKUP(A47,TEST!$AA$27:$AS$36,8)))
K48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!H46="","",TEST!H46),VLOOKUP(A48,TEST!$AA$27:$AS$36,8)))
K49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!H47="","",TEST!H47),VLOOKUP(A49,TEST!$AA$27:$AS$36,8)))
K50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!H48="","",TEST!H48),VLOOKUP(A50,TEST!$AA$27:$AS$36,8)))
K51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!H49="","",TEST!H49),VLOOKUP(A51,TEST!$AA$27:$AS$36,8)))
K52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!H50="","",TEST!H50),VLOOKUP(A52,TEST!$AA$27:$AS$36,8)))
K53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!H51="","",TEST!H51),VLOOKUP(A53,TEST!$AA$27:$AS$36,8)))
K54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!H52="","",TEST!H52),VLOOKUP(A54,TEST!$AA$27:$AS$36,8)))
L37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!I35="","",TEST!I35),VLOOKUP(A37,TEST!$AA$27:$AS$36,9)))
L38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!I36="","",TEST!I36),VLOOKUP(A38,TEST!$AA$27:$AS$36,9)))
L39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!I37="","",TEST!I37),VLOOKUP(A39,TEST!$AA$27:$AS$36,9)))
L40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!I38="","",TEST!I38),VLOOKUP(A40,TEST!$AA$27:$AS$36,9)))
L41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!I39="","",TEST!I39),VLOOKUP(A41,TEST!$AA$27:$AS$36,9)))
L42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!I40="","",TEST!I40),VLOOKUP(A42,TEST!$AA$27:$AS$36,9)))
L43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!I41="","",TEST!I41),VLOOKUP(A43,TEST!$AA$27:$AS$36,9)))
L44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!I42="","",TEST!I42),VLOOKUP(A44,TEST!$AA$27:$AS$36,9)))
L45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!I43="","",TEST!I43),VLOOKUP(A45,TEST!$AA$27:$AS$36,9)))
L46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!I44="","",TEST!I44),VLOOKUP(A46,TEST!$AA$27:$AS$36,9)))
L47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!I45="","",TEST!I45),VLOOKUP(A47,TEST!$AA$27:$AS$36,9)))
L48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!I46="","",TEST!I46),VLOOKUP(A48,TEST!$AA$27:$AS$36,9)))
L49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!I47="","",TEST!I47),VLOOKUP(A49,TEST!$AA$27:$AS$36,9)))
L50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!I48="","",TEST!I48),VLOOKUP(A50,TEST!$AA$27:$AS$36,9)))
L51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!I49="","",TEST!I49),VLOOKUP(A51,TEST!$AA$27:$AS$36,9)))
L52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!I50="","",TEST!I50),VLOOKUP(A52,TEST!$AA$27:$AS$36,9)))
L53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!I51="","",TEST!I51),VLOOKUP(A53,TEST!$AA$27:$AS$36,9)))
L54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!I52="","",TEST!I52),VLOOKUP(A54,TEST!$AA$27:$AS$36,9)))
M37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!J35="","",TEST!J35),VLOOKUP(A37,TEST!$AA$27:$AS$36,10)))
M38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!J36="","",TEST!J36),VLOOKUP(A38,TEST!$AA$27:$AS$36,10)))
M39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!J37="","",TEST!J37),VLOOKUP(A39,TEST!$AA$27:$AS$36,10)))
M40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!J38="","",TEST!J38),VLOOKUP(A40,TEST!$AA$27:$AS$36,10)))
M41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!J39="","",TEST!J39),VLOOKUP(A41,TEST!$AA$27:$AS$36,10)))
M42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!J40="","",TEST!J40),VLOOKUP(A42,TEST!$AA$27:$AS$36,10)))
M43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!J41="","",TEST!J41),VLOOKUP(A43,TEST!$AA$27:$AS$36,10)))
M44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!J42="","",TEST!J42),VLOOKUP(A44,TEST!$AA$27:$AS$36,10)))
M45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!J43="","",TEST!J43),VLOOKUP(A45,TEST!$AA$27:$AS$36,10)))
M46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!J44="","",TEST!J44),VLOOKUP(A46,TEST!$AA$27:$AS$36,10)))
M47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!J45="","",TEST!J45),VLOOKUP(A47,TEST!$AA$27:$AS$36,10)))
M48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!J46="","",TEST!J46),VLOOKUP(A48,TEST!$AA$27:$AS$36,10)))
M49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!J47="","",TEST!J47),VLOOKUP(A49,TEST!$AA$27:$AS$36,10)))
M50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!J48="","",TEST!J48),VLOOKUP(A50,TEST!$AA$27:$AS$36,10)))
M51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!J49="","",TEST!J49),VLOOKUP(A51,TEST!$AA$27:$AS$36,10)))
M52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!J50="","",TEST!J50),VLOOKUP(A52,TEST!$AA$27:$AS$36,10)))
M53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!J51="","",TEST!J51),VLOOKUP(A53,TEST!$AA$27:$AS$36,10)))
M54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!J52="","",TEST!J52),VLOOKUP(A54,TEST!$AA$27:$AS$36,10)))
N37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!K35="","",TEST!K35),VLOOKUP(A37,TEST!$AA$27:$AS$36,11)))
N38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!K36="","",TEST!K36),VLOOKUP(A38,TEST!$AA$27:$AS$36,11)))
N39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!K37="","",TEST!K37),VLOOKUP(A39,TEST!$AA$27:$AS$36,11)))
N40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!K38="","",TEST!K38),VLOOKUP(A40,TEST!$AA$27:$AS$36,11)))
N41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!K39="","",TEST!K39),VLOOKUP(A41,TEST!$AA$27:$AS$36,11)))
N42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!K40="","",TEST!K40),VLOOKUP(A42,TEST!$AA$27:$AS$36,11)))
N43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!K41="","",TEST!K41),VLOOKUP(A43,TEST!$AA$27:$AS$36,11)))
N44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!K42="","",TEST!K42),VLOOKUP(A44,TEST!$AA$27:$AS$36,11)))
N45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!K43="","",TEST!K43),VLOOKUP(A45,TEST!$AA$27:$AS$36,11)))
N46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!K44="","",TEST!K44),VLOOKUP(A46,TEST!$AA$27:$AS$36,11)))
N47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!K45="","",TEST!K45),VLOOKUP(A47,TEST!$AA$27:$AS$36,11)))
N48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!K46="","",TEST!K46),VLOOKUP(A48,TEST!$AA$27:$AS$36,11)))
N49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!K47="","",TEST!K47),VLOOKUP(A49,TEST!$AA$27:$AS$36,11)))
N50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!K48="","",TEST!K48),VLOOKUP(A50,TEST!$AA$27:$AS$36,11)))
N51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!K49="","",TEST!K49),VLOOKUP(A51,TEST!$AA$27:$AS$36,11)))
N52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!K50="","",TEST!K50),VLOOKUP(A52,TEST!$AA$27:$AS$36,11)))
N53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!K51="","",TEST!K51),VLOOKUP(A53,TEST!$AA$27:$AS$36,11)))
N54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!K52="","",TEST!K52),VLOOKUP(A54,TEST!$AA$27:$AS$36,11)))
O37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!L35="","",TEST!L35),VLOOKUP(A37,TEST!$AA$27:$AS$36,12)))
O38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!L36="","",TEST!L36),VLOOKUP(A38,TEST!$AA$27:$AS$36,12)))
O39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!L37="","",TEST!L37),VLOOKUP(A39,TEST!$AA$27:$AS$36,12)))
O40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!L38="","",TEST!L38),VLOOKUP(A40,TEST!$AA$27:$AS$36,12)))
O41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!L39="","",TEST!L39),VLOOKUP(A41,TEST!$AA$27:$AS$36,12)))
O42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!L40="","",TEST!L40),VLOOKUP(A42,TEST!$AA$27:$AS$36,12)))
O43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!L41="","",TEST!L41),VLOOKUP(A43,TEST!$AA$27:$AS$36,12)))
O44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!L42="","",TEST!L42),VLOOKUP(A44,TEST!$AA$27:$AS$36,12)))
O45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!L43="","",TEST!L43),VLOOKUP(A45,TEST!$AA$27:$AS$36,12)))
O46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!L44="","",TEST!L44),VLOOKUP(A46,TEST!$AA$27:$AS$36,12)))
O47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!L45="","",TEST!L45),VLOOKUP(A47,TEST!$AA$27:$AS$36,12)))
O48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!L46="","",TEST!L46),VLOOKUP(A48,TEST!$AA$27:$AS$36,12)))
O49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!L47="","",TEST!L47),VLOOKUP(A49,TEST!$AA$27:$AS$36,12)))
O50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!L48="","",TEST!L48),VLOOKUP(A50,TEST!$AA$27:$AS$36,12)))
O51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!L49="","",TEST!L49),VLOOKUP(A51,TEST!$AA$27:$AS$36,12)))
O52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!L50="","",TEST!L50),VLOOKUP(A52,TEST!$AA$27:$AS$36,12)))
O53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!L51="","",TEST!L51),VLOOKUP(A53,TEST!$AA$27:$AS$36,12)))
O54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!L52="","",TEST!L52),VLOOKUP(A54,TEST!$AA$27:$AS$36,12)))
P37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!M35="","",TEST!M35),VLOOKUP(A37,TEST!$AA$27:$AS$36,13)))
P38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!M36="","",TEST!M36),VLOOKUP(A38,TEST!$AA$27:$AS$36,13)))
P39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!M37="","",TEST!M37),VLOOKUP(A39,TEST!$AA$27:$AS$36,13)))
P40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!M38="","",TEST!M38),VLOOKUP(A40,TEST!$AA$27:$AS$36,13)))
P41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!M39="","",TEST!M39),VLOOKUP(A41,TEST!$AA$27:$AS$36,13)))
P42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!M40="","",TEST!M40),VLOOKUP(A42,TEST!$AA$27:$AS$36,13)))
P43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!M41="","",TEST!M41),VLOOKUP(A43,TEST!$AA$27:$AS$36,13)))
P44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!M42="","",TEST!M42),VLOOKUP(A44,TEST!$AA$27:$AS$36,13)))
P45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!M43="","",TEST!M43),VLOOKUP(A45,TEST!$AA$27:$AS$36,13)))
P46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!M44="","",TEST!M44),VLOOKUP(A46,TEST!$AA$27:$AS$36,13)))
P47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!M45="","",TEST!M45),VLOOKUP(A47,TEST!$AA$27:$AS$36,13)))
P48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!M46="","",TEST!M46),VLOOKUP(A48,TEST!$AA$27:$AS$36,13)))
P49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!M47="","",TEST!M47),VLOOKUP(A49,TEST!$AA$27:$AS$36,13)))
P50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!M48="","",TEST!M48),VLOOKUP(A50,TEST!$AA$27:$AS$36,13)))
P51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!M49="","",TEST!M49),VLOOKUP(A51,TEST!$AA$27:$AS$36,13)))
P52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!M50="","",TEST!M50),VLOOKUP(A52,TEST!$AA$27:$AS$36,13)))
P53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!M51="","",TEST!M51),VLOOKUP(A53,TEST!$AA$27:$AS$36,13)))
P54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!M52="","",TEST!M52),VLOOKUP(A54,TEST!$AA$27:$AS$36,13)))
Q37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!N35="","",TEST!N35),VLOOKUP(A37,TEST!$AA$27:$AS$36,14)))
Q38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!N36="","",TEST!N36),VLOOKUP(A38,TEST!$AA$27:$AS$36,14)))
Q39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!N37="","",TEST!N37),VLOOKUP(A39,TEST!$AA$27:$AS$36,14)))
Q40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!N38="","",TEST!N38),VLOOKUP(A40,TEST!$AA$27:$AS$36,14)))
Q41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!N39="","",TEST!N39),VLOOKUP(A41,TEST!$AA$27:$AS$36,14)))
Q42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!N40="","",TEST!N40),VLOOKUP(A42,TEST!$AA$27:$AS$36,14)))
Q43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!N41="","",TEST!N41),VLOOKUP(A43,TEST!$AA$27:$AS$36,14)))
Q44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!N42="","",TEST!N42),VLOOKUP(A44,TEST!$AA$27:$AS$36,14)))
Q45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!N43="","",TEST!N43),VLOOKUP(A45,TEST!$AA$27:$AS$36,14)))
Q46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!N44="","",TEST!N44),VLOOKUP(A46,TEST!$AA$27:$AS$36,14)))
Q47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!N45="","",TEST!N45),VLOOKUP(A47,TEST!$AA$27:$AS$36,14)))
Q48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!N46="","",TEST!N46),VLOOKUP(A48,TEST!$AA$27:$AS$36,14)))
Q49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!N47="","",TEST!N47),VLOOKUP(A49,TEST!$AA$27:$AS$36,14)))
Q50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!N48="","",TEST!N48),VLOOKUP(A50,TEST!$AA$27:$AS$36,14)))
Q51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!N49="","",TEST!N49),VLOOKUP(A51,TEST!$AA$27:$AS$36,14)))
Q52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!N50="","",TEST!N50),VLOOKUP(A52,TEST!$AA$27:$AS$36,14)))
Q53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!N51="","",TEST!N51),VLOOKUP(A53,TEST!$AA$27:$AS$36,14)))
Q54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!N52="","",TEST!N52),VLOOKUP(A54,TEST!$AA$27:$AS$36,14)))
R37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!O35="","",TEST!O35),VLOOKUP(A37,TEST!$AA$27:$AS$36,15)))
R38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!O36="","",TEST!O36),VLOOKUP(A38,TEST!$AA$27:$AS$36,15)))
R39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!O37="","",TEST!O37),VLOOKUP(A39,TEST!$AA$27:$AS$36,15)))
R40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!O38="","",TEST!O38),VLOOKUP(A40,TEST!$AA$27:$AS$36,15)))
R41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!O39="","",TEST!O39),VLOOKUP(A41,TEST!$AA$27:$AS$36,15)))
R42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!O40="","",TEST!O40),VLOOKUP(A42,TEST!$AA$27:$AS$36,15)))
R43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!O41="","",TEST!O41),VLOOKUP(A43,TEST!$AA$27:$AS$36,15)))
R44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!O42="","",TEST!O42),VLOOKUP(A44,TEST!$AA$27:$AS$36,15)))
R45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!O43="","",TEST!O43),VLOOKUP(A45,TEST!$AA$27:$AS$36,15)))
R46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!O44="","",TEST!O44),VLOOKUP(A46,TEST!$AA$27:$AS$36,15)))
R47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!O45="","",TEST!O45),VLOOKUP(A47,TEST!$AA$27:$AS$36,15)))
R48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!O46="","",TEST!O46),VLOOKUP(A48,TEST!$AA$27:$AS$36,15)))
R49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!O47="","",TEST!O47),VLOOKUP(A49,TEST!$AA$27:$AS$36,15)))
R50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!O48="","",TEST!O48),VLOOKUP(A50,TEST!$AA$27:$AS$36,15)))
R51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!O49="","",TEST!O49),VLOOKUP(A51,TEST!$AA$27:$AS$36,15)))
R52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!O50="","",TEST!O50),VLOOKUP(A52,TEST!$AA$27:$AS$36,15)))
R53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!O51="","",TEST!O51),VLOOKUP(A53,TEST!$AA$27:$AS$36,15)))
R54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!O52="","",TEST!O52),VLOOKUP(A54,TEST!$AA$27:$AS$36,15)))
S37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!P35="","",TEST!P35),VLOOKUP(A37,TEST!$AA$27:$AS$36,16)))
S38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!P36="","",TEST!P36),VLOOKUP(A38,TEST!$AA$27:$AS$36,16)))
S39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!P37="","",TEST!P37),VLOOKUP(A39,TEST!$AA$27:$AS$36,16)))
S40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!P38="","",TEST!P38),VLOOKUP(A40,TEST!$AA$27:$AS$36,16)))
S41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!P39="","",TEST!P39),VLOOKUP(A41,TEST!$AA$27:$AS$36,16)))
S42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!P40="","",TEST!P40),VLOOKUP(A42,TEST!$AA$27:$AS$36,16)))
S43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!P41="","",TEST!P41),VLOOKUP(A43,TEST!$AA$27:$AS$36,16)))
S44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!P42="","",TEST!P42),VLOOKUP(A44,TEST!$AA$27:$AS$36,16)))
S45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!P43="","",TEST!P43),VLOOKUP(A45,TEST!$AA$27:$AS$36,16)))
S46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!P44="","",TEST!P44),VLOOKUP(A46,TEST!$AA$27:$AS$36,16)))
S47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!P45="","",TEST!P45),VLOOKUP(A47,TEST!$AA$27:$AS$36,16)))
S48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!P46="","",TEST!P46),VLOOKUP(A48,TEST!$AA$27:$AS$36,16)))
S49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!P47="","",TEST!P47),VLOOKUP(A49,TEST!$AA$27:$AS$36,16)))
S50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!P48="","",TEST!P48),VLOOKUP(A50,TEST!$AA$27:$AS$36,16)))
S51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!P49="","",TEST!P49),VLOOKUP(A51,TEST!$AA$27:$AS$36,16)))
S52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!P50="","",TEST!P50),VLOOKUP(A52,TEST!$AA$27:$AS$36,16)))
S53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!P51="","",TEST!P51),VLOOKUP(A53,TEST!$AA$27:$AS$36,16)))
S54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!P52="","",TEST!P52),VLOOKUP(A54,TEST!$AA$27:$AS$36,16)))
T37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!Q35="","",TEST!Q35),VLOOKUP(A37,TEST!$AA$27:$AS$36,17)))
T38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!Q36="","",TEST!Q36),VLOOKUP(A38,TEST!$AA$27:$AS$36,17)))
T39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!Q37="","",TEST!Q37),VLOOKUP(A39,TEST!$AA$27:$AS$36,17)))
T40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!Q38="","",TEST!Q38),VLOOKUP(A40,TEST!$AA$27:$AS$36,17)))
T41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!Q39="","",TEST!Q39),VLOOKUP(A41,TEST!$AA$27:$AS$36,17)))
T42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!Q40="","",TEST!Q40),VLOOKUP(A42,TEST!$AA$27:$AS$36,17)))
T43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!Q41="","",TEST!Q41),VLOOKUP(A43,TEST!$AA$27:$AS$36,17)))
T44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!Q42="","",TEST!Q42),VLOOKUP(A44,TEST!$AA$27:$AS$36,17)))
T45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!Q43="","",TEST!Q43),VLOOKUP(A45,TEST!$AA$27:$AS$36,17)))
T46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!Q44="","",TEST!Q44),VLOOKUP(A46,TEST!$AA$27:$AS$36,17)))
T47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!Q45="","",TEST!Q45),VLOOKUP(A47,TEST!$AA$27:$AS$36,17)))
T48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!Q46="","",TEST!Q46),VLOOKUP(A48,TEST!$AA$27:$AS$36,17)))
T49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!Q47="","",TEST!Q47),VLOOKUP(A49,TEST!$AA$27:$AS$36,17)))
T50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!Q48="","",TEST!Q48),VLOOKUP(A50,TEST!$AA$27:$AS$36,17)))
T51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!Q49="","",TEST!Q49),VLOOKUP(A51,TEST!$AA$27:$AS$36,17)))
T52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!Q50="","",TEST!Q50),VLOOKUP(A52,TEST!$AA$27:$AS$36,17)))
T53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!Q51="","",TEST!Q51),VLOOKUP(A53,TEST!$AA$27:$AS$36,17)))
T54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!Q52="","",TEST!Q52),VLOOKUP(A54,TEST!$AA$27:$AS$36,17)))
U37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!R35="","",TEST!R35),VLOOKUP(A37,TEST!$AA$27:$AS$36,18)))
U38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!R36="","",TEST!R36),VLOOKUP(A38,TEST!$AA$27:$AS$36,18)))
U39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!R37="","",TEST!R37),VLOOKUP(A39,TEST!$AA$27:$AS$36,18)))
U40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!R38="","",TEST!R38),VLOOKUP(A40,TEST!$AA$27:$AS$36,18)))
U41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!R39="","",TEST!R39),VLOOKUP(A41,TEST!$AA$27:$AS$36,18)))
U42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!R40="","",TEST!R40),VLOOKUP(A42,TEST!$AA$27:$AS$36,18)))
U43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!R41="","",TEST!R41),VLOOKUP(A43,TEST!$AA$27:$AS$36,18)))
U44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!R42="","",TEST!R42),VLOOKUP(A44,TEST!$AA$27:$AS$36,18)))
U45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!R43="","",TEST!R43),VLOOKUP(A45,TEST!$AA$27:$AS$36,18)))
U46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!R44="","",TEST!R44),VLOOKUP(A46,TEST!$AA$27:$AS$36,18)))
U47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!R45="","",TEST!R45),VLOOKUP(A47,TEST!$AA$27:$AS$36,18)))
U48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!R46="","",TEST!R46),VLOOKUP(A48,TEST!$AA$27:$AS$36,18)))
U49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!R47="","",TEST!R47),VLOOKUP(A49,TEST!$AA$27:$AS$36,18)))
U50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!R48="","",TEST!R48),VLOOKUP(A50,TEST!$AA$27:$AS$36,18)))
U51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!R49="","",TEST!R49),VLOOKUP(A51,TEST!$AA$27:$AS$36,18)))
U52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!R50="","",TEST!R50),VLOOKUP(A52,TEST!$AA$27:$AS$36,18)))
U53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!R51="","",TEST!R51),VLOOKUP(A53,TEST!$AA$27:$AS$36,18)))
U54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!R52="","",TEST!R52),VLOOKUP(A54,TEST!$AA$27:$AS$36,18)))
V37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!S35="","",TEST!S35),VLOOKUP(A37,TEST!$AA$27:$AS$36,19)))
V38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!S36="","",TEST!S36),VLOOKUP(A38,TEST!$AA$27:$AS$36,19)))
V39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!S37="","",TEST!S37),VLOOKUP(A39,TEST!$AA$27:$AS$36,19)))
V40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!S38="","",TEST!S38),VLOOKUP(A40,TEST!$AA$27:$AS$36,19)))
V41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!S39="","",TEST!S39),VLOOKUP(A41,TEST!$AA$27:$AS$36,19)))
V42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!S40="","",TEST!S40),VLOOKUP(A42,TEST!$AA$27:$AS$36,19)))
V43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!S41="","",TEST!S41),VLOOKUP(A43,TEST!$AA$27:$AS$36,19)))
V44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!S42="","",TEST!S42),VLOOKUP(A44,TEST!$AA$27:$AS$36,19)))
V45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!S43="","",TEST!S43),VLOOKUP(A45,TEST!$AA$27:$AS$36,19)))
V46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!S44="","",TEST!S44),VLOOKUP(A46,TEST!$AA$27:$AS$36,19)))
V47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!S45="","",TEST!S45),VLOOKUP(A47,TEST!$AA$27:$AS$36,19)))
V48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!S46="","",TEST!S46),VLOOKUP(A48,TEST!$AA$27:$AS$36,19)))
V49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!S47="","",TEST!S47),VLOOKUP(A49,TEST!$AA$27:$AS$36,19)))
V50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!S48="","",TEST!S48),VLOOKUP(A50,TEST!$AA$27:$AS$36,19)))
V51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!S49="","",TEST!S49),VLOOKUP(A51,TEST!$AA$27:$AS$36,19)))
V52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!S50="","",TEST!S50),VLOOKUP(A52,TEST!$AA$27:$AS$36,19)))
V53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!S51="","",TEST!S51),VLOOKUP(A53,TEST!$AA$27:$AS$36,19)))
V54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!S52="","",TEST!S52),VLOOKUP(A54,TEST!$AA$27:$AS$36,19)))

 

[picklefactory]

Bug fixed, now showing correct data, sorry.

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
37	5010641278	Hoops	T630	0	150	150	764	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
38	5010641279	Hoops	T630	30	208	208	0	0	0			10							30		30
39	7420892771	Cannons	55	48	23	23	76	0	0								48				48
40	7484580457	0	0	28	885	585	0	300	0							3	15		6	15	21	18
41	1395298	Cab Bkts	55	12	161	161	100	0	0	0	12	0	0	0	0	12	0	0	0	0	12	12
42	1395298	Cab Bkts	55	12	161	161	100	0	0	0	12	0	0	0	0	12	0	0	0	0	12	12
43	1395299	Cab Bkts	55	12	177	177	0	0	0	0	12	0	0	0	0	12	0	0	0	0	12	12
44	1395299	Cab Bkts	55	12	177	177	0	0	0	0	12	0	0	0	0	12	0	0	0	0	12	12
45	1395300	Cab Bkts	55	44	53	29	148	24	0	0	9	0	0	0	12	0	12	24	24	12	36	24
46	1395300	Cab Bkts	55	44	53	29	148	24	0	0	9	0	0	0	12	0	12	24	24	12	36	24
47	1395301	Cab Bkts	55	40	51	51	134	0	0	0	12	0	0	0	0	12	0	36	12	24	36	12
48	1395301	Cab Bkts	55	40	51	51	134	0	0	0	12	0	0	0	0	12	0	36	12	24	36	12
49	51.08140-0222	MAN Bananas	400	80	457	457	244	0	0							80				80
50	9522627V	Shark Fins	Mynx	70	246	70	186	176	0	0	0	0	0	0	0	0	70	0	0	0	0	70
51	9522627V	Shark Fins	Mynx	70	246	70	186	176	0	0	0	0	0	0	0	0	70	0	0	0	0	70
52	9522628V	Shark Fins	Mynx	70	69	69	388	0	0	0	0	0	0	0	0	6	70	70	0	0	0	0
53	9522628V	Shark Fins	Mynx	70	69	69	388	0	0	0	0	0	0	0	0	6	70	70	0	0	0	0
54	Afru 634	AFRU634	M630	400	534	131	1974	403	0	0	200	200	0	200	0	200	200	200	200	200	400	200
TEST2

Cell Formulas
Range	Formula
A37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!A35="","",TEST!A35),VLOOKUP(TEST!A35,TEST!$Z$2:$AA$21,2)))
A38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!A36="","",TEST!A36),VLOOKUP(TEST!A36,TEST!$Z$2:$AA$21,2)))
A39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!A37="","",TEST!A37),VLOOKUP(TEST!A37,TEST!$Z$2:$AA$21,2)))
A40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!A38="","",TEST!A38),VLOOKUP(TEST!A38,TEST!$Z$2:$AA$21,2)))
A41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!A39="","",TEST!A39),VLOOKUP(TEST!A39,TEST!$Z$2:$AA$21,2)))
A42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!A40="","",TEST!A40),VLOOKUP(TEST!A40,TEST!$Z$2:$AA$21,2)))
A43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!A41="","",TEST!A41),VLOOKUP(TEST!A41,TEST!$Z$2:$AA$21,2)))
A44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!A42="","",TEST!A42),VLOOKUP(TEST!A42,TEST!$Z$2:$AA$21,2)))
A45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!A43="","",TEST!A43),VLOOKUP(TEST!A43,TEST!$Z$2:$AA$21,2)))
A46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!A44="","",TEST!A44),VLOOKUP(TEST!A44,TEST!$Z$2:$AA$21,2)))
A47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!A45="","",TEST!A45),VLOOKUP(TEST!A45,TEST!$Z$2:$AA$21,2)))
A48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!A46="","",TEST!A46),VLOOKUP(TEST!A46,TEST!$Z$2:$AA$21,2)))
A49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!A47="","",TEST!A47),VLOOKUP(TEST!A47,TEST!$Z$2:$AA$21,2)))
A50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!A48="","",TEST!A48),VLOOKUP(TEST!A48,TEST!$Z$2:$AA$21,2)))
A51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!A49="","",TEST!A49),VLOOKUP(TEST!A49,TEST!$Z$2:$AA$21,2)))
A52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!A50="","",TEST!A50),VLOOKUP(TEST!A50,TEST!$Z$2:$AA$21,2)))
A53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!A51="","",TEST!A51),VLOOKUP(TEST!A51,TEST!$Z$2:$AA$21,2)))
A54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!A52="","",TEST!A52),VLOOKUP(TEST!A52,TEST!$Z$2:$AA$21,2)))
B37	=IF(A37="","",VLOOKUP(A37,TEST3!$D$2:$F$51,2))
B38	=IF(A38="","",VLOOKUP(A38,TEST3!$D$2:$F$51,2))
B39	=IF(A39="","",VLOOKUP(A39,TEST3!$D$2:$F$51,2))
B40	=IF(A40="","",VLOOKUP(A40,TEST3!$D$2:$F$51,2))
B41	=IF(A41="","",VLOOKUP(A41,TEST3!$D$2:$F$51,2))
B42	=IF(A42="","",VLOOKUP(A42,TEST3!$D$2:$F$51,2))
B43	=IF(A43="","",VLOOKUP(A43,TEST3!$D$2:$F$51,2))
B44	=IF(A44="","",VLOOKUP(A44,TEST3!$D$2:$F$51,2))
B45	=IF(A45="","",VLOOKUP(A45,TEST3!$D$2:$F$51,2))
B46	=IF(A46="","",VLOOKUP(A46,TEST3!$D$2:$F$51,2))
B47	=IF(A47="","",VLOOKUP(A47,TEST3!$D$2:$F$51,2))
B48	=IF(A48="","",VLOOKUP(A48,TEST3!$D$2:$F$51,2))
B49	=IF(A49="","",VLOOKUP(A49,TEST3!$D$2:$F$51,2))
B50	=IF(A50="","",VLOOKUP(A50,TEST3!$D$2:$F$51,2))
B51	=IF(A51="","",VLOOKUP(A51,TEST3!$D$2:$F$51,2))
B52	=IF(A52="","",VLOOKUP(A52,TEST3!$D$2:$F$51,2))
B53	=IF(A53="","",VLOOKUP(A53,TEST3!$D$2:$F$51,2))
B54	=IF(A54="","",VLOOKUP(A54,TEST3!$D$2:$F$51,2))
C37	=IF(A37="","",VLOOKUP(A37,TEST3!$D$2:$F$51,3))
C38	=IF(A38="","",VLOOKUP(A38,TEST3!$D$2:$F$51,3))
C39	=IF(A39="","",VLOOKUP(A39,TEST3!$D$2:$F$51,3))
C40	=IF(A40="","",VLOOKUP(A40,TEST3!$D$2:$F$51,3))
C41	=IF(A41="","",VLOOKUP(A41,TEST3!$D$2:$F$51,3))
C42	=IF(A42="","",VLOOKUP(A42,TEST3!$D$2:$F$51,3))
C43	=IF(A43="","",VLOOKUP(A43,TEST3!$D$2:$F$51,3))
C44	=IF(A44="","",VLOOKUP(A44,TEST3!$D$2:$F$51,3))
C45	=IF(A45="","",VLOOKUP(A45,TEST3!$D$2:$F$51,3))
C46	=IF(A46="","",VLOOKUP(A46,TEST3!$D$2:$F$51,3))
C47	=IF(A47="","",VLOOKUP(A47,TEST3!$D$2:$F$51,3))
C48	=IF(A48="","",VLOOKUP(A48,TEST3!$D$2:$F$51,3))
C49	=IF(A49="","",VLOOKUP(A49,TEST3!$D$2:$F$51,3))
C50	=IF(A50="","",VLOOKUP(A50,TEST3!$D$2:$F$51,3))
C51	=IF(A51="","",VLOOKUP(A51,TEST3!$D$2:$F$51,3))
C52	=IF(A52="","",VLOOKUP(A52,TEST3!$D$2:$F$51,3))
C53	=IF(A53="","",VLOOKUP(A53,TEST3!$D$2:$F$51,3))
C54	=IF(A54="","",VLOOKUP(A54,TEST3!$D$2:$F$51,3))
D37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!B35="","",TEST!B35),VLOOKUP(A37,TEST!$AA$27:$AS$36,2)))
D38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!B36="","",TEST!B36),VLOOKUP(A38,TEST!$AA$27:$AS$36,2)))
D39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!B37="","",TEST!B37),VLOOKUP(A39,TEST!$AA$27:$AS$36,2)))
D40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!B38="","",TEST!B38),VLOOKUP(A40,TEST!$AA$27:$AS$36,2)))
D41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!B39="","",TEST!B39),VLOOKUP(A41,TEST!$AA$27:$AS$36,2)))
D42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!B40="","",TEST!B40),VLOOKUP(A42,TEST!$AA$27:$AS$36,2)))
D43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!B41="","",TEST!B41),VLOOKUP(A43,TEST!$AA$27:$AS$36,2)))
D44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!B42="","",TEST!B42),VLOOKUP(A44,TEST!$AA$27:$AS$36,2)))
D45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!B43="","",TEST!B43),VLOOKUP(A45,TEST!$AA$27:$AS$36,2)))
D46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!B44="","",TEST!B44),VLOOKUP(A46,TEST!$AA$27:$AS$36,2)))
D47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!B45="","",TEST!B45),VLOOKUP(A47,TEST!$AA$27:$AS$36,2)))
D48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!B46="","",TEST!B46),VLOOKUP(A48,TEST!$AA$27:$AS$36,2)))
D49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!B47="","",TEST!B47),VLOOKUP(A49,TEST!$AA$27:$AS$36,2)))
D50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!B48="","",TEST!B48),VLOOKUP(A50,TEST!$AA$27:$AS$36,2)))
D51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!B49="","",TEST!B49),VLOOKUP(A51,TEST!$AA$27:$AS$36,2)))
D52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!B50="","",TEST!B50),VLOOKUP(A52,TEST!$AA$27:$AS$36,2)))
D53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!B51="","",TEST!B51),VLOOKUP(A53,TEST!$AA$27:$AS$36,2)))
D54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!B52="","",TEST!B52),VLOOKUP(A54,TEST!$AA$27:$AS$36,2)))
E37	=IF(A37="","",IF(OR(A37=TEST3!$C$2,A37=TEST3!$C$3,A37,TEST3!$C$4,A37=TEST3!$C$5,A37=TEST3!$C$5),F37+H37+I37,F37+I37))
E38	=IF(A38="","",IF(OR(A38=TEST3!$C$2,A38=TEST3!$C$3,A38,TEST3!$C$4,A38=TEST3!$C$5,A38=TEST3!$C$5),F38+H38+I38,F38+I38))
E39	=IF(A39="","",IF(OR(A39=TEST3!$C$2,A39=TEST3!$C$3,A39,TEST3!$C$4,A39=TEST3!$C$5,A39=TEST3!$C$5),F39+H39+I39,F39+I39))
E40	=IF(A40="","",IF(OR(A40=TEST3!$C$2,A40=TEST3!$C$3,A40,TEST3!$C$4,A40=TEST3!$C$5,A40=TEST3!$C$5),F40+H40+I40,F40+I40))
E41	=IF(A41="","",IF(OR(A41=TEST3!$C$2,A41=TEST3!$C$3,A41,TEST3!$C$4,A41=TEST3!$C$5,A41=TEST3!$C$5),F41+H41+I41,F41+I41))
E42	=IF(A42="","",IF(OR(A42=TEST3!$C$2,A42=TEST3!$C$3,A42,TEST3!$C$4,A42=TEST3!$C$5,A42=TEST3!$C$5),F42+H42+I42,F42+I42))
E43	=IF(A43="","",IF(OR(A43=TEST3!$C$2,A43=TEST3!$C$3,A43,TEST3!$C$4,A43=TEST3!$C$5,A43=TEST3!$C$5),F43+H43+I43,F43+I43))
E44	=IF(A44="","",IF(OR(A44=TEST3!$C$2,A44=TEST3!$C$3,A44,TEST3!$C$4,A44=TEST3!$C$5,A44=TEST3!$C$5),F44+H44+I44,F44+I44))
E45	=IF(A45="","",IF(OR(A45=TEST3!$C$2,A45=TEST3!$C$3,A45,TEST3!$C$4,A45=TEST3!$C$5,A45=TEST3!$C$5),F45+H45+I45,F45+I45))
E46	=IF(A46="","",IF(OR(A46=TEST3!$C$2,A46=TEST3!$C$3,A46,TEST3!$C$4,A46=TEST3!$C$5,A46=TEST3!$C$5),F46+H46+I46,F46+I46))
E47	=IF(A47="","",IF(OR(A47=TEST3!$C$2,A47=TEST3!$C$3,A47,TEST3!$C$4,A47=TEST3!$C$5,A47=TEST3!$C$5),F47+H47+I47,F47+I47))
E48	=IF(A48="","",IF(OR(A48=TEST3!$C$2,A48=TEST3!$C$3,A48,TEST3!$C$4,A48=TEST3!$C$5,A48=TEST3!$C$5),F48+H48+I48,F48+I48))
E49	=IF(A49="","",IF(OR(A49=TEST3!$C$2,A49=TEST3!$C$3,A49,TEST3!$C$4,A49=TEST3!$C$5,A49=TEST3!$C$5),F49+H49+I49,F49+I49))
E50	=IF(A50="","",IF(OR(A50=TEST3!$C$2,A50=TEST3!$C$3,A50,TEST3!$C$4,A50=TEST3!$C$5,A50=TEST3!$C$5),F50+H50+I50,F50+I50))
E51	=IF(A51="","",IF(OR(A51=TEST3!$C$2,A51=TEST3!$C$3,A51,TEST3!$C$4,A51=TEST3!$C$5,A51=TEST3!$C$5),F51+H51+I51,F51+I51))
E52	=IF(A52="","",IF(OR(A52=TEST3!$C$2,A52=TEST3!$C$3,A52,TEST3!$C$4,A52=TEST3!$C$5,A52=TEST3!$C$5),F52+H52+I52,F52+I52))
E53	=IF(A53="","",IF(OR(A53=TEST3!$C$2,A53=TEST3!$C$3,A53,TEST3!$C$4,A53=TEST3!$C$5,A53=TEST3!$C$5),F53+H53+I53,F53+I53))
E54	=IF(A54="","",IF(OR(A54=TEST3!$C$2,A54=TEST3!$C$3,A54,TEST3!$C$4,A54=TEST3!$C$5,A54=TEST3!$C$5),F54+H54+I54,F54+I54))
F37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!C35="","",TEST!C35),VLOOKUP(A37,TEST!$AA$27:$AS$36,3)))
F38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!C36="","",TEST!C36),VLOOKUP(A38,TEST!$AA$27:$AS$36,3)))
F39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!C37="","",TEST!C37),VLOOKUP(A39,TEST!$AA$27:$AS$36,3)))
F40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!C38="","",TEST!C38),VLOOKUP(A40,TEST!$AA$27:$AS$36,3)))
F41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!C39="","",TEST!C39),VLOOKUP(A41,TEST!$AA$27:$AS$36,3)))
F42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!C40="","",TEST!C40),VLOOKUP(A42,TEST!$AA$27:$AS$36,3)))
F43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!C41="","",TEST!C41),VLOOKUP(A43,TEST!$AA$27:$AS$36,3)))
F44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!C42="","",TEST!C42),VLOOKUP(A44,TEST!$AA$27:$AS$36,3)))
F45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!C43="","",TEST!C43),VLOOKUP(A45,TEST!$AA$27:$AS$36,3)))
F46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!C44="","",TEST!C44),VLOOKUP(A46,TEST!$AA$27:$AS$36,3)))
F47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!C45="","",TEST!C45),VLOOKUP(A47,TEST!$AA$27:$AS$36,3)))
F48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!C46="","",TEST!C46),VLOOKUP(A48,TEST!$AA$27:$AS$36,3)))
F49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!C47="","",TEST!C47),VLOOKUP(A49,TEST!$AA$27:$AS$36,3)))
F50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!C48="","",TEST!C48),VLOOKUP(A50,TEST!$AA$27:$AS$36,3)))
F51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!C49="","",TEST!C49),VLOOKUP(A51,TEST!$AA$27:$AS$36,3)))
F52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!C50="","",TEST!C50),VLOOKUP(A52,TEST!$AA$27:$AS$36,3)))
F53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!C51="","",TEST!C51),VLOOKUP(A53,TEST!$AA$27:$AS$36,3)))
F54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!C52="","",TEST!C52),VLOOKUP(A54,TEST!$AA$27:$AS$36,3)))
G37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!D35="","",TEST!D35),VLOOKUP(A37,TEST!$AA$27:$AS$36,4)))
G38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!D36="","",TEST!D36),VLOOKUP(A38,TEST!$AA$27:$AS$36,4)))
G39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!D37="","",TEST!D37),VLOOKUP(A39,TEST!$AA$27:$AS$36,4)))
G40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!D38="","",TEST!D38),VLOOKUP(A40,TEST!$AA$27:$AS$36,4)))
G41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!D39="","",TEST!D39),VLOOKUP(A41,TEST!$AA$27:$AS$36,4)))
G42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!D40="","",TEST!D40),VLOOKUP(A42,TEST!$AA$27:$AS$36,4)))
G43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!D41="","",TEST!D41),VLOOKUP(A43,TEST!$AA$27:$AS$36,4)))
G44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!D42="","",TEST!D42),VLOOKUP(A44,TEST!$AA$27:$AS$36,4)))
G45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!D43="","",TEST!D43),VLOOKUP(A45,TEST!$AA$27:$AS$36,4)))
G46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!D44="","",TEST!D44),VLOOKUP(A46,TEST!$AA$27:$AS$36,4)))
G47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!D45="","",TEST!D45),VLOOKUP(A47,TEST!$AA$27:$AS$36,4)))
G48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!D46="","",TEST!D46),VLOOKUP(A48,TEST!$AA$27:$AS$36,4)))
G49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!D47="","",TEST!D47),VLOOKUP(A49,TEST!$AA$27:$AS$36,4)))
G50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!D48="","",TEST!D48),VLOOKUP(A50,TEST!$AA$27:$AS$36,4)))
G51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!D49="","",TEST!D49),VLOOKUP(A51,TEST!$AA$27:$AS$36,4)))
G52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!D50="","",TEST!D50),VLOOKUP(A52,TEST!$AA$27:$AS$36,4)))
G53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!D51="","",TEST!D51),VLOOKUP(A53,TEST!$AA$27:$AS$36,4)))
G54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!D52="","",TEST!D52),VLOOKUP(A54,TEST!$AA$27:$AS$36,4)))
H37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!E35="","",TEST!E35),VLOOKUP(A37,TEST!$AA$27:$AS$36,5)))
H38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!E36="","",TEST!E36),VLOOKUP(A38,TEST!$AA$27:$AS$36,5)))
H39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!E37="","",TEST!E37),VLOOKUP(A39,TEST!$AA$27:$AS$36,5)))
H40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!E38="","",TEST!E38),VLOOKUP(A40,TEST!$AA$27:$AS$36,5)))
H41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!E39="","",TEST!E39),VLOOKUP(A41,TEST!$AA$27:$AS$36,5)))
H42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!E40="","",TEST!E40),VLOOKUP(A42,TEST!$AA$27:$AS$36,5)))
H43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!E41="","",TEST!E41),VLOOKUP(A43,TEST!$AA$27:$AS$36,5)))
H44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!E42="","",TEST!E42),VLOOKUP(A44,TEST!$AA$27:$AS$36,5)))
H45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!E43="","",TEST!E43),VLOOKUP(A45,TEST!$AA$27:$AS$36,5)))
H46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!E44="","",TEST!E44),VLOOKUP(A46,TEST!$AA$27:$AS$36,5)))
H47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!E45="","",TEST!E45),VLOOKUP(A47,TEST!$AA$27:$AS$36,5)))
H48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!E46="","",TEST!E46),VLOOKUP(A48,TEST!$AA$27:$AS$36,5)))
H49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!E47="","",TEST!E47),VLOOKUP(A49,TEST!$AA$27:$AS$36,5)))
H50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!E48="","",TEST!E48),VLOOKUP(A50,TEST!$AA$27:$AS$36,5)))
H51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!E49="","",TEST!E49),VLOOKUP(A51,TEST!$AA$27:$AS$36,5)))
H52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!E50="","",TEST!E50),VLOOKUP(A52,TEST!$AA$27:$AS$36,5)))
H53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!E51="","",TEST!E51),VLOOKUP(A53,TEST!$AA$27:$AS$36,5)))
H54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!E52="","",TEST!E52),VLOOKUP(A54,TEST!$AA$27:$AS$36,5)))
I37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!F35="","",TEST!F35),VLOOKUP(A37,TEST!$AA$27:$AS$36,6)))
I38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!F36="","",TEST!F36),VLOOKUP(A38,TEST!$AA$27:$AS$36,6)))
I39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!F37="","",TEST!F37),VLOOKUP(A39,TEST!$AA$27:$AS$36,6)))
I40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!F38="","",TEST!F38),VLOOKUP(A40,TEST!$AA$27:$AS$36,6)))
I41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!F39="","",TEST!F39),VLOOKUP(A41,TEST!$AA$27:$AS$36,6)))
I42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!F40="","",TEST!F40),VLOOKUP(A42,TEST!$AA$27:$AS$36,6)))
I43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!F41="","",TEST!F41),VLOOKUP(A43,TEST!$AA$27:$AS$36,6)))
I44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!F42="","",TEST!F42),VLOOKUP(A44,TEST!$AA$27:$AS$36,6)))
I45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!F43="","",TEST!F43),VLOOKUP(A45,TEST!$AA$27:$AS$36,6)))
I46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!F44="","",TEST!F44),VLOOKUP(A46,TEST!$AA$27:$AS$36,6)))
I47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!F45="","",TEST!F45),VLOOKUP(A47,TEST!$AA$27:$AS$36,6)))
I48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!F46="","",TEST!F46),VLOOKUP(A48,TEST!$AA$27:$AS$36,6)))
I49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!F47="","",TEST!F47),VLOOKUP(A49,TEST!$AA$27:$AS$36,6)))
I50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!F48="","",TEST!F48),VLOOKUP(A50,TEST!$AA$27:$AS$36,6)))
I51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!F49="","",TEST!F49),VLOOKUP(A51,TEST!$AA$27:$AS$36,6)))
I52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!F50="","",TEST!F50),VLOOKUP(A52,TEST!$AA$27:$AS$36,6)))
I53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!F51="","",TEST!F51),VLOOKUP(A53,TEST!$AA$27:$AS$36,6)))
I54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!F52="","",TEST!F52),VLOOKUP(A54,TEST!$AA$27:$AS$36,6)))
J37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!G35="","",TEST!G35),VLOOKUP(A37,TEST!$AA$27:$AS$36,7)))
J38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!G36="","",TEST!G36),VLOOKUP(A38,TEST!$AA$27:$AS$36,7)))
J39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!G37="","",TEST!G37),VLOOKUP(A39,TEST!$AA$27:$AS$36,7)))
J40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!G38="","",TEST!G38),VLOOKUP(A40,TEST!$AA$27:$AS$36,7)))
J41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!G39="","",TEST!G39),VLOOKUP(A41,TEST!$AA$27:$AS$36,7)))
J42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!G40="","",TEST!G40),VLOOKUP(A42,TEST!$AA$27:$AS$36,7)))
J43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!G41="","",TEST!G41),VLOOKUP(A43,TEST!$AA$27:$AS$36,7)))
J44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!G42="","",TEST!G42),VLOOKUP(A44,TEST!$AA$27:$AS$36,7)))
J45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!G43="","",TEST!G43),VLOOKUP(A45,TEST!$AA$27:$AS$36,7)))
J46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!G44="","",TEST!G44),VLOOKUP(A46,TEST!$AA$27:$AS$36,7)))
J47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!G45="","",TEST!G45),VLOOKUP(A47,TEST!$AA$27:$AS$36,7)))
J48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!G46="","",TEST!G46),VLOOKUP(A48,TEST!$AA$27:$AS$36,7)))
J49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!G47="","",TEST!G47),VLOOKUP(A49,TEST!$AA$27:$AS$36,7)))
J50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!G48="","",TEST!G48),VLOOKUP(A50,TEST!$AA$27:$AS$36,7)))
J51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!G49="","",TEST!G49),VLOOKUP(A51,TEST!$AA$27:$AS$36,7)))
J52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!G50="","",TEST!G50),VLOOKUP(A52,TEST!$AA$27:$AS$36,7)))
J53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!G51="","",TEST!G51),VLOOKUP(A53,TEST!$AA$27:$AS$36,7)))
J54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!G52="","",TEST!G52),VLOOKUP(A54,TEST!$AA$27:$AS$36,7)))
K37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!H35="","",TEST!H35),VLOOKUP(A37,TEST!$AA$27:$AS$36,8)))
K38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!H36="","",TEST!H36),VLOOKUP(A38,TEST!$AA$27:$AS$36,8)))
K39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!H37="","",TEST!H37),VLOOKUP(A39,TEST!$AA$27:$AS$36,8)))
K40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!H38="","",TEST!H38),VLOOKUP(A40,TEST!$AA$27:$AS$36,8)))
K41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!H39="","",TEST!H39),VLOOKUP(A41,TEST!$AA$27:$AS$36,8)))
K42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!H40="","",TEST!H40),VLOOKUP(A42,TEST!$AA$27:$AS$36,8)))
K43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!H41="","",TEST!H41),VLOOKUP(A43,TEST!$AA$27:$AS$36,8)))
K44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!H42="","",TEST!H42),VLOOKUP(A44,TEST!$AA$27:$AS$36,8)))
K45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!H43="","",TEST!H43),VLOOKUP(A45,TEST!$AA$27:$AS$36,8)))
K46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!H44="","",TEST!H44),VLOOKUP(A46,TEST!$AA$27:$AS$36,8)))
K47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!H45="","",TEST!H45),VLOOKUP(A47,TEST!$AA$27:$AS$36,8)))
K48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!H46="","",TEST!H46),VLOOKUP(A48,TEST!$AA$27:$AS$36,8)))
K49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!H47="","",TEST!H47),VLOOKUP(A49,TEST!$AA$27:$AS$36,8)))
K50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!H48="","",TEST!H48),VLOOKUP(A50,TEST!$AA$27:$AS$36,8)))
K51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!H49="","",TEST!H49),VLOOKUP(A51,TEST!$AA$27:$AS$36,8)))
K52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!H50="","",TEST!H50),VLOOKUP(A52,TEST!$AA$27:$AS$36,8)))
K53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!H51="","",TEST!H51),VLOOKUP(A53,TEST!$AA$27:$AS$36,8)))
K54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!H52="","",TEST!H52),VLOOKUP(A54,TEST!$AA$27:$AS$36,8)))
L37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!I35="","",TEST!I35),VLOOKUP(A37,TEST!$AA$27:$AS$36,9)))
L38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!I36="","",TEST!I36),VLOOKUP(A38,TEST!$AA$27:$AS$36,9)))
L39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!I37="","",TEST!I37),VLOOKUP(A39,TEST!$AA$27:$AS$36,9)))
L40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!I38="","",TEST!I38),VLOOKUP(A40,TEST!$AA$27:$AS$36,9)))
L41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!I39="","",TEST!I39),VLOOKUP(A41,TEST!$AA$27:$AS$36,9)))
L42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!I40="","",TEST!I40),VLOOKUP(A42,TEST!$AA$27:$AS$36,9)))
L43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!I41="","",TEST!I41),VLOOKUP(A43,TEST!$AA$27:$AS$36,9)))
L44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!I42="","",TEST!I42),VLOOKUP(A44,TEST!$AA$27:$AS$36,9)))
L45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!I43="","",TEST!I43),VLOOKUP(A45,TEST!$AA$27:$AS$36,9)))
L46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!I44="","",TEST!I44),VLOOKUP(A46,TEST!$AA$27:$AS$36,9)))
L47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!I45="","",TEST!I45),VLOOKUP(A47,TEST!$AA$27:$AS$36,9)))
L48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!I46="","",TEST!I46),VLOOKUP(A48,TEST!$AA$27:$AS$36,9)))
L49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!I47="","",TEST!I47),VLOOKUP(A49,TEST!$AA$27:$AS$36,9)))
L50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!I48="","",TEST!I48),VLOOKUP(A50,TEST!$AA$27:$AS$36,9)))
L51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!I49="","",TEST!I49),VLOOKUP(A51,TEST!$AA$27:$AS$36,9)))
L52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!I50="","",TEST!I50),VLOOKUP(A52,TEST!$AA$27:$AS$36,9)))
L53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!I51="","",TEST!I51),VLOOKUP(A53,TEST!$AA$27:$AS$36,9)))
L54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!I52="","",TEST!I52),VLOOKUP(A54,TEST!$AA$27:$AS$36,9)))
M37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!J35="","",TEST!J35),VLOOKUP(A37,TEST!$AA$27:$AS$36,10)))
M38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!J36="","",TEST!J36),VLOOKUP(A38,TEST!$AA$27:$AS$36,10)))
M39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!J37="","",TEST!J37),VLOOKUP(A39,TEST!$AA$27:$AS$36,10)))
M40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!J38="","",TEST!J38),VLOOKUP(A40,TEST!$AA$27:$AS$36,10)))
M41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!J39="","",TEST!J39),VLOOKUP(A41,TEST!$AA$27:$AS$36,10)))
M42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!J40="","",TEST!J40),VLOOKUP(A42,TEST!$AA$27:$AS$36,10)))
M43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!J41="","",TEST!J41),VLOOKUP(A43,TEST!$AA$27:$AS$36,10)))
M44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!J42="","",TEST!J42),VLOOKUP(A44,TEST!$AA$27:$AS$36,10)))
M45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!J43="","",TEST!J43),VLOOKUP(A45,TEST!$AA$27:$AS$36,10)))
M46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!J44="","",TEST!J44),VLOOKUP(A46,TEST!$AA$27:$AS$36,10)))
M47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!J45="","",TEST!J45),VLOOKUP(A47,TEST!$AA$27:$AS$36,10)))
M48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!J46="","",TEST!J46),VLOOKUP(A48,TEST!$AA$27:$AS$36,10)))
M49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!J47="","",TEST!J47),VLOOKUP(A49,TEST!$AA$27:$AS$36,10)))
M50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!J48="","",TEST!J48),VLOOKUP(A50,TEST!$AA$27:$AS$36,10)))
M51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!J49="","",TEST!J49),VLOOKUP(A51,TEST!$AA$27:$AS$36,10)))
M52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!J50="","",TEST!J50),VLOOKUP(A52,TEST!$AA$27:$AS$36,10)))
M53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!J51="","",TEST!J51),VLOOKUP(A53,TEST!$AA$27:$AS$36,10)))
M54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!J52="","",TEST!J52),VLOOKUP(A54,TEST!$AA$27:$AS$36,10)))
N37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!K35="","",TEST!K35),VLOOKUP(A37,TEST!$AA$27:$AS$36,11)))
N38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!K36="","",TEST!K36),VLOOKUP(A38,TEST!$AA$27:$AS$36,11)))
N39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!K37="","",TEST!K37),VLOOKUP(A39,TEST!$AA$27:$AS$36,11)))
N40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!K38="","",TEST!K38),VLOOKUP(A40,TEST!$AA$27:$AS$36,11)))
N41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!K39="","",TEST!K39),VLOOKUP(A41,TEST!$AA$27:$AS$36,11)))
N42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!K40="","",TEST!K40),VLOOKUP(A42,TEST!$AA$27:$AS$36,11)))
N43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!K41="","",TEST!K41),VLOOKUP(A43,TEST!$AA$27:$AS$36,11)))
N44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!K42="","",TEST!K42),VLOOKUP(A44,TEST!$AA$27:$AS$36,11)))
N45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!K43="","",TEST!K43),VLOOKUP(A45,TEST!$AA$27:$AS$36,11)))
N46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!K44="","",TEST!K44),VLOOKUP(A46,TEST!$AA$27:$AS$36,11)))
N47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!K45="","",TEST!K45),VLOOKUP(A47,TEST!$AA$27:$AS$36,11)))
N48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!K46="","",TEST!K46),VLOOKUP(A48,TEST!$AA$27:$AS$36,11)))
N49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!K47="","",TEST!K47),VLOOKUP(A49,TEST!$AA$27:$AS$36,11)))
N50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!K48="","",TEST!K48),VLOOKUP(A50,TEST!$AA$27:$AS$36,11)))
N51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!K49="","",TEST!K49),VLOOKUP(A51,TEST!$AA$27:$AS$36,11)))
N52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!K50="","",TEST!K50),VLOOKUP(A52,TEST!$AA$27:$AS$36,11)))
N53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!K51="","",TEST!K51),VLOOKUP(A53,TEST!$AA$27:$AS$36,11)))
N54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!K52="","",TEST!K52),VLOOKUP(A54,TEST!$AA$27:$AS$36,11)))
O37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!L35="","",TEST!L35),VLOOKUP(A37,TEST!$AA$27:$AS$36,12)))
O38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!L36="","",TEST!L36),VLOOKUP(A38,TEST!$AA$27:$AS$36,12)))
O39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!L37="","",TEST!L37),VLOOKUP(A39,TEST!$AA$27:$AS$36,12)))
O40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!L38="","",TEST!L38),VLOOKUP(A40,TEST!$AA$27:$AS$36,12)))
O41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!L39="","",TEST!L39),VLOOKUP(A41,TEST!$AA$27:$AS$36,12)))
O42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!L40="","",TEST!L40),VLOOKUP(A42,TEST!$AA$27:$AS$36,12)))
O43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!L41="","",TEST!L41),VLOOKUP(A43,TEST!$AA$27:$AS$36,12)))
O44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!L42="","",TEST!L42),VLOOKUP(A44,TEST!$AA$27:$AS$36,12)))
O45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!L43="","",TEST!L43),VLOOKUP(A45,TEST!$AA$27:$AS$36,12)))
O46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!L44="","",TEST!L44),VLOOKUP(A46,TEST!$AA$27:$AS$36,12)))
O47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!L45="","",TEST!L45),VLOOKUP(A47,TEST!$AA$27:$AS$36,12)))
O48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!L46="","",TEST!L46),VLOOKUP(A48,TEST!$AA$27:$AS$36,12)))
O49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!L47="","",TEST!L47),VLOOKUP(A49,TEST!$AA$27:$AS$36,12)))
O50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!L48="","",TEST!L48),VLOOKUP(A50,TEST!$AA$27:$AS$36,12)))
O51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!L49="","",TEST!L49),VLOOKUP(A51,TEST!$AA$27:$AS$36,12)))
O52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!L50="","",TEST!L50),VLOOKUP(A52,TEST!$AA$27:$AS$36,12)))
O53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!L51="","",TEST!L51),VLOOKUP(A53,TEST!$AA$27:$AS$36,12)))
O54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!L52="","",TEST!L52),VLOOKUP(A54,TEST!$AA$27:$AS$36,12)))
P37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!M35="","",TEST!M35),VLOOKUP(A37,TEST!$AA$27:$AS$36,13)))
P38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!M36="","",TEST!M36),VLOOKUP(A38,TEST!$AA$27:$AS$36,13)))
P39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!M37="","",TEST!M37),VLOOKUP(A39,TEST!$AA$27:$AS$36,13)))
P40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!M38="","",TEST!M38),VLOOKUP(A40,TEST!$AA$27:$AS$36,13)))
P41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!M39="","",TEST!M39),VLOOKUP(A41,TEST!$AA$27:$AS$36,13)))
P42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!M40="","",TEST!M40),VLOOKUP(A42,TEST!$AA$27:$AS$36,13)))
P43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!M41="","",TEST!M41),VLOOKUP(A43,TEST!$AA$27:$AS$36,13)))
P44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!M42="","",TEST!M42),VLOOKUP(A44,TEST!$AA$27:$AS$36,13)))
P45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!M43="","",TEST!M43),VLOOKUP(A45,TEST!$AA$27:$AS$36,13)))
P46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!M44="","",TEST!M44),VLOOKUP(A46,TEST!$AA$27:$AS$36,13)))
P47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!M45="","",TEST!M45),VLOOKUP(A47,TEST!$AA$27:$AS$36,13)))
P48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!M46="","",TEST!M46),VLOOKUP(A48,TEST!$AA$27:$AS$36,13)))
P49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!M47="","",TEST!M47),VLOOKUP(A49,TEST!$AA$27:$AS$36,13)))
P50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!M48="","",TEST!M48),VLOOKUP(A50,TEST!$AA$27:$AS$36,13)))
P51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!M49="","",TEST!M49),VLOOKUP(A51,TEST!$AA$27:$AS$36,13)))
P52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!M50="","",TEST!M50),VLOOKUP(A52,TEST!$AA$27:$AS$36,13)))
P53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!M51="","",TEST!M51),VLOOKUP(A53,TEST!$AA$27:$AS$36,13)))
P54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!M52="","",TEST!M52),VLOOKUP(A54,TEST!$AA$27:$AS$36,13)))
Q37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!N35="","",TEST!N35),VLOOKUP(A37,TEST!$AA$27:$AS$36,14)))
Q38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!N36="","",TEST!N36),VLOOKUP(A38,TEST!$AA$27:$AS$36,14)))
Q39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!N37="","",TEST!N37),VLOOKUP(A39,TEST!$AA$27:$AS$36,14)))
Q40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!N38="","",TEST!N38),VLOOKUP(A40,TEST!$AA$27:$AS$36,14)))
Q41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!N39="","",TEST!N39),VLOOKUP(A41,TEST!$AA$27:$AS$36,14)))
Q42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!N40="","",TEST!N40),VLOOKUP(A42,TEST!$AA$27:$AS$36,14)))
Q43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!N41="","",TEST!N41),VLOOKUP(A43,TEST!$AA$27:$AS$36,14)))
Q44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!N42="","",TEST!N42),VLOOKUP(A44,TEST!$AA$27:$AS$36,14)))
Q45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!N43="","",TEST!N43),VLOOKUP(A45,TEST!$AA$27:$AS$36,14)))
Q46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!N44="","",TEST!N44),VLOOKUP(A46,TEST!$AA$27:$AS$36,14)))
Q47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!N45="","",TEST!N45),VLOOKUP(A47,TEST!$AA$27:$AS$36,14)))
Q48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!N46="","",TEST!N46),VLOOKUP(A48,TEST!$AA$27:$AS$36,14)))
Q49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!N47="","",TEST!N47),VLOOKUP(A49,TEST!$AA$27:$AS$36,14)))
Q50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!N48="","",TEST!N48),VLOOKUP(A50,TEST!$AA$27:$AS$36,14)))
Q51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!N49="","",TEST!N49),VLOOKUP(A51,TEST!$AA$27:$AS$36,14)))
Q52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!N50="","",TEST!N50),VLOOKUP(A52,TEST!$AA$27:$AS$36,14)))
Q53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!N51="","",TEST!N51),VLOOKUP(A53,TEST!$AA$27:$AS$36,14)))
Q54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!N52="","",TEST!N52),VLOOKUP(A54,TEST!$AA$27:$AS$36,14)))
R37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!O35="","",TEST!O35),VLOOKUP(A37,TEST!$AA$27:$AS$36,15)))
R38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!O36="","",TEST!O36),VLOOKUP(A38,TEST!$AA$27:$AS$36,15)))
R39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!O37="","",TEST!O37),VLOOKUP(A39,TEST!$AA$27:$AS$36,15)))
R40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!O38="","",TEST!O38),VLOOKUP(A40,TEST!$AA$27:$AS$36,15)))
R41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!O39="","",TEST!O39),VLOOKUP(A41,TEST!$AA$27:$AS$36,15)))
R42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!O40="","",TEST!O40),VLOOKUP(A42,TEST!$AA$27:$AS$36,15)))
R43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!O41="","",TEST!O41),VLOOKUP(A43,TEST!$AA$27:$AS$36,15)))
R44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!O42="","",TEST!O42),VLOOKUP(A44,TEST!$AA$27:$AS$36,15)))
R45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!O43="","",TEST!O43),VLOOKUP(A45,TEST!$AA$27:$AS$36,15)))
R46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!O44="","",TEST!O44),VLOOKUP(A46,TEST!$AA$27:$AS$36,15)))
R47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!O45="","",TEST!O45),VLOOKUP(A47,TEST!$AA$27:$AS$36,15)))
R48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!O46="","",TEST!O46),VLOOKUP(A48,TEST!$AA$27:$AS$36,15)))
R49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!O47="","",TEST!O47),VLOOKUP(A49,TEST!$AA$27:$AS$36,15)))
R50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!O48="","",TEST!O48),VLOOKUP(A50,TEST!$AA$27:$AS$36,15)))
R51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!O49="","",TEST!O49),VLOOKUP(A51,TEST!$AA$27:$AS$36,15)))
R52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!O50="","",TEST!O50),VLOOKUP(A52,TEST!$AA$27:$AS$36,15)))
R53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!O51="","",TEST!O51),VLOOKUP(A53,TEST!$AA$27:$AS$36,15)))
R54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!O52="","",TEST!O52),VLOOKUP(A54,TEST!$AA$27:$AS$36,15)))
S37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!P35="","",TEST!P35),VLOOKUP(A37,TEST!$AA$27:$AS$36,16)))
S38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!P36="","",TEST!P36),VLOOKUP(A38,TEST!$AA$27:$AS$36,16)))
S39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!P37="","",TEST!P37),VLOOKUP(A39,TEST!$AA$27:$AS$36,16)))
S40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!P38="","",TEST!P38),VLOOKUP(A40,TEST!$AA$27:$AS$36,16)))
S41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!P39="","",TEST!P39),VLOOKUP(A41,TEST!$AA$27:$AS$36,16)))
S42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!P40="","",TEST!P40),VLOOKUP(A42,TEST!$AA$27:$AS$36,16)))
S43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!P41="","",TEST!P41),VLOOKUP(A43,TEST!$AA$27:$AS$36,16)))
S44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!P42="","",TEST!P42),VLOOKUP(A44,TEST!$AA$27:$AS$36,16)))
S45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!P43="","",TEST!P43),VLOOKUP(A45,TEST!$AA$27:$AS$36,16)))
S46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!P44="","",TEST!P44),VLOOKUP(A46,TEST!$AA$27:$AS$36,16)))
S47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!P45="","",TEST!P45),VLOOKUP(A47,TEST!$AA$27:$AS$36,16)))
S48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!P46="","",TEST!P46),VLOOKUP(A48,TEST!$AA$27:$AS$36,16)))
S49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!P47="","",TEST!P47),VLOOKUP(A49,TEST!$AA$27:$AS$36,16)))
S50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!P48="","",TEST!P48),VLOOKUP(A50,TEST!$AA$27:$AS$36,16)))
S51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!P49="","",TEST!P49),VLOOKUP(A51,TEST!$AA$27:$AS$36,16)))
S52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!P50="","",TEST!P50),VLOOKUP(A52,TEST!$AA$27:$AS$36,16)))
S53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!P51="","",TEST!P51),VLOOKUP(A53,TEST!$AA$27:$AS$36,16)))
S54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!P52="","",TEST!P52),VLOOKUP(A54,TEST!$AA$27:$AS$36,16)))
T37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!Q35="","",TEST!Q35),VLOOKUP(A37,TEST!$AA$27:$AS$36,17)))
T38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!Q36="","",TEST!Q36),VLOOKUP(A38,TEST!$AA$27:$AS$36,17)))
T39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!Q37="","",TEST!Q37),VLOOKUP(A39,TEST!$AA$27:$AS$36,17)))
T40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!Q38="","",TEST!Q38),VLOOKUP(A40,TEST!$AA$27:$AS$36,17)))
T41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!Q39="","",TEST!Q39),VLOOKUP(A41,TEST!$AA$27:$AS$36,17)))
T42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!Q40="","",TEST!Q40),VLOOKUP(A42,TEST!$AA$27:$AS$36,17)))
T43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!Q41="","",TEST!Q41),VLOOKUP(A43,TEST!$AA$27:$AS$36,17)))
T44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!Q42="","",TEST!Q42),VLOOKUP(A44,TEST!$AA$27:$AS$36,17)))
T45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!Q43="","",TEST!Q43),VLOOKUP(A45,TEST!$AA$27:$AS$36,17)))
T46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!Q44="","",TEST!Q44),VLOOKUP(A46,TEST!$AA$27:$AS$36,17)))
T47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!Q45="","",TEST!Q45),VLOOKUP(A47,TEST!$AA$27:$AS$36,17)))
T48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!Q46="","",TEST!Q46),VLOOKUP(A48,TEST!$AA$27:$AS$36,17)))
T49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!Q47="","",TEST!Q47),VLOOKUP(A49,TEST!$AA$27:$AS$36,17)))
T50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!Q48="","",TEST!Q48),VLOOKUP(A50,TEST!$AA$27:$AS$36,17)))
T51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!Q49="","",TEST!Q49),VLOOKUP(A51,TEST!$AA$27:$AS$36,17)))
T52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!Q50="","",TEST!Q50),VLOOKUP(A52,TEST!$AA$27:$AS$36,17)))
T53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!Q51="","",TEST!Q51),VLOOKUP(A53,TEST!$AA$27:$AS$36,17)))
T54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!Q52="","",TEST!Q52),VLOOKUP(A54,TEST!$AA$27:$AS$36,17)))
U37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!R35="","",TEST!R35),VLOOKUP(A37,TEST!$AA$27:$AS$36,18)))
U38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!R36="","",TEST!R36),VLOOKUP(A38,TEST!$AA$27:$AS$36,18)))
U39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!R37="","",TEST!R37),VLOOKUP(A39,TEST!$AA$27:$AS$36,18)))
U40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!R38="","",TEST!R38),VLOOKUP(A40,TEST!$AA$27:$AS$36,18)))
U41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!R39="","",TEST!R39),VLOOKUP(A41,TEST!$AA$27:$AS$36,18)))
U42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!R40="","",TEST!R40),VLOOKUP(A42,TEST!$AA$27:$AS$36,18)))
U43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!R41="","",TEST!R41),VLOOKUP(A43,TEST!$AA$27:$AS$36,18)))
U44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!R42="","",TEST!R42),VLOOKUP(A44,TEST!$AA$27:$AS$36,18)))
U45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!R43="","",TEST!R43),VLOOKUP(A45,TEST!$AA$27:$AS$36,18)))
U46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!R44="","",TEST!R44),VLOOKUP(A46,TEST!$AA$27:$AS$36,18)))
U47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!R45="","",TEST!R45),VLOOKUP(A47,TEST!$AA$27:$AS$36,18)))
U48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!R46="","",TEST!R46),VLOOKUP(A48,TEST!$AA$27:$AS$36,18)))
U49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!R47="","",TEST!R47),VLOOKUP(A49,TEST!$AA$27:$AS$36,18)))
U50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!R48="","",TEST!R48),VLOOKUP(A50,TEST!$AA$27:$AS$36,18)))
U51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!R49="","",TEST!R49),VLOOKUP(A51,TEST!$AA$27:$AS$36,18)))
U52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!R50="","",TEST!R50),VLOOKUP(A52,TEST!$AA$27:$AS$36,18)))
U53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!R51="","",TEST!R51),VLOOKUP(A53,TEST!$AA$27:$AS$36,18)))
U54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!R52="","",TEST!R52),VLOOKUP(A54,TEST!$AA$27:$AS$36,18)))
V37	=IF(TEST!A35="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A35)=0,IF(TEST!S35="","",TEST!S35),VLOOKUP(A37,TEST!$AA$27:$AS$36,19)))
V38	=IF(TEST!A36="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A36)=0,IF(TEST!S36="","",TEST!S36),VLOOKUP(A38,TEST!$AA$27:$AS$36,19)))
V39	=IF(TEST!A37="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A37)=0,IF(TEST!S37="","",TEST!S37),VLOOKUP(A39,TEST!$AA$27:$AS$36,19)))
V40	=IF(TEST!A38="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A38)=0,IF(TEST!S38="","",TEST!S38),VLOOKUP(A40,TEST!$AA$27:$AS$36,19)))
V41	=IF(TEST!A39="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A39)=0,IF(TEST!S39="","",TEST!S39),VLOOKUP(A41,TEST!$AA$27:$AS$36,19)))
V42	=IF(TEST!A40="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A40)=0,IF(TEST!S40="","",TEST!S40),VLOOKUP(A42,TEST!$AA$27:$AS$36,19)))
V43	=IF(TEST!A41="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A41)=0,IF(TEST!S41="","",TEST!S41),VLOOKUP(A43,TEST!$AA$27:$AS$36,19)))
V44	=IF(TEST!A42="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A42)=0,IF(TEST!S42="","",TEST!S42),VLOOKUP(A44,TEST!$AA$27:$AS$36,19)))
V45	=IF(TEST!A43="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A43)=0,IF(TEST!S43="","",TEST!S43),VLOOKUP(A45,TEST!$AA$27:$AS$36,19)))
V46	=IF(TEST!A44="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A44)=0,IF(TEST!S44="","",TEST!S44),VLOOKUP(A46,TEST!$AA$27:$AS$36,19)))
V47	=IF(TEST!A45="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A45)=0,IF(TEST!S45="","",TEST!S45),VLOOKUP(A47,TEST!$AA$27:$AS$36,19)))
V48	=IF(TEST!A46="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A46)=0,IF(TEST!S46="","",TEST!S46),VLOOKUP(A48,TEST!$AA$27:$AS$36,19)))
V49	=IF(TEST!A47="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A47)=0,IF(TEST!S47="","",TEST!S47),VLOOKUP(A49,TEST!$AA$27:$AS$36,19)))
V50	=IF(TEST!A48="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A48)=0,IF(TEST!S48="","",TEST!S48),VLOOKUP(A50,TEST!$AA$27:$AS$36,19)))
V51	=IF(TEST!A49="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A49)=0,IF(TEST!S49="","",TEST!S49),VLOOKUP(A51,TEST!$AA$27:$AS$36,19)))
V52	=IF(TEST!A50="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A50)=0,IF(TEST!S50="","",TEST!S50),VLOOKUP(A52,TEST!$AA$27:$AS$36,19)))
V53	=IF(TEST!A51="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A51)=0,IF(TEST!S51="","",TEST!S51),VLOOKUP(A53,TEST!$AA$27:$AS$36,19)))
V54	=IF(TEST!A52="","",IF(COUNTIF(TEST!$Z$2:$Z$21,TEST!A52)=0,IF(TEST!S52="","",TEST!S52),VLOOKUP(A54,TEST!$AA$27:$AS$36,19)))

 

[Akuini]

Using 9522627V as example, then which row do you want to hide?

 

[Akuini]

This macro will make the duplicate row (in col A) turn yellow.
Then you can manually filter the data using Filter by Color > check No Fill.

Sub markDeDuplicate()
'https://www.mrexcel.com/forum/excel-questions/1013846-hide-dupilcate-range-but-leaving-original.html
Dim d As Object, x
Set d = CreateObject("scripting.dictionary")
For Each x In Range("A1", Cells(Rows.count, "A").End(xlUp))
    If Not d.Exists(x.Value) Then
    d(x.Value) = 1
    Else
    x.Interior.ColorIndex = 6 'yellow
    End If
Next
End Sub

I’m using part of your sample.

Book1
	A	B
1	A	B
2	1395298	Cab Bkts
3	1395298	Cab Bkts
4	1395299	Cab Bkts
5	1395299	Cab Bkts
6	1395300	Cab Bkts
7	1395300	Cab Bkts
8	1395301	Cab Bkts
9	1395301	Cab Bkts
10	51.08140-0222	MAN Bananas
11	9522627V	Shark Fins
12	9522627V	Shark Fins
Sheet3

After filtering

[TABLE="width: 240"]
<colgroup><col span="2"></colgroup><tbody>[TR]

Book1
	A	B
1	A	B
2	1395298	Cab Bkts
4	1395299	Cab Bkts
6	1395300	Cab Bkts
8	1395301	Cab Bkts
10	51.08140-0222	MAN Bananas
11	9522627V	Shark Fins
Sheet3

[/TR]
[TR]
[TD="align: right"]1395298[/TD]
[TD]Cab Bkts[/TD]
[/TR]
[TR]
[TD="align: right"]1395299[/TD]
[TD]Cab Bkts[/TD]
[/TR]
[TR]
[TD="align: right"]1395300[/TD]
[TD]Cab Bkts[/TD]
[/TR]
[TR]
[TD="align: right"]1395301[/TD]
[TD]Cab Bkts[/TD]
[/TR]
[TR]
[TD]51.08140-0222[/TD]
[TD]MAN Bananas[/TD]
[/TR]
[TR]
[TD]9522627V[/TD]
[TD]Shark Fins
[/TD]
[/TR]
</tbody>[/TABLE]

 

[picklefactory]

Hi Akuini
Either, it doesn't matter as they are both the same, but I don't want any manual intervention. The existing wb is extremely manual, my task is to remove all the manual elements.
Thanks

 

[picklefactory]

But you've possibly given me the answer, I just swapped your colour change for hide row, I think I can work with that, especially if I add unhide all initially, to clear any previously hidden rows. I'll play with that now.
Thank you

Sub markDeDuplicate()
'https://www.mrexcel.com/forum/excel-questions/1013846-hide-dupilcate-range-but-leaving-original.html
Dim d As Object, x
Set d = CreateObject("scripting.dictionary")
For Each x In Range("A1", Cells(Rows.Count, "A").End(xlUp))
    If Not d.Exists(x.Value) Then
    d(x.Value) = 1
    Else
    x.EntireRow.Hidden = True
    End If
Next
End Sub

 

[Akuini]

Ah, you're right, that's more simple.
Glad you figured it out.
Cheers