Need complex excel formula to plot revenue into each month given start and end dates

D

DVM

New Member
Joined
Jun 24, 2009
Messages
4
This may be an accounting function, but I am trying to do the following.

Let's say:
Contract is for $100,000
Start Date is 6/15/09
End Date is 9/30/09

I know I could subtract the dates and divide against $100,000 to get the daily revenue. I could then multiply the daily by the number of days in each month.

However, what I really want to do is get an Excel formula to calculate the monthly amount in the correct fields no matter what the start and end dates and no matter how many days in each month.

The answer in this case would be
Jun = $14,019
Jul = $28,972
Aug = $28.972
Sep = $28,037

Sept only has 30 days, whereas Jul and Aug have 31.

Thoughts?
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Sort by date Sort by votes
assuming your data is in A1:P10

<TABLE style="WIDTH: 737pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=981 border=0 x:str><COLGROUP><COL style="WIDTH: 42pt" width=56><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3626" width=85><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3669" width=86><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 3498" width=82><COL style="WIDTH: 42pt" span=12 width=56><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 42pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=56 height=18>
​
</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 64pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: silver" width=85>
A​
</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 65pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: silver" width=86>
B​
</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 62pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: silver" width=82>
C​
</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 42pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: silver" width=56>
D​
</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 42pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: silver" width=56>
E​
</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 42pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: silver" width=56>
F​
</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 42pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: silver" width=56>
G​
</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 42pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: silver" width=56>
H​
</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 42pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: silver" width=56>
I​
</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 42pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: silver" width=56>
J​
</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 42pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: silver" width=56>
K​
</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 42pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: silver" width=56>
L​
</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 42pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: silver" width=56>
M​
</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 42pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: silver" width=56>
N​
</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 42pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: silver" width=56>
O​
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: silver" height=18 x:num>
1​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">
Amount​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">
Start​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">
End​
</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39814">
Jan-09​
</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39845">
Feb-09​
</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39873">
Mar-09​
</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39904">
Apr-09​
</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39934">
May-09​
</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39965">
Jun-09​
</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39995">
Jul-09​
</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40026">
Aug-09​
</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40057">
Sep-09​
</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40087">
Oct-09​
</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40118">
Nov-09​
</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40148">
Dec-09​
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: silver" height=18 x:num>
2​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=RANDBETWEEN(100000,1000000)">
940068​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40173" x:fmla="=DATE(2009,RANDBETWEEN(1,12),RANDBETWEEN(1,31))">
26/12/2009​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40293" x:fmla="=C3+120">
25/04/2010​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D3>=F$2,$C3<=DATE(YEAR(F$2),MONTH(F$2)+1,0)),MIN($D3,DATE(YEAR(F$2),MONTH(F$2)+1,1))-MAX($C3,F$2),0)/($D3-$C3))*$B3">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D3>=G$2,$C3<=DATE(YEAR(G$2),MONTH(G$2)+1,0)),MIN($D3,DATE(YEAR(G$2),MONTH(G$2)+1,1))-MAX($C3,G$2),0)/($D3-$C3))*$B3">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D3>=H$2,$C3<=DATE(YEAR(H$2),MONTH(H$2)+1,0)),MIN($D3,DATE(YEAR(H$2),MONTH(H$2)+1,1))-MAX($C3,H$2),0)/($D3-$C3))*$B3">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D3>=I$2,$C3<=DATE(YEAR(I$2),MONTH(I$2)+1,0)),MIN($D3,DATE(YEAR(I$2),MONTH(I$2)+1,1))-MAX($C3,I$2),0)/($D3-$C3))*$B3">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D3>=J$2,$C3<=DATE(YEAR(J$2),MONTH(J$2)+1,0)),MIN($D3,DATE(YEAR(J$2),MONTH(J$2)+1,1))-MAX($C3,J$2),0)/($D3-$C3))*$B3">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D3>=K$2,$C3<=DATE(YEAR(K$2),MONTH(K$2)+1,0)),MIN($D3,DATE(YEAR(K$2),MONTH(K$2)+1,1))-MAX($C3,K$2),0)/($D3-$C3))*$B3">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D3>=L$2,$C3<=DATE(YEAR(L$2),MONTH(L$2)+1,0)),MIN($D3,DATE(YEAR(L$2),MONTH(L$2)+1,1))-MAX($C3,L$2),0)/($D3-$C3))*$B3">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D3>=M$2,$C3<=DATE(YEAR(M$2),MONTH(M$2)+1,0)),MIN($D3,DATE(YEAR(M$2),MONTH(M$2)+1,1))-MAX($C3,M$2),0)/($D3-$C3))*$B3">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D3>=N$2,$C3<=DATE(YEAR(N$2),MONTH(N$2)+1,0)),MIN($D3,DATE(YEAR(N$2),MONTH(N$2)+1,1))-MAX($C3,N$2),0)/($D3-$C3))*$B3">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D3>=O$2,$C3<=DATE(YEAR(O$2),MONTH(O$2)+1,0)),MIN($D3,DATE(YEAR(O$2),MONTH(O$2)+1,1))-MAX($C3,O$2),0)/($D3-$C3))*$B3">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="47003.4" x:fmla="=(IF(AND($D3>=P$2,$C3<=DATE(YEAR(P$2),MONTH(P$2)+1,0)),MIN($D3,DATE(YEAR(P$2),MONTH(P$2)+1,1))-MAX($C3,P$2),0)/($D3-$C3))*$B3">
47003​
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: silver" height=18 x:num>
3​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=RANDBETWEEN(100000,1000000)">
463138​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39841" x:fmla="=DATE(2009,RANDBETWEEN(1,12),RANDBETWEEN(1,31))">
28/01/2009​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39961" x:fmla="=C4+120">
28/05/2009​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="15437.933333333332" x:fmla="=(IF(AND($D4>=E$2,$C4<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D4,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C4,E$2),0)/($D4-$C4))*$B4">
15438​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="108065.53333333334" x:fmla="=(IF(AND($D4>=F$2,$C4<=DATE(YEAR(F$2),MONTH(F$2)+1,0)),MIN($D4,DATE(YEAR(F$2),MONTH(F$2)+1,1))-MAX($C4,F$2),0)/($D4-$C4))*$B4">
108066​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="119643.98333333335" x:fmla="=(IF(AND($D4>=G$2,$C4<=DATE(YEAR(G$2),MONTH(G$2)+1,0)),MIN($D4,DATE(YEAR(G$2),MONTH(G$2)+1,1))-MAX($C4,G$2),0)/($D4-$C4))*$B4">
119644​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="115784.5" x:fmla="=(IF(AND($D4>=H$2,$C4<=DATE(YEAR(H$2),MONTH(H$2)+1,0)),MIN($D4,DATE(YEAR(H$2),MONTH(H$2)+1,1))-MAX($C4,H$2),0)/($D4-$C4))*$B4">
115785​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="104206.05" x:fmla="=(IF(AND($D4>=I$2,$C4<=DATE(YEAR(I$2),MONTH(I$2)+1,0)),MIN($D4,DATE(YEAR(I$2),MONTH(I$2)+1,1))-MAX($C4,I$2),0)/($D4-$C4))*$B4">
104206​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D4>=J$2,$C4<=DATE(YEAR(J$2),MONTH(J$2)+1,0)),MIN($D4,DATE(YEAR(J$2),MONTH(J$2)+1,1))-MAX($C4,J$2),0)/($D4-$C4))*$B4">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D4>=K$2,$C4<=DATE(YEAR(K$2),MONTH(K$2)+1,0)),MIN($D4,DATE(YEAR(K$2),MONTH(K$2)+1,1))-MAX($C4,K$2),0)/($D4-$C4))*$B4">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D4>=L$2,$C4<=DATE(YEAR(L$2),MONTH(L$2)+1,0)),MIN($D4,DATE(YEAR(L$2),MONTH(L$2)+1,1))-MAX($C4,L$2),0)/($D4-$C4))*$B4">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D4>=M$2,$C4<=DATE(YEAR(M$2),MONTH(M$2)+1,0)),MIN($D4,DATE(YEAR(M$2),MONTH(M$2)+1,1))-MAX($C4,M$2),0)/($D4-$C4))*$B4">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D4>=N$2,$C4<=DATE(YEAR(N$2),MONTH(N$2)+1,0)),MIN($D4,DATE(YEAR(N$2),MONTH(N$2)+1,1))-MAX($C4,N$2),0)/($D4-$C4))*$B4">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D4>=O$2,$C4<=DATE(YEAR(O$2),MONTH(O$2)+1,0)),MIN($D4,DATE(YEAR(O$2),MONTH(O$2)+1,1))-MAX($C4,O$2),0)/($D4-$C4))*$B4">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D4>=P$2,$C4<=DATE(YEAR(P$2),MONTH(P$2)+1,0)),MIN($D4,DATE(YEAR(P$2),MONTH(P$2)+1,1))-MAX($C4,P$2),0)/($D4-$C4))*$B4">
0​
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: silver" height=18 x:num>
4​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=RANDBETWEEN(100000,1000000)">
275349​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39900" x:fmla="=DATE(2009,RANDBETWEEN(1,12),RANDBETWEEN(1,31))">
28/03/2009​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40020" x:fmla="=C5+120">
26/07/2009​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D5>=E$2,$C5<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D5,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C5,E$2),0)/($D5-$C5))*$B5">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D5>=F$2,$C5<=DATE(YEAR(F$2),MONTH(F$2)+1,0)),MIN($D5,DATE(YEAR(F$2),MONTH(F$2)+1,1))-MAX($C5,F$2),0)/($D5-$C5))*$B5">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="9178.3" x:fmla="=(IF(AND($D5>=G$2,$C5<=DATE(YEAR(G$2),MONTH(G$2)+1,0)),MIN($D5,DATE(YEAR(G$2),MONTH(G$2)+1,1))-MAX($C5,G$2),0)/($D5-$C5))*$B5">
9178​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="68837.25" x:fmla="=(IF(AND($D5>=H$2,$C5<=DATE(YEAR(H$2),MONTH(H$2)+1,0)),MIN($D5,DATE(YEAR(H$2),MONTH(H$2)+1,1))-MAX($C5,H$2),0)/($D5-$C5))*$B5">
68837​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="71131.825000000012" x:fmla="=(IF(AND($D5>=I$2,$C5<=DATE(YEAR(I$2),MONTH(I$2)+1,0)),MIN($D5,DATE(YEAR(I$2),MONTH(I$2)+1,1))-MAX($C5,I$2),0)/($D5-$C5))*$B5">
71132​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="68837.25" x:fmla="=(IF(AND($D5>=J$2,$C5<=DATE(YEAR(J$2),MONTH(J$2)+1,0)),MIN($D5,DATE(YEAR(J$2),MONTH(J$2)+1,1))-MAX($C5,J$2),0)/($D5-$C5))*$B5">
68837​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="57364.375" x:fmla="=(IF(AND($D5>=K$2,$C5<=DATE(YEAR(K$2),MONTH(K$2)+1,0)),MIN($D5,DATE(YEAR(K$2),MONTH(K$2)+1,1))-MAX($C5,K$2),0)/($D5-$C5))*$B5">
57364​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D5>=L$2,$C5<=DATE(YEAR(L$2),MONTH(L$2)+1,0)),MIN($D5,DATE(YEAR(L$2),MONTH(L$2)+1,1))-MAX($C5,L$2),0)/($D5-$C5))*$B5">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D5>=M$2,$C5<=DATE(YEAR(M$2),MONTH(M$2)+1,0)),MIN($D5,DATE(YEAR(M$2),MONTH(M$2)+1,1))-MAX($C5,M$2),0)/($D5-$C5))*$B5">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D5>=N$2,$C5<=DATE(YEAR(N$2),MONTH(N$2)+1,0)),MIN($D5,DATE(YEAR(N$2),MONTH(N$2)+1,1))-MAX($C5,N$2),0)/($D5-$C5))*$B5">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D5>=O$2,$C5<=DATE(YEAR(O$2),MONTH(O$2)+1,0)),MIN($D5,DATE(YEAR(O$2),MONTH(O$2)+1,1))-MAX($C5,O$2),0)/($D5-$C5))*$B5">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D5>=P$2,$C5<=DATE(YEAR(P$2),MONTH(P$2)+1,0)),MIN($D5,DATE(YEAR(P$2),MONTH(P$2)+1,1))-MAX($C5,P$2),0)/($D5-$C5))*$B5">
0​
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: silver" height=18 x:num>
5​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=RANDBETWEEN(100000,1000000)">
644101​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40093" x:fmla="=DATE(2009,RANDBETWEEN(1,12),RANDBETWEEN(1,31))">
07/10/2009​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40213" x:fmla="=C6+120">
04/02/2010​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D6>=E$2,$C6<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D6,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C6,E$2),0)/($D6-$C6))*$B6">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D6>=F$2,$C6<=DATE(YEAR(F$2),MONTH(F$2)+1,0)),MIN($D6,DATE(YEAR(F$2),MONTH(F$2)+1,1))-MAX($C6,F$2),0)/($D6-$C6))*$B6">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D6>=G$2,$C6<=DATE(YEAR(G$2),MONTH(G$2)+1,0)),MIN($D6,DATE(YEAR(G$2),MONTH(G$2)+1,1))-MAX($C6,G$2),0)/($D6-$C6))*$B6">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D6>=H$2,$C6<=DATE(YEAR(H$2),MONTH(H$2)+1,0)),MIN($D6,DATE(YEAR(H$2),MONTH(H$2)+1,1))-MAX($C6,H$2),0)/($D6-$C6))*$B6">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D6>=I$2,$C6<=DATE(YEAR(I$2),MONTH(I$2)+1,0)),MIN($D6,DATE(YEAR(I$2),MONTH(I$2)+1,1))-MAX($C6,I$2),0)/($D6-$C6))*$B6">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D6>=J$2,$C6<=DATE(YEAR(J$2),MONTH(J$2)+1,0)),MIN($D6,DATE(YEAR(J$2),MONTH(J$2)+1,1))-MAX($C6,J$2),0)/($D6-$C6))*$B6">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D6>=K$2,$C6<=DATE(YEAR(K$2),MONTH(K$2)+1,0)),MIN($D6,DATE(YEAR(K$2),MONTH(K$2)+1,1))-MAX($C6,K$2),0)/($D6-$C6))*$B6">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D6>=L$2,$C6<=DATE(YEAR(L$2),MONTH(L$2)+1,0)),MIN($D6,DATE(YEAR(L$2),MONTH(L$2)+1,1))-MAX($C6,L$2),0)/($D6-$C6))*$B6">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D6>=M$2,$C6<=DATE(YEAR(M$2),MONTH(M$2)+1,0)),MIN($D6,DATE(YEAR(M$2),MONTH(M$2)+1,1))-MAX($C6,M$2),0)/($D6-$C6))*$B6">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="134187.70833333334" x:fmla="=(IF(AND($D6>=N$2,$C6<=DATE(YEAR(N$2),MONTH(N$2)+1,0)),MIN($D6,DATE(YEAR(N$2),MONTH(N$2)+1,1))-MAX($C6,N$2),0)/($D6-$C6))*$B6">
134188​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="161025.25" x:fmla="=(IF(AND($D6>=O$2,$C6<=DATE(YEAR(O$2),MONTH(O$2)+1,0)),MIN($D6,DATE(YEAR(O$2),MONTH(O$2)+1,1))-MAX($C6,O$2),0)/($D6-$C6))*$B6">
161025​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="166392.75833333336" x:fmla="=(IF(AND($D6>=P$2,$C6<=DATE(YEAR(P$2),MONTH(P$2)+1,0)),MIN($D6,DATE(YEAR(P$2),MONTH(P$2)+1,1))-MAX($C6,P$2),0)/($D6-$C6))*$B6">
166393​
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: silver" height=18 x:num>
6​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=RANDBETWEEN(100000,1000000)">
409121​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39922" x:fmla="=DATE(2009,RANDBETWEEN(1,12),RANDBETWEEN(1,31))">
19/04/2009​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40042" x:fmla="=C7+120">
17/08/2009​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D7>=E$2,$C7<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D7,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C7,E$2),0)/($D7-$C7))*$B7">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D7>=F$2,$C7<=DATE(YEAR(F$2),MONTH(F$2)+1,0)),MIN($D7,DATE(YEAR(F$2),MONTH(F$2)+1,1))-MAX($C7,F$2),0)/($D7-$C7))*$B7">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D7>=G$2,$C7<=DATE(YEAR(G$2),MONTH(G$2)+1,0)),MIN($D7,DATE(YEAR(G$2),MONTH(G$2)+1,1))-MAX($C7,G$2),0)/($D7-$C7))*$B7">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40912.1" x:fmla="=(IF(AND($D7>=H$2,$C7<=DATE(YEAR(H$2),MONTH(H$2)+1,0)),MIN($D7,DATE(YEAR(H$2),MONTH(H$2)+1,1))-MAX($C7,H$2),0)/($D7-$C7))*$B7">
40912​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="105689.59166666667" x:fmla="=(IF(AND($D7>=I$2,$C7<=DATE(YEAR(I$2),MONTH(I$2)+1,0)),MIN($D7,DATE(YEAR(I$2),MONTH(I$2)+1,1))-MAX($C7,I$2),0)/($D7-$C7))*$B7">
105690​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="102280.25" x:fmla="=(IF(AND($D7>=J$2,$C7<=DATE(YEAR(J$2),MONTH(J$2)+1,0)),MIN($D7,DATE(YEAR(J$2),MONTH(J$2)+1,1))-MAX($C7,J$2),0)/($D7-$C7))*$B7">
102280​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="105689.59166666667" x:fmla="=(IF(AND($D7>=K$2,$C7<=DATE(YEAR(K$2),MONTH(K$2)+1,0)),MIN($D7,DATE(YEAR(K$2),MONTH(K$2)+1,1))-MAX($C7,K$2),0)/($D7-$C7))*$B7">
105690​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="54549.466666666667" x:fmla="=(IF(AND($D7>=L$2,$C7<=DATE(YEAR(L$2),MONTH(L$2)+1,0)),MIN($D7,DATE(YEAR(L$2),MONTH(L$2)+1,1))-MAX($C7,L$2),0)/($D7-$C7))*$B7">
54549​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D7>=M$2,$C7<=DATE(YEAR(M$2),MONTH(M$2)+1,0)),MIN($D7,DATE(YEAR(M$2),MONTH(M$2)+1,1))-MAX($C7,M$2),0)/($D7-$C7))*$B7">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D7>=N$2,$C7<=DATE(YEAR(N$2),MONTH(N$2)+1,0)),MIN($D7,DATE(YEAR(N$2),MONTH(N$2)+1,1))-MAX($C7,N$2),0)/($D7-$C7))*$B7">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D7>=O$2,$C7<=DATE(YEAR(O$2),MONTH(O$2)+1,0)),MIN($D7,DATE(YEAR(O$2),MONTH(O$2)+1,1))-MAX($C7,O$2),0)/($D7-$C7))*$B7">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D7>=P$2,$C7<=DATE(YEAR(P$2),MONTH(P$2)+1,0)),MIN($D7,DATE(YEAR(P$2),MONTH(P$2)+1,1))-MAX($C7,P$2),0)/($D7-$C7))*$B7">
0​
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: silver" height=18 x:num>
7​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=RANDBETWEEN(100000,1000000)">
171716​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40117" x:fmla="=DATE(2009,RANDBETWEEN(1,12),RANDBETWEEN(1,31))">
31/10/2009​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40237" x:fmla="=C8+120">
28/02/2010​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D8>=E$2,$C8<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D8,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C8,E$2),0)/($D8-$C8))*$B8">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D8>=F$2,$C8<=DATE(YEAR(F$2),MONTH(F$2)+1,0)),MIN($D8,DATE(YEAR(F$2),MONTH(F$2)+1,1))-MAX($C8,F$2),0)/($D8-$C8))*$B8">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D8>=G$2,$C8<=DATE(YEAR(G$2),MONTH(G$2)+1,0)),MIN($D8,DATE(YEAR(G$2),MONTH(G$2)+1,1))-MAX($C8,G$2),0)/($D8-$C8))*$B8">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D8>=H$2,$C8<=DATE(YEAR(H$2),MONTH(H$2)+1,0)),MIN($D8,DATE(YEAR(H$2),MONTH(H$2)+1,1))-MAX($C8,H$2),0)/($D8-$C8))*$B8">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D8>=I$2,$C8<=DATE(YEAR(I$2),MONTH(I$2)+1,0)),MIN($D8,DATE(YEAR(I$2),MONTH(I$2)+1,1))-MAX($C8,I$2),0)/($D8-$C8))*$B8">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D8>=J$2,$C8<=DATE(YEAR(J$2),MONTH(J$2)+1,0)),MIN($D8,DATE(YEAR(J$2),MONTH(J$2)+1,1))-MAX($C8,J$2),0)/($D8-$C8))*$B8">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D8>=K$2,$C8<=DATE(YEAR(K$2),MONTH(K$2)+1,0)),MIN($D8,DATE(YEAR(K$2),MONTH(K$2)+1,1))-MAX($C8,K$2),0)/($D8-$C8))*$B8">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D8>=L$2,$C8<=DATE(YEAR(L$2),MONTH(L$2)+1,0)),MIN($D8,DATE(YEAR(L$2),MONTH(L$2)+1,1))-MAX($C8,L$2),0)/($D8-$C8))*$B8">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D8>=M$2,$C8<=DATE(YEAR(M$2),MONTH(M$2)+1,0)),MIN($D8,DATE(YEAR(M$2),MONTH(M$2)+1,1))-MAX($C8,M$2),0)/($D8-$C8))*$B8">
0​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="1430.9666666666667" x:fmla="=(IF(AND($D8>=N$2,$C8<=DATE(YEAR(N$2),MONTH(N$2)+1,0)),MIN($D8,DATE(YEAR(N$2),MONTH(N$2)+1,1))-MAX($C8,N$2),0)/($D8-$C8))*$B8">
1431​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla="=(IF(AND($D8>=O$2,$C8<=DATE(YEAR(O$2),MONTH(O$2)+1,0)),MIN($D8,DATE(YEAR(O$2),MONTH(O$2)+1,1))-MAX($C8,O$2),0)/($D8-$C8))*$B8">
42929​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="44359.966666666674" x:fmla="=(IF(AND($D8>=P$2,$C8<=DATE(YEAR(P$2),MONTH(P$2)+1,0)),MIN($D8,DATE(YEAR(P$2),MONTH(P$2)+1,1))-MAX($C8,P$2),0)/($D8-$C8))*$B8">
44360​
</TD></TR></TBODY></TABLE>


