This doesn't work properly until all periods/expenditures have been reported,
but will give you the numbers you want at that point in time.

Assuming first entry is in row 2, in cell F2 put this formula:
=A2/B$7
and 'fill' the formula down to row 7, format F2:F7 as % and you should get
these values using your example values:
15%, 19%, 16%, 15%, 19%, 15% for the percent of total period.

in cell G2 put this formula:
=C2/D$7
and again, fill down, and format as % and it will give these values for
percent of total expenditures:
17%, 19%, 13%, 11%, 20%, 20%

"Saintsman" wrote:

Can anyone help with a simpler way
Problem
Produce a set of cashflow data (cash spent) for a construction project -
which I can then benchmark against similar projects
Data (extract sample only)
A=period (days)
B=cumulative period (days)
C=spend for that period
D=cumulative spend
A B C D E
28 28 £641,727 £641,727 £22,919
34 62 £705,670 £1,347,397 £20,755
29 91 £491,425 £1,838,822 £16,946
28 119 £424,422 £2,263,244 £15,158
35 154 £773,256 £3,036,500 £22,093
28 182 £763,561 £3,800,061 £27,270

I need to end up with a set of %'s for the project. Period should be 5%;
10%; 15% etc ie
5% period; 3% cost
10% period; 5% cost
etc etc to 100% period; 100% cost

So, if 5% period = 36days the amount spent would be (28days@£22919) +
(8days@£20755)
The plan is to produce an S-curve which can be used for similar projects
Anybody able to help?

Saintsman