Forum Discussion
Resource Loading for project pipeline
We have a portfolio of proposals and projects in different stages: - some of these are under bidding (with various degrees of certainty that these will be awarded) - some of these are awarded and a...
Thank you John for the reply.
I'm using stand-alone Project.
I would like to create a forecast man-power histogram similar to the attached with the following features:
1. Unlike the histogram in the spreadsheet attached, each resource would be multiplied by probability of winning bid for every time period.
2. Once the first step is done, I would also like to see an individual manpower cumulative loading across multiple projects. To see if this exceeds above a certain threshold (say 100).
Thank you!
Cristian
Cristian,
In order to get that type of graphic, you will have to export timescaled Project data to Excel and then manipulate the data to produce the histogram and manpower cumulative loading. I would use VBA to do that. If you want some help with that let me know.
John
In order to get that type of graphic, you will have to export timescaled Project data to Excel and then manipulate the data to produce the histogram and manpower cumulative loading. I would use VBA to do that. If you want some help with that let me know.
John