M
Marcael
*BACKGROUND INFORMATION*
I have a project plan that is a rollup of multiple projects that I use
for scheduling work out a quarter at a time. Each project detail is
limited to approx a business analysis, development, testing task with
different combinations of people assigned within and across projects.
Approximate % complete for each task is updated weekly.
I am using the Resource Usage report (sorts by resources (people)) as
my management report to see if someone can have a new project assigned
to them weeks out from now, if they are overallocated, etc. The
report lists by resource and week how many hours will be spent on each
project.
**REQUIREMENT**
What I need to incorporate into the Resource Usage report (similar
view) is a column that by task tells me if the resource is currently
behind schedule so I can adjust the duration of task, start date of
future work, etc.
One idea I have is to have a percentage per task that tells me based
on the defined start date, todays date and work completed, what is the
percent done I should be. I would like to put this right next to a
work completed column.
Another idea is a new column that follows each column with hours per
project. The column would should what the percent complete the
project should be in at that week.
I am not sure if/how I can add the new column(s). I have been looking
at what is already defined and not finding what I need. Any
suggestions or technical direction would be appreciated.
Thanks in advance.
I have a project plan that is a rollup of multiple projects that I use
for scheduling work out a quarter at a time. Each project detail is
limited to approx a business analysis, development, testing task with
different combinations of people assigned within and across projects.
Approximate % complete for each task is updated weekly.
I am using the Resource Usage report (sorts by resources (people)) as
my management report to see if someone can have a new project assigned
to them weeks out from now, if they are overallocated, etc. The
report lists by resource and week how many hours will be spent on each
project.
**REQUIREMENT**
What I need to incorporate into the Resource Usage report (similar
view) is a column that by task tells me if the resource is currently
behind schedule so I can adjust the duration of task, start date of
future work, etc.
One idea I have is to have a percentage per task that tells me based
on the defined start date, todays date and work completed, what is the
percent done I should be. I would like to put this right next to a
work completed column.
Another idea is a new column that follows each column with hours per
project. The column would should what the percent complete the
project should be in at that week.
I am not sure if/how I can add the new column(s). I have been looking
at what is already defined and not finding what I need. Any
suggestions or technical direction would be appreciated.
Thanks in advance.