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

Posted on 2011-04-24
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
    LVL 12

    Expert Comment


    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

    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

    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

    the exact answer for this question was not provided.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    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.
    Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    733 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

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now