Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-26-2011, 11:21 AM
AndreT AndreT is offline Critical Path w/ 2 Calendars Windows XP Critical Path w/ 2 Calendars Office 2000
Novice
Critical Path w/ 2 Calendars
 
Join Date: Jan 2011
Location: So. Ca
Posts: 7
AndreT is on a distinguished road
Question Critical Path w/ 2 Calendars

I have several calendars, one for 365 days a year without holidays, for tests like microbiology incubation, another for 7 days a week but allow holidays used during crunch time, and 5 days a week, a normal one.



I believe this causes problem with my critical path calculation, here's what happened -

Task 1 uses 365 days calendar, takes 5 days from Mon-Fri,
Task 2 follows and uses 5 d/w calendar, takes 2 days from next Mon-Tue.

The critical path calculation shows task 1 has 2 slack days, not in critical path

I tried to use Options>Calculation and set "Tasks are critical if slack is less than or equal to" as 2 days, but it shows too many tasks

Anyone has any suggestion on how to show the true critical paths Thanks for your advice in advance.
Reply With Quote
  #2  
Old 07-26-2011, 01:47 PM
Kimberly Kimberly is offline Critical Path w/ 2 Calendars Windows 7 64bit Critical Path w/ 2 Calendars Office 2010 64bit
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

I'm not sure I follow, because it seems to me that Task 1 should not be in the critical path (if you started Task 1 on Wed instead of Mon, it would not change the start date of Task 2, meaning Task 1 has 2 days of slack).

If it is that you need for the task to finish during work hours Friday, maybe try setting a FNLT constraint on Task 1 for Friday and see if that helps.
Reply With Quote
  #3  
Old 07-26-2011, 02:08 PM
AndreT AndreT is offline Critical Path w/ 2 Calendars Windows XP Critical Path w/ 2 Calendars Office 2000
Novice
Critical Path w/ 2 Calendars
 
Join Date: Jan 2011
Location: So. Ca
Posts: 7
AndreT is on a distinguished road
Default Standard CPA Incorrect under 2 calendars

That was my point, task 2 can not move ahead even though task 1 still has 2 days slack. As a result, the critical path filter won't show task 1 and any critical path tasks before task1. The whole project shows task 2 as the only one task in the critical path, that's it.

The early/late start/finish date calculation for the slack doesn't work under 2 different calendars. May be it should be based on the more restrictive calendars between the two task? Any article discuss this special case? Need advice on the alternatives in MS Project?

BTW, what is FNLT?

Last edited by AndreT; 07-26-2011 at 02:30 PM. Reason: clarification
Reply With Quote
  #4  
Old 07-26-2011, 03:51 PM
Kimberly Kimberly is offline Critical Path w/ 2 Calendars Windows 7 64bit Critical Path w/ 2 Calendars Office 2010 64bit
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Quote:
task 2 can not move ahead even though task 1 still has 2 days slack. As a result, the critical path filter won't show task 1 and any critical path tasks before task1
I respecfully disagree. The critical path filter won't show task 1 because it is not critical... If something goes amiss, and you don't start task 1 on time, there is no affect on task 2 or on the project finish date.

Critical means that if it finishes late then some other task or the project finish date will be affected. Task 1 is not critical; if you don't start it until Tuesday, it won't hurt anything.

Critical does not mean that the next task cannot start early. It means that this task cannot get behind.

FNLT is Finish No Later Than constraint.
Instead though, add 2 days of lag time to Task 1. This should make it critical.
Reply With Quote
  #5  
Old 07-26-2011, 04:35 PM
AndreT AndreT is offline Critical Path w/ 2 Calendars Windows XP Critical Path w/ 2 Calendars Office 2000
Novice
Critical Path w/ 2 Calendars
 
Join Date: Jan 2011
Location: So. Ca
Posts: 7
AndreT is on a distinguished road
Default

Hi, Kimberly -

My problem is the schedule shows Task 2 as the only task in the critical path.

I want to know if there is any alternative in MS Project to show Task 1 in critical path even though it has 2 days slack time, Task 2 can not move any further ahead.

If no other alternative, I'll have to add a 2 day dummy task and watch it, or go back to option 2 days.
Reply With Quote
  #6  
Old 07-26-2011, 05:36 PM
Kimberly Kimberly is offline Critical Path w/ 2 Calendars Windows 7 64bit Critical Path w/ 2 Calendars Office 2010 64bit
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Did you try adding 2 days of lag to Task 1?

If you're not sure how... Double-click on Task 1. Go to the Predecessors tab. Click in the Lag field and type a 2 and press Enter.

I hope this will get it!

Last edited by Kimberly; 07-26-2011 at 05:49 PM. Reason: typo fix
Reply With Quote
  #7  
Old 07-27-2011, 11:22 AM
AndreT AndreT is offline Critical Path w/ 2 Calendars Windows XP Critical Path w/ 2 Calendars Office 2000
Novice
Critical Path w/ 2 Calendars
 
Join Date: Jan 2011
Location: So. Ca
Posts: 7
AndreT is on a distinguished road
Default

Hi, Kimberly -

Thanks for your advice. I can do that.

Andre
Reply With Quote
Reply

Tags
cpa; weekend

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Critical Path w/ 2 Calendars Relative path to desktop b0x4it Word VBA 4 05-18-2011 11:50 PM
HELP! Rebuilt box & IRM lock out of critical docs markcal Office 0 04-25-2010 11:45 AM
Template path question phreeq Word 3 02-22-2010 05:08 PM
Critical Path w/ 2 Calendars Saving files in a specific path bjtrain83 Word 1 01-10-2010 02:36 PM
Critical Path w/ 2 Calendars get file name without Path Ziggy1 Word VBA 1 09-29-2006 07:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:13 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft