#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 (To-Complete 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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to hide comments and comment indicators from OTHERS | Elena A | Excel | 0 | 12-03-2014 12:08 PM |
Copying indicators from project to excel | Raviwildcat | Project | 3 | 04-13-2014 07:39 AM |
Graphical Indicators customisation | Guloluseus | Project | 5 | 03-03-2014 06:06 PM |
Is there any way of importing Indicators field through code? | Prabhakar | Project | 0 | 04-07-2011 05:50 AM |
Can I import custom graphical indicators? | Steve Sells | Project | 4 | 04-07-2011 05:11 AM |