Thanks, ... View more

Thanks, Yes the outest has the data. ... View more

Thanks again. I owe you a large beer:-) ... View more

Thanks a million Rob. I was a bit further along than when I wrote the post, but far from a solution.   For Con1 and Con2 here you've coded the roles you can't have together. In real life there is approx. 20 roles to fill all with different roles you can't fullfill at the same time. on the top of your head is there a more dynamic way to write this constraint. If no it is not a large problem as the constraints can be created in a preceding macro.   Also in real life some persons have clear preferences for certain roles. This is for an offshore platform where the personnel change rapidly. Since there in most cases are several solutions to the problem you can be assigned role A day 1 and then role B day 2. My thoughts on how to avoid this is to give the role you have the day before the value 1 and your preferred role Value 2. From that i would just hav a Var multiplying value and assign and maximize on that. Do you see any problems with that approach?   Again thanks a lot. ... View more

Thanks, works like a dream ... View more

Thanks a million. I did not think about dictonary.tables. Shame on me.  ... View more

Thanks Falco. I tried creating a hierarchy the first time. However I created the hierarchy after I had added the Network Analyses and chosen Hierarchical. After your post I created the Hiearchy before adding the Network diagram and then i worked. Maybe a bug.   The Levels name is a bit confusing ... View more