Go Back   TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



calculate Sum of all slack in ms project

Microsoft Project


Reply
 
Thread Tools Search this Thread
  #1  
Old 05-09-2011
Member
 
Join Date: Nov 2008
Posts: 2
calculate Sum of all slack in ms project

Hi all,

I'm trying to calculate the sum of all the slack between two milestones (i.e. how many days milestone 1 can be delayed before it effects milestone 2). They are linked together by a number of activitivies of varying durations, with 'gaps' between end dates and start dates due to other constraints. The two milestones are not on the critical path so total slack does not give me the answer, neither does free slack, because the tasks are also linked to other activities outside of this strand.

I'll try and give a simple example, all items are linked together sequentially, and i have included weekends as working days just to keep the maths simple.

Milestone 1 - 1/05/11 - no days slack
task a - 01/05/11-31/05/11 - 10 days slack (only showing 2 days slack because it's linked to another task starting on 02/06, which is part of another strand linking to a completely different milestone)
task b - 10/06/11-15/06/11 - 5 days slack
task c - 20/06/11-30/06/11 - 5 days slack
Milestone 2 - 15/07/11 - 15 days slack

There is the method of just increasing the start date of milestone 1 until milestone 2 changes, but it's not exactly scientific...any suggestions would be most welcome!

thanks...Luni.

Reply With Quote
  #2  
Old 05-09-2011
Member
 
Join Date: Dec 2007
Posts: 1,728
Re: calculate Sum of all slack in ms project

Add the Start Slack and Finish Slack fields to any task view when you want to review how free slack was calculated. The Start Slack field contains the duration representing the difference between the early start and late start dates. The Finish Slack field contains the duration representing the difference between the early finish and late finish dates. More information can be found here.
Reply With Quote
  #3  
Old 05-09-2011
Member
 
Join Date: Nov 2008
Posts: 2
Re: calculate Sum of all slack in ms project

Hi James,

Thanks for the response, unfortunately, I can't use the Finish slack figures. See my example...
the sum off all the slack between the two milestones is 35 days, however, because 'task a' has two successors (one of which is not in the strand of the two milestones), it is showing only 2 days slack, not 10. Thus giving me 27 days slack overall, this is not correct.

I've attached an example gantt to demonstrate what I mean.
Attached Thumbnails
sum-slack.jpg  
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "calculate Sum of all slack in ms project"
Thread Thread Starter Forum Replies Last Post
How to view the link between the deliverable project task and the dependency project task in project pro 2010 Hevel Microsoft Project 4 20-04-2012 11:22 PM
Error opening Project 2007 file after using project 2010 Jio Microsoft Project 3 10-11-2010 07:27 PM
MS Project 2003 assigning values of individual project workdays within a summary task ttippie Windows Software 1 20-08-2010 01:27 AM
Critical Path and Negative Total Slack BoanHed Microsoft Project 3 16-06-2008 11:49 AM
Project 2007 Client Cannot Connect To Project Server 2003 PARRISH Microsoft Project 1 21-02-2007 10:24 PM


All times are GMT +5.5. The time now is 11:13 AM.