D2

=(IF(AND($C2>=D$1,$B2<=DATE(YEAR(D$1),MONTH(D$1)+1,0)),MIN($C2,DATE(YEAR(D$1),MONTH(D$1)+1,1))-MAX($B2,D$1),0)/($C2-$B2))*$A2

copied down and across
 
Upvote 0
One other question. I know this may be a bit much to ask, but what if you were trying to do by week or day?

By week
Jul 1
Jul 8
Jul 15

or

By day
Jul 1
Jul 2
Jul 3
 
Upvote 0
  • for Weeks
<TABLE style="WIDTH: 764pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1015 border=0 x:str><COLGROUP><COL style="WIDTH: 42pt" span=2 width=56><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 3285" span=2 width=77><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2474" span=2 width=58><COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2773" span=3 width=65><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2517" span=2 width=59><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2816" span=2 width=66><COL style="WIDTH: 45pt; mso-width-source: userset; mso-width-alt: 2560" span=2 width=60><COL style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2901" width=68><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: white" width=56 height=20>
​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=56>
A​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=77>
B​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=77>
C​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=58>
D​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=58>
E​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 49pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=65>
F​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 49pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=65>
G​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 49pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=65>
H​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=59>
I​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=59>
J​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 50pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=66>
K​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 50pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=66>
L​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 45pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=60>
M​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 45pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=60>
N​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 51pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=68>
O​
</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: silver" width=56 height=20 x:num u1:num>
1​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=56>
Amount​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77>
Start​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77>
End​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=58 x:num="39814" u1:num="39965">
1-Jan-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=58 x:num="39821" u1:num="39995">
8-Jan-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 49pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=65 x:num="39828" u1:num="39995">
15-Jan-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 49pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=65 x:num="39835" u1:num="39995">
22-Jan-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 49pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=65 x:num="39842" u1:num="39995">
29-Jan-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=59 x:num="39845" u1:num="39995">
1-Feb-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=59 x:num="39852" u1:num="39995">
8-Feb-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 50pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=66 x:num="39859" u1:num="39995">
15-Feb-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 50pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=66 x:num="39866" u1:num="39995">
22-Feb-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 45pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=60 x:num="39873" u1:num="39995">
1-Mar-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 45pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=60 x:num="39880" u1:num="39995">
8-Mar-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 51pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=68 x:num="39887" u1:num="39995">
15-Mar-09​
</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: silver" width=56 height=20 x:num u1:num>
2​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=56 x:num u1:num u1:fmla="=RANDBETWEEN(100000,1000000)">
940068​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="39828" u1:num="40173" u1:fmla="=DATE(2009,RANDBETWEEN(1,12),RANDBETWEEN(1,31))">
15/01/2009​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="39842" u1:num="40293" u1:fmla="=C3+120">
29/01/2009​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="438698.4">
438698​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="438698.4">
438698​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="62671.199999999997">
62671​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: silver" width=56 height=20 x:num u1:num>
3​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=56 x:num u1:num u1:fmla="=RANDBETWEEN(100000,1000000)">
463138​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="39841" u1:num="39841" u1:fmla="=DATE(2009,RANDBETWEEN(1,12),RANDBETWEEN(1,31))">
28/01/2009​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="39961" u1:num="39961" u1:fmla="=C4+120">
28/05/2009​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="3827.5867768595044">
3828​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="11482.760330578512">
11483​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="26793.10743801653">
26793​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="26793.10743801653">
26793​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="26793.10743801653">
26793​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="26793.10743801653">
26793​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="26793.10743801653">
26793​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="26793.10743801653">
26793​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="26793.10743801653">
26793​
</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: silver" width=56 height=20 x:num u1:num>
4​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=56 x:num u1:num u1:fmla="=RANDBETWEEN(100000,1000000)">
275349​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="39535" u1:num="39900" u1:fmla="=DATE(2009,RANDBETWEEN(1,12),RANDBETWEEN(1,31))">
28/03/2008​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="39979" u1:num="40020" u1:fmla="=C5+120">
15/06/2009​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="4331.3325842696631">
4331​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="4331.3325842696631">
4331​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="4331.3325842696631">
4331​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="4331.3325842696631">
4331​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="1856.2853932584271">
1856​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="4331.3325842696631">
4331​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="4331.3325842696631">
4331​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="4331.3325842696631">
4331​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="4331.3325842696631">
4331​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="4331.3325842696631">
4331​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="4331.3325842696631">
4331​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="4331.3325842696631">
4331​
</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: silver" width=56 height=20 x:num u1:num>
5​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=56 x:num u1:num u1:fmla="=RANDBETWEEN(100000,1000000)">
644101​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="39820" u1:num="40093" u1:fmla="=DATE(2009,RANDBETWEEN(1,12),RANDBETWEEN(1,31))">
07/01/2009​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="39848" u1:num="40213" u1:fmla="=C6+120">
04/02/2009​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="22210.379310344826">
22210​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="155472.6551724138">
155473​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="155472.6551724138">
155473​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="155472.6551724138">
155473​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="66631.137931034478">
66631​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="88841.517241379304">
88842​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: silver" width=56 height=20 x:num u1:num>
6​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=56 x:num u1:num u1:fmla="=RANDBETWEEN(100000,1000000)">
409121​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="39922" u1:num="39922" u1:fmla="=DATE(2009,RANDBETWEEN(1,12),RANDBETWEEN(1,31))">
19/04/2009​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="39950" u1:num="40042" u1:fmla="=C7+120">
17/05/2009​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: silver" width=56 height=20 x:num u1:num>
7​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=56 x:num u1:num u1:fmla="=RANDBETWEEN(100000,1000000)">
171716​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="39844" u1:num="40117" u1:fmla="=DATE(2009,RANDBETWEEN(1,12),RANDBETWEEN(1,31))">
31/01/2009​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="39872" u1:num="40237" u1:fmla="=C8+120">
28/02/2009​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="5921.2413793103451">
5921​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="41448.689655172413">
41449​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="41448.689655172413">
41449​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="41448.689655172413">
41449​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="41448.689655172413">
41449​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD></TR></TBODY></TABLE>

