Difference between revisions of "Results.tsv"

From PC2wiki
Jump to: navigation, search
m (See Also: add link)
(Updated wording for how results.tsv is generated, added links to Finalize Tab)
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
A [[CCS]] standard TSV file that contains contest results.  This
+
A "results.tsv" file is a tab-separated-values (TSV) file that contains contest results in the [[CLICS]] [[CCS]] format.  This
file is input to the [[ICPC]] [[CMS]]
+
file is formatted such that it can be directly input to the [[ICPC]] [[CMS]].
  
 
==File Format==
 
==File Format==
  
Per the [[CCS]] spec.
+
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.
 
 
A 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
 
The first line has the following format
Line 44: Line 42:
 
==Generating Results.tsv==
 
==Generating Results.tsv==
  
===Using Admin===
+
===Using the PC2 Admin===
 +
 
 +
The results.tsv file is automatically generated when the contest is "[[Finalize Tab|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.
 +
 
  
When a contest is finalized the results.tsv file can be viewed using the [[Export Tab]] (Admin | Run Contest | Export )
+
===Using the PC2 Scoreboard===
and clicking the Save Results button to view the file.
+
 
 +
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".
  
The results.tsv file will be will be automatically generated to results/results.tsv starting in version 9.4.
 
On the [[Finalize Tab]] there is a View button to view the contents of the file.
 
  
 
==See Also==
 
==See Also==
Line 56: Line 62:
 
* [[Export Tab]]
 
* [[Export Tab]]
 
* Reference CCS [https://clics.ecs.baylor.edu/index.php/Contest_Control_System#results.tsv results.tsv]
 
* Reference CCS [https://clics.ecs.baylor.edu/index.php/Contest_Control_System#results.tsv results.tsv]
[[Category:CCS|CCS]]
 
  
 +
[[Category:CLICS]]
 
[[Category:Version 9.3]]
 
[[Category:Version 9.3]]
 
 
[[Category:Import and Export]]
 
[[Category:Import and Export]]

Latest revision as of 16:22, 15 December 2016

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