Data creation flow

For details on data creation, see the Manual together with Sample Data.

1.About data

There are three types of original data.

2.Create judge data

First, create the judge data.

Column A (Group): Enter the group using only 1 letter. This data islinked to the judge in the timetable.
Column B (Number): Enter the judge number.
Column C (Judge): Enter the name of the judge. It must match the judge number.
Column D (Terminal): Enter terminals in sequential order. Upper limit is 93. It is automatically associated with the login account in the management screen “Judge”.
Column E (Mail): Enter the email address that corresponds to the judges when they use their own terminals. This is for a Password Less Login to the judges’ terminal. We will send you a magic link to login to that address.

3.Create timetable data

Next, create a timetable.

Column A (Competition Number): Enternumbers in sequential order. No.1 must be the first competition. The intermediate breaks and awards ceremony can also be included.
Column B (Time): Enter the starting time.
Column C (Judge): Enter the group and name of the judges. This data islinked to the judge in the management screen. In addition, the management screentimetables will only show the rows existthis data.
Column D (Section): Enter the competition name. Since this name is used for identification, please make sureit is written with identical character strings for each round.
Column E (Type): Enter whether the competition isamateur or professional using only 1 letter. This isused for identification when displaying the allresultand is linked to the type of competitionin the management screen. You can register types of competitionsother than the default ones from the management screen.
Column F (Round): Enter the round.
Column G (Entry): Enter the number of competitors.
Column H (H): Enter the heat number.
Column I (UP): Enter the up number.
Column J (Musics): Enter the number of musics.
Column K (Category): Enter the order of the competitions using one letter for each category. This islinked to the categoryin the management screen. You can register categories other than the default ones from the management screen.
Column L (Interval): Enter the intervals.

4.Create player data

Finally, create player data for each section. In the following examples 5-11 creates player data for the “Amateur Latin” section.

Column A (No.):Enter the competitor number.
Column B (Seed):If a competitoris seeded, enter their starting timetable competition number. This islinked to the timetable. If a competitoris not seeded, leave blank.
Column C (Code1):If a competitor hasan association code, you can enter it. This is not required for the system. It can be used for other purposes.
Column D (Code2): This is not required for the system. It can be used for other purposes.
Column E (Name1):Enter the full name of the competitor.
Column F (Pronunciation1):Enter the pronunciation for Name1. This is not required for the system.
Column G (Name2):Enter the full name of the competitor.
Column H (Pronunciation2):Enter the pronunciation for Name2. This is not required for the system.
Column I (Place):Enterthebelongs. Prefecture names are used in the sample data, so please change accordingly.
Column J (Competition):Enter the competition section. This column is not read as data but used as a filter when generating data. Please paste it onto a separate sheet and create a CSV file. At that time, heading row is not necessary.