I’ve got a question which is: “How do you calculate the working days in formulas when the baseline is not Baseline 0, and you need to see variance of that Baseline?”
It’s easy and I’ll show you how with MS PROJECT 2016. First I will create a simple Project with only two Tasks:
Now I am going to create some Resources and I will assign them to those Tasks:
Finally I will save thee Baseline:
Now, suppose that, for example, Task 1 was started at 17.07.2018 (instead of 16.07.2018), and Actual duration i1 1 day, but remaining duration will be another 3 days:
Suppose that another Task, is needed for the Project, and John and Mary are going to work on that Task:
Let’s no switch to Variance Table:
As you can see, Task 1 has Start Variance 1 day (because it was started 1 day latter than planned) , and Finish Variance 3 days (because it has duration 2 days longer than planned, and it was started 1 day latter than planned).
And no suppose that this is your new plan, because Stakeholders, Sponsor, CEO, or anyone else approved it as a new Project plan. But for historic purposes the old should be saved, so you should save this new plan as Baseline 1 (I’m not going to show you pictures, because procedure is the same like when I saved first Baseline. You just have to choose Baseline 1. After I save this baseline I will get in Variance table this:
Do you notice any change? NO! Same result. Now, if you want to see Variance according to Baseline 1 you should follow this steps:
So now if I look at the Variance Table I have:
So now, everything is OK. you can do this for every single Baseline.