Simplify Formulas - Fantasy Football Draft Sheet

M

michael88

New Member
Joined
Aug 25, 2015
Messages
8
Hi everyone,

I created a fantasy football sheet to assist with my upcoming draft. Everything works fine, but it is super slow. There is a lot going on in the sheet and I was hoping there might be some simpler formulas that could speed up the processing. I can't seem to attach the sheet, so I'll try and do my best to breakdown the formulas below:

Formula 1: The formula below is used to see how many players at the QB position were drafted by a certain team. This is repeated for RB, WR, TE, K, and DEF for all 10 teams in the league.

=SUM(IFERROR(VLOOKUP($B$2,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$3,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$4,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$5,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$6,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$7,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$8,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$9,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$10,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$11,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$12,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$13,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$14,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$15,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$16,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$17,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$18,QB!$D:$E,2,FALSE),0))

Basically, it is looking up a value of 1 for each draft slot for each team if the players name drafted matched a player on the QB sheet.

Formula 2: If a player is drafted, they are assigned a value of 1 in their respective tab (QB,RB,WR,TE,K,DEF). This shows the next best player at their position in terms of highest points.

{=MAX(IF(QB!$X:$X=1,,QB!$S:$S))}

Formula 3: This formula shows the % dropoff from the best player available at the position the the 2nd best player. This is continued to the 10th best player.

{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),2))/$D$30}

These are the three main formulas taking up a bunch of processing power.

I'd really appreciate it if you could take a look and offer advice.

Thanks,

Mike
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Sort by date Sort by votes
I'm nowhere near smart enough to figure out all that without some data in Excel. Please use the Excel HTML add-in to give us data; you can find it in the link in my signature below.
 
Upvote 0
Here is one of the formulas. It is looking in B2-B18 and matching up with a list of QBs in the QB tab.

Excel 2010
AB
1Team #1
2Round 11
3Round 220
4Round 321
5Round 440
6Round 541
7Round 660
8Round 761
9Round 880
10Round 981
11Round 10100
12Round 11101
13Round 12120
14Round 13121
15Round 14140
16Round 15141
17Round 16160
18Round 17161
19
20
21
22QB0
23RB0
24WR0
25TE0
26K0
27DEF0

<tbody>
</tbody>
Draft Sheet​

Worksheet Formulas
CellFormula
B22=SUM(IFERROR(VLOOKUP($B$2,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$3,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$4,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$5,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$6,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$7,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$8,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$9,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$10,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$11,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$12,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$13,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$14,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$15,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$16,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$17,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$18,QB!$D:$E,2,FALSE),0))
B23=SUM(IFERROR(VLOOKUP($B$2,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$3,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$4,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$5,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$6,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$7,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$8,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$9,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$10,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$11,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$12,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$13,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$14,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$15,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$16,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$17,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$18,RB!$D:$E,2,FALSE),0))
B24=SUM(IFERROR(VLOOKUP($B$2,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$3,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$4,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$5,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$6,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$7,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$8,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$9,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$10,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$11,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$12,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$13,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$14,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$15,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$16,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$17,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$18,WR!$D:$E,2,FALSE),0))
B25=SUM(IFERROR(VLOOKUP($B$2,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$3,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$4,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$5,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$6,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$7,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$8,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$9,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$10,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$11,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$12,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$13,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$14,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$15,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$16,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$17,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$18,TE!$D:$E,2,FALSE),0))
B26=SUM(IFERROR(VLOOKUP($B$2,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$3,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$4,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$5,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$6,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$7,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$8,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$9,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$10,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$11,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$12,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$13,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$14,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$15,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$16,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$17,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$18,K!$D:$E,2,FALSE),0))
B27=SUM(IFERROR(VLOOKUP($B$2,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$3,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$4,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$5,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$6,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$7,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$8,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$9,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$10,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$11,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$12,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$13,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$14,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$15,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$16,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$17,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$18,DEF!$C:$D,2,FALSE),0))

<tbody>
</tbody>

<tbody>
</tbody>


This is from the QB tab
Excel 2010
ABCDEFGHIJKLMNOPQRSTUVWXY
3RkRkOvr$PlayerTmByeGPYdsPTDsIntRYdsRTDs300+ADPTDOPPRFPNEW
422026Andrew Luck1IND10164822381222121019.612123993993470Andrew Luck

