ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Qualifier
2
Enter the contestants names and the qualifier chart. Enter each score, then sort Final Score column from Z to A. Take the top ## and copy/paste to the Round 1 sheet
3
4
Picking with Picklist
5
To pick two charts for future rounds, enter all Contestant names and their chart picks. Then, enter the number of Contestants, and a string of numbers/letters in the Key to randomize. The two charts randomly chosen will be below.
6
7
Picking with Chartlist
8
Chartlist is generated from all charts available between levels 9.0-9.9 EXT and 10.0-10.9 BSC/ADV/EXC available on jubeat festo before January 1, 2019. Each round has two charts which will be pulled from the "Chartlists for Rounds" spreadsheet. Each round's chartlists are filtered to a range of difficulties, which are found below.
9
10
Rounds
11
Enter contestant names in first column, and chart titles in the Chart 1 / Chart 2 headers. Enter scores as they play, then sort Final Score on Z to A. Assign Strikes with an X in the Strike column.
12
Continue for further rounds. Strikes will cascade to future rounds. A Strike in the Strike? and Strike Previous columns will trigger the Eliminated column.
13
Be sure to copy and paste the contestant names from Round to Round, to ensure they match exactly from sheet to sheet.
14
15
Chart 1Chart 2
16
Round 19.0-9.59.5-10.0
17
Round 29.5-10.09.8-10.2
18
Round 39.8-10.210.0-10.3
19
Round 410.0-10.410.0-10.5
20
Round 510.0-10.610.0-10.7
21
Round 610.0-10.810.0-10.9
22
Round 7+10.0-10.910.0-10.9
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
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
94
95
96
97
98
99
100