How do I redistribute sales fairly if I want to increase the growth percentage?

T

tblackwell

New Member
Joined
Oct 24, 2018
Messages
28
Office Version
  1. 365
Platform
  1. Windows
I am working on a sales forecast for 2020. The forecast has 92 locations and I have sales by week by site for Period 1 2019 and a forecast of sales by week for Period 1 2020.

Period 1 2019 Sales Total: $11,586,579
Period 1 2020 Sales Forecast: $11,57,090
Dollar Change in sales 2019 to 2020: +$512
Percent Change in sales 2019 to 2020: +0.00%

Let's say I think the forecast of +0.00% is too conservative and I want to raise the forecast to +1.00%. This would mean that...

Period 1 2019 Sales Total: $11,586,579
Period 1 2020 Sales Forecast: $11,702,445
Dollar Change in sales 2019 to 2020: +$115,886
Percent Change in sales 2019 to 2020: +1.00%

This means that I would need to raise my forecast by $115,354 across 92 locations

What is the best way to distribute the $115,354 fairly across all 92 locations and the best way to do this in a formula in excel?

Appreciate any help you can provide!

(Windows 10 Pro, Office 365)


ABCDEFGHIJKLMNOP
Period $ ChangePeriod % Change
Period Total
Weekly Subtotal
Week Ending
P1W1P1W2P1W3P1W4P1W5P1W1P1W2P1W3P1W4P1W5
Store_NumTotal Net Sales WTDTotal Net Sales WTDTotal Net Sales WTDTotal Net Sales WTDTotal Net Sales WTDTotal Net Sales WTDTotal Net Sales WTDTotal Net Sales WTDTotal Net Sales WTDTotal Net Sales WTD

