Resources, tasks, dates, remaining work view

[schedulerkh]

I am using Microsoft Project 2007 to schedule multiple projects for a
group of 20 people - sharing resources. We are looking at the workload
projections for both the groups and individuals, and need to see
scheduling conflicts. I would like to be able to view a report of each
resource with a list including: resource name, project name, task name,
starting date, finish date, and remaining work. I haven't been able to
find a way to do this.

If you know how, please reply...

thanks for your help!

 

[Andrew Lavinsky]

Pull up the Resource Usage View. Go to Projects > Group By, and create a
new group to group by the following fields:

1) Resource
2) Project

Then add the fields required. That should get you close to what you're looking
for.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

 

[Prasad]

Pull up the Resource Usage View.  Go to Projects > Group By, and createa
new group to group by the following fields:

1) Resource
2) Project

Then add the fields required.  That should get you close to what you'relooking
for.

- Andrew Lavinsky
Blog:http://blogs.catapultsystems.com/epm

Hi Scheduler,

I am disappointed to see only one response to your post. Your concerns
do not seem to be serious for many experts.

As far as I know, schedule conflicts do not arise when you use
automatic resource leveling feature of MS Project. Have you resolved
your ssues including schedule conflicts following Andrew's
suggestion? I thought this requirement is quite common in many multi-
project environments involving shared resources of limited capacity,
particularly when resources have different skill sets.

Regards, Prasad

 

[Rob W]

Hi,
Can I please ask somemore questions on this? This almost works but still shows completed work in the table to the right. Is there anyway of just showing the remaining work? Where is does show percentage complete, it does not just show whats remaining?

Thanks for any advice on this..


Regards,


-RW.



Andrew Lavinsky wrote:

Pull up the Resource Usage View.
26-May-10

Pull up the Resource Usage View. Go to Projects > Group By, and create a
new group to group by the following fields:

1) Resource
2) Project

Then add the fields required. That should get you close to what you are looking
for.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Free Online Courses Available for Eggheadcafe.com Users
http://www.eggheadcafe.com/tutorial...8-fc3cf6855293/free-online-courses-avail.aspx

 

[Jan De Messemaeker]

Hi Rob,

1. No, there is no way of showing remaining work only in the right part of a
Usage View
2. You can show %complete.

IMHO best is to update the project such that all work before the status date
is done, and all work after is remaining (Update Project form makes that
easy) ; then you do not need both lines.

HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Andrew Lavinsky]

FYi that automatic leveling is generally not recommended as it wreaks havoc
on schedules. My preference is to use manual leveling on a resource by resource
basis.

Also note that this newsgroup is imminently to be retired. You may wish
to post future queries here (for all Project versions):

http://social.technet.microsoft.com/Forums/en-US/projectprofessional2010general/threads


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

 

[Prasad]

FYi that automatic leveling is generally not recommended as it wreaks havoc
on schedules.  My preference is to use manual leveling on a resource byresource
basis.

Also note that this newsgroup is imminently to be retired.  You may wish
to post future queries here (for all Project versions):

http://social.technet.microsoft.com/Forums/en-US/projectprofessional2...

- Andrew Lavinsky
Blog:http://blogs.catapultsystems.com/epm

Hi Andrew,

I am not really comfortable with manual resource leveling in multi-
project scheduling when many shared resources have limited capacity. I
wonder how much time and effort are needed to manually resolve
resource overloading when we have to schedule about 300 tasks of 10
concurrent projects on 20 shared resources and generate a meaningful
schedule for each of 20 resources. If the resource-leveled multi-
project schedule is to be updated after a week or two, we have to
repeat the laborious effort for many hours.

Why don't the Project schedulers try to use an add-in for quick
automatic resource leveling and save many man hours ever month? I
know, saving such man hours is not good for the current job market.
But, an added advantage with automatic resource leveling is the fast,
extensive and realistic what-if analysis of schedules.

Regards, Prasad

 

[Terry Rowley]

Hi Andrew,

I am not really comfortable with manual resource leveling in multi-
project scheduling when many shared resources have limited capacity. I
wonder how much time and effort are needed to manually resolve
resource overloading when we have to schedule about 300 tasks of 10
concurrent projects on 20 shared resources and generate a meaningful
schedule for each of 20 resources. If the resource-leveled multi-
project schedule is to be updated after a week or two, we have to
repeat the laborious effort for many hours.

Why don't the Project schedulers try to use an add-in for quick
automatic resource leveling and save many man hours ever month? I
know, saving such man hours is not good for the current job market.
But, an added advantage with automatic resource leveling is the fast,
extensive and realistic what-if analysis of schedules.

Regards,  Prasad

As was pointed out, Project does a terrible job automatically leveling
resources. It is totally unpredictable and seems to cause more
problems than solutions. The only upside I've found to using automatic
scheduling is that I end up learning more about Project while I try to
figure out what the heck went kaplooey (that is a 'technical' term) in
the rest of the schedule when I tried to level it.

I've been using a software package called Schedlyzer (www.optisol.biz)
which has similarities to Project but has much fewer options and,
therefore, makes it simpler to operate. I found Project to be very
powerful, but it is so powerful and has so many different options
available (most I would never use) that it took me forever to lean the
software package.

It was relatively easy for me to import my Project data into
Schedlyzer and begin using the software after a few hours of training.
Schedlyzer is not a direct replacement for Project if you use all of
Projects options, but I found it to met my needs. Also, when I was
first thinking about trying something different than Project, the
Schedlyzer people gave me a 60 day, fully functional trial version of
their program, gave me some on-line webmeeting demos, and were nearly
always immediately avaiable for phone support when I had questions.
They also pretty much setup my schedule for me with the data I
provided them.

If nothing else, I'd suggest looking at their website and getting a
download copy of their free software...you've got nothing to lose.