How to calculate weekly total

[FiachraFiachra]

Hi,
Has anyone a way of showing on the usage table a total for the
combined resources on a weekly basis?
Basically, what I have is a table of all resources using peak units
and require a weekly total on this at the base of the table eg:

1 CARPENTER +C 1,823hrs 1 1 2 3 3
5 5 5
2 JOINER +j 567hrs 1 4
4 3
..
..
..
..
(Here i want TOTAL) (1) (2) (6)
(7) .........................

any suggestions...?

 

[John]

Hi,
Has anyone a way of showing on the usage table a total for the
combined resources on a weekly basis?
Basically, what I have is a table of all resources using peak units
and require a weekly total on this at the base of the table eg:

1 CARPENTER 1,823hrs 1 1 2 3 3 5 5 5
2 JOINE 567hrs 1 4 4 3
.
.
.
.
(Here i want TOTAL) (1) (2) (6)
(7) .........................

any suggestions...?

Fiachra,
The only way to get the exact format you want is to use VBA to export
the data to another application (e.g. Excel). As an alternative you
could try the "Analyze timescale data in Excel" utility found on the
Analysis toolbar. Run it from the Resource Usage view.

However, you can get a report that will be very close to what you want
by setting the timescale on the Resource Usage view to be weeks. The
format in your post doesn't come through very well when I view it so I
don't know exactly what is being summed up but you might need to also
use Project's grouping function (Project/Group by/Customize Group by).

Hope this helps.
John
Project MVP

 

[FiachraFiachra]

Thanks John! very helpful altogether...

Fiachra

 

[John]

Thanks John! very helpful altogether...

Fiachra

Fiachra,
You're welcome and thanks for the feedback.
John