World Beyblade Organization by Fighting Spirits Inc.
Making a Tournament Manager Application to Automate Sheet Generation - Printable Version

+- World Beyblade Organization by Fighting Spirits Inc. (https://worldbeyblade.org)
+-- Forum: Off-Topic Forums (https://worldbeyblade.org/Forum-Off-Topic-Forums)
+--- Forum: Your Creations (https://worldbeyblade.org/Forum-Your-Creations)
+--- Thread: Making a Tournament Manager Application to Automate Sheet Generation (/Thread-Making-a-Tournament-Manager-Application-to-Automate-Sheet-Generation)

Making a Tournament Manager Application to Automate Sheet Generation - Astorec - Oct. 07, 2024

I wanted to get some more potential ideas from folks here on the forum as I've posted about the app on the UK Discord Server and I've used it for some of the recent Geek Retreat events in Glasgow.

Essentially the app connects to the Challonge API and from it, you can do the normal Tournament Management from there like creating tournaments, adding players, etc. The app also connects to your Google Account, which then under the settings of the Application you can add the Sheet ID from the Google Sheets URL and it will automatically update this sheet when new players are added. Not only that the application will also update the Tournament Format on Challonge as well based on the amount of players.

Additionally, match winners can be declared from the app as well, and when declared through the Application the sheet would automatically be updated. Not only that, if a tournament already has taken place and it was done through Challonge, you can paste the Link into the application and it will import all the Data to a new sheet within the Linked Document rather than having to manually enter all the data on a Spreadsheet. So far there are a couple of things I still need to add Manually like converting the Sheet into a Table (Google API doesn't support this yet I don't believe) and also adding the 1st, 2nd, and 3rd place points to the winners of the tournament.

Currently, the Spreadsheet stuff I have is based on what is used on the UK Discord Server for the leaderboards there. It also has some stuff in place to check if there are group stages or not and will split up the Leaderboard it creates based on the amount of people in each group including finals.


Here are a couple of examples of the Generated Spreadsheets that the Application has created:

Round Robin Example (Click to View)

Swiss Example (Click to View)


Is there interest in something like this being made available to organizers to use? Also if there is anything you would like to see in something like this let me know :3 


Currently, the application is Being made in Python as a Learning exercise for myself for Python as well. I think there will be some stuff that will need to be updated as the V1 Version of the API for Challonge doesn't support the Hosting of Group stage events (Even though I can import it to the sheet easily) but the V2 version does but there is currently no Python Wrapper for it so this will be something I will need to look in to for allowing the Group Stages to work properly within the application.