Automatic Tournament Management System

LINK TO PROJECT

Overview

This project is a demonstration spreadsheet for an automatic tournament management system designed to simplify tournament organization and scoring.

The system automatically handles calculations, bracket generation, and formatting, allowing tournament organizers to focus on running the event and entering scores.

Participants can be entered into the Pools sheet along with their round-robin scores. These results are then automatically transferred to the appropriate elimination bracket. Once the elimination bracket is complete, tournament results can be exported through the Export sheet.

The exported data can be used with my Fencing Data Analytics Project:

Fencing Data Analytics Project

The automation and macros in this project are written using Google Apps Script.

Sheets Relevant to the Demo

• Pools
• Standard Bracket (16)
• Export

---

Features

• Automatic pool management

  • Enter participants and round-robin scores.
  • Automatically calculates pool results and rankings.

• Macro-powered automation

  • Apps Script macros automate repetitive tasks.
  • Toggleable controls provide flexible tournament management.

• Automatic bracket generation

  • Pool results automatically populate elimination brackets.
  • Bracket logic supports USFA classification calculations.

• Conditional formatting

  • Visual formatting makes scores, results, and tournament progression easier to interpret.

• CSV exporting

  • Tournament results can be exported in a CSV-style format for use in other programs and data-storage environments.

---

Macros

Manual Macros

Macro	Shortcut	Description
Score Clearer	CTRL + SHIFT + ALT + 1	Clears all scores on the currently open sheet.

Automatic Macros

Macro	Location	Description
Auto-Hide Pool Orders	Controls box on Pools	Automatically hides unused or unnecessary bout orders for each pool.
Auto-Hide Pool Columns	Controls box on Pools	Automatically hides unused or unnecessary pool completion checklists.

---

Sheets

Pools

The primary sheet for entering tournament participants and pool results.

• Participants can be entered into each pool.
• Round-robin scores are entered directly into the sheet.
• Pool rankings and statistics are calculated automatically.
• A checklist in the center tracks remaining bouts.
• Controls and additional statistics are located on the right side.
• Automatic hiding features keep unused bout orders and columns out of the way.

Standard Bracket (16)

A standard 16-person elimination bracket intended for smaller tournaments.

• Pool results are automatically transferred into the bracket.
• Tournament results are calculated automatically.
• Includes an optional 3rd-place bout toggle located below the results on the right side.

Standard Bracket (32), (64), & (128)

Larger versions of the standard elimination bracket.

These sheets function similarly to Standard Bracket (16) while supporting larger tournament sizes.

Simple Repechage Bracket (32)

A 32-person repechage bracket in which participants who lose to finalists have an opportunity to continue competing for a higher placement.

This style of bracket is commonly used in wrestling tournaments.

Double Elimination Bracket (32)

A 32-person double-elimination bracket where participants can lose two matches before being fully eliminated.

Implementation includes a Loser's Bracket that continues through the tournament and determines 3rd place.

Triple Elimination Bracket (16)

A custom 16-person triple-elimination bracket where participants can lose three matches before being eliminated.

This is a static bracket designed to distribute the lower brackets as fairly as possible while maintaining a practical tournament structure.

Round Robin (16)

A 16-person true round-robin tournament format.

Unlike the Pools sheet, every participant has the opportunity to fence every other participant.

Classification Table

A reference table containing information used for USFA tournament classification.

Classification Calculator

An automatic calculator that reads the results from the tournament brackets and compares them against the Classification Table.

It determines the classification that the current tournament is capable of achieving based on the recorded results.

Bout Orders

Contains the automatic bout orders used by the Pools sheet.

The appropriate bout orders are displayed in the center of the Pools sheet based on the number of participants in each pool.

Export

Reads data from the Pools sheet and all bracket sheets and produces CSV-style output.

The exported data can be used for:

• External data analysis
• Data storage
• Custom scoring software
• The Fencing Data Analytics Project