E1

=MIN(D1+7,EOMONTH(D1,0)+1)

and copied right

D2

=IF(OR(AND(D$1>=$B2,D$1<=$C2),AND(D$1<=$B2,MIN(D$1+6,EOMONTH(D$1,0))>=$B2)),(MIN(EOMONTH(D$1,0),D$1+6,$C2)-MAX(D$1,$B2)+1)/($C2-$B2+1))*$A2

copied down and across


  • for Days
<TABLE style="WIDTH: 797pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1058 border=0 x:str><COLGROUP><COL style="WIDTH: 42pt" span=2 width=56><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 3285" span=2 width=77><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2816" width=66><COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2773" width=65><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2816" span=3 width=66><COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2773" span=2 width=65><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2858" span=2 width=67><COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2773" span=2 width=65><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2944" width=69><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: white" width=56 height=20>
​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=56>
A​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=77>
B​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=77>
C​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 50pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=66>
D​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 49pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=65>
E​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 50pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=66>
F​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 50pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=66>
G​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 50pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=66>
H​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 49pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=65>
I​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 49pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=65>
J​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 50pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=67>
K​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 50pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=67>
L​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 49pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=65>
M​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 49pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=65>
N​
</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 52pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=69>
O​
</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: silver" width=56 height=20 x:num u1:num>
1​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=56>
Amount​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77>
Start​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77>
End​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 50pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=66 x:num="39833" u1:num="39965">
20-Jan-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 49pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=65 x:num="39834" u1:num="39995">
21-Jan-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 50pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=66 x:num="39835" u1:num="40026">
22-Jan-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 50pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=66 x:num="39836" u1:num="40057">
23-Jan-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 50pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=66 x:num="39837" u1:num="40087">
24-Jan-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 49pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=65 x:num="39838" u1:num="40118">
25-Jan-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 49pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=65 x:num="39839" u1:num="40148">
26-Jan-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 50pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="39840">
27-Jan-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 50pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="39841">
28-Jan-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 49pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=65 x:num="39842">
29-Jan-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 49pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=65 x:num="39843">
30-Jan-09​
</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 52pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=69 x:num="39844">
31-Jan-09​
</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: silver" width=56 height=20 x:num u1:num>
2​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=56 x:num u1:num u1:fmla="=RANDBETWEEN(100000,1000000)">
940068​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="39833" u1:num="40173" u1:fmla="=DATE(2009,RANDBETWEEN(1,12),RANDBETWEEN(1,31))">
20/01/2009​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="39844" u1:num="40293" u1:fmla="=C3+120">
31/01/2009​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
78339​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
78339​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
78339​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
78339​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
78339​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
78339​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
78339​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
78339​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
78339​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
78339​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
78339​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
78339​
</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: silver" width=56 height=20 x:num u1:num>
3​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=56 x:num u1:num u1:fmla="=RANDBETWEEN(100000,1000000)">
463138​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="39841" u1:num="39841" u1:fmla="=DATE(2009,RANDBETWEEN(1,12),RANDBETWEEN(1,31))">
28/01/2009​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="39961" u1:num="39961" u1:fmla="=C4+120">
28/05/2009​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="3827.586776859504" u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
3828​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="3827.586776859504" u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
3828​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="3827.586776859504" u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
3828​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num="3827.586776859504" u1:num u1:fmla="=(IF(AND($D3>=E$2,$C3<=DATE(YEAR(E$2),MONTH(E$2)+1,0)),MIN($D3,DATE(YEAR(E$2),MONTH(E$2)+1,1))-MAX($C3,E$2),0)/($D3-$C3))*$B3">
3828​
</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: silver" width=56 height=20 x:num u1:num>
4​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=56 x:num u1:num u1:fmla="=RANDBETWEEN(100000,1000000)">
275349​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="39900" u1:num="39900" u1:fmla="=DATE(2009,RANDBETWEEN(1,12),RANDBETWEEN(1,31))">
28/03/2009​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="40020" u1:num="40020" u1:fmla="=C5+120">
26/07/2009​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: silver" width=56 height=20 x:num u1:num>
5​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=56 x:num u1:num u1:fmla="=RANDBETWEEN(100000,1000000)">
644101​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="40093" u1:num="40093" u1:fmla="=DATE(2009,RANDBETWEEN(1,12),RANDBETWEEN(1,31))">
07/10/2009​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="40213" u1:num="40213" u1:fmla="=C6+120">
04/02/2010​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: silver" width=56 height=20 x:num u1:num>
6​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=56 x:num u1:num u1:fmla="=RANDBETWEEN(100000,1000000)">
409121​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="39922" u1:num="39922" u1:fmla="=DATE(2009,RANDBETWEEN(1,12),RANDBETWEEN(1,31))">
19/04/2009​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="40042" u1:num="40042" u1:fmla="=C7+120">
17/08/2009​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: silver" width=56 height=20 x:num u1:num>
7​
</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=56 x:num u1:num u1:fmla="=RANDBETWEEN(100000,1000000)">
171716​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="40117" u1:num="40117" u1:fmla="=DATE(2009,RANDBETWEEN(1,12),RANDBETWEEN(1,31))">
31/10/2009​
</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 58pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=77 x:num="40237" u1:num="40237" u1:fmla="=C8+120">
28/02/2010​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white; mso-ignore: style" x:num>
0​
</TD></TR></TBODY></TABLE>


