Resource Usage at Summary Task Level in MSP2000

[marty]

I have tracked down about three similar posts in the newsgroup going
back to 2002 and wondered if anyone has developed/learned of a
solution: I am looking for a way to create a very simple resource
usage report for summary tasks in a project, using the default format
that MSP2000 provides for resource usage at project level. i.e. for
each resource, show the total work. To further simplify things, i
don't even need the data time phased. It seems like it should be
straightforward - it's just the accumulation of each resource's
individual task assignment work values totaled within the summary
tasks. ? Am i missing something?

[John]

Post by marty
I have tracked down about three similar posts in the newsgroup going
back to 2002 and wondered if anyone has developed/learned of a
solution: I am looking for a way to create a very simple resource
usage report for summary tasks in a project, using the default format
that MSP2000 provides for resource usage at project level. i.e. for
each resource, show the total work. To further simplify things, i
don't even need the data time phased. It seems like it should be
straightforward - it's just the accumulation of each resource's
individual task assignment work values totaled within the summary
tasks. ? Am i missing something?

Marty,
I guess I'm lost. For the Resource Usage view, as long as the Work field
is displayed as a column (static not timescaled), each resource's total
work hours are shown. What am I missing?

John

[Jan De Messemaeker]

Hi John,

The Resource Usage view does not know summary tasks
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620

Post by John

Post by marty
I have tracked down about three similar posts in the newsgroup going
back to 2002 and wondered if anyone has developed/learned of a
solution: I am looking for a way to create a very simple resource
usage report for summary tasks in a project, using the default format
that MSP2000 provides for resource usage at project level. i.e. for
each resource, show the total work. To further simplify things, i
don't even need the data time phased. It seems like it should be
straightforward - it's just the accumulation of each resource's
individual task assignment work values totaled within the summary
tasks. ? Am i missing something?

Marty,
I guess I'm lost. For the Resource Usage view, as long as the Work field
is displayed as a column (static not timescaled), each resource's total
work hours are shown. What am I missing?
John

[John]

Post by Jan De Messemaeker
Hi John,
The Resource Usage view does not know summary tasks
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620

Post by John

Post by marty
I have tracked down about three similar posts in the newsgroup going
back to 2002 and wondered if anyone has developed/learned of a
solution: I am looking for a way to create a very simple resource
usage report for summary tasks in a project, using the default format
that MSP2000 provides for resource usage at project level. i.e. for
each resource, show the total work. To further simplify things, i
don't even need the data time phased. It seems like it should be
straightforward - it's just the accumulation of each resource's
individual task assignment work values totaled within the summary
tasks. ? Am i missing something?

Marty,
I guess I'm lost. For the Resource Usage view, as long as the Work field
is displayed as a column (static not timescaled), each resource's total
work hours are shown. What am I missing?
John

Jan,
Yes, I understand that but Marty's post said he wanted to show the total
work for each resource and the Resource Usage view does show that.
That's why I'm lost. Maybe you caught something in his post that I
didn't.

John

[Mike Glen]

I think he wants the totals by summary, ie if he has different phases of a
project with a summary for each, he wants the total for each summary not the
total for the project as a whole that the Useage view gives. I can only
think that it would require some vba code to do this.


Mike Glen
Project MVP

Post by John

Post by Jan De Messemaeker
Hi John,
The Resource Usage view does not know summary tasks
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620

Post by John

Post by marty
I have tracked down about three similar posts in the newsgroup
going back to 2002 and wondered if anyone has developed/learned of
a solution: I am looking for a way to create a very simple resource
usage report for summary tasks in a project, using the default
format that MSP2000 provides for resource usage at project level.
i.e. for each resource, show the total work. To further simplify
things, i don't even need the data time phased. It seems like it
should be straightforward - it's just the accumulation of each
resource's individual task assignment work values totaled within
the summary tasks. ? Am i missing something?

Marty,
I guess I'm lost. For the Resource Usage view, as long as the Work
field is displayed as a column (static not timescaled), each
resource's total work hours are shown. What am I missing?
John

Jan,
Yes, I understand that but Marty's post said he wanted to show the
total work for each resource and the Resource Usage view does show
that. That's why I'm lost. Maybe you caught something in his post
that I didn't.
John

[John]

Mike,
It might help if Marty, the original poster, checked back in. It seems
you, me and Jan are just talking amongst ourselves. Maybe I should have
assumed that since he (Marty) checked past posts, the answer isn't as
simple as the Resource Usage view itself. Perhaps I oversimplified what
he wanted when I took his example literally ("for each resource, show
the total work"). Without further input from Marty, I would also
probably suggest a VBA solution but depending on his file structure, it
may be possible to use another method.

John

[Jan De Messemaeker]

Hi John,

Copy/Paste:

----------------------
I am looking for a way to create a very simple resource
usage report for summary tasks in a project, using the default format
that MSP2000 provides for resource usage at project level.
----------------------

I've had several customers who asked for that and for one I wrote the VBA
code.
Not elegant, I crtaed an othe rproject with the summaries as tasks.

HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620

Post by John

Post by Jan De Messemaeker
Hi John,
The Resource Usage view does not know summary tasks
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620

Post by John

Post by marty
I have tracked down about three similar posts in the newsgroup going
back to 2002 and wondered if anyone has developed/learned of a
solution: I am looking for a way to create a very simple resource
usage report for summary tasks in a project, using the default format
that MSP2000 provides for resource usage at project level. i.e. for
each resource, show the total work. To further simplify things, i
don't even need the data time phased. It seems like it should be
straightforward - it's just the accumulation of each resource's
individual task assignment work values totaled within the summary
tasks. ? Am i missing something?

Marty,
I guess I'm lost. For the Resource Usage view, as long as the Work field
is displayed as a column (static not timescaled), each resource's total
work hours are shown. What am I missing?
John

Jan,
Yes, I understand that but Marty's post said he wanted to show the total
work for each resource and the Resource Usage view does show that.
That's why I'm lost. Maybe you caught something in his post that I
didn't.
John