+ Reply to Thread
Results 1 to 2 of 2

Round robin tournament

  1. #1
    Registered User
    Join Date
    03-21-2018
    Location
    birmingham
    MS-Off Ver
    office 365
    Posts
    1

    Round robin tournament

    Hi i am trying to find a spread sheet that i can run a round robin tournament at one venue with 4 rinks for indoor bowls has any one any suggestions please

  2. #2
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: Round robin tournament

    Welcome to the forum!

    I don't know of any ready-made templates for round robin scheduling, but I previously helped someone with a similar request by creating a rough "tracker" for scheduling matches. I don't know your exact needs, but the attachment uses the matrices in J1:R9 and A1:C9 to track how even your schedule is as you assign matchups in columns F and G. Currently, the data in the attachment schedules 8 teams for two matches against each opponent using 4 different venues/rinks. The worksheet is also set up to help you even out the number of times each team is assigned as the home or away side, though I'm not sure if that matters to your project. Anyway, the idea is to use the matrices to build one set (7 matchdays) of matchups in which each team plays the others once, then duplicate that set while switching the home/away sides to give you a balanced schedule in which every team plays the others twice (once as the home side, once away). Double it again if you need them to play their opponents 4 times, etc. The formula that provides the matchup tracker matrix in K2 is:

    =IF(K$1=$J2,"X",COUNTIFS($F:$F,K$1,$G:$G,$J2)+COUNTIFS($F:$F,$J2,$G:$G,K$1))

    Fill right and down to complete the matrix. All formulas can be filled down or right if you need more teams or matchups. The attachment should make things much clearer than I can describe, so take a look to see if it will help. If not, please provide more details about what you're looking to do.
    Attached Files Attached Files
    If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".

    If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
    https://www.excelforum.com/the-water...ke-thread.html

+ 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. [SOLVED] Need help with a round robin tournament schedule
    By BeachRock in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-26-2017, 12:41 AM
  2. Replies: 10
    Last Post: 08-07-2017, 01:33 PM
  3. Round Robin combination formula?
    By xix_xix in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-24-2014, 05:02 PM
  4. Round Robin sheet
    By Windy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-09-2013, 07:28 AM
  5. Sort and Rank teams Win Loss Draw Tally in round robin tournament
    By jammjamm in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-07-2012, 06:19 PM
  6. Round Robin Tournament Generator
    By boombaddis in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-16-2012, 02:09 PM
  7. [SOLVED] Round Robin Tournament Generator
    By Bob in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2006, 12:50 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