Keeping dates for inserted file after link is broken

M

meesh1224

I have a master schedule that I am using for my project. I have requested
work from a supporting team and they created their own schedule. I would like
to insert that schedule and break the link to absorb that plan into the
existing master. When I do this and break the link the dates of the insert
schedule change. I know that the inserted plan has been leveled and it has
it's own project start date. Breaking the link looses all of this information
and schedules the tasks with the rest of the schedule... Is there a way to
keep the dates from that inserted schedule when breaking the link?
I have also tried just copying and pasting the tasks into the master
schedule and the result is basically the same.
The only other thing I can think of, because the resource on the inserted
schedule is already in the master, is to make her unavailable between the
time of the master schedule tasks and the inserted schedule tasks.

Thanks,
Michelle
 
J

John

meesh1224 said:
I have a master schedule that I am using for my project. I have requested
work from a supporting team and they created their own schedule. I would like
to insert that schedule and break the link to absorb that plan into the
existing master. When I do this and break the link the dates of the insert
schedule change. I know that the inserted plan has been leveled and it has
it's own project start date. Breaking the link looses all of this information
and schedules the tasks with the rest of the schedule... Is there a way to
keep the dates from that inserted schedule when breaking the link?
I have also tried just copying and pasting the tasks into the master
schedule and the result is basically the same.
The only other thing I can think of, because the resource on the inserted
schedule is already in the master, is to make her unavailable between the
time of the master schedule tasks and the inserted schedule tasks.

Thanks,
Michelle

Michelle,
There are various ways to get there but first let me ask some questions.

First, you mentioned that the supporting team schedule is leveled. Do
you still want that portion of the master leveled (or have the
equivalent of the leveled schedule)?

Second, Is the supporting team going to work to their schedule? If you
incorporate a static copy into your master, it will be a snapshot at
that point in time and therefore will not track with their schedule
after the initial snapshot. That doesn't seem very useful to me.

Third, I don't understand your comment about the resource. If she is a
resource that will work on tasks for both the supporting team and other
tasks, then why would she be unavailable? If she is only assigned to
tasks for the supporting team then she is assigned to tasks for the
supporting team. If she works on all types of tasks then the schedule
needs to be able to detect overallocations.

John
Project MVP
 
M

meesh1224

Hi John,
All great questions.
First, I am assuming that the supporting team schedule is leveled because
there is no indicator that a constraint has forced the dates. The creator of
the schedule is on vacation and sent the schedule at the 11th hour with no
detail around how it was created.
I do not want a static copy of the schedule inserted. I want it to be active
tasks in the plan that I can track to. The owner of the plan works in a
different office and thought it would be easier just to provide his own plan.
There lies the underlying problem. There was no communication about the
standards that should have been used to establish his schedule (i.e.
calendar, working hours, etc.).
The resource assigned to all of the tasks in the scheduled I'd like to add
has already been assigned to other tasks already in the master schedule that
were added on behalf of that same team - this additional schedule is like a
second bucket of work that the resource will be working on next... The
existing tasks she is assigned to should be complete before she started this
next bucket of work which should nicely waterfall. However, when I remove the
link to the inserted project or I paste the tasks in, these new tasks are
being scheduled before and around the existing tasks.

I apologize for the interchanging use of plan and schedule. They mean one in
the same in this context.

Thanks.
Michelle
 
J

John

meesh1224 said:
Hi John,
All great questions.
First, I am assuming that the supporting team schedule is leveled because
there is no indicator that a constraint has forced the dates. The creator of
the schedule is on vacation and sent the schedule at the 11th hour with no
detail around how it was created.
I do not want a static copy of the schedule inserted. I want it to be active
tasks in the plan that I can track to. The owner of the plan works in a
different office and thought it would be easier just to provide his own plan.
There lies the underlying problem. There was no communication about the
standards that should have been used to establish his schedule (i.e.
calendar, working hours, etc.).
The resource assigned to all of the tasks in the scheduled I'd like to add
has already been assigned to other tasks already in the master schedule that
were added on behalf of that same team - this additional schedule is like a
second bucket of work that the resource will be working on next... The
existing tasks she is assigned to should be complete before she started this
next bucket of work which should nicely waterfall. However, when I remove the
link to the inserted project or I paste the tasks in, these new tasks are
being scheduled before and around the existing tasks.

I apologize for the interchanging use of plan and schedule. They mean one in
the same in this context.

Thanks.
Michelle


Michele,
Ah, the old 11th hour trick - I think we have all experienced that at
one time or another.

