Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

How to put more than to contraints on a task in MS proj

7 replies [Last post]
Wed, 2005-10-26 12:55
manulal inasu
User offline. Last seen 18 years 31 weeks ago. Offline
Joined: 15 Oct 2005
Posts: 52
Groups: None
Hi,

I am working in a ship repair project and the plan has got a lot of constraints. Any idea how to put more than two contraints on a task?

to explain my question, suppose i have a task "a" with 4 days duration and I have to put both "start no earlier than" and "finish no later than" constraints on this task.

I dont know whether its possible or not in MS Project. So I have developed a planning program in Excel in which it is possible. But it is too slow as the size is around 120 MB and lot of formulae involved. So i thought its better to find out a easier method in MS Project itself.

Can anybody help me please?
Top

Replies

Thu, 2012-08-16 16:13
#1
Michael Slawinski
User offline. Last seen 1 year 22 weeks ago. Offline
Joined: 31 Mar 2012
Posts: 13
Groups: Sarawak Primavera User Group (SPUG)

Establishing 2 relationships between tasks:

from the book MS Project 2007, 99 tricks and Traps, by Eastwood Harris

 

you need to insert a milestone in the loop to assign 2 constraints between tasks in MSP

 

ID Duration Predecessors Successors
1 10d   3SS;2
2 0d 1 3FF
3 5d 1SS; 2FF  
Top
Fri, 2005-10-28 05:10
#2
manulal inasu
User offline. Last seen 18 years 31 weeks ago. Offline
Joined: 15 Oct 2005
Posts: 52
Groups: None
Dear Larry, sukumaran,alex and zhang,

Thank you all for your replies, I tried start and finish milestones and it worked exactly as I wanted. Thank you guys.

I know very well that applying constraints is not at all good in a schedule because of many reasons. But the present project I am working on is a special case. I think you people will be astonished to know that the ship of which we are doing the refit will go to water 4 times during the period of refit and 4 different sub projects are to be included in the master plan which are linked to each other in a very complex manner and at the same time executed by diffeerent agencies and one of them being the Royal navy of Oman. So constraints are a must.

What you guys suggested saved me a lot of time, I spent a lot of hours in excel programming to meet these requirements, any way it was a nice experience.
Thank you to all once again.

One more thing I wanted to tell you, when I did resource levelling in MS project it took more time than the program I created in excel and the result was the same.

Manu.
Top
Thu, 2005-10-27 07:04
#3
Larry Blankenship
User offline. Last seen 12 years 15 weeks ago. Offline
Joined: 14 Oct 2005
Posts: 61
Groups: Petro-Chem / Oil & Gas
It’s not recommended, but what you might do is put a milestone at the end of the task with a must finish on constraint and must start on constraint on the task itself. Alternately, if you make the task type Fixed Duration, and then put a must start on constraint on it, that would have the same effect. However, be prepared to add resources if your schedule starts to slip.

As others have said, it’s probably not a good idea, as it will cause you no end of grief when you go to update and reschedule the remaining work.

Is there a reason you need to do it this way?

Larry
Top
Thu, 2005-10-27 02:02
#4
Sukumaran Subaram...
User offline. Last seen 9 years 4 weeks ago. Offline
Joined: 2 Mar 2005
Posts: 229
Groups: GPC Malaysia
Manulal,

A. 1st plot the schedule in MSP.
B. 2nd Go to Task Information:
B1. Assign constraint
B2. Enter deadline - A target date indicating when you want a task to be completed. If the deadline date passes and the task is not completed, project displays an indicator.

If you want to assign more than 2 constraints in MSP, I don’t think so you can do it, never come across such a situation. Suggest you create start and finish milestones and link the activity bar to milestones as a controlling factor.

Also before update the schedule save it as a baseline for your comparison between current and target.

Cheers!!!
Top
Thu, 2005-10-27 00:34
#5
Alex Wong
User offline. Last seen 11 years 20 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
echoooo.....
Top
Thu, 2005-10-27 00:21
#6
Zhang Haixiang
User offline. Last seen 3 years 44 weeks ago. Offline
Joined: 14 Apr 2005
Posts: 250
Groups: None
creat some dummy tasks with constraint and link to the task
Top
Wed, 2005-10-26 20:45
#7
Alex Wong
User offline. Last seen 11 years 20 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
Hi manulal

My question is how you build your schedule??

Constraints should be use in a very restricted condition in a CPM model.

Anyway to answer your question: If you want to have various condition (what you refer to constraints) to drive the activity - what you can do is to have varisoul predecessors activities and linked to the activity. that way the activity will be dependent on the predecessor conditions.

HTH - But I still insist use as little as possible on constraints

Good Luck

ALex
Top