MS Project View?

[LosMorans]

Is there a "View" or report in MS Project that displays just the
activities with overallocated resources?

Thank you

 

[John]

Is there a "View" or report in MS Project that displays just the
activities with overallocated resources?

Thank you

LosMorans,
There is not a specific built-in view for that but there is a built-in
report (View/Reports, then pick the Assignments report). You could
create a view by using the Resource Usage view coupled with the
Overallocated Resources filter.

You could also get a task type view (e.g. Gantt Chart) to display only
tasks with overallocated resources but it will take some VBA to loop
through all tasks, identify those with overallocated resources and then
display the result.

Hope this helps.
John
Project MVP

 

[vanita]

Hi

If you want to display tasks with overallocated resources, open a task based
view and insert a column of Flag1. Customise the Flag1 column with formula
IIf([Overallocated],Yes,No)

Now for overallocated tasks, the column would show 'Yes' and for other
activities 'No'. Now go toProject > Filter > More filters and create a new
filter as 'Field name (Flag1) - Test (equals) - Value (Yes)' and apply the
filter.

View would only show activities with overallocated resources.

I hope it helps.
Vanita

 

[JulieS]

A quick clarification. You can add the Overallocated field to a
task view -- no need to create an additional field with the formula.
However, the Overallocated field shown in a task view will only show
"yes" if a resource is assigned to the task above his/her max units
to that tasks. If a resource is overallocated because of an overlap
of assignments the overallocated field in a task view will not
indicate that. The most common reason a resource is overallocated is
due to an overlap of assignments, not an individual assignment above
max. units.

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

Hi

If you want to display tasks with overallocated resources, open a
task based
view and insert a column of Flag1. Customise the Flag1 column with
formula
IIf([Overallocated],Yes,No)

Now for overallocated tasks, the column would show 'Yes' and for
other
activities 'No'. Now go toProject > Filter > More filters and
create a new
filter as 'Field name (Flag1) - Test (equals) - Value (Yes)' and
apply the
filter.

View would only show activities with overallocated resources.

I hope it helps.
Vanita

Is there a "View" or report in MS Project that displays just the
activities with overallocated resources?

Thank you


--
LosMorans
------------------------------------------------------------------------
LosMorans's Profile:
http://forums.techarena.in/members/losmorans.htm
View this thread:
http://forums.techarena.in/microsoft-project/1078359.htm

http://forums.techarena.in