Reports by resource by project

J

john

Hello All,
I am using project 2002 standard. I have created a
resource pool for my organisation. I have several programs
(Master Project files) utilizing this resource pool. I
need the ability to report across the organisation on all
projects. What I am looking for is:
Resource A 1/1 2/1 3/1
Project 1 120 hrs 80 hrs 20hrs
Project 2 160hrs 80hrs
Resource B
Project 2 200hrs 160hrs
Project 8 300hrs
I would like to be able to pull this data into excel to
create visual charts.
Thanks,
John
 
J

John

John,
If I were doing it, I would write a VBA routine to gather and export the
data. However if you don't have VBA experience here are a couple of
other options that might help.

Use a combination of the "analyze timescale data in Excel" add-in found
on the analysis toolbar and an export map to get both the timescaled and
static data from Project to Excel. The resulting data will need to be
manipulated in Excel to get the format you want but the basic data will
be there.

You might also like to look at a macro one of the other MVPs (Rod Gill)
has written called, "reporting across multiple projects". I don't know
if it is exactly what you need but it might be a good start. Rod's macro
can be found at:
http://www.mvps.org/project/reporting_across_multiple_projects.htm

Hope this helps.
John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top