<tbody>
</tbody>
QB​

Worksheet Formulas
CellFormula
X4=COUNTIF('Draft Sheet'!$B$2:$K$18,D4)
Y4=D4

<tbody>
</tbody>

<tbody>
</tbody>
 
Upvote 0
These are the other formulas that show the next best players. It references the same QB tab above.

Excel 2010
ABCDEFGHIJKLM
29PlayerBye WeekPointsVariance to 2nd BPVariance to 3rd BPVariance to 4th BPVariance to 5th BPVariance to 6th BPVariance to 7th BPVariance to 8th BPVariance to 9th BPVariance to 10th BP
30BR QBAndrew Luck10 346.98 3.59%4.45%11.49%11.74%14.26%15.38%17.76%18.43%20.15%

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Draft Sheet​

Worksheet Formulas
CellFormula
B30=INDEX(QB!$D:$D,MATCH('Draft Sheet'!D30,QB!S:S,0))
C30=INDEX(QB!$G:$G,MATCH('Draft Sheet'!B30,QB!D:D,0))

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>

Array Formulas
CellFormula
D30{=MAX(IF(QB!$X:$X=1,,QB!$S:$S))}
E30{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),2))/$D$30}
F30{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),3))/$D$30}
G30{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),4))/$D$30}
H30{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),5))/$D$30}
I30{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),6))/$D$30}
J30{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),7))/$D$30}
K30{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),8))/$D$30}
L30{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),9))/$D$30}
M30{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),10))/$D$30}

<thead>
</thead><tbody>
</tbody>
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>
 
Upvote 0
This is the whole main sheet.

Excel 2010
ABCDEFGHIJKLM
1Team #1Team #2Team #3Team #4Team #5Team #6Team #7Team #8Team #9Team #10
2Round 112345678910
3Round 220191817161514131211
4Round 321222324252627282930
5Round 440393837363534333231
6Round 541424344454647484950
7Round 660595857565554535251
8Round 761626364656667686970
9Round 880797877767574737271
10Round 981828384858687888990
11Round 10100999897969594939291
12Round 11101102103104105106107108109110
13Round 12120119118117116115114113112111
14Round 13121122123124125126127128129130
15Round 14140139138137136135134133132131
16Round 15141142143144145146147148149150
17Round 16160159158157156155154153152151
18Round 17161162163164165166167168169170
19
20
21Team #2Team #3Team #4Team #5Team #6Team #7Team #8Team #9Team #10TOTAL Drafted
22QB00000000000
23RB00000000000
24WR00000000000
25TE00000000000
26K00000000000
27DEF00000000000
28
29PlayerBye WeekPointsVariance to 2nd BPVariance to 3rd BPVariance to 4th BPVariance to 5th BPVariance to 6th BPVariance to 7th BPVariance to 8th BPVariance to 9th BPVariance to 10th BP
30BR QBAndrew Luck10 346.98 3.59%4.45%11.49%11.74%14.26%15.38%17.76%18.43%20.15%
31BR RBLe'Veon Bell11 298.40 5.70%8.68%10.09%15.11%15.35%15.99%22.22%23.53%24.63%
32BR WRDemaryius Thomas7 284.00 0.32%1.97%4.54%6.34%12.61%13.35%20.81%21.48%22.01%
33BR TERob Gronkowski4 255.50 26.65%32.05%39.33%39.41%41.68%45.01%45.13%47.01%49.20%
34BR KStephen Gostkowski4 169.00 5.33%5.92%6.51%9.47%10.06%10.65%13.02%14.79%15.38%
35BR DEFSeattle Seahawks9 164.00 4.88%6.10%7.32%8.54%9.15%10.37%10.98%23.78%29.88%

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Draft Sheet​

