How to Forecast EVM data post status Date in Project server 2016? RRS feed

  • Question

  • Hi,

    I am currently using Physical%Complete method for EVM in MPP and on detailed analysis we understood that MPP doesn't calculate EVM correctly with Physical%Complete. So, as a workaround we are calculating the EVM data using SQL Procedure which resembles the calculation when MPP uses %Complete. We were successful in calculating the values till Status date. But the problem is we also need to forecast the trend in which the EVM data changes after the status date and till the project end date(estimated). My issue is I am unable to find formulas to forecast the data post the status date.

    I do have the formulas to calculate EAC,ETC,VAC. but all these give only the value at completion. My requirement is to calculate the periodic values of EVM data in the range between status date and Project end date(estimated)?

    Below Link has the formulas for EAC, ETC,VAC: 

    FYI, we are currently using MS Project Server 2016 with MPP 2016.




    Wednesday, November 15, 2017 4:00 AM