2 'tournament_title': 'Trøndisk 2021',
3 'tournament_footer': 'www.plastkast.no | #trøndisk',
6 'kick_fifth_from_third': true, // If true, games against the 5th in the group don't count when ranking thirds.
8 // Share both sheets with ultimate-nm-2018@solskogen-cubemap.iam.gserviceaccount.com.
9 'score_sheet_id': '1dnTjgWEZflVOf_IImbF6-d_JhE3GCchJ7SGTklaiJzs',
10 'score_sheet_index': 1088951921, // #gid= in the URL.
11 'roster_sheet_id': '1u4Fof_gespv1yUWm4TcusqgkwV2qpTTQaLqFqoXnwNs',
12 'api_key': 'AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU',
16 // Rank, name, points.
17 'score_sheet_cols': [ 'Results!S', 'Results!T', 'Results!U' ],
18 'point_total_start_row': 8,
19 'ranking_list_start_row': 15,
20 'ranking_list_explain_cell': 'Results!S21',
24 // Rank, name, points.
25 'score_sheet_cols': [ 'Results!W', 'Results!X', 'Results!Y' ],
26 'point_total_start_row': 8,
27 'ranking_list_start_row': 15,
28 'ranking_list_explain_cell': 'Results!W21',
32 // Rank, name, points.
33 'score_sheet_cols': [ 'Results!AA', 'Results!AB', 'Results!AC' ],
34 'point_total_start_row': 8,
35 'ranking_list_start_row': 15,
36 'ranking_list_explain_cell': 'Results!AA21',
39 'Playoffs 9th-14th': {
40 // Rank, name, points.
41 'score_sheet_cols': [ 'Results!S', 'Results!T', 'Results!U' ],
42 'point_total_start_row': null,
43 'ranking_list_start_row': 34,
44 'ranking_list_explain_cell': 'Results!W34',
48 'explain_third_cell': 'Results!S27',
51 // Teams Field Row Match name Mark name Group name Game day (default 7)
52 [ 'Z3', 'X5|Y5', 0, 0, 'P1', false, 'Playoffs 9th–14th', ],
53 [ 'X4', 'Y5|Z5', 1, 0, 'P2', false, 'Playoffs 9th–14th', ],
54 [ 'Y4', 'Z4', 2, 0, 'P3', false, 'Playoffs 9th–14th', ],
56 [ 'X1', 'Y3', 0, 1, 'X1/Y3', false, 'Quarterfinals', ], // Q1
57 [ 'Z1', 'Y2', 1, 1, 'Z1/Y2', false, 'Quarterfinals', ], // Q2
58 [ 'X2', 'Z2', 0, 2, 'X2/Z2', false, 'Quarterfinals' ], // Q3
59 [ 'Y1', 'X3', 1, 2, 'Y1/X3', false, 'Quarterfinals' ], // Q4
61 // Playoffs 9th–11th, on last field
62 [ 'W P1', 'W P3', 2, 2, 'W P1/W P3', false, 'Playoffs 9th–11th', ],
63 [ 'W P2', 'W P3', 2, 4, 'W P2/W P3', false, 'Playoffs 9th–11th', ],
64 [ 'W P1', 'W P2', 2, 6, 'W P1/W P2', false, 'Playoffs 9th–11th', ],
66 // Playoffs 12th–14th, mostly on last field
67 [ 'L P1', 'L P3', 2, 3, 'L P1/L P3', false, 'Playoffs 12th–14th', ],
68 [ 'L P2', 'L P3', 2, 5, 'L P2/L P3', false, 'Playoffs 12th–14th', ],
69 [ 'L P1', 'L P2', 1, 7, 'L P1/L P2', false, 'Playoffs 12th–14th', ],
72 [ 'W X1/Y3', 'W Z1/Y2', 0, 3, 'Semi 1', false, 'Semifinals' ],
73 [ 'L X1/Y3', 'L Z1/Y2', 1, 3, 'L-semi 1', false, 'Playoffs 5th–8th' ],
74 [ 'W X2/Z2', 'W Y1/X3', 0, 4, 'Semi 2', false, 'Semifinals' ],
75 [ 'L X2/Z2', 'L Y1/X3', 1, 4, 'L-semi 2', false, 'Playoffs 5th–8th' ],
77 [ 'W L-semi 1', 'W L-semi 2', 0, 6, '5th', false, 'Match for 5th' ],
78 [ 'L L-semi 1', 'L L-semi 2', 1, 6, '7th', false, 'Match for 7th' ],
79 [ 'L semi 1', 'L semi 2', 0, 7, '3rd', false, 'Bronze final' ],
80 [ 'W semi 1', 'W semi 2', 0, 7, 'Final', false, 'Final' ]
82 'playoff_games_start_row': 26,
83 'playoff_games_cols': [
88 'playoff_games_start_row_detail_sheet': 38