today I will explain Overallocated fields in MS PROJECT 2013, because they are confusing a lot of my Blog readers.
First I will create Project with three Tasks, and I will add Overallocated field in Gantt Chart View:
I will create two Resources for my Project, and I will add Overallocated field in Resource Sheet, as well:
Now I am going to assign John to Task 1 and Task 2:
As you can see, John is Overallocated in Task 1, and Task 2, but Overallocated field in Gantt Chart View says No! Why? Let’s look at Resource Sheet:
As you can see, Overallocated field here is Yes for John? Why? Because in Resource Sheet Overallocated field is Resource field, and it says that this particular Resource (John, in my example) is Overallocated among Tasks.
On the other hand, in Gantt Chart View, Overallocated field is Task field, and it says that there in no Over allocation for any Resource in that particular Task (Task 1, and Task 2 in my example). Confused? OK. Let me assign Mary to the Task 3:
Overallocated field is No, as expected. Since Mary has 100% as max Units Capacity, I will assign Mary on the Task 3 with, for example, 120%:
and I will get:
To conclude, if Resource works with more than max Capacity at some Tasks, it will be Overallocated in Task Overallocated field (in my example in Gant Chart View), for this Tasks, and it will be Overallocated in Resource Overallocated field (in my example in Resource Sheet), as well. On the other hand, if Resource work at the same time for multiple Tasks, but within max Capacity, then it will not be Overallocated in Task Overallocated field, but it will be Overallocated in Resource Overallocated field.
Hope this helps.