D2

=IF(AND($B2<=D$1,$C2>=D$1),$A2/($C2-$B2+1),0)

copied down and across
 
Upvote 0
sanrv1f said:
  • for Weeks
A​
B​
C​
D​
E​
F​
G​
H​
I​
J​
K​
L​
M​
N​
O​
1​
Amount​
Start​
End​
1-Jan-09​
8-Jan-09​
15-Jan-09​
22-Jan-09​
29-Jan-09​
1-Feb-09​
8-Feb-09​
15-Feb-09​
22-Feb-09​
1-Mar-09​
8-Mar-09​
15-Mar-09​
2​
940068​
15/01/2009​
29/01/2009​
0​
0​
438698​
438698​
62671​
0​
0​
0​
0​
0​
0​
0​
3​
463138​
28/01/2009​
28/05/2009​
0​
0​
0​
3828​
11483​
26793​
26793​
26793​
26793​
26793​
26793​
26793​
4​
275349​
28/03/2008​
15/06/2009​
4331​
4331​
4331​
4331​
1856​
4331​
4331​
4331​
4331​
4331​
4331​
4331​
5​
644101​
07/01/2009​
04/02/2009​
22210​
155473​
155473​
155473​
66631​
88842​
0​
0​
0​
0​
0​
0​
6​
409121​
19/04/2009​
17/05/2009​
0​
0​
0​
0​
0​
0​
0​
0​
0​
0​
0​
0​
7​
171716​
31/01/2009​
28/02/2009​
0​
0​
0​
0​
5921​
41449​
41449​
41449​
41449​
0​
0​
0​

<colgroup><col style="WIDTH: 42pt" span="2" width="56"><col style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 3285" span="2" width="77"><col style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2474" span="2" width="58"><col style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2773" span="3" width="65"><col style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2517" span="2" width="59"><col style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2816" span="2" width="66"><col style="WIDTH: 45pt; mso-width-source: userset; mso-width-alt: 2560" span="2" width="60"><col style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2901" width="68"></colgroup><tbody>
</tbody>


E1

=MIN(D1+7,EOMONTH(D1,0)+1)

and copied right

D2

=IF(OR(AND(D$1>=$B2,D$1<=$C2),AND(D$1<=$B2,MIN(D$1+6,EOMONTH(D$1,0))>=$B2)),(MIN(EOMONTH(D$1,0),D$1+6,$C2)-MAX(D$1,$B2)+1)/($C2-$B2+1))*$A2

copied down and across


  • for Days
A​
B​
C​
D​
E​
F​
G​
H​
I​
J​
K​
L​
M​
N​
O​
1​
Amount​
Start​
End​
20-Jan-09​
21-Jan-09​
22-Jan-09​
23-Jan-09​
24-Jan-09​
25-Jan-09​
26-Jan-09​
27-Jan-09​
28-Jan-09​
29-Jan-09​
30-Jan-09​
31-Jan-09​
2​
940068​
20/01/2009​
31/01/2009​
78339​
78339​
78339​
78339​
78339​
78339​
78339​
78339​
78339​
78339​
78339​
78339​
3​
463138​
28/01/2009​
28/05/2009​
0​
0​
0​
0​
0​
0​
0​
0​
3828​
3828​
3828​
3828​
4​
275349​
28/03/2009​
26/07/2009​
0​
0​
0​
0​
0​
0​
0​
0​
0​
0​
0​
0​
5​
644101​
07/10/2009​
04/02/2010​
0​
0​
0​
0​
0​
0​
0​
0​
0​
0​
0​
0​
6​
409121​
19/04/2009​
17/08/2009​
0​
0​
0​
0​
0​
0​
0​
0​
0​
0​
0​
0​
7​
171716​
31/10/2009​
28/02/2010​
0​
0​
0​
0​
0​
0​
0​
0​
0​
0​
0​
0​

