Critical Path for a Subset of Schedule

%3CLINGO-SUB%20id%3D%22lingo-sub-3485690%22%20slang%3D%22en-US%22%3ECritical%20Path%20for%20a%20Subset%20of%20Schedule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3485690%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%20Can%20critical%20path%20be%20seen%20for%20a%20subset%20of%20schedule%20instead%20of%20entire%20schedule%20%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20program%20schedule%2C%20which%20runs%20for%20over%203%20years.%20The%20entire%20schedule%20is%20broken%20down%20into%20sizeable%20%22Work%20Packages%22%20and%20there%20are%20deliverables%20%26amp%3B%20milestones%20for%20every%20work%20package.%26nbsp%3B%20The%20future%20work%20packages%20are%20just%20place%20holders%20and%20the%20work%20packages%20which%20have%20their%20deliverables%20in%20the%20next%204%20months%20are%20active%20work%20packages.%20There%20are%20multiple%20active%20work%20packages%20and%20they%20do%20not%20link%20to%20each%20other%20i.e.%20they%20are%20not%20dependent%20on%20one%20another.%3C%2FP%3E%3CP%3EOnly%20for%20these%20active%20work%20packages%2C%20detailed%20tasks%20are%20identified%20and%20their%20dependencies%20are%20linked%20to%20the%20work%20package's%20deliverables%20%26amp%3B%20milestones%20etc.%26nbsp%3B%3C%2FP%3E%3CP%3EThese%20active%20work%20packages%20are%20not%20linked%20to%20each%20other.%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20often%20these%20work%20package's%20has%20their%201st%20task%20to%20start%20on%20a%20particular%20date%20i.e.%20they%20have%20%22Must%20start%20on%22%20constraint%20and%20then%20the%20subsequent%20tasks%20are%20identified%20and%20linked%20to%20each%20other.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20I%20need%20to%20find%20the%20critical%20path%20for%20these%20individual%20work%20packages%20i.e.%20which%20of%20the%20tasks%20within%20the%20work%20package%20when%20delayed%20will%20delay%20the%20milestone%20of%20that%20particular%20work%20package.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECritical%20path%20filtering%20%26amp%3B%20highlight%20feature%20works%20when%20the%20entire%20schedule%20is%20linked%20and%20these%20give%20the%20critical%20path%20for%20entire%20schedule.%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20how%20do%20I%20find%20the%20critical%20path%20for%20a%20subset%20of%20schedule%20i.e.%20in%20my%20case%2C%20critical%20path%20of%20the%20work%20package(s)%20%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20crude%20way%20is%20to%20copy%20paste%20a%20work%20package%20on%20another%20.mpp%20file%2C%20and%20use%20filter%20%2F%20highlight%20critical%20path%20feature.%26nbsp%3B%20Another%20way%20is%20to%20make%20each%20work%20package%20as%20a%20sub-project%20with%20independent%20.mpp%20file%20and%20have%20a%20master%20schedule%20linking%20all%20sub-projects.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20want%20to%20do%20both%20of%20these%20due%20to%20level%20of%20complexities%20involved.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20how%20do%20I%20find%20a%20critical%20path%20for%20a%20work%20package%20alone%20%3F%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20thoughts%20please%20%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3488679%22%20slang%3D%22en-US%22%3ERe%3A%20Critical%20Path%20for%20a%20Subset%20of%20Schedule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3488679%22%20slang%3D%22en-US%22%3ENKumar2010%20--%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20Microsoft%20Project%2C%20there%20is%20no%20way%20to%20display%20a%20Critical%20Path%20for%20only%20a%20subset%20of%20tasks%20in%20a%20project.%20Sorry%2C%20but%20hope%20this%20helps.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3489981%22%20slang%3D%22en-US%22%3ERe%3A%20Critical%20Path%20for%20a%20Subset%20of%20Schedule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3489981%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1370364%22%20target%3D%22_blank%22%3E%40NKumar2010%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWow%2C%20that's%20sounds%20a%20whole%20lot%20like%20schedules%20I%20used%20to%20work%20with%2C%20near%20term%20active%20tasks%20and%20longer%20term%20planning%20packages.%20I%20believe%20there%20is%20a%20way%20to%20see%20the%20critical%20paths%20you%20want.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOur%20schedules%20had%20major%20milestones%20tied%20to%20phases%20of%20the%20overall%20plan.%20To%20get%20a%20view%20of%20the%20path%20to%20any%20particular%20milestone%20I%20set%20an%20earlier%20%22finish-no-later-than%22%20constraint%20on%20that%20milestone.%20That%20immediately%20set%20up%20negative%20slack%20on%20those%20tasks%20leading%20up%20to%20the%20milestone%2C%20hence%20a%20critical%20path%20to%20that%20milestone.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGive%20it%20a%20shot.%3C%2FP%3E%3CP%3EJohn%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3506238%22%20slang%3D%22en-US%22%3ERe%3A%20Critical%20Path%20for%20a%20Subset%20of%20Schedule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3506238%22%20slang%3D%22en-US%22%3E%3CP%3ESimilar%20to%20what%20John%20suggested%2C%20I%20set%20a%20deadline%20on%20the%20target%20task%20that%20is%20several%20years%20in%20the%20past.%20That%20forces%20the%20task%20onto%20the%20critical%20path%20and%20the%20task%20has%20a%20lot%20of%20negative%20slack.%20In%20fact%2C%20if%20you%20set%20the%20deadline%20far%20enough%20in%20the%20past%2C%20the%20task%20in%20question%20will%20have%20the%20greatest%20amount%20of%20negative%20slack%20of%20all%20the%20tasks.%20Now%20filter%20the%20'Total%20Slack'%20column%20so%20you%20are%20only%20displaying%20tasks%20with%20that%20value.%20That's%20your%20critical%20path%20to%20your%20intermediate%20milestone.%20It%20is%20what%20some%20people%20call%20the%20'first%20critical%20path'.%20If%20you%20want%20to%20see%20the%20'second%20critical%20path'%2C%20filter%20for%20the%20second%20largest%20amount%20of%20total%20slack%2C%20and%20so%20on%20for%203rd%20critical%20path.%20Don't%20forget%20to%20remove%20the%20deadline%20when%20you're%20done!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20was%20actually%20a%20question%20I%20was%20asked%20in%20an%20interview%20several%20years%20ago.%20Hope%20this%20helps.%20Good%20luck.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1370364%22%20target%3D%22_blank%22%3E%40NKumar2010%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi,

  Can critical path be seen for a subset of schedule instead of entire schedule ? 

 

