Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


How to calculate BCWS and BCWP and CV based on the information saved in Baseline 1

Posted on 2011-04-24
Medium Priority
Last Modified: 2013-11-15
I need to be able to compare various schedules in my project plan, one of which includes the BCWS and BCWP based on the Schedule I saved in baseline 1.  And then, also to be able to see the variance based on Baseline 1 vs. Actual (aka CV in MS Project).  Do I need to build a macro for this, since I haven't seen such an option in MS Project, and if the answer is yes, what would be the code that would apply in this case.  MS Project only provides the BCWS and BCWP based on the baseline schedule not on baseline 1 schedule.
Question by:pmcoordinator
  • 2
  • 2
LVL 12

Expert Comment

by:Dr. Thomas Henkelmann
ID: 35474865

this depends on the version of MSP you are using:

For the 2010 version you can select the baseline for EVA in the options at File..Options..Advanced..Earned Value Options.
For 2007 you find the same in Tools..Options..Calculation..Earned Value



Author Comment

ID: 35484304
Yes, that works.  My question now is, what if I want to see the EVA caclulations based on baseline and baseline 1 all in one view at the same time, so I can compare the numbers.  Is that possible, or I can only view that for one baseline at a time.  

LVL 12

Accepted Solution

Dr. Thomas Henkelmann earned 1500 total points
ID: 35485016
That's probably the issue here. You need to select either Baseline OR Baseline1 as your base for EV calculation. Finally there is only ONE BCWP and BCWS field (also timephased data) and this is set in the options to pull from the selected baseline.

Or do you just need to compare baseline vs baseline1 and see BCWP with these?

Author Closing Comment

ID: 36008175
the exact answer for this question was not provided.

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

At the office, we’ve started to get serious about organizing what we’re doing. I mean, it was getting to the point where every time I received a phone call, it began with “I know you’re really busy, but…” My boss was taking tasks away from me left a…
Article by: x-men
Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question