Hello,
I would be grateful if someone could help me create formulas to determine how much sales must happen going forward (for the month, or for the quarter or for the year) based on YTD, Week-to-date or Quarter-to-date actual sales and a target for the year, the month, and the quarter (simple monthly average are fine, e.g. forward sales divided by remaining periods).
I have tried I cannot get a mix of actuals and estimates (for my chart). I have a hard time making Excel calculate the remaining (monthly, or quarterly, or annual) estimate(s) and replace the last estimate(s) (in the data to chart) with the new actuals when they are entered in a sales database (and only keep the estimates when there are no actuals available).
I have tried to set up columns to calculate cumulative data, but my spreadsheet got only bigger and I got more confused. Thanks for your help!
(I am sorry if the spreadsheet below looks ugly, I didn't know how to import a clean excel file on here)
Thanks a lot in advance!
<table x:str="" style="border-collapse: collapse; width: 449pt;" border="0" cellpadding="0" cellspacing="0" width="598"><col style="width: 48pt;" span="3" width="64"> <col style="width: 32pt;" width="43"> <col style="width: 35pt;" width="46"> <col style="width: 48pt;" span="2" width="64"> <col style="width: 40pt;" width="53"> <col style="width: 54pt;" width="72"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt; width: 48pt;" x:num="" width="64" height="17">1</td> <td class="xl25" style="border-left: medium none; width: 48pt;" width="64">B</td> <td class="xl25" style="border-left: medium none; width: 48pt;" width="64">C</td> <td class="xl25" style="border-left: medium none; width: 32pt;" width="43">D</td> <td class="xl25" style="border-left: medium none; width: 35pt;" width="46">E</td> <td class="xl25" style="border-left: medium none; width: 48pt;" width="64">F</td> <td class="xl25" style="border-left: medium none; width: 48pt;" width="64">G</td> <td class="xl25" style="border-left: medium none; width: 40pt;" width="53">H</td> <td class="xl25" style="border-left: medium none; width: 54pt;" width="72">I</td> <td style="width: 48pt;" width="64">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">2</td> <td class="xl26" colspan="2" style="">Sale Database</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">3</td> <td class="xl27">Month</td> <td class="xl27">Week #</td> <td class="xl27">Sales</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">4</td> <td class="xl27">January</td> <td class="xl27">Week 1</td> <td class="xl28" x:num="9000">$9,000</td> <td class="xl27">
</td> <td class="xl27" colspan="2" style="">February Target =</td> <td class="xl28" x:num="37000">$37,000</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">5</td> <td class="xl27">January</td> <td class="xl27">Week 2</td> <td class="xl28" x:num="8180">$8,180</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">6</td> <td class="xl27">January</td> <td class="xl27">Week 3</td> <td class="xl28" x:num="9700">$9,700</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl25" style="border-top: medium none; height: 13.5pt;" x:num="" height="18">7</td> <td class="xl29" style="border-left: medium none;">January</td> <td class="xl30">Week 4</td> <td class="xl31" x:num="8680">$8,680</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">8</td> <td class="xl27">February</td> <td class="xl27">Week 1</td> <td class="xl28" x:num="7600">$7,600</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">9</td> <td class="xl27">February</td> <td class="xl27">Week 2</td> <td colspan="4" rowspan="3" class="xl37" style="border-right: 0.5pt solid black; border-bottom: 0.5pt solid black;">Manually entered every week</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">10</td> <td class="xl27">February</td> <td class="xl27">Week 3</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl25" style="border-top: medium none; height: 13.5pt;" x:num="" height="18">11</td> <td class="xl29" style="border-left: medium none;">February</td> <td class="xl30">Week 4</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">12</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">13</td> <td class="xl27" colspan="8" style="" x:str="Question: Create a formula to estimate Week 2, 3, and 4 given the February target ">Question: Create a formula to estimate Week 2, 3, and 4 given the February target </td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">14</td> <td class="xl46" colspan="8" style="">In this case, $37,000 minus $7,600 = $29,400 can be spread evenly over 3 weeks</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">15</td> <td class="xl46" colspan="8" style="">Then when the actual sales for Feb. Week 2 are in, I want only week 3, and 4 to be estimated</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">16</td> <td class="xl46" colspan="4" style="">For example, February sales = $8,000</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">17</td> <td class="xl46" colspan="7" style="">How do I write this formula to estimate forward sales as I add new data?</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">18</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">19</td> <td class="xl27">
</td> <td colspan="4" style="">Before I entered Data in database</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">20</td> <td class="xl27">
</td> <td class="xl32" colspan="2" style="border-right: 0.5pt solid black;">Source Data for Graph</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">21</td> <td class="xl27">
</td> <td class="xl34" x:fmla="=B8">February</td> <td class="xl35" x:fmla="=C8">Week 1</td> <td class="xl36" x:num="7600" x:fmla="=D8" align="right">$7,600</td> <td class="xl27" colspan="2" style="">(note: actual)</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">22</td> <td class="xl27">
</td> <td class="xl34" x:fmla="=B9">February</td> <td class="xl35" x:fmla="=C9">Week 2</td> <td class="xl27" x:num="" x:fmla="=29400/3" align="right">9800</td> <td class="xl27">(estimate)</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">23</td> <td class="xl27">
</td> <td class="xl34" x:fmla="=B10">February</td> <td class="xl35" x:fmla="=C10">Week 3</td> <td class="xl27" x:num="" x:fmla="=29400/3" align="right">9800</td> <td class="xl27">(estimate)</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">24</td> <td class="xl27">
</td> <td class="xl34" x:fmla="=B11">February</td> <td class="xl35" x:fmla="=C11">Week 4</td> <td class="xl27" x:num="" x:fmla="=29400/3" align="right">9800</td> <td class="xl27">(estimate)</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">25</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">26</td> <td>
</td> <td colspan="4" style="">After I entered Data in database</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">27</td> <td>
</td> <td class="xl32" colspan="2" style="border-right: 0.5pt solid black;">Source Data for Graph</td> <td class="xl33"> </td> <td class="xl27">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">28</td> <td>
</td> <td class="xl34" x:fmla="=C21">February</td> <td class="xl35" x:fmla="=D21">Week 1</td> <td class="xl36" x:num="7600" x:fmla="=E21" align="right">$7,600</td> <td class="xl27">Actual</td> <td class="xl24">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">29</td> <td>
</td> <td class="xl34" x:fmla="=C22">February</td> <td class="xl35" x:fmla="=D22">Week 2</td> <td class="xl36" x:num="8000" align="right">$8,000</td> <td class="xl27">(estimate)</td> <td class="xl24">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">30</td> <td>
</td> <td class="xl34" x:fmla="=C23">February</td> <td class="xl35" x:fmla="=D23">Week 3</td> <td class="xl36" x:num="10700" align="right">$10,700</td> <td class="xl27">(estimate)</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">31</td> <td>
</td> <td class="xl34" x:fmla="=C24">February</td> <td class="xl35" x:fmla="=D24">Week 4</td> <td class="xl36" x:num="10700" align="right">$10,700</td> <td class="xl27">(estimate)</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td colspan="9" style="height: 12.75pt;" height="17">Also, I'd like to estimate remaining Quarter or Year sales, based on Qtr and Yr targets</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td colspan="3" style="height: 12.75pt;" height="17">(same principle as above</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> </tbody></table>
I would be grateful if someone could help me create formulas to determine how much sales must happen going forward (for the month, or for the quarter or for the year) based on YTD, Week-to-date or Quarter-to-date actual sales and a target for the year, the month, and the quarter (simple monthly average are fine, e.g. forward sales divided by remaining periods).
I have tried I cannot get a mix of actuals and estimates (for my chart). I have a hard time making Excel calculate the remaining (monthly, or quarterly, or annual) estimate(s) and replace the last estimate(s) (in the data to chart) with the new actuals when they are entered in a sales database (and only keep the estimates when there are no actuals available).
I have tried to set up columns to calculate cumulative data, but my spreadsheet got only bigger and I got more confused. Thanks for your help!
(I am sorry if the spreadsheet below looks ugly, I didn't know how to import a clean excel file on here)
Thanks a lot in advance!
<table x:str="" style="border-collapse: collapse; width: 449pt;" border="0" cellpadding="0" cellspacing="0" width="598"><col style="width: 48pt;" span="3" width="64"> <col style="width: 32pt;" width="43"> <col style="width: 35pt;" width="46"> <col style="width: 48pt;" span="2" width="64"> <col style="width: 40pt;" width="53"> <col style="width: 54pt;" width="72"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt; width: 48pt;" x:num="" width="64" height="17">1</td> <td class="xl25" style="border-left: medium none; width: 48pt;" width="64">B</td> <td class="xl25" style="border-left: medium none; width: 48pt;" width="64">C</td> <td class="xl25" style="border-left: medium none; width: 32pt;" width="43">D</td> <td class="xl25" style="border-left: medium none; width: 35pt;" width="46">E</td> <td class="xl25" style="border-left: medium none; width: 48pt;" width="64">F</td> <td class="xl25" style="border-left: medium none; width: 48pt;" width="64">G</td> <td class="xl25" style="border-left: medium none; width: 40pt;" width="53">H</td> <td class="xl25" style="border-left: medium none; width: 54pt;" width="72">I</td> <td style="width: 48pt;" width="64">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">2</td> <td class="xl26" colspan="2" style="">Sale Database</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">3</td> <td class="xl27">Month</td> <td class="xl27">Week #</td> <td class="xl27">Sales</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">4</td> <td class="xl27">January</td> <td class="xl27">Week 1</td> <td class="xl28" x:num="9000">$9,000</td> <td class="xl27">
</td> <td class="xl27" colspan="2" style="">February Target =</td> <td class="xl28" x:num="37000">$37,000</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">5</td> <td class="xl27">January</td> <td class="xl27">Week 2</td> <td class="xl28" x:num="8180">$8,180</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">6</td> <td class="xl27">January</td> <td class="xl27">Week 3</td> <td class="xl28" x:num="9700">$9,700</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl25" style="border-top: medium none; height: 13.5pt;" x:num="" height="18">7</td> <td class="xl29" style="border-left: medium none;">January</td> <td class="xl30">Week 4</td> <td class="xl31" x:num="8680">$8,680</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">8</td> <td class="xl27">February</td> <td class="xl27">Week 1</td> <td class="xl28" x:num="7600">$7,600</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">9</td> <td class="xl27">February</td> <td class="xl27">Week 2</td> <td colspan="4" rowspan="3" class="xl37" style="border-right: 0.5pt solid black; border-bottom: 0.5pt solid black;">Manually entered every week</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">10</td> <td class="xl27">February</td> <td class="xl27">Week 3</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl25" style="border-top: medium none; height: 13.5pt;" x:num="" height="18">11</td> <td class="xl29" style="border-left: medium none;">February</td> <td class="xl30">Week 4</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">12</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">13</td> <td class="xl27" colspan="8" style="" x:str="Question: Create a formula to estimate Week 2, 3, and 4 given the February target ">Question: Create a formula to estimate Week 2, 3, and 4 given the February target </td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">14</td> <td class="xl46" colspan="8" style="">In this case, $37,000 minus $7,600 = $29,400 can be spread evenly over 3 weeks</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">15</td> <td class="xl46" colspan="8" style="">Then when the actual sales for Feb. Week 2 are in, I want only week 3, and 4 to be estimated</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">16</td> <td class="xl46" colspan="4" style="">For example, February sales = $8,000</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">17</td> <td class="xl46" colspan="7" style="">How do I write this formula to estimate forward sales as I add new data?</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">18</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">19</td> <td class="xl27">
</td> <td colspan="4" style="">Before I entered Data in database</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">20</td> <td class="xl27">
</td> <td class="xl32" colspan="2" style="border-right: 0.5pt solid black;">Source Data for Graph</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">21</td> <td class="xl27">
</td> <td class="xl34" x:fmla="=B8">February</td> <td class="xl35" x:fmla="=C8">Week 1</td> <td class="xl36" x:num="7600" x:fmla="=D8" align="right">$7,600</td> <td class="xl27" colspan="2" style="">(note: actual)</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">22</td> <td class="xl27">
</td> <td class="xl34" x:fmla="=B9">February</td> <td class="xl35" x:fmla="=C9">Week 2</td> <td class="xl27" x:num="" x:fmla="=29400/3" align="right">9800</td> <td class="xl27">(estimate)</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">23</td> <td class="xl27">
</td> <td class="xl34" x:fmla="=B10">February</td> <td class="xl35" x:fmla="=C10">Week 3</td> <td class="xl27" x:num="" x:fmla="=29400/3" align="right">9800</td> <td class="xl27">(estimate)</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">24</td> <td class="xl27">
</td> <td class="xl34" x:fmla="=B11">February</td> <td class="xl35" x:fmla="=C11">Week 4</td> <td class="xl27" x:num="" x:fmla="=29400/3" align="right">9800</td> <td class="xl27">(estimate)</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">25</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">26</td> <td>
</td> <td colspan="4" style="">After I entered Data in database</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">27</td> <td>
</td> <td class="xl32" colspan="2" style="border-right: 0.5pt solid black;">Source Data for Graph</td> <td class="xl33"> </td> <td class="xl27">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">28</td> <td>
</td> <td class="xl34" x:fmla="=C21">February</td> <td class="xl35" x:fmla="=D21">Week 1</td> <td class="xl36" x:num="7600" x:fmla="=E21" align="right">$7,600</td> <td class="xl27">Actual</td> <td class="xl24">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">29</td> <td>
</td> <td class="xl34" x:fmla="=C22">February</td> <td class="xl35" x:fmla="=D22">Week 2</td> <td class="xl36" x:num="8000" align="right">$8,000</td> <td class="xl27">(estimate)</td> <td class="xl24">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">30</td> <td>
</td> <td class="xl34" x:fmla="=C23">February</td> <td class="xl35" x:fmla="=D23">Week 3</td> <td class="xl36" x:num="10700" align="right">$10,700</td> <td class="xl27">(estimate)</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">31</td> <td>
</td> <td class="xl34" x:fmla="=C24">February</td> <td class="xl35" x:fmla="=D24">Week 4</td> <td class="xl36" x:num="10700" align="right">$10,700</td> <td class="xl27">(estimate)</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td colspan="9" style="height: 12.75pt;" height="17">Also, I'd like to estimate remaining Quarter or Year sales, based on Qtr and Yr targets</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td colspan="3" style="height: 12.75pt;" height="17">(same principle as above</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> </tbody></table>
