I have a question from one of my blog readers:
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:
If I now put same values at %Complete, I will get.
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.