Formula for monthly cash flow projection based on billing date and value

[reemt]

Hi,

I'm working on a monthly cashflow projection and i need some help in a formula.

Actually it is a monthly forcast of cashflow per client based on the invoiced amounts and the date when it was invoiced and the terms of payment of this specific client.

so if for a client x, i have terms of payment of 30 days, and I invoiced 100k to him in FEB 2011, so i need to show in my monthly cash flow of 2011 automatically that i will be recieving from this client 100k in MAR 2011.

The billing amounts will be input, but i need a formula to have the cashflow plan as an output.

<TABLE style="WIDTH: 626pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=835><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 87pt; mso-width-source: userset; mso-width-alt: 4242" width=116><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 48pt" span=8 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17 width=64> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 87pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=116> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #c00000; WIDTH: 251pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl72 width=335 colSpan=5>Billing</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #0070c0; WIDTH: 240pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=320 colSpan=5>Cashflow</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>Client </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>Terms of payment </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>Jan-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>Feb-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>Mar-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>Apr-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>(etc)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>Jan-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>Feb-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>Mar-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>Apr-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>(etc)</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>X</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>30</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>0</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67> 100,000 </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>0</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>0</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>0</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68>????</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65> </TD></TR></TBODY></TABLE>

so, actually, in the table above, i need a formula for the monthly cashflow that will be dragged over all months and all clients that will be linked automatically to the billed amounts and related date and terms of payment.

thanks

 

[Snailspace]

The following simply looks up the cashflow month and finds the corresponding date less the terms in the invoicing section.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>



Excel 2003
<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>A</TH><TH>B</TH><TH>C</TH><TH>D</TH><TH>E</TH><TH>F</TH><TH>G</TH><TH>H</TH><TH>I</TH><TH>J</TH><TH>K</TH><TH>L</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">1</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ff0000; COLOR: #ffffff; BORDER-TOP: black 1px solid">Billing</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ff0000; COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ff0000; COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ff0000; COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ff0000; COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #0066cc; COLOR: #ffffff; BORDER-TOP: black 1px solid">Cashflow</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #0066cc; COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #0066cc; COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #0066cc; COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #0066cc; COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">2</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Client </TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Terms of payment </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Jan-11</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Feb-11</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Mar-11</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Apr-11</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">(etc)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Jan-11</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Feb-11</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Mar-11</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Apr-11</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">(etc)</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">3</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">X</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">100,000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">100000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">4</TD><TD style="BORDER-TOP: black 1px solid">y</TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid">60</TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid">1000</TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">1000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">5</TD><TD>z</TD><TD style="TEXT-ALIGN: right">30</TD><TD style="TEXT-ALIGN: right">2000</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">2000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">6</TD><TD>a</TD><TD style="TEXT-ALIGN: right">30</TD><TD style="TEXT-ALIGN: right">3000</TD><TD style="TEXT-ALIGN: right">20000</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">3000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">7</TD><TD>b</TD><TD style="TEXT-ALIGN: right">30</TD><TD style="TEXT-ALIGN: right">4000</TD><TD style="TEXT-ALIGN: right">20000</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">4000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">8</TD><TD>c</TD><TD style="TEXT-ALIGN: right">60</TD><TD style="TEXT-ALIGN: right">5000</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">5000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">9</TD><TD>d</TD><TD style="TEXT-ALIGN: right">30</TD><TD style="TEXT-ALIGN: right">6000</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">6000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">10</TD><TD>e</TD><TD style="TEXT-ALIGN: right">90</TD><TD style="TEXT-ALIGN: right">7000</TD><TD style="TEXT-ALIGN: right">20000</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">7000</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid"></TD></TR></TBODY></TABLE>

Sheet1​

Excel 2003<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>H</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">3</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD></TR></TBODY></TABLE>

Sheet1​

<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>H3</TH><TD style="TEXT-ALIGN: left">=IF(ISERROR(INDEX($C3:$F3,0,MATCH(H$2,$C$2:$F$2,1)-($B3/30))),"",INDEX($C3:$F3,0,MATCH(H$2,$C$2:$F$2,1)-($B3/30)))</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

 

[reemt]

hi,

Thank you for your reply .. but it didnt work with me ..

 

[Snailspace]

I wonder if this is down to us having different columns for the data.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Can you try copying the spreadsheet from my post into a blank workbook, delete column A that has the row numbers in it, clear the cells H3:K10. Then paste my formula into H3.Drag over to fill the cashflow section. <o></o>
If this works then we just need to substitute the correct columns into your spreadsheet.<o></o>

 

