showing schedule of projects

[Dan]

I use a resource pool and link this to many projects.

However, what I would like to do is produce a report that shows what
projects each individual in my resource pool is working on - on a daily
basis. I don't want to go down to task or job level, just project. So, for
example, I have 3 projects on the go, P1, P2 and P3 and Dave is meant to be
working on P1 every day in june except for 4 days, where he will instead be
working on project P2. Steve on the other hand will be working on P1 for
week 1, P2 for week 2, P3 for week 3 and P4 for week 4.

I would like a report that shows something like:

June
01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22
.... 30

Dave P1 P2 P1 P1 P1 P1 P1 P1 P1 P2 P1 P1 P1 P1 P1 P2 P1 P1 P1 P1 P1 P2
.... etc
Steve P1 P1 P1 P1 P1 P1 P1 P2 P2 P2 P2 P2 P2 P2 P3 P2 P2 P2 P2 P2 P2 P3
.... etc

I'd be grateful if someone could point me in the right direction.

Kind regards,

Dan

 

[John]

I use a resource pool and link this to many projects.

However, what I would like to do is produce a report that shows what
projects each individual in my resource pool is working on - on a daily
basis. I don't want to go down to task or job level, just project. So, for
example, I have 3 projects on the go, P1, P2 and P3 and Dave is meant to be
working on P1 every day in june except for 4 days, where he will instead be
working on project P2. Steve on the other hand will be working on P1 for
week 1, P2 for week 2, P3 for week 3 and P4 for week 4.

I would like a report that shows something like:

June
01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22
... 30

Dave P1 P2 P1 P1 P1 P1 P1 P1 P1 P2 P1 P1 P1 P1 P1 P2 P1 P1 P1 P1 P1 P2
... etc
Steve P1 P1 P1 P1 P1 P1 P1 P2 P2 P2 P2 P2 P2 P2 P3 P2 P2 P2 P2 P2 P2 P3
... etc

I'd be grateful if someone could point me in the right direction.

Kind regards,

Dan

Dan,
You can get something equivalent to what you want or you can get exactly
what you want, it depends on what you accept as "the right direction".

To get equivalent to what you want, use the Resource Usage view and
display the Project field as a column on the left side. Set up the
timescale data on the right side to show "Days". It doesn't really
matter what type of data is shown on the right side as long as it
relates to a resource's assignment (e.g. Work, Peak Units, etc.). Any
non-zero data that appears on the right side indicates that resource is
working on the Project listed on the left side. This approach also
provides information if a particular resource happens to work on one
project part of the day and other projects the rest of the day.

There are variations to the above approach (i.e. Task Usage view and
perhaps some filtering), but the result will still only be an equivalent
report.

The exact report you want can be developed but it will require the use
of an advanced feature of Project, namely, VBA. For the type of report
you want this is the approach I would take. The code would export the
necessary data to Excel and then format it in the form you need.

Hope this helps.
John
Project MVP