Odd WCA stats/ Stats request Thread

[Stefan]

It would be cool to show "Highest Past Rank" for each competitors events in their WCA profile. So the former #11 in 2x2 could now be #950, but we currently don't know. Is this info available in the database? If so, could it be made public on the WCA profiles page? It would be nice to have some ranking history instead of just current ranking and past results.

I wouldn't really like it in the default display of the person pages, but I've started working on a misc section page for this after Thom wondered about his ranking progression in the latest cubecast. I guess I could link to it from person pages maybe.

 

[Evan Liu]

http://esk.staticcling.org/cubers/

I wrote some ugly code to calculate peak rankings. May not be totally accurate for singles (you might have a slightly better ranking).

Tim Sun had done this on the above website, but it's been down for a while.

 

[Mikel]

I think it would be a good idea to add somewhere on personal WCA profiles the number of competitions they have been to. I mean, we can count, but humans are lazy.

 

[Stefan]

I think it would be a good idea to add somewhere on personal WCA profiles the number of competitions they have been to. I mean, we can count, but humans are lazy.

I added it in the "Details" line. If there are other interesting single-value statistics like that, I might add a single-row "Statistics" table for this and them instead.

 

[Tim Major]

I assume this stat has been done recently, podium world records for events with maybe 5 results included (1st would generally be WC, with the exception of things like 2x2 in Australia)

I'd not, someone clever mind generating for all events?

 

[Pro94]

Gabriel Dechichi Barbar at his last competition got a 7.21 single on 3x3 and then 7.16, but only this one is recognized as SaR.
https://www.worldcubeassociation.org/results/p.php?i=2009BARB01#333

 

[kinch2002]

I added it in the "Details" line. If there are other interesting single-value statistics like that, I might add a single-row "Statistics" table for this and them instead.

Count of NRs, CRs, WRs
Sum of Singles rank
Sum of Averages rank

 

[Sebastien]

Gabriel Dechichi Barbar at his last competition got a 7.21 single on 3x3 and then 7.16, but only this one is recognized as SaR.
https://www.worldcubeassociation.org/results/p.php?i=2009BARB01#333

Because its correct this way? Read the regs.

 

[cubizh]

Spoiler: First Solve Success Rates

