All -- this is on my Christmas wishlist:
I would love to trim the excess from a general ledger that our system generates. On several accounts, we have rows and rows of transactional data that we simply do not need to see. In the below, I would want 'p' and 'r' summarized, but I would always want to see each and every line with a 'j'
I don't want to simply delete the rows or hide them so the report still 'works' if you took a calculator to it and added it by hand...
Does it seem like this is even doable, or am I biting off more than I can chew here?
thanks for the advice and help!!
This is what we currently have (super abbreviated of course):
<script language="JavaScript" src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></script><center><table align="center" cellpadding="0" cellspacing="0"><tbody><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0);" colspan="11" bgcolor="#0c266b"><table align="center" border="0" width="100%"><tbody><tr><td align="left">Microsoft Excel - testy.xls</td><td style="font-size: 9pt; color: rgb(255, 255, 255); font-family: caption;" align="right">___Running: 12.0 : OS = Windows XP </td></tr></tbody></table></td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); height: 25px;" colspan="11" bgcolor="#d4d0c8"><table valign="MIDDLE" align="center" border="0" width="100%"><tbody><tr><td style="font-size: 10pt; color: rgb(0, 0, 0); font-family: caption;">(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout</td><td align="right" valign="center"><form name="formCb755237"><input onclick='window.clipboardData.setData("Text",document.formFb078704.sltNb935705.value);' value="Copy Formula" name="btCb873980" type="button"></form></td></tr></tbody></table></td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0);" colspan="11" bgcolor="white"><table border="0"><tbody><tr><form name="formFb078704"></form><td style="width: 60px;" align="middle" bgcolor="white"><select onchange="document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value" name="sltNb935705"><option value="=+I1+G2-H2" selected="selected">I2</option><option value="=+I2+G3-H3">I3</option><option value="=+I3+G4-H4">I4</option><option value="=+I4+G5-H5">I5</option><option value="=+I5+G6-H6">I6</option><option value="=+I6+G7-H7">I7</option><option value="=+I7+G8-H8">I8</option><option value="=+I8">I9</option></select></td><td align="right" bgcolor="#d4d0c8" width="3%">=</td><td align="left" bgcolor="white"><input size="80" value="=+I1+G2-H2" name="txbFb426622"></td></tr></tbody></table></td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); background-color: rgb(212, 208, 200);" align="middle" width="2%">
</td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>A</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>B</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>C</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>D</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>E</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>F</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>G</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>H</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>I</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>J</center></td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>1</center></td><td style="border-style: solid; border-color: rgb(0, 0, 0) rgb(212, 208, 200) rgb(212, 208, 200) rgb(0, 0, 0); border-width: 0.5pt; font-weight: bold; font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;">23010-000</td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;">Prepaid Revenue</td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;">(5,748.03)</td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> = Beginning Balance =</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>2</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">ceshorel</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">6/2/2008</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">07/08 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">(t0134922) SOME GUY</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">R-3878219</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">mo5761722350</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">17.68 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">(5,730.35)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">:Prog Gen Reverses receipt C</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>3</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">ceshorel</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">6/2/2008</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">07/08 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">(t0134922) SOME GUY</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">R-3878223</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">mo5761722349</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">300.00 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">(5,430.35)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">:Prog Gen Reverses receipt C</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>4</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">ceshorel</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">6/2/2008</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">07/08 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">(t0134922) SOME GUY</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">R-3878218</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">none</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">17.68 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">(5,448.03)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">:Prog Gen Reverses receipt C</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>5</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">ceshorel</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">6/2/2008</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">07/08 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">(t0134922) SOME GUY</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">R-3878222</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">none</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">300.00 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">(5,748.03)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">:Prog Gen Reverses receipt C</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>6</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">ceshorel</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">6/24/2008</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">07/08 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">(t0162151) ANOTHER GUY</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">R-3716309</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">none</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">523.10 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">(5,224.93)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">:Prog Gen prepayment transfe</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>7</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">ceshorel</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">7/1/2008</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">07/08 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">(ACCRUAL) 06/08 FCF ACCRUALS</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">J-197214</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">:Reversal of</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">290.00 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">(5,514.93)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">Doe - 201</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>8</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">ceshorel</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">7/8/2008</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">07/08 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">(ceapa150) A Something</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">P-688952</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">30485</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">272.50 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">(5,242.43)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">#220 Doey</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>9</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); text-indent: 1em; font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;">NetChange= 505.60</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;">(5,242.43)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> = Ending Balance =</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>10</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;"> </td></tr><tr><td style="border-style: solid; border-color: rgb(128, 128, 128) rgb(0, 0, 0) rgb(0, 0, 0); border-width: 0.5pt; background-color: rgb(212, 208, 200);" colspan="11"><table valign="TOP" align="left" width="100%"><tbody><tr><td style="border-style: solid; border-color: rgb(128, 128, 128) rgb(0, 0, 0) rgb(0, 0, 0); border-width: 0.5pt; width: 120pt; background-color: rgb(255, 255, 255);" align="left">$$436312136522</td><td> </td></tr></tbody></table></td></tr></tbody></table>
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</center>
This is what I would like to achieve:
<script language="JavaScript" src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></script><center><table align="center" cellpadding="0" cellspacing="0"><tbody><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0);" colspan="11" bgcolor="#0c266b"><table align="center" border="0" width="100%"><tbody><tr><td align="left">Microsoft Excel - testy.xls</td><td style="font-size: 9pt; color: rgb(255, 255, 255); font-family: caption;" align="right">___Running: 12.0 : OS = Windows XP </td></tr></tbody></table></td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); height: 25px;" colspan="11" bgcolor="#d4d0c8"><table valign="MIDDLE" align="center" border="0" width="100%"><tbody><tr><td style="font-size: 10pt; color: rgb(0, 0, 0); font-family: caption;">(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout</td><td align="right" valign="center"><form name="formCb605117"><input onclick='window.clipboardData.setData("Text",document.formFb202339.sltNb447362.value);' value="Copy Formula" name="btCb942116" type="button"></form></td></tr></tbody></table></td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0);" colspan="11" bgcolor="white"><table border="0"><tbody><tr><form name="formFb202339"></form><td style="width: 60px;" align="middle" bgcolor="white"><select onchange="document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value" name="sltNb447362"><option value="=+I13+G14-H14" selected="selected">I14</option><option value="=+I14+G15-H15">I15</option><option value="=+I15+G16-H16">I16</option><option value="=+I16">I17</option></select></td><td align="right" bgcolor="#d4d0c8" width="3%">=</td><td align="left" bgcolor="white"><input size="80" value="=+I13+G14-H14" name="txbFb150492"></td></tr></tbody></table></td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); background-color: rgb(212, 208, 200);" align="middle" width="2%">
</td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>A</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>B</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>C</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>D</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>E</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>F</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>G</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>H</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>I</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>J</center></td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>13</center></td><td style="border-style: solid; border-color: rgb(0, 0, 0) rgb(212, 208, 200) rgb(212, 208, 200) rgb(0, 0, 0); border-width: 0.5pt; font-weight: bold; font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;">23010-000</td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;">Prepaid Revenue</td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;">(5,748.03)</td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> = Beginning Balance =</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>14</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">ceshorel</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">7/1/2008</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">07/08 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">(ACCRUAL) 06/08 FCF ACCRUALS</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">J-197214</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">:Reversal of</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">290.00 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">(6,038.03)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">Doe - 201</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>15</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">ceshorel</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">7/31/2008</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">07/08 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">NET CHANGE</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;"> ---</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;"> ---</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">523.10 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">(5,514.93)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">All R Activity</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>16</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">ceshorel</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">7/31/2008</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">07/08 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">NET CHANGE</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;"> ---</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;"> ---</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">272.50 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">(5,242.43)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">All P Activity</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>17</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); text-indent: 1em; font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;">NetChange= 505.60</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;">(5,242.43)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> = Ending Balance =</td></tr><tr><td style="border-style: solid; border-color: rgb(128, 128, 128) rgb(0, 0, 0) rgb(0, 0, 0); border-width: 0.5pt; background-color: rgb(212, 208, 200);" colspan="11"><table valign="TOP" align="left" width="100%"><tbody><tr><td style="border-style: solid; border-color: rgb(128, 128, 128) rgb(0, 0, 0) rgb(0, 0, 0); border-width: 0.5pt; width: 120pt; background-color: rgb(255, 255, 255);" align="left">$$436312136522</td><td> </td></tr></tbody></table></td></tr></tbody></table>
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
</center>
I would love to trim the excess from a general ledger that our system generates. On several accounts, we have rows and rows of transactional data that we simply do not need to see. In the below, I would want 'p' and 'r' summarized, but I would always want to see each and every line with a 'j'
I don't want to simply delete the rows or hide them so the report still 'works' if you took a calculator to it and added it by hand...
Does it seem like this is even doable, or am I biting off more than I can chew here?
thanks for the advice and help!!
This is what we currently have (super abbreviated of course):
<script language="JavaScript" src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></script><center><table align="center" cellpadding="0" cellspacing="0"><tbody><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0);" colspan="11" bgcolor="#0c266b"><table align="center" border="0" width="100%"><tbody><tr><td align="left">Microsoft Excel - testy.xls</td><td style="font-size: 9pt; color: rgb(255, 255, 255); font-family: caption;" align="right">___Running: 12.0 : OS = Windows XP </td></tr></tbody></table></td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); height: 25px;" colspan="11" bgcolor="#d4d0c8"><table valign="MIDDLE" align="center" border="0" width="100%"><tbody><tr><td style="font-size: 10pt; color: rgb(0, 0, 0); font-family: caption;">(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout</td><td align="right" valign="center"><form name="formCb755237"><input onclick='window.clipboardData.setData("Text",document.formFb078704.sltNb935705.value);' value="Copy Formula" name="btCb873980" type="button"></form></td></tr></tbody></table></td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0);" colspan="11" bgcolor="white"><table border="0"><tbody><tr><form name="formFb078704"></form><td style="width: 60px;" align="middle" bgcolor="white"><select onchange="document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value" name="sltNb935705"><option value="=+I1+G2-H2" selected="selected">I2</option><option value="=+I2+G3-H3">I3</option><option value="=+I3+G4-H4">I4</option><option value="=+I4+G5-H5">I5</option><option value="=+I5+G6-H6">I6</option><option value="=+I6+G7-H7">I7</option><option value="=+I7+G8-H8">I8</option><option value="=+I8">I9</option></select></td><td align="right" bgcolor="#d4d0c8" width="3%">=</td><td align="left" bgcolor="white"><input size="80" value="=+I1+G2-H2" name="txbFb426622"></td></tr></tbody></table></td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); background-color: rgb(212, 208, 200);" align="middle" width="2%">
</td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>A</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>B</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>C</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>D</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>E</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>F</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>G</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>H</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>I</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>J</center></td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>1</center></td><td style="border-style: solid; border-color: rgb(0, 0, 0) rgb(212, 208, 200) rgb(212, 208, 200) rgb(0, 0, 0); border-width: 0.5pt; font-weight: bold; font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;">23010-000</td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;">Prepaid Revenue</td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;">(5,748.03)</td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> = Beginning Balance =</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>2</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">ceshorel</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">6/2/2008</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">07/08 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">(t0134922) SOME GUY</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">R-3878219</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">mo5761722350</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">17.68 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">(5,730.35)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">:Prog Gen Reverses receipt C</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>3</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">ceshorel</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">6/2/2008</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">07/08 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">(t0134922) SOME GUY</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">R-3878223</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">mo5761722349</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">300.00 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">(5,430.35)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">:Prog Gen Reverses receipt C</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>4</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">ceshorel</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">6/2/2008</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">07/08 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">(t0134922) SOME GUY</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">R-3878218</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">none</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">17.68 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">(5,448.03)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">:Prog Gen Reverses receipt C</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>5</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">ceshorel</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">6/2/2008</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">07/08 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">(t0134922) SOME GUY</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">R-3878222</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">none</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">300.00 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">(5,748.03)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">:Prog Gen Reverses receipt C</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>6</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">ceshorel</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">6/24/2008</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">07/08 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">(t0162151) ANOTHER GUY</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">R-3716309</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">none</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">523.10 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">(5,224.93)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">:Prog Gen prepayment transfe</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>7</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">ceshorel</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">7/1/2008</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">07/08 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">(ACCRUAL) 06/08 FCF ACCRUALS</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">J-197214</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">:Reversal of</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">290.00 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">(5,514.93)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">Doe - 201</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>8</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">ceshorel</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">7/8/2008</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">07/08 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">(ceapa150) A Something</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">P-688952</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">30485</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">272.50 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">(5,242.43)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">#220 Doey</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>9</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); text-indent: 1em; font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;">NetChange= 505.60</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;">(5,242.43)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> = Ending Balance =</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>10</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;"> </td></tr><tr><td style="border-style: solid; border-color: rgb(128, 128, 128) rgb(0, 0, 0) rgb(0, 0, 0); border-width: 0.5pt; background-color: rgb(212, 208, 200);" colspan="11"><table valign="TOP" align="left" width="100%"><tbody><tr><td style="border-style: solid; border-color: rgb(128, 128, 128) rgb(0, 0, 0) rgb(0, 0, 0); border-width: 0.5pt; width: 120pt; background-color: rgb(255, 255, 255);" align="left">$$436312136522</td><td> </td></tr></tbody></table></td></tr></tbody></table>
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</center>
This is what I would like to achieve:
<script language="JavaScript" src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></script><center><table align="center" cellpadding="0" cellspacing="0"><tbody><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0);" colspan="11" bgcolor="#0c266b"><table align="center" border="0" width="100%"><tbody><tr><td align="left">Microsoft Excel - testy.xls</td><td style="font-size: 9pt; color: rgb(255, 255, 255); font-family: caption;" align="right">___Running: 12.0 : OS = Windows XP </td></tr></tbody></table></td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); height: 25px;" colspan="11" bgcolor="#d4d0c8"><table valign="MIDDLE" align="center" border="0" width="100%"><tbody><tr><td style="font-size: 10pt; color: rgb(0, 0, 0); font-family: caption;">(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout</td><td align="right" valign="center"><form name="formCb605117"><input onclick='window.clipboardData.setData("Text",document.formFb202339.sltNb447362.value);' value="Copy Formula" name="btCb942116" type="button"></form></td></tr></tbody></table></td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0);" colspan="11" bgcolor="white"><table border="0"><tbody><tr><form name="formFb202339"></form><td style="width: 60px;" align="middle" bgcolor="white"><select onchange="document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value" name="sltNb447362"><option value="=+I13+G14-H14" selected="selected">I14</option><option value="=+I14+G15-H15">I15</option><option value="=+I15+G16-H16">I16</option><option value="=+I16">I17</option></select></td><td align="right" bgcolor="#d4d0c8" width="3%">=</td><td align="left" bgcolor="white"><input size="80" value="=+I13+G14-H14" name="txbFb150492"></td></tr></tbody></table></td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); background-color: rgb(212, 208, 200);" align="middle" width="2%">
</td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>A</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>B</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>C</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>D</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>E</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>F</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>G</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>H</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>I</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>J</center></td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>13</center></td><td style="border-style: solid; border-color: rgb(0, 0, 0) rgb(212, 208, 200) rgb(212, 208, 200) rgb(0, 0, 0); border-width: 0.5pt; font-weight: bold; font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;">23010-000</td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;">Prepaid Revenue</td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;">(5,748.03)</td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> = Beginning Balance =</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>14</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">ceshorel</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">7/1/2008</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">07/08 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">(ACCRUAL) 06/08 FCF ACCRUALS</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">J-197214</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">:Reversal of</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">290.00 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">(6,038.03)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">Doe - 201</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>15</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">ceshorel</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">7/31/2008</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">07/08 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">NET CHANGE</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;"> ---</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;"> ---</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">523.10 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">(5,514.93)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">All R Activity</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>16</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">ceshorel</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">7/31/2008</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">07/08 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">NET CHANGE</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;"> ---</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;"> ---</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">272.50 </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;">(5,242.43)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;">All P Activity</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>17</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); text-indent: 1em; font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;">NetChange= 505.60</td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: right;">(5,242.43)</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(153, 204, 255); text-align: left;"> = Ending Balance =</td></tr><tr><td style="border-style: solid; border-color: rgb(128, 128, 128) rgb(0, 0, 0) rgb(0, 0, 0); border-width: 0.5pt; background-color: rgb(212, 208, 200);" colspan="11"><table valign="TOP" align="left" width="100%"><tbody><tr><td style="border-style: solid; border-color: rgb(128, 128, 128) rgb(0, 0, 0) rgb(0, 0, 0); border-width: 0.5pt; width: 120pt; background-color: rgb(255, 255, 255);" align="left">$$436312136522</td><td> </td></tr></tbody></table></td></tr></tbody></table>
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
</center>