Total Cumulative Actual Work

N

Natalia

Hi,

I was wondering how in MSP 2002 I can get the Total
Cumulative actual work? By using analyze timescale data,
I can get the total cumulative work but I would also like
to get the cum. of actual work. Is that feasible?

Thank you,

Natalia
 
J

John Beamish

Step 1: show the Project Summary Task

Click on Tools | Options | View-tab and make certain there is a check mark
in "Show Project Summary Task".

Step 2: show Actual Work
Click on the column heading to select the entire column; press the <Ins> key
and select the "Actual Work" column.

The "Actual Work" in the Project Summary Task is the cummulative total of
all actual work.

JLB, PMP
 
N

Natalia

That works for the total of the project from beginning to
end. Is it possible to have the cumulative actual work
per month?

Thanks again,

Natalia
 
G

Gérard Ducouret

Nathalia,
No, I'm afraid. But you can display the Cumulative Work :

Use the Task Usage view : View / Task Usage
Instead of the Work field which is displayed by default, you'll display the
Cumulative Work field :
Right Click on a yellow cell, choose Cumulative Work

Gérard Ducouret
 
J

John Beamish

Not directly. The best I can come up with is:

1. Click on View | Resource Usage
2. Click on the Analyze Timescaled Data in Excel button (on the Analysis
toolbar)
3. In step 2 of the wizard you can choose the fields you want to see.
"Work" is already included in the export; add Actual Work and Cummulative
Work
4. In step 3 choose Months
5. When you finish the wizard it will take a few moments as it generates an
Excel spreadsheet.

6. In the spreadsheet you will have each resource and three lines for each
resource (Work, Actual Work, Cumulative Work). Now you have to do some
"grunt" work. The Actual Work cells contain Actual Work on a _monthly_
basis, not a cumulative basis. In the "Cumulative Work" cells create a
formula that sums in a cumulative fashion the Actual Work cells.

When I did it, I created the formula for the first "Cumulative Work" line
and then copied it and pasted it into each successive "Cumulative Work" line
and Excel made the necessary changes so that the formula referenced the
correct cells. It took me -- at most -- 2 minutes to do a complex plan
(150+ resources).

7. At the bottom of your spreadsheet, create a formula that does sums the
cumulative work for each month.

The nice thing about this approach is that you could also choose to export
costs and see how they are progressing, too. The "un-nice" thing is that
you'll have to do a bit of typing.

JLB, PMP
 
Top