[TABLE="width:500, class:grid, align:left"]
[TR][TD] Event [/TD][TD] 1st time fails [/TD][TD] 1st time successes [/TD][TD] 1st time DNS [/TD][TD] Total 1st Attempts [/TD][TD] 1st Time Fail Rate [/TD][/TR]
[TR][TD] 5x5 blindfolded [/TD][TD] 202 [/TD][TD] 11 [/TD][TD] 0 [/TD][TD] 213 [/TD][TD] 94.84% [/TD][/TR]
[TR][TD] 4x4 blindfolded [/TD][TD] 379 [/TD][TD] 46 [/TD][TD] 0 [/TD][TD] 425 [/TD][TD] 89.18% [/TD][/TR]
[TR][TD] 3x3 blindfolded [/TD][TD] 2409 [/TD][TD] 561 [/TD][TD] 1 [/TD][TD] 2971 [/TD][TD] 81.08% [/TD][/TR]
[TR][TD] 3x3 multi blindfolded [/TD][TD] 623 [/TD][TD] 460 [/TD][TD] 11 [/TD][TD] 1094 [/TD][TD] 56.95% [/TD][/TR]
[TR][TD] 3x3 fewest moves [/TD][TD] 972 [/TD][TD] 1041 [/TD][TD] 34 [/TD][TD] 2047 [/TD][TD] 47.48% [/TD][/TR]
[TR][TD] 3x3 mbld old style [/TD][TD] 63 [/TD][TD] 124 [/TD][TD] 0 [/TD][TD] 187 [/TD][TD] 33.69% [/TD][/TR]
[TR][TD] 3x3 with feet [/TD][TD] 213 [/TD][TD] 613 [/TD][TD] 0 [/TD][TD] 826 [/TD][TD] 25.79% [/TD][/TR]
[TR][TD] Rubik's Clock [/TD][TD] 305 [/TD][TD] 1162 [/TD][TD] 0 [/TD][TD] 1467 [/TD][TD] 20.79% [/TD][/TR]
[TR][TD] 7x7 Cube [/TD][TD] 193 [/TD][TD] 1290 [/TD][TD] 0 [/TD][TD] 1483 [/TD][TD] 13.01% [/TD][/TR]
[TR][TD] Rubik's Magic [/TD][TD] 558 [/TD][TD] 4381 [/TD][TD] 0 [/TD][TD] 4939 [/TD][TD] 11.30% [/TD][/TR]
[TR][TD] 6x6 Cube [/TD][TD] 176 [/TD][TD] 1386 [/TD][TD] 0 [/TD][TD] 1562 [/TD][TD] 11.27% [/TD][/TR]
[TR][TD] Square-1 [/TD][TD] 188 [/TD][TD] 1626 [/TD][TD] 1 [/TD][TD] 1815 [/TD][TD] 10.36% [/TD][/TR]
[TR][TD] 4x4 Cube [/TD][TD] 785 [/TD][TD] 7150 [/TD][TD] 1 [/TD][TD] 7936 [/TD][TD] 9.89% [/TD][/TR]
[TR][TD] Megaminx [/TD][TD] 241 [/TD][TD] 2357 [/TD][TD] 0 [/TD][TD] 2598 [/TD][TD] 9.28% [/TD][/TR]
[TR][TD] 5x5 Cube [/TD][TD] 402 [/TD][TD] 4270 [/TD][TD] 1 [/TD][TD] 4673 [/TD][TD] 8.60% [/TD][/TR]
[TR][TD] 333oh [/TD][TD] 601 [/TD][TD] 6847 [/TD][TD] 10 [/TD][TD] 7458 [/TD][TD] 8.06% [/TD][/TR]
[TR][TD] Rubik's Cube [/TD][TD] 1365 [/TD][TD] 22177 [/TD][TD] 36 [/TD][TD] 23578 [/TD][TD] 5.79% [/TD][/TR]
[TR][TD] Master Magic [/TD][TD] 116 [/TD][TD] 1966 [/TD][TD] 0 [/TD][TD] 2082 [/TD][TD] 5.57% [/TD][/TR]
[TR][TD] 2x2 Cube [/TD][TD] 623 [/TD][TD] 11475 [/TD][TD] 6 [/TD][TD] 12104 [/TD][TD] 5.15% [/TD][/TR]
[TR][TD] pyraminx [/TD][TD] 275 [/TD][TD] 5240 [/TD][TD] 6 [/TD][TD] 5521 [/TD][TD] 4.98% [/TD][/TR]
[/TABLE]

Spoiler: Illustrative Chart

 

[ThomasJE]

Could someone compile the medal table (countries) for all WC's? (including 82 and 03)

 

[Pro94]

Because its correct this way? Read the regs.

I can't ge it...
For example on his 3rd competition, SESC/Santos 2010, he got 2 SaR single on 3x3 in two different rounds, I can't see why it's not the same here.

 

[Stefan]

Ah, darn, I was hoping there were days of the week we never have competitions...

Spoiler: Durations of competitions in days

days competitions
1    969
2    492
3     56

SELECT days, count(*) competitions
FROM
(SELECT datediff(year*10000+endMonth*100+endDay, year*10000+month*100+day) + 1 days
FROM Competitions) tmp
GROUP BY days

Spoiler: How often each weekday was used

weekday count
   Mon    27
   Tue    18
   Wed    12
   Thu    20
   Fri   109
   Sat  1180
   Sun   755

