Cleaning Up AR Aging Detail Report Using Visual Basic --- If...Then? Offset? ...?

S

smcjo

New Member
Joined
May 5, 2014
Messages
2
I am new to VBA, but I have been trying to figure out a way to simplify this process -- when I took over the project, I was told it would take me between 3-5 days/month to clean up! After playing around with If statements and various functions, I have been able to reduce the time significantly; however, I KNOW it can be done much more efficiently. I believe I can figure out everything except how to insert the Customers' Names and Acct #s next to their corresponding invoices in the far left columns.

Hopefully that explaination was not too "scrambled"... I have looked at this farrr too long. :eek: Any assistance/advice would be greatly appreciated. Thanks in advance!


BEFORE:

<table align="left" border="1" cellpadding="1" cellspacing="1" style="width: 500px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" style="width:1393px;" width="1045">
<colgroup>
<col />
<col />
<col />
<col span="3" />
<col />
<col span="7" />
</colgroup>
<tbody>
<tr height="27">
<td height="27" style="height:36px;width:143px;"> </td>
<td style="width:71px;"> </td>
<td style="width:181px;"> </td>
<td style="width:71px;"> </td>
<td style="width:71px;"> </td>
<td style="width:71px;">Aged Receivables Detail</td>
<td style="width:292px;"> </td>
<td style="width:71px;"> </td>
<td style="width:71px;"> </td>
<td style="width:71px;"> </td>
<td style="width:71px;"> </td>
<td style="width:71px;"> </td>
<td style="width:71px;"> </td>
<td style="width:71px;"> </td>
</tr>
<tr height="15">
<td height="15" style="height:20px;"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>My Company's Name</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr height="15">
<td height="15" style="height:20px;"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>As of 04/30/2014  (All Publications)</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr height="15">
<td height="15" style="height:20px;"> </td>
<td> </td>
<td>Date</td>
<td>Type</td>
<td>Document</td>
<td>Publication</td>
<td>Description</td>
<td>Due Date</td>
<td>Prepay</td>
<td>Current</td>
<td>Over 30</td>
<td>Over 60</td>
<td>Over 90</td>
<td>Over 120</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">The First Company</td>
<td align="right">9</td>
<td>10/25/2013</td>
<td>Invoice</td>
<td align="right">89665192</td>
<td>1-City</td>
<td>DEC-2013, Full Page Display</td>
<td>10/25/2013</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>2,200.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Daisy's</td>
<td align="right">1048858</td>
<td>02/08/2014</td>
<td>Invoice</td>
<td align="right">89667658</td>
<td>Auto</td>
<td>Apr-2014, Full Page Dealer</td>
<td>02/08/2014</td>
<td> </td>
<td> </td>
<td> </td>
<td>3,195.00</td>
<td> </td>
<td> </td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Daisy's</td>
<td align="right">1048858</td>
<td>03/08/2014</td>
<td>Invoice</td>
<td align="right">89668502</td>
<td>Auto</td>
<td>May-2014, Full Page Dealer</td>
<td>03/08/2014</td>
<td> </td>
<td> </td>
<td>3,195.00</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Daisy's</td>
<td align="right">1048858</td>
<td>04/08/2014</td>
<td>Invoice</td>
<td align="right">89567725</td>
<td>Auto</td>
<td>Jun-2014, Full Page Dealer</td>
<td>04/08/2014</td>
<td> </td>
<td>3,195.00</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">BP</td>
<td align="right">1083491</td>
<td>03/01/2014</td>
<td>Invoice</td>
<td align="right">89660042</td>
<td>X-Web AUTO</td>
<td>03/01/2014 - 03/31/2014 Dealer Program -</td>
<td>03/01/2014</td>
<td> </td>
<td> </td>
<td> </td>
<td>1,195.00</td>
<td> </td>
<td> </td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Harry's Shop</td>
<td align="right">1093334</td>
<td>04/08/2014</td>
<td>Invoice</td>
<td align="right">89660932</td>
<td>Auto</td>
<td>Jun-2014, 1/6 Page Classified</td>
<td>04/08/2014</td>
<td> </td>
<td>495</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Gas Station</td>
<td align="right">1063887</td>
<td>04/08/2014</td>
<td>Invoice</td>
<td align="right">89607931</td>
<td>Auto</td>
<td>Jun-2014, Full Page Dealer</td>
<td>04/08/2014</td>
<td> </td>
<td>3,495.00</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">The Gallery</td>
<td align="right">1063794</td>
<td>04/08/2014</td>
<td>Invoice</td>
<td align="right">89067878</td>
<td>Auto</td>
<td>Jun-2014, Full Page Dealer</td>
<td>04/08/2014</td>
<td> </td>
<td>3,500.00</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Company #3</td>
<td align="right">1073710</td>
<td>03/08/2014</td>
<td>Invoice</td>
<td align="right">89687190</td>
<td>Auto</td>
<td>May-2014, Full Page Dealer</td>
<td>03/08/2014</td>
<td> </td>
<td> </td>
<td>3,495.00</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Company #3</td>
<td align="right">1073710</td>
<td>04/01/2014</td>
<td>Invoice</td>
<td align="right">89467020</td>
<td>X-Web AUTO</td>
<td>04/01/2014 - 04/30/2014 Dealer Program -</td>
<td>04/01/2014</td>
<td> </td>
<td>895</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Company #3</td>
<td align="right">1073710</td>
<td>04/08/2014</td>
<td>Invoice</td>
<td align="right">89667412</td>
<td>Auto</td>
<td>Jun-2014, Full Page Dealer</td>
<td>04/08/2014</td>
<td> </td>
<td>3,495.00</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>11/08/2011</td>
<td>Invoice</td>
<td align="right">86147811</td>
<td>Auto</td>
<td>Auto Jan-2012 Full Page Display</td>
<td>11/08/2011</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>3,940.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>12/08/2011</td>
<td>Invoice</td>
<td align="right">86483171</td>
<td>Auto</td>
<td>Auto Feb-2012 Full Page Display</td>
<td>12/08/2011</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>01/08/2012</td>
<td>Invoice</td>
<td align="right">86485152</td>
<td>Auto</td>
<td>Auto Mar-2012 Full Page Display</td>
<td>01/08/2012</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>02/08/2012</td>
<td>Invoice</td>
<td align="right">86150874</td>
<td>Auto</td>
<td>Auto Apr-2012 Full Page Display</td>
<td>02/08/2012</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>03/08/2012</td>
<td>Invoice</td>
<td align="right">86150985</td>
<td>Auto</td>
<td>Auto May-2012 Full Page Display</td>
<td>03/08/2012</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>04/08/2012</td>
<td>Invoice</td>
<td align="right">86501866</td>
<td>Auto</td>
<td>Auto Jun-2012 Full Page Display</td>
<td>04/08/2012</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>05/08/2012</td>
<td>Invoice</td>
<td align="right">86150867</td>
<td>Auto</td>
<td>Auto Jul-2012 Full Page Display</td>
<td>05/08/2012</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>06/08/2012</td>
<td>Invoice</td>
<td align="right">86153353</td>
<td>Auto</td>
<td>Auto Aug-2012 Full Page Display</td>
<td>06/08/2012</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>07/08/2012</td>
<td>Invoice</td>
<td align="right">86716706</td>
<td>Auto</td>
<td>Auto Sep-2012 Full Page Display</td>
<td>07/08/2012</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>08/08/2012</td>
<td>Invoice</td>
<td align="right">85571779</td>
<td>Auto</td>
<td>Auto Oct-2012 Full Page Display</td>
<td>08/08/2012</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>09/08/2012</td>
<td>Invoice</td>
<td align="right">86518888</td>
<td>Auto</td>
<td>Auto Nov-2012 Full Page Display</td>
<td>09/08/2012</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>10/08/2012</td>
<td>Invoice</td>
<td align="right">86603269</td>
<td>Auto</td>
<td>Auto Dec-2012 Full Page Display</td>
<td>10/08/2012</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>11/08/2012</td>
<td>Invoice</td>
<td align="right">86621063</td>
<td>Auto</td>
<td>Auto Jan-2013 Full Page Display</td>
<td>11/08/2012</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>12/08/2012</td>
<td>Invoice</td>
<td align="right">86612064</td>
<td>Auto</td>
<td>Auto Feb-2013 Full Page Display</td>
<td>12/08/2012</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>01/08/2013</td>
<td>Invoice</td>
<td align="right">89662012</td>
<td>Auto</td>
<td>Mar-2013, Full Page Display</td>
<td>01/08/2013</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>02/08/2013</td>
<td>Invoice</td>
<td align="right">89660682</td>
<td>Auto</td>
<td>Apr-2013, Full Page Display</td>
<td>02/08/2013</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>03/08/2013</td>
<td>Invoice</td>
<td align="right">89860695</td>
<td>Auto</td>
<td>May-2013, Full Page Display</td>
<td>03/08/2013</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>04/08/2013</td>
<td>Invoice</td>
<td align="right">89561267</td>
<td>Auto</td>
<td>Jun-2013, Full Page Display</td>
<td>04/08/2013</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>05/08/2013</td>
<td>Invoice</td>
<td align="right">89681703</td>
<td>Auto</td>
<td>Jul-2013, Full Page Display</td>
<td>05/08/2013</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>06/08/2013</td>
<td>Invoice</td>
<td align="right">88662314</td>
<td>Auto</td>
<td>Aug-2013, Full Page Display</td>
<td>06/08/2013</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>07/08/2013</td>
<td>Invoice</td>
<td align="right">89661933</td>
<td>Auto</td>
<td>Sep-2013, Full Page Display</td>
<td>07/08/2013</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>08/08/2013</td>
<td>Invoice</td>
<td align="right">89663567</td>
<td>Auto</td>
<td>Oct-2013, Full Page Display</td>
<td>08/08/2013</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>09/08/2013</td>
<td>Invoice</td>
<td align="right">89664378</td>
<td>Auto</td>
<td>Nov-2013, Full Page Display</td>
<td>09/08/2013</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>10/08/2013</td>
<td>Invoice</td>
<td align="right">89664659</td>
<td>Auto</td>
<td>Dec-2013, Full Page Display</td>
<td>10/08/2013</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>11/08/2013</td>
<td>Invoice</td>
<td align="right">89665469</td>
<td>Auto</td>
<td>Jan-2014, Full Page Display</td>
<td>11/08/2013</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>12/08/2013</td>
<td>Invoice</td>
<td align="right">89665581</td>
<td>Auto</td>
<td>Feb-2014, Full Page Display</td>
<td>12/08/2013</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>01/08/2014</td>
<td>Invoice</td>
<td align="right">89666133</td>
<td>Auto</td>
<td>Mar-2014, Full Page Display</td>
<td>01/08/2014</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
<td> </td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>02/08/2014</td>
<td>Invoice</td>
<td align="right">89666907</td>
<td>Auto</td>
<td>Apr-2014, Full Page Display</td>
<td>02/08/2014</td>
<td> </td>
<td> </td>
<td> </td>
<td>4,000.00</td>
<td> </td>
<td> </td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>03/08/2014</td>
<td>Invoice</td>
<td align="right">89667470</td>
<td>Auto</td>
<td>May-2014, Full Page Display</td>
<td>03/08/2014</td>
<td> </td>
<td> </td>
<td>4,000.00</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Car Transport</td>
<td align="right">1102863</td>
<td>04/08/2014</td>
<td>Invoice</td>
<td align="right">89668000</td>
<td>Auto</td>
<td>Jun-2014, Full Page Display</td>
<td>04/08/2014</td>
<td> </td>
<td>4,000.00</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Properties</td>
<td align="right">1710023</td>
<td>02/20/2014</td>
<td>Invoice</td>
<td align="right">89667353</td>
<td>Home</td>
<td>May-2014, Full Page Real Estate</td>
<td>02/20/2014</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>1,650.00</td>
<td> </td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Luxury Properties</td>
<td align="right">1710023</td>
<td>03/20/2014</td>
<td>Invoice</td>
<td align="right">89668684</td>
<td>Home</td>
<td>Jun-2014, Full Page Real Estate</td>
<td>03/20/2014</td>
<td> </td>
<td> </td>
<td> </td>
<td>1,650.00</td>
<td> </td>
<td> </td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Bentley City</td>
<td align="right">1127354</td>
<td>03/08/2014</td>
<td>Invoice</td>
<td align="right">89668155</td>
<td>Auto</td>
<td>May-2014, 1/6 Page Classified</td>
<td>03/08/2014</td>
<td> </td>
<td> </td>
<td>1,000.00</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Bentley City</td>
<td align="right">1127354</td>
<td>04/01/2014</td>
<td>Invoice</td>
<td align="right">89657854</td>
<td>X-Web AUTO</td>
<td>04/01/2014 - 04/30/2014 Dealer Program -</td>
<td>04/01/2014</td>
<td> </td>
<td>1,985.00</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr height="15">
<td height="15" style="height:20px;">Bentley City</td>
<td align="right">1127354</td>
<td>04/08/2014</td>
<td>Invoice</td>
<td align="right">89669821</td>
<td>Auto</td>
<td>Jun-2014, 1/6 Page Classified</td>
<td>04/08/2014</td>
<td> </td>
<td>1,000.00</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</tbody>
</table>
</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</tbody>
</table>

