Forum Discussion
MS Project Professional Master File Duration less than duration of highest Subproject
- KenPb,
Yeah that gave me just enough info. Indeed if subproject ABC has exceptions which allow Sunday to be working time then you will see an apparent discrepancy in the Duration field. The master file has the Standard calendar so it is measuring duration time per that calendar which means it will not count Sundays.
It's not clear what you are trying to achieve. You can create a custom Text field with the following formula and it will display the same duration as subproject ABC but only for the case where subproject ABC is the dominant subproject (i.e. starts earlier and finishes later than any other subproject). Why? Because the formula simply measures calendar time instead of working time.
Text1=DateDiff("d",[Start],[Finish]) & " days".
If another subproject has an earlier start or a later finish, then the formula will give an invalid duration. So again, I'm not sure what you are trying to achieve.
Is there a way to create a custom duration at master level that will respond to the intent regardless of whether the subproject with the exceptions is dominant or not? Yes, but it would require VBA.
John
KenPb,
Thanks for the picture but it doesn't give quite enough information. For example, what is the task ID for each of the tasks shown in your "screen shot"?
Other relevant information:
1. What is the Project calendar for the master?
2. What is the Project calendar for each subproject?
3. If calendars are different, what are the differences (e.g. working hours, working days, hours per day, etc.)?
4. In the master do you have the calculation option set to "on"?
5. Also in your Project options do you have "inserted projects to be calculated like summary tasks"?
John
John-project Hi and thanks for the reply. The calendars for the master and sub projects are all standard M-F 40hr work week however in one of the sub projects there are a number of exceptions where a task start and completion date was on a non working day. I believe this might be the issue. Any recommendations to resolve?
Thanks, Ken
- KenPb,
Thanks for answering a few questions but you still didn't answer the main question, namely, what is the task ID for each of the lines shown in your "screen shot"?
I'd also like to see the Start and Finish fields for all the tasks shown. As far as the subproject with calendar exceptions I can't offer any recommendations until I see more.
JohnHi and thanks for your patience. My project that I was working on was fairly advanced with a lot of content, so it was a bit difficult to get that info.
I however reproduced the issue in a simpler test project below:
The discrepancy occurred when, for SubProject ABC, I put the start, end completion date on Sunday (non-working day) where I introduced this exception.
The calendars for the Master and subprojects are all Standard (40hrs, M-F).
I hope this is enough info to help diagnose a resolution. Thanks, Ken
Task Mode Task Name % Complete Duration Start Finish ID Auto Scheduled Master Project Test 47% 62 days? 2022-09-23 2022-12-19 0 1 Auto Scheduled SubProject ABC 69% 63 days 2022-09-23 2022-12-19 2 Auto Scheduled Define Scope 100% 21 days 2022-09-23 2022-10-21 1 Auto Scheduled Development 100% 5 days 2022-10-24 2022-10-28 2 Auto Scheduled Test 100% 1 day 2022-10-30 2022-10-30 3 Auto Scheduled Implement 0% 12 days 2022-12-02 2022-12-19 4 3 Auto Scheduled SubProject DEF 0% 29 days? 2022-11-09 2022-12-19 4 Auto Scheduled Define Scope 0% 8 days 2022-11-09 2022-11-18 1 Auto Scheduled Development 0% 15 days 2022-11-21 2022-12-09 2 Auto Scheduled Test 0% 1 day? 2022-12-12 2022-12-12 3 Auto Scheduled Implement 0% 5 days 2022-12-13 2022-12-19 4 - KenPb,
Yeah that gave me just enough info. Indeed if subproject ABC has exceptions which allow Sunday to be working time then you will see an apparent discrepancy in the Duration field. The master file has the Standard calendar so it is measuring duration time per that calendar which means it will not count Sundays.
It's not clear what you are trying to achieve. You can create a custom Text field with the following formula and it will display the same duration as subproject ABC but only for the case where subproject ABC is the dominant subproject (i.e. starts earlier and finishes later than any other subproject). Why? Because the formula simply measures calendar time instead of working time.
Text1=DateDiff("d",[Start],[Finish]) & " days".
If another subproject has an earlier start or a later finish, then the formula will give an invalid duration. So again, I'm not sure what you are trying to achieve.
Is there a way to create a custom duration at master level that will respond to the intent regardless of whether the subproject with the exceptions is dominant or not? Yes, but it would require VBA.
John
