#1
|
|||
|
|||
Locking resource for over-allocation resolution
I have either forgotten how - or there is no way to do - what I thought I used to be able to do in MS Project; probably the former. I have a project with about a dozen resources and a few hundred tasks, and a bunch of resources are over allocated.
I have the gantt chart on the top and the resource graph on the bottom. I select a task in the top and I see the resource usage graph for the first entry in my resource sheet below. Excellent. I can now scroll left and right in the bottom right pane to find the red bars and over allocation, and I can scroll up and down on the gantt on the top until the task bars line up with the red overextended resource task assignments. I can then reduce the percentage of the users time assigned to the task in each task until I get a satisfactory allocation for this resource. Now I select the next resource in the bottom left (many of these tasks have a bunch of people working on them). I now go to the right bottom and scroll left and right to find the red bars again showing me over allocation. Up the top in the gantt I now scroll up and down to find the task bars that align with the red resource allocation bars. That all works fine. But now, I click in the resource column of the top left to change the assigned percentage for this resource and bingo - the bottom resource graph now pops back to the first entry in the resource sheet. To carry on working with this second resource I have to continually reselect the resource in the resource sheet on the bottom left. And this it true for all resources. I want to LOCK the resource graph for ONE resource until I have dealt with all the over allocation for that resource. Then lock the next one and repeat - and so on. But the continual popping back to the top of the sheet is driving me nuts. Does anyone know any way I can do this? Thanks - Lawrence |
#2
|
|||
|
|||
Hi Lawrence
I am not sure that reducing the Assignment Units against each resource is the right way to do it as if a task is scheduled to a given amount of time then more resource should be added in order to achieve it in less time. However if you really want to do it the way you suggest then follow these steps: 1. Select Task Usage View. 2. Insert two new columns to the view: - Overallocated - Assignment Units 3. Filter the Overallocated column to "Yes". 4. Then change the assignment units for each resource until the Overallocated column reads "No". Hope this helps. Good luck. Tony |
Tags |
gantt, over-allocation, resources |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Resolution mismatch | Adforum | PowerPoint | 5 | 05-25-2011 12:24 PM |
Locking a Form | lafranceds | Word | 1 | 12-12-2010 11:40 AM |
Graphics resolution | Roscoe | Drawing and Graphics | 5 | 07-02-2010 07:43 AM |
locking out word | joe | Word | 0 | 11-19-2009 02:09 AM |
Locking Text | Boise User | Word | 0 | 01-24-2009 01:55 PM |