Odd WCA stats/ Stats request Thread

ilikecubing · Apr 14, 2012

Code:

+------------+----------------------------+-----------------+----+
| personId   | personName                 | personCountryId | nb |
+------------+----------------------------+-----------------+----+
| 2008MORE02 | Hippolyte Moreau           | France          |  5 |
| 2011KULS01 | Ayush Kumar                | India           |  3 |
| 2009VALL01 | Cristobal Correa del Valle | Chile           |  3 |
| 2004SECH01 | François Sechet            | France          |  3 |
| 2004ROUX01 | Gilles Roux                | France          |  3 |
| 2006JAEY01 | JaeYoung Chun (천재영)      | Korea           |  3 |
| 2008CAMP01 | Pablo Ruiz Campos          | Mexico          |  3 |
| 2008CRAW01 | Simon Crawford             | United Kingdom  |  3 |
+------------+----------------------------+-----------------+----+
8 rows in set (1.52 sec)

Stood 2nd in my previous comp,so not in this list anymore

Request for list of top 10 ppl with biggest difference between their 4x4 single and average

Flyt · Apr 14, 2012

ilikecubing said:
Request for list of top 10 ppl with biggest difference between their 4x4 single and average

And shortest, please =)

Bob · Apr 14, 2012

ilikecubing said:
Stood 2nd in my previous comp,so not in this list anymore

Request for list of top 10 ppl with biggest difference between their 4x4 single and average

Whoa...why does your WCAID not follow convention?

Michael Womack · Apr 14, 2012

Can someone find me the cubers that has a 2x2/3x3 solve of 5 mins -10 mins.

Julian · Apr 14, 2012

Michael Womack said:
Can someone find me the cubers that has a 2x2/3x3 solve of 5 mins -10 mins.

Last two.
Last 13.

ilikecubing · Apr 14, 2012

Bob said:
Whoa...why does your WCAID not follow convention?

Its because I had a name change

Pro94 · Apr 15, 2012

We had 4 WRs this weekend in 3 different competitions, all in Europe (5 if we consider 3x3 Best Podium).
Has this already happened?

blakedacuber · Apr 15, 2012

Most national records brOken by a single person at 1 competition in the last 3 years?

Coolster01 · Apr 17, 2012

Youngest 4x4 and 5x5 BLD solver?

I was wondering if i am the world's youngest 4x4 BLDer which i will do at nationals. I am reaaally close for 4x4 and am sure to get it next weekend, considering it's pretty easy for me. For 5x5 BLD, i just need an inner edges parity algorithm. Im the 8th youngest for normal BLD (yes, done at Hillsdale Winter 2012). Please answer. Thanks!
Edit: Sorry I'm new to speedsolving so I obviously multi posted way too much

pdilla · Apr 17, 2012

ben1996123 · Apr 17, 2012

It depends how old you are.

RNewms27 · Apr 17, 2012

He is somewhere between 10 and 11.

drewsopchak · Apr 17, 2012

Your constitution must be admirable to be big cube blding at your age.

Coolster01 · Apr 17, 2012

pdilla said:
Age?

Oh whoops, i am 10 years 8 months and 8 days old as of April 17

Oh by the way check out my video on my youtube channel of mu BLD solve. I cant get the link because I'm on an iPad

drewsopchak said:
Your constitution must be admirable to be big cube blding at your age.

This is probably the only thing I'll ever accomplish in life that isnt fun but i had to push myself LOL. Eventually big cubes BLD will be fun

ardi4nto · Apr 17, 2012

ilikecubing said:
Request for list of top 10 ppl with biggest difference between their 4x4 single and average

Hi Ayush,

Here it is,

Code:

+----------+----------+------------+----------------------------+------------+-----------------+
| pbAvg    | pbSgl    | difference | personName                 | personId   | personCountryId |
+----------+----------+------------+----------------------------+------------+-----------------+
| 422.4800 | 195.6100 |   226.8700 | Kenn-Eerik Kannike         | 2009KANN01 | Estonia         |
| 412.4900 | 206.6500 |   205.8400 | Aman Agrawal               | 2012AGRA01 | India           |
| 322.2900 | 133.3800 |   188.9100 | Marine Asalia              | 2009ASAL01 | India           |
| 468.9800 | 292.3400 |   176.6400 | Saarthi Bhatia             | 2009BHAT02 | India           |
| 375.8900 | 203.7200 |   172.1700 | Indrek J├Áe                | 2009JOEI01 | Estonia         |
| 335.5800 | 175.5700 |   160.0100 | Dariusz Peta               | 2005PETA01 | Poland          |
| 332.6100 | 173.7200 |   158.8900 | Eduardo Gonz├ílez Parra    | 2011PARR03 | Mexico          |
| 337.4900 | 180.3800 |   157.1100 | Krzysztof Boryczko         | 2005BORY01 | Poland          |
| 317.9600 | 161.3000 |   156.6600 | Rebecca Hughey             | 2007HUGH04 | USA             |
| 369.9200 | 219.0800 |   150.8400 | Patrick Garcin             | 2008GARC05 | France          |
+----------+----------+------------+----------------------------+------------+-----------------+

Based on Stefan's code few pages before.

Code:

SELECT pbAvg, pbSgl, pbAvg-pbSgl difference, personName, personId, personCountryId
FROM (SELECT min(if(average>0,average/100.00,1111111111)) AS pbAvg, min(if(best>0,best/100.00,1111111111)) AS pbSgl, personName, personId, personCountryId
FROM results
WHERE eventId = '444'
GROUP BY personId) helper
WHERE pbAvg<1111111111 AND pbSgl<1111111111
ORDER BY difference DESC
LIMIT 10

For the smallest difference:

Code:

+---------+---------+------------+-------------------------------------------------+------------+-----------------+
| pbAvg   | pbSgl   | difference | personName                                      | personId   | personCountryId |
+---------+---------+------------+-------------------------------------------------+------------+-----------------+
| 80.6600 | 80.1900 |     0.4700 | Muhammad Bintang Assyidik                       | 2010ASSY01 | Indonesia       |
| 57.4400 | 56.7200 |     0.7200 | Erwan Kohler                                    | 2010KOHL02 | Switzerland     |
| 66.0700 | 64.7700 |     1.3000 | Yukiko Makino (þëºÚçÄþö▒Õ©îÕ¡É)                 | 2007MAKI01 | Japan           |
| 74.8800 | 73.5600 |     1.3200 | Mateusz Burnicki                                | 2006BURN01 | Poland          |
| 75.6500 | 74.2800 |     1.3700 | Zijing Jin (ÚçæÕ¡ÉÚØû)                          | 2011JINZ01 | China           |
| 70.9700 | 69.5600 |     1.4100 | Sakai Taisyu (ÕØéõ║òÕñºÕæ¿)                     | 2012TAIS01 | Japan           |
| 82.0000 | 80.5600 |     1.4400 | Bo-Zhou Xiao                                    | 2009XIAO01 | Taiwan          |
| 59.6600 | 58.1600 |     1.5000 | Dakota Allen Harris                             | 2008HARR03 | USA             |
| 58.7200 | 57.1500 |     1.5700 | Julian David                                    | 2010DAVI06 | Canada          |
| 51.6800 | 50.0200 |     1.6600 | Marcin Zalewski                                 | 2011ZALE02 | Poland          |
+---------+---------+------------+-------------------------------------------------+------------+-----------------+

Henrik · Apr 17, 2012

blakedacuber said:
Most national records brOken by a single person at 1 competition in the last 3 years?

I think you are right up there with your 14

I found one of my own where I did 10 NRs (It keeps getting harder to break

)

ben1996123 · Apr 17, 2012

Longest standing NRs?

aronpm · Apr 17, 2012

ben1996123 said:
Longest standing NRs?

Almost 30 years, and counting http://worldcubeassociation.org/results/p.php?i=1982BORS01

Pro94 · Apr 17, 2012

Most national records brOken by a single person at 1 competition in the last 3 years?

It depends: Feliks has 17 NRs in one comp (counting CRs and WR, because they are also NRs). If you count only NRs I agree with Henrik.

SimonWestlund · Apr 17, 2012

Henrik said:
I think you are right up there with your 14

I found one of my own where I did 10 NRs (It keeps getting harder to break )

I broke 16 at the Helsinki Open 2011

Odd WCA stats/ Stats request Thread

Veteran

Member

Premium Member

Legend

Veteran

Veteran

Veteran

Premium Member

Veteran

Veteran

Banned

Veteran

Veteran

Veteran

Regular

Veteran

Banned

Veteran

Veteran

Veteran

Similar threads