+ Reply to Thread
Results 1 to 3 of 3

Schedule Darts League

  1. #1
    Registered User
    Join Date
    06-15-2020
    Location
    Eindhoven
    MS-Off Ver
    2016
    Posts
    19

    Schedule Darts League

    Hello,

    I'm looking for some vba-code that generates a schedule of dartmatches to be played.
    I have a vba-code that creates all possible matches to play each other:
    Please Login or Register  to view this content.
    The code is working well, but what I want is that the matches will be generated like this:
    Please Login or Register  to view this content.
    As you can see are the first two games player 1 - player 2 and player 8 - player 9. Player 6 and player 7 are the markers and so on. Within 1 match there are 3 players involved.

    I'm looking for a vba-code that generates the matches and the players that has to mark. The matches needs to played on two courts, so a player cannot play two matches at the same time.
    I've to to this manually, but maybe there is some code that generates this.

    There are 9 players. Totally there needs 72 matches to be played. Each player plays two games against each other and has to mark 8 matches.

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: Schedule Darts League

    Assuming you have nine names in A1:A9 then the following will generate *something* at least

    Please Login or Register  to view this content.
    WBD
    Office 365 on Windows 11, looking for rep!

  3. #3
    Registered User
    Join Date
    06-15-2020
    Location
    Eindhoven
    MS-Off Ver
    2016
    Posts
    19

    Re: Schedule Darts League

    The code is working well. Thank you.

    But what I want is that the matches are spread over x number of days, for example five days.
    Sometimes you play three matches on a day, sometimes four matches. I know that 36/5 = 7,2 matches a day, but with 7 games on a day per court, I have only 1 match left to be played in one of that days. That's no big deal. In my calculation I assume that everyone plays twice against each other.

    I can shoove with the matches that the code generated, but than some players play three matches after each other and that's not the intention. You can play a maximum of two matches in a row.

    I'm also trying to generate the matches for 8 players, but then I get some blanks in cells. Maybe there is a possibility to choose between 8 or 9 players? I understand it can be difficult to create such a code, but the beginning is made.
    Last edited by Schiavoni; 09-10-2020 at 07:47 AM.

+ 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. schedule generator darts
    By kerm007 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2019, 08:50 PM
  2. League Schedule Generator
    By bfragale in forum Excel General
    Replies: 0
    Last Post: 02-27-2019, 03:11 PM
  3. [SOLVED] Darts League Schedule - Irregular Pattern finding
    By lcartwright in forum Excel General
    Replies: 5
    Last Post: 05-05-2017, 09:54 AM
  4. League schedule
    By albundypolk33 in forum Excel General
    Replies: 0
    Last Post: 11-24-2014, 01:56 PM
  5. league schedule
    By Quicksnot in forum Excel General
    Replies: 3
    Last Post: 07-29-2014, 01:48 PM
  6. League Schedule
    By Vick in forum Excel General
    Replies: 1
    Last Post: 08-17-2006, 08:05 PM
  7. [SOLVED] Golf League Schedule
    By Golf League Schedule in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-20-2005, 11:06 AM

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