SELECT wd, count(*)
FROM (
(SELECT weekday(year*10000+month*100+day) wd FROM Competitions) UNION ALL
(SELECT (weekday(year*10000+month*100+day) + 1) % 7 wd FROM Competitions WHERE datediff(year*10000+endMonth*100+endDay, year*10000+month*100+day) > 0) UNION ALL
(SELECT (weekday(year*10000+month*100+day) + 2) % 7 wd FROM Competitions WHERE datediff(year*10000+endMonth*100+endDay, year*10000+month*100+day) > 1)
) tmp
GROUP BY wd

Spoiler: The competitions on Wednesdays

GuangdongOpen2008         Wed
DubaiOpen2009             Wed
MammutOpen2009            Wed
ChennaiCubeChallenge2009  Wed
JavaFMCCubeDay2010        Wed
QingmingOpen2012          Wed
Guangzhou2013             Wed
IranOpen2012              Wed-Fri
ShristiOpen2009       Tue-Wed
SouthItalianOpen2009  Tue-Wed
BogorOpen2011         Tue-Wed
GuangdongOpen2013     Tue-Wed

SELECT wed.id, weekday(year*10000+month*100+day) start, weekday(year*10000+endMonth*100+endDay)
FROM (
(SELECT id, weekday(year*10000+month*100+day) wd FROM Competitions) UNION ALL
(SELECT id, (weekday(year*10000+month*100+day) + 1) % 7 wd FROM Competitions WHERE datediff(year*10000+endMonth*100+endDay, year*10000+month*100+day) > 0) UNION ALL
(SELECT id, (weekday(year*10000+month*100+day) + 2) % 7 wd FROM Competitions WHERE datediff(year*10000+endMonth*100+endDay, year*10000+month*100+day) > 1)
) wed, Competitions
WHERE wd=2 AND Competitions.id = wed.id

I can't ge it...
For example on his 3rd competition, SESC/Santos 2010, he got 2 SaR single on 3x3 in two different rounds, I can't see why it's not the same here.

The regulations have changed?

 

[Brest]

I can't ge it...
For example on his 3rd competition, SESC/Santos 2010, he got 2 SaR single on 3x3 in two different rounds, I can't see why it's not the same here.

Probably because the first two rounds were on Friday / Saturday, and the Final round was on Sunday. This would mean the final was on a different calendar date. 9i2
Or the regulations were different when the competition was held. 9i3

 

[TDM]

I can't ge it...
For example on his 3rd competition, SESC/Santos 2010, he got 2 SaR single on 3x3 in two different rounds, I can't see why it's not the same here.

https://www.worldcubeassociation.org/regulations/#9i2

 

[Nathan Dwyer]

I would be interested to see a PB streak ranking based on how many competitions someone went with a PB single or average every competition.

 

[porkynator]

I would be interested to see a PB streak ranking based on how many competitions someone went with a PB single or average every competition.

This would be interesting.
I'm on a PB-streak since my first comp.
Can this be done also for only one event? (PB-streak for 3x3 single, PB-streak for 5x5 avg, and so on).

 

[Nathan Dwyer]

Can this be done also for only one event? (PB-streak for 3x3 single, PB-streak for 5x5 avg, and so on).

I think it would be a cool thing to have this on the WCA website in the statistics section, for just 3x3 and overall, and current and past streaks

 

[Pro94]

Probably because the first two rounds were on Friday / Saturday, and the Final round was on Sunday. This would mean the final was on a different calendar date. 9i2
Or the regulations were different when the competition was held. 9i3

https://www.worldcubeassociation.org/regulations/#9i2

Oh, ok, I didn't that rule was changed.

 

[Mikel]

I added it in the "Details" line. If there are other interesting single-value statistics like that, I might add a single-row "Statistics" table for this and them instead.

You really are the "Nicest Person on the Forum"

 

[cubizh]

Could someone compile the medal table (countries) for all WC's? (including 82 and 03)

Spoiler: Table of Medals