Odd WCA stats/ Stats request Thread

MaeLSTRoM said:
Well this is a pain. Any particular reason All persons was removed?
Click to expand...

Some pages were huuuge, I found top 1000 more interesting, it made the introduction of "1000 Results" consistent, and if people really want all results for further analysis, they can download the export.

MaeLSTRoM said:
For some events (3x3, 2x2) The vast majority of people now cannot see where they stack up in the world against others around their speed.
Click to expand...

Everybody's ranks are at the top of their person page.

MaeLSTRoM said:
(It also breaks my sum of ranks script, but that's kind of arbitary :b
Click to expand...

You're just doing that for UK, right? The UK doesn't have nearly 1000 cubers.

MaeLSTRoM said:
Nevermind, it can still be accessed, just by putting '&show=All%2BPersons' in the URL
Click to expand...

Good catch, I forgot to take that out :p

Alright, alright, I'll reconsider it.
 
Stefan said:
Some pages were huuuge, I found top 1000 more interesting, it made the introduction of "1000 Results" consistent, and if people really want all results for further analysis, they can download the export.
Click to expand...

Does it matter if the pages are huge? Surely that problem falls on the person accessing the page?

Stefan said:
Everybody's ranks are at the top of their person page.
Click to expand...

Yeah but I meant if I wanted to see how far ahead the next hundred ranks was (e.g. person at 1546 wants to know where 1500 is) or who is at the same speed as me, it now is a lot harder.

Stefan said:
You're just doing that for UK, right? The UK doesn't have nearly 1000 cubers.
Click to expand...

No, it was for everyone, but I just did it to see if I could, doesnt really bother me :b

Stefan said:
Good catch, I forgot to take that out :p

Alright, alright, I'll reconsider it.
Click to expand...

;)

On the subject of using the export, are there any instructions on how to set it up anywhere?
 
MaeLSTRoM said:
Yeah but I meant if I wanted to see how far ahead the next hundred ranks was (e.g. person at 1546 wants to know where 1500 is) or who is at the same speed as me, it now is a lot harder.
Click to expand...
Maybe it would be possible to search someone, and to see the 100/200/n persons around him.

MaeLSTRoM said:
On the subject of using the export, are there any instructions on how to set it up anywhere?
Click to expand...

It's an SQL database, so if you know how to use SQL, it shouldn't be a problem.
 
MaeLSTRoM said:
Does it matter if the pages are huge? Surely that problem falls on the person accessing the page?
Click to expand...

The server also has to produce and send more. But I admit I don't know whether it's a problem.

I might calculate some statistics later...

MaeLSTRoM said:
No, it was for everyone
Click to expand...

Then I think you really should have used the export instead. I don't understand why you didn't. Please explain.

MaeLSTRoM said:
of using the export, are there any instructions on how to set it up anywhere?
Click to expand...

Right on the export page:
SQL: WCA_export767_20120903.sql.zip (9.2 MB)
SQL statements, for import into SQL databases.

TSV: WCA_export767_20120903.tsv.zip (8.6 MB)
Tab-separated values, for spreadsheets in OpenOffice.org, Excel, etc.
Click to expand...

Do you really need more instructions than that? If you run an SQL database, just import the SQL. If not, you should find the TSV easy to use (especially easier than parsing our html pages) in your own program or in OpenOffice.org, Excel, etc.
 
Last edited:
Stefan said:
Then I think you really should have used the export instead. I don't understand why you didn't. Please explain.
Click to expand...

To be honest, I don't know. I just decided that the easiest way for me to do it would be to parse the HTML pages. I did it more to train my programming than to be useful.
 
Well, check these out and tell me what you think :)
WCA_export_Persons.tsv
WCA_export_RanksSingle.tsv
WCA_export_RanksAverage.tsv
(or WCA_export_Results.tsv if you prefer)
 
Last edited:
Alright, "All Persons" is back. At least for now. I'm hoping that the new "1000 Persons" is better for most people so they'll use that instead.

But Chris, still do check out the tsv-files.
 
Stefan said:
Alright, "All Persons" is back. At least for now. I'm hoping that the new "1000 Persons" is better for most people so they'll use that instead.

But Chris, still do check out the tsv-files.
Click to expand...

Yep, I will do as soon as I get either office programs or SQL server on this new laptop... I'm doign badly at catching up to where my old laptop was on programs. I did look at the tsv files in notepad though, and although it kind of crashed, it looks a lot easier to deal with. not sure how to seperate lines though? They seem to just follow on?
 
MaeLSTRoM said:
Yep, I will do as soon as I get either office programs or SQL server on this new laptop... I'm doign badly at catching up to where my old laptop was on programs. I did look at the tsv files in notepad though, and although it kind of crashed, it looks a lot easier to deal with. not sure how to seperate lines though? They seem to just follow on?
Click to expand...

That's because notepad is dumb and only knows DOS line endings. Just open it with a modern text editor.
 
Even wordpad works.

So really pretty much any that you would use, except notepad. But if you don't have one yet and want a suggestion, I'm using Notepad++ and have been using PSPad before and I like both (don't know which one I like better).
 
You must log in or register to reply here.

Similar threads

Minetoucubing
Odd or fake QJ megaminx?
Replies
0
Views
188
Minetoucubing
Minetoucubing
MrCubert
SS Oddballs Redemption 2026
Replies
2
Views
433
MrCubert
MrCubert
J
Special Characters in my name appear odd in the weekly competitions
Replies
0
Views
484
J:org
J
D
reduction parity on odd cubes vs even cubes
Replies
5
Views
3,046
Christopher Mowla
Christopher Mowla
Discomantis
Need help solving odd swaps on big cubes
Replies
15
Views
2,502
Discomantis
Discomantis
Back
Top