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