([Finish Variance]/ ProjDateDiff(Phase Start,Phase Finish))

[RixMcx]

Obviously this ([Finish Variance]/ ProjDateDiff(Phase Start,Phase Finish))
does not work because I can't figure out how to capture Phase start and
finish in the formula. I want to report on indivdual phase health by
comparing Finish Variance to phase duration.

This alternative ([Finish Variance]/(ProjDateDiff([Project
Start],[Finish]))*100) works but I would like to use the phase. Something
like;

IIf([name]= "Design Phase" and [SubTask]="Design Phase",[Finish Variance]/
ProjDateDiff(Phase Start,Phase Finish,IIf([name]= "Test Phase" and
[SubTask]="Test Phase",[Finish Variance]/ ProjDateDiff(Phase Start,Phase
Finish,

and so on.

 

[Andrew Lavinsky]

Assuming your phases are all the top level summary tasks, I would do some
custom field which flags Outline Level 1 tasks. I don't have Project open on
my current computer, but something like:

IIF([Outline Level]=1,IIF([Milestone]=No,Round([Finish
Variance]/[Duration]*100,0),""),"")&"%"

In a spare text field.

Although, a better measure of variance would be Finish Variance / Baseline
Duration.

 

[RixMcx]

Andrew. I did not get the result I was after. I s their a way to create a
custom date column to show [Phase Start] and another for [Phase Finish]. I
want all the sub tasks in their phase to show their Phase Start in the custom
column.

thanks

Assuming your phases are all the top level summary tasks, I would do some
custom field which flags Outline Level 1 tasks. I don't have Project open on
my current computer, but something like:

IIF([Outline Level]=1,IIF([Milestone]=No,Round([Finish
Variance]/[Duration]*100,0),""),"")&"%"

In a spare text field.

Although, a better measure of variance would be Finish Variance / Baseline
Duration.

Obviously this ([Finish Variance]/ ProjDateDiff(Phase Start,Phase Finish))
does not work because I can't figure out how to capture Phase start and
finish in the formula. I want to report on indivdual phase health by
comparing Finish Variance to phase duration.

This alternative ([Finish Variance]/(ProjDateDiff([Project
Start],[Finish]))*100) works but I would like to use the phase. Something
like;

IIf([name]= "Design Phase" and [SubTask]="Design Phase",[Finish Variance]/
ProjDateDiff(Phase Start,Phase Finish,IIf([name]= "Test Phase" and
[SubTask]="Test Phase",[Finish Variance]/ ProjDateDiff(Phase Start,Phase
Finish,

and so on.

 

[Andrew Lavinsky]

If I understand you correctly, then you want each subtask finish variance
to measure against the the summary task duration?

That's a bit hard to do, but the easiest way would be:

1) Develop your schedule
2) Create a custom Duration field for each phase. In the formula, simply
set the Duration1/2/3 equal to the calculated duration of each summary task.
3) Create a second custom field which calculates the Finish Variance/Duration1

The hard part is to track one field against data calculated in another field.

Alternately, you could do what you're looking for using VBA, but not sure
if that would be easier or harder.

I guess the main question is "why?" I don't think I've seen anyone track
a project using that kind of metric.


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Andrew. I did not get the result I was after. I s their a way to
create a custom date column to show [Phase Start] and another for
[Phase Finish]. I want all the sub tasks in their phase to show their
Phase Start in the custom column.

thanks

Assuming your phases are all the top level summary tasks, I would do
some custom field which flags Outline Level 1 tasks. I don't have
Project open on my current computer, but something like:

IIF([Outline Level]=1,IIF([Milestone]=No,Round([Finish
Variance]/[Duration]*100,0),""),"")&"%"

In a spare text field.

Although, a better measure of variance would be Finish Variance /
Baseline Duration.

Obviously this ([Finish Variance]/ ProjDateDiff(Phase Start,Phase
Finish)) does not work because I can't figure out how to capture
Phase start and finish in the formula. I want to report on
indivdual phase health by comparing Finish Variance to phase
duration.

This alternative ([Finish Variance]/(ProjDateDiff([Project
Start],[Finish]))*100) works but I would like to use the phase.
Something like;

IIf([name]= "Design Phase" and [SubTask]="Design Phase",[Finish
Variance]/ ProjDateDiff(Phase Start,Phase Finish,IIf([name]= "Test
Phase" and [SubTask]="Test Phase",[Finish Variance]/
ProjDateDiff(Phase Start,Phase Finish,

and so on.

 

[RixMcx]

Thanks Andrew, yes you understand correctly(what I am trying to do). I think
VBA is the way to go. Do I need to create a user defined function or would a
conditional statement work?. I have worked with VBA in Access and Outlook.
Would I declare "Name" And "Duration" and then extract the value AS Phase
duration? I am a bit rusty in VBA.

As for why I am trying to do this; I wanted to demonstrate different ways
of displaying project health, good methods as well as poor methods.
Basically it has become a challenge and I would like to finish what I have
started. thanks for your help.

Rick

If I understand you correctly, then you want each subtask finish variance
to measure against the the summary task duration?

That's a bit hard to do, but the easiest way would be:

1) Develop your schedule
2) Create a custom Duration field for each phase. In the formula, simply
set the Duration1/2/3 equal to the calculated duration of each summary task.
3) Create a second custom field which calculates the Finish Variance/Duration1

The hard part is to track one field against data calculated in another field.

Alternately, you could do what you're looking for using VBA, but not sure
if that would be easier or harder.

I guess the main question is "why?" I don't think I've seen anyone track
a project using that kind of metric.


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Andrew. I did not get the result I was after. I s their a way to
create a custom date column to show [Phase Start] and another for
[Phase Finish]. I want all the sub tasks in their phase to show their
Phase Start in the custom column.

thanks

Assuming your phases are all the top level summary tasks, I would do
some custom field which flags Outline Level 1 tasks. I don't have
Project open on my current computer, but something like:

IIF([Outline Level]=1,IIF([Milestone]=No,Round([Finish
Variance]/[Duration]*100,0),""),"")&"%"

In a spare text field.

Although, a better measure of variance would be Finish Variance /
Baseline Duration.

:

Obviously this ([Finish Variance]/ ProjDateDiff(Phase Start,Phase
Finish)) does not work because I can't figure out how to capture
Phase start and finish in the formula. I want to report on
indivdual phase health by comparing Finish Variance to phase
duration.

This alternative ([Finish Variance]/(ProjDateDiff([Project
Start],[Finish]))*100) works but I would like to use the phase.
Something like;

IIf([name]= "Design Phase" and [SubTask]="Design Phase",[Finish
Variance]/ ProjDateDiff(Phase Start,Phase Finish,IIf([name]= "Test
Phase" and [SubTask]="Test Phase",[Finish Variance]/
ProjDateDiff(Phase Start,Phase Finish,

and so on.

.

 

[Andrew Lavinsky]

You'd be best off posting this in the Developer Group. When you do, specify
that you want to roll summary task data down to the subtask level. That
should get you an answer pretty quickly.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

 

[RixMcx]

I gave it a shot but I am definately missing something. When I try to
compile I get "missing for without next"

Sub GetPhaseDuration()

Dim start As Date
Dim Finish As Date
Dim PhaseDuration As Integer

For Each Task In active.Project.Tasks
If Task.Summary Then
PhaseDuration = Task.Summary.Duration
End If
If Not Task.Summary Then
PhaseDuration = 0


End If
End Sub

If I understand you correctly, then you want each subtask finish variance
to measure against the the summary task duration?

That's a bit hard to do, but the easiest way would be:

1) Develop your schedule
2) Create a custom Duration field for each phase. In the formula, simply
set the Duration1/2/3 equal to the calculated duration of each summary task.
3) Create a second custom field which calculates the Finish Variance/Duration1

The hard part is to track one field against data calculated in another field.

Alternately, you could do what you're looking for using VBA, but not sure
if that would be easier or harder.

I guess the main question is "why?" I don't think I've seen anyone track
a project using that kind of metric.


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Andrew. I did not get the result I was after. I s their a way to
create a custom date column to show [Phase Start] and another for
[Phase Finish]. I want all the sub tasks in their phase to show their
Phase Start in the custom column.

thanks

Assuming your phases are all the top level summary tasks, I would do
some custom field which flags Outline Level 1 tasks. I don't have
Project open on my current computer, but something like:

IIF([Outline Level]=1,IIF([Milestone]=No,Round([Finish
Variance]/[Duration]*100,0),""),"")&"%"

In a spare text field.

Although, a better measure of variance would be Finish Variance /
Baseline Duration.

:

Obviously this ([Finish Variance]/ ProjDateDiff(Phase Start,Phase
Finish)) does not work because I can't figure out how to capture
Phase start and finish in the formula. I want to report on
indivdual phase health by comparing Finish Variance to phase
duration.

This alternative ([Finish Variance]/(ProjDateDiff([Project
Start],[Finish]))*100) works but I would like to use the phase.
Something like;

IIf([name]= "Design Phase" and [SubTask]="Design Phase",[Finish
Variance]/ ProjDateDiff(Phase Start,Phase Finish,IIf([name]= "Test
Phase" and [SubTask]="Test Phase",[Finish Variance]/
ProjDateDiff(Phase Start,Phase Finish,

and so on.

.