Worksheet Formulas
CellFormula
C21=C1
D21=D1
E21=E1
F21=F1
G21=G1
H21=H1
I21=I1
J21=J1
K21=K1
B22=SUM(IFERROR(VLOOKUP($B$2,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$3,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$4,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$5,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$6,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$7,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$8,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$9,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$10,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$11,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$12,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$13,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$14,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$15,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$16,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$17,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$18,QB!$D:$E,2,FALSE),0))
C22=SUM(IFERROR(VLOOKUP($C$2,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$3,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$4,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$5,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$6,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$7,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$8,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$9,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$10,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$11,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$12,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$13,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$14,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$15,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$16,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$17,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$18,QB!$D:$E,2,FALSE),0))
D22=SUM(IFERROR(VLOOKUP($D$2,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$3,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$4,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$5,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$6,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$7,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$8,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$9,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$10,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$11,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$12,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$13,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$14,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$15,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$16,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$17,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$18,QB!$D:$E,2,FALSE),0))
E22=SUM(IFERROR(VLOOKUP($E$2,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$3,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$4,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$5,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$6,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$7,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$8,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$9,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$10,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$11,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$12,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$13,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$14,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$15,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$16,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$17,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$18,QB!$D:$E,2,FALSE),0))
F22=SUM(IFERROR(VLOOKUP($F$2,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$3,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$4,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$5,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$6,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$7,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$8,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$9,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$10,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$11,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$12,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$13,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$14,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$15,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$16,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$17,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$18,QB!$D:$E,2,FALSE),0))
G22=SUM(IFERROR(VLOOKUP($G$2,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$3,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$4,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$5,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$6,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$7,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$8,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$9,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$10,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$11,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$12,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$13,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$14,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$15,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$16,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$17,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$18,QB!$D:$E,2,FALSE),0))
H22=SUM(IFERROR(VLOOKUP($H$2,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$3,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$4,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$5,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$6,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$7,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$8,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$9,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$10,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$11,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$12,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$13,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$14,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$15,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$16,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$17,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$18,QB!$D:$E,2,FALSE),0))
I22=SUM(IFERROR(VLOOKUP($I$2,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$3,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$4,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$5,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$6,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$7,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$8,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$9,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$10,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$11,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$12,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$13,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$14,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$15,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$16,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$17,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$18,QB!$D:$E,2,FALSE),0))
J22=SUM(IFERROR(VLOOKUP($J$2,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$3,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$4,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$5,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$6,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$7,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$8,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$9,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$10,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$11,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$12,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$13,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$14,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$15,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$16,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$17,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$18,QB!$D:$E,2,FALSE),0))
K22=SUM(IFERROR(VLOOKUP($K$2,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$3,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$4,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$5,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$6,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$7,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$8,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$9,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$10,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$11,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$12,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$13,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$14,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$15,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$16,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$17,QB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$18,QB!$D:$E,2,FALSE),0))
L22=SUM(B22:K22)
B23=SUM(IFERROR(VLOOKUP($B$2,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$3,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$4,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$5,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$6,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$7,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$8,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$9,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$10,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$11,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$12,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$13,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$14,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$15,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$16,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$17,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$18,RB!$D:$E,2,FALSE),0))
C23=SUM(IFERROR(VLOOKUP($C$2,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$3,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$4,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$5,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$6,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$7,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$8,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$9,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$10,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$11,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$12,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$13,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$14,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$15,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$16,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$17,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$18,RB!$D:$E,2,FALSE),0))
D23=SUM(IFERROR(VLOOKUP($D$2,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$3,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$4,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$5,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$6,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$7,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$8,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$9,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$10,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$11,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$12,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$13,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$14,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$15,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$16,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$17,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$18,RB!$D:$E,2,FALSE),0))
E23=SUM(IFERROR(VLOOKUP($E$2,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$3,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$4,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$5,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$6,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$7,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$8,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$9,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$10,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$11,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$12,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$13,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$14,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$15,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$16,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$17,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$18,RB!$D:$E,2,FALSE),0))
F23=SUM(IFERROR(VLOOKUP($F$2,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$3,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$4,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$5,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$6,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$7,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$8,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$9,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$10,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$11,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$12,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$13,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$14,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$15,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$16,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$17,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$18,RB!$D:$E,2,FALSE),0))
G23=SUM(IFERROR(VLOOKUP($G$2,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$3,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$4,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$5,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$6,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$7,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$8,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$9,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$10,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$11,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$12,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$13,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$14,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$15,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$16,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$17,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$18,RB!$D:$E,2,FALSE),0))
H23=SUM(IFERROR(VLOOKUP($H$2,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$3,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$4,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$5,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$6,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$7,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$8,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$9,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$10,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$11,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$12,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$13,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$14,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$15,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$16,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$17,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$18,RB!$D:$E,2,FALSE),0))
I23=SUM(IFERROR(VLOOKUP($I$2,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$3,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$4,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$5,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$6,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$7,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$8,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$9,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$10,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$11,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$12,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$13,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$14,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$15,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$16,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$17,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$18,RB!$D:$E,2,FALSE),0))
J23=SUM(IFERROR(VLOOKUP($J$2,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$3,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$4,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$5,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$6,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$7,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$8,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$9,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$10,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$11,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$12,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$13,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$14,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$15,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$16,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$17,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$18,RB!$D:$E,2,FALSE),0))
K23=SUM(IFERROR(VLOOKUP($K$2,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$3,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$4,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$5,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$6,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$7,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$8,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$9,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$10,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$11,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$12,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$13,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$14,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$15,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$16,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$17,RB!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$18,RB!$D:$E,2,FALSE),0))
L23=SUM(B23:K23)
B24=SUM(IFERROR(VLOOKUP($B$2,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$3,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$4,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$5,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$6,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$7,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$8,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$9,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$10,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$11,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$12,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$13,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$14,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$15,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$16,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$17,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$18,WR!$D:$E,2,FALSE),0))
C24=SUM(IFERROR(VLOOKUP($C$2,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$3,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$4,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$5,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$6,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$7,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$8,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$9,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$10,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$11,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$12,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$13,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$14,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$15,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$16,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$17,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$18,WR!$D:$E,2,FALSE),0))
D24=SUM(IFERROR(VLOOKUP($D$2,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$3,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$4,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$5,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$6,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$7,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$8,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$9,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$10,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$11,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$12,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$13,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$14,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$15,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$16,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$17,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$18,WR!$D:$E,2,FALSE),0))
E24=SUM(IFERROR(VLOOKUP($E$2,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$3,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$4,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$5,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$6,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$7,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$8,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$9,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$10,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$11,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$12,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$13,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$14,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$15,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$16,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$17,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$18,WR!$D:$E,2,FALSE),0))
F24=SUM(IFERROR(VLOOKUP($F$2,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$3,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$4,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$5,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$6,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$7,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$8,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$9,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$10,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$11,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$12,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$13,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$14,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$15,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$16,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$17,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$18,WR!$D:$E,2,FALSE),0))
G24=SUM(IFERROR(VLOOKUP($G$2,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$3,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$4,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$5,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$6,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$7,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$8,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$9,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$10,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$11,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$12,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$13,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$14,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$15,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$16,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$17,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$18,WR!$D:$E,2,FALSE),0))
H24=SUM(IFERROR(VLOOKUP($H$2,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$3,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$4,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$5,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$6,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$7,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$8,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$9,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$10,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$11,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$12,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$13,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$14,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$15,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$16,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$17,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$18,WR!$D:$E,2,FALSE),0))
I24=SUM(IFERROR(VLOOKUP($I$2,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$3,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$4,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$5,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$6,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$7,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$8,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$9,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$10,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$11,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$12,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$13,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$14,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$15,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$16,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$17,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$18,WR!$D:$E,2,FALSE),0))
J24=SUM(IFERROR(VLOOKUP($J$2,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$3,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$4,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$5,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$6,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$7,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$8,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$9,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$10,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$11,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$12,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$13,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$14,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$15,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$16,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$17,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$18,WR!$D:$E,2,FALSE),0))
K24=SUM(IFERROR(VLOOKUP($K$2,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$3,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$4,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$5,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$6,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$7,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$8,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$9,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$10,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$11,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$12,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$13,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$14,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$15,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$16,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$17,WR!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$18,WR!$D:$E,2,FALSE),0))
L24=SUM(B24:K24)
B25=SUM(IFERROR(VLOOKUP($B$2,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$3,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$4,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$5,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$6,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$7,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$8,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$9,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$10,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$11,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$12,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$13,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$14,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$15,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$16,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$17,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$18,TE!$D:$E,2,FALSE),0))
C25=SUM(IFERROR(VLOOKUP($C$2,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$3,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$4,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$5,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$6,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$7,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$8,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$9,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$10,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$11,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$12,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$13,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$14,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$15,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$16,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$17,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$18,TE!$D:$E,2,FALSE),0))
D25=SUM(IFERROR(VLOOKUP($D$2,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$3,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$4,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$5,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$6,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$7,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$8,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$9,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$10,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$11,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$12,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$13,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$14,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$15,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$16,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$17,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$18,TE!$D:$E,2,FALSE),0))
E25=SUM(IFERROR(VLOOKUP($E$2,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$3,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$4,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$5,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$6,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$7,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$8,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$9,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$10,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$11,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$12,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$13,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$14,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$15,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$16,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$17,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$18,TE!$D:$E,2,FALSE),0))
F25=SUM(IFERROR(VLOOKUP($F$2,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$3,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$4,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$5,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$6,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$7,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$8,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$9,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$10,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$11,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$12,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$13,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$14,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$15,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$16,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$17,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$18,TE!$D:$E,2,FALSE),0))
G25=SUM(IFERROR(VLOOKUP($G$2,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$3,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$4,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$5,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$6,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$7,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$8,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$9,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$10,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$11,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$12,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$13,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$14,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$15,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$16,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$17,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$18,TE!$D:$E,2,FALSE),0))
H25=SUM(IFERROR(VLOOKUP($H$2,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$3,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$4,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$5,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$6,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$7,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$8,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$9,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$10,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$11,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$12,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$13,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$14,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$15,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$16,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$17,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$18,TE!$D:$E,2,FALSE),0))
I25=SUM(IFERROR(VLOOKUP($I$2,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$3,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$4,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$5,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$6,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$7,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$8,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$9,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$10,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$11,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$12,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$13,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$14,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$15,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$16,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$17,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$18,TE!$D:$E,2,FALSE),0))
J25=SUM(IFERROR(VLOOKUP($J$2,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$3,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$4,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$5,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$6,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$7,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$8,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$9,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$10,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$11,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$12,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$13,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$14,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$15,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$16,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$17,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$18,TE!$D:$E,2,FALSE),0))
K25=SUM(IFERROR(VLOOKUP($K$2,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$3,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$4,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$5,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$6,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$7,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$8,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$9,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$10,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$11,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$12,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$13,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$14,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$15,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$16,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$17,TE!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$18,TE!$D:$E,2,FALSE),0))
L25=SUM(B25:K25)
B26=SUM(IFERROR(VLOOKUP($B$2,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$3,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$4,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$5,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$6,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$7,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$8,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$9,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$10,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$11,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$12,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$13,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$14,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$15,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$16,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$17,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($B$18,K!$D:$E,2,FALSE),0))
C26=SUM(IFERROR(VLOOKUP($C$2,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$3,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$4,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$5,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$6,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$7,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$8,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$9,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$10,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$11,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$12,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$13,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$14,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$15,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$16,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$17,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($C$18,K!$D:$E,2,FALSE),0))
D26=SUM(IFERROR(VLOOKUP($D$2,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$3,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$4,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$5,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$6,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$7,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$8,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$9,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$10,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$11,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$12,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$13,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$14,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$15,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$16,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$17,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($D$18,K!$D:$E,2,FALSE),0))
E26=SUM(IFERROR(VLOOKUP($E$2,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$3,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$4,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$5,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$6,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$7,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$8,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$9,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$10,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$11,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$12,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$13,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$14,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$15,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$16,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$17,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($E$18,K!$D:$E,2,FALSE),0))
F26=SUM(IFERROR(VLOOKUP($F$2,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$3,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$4,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$5,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$6,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$7,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$8,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$9,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$10,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$11,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$12,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$13,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$14,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$15,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$16,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$17,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($F$18,K!$D:$E,2,FALSE),0))
G26=SUM(IFERROR(VLOOKUP($G$2,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$3,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$4,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$5,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$6,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$7,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$8,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$9,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$10,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$11,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$12,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$13,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$14,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$15,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$16,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$17,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($G$18,K!$D:$E,2,FALSE),0))
H26=SUM(IFERROR(VLOOKUP($H$2,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$3,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$4,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$5,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$6,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$7,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$8,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$9,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$10,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$11,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$12,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$13,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$14,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$15,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$16,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$17,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($H$18,K!$D:$E,2,FALSE),0))
I26=SUM(IFERROR(VLOOKUP($I$2,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$3,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$4,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$5,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$6,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$7,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$8,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$9,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$10,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$11,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$12,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$13,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$14,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$15,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$16,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$17,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($I$18,K!$D:$E,2,FALSE),0))
J26=SUM(IFERROR(VLOOKUP($J$2,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$3,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$4,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$5,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$6,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$7,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$8,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$9,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$10,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$11,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$12,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$13,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$14,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$15,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$16,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$17,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($J$18,K!$D:$E,2,FALSE),0))
K26=SUM(IFERROR(VLOOKUP($K$2,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$3,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$4,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$5,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$6,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$7,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$8,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$9,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$10,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$11,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$12,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$13,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$14,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$15,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$16,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$17,K!$D:$E,2,FALSE),0),IFERROR(VLOOKUP($K$18,K!$D:$E,2,FALSE),0))
L26=SUM(B26:K26)
B27=SUM(IFERROR(VLOOKUP($B$2,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$3,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$4,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$5,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$6,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$7,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$8,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$9,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$10,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$11,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$12,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$13,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$14,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$15,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$16,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$17,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($B$18,DEF!$C:$D,2,FALSE),0))
C27=SUM(IFERROR(VLOOKUP($C$2,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($C$3,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($C$4,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($C$5,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($C$6,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($C$7,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($C$8,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($C$9,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($C$10,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($C$11,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($C$12,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($C$13,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($C$14,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($C$15,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($C$16,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($C$17,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($C$18,DEF!$C:$D,2,FALSE),0))
D27=SUM(IFERROR(VLOOKUP($D$2,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($D$3,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($D$4,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($D$5,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($D$6,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($D$7,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($D$8,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($D$9,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($D$10,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($D$11,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($D$12,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($D$13,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($D$14,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($D$15,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($D$16,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($D$17,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($D$18,DEF!$C:$D,2,FALSE),0))
E27=SUM(IFERROR(VLOOKUP($E$2,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($E$3,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($E$4,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($E$5,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($E$6,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($E$7,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($E$8,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($E$9,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($E$10,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($E$11,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($E$12,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($E$13,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($E$14,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($E$15,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($E$16,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($E$17,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($E$18,DEF!$C:$D,2,FALSE),0))
F27=SUM(IFERROR(VLOOKUP($F$2,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($F$3,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($F$4,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($F$5,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($F$6,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($F$7,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($F$8,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($F$9,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($F$10,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($F$11,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($F$12,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($F$13,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($F$14,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($F$15,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($F$16,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($F$17,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($F$18,DEF!$C:$D,2,FALSE),0))
G27=SUM(IFERROR(VLOOKUP($G$2,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($G$3,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($G$4,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($G$5,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($G$6,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($G$7,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($G$8,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($G$9,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($G$10,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($G$11,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($G$12,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($G$13,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($G$14,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($G$15,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($G$16,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($G$17,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($G$18,DEF!$C:$D,2,FALSE),0))
H27=SUM(IFERROR(VLOOKUP($H$2,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($H$3,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($H$4,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($H$5,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($H$6,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($H$7,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($H$8,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($H$9,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($H$10,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($H$11,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($H$12,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($H$13,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($H$14,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($H$15,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($H$16,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($H$17,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($H$18,DEF!$C:$D,2,FALSE),0))
I27=SUM(IFERROR(VLOOKUP($I$2,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($I$3,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($I$4,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($I$5,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($I$6,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($I$7,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($I$8,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($I$9,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($I$10,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($I$11,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($I$12,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($I$13,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($I$14,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($I$15,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($I$16,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($I$17,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($I$18,DEF!$C:$D,2,FALSE),0))
J27=SUM(IFERROR(VLOOKUP($J$2,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($J$3,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($J$4,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($J$5,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($J$6,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($J$7,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($J$8,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($J$9,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($J$10,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($J$11,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($J$12,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($J$13,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($J$14,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($J$15,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($J$16,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($J$17,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($J$18,DEF!$C:$D,2,FALSE),0))
K27=SUM(IFERROR(VLOOKUP($K$2,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($K$3,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($K$4,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($K$5,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($K$6,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($K$7,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($K$8,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($K$9,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($K$10,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($K$11,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($K$12,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($K$13,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($K$14,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($K$15,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($K$16,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($K$17,DEF!$C:$D,2,FALSE),0),IFERROR(VLOOKUP($K$18,DEF!$C:$D,2,FALSE),0))
L27=SUM(B27:K27)
B30=INDEX(QB!$D:$D,MATCH('Draft Sheet'!D30,QB!S:S,0))
C30=INDEX(QB!$G:$G,MATCH('Draft Sheet'!B30,QB!D:D,0))
B31=INDEX(RB!$D:$D,MATCH('Draft Sheet'!D31,RB!V:V,0))
C31=INDEX(RB!$G:$G,MATCH('Draft Sheet'!B31,RB!D:D,0))
B32=INDEX(WR!$D:$D,MATCH('Draft Sheet'!D32,WR!V:V,0))
C32=INDEX(WR!$G:$G,MATCH('Draft Sheet'!B32,WR!D:D,0))
B33=INDEX(TE!$D:$D,MATCH('Draft Sheet'!D33,TE!V:V,0))
C33=INDEX(TE!$G:$G,MATCH('Draft Sheet'!B33,TE!D:D,0))
B34=INDEX(K!$D:$D,MATCH('Draft Sheet'!D34,K!S:S,0))
C34=INDEX(K!$G:$G,MATCH('Draft Sheet'!B34,K!D:D,0))
B35=INDEX(DEF!$C:$C,MATCH('Draft Sheet'!D35,DEF!M:M,0))
C35=INDEX(DEF!$E:$E,MATCH('Draft Sheet'!B35,DEF!C:C,0))

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>

Array Formulas
CellFormula
D30{=MAX(IF(QB!$X:$X=1,,QB!$S:$S))}
E30{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),2))/$D$30}
F30{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),3))/$D$30}
G30{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),4))/$D$30}
H30{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),5))/$D$30}
I30{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),6))/$D$30}
J30{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),7))/$D$30}
K30{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),8))/$D$30}
L30{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),9))/$D$30}
M30{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),10))/$D$30}
D31{=MAX(IF(RB!$X:$X=1,,RB!$V:$V))}
E31{=($D$31-LARGE(IF(RB!$X:$X=1,,RB!$V:$V),2))/$D$31}
F31{=($D$31-LARGE(IF(RB!$X:$X=1,,RB!$V:$V),3))/$D$31}
G31{=($D$31-LARGE(IF(RB!$X:$X=1,,RB!$V:$V),4))/$D$31}
H31{=($D$31-LARGE(IF(RB!$X:$X=1,,RB!$V:$V),5))/$D$31}
I31{=($D$31-LARGE(IF(RB!$X:$X=1,,RB!$V:$V),6))/$D$31}
J31{=($D$31-LARGE(IF(RB!$X:$X=1,,RB!$V:$V),7))/$D$31}
K31{=($D$31-LARGE(IF(RB!$X:$X=1,,RB!$V:$V),8))/$D$31}
L31{=($D$31-LARGE(IF(RB!$X:$X=1,,RB!$V:$V),9))/$D$31}
M31{=($D$31-LARGE(IF(RB!$X:$X=1,,RB!$V:$V),10))/$D$31}
D32{=MAX(IF(WR!$X:$X=1,,WR!$V:$V))}
E32{=($D$32-LARGE(IF(WR!$X:$X=1,,WR!$V:$V),2))/$D$32}
F32{=($D$32-LARGE(IF(WR!$X:$X=1,,WR!$V:$V),3))/$D$32}
G32{=($D$32-LARGE(IF(WR!$X:$X=1,,WR!$V:$V),4))/$D$32}
H32{=($D$32-LARGE(IF(WR!$X:$X=1,,WR!$V:$V),5))/$D$32}
I32{=($D$32-LARGE(IF(WR!$X:$X=1,,WR!$V:$V),6))/$D$32}
J32{=($D$32-LARGE(IF(WR!$X:$X=1,,WR!$V:$V),7))/$D$32}
K32{=($D$32-LARGE(IF(WR!$X:$X=1,,WR!$V:$V),8))/$D$32}
L32{=($D$32-LARGE(IF(WR!$X:$X=1,,WR!$V:$V),9))/$D$32}
M32{=($D$32-LARGE(IF(WR!$X:$X=1,,WR!$V:$V),10))/$D$32}
D33{=MAX(IF(TE!$X:$X=1,,TE!$V:$V))}
E33{=($D$33-LARGE(IF(TE!$X:$X=1,,TE!$V:$V),2))/$D$33}
F33{=($D$33-LARGE(IF(TE!$X:$X=1,,TE!$V:$V),3))/$D$33}
G33{=($D$33-LARGE(IF(TE!$X:$X=1,,TE!$V:$V),4))/$D$33}
H33{=($D$33-LARGE(IF(TE!$X:$X=1,,TE!$V:$V),5))/$D$33}
I33{=($D$33-LARGE(IF(TE!$X:$X=1,,TE!$V:$V),6))/$D$33}
J33{=($D$33-LARGE(IF(TE!$X:$X=1,,TE!$V:$V),7))/$D$33}
K33{=($D$33-LARGE(IF(TE!$X:$X=1,,TE!$V:$V),8))/$D$33}
L33{=($D$33-LARGE(IF(TE!$X:$X=1,,TE!$V:$V),9))/$D$33}
M33{=($D$33-LARGE(IF(TE!$X:$X=1,,TE!$V:$V),10))/$D$33}
D34{=MAX(IF(K!$X:$X=1,,K!$S:$S))}
E34{=($D$34-LARGE(IF(K!$X:$X=1,,K!$S:$S),2))/$D$34}
F34{=($D$34-LARGE(IF(K!$X:$X=1,,K!$S:$S),3))/$D$34}
G34{=($D$34-LARGE(IF(K!$X:$X=1,,K!$S:$S),4))/$D$34}
H34{=($D$34-LARGE(IF(K!$X:$X=1,,K!$S:$S),5))/$D$34}
I34{=($D$34-LARGE(IF(K!$X:$X=1,,K!$S:$S),6))/$D$34}
J34{=($D$34-LARGE(IF(K!$X:$X=1,,K!$S:$S),7))/$D$34}
K34{=($D$34-LARGE(IF(K!$X:$X=1,,K!$S:$S),8))/$D$34}
L34{=($D$34-LARGE(IF(K!$X:$X=1,,K!$S:$S),9))/$D$34}
M34{=($D$34-LARGE(IF(K!$X:$X=1,,K!$S:$S),10))/$D$34}
D35{=MAX(IF(DEF!$X:$X=1,,DEF!$M:$M))}
E35{=($D$35-LARGE(IF(DEF!$X:$X=1,,DEF!$M:$M),2))/$D$35}
F35{=($D$35-LARGE(IF(DEF!$X:$X=1,,DEF!$M:$M),3))/$D$35}
G35{=($D$35-LARGE(IF(DEF!$X:$X=1,,DEF!$M:$M),4))/$D$35}
H35{=($D$35-LARGE(IF(DEF!$X:$X=1,,DEF!$M:$M),5))/$D$35}
I35{=($D$35-LARGE(IF(DEF!$X:$X=1,,DEF!$M:$M),6))/$D$35}
J35{=($D$35-LARGE(IF(DEF!$X:$X=1,,DEF!$M:$M),7))/$D$35}
K35{=($D$35-LARGE(IF(DEF!$X:$X=1,,DEF!$M:$M),8))/$D$35}
L35{=($D$35-LARGE(IF(DEF!$X:$X=1,,DEF!$M:$M),9))/$D$35}
M35{=($D$35-LARGE(IF(DEF!$X:$X=1,,DEF!$M:$M),10))/$D$35}

<thead>
</thead><tbody>
</tbody>
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>
 
Upvote 0
You must log in or register to reply here.

Similar threads

gtd526
  • Question
search and answer only ODD rows
Replies
6
Views
150
gtd526
gtd526
VinceF
  • Question
VBA To Copy & Paste Value
Replies
0
Views
167
VinceF
VinceF
I
  • Question
VBA to remove formulas with values causing wrong calculations
2
Replies
12
Views
307
Peter_SSs
Peter_SSs
L
  • Solved
Help with IF Formula for my Data.
Replies
5
Views
360
Lukma
L
L
  • Solved
Formula in the helper column. need duplicate to be count as One
Replies
7
Views
177
KRice
K

Forum statistics

Threads
1,215,242
Messages
6,123,830
Members
449,127
Latest member
Cyko

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top