Resource Usage

J

Jeff

Does anyone know if there is a way to update Resource
Usage Sheet with percentages versus hours???

Thanks for the response!
 
D

Dale Howard

Jeff --

If you asking if actuals can be entered as a % Complete value in the
timephased grid (yellow/white timesheet on the right side) of the Resource
Usage view, they cannot. If you want to enter actuals in this view, you
must enter your actuals in hours in the Actual Work field, most likely done
on a daily or weekly basis. Hope this helps, even if it's bad news.
 
J

Jeff

Dale,

Thanks for the response - but I am wanting to change
the planned percentages - do you know if I can do that?
We prefer to plan project resource based on percentage of
time versus hours - is that possible???

Thanks & if you would prefer, please give me a call (407)
566-2827.

Jeff
 
D

Dale Howard

Jeff --

I you are wanting to set up the planned percentage for resource assignments
to tasks, I don't believe the Resource Usage view is for you, as you are not
allowed to manually change the value called Percent Allocation in the
timephased grid. Instead, have you considered the following approach:

1. Plan your task list in the Gantt Chart view, leaving the Duration of
each task at the default value of 1 day
2. Set all task dependencies and constraints for the project
3. When you are ready to begin resource allocation, click Window - Split to
open a combination view with the Gantt Chart in the top pane and the Task
Form in the lower pane
4. Select the first task in the project
5. In the Task Form, select one or more resources who will be assigned to
the task
6. For each resource, specify a Units value (this value represents the
percentage of an average working day that the resource will commit to this
task; for example, 50% Units represents an average of 4 hours per day of
work on the task)
7. For each resource, set a Work value which represents the number of hours
of "burned work" the resource will commit to the task
8. Click the OK button to create the assignment and to cause MS Project to
calculate the Duration for the task
9. Click the Next button to move to the next task in the project and repeat
this process

The calculated Duration in step 8 represents the earliest that the task can
possibly finish, based on the assignment Units and the Work hours estimated
for the task. For example, if a single resource is assigned to a task at
50% Units and 40 hours of work, MS Project will calculate the Duration at 10
days, assuming that 8 hours per day is your standard work day.

I believe that this approach might be a better way for you to specify the
percentage of time on each task, assuming that the Units value is what you
mean by percentage of time. If this isn't what you are looking for, I ask
your forgiveness in advance. Hope this helps.
 

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