SV in days

[Alexander Barvinsky]

Greetings,
I'm trying to calculate SV in form of "hours". Algorythm:
if [SV] <> 0 then calculate [SV]/ cost rate of resource, assigned to the
current task.
Where I can find cost rate of current task?
All this I want to calculate in Ent.Field
Any other ideas?
I would appreciative for any advises


Alerxander Barvinsky
Director of Operations Department

 

[John]

Greetings,
I'm trying to calculate SV in form of "hours". Algorythm:
if [SV] <> 0 then calculate [SV]/ cost rate of resource, assigned to the
current task.
Where I can find cost rate of current task?
All this I want to calculate in Ent.Field
Any other ideas?
I would appreciative for any advises


Alerxander Barvinsky
Director of Operations Department

Alexander,
Have you though about using the Start Variance field itself? It will
show the variance in hours if you set Tools/Options/Schedule "Duration
is entered in", to "Hours".

Nonetheless, resource pay rates are available via the Pay Rates
Collection Object (accessible through VBA only).

Hope this helps.
John
Project MVP

 

[Bill Bordiuk]

SV is stored in minutes like any other duration. SV / 60 = SV in hours, (SV
/ 60) / ActiveProject.HoursPerDay gives it to you in days (unless someone
mucked around with the project calendar).

Bill B.