Measuring Schedule variance without Earned Value RRS feed

  • Question

  • My client wants to measure the Project schedules only and they don't want to measure cost by work schedules and work performed and they don't put resources on tasks. They just update % complete value for individual tasks. Can anybody tell me how can we calculate schedule variance as of specific date. I need to incorporate schedule variance as of today in an excel report. Do I need to force them to at least put one dummy resource for every task so that it calculates work and actual work? Pardon me of any earned value concept issue.


    From Microsoft Forums
    Friday, October 21, 2011 9:53 AM


  • Hello Adil,

    If the customer is open to creating resources will $1 (or local currency) rate per hour and then assigning the resources to tasks, you can use the earned value calculations.

    However, there are other measures that may be of use -- finish variance is the comparison of baseline finish to current finish -- this will let them see how far ahead/behind schedule they are as of the tracking date.  Work variance and duration variance are also all ready calculated for project files with baselines saved.

    You may also find a white paper written by Jim Askel (MVP) very helpful.  See:

    and Jim's blog:

    I hope this helps.


    Friday, October 21, 2011 10:30 AM