How do I download the CSV file of the ranking list?

Modified on: 02/14/2024 at 15:21

As an administrator of a Scorecast Business platform, you have the option of uploading your rankings as a CSV file. This is a format compatible with common spreadsheet programs such as Microsoft Excel, Google Sheets, OpenOffice Calc or Numbers. This enables you to keep track of your rankings, make graphs or even compile a few statistics.


Retrieve my ranking in CSV format

To retrieve the CSV file of your ranking, you need to be logged in with your administrator account on your Scorecast Business contest website. 

  1. Go to the Standings page.
  2. Click on Download .CSV.
  3. The file will be automatically downloaded to your computer in the usual folder where you receive downloads from your web browser.



Tip: you can also download a single-day or round ranking in CSV format (if compatible with your competition). To do this, filter the ranking by day or round and check whether the Download .CSV button is active. If it is, you'll be able to download the standings for the round in question.


Explanations of column headings

Some explanations of column names to help you decode the resulting CSV file (depending on the competition, you may not see all the columns below):


Column headingDescription

position

ranking position
username
username or first name/last name
total
number of points obtained
forecastsPoints
number of points obtained on match predictions (= not on bonus questions)
pollsPoints

number of points obtained on bonus questions (= not on matches)

handicap
bonus or malus obtained by the player (set by the administrator)

perfectsCount

number of "perfect" match predictions obtained (good score)
bettersCountnumber of "good spread" match predictions obtained

goodsCount

number of "good winner" match predictions obtained
forecastsCount
number of match predictions made
pollsCount

number of bonus questions answered

efficiencyRate

efficiency percentage, % of match predictions where at least 1 point was scored out of all predictions made (this rate does not take bonus questions into account)

teamId

player's team identifier (if null, player has no team)


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article