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.

Summarizing Total Slack

3 replies [Last post]
Ernie Bilbrough
User offline. Last seen 11 years 22 weeks ago. Offline
Joined: 30 Jul 2012
Posts: 6
Groups: None

I'm looking for a way to summarize the total slack of my project.

Does MSProject have a way to calculate average or net of my 200+ tasks total slack?

Replies

Ernie Bilbrough
User offline. Last seen 11 years 22 weeks ago. Offline
Joined: 30 Jul 2012
Posts: 6
Groups: None

Is there a way to calculate the sum or net total slack?

Ernie Bilbrough
User offline. Last seen 11 years 22 weeks ago. Offline
Joined: 30 Jul 2012
Posts: 6
Groups: None

Is there a way to calculate the sum or net total slack?

Stephen Devaux
User offline. Last seen 34 weeks 2 days ago. Offline
Joined: 23 Mar 2005
Posts: 667

I guess any knowledge is always better than no knowledge. But the difference in value between knowing the average slack in a schedule and not knowing it is probably as little as is imaginable. Why would you want to know this?

Let's imagine two scenarios, A and B:

In A, you have 200 acitivities of which 50 have zero slack and 150 have four days of slack each, for an average of three days of slack ([4 * 150] / 200) for all 200 activities.

In B, you have 200 acitivities of which 49 have zero slack, one has 600 days of slack and the other 150 have four days of slack each, for an average of five days of slack ({400 + [4 * 150]} / 200) for all 200 activities.

Is there really some significance to B having an average of twice as  slack? If so, I don't see it.

Interestingly, if it were critical path drag we were talking about, it might matter what the average drag of the critical path activities are. If we have 50 CP activities and they have a total drag of 500 days for an average drag ten days each, it tells me that somewhere there is still an opportunity to optimize (i.e., compress) the schedule, whereas if the total drag is just 100 days for an average of two days each, there may not be a great deal more to be wrung out of the schedule.

Fraternally in project management,

Steve the Bajan