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
 
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
Team #1
Round 1
Round 2
Round 3
Round 4
Round 5
Round 6
Round 7
Round 8
Round 9
Round 10
Round 11
Round 12
Round 13
Round 14
Round 15
Round 16
Round 17
QB
RB
WR
TE
K
DEF

<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]1[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]20[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]21[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]40[/TD]

[TD="align: center"]6[/TD]

[TD="align: center"]41[/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]60[/TD]

[TD="align: center"]8[/TD]

[TD="align: center"]61[/TD]

[TD="align: center"]9[/TD]

[TD="align: center"]80[/TD]

[TD="align: center"]10[/TD]

[TD="align: center"]81[/TD]

[TD="align: center"]11[/TD]

[TD="align: center"]100[/TD]

[TD="align: center"]12[/TD]

[TD="align: center"]101[/TD]

[TD="align: center"]13[/TD]

[TD="align: center"]120[/TD]

[TD="align: center"]14[/TD]

[TD="align: center"]121[/TD]

[TD="align: center"]15[/TD]

[TD="align: center"]140[/TD]

[TD="align: center"]16[/TD]

[TD="align: center"]141[/TD]

[TD="align: center"]17[/TD]

[TD="align: center"]160[/TD]

[TD="align: center"]18[/TD]

[TD="align: center"]161[/TD]

[TD="align: center"]19[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]21[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]22[/TD]

[TD="align: center"]0[/TD]

[TD="align: center"]23[/TD]

[TD="align: center"]0[/TD]

[TD="align: center"]24[/TD]

[TD="align: center"]0[/TD]

[TD="align: center"]25[/TD]

[TD="align: center"]0[/TD]

[TD="align: center"]26[/TD]

[TD="align: center"]0[/TD]

[TD="align: center"]27[/TD]

[TD="align: center"]0[/TD]

</tbody>
Draft Sheet​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]B22[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]B23[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]B24[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]B25[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]B26[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]B27[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]


This is from the QB tab
Excel 2010
ABCDEFGHIJKLMNOPQRSTUVWXY
22026Andrew LuckINDAndrew Luck

<tbody>
[TD="align: center"]3[/TD]
[TD="align: center"]Rk[/TD]
[TD="align: center"]RkOvr[/TD]
[TD="align: center"]$[/TD]
[TD="align: center"]Player[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Tm[/TD]
[TD="align: center"]Bye[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]PYds[/TD]
[TD="align: center"]PTDs[/TD]
[TD="align: center"]Int[/TD]
[TD="align: center"]RYds[/TD]
[TD="align: center"]RTDs[/TD]
[TD="align: center"]300+[/TD]
[TD="align: center"]ADP[/TD]
[TD="align: center"]TDO[/TD]
[TD="align: center"]PPR[/TD]
[TD="align: center"]FP[/TD]
[TD="align: center"]NEW[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]4822[/TD]
[TD="align: right"]38[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]221[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]19.61[/TD]
[TD="align: right"]212[/TD]
[TD="align: right"]399[/TD]
[TD="align: right"]399[/TD]
[TD="align: right"]347[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

</tbody>
QB​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]X4[/TH]
[TD="align: left"]=COUNTIF('Draft Sheet'!$B$2:$K$18,D4)[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]Y4[/TH]
[TD="align: left"]=D4[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
These are the other formulas that show the next best players. It references the same QB tab above.

Excel 2010
ABCDEFGHIJKLM
PlayerBye 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
BR QBAndrew Luck

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]29[/TD]
[TD="align: right"][/TD]

[TD="align: center"]30[/TD]

[TD="align: right"]10[/TD]
[TD="align: center"] 346.98 [/TD]
[TD="align: center"]3.59%[/TD]
[TD="align: center"]4.45%[/TD]
[TD="align: center"]11.49%[/TD]
[TD="align: center"]11.74%[/TD]
[TD="align: center"]14.26%[/TD]
[TD="align: center"]15.38%[/TD]
[TD="align: center"]17.76%[/TD]
[TD="align: center"]18.43%[/TD]
[TD="align: center"]20.15%[/TD]

</tbody>
Draft Sheet​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B30[/TH]
[TD="align: left"]=INDEX(QB!$D:$D,MATCH('Draft Sheet'!D30,QB!S:S,0))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C30[/TH]
[TD="align: left"]=INDEX(QB!$G:$G,MATCH('Draft Sheet'!B30,QB!D:D,0))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D30[/TH]
[TD="align: left"]{=MAX(IF(QB!$X:$X=1,,QB!$S:$S))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E30[/TH]
[TD="align: left"]{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),2))/$D$30}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F30[/TH]
[TD="align: left"]{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),3))/$D$30}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]G30[/TH]
[TD="align: left"]{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),4))/$D$30}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]H30[/TH]
[TD="align: left"]{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),5))/$D$30}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]I30[/TH]
[TD="align: left"]{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),6))/$D$30}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]J30[/TH]
[TD="align: left"]{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),7))/$D$30}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]K30[/TH]
[TD="align: left"]{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),8))/$D$30}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]L30[/TH]
[TD="align: left"]{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),9))/$D$30}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]M30[/TH]
[TD="align: left"]{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),10))/$D$30}[/TD]
[/TR]
</tbody>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
This is the whole main sheet.

