Filter Resource Usage Profile by WBS
- Created
- 15
- 5
I am trying to do a manual resource leveling and I would like to be able to focus on one wbs element at a time - unit. Is there a way to set up the profile so that it filters on wbs? I only want to see the resources for a specific unit not the entire project. It either cannot be done or I am missing something simple. Any thoughts appreciated. I am using P6 8.3. Thanks.
15 replies
Oldest first- 0DHDennis Hanks ·
Raymond:Thanks, but not quite
Raymond:
Thanks, but not quite what I need. I assume that there is no filter/sort for the Resource Usage Profile so that I only see a specific WBS code (in this case 1.1.10.4 - OSBL piping design) histogram. I like the visual feedback of seeing the resource histogram that I can change via duration and/or logic. I want to level one area and then move on to the other and then finally adjust the entire discipline.
Again, thanks. I seldom use the Resource Assignment tab, so it was a nice education. If I could do the same filter for the Resource Usage Profile, I would be home free.
- 0RDRaymund de Laza ·
Dennis,I Suggest to use the
Dennis,
I Suggest to use the Stacked Histogram and Create a Resource Code as your WBS Code and assign to those Resources assigned in the Activities under the subject WBS.
From Stacked Histogram you can now filter those resources as required.
Hope this will help.
- 0DHDennis Hanks ·
Raymond:Not sure I
Raymond:
Not sure I understand, but will give it a try. Obviously, the solution is more involved than I expected and I did not overlook something simple. In a way reassuring, in another disappointing. I would have thought this would have been a fundatmental feature. Will let you know how it goes. Thanks.
Update: I am trying to use the Reflection feature. Make a reflection, filter on non-WBS element, delete all with subject resouce, level, merge, and check. Check may have to wait until I have modified all the WBS units. May lose some inter-unit ties, but since that is the final step, it may not be much of a drawback.
- 0DHDennis Hanks ·
Raymond:Yes, but you lose the
Raymond:
Yes, but you lose the GUI interface. For me, it is easier and more comprehensible to change the durations and link while in the "Gantt" view. In my mind, this should be easy and straightforward. Why it is not, I have no clue. Thanks for sticking with me. Because of you I stumbled upon the reflection workaround. So far, it is working.
- 0VLVladimir Liberzon ·
Dennis,it is amazing how
Dennis,
it is amazing how complicated is this simple function in P6 but does it make sense to level resources manually?
When you will enter actual data something will be done not exactly as planned and you will do manual leveling again and again.
Are you ready for this permanent time consuming exersize?
P6 has poor automatic leveling capabilities but if you are not happy with leveling results assign activity priorities instead of moving activities manually or adding soft links. It may help and it is easy to modify if necessary though still does not guarantee optimal results.
- 0DHDennis Hanks ·
Vladimir:You are right. This
Vladimir:
You are right. This is a one-time only exercise. To do it more often, just invites pain. In this case, I have a 'sow's ear' that I am trying to turn into a 'silk purse' for use in another model. For me, the Primavera leveling algorithm does not return acceptable results.
I would think that once you determine the appropriate activity staffing, that should remain relatively constant (staffing levels/durations were poorly determined). As for out-of-sequence progress, I would think that that is highly dependent upon the level of detail/complexity. For me, I strive to simplify as much as possible - no schedule >3000 activities. The 'ear' was about 5000 activities. The 'purse' is at 1388 and I may reduce that further when I get into construction.
My goal is to put only as much detail on the schedule to permit me to perform effective forecasting and determine when a superintendent can have an area and how soon he must be out of that area. Beyond that, I think he is better able to control his work using his personal tools (spreadsheets/checklists). This is heavily dependent upon the quality of the current estimate(s). Handover milestones do pose a problem for my system, but they can be addressed via alternative means (constraints and emails).
My experience suggests that superindents do not use project schedules - or anyone else, for that matter.
- 0VLVladimir Liberzon ·
Dennis,we do similar work
Dennis,
we do similar work (though with automatic leveling) preparing contract requirements.
When construction is ours we do not rely on superintendent schedules but suggest them to follow scheduled order of work. They shall review prepared schedules but if agreed it shall be followed. Detailed schedule permits to optimize project resource requirements.
- 0DHDennis Hanks ·
Arnold;Thanks for the
Arnold;
Thanks for the suggestion. Not sure when I will be able to use it. I used the filtered reflection that had mixed results. Fortunately, this particular exercise is behind me. Apparently, Oracle has the 'feature' listed as an enhancement request, so maybe next release. I will have to look into "resource analysis". Again, thanks.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?