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:
I will create to Resources, John and Mary:
And I will assign them to Tasks, accordingly:
Now I will put 50% at %complete for the first Task, and 25% for the second, and I will get:
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:
and then:
and finally:
If I now put same values at %Complete, I will get.
As
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:
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!
Like this:
Like Loading...
Related
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)!
As 
Nenad Trajkovski 
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?
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?
Read my blog post from today, 11/21/16