Excel 2010
ABCDEFGHIJKLM
Team #1Team #2Team #3Team #4Team #5Team #6Team #7Team #8Team #9Team #10
Round 1
Round 2
Round 3
Round 4
Round 5
Round 6
Round 7
Round 8
Round 9
Round 10
Round 11
Round 12
Round 13
Round 14
Round 15
Round 16
Round 17
Team #2Team #3Team #4Team #5Team #6Team #7Team #8Team #9Team #10TOTAL Drafted
QB
RB
WR
TE
K
DEF
PlayerBye 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
BR QBAndrew Luck
BR RBLe'Veon Bell
BR WRDemaryius Thomas
BR TERob Gronkowski
BR KStephen Gostkowski
BR DEFSeattle Seahawks

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]10[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]20[/TD]
[TD="align: center"]19[/TD]
[TD="align: center"]18[/TD]
[TD="align: center"]17[/TD]
[TD="align: center"]16[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]14[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]11[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]21[/TD]
[TD="align: center"]22[/TD]
[TD="align: center"]23[/TD]
[TD="align: center"]24[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]27[/TD]
[TD="align: center"]28[/TD]
[TD="align: center"]29[/TD]
[TD="align: center"]30[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]40[/TD]
[TD="align: center"]39[/TD]
[TD="align: center"]38[/TD]
[TD="align: center"]37[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]35[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]33[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]31[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]

[TD="align: center"]41[/TD]
[TD="align: center"]42[/TD]
[TD="align: center"]43[/TD]
[TD="align: center"]44[/TD]
[TD="align: center"]45[/TD]
[TD="align: center"]46[/TD]
[TD="align: center"]47[/TD]
[TD="align: center"]48[/TD]
[TD="align: center"]49[/TD]
[TD="align: center"]50[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]60[/TD]
[TD="align: center"]59[/TD]
[TD="align: center"]58[/TD]
[TD="align: center"]57[/TD]
[TD="align: center"]56[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]54[/TD]
[TD="align: center"]53[/TD]
[TD="align: center"]52[/TD]
[TD="align: center"]51[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]

[TD="align: center"]61[/TD]
[TD="align: center"]62[/TD]
[TD="align: center"]63[/TD]
[TD="align: center"]64[/TD]
[TD="align: center"]65[/TD]
[TD="align: center"]66[/TD]
[TD="align: center"]67[/TD]
[TD="align: center"]68[/TD]
[TD="align: center"]69[/TD]
[TD="align: center"]70[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="align: center"]80[/TD]
[TD="align: center"]79[/TD]
[TD="align: center"]78[/TD]
[TD="align: center"]77[/TD]
[TD="align: center"]76[/TD]
[TD="align: center"]75[/TD]
[TD="align: center"]74[/TD]
[TD="align: center"]73[/TD]
[TD="align: center"]72[/TD]
[TD="align: center"]71[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]

