Odd WCA stats/ Stats request Thread

[Jimmy Liu]

Would it be possible to rank the top 10 official sum of minx averages and singles?

For example, mine would be:
pyra: 4.45
skewb: 3.91
mega: 44.49
=52.85

I would do it but I've no idea how to. Thanks in advance to whoever helps me out!

Skewb is a kind of minx? Hmmm....

How about sum of pyra, SQ1 and Skewb?

 

[EMI]

Skewb is a kind of minx? Hmmm....

How about sum of pyra, SQ1 and Skewb?

No, Square-1, 2x2, 3x3, 4x4 and 5x5 pls, but only singles.

 

[Lucas Wesche]

No, Square-1, 2x2, 3x3, 4x4 and 5x5 pls, but only singles.

Why no average?

 

[EMI]

Why no average?

Because my 5x5 average is bad...

 

[guysensei1]

What is the longest standing record (NR/CR/WR) of all time?

(1982 World championship excluded for obvious reasons)

 

[Pro94]

What is the longest standing record (NR/CR/WR) of all time?

(1982 World championship excluded for obvious reasons)

NR: 3x3 Fewest Moves Single (Czech Republic) https://www.worldcubeassociation.org/results/p.php?i=2003GOLJ01 (4010 days)

 

[Stefan]

What is the longest standing record (NR/CR/WR) of all time?

(1982 World championship excluded for obvious reasons)

None of the 1982 results are regional records anymore. I guess you mean to include standing times of obsolete records?

NR: 3x3 Fewest Moves Single (Czech Republic) https://www.worldcubeassociation.org/results/p.php?i=2003GOLJ01 (4010 days)

That's 3500 days.

 

[Pro94]

None of the 1982 results are regional records anymore. I guess you mean to include standing times of obsolete records?



That's 3500 days.

My bad, I counted the first of his WRs.

 

[guysensei1]

None of the 1982 results are regional records anymore. I guess you mean to include standing times of obsolete records?

Let me rephrase:
What is the longest time that any person has held a record? It could be either still ongoing or already beaten. Exclude records from 1982.

 

[antoineccantin]

Shortest lasting WRs?

 

[Mikel]

Shortest lasting WRs?

Under the current regulations, it's not considered a record unless it's the fastest result of that day. This means the shortest records can only be at minimum 1 day. John Brechon 7.46 skewb WR average stood only 1 day.

 

[Pro94]

http://cubecomps.com/live.php?cid=594&cat=2&rnd=3

0.78 and 0.81 2x2 singles.
Also a 1.03 on 4th scramble, but I'd say it was the previous scramble.

 

[Divineskulls]

Would it be possible to rank the top 10 official sum of minx averages and singles?

For example, mine would be:
pyra: 4.45
skewb: 3.91
mega: 44.49
=52.85

I would do it but I've no idea how to. Thanks in advance to whoever helps me out!

Bump? I actually tried to work it out with the SQL export, but I don't know enough to actually do it. :/

 

[Lid]

Bump? I actually tried to work it out with the SQL export, but I don't know enough to actually do it. :/

I'll hack something together ...

 

[Divineskulls]

I'll hack something together ...

Thank you so much!

 

[Lid]

Spoiler: top25 single

Singles top25
-------------
 1 51.11 2010CORM02 Louis Cormier, Canada
 2 51.29 2008ANDE02 Oscar Roth Andersen, Denmark
 3 52.58 2009ZEMD01 Feliks Zemdegs, Australia
 4 55.02 2008WEST02 Simon Westlund, Sweden
 5 57.63 2011WALL02 Chris Wall, United Kingdom
 6 58.89 2008JONG03 Jong-Ho Jeong (정종호), Korea
 7 59.18 2009YAUR01 Robert Yau, United Kingdom
 8 1:00.52 2010OMUL02 Matic Omulec, Slovenia
 9 1:01.62 2011RECH01 Nick Rech, USA