<colgroup><col style="WIDTH: 42pt" span="2" width="56"><col style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 3285" span="2" width="77"><col style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2816" width="66"><col style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2773" width="65"><col style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2816" span="3" width="66"><col style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2773" span="2" width="65"><col style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2858" span="2" width="67"><col style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2773" span="2" width="65"><col style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2944" width="69"></colgroup><tbody>
</tbody>



D2

=IF(AND($B2<=D$1,$C2>=D$1),$A2/($C2-$B2+1),0)

copied down and across
Click to expand...

Hi, I'm trying to do something very similar to this, however the "weeks" I want to split the revenue over are not traditional calendar weeks of the year, and are rather just D1+7 days.
I'm struggling on how to get the D2 formula to work for this scenario (given its currently contains the EOMONTH formula which I think is driving back to traditional 52 week period).

Any help with this?
Much appreciated.

Sarah
 
Upvote 0
I'm having an issue with spliting revenue across months. I want to be able to split the revenue evenly over whole months, irrespective of whether they have 28, 30 or 31 days. I want to create the additional rules:

IF number of days in month <=5 recognise 0
IF number of days in month <20 recognise half a month
Otherwise recognise a whole month

I've tried the following formula and whilst it works most of the time when the month starts and or ends with february and on some other random occasions, the SUM value of the recognised amounts is not equal to the value being split.

