5 Things to Know about Microsoft Project Baselines

The baseline — whether it be about the schedule, the budget, or the scope — is essential in projects. Without it, you have no way to measure the performance of your work. But there may be a few things you don’t know about baselines in Microsoft Project. In this article, I share five facets of baselines worth adding to your mental knowledgebase. Although I’ve taken the images from Project 2016, the same techniques I cover here can be reproduced with Project 2010 and Project 2013.

  1. There are 11 Baselines

In Project setting a baseline is easy. You select the ribbon tab “Project” and in the “Schedule” group select “Set Baseline” and then select “Set Baseline.”

Setting a Project Baseline in Microsoft Project
Setting a Project Baseline in Microsoft Project

A new menu opens and gives you the option to set the baseline for just a selection of tasks or the whole schedule in total. Pressing OK without changing any of the settings will set the baseline, and you’re done.

But, you can do more. Here’s a screenshot when you open the dropdown arrow beside Baseline:

Setting a Project Baseline in Microsoft Project

You have the chance to set up to 11 baselines for your schedule. It might also be nice to know what the baseline saves for you. Here’s the list of fields that are saved, with “Baseline #” in front of it:

Setting a Project Baseline in Microsoft Project
  1. Only One Baseline Works with Earned Value Management

It’s a good thing that you can save more than just one baseline. Just think about scope changes. You may end up wanting to save Baseline 1, 2 or 3… (More on that in tip #4.)

But keep in mind, only “Baseline” — the first baseline, which doesn’t have a number — works together with the earned value management functionality within Microsoft Project!

You’ll need to use the first baseline if you intend to work with EVM and want to use Project to get a good sense of your planned value (PV), actual cost work performed or actual costs (ACWP/AC) and schedule variance (SV). All the EV items work with either the actual schedule or the information from the first baseline.

  1. You Can Show Any Baseline with This Simple Trick

There are a couple of views with baseline already available to you when you have done nothing in regards to customization. The most notable view is the Tracking Gantt.

Setting a Project Baseline in Microsoft Project

The Tracking Gantt is a great way to visualize progress on your schedule for several reasons:

  • It contains a visual on percent complete (also for summary rows and the project summary row);
  • It shows the critical path in red; and
  • It shows the baseline (but only the baseline).

The last reason gives us food for thought. Can we show a schedule and compare it with Baselines 1 through 10? You might want to do this for a lessons-learned session, for instance, where you’d decompose the schedule and review where things went wrong and could be improved or where things went very well. If a schedule had three scope changes, you might be interested to see the gap between the original schedule and the finished product. That way you could generate a view on how good or bad your project managers are in their estimations. (Don’t get me wrong; the consensus is that we all really stink at estimating! Wouldn’t it be nice to be reminded of it on a regular basis?)

So how do you show the other baselines? It’s easy! In the newer versions (2010 and up) there’s an option in the contextual tab, Gantt chart tools | Format, in the ribbon.

Setting a Project Baseline in Microsoft Project

The option is called Baseline, and it’s available from the group, Bar Styles. Here you have a dropdown giving you the option to show every baseline compared to the current Gantt view. For instance, I made a new baseline (Baseline number 1) with the schedule I showed earlier, and here’s the resulting Tracking Gantt view:

Setting a Project Baseline in Microsoft Project

While this may look like the same picture as above, it shows Baseline1 instead of “Baseline.” Take a closer look at the darker bars underneath the actual schedule. You can now switch between the baselines to compare them.

If you’d like to see the different baselines together, here’s an image from a guest post done by Bonnie Biafore on my blog.

Setting a Project Baseline in Microsoft Project
  1. You Should Set up Two Baselines Each Time

Back to the scope changes, because there’s something to keep in mind here. Whenever you have a change in scope, you might like to compare the actual schedule to the current approved budget and timeline, right? That means you set a new baseline and work with that baseline in your progress reports.

Again, the thing you need to keep in mind is that you’ll have to use “Baseline” for earned value management.

So, when you change the baseline, you’ll overwrite that one to make your calculations reliable. But you’ll also want to retain the original baseline for your lessons-learned sessions. That’s why I suggest you create not one but two baselines every time you have a schedule approved by management or your client. This is how I would suggest you proceed:

[table id=37 /]

With this technique you never have to wonder about which baseline you should pick in the Tracking Gantt because you have the right one there already. And your EVM measurements will still be correct.

  1. You Can Lock Six Baselines if You Use Project Server or Project Online

If you’re using Project together with the server installment (EPM 2007, EPM 2010, PPM 2013, PPM 2016 and Project Online), you’re in luck! There’s even more baseline magic you can tap into.

If your organization needs reports that contain baseline information in a structure set by the enterprise project management office or something similar, there might be a reason to lock those baselines from random changes! You can do this for the first six baselines — meaning, Baseline and Baseline 1 through 5. In this way you could create a permissions structure. The PMO would have the authority to set the locked baseline using those six baselines, and you’d be able to continue using baselines six through 10 for your own unofficial purposes. One caveat: Setting these permissions is something you probably won’t be able to do yourself. Contact an administrator to get this feature implemented.

While there’s plenty more to understand about baselines, I hope this story will give you some new tricks for honing your project management skills.

Do you have your own baseline tips? Share them in the comments below so the entire MPUG community will benefit.

Image Source

MPUG You LogoLearn how an MPUG Membership helps individuals and teams become better project managers and Microsoft Project users through Microsoft Project Training.

Join MPUG to attend live training webinars, access 500+ hours of on-demand sessions, receive certificates of completion and earn the Project Management Institute (PMI)® Professional Development Units (PDUs) that you need.


Watch an MPUG training webinar for free and improve your Microsoft Project skills in less than 1 hour.


[ezcol_1third]

FREE MPUG Resources

 [/ezcol_1third]

[ezcol_1third]

Microsoft Project Resources

 [/ezcol_1third]

[ezcol_1third_end]

Additional Resources

Written by Erik van Hurck
Erik van Hurck is a Senior PPM consultant for Projectum, a western European Microsoft Partner with offices in Denmark and The Netherlands. On top of that Erik is a Microsoft MVP. As such, Erik assists enterprise customers to adopt the new Power Platform cloud solutions for Project and Portfolio Management. Beyond writing for MPUG, Erik also has a personal blog (www.theprojectcornerblog.com).
Share This Post
Have your say!
00
13 Comments
  1. Thanks Eric. Very good article.

  2. Great article. I’ve always recommended using one baseline after every regular update to my schedule so that I can quickly identify the progress made in the previous period. It’s a commonly asked question of project managers (e.g. “What did we advance in the past week?”) and with a baseline from the previous period, it’s an instant report using the tracking barchart.

  3. Regarding Item 2. “Only One Baseline Works with Earned Value Management”:
    MSP will allow us to utilize Baselines 1-10 for EVM, if we change our schedule’s options.
    How: Select [File][Project Options][Advanced][Baseline for Earned Value calculation] and select Baseline 1 – 10. The EV fields (BCWS, ACWP, etc…) will change accordingly.

  4. Agree with Jill’s 1/31/17, 11:46am comment about being able to use baselines other than the first, Baseline, for earned value.

  5. Great article on a difficult subject. Just a reflection on the numbering and use of the baselines as one progresses thru a project. I use the “baseline10” for the first approved scope of the project. Then when a scope change, and CR comes I save that as baseline1. This way I always know that the numberings of the CR’s follows the numberings of the baselines. That is up to number 9 of course. If we get more scope changes than that, I’m probable not around as PM anyway (-;

  6. Hi Jill and David,
    Great response! I’ve tested it and seems to work nicely! I didn’t know this, thanks for sharing.

    Hi Anders,
    Thanks for sharing your best practices on the CR numbers, it’s an interesting method and I see why you adopted it.

    Hi Michael and Chris,
    Thank you for responding and the kind words.

    Thanks all,
    Erik v H

  7. Hi Chris,
    Can you explain how you use ‘one baseline after every regular update to my schedule so that I can quickly identify the progress made in the previous period.’
    Thanks
    Adriana

  8. Hi Adriana,

    I would suggest you take the approach by selecting 1 specific baseline and use that one for this purpose. As an example, use Baseline 10 for this. And use baselines 0 to 9 for the primary function of the baselines.

    Thanks for reading,
    Erik

  9. Hi Raj,

    On the multiple baselines have a look at the link for the guest post Bonnie did. And about EVM I believe I’ve heard people discuss that there are options to assign another Baseline to EVM calculations. I wrote a post on my blog called “About earned value management”. It might help you.

    Kind regards, and thank you for reading the post.
    Erik

  10. Hi Veda,

    Thanks for the comment. I agree that it is not available out of the box. But I do see a chance to visualise changes in critical path by leveraging 2 custom fields (+1 for each additional baseline).

    I will start work on a post to describe the solution. Keep an eye out for it in Januari.

    Kind regards,
    Erik v Hurck

  11. Hi Lance,

    Master project files have their own baselines and won’t show you the subproject values.

  12. The problem with Microsoft Project baselines, is that you cannot save them separately, and import them Later on as you can do with Asta Power Project, and Primavera. This is a problem since it is often common that a revised baseline needs to be produced which is not just a copy of the current “progressed” project

  13. Hi Rob,

    Interesting case to be sure.

    I would like to suggest looking into calendars first. A calendar might change dates without proper warning. Also the different versions could be an issue.

    But mainly: don’t copy tasks and don’t let the PM change things without telling you about it.

    Baseline columns can be manually overwritten as well. Except if you use the server version of the product, that has the option to lock 5 of the baselines.

    If you like you can send me screenshots of the changes and we can look more into it. Find me at LinkedIn and let’s connect.

Leave a Reply