Customizing Enterprise Fields for Computing %Finish Variance

[Nitesh]

Hi Friends
I’m using Project professional 2003 and need to customize some fields to
calculate Finish Variance & % Finish Variance upto 10, for some analysis
purpose.

The formula which I’m using is:

• Finish Variance 1, Finish Variance 2 to Finish Variance 10– Global Custom
filed to be created w.r.t. the equation (Finish Date – BaselineN Finish Date)
where N=1,2,…10 based on internally baselined information.
• % Finish VarianceN = (Finish VarianceN)/(BaselineN Duration)

Details about fields:
1. Finish Variance1 is Enterprise Number 1 field and same is upto Finish
Variance10 is Enterprise Number 10. And the formula which I have used is same
is mention above.
2. % Finish VarianceN is Enterprise NumberN field.

Problem:
Finish Variance1……..Finish Variance10 shows correct value but %Finish
Variance not display correct value. I think I’m using two different values (
Finish Variance as Number & Baseline Duration as Duration field) or may be
using wrong filed type (Enterprise / Custome fileds) for calculation. May be
I’m wrong but need your help to correct it.

This is required because of doing some analysis by Sr. Management.

 

[Jonathan Sofer [MVP]]

Nitesh,

Be aware that duration is stored as working minutes per day. In most cases
this is 8 hrs x 60 min = 480. You must therefore account for this in your
calculations. Try dividing your Baseline Duration by 480 before you divide
your Finish Variance by it.

For future reference, I find it easier to break down each element of my
formula calculations first to verify I am getting the desired results before
putting it all together.

Jonathan

 

[Nitesh]

Thanks Jonathan, its working.

 

[Nitesh]

HI Jonathan

One more query:
Is it possible to display Finish Variance 1...10 (Enterprise custom
fileds)fields in days unit like Finish Variance field. If yes then please
what is a Function or Formula used for?

 

[Jonathan Sofer [MVP]]

Nitesh,

You will need to change your custom enterprise field from using a Number
type to using a Duration type if you want it to show days in the value
label. Then you will need to change your formula to read:

=ProjDateDiff([BaselineN Finish],[Finish],[Project Calendar])

where N is your respective baseline number.

This will give you a duration difference based on the project calendar. If
your project calendar is the standard one then it will ignore weekends.

Hope this helps,

Jonathan

 

[Nitesh]

Thank you soo much Jonathan, it's realy works.
--
------------------------------
Thanks
Nitesh
------------------------------

Nitesh,

You will need to change your custom enterprise field from using a Number
type to using a Duration type if you want it to show days in the value
label. Then you will need to change your formula to read:

=ProjDateDiff([BaselineN Finish],[Finish],[Project Calendar])

where N is your respective baseline number.

This will give you a duration difference based on the project calendar. If
your project calendar is the standard one then it will ignore weekends.

Hope this helps,

Jonathan

HI Jonathan

One more query:
Is it possible to display Finish Variance 1...10 (Enterprise custom
fileds)fields in days unit like Finish Variance field. If yes then please
what is a Function or Formula used for?

--