Creating relative date restrictions
in [Project]
|
Prev: How to handle Units changed in Tasks
Next: How to add cost expended, cost allowed, hours expended without actual resources
From: hayansekki724 on 17 Nov 2009 05:39 delete please -- hayansekki724 ------------------------------------------------------------------------ hayansekki724's Profile: http://forums.techarena.in/members/155494.htm View this thread: http://forums.techarena.in/microsoft-project/1272064.htm http://forums.techarena.in
From: Jim Aksel on 17 Nov 2009 09:38 Try using a hammock task (Read FAQ#19 here: http://project.mvps.org/faqs.htm Use this twist. Establish two milestones. M1 is SS+10days with Task1. M2 is FF+20days to the Finish of Task1. Your Hammock (Task2) has a start of M1 and a finish of M2. This essentially offsets your Task 2 from Task1. There is a concern however. You are requesting a start of task2 "NET." Ifit starts 3 weeks later is that OK? If it starts later does it still have to FNET 4 weeks after Task1? Could it finish 10 weeks later? The solution I have given will only supply one possible scenario. You will have to adjust the milestone dates lag values to accomplish the result. That you will have to do on the fly. Since your task start and ends are somewhat vague, you should also consider other items that may constrain the duration, work, and cost of Task2. -- If this post was helpful, please consider rating it. Jim Aksel, MVP Check out my blog for more information: http://www.msprojectblog.com "hayansekki724" wrote: > > I'm trying to create a relative time constraint in project, but I can't > seem to find any option other than entering a fixed date. Example > below. > > I want task 2 to start no earlier than two weeks after task 1 > completes, and I want task 2 to complete no earlier than four weeks > after task 1 completes. I don't want to enter the actual value of ([task > 1 complete date]+[2 weeks]) for my start date, because task 1 will have > an end date that is variable. > Can anyone tell me how I could get Project (2007) to accept a formula > for the date restrictions? > > Thanks in advance! > > > -- > hayansekki724 > ------------------------------------------------------------------------ > hayansekki724's Profile: http://forums.techarena.in/members/155494.htm > View this thread: http://forums.techarena.in/microsoft-project/1271993.htm > > http://forums.techarena.in > > . >
From: hayansekki724 on 17 Nov 2009 10:54 Thanks guys. VBA is probably more than I want to mess with to get my project working, but I get the idea of the hammock task. If I understand it correctly, I'm going to need a couple of dummy tasks in here to drive the dates, which won't look great in my network diagram, but it's better than having my dates wrong. Thanks for both your ideas. -- hayansekki724 ------------------------------------------------------------------------ hayansekki724's Profile: http://forums.techarena.in/members/155494.htm View this thread: http://forums.techarena.in/microsoft-project/1271993.htm http://forums.techarena.in
From: "Steve House" sjhouse at hotmail dot on 17 Nov 2009 15:54 Task 1 is linked to Task 2 with a conventional finish to start dependency link. Such a link says Task 2 can begin no earlier than the finish of Task 1. Now click the link arrow and add a +2week lag time. NowTask 2 may start no ealier than 2 weeks after the completion of Task 1. Task 1 get delayed, Task 2 will too. Set Task 2's duration to 2 weeks. 2 weeks lag plus 2 weeks duration means the expected finish of 2 will be 4 weeks after the completion of task 1. Note - you should NOT be setting dates for individual tasks. Duration, links, and resource availability, not management's desires, determine when tasks are able to take place. -- Steve House MS Project Trainer & Consultant "hayansekki724" <hayansekki724.41sarb(a)DoNotSpam.com> wrote in message news:hayansekki724.41sarb(a)DoNotSpam.com... > > I'm trying to create a relative time constraint in project, but I can't > seem to find any option other than entering a fixed date. Example > below. > > I want task 2 to start no earlier than two weeks after task 1 > completes, and I want task 2 to complete no earlier than four weeks > after task 1 completes. I don't want to enter the actual value of ([task > 1 complete date]+[2 weeks]) for my start date, because task 1 will have > an end date that is variable. > Can anyone tell me how I could get Project (2007) to accept a formula > for the date restrictions? > > Thanks in advance! > > > -- > hayansekki724 > ------------------------------------------------------------------------ > hayansekki724's Profile: http://forums.techarena.in/members/155494.htm > View this thread: http://forums.techarena.in/microsoft-project/1271993.htm > > http://forums.techarena.in >
From: hayansekki724 on 17 Nov 2009 19:18
Thank you, this is very helpful. I knew there must be some way to do it. In what view do I click the link arrow? (I'll probably figure this out myself when I get into the office). It's not a two week duration task, but this will look neater than using hammock tasks. The project owner's specifications determine when the tasks can take place in this case, so I don't have much option there. :p Steve House;4694027 Wrote: > Task 1 is linked to Task 2 with a conventional finish to start > dependency > link. Such a link says Task 2 can begin no earlier than the finish of > Task > 1. > Now click the link arrow and add a +2week lag time. NowTask 2 may > start no > ealier than 2 weeks after the completion of Task 1. Task 1 get > delayed, > Task 2 will too. Set Task 2's duration to 2 weeks. 2 weeks lag plus > 2 > weeks duration means the expected finish of 2 will be 4 weeks after > the > completion of task 1. > > Note - you should NOT be setting dates for individual tasks. > Duration, > links, and resource availability, not management's desires, determine > when > tasks are able to take place. > -- > Steve House > MS Project Trainer & Consultant -- hayansekki724 ------------------------------------------------------------------------ hayansekki724's Profile: http://forums.techarena.in/members/155494.htm View this thread: http://forums.techarena.in/microsoft-project/1271993.htm http://forums.techarena.in |