Finish date and the problem in MS PROJECT 2010! Or not?

Hi guys,

I have a question from one of my Blog readers: “Is it possible to see Finish Variance in working days instead of calendar days? e.g. If i completed my task on Monday, instead of Friday, i want to see variance of 1 working day”.

Piece of Cake in MS PROJECT 2010, and MS PROJECT 2013 as well!

First I will create a Project with one Task!

Resources for this Task are irrelevant, so I will skip that part.

I am going to save The Baseline for this Project:

and then:

OK!

Now, suppose that this Task was started as Scheduled, but Finished on Monday instead on Friday! I will now put those Information in MS PROJECT 2010:

and then:

That’s it. Now I will check the Variance Table:

and I will get:

As you can see Baseline Start, and Start (Actual) are the same, but Baseline Finish, and Finish (Actual), are different.

Finish Variance is not just Finish – Baseline Finish, because in that case it will be 3 days, instead of one!

The formula is: Finish Var. = Finish – Baseline Finish – Non working days, and in my example it is (12.11.2011-09.11.2012) – 2 (Saturday and Sunday) = 3-2=1

It works!

In my next two Post I will answer to another two questions of my Blog Readers.

Effort driven Tasks, because one of my Blog reader is confused about this and how Work (hours) are changed in effort driven Tasks
What happens with %units when you have fixed work/fixed duration Task, and change duration/work! My blog reader thinks that there is a Bug, but there is not a bug.

Regards!

About Nenad Trajkovski

Location: Zagreb, Croatia Occupation: Project Manager Interests: Project Management and MS PROJECT He was born in Zagreb, Croatia at 1963. After completing his college he started working on projects in different business areas (banking, manufacturing, automotive industry, distribution, oil companies, etc.) developing and implementing ERP systems into different companies. He has got a lot of experience working with people in different business processes and also possesses great knowledge in information technologies and financial services. Today he works as a business consultant, adn Project Manager in PERPETUUM MOBILE d.o.o. Zagreb. He is a regular lecturer for Project Management in MS Innovation Center in Varaždin, Logosoft Sarajevo in Bosnia and Herzegovina and SEAVUS GROUP in Skopje Macedonia. He was named the best lecturer of WINDAYS 2008 while his lecture was also voted as the best. In addition, he was in TOP 10 lecturers at the MS SINERGY 2009 and MS VISIA 2009, 2010. Shares first place as the best lecturer of KulenDays 2009 and 2010 and PMI Conference 2009 in Zagreb. He is also a regular lecturer in the MS Community. He is a Certified Accountant and a PMP (Project Manager Professional) and a PMI-RMP (Risk Manager Professional), MCP, MCT, and Microsoft Certified Technical Specialist - Microsoft Project 2010. From 01.01.2012 awarded with MVP (Microsoft Most Valuable Proffesional - Microsoft Project)!

View all posts by Nenad Trajkovski →