Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Apr 2001
    Location
    Rockton, Illinois, USA
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #3
    New Lounger
    Join Date
    Apr 2001
    Location
    Rockton, Illinois, USA
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #5
    New Lounger
    Join Date
    Apr 2001
    Location
    Rockton, Illinois, USA
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: preference based assignment (2000 sp3)

    And what does TR/X for Moreno mean?

  7. #7
    New Lounger
    Join Date
    Apr 2001
    Location
    Rockton, Illinois, USA
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #9
    4 Star Lounger
    Join Date
    Oct 2005
    Posts
    599
    Thanks
    1
    Thanked 1 Time in 1 Post

    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
  •