Results 1 to 2 of 2

Thread: Attempting some timetabling...a friend suggested you might be able to help

  1. #1

    Attempting some timetabling...a friend suggested you might be able to help

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a timetabling issue that I need to deal with and a friend suggested that some Excel gurus might be able to help me out with it.

    It is a simple problem, and I could probably spend a few hours doing it manually, but it is something I would like to repeat in the future and it would be great to have some sort of system to do all the hard work for me.

    I have 10 locations, and 20 people.

    The idea is to have two people at each location, however, each person must be with a different person at the next location.

    So in simple terms..

    location1, Person1 and Person2
    location2, Person3 and Person4
    location3, Person5 and Person6

    and so on up to 10 locations and 20 people.

    Then move them all to the next location, hoping it would look something like this..

    location1, Person3 and Person5
    location2, Person6 and Person2
    location3, Person1 and Person4

    It does not matter in what order they go or with whom, so long as at the end of the day, everyone has visited each location and in each location they were with a different person.

    Any ideas on how I can set this up, so that it will automatically generate a system, as doing it manually is proving to be quite painful.

    Or if excel is not the tool, any suggestions on a tool that can do this would be gratefully received.

    Thanks in advance.

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    I found an Excel spreadsheet called IanBalancedRoundRobin on the web that seems to do it. Google it.

Posting Permissions

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