Importing External schedule into a Master- Different calendar options
Importing External schedule into a Master- Different calendar options
(OP)
I would like to import an external schedule into a master schedule I have but, they have different calendar options.
The master schedule has its calendar options set to 7 hr/day, 35 hr/wk. The external schedule has its option set to 8 hr/day, 40 hr/wk. This obviously affects how project is converting the task duration into hours. A task that was once 1 day is now 1.14 days.
I tried changing the master schedule's calendar options and then importing the external schedule because I thought the ratio was only affected one time at import and then change the master schedule's calendar options back.
I have many external schedules to import so, I am trying to avoid manually correcting each duration.
Any advice?
The master schedule has its calendar options set to 7 hr/day, 35 hr/wk. The external schedule has its option set to 8 hr/day, 40 hr/wk. This obviously affects how project is converting the task duration into hours. A task that was once 1 day is now 1.14 days.
I tried changing the master schedule's calendar options and then importing the external schedule because I thought the ratio was only affected one time at import and then change the master schedule's calendar options back.
I have many external schedules to import so, I am trying to avoid manually correcting each duration.
Any advice?
RE: Importing External schedule into a Master- Different calendar options
The question is what you want to achieve. If resources have been planned you can not just change 40 hours per week into 35 hours per week. It may be, however that you are not interested in details on an hourly basis and just want to think in arbitrary units of so many working days, no matter how many hours a day one is working.
Please, clarify first what you want to achieve before we try to find some workaround. Do you use resources [Work] in hours? What to do with that? Just reduce all work with 12,5% ? Or...?
You could also think the other way round. Make the 40 hours / week your Project calendar and use a special calendar of 35 hours / week for the perhaps few tasks in your master file. However, if you would give in that case a task 10 days with a 7 hours calendar in reality you would get 80 / 7 working days as duration. Why on earth do you use a 7 hours calendar if you want to neglect the 12,5 % difference for other tasks? As a rule of thumb never try to calculate in more detail than about say half the time you want to update your project. Quite often managers want to plan in hours or maximum a few days while updating the project is done once every 2 weeks or month if ever done. The planning has become a paper tiger in that case.
Why an easy solution if you can make it complicated?
Greetings from the Netherlands
RE: Importing External schedule into a Master- Different calendar options
What I am trying to accomplish is to still have the same finish date on the tasks when I import the outside schedules which use the 8h/d, 40h/w calendar.
I want 1 day to equal 1 day in the master schedule. We do not break tasks down to hours. It does not matter to me if one of the contractors work 8hr/day versus 7 hr/day. Our organization has not yet begun to measure work effort on a per hour basis.
If the complete work package was 80 days in their schedule, I want it to also say 80 days when imported into mine – not 91.43 days. The most important thing to our project right now is have a correct completion date.
RE: Importing External schedule into a Master- Different calendar options
In e.g. Text20 I would use the following formula:
IIf([Flag20];ProjDurConv(ProjDurValue([Duration]*7/8);7);ProjDurConv(ProjDurValue([Duration]);7))
It may be necessary to replace ; by , depending on your list separator.
Make certain that the same formula would be used for Summary Tasks. [Tick box]
In all projects the fields Text20 and Flag20 have to be added. If you have an 8 hours calendar set Flag20 to Yes. This is assuming you use a 7 hour one.
Rename Text20 e.g. to Dur. Check everything and then in your table remove [hide] the fields Flag20 and Duration or move these far to the right of the table.
Why an easy solution if you can make it complicated?
Greetings from the Netherlands
RE: Importing External schedule into a Master- Different calendar options
Why an easy solution if you can make it complicated?
Greetings from the Netherlands
RE: Importing External schedule into a Master- Different calendar options
I do not know what flag field and text field are or how to use them so, I will have to do some research on your suggestion. Thanks so much for your assistance so far.
RE: Importing External schedule into a Master- Different calendar options
Why an easy solution if you can make it complicated?
Greetings from the Netherlands
RE: Importing External schedule into a Master- Different calendar options