[TD="align: center"]81[/TD]
[TD="align: center"]82[/TD]
[TD="align: center"]83[/TD]
[TD="align: center"]84[/TD]
[TD="align: center"]85[/TD]
[TD="align: center"]86[/TD]
[TD="align: center"]87[/TD]
[TD="align: center"]88[/TD]
[TD="align: center"]89[/TD]
[TD="align: center"]90[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]

[TD="align: center"]100[/TD]
[TD="align: center"]99[/TD]
[TD="align: center"]98[/TD]
[TD="align: center"]97[/TD]
[TD="align: center"]96[/TD]
[TD="align: center"]95[/TD]
[TD="align: center"]94[/TD]
[TD="align: center"]93[/TD]
[TD="align: center"]92[/TD]
[TD="align: center"]91[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]

[TD="align: center"]101[/TD]
[TD="align: center"]102[/TD]
[TD="align: center"]103[/TD]
[TD="align: center"]104[/TD]
[TD="align: center"]105[/TD]
[TD="align: center"]106[/TD]
[TD="align: center"]107[/TD]
[TD="align: center"]108[/TD]
[TD="align: center"]109[/TD]
[TD="align: center"]110[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]

[TD="align: center"]120[/TD]
[TD="align: center"]119[/TD]
[TD="align: center"]118[/TD]
[TD="align: center"]117[/TD]
[TD="align: center"]116[/TD]
[TD="align: center"]115[/TD]
[TD="align: center"]114[/TD]
[TD="align: center"]113[/TD]
[TD="align: center"]112[/TD]
[TD="align: center"]111[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]

[TD="align: center"]121[/TD]
[TD="align: center"]122[/TD]
[TD="align: center"]123[/TD]
[TD="align: center"]124[/TD]
[TD="align: center"]125[/TD]
[TD="align: center"]126[/TD]
[TD="align: center"]127[/TD]
[TD="align: center"]128[/TD]
[TD="align: center"]129[/TD]
[TD="align: center"]130[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]

[TD="align: center"]140[/TD]
[TD="align: center"]139[/TD]
[TD="align: center"]138[/TD]
[TD="align: center"]137[/TD]
[TD="align: center"]136[/TD]
[TD="align: center"]135[/TD]
[TD="align: center"]134[/TD]
[TD="align: center"]133[/TD]
[TD="align: center"]132[/TD]
[TD="align: center"]131[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]

[TD="align: center"]141[/TD]
[TD="align: center"]142[/TD]
[TD="align: center"]143[/TD]
[TD="align: center"]144[/TD]
[TD="align: center"]145[/TD]
[TD="align: center"]146[/TD]
[TD="align: center"]147[/TD]
[TD="align: center"]148[/TD]
[TD="align: center"]149[/TD]
[TD="align: center"]150[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]

[TD="align: center"]160[/TD]
[TD="align: center"]159[/TD]
[TD="align: center"]158[/TD]
[TD="align: center"]157[/TD]
[TD="align: center"]156[/TD]
[TD="align: center"]155[/TD]
[TD="align: center"]154[/TD]
[TD="align: center"]153[/TD]
[TD="align: center"]152[/TD]
[TD="align: center"]151[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]

[TD="align: center"]161[/TD]
[TD="align: center"]162[/TD]
[TD="align: center"]163[/TD]
[TD="align: center"]164[/TD]
[TD="align: center"]165[/TD]
[TD="align: center"]166[/TD]
[TD="align: center"]167[/TD]
[TD="align: center"]168[/TD]
[TD="align: center"]169[/TD]
[TD="align: center"]170[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]21[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]22[/TD]

