Trying to create variation column...

[DerekM]

i want to use the PERT columns to create a variation colum using the
following formula - [ ( Pessimistic - Optimistic ) / 6 ]2
In Project I've added the column and created a formula to pull from
Duration3- Duration1 /6 but can't get the power of 2 to work. If I use ^2 it
gives me a crazy number thats not right.

 

[Jan De Messemaeker]

Have you taken into account that durations are stored in minutes?
HTH

 

[DerekM]

It shouldn't make a difference since you can set option to show in whatever
you want(minute,hour,day,week,month)

Have you taken into account that durations are stored in minutes?
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620

i want to use the PERT columns to create a variation colum using the
following formula - [ ( Pessimistic - Optimistic ) / 6 ]2
In Project I've added the column and created a formula to pull from
Duration3- Duration1 /6 but can't get the power of 2 to work. If I use ^2 it
gives me a crazy number thats not right.

 

[Jan De Messemaeker]

Show, yes, but when it multiplies it by itself, that is internal.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620

It shouldn't make a difference since you can set option to show in whatever
you want(minute,hour,day,week,month)

Have you taken into account that durations are stored in minutes?
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620

i want to use the PERT columns to create a variation colum using the
following formula - [ ( Pessimistic - Optimistic ) / 6 ]2
In Project I've added the column and created a formula to pull from
Duration3- Duration1 /6 but can't get the power of 2 to work. If I

use ^2
it

gives me a crazy number thats not right.