Tournament Templates
You can enter the the games to Cupdom with a browser. However, for large tournaments we suggest using your favorite spreadsheet program (e.g. free LibreOffice or Microsoft Excel). The spreadsheet templates also illustrate how to use Cupdom macros to automatize your tournament.
To use tournament templates:
- Download the Excel template
- Edit the games using MS Excel or LibreOffice Calc
- Upload the games to the admin interface: Games page > Import Games
Cupdom reads your tournament data always from the first tab regardless the names or the total number of the tabs. You can use functions and defined names of your spreadsheet application to create an import template.
Simple
This is the most basic template. Check this out if you're intersted in the format of the import file.
Download the template
Simple Knock-Out
This template implements a simple knock-out (cup) tournament. The tournament starts with 16 teams.
The winners continue the tournament to the final. The winners are referenced by +GAME_ID
code.
Download the template
Two-Stage Round-Robin
In this samplate template the 9 teams are divided into three groups (Group A-Group C). In the first stage
the teams meet both opponents in their own group. In the second stage the teams are divided into three final
groups (Final 1-3, Final 4-6 and Final 7-9) based in their standings in the first phase. The first stage is
implemented using the @GROUP:POSITION
code.
Download the template
Two-Stage Round-Robin and Knockout
In this sample the 16 teams are divided into four groups (Group A-Group D). In the first stage they play a round-robin tournament within their group. In the second stage the teams meet their equals from another group. This is junior version of a knock-out: the losers meet in their final match.
The first knock-out games utilise the @GROUP:POSITION
code. The knock-out stage is
implemented using +GAME_ID
and -GAME_ID
codes.
This file also contains some automation to handle large number of data:
start_date
andend_date
are populated from the cellA2
. To change the dates you need to edit only this cell.start_time
andend_time
are calculated using the parameters in tabParameters
. Just enter the start time of the first game atB2
and the parameters in the Parameters tab and you're good!- The team names are set in the lines 2-9 (games 1-8). They set defined names (sort of variables)
team_a1, team_a2, team_a3, team_a4
(for the group A),team_b1, ..., team_b4
(for the team B) and so on. In the later rounds the team names are read from these defined names. For example the name of the home team in game 12 atI13
is=team_b2
. In short: to change the team names just edit names in the lines 2-9.
Download the template
Cupdom Macros Cheat Sheet
+GAME_ID |
Winner of the game GAME_ID Example: +QualA1 (Winner of the game QualA1)Note: The original game QualB3 cannot be draw. |
-GAME_ID |
Loser of the game GAME_ID Example: -QualB3 (Loser of the game QualB3)Note: The original game QualB3 cannot be draw. |
@GROUP:POSITION |
Team in a GROUP at the position POSITION Example: @QualB:3 (Team of the qualification group QualB position 3)Note: The referred group must be in locked state. Lock the qualification groups after the last game of the group has been played. |