• Welcome to SpeedSolving.com — the world’s largest puzzle community!

    You’re currently browsing as a guest, which means you have limited access to discussions, resources, member profiles, and community features.

    Join 50,000+ cubers and puzzle enthusiasts from around the world to ask questions, share solves, improve faster, and be part of the community.

    Registration is free, fast, and easy — create your account today.

    Already a member? Log in here to hide this message and start participating.
Would it be possible to implement sum of ranks onto each WCA profile? Just add another row with sum of single and sum of avg, and then WR/CR/NR for each. Just pretend its another event or something. This way it would be automatically updating and easy to find.
 
Would it be possible to implement sum of ranks onto each WCA profile? Just add another row with sum of single and sum of avg, and then WR/CR/NR for each. Just pretend its another event or something. This way it would be automatically updating and easy to find.

That sounds like a really good idea, then also all-rounders would be winning things for a change
 
The number of regional records per year (and per year from january-april because 2011 isn't finished yet). Spot the trend.

Code:
year   all  j-a
---------------
1982    19    0
2003    80    0
2004   241   64
2005   450  106
2006   626  148
2007  1005  240
2008  1457  446
2009  2290  791
2010  2526  730
2011   752  684

SELECT   year,
         sum((regionalsinglerecord<>'') + (regionalaveragerecord<>'')),
         sum(if(month>4,0,(regionalsinglerecord<>'') + (regionalaveragerecord<>'')))
FROM     Results, Competitions c
WHERE    c.id=competitionId and (regionalsinglerecord<>'' or regionalaveragerecord<>'')
GROUP BY year
 
Last edited:
What is the slowest solve for each event? :)

Code:
5x5 blindfolded   2:34:36.00
4x4 blindfolded     46:12.00
3x3 blindfolded     35:00.00
7x7 Cube            33:44.00
6x6 Cube            26:29.00
5x5 Cube            23:03.00
3x3 with feet       16:49.00
Megaminx            15:50.00
Rubik's Cube        15:08.00
4x4 Cube            14:48.00
3x3 one-handed      11:35.00
Master Magic        10:01.00
Rubik's Magic        9:59.63
2x2 Cube             9:59.06
Square-1             9:46.80
Pyraminx             9:37.75
Rubik's Clock        8:07.50

But please don't try to beat these. Would be a waste of time for you and the others.
 
Last edited:
Code:
5x5 blindfolded   2:34:36.00
4x4 Cube          2:09:00.00
4x4 blindfolded     46:12.00
3x3 blindfolded     35:00.00
7x7 Cube            33:44.00
6x6 Cube            26:29.00
5x5 Cube            23:03.00
3x3 with feet       16:49.00
Megaminx            15:50.00
Rubik's Cube        15:08.00
3x3 one-handed      11:35.00
Master Magic        10:01.00
Rubik's Magic        9:59.63
2x2 Cube             9:59.06
Square-1             9:46.80
Pyraminx             9:37.75
Rubik's Clock        8:07.50

But please don't try to beat these. Would be a waste of competition time for you and the others.

:O Who spent 2 hours solving a 4x4?!?!?
 
Ok fixed, it's 14:48.00 now.

Woot, I just realized I not only have the slowest 5BLD but also the slowest 3BLD (those 35 minutes gave me place 3 in the world, though :) ... ah, the golden times).
 
Last edited:
Just checked the reults of that comp: there was NR and/or ER and/or WR in every round of every event.

Regarding the BLD result: you have an "official" improvement of over 30 minutes ;-)

Look what I found on Ron's report page:

Stefan_blindfold1.jpg
 
Just checked the reults of that comp: there was NR and/or ER and/or WR in every round of every event.

Regarding the BLD result: you have an "official" improvement of over 30 minutes ;-)

Look what I found on Ron's report page:

Stefan_blindfold1.jpg
I remember this. The ovation he got will be forever engrained in my memory.
 
Just wanted to point out that the single/average WR of almost all events are now held by 1 person. (Except for 2x2x2 and master magic). I think that is a clear indication that we have reached "maturity" in the results and that we have some real specialist now.
Time will tell if this is temporary or more permanent

(so square-1 single/average person 1, clock single/average person 2, etc)
 
Last edited:
Back
Top