How do I create a "Cumulative Work" column in Project?

[Mark]

 

[JulieS]

Hi Mark,

As far as I know, the Cumulative Work field is only available in the
timescaled portion of the Task Usage or Resource Usage view.

I hope this helps. Let us know how you get along.

Julie

 

[Mark]

Thanks. You just confirmed what I've been busting my brains over. I even
created a numbers column and tried to use Cum. Work in a formula calculation.
I find it hard to believe the information I need is available but I can't
use it in any calculations.

 

[JulieS]

You're welcome Mark and thanks for the feedback. Hope your brain isn't
too hurt

Perhaps there is a method to get the information you are searching for
through VBA, but I'm afraid that isn't my forte. You may try posting
your question with a bit more details in the Project Developer
newsgroup.

Julie

 

[Mark]

Thank you Julie.

I will let you know what I come up with. As for my brain, I haven't seen it
since the directors introduced bean counting 401 (How to be 120% Productive
with no Incentives) (LOL).

Mark

 

[John]

Thank you Julie.

I will let you know what I come up with. As for my brain, I haven't seen it
since the directors introduced bean counting 401 (How to be 120% Productive
with no Incentives) (LOL).

Mark

Mark,
Pardon the interruption but here's a thought. In what context are you
considering cumulative work? For example, the Actual Work field shows
the cumulative work based on the % Work Complete. Does that give what
you want?

John
Project MVP

 

[Jan De Messemaeker]

Hi,

Yes, Cumulative work up to a certain date can be calculated through VBA
(using the timescaledata method). You have to be sur ewhich date you talk
about. Yesterday? Today?. The status date?
HTH

 

[Mark]

Could you send me a sample script for cumulative work today?

 

[Mark]

John,
No it won't. If I allow the program to update it that way I will not be
able to calculate budget with true percentage complete. If I update the
program to 10% complete it will automatically adjust my hours to match up.
Same with schedule. I need to know what the projected schedule is to
calculate where we are currently at. The cumulative hours is my baseline for
Schedule Performance Index.

 

[Jan De Messemaeker]

Hi,

I can send a snippet calculating it on task level

subCumWork
dim Job as task
dim TSV as timescalevalues
For each job in activeproject.tasks
if not job is nothing then
job.number1=0
if not job.start>vba.date then
set tsv=job.timescaledata(job.Start,VBA.Date,pjtasktimescaledcumulativework,
_
pjtimescaledays,1)
Job.Number1=tsv(tsv.count)/(60*activeproject.Hoursperday)
end if
end if
next job
end sub

HTH

 

[John Sitka]

What is Schedule Performance Index?

John,
No it won't. If I allow the program to update it that way I will not be
able to calculate budget with true percentage complete. If I update the
program to 10% complete it will automatically adjust my hours to match up.
Same with schedule. I need to know what the projected schedule is to
calculate where we are currently at. The cumulative hours is my baseline for
Schedule Performance Index.

 

[John Sitka]

got it.
The ratio of Earned Value to plan (PV) is your Schedule Performance Index

 

[Mark]

Thank You.

Hi,

I can send a snippet calculating it on task level

subCumWork
dim Job as task
dim TSV as timescalevalues
For each job in activeproject.tasks
if not job is nothing then
job.number1=0
if not job.start>vba.date then
set tsv=job.timescaledata(job.Start,VBA.Date,pjtasktimescaledcumulativework,
_
pjtimescaledays,1)
Job.Number1=tsv(tsv.count)/(60*activeproject.Hoursperday)
end if
end if
next job
end sub

HTH