I’m looking to create a dynamic spreadsheet in MS Excel to double check P3 and do other work offline.

Specifically, I am looking to create a spreadsheet where I can enter in a total duration, remaining duration, a curve type and total number of units (manhours, euros, etc.) so that I may then be able to calculate the remaining values by period.

For example:

I have a ten month duration for manhours where durations are also in months. For this task I have allocated 100k manhours. I have chosen to model the based on a bell shaped distribution and have alocated the manhours as follows:

Month: qty
1: 1k
2: 3k
3: 8k
4: 15k
5: 23k
6: 23K
7: 15k
8: 8k
9: 3k
10: 1k

Halfway through the project, I progress the activity. I want to forecase the remaining distribution of 75K in accordance with the "trailing" end of the distribution curve which would yield the following values:

Month: qty
5: 23,630
6: 23,630
7: 15,411
8: 8,219
9: 3,081
10: 1,027

I can make these calculation manually, but as I stated above I’m looking for a MS Excel templete where I enter or select the appropriate variables and then view the result.

The curves that I am looking for a the standard curves in P3.

If anyone has any ideas, it would be greatly appreciated.

Cheers,