Results 1 to 6 of 6

Thread: [RESOLVED] Difficut assignment

Threaded View

  1. #1

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    San Jose, CA

    Resolved [RESOLVED] Difficut assignment

    The attached file is a staff scheduling tool for assigning staff to "slots" in 6 cafeterias. Each cafeteria has two shifts every day except Friday where there is no PM shift.I'm having great difficulty handling the coding for a few special staff members. Let's assume one of them is Marty. All assignments should be random. The rules for Marty' are:

    1. Marty must work in all cafeterias by the end of the week. Double shifts where he works in one cafeteria in the AM shift and in the same or different cafeteria in the PM shift are OK.
    2. Marty may not be in more than one cafeteria in a shift on the same day.
    3. Marty's count of shifts at the end of the week should be a minimum of 6 and maximum of 10.
    4. Cafeteria's 2, 5 and 6 have lighter traffic than the others. They are highlighted in yellow on the worksheet. Marty can only work in those cafeterias once a week.

    Marty's name should appear in his assigned slots.
    Attached Files Attached Files

Posting Permissions

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

Click Here to Expand Forum to Full Width