<colgroup><col style="width: 25pxpx"><col><col><col><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: 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"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]11,586,579[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]11,587,090[/TD]
[TD="align: right"][/TD]
[TD="align: right"]512[/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"][/TD]

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

[TD="align: right"]2,388,267[/TD]
[TD="align: right"]2,248,082[/TD]
[TD="align: right"]2,212,158[/TD]
[TD="align: right"]2,329,619[/TD]
[TD="align: right"]2,408,453[/TD]
[TD="align: right"][/TD]
[TD="align: right"]2,372,677[/TD]
[TD="align: right"]2,344,286[/TD]
[TD="align: right"]2,291,338[/TD]
[TD="align: right"]2,307,031[/TD]
[TD="align: right"]2,271,759[/TD]
[TD="align: right"][/TD]
[TD="align: right"]115,866[/TD]
[TD="align: right"]1.00%[/TD]
[TD="align: right"] 11,702,445 [/TD]

[TD="align: center"]4[/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: right"]115,354[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

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

[TD="align: right"]1/8/2019[/TD]
[TD="align: right"]1/15/2019[/TD]
[TD="align: right"]1/22/2019[/TD]
[TD="align: right"]1/29/2019[/TD]
[TD="align: right"]2/5/2019[/TD]
[TD="align: right"][/TD]
[TD="align: right"]1/7/2020[/TD]
[TD="align: right"]1/14/2020[/TD]
[TD="align: right"]1/21/2020[/TD]
[TD="align: right"]1/28/2020[/TD]
[TD="align: right"]2/4/2020[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/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: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/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"]8[/TD]

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

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

[TD="align: center"]9[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]23307.1[/TD]
[TD="align: right"]19711.32[/TD]
[TD="align: right"]18721.71[/TD]
[TD="align: right"]20915.36[/TD]
[TD="align: right"]20852.3[/TD]
[TD="align: right"][/TD]
[TD="align: right"]20342.3094[/TD]
[TD="align: right"]17708.9165[/TD]
[TD="align: right"]21525.0994[/TD]
[TD="align: right"]20972.8614[/TD]
[TD="align: right"]20988.9583[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]19289.63[/TD]
[TD="align: right"]14013.56[/TD]
[TD="align: right"]13670.45[/TD]
[TD="align: right"]16415.49[/TD]
[TD="align: right"]14924.92[/TD]
[TD="align: right"][/TD]
[TD="align: right"]17121.3979[/TD]
[TD="align: right"]14408.4069[/TD]
[TD="align: right"]16586.8535[/TD]
[TD="align: right"]17366.8461[/TD]
[TD="align: right"]17122.4549[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]26350.22[/TD]
[TD="align: right"]22814.24[/TD]
[TD="align: right"]20506.84[/TD]
[TD="align: right"]24964.98[/TD]
[TD="align: right"]25644.98[/TD]
[TD="align: right"][/TD]
[TD="align: right"]28160.73[/TD]
[TD="align: right"]26445.3041[/TD]
[TD="align: right"]26741.6725[/TD]
[TD="align: right"]22662.0707[/TD]
[TD="align: right"]21082.49[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]6004[/TD]
[TD="align: right"]18357.8[/TD]
[TD="align: right"]15772.23[/TD]
[TD="align: right"]16944.87[/TD]
[TD="align: right"]18257.87[/TD]
[TD="align: right"]19619.81[/TD]
[TD="align: right"][/TD]
[TD="align: right"]17846.5497[/TD]
[TD="align: right"]15484.5381[/TD]
[TD="align: right"]18654.8218[/TD]
[TD="align: right"]18143.3343[/TD]
[TD="align: right"]18396.6408[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]6005[/TD]
[TD="align: right"]19162.42[/TD]
[TD="align: right"]15005.24[/TD]
[TD="align: right"]15267.78[/TD]
[TD="align: right"]17336.39[/TD]
[TD="align: right"]18421.19[/TD]
[TD="align: right"][/TD]
[TD="align: right"]18113.2928[/TD]
[TD="align: right"]19287.3147[/TD]
[TD="align: right"]18948.7407[/TD]
[TD="align: right"]18300.0356[/TD]
[TD="align: right"]17346.7812[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]6006[/TD]
[TD="align: right"]30017.97[/TD]
[TD="align: right"]25498.35[/TD]
[TD="align: right"]26161.25[/TD]
[TD="align: right"]28485.63[/TD]
[TD="align: right"]30189.3[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25406.0682[/TD]
[TD="align: right"]25406.0682[/TD]
[TD="align: right"]28423.8025[/TD]
[TD="align: right"]23990.1941[/TD]
[TD="align: right"]24916.5099[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]6007[/TD]
[TD="align: right"]23462.68[/TD]
[TD="align: right"]22524.48[/TD]
[TD="align: right"]17704.36[/TD]
[TD="align: right"]20662.8[/TD]
[TD="align: right"]24215.73[/TD]
[TD="align: right"][/TD]
[TD="align: right"]23660.7748[/TD]
[TD="align: right"]23660.7748[/TD]
[TD="align: right"]25029.53[/TD]
[TD="align: right"]22144.8275[/TD]
[TD="align: right"]19146.4872[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]6008[/TD]
[TD="align: right"]33073.17[/TD]
[TD="align: right"]27137.83[/TD]
[TD="align: right"]30216.72[/TD]
[TD="align: right"]30279.7[/TD]
[TD="align: right"]31712.29[/TD]
[TD="align: right"][/TD]
[TD="align: right"]33416.1431[/TD]
[TD="align: right"]33416.1431[/TD]
[TD="align: right"]30327.7975[/TD]
[TD="align: right"]23884.6073[/TD]
[TD="align: right"]26021.835[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]6009[/TD]
[TD="align: right"]23660.04[/TD]
[TD="align: right"]22442.96[/TD]
[TD="align: right"]25441.55[/TD]
[TD="align: right"]28043.23[/TD]
[TD="align: right"]27881.39[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25873.4452[/TD]
[TD="align: right"]26560.3488[/TD]
[TD="align: right"]28280.4429[/TD]
[TD="align: right"]29442.7934[/TD]
[TD="align: right"]28460.29[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]6010[/TD]
[TD="align: right"]29743.83[/TD]
[TD="align: right"]22766.06[/TD]
[TD="align: right"]22139.44[/TD]
[TD="align: right"]25437.63[/TD]
[TD="align: right"]30035.21[/TD]
[TD="align: right"][/TD]
[TD="align: right"]26371.6705[/TD]
[TD="align: right"]27921.1313[/TD]
[TD="align: right"]29661.7556[/TD]
[TD="align: right"]27603.4336[/TD]
[TD="align: right"]27407.8259[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]6011[/TD]
[TD="align: right"]21599.28[/TD]
[TD="align: right"]19281.18[/TD]
[TD="align: right"]19843.1[/TD]
[TD="align: right"]20988.8[/TD]
[TD="align: right"]20455.9[/TD]
[TD="align: right"][/TD]
[TD="align: right"]18560.2147[/TD]
[TD="align: right"]16949.5793[/TD]
[TD="align: right"]17952.5472[/TD]
[TD="align: right"]18393.3956[/TD]
[TD="align: right"]17845.8451[/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"]6012[/TD]
[TD="align: right"]14600.92[/TD]
[TD="align: right"]11388.38[/TD]
[TD="align: right"]12722.69[/TD]
[TD="align: right"]13643.31[/TD]
[TD="align: right"]14548.95[/TD]
[TD="align: right"][/TD]
[TD="align: right"]14107.4122[/TD]
[TD="align: right"]12580.4383[/TD]
[TD="align: right"]10834.962[/TD]
[TD="align: right"]12381.5964[/TD]
[TD="align: right"]12532.0485[/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"]6013[/TD]
[TD="align: right"]28025.68[/TD]
[TD="align: right"]25027.8[/TD]
[TD="align: right"]23630.08[/TD]
[TD="align: right"]26714.62[/TD]
[TD="align: right"]27391.91[/TD]
[TD="align: right"][/TD]
[TD="align: right"]26094.6985[/TD]
[TD="align: right"]26094.6985[/TD]
[TD="align: right"]25623.8625[/TD]
[TD="align: right"]22355.352[/TD]
[TD="align: right"]21475.0974[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]22[/TD]
[TD="align: right"]6014[/TD]
[TD="align: right"]20035.25[/TD]
[TD="align: right"]18796.68[/TD]
[TD="align: right"]17137.59[/TD]
[TD="align: right"]18775.44[/TD]
[TD="align: right"]19499.23[/TD]
[TD="align: right"][/TD]
[TD="align: right"]19977.0593[/TD]
[TD="align: right"]19977.0593[/TD]
[TD="align: right"]19768.265[/TD]
[TD="align: right"]17866.6851[/TD]
[TD="align: right"]17136.3401[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]23[/TD]
[TD="align: right"]6015[/TD]
[TD="align: right"]31436.46[/TD]
[TD="align: right"]25150.36[/TD]
[TD="align: right"]25754.54[/TD]
[TD="align: right"]27917.56[/TD]
[TD="align: right"]27319.97[/TD]
[TD="align: right"][/TD]
[TD="align: right"]35345.0346[/TD]
[TD="align: right"]35345.0346[/TD]
[TD="align: right"]30883.795[/TD]
[TD="align: right"]24633.9549[/TD]
[TD="align: right"]24918.7412[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]24[/TD]
[TD="align: right"]6017[/TD]
[TD="align: right"]26259.35[/TD]
[TD="align: right"]23628.25[/TD]
[TD="align: right"]22126.8[/TD]
[TD="align: right"]24038.16[/TD]
[TD="align: right"]25452.11[/TD]
[TD="align: right"][/TD]
[TD="align: right"]24478.0844[/TD]
[TD="align: right"]21522.3566[/TD]
[TD="align: right"]23864.9317[/TD]
[TD="align: right"]24745.4886[/TD]
[TD="align: right"]24527.1256[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]25[/TD]
[TD="align: right"]6018[/TD]
[TD="align: right"]27043.38[/TD]
[TD="align: right"]24071.12[/TD]
[TD="align: right"]25959.15[/TD]
[TD="align: right"]27114.98[/TD]
[TD="align: right"]28163.14[/TD]
[TD="align: right"][/TD]
[TD="align: right"]26227.7614[/TD]
[TD="align: right"]24036.7058[/TD]
[TD="align: right"]26078.9506[/TD]
[TD="align: right"]26462.7876[/TD]
[TD="align: right"]26696.946[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]26[/TD]
[TD="align: right"]6019[/TD]
[TD="align: right"]15944.05[/TD]
[TD="align: right"]13965.25[/TD]
[TD="align: right"]13980.73[/TD]
[TD="align: right"]15532.36[/TD]
[TD="align: right"]16027.03[/TD]
[TD="align: right"][/TD]
[TD="align: right"]15540.6763[/TD]
[TD="align: right"]15540.6763[/TD]
[TD="align: right"]14091.495[/TD]
[TD="align: right"]14133.5963[/TD]
[TD="align: right"]13006.2598[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]27[/TD]
[TD="align: right"]6021[/TD]
[TD="align: right"]28210.97[/TD]
[TD="align: right"]23378.14[/TD]
[TD="align: right"]24129.61[/TD]
[TD="align: right"]25831.29[/TD]
[TD="align: right"]25960.44[/TD]
[TD="align: right"][/TD]
[TD="align: right"]27015.7604[/TD]
[TD="align: right"]23420.9839[/TD]
[TD="align: right"]25158.6226[/TD]
[TD="align: right"]26414.6149[/TD]
[TD="align: right"]25694.6451[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]28[/TD]
[TD="align: right"]6022[/TD]
[TD="align: right"]25364.97[/TD]
[TD="align: right"]23400.21[/TD]
[TD="align: right"]22380.95[/TD]
[TD="align: right"]26094.93[/TD]
[TD="align: right"]24862.6[/TD]
[TD="align: right"][/TD]
[TD="align: right"]22978.1597[/TD]
[TD="align: right"]21211.8406[/TD]
[TD="align: right"]25047.186[/TD]
[TD="align: right"]24187.8924[/TD]
[TD="align: right"]23746.5293[/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"]6023[/TD]
[TD="align: right"]23241.87[/TD]
[TD="align: right"]19150.08[/TD]
[TD="align: right"]19511.77[/TD]
[TD="align: right"]21040.38[/TD]
[TD="align: right"]20718.43[/TD]
[TD="align: right"][/TD]
[TD="align: right"]22673.9904[/TD]
[TD="align: right"]19797.1913[/TD]
[TD="align: right"]22691.7449[/TD]
[TD="align: right"]21612.9073[/TD]
[TD="align: right"]21789.1874[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]30[/TD]
[TD="align: right"]6024[/TD]
[TD="align: right"]26275.05[/TD]
[TD="align: right"]23232.33[/TD]
[TD="align: right"]22823.12[/TD]
[TD="align: right"]24196.46[/TD]
[TD="align: right"]25220.02[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25916.0535[/TD]
[TD="align: right"]25862.4635[/TD]
[TD="align: right"]26837.2683[/TD]
[TD="align: right"]26378.6819[/TD]
[TD="align: right"]23797.1073[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]31[/TD]
[TD="align: right"]6025[/TD]
[TD="align: right"]16654.4[/TD]
[TD="align: right"]16606.33[/TD]
[TD="align: right"]16238.04[/TD]
[TD="align: right"]17218.49[/TD]
[TD="align: right"]17530.94[/TD]
[TD="align: right"][/TD]
[TD="align: right"]16222.1661[/TD]
[TD="align: right"]14410.6994[/TD]
[TD="align: right"]17187.4121[/TD]
[TD="align: right"]17650.9345[/TD]
[TD="align: right"]16510.5476[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]32[/TD]
[TD="align: right"]6026[/TD]
[TD="align: right"]22471.6[/TD]
[TD="align: right"]16042.59[/TD]
[TD="align: right"]17649.92[/TD]
[TD="align: right"]19254.46[/TD]
[TD="align: right"]21435.26[/TD]
[TD="align: right"][/TD]
[TD="align: right"]23280.0728[/TD]
[TD="align: right"]23743.4219[/TD]
[TD="align: right"]22891.065[/TD]
[TD="align: right"]24253.5225[/TD]
[TD="align: right"]24228.3758[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]33[/TD]
[TD="align: right"]6027[/TD]
[TD="align: right"]23328.91[/TD]
[TD="align: right"]17070.95[/TD]
[TD="align: right"]18710.31[/TD]
[TD="align: right"]21783.61[/TD]
[TD="align: right"]21983.96[/TD]
[TD="align: right"][/TD]
[TD="align: right"]24150.2575[/TD]
[TD="align: right"]20457.9893[/TD]
[TD="align: right"]19957.1975[/TD]
[TD="align: right"]22597.7284[/TD]
[TD="align: right"]22875.6225[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]34[/TD]
[TD="align: right"]6028[/TD]
[TD="align: right"]20519.88[/TD]
[TD="align: right"]17287.43[/TD]
[TD="align: right"]17358.75[/TD]
[TD="align: right"]17892.15[/TD]
[TD="align: right"]19141.59[/TD]
[TD="align: right"][/TD]
[TD="align: right"]18042.0385[/TD]
[TD="align: right"]18307.0461[/TD]
[TD="align: right"]19251.4621[/TD]
[TD="align: right"]19288.9645[/TD]
[TD="align: right"]16603.7008[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]35[/TD]
[TD="align: right"]6029[/TD]
[TD="align: right"]22212.83[/TD]
[TD="align: right"]18942.54[/TD]
[TD="align: right"]20326.63[/TD]
[TD="align: right"]21369.87[/TD]
[TD="align: right"]21891.78[/TD]
[TD="align: right"][/TD]
[TD="align: right"]21747.9111[/TD]
[TD="align: right"]20085.1915[/TD]
[TD="align: right"]22195.5183[/TD]
[TD="align: right"]21582.6998[/TD]
[TD="align: right"]21329.5131[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]36[/TD]
[TD="align: right"]6031[/TD]
[TD="align: right"]22523.86[/TD]
[TD="align: right"]19788.18[/TD]
[TD="align: right"]11820.02[/TD]
[TD="align: right"]21546.83[/TD]
[TD="align: right"]20783.27[/TD]
[TD="align: right"][/TD]
[TD="align: right"]21322.4508[/TD]
[TD="align: right"]18423.8259[/TD]
[TD="align: right"]19439.2623[/TD]
[TD="align: right"]21393.7312[/TD]
[TD="align: right"]20415.01[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]37[/TD]
[TD="align: right"]6032[/TD]
[TD="align: right"]19719.95[/TD]
[TD="align: right"]16291.66[/TD]
[TD="align: right"]18012.94[/TD]
[TD="align: right"]18069.66[/TD]
[TD="align: right"]19306.6[/TD]
[TD="align: right"][/TD]
[TD="align: right"]23215.89[/TD]
[TD="align: right"]23215.89[/TD]
[TD="align: right"]22423.98[/TD]
[TD="align: right"]19424.795[/TD]
[TD="align: right"]11132.8274[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]38[/TD]
[TD="align: right"]6033[/TD]
[TD="align: right"]31037.97[/TD]
[TD="align: right"]28336.27[/TD]
[TD="align: right"]26934.88[/TD]
[TD="align: right"]29060.5[/TD]
[TD="align: right"]29298.84[/TD]
[TD="align: right"][/TD]
[TD="align: right"]28517.0388[/TD]
[TD="align: right"]25628.0563[/TD]
[TD="align: right"]28232.0345[/TD]
[TD="align: right"]28229.8572[/TD]
[TD="align: right"]26732.7125[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]39[/TD]
[TD="align: right"]6034[/TD]
[TD="align: right"]23167.23[/TD]
[TD="align: right"]20112.59[/TD]
[TD="align: right"]19338.23[/TD]
[TD="align: right"]21844.32[/TD]
[TD="align: right"]23052.95[/TD]
[TD="align: right"][/TD]
[TD="align: right"]28171.6467[/TD]
[TD="align: right"]28171.6467[/TD]
[TD="align: right"]23960.5075[/TD]
[TD="align: right"]20532.2395[/TD]
[TD="align: right"]20043.7887[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]40[/TD]
[TD="align: right"]6035[/TD]
[TD="align: right"]17380.46[/TD]
[TD="align: right"]14660.68[/TD]
[TD="align: right"]15082.65[/TD]
[TD="align: right"]17306.13[/TD]
[TD="align: right"]17549.2[/TD]
[TD="align: right"][/TD]
[TD="align: right"]18934.8881[/TD]
[TD="align: right"]17622.8645[/TD]
[TD="align: right"]18602.3775[/TD]
[TD="align: right"]18674.0128[/TD]
[TD="align: right"]18717.0913[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]41[/TD]
[TD="align: right"]6036[/TD]
[TD="align: right"]29754.85[/TD]
[TD="align: right"]26617.85[/TD]
[TD="align: right"]26827.62[/TD]
[TD="align: right"]28858.24[/TD]
[TD="align: right"]29409.32[/TD]
[TD="align: right"][/TD]
[TD="align: right"]27624.7344[/TD]
[TD="align: right"]24600.4366[/TD]
[TD="align: right"]27306.1057[/TD]
[TD="align: right"]28444.209[/TD]
[TD="align: right"]26864.2914[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]42[/TD]
[TD="align: right"]6037[/TD]
[TD="align: right"]32466.83[/TD]
[TD="align: right"]27200.57[/TD]
[TD="align: right"]29044.57[/TD]
[TD="align: right"]30752.5[/TD]
[TD="align: right"]32204.91[/TD]
[TD="align: right"][/TD]
[TD="align: right"]29743.8771[/TD]
[TD="align: right"]27581.8052[/TD]
[TD="align: right"]30749.2225[/TD]
[TD="align: right"]30623.9168[/TD]
[TD="align: right"]30423.2492[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]43[/TD]
[TD="align: right"]6038[/TD]
[TD="align: right"]23126.87[/TD]
[TD="align: right"]20096.38[/TD]
[TD="align: right"]20907.67[/TD]
[TD="align: right"]21061.87[/TD]
[TD="align: right"]22786.85[/TD]
[TD="align: right"][/TD]
[TD="align: right"]24268.0841[/TD]
[TD="align: right"]24268.0841[/TD]
[TD="align: right"]21449.8875[/TD]
[TD="align: right"]18954.1493[/TD]
[TD="align: right"]19658.5125[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]44[/TD]
[TD="align: right"]6050[/TD]
[TD="align: right"]26493.83[/TD]
[TD="align: right"]27123.35[/TD]
[TD="align: right"]27272.37[/TD]
[TD="align: right"]27157.64[/TD]
[TD="align: right"]29308.03[/TD]
[TD="align: right"][/TD]
[TD="align: right"]26459.9827[/TD]
[TD="align: right"]26595.6821[/TD]
[TD="align: right"]25158.8529[/TD]
[TD="align: right"]25229.2248[/TD]
[TD="align: right"]25859.6062[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]45[/TD]
[TD="align: right"]6051[/TD]
[TD="align: right"]21747.25[/TD]
[TD="align: right"]21345.05[/TD]
[TD="align: right"]20791.67[/TD]
[TD="align: right"]21056.77[/TD]
[TD="align: right"]21133.63[/TD]
[TD="align: right"][/TD]
[TD="align: right"]23347.4026[/TD]
[TD="align: right"]23347.4026[/TD]
[TD="align: right"]21008.005[/TD]
[TD="align: right"]20287.5125[/TD]
[TD="align: right"]20253.8475[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]46[/TD]
[TD="align: right"]6052[/TD]
[TD="align: right"]30323.62[/TD]
[TD="align: right"]28648.79[/TD]
[TD="align: right"]28665.88[/TD]
[TD="align: right"]28901.25[/TD]
[TD="align: right"]28211.4[/TD]
[TD="align: right"][/TD]
[TD="align: right"]28584.1139[/TD]
[TD="align: right"]30280.4598[/TD]
[TD="align: right"]28002.9974[/TD]
[TD="align: right"]28850.193[/TD]
[TD="align: right"]27337.7266[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]47[/TD]
[TD="align: right"]6053[/TD]
[TD="align: right"]26680.49[/TD]
[TD="align: right"]26908.92[/TD]
[TD="align: right"]26921.59[/TD]
[TD="align: right"]27593.35[/TD]
[TD="align: right"]25711.31[/TD]
[TD="align: right"][/TD]
[TD="align: right"]26361.5916[/TD]
[TD="align: right"]26833.7515[/TD]
[TD="align: right"]25648.5046[/TD]
[TD="align: right"]25414.2701[/TD]
[TD="align: right"]24391.6721[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]48[/TD]
[TD="align: right"]6054[/TD]
[TD="align: right"]31809.39[/TD]
[TD="align: right"]32224.15[/TD]
[TD="align: right"]30799.53[/TD]
[TD="align: right"]32904.17[/TD]
[TD="align: right"]33099.43[/TD]
[TD="align: right"][/TD]
[TD="align: right"]31093.1173[/TD]
[TD="align: right"]30578.2879[/TD]
[TD="align: right"]28106.2143[/TD]
[TD="align: right"]29451.0997[/TD]
[TD="align: right"]29553.0929[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]49[/TD]
[TD="align: right"]6055[/TD]
[TD="align: right"]29168.86[/TD]
[TD="align: right"]28621.64[/TD]
[TD="align: right"]28156.83[/TD]
[TD="align: right"]28526.54[/TD]
[TD="align: right"]30645.2[/TD]
[TD="align: right"][/TD]
[TD="align: right"]29411.1902[/TD]
[TD="align: right"]30172.8017[/TD]
[TD="align: right"]26572.1984[/TD]
[TD="align: right"]28608.0125[/TD]
[TD="align: right"]28903.9314[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]50[/TD]
[TD="align: right"]6057[/TD]
[TD="align: right"]22752.46[/TD]
[TD="align: right"]22349.61[/TD]
[TD="align: right"]21510.52[/TD]
[TD="align: right"]21407.33[/TD]
[TD="align: right"]21666.45[/TD]
[TD="align: right"][/TD]
[TD="align: right"]21146.8956[/TD]
[TD="align: right"]20229.2072[/TD]
[TD="align: right"]19676.9031[/TD]
[TD="align: right"]20450.6013[/TD]
[TD="align: right"]19738.4136[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]51[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]21855.5[/TD]
[TD="align: right"]21654.11[/TD]
[TD="align: right"]22259.21[/TD]
[TD="align: right"]22007.95[/TD]
[TD="align: right"]21891.76[/TD]
[TD="align: right"][/TD]
[TD="align: right"]20403.9317[/TD]
[TD="align: right"]21412.7689[/TD]
[TD="align: right"]20100.3493[/TD]
[TD="align: right"]21160.0704[/TD]
[TD="align: right"]20808.6321[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]52[/TD]
[TD="align: right"]6059[/TD]
[TD="align: right"]22534.59[/TD]
[TD="align: right"]23134.44[/TD]
[TD="align: right"]21798.42[/TD]
[TD="align: right"]22736.4[/TD]
[TD="align: right"]22842.3[/TD]
[TD="align: right"][/TD]
[TD="align: right"]21501.7168[/TD]
[TD="align: right"]21501.7168[/TD]
[TD="align: right"]21574.3976[/TD]
[TD="align: right"]22588.56[/TD]
[TD="align: right"]21245.6739[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]53[/TD]
[TD="align: right"]6060[/TD]
[TD="align: right"]19130.06[/TD]
[TD="align: right"]17837.39[/TD]
[TD="align: right"]18708.91[/TD]
[TD="align: right"]18443.63[/TD]
[TD="align: right"]19756.2[/TD]
[TD="align: right"][/TD]
[TD="align: right"]16390.1427[/TD]
[TD="align: right"]15870.3618[/TD]
[TD="align: right"]15789.6144[/TD]
[TD="align: right"]16402.2408[/TD]
[TD="align: right"]15793.7036[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]54[/TD]
[TD="align: right"]6061[/TD]
[TD="align: right"]35056.54[/TD]
[TD="align: right"]34419.52[/TD]
[TD="align: right"]33319.73[/TD]
[TD="align: right"]33751.84[/TD]
[TD="align: right"]33692.66[/TD]
[TD="align: right"][/TD]
[TD="align: right"]33163.4144[/TD]
[TD="align: right"]33720.0387[/TD]
[TD="align: right"]30880.5295[/TD]
[TD="align: right"]32450.1221[/TD]
[TD="align: right"]33079.268[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]55[/TD]
[TD="align: right"]6062[/TD]
[TD="align: right"]28886.43[/TD]
[TD="align: right"]27157.92[/TD]
[TD="align: right"]26693.15[/TD]
[TD="align: right"]26770.67[/TD]
[TD="align: right"]28558.31[/TD]
[TD="align: right"][/TD]
[TD="align: right"]32092.7137[/TD]
[TD="align: right"]32092.7137[/TD]
[TD="align: right"]30404.475[/TD]
[TD="align: right"]28764.1075[/TD]
[TD="align: right"]28609.865[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]56[/TD]
[TD="align: right"]6063[/TD]
[TD="align: right"]25291.21[/TD]
[TD="align: right"]26487.55[/TD]
[TD="align: right"]23520.09[/TD]
[TD="align: right"]25660.95[/TD]
[TD="align: right"]25903.64[/TD]
[TD="align: right"][/TD]
[TD="align: right"]24283.9025[/TD]
[TD="align: right"]23938.8647[/TD]
[TD="align: right"]22730.8924[/TD]
[TD="align: right"]23909.2155[/TD]
[TD="align: right"]23718.9905[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]57[/TD]
[TD="align: right"]6064[/TD]
[TD="align: right"]26172.5[/TD]
[TD="align: right"]25863.72[/TD]
[TD="align: right"]24873.3[/TD]
[TD="align: right"]24651.79[/TD]
[TD="align: right"]26320.13[/TD]
[TD="align: right"][/TD]
[TD="align: right"]27876.381[/TD]
[TD="align: right"]27875.092[/TD]
[TD="align: right"]28652.8637[/TD]
[TD="align: right"]28857.0511[/TD]
[TD="align: right"]28734.6853[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]58[/TD]
[TD="align: right"]6065[/TD]
[TD="align: right"]25357.98[/TD]
[TD="align: right"]24717.23[/TD]
[TD="align: right"]24134.48[/TD]
[TD="align: right"]24700.86[/TD]
[TD="align: right"]25279.14[/TD]
[TD="align: right"][/TD]
[TD="align: right"]24824.4517[/TD]
[TD="align: right"]24405.4897[/TD]
[TD="align: right"]23663.5546[/TD]
[TD="align: right"]24193.0162[/TD]
[TD="align: right"]25000.7345[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]59[/TD]
[TD="align: right"]6066[/TD]
[TD="align: right"]27414.59[/TD]
[TD="align: right"]25864.45[/TD]
[TD="align: right"]26062.7[/TD]
[TD="align: right"]26208.6[/TD]
[TD="align: right"]26078.56[/TD]
[TD="align: right"][/TD]
[TD="align: right"]27808.9167[/TD]
[TD="align: right"]26792.6832[/TD]
[TD="align: right"]26658.0883[/TD]
[TD="align: right"]26443.748[/TD]
[TD="align: right"]26658.5624[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]60[/TD]
[TD="align: right"]6067[/TD]
[TD="align: right"]37513.23[/TD]
[TD="align: right"]35988.42[/TD]
[TD="align: right"]34485.5[/TD]
[TD="align: right"]34872.18[/TD]
[TD="align: right"]36934.46[/TD]
[TD="align: right"][/TD]
[TD="align: right"]36861.7316[/TD]
[TD="align: right"]35898.623[/TD]
[TD="align: right"]35423.5289[/TD]
[TD="align: right"]36017.4789[/TD]
[TD="align: right"]37226.9805[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]61[/TD]
[TD="align: right"]6068[/TD]
[TD="align: right"]31035.12[/TD]
[TD="align: right"]30319.19[/TD]
[TD="align: right"]29410[/TD]
[TD="align: right"]30716.24[/TD]
[TD="align: right"]29696.49[/TD]
[TD="align: right"][/TD]
[TD="align: right"]28937.1355[/TD]
[TD="align: right"]29889.5761[/TD]
[TD="align: right"]29115.5573[/TD]
[TD="align: right"]29407.1496[/TD]
[TD="align: right"]29730.1044[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]62[/TD]
[TD="align: right"]6069[/TD]
[TD="align: right"]22009.5[/TD]
[TD="align: right"]23185.84[/TD]
[TD="align: right"]22804.95[/TD]
[TD="align: right"]23727.35[/TD]
[TD="align: right"]24369.69[/TD]
[TD="align: right"][/TD]
[TD="align: right"]22391.9677[/TD]
[TD="align: right"]22007.301[/TD]
[TD="align: right"]20575.2774[/TD]
[TD="align: right"]21739.114[/TD]
[TD="align: right"]21983.4582[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]63[/TD]
[TD="align: right"]6071[/TD]
[TD="align: right"]39678.72[/TD]
[TD="align: right"]38725.47[/TD]
[TD="align: right"]38768.78[/TD]
[TD="align: right"]39398.14[/TD]
[TD="align: right"]40628.55[/TD]
[TD="align: right"][/TD]
[TD="align: right"]38194.9484[/TD]
[TD="align: right"]38403.5583[/TD]
[TD="align: right"]38140.7658[/TD]
[TD="align: right"]39063.4131[/TD]
[TD="align: right"]38554.8659[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]64[/TD]
[TD="align: right"]6072[/TD]
[TD="align: right"]35493.29[/TD]
[TD="align: right"]34900.25[/TD]
[TD="align: right"]33971.36[/TD]
[TD="align: right"]35366.03[/TD]
[TD="align: right"]36424.55[/TD]
[TD="align: right"][/TD]
[TD="align: right"]35762.3735[/TD]
[TD="align: right"]36500.5251[/TD]
[TD="align: right"]34877.0359[/TD]
[TD="align: right"]36759.6746[/TD]
[TD="align: right"]36433.1284[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]65[/TD]
[TD="align: right"]6073[/TD]
[TD="align: right"]21338.51[/TD]
[TD="align: right"]21292.52[/TD]
[TD="align: right"]21592.92[/TD]
[TD="align: right"]20122.65[/TD]
[TD="align: right"]22678.78[/TD]
[TD="align: right"][/TD]
[TD="align: right"]19916.9364[/TD]
[TD="align: right"]18987.2312[/TD]
[TD="align: right"]18718.9421[/TD]
[TD="align: right"]19339.0702[/TD]
[TD="align: right"]19785.5109[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]66[/TD]
[TD="align: right"]6074[/TD]
[TD="align: right"]32025.13[/TD]
[TD="align: right"]32692.77[/TD]
[TD="align: right"]31837.36[/TD]
[TD="align: right"]32317.24[/TD]
[TD="align: right"]34409.59[/TD]
[TD="align: right"][/TD]
[TD="align: right"]33964.7225[/TD]
[TD="align: right"]33964.7225[/TD]
[TD="align: right"]29864.73[/TD]
[TD="align: right"]30500.255[/TD]
[TD="align: right"]30428.45[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]67[/TD]
[TD="align: right"]6075[/TD]
[TD="align: right"]20219.45[/TD]
[TD="align: right"]18920.2[/TD]
[TD="align: right"]16563.31[/TD]
[TD="align: right"]20571.68[/TD]
[TD="align: right"]19068.14[/TD]
[TD="align: right"][/TD]
[TD="align: right"]17569.3895[/TD]
[TD="align: right"]19623.8433[/TD]
[TD="align: right"]18978.83[/TD]
[TD="align: right"]18819.1063[/TD]
[TD="align: right"]18149.4118[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]68[/TD]
[TD="align: right"]6076[/TD]
[TD="align: right"]26824.45[/TD]
[TD="align: right"]30724.12[/TD]
[TD="align: right"]31470.97[/TD]
[TD="align: right"]30573.08[/TD]
[TD="align: right"]33503[/TD]
[TD="align: right"][/TD]
[TD="align: right"]26269.4431[/TD]
[TD="align: right"]28804.2463[/TD]
[TD="align: right"]29393.8816[/TD]
[TD="align: right"]30094.5902[/TD]
[TD="align: right"]29986.6542[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]69[/TD]
[TD="align: right"]6077[/TD]
[TD="align: right"]35076.4[/TD]
[TD="align: right"]34921.67[/TD]
[TD="align: right"]33983.19[/TD]
[TD="align: right"]33171.31[/TD]
[TD="align: right"]35337.37[/TD]
[TD="align: right"][/TD]
[TD="align: right"]34054.7317[/TD]
[TD="align: right"]34741.2644[/TD]
[TD="align: right"]32534.4518[/TD]
[TD="align: right"]34725.3038[/TD]
[TD="align: right"]34686.3201[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]70[/TD]
[TD="align: right"]6078[/TD]
[TD="align: right"]22742.44[/TD]
[TD="align: right"]22590.05[/TD]
[TD="align: right"]20905.29[/TD]
[TD="align: right"]22710.79[/TD]
[TD="align: right"]22428.51[/TD]
[TD="align: right"][/TD]
[TD="align: right"]21041.7723[/TD]
[TD="align: right"]21000.8013[/TD]
[TD="align: right"]21186.7216[/TD]
[TD="align: right"]22370.3862[/TD]
[TD="align: right"]21883.7834[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]71[/TD]
[TD="align: right"]6079[/TD]
[TD="align: right"]29305.11[/TD]
[TD="align: right"]29417.94[/TD]
[TD="align: right"]27850.25[/TD]
[TD="align: right"]29750.07[/TD]
[TD="align: right"]29899.85[/TD]
[TD="align: right"][/TD]
[TD="align: right"]27481.2164[/TD]
[TD="align: right"]26788.2721[/TD]
[TD="align: right"]28965.875[/TD]
[TD="align: right"]30089.2185[/TD]
[TD="align: right"]31391.2416[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]72[/TD]
[TD="align: right"]6081[/TD]
[TD="align: right"]30462.67[/TD]
[TD="align: right"]33185.3[/TD]
[TD="align: right"]32232.13[/TD]
[TD="align: right"]33896.79[/TD]
[TD="align: right"]37517.52[/TD]
[TD="align: right"][/TD]
[TD="align: right"]40244.6475[/TD]
[TD="align: right"]39625.3494[/TD]
[TD="align: right"]38573.5923[/TD]
[TD="align: right"]37856.6648[/TD]
[TD="align: right"]38523.0697[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]73[/TD]
[TD="align: right"]6082[/TD]
[TD="align: right"]29967.58[/TD]
[TD="align: right"]32010.4[/TD]
[TD="align: right"]29892.15[/TD]
[TD="align: right"]32416.64[/TD]
[TD="align: right"]31650.42[/TD]
[TD="align: right"][/TD]
[TD="align: right"]29744.3027[/TD]
[TD="align: right"]30533.6561[/TD]
[TD="align: right"]29103.7342[/TD]
[TD="align: right"]30997.8969[/TD]
[TD="align: right"]30237.5455[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]74[/TD]
[TD="align: right"]6083[/TD]
[TD="align: right"]25998.81[/TD]
[TD="align: right"]24372.67[/TD]
[TD="align: right"]24682.88[/TD]
[TD="align: right"]24339.71[/TD]
[TD="align: right"]26047.66[/TD]
[TD="align: right"][/TD]
[TD="align: right"]23432.4983[/TD]
[TD="align: right"]22711.4337[/TD]
[TD="align: right"]22884.2923[/TD]
[TD="align: right"]23294.5508[/TD]
[TD="align: right"]23534.585[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]75[/TD]
[TD="align: right"]6084[/TD]
[TD="align: right"]19970.93[/TD]
[TD="align: right"]19263.42[/TD]
[TD="align: right"]19266.24[/TD]
[TD="align: right"]19709.77[/TD]
[TD="align: right"]20145.08[/TD]
[TD="align: right"][/TD]
[TD="align: right"]19317.6172[/TD]
[TD="align: right"]19595.7053[/TD]
[TD="align: right"]18505.8858[/TD]
[TD="align: right"]18434.6254[/TD]
[TD="align: right"]17707.9117[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]76[/TD]
[TD="align: right"]6086[/TD]
[TD="align: right"]26617.18[/TD]
[TD="align: right"]28792.75[/TD]
[TD="align: right"]26255.83[/TD]
[TD="align: right"]27167.68[/TD]
[TD="align: right"]28403.7[/TD]
[TD="align: right"][/TD]
[TD="align: right"]26008.3418[/TD]
[TD="align: right"]26437.3274[/TD]
[TD="align: right"]26379.2212[/TD]
[TD="align: right"]27014.7084[/TD]
[TD="align: right"]27404.8869[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]77[/TD]
[TD="align: right"]6087[/TD]
[TD="align: right"]27962.45[/TD]
[TD="align: right"]29125.43[/TD]
[TD="align: right"]27941.31[/TD]
[TD="align: right"]29009.47[/TD]
[TD="align: right"]29207.17[/TD]
[TD="align: right"][/TD]
[TD="align: right"]28167.1024[/TD]
[TD="align: right"]26872.5836[/TD]
[TD="align: right"]26689.7062[/TD]
[TD="align: right"]27640.3673[/TD]
[TD="align: right"]28198.586[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]78[/TD]
[TD="align: right"]6088[/TD]
[TD="align: right"]18240.25[/TD]
[TD="align: right"]18846.67[/TD]
[TD="align: right"]18460.28[/TD]
[TD="align: right"]18958.52[/TD]
[TD="align: right"]19558.34[/TD]
[TD="align: right"][/TD]
[TD="align: right"]19024.1981[/TD]
[TD="align: right"]18244.8942[/TD]
[TD="align: right"]18261.9523[/TD]
[TD="align: right"]19043.8131[/TD]
[TD="align: right"]18042.4677[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]79[/TD]
[TD="align: right"]6089[/TD]
[TD="align: right"]31892.56[/TD]
[TD="align: right"]31376.77[/TD]
[TD="align: right"]30795.16[/TD]
[TD="align: right"]31541.96[/TD]
[TD="align: right"]32000.1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]31942.2903[/TD]
[TD="align: right"]30358.1583[/TD]
[TD="align: right"]29747.4514[/TD]
[TD="align: right"]30411.3311[/TD]
[TD="align: right"]31211.5066[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]80[/TD]
[TD="align: right"]6090[/TD]
[TD="align: right"]30991.29[/TD]
[TD="align: right"]29096.61[/TD]
[TD="align: right"]27618.07[/TD]
[TD="align: right"]29735.43[/TD]
[TD="align: right"]28560.61[/TD]
[TD="align: right"][/TD]
[TD="align: right"]29965.0956[/TD]
[TD="align: right"]28544.0138[/TD]
[TD="align: right"]28235.1428[/TD]
[TD="align: right"]29612.3136[/TD]
[TD="align: right"]29418.5009[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]81[/TD]
[TD="align: right"]6091[/TD]
[TD="align: right"]25497.92[/TD]
[TD="align: right"]25808.67[/TD]
[TD="align: right"]23398.83[/TD]
[TD="align: right"]24852.04[/TD]
[TD="align: right"]25827.08[/TD]
[TD="align: right"][/TD]
[TD="align: right"]30304.9855[/TD]
[TD="align: right"]30222.012[/TD]
[TD="align: right"]30365.8477[/TD]
[TD="align: right"]30257.9607[/TD]
[TD="align: right"]31497.6979[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]82[/TD]
[TD="align: right"]6092[/TD]
[TD="align: right"]12275.44[/TD]
[TD="align: right"]12773.44[/TD]
[TD="align: right"]12362.72[/TD]
[TD="align: right"]17287.84[/TD]
[TD="align: right"]15838.27[/TD]
[TD="align: right"][/TD]
[TD="align: right"]14343.8273[/TD]
[TD="align: right"]14343.8273[/TD]
[TD="align: right"]14332.9439[/TD]
[TD="align: right"]14093.257[/TD]
[TD="align: right"]16838.5346[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]83[/TD]
[TD="align: right"]6093[/TD]
[TD="align: right"]26765.75[/TD]
[TD="align: right"]26307.44[/TD]
[TD="align: right"]24899.4[/TD]
[TD="align: right"]26080.03[/TD]
[TD="align: right"]26414.01[/TD]
[TD="align: right"][/TD]
[TD="align: right"]26060.492[/TD]
[TD="align: right"]26362.7724[/TD]
[TD="align: right"]26079.4803[/TD]
[TD="align: right"]26849.2719[/TD]
[TD="align: right"]25923.5841[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]84[/TD]
[TD="align: right"]6094[/TD]
[TD="align: right"]30939.68[/TD]
[TD="align: right"]33455.85[/TD]
[TD="align: right"]31901.12[/TD]
[TD="align: right"]32860.93[/TD]
[TD="align: right"]33823.37[/TD]
[TD="align: right"][/TD]
[TD="align: right"]30227.1597[/TD]
[TD="align: right"]31521.4684[/TD]
[TD="align: right"]29362.4913[/TD]
[TD="align: right"]30945.4521[/TD]
[TD="align: right"]30864.7824[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]85[/TD]
[TD="align: right"]6095[/TD]
[TD="align: right"]28840.47[/TD]
[TD="align: right"]30818.42[/TD]
[TD="align: right"]27551.95[/TD]
[TD="align: right"]29280.36[/TD]
[TD="align: right"]29673.11[/TD]
[TD="align: right"][/TD]
[TD="align: right"]29889.2808[/TD]
[TD="align: right"]29638.1721[/TD]
[TD="align: right"]28610.6782[/TD]
[TD="align: right"]29694.9704[/TD]
[TD="align: right"]30165.9958[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]86[/TD]
[TD="align: right"]6096[/TD]
[TD="align: right"]21772.1[/TD]
[TD="align: right"]21975.41[/TD]
[TD="align: right"]20838.5[/TD]
[TD="align: right"]22261.07[/TD]
[TD="align: right"]22338.19[/TD]
[TD="align: right"][/TD]
[TD="align: right"]22478.2183[/TD]
[TD="align: right"]22102.0075[/TD]
[TD="align: right"]21582.8586[/TD]
[TD="align: right"]21575.0917[/TD]
[TD="align: right"]21481.3072[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]87[/TD]
[TD="align: right"]6097[/TD]
[TD="align: right"]27906.53[/TD]
[TD="align: right"]28049.99[/TD]
[TD="align: right"]27188.69[/TD]
[TD="align: right"]28406.12[/TD]
[TD="align: right"]27855.8[/TD]
[TD="align: right"][/TD]
[TD="align: right"]29179.0944[/TD]
[TD="align: right"]27677.4781[/TD]
[TD="align: right"]27165.3671[/TD]
[TD="align: right"]27272.3304[/TD]
[TD="align: right"]27487.5386[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]88[/TD]
[TD="align: right"]6098[/TD]
[TD="align: right"]22536.49[/TD]
[TD="align: right"]22616.72[/TD]
[TD="align: right"]21628.87[/TD]
[TD="align: right"]21405.98[/TD]
[TD="align: right"]22825.92[/TD]
[TD="align: right"][/TD]
[TD="align: right"]27455.0476[/TD]
[TD="align: right"]27455.0476[/TD]
[TD="align: right"]22897.11[/TD]
[TD="align: right"]23044.13[/TD]
[TD="align: right"]22029.09[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]89[/TD]
[TD="align: right"]6099[/TD]
[TD="align: right"]27037.28[/TD]
[TD="align: right"]25962.29[/TD]
[TD="align: right"]26768.22[/TD]
[TD="align: right"]25589.87[/TD]
[TD="align: right"]26826.12[/TD]
[TD="align: right"][/TD]
[TD="align: right"]26563.4115[/TD]
[TD="align: right"]26340.5795[/TD]
[TD="align: right"]24768.5769[/TD]
[TD="align: right"]24158.7709[/TD]
[TD="align: right"]24749.5523[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]90[/TD]
[TD="align: right"]6100[/TD]
[TD="align: right"]29529.92[/TD]
[TD="align: right"]29826.07[/TD]
[TD="align: right"]28264.02[/TD]
[TD="align: right"]28230.2[/TD]
[TD="align: right"]31260.25[/TD]
[TD="align: right"][/TD]
[TD="align: right"]30028.0467[/TD]
[TD="align: right"]29659.3928[/TD]
[TD="align: right"]28394.1938[/TD]
[TD="align: right"]28854.0419[/TD]
[TD="align: right"]29061.8597[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]91[/TD]
[TD="align: right"]6101[/TD]
[TD="align: right"]38149.88[/TD]
[TD="align: right"]39838.2[/TD]
[TD="align: right"]38431.07[/TD]
[TD="align: right"]38910.88[/TD]
[TD="align: right"]41040.79[/TD]
[TD="align: right"][/TD]
[TD="align: right"]40732.0205[/TD]
[TD="align: right"]42015.2407[/TD]
[TD="align: right"]40546.4703[/TD]
[TD="align: right"]41473.0708[/TD]
[TD="align: right"]42047.3156[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]92[/TD]
[TD="align: right"]6103[/TD]
[TD="align: right"]18747.67[/TD]
[TD="align: right"]20113.63[/TD]
[TD="align: right"]19315.71[/TD]
[TD="align: right"]20131.29[/TD]
[TD="align: right"]22400.12[/TD]
[TD="align: right"][/TD]
[TD="align: right"]23938.776[/TD]
[TD="align: right"]23938.776[/TD]
[TD="align: right"]19677.7688[/TD]
[TD="align: right"]21593.0325[/TD]
[TD="align: right"]20674.6724[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]93[/TD]
[TD="align: right"]6104[/TD]
[TD="align: right"]16164.49[/TD]
[TD="align: right"]16877.74[/TD]
[TD="align: right"]15279.11[/TD]
[TD="align: right"]17364.07[/TD]
[TD="align: right"]17172.88[/TD]
[TD="align: right"][/TD]
[TD="align: right"]14652.8492[/TD]
[TD="align: right"]16009.5451[/TD]
[TD="align: right"]13592.8243[/TD]
[TD="align: right"]14620.9913[/TD]
[TD="align: right"]15581.4165[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]94[/TD]
[TD="align: right"]6105[/TD]
[TD="align: right"]22107.84[/TD]
[TD="align: right"]22829.54[/TD]
[TD="align: right"]20914.33[/TD]
[TD="align: right"]21758.58[/TD]
[TD="align: right"]22780.16[/TD]
[TD="align: right"][/TD]
[TD="align: right"]23615.1796[/TD]
[TD="align: right"]23615.1796[/TD]
[TD="align: right"]21811.785[/TD]
[TD="align: right"]22045.7475[/TD]
[TD="align: right"]20165.3643[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]95[/TD]
[TD="align: right"]6106[/TD]
[TD="align: right"]19023.44[/TD]
[TD="align: right"]18391.7[/TD]
[TD="align: right"]17414.97[/TD]
[TD="align: right"]18295.4[/TD]
[TD="align: right"]19540.64[/TD]
[TD="align: right"][/TD]
[TD="align: right"]24533.7607[/TD]
[TD="align: right"]24533.7607[/TD]
[TD="align: right"]20076.2516[/TD]
[TD="align: right"]19601.5079[/TD]
[TD="align: right"]18005.3603[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]96[/TD]
[TD="align: right"]6200[/TD]
[TD="align: right"]30566.1[/TD]
[TD="align: right"]28188.99[/TD]
[TD="align: right"]28950.61[/TD]
[TD="align: right"]27956.92[/TD]
[TD="align: right"]30725.52[/TD]
[TD="align: right"][/TD]
[TD="align: right"]32964.3607[/TD]
[TD="align: right"]32964.3607[/TD]
[TD="align: right"]29836.105[/TD]
[TD="align: right"]27892.365[/TD]
[TD="align: right"]27941.1275[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]97[/TD]
[TD="align: right"]6201[/TD]
[TD="align: right"]35368.42[/TD]
[TD="align: right"]31001.6[/TD]
[TD="align: right"]33810.41[/TD]
[TD="align: right"]33712.13[/TD]
[TD="align: right"]37087.36[/TD]
[TD="align: right"][/TD]
[TD="align: right"]29048.6693[/TD]
[TD="align: right"]33185.3662[/TD]
[TD="align: right"]27701.8991[/TD]
[TD="align: right"]33028.0275[/TD]
[TD="align: right"]33562.5737[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]98[/TD]
[TD="align: right"]6202[/TD]
[TD="align: right"]41735.09[/TD]
[TD="align: right"]34362.47[/TD]
[TD="align: right"]37262.14[/TD]
[TD="align: right"]38948.34[/TD]
[TD="align: right"]42071.86[/TD]
[TD="align: right"][/TD]
[TD="align: right"]34933.0826[/TD]
[TD="align: right"]40391.0474[/TD]
[TD="align: right"]36529.2519[/TD]
[TD="align: right"]40010.1014[/TD]
[TD="align: right"]39059.3684[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]99[/TD]
[TD="align: right"]6203[/TD]
[TD="align: right"]33901.71[/TD]
[TD="align: right"]27199.15[/TD]
[TD="align: right"]32107.61[/TD]
[TD="align: right"]31746.49[/TD]
[TD="align: right"]34618.21[/TD]
[TD="align: right"][/TD]
[TD="align: right"]37239.7094[/TD]
[TD="align: right"]35535.7397[/TD]
[TD="align: right"]29774.9739[/TD]
[TD="align: right"]35003.5097[/TD]
[TD="align: right"]28188.9174[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]100[/TD]
[TD="align: right"]6204[/TD]
[TD="align: right"]24532.41[/TD]
[TD="align: right"]20368.24[/TD]
[TD="align: right"]22566.51[/TD]
[TD="align: right"]23281.94[/TD]
[TD="align: right"]24273.01[/TD]
[TD="align: right"][/TD]
[TD="align: right"]18978.4055[/TD]
[TD="align: right"]22438.489[/TD]
[TD="align: right"]20785.8558[/TD]
[TD="align: right"]22998.7442[/TD]
[TD="align: right"]22633.9122[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>
Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]F2[/TH]
[TD="align: left"]=SUM(B3:F3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L2[/TH]
[TD="align: left"]=SUM(H3:L3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B3[/TH]
[TD="align: left"]=SUBTOTAL(9,B9:B111)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C3[/TH]
[TD="align: left"]=SUBTOTAL(9,C9:C111)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D3[/TH]
[TD="align: left"]=SUBTOTAL(9,D9:D111)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E3[/TH]
[TD="align: left"]=SUBTOTAL(9,E9:E111)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]F3[/TH]
[TD="align: left"]=SUBTOTAL(9,F9:F111)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H3[/TH]
[TD="align: left"]=SUBTOTAL(9,H9:H111)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I3[/TH]
[TD="align: left"]=SUBTOTAL(9,I9:I111)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J3[/TH]
[TD="align: left"]=SUBTOTAL(9,J9:J111)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K3[/TH]
[TD="align: left"]=SUBTOTAL(9,K9:K111)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L3[/TH]
[TD="align: left"]=SUBTOTAL(9,L9:L111)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P3[/TH]
[TD="align: left"]=F2*(1+O3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N2[/TH]
[TD="align: left"]=L2-F2[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O2[/TH]
[TD="align: left"]=N2/F2[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N3[/TH]
[TD="align: left"]=P3-F2[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N4[/TH]
[TD="align: left"]=N3-N2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Sort by date Sort by votes
Hi Tblackwell,
if you want to raise total by 1%, you can raise all the underlying values by 1%. So basically add 1% to all shops. Is that what you are looking for?
Cheers,
Koen
 
Upvote 0
Rijnsent said:
Hi Tblackwell,
if you want to raise total by 1%, you can raise all the underlying values by 1%. So basically add 1% to all shops. Is that what you are looking for?
Cheers,
Koen
Click to expand...

Koen - No because I want to evenly distribute the $115,354 across 92 locations. Each location has a different volume, so 1% evenly spread would not equal $115,354.
 
Upvote 0
I don't have the formula for you but the best way in my opinion is to use a weighted average. Meaning figure out the percentage that each of the 92 locations contributed to the 11,586,579 and distribute the new forecast back to the 92 locations by their respective percentage contribution to the original.
 
Upvote 0
Hi tblackwell,
so you want to add 1/92nd of that $115354 to every location? That does mean that locations with a lower sales e.g. row 65 have to grow much more vs e.g. row row 84. If you want that you could add 1/92nd (divided by 5 weeks) to every week. That feels a bit unfair to the lower selling units, but I don't know your business.
Koen
 
Upvote 0
Hi Rijnsent,

If you are replying to what I suggested then you missed the jist of it. For example, Store 6001 in the first week contributed 23307.01 to the 11,586,579 that is equal to 0.2012%. Multiply the proposed increase by that percentage to figure how much of the increase should be placed upon that store for that corresponding future period.
 
Upvote 0
You must log in or register to reply here.

Similar threads

H
  • Question Question
Dynamic Growth Formula with Varying Time Periods
Replies
0
Views
737
HeresRandy
H

Forum statistics

Threads
1,224,818
Messages
6,181,152
Members
453,021
Latest member
Justyna P

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