Resource Availability Report

[bfkesq]

Hi there, I've been reading the boards trying to find more information about
generating a report from my master project file (about 5 projects all of
which share a common resource pool). My end goal is to produce something in
excel (hopefully using a visual report) that looks like the "who does what
when" text based report except I want the data (what would be the crosstab)
to be remaining availability and then use excel to format the cells so anyone
with more than 30 hours of availability for the week is in green highlight,
between 10-30 is yellow, and anything below 10 is red.

I've tried making a visual report from the standard templates but when I do,
when I select weekly calender the availability says 128 hours and the work
hours seem astronomically high. I would greatly appreciate any help anyone
could offer. Thanks

-Brendan

 

[Rod Gill]

The Availability hours are calculated based on the max units for the
Resource (see Resource Sheet) and the hours in the Resource's Base Calendar.
What do you have?

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[bfkesq]

Rod,
Thanks for your quick response. I am using a standard resource calendar
with the pre-set standarda availability of 8-5 with the one hour break from
12-1. The max units is set to 100% for each of the resources.

 

[bfkesq]

And, I forgot to mention, that when I produce a text-based "who does what
when" report, the availability is correct, it just becomes skewed when I
produce a visual based resource report.

Brendan

 

[Michael.Tarnowski]

Hi there, I've been reading the boards trying to find more information about
generating a report from my master project file (about 5 projects all of
which share a common resource pool). My end goal is to produce something in
excel (hopefully using a visual report) that looks like the "who does what
when" text based report except I want the data (what would be the crosstab)
to be remaining availability and then use excel to format the cells so anyone
with more than 30 hours of availability for the week is in green highlight,
between 10-30 is yellow, and anything below 10 is red.

I've tried making a visual report from the standard templates but when I do,
when I select weekly calender the availability says 128 hours and the work
hours seem astronomically high. I would greatly appreciate any help anyone
could offer. Thanks

-Brendan

Brendan,
MSP is a planning tool, you assign resources you expect that they will
do the task in question. - But if they really *will* perform the
assigned task is a another question: the assigned employee could be
called back by senior management or higher prioritized issues would
come around.
As fare as I know most organizations use beside planning tools (MSP)
HR real workload monitor tools where each employee enters at the end
of each week the real spent workload for all his activities (project
WBS or department horizontal matrix activities).
It is up to the project manager to keep his MSP resource planning in
sync with the real spent workloads. - If she is a lucky girl, the
tools have an easy interface to collaborate with MSP ;-)

Cheers Michael

 

[Michael.Tarnowski]

Hi there, I've been reading the boards trying to find more information about
generating a report from my master project file (about 5 projects all of
which share a common resource pool). My end goal is to produce something in
excel (hopefully using a visual report) that looks like the "who does what
when" text based report except I want the data (what would be the crosstab)
to be remaining availability and then use excel to format the cells so anyone
with more than 30 hours of availability for the week is in green highlight,
between 10-30 is yellow, and anything below 10 is red.

I've tried making a visual report from the standard templates but when I do,
when I select weekly calender the availability says 128 hours and the work
hours seem astronomically high. I would greatly appreciate any help anyone
could offer. Thanks

-Brendan

Brendan,
MSP is a planning tool, you assign resources you expect that they will
do the task in question. - But if they really *will* perform the
assigned task is a another question: the assigned employee could be
called back by senior management or higher prioritized issues would
come around.
As fare as I know most organizations use beside planning tools (MSP)
HR real workload monitor tools (like SAP) where each employee enters
at the end
of each week the real spent workload for all his activities (project
WBS or department horizontal matrix activities).
It is up to the project manager to keep his MSP resource planning in
sync with the real spent workloads. - If she is a lucky girl, the
tools have an easy interface to collaborate with MSP ;-)

Thus, the most proper answer to the questioin "who worked really on
what?" you will get not by MSP, but by the HR workload system.

Cheers Michael