Forum Discussion
KDash1228
Nov 28, 2022Copper Contributor
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...
- Nov 28, 2022KDash1228
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
KDash1228
Nov 28, 2022Copper Contributor
What 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 file
Attached 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
John-project
Nov 28, 2022Silver Contributor
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
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
- KDash1228Nov 29, 2022Copper Contributor
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.
Since these are ongoing tasks that the Resource works on throughout the entire year, I changed the start date to 9/1/22 to 8/31/23 since those are the start and end dates of the fiscal year for my company. I am assuming that would be the correct way to set the duration, start, and finish values. Correct?
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.Instead of depending on the Columns to display the number of weekly hours per resource, I should use the Timeline to view that information. Correct?
It sounds like the best views for my needs will be the Resource Usage, Task Usage, and Task Sheet. Correct?
Thank You! This has been super helpful.
- John-projectNov 29, 2022Silver ContributorKDash1228,
Setting a single task's duration to span a full year, fiscal or calendar, is a rather big chunk to time. Even though the task may be ongoing over that period, I suggest you break it down into more manageable periods, like quarters or months. That will give you a better ability to manage the work. As far as entering the data, enter the start date (if there are absolutely no prior tasks driving) and then enter the duration. Adjust as necessary to get the finish date desired. Remember, duration is in working days but you can enter calendar time as elapsed days (i.e. 30ed) for a typical month.
In the Task and Resource Usage views the left side is the "static" data (e.g. work is total work) and the right side is the "dynamic" data (e.g. work over the periods specified by the timescale). So yes, the best views for you needs are the Task and Resource Usage views. Depending on whether you want to display the Gantt bars, the Gantt Chart view will show them but the Task Sheet will only show the descriptive data with no Gantt display.
John- KDash1228Nov 30, 2022Copper Contributor
Thank you, this has been extremely helpful. My file is now setup & formatted with the information that I need to show. I appreciate the time you have taken to help.