[reemt]

Hi, Thanks again for your reply,

i have tried it on a new worksheet as you said and it worked, but i donno why it is not working on my sheet.. below is my table with the related cell ref. and the formula that i used for cell AW6.
<TABLE style="WIDTH: 991pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1320><COLGROUP><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2413" width=66><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><COL style="WIDTH: 128pt; mso-width-source: userset; mso-width-alt: 6253" width=171><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669" width=73><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" span=2 width=84><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" span=8 width=84><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #95b3d7; WIDTH: 50pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl113 height=21 width=66> </TD><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4 1pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 65pt; BORDER-TOP: #b8cce4 1pt solid; BORDER-RIGHT: #b8cce4 1pt solid" class=xl110 width=86>C</TD><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #dbe5f1; WIDTH: 128pt; BORDER-TOP: #b8cce4 1pt solid; BORDER-RIGHT: #b8cce4 1pt solid" class=xl110 width=171>D</TD><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #dbe5f1; WIDTH: 55pt; BORDER-TOP: #b8cce4 1pt solid; BORDER-RIGHT: #b8cce4 1pt solid" class=xl110 width=73>S</TD><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #dbe5f1; WIDTH: 63pt; BORDER-TOP: #b8cce4 1pt solid; BORDER-RIGHT: #b8cce4 1pt solid" class=xl110 width=84>T</TD><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #dbe5f1; WIDTH: 63pt; BORDER-TOP: #b8cce4 1pt solid; BORDER-RIGHT: #b8cce4 1pt solid" class=xl110 width=84>U</TD><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #dbe5f1; WIDTH: 63pt; BORDER-TOP: #b8cce4 1pt solid; BORDER-RIGHT: #b8cce4 1pt solid" class=xl110 width=84>V</TD><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #dbe5f1; WIDTH: 63pt; BORDER-TOP: #b8cce4 1pt solid; BORDER-RIGHT: #b8cce4 1pt solid" class=xl110 width=84>W </TD><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #dbe5f1; WIDTH: 63pt; BORDER-TOP: #b8cce4 1pt solid; BORDER-RIGHT: #b8cce4 1pt solid" class=xl110 width=84>X</TD><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #dbe5f1; WIDTH: 63pt; BORDER-TOP: #b8cce4 1pt solid; BORDER-RIGHT: #b8cce4 1pt solid" class=xl110 width=84>AW</TD><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #dbe5f1; WIDTH: 63pt; BORDER-TOP: #b8cce4 1pt solid; BORDER-RIGHT: #b8cce4 1pt solid" class=xl110 width=84>AY</TD><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #dbe5f1; WIDTH: 63pt; BORDER-TOP: #b8cce4 1pt solid; BORDER-RIGHT: #b8cce4 1pt solid" class=xl110 width=84>AZ</TD><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #dbe5f1; WIDTH: 63pt; BORDER-TOP: #b8cce4 1pt solid; BORDER-RIGHT: #b8cce4 1pt solid" class=xl110 width=84>BA</TD><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #dbe5f1; WIDTH: 63pt; BORDER-TOP: #b8cce4 1pt solid; BORDER-RIGHT: #b8cce4 1pt solid" class=xl110 width=84>BB</TD><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #dbe5f1; WIDTH: 63pt; BORDER-TOP: #b8cce4 1pt solid; BORDER-RIGHT: #b8cce4 1pt solid" class=xl110 width=84>BC</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4 1pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 50pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 1pt solid" class=xl111 height=21 width=66>4</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 65pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=86></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 128pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=171></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 55pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl103 width=73>Jul-11</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl103 width=84>Aug-11</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl103 width=84>Sep-11</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl103 width=84>Oct-11</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl103 width=84>Nov-11</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl103 width=84>Dec-11</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl103 width=84>Jul-11</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl103 width=84>Aug-11</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl103 width=84>Sep-11</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl103 width=84>Oct-11</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl103 width=84>Nov-11</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl103 width=84>Dec-11</TD></TR><TR style="HEIGHT: 25.5pt; mso-height-source: userset" height=34><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4 1pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 50pt; HEIGHT: 25.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 1pt solid" class=xl111 height=34 width=66>5</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #c00000; WIDTH: 65pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl105 width=86>Days to Pay</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: #c00000; WIDTH: 128pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl68 width=171>Client</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: #632523; WIDTH: 55pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl71 width=73>WF Jul 2011</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: #632523; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl71 width=84>WF Aug 2011</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: #632523; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl71 width=84>WF Sep 2011</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: #632523; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl71 width=84>WF Oct 2011</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: #632523; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl71 width=84>WF Nov 2011</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: #632523; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl71 width=84>WF Dec 2011</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: #0070c0; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl73 width=84>CF Jul 2011</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: #0070c0; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl73 width=84>CF Aug 2011</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: #0070c0; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl73 width=84>CF Sep 2011</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: #0070c0; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl73 width=84>CF Oct 2011</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: #0070c0; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl73 width=84>CF Nov 2011</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: #0070c0; WIDTH: 63pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl73 width=84>CF Dec 2011</TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4 1pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 50pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 1pt solid" class=xl111 height=17 width=66>6</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 65pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl106 width=86>30</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 128pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl75 width=171>Manazel</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl78> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl78> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl78> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl78> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl78> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl78> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4 1pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 50pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 1pt solid" class=xl111 height=17 width=66>7</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 65pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl107 width=86>30</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 128pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl86 width=171>SERCO</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 55pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl88 width=73> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl88 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl88 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl88 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl88 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl88 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4 1pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 50pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 1pt solid" class=xl111 height=17 width=66>8</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 65pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl108 width=86>30</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 128pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl92 width=171>TDIC</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 55pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl94 width=73> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl94 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl94 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl94 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl94 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl94 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4 1pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 50pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 1pt solid" class=xl111 height=17 width=66>9</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 65pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl106 width=86>30</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 128pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl95 width=171>TDIC</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 55pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=73> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4 1pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 50pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 1pt solid" class=xl111 height=17 width=66>10</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 65pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl106 width=86>30</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 128pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl75 width=171>TDIC</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 55pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=73>90,000</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4 1pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 50pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 1pt solid" class=xl111 height=17 width=66>11</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 65pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl106 width=86>30</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 128pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl75 width=171>TDIC</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 55pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=73>20,000</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4 1pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 50pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 1pt solid" class=xl111 height=17 width=66>12</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 65pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl106 width=86>30</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 128pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl75 width=171>TDIC</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 55pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=73> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4 1pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 50pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 1pt solid" class=xl111 height=17 width=66>13</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 65pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl107 width=86> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 128pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl99 width=171>TDIC</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 55pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl88 width=73> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl88 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl88 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl88 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl88 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl88 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4 1pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 50pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 1pt solid" class=xl111 height=17 width=66>14</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 65pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl106 width=86>30</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 128pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl75 width=171>Tameer Holding Investments LLC</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 55pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=73> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84>45,000</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4 1pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 50pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 1pt solid" class=xl111 height=17 width=66>15</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 65pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl109 width=86>30</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 128pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl91 width=171>Abwab Real Estate</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 55pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl94 width=73> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl94 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl94 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl94 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl94 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl94 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: #b8cce4 1pt solid; BORDER-LEFT: #b8cce4 1pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 50pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 1pt solid" class=xl111 height=17 width=66>16</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 65pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl106 width=86>30</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 128pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl95 width=171>ACW Holdings Ltd.</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 55pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=73> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84>27,500</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84>30,000</TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl77 width=84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD><TD style="BORDER-BOTTOM: #a5a5a5 1pt solid; BORDER-LEFT: #a5a5a5; BACKGROUND-COLOR: transparent; BORDER-TOP: #a5a5a5; BORDER-RIGHT: #a5a5a5 1pt solid" class=xl84> </TD></TR></TBODY></TABLE>