My feeling is that if the other party is on vacation and he didn't
communicate with you about his plan, then you are free to make your own
decisions with regard to the schedule, although it may be a little tough
to get him to buy in to it when he returns from vacation.

You mention that you do NOT want a static copy of his schedule. Did you
try linking in his project dynamically (i.e. insert it into you master
via Insert/Projects). The default setting will give a dynamic insertion.
I haven't personally tried dynamically inserting a leveled project into
a non-leveled master but it should work just like you want (i.e. the
subproject will stay in its leveled state) because the subproject isn't
actually a part of the master. Rather, the master only contains a
pointer to the separate subproject. What you see at the master level is
a combination view.

If for some reason you cannot insert his file as a dynamic subproject
into your master, there are other ways to get the same schedule effect
but then it's an either/or proposition. Either his works to your version
of their schedule or you will only be able to get a snapshot of the
sub-team's schedule on a periodic basis (i.e. periodic static
insertion). One other option is to link selected tasks from the sub-team
schedule to your master (i.e. external predecessors/successors).

Your last paragraph is a bit confusing. It sounds like the sub-team's
schedule, (or at least some of it), is already in yours (i.e. ". . .in
the master schedule that were added on behalf of that same team. . .").
The mentioned resource's assignments will only dovetail (i.e. waterfall)
with tasks in the master and subproject if the links are appropriate. In
other words, the overall schedule should be laid out such that tasks are
linked in a logical order of progression. If the resource of interest is
assigned to those tasks there shouldn't be an issue with tasks being out
of sequence or overallocation of the resource.

I know, it is not easy to explain your schedule structure to someone
else. I'm not sure if I'm helping or just confusing you more. And by the
way, I don't have a problem with using "plan" and "schedule"
interchangeably. I guess one could argue that a plan is more
encompassing (i.e. the whole job, of which the schedule is just a part)
but for our discussion, assume they are one in the same.

John
 
M

meesh1224

The bottom line is I am trying to absorb the tasks in the "provided" plan
into the master schedule not using a dynamic link and without loosing the
timeline the provided plan outlines. I am not opposed to the dynamic link of
an inserted plan and have used them successfully before. However, my team
generates metrics from the project schedule by creating an excel extract and
pivoting on the data... My concern is that having another project in the
extract will skew the data because some of the metrics are based off the ID
and with the inserted project you will have more than one interation of the
ID. We do concatenate the project name on the ID but again I am not sure how
the whole thing will play out. Having the plan absorbed into the existing
master plan mitigates that...

What risk, if any, is there if I do use the inserted project as a dynamic
link and update the inserted plan as part of the master schedule versus
updating the inserted plan at it's source. For example, the inserted schedule
resides on a file server in one place and the master schedule in which it is
inserted resides somewhere else. Is there a risk if I am not updating it on
the file server it resides? Does that make sense?

Thanks so much for your patience and help!
Michelle
 
J

John

meesh1224 said:
The bottom line is I am trying to absorb the tasks in the "provided" plan
into the master schedule not using a dynamic link and without loosing the
timeline the provided plan outlines. I am not opposed to the dynamic link of
an inserted plan and have used them successfully before. However, my team
generates metrics from the project schedule by creating an excel extract and
pivoting on the data... My concern is that having another project in the
extract will skew the data because some of the metrics are based off the ID
and with the inserted project you will have more than one interation of the
ID. We do concatenate the project name on the ID but again I am not sure how
the whole thing will play out. Having the plan absorbed into the existing
master plan mitigates that...

What risk, if any, is there if I do use the inserted project as a dynamic
link and update the inserted plan as part of the master schedule versus
updating the inserted plan at it's source. For example, the inserted schedule
resides on a file server in one place and the master schedule in which it is
inserted resides somewhere else. Is there a risk if I am not updating it on
the file server it resides? Does that make sense?

Thanks so much for your patience and help!
Michelle


Michele,
Sorry I didn't respond sooner. I just saw you reply late today (Monday,
10 pm MST).

I can't speak to your Excel processing because I don't know what you are
doing. However, did you think about using the Unique ID instead of
standard ID? Nonetheless, if you are concatenating the project name with
the ID, that makes each task unique even in a dynamic consolidated file.

I don't see any issue with updating a dynamic link. The update can be
performed in either the master or the subproject - that's the whole idea
of a "dynamic link". And, since the link includes the file path, it
doesn't matter which server which file is on. So yes, it does make sense
and no, I don't see any risk.

Hope this helps.
John
Project MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top