=(IF(AND($C2>=D$1,$B2<=DATE(YEAR(D$1),MONTH(D$1)+1,0)),IF(MIN($C2,DATE(YEAR(D$1),MONTH(D$1)+1,1))-MAX($B2,D$1)<=5,0,IF(MIN($C2,DATE(YEAR(D$1),MONTH(D$1)+1,1))-MAX($B2,D$1)<=20,15,30)/(DAYS360($B2,$C2,TRUE)+1)*$A2),0))

Please see attached file:


Value
To
From
Jan-13
Feb-13
Mar-13
Apr-13
May-13
Jun-13
Jul-13
Aug-13
Sep-13
Oct-13
Nov-13
Dec-13
Jan-14
Feb-14
Rec
160.00
01/01/2013
31/03/2013
52.17
52.17
52.17
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
-3.48
628.20
04/01/2013
03/01/2014
52.06
52.06
52.06
52.06
52.06
52.06
52.06
52.06
52.06
52.06
52.06
52.06
0.00
0.00
-3.47
101.25
10/01/2013
09/01/2014
4.20
8.39
8.39
8.39
8.39
8.39
8.39
8.39
8.39
8.39
8.39
8.39
4.20
0.00
-0.56
199.06
11/01/2013
10/01/2014
8.25
16.50
16.50
16.50
16.50
16.50
16.50
16.50
16.50
16.50
16.50
16.50
8.25
0.00
-1.10
471.00
17/01/2013
16/01/2014
19.52
39.03
39.03
39.03
39.03
39.03
39.03
39.03
39.03
39.03
39.03
39.03
19.52
0.00
-2.60
628.20
16/01/2013
15/01/2014
26.03
52.06
52.06
52.06
52.06
52.06
52.06
52.06
52.06
52.06
52.06
52.06
26.03
0.00
-3.47
628.20
22/01/2013
21/01/2014
26.03
52.06
52.06
52.06
52.06
52.06
52.06
52.06
52.06
52.06
52.06
52.06
26.03
0.00
-3.47

