TournamentSheet_20170619
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCD
1
2
3
This sheet can be used to make the draw for a tournament and directly generate all the group and KO sheetsYou should only (have to) make changes in the GREEN fields!
4
These can be printed, filled live with the results and easily shared to everyoneYou need a Google account to use this.
(for the best experience, use Google Chrome)
5
StepsDetails
6
0Be sure you use the newest version: http://tiny.cc/ICOtournamentsheetDon't copy a sheet from a previous tournament. Use that at http://tiny.cc/ICOtournamentsheet: bug fixes and updates are made continuously!
7
1Create a COPY of this sheet for your own useGoto "File" menu and choose "Make a copy ..." - THEN you can make changes!
8
2For larger tournaments, create a copy for each categorySee step 1. Each category will create one sheet for each group and one for KO. This creates a lot of sheets. If you have several categories, it is easier to have multiple documents: in one browser window, you will have one tab for each category. In each tab, you will have a few sheets (one for each group and KO).
9
It might also be easier for others to browse the results.
10
3In the MAIN sheet, specify the settings for your tournamentIn the MAIN sheet, choose your federation (e.g. ICO). Next, shoose the category and whether you want to have a group phase or not.
11
If your fedaration or category is not available, please contact gossen@crossminton.org and we will enter it for you. You can also try to add it yourself in the hidden sheet "Categories".
12
4In the MAIN sheet, enter the participants.You can easily copy list of participants from Ophardt registration ovrview page, see a brief video at https://goo.gl/photos/xKCvok6rH3m6YazB7
13
The corresponding ranking points will be automatically retrieved (if there is an internet connection) - takes a few seconds. If you copy from Ophardt and there are comments, you will have to adjust the list of participants manually (always use COPY/PASTE and then delete manually; if you use CUT/PASTE, the formulas in the "Points" column will be confused)
14
For Doubles, make sure that the pairs are together, i.e. the partners are in two consecutive lines!
15
5Start the drawIn the "Corssminton" menu, choose "Start Draw"
If everything goes fine, it should generate one sheet for each group (if you have a group phase) and one for the KO phase.
16
6Reset the drawIf everything works fine, you can also reset the draw ("Crossminton" menu, "Reset Draw") and let an official ICO person make the draw for you.
"Reset Draw" - "Only current category" resets the category that is specifies in the "Category name" field in the MAIN sheet (independent of which sheet is currently displayed)
17
7Create a list of all gamesAfter making the draw, you can generate a list of all games (e.g. for scheduling) using "Crossminton" menu, "Create overview tab".
18
8Share for everyone to see (not edit!)In the top right corner choose "Share". Click on "Get shareable link" and ensure that "everyone can view" (not edit) is selected. The link can now be shared through any channels.
19
Alternatively, you can also collect all your tournament sheets in one folder in your Google Drive and share the whole folder.
20
9Print sheetsOn a sheet, choose "File" -> "Print"
21
Settings for Group Sheets: Current Sheet, Letter, Fit to width, Landscape
Settings for KO Sheets: Current Sheet, Letter, Actual size, Landscape
Then print only those pages you need.
22
10Generate resultsEach KO sheet shows (scroll right) the results of its category. The top positions are calculated automatically, for the "3rd in group" etc. rankings, click on the "Update Results" button.
23
Using "Crossminton" -> "Results" -> "Save as CSV" generates CSV file(s) in your Google drive that should be directly importable to Ophardt
24
25
26
Special Features
27
AFix the points on the seeding deadlineOphardt doesn't allow to get the ranking points from a specific date. However, you can open the sheet on the seeding deadline day and then choose "Crossminton" menu, "Ranking / Points" and "Use current ranking (not live)". From now on, it will use the ranking retrieved on that day. You can switch back to live ranking through the menu.
28
BCreate a list of all gamesAfter making the draw, you can generate a list of all games (e.g. for scheduling) using "Crossminton" menu, "Create overview tab".
Currently, this lists all games in the group phases.
29
30
31
Troubleshooting
32
1Something went wrong that is not covered belowContact Paul at speeden@paul-holleis.de
33
2In the results, the country is not filled inPaste the list of players of all the categories you need the country in your sheet in the MAIN sheet. The results list takes the country from there. There is practically no other way to get it for the sheet.
34
3In the results, family and first name are separated in a wrong way or not at allDon't worry, the way the data is processed by the ICO anyway concatenates first and family name together
35
4In the results for doubles, each player should be in its own line for the ICO tournament report Excel sheetI know :-( The CSV export works correctly.
Working on it ......... For now, if doubles are detected, an according list with each partner on a single line is generated to the right for easier copying
36
5The CSV files exported cannot be uploaded to OphardtThis might well be - I was not able to test it yet ...
37
6It is extremely slowIt works best and fastest in Google Chrome browser (but true, it is not speed optimized)
38
39
40
41
42
43
44
45
46
47
48
49
50
51
Loading...
 
 
 
Documentation
MAIN
Language
Categories
Ranking
Template 3
Template 4
Template 5
Template KO 4
Template KO 8
Template KO 16
Template KO 32
DO NOT DELETE - AutoCrat Job Settings
Copy of Template 4