T
tgreen_etc
I have around 15 active projects, all of which are individually broken down
to have phases/subtasks/etc. (consequently, one plan may have indents to
about 4 or 5 levels deep). To create a "master project plan" I simply copy
the collapsed project at outline level one, and paste it in the master file,
which works great. After that, I am looking to use the resource usage view
to see all of my resources (i.e. employees Name) listed by name, and then be
able to see below each employee name, A) what projects they are assigned to
(not all employees work on every project) and B) how many hours they have
assigned to them broken down per week. I would like to see this in both
total for the week (seen in the detail view "Work" on the right hand screen)
and overall subtotal by project (shown at outline level one, also on the
right side)…. This is where things get sticky!
I can come very close to achieving this using the following steps:
Copy/paste all projects into one master file > choose “View†> choose
“Resource Usage†> choose “Project, Group By, Assignments Keeping Outline
Structureâ€. Now I am able to press the "+" next to a name, and see all
projects the person is assigned to below their name. I can also see their
total hour per week, as a total of all the projects they are assigned to.
What I cannot see is the total hours for each individual project, per week.
This is because by project, the hour each person is assigned per week only
total up to the associated phase of the project; I can see all the hour only
when the project below the name is entirely expanded. My goal is to see
something like the following (this is assuming each project has multiple
outline levels):
- John 102.47 hrs work 8h 11h
14h
+Project A 27.25 hrs work 4h 9h
5h
+Project B 75.25 hrs work 2h 2h
6h
+Project C 50 hrs work 2h
3h
Right now, I see all this information with the exception of the hours by
project per week (i.e. the 4h, 2h, etc.) This is because the project is not
expanded; I can only see these hour totals when they either A) lie within the
first outline level, or B) the project has no indents.
So, what I need is actually a bit simple, just for the numbers within the
collapsed project to total up to the top!
Please help me, I have literally tried everything that I can possibly think
of with this.
to have phases/subtasks/etc. (consequently, one plan may have indents to
about 4 or 5 levels deep). To create a "master project plan" I simply copy
the collapsed project at outline level one, and paste it in the master file,
which works great. After that, I am looking to use the resource usage view
to see all of my resources (i.e. employees Name) listed by name, and then be
able to see below each employee name, A) what projects they are assigned to
(not all employees work on every project) and B) how many hours they have
assigned to them broken down per week. I would like to see this in both
total for the week (seen in the detail view "Work" on the right hand screen)
and overall subtotal by project (shown at outline level one, also on the
right side)…. This is where things get sticky!
I can come very close to achieving this using the following steps:
Copy/paste all projects into one master file > choose “View†> choose
“Resource Usage†> choose “Project, Group By, Assignments Keeping Outline
Structureâ€. Now I am able to press the "+" next to a name, and see all
projects the person is assigned to below their name. I can also see their
total hour per week, as a total of all the projects they are assigned to.
What I cannot see is the total hours for each individual project, per week.
This is because by project, the hour each person is assigned per week only
total up to the associated phase of the project; I can see all the hour only
when the project below the name is entirely expanded. My goal is to see
something like the following (this is assuming each project has multiple
outline levels):
- John 102.47 hrs work 8h 11h
14h
+Project A 27.25 hrs work 4h 9h
5h
+Project B 75.25 hrs work 2h 2h
6h
+Project C 50 hrs work 2h
3h
Right now, I see all this information with the exception of the hours by
project per week (i.e. the 4h, 2h, etc.) This is because the project is not
expanded; I can only see these hour totals when they either A) lie within the
first outline level, or B) the project has no indents.
So, what I need is actually a bit simple, just for the numbers within the
collapsed project to total up to the top!
Please help me, I have literally tried everything that I can possibly think
of with this.