<table x:str="" style="border-collapse: collapse; width: 1558pt;" width="2081" border="0" cellpadding="0" cellspacing="0"><col style="width: 38pt;" width="51"> <col style="width: 44pt;" width="58"> <col style="width: 35pt;" span="12" width="47"> <col style="width: 48pt;" width="64"> <col style="width: 48pt;" span="21" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td colspan="36" class="xl25" style="height: 12.75pt; width: 1558pt;" width="2081" height="17">I have a problem with scheduling Project Income.
I have extracted one of the Projects Revenue Streams but have not been successful in scheduling the expected Billing Flow in a Calendar Yr template according to the rules listed.
Ideal - to change the The Key Milestone dates for delays etc - that will automatically trigger when the project billing will occur.</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td colspan="8" class="xl25" style="height: 12.75pt;" height="17">Have spent time with date formulas etc but failed</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" colspan="3" style="height: 12.75pt;" height="17">Can somebody help me?</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td colspan="7" class="xl25" style="height: 12.75pt;" height="17">Thanks in advance
<table x:str="" style="border-collapse: collapse; width: 502pt;" width="673" border="0" cellpadding="0" cellspacing="0"><col style="width: 38pt;" width="51"> <col style="width: 44pt;" width="58"> <col style="width: 35pt;" span="12" width="47"> <tbody><tr style="height: 11.25pt;" height="15"> <td class="xl29" colspan="2" style="height: 11.25pt; width: 82pt;" width="109" height="15">1. Schedule of Charging Streams</td> <td class="xl31" style="width: 35pt;" width="47">Mth 1</td> <td class="xl31" style="width: 35pt;" width="47">Mth 2</td> <td class="xl31" style="width: 35pt;" width="47">Mth 3</td> <td class="xl31" style="width: 35pt;" width="47">Mth 4</td> <td class="xl31" style="width: 35pt;" width="47">Mth 5</td> <td class="xl31" style="width: 35pt;" width="47">Mth 6</td> <td class="xl31" style="width: 35pt;" width="47">Mth 7</td> <td class="xl31" style="width: 35pt;" width="47">Mth 8</td> <td class="xl31" style="width: 35pt;" width="47">Mth 9</td> <td class="xl31" style="width: 35pt;" width="47">Mth 10</td> <td class="xl31" style="width: 35pt;" width="47">Mth 11</td> <td class="xl31" style="width: 35pt;" width="47">Mth 12</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl32" colspan="3" style="height: 11.25pt;" height="15">Revenue Streams (£k)</td> <td class="xl31"> </td> <td class="xl31"> </td> <td class="xl31"> </td> <td class="xl31"> </td> <td class="xl31"> </td> <td class="xl31"> </td> <td class="xl31"> </td> <td class="xl31"> </td> <td class="xl31"> </td> <td class="xl31"> </td> <td class="xl31"> </td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl33" style="height: 11.25pt;" height="15">Charge Stream 1</td> <td class="xl30"> </td> <td class="xl34" x:num="518.41209880000008">518</td> <td class="xl34" x:num="1.9978475999999998">2</td> <td class="xl34" x:num="1.9978475999999998">2</td> <td class="xl34" x:num="1.9978475999999998">2</td> <td class="xl34" x:num="1.9978475999999998">2</td> <td class="xl34" x:num="1.9978475999999998">2</td> <td class="xl34" x:num="1.9978475999999998">2</td> <td class="xl34" x:num="1.9978475999999998">2</td> <td class="xl34" x:num="1.9978475999999998">2</td> <td class="xl34" x:num="1.9978475999999998">2</td> <td class="xl34" x:num="1.9978475999999998">2</td> <td class="xl34" x:num="1.9978475999999998">2</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl33" style="height: 11.25pt;" height="15">Charge Stream 2</td> <td class="xl30"> </td> <td class="xl34" x:num="150.14433526507062">150</td> <td class="xl34" x:num="">75</td> <td class="xl34" x:num="">75</td> <td class="xl34" x:num="">50</td> <td class="xl34" x:num="">50</td> <td class="xl34" x:num="">50</td> <td class="xl34" x:num="">50</td> <td class="xl34" x:num="">50</td> <td class="xl34" x:num="">50</td> <td class="xl34" x:num="">50</td> <td class="xl34" x:num="">50</td> <td class="xl34" x:num="">50</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl33" style="height: 11.25pt;" height="15">Charge Stream 3</td> <td class="xl30"> </td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl33" style="height: 11.25pt;" height="15">Charge Stream 4</td> <td class="xl30"> </td> <td class="xl34" x:num="">0</td> <td class="xl34" x:num="">0</td> <td class="xl35" x:num="">300</td> <td class="xl34" x:num="">0</td> <td class="xl34" x:num="">0</td> <td class="xl35" x:num="">300</td> <td class="xl34" x:num="">0</td> <td class="xl34" x:num="">0</td> <td class="xl35" x:num="">300</td> <td class="xl34" x:num="">0</td> <td class="xl34" x:num="">0</td> <td class="xl34" x:num="">0</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl33" style="height: 12pt;" height="16"> </td> <td class="xl30"> </td> <td class="xl36" x:num="768.55643406507068" x:fmla="=SUM(C3:C6)">769</td> <td class="xl36" x:num="176.9978476" x:fmla="=SUM(D3:D6)">177</td> <td class="xl37" x:num="476.9978476" x:fmla="=SUM(E3:E6)">477</td> <td class="xl36" x:num="151.9978476" x:fmla="=SUM(F3:F6)">152</td> <td class="xl36" x:num="151.9978476" x:fmla="=SUM(G3:G6)">152</td> <td class="xl36" style="border-top: medium none;" x:num="451.9978476" x:fmla="=SUM(H3:H6)">452</td> <td class="xl36" x:num="151.9978476" x:fmla="=SUM(I3:I6)">152</td> <td class="xl36" x:num="151.9978476" x:fmla="=SUM(J3:J6)">152</td> <td class="xl36" style="border-top: medium none;" x:num="451.9978476" x:fmla="=SUM(K3:K6)">452</td> <td class="xl36" x:num="151.9978476" x:fmla="=SUM(L3:L6)">152</td> <td class="xl36" x:num="151.9978476" x:fmla="=SUM(M3:M6)">152</td> <td class="xl36" x:num="151.9978476" x:fmla="=SUM(N3:N6)">152</td> </tr> <tr style="height: 6.75pt;" height="9"> <td class="xl24" style="height: 6.75pt;" height="9">
</td> <td class="xl24">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl38" style="height: 11.25pt;" height="15">Billing Start Dates</td> <td class="xl25"> </td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl25" style="height: 11.25pt;" height="15">Milestone 1</td> <td class="xl39" x:num="39976">12-Jun-09</td> <td class="xl43" colspan="6" style="">these start dates can be changed for delays etc</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl25" style="height: 11.25pt;" height="15">Milestone 2</td> <td class="xl39" x:num="40068">12-Sep-09</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 6.75pt;" height="9"> <td class="xl24" style="height: 6.75pt;" height="9">
</td> <td class="xl24">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl40" style="height: 11.25pt;" height="15">Billing Criteria</td> <td class="xl24">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td colspan="14" class="xl41" style="height: 11.25pt;" height="15">1. Revenue Stream 1; billing commences 1 month in arrears from Milestone 1 achievement</td> </tr> <tr style="height: 11.25pt;" height="15"> <td colspan="14" class="xl41" style="height: 11.25pt;" height="15">2. Revenue Stream 2 & 3; billing commences 1 month in arrears from Milestone 2 dates</td> </tr> <tr style="height: 11.25pt;" height="15"> <td colspan="14" class="xl41" style="height: 11.25pt;" height="15">3. Revenue Stream 4; billing commences 4 month after Milestone 1 Date</td> </tr> <tr style="height: 6pt;" height="8"> <td class="xl41" style="height: 6pt;" height="8">
</td> <td class="xl41">
</td> <td class="xl42">
</td> <td class="xl42">
</td> <td class="xl42">
</td> <td class="xl42">
</td> <td class="xl42">
</td> <td class="xl42">
</td> <td class="xl42">
</td> <td class="xl42">
</td> <td class="xl42">
</td> <td class="xl42">
</td> <td class="xl42">
</td> <td class="xl42">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl26" style="height: 11.25pt;" height="15">Billing</td> <td class="xl24">
</td> <td class="xl27">Apr</td> <td class="xl27">May</td> <td class="xl27">Jun</td> <td class="xl27">Jul</td> <td class="xl27">Aug</td> <td class="xl27">Sep</td> <td class="xl27">Oct</td> <td class="xl27">Nov</td> <td class="xl27">Dec</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl24" style="height: 11.25pt;" height="15">
</td> <td class="xl24">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl33" style="height: 11.25pt;" height="15">Cash Stream 1</td> <td class="xl26"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl33" style="height: 11.25pt;" height="15">Cash Stream 2</td> <td class="xl26"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl33" style="height: 11.25pt;" height="15">Cash Stream 3</td> <td class="xl26"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl33" style="height: 11.25pt;" height="15">Cash Stream 4</td> <td class="xl26"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl24" style="height: 11.25pt;" height="15">
</td> <td class="xl24">
</td> <td class="xl27" x:num="" x:fmla="=SUM(C20:C23)">0</td> <td class="xl27" x:num="" x:fmla="=SUM(D20:D23)">0</td> <td class="xl27" x:num="" x:fmla="=SUM(E20:E23)">0</td> <td class="xl27" x:num="" x:fmla="=SUM(F20:F23)">0</td> <td class="xl27" x:num="" x:fmla="=SUM(G20:G23)">0</td> <td class="xl27" x:num="" x:fmla="=SUM(H20:H23)">0</td> <td class="xl27" x:num="" x:fmla="=SUM(I20:I23)">0</td> <td class="xl27" x:num="" x:fmla="=SUM(J20:J23)">0</td> <td class="xl27" x:num="" x:fmla="=SUM(K20:K23)">0</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> </tbody></table>
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> </tr> </tbody></table>
I have extracted one of the Projects Revenue Streams but have not been successful in scheduling the expected Billing Flow in a Calendar Yr template according to the rules listed.
Ideal - to change the The Key Milestone dates for delays etc - that will automatically trigger when the project billing will occur.</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td colspan="8" class="xl25" style="height: 12.75pt;" height="17">Have spent time with date formulas etc but failed</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" colspan="3" style="height: 12.75pt;" height="17">Can somebody help me?</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td colspan="7" class="xl25" style="height: 12.75pt;" height="17">Thanks in advance
<table x:str="" style="border-collapse: collapse; width: 502pt;" width="673" border="0" cellpadding="0" cellspacing="0"><col style="width: 38pt;" width="51"> <col style="width: 44pt;" width="58"> <col style="width: 35pt;" span="12" width="47"> <tbody><tr style="height: 11.25pt;" height="15"> <td class="xl29" colspan="2" style="height: 11.25pt; width: 82pt;" width="109" height="15">1. Schedule of Charging Streams</td> <td class="xl31" style="width: 35pt;" width="47">Mth 1</td> <td class="xl31" style="width: 35pt;" width="47">Mth 2</td> <td class="xl31" style="width: 35pt;" width="47">Mth 3</td> <td class="xl31" style="width: 35pt;" width="47">Mth 4</td> <td class="xl31" style="width: 35pt;" width="47">Mth 5</td> <td class="xl31" style="width: 35pt;" width="47">Mth 6</td> <td class="xl31" style="width: 35pt;" width="47">Mth 7</td> <td class="xl31" style="width: 35pt;" width="47">Mth 8</td> <td class="xl31" style="width: 35pt;" width="47">Mth 9</td> <td class="xl31" style="width: 35pt;" width="47">Mth 10</td> <td class="xl31" style="width: 35pt;" width="47">Mth 11</td> <td class="xl31" style="width: 35pt;" width="47">Mth 12</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl32" colspan="3" style="height: 11.25pt;" height="15">Revenue Streams (£k)</td> <td class="xl31"> </td> <td class="xl31"> </td> <td class="xl31"> </td> <td class="xl31"> </td> <td class="xl31"> </td> <td class="xl31"> </td> <td class="xl31"> </td> <td class="xl31"> </td> <td class="xl31"> </td> <td class="xl31"> </td> <td class="xl31"> </td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl33" style="height: 11.25pt;" height="15">Charge Stream 1</td> <td class="xl30"> </td> <td class="xl34" x:num="518.41209880000008">518</td> <td class="xl34" x:num="1.9978475999999998">2</td> <td class="xl34" x:num="1.9978475999999998">2</td> <td class="xl34" x:num="1.9978475999999998">2</td> <td class="xl34" x:num="1.9978475999999998">2</td> <td class="xl34" x:num="1.9978475999999998">2</td> <td class="xl34" x:num="1.9978475999999998">2</td> <td class="xl34" x:num="1.9978475999999998">2</td> <td class="xl34" x:num="1.9978475999999998">2</td> <td class="xl34" x:num="1.9978475999999998">2</td> <td class="xl34" x:num="1.9978475999999998">2</td> <td class="xl34" x:num="1.9978475999999998">2</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl33" style="height: 11.25pt;" height="15">Charge Stream 2</td> <td class="xl30"> </td> <td class="xl34" x:num="150.14433526507062">150</td> <td class="xl34" x:num="">75</td> <td class="xl34" x:num="">75</td> <td class="xl34" x:num="">50</td> <td class="xl34" x:num="">50</td> <td class="xl34" x:num="">50</td> <td class="xl34" x:num="">50</td> <td class="xl34" x:num="">50</td> <td class="xl34" x:num="">50</td> <td class="xl34" x:num="">50</td> <td class="xl34" x:num="">50</td> <td class="xl34" x:num="">50</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl33" style="height: 11.25pt;" height="15">Charge Stream 3</td> <td class="xl30"> </td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> <td class="xl34" x:num="">100</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl33" style="height: 11.25pt;" height="15">Charge Stream 4</td> <td class="xl30"> </td> <td class="xl34" x:num="">0</td> <td class="xl34" x:num="">0</td> <td class="xl35" x:num="">300</td> <td class="xl34" x:num="">0</td> <td class="xl34" x:num="">0</td> <td class="xl35" x:num="">300</td> <td class="xl34" x:num="">0</td> <td class="xl34" x:num="">0</td> <td class="xl35" x:num="">300</td> <td class="xl34" x:num="">0</td> <td class="xl34" x:num="">0</td> <td class="xl34" x:num="">0</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl33" style="height: 12pt;" height="16"> </td> <td class="xl30"> </td> <td class="xl36" x:num="768.55643406507068" x:fmla="=SUM(C3:C6)">769</td> <td class="xl36" x:num="176.9978476" x:fmla="=SUM(D3:D6)">177</td> <td class="xl37" x:num="476.9978476" x:fmla="=SUM(E3:E6)">477</td> <td class="xl36" x:num="151.9978476" x:fmla="=SUM(F3:F6)">152</td> <td class="xl36" x:num="151.9978476" x:fmla="=SUM(G3:G6)">152</td> <td class="xl36" style="border-top: medium none;" x:num="451.9978476" x:fmla="=SUM(H3:H6)">452</td> <td class="xl36" x:num="151.9978476" x:fmla="=SUM(I3:I6)">152</td> <td class="xl36" x:num="151.9978476" x:fmla="=SUM(J3:J6)">152</td> <td class="xl36" style="border-top: medium none;" x:num="451.9978476" x:fmla="=SUM(K3:K6)">452</td> <td class="xl36" x:num="151.9978476" x:fmla="=SUM(L3:L6)">152</td> <td class="xl36" x:num="151.9978476" x:fmla="=SUM(M3:M6)">152</td> <td class="xl36" x:num="151.9978476" x:fmla="=SUM(N3:N6)">152</td> </tr> <tr style="height: 6.75pt;" height="9"> <td class="xl24" style="height: 6.75pt;" height="9">
</td> <td class="xl24">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl38" style="height: 11.25pt;" height="15">Billing Start Dates</td> <td class="xl25"> </td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl25" style="height: 11.25pt;" height="15">Milestone 1</td> <td class="xl39" x:num="39976">12-Jun-09</td> <td class="xl43" colspan="6" style="">these start dates can be changed for delays etc</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl25" style="height: 11.25pt;" height="15">Milestone 2</td> <td class="xl39" x:num="40068">12-Sep-09</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 6.75pt;" height="9"> <td class="xl24" style="height: 6.75pt;" height="9">
</td> <td class="xl24">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl40" style="height: 11.25pt;" height="15">Billing Criteria</td> <td class="xl24">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td colspan="14" class="xl41" style="height: 11.25pt;" height="15">1. Revenue Stream 1; billing commences 1 month in arrears from Milestone 1 achievement</td> </tr> <tr style="height: 11.25pt;" height="15"> <td colspan="14" class="xl41" style="height: 11.25pt;" height="15">2. Revenue Stream 2 & 3; billing commences 1 month in arrears from Milestone 2 dates</td> </tr> <tr style="height: 11.25pt;" height="15"> <td colspan="14" class="xl41" style="height: 11.25pt;" height="15">3. Revenue Stream 4; billing commences 4 month after Milestone 1 Date</td> </tr> <tr style="height: 6pt;" height="8"> <td class="xl41" style="height: 6pt;" height="8">
</td> <td class="xl41">
</td> <td class="xl42">
</td> <td class="xl42">
</td> <td class="xl42">
</td> <td class="xl42">
</td> <td class="xl42">
</td> <td class="xl42">
</td> <td class="xl42">
</td> <td class="xl42">
</td> <td class="xl42">
</td> <td class="xl42">
</td> <td class="xl42">
</td> <td class="xl42">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl26" style="height: 11.25pt;" height="15">Billing</td> <td class="xl24">
</td> <td class="xl27">Apr</td> <td class="xl27">May</td> <td class="xl27">Jun</td> <td class="xl27">Jul</td> <td class="xl27">Aug</td> <td class="xl27">Sep</td> <td class="xl27">Oct</td> <td class="xl27">Nov</td> <td class="xl27">Dec</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl24" style="height: 11.25pt;" height="15">
</td> <td class="xl24">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl33" style="height: 11.25pt;" height="15">Cash Stream 1</td> <td class="xl26"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl33" style="height: 11.25pt;" height="15">Cash Stream 2</td> <td class="xl26"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl33" style="height: 11.25pt;" height="15">Cash Stream 3</td> <td class="xl26"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl33" style="height: 11.25pt;" height="15">Cash Stream 4</td> <td class="xl26"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl24" style="height: 11.25pt;" height="15">
</td> <td class="xl24">
</td> <td class="xl27" x:num="" x:fmla="=SUM(C20:C23)">0</td> <td class="xl27" x:num="" x:fmla="=SUM(D20:D23)">0</td> <td class="xl27" x:num="" x:fmla="=SUM(E20:E23)">0</td> <td class="xl27" x:num="" x:fmla="=SUM(F20:F23)">0</td> <td class="xl27" x:num="" x:fmla="=SUM(G20:G23)">0</td> <td class="xl27" x:num="" x:fmla="=SUM(H20:H23)">0</td> <td class="xl27" x:num="" x:fmla="=SUM(I20:I23)">0</td> <td class="xl27" x:num="" x:fmla="=SUM(J20:J23)">0</td> <td class="xl27" x:num="" x:fmla="=SUM(K20:K23)">0</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> </tbody></table>
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> </tr> </tbody></table>
