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!

image

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

I am going to save The Baseline for this Project:

image

and then:

image

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:

image

and then:

image

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

image

and I will get:

image 

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.

  1. Effort driven Tasks, because one of my Blog reader is confused about this and how Work (hours) are changed in effort driven Tasks
  2. 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!

Advertisements

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)!
This entry was posted in MICROSOFT PROJECT, Microsoft PRoject 2010, MS PROJECT 2010, PRoject Management and tagged , , . Bookmark the permalink.

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

  1. hammadbinarif says:

    Thanks a lot for your Post. It did answer my question 🙂

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s