Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Planned and Earned Value into Project
Wondering if anyone has done any formulas for either Planned Value (PV), Earned Value (EV), into their SS projects? I have all the costing,tasks, opex/capex.%Complete,dates.. in my projects and this would be my next step 
Comments
-
Tom,
I am looking for the exact same thing - ie how to show earned value of projects with Smartsheet.
Both schedule and cost.
And generate the curve for reporting.
Let me know if you find anything and I will do the same.
Rob
-
HI Robert,
Good day and thanks for your interest. I have done some of the following work so far..
-Already have my main budget at Completion (BAC)
-My Actual cost numbers come from a weekly report (AC)
-My SS project auto calulates the % Completed
-I created a formula for my Earned Value (EV) %Complete * BAC Example: .50 * $20,000 = $10,000
Still working the more complicated formulas
, Thanks, Tom -
Tom,
Got it and thanks for the reply.
For an Earned Value curves:
Cost Variance is CV = BCWP - ACWP
Schedule is similar with SV = BCWP - BCWS.
Are these typically plotted on the same curve, or 2 separate curves?
I am starting from scratch - did you find a excel or other spreadsheet which can graphically take th evalues and display to a Earned Value Curve?