Special Snapshot View

[Ryan P]

We have a mixture of small projects with a few large ones, with each project
having it's own project file. Then we have a master file to view them all
and a resource pool.

What I am trying to do is create a way to see a quick snapshot of work loads
and deadlines so when a new project is handed to me I know who to assign it
to and if we will have a major conflict.

What I have decided would be great is if I could somehow have a snapshot
(realtime) as follows.

Engineer
Project ABC
Due Date (total hours for this engineer on this project)
Project DEF
Due Date (total hours for this engineer on this project)

I do have a lot of VBA experience, so if that is the direction that I need
to go I can do that. I am just wondering if there is a magic report/view
that would already do this for me.

Right now I am contemplating just dumping it all into excel and creating a
macro to format as I need. But this requires me to update that excel file
every time the master project changes, or when I need to assign a new project.

Any ideas, help, suggestions are greatly appreciated.

 

[Mike Glen]

Hi Ryan,

If you want a vba solution, try posting on the developer newsgroup. Please
see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other
useful Project information can be seen at this web address:
http://www.mvps.org/project/.

Mike Glen
Project MVP

 

[Pratta]

Hi Ryan
Have you tried using the Resource Usage view with the master project open.
Just insert a column for the project on the LHS. If the fies are open then
the filename will show, if not it will show the path.
As you have a resource pool then all resources are listed with all the
tasks, in all the projects, with the flexibility of roll-up to resource
summary level. You can drill down to find the cause of overallocation..
You don't need to do any VBA to get these views.

Regards...............Pratta