<p> </p>
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Sort by date Sort by votes
Sorry, I can not seem to get the examples in correctly - The "before" looks like this:



























































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































Aged Receivables Detail
My Company's Name
As of 04/30/2014 (All Publications)
The First Company Attn: Acct #:9Avg Age: Rep:AJV
Phone:(800)898-0887 x226 Status:OkHigh Bal:
DateTypeDocumentPublicationDescriptionDue DatePrepayCurrentOver 30Over 60Over 90Over 120InterestTotal
10/25/2013Invoice896651921-CityDEC-2013, Full Page Display10/25/2013 2,200.00 2,200.00
Total The First Company 000002,200.0002,200.00
Daisy's Attn: Acct #:1048858Avg Age: Rep:CHR
Phone:(800)699-8987 Status:OkHigh Bal:
DateTypeDocumentPublicationDescriptionDue DatePrepayCurrentOver 30Over 60Over 90Over 120InterestTotal
02/08/2014Invoice89667658AutoApr-2014, Full Page Dealer02/08/2014 3,195.00 3,195.00
03/08/2014Invoice89668502AutoMay-2014, Full Page Dealer03/08/2014 3,195.00 3,195.00
04/08/2014Invoice89567725AutoJun-2014, Full Page Dealer04/08/2014 3,195.00 3,195.00
Total Daisy's 03,195.003,195.003,195.000009,585.00
BP Attn: Acct #:1083491Avg Age: Rep:RPR
Phone:(800)568-7778 Status:OkHigh Bal:
DateTypeDocumentPublicationDescriptionDue DatePrepayCurrentOver 30Over 60Over 90Over 120InterestTotal
03/01/2014Invoice89660042X-Web AUTO03/01/2014 - 03/31/2014 Dealer Program -03/01/2014 1,195.00 1,195.00
Standard
Total BP 0001,195.000001,195.00
Harry's Shop Attn: Acct #:1093334Avg Age: Rep:UPE
Phone:(800)986-7777 Status:OkHigh Bal:
DateTypeDocumentPublicationDescriptionDue DatePrepayCurrentOver 30Over 60Over 90Over 120InterestTotal
04/08/2014Invoice89660932AutoJun-2014, 1/6 Page Classified04/08/2014 495 495
Total Harry's Shop 049500000495
Gas Station Attn: Acct #:1063887Avg Age: Rep:MSM
Phone:(858)685-9800 Status:OkHigh Bal:
DateTypeDocumentPublicationDescriptionDue DatePrepayCurrentOver 30Over 60Over 90Over 120InterestTotal
04/08/2014Invoice89607931AutoJun-2014, Full Page Dealer04/08/2014 3,495.00 3,495.00
04/01/2014 - 04/30/2014 Dealer Program -
Standard
Total Gas Station 0.003,495.000.000.000.000.000.003,495.00
The Gallery Attn: Acct #:1063794Avg Age: Rep:APR
Phone:(888)884-4487 Status:OkHigh Bal:
DateTypeDocumentPublicationDescriptionDue DatePrepayCurrentOver 30Over 60Over 90Over 120InterestTotal
04/08/2014Invoice89067878AutoJun-2014, Full Page Dealer04/08/2014 3,500.00 3,500.00
Total The Gallery 0.003,500.000.000.000.000.000.003,500.00
Company #3 Attn: Acct #:1073710Avg Age: Rep:WRE
Phone:(591)984-6677 Status:OkHigh Bal:
DateTypeDocumentPublicationDescriptionDue DatePrepayCurrentOver 30Over 60Over 90Over 120InterestTotal
03/08/2014Invoice89687190AutoMay-2014, Full Page Dealer03/08/2014 3,495.00 3,495.00
04/01/2014Invoice89467020X-Web AUTO04/01/2014 - 04/30/2014 Dealer Program -04/01/2014 895.00 895.00
Standard
Page 1 05/02/2014 11:16 AM
04/08/2014Invoice89667412AutoJun-2014, Full Page Dealer04/08/2014 3,495.00 3,495.00
Total Company #3 0.004,390.003,495.000.000.000.000.007,885.00
Luxury Car Transport Attn: Acct #:1102863Avg Age: Rep:SWE
Phone:(497)243-9994 Status:OkHigh Bal:
DateTypeDocumentPublicationDescriptionDue DatePrepayCurrentOver 30Over 60Over 90Over 120InterestTotal
11/08/2011Invoice86147811AutoAuto Jan-2012 Full Page Display11/08/2011 3,940.00 3,940.00
12/08/2011Invoice86483171AutoAuto Feb-2012 Full Page Display12/08/2011 4,000.00 4,000.00
01/08/2012Invoice86485152AutoAuto Mar-2012 Full Page Display01/08/2012 4,000.00 4,000.00
02/08/2012Invoice86150874AutoAuto Apr-2012 Full Page Display02/08/2012 4,000.00 4,000.00
03/08/2012Invoice86150985AutoAuto May-2012 Full Page Display03/08/2012 4,000.00 4,000.00
04/08/2012Invoice86501866AutoAuto Jun-2012 Full Page Display04/08/2012 4,000.00 4,000.00
05/08/2012Invoice86150867AutoAuto Jul-2012 Full Page Display05/08/2012 4,000.00 4,000.00
06/08/2012Invoice86153353AutoAuto Aug-2012 Full Page Display06/08/2012 4,000.00 4,000.00
07/08/2012Invoice86716706AutoAuto Sep-2012 Full Page Display07/08/2012 4,000.00 4,000.00
08/08/2012Invoice85571779AutoAuto Oct-2012 Full Page Display08/08/2012 4,000.00 4,000.00
09/08/2012Invoice86518888AutoAuto Nov-2012 Full Page Display09/08/2012 4,000.00 4,000.00
10/08/2012Invoice86603269AutoAuto Dec-2012 Full Page Display10/08/2012 4,000.00 4,000.00
11/08/2012Invoice86621063AutoAuto Jan-2013 Full Page Display11/08/2012 4,000.00 4,000.00
12/08/2012Invoice86612064AutoAuto Feb-2013 Full Page Display12/08/2012 4,000.00 4,000.00
01/08/2013Invoice89662012AutoMar-2013, Full Page Display01/08/2013 4,000.00 4,000.00
02/08/2013Invoice89660682AutoApr-2013, Full Page Display02/08/2013 4,000.00 4,000.00
03/08/2013Invoice89860695AutoMay-2013, Full Page Display03/08/2013 4,000.00 4,000.00
04/08/2013Invoice89561267AutoJun-2013, Full Page Display04/08/2013 4,000.00 4,000.00
05/08/2013Invoice89681703AutoJul-2013, Full Page Display05/08/2013 4,000.00 4,000.00
06/08/2013Invoice88662314AutoAug-2013, Full Page Display06/08/2013 4,000.00 4,000.00
07/08/2013Invoice89661933AutoSep-2013, Full Page Display07/08/2013 4,000.00 4,000.00
08/08/2013Invoice89663567AutoOct-2013, Full Page Display08/08/2013 4,000.00 4,000.00
09/08/2013Invoice89664378AutoNov-2013, Full Page Display09/08/2013 4,000.00 4,000.00
10/08/2013Invoice89664659AutoDec-2013, Full Page Display10/08/2013 4,000.00 4,000.00
11/08/2013Invoice89665469AutoJan-2014, Full Page Display11/08/2013 4,000.00 4,000.00
12/08/2013Invoice89665581AutoFeb-2014, Full Page Display12/08/2013 4,000.00 4,000.00
01/08/2014Invoice89666133AutoMar-2014, Full Page Display01/08/2014 4,000.00 4,000.00
02/08/2014Invoice89666907AutoApr-2014, Full Page Display02/08/2014 4,000.00 4,000.00
03/08/2014Invoice89667470AutoMay-2014, Full Page Display03/08/2014 4,000.00 4,000.00
04/08/2014Invoice89668000AutoJun-2014, Full Page Display04/08/2014 4,000.00 4,000.00
Total Luxury Car Transport 0.004,000.004,000.004,000.004,000.00103,940.000.00119,940.00
Luxury Properties Attn: Acct #:1710023Avg Age: Rep:FRG
Phone:(701)884-7991 Status:OkHigh Bal:
DateTypeDocumentPublicationDescriptionDue DatePrepayCurrentOver 30Over 60Over 90Over 120InterestTotal
02/20/2014Invoice89667353HomeMay-2014, Full Page Real Estate02/20/2014 1,650.00 1,650.00
03/20/2014Invoice89668684HomeJun-2014, Full Page Real Estate03/20/2014 1,650.00 1,650.00
Total Luxury Properties 0.000.001,650.001,650.000.000.000.003,300.00
Bentley City Attn: Acct #:1127354Avg Age: Rep:SWC
Phone:(778)484-1899 Status:OkHigh Bal:
DateTypeDocumentPublicationDescriptionDue DatePrepayCurrentOver 30Over 60Over 90Over 120InterestTotal
03/08/2014Invoice89668155AutoMay-2014, 1/6 Page Classified03/08/2014 1,000.00 1,000.00
May-2014, 1/6 Page Classified
Page 2 05/02/2014 11:16 AM
04/01/2014Invoice89657854X-Web AUTO04/01/2014 - 04/30/2014 Dealer Program -04/01/2014 1,985.00 1,985.00
Standard
04/08/2014Invoice89669821AutoJun-2014, 1/6 Page Classified04/08/2014 1,000.00 1,000.00
Jun-2014, 1/6 Page Classified
Total Bentley City 0.002,985.001,000.000.000.000.000.003,985.00

<colgroup></colgroup> <colgroup><col span="2"></colgroup> <colgroup><col></colgroup> <colgroup><col span="3"></colgroup> <colgroup><col></colgroup> <colgroup><col span="9"></colgroup> <tbody>
</tbody>


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

Similar threads

I
  • Question
Excel averageifs-
Replies
7
Views
375
Fluff
Fluff
M
  • Question
Help with FilterXML formula
Replies
0
Views
1K
montex01
M
M
  • Solved
Sort 4 columns using excel 2000
Replies
9
Views
403
Fluff
Fluff
A
  • Question
Web Scraping using VBA
Replies
4
Views
9K
atr140
A
M
  • Question
Excel Formula help
Replies
4
Views
748
Sam_D_Ben
S

Forum statistics

Threads
1,214,987
Messages
6,122,614
Members
449,090
Latest member
vivek chauhan

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