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,
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,