% Complete Forecast to Future Date

Matthew Berg

Is there a way to project a POC (Percentage of Completion) to a certain Date?

The assumption is that the baseline schedule has been vetted, and agreed upon.

What I would want to do is forecast for example what the POC would be to the end of the Month, or to the end of the Next Month - I'm at May 30th right now, so I can recognize what is is now (say 8%) but I'm being asked to forecast where the project will be on June 30th and July 31st.

Paul Newcome

You would use something like this...

(DATE(date_you_want_to_project_to) - [Start Date]@row) / ([End Date]@row - [Start Date]@row)

jwnek

Paul,

How would you modify this formula to show a "weighted" percent complete, by month (or a specific date).

So I would like to show a projection, of what the expected weighted percent complete will be.

I would like to show this for the future 24 months of the project.

Thanks in advance.

jwnek

📈