Allocating resources

[Lindsay]

I have a 3,700 activity schedule with resources assigned. The resource are
groups, Examples: Elec, Piping, Welding. Each group has 10 men so I set the
max. units to 1000%. Now I need to allocate the units to the activity. Is
there any way to import this information from Excel? Right now when I click
on an activity the allocated units is 100% but I need to adjust them and I
don't want to have to click on all 3,700 activitys to do this.

 

[Mike Glen]

Hi Lindsay,

Welcome to this Microsoft Project newsgroup

Well... it has to be done to each task. You can select all the Tasks that
have the same resource, then Project/Task Information/Resources tab and
change the 100% to what ever you want and all the selected tasks will
receive the amendment.

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

 

[Steve House]

The default resource assignment is either 100% or the resource's maximum
availability, whichever is less. Anything else, you have to manually
provide the desired level on a task by task and resource by resource basis.

 

[JulieS]

Hi Lindsay,

A couple of options that may help speed things along.

If you want to increase the assignment units for all Piping, Elec, etc.
resources you can select all tasks in your project by clicking the Task
Name Column. Click the assign resources button on the Standard toolbar,
select the first resource that you wish to change from 100% to 1000%,
click the Replace button. In the Replace dialog box, select the same
resource and specify the new assignment units. Repeat for the other
resources.

You could also display the Resource Usage view and add the Assignment
Units field to the table (left side). Enter the new higher assignment
unit for the first resource's first assignment and then use the fill
handle to copy the higher assignment unit to each assignment for that
resource. Repeat for other resources and assignments.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[Jan De Messemaeker]

Hi,

If in Excel you have the resource name and the percentage (or decimal units)
you want to apply maybe (just maybe) you can put together a formula to mimic
the resourcenames ccolumn e.g. Piping[200%]; than copy/paste this from Excel
into the resource name field.

Also, a VBA procedure doing that would not be trivial, but not that hard to
write either.
HTH