From: jackie on 4 Feb 2010 12:22 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 4 Feb 2010 12:37 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 4 Feb 2010 13:04 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 4 Feb 2010 19:05 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 4 Feb 2010 22:50 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
|
Pages: 1 Prev: Attach Outlook email Next: How do I reflect the true finish date for a task? |