Macro for changing % allocation

S

Sage James

I'm Using Project Server 2003.

After updating the actuals, EPM reassigns the assignment units for many of
the tasks that have actuals.

I have been changing the assignemnt units back to 70% manually.

Is it possible to write an Enterprise macro that will do this?

Thanks.
 
M

Marc Soester [MVP]

Hi Sage,

I am sure you are able to write a VBA code that can do what you are after. I
would recommend a book called "VBA Programming for Microsoft Office Project
Versions 98 trhough 2007". this is an excellent book written by Rod Gill a
Project MVP with vast experience on Project and VBA.
I hope this helps
 
D

Dale Howard [MVP]

Sage --

You DO NOT need to reset the Units value for each resource after updating
actuals into the Microsoft Project plan. Here's what you don't understand:
the Units value you see for each resource assigned to a task initially
represents the original Units value. After updating actuals, however, the
number represents the Peak Units for each task assignment, which is the
maximum percentage of a working day shown in either the Actual Work field or
the Remaining Work field over the life of the task. For example, I assign a
resource at 50% Units on a task. When reporting actuals, the resource
enters 6 hours of Actual Work during one of the days in the reporting
period. The 6 hours of Actual Work converts to a Peak Units value of 75%.
When you update the progress on the task, the system automatically changes
the Peak Units value for the task assignment to 75%, but continues to assign
the Remaining Work hours at 50% Units across the remainder of the task.

I don't know where you got the idea that you have to reset the Units value
back to its original value on each task, but I believe you are wasting a lot
of time doing so. Hope this helps.
 
P

Paul Conroy

You can keep you units constant by entering time above and beyond what is
planned as overtime.
 
S

Sage James

Thanks for the replies!

Here's the context: we just rolled EPM out mid-project for one of our groups
and a couple of months of past actuals were dumped into a single day in the
timesheets to start out. Not optimal but that was the compromise. This
created high peak units that we would rather not have displayed. I'd still
like to get rid of it with a macro and not manually as it is a waste of time
ans Dale notes. I'll try and find the book Marc mentioned but if anyone knows
a few lines of code that would do it, I'd appreciate it. It looks like the
"Resource Names" task field value has the units appended to the resource name
but it would be helpful to be able to pull the Resource name value out with
no units and without having to parse them out of the string.

Thanks,

- James

Paul: not sure I follow your response - can you provide an example?

Thanks.
 
Top