10 1:01.73 2010BREC01 John Brechon, USA
11 1:02.60 2009DIMP01 Mariano D'Imperio, Italy
12 1:02.63 2012WESC01 Lucas Wesche, Germany
13 1:03.93 2007NAKA03 Yu Nakajima (中島悠), Japan
14 1:04.71 2010WEYE02 Sebastian Weyer, Germany
15 1:06.57 2010CANT02 Antoine Cantin, Canada
16 1:06.72 2010WANG17 Yiwei Wang (王祎玮), China
17 1:07.00 2011SBAH01 Rami Sbahi, USA
18 1:08.02 2012KRIS12 Artur Kristof, Poland
19 1:08.50 2011THOM01 Justin Thomas, USA
20 1:08.73 2009SHEP01 Daniel Sheppard, United Kingdom
21 1:09.17 2009LIUE01 Evan Liu, USA
22 1:09.18 2005AKKE01 Erik Akkersdijk, Netherlands
23 1:09.25 2011CHAP01 José Leonardo Chaparro Prieto, Colombia
24 1:09.32 2012COST01 Kevin Costello III, USA
25 1:10.51 2011DERS01 Ramón Dersch, Germany

Spoiler: top25 average

Averages top25
--------------
 1 59.41 2010CORM02 Louis Cormier, Canada
 2 1:02.23 2008ANDE02 Oscar Roth Andersen, Denmark
 3 1:04.58 2009ZEMD01 Feliks Zemdegs, Australia
 4 1:07.23 2011WALL02 Chris Wall, United Kingdom
 5 1:07.57 2009YAUR01 Robert Yau, United Kingdom
 6 1:08.48 2008WEST02 Simon Westlund, Sweden
 7 1:10.27 2007NAKA03 Yu Nakajima (中島悠), Japan
 8 1:11.10 2008JONG03 Jong-Ho Jeong (정종호), Korea
 9 1:11.87 2011RECH01 Nick Rech, USA
10 1:11.95 2010OMUL02 Matic Omulec, Slovenia
11 1:13.35 2010BREC01 John Brechon, USA
12 1:14.24 2011SBAH01 Rami Sbahi, USA
13 1:15.65 2012WESC01 Lucas Wesche, Germany
14 1:18.34 2010CANT02 Antoine Cantin, Canada
15 1:19.36 2011CHAP01 José Leonardo Chaparro Prieto, Colombia
16 1:20.92 2009DIMP01 Mariano D'Imperio, Italy
17 1:21.10 2010LANE02 Mitchell Lane, USA
18 1:21.15 2005AKKE01 Erik Akkersdijk, Netherlands
19 1:21.76 2012MCNE01 Jayden McNeill, Australia
20 1:21.82 2010WEYE02 Sebastian Weyer, Germany
21 1:22.55 2010HIDA01 Jaka Wahyu Hidayat, Indonesia
22 1:22.70 2008BARA01 Bence Barát, Hungary
23 1:23.38 2010BENT01 Jan Bentlage, Germany
24 1:23.55 2011THOM01 Justin Thomas, USA
25 1:23.66 2012CHOS01 SeungBeom Cho (조승범), Korea

Note: latest export does not have Euro 2014 in it.
edit: Looks like the ranks files doesn't have US Nats either ...

 

[Stefan]

I actually tried to work it out with the SQL export, but I don't know enough to actually do it. :/

One way to do it:

SELECT sum(best)/100, name
FROM RanksSingle JOIN Persons ON Persons.id = personId
WHERE eventId in ('pyram', 'skewb', 'minx')
GROUP BY personId
HAVING count(*) = 3
ORDER BY 1
LIMIT 10

 

[Stefan]

Where an NR = 1 point, CR = 5 points and WR = 10 points, who are the top 100 cubers? I was mostly wondering about the gap between Feliks and 2nd place

Guess who is second place.

 

[Robert-Y]

Conor Cronin?

 

[vcuber13]

Conor Cronin?

Emile has had way more AfRs

Erik?