Earned Value Analysis (EVA)

Greetings Smartsheet Community:

Has anyone Created a Template for EVA?

Best Answer

  • DW1
    DW1 ✭✭✭✭
    Answer ✓

    @Kaleb providing the template is a bit beyond the scope of this comment thread.

    In short you'll need to establish baseline budget and schedule columns and have those auto-calculate progress as time elapses. This drives your EVM metrics and forecasts as you apply updates to your schedule in terms of progress, effort worked, and current timelines. You will need to ensure that your parent tasks are rolling up the effort correctly to avoid bad '% planned complete' results. Every EVM metric is derived from the result of comparing the below columns.


Answers

  • DW1
    DW1 ✭✭✭✭

    Yes. What specific EVM measurements are you looking for?

  • Kaleb
    Kaleb ✭✭✭✭✭

    EV

    PV

    CV

    SV

    SPI

    CPI

    VAC

    ETC

  • DW1
    DW1 ✭✭✭✭
    Answer ✓

    @Kaleb providing the template is a bit beyond the scope of this comment thread.

    In short you'll need to establish baseline budget and schedule columns and have those auto-calculate progress as time elapses. This drives your EVM metrics and forecasts as you apply updates to your schedule in terms of progress, effort worked, and current timelines. You will need to ensure that your parent tasks are rolling up the effort correctly to avoid bad '% planned complete' results. Every EVM metric is derived from the result of comparing the below columns.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!