Smartsheet SPI

Fran Warner

Has anyone developed a project schedule in smartsheet that calculates SPI?  If you have, would you be willing to share?

Ted Cochran

Hi Fran,

 

I do have an example sheet, but it has a lot of advanced functionality in it that you may not need.  Calculating SPI can be pretty simple though.

 

In essence, if you have a budget column in addition to your % Complete column, you can calculate the EV (earned value) for the project overall through rollups.  Once you multiply the weighted average of the % Complete (the top level of your project calculates this already if used in project settings) by the total budget for the project.

 

Then calculate Planned Value by multiplying the Total Budget by the percentage of tasks that have been assigned dates.  (Or you could simply assume that everything is already planned and use the Total Budget).

 

Then divide your Earned Value by your Planned Value, and voila!  You have your Schedule Perfomance Index.  This basically is a weighted average of the percent complete based on the planned cost.

 

Let me know if you need more detail, or if this isn't quite what you were looking for.

 

 

Fran Warner

• Thanks for the explanation and for replying.  What would be even more awesome is if I could get a copy of your worksheet.  If I "see" how to do it, I can replicate what I need on my end.  If you're willing to share, my email is fwarner@govstrive.com

 

Many thanks...