Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-25-2011, 02:18 PM
lawrencehare lawrencehare is offline Locking resource for over-allocation resolution Mac OS X Locking resource for over-allocation resolution Office for Mac 2011
Novice
Locking resource for over-allocation resolution
 
Join Date: Nov 2010
Location: Bethesda, MD
Posts: 12
lawrencehare is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 06-01-2011, 03:25 AM
OTPM OTPM is offline Locking resource for over-allocation resolution Windows 7 32bit Locking resource for over-allocation resolution Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

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
Reply With Quote
Reply

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
Locking resource for over-allocation resolution 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:32 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft