Dependency Settings

Jody Gipson

i am trying to build a construction timeline for a project.  and i need to use different dependency time frames for different vendors in the same spreadsheet.  for example:

 

Permitting works on a business work week schedule.  so Mon-Fri no weekends and no holidays.

However the GC has agreed he wiil complete his work in exactly 120 from his starting day, meaning he will work days, weekend, holidays so to finish this job.  so how do I change his dependency settings for just his time frame.   the one part of the Gant chart would work off of a work week schedule of monday -Friday and his 4-5 rows needs to calculate based upon 120 calendar days

 

please help

Monikka Mann

Hi, 

 

I think if you use the elapsed time functionality, this should work. I have to do this a lot for testing.

 

Just put an 'e' in front of the duration: Elapsed time (lead with an e to indicate duration in elapsed time e.g. e3d, e5h, e3.5d, etc). A task with a duration in elapsed time ignores non-working time. The task will start and end in the amount of time specified regardless of working day length and non-working days in the sheet.

 

Hope this helps!

 

Monikka

Jody Gipson

yes that worked thank you

 

J. Craig Williams

Jody,

 

Read up on the elapsed dependency.

In a normal 8 hour per day sheet, 1d = 8h.

Using elapsed, it is 24h. Be careful.

 

Craig