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.

Go to the Standings page.
Click on Download .CSV.
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 heading	Description
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)
bettersCount	number 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)