the formula that i used for AW6 is:

=IF(ISERROR(INDEX($S6:$X6,0,MATCH(AW$4,$S$4:$X$4,1)-($C6/30))),"",INDEX($S6:$X6,0,MATCH(AW$4,$S$2:$X$4,1)-($C6/30)))

thanks

 

[reemt]

Hello,

i just tried it again and it worked.. thank you

 

[reemt]

Hi Again,

Can you give me please a very brief explaination of how this formula is made .. i mean i know the index match function, but how by adding a minus the number of month it will move forward by the same number ?

Thank you very much...

 

[Snailspace]

Glad it works,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
The match part looks at the appropriate month and finds the corresponding position in the invoicing headers.<o></o>

Excel 2003<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>A</TH><TH>B</TH><TH>C</TH><TH>D</TH><TH>E</TH><TH>F</TH><TH>G</TH><TH>H</TH><TH>I</TH><TH>J</TH><TH>K</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">1</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ff0000; COLOR: #ffffff; BORDER-TOP: black 1px solid">Billing</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ff0000; COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ff0000; COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ff0000; COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ff0000; COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #0066cc; COLOR: #ffffff; BORDER-TOP: black 1px solid">Cashflow</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #0066cc; COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #0066cc; COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #0066cc; COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #0066cc; COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">2</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Client</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Terms of payment</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Jan-11</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Feb-11</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Mar-11</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Apr-11</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">(etc)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Jan-11</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Feb-11</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Mar-11</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Apr-11</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">3</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">X</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">100,000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid">1</TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid">2</TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid">3</TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">4</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">4</TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid">y</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid">60</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid">1000</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid">1</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right; BORDER-RIGHT: black 1px solid">4</TD></TR></TBODY></TABLE>

