Hi
i am looking for a macro to generate all possible combinations of N elements in C columns
for example I have 3 columns
CoL 1 Account
Col 2 Month
Col 3 Year
Independant of number of elements in each column I want to get all possible combinations of 3 elements ( not 2 or 1 element only )
example
Base is
<table x:str="" style="border-collapse: collapse; width: 124pt;" border="0" cellpadding="0" cellspacing="0" width="165"><col style="width: 52pt;" width="69"> <col style="width: 40pt;" width="53"> <col style="width: 32pt;" width="43"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 52pt;" width="69" height="17">ACCOUNT</td> <td style="width: 40pt;" width="53">MONTH</td> <td style="width: 32pt;" width="43">YEAR</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>jan</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>feb</td> <td x:num="" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>mar</td> <td x:num="" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>apr</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>may</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>jun</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>jul</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>aug</td> <td>
</td> </tr> </tbody></table>number of combination is 3 x 8 X 3 in that case 72 lines to generate but keeping data in columns ( not concatenate field)
result is 72 lines in 3 columns
<table x:str="" style="border-collapse: collapse; width: 144pt;" border="0" cellpadding="0" cellspacing="0" width="192"><col style="width: 48pt;" span="3" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 48pt;" width="64" height="17">ACCOUNT</td> <td style="width: 48pt;" width="64">MONTH</td> <td style="width: 48pt;" width="64">YEAR</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>jan</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>feb</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>mar</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>apr</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>may</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>jun</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>jul</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>aug</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>jan</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>feb</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>mar</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>apr</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>may</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>jun</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>jul</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>aug</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>jan</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>feb</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>mar</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>apr</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>may</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>jun</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>jul</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>aug</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>jan</td> <td x:num="" x:fmla="=C2+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>feb</td> <td x:num="" x:fmla="=C3+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>mar</td> <td x:num="" x:fmla="=C4+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>apr</td> <td x:num="" x:fmla="=C5+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>may</td> <td x:num="" x:fmla="=C6+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>jun</td> <td x:num="" x:fmla="=C7+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>jul</td> <td x:num="" x:fmla="=C8+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>aug</td> <td x:num="" x:fmla="=C9+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>jan</td> <td x:num="" x:fmla="=C10+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>feb</td> <td x:num="" x:fmla="=C11+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>mar</td> <td x:num="" x:fmla="=C12+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>apr</td> <td x:num="" x:fmla="=C13+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>may</td> <td x:num="" x:fmla="=C14+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>jun</td> <td x:num="" x:fmla="=C15+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>jul</td> <td x:num="" x:fmla="=C16+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>aug</td> <td x:num="" x:fmla="=C17+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>jan</td> <td x:num="" x:fmla="=C18+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>feb</td> <td x:num="" x:fmla="=C19+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>mar</td> <td x:num="" x:fmla="=C20+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>apr</td> <td x:num="" x:fmla="=C21+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>may</td> <td x:num="" x:fmla="=C22+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>jun</td> <td x:num="" x:fmla="=C23+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>jul</td> <td x:num="" x:fmla="=C24+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>aug</td> <td x:num="" x:fmla="=C25+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>jan</td> <td x:num="" x:fmla="=C26+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>feb</td> <td x:num="" x:fmla="=C27+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>mar</td> <td x:num="" x:fmla="=C28+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>apr</td> <td x:num="" x:fmla="=C29+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>may</td> <td x:num="" x:fmla="=C30+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>jun</td> <td x:num="" x:fmla="=C31+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>jul</td> <td x:num="" x:fmla="=C32+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>aug</td> <td x:num="" x:fmla="=C33+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>jan</td> <td x:num="" x:fmla="=C34+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>feb</td> <td x:num="" x:fmla="=C35+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>mar</td> <td x:num="" x:fmla="=C36+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>apr</td> <td x:num="" x:fmla="=C37+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>may</td> <td x:num="" x:fmla="=C38+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>jun</td> <td x:num="" x:fmla="=C39+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>jul</td> <td x:num="" x:fmla="=C40+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>aug</td> <td x:num="" x:fmla="=C41+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>jan</td> <td x:num="" x:fmla="=C42+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>feb</td> <td x:num="" x:fmla="=C43+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>mar</td> <td x:num="" x:fmla="=C44+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>apr</td> <td x:num="" x:fmla="=C45+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>may</td> <td x:num="" x:fmla="=C46+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>jun</td> <td x:num="" x:fmla="=C47+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>jul</td> <td x:num="" x:fmla="=C48+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>aug</td> <td x:num="" x:fmla="=C49+1" align="right">2009</td> </tr> </tbody></table>
Thanks in Advance for helping
i am looking for a macro to generate all possible combinations of N elements in C columns
for example I have 3 columns
CoL 1 Account
Col 2 Month
Col 3 Year
Independant of number of elements in each column I want to get all possible combinations of 3 elements ( not 2 or 1 element only )
example
Base is
<table x:str="" style="border-collapse: collapse; width: 124pt;" border="0" cellpadding="0" cellspacing="0" width="165"><col style="width: 52pt;" width="69"> <col style="width: 40pt;" width="53"> <col style="width: 32pt;" width="43"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 52pt;" width="69" height="17">ACCOUNT</td> <td style="width: 40pt;" width="53">MONTH</td> <td style="width: 32pt;" width="43">YEAR</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>jan</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>feb</td> <td x:num="" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>mar</td> <td x:num="" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>apr</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>may</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>jun</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>jul</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>aug</td> <td>
</td> </tr> </tbody></table>number of combination is 3 x 8 X 3 in that case 72 lines to generate but keeping data in columns ( not concatenate field)
result is 72 lines in 3 columns
<table x:str="" style="border-collapse: collapse; width: 144pt;" border="0" cellpadding="0" cellspacing="0" width="192"><col style="width: 48pt;" span="3" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 48pt;" width="64" height="17">ACCOUNT</td> <td style="width: 48pt;" width="64">MONTH</td> <td style="width: 48pt;" width="64">YEAR</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>jan</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>feb</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>mar</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>apr</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>may</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>jun</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>jul</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>aug</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>jan</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>feb</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>mar</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>apr</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>may</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>jun</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>jul</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>aug</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>jan</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>feb</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>mar</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>apr</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>may</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>jun</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>jul</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>aug</td> <td x:num="" align="right">2007</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>jan</td> <td x:num="" x:fmla="=C2+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>feb</td> <td x:num="" x:fmla="=C3+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>mar</td> <td x:num="" x:fmla="=C4+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>apr</td> <td x:num="" x:fmla="=C5+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>may</td> <td x:num="" x:fmla="=C6+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>jun</td> <td x:num="" x:fmla="=C7+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>jul</td> <td x:num="" x:fmla="=C8+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>aug</td> <td x:num="" x:fmla="=C9+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>jan</td> <td x:num="" x:fmla="=C10+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>feb</td> <td x:num="" x:fmla="=C11+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>mar</td> <td x:num="" x:fmla="=C12+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>apr</td> <td x:num="" x:fmla="=C13+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>may</td> <td x:num="" x:fmla="=C14+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>jun</td> <td x:num="" x:fmla="=C15+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>jul</td> <td x:num="" x:fmla="=C16+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>aug</td> <td x:num="" x:fmla="=C17+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>jan</td> <td x:num="" x:fmla="=C18+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>feb</td> <td x:num="" x:fmla="=C19+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>mar</td> <td x:num="" x:fmla="=C20+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>apr</td> <td x:num="" x:fmla="=C21+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>may</td> <td x:num="" x:fmla="=C22+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>jun</td> <td x:num="" x:fmla="=C23+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>jul</td> <td x:num="" x:fmla="=C24+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>aug</td> <td x:num="" x:fmla="=C25+1" align="right">2008</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>jan</td> <td x:num="" x:fmla="=C26+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>feb</td> <td x:num="" x:fmla="=C27+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>mar</td> <td x:num="" x:fmla="=C28+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>apr</td> <td x:num="" x:fmla="=C29+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>may</td> <td x:num="" x:fmla="=C30+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>jun</td> <td x:num="" x:fmla="=C31+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>jul</td> <td x:num="" x:fmla="=C32+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sales</td> <td>aug</td> <td x:num="" x:fmla="=C33+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>jan</td> <td x:num="" x:fmla="=C34+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>feb</td> <td x:num="" x:fmla="=C35+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>mar</td> <td x:num="" x:fmla="=C36+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>apr</td> <td x:num="" x:fmla="=C37+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>may</td> <td x:num="" x:fmla="=C38+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>jun</td> <td x:num="" x:fmla="=C39+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>jul</td> <td x:num="" x:fmla="=C40+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Expenses</td> <td>aug</td> <td x:num="" x:fmla="=C41+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>jan</td> <td x:num="" x:fmla="=C42+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>feb</td> <td x:num="" x:fmla="=C43+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>mar</td> <td x:num="" x:fmla="=C44+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>apr</td> <td x:num="" x:fmla="=C45+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>may</td> <td x:num="" x:fmla="=C46+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>jun</td> <td x:num="" x:fmla="=C47+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>jul</td> <td x:num="" x:fmla="=C48+1" align="right">2009</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Material</td> <td>aug</td> <td x:num="" x:fmla="=C49+1" align="right">2009</td> </tr> </tbody></table>
Thanks in Advance for helping