Reporting on total work for a specific task(s) predecessors

[dubosejh]

Does anyone know how to view/report on the work value of the
predecessors for a specific task.

I simply want to view the value for work for each of the predecessors
of a task and possible see that added up into something like "total
work for predecessors".

The WBS used represents the Component, Sub component, etc. of a major
piece of software. However, the dependency network spans the tasks
within those Components, sub component, etc., so it is not an option
to created a WBS that matches the predecessor network.

Thanks

 

[davegb]

Does anyone know how to view/report on the work value of the
predecessors for a specific task.

I simply want to view the value for work for each of the predecessors
of a task and possible see that added up into something like "total
work for predecessors".

The WBS used represents the Component, Sub component, etc. of a major
piece of software. However, the dependency network spans the tasks
within those Components, sub component, etc., so it is not an option
to created a WBS that matches the predecessor network.

Thanks

A VBA macro would be the only way I can think of to do that.

 

[Jack Dahlgren]

VBA is probably the only way, and you would have the issue of potential
double counting.
For example if one of the predecessors had two successors, you would count
it (and all of its predecessors) for each of those tasks. Also, how many
levels back would you go?

Perhaps could code them using an outline or text field and then group by
them?

If you can be more specific on why you want to do this and what you expect
out of it, perhaps someone here can propose a better way of achieving that
result.

-Jack Dahlgren