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.

  • Timetable
  • Judge
  • Player

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. If you can use up to 1terminal, the last one is 1. If you can use up to 22, the last one is 22. Accounts will be automatically associated with the judge in the management screenafter logging in.

3.Judge data saved as “CSV UTF-8 (Comma delimited) (* .csv)” from “File”-> “Save As”

4.Click “OK”

5.Ignore the yellow display, and quit Excel

6.Open the output data in Notepad

7.Check if comma-separated data is available

8.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.

9.Save timetable data as “CSV UTF-8 (Comma delimited) (* .csv)” from “File”-> “Save As”

10.Click “OK”

11.Ignore the yellow display, and quit Excel

12.Open the output data in Notepad

13.Check if comma-separated data is available

14.Create player data

Finally, create player data for each section. The following example 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.

15.Press the “Competition” data filter in row J

16.Select one competition section

17.Only data for the selected competition section is displayed

18.Create a new worksheet

19.Return to 17 player sheet and select columns A through I to copy

20.Paste the data copied in 19 to the new worksheet created in 18 as “value”

21.Change the name of the new worksheet to which “Value” is pasted

22.21 player data is saved as “CSV UTF-8 (Comma delimited) (* .csv)” from “File”-> “Save As”

23.Click “OK”

24.Ignore the yellow display, and quit Excel

25.Open the output data in Notepad

26.Check if comma-separated data is available

27.Do 15-26 for each competition section