Data creation flow

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

Manual

Sample Data

1.About data

There are four types of original data.

Judge
Major item
Timetable
Judgment sheets

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 No. : 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. The upper limit of the case where only one can be used in the trial version is 1, the upper limit is 22 when it can be used up to 22 in the regular version. Accounts will be automatically associated with the judge in the management screen after logging in.
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.

Judge Password Less Login

Judges' terminals can be logged in without a password. 1. data : Use an email address for …

3.Create Major item

Next, create a major item.

Column A number：Enter the number of major item. This is linked to major item of the judge paper.
Column B major_item：Enter the major item of the judging.
Column C award：Enter the award that link to major items of the judging. If you don’t need a award, you can leave it blank.

4.Create Timetable data

Third, create a timetable.

Column A Number：Enter numbers in sequential order. No.1 must be the first competition. The intermediate breaks and awards ceremony can also be included.
Column B Category1：It is main division.The timetable of the summary account is a single section that combines Category1 and Subcategory1.
Column C Subcategory1：It is included in Category1. It can be blank.
Column D Category2：It is subdivision. The timetable of the summary account is a single section that combines Category2 and Subcategory2.
Column E Subcategory2：It is included in Category2. It can be blank.
Column F Name1：It is main name. The timetable of the summary account is a single name that combines Name1,Name2 and Name3.
Column G Name2：It is included in Name1. It can be blank.
Column H Name3：It is included in Name1. It can be blank.
Column I Time：Enter the starting time. It can be blank.
Column J Judge：Enter the group and name of the judges. This data is linked to the judge in the management screen. In addition, the management screen timetables will only show the rows exist this data.
Column K Interval：Enter the intervals. It can be blank.

5.Create Judgment sheets data

Finally, create a judge sheet for each section. The following is an example of creating a judgment sheet for the “CHEER” section.

Column A major_item number：Enter the number of major item.Linked to major items. Multiple types of judgment sheets can be created, but the major item number must be common for all judge sheets. If there are two or more same major items, you must write the line continuously.
Column B item：Enter the item of thejudging.
Column C description：Enter the description of thejudging item. If you don’t need it, you can leave it blank.
Column D lowest：Enter the lowest point of thejudging.
Column E highest：Enter the highest point of thejudging.
Column F initial value：The initial display value of the score on the tablet. If it is blank, it will be the value specified in the Settings.
Column G Rank limit：Enter the limited numberof all result view. If you don’t need a award, you can leave it blank.
Column H Grade：Enter the grade of grade view for all result. If you don’t need a award, you can leave it blank.
Column I Range %：Greater than or equal to this value corresponds to the grade of column G. If you don’t need a award, you can leave it blank.

6.Conversion to data to be read by the scoring system

Convert the timetable, judges, major item, and judgment sheet(for each section) to CSV format using a macro in order to load them into the scoring system.

7.Open the folder containing the data and launch the csv_export_utf8.xlsm file