Sheet3​

<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>H3</TH><TD style="TEXT-ALIGN: left">=MATCH(H$2,$C$2:$F$2,1)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>I3</TH><TD style="TEXT-ALIGN: left">=MATCH(I$2,$C$2:$F$2,1)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>J3</TH><TD style="TEXT-ALIGN: left">=MATCH(J$2,$C$2:$F$2,1)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>K3</TH><TD style="TEXT-ALIGN: left">=MATCH(K$2,$C$2:$F$2,1)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>H4</TH><TD style="TEXT-ALIGN: left">=MATCH(H$2,$C$2:$F$2,1)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>I4</TH><TD style="TEXT-ALIGN: left">=MATCH(I$2,$C$2:$F$2,1)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>J4</TH><TD style="TEXT-ALIGN: left">=MATCH(J$2,$C$2:$F$2,1)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>K4</TH><TD style="TEXT-ALIGN: left">=MATCH(K$2,$C$2:$F$2,1)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>


As your terms are likely to be multiples of 30 divide the terms by this to find out how many columns back you want to look at the information. This is then passed to the index function to tell it which value to return.<o></o>

Excel 2003<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>A</TH><TH>B</TH><TH>C</TH><TH>D</TH><TH>E</TH><TH>F</TH><TH>G</TH><TH>H</TH><TH>I</TH><TH>J</TH><TH>K</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">1</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ff0000; COLOR: #ffffff; BORDER-TOP: black 1px solid">Billing</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ff0000; COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ff0000; COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ff0000; COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ff0000; COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #0066cc; COLOR: #ffffff; BORDER-TOP: black 1px solid">Cashflow</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #0066cc; COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #0066cc; COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #0066cc; COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #0066cc; COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">2</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Client</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Terms of payment</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Jan-11</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Feb-11</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Mar-11</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Apr-11</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">(etc)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Jan-11</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Feb-11</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Mar-11</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Apr-11</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">3</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">X</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">100,000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid">0</TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid">1</TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid">2</TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">3</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">4</TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid">y</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid">60</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid">1000</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid">-1</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right; BORDER-RIGHT: black 1px solid">2</TD></TR></TBODY></TABLE>

Sheet3​

<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>H3</TH><TD style="TEXT-ALIGN: left">=MATCH(H$2,$C$2:$F$2,1)-($B3/30)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>I3</TH><TD style="TEXT-ALIGN: left">=MATCH(I$2,$C$2:$F$2,1)-($B3/30)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>J3</TH><TD style="TEXT-ALIGN: left">=MATCH(J$2,$C$2:$F$2,1)-($B3/30)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>K3</TH><TD style="TEXT-ALIGN: left">=MATCH(K$2,$C$2:$F$2,1)-($B3/30)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>H4</TH><TD style="TEXT-ALIGN: left">=MATCH(H$2,$C$2:$F$2,1)-($B4/30)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>I4</TH><TD style="TEXT-ALIGN: left">=MATCH(I$2,$C$2:$F$2,1)-($B4/30)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>J4</TH><TD style="TEXT-ALIGN: left">=MATCH(J$2,$C$2:$F$2,1)-($B4/30)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>K4</TH><TD style="TEXT-ALIGN: left">=MATCH(K$2,$C$2:$F$2,1)-($B4/30)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
The iserr part is just to make it look tidier for the #value errors that occur if you are trying to look for a column which does not exist, i.e Jan in cashflow as you cannot count back a column since it does not exist.

Hope that makes sense.

As an aside,<o></o>
I’m not sure what raw data you’re pulling the information in from, but you could possibly use the same principle of dividing by 30, and using this in the EOMONTH function based on invoice date.<o></o>
Then you may be able to use a pivot table rather than having to fill in the invoice totals.<o></o>
<o></o>