#1




How to get some EVM (Earned Value Management) Indicators
First of all good morning/afternoon/ evening as the case may be:
I have been working the EVM (Earned Value Management) methodology in MS Project and I've been able to get several indicators, such as: Planned Value (PV),*Earned Value (EV),*Actual Cost (AC),*Cost Variation (CV),*Schedule Variation (SV),*EAC (Estimate at Completion), Variation at Completion (VAC), Budget at Completion (BAC), Cost Performance Index (CPI), TCPI (ToComplete Performance Index) and Schedule Performance Index (SPI). However I haven't still been able to find how to get the following indicators: Time Estimate at Completion (EACT), Estimate to Complete (ETC) and CPIxSPI. my question is: Can I get these indicators in any view?? or do I have to calculate them via a calculated field??? I'd really appreciate if you can help me. Thanks a lot!!! 
#2




Hi Sebastian,
If you know the formulas to calculate those values you can calculate them in spare (custom) fields. If you could share the formulas, I'll try to be more helpful walking you through the process. 
#3




Project EVM
Quote:
Time Estimate at Completion (EACT): (BAC/SPI) / (BAC/months) where BAC is Budget at Completion and SPI Schedule Performance Index. [B]Estimate to Complete: EAC AC where EAC is Estimate at Completion and AC is Actual Cost of Work Performed) [B]SPIxCPI: Just the multiplication of these two values. I'd really appreciate if you could help me with this!!! Thanks sir!!! 
#4




You're welcome. I'm not a "sir" but rather Julie  a Ma'am if you must
All of the earned value data (with the exception of SPI and CPI) are in cost terms. So, you can use some of the spare cost fields (Cost1, Cost2) as needed to perform the calculations. Add the field to a table (left side of the view) and then right click on the column heading and select "Custom Field". Click the option for Formula and enter the formula. For example for BAC  the formula would be [EAC][AC] Field names are enclosed in square brackets. For multiplication use * instead of x. 
#5




Thanks a lot!!!!
Quote:
I'd rather call you Julie!!! thanks a lot!!! Thanks for answering my questions!!! So, I'm going to insert those fields via calculated fields!!! Thanks!!! 
#6




You're welcome. Post back if you have any further questions.

Tags 
eact, estimate to complete, evm 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
How to hide comments and comment indicators from OTHERS  Elena A  Excel  0  12032014 12:08 PM 
Copying indicators from project to excel  Raviwildcat  Project  3  04132014 07:39 AM 
Graphical Indicators customisation  Guloluseus  Project  5  03032014 06:06 PM 
Is there any way of importing Indicators field through code?  Prabhakar  Project  0  04072011 05:50 AM 
Can I import custom graphical indicators?  Steve Sells  Project  4  04072011 05:11 AM 