I have a program schedule, which runs for over 3 years. The entire schedule is broken down into sizeable "Work Packages" and there are deliverables & milestones for every work package.  The future work packages are just place holders and the work packages which have their deliverables in the next 4 months are active work packages. There are multiple active work packages and they do not link to each other i.e. they are not dependent on one another.

Only for these active work packages, detailed tasks are identified and their dependencies are linked to the work package's deliverables & milestones etc. 

These active work packages are not linked to each other. 

Also, often these work package's has their 1st task to start on a particular date i.e. they have "Must start on" constraint and then the subsequent tasks are identified and linked to each other.  

 

Now I need to find the critical path for these individual work packages i.e. which of the tasks within the work package when delayed will delay the milestone of that particular work package. 

 

Critical path filtering & highlight feature works when the entire schedule is linked and these give the critical path for entire schedule. 

But how do I find the critical path for a subset of schedule i.e. in my case, critical path of the work package(s) ?  

 

One crude way is to copy paste a work package on another .mpp file, and use filter / highlight critical path feature.  Another way is to make each work package as a sub-project with independent .mpp file and have a master schedule linking all sub-projects. 

I don't want to do both of these due to level of complexities involved. 

 

So how do I find a critical path for a work package alone ? 

Any thoughts please ? 

3 Replies
NKumar2010 --

In Microsoft Project, there is no way to display a Critical Path for only a subset of tasks in a project. Sorry, but hope this helps.

@NKumar2010 

Wow, that's sounds a whole lot like schedules I used to work with, near term active tasks and longer term planning packages. I believe there is a way to see the critical paths you want.

 

Our schedules had major milestones tied to phases of the overall plan. To get a view of the path to any particular milestone I set an earlier "finish-no-later-than" constraint on that milestone. That immediately set up negative slack on those tasks leading up to the milestone, hence a critical path to that milestone.

 

Give it a shot.

John

Similar to what John suggested, I set a deadline on the target task that is several years in the past. That forces the task onto the critical path and the task has a lot of negative slack. In fact, if you set the deadline far enough in the past, the task in question will have the greatest amount of negative slack of all the tasks. Now filter the 'Total Slack' column so you are only displaying tasks with that value. That's your critical path to your intermediate milestone. It is what some people call the 'first critical path'. If you want to see the 'second critical path', filter for the second largest amount of total slack, and so on for 3rd critical path. Don't forget to remove the deadline when you're done!

 

This was actually a question I was asked in an interview several years ago. Hope this helps. Good luck.

@NKumar2010