Forum Discussion
Using Project as Resource Planner
Is it possible to use MS Project as a Resource Planner/Tracker?
If so, how would I set this up in Project?
Which views would be best to track this information?
I cannot figure out how to format the Hours, Duration, Start/End time as I want to see the number of hours each Resource is assigned to a task/project on a weekly basis.
If a new task needs to be assigned, I want to see how many hours each Resource is working (per week per task), so I can make properly reassign tasks.
Project A: Task 1, Task 2
Project B: Task 3, Task 4
Resource A
Resource B
Resource C
Resource A is assigned to Task 1 (20 hrs/wk) & Task 2 (20 hrs/wk)
Resource B is assigned to Task 3 (10 hrs/wk) & Task 4 (30 hrs/wk)
Resource C is assigned to Task 1 (10 hrs/wk)
I want to see all Resources assigned to each Task & each project.
I want to see all Tasks listed under a Project.
I want to see all Tasks assigned to a Resource.
- KDash1228
Thanks for the info. The first thing I suggest is change all your tasks to auto-scheduled. Manual scheduling may be useful when setting up a rough draft for a plan but once the plan is in place and you're ready to assign resources, all tasks should be auto-scheduled. Only then can you reap the benefits of Project's scheduling engine.
I see you have tasks that are set up as milestones (i.e. zero duration). Keep in mind that milestones are not tasks at all, they are a point in time normally defining the beginning or end of a group of activities. Milestones should not have resources assigned.
I also note that your task durations are all 5 days yet the resource hours do not add up to what is normally a full workweek (i.e. 40h). If your tasks are supposed to be for a fixed time span then I suggest you set the tasks as Fixed Duration and adjust resource hours as desired to occur anytime during that span.
As far as setting up the Task or Resource Usage views for weekly and yearly resource work loads, set the timescale to show weeks for weekly spread and a separate view with the timescale set to show years for yearly hours. Alternately, you can set the timescale to show weeks and then add the Cumulative Work field in the Details. You'll have to do a little math with the cumulative values see the difference year to year, but it will all be in one view.
Hope this helps.
John
7 Replies
- KDash1228,
The term "resource planner/tracker" is a bit subjective, it can mean different things for different users. Generally though, yes, Project should be able to meet your needs.
First of all, what version of Project are you using (e.g. stand alone desktop, Project Online, Project for the Web)?
Is each "project" a separate file or simply different summary groups in a single file? If multiple files, are you using a resource pool?
The "I want to see" items listed are readily available in either the Task Usage or Resource Usage views.
JohnWhat version of Project are you using -- Desktop Project Standard
Is each "project" a separate file or simply different summary groups in a single file?-- Different summary groups in a single fileAttached are screenshots of 3 different views I think I want to use. But, I am not sure how to properly format the views/tasks to show the number of weekly hours assigned to a task versus total hours assigned throughout the year.
Task Usage
Resource Usage
Task Sheet
- KDash1228
Thanks for the info. The first thing I suggest is change all your tasks to auto-scheduled. Manual scheduling may be useful when setting up a rough draft for a plan but once the plan is in place and you're ready to assign resources, all tasks should be auto-scheduled. Only then can you reap the benefits of Project's scheduling engine.
I see you have tasks that are set up as milestones (i.e. zero duration). Keep in mind that milestones are not tasks at all, they are a point in time normally defining the beginning or end of a group of activities. Milestones should not have resources assigned.
I also note that your task durations are all 5 days yet the resource hours do not add up to what is normally a full workweek (i.e. 40h). If your tasks are supposed to be for a fixed time span then I suggest you set the tasks as Fixed Duration and adjust resource hours as desired to occur anytime during that span.
As far as setting up the Task or Resource Usage views for weekly and yearly resource work loads, set the timescale to show weeks for weekly spread and a separate view with the timescale set to show years for yearly hours. Alternately, you can set the timescale to show weeks and then add the Cumulative Work field in the Details. You'll have to do a little math with the cumulative values see the difference year to year, but it will all be in one view.
Hope this helps.
John