<tbody>
</tbody>

<tbody>
</tbody>
 
Last edited:
Upvote 0
Hi - this formula really helps me but there is a slight problem when the money falls on the same day i.e. if the start date and end date are the same day it returns a zero and then I get a #DIV/0!
Is there any way you can adjust the formula to cater for a scenario where the money is recognized in one full day?

I'm referring to the first post in this thread using the following formula:

=(IF(AND($C2>=D$1,$B2<=DATE(YEAR(D$1),MONTH(D$1)+1,0)),MIN($C2,DATE(YEAR(D$1),MONTH(D$1)+1,1))-MAX($B2,D$1),0)/($C2-$B2))*$A2

Desperately need your help on this...thanks.
 
Last edited:
Upvote 0
Mich35elle said:
I know this may be a bit much to ask, but what if you were trying to do by week or day?
1.jpg
2.jpg
3.jpg
4.jpg
Click to expand...

My reporting has to be by month unfortunately...
 
Upvote 0
You must log in or register to reply here.

Similar threads

W
  • Solved
Validate month based on contract dates & Calculate number of weeks in that month to calculate hours booked per month
2
Replies
16
Views
1K
phiero21
P
vinzent
  • Question
Formula to get the 4th workday before end of month
Replies
8
Views
143
Tetra201
Tetra201
F
  • Solved
Date Range Period over Period over years
Replies
7
Views
470
flashgordie
F
B
  • Question
Copying data from a year tab and pasting into month tabs
Replies
2
Views
184
B-radK
B
J
  • Question
How to allocate project hours between specific dates using specific daily hour burn rates and including awkward calendar month start/end+holidays
2
Replies
11
Views
984
felixstraube
F

Forum statistics

Threads
1,214,951
Messages
6,122,446
Members
449,083
Latest member
Ava19

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top