[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: right"][/TD]

[TD="align: center"]23[/TD]

[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: right"][/TD]

[TD="align: center"]24[/TD]

[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: right"][/TD]

[TD="align: center"]25[/TD]

[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: right"][/TD]

[TD="align: center"]26[/TD]

[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: right"][/TD]

[TD="align: center"]27[/TD]

[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: right"][/TD]

[TD="align: center"]28[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]29[/TD]
[TD="align: right"][/TD]

[TD="align: center"]30[/TD]

[TD="align: right"]10[/TD]
[TD="align: center"] 346.98 [/TD]
[TD="align: center"]3.59%[/TD]
[TD="align: center"]4.45%[/TD]
[TD="align: center"]11.49%[/TD]
[TD="align: center"]11.74%[/TD]
[TD="align: center"]14.26%[/TD]
[TD="align: center"]15.38%[/TD]
[TD="align: center"]17.76%[/TD]
[TD="align: center"]18.43%[/TD]
[TD="align: center"]20.15%[/TD]

[TD="align: center"]31[/TD]

[TD="align: right"]11[/TD]
[TD="align: center"] 298.40 [/TD]
[TD="align: center"]5.70%[/TD]
[TD="align: center"]8.68%[/TD]
[TD="align: center"]10.09%[/TD]
[TD="align: center"]15.11%[/TD]
[TD="align: center"]15.35%[/TD]
[TD="align: center"]15.99%[/TD]
[TD="align: center"]22.22%[/TD]
[TD="align: center"]23.53%[/TD]
[TD="align: center"]24.63%[/TD]

[TD="align: center"]32[/TD]

[TD="align: right"]7[/TD]
[TD="align: center"] 284.00 [/TD]
[TD="align: center"]0.32%[/TD]
[TD="align: center"]1.97%[/TD]
[TD="align: center"]4.54%[/TD]
[TD="align: center"]6.34%[/TD]
[TD="align: center"]12.61%[/TD]
[TD="align: center"]13.35%[/TD]
[TD="align: center"]20.81%[/TD]
[TD="align: center"]21.48%[/TD]
[TD="align: center"]22.01%[/TD]

[TD="align: center"]33[/TD]

[TD="align: right"]4[/TD]
[TD="align: center"] 255.50 [/TD]
[TD="align: center"]26.65%[/TD]
[TD="align: center"]32.05%[/TD]
[TD="align: center"]39.33%[/TD]
[TD="align: center"]39.41%[/TD]
[TD="align: center"]41.68%[/TD]
[TD="align: center"]45.01%[/TD]
[TD="align: center"]45.13%[/TD]
[TD="align: center"]47.01%[/TD]
[TD="align: center"]49.20%[/TD]

[TD="align: center"]34[/TD]

[TD="align: right"]4[/TD]
[TD="align: center"] 169.00 [/TD]
[TD="align: center"]5.33%[/TD]
[TD="align: center"]5.92%[/TD]
[TD="align: center"]6.51%[/TD]
[TD="align: center"]9.47%[/TD]
[TD="align: center"]10.06%[/TD]
[TD="align: center"]10.65%[/TD]
[TD="align: center"]13.02%[/TD]
[TD="align: center"]14.79%[/TD]
[TD="align: center"]15.38%[/TD]

[TD="align: center"]35[/TD]

[TD="align: right"]9[/TD]
[TD="align: center"] 164.00 [/TD]
[TD="align: center"]4.88%[/TD]
[TD="align: center"]6.10%[/TD]
[TD="align: center"]7.32%[/TD]
[TD="align: center"]8.54%[/TD]
[TD="align: center"]9.15%[/TD]
[TD="align: center"]10.37%[/TD]
[TD="align: center"]10.98%[/TD]
[TD="align: center"]23.78%[/TD]
[TD="align: center"]29.88%[/TD]

</tbody>
Draft Sheet​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C21[/TH]
[TD="align: left"]=C1[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D21[/TH]
[TD="align: left"]=D1[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E21[/TH]
[TD="align: left"]=E1[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F21[/TH]
[TD="align: left"]=F1[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]G21[/TH]
[TD="align: left"]=G1[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]H21[/TH]
[TD="align: left"]=H1[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]I21[/TH]
[TD="align: left"]=I1[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]J21[/TH]
[TD="align: left"]=J1[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]K21[/TH]
[TD="align: left"]=K1[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B22[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C22[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D22[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E22[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F22[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]G22[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]H22[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]I22[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]J22[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]K22[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]L22[/TH]
[TD="align: left"]=SUM(B22:K22)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B23[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C23[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D23[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E23[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F23[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]G23[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]H23[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]I23[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]J23[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]K23[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]L23[/TH]
[TD="align: left"]=SUM(B23:K23)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B24[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C24[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D24[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E24[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F24[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]G24[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]H24[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]I24[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]J24[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]K24[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]L24[/TH]
[TD="align: left"]=SUM(B24:K24)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B25[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C25[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D25[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E25[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F25[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]G25[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]H25[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]I25[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]J25[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]K25[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]L25[/TH]
[TD="align: left"]=SUM(B25:K25)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B26[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C26[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D26[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E26[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F26[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]G26[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]H26[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]I26[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]J26[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]K26[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]L26[/TH]
[TD="align: left"]=SUM(B26:K26)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B27[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C27[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D27[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E27[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F27[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]G27[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]H27[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]I27[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]J27[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]K27[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]L27[/TH]
[TD="align: left"]=SUM(B27:K27)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B30[/TH]
[TD="align: left"]=INDEX(QB!$D:$D,MATCH('Draft Sheet'!D30,QB!S:S,0))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C30[/TH]
[TD="align: left"]=INDEX(QB!$G:$G,MATCH('Draft Sheet'!B30,QB!D:D,0))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B31[/TH]
[TD="align: left"]=INDEX(RB!$D:$D,MATCH('Draft Sheet'!D31,RB!V:V,0))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C31[/TH]
[TD="align: left"]=INDEX(RB!$G:$G,MATCH('Draft Sheet'!B31,RB!D:D,0))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B32[/TH]
[TD="align: left"]=INDEX(WR!$D:$D,MATCH('Draft Sheet'!D32,WR!V:V,0))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C32[/TH]
[TD="align: left"]=INDEX(WR!$G:$G,MATCH('Draft Sheet'!B32,WR!D:D,0))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B33[/TH]
[TD="align: left"]=INDEX(TE!$D:$D,MATCH('Draft Sheet'!D33,TE!V:V,0))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C33[/TH]
[TD="align: left"]=INDEX(TE!$G:$G,MATCH('Draft Sheet'!B33,TE!D:D,0))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B34[/TH]
[TD="align: left"]=INDEX(K!$D:$D,MATCH('Draft Sheet'!D34,K!S:S,0))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C34[/TH]
[TD="align: left"]=INDEX(K!$G:$G,MATCH('Draft Sheet'!B34,K!D:D,0))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B35[/TH]
[TD="align: left"]=INDEX(DEF!$C:$C,MATCH('Draft Sheet'!D35,DEF!M:M,0))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C35[/TH]
[TD="align: left"]=INDEX(DEF!$E:$E,MATCH('Draft Sheet'!B35,DEF!C:C,0))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D30[/TH]
[TD="align: left"]{=MAX(IF(QB!$X:$X=1,,QB!$S:$S))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E30[/TH]
[TD="align: left"]{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),2))/$D$30}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F30[/TH]
[TD="align: left"]{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),3))/$D$30}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]G30[/TH]
[TD="align: left"]{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),4))/$D$30}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]H30[/TH]
[TD="align: left"]{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),5))/$D$30}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]I30[/TH]
[TD="align: left"]{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),6))/$D$30}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]J30[/TH]
[TD="align: left"]{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),7))/$D$30}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]K30[/TH]
[TD="align: left"]{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),8))/$D$30}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]L30[/TH]
[TD="align: left"]{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),9))/$D$30}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]M30[/TH]
[TD="align: left"]{=($D$30-LARGE(IF(QB!$X:$X=1,,QB!$S:$S),10))/$D$30}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D31[/TH]
[TD="align: left"]{=MAX(IF(RB!$X:$X=1,,RB!$V:$V))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E31[/TH]
[TD="align: left"]{=($D$31-LARGE(IF(RB!$X:$X=1,,RB!$V:$V),2))/$D$31}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F31[/TH]
[TD="align: left"]{=($D$31-LARGE(IF(RB!$X:$X=1,,RB!$V:$V),3))/$D$31}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]G31[/TH]
[TD="align: left"]{=($D$31-LARGE(IF(RB!$X:$X=1,,RB!$V:$V),4))/$D$31}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]H31[/TH]
[TD="align: left"]{=($D$31-LARGE(IF(RB!$X:$X=1,,RB!$V:$V),5))/$D$31}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]I31[/TH]
[TD="align: left"]{=($D$31-LARGE(IF(RB!$X:$X=1,,RB!$V:$V),6))/$D$31}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]J31[/TH]
[TD="align: left"]{=($D$31-LARGE(IF(RB!$X:$X=1,,RB!$V:$V),7))/$D$31}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]K31[/TH]
[TD="align: left"]{=($D$31-LARGE(IF(RB!$X:$X=1,,RB!$V:$V),8))/$D$31}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]L31[/TH]
[TD="align: left"]{=($D$31-LARGE(IF(RB!$X:$X=1,,RB!$V:$V),9))/$D$31}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]M31[/TH]
[TD="align: left"]{=($D$31-LARGE(IF(RB!$X:$X=1,,RB!$V:$V),10))/$D$31}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D32[/TH]
[TD="align: left"]{=MAX(IF(WR!$X:$X=1,,WR!$V:$V))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E32[/TH]
[TD="align: left"]{=($D$32-LARGE(IF(WR!$X:$X=1,,WR!$V:$V),2))/$D$32}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F32[/TH]
[TD="align: left"]{=($D$32-LARGE(IF(WR!$X:$X=1,,WR!$V:$V),3))/$D$32}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]G32[/TH]
[TD="align: left"]{=($D$32-LARGE(IF(WR!$X:$X=1,,WR!$V:$V),4))/$D$32}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]H32[/TH]
[TD="align: left"]{=($D$32-LARGE(IF(WR!$X:$X=1,,WR!$V:$V),5))/$D$32}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]I32[/TH]
[TD="align: left"]{=($D$32-LARGE(IF(WR!$X:$X=1,,WR!$V:$V),6))/$D$32}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]J32[/TH]
[TD="align: left"]{=($D$32-LARGE(IF(WR!$X:$X=1,,WR!$V:$V),7))/$D$32}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]K32[/TH]
[TD="align: left"]{=($D$32-LARGE(IF(WR!$X:$X=1,,WR!$V:$V),8))/$D$32}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]L32[/TH]
[TD="align: left"]{=($D$32-LARGE(IF(WR!$X:$X=1,,WR!$V:$V),9))/$D$32}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]M32[/TH]
[TD="align: left"]{=($D$32-LARGE(IF(WR!$X:$X=1,,WR!$V:$V),10))/$D$32}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D33[/TH]
[TD="align: left"]{=MAX(IF(TE!$X:$X=1,,TE!$V:$V))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E33[/TH]
[TD="align: left"]{=($D$33-LARGE(IF(TE!$X:$X=1,,TE!$V:$V),2))/$D$33}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F33[/TH]
[TD="align: left"]{=($D$33-LARGE(IF(TE!$X:$X=1,,TE!$V:$V),3))/$D$33}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]G33[/TH]
[TD="align: left"]{=($D$33-LARGE(IF(TE!$X:$X=1,,TE!$V:$V),4))/$D$33}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]H33[/TH]
[TD="align: left"]{=($D$33-LARGE(IF(TE!$X:$X=1,,TE!$V:$V),5))/$D$33}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]I33[/TH]
[TD="align: left"]{=($D$33-LARGE(IF(TE!$X:$X=1,,TE!$V:$V),6))/$D$33}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]J33[/TH]
[TD="align: left"]{=($D$33-LARGE(IF(TE!$X:$X=1,,TE!$V:$V),7))/$D$33}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]K33[/TH]
[TD="align: left"]{=($D$33-LARGE(IF(TE!$X:$X=1,,TE!$V:$V),8))/$D$33}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]L33[/TH]
[TD="align: left"]{=($D$33-LARGE(IF(TE!$X:$X=1,,TE!$V:$V),9))/$D$33}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]M33[/TH]
[TD="align: left"]{=($D$33-LARGE(IF(TE!$X:$X=1,,TE!$V:$V),10))/$D$33}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D34[/TH]
[TD="align: left"]{=MAX(IF(K!$X:$X=1,,K!$S:$S))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E34[/TH]
[TD="align: left"]{=($D$34-LARGE(IF(K!$X:$X=1,,K!$S:$S),2))/$D$34}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F34[/TH]
[TD="align: left"]{=($D$34-LARGE(IF(K!$X:$X=1,,K!$S:$S),3))/$D$34}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]G34[/TH]
[TD="align: left"]{=($D$34-LARGE(IF(K!$X:$X=1,,K!$S:$S),4))/$D$34}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]H34[/TH]
[TD="align: left"]{=($D$34-LARGE(IF(K!$X:$X=1,,K!$S:$S),5))/$D$34}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]I34[/TH]
[TD="align: left"]{=($D$34-LARGE(IF(K!$X:$X=1,,K!$S:$S),6))/$D$34}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]J34[/TH]
[TD="align: left"]{=($D$34-LARGE(IF(K!$X:$X=1,,K!$S:$S),7))/$D$34}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]K34[/TH]
[TD="align: left"]{=($D$34-LARGE(IF(K!$X:$X=1,,K!$S:$S),8))/$D$34}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]L34[/TH]
[TD="align: left"]{=($D$34-LARGE(IF(K!$X:$X=1,,K!$S:$S),9))/$D$34}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]M34[/TH]
[TD="align: left"]{=($D$34-LARGE(IF(K!$X:$X=1,,K!$S:$S),10))/$D$34}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D35[/TH]
[TD="align: left"]{=MAX(IF(DEF!$X:$X=1,,DEF!$M:$M))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E35[/TH]
[TD="align: left"]{=($D$35-LARGE(IF(DEF!$X:$X=1,,DEF!$M:$M),2))/$D$35}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F35[/TH]
[TD="align: left"]{=($D$35-LARGE(IF(DEF!$X:$X=1,,DEF!$M:$M),3))/$D$35}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]G35[/TH]
[TD="align: left"]{=($D$35-LARGE(IF(DEF!$X:$X=1,,DEF!$M:$M),4))/$D$35}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]H35[/TH]
[TD="align: left"]{=($D$35-LARGE(IF(DEF!$X:$X=1,,DEF!$M:$M),5))/$D$35}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]I35[/TH]
[TD="align: left"]{=($D$35-LARGE(IF(DEF!$X:$X=1,,DEF!$M:$M),6))/$D$35}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]J35[/TH]
[TD="align: left"]{=($D$35-LARGE(IF(DEF!$X:$X=1,,DEF!$M:$M),7))/$D$35}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]K35[/TH]
[TD="align: left"]{=($D$35-LARGE(IF(DEF!$X:$X=1,,DEF!$M:$M),8))/$D$35}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]L35[/TH]
[TD="align: left"]{=($D$35-LARGE(IF(DEF!$X:$X=1,,DEF!$M:$M),9))/$D$35}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]M35[/TH]
[TD="align: left"]{=($D$35-LARGE(IF(DEF!$X:$X=1,,DEF!$M:$M),10))/$D$35}[/TD]
[/TR]
</tbody>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question Question
Using Vlookup for Alphanumeric and numeric values. It is not recognising the numeric
Replies
8
Views
193
coulombevin
coulombevin
F
  • Question Question
Consecutive Inspection Date
Replies
0
Views
64
fahad_ibnfurjan
F
E
  • Solved
extend Excel formula to filter based on a period
Replies
5
Views
348
smozgur
smozgur
E
  • Locked
  • Question Question
Excel formjlailter data to be analysed
Replies
1
Views
182
Fluff
Fluff
D
  • Solved
VBA to generate report
2
Replies
15
Views
306
dsubash
D

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