Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Showing which predecessors & successors are drivin

5 replies [Last post]
Fri, 2005-05-27 09:08
Ian Wilkinson
User offline. Last seen 12 years 48 weeks ago. Offline
Joined: 20 May 2005
Posts: 6
Groups: None
An activity can have many predecessors and successors. You can see them in the predecessors and successors Form.
I use MSP 2000 and P3.
Does anyone know whether the predecessors and successors Form can be customised to highlight which predecessors and successors are driving the selected activity?
In P3 the equivalent predecessors and successors Form highlights the driving predecessors and successors with an asterisk.
By driving I mean those predessors or successors which have zero free slack relative to the selected activity.

This feature would be useful for tracing critical paths. I know that you can use a filter for critical path activities or create a filter for activities with different total slack values but this is nowhere near as effective as tracing the driving logic using the predecessors and successors activity form.
Top

Replies

Sun, 2006-08-20 21:52
#1
Zhang Haixiang
User offline. Last seen 3 years 28 weeks ago. Offline
Joined: 14 Apr 2005
Posts: 250
Groups: None
Hi Tom,

Good method, but it is not so accurate.
if one of the pred. of the milestone have a min. free float,that not means this pred. is driving the milestone, because its succ other than this milestone may cause the min FF. Am i right?
Top
Sat, 2006-08-19 20:13
#2
Tom Hadley
User offline. Last seen 18 weeks 1 day ago. Offline
Joined: 2 Mar 2004
Posts: 41
Groups: Building Information Modelling, Planning, Claims & Contracting, The GrapeVine
Hi all

I have the same issue in MSP, this is how I have addressed it (partly):-

Lets say you have 20 or so activites feeding into a milestone and you want to identify which ones are driving

First filter on tasks which have the milestone as a succesor, then filter these for criticality or free float.

My understandin gof the definition if driving is :-

Those activities preceeding an activty which are either critical or have minimum or zero "free float"

i.e. any delay to these preceeding activities will inturn delay the current activity

I would be pleased to get some feedback an dview on this solution

Kind regards

Tom
Top
Thu, 2006-07-06 00:17
#3
Zhang Haixiang
User offline. Last seen 3 years 28 weeks ago. Offline
Joined: 14 Apr 2005
Posts: 250
Groups: None
I’m writing a VB code but have some problem
the code can only deal with Lag in day or eday,for lag as 50% the result is no correct.

the method is to caculate the start date for the task using each pred. if the caculated date is the same as MSP, then the Pred. is considered driving.

Is there any other easy method?
Top
Wed, 2006-07-05 07:39
#4
Robyn Brown
User offline. Last seen 13 years 13 weeks ago. Offline
Joined: 18 Dec 2004
Posts: 10
Groups: None
Dear All,

It is possible for MS Project to provide an analysis of the activity driver information. This needs a bit of additional VB coding, but will quickly and clearly show the full CP\Driver for each selected milestone.


Regards
Robyn
Top