Resource List

[sjk1000]

Hi
I need to be able to generate a single report that
1. projects we're engaged in,
2. the individuals involved in each project and
3. the number of days in the week that each person is
assigned.

This is a fairly standard output of a resource management tool but I'm
getting mixed messages about whether MSProject can do this. At the
moment we're using 2003 Standard but if we can argue the case for
funding we'll move to 2007 Professional & Server.

The o/p would look like this:

Project A wc5/3/7 wc12/3/7 wc19/3/7 wc26/3/7 wc2/4/7
wc9/4/7
John 5 4 4
2 2 2
Steve 3 3 3
3 3 3
Mike 1 1 4
4 4 4
Claire 5 5 3
3 5 5

Project B wc5/3/7 wc12/3/7 wc19/3/7 wc26/3/7 wc2/4/7
wc9/4/7
John 0 1 1
1 1 1
Steve 2 2 2
2 2 2
Jeff 1 4 4
4 4 4
Claire 0 0 2
2 0 0

etc.

My next step would be a report that shows availability. eg

wc5/3/7 wc12/3/7 wc19/3/7 wc26/3/7 wc2/4/7
wc9/4/7
John 0 0 0
0 0 0
Steve 0 0 0
0 0 0
Mike 4 4 1
1 1 1
Claire 0 0 0
0 0 0
Jeff 4 1 1
1 1 1

....but I'll tackle one problem at a time.
Any pointers or advice would be very much appreciated
Thanks, Steve

 

[sjk1000]

Fantastic! Love the way it reformats my tables. You get the idea I
hope

ps insert missing "shows" at the end of the first line.

Thanks, Steve

 

[John]

Hi
I need to be able to generate a single report that
1. projects we're engaged in,
2. the individuals involved in each project and
3. the number of days in the week that each person is
assigned.

This is a fairly standard output of a resource management tool but I'm
getting mixed messages about whether MSProject can do this. At the
moment we're using 2003 Standard but if we can argue the case for
funding we'll move to 2007 Professional & Server.

The o/p would look like this:

Project A wc5/3/7 wc12/3/7 wc19/3/7 wc26/3/7 wc2/4/7
wc9/4/7
John 5 4 4
2 2 2
Steve 3 3 3
3 3 3
Mike 1 1 4
4 4 4
Claire 5 5 3
3 5 5

Project B wc5/3/7 wc12/3/7 wc19/3/7 wc26/3/7 wc2/4/7
wc9/4/7
John 0 1 1
1 1 1
Steve 2 2 2
2 2 2
Jeff 1 4 4
4 4 4
Claire 0 0 2
2 0 0

etc.

My next step would be a report that shows availability. eg

wc5/3/7 wc12/3/7 wc19/3/7 wc26/3/7 wc2/4/7
wc9/4/7
John 0 0 0
0 0 0
Steve 0 0 0
0 0 0
Mike 4 4 1
1 1 1
Claire 0 0 0
0 0 0
Jeff 4 1 1
1 1 1

...but I'll tackle one problem at a time.
Any pointers or advice would be very much appreciated
Thanks, Steve

Steve,
Yes Project can do those things. The first are easy, the last one takes
a little more "effort".

Depending on how your "projects" are identified (e.g. summary lines in
one large file, individual project files, etc.), the first two elements
of your desired report can be developed from the Resource Usage view. If
the projects are in one large file, each project can be identified by
WBS, a spare field or other identifier. Then using filters and/or
grouping the desired report can be obtained. If each of the projects are
in individual files, then you will need a master file (Insert/Project)
that consolidates each of the individual files. Filters and/or grouping
can then be applied to the master file.

Getting the number of days each resource works in a week isn't a readily
available parameter. The only way I can think of to get that type of
report from Project Standard or Pro is through VBA. It may or may not be
more easily obtainable with Project Server. You might want to post to
our sister newsgroup, microsoft.public.project.server and pose your
question there.

Hope this helps.
John
Project MVP

 

[sjk1000]

Thanks for the reply John. We'll give it a try and let you know.
Steve

 

[John]

Thanks for the reply John. We'll give it a try and let you know.
Steve

Steve,
You're welcome and thanks for the feedback.
John