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

Threaded View

  1. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

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

    Seeing that there are more shifts than there are personnel, the system will, given enough time, rotate all personnel evenly through all positions. You can number the shifts or just list the employees and give them a number between 1 and 22. Both types of shift are shown here.

    Random numbers when applied to shifts often produce unacceptable results like an employee working many nearly consecutive shifts while others don't work very often.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

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