today I will show you how Microsoft Project for the Web calculate effort when Resources have different Calendars.
First of all let’s see Calendars for two Resources: Tim and Ellen:
Let’s see Ellen’s Calendar:
Believe me, Ellen has this work hours for each and every working day, because I set it up Calendar for her.
Now, let’s see Tim’s Calendar:
OK, let me create brand new Project:
First of all I will put 4 days duration for all Tasks:
So, for Ellen’s Task Effort is 16 hours (4 days * 4 hours per day – from 09:00 AM to 01:00 PM). For Tim’s Task Effort is 32 hours (4 days * 8 hors per day – from 09:00 AM to 05:00 PM). Finally for Ellen’s and Tim’s Task Effort is 48 hours (Ellen’s 16 hours + Tim’s 32 hours),
Now I will erase Duration, so I will have:
Now I will put 16 hours for Ellen’s Task, 32 hours for Tim’s Task and 48 hours for Ellen’s and Tim’s Task, and I will get:
WOW! Duration for every Task is 1 day! Do not forget, that in Project for the Web, Task Type is Fixed Duration. and cannot be changed!
I will now change duration for ever Tasks from 1 to 4 days, and I will get:
As you can see now, Calendars are not respected, but instead effort is multiplied by 4, e.g.:
- Ellen’s Task has 64 hours (1 day was 16 hours, so 4 days is 64 hours)
- Tim’s Task has 128 hours (1 day was 32 hours, so 4 days is 128 hours)
- Ellen’s and Tim’s Task ad 192 hours (1 day way 48 hours, so 4 days is 192 hours)
To conclude, you can get confused when Duration and effort is combined. The best expected result will be if you enter Duration, and Let Project for the web to calculate effort!