From PC2wiki
Revision as of 16:22, 15 December 2016 by Clevengr (talk | contribs) (Updated wording for how results.tsv is generated, added links to Finalize Tab)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

A "results.tsv" file is a tab-separated-values (TSV) file that contains contest results in the CLICS CCS format. This file is formatted such that it can be directly input to the ICPC CMS.

File Format

The format of the results.tsv file is as defined in the CLICS CCS specification: it is text file consisting of a version line and one line for each team in the contest, sorted in rank order with alphabetical order on team name as tie breaker. Each line has tab separated fields as defined below.

The first line has the following format

Field Description Example Type
1 Label results must be the string constant "results"
2 Version number 1 integer

Then follow several lines with the following format (one per team).

Field Description Example Type
1 External ID 24314 integer
2 Rank in contest 1 integer
3 Award Gold Medal string
4 Number of problems the team has solved 4 integer
5 Total Time 534 integer
6 Time of the last submission 233 integer
7 Group Winner North American string

Generating Results.tsv

Using the PC2 Admin

The results.tsv file is automatically generated when the contest is "Finalized". (Finalizing is done using the Admin Finalize Tab (Admin | Run Contest | Finalize).) The generated file is saved in a folder named "results", in the file "results.tsv". Once the contest is Finalized, the "View" button on the Finalize Tab allows viewing the file contents.

The results.tsv file can also be viewed on the Admin using the Export Tab (Admin | Run Contest | Export ) and clicking the "Save Results" button. This displays a dialog showing the contents of the results.tsv file; clicking the "Save" button on the dialog allows saving the file to any desired location.

Using the PC2 Scoreboard

The results.tsv file is automatically generated on the Scoreboard machine when the contest is finalized. As on the Admin, the file is saved in a folder named "results".

See Also