Hi,
How to use excel formula to spread the cost of the project knowing that its time vary from 12 months to 48 months and that it does not always follow an s curve? like the following list of data:
total cost of the project :$310135272.2

Month Percentage of Cost
1 0.6708%
2 19.0990%
3 0.0259%
4 0.0259%
5 0.0259%
6 0.0259%
7 1.1473%
8 0.6898%
9 3.5729%
10 2.9887%
11 2.9156%
12 2.3157%
13 28.4282%
14 28.2524%
15 1.0606%
16 1.3427%
17 1.2938%
18 6.1188%
so, if the number of months is 48 how can I spread those % keeping the same type of graph and the same cost of the projects ( slow progress)?
Thanks.