+ Reply to Thread
Results 1 to 4 of 4

Need help relating a list of random numbers to a list of names so that i can create a rota

Hybrid View

  1. #1
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Need help relating a list of random numbers to a list of names so that i can create a

    Hi

    Wouldn’t it be easier and fairer to just rotate staff through the different tasks? If you use a genuinely random system, you’ll find some people repeating tasks and some seldom doing some. Also, if you have more staff than roles to fill, a random system will not distribute the days off equally in the short term. These things will average out in the long term, but staff may not see it that way if they get several days without work.

    Anyway … one way to randomise task allocation and ensure there is no duplication of roles would be to put random numbers next to each name and then allocate tasks according to the rank of those random numbers. So the highest random number is reception 1, the second highest is reception 2, and so on. Each time you refresh the sheet the random numbers and their ranks will change, allocating that position to different people.

  2. #2
    Registered User
    Join Date
    09-10-2013
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Need help relating a list of random numbers to a list of names so that i can create a

    But given that there are 30 distinct duties and only 22 staff members, i would have to devise a formula to randomly determine who the 8 additional staff members were. This is something i have been struggling with - i have also found it tremendously difficult to 'translate' that kind of information into anything resembling a staff rota. I don't know how to relate the unique random numbers to the names/tasks to allow the creation of an instantaneous rota. I'm obviously missing something... I have attached what i have done thus far.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create a list of the sum of random numbers
    By tddavid89 in forum Excel General
    Replies: 2
    Last Post: 11-08-2012, 03:17 AM
  2. Replies: 2
    Last Post: 08-01-2012, 01:24 PM
  3. [SOLVED] How can I create a list of random numbers with no duplicates?
    By Kwasniewski in forum Excel General
    Replies: 2
    Last Post: 05-14-2006, 09:50 PM
  4. [SOLVED] If I create a random list in Excel, does it repeat numbers?
    By Kelly in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-29-2005, 11:06 PM
  5. Setting up a random list from long list of names ?
    By yorkshire exile in forum Excel General
    Replies: 4
    Last Post: 01-06-2005, 10:06 AM

Tags for this Thread

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