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.

Trial version of DRAG-computing software

17 replies [Last post]
Stephen Devaux
User offline. Last seen 18 weeks 6 days ago. Offline
Joined: 23 Mar 2005
Posts: 667
Since there has been a thread in the Spider Project topic discussing this, I guess I should really mention this here. There is a trial version of Sumatra.com’s Project Optimizer add-on software that, among other features, computes critical path DRAG (the amount of time a critical path activity is adding to the project duration).

http://sumatra.com/projectoptimizer/projectoptimizer.htm

It works with MSP2007 and 2010. According to the Sumatra website, the trial version is available until August 1st.

And no, I don’t have any financial arrangement with Sumatra, Spider Project, or any other DRAG-computing software (and no control over the website).

If you’re interested in learning more about DRAG, I recommend this article by 1996 PMBOK Guide author Bill Duncan at ProjectsatWork.com:

http://www.projectsatwork.com/content/articles/246653.cfm

(Yes, I’m listed as co-author, but Bill actually wrote almost every word -- he was nice enough to credit me because I introduced him to the concept.)

Fraternally in project management,

Steve the Bajan

Replies

Mike Testro
User offline. Last seen 6 weeks 1 day ago. Offline
Joined: 14 Dec 2005
Posts: 4418
Hi Mimoune

I can’t move individual threads - just the whole topic.

Its not the first time a topic has gone wildly off course and lets hope it won’t be the last - thats one of the joys of PP.

By the way - soccer is an acceptable English word for a game that should really be called feetball.

Best regards

Mike Testro.
mimoune djouallah
User offline. Last seen 4 years 41 weeks ago. Offline
Joined: 14 Oct 2006
Posts: 388
hi all

thanks all for your comments, and sorry Stephen for hijacking your thread, actually i am not a football fan(Please Americans it is not this silly word soccer;)
but i respect it at least for the fact that people from the other side of the ocean now know there is a country call it Algeria, which for me is a huge success.

and please moderator for the sake of fun, can you move those threads, to trivia area of the forum, perhaps you can call it, Rafael vs Mike, the revenge ;)

have a good day
Mimoune
Rafael Davila
User offline. Last seen 1 day 16 hours ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Mike and Stephen,

I am not really a soccer fan; I am not following the games but just wanted to add some spice into the issue. Is my way to let Mimoune know I welcome his comments about the games as he is sharing his passion for a game many love in the same way I love baseball, boxing and basketball. I do the same with our Pilipino friends who in a similar way love boxing, I enjoy their comments same as yours. Thanks for keeping the humor.

Best regards,
Rafael
Stephen Devaux
User offline. Last seen 18 weeks 6 days ago. Offline
Joined: 23 Mar 2005
Posts: 667
"But then England beat Australia 21 - 20 in the game that really matters over the weekend."

Wow! That’s a really low scoring cricket match!

Fraternally in cricket,

Steve the Bajan
Mike Testro
User offline. Last seen 6 weeks 1 day ago. Offline
Joined: 14 Dec 2005
Posts: 4418
Hi Rafael.

It could easily happen - we will know tomorrow.

But then England beat Australia 21 - 20 in the game that really matters over the weekend.

Best regards

Mike Testro
Rafael Davila
User offline. Last seen 1 day 16 hours ago. Offline
Joined: 1 Mar 2004
Posts: 5229
USA Team
Mike Testro
User offline. Last seen 6 weeks 1 day ago. Offline
Joined: 14 Dec 2005
Posts: 4418
Hi Mimoune

It could be that England is out of the contest - but at least France will be on the plane first.

Algeria played well and deserve to go through.

Best regards

Mike Testro
mimoune djouallah
User offline. Last seen 4 years 41 weeks ago. Offline
Joined: 14 Oct 2006
Posts: 388
hi Mike

i just notice this thread, i hope you enjoyed the game ;), you have to see the reaction of the English heavy lift supervisor who works with us after the game.

best regards
Mimoune

sorry, i could not resist ;)
Rafael Davila
User offline. Last seen 1 day 16 hours ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Mike,

Of course paying the LDs is an option, but you got to compare it to your other options, even those I missed to mention many like second shifts, help from other contractors and many others, that is why I said there is no magic bullet, DRAG is more like a silver bullet for crashing, will keep away the wolf-man but not a vampire.

I already ruled out other options when I said “when everything else makes no sense”, just to force you into the idea of crashing and at this point not be distracted by the other options.

Hope you are enjoying the games, same as I did with the NBA Finals except last night game. A Yankee/Mets fan which happens to be a Celtics fan, how about that? Fenway franks is the only good thing at The Wall.

Best Regards,
Rafael
Mike Testro
User offline. Last seen 6 weeks 1 day ago. Offline
Joined: 14 Dec 2005
Posts: 4418
Hi Rafael

You wrote - ".... you have no option than to crash your activities."

There is always the option to face the over run and pay the LAD’s - particularly if the cost of acceleration is more costly and the outcome doubtful.

There is always the chance that the employer will give you a chance for an EoT to fudge the issue.

Best regards - its half time with England v Algeria - must dash.

Mike Testro
Stephen Devaux
User offline. Last seen 18 weeks 6 days ago. Offline
Joined: 23 Mar 2005
Posts: 667
Mike wrote:

"If you can forecast where these circumstances are most likely to arise then I can see the pro-active advantage."

I’ll gratefully accept that -- I think it’s the best I’m likely to get. Big Grin

Raphael wrote:

"Drag tells you up to how much the actual critical path can be compressed and prevents over compressing activities when some portion does not further reduce total duration. Then perhaps no further reduction should be done on these activities but in others along the multiple critical paths."

The word "perhaps" is key. However, the optimization process can also be iterative -- if you compress a 30D task that has drag of 12D to a new duration of just 10D, now the activity has TF of 8D, and the parallel CP activity may have drag of 8D. Now you can look to gain even more time by compressing that activity, etc.

But, with "perhaps", I take your point.

Raphael also wrote:

"Crashing after first critical path is compressed gets complicated, DRAG helps. Is not a magic bullet but good to have in your bag of tricks."

Well put. There is no magic bullet in PM -- just metrics and wisdom.

Mike also wrote:

"When I read the phrase "multiple critical paths" I reach for my fiddle detector."

Me, too! I’ve seen ’em, but I’m always suspicious!

But Raphael’s most recent post is right on the money, in terms of understanding the implications of drag and crashing.

Fraternally in project management,

Steve the Bajan


Rafael Davila
User offline. Last seen 1 day 16 hours ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Mike,

When you construct a schedule there is probability 99.99999% there will be a single critical path. But when your job is in trouble, after no more changes in logic or normal increase in resource availability make sense you have no option than to crash your activities. Is a procedure of last resort and you better do it economically as you already are in trouble.

You only crash activities that impact project duration; these are activities on your longest path. Why spend money into crashing activity time that has no impact on total project duration? It will not only be a waste of money but will distract your resources into futile exercise, this might even create more chaos.

After some reduction of your critical activities duration or crashing (reduction in duration to its practical limit) then a new parallel critical path will emerge unless you want to create for fun float where not needed.

Best Regards,
Rafael
Mike Testro
User offline. Last seen 6 weeks 1 day ago. Offline
Joined: 14 Dec 2005
Posts: 4418
Hi Rafael

When I read the phrase "multiple critical paths" I reach for my fiddle detector.

I have never yet encountered more than one critical path that runs through a properly constructed programme that hasn’t been created artificially.

Best regards

Mike Testro
Rafael Davila
User offline. Last seen 1 day 16 hours ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Mike,

Under FS only schedules and no resource leveling and no constraints DRAG is a beauty. Under resource leveling it gets complicated but it still helps much. Its use is augmented in the case youe CPM has many paths that can potentially become critical, paths with low float amount. Drag tells you up to how much the actual critical path can be compressed and prevents over compressing activities when some portion does not further reduce total duration. Then perhaps no further reduction should be done on these activities but in others along the multiple critical paths.

Crashing after first critical path is compressed gets complicated, DRAG helps. Is not a magic bullet but good to have in your bag of tricks.

Best Regards,
Rafael
Mike Testro
User offline. Last seen 6 weeks 1 day ago. Offline
Joined: 14 Dec 2005
Posts: 4418
Hi Stephen

Its true I paddle about in the simple Construction Pond where FS Links and no constraints are best practice.

It is relatively easy to spot potential bottlenecks because I know where they happen and can schedule around them - scaffolding to a high level gable going through a low level roof is a typical example.

Even so a typical housing project could have as many as 10k tasks to control but it is relatively simple (but boring) when a routine is set up.

No I don’t have a new algorithm - I wouldn’t know what one was even if it crept up and bit my bum - I am at the level where I don’t need to know how to design a ball point pen in order to write a letter.

Of course if you are planning for something that has never been done before then most of the schedule is going to be pure guess work anyway so later improvements is a big advantage.

Even so the starting point must be the critical path and if circumstances create a new critical path then that has to be reviewed as and when it happens.

If you can forecast where these circumstances are most likely to arise then I can see the pro-active advantage.

Meanwhile I’ll stick to my pond.

Best regards

Mike Testro
Stephen Devaux
User offline. Last seen 18 weeks 6 days ago. Offline
Joined: 23 Mar 2005
Posts: 667
Hi, Mike.

I can’t say for certain, because I’m not sure I understand your filtering process -- but I honestly can’t see how what you describe would compute how much time each activity is adding to the duration, even in a short network.

On a small network with only FS relationships, DRAG is pretty easy to compute visually. On a large network with complex dependencies, it’s both difficult and very time-consuming without software help. (As a consultant, I’ve spent much time helping clients identify opportunities to recover schedules by papering my house with network diagrams. Without software, it would sometimes take more than a day to compute the DRAG in a 3000+ activity network.)

Knowing how much time each activity/bottleneck/constraint is adding to the project duration seems like a pretty fundamental metric -- more so than float (total or free), which pretty much every package computes, yet is off the critical path. You can have a thirty-day activity on the CP that’s only adding one day, but an eight-day activity that’s adding eight. But yet the metric, and even the idea of it, is not listed in the PMBOK Guide nor any other PM book I know of, and no software computed it prior to my book. It certainly was new info to both Vladimir Liberzon of Spider Project (you can ask him) and Joel Koppelman (founder and CEO of Primavera), enough so that Vladimir programmed an algorithm to do the computation in Spider.

So if you have a filter and simple algorithm that will compute it, I’d love it if you could send it to me.

"But what is the purpose - the critical tasks will be as tight as they possibly can be to start with."

Clearly, the projects you work on are very different from mine. Maybe what you describe is the norm on the construction projects you work on. I’ve done a little construction and that certainly hasn’t been my experience, but I won’t deny perhaps it’s been yours.

However, I’ve also worked with many other industries, and I can assure you that such is not the case in aerospace/defense, or nuke plant shutdowns, or pharma, or consumer electronics (and I won’t even mention information systems!). Before optimization of the schedule, it’s not unusual to have activities with hundreds of days of float, or four or more weeks of DRAG, on a two year project. Typically, I find that I can compress a schedule anywhere from 10% to 40%, and DRAG computation is what makes it possible.

I’d also add that even if "the critical tasks will be as tight as they possibly can be to start with", that may be how they start -- but it’s not how they’ll be when things start slipping! The the typical scheduler is scrambling to find places to recover, and the DRAG metric points him to productive areas.


Fraternally in project management,

Steve the Bajan
Mike Testro
User offline. Last seen 6 weeks 1 day ago. Offline
Joined: 14 Dec 2005
Posts: 4418
Hi Stephen

Surely you can create the same information by filtering on Non Crtical Tasks and then generating a critical path within the filter.

The difference will be the DRAG as you call it.

But what is the purpose - the critical tasks will be as tight as they possibly can be to start with.

Best regards

Mike Testro