+ Reply to Thread
Results 1 to 2 of 2

Building the schedule for a speed date algorithm

Hybrid View

wolf1015 Building the schedule for a... 03-10-2016, 11:44 AM
protonLeah Re: Building the schedule for... 03-10-2016, 06:31 PM
  1. #1
    Registered User
    Join Date
    03-10-2016
    Location
    Brussels
    MS-Off Ver
    2010
    Posts
    2

    Building the schedule for a speed date algorithm

    Hello everyone.

    The Problem
    I am working on a speed date project. The "who meets whom" part is already solved, and the output of that is a full list with all the pairs that will be meeting that day. The actual speed dating day will consist of N rounds, and will have P participants. The restrictions are:
    • P is an even number
    • Each participant is represented by a number, from 1 to P
    • N is equal or lower than P-1
    • Each person meets N other people, and is seen by N people as well. Consequently, people don't "sit out" (i.e. everyone must meet someone on all rounds)
    • People meet in pairs, and naturally, one person can only have one meeting on each round.


    The Need
    Does anyone know an algorithm that could help me address the issue exposed on Example 2? (i.e. indicates which pairs are meeting in which round).

    The Input
    As for the input, you are given a list with 2 columns. Each line contains a pair that must meet, and there are " P * N / 2 pairs "(i.e. each round accommodates P/2 pairs). The lowest number between the two people is on the left column. Not sure this matters.

    I can also point out that N will probably be 3, 4 or 5, and that P will be somewhere in the range of 30-40 (again, even numbers only). I don't need the fastest solution in the world. If you have an algorithm that solves the problem in under 6 hours with the power of an average desktop, I am happy enough.

    Examples
    2 examples: Example 1 has 6 people and 4 rounds. Example 2 has 30 people and 4 rounds.

    Output of the example 1: One can read the table as: (1st line example) Person1(p1) is meeting p2 on round1, then meets p3 on round 2, then p4 on r3, and finally p5 on r4

    Output of the Example 2: This showcases where one can start seeing some issues: as we try to allocate the pairs, some clashes start to occur. 1st clash in this example occurs at Yellow (line 19 of the input), and a 2nd clash occurs at red (line 29 of the input). The yellow case was "solved" by simply delaying the pair 6 & 10 to the 2nd round. But when we try to make players 8 & 9 meet, we can see how attempting to make that happen, would cause a cascade of effects on the table.


    SDall.png

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,926

    Re: Building the schedule for a speed date algorithm

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

    1. Our answerers are looking to "help" more often than they are looking to "do an entire project for you for free".
    2. Jump into this project yourself, when you get stuck on ONE specific hurdle, post that ONE item as a forum question.
    3. Show us what you've tried in an attached sample workbook and how it's not working for you. When you're doing the work yourself, just writing out a complete example question in a forum often points you to solution before you even finish posting.
    4. If you can't make any headway at all and no help is forthcoming in the free forum(s), we do have a Commercial Services forum where you can pay for assistance directly from our EF gurus."
    Ben Van Johnson

+ 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. Building a simple Survey Tool in Excel with some specific logical algorithm
    By abu0022 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-29-2016, 06:50 PM
  2. want to speed up a loop algorithm
    By freak11 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2014, 06:33 PM
  3. [SOLVED] Need Help building a schedule
    By gburwell88 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-14-2012, 01:12 PM
  4. Duty Schedule i'm building, looking for advice
    By tlbliss in forum Excel General
    Replies: 1
    Last Post: 03-07-2011, 08:29 PM
  5. Building a duty schedule, not sure what to do now.
    By tlbliss in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-07-2011, 08:29 PM
  6. trying to organize a building schedule!
    By hcubed in forum Excel General
    Replies: 1
    Last Post: 04-01-2008, 01:33 AM
  7. Schedule building help please
    By Macmo in forum Excel General
    Replies: 0
    Last Post: 12-04-2005, 08:40 PM

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