+ Reply to Thread
Results 1 to 5 of 5

Help needed: Specific tournament bracket problem

  1. #1
    Registered User
    Join Date
    11-23-2021
    Location
    Kiruna, Sweden
    MS-Off Ver
    Newest
    Posts
    2

    Post Help needed: Specific tournament bracket problem

    I am organizing a badminton tournament and need to make a proper tournament setup.
    Needs:
    - Names must be taken as input. An odd number of players is fine.
    - The program organizes the players in teams of two for each match. The teams are changed every match, so player A is teamed with player B in match 1, but in match 2, player A is teamed with player H for instance.
    - Number of group games must be taken as input
    - After group games, players are ranked individually by the number of victories
    - 8 teams (16 best players after group games) are set up to play quarter final, semifinal, final, different team-up as before. If the player loses a game now, the player is out of the tournament

    Anyone have a template for this or somewhere to start?

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

    Re: Help needed: Specific tournament bracket problem

    Hi. See attached. It's not exactly what you're after but quite close. It can only handle 8 players in the quarter finals. Instructions:

    1. Check the Settings sheet to set the options you want in the tournament - change the 15 to 21 if you want to play full games (depends how much time and how many courts you have available).
    2. On the Group A sheet, double-click the New Group button to create enough groups for your tournament.
    3. In each Group X sheet, type the players names in Column B up to a maximum of 8 - everything else should fill out automatically.
    4. When you've typed in all the names, double-click the Generate to create the fixtures for each group.
    5. When the games have been played, type in the loser's score first - the winner's score will be filled in automatically. You can click Clear to clear out all the scores at any time.
    6. Once all group games are completed, go to the Knockout sheet and double-click the Generate button to fetch the group winners into the knockout stage.
    7. Again, when entering the scores in the Knockout sheet, enter the loser's score first and the winner's score will fill automatically.

    I've run a few badminton tournaments myself with this spreadsheet so I hope it's a good start at least for you. I should warn you that you MUST NOT use copy/paste in this spreadsheet because it will most likely break the formatting.

    WBD
    Attached Files Attached Files
    Office 365 on Windows 11, looking for rep!

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2503
    Posts
    13,702

    Re: Help needed: Specific tournament bracket problem

    Hello jantonnesen. Welcome to the forum.

    It sounds like what I have always known as 'round robin' tournaments.

    Rather than "reinvent the wheel" try this article.

    https://en.wikipedia.org/wiki/Round-robin_tournament
    Dave

  4. #4
    Registered User
    Join Date
    11-23-2021
    Location
    Kiruna, Sweden
    MS-Off Ver
    Newest
    Posts
    2

    Re: Help needed: Specific tournament bracket problem

    Thanks! Its a good place to start.

    Problem is I want to have teams of two players in each game and the teams are changed each game, then I want to track wins and losses to individual players, not teams. This is my biggest challenge. Any ideas?

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

    Re: Help needed: Specific tournament bracket problem

    Ah! It's a doubles tournament but you want to track individual players. That sounds tricky and lots of work. Sorry I can't help there.

    WBD

+ 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. Tournament Bracket Game Editting
    By Darkrogueseal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-22-2014, 08:39 AM
  2. Replies: 2
    Last Post: 01-12-2012, 03:12 PM
  3. Bracket or Tournament Help
    By rogeru in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2011, 02:11 PM
  4. 2011 NCAA Tournament Bracket
    By bluerog in forum The Water Cooler
    Replies: 1
    Last Post: 03-18-2011, 09:30 AM
  5. Bracket Tournament help
    By Ziggy_Excel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-11-2010, 10:29 AM
  6. Making tournament Bracket
    By chris386 in forum Excel General
    Replies: 1
    Last Post: 06-28-2007, 01:22 PM
  7. Help with Tournament Bracket Generator (with Photos)
    By ghost_rider in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 02-22-2006, 11:39 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