Loading...
Quick Links

5 Things to Know about Microsoft Project Baselines

tennis-443269_1920The 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.”

Erik_van_Hurck_Baselines_figure_1

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:

Erik_van_Hurck_Baselines_figure_2

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:

Erik_van_Hurck_Baselines_figure_3

    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.

Erik_van_Hurck_Baselines_figure_4

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.

Erik_van_Hurck_Baselines_figure_5

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:

Erik_van_Hurck_Baselines_figure_6

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.

Erik_van_Hurck_Baselines_figure_7

    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:

Type of approvalWhich baselines to set
Original approvalBaseline and Baseline 1
First scope changeBaseline and Baseline 2
Second scope changeBaseline and Baseline 3
......
Ninth scope change

(I'd hope, of course, that it never came to this...)
Baseline and Baseline 10

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

Share This Post
22 Comments
  1. Thanks Eric. Very good article.

    Reply
  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.

    Reply
  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.

    Reply
  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.

    Reply
  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 (-;

    Reply
  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

    Reply
  7. Great. Thanks

    Reply
  8. 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

    Reply
  9. 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

    Reply
  10. Great post. Thank you Erik for sharing this.

    Can you please through some more light on the point saving two baseline at a time. (4th point in the post). What I understand from the write up is that the baseline named “Baseline” should be the original plan schedule, and the other baselines (Baseline 1 to 10) can be used recording the scope changes.
    And can’t we change the baseline for EVM calculation ?
    There is one options wherein the user needs to specify which baseline should be used for EVM calculation.

    Reply
  11. 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

    Reply
  12. Hi Erik, Its a lovely post for people who are interested to see how the project has been executed from the beginning and which are the areas that impacted the project across baselines. However, I have an unusual query, which is know is not possible, still want to ask. Is it possible to filter out or see the change in critical path across the baselines ? Example: In baseline 1 there is a critical path, there is a sudden scope change and I had to change the dates which I have taken as baseline 2. Now, I want to see what was the critical path in baseline 1 and what would be the critical path in baseline 2. This is for a large construction project.

    Thanks in advance.

    Reply
  13. 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

    Reply
  14. Great article, thanks for sharing.

    I read about baselines before, was not sure when I had to set it. I now understand that it has to be set at the beginning – the original plan(schedule)

    Reply
  15. I am trying to create a baseline for my project. My first project is the Master Plan, with Baseline 1 assigned to it. I am adding a second project. Want to create a baseline for this project (Baseline 1). I tried creating a Baseline 1 for the second project, but after the merge it does not show up in my columns. Any help would be greatly appreciated. Thanks

    Reply
  16. Hi Lance,

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

    Reply
  17. 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

    Reply
  18. I have only been using MSProject (v2016) for about a year, having lots of experience with P6. One of our clients has been complaining that the baseline dates in their project have changed. The first time, I wondered if I had just updated the wrong column, but then I hid the baseline columns to prevent that. Then I found that if I copy an existing activity, that its baseline dates are copied as well (which I didn’t notice because I had hidden baseline dates). So, I now only add new activities by key. But with more complaints, I did a compare against their identified approved baseline and found over 300 baseline dates were different. Unfortuantely, the PM sometimes make changes without telling me, and he has an older version of MSP-2013. I am completely stumped as to what is causing this problem, and how to prevent it in the future. Is it related to possibly different versions date offsets (like happens going back and forth from P6) or a bug in MSProject, or what? Your thoughts, please. Thanx.

    Reply
  19. 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.

    Reply
  20. Thanx, Eric. I may take you up on that on LinkedIn — thank you. In the meantime, I will say that we have not changed calendars on any of the tasks that have changed baseline dates. There are only two calendars used — our normal work calendar with company holidays (not the same as MS), and a 7-day-overnight work calendar, on some overnight activities. I have also found that MSP ignores some holidays I have set in the default calendar, forcing me to set a specific calendar to avoid some holidays (like Xmas!). That’s it, I think. I can’t control what the PM does, and believe me I would if I could. I am aware that baseline dates can be manually changed — that’s a major deficiency in MSP as far as I am concerned. Wasn’t aware that MSP Server can lock half of the baselines (why just half of them?), but we only use the local copies. Anyhow, thanx again. I will be in touch.

    Reply
  21. Very nice Article.
    I work mostly on p6, my question is importing MSP into P6.

    I would like to import baseline dates in P6. is there any way we can bring that information in P6. Because whenever I import MSP in P6, i only gets the currents project dates but not baseline information.

    Many thanks

    Reply
  22. I have been away from MSP for a while, been mostly using Primavera. The company I am now working for has decided to move away from Primavera for all projects, but am trying to keep the larger ones in Primavera. My question is, as a fair few of the projects have been running for some time, can I add a baseline in the past (i.e. original baseline date from Primavera). Exporting from Primavera to MSP 2016 is not recognised as P6 only transfers MPX files which is MSP2013 or earlier…

    Reply

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Please complete this equation so we know you’re not a robot. *

+ 60 = 69

Thanks for submitting your comment!
You must be logged in to comment.