Effort Columns in Resource Sheet View

D

DS

Hi All.

I'm using MS-Project Pro 2003.

I'm in the "Resource Sheet" view and would like to get a calculation of the
actual effort days that my resources will be doing. I have added the
'Regular Work' column, which totals 'Work', but it seems to total the work
over the calendar schedule.

So, my 'Project Manager' who has tasks at the beginning of the project and
at the end of the project but in total does about 10 effort days of work, has
a 'Regular Work' total of 97 days (the duration of the project). The total
I'd like to see on the 'Resource Sheet' is the actual effort a resource is
committing to the project - in this case, the PM is spending 10 effort days
on the project (not 97).

Is there a column I can add (or a custom column) I can use to determine this
total?

Thanks.

DS
 
J

JulieS

Hi DS,

If you have added the Work column to the resource sheet, you are seeing the
total "effort" for the Project Manager. He or she is scheduled for 97 days
of work. It the 97 days of total work is much higher than you expected, it
sounds as though there may be a problem with how the Project Manager is
assigned to the tasks. Make sure you don't have the Project Manager assigned
to summary tasks.

I suggest going to the Resource Usage View and taking a look at how many
hours per day you have the Project Manager assigned to tasks.

You may also find some very useful information about the relationship
between work, duration, and unit assignment in fellow MVP Mike Glen's
excellent series of articles at:

http://project.mvps.org/mike's_tutorials.htm

I hope this helps. Let us know how you get along.

Julie
 
D

DS

Hi Julie.

Thanks so much for the tip. I removed resources from the summary tasks, and
the resource counts look right now.

Cheers.

DS
 
J

JulieS

Hi DS,

Glad to know that all appears better. You're very welcome for the
assistance and thanks for the feedback.

Julie
Project MVP
 

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