How to disconnect relation between %Complete and %Work complete in MS PROJECT 2016?

 

Hi,

I have a question from one of my blog readers:

“Hi,
I just came across your resource tool and am hoping to find some help. I am having trouble disconnecting % Work Complete (Actual work done) from % Complete (what work progress should be, based on duration). I need this tracking tool for comparison. But they keep copying each other.”

I will show you a simple example with MS PROJECT 2016!

First I will going to create a simple Project with only two Tasks (and I will add some columns in Gantt Chart View). One Task will be Auto, and another Manually scheduling:

image

I will create to Resources, John and Mary:

image

And I will assign them to Tasks, accordingly:

image

Now I will put 50% at %complete for the first Task, and 25% for the second, and I will get:

image

As you can see, %work completed is updated automatically, and that is what we want to avoid here.

To avoid that you should set up this option:

image

and then:

image

and finally:

image

If I now put same values at %Complete, I will get.

imageAs

As you can see, now %work complete is0%. Notice that in this case you can not update %Complete for Manually scheduled Task, but only for Auto Scheduled. I will put now 40% in %work complete field for both Tasks, and I will get:

image

As you can see, %Complete remains the same.

So, yes, you can do it. But be aware that in this case you have killed formula: WORK = DURATION * UNITS , and you should care about everything by yourself.

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 2013, MS PROJECT 2010, MS PROJECT 2016, PMI, PRoject Management and tagged , . Bookmark the permalink.

3 Responses to How to disconnect relation between %Complete and %Work complete in MS PROJECT 2016?

  1. vmkpmk says:

    Dear Ninad,

    I have below query in Fixed Duration Task.
    step1; created a task “paint the wall” with duration as 10 days (work starts by a monday). Task is fixed duration
    Step2: created a resource “A” (100%) – (8hrs/day)
    Step3: assigned this resource in this task.
    Step4: In task usage, changed the timelines middletier->months, bottomtier->weeks
    Step5: in task usage, entered actual work = 20hr in that task. It gave an warning message. Skipped.
    Now it shows 1st week, Resource works 20hrs, and overallocated in next week with 60hrs.
    Now, my query is, if i add another resource “B”, i expect that this extra 20hrs in 2nd week should be assigned to this resource “B”.
    Please guide on how to achieve this?

    • vmkpmk says:

      I have below query in Fixed Duration Task.
      step1; created a task “paint the wall” with duration as 10 days (work starts by a monday). Task is fixed duration
      Step2: created a resource “A” (100%) – (8hrs/day)
      Step3: assigned this resource in this task.
      Step4: In task usage, changed the timelines middletier->months, bottomtier->weeks
      Step5: in task usage, entered actual work = 20hr in that task. It gave an warning message. Skipped.
      Now it shows 1st week, Resource works 20hrs, and overallocated in next week with 60hrs.
      Now, my query is, if i add another resource “B”, i expect that this extra 20hrs in 2nd week should be assigned to this resource “B”.`
      I would like the ms project to calculate by itself and assign 40hrs for resource A and 20hrs to resource B.
      Please guide on how to achieve this?

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