From: jackie on

Hi I wonder if you can help

Is there a fast way to enter a bunch of predecessors when a) predecessors
are scattered all over the plan and when b) predecessors are sequential tasks
under a summary task

Many thanks
J
From: Rob Schneider on
Perhaps there are other ways, but I find a fast way is to gather up the
ID's of all the predecessors, and then in the predecessor column add
them in a sequence with commas, e.g. for task 6, the predecessors
2,16,102,203,4

Somtimes it's quicker to think of it the other way and instead of
defining predecessors, define successors. Using the example above, you
would make for tasks 2,16,102, 203, and 4 task 6 as the sucessor.

It's all how you look at it.

Re for the when the predecessors are sequential tasks under a summary
task, it is best *not* to use the summary task as the predecessor or
successor. use the (depending on which is appropriate) the first or
last of the sequence as the single predecessor.

Also use real tasks, not summary tasks, for defining predecessor/successor.


--rms

www.rmschneider.com




On 04/02/10 17:22, jackie wrote:
>
> Hi I wonder if you can help
>
> Is there a fast way to enter a bunch of predecessors when a) predecessors
> are scattered all over the plan and when b) predecessors are sequential tasks
> under a summary task
>
> Many thanks
> J
From: Jack Dahlgren MVP on
For part B:

To quickly link a string of sequential tasks (which are in the correct
order)
Select them all. Click the "link tasks" icon on the toolbar - looks like a
little chain or CTRL+F2 key.

-Jack Dahlgren

"jackie" <jackie(a)discussions.microsoft.com> wrote in message
news:8084B2D8-D9D4-4DC6-8325-DC448C512DA1(a)microsoft.com...
>
> Hi I wonder if you can help
>
> Is there a fast way to enter a bunch of predecessors when a) predecessors
> are scattered all over the plan and when b) predecessors are sequential
> tasks
> under a summary task
>
> Many thanks
> J

From: Trevor Rabey on
This is just a data editing problem.
The objective is to avoid all of the typing and data entry.
There are lots of situations, working with MSP, when you need to edit big
chunks of data.
There are lots of ways to do various editing jobs.
Editing comes down to fluent use of copy, paste, fill down, replace,
preferably with the keyboard shortcuts rather than the mouse (v slow).
Sometimes it is easiest to stay in MSP and other times copying and pasting
the data into WORD or EXCEL, then editing there and then copying and
pasting.
WORD has Edit, Replace, and EXCEL has lots of good text functions like
PROPER(), CLEAN(), TRIM().
Sometimes it is necessary to sort, filter or group the tasks first to get
them into a better conformation for the copy, paste, fill down, replace etc.
You may have to use a spare text or flag field, populate it with something
and then sort, filter or group on that field in order to get the tasks
bunched up right.
For example, here the tasks are A-F and the predecessors of D-F are A-C.
To do this I would just show the ID column and copy the A-C IDs and paste em
into the predecessors column starting at D.

1. A
2. B
3. C
4. D, 1
5. E, 2
6. F, 3

It is common to have to make a string of tasks predecessors to one at the
bottom of the list like this:

1. A
2. B
3. C
4. D
5. E
6. F, 1,2,3,4,5

Since you have the ID column you can copy 1,2,3,4,5 as a vertical list, but
you need it as a horizontal list separated by commas.
Easy, just paste the vertical list into a WORD doc (show the hidden
characters) and use Edit, Replace to substitute commas for the paragraph
feed marks.
Then copy and paste back into MSP.
--
Trevor Rabey
0407213955
61 8 92727485
PERFECT PROJECT PLANNING
www.perfectproject.com.au

"jackie" <jackie(a)discussions.microsoft.com> wrote in message
news:8084B2D8-D9D4-4DC6-8325-DC448C512DA1(a)microsoft.com...
>
> Hi I wonder if you can help
>
> Is there a fast way to enter a bunch of predecessors when a) predecessors
> are scattered all over the plan and when b) predecessors are sequential
> tasks
> under a summary task
>
> Many thanks
> J


From: Sai on
On Feb 4, 10:22 pm, jackie <jac...(a)discussions.microsoft.com> wrote:
> Hi I wonder if you can help
>
> Is there a fast way to enter a bunch of predecessors when a) predecessors
> are scattered all over the plan and when b) predecessors are sequential tasks
> under a summary task
>
> Many thanks
> J

J - I would use the "Link tasks" or Ctrl + F2 to select the tasks in
Gantt Sheet and sequence them, but to optimize/correct the links,
would change the view to "Network diagram" to validate the dependences
and correct them (after hiding some of the fields displayed in the
shapes).

Hope this helps

- Sai, PMP, PMI-SP, MCT, MCTS
http://saipower.wordpress.com