How can I calculate the expected progress?

[Homero González Abarca]

Hi,
Is there an existsing field or a way to customize an enterprise field
formula to calculate the progress that the project should have at the
current date?

Up to now I have created a formula that calculate the expected progress
based on how many days have elapsed since the project started and how many
days are left until the end date. This formula doesn't take in consideration
the distribution of the tasks along the project.

For example, the formula should show different results for a 5 day project
that only have a single task to a project that in addition to have a 5 day
task have 3 more tasks each one of 1 day all of them ocurring in parallel
and starting at the first day of the project. The expected results of the
formula if we were located at the end of the third day of the project,
should be, for the first project 60% and for the second should be 75%.

Is there a way to create this type of formula?

Thanks in advance,
Homero.

 

[Gary L. Chefetz \(MVP\)]

Homero:

Baselining a project povides this functionality. Once you set a baseline,
the dates of what should have been are etched in stone until you change
them. All of the variance fields in Project are calculated from the baseline
values. You can show baseline against actual and vairance from baseline
throughout the application.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-