Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Resource Availability v Requirement Report

10 replies [Last post]
Mon, 2008-12-15 10:21
Mark Chapman
User offline. Last seen 8 years 32 weeks ago. Offline
Joined: 18 May 2006
Posts: 183
Groups: None
I am trying to create a printed multiple project report where I can see the resource availability v loading v over loading and preferably by roles. I think this must be a common report but I can’t recreate it - I’m getting close.
Top

Replies

Wed, 2008-12-17 14:08
#1
Ali Farhat
User offline. Last seen 14 years 12 weeks ago. Offline
Joined: 23 Oct 2008
Posts: 120
Groups: None
I just called a friend of mine using P5..he said that this feature is available in P5 too..
ok, i dont know, but maybe it is disabled somewhere.
Top
Wed, 2008-12-17 04:32
#2
Mark Chapman
User offline. Last seen 8 years 32 weeks ago. Offline
Joined: 18 May 2006
Posts: 183
Groups: None
For me I only see the RU under the Activity screen (as I have said 3/4 times now). I don’t see any red - is this a new feature of P6.
Top
Tue, 2008-12-16 18:10
#3
Ali Farhat
User offline. Last seen 14 years 12 weeks ago. Offline
Joined: 23 Oct 2008
Posts: 120
Groups: None
yes I am, but it is available in P5 too...
Top
Tue, 2008-12-16 12:27
#4
Mark Chapman
User offline. Last seen 8 years 32 weeks ago. Offline
Joined: 18 May 2006
Posts: 183
Groups: None
I take it you have P6 then?
Top
Tue, 2008-12-16 11:22
#5
Ali Farhat
User offline. Last seen 14 years 12 weeks ago. Offline
Joined: 23 Oct 2008
Posts: 120
Groups: None
It is the "small blue man with grey and red histogram behind"
Top
Tue, 2008-12-16 10:45
#6
Mark Chapman
User offline. Last seen 8 years 32 weeks ago. Offline
Joined: 18 May 2006
Posts: 183
Groups: None
are we talking p5? Where do I find your resource usage profile? Within the "Activity" screen?
Top
Tue, 2008-12-16 10:20
#7
Ali Farhat
User offline. Last seen 14 years 12 weeks ago. Offline
Joined: 23 Oct 2008
Posts: 120
Groups: None
I am referring to Resource usage PROFILE not the activity usage.
in this window you will view the usage of each resource accross a project or more than one project, for each resource profile you can view the allocated resource per time unit compared to the limit allowed and any overallocation will be displayed in red.
Top
Tue, 2008-12-16 09:35
#8
Mark Chapman
User offline. Last seen 8 years 32 weeks ago. Offline
Joined: 18 May 2006
Posts: 183
Groups: None
Which resource usage (RU)? I covered the activity RU in option 1.

>1. Activity (all projects open) Gantt chart with resource usage spreadsheet
Top
Tue, 2008-12-16 08:35
#9
Ali Farhat
User offline. Last seen 14 years 12 weeks ago. Offline
Joined: 23 Oct 2008
Posts: 120
Groups: None
What about the resource usage profile?
Top
Tue, 2008-12-16 07:39
#10
Mark Chapman
User offline. Last seen 8 years 32 weeks ago. Offline
Joined: 18 May 2006
Posts: 183
Groups: None
No suggestions?

I have 2 best reports but neither are the complete package.

1. Activity (all projects open) Gantt chart with resource usage spreadsheet with fields remaining units and you can see hours per week.

problems:
a - how do I tell what’s overloaded or underloaded? so no colours.
b - cannot add fields like limit and overallocated.
c - cannot copy and paste to excel or export.

2.Use Tracking option - 6 windows though with top right either gantt or spreadsheet and bottom right spreadsheet. Bottom right spreadsheet fields: Available units, limit, overallocated and remaining.

problems:
a - cannot print bottom spreadsheet!
b - cannot export to excel


I maybe missing a trick here but someone must see a big flaw I am making. Is there another way I can see the resource fields (overallocation, limit, etc)? you would have thought they were availble in the activity screen.

Cheers,

Mark
Top