# Thread: preference based assignment (2000 sp3)

1. ## preference based assignment (2000 sp3)

I have a spreadsheet that generates 10 random numbers and ranks the so that i end up with ten whole numbers. these numbers are then used to assign positions within a crew of ten individuals. how do i exclude certain assignment from those individauls that have a preference.

2. ## Re: preference based assignment (2000 sp3)

Can you explain in more detail what you want to accomplish? Perhaps with an example?

BTW, your formulas can be simplified if you create a small lookup table - see attached version.

3. ## Re: preference based assignment (2000 sp3)

several of the crewmen have a stated what assignments they prefer not to work. this may be one assignment or two or three. some don't care. i would like to just open the file, hit print and post the assignment schedule.

4. ## Re: preference based assignment (2000 sp3)

I assume that the second sheet lists those preferences. Some sport a * apparently meaning "days only". How is that to be incorporated in the assignment?

5. ## Re: preference based assignment (2000 sp3)

thanks for the lookup. i work a rotating shift which means that sometimes i work nights and sometimes i work days. i really wasn't worried about that now but i assume i would use a dialog box to enter if the schedule is for days or nights and if it is for three days or four days of shift work

6. ## Re: preference based assignment (2000 sp3)

And what does TR/X for Moreno mean?

7. ## Re: preference based assignment (2000 sp3)

the x stands for extra. the asterisk means "i will accept the assignment only on dayshift". n/a means "i dont care what the assignment is".

8. ## Re: preference based assignment (2000 sp3)

Perhaps someone else will come up with a solution, but I think it's beyond the scope of Woody's Lounge. Because of the addition of preferences, you may have to backtrack if a "straight" assignment cannot be completed, so formulas won't do.

9. ## Re: preference based assignment (2000 sp3)

I would like to help, but I'm not sure what the parameters are when it comes to scheduling...maybe dannio69 could write a fuller explanation of what he needs to consider when scheduling and what kind of scheds he is trying to produce....labels on he columns in his sample would help also....

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•