View Single Post
Old 2010-01-23, 13:53   #1
opyrt
 
opyrt's Avatar
 
Apr 2008
Oslo, Norway

110110012 Posts
Thumbs up CSVs for stats available + New combined stats

Ltd has made stats for this project available as csv files. They are:

For PRP:
http://www.psp-project.de/csv/prp_teams.csv
http://www.psp-project.de/csv/prp_users.csv

For sieve:
http://www.psp-project.de/csv/sieve_users.csv
http://www.psp-project.de/csv/sieve_teams.csv

The field values are explained in the first row, the separator is the ampersand symbol (&) and there is no text qualificator. The CSV-files for PRP contains information on both first pass (fields with FP in them), second pass (fields with SP in them) and those two combined.

We encourage everyone who parses the stats.html page to build their own stats to convert to using the csvs.





A few important things:
  1. The csv files are updated every 15 minutes.
  2. Adding the scores of all team members does not necessarily equal the team score, as some members have changed teams after earning points for another team.
  3. Stats.html might be changed in the future, breaking stats for those who have not converted.
As discussed in another thread, we decided that "Combined stats" are better for PRP instead of separate stats for first pass and second pass. This is also how GIMPS and Seventeen or Bust does it.

To make sure things were OK, we contacted Bok of stats.free-dc.org to test the new files and the result is here:
http://stats.free-dc.org/stats.php?page=proj&proj=psp

If you feel that some fields are missing in the csvs, please let us know and we'll have a look (not promising anything ;).

I would like to thank ltd for all the work he has put into this, and Bok for his assistance in the layout of the files and for creating the new stats on stats.free-dc.org. You guys are awesome!

-Kai

PS: I will contact Nanobot of the DC-Vault to get him to convert to csv. If you know someone else who parses stats from here, please let them know if this thread.
opyrt is offline   Reply With Quote