Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-15-2015, 04:50 PM
SebastianColombia SebastianColombia is offline How to get some EVM (Earned Value Management) Indicators Windows 8 How to get some EVM (Earned Value Management) Indicators Office 2013
Novice
How to get some EVM (Earned Value Management) Indicators
 
Join Date: Jun 2015
Posts: 3
SebastianColombia is on a distinguished road
Cool 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!!!
Reply With Quote
  #2  
Old 07-01-2015, 05:32 PM
JulieS JulieS is offline How to get some EVM (Earned Value Management) Indicators Windows 7 64bit How to get some EVM (Earned Value Management) Indicators Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
  #3  
Old 07-12-2015, 04:16 PM
SebastianColombia SebastianColombia is offline How to get some EVM (Earned Value Management) Indicators Windows 8 How to get some EVM (Earned Value Management) Indicators Office 2013
Novice
How to get some EVM (Earned Value Management) Indicators
 
Join Date: Jun 2015
Posts: 3
SebastianColombia is on a distinguished road
Thumbs up Project EVM

Quote:
Originally Posted by JulieS View Post
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.
Sir, first of all, thanks for answering to my post!!! The formulas are as follows:

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!!!
Reply With Quote
  #4  
Old 07-13-2015, 02:29 PM
JulieS JulieS is offline How to get some EVM (Earned Value Management) Indicators Windows 7 64bit How to get some EVM (Earned Value Management) Indicators Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
  #5  
Old 07-16-2015, 05:57 AM
SebastianColombia SebastianColombia is offline How to get some EVM (Earned Value Management) Indicators Windows 8 How to get some EVM (Earned Value Management) Indicators Office 2013
Novice
How to get some EVM (Earned Value Management) Indicators
 
Join Date: Jun 2015
Posts: 3
SebastianColombia is on a distinguished road
Default Thanks a lot!!!!

Quote:
Originally Posted by JulieS View Post
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.

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!!!
Reply With Quote
  #6  
Old 07-16-2015, 06:33 AM
JulieS JulieS is offline How to get some EVM (Earned Value Management) Indicators Windows 7 64bit How to get some EVM (Earned Value Management) Indicators Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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

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 12-03-2014 12:08 PM
How to get some EVM (Earned Value Management) Indicators 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 05:25 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft