This is the whole main sheet.
Excel 2010
| A | B | C | D | E | F | G | H | I | J | K | L | M |
---|
Team #1 | Team #2 | Team #3 | Team #4 | Team #5 | Team #6 | Team #7 | Team #8 | Team #9 | Team #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 #2 | Team #3 | Team #4 | Team #5 | Team #6 | Team #7 | Team #8 | Team #9 | Team #10 | TOTAL Drafted | | | | |
QB | | | | | | | | | | | | | |
RB | | | | | | | | | | | | | |
WR | | | | | | | | | | | | | |
TE | | | | | | | | | | | | | |
K | | | | | | | | | | | | | |
DEF | | | | | | | | | | | | | |
| | | | | | | | | | | | | |
Player | Bye Week | Points | Variance to 2nd BP | Variance to 3rd BP | Variance to 4th BP | Variance to 5th BP | Variance to 6th BP | Variance to 7th BP | Variance to 8th BP | Variance to 9th BP | Variance to 10th BP | | |
BR QB | Andrew Luck | | | | | | | | | | | | |
BR RB | Le'Veon Bell | | | | | | | | | | | | |
BR WR | Demaryius Thomas | | | | | | | | | | | | |
BR TE | Rob Gronkowski | | | | | | | | | | | | |
BR K | Stephen Gostkowski | | | | | | | | | | | | |
BR DEF | Seattle 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]