% 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

📈

LCrane

Hi @jwnek Did you receive a response to your last message? I am looking for this as well. Thank you@

jwnek

Hello, I did not receive a response to my question yet, sorry. Still have not been able to create a formula that works, to forecast a weighted percent complete.

If you have any luck, please let me know.

Sandy Drew

Hello, I used something similar to this formula for a client before. They utilized an Expected % Complete column to compare against their actual % complete. (C@row is a simple count(children()) formula helper column)

=IFERROR(IF(C@row > 0, AVGW(CHILDREN([Expected Completion %]@row), CHILDREN(Duration@row)), IF(TODAY() < Start@row, 0, IF(TODAY() >= Finish@row, 1, (NETWORKDAYS(Start@row, TODAY()) / Duration@row)))), "ERROR")