Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Resource availability and capacity

Highlighted
Bernard.Chee
Super Collector

Resource availability and capacity

Hi,

Has anybody attempted to write SQL queries to generate reports that are useful for determing the capacity and availability of a resource ? The "Resource Load Breakdown" screen is a possibility but alas there is no export to Excel functionality.

Any comments or advice will be much appreciated. Thanks.

regards,

Bernard Chee
bernard.chee@gmail.com
4 REPLIES
Vinod Jadhav
Regular Collector

Re: Resource availability and capacity

Hi Bernard,

I had created report simillar to 'Resource Load Breakdown' compartible to PPM 6.0 version because of the same limitation. Capacity needs to be calculated from the WBS Scheduled efforts against resource while Demand would come from Staffing profile planned FTEs. You would have to take resource calendars into consideration while deriving capacity of the resource.

Right now I do not have those scripts with me but if you need, I can look for them.

Regards,
Vinod
Bernard.Chee
Super Collector

Re: Resource availability and capacity

Hi Vinod,

Yes, I would be most interested to have a look at your scripts. Thanks for your trouble.

regards,

Bernard
kev marks
Regular Collector

Re: Resource availability and capacity

Hi Vinod,
Please do attach them to this post if you have time to find them, we have a similar requirement.
I will gladly post any changes/improvements we make to them

thanks
Kevin
Semenov Alexand
Esteemed Contributor

Re: Resource availability and capacity

Hi
In 7.5 allow export to Excel Resource Load Breakdown. In 7.1. it's possible by copy from PPM and paste to Excel.
Good Luck
//Add this to "OnDomLoad" event