Earned value

Øystein Wikeby

Is there a reasonably easy way to track earned vs planned value with Smartsheet?

Robin Sherwood

So I have set this up in the following way. 

 

I have project sheets for each of my schedules and then I create a separate sheet for the EVM portfolio using a combination of cell links and Formulas. In each project schedule I have an overall summary row that gives me the Start, Finish and % Complete of the entire project. These get linked into the portfolio view. 

 

Here is what my portfolio sheet looks like. I show the generic formula under the values for each column. I had to split the row into two images so that it was readable. Sorry. Hopfully you get the idea. 

 

  

 

Hope that helps, 

 

Robin

Øystein Wikeby

Thanks!

Joel Webley

Interesting technique.  Any plans to add this functionality in future updates?

Kevin Phillips

I took a slightly different approach to track the complete earned value metrics for each task as it relates to the original start/finish dates, the actual start/finish dates, the planned durationand the % allocation. It is looking at costs to perform each tasks. We currently do not have a way to determine actual labor costs for each task, so we have to estimate an hourly rate and go from there. It allows us to get ballpark on labor costs, but it does allow a fairly accurate SPI and CPI, which helps with schedule analysis. We are in the early stages of use and are working out a few kinks, but so far so good.

 

I've requested this feature of Smarsheet before, but it didn't take too long for me to add the proper calculations. It would be nice to have this as part of the product thought.

 

 

Brian@Presidio

Hi All, I see these posts several years old, but I was wondering if Kevin, or anyone else has a template they wouldn't mind sharing for EVM?