Round Robin + Single elimination tournament brackets - Shared

	A	B	D	E	G	H
1	LOGOS:
2	logoLeft	Replace with your logo
3	logoRight	Replace with your logo
4	link	robosota.fi/points-calculator-for-judging/
5	POINTS:	(Only uneven numbers, No ties allowed!)	DROPDOWNS:	(Generates point dropdowns automaticly from total points)
6	matchTotalPoints	15	Generated point dropdowns:	0	Leagues:	150 g Muoviliiga
7				1		150 g
8	INFO: Round Robin + Single elimination tournament brackets. - Pick up suitable sheet, add participant names and your ready to go. - Everything else, excluding points/wins/losses dropdowns, names and sheet header information, is done automaticly. - 2 qualifying matches / participant before finals. - Total points per match in qualifying are divided between bots. - If there is tie between qualifying points entering into any of the first finals slots bracket will randomly choose one of the bots into it. - Checking and unchecking "Lock order" will randomize slots again. - Remember to lock order from 1st final when function has finished declaring slots. - No coin tosses, rematches or ties in entire bracket. - Judging is done with online calculator found from link above. - Order in qualifying can be changed from match offset. HOW TO COPY: 1. Create copy from this document into your own drive account from: File > Create copy 2. Now in the copy there should be dropdowns with pickable values and Apps script extension appeared in to the top bar. If not check that you really opened the copy and not the original link. 3. Read how to authorize scripts: https://spreadsheet.dev/authorizing-an-apps-script 4. Open Extensions > Apps script and select one of the functions and run it, now google asks permission to run scripts, approve them like told in part 3 and your ready. NOTICE: Sheet includes scripts and needs Apps script extension to work. Extension is included in Google sheets by default (Extensions > Apps Script). Scripts are used for: - Clear sheet functions - Random index generator for 1st final slots When making copy from it they have to be approved from new owners google account. Otherwise brackets won't work! Apps script extension missing? https://www.lido.app/tutorials/script-editor-google-sheets-missing More from authorization: https://spreadsheet.dev/authorizing-an-apps-script If adding more sheets clear button function has to be added also if cell structure isn't the same!			2		450 g
9				3
10				4
11				5
12				6
13				7
14				8
15				9
16				10
17				11
18				12
19				13
20				14
21				15
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46	Copyright © Robosota Ry - Finland
47	robosota.fi
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93