+ Reply to Thread
Results 1 to 4 of 4

Creating roster with a few rules using Excel

  1. #1
    Registered User
    Join Date
    06-11-2009
    Location
    asd
    MS-Off Ver
    Excel 2003
    Posts
    27

    Creating roster with a few rules using Excel

    Hi, I need to create a monthly roster which schedules 2 people to be on duty each day. The parameters I need included are:

    1. No 2 same people should be together as far as possible (i.e. A & B, A & C, not A&B, A&B, ...)
    2. When a person goes on leave, is there some kind of formula I can use to continue pairing people up with the above rule but 'replacing' this person who is away?

    Also, anyone know how I can check older posts that I have made? I can't find a link which shows me all my posts, and so far have had to manually scroll through pages to try and look for my previous posts.

    Thanks!

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Creating roster with a few rules using Excel

    Hi frutz,

    Go to this link and click the "Search Now" button:

    frutz

    You might want to save the link (right click).

    Cheers,
    Last edited by ConneXionLost; 06-19-2009 at 02:11 AM. Reason: save comment
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Registered User
    Join Date
    06-11-2009
    Location
    asd
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: Creating roster with a few rules using Excel

    Thanks for the quick reply . so I have to remember the titles of the threads I've posted? i was wondering if there was any link which would show all of my past posts?

    Any idea how to go about the schedule?

  4. #4
    Registered User
    Join Date
    09-14-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Creating roster with a few rules

    Hi

    Hi, I need to create a monthly roster which schedules 4 people to be on duty each day 24/7.

    1. Person 1 always come in day and afternoon shift only , (this person can act as reliver for day and afternoon shifts)

    2. Person 2 , 3 and 4 have to be in all shifts on rotation basis
    3. all three should get 2 days weeklyoff...


    i m doing it manually... Is there any formula.

    Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1