2 'tournament_title': 'Battle for Oak Hill 2020',
3 'tournament_footer': 'www.plastkast.no | #oakhill',
6 // Share both sheets with ultimate-nm-2018@solskogen-cubemap.iam.gserviceaccount.com.
7 'score_sheet_id': '1vEKBGGG0DYkQUcePY9EHFaT1Nj_Ops57xHzKvIBCloU',
8 'score_sheet_index': 1088951921, // #gid= in the URL.
9 'roster_sheet_id': '1is-fwcH_miWEaSJuP8aocvmNUESaS_HbFx58oTZ3EJ4',
10 'api_key': 'AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU',
14 // Rank, name, points.
15 'score_sheet_cols': [ 'Results!S', 'Results!T', 'Results!U' ],
16 'point_total_start_row': 8,
17 'ranking_list_start_row': 15,
18 'ranking_list_explain_row': 21
21 // Rank, name, points.
22 'score_sheet_cols': [ 'Results!W', 'Results!X', 'Results!Y' ],
23 'point_total_start_row': 8,
24 'ranking_list_start_row': 15,
25 'ranking_list_explain_row': 21
28 // Rank, name, points.
29 'score_sheet_cols': [ 'Results!AA', 'Results!AB', 'Results!AC' ],
30 'point_total_start_row': 8,
31 'ranking_list_start_row': 15,
32 'ranking_list_explain_row': 21
34 'Playoffs 9th-13th': {
35 // Rank, name, points.
36 'score_sheet_cols': [ 'Results!S', 'Results!T', 'Results!U' ],
37 'point_total_start_row': null,
38 'ranking_list_start_row': 34,
39 'ranking_list_explain_row': 40
42 'explain_third_cell': 'Results!S26',
45 // Teams Field Row Match name Mark name Group name Game day (default 7)
46 [ 'C5', 'A4', 0, 0, 'C5/A4', false, 'Playoffs 9th–13th', 6 ],
47 [ 'B4', 'C4', 1, 0, 'B4/C4', false, 'Playoffs 9th–13th', 6 ],
48 [ 'A4', 'B4', 0, 2, 'A4/B4', false, 'Playoffs 9th–13th', 6 ],
49 [ 'Z3', 'C5', 1, 2, 'Z3/C5', false, 'Playoffs 9th–13th',, 6 ],
50 [ 'C4', 'Z3', 0, 8, 'C4/Z3', false, 'Playoffs 9th–13th' ],
51 [ 'C5', 'B4', 1, 8, 'C5/B4', false, 'Playoffs 9th–13th' ],
53 [ 'X1', 'Y3', 0, 9, 'X1/Y3', false, 'Quarterfinals' ], // Q1
54 [ 'Z1', 'Y2', 1, 9, 'Z1/Y2', false, 'Quarterfinals' ], // Q2
55 [ 'X2', 'Z2', 0, 10, 'X2/Z2', false, 'Quarterfinals' ], // Q3
56 [ 'Y1', 'X3', 1, 10, 'Y1/X3', false, 'Quarterfinals' ], // Q4
58 [ 'C4', 'C5', 0, 11, 'C4/B5', false, 'Playoffs 9th–13th' ],
59 [ 'Z3', 'A4', 1, 11, 'Z3/A4', false, 'Playoffs 9th–13th' ],
61 [ 'W X1/Y3', 'W Z1/Y2', 0, 12, 'Semi 1', true, 'Semifinals' ],
62 [ 'L X1/Y3', 'L Z1/Y3', 1, 12, 'L-semi 1', true, 'Playoffs 5th–8th' ],
63 [ 'W X2/Z2', 'W Y1/X3', 0, 13, 'Semi 2', true, 'Semifinals' ],
64 [ 'L X2/Z2', 'L Y1/X3', 1, 13, 'L-semi 2', true, 'Playoffs 5th–8th' ],
66 [ 'B4', 'Z3', 0, 14, 'B4/Z3', false, 'Playoffs 9th–13th' ],
67 [ 'A4', 'C4', 1, 14, 'A4/C4', false, 'Playoffs 9th–13th' ],
69 [ 'W L-semi 1', 'W L-semi 2', 0, 15, '5th', true, 'Match for 5th' ],
70 [ 'L L-semi 1', 'L L-semi 2', 1, 15, '7th', true, 'Match for 7th' ],
71 [ 'L semi 1', 'L semi 2', 0, 16, '3rd', true, 'Bronze final' ],
72 [ 'W semi 1', 'W semi 2', 0, 17, 'Final', true, 'Final' ]
74 'playoff_games_start_row': 19,
75 'playoff_games_cols': [