L
lisalp
I have seen similar threads but have not found my specific quest. I a
an R&D Product Development Manager with a request from our VP to provid
a Resource Allocation Report (generated from MSP 2007)that contains
row for each of our department resources (personnel) and a column fo
each project with sum totals. This would generate a single repor
conveying the total resources allocated for each project (column total
and each individual's allocation (row total) for a specific timefram
(month, quarter, etc.).
Is this possible to generate from MSP 2007 with a Master Project fil
correlated to a Master Resource Pool?
I can not seem to display that for Feb., as an example (or any othe
timeframe or total project), "Joe" has 10 days allocated to Project
and 5 days to Project B, and "Jill" has 5 days to Project A and 5 day
into Project B. With the report requested it would be obvious tha
Project A and B would utilize the projects would utilize 15 and 1
days, respectively and that "Joe" and "Jill" are allocated for 15 and 1
days, respectively.
I don't mind exporting into Excel (2003), if I have the correct data t
further manipulate via macro or any other means. My attempts thus fa
have ended up with a Task Usage table that breaks down resources int
"tasks" from projects (even with a project column and numerous attempt
to group by task) and does not summarize "projects".
Can anyone shed light on this dilemma
an R&D Product Development Manager with a request from our VP to provid
a Resource Allocation Report (generated from MSP 2007)that contains
row for each of our department resources (personnel) and a column fo
each project with sum totals. This would generate a single repor
conveying the total resources allocated for each project (column total
and each individual's allocation (row total) for a specific timefram
(month, quarter, etc.).
Is this possible to generate from MSP 2007 with a Master Project fil
correlated to a Master Resource Pool?
I can not seem to display that for Feb., as an example (or any othe
timeframe or total project), "Joe" has 10 days allocated to Project
and 5 days to Project B, and "Jill" has 5 days to Project A and 5 day
into Project B. With the report requested it would be obvious tha
Project A and B would utilize the projects would utilize 15 and 1
days, respectively and that "Joe" and "Jill" are allocated for 15 and 1
days, respectively.
I don't mind exporting into Excel (2003), if I have the correct data t
further manipulate via macro or any other means. My attempts thus fa
have ended up with a Task Usage table that breaks down resources int
"tasks" from projects (even with a project column and numerous attempt
to group by task) and does not summarize "projects".
Can anyone shed light on this dilemma