Odd WCA stats/ Stats request Thread

[Lid]

Who's gotten the most top 3 places without coming first?

Kian Barry with 39 (0-14-25).

 

[Jimmy Liu]

Could someone make a top 100 world single and average sum of ranks for those who haven't had any NRs?

 

[Randomno]

Similar to my last request, what's the largest CR-WR difference excluding Africa?

 

[Ninja Storm]

Biggest difference between CR time and where it's place for WR? For example, Rami Sbahi has the NAR for feet average, but his time is 10th in the world (difference would be 9 then).

Same question as above, but excluding Africa?

 

[TDM]

Same question as above, but excluding Africa?

Didn't he just ask that?

 

[Randomno]

Didn't he just ask that?

Yeah I think he might have done.

 

[guysensei1]

What is the slowest single ever recorded in the WCA that is not a DNF? MultiBLD excluded.

 

[supercavitation]

What is the slowest single ever recorded in the WCA that is not a DNF? MultiBLD excluded.

I'm not positive, but I'd bet on Stefan Pochmann's 2:34:36.00 for the WCA's first 5BLD success.

 

[Stefan]

What is the slowest single ever recorded in the WCA that is not a DNF? MultiBLD excluded.

Not my 2.5 hours 5x5 blindsolve. No, no, it's this feetsolve taking almost 91 hours:
https://www.worldcubeassociation.org/results/c.php?i=ChongqingOpen2014&allResults=1#333ft

Edit: Top 20 excluding multi/big blind:

Spoiler: Slowest solves

Using data from WCA_export513_20141116 and Stefan's WCA Statistics Tools.

[TABLE="class:grid,align:left"]
[TR][TD]competitionId[/TD][TD]eventId[/TD][TD]roundId[/TD][TD]personName[/TD][TD]Worst[/TD][TD]value1[/TD][TD]value2[/TD][TD]value3[/TD][TD]value4[/TD][TD]value5[/TD][/TR]
[TR][TD]Chongqing Open 2014[/TD][TD]3x3 with feet[/TD][TD]f[/TD][TD]Xin Shi (石欣)[/TD][TD="align:right"]90:56:00.00[/TD][TD="align:right"]3:47.22[/TD][TD="align:right"]DNF[/TD][TD="align:right"]90:56:00.00[/TD][TD="align:right"][/TD][TD="align:right"][/TD][/TR]
[TR][TD]Ho Chi Minh 2013[/TD][TD]5x5 Cube[/TD][TD]f[/TD][TD]Đoàn Thanh Duy[/TD][TD="align:right"]2:18:38.00[/TD][TD="align:right"]2:11.54[/TD][TD="align:right"]2:18:38.00[/TD][TD="align:right"]2:23.69[/TD][TD="align:right"][/TD][TD="align:right"][/TD][/TR]
[TR][TD]Kharkiv Winter 2012[/TD][TD]3x3 one-handed[/TD][TD]d[/TD][TD]Illia Zhadan (Ілля Жадан)[/TD][TD="align:right"]2:00:34.00[/TD][TD="align:right"]54.91[/TD][TD="align:right"]1:16.77[/TD][TD="align:right"]2:00:34.00[/TD][TD="align:right"]2:03.81[/TD][TD="align:right"]58.05[/TD][/TR]
[TR][TD]Pune Fall Open 2014[/TD][TD]Rubik's Cube[/TD][TD="align:right"]1[/TD][TD]Akash Nagarkar[/TD][TD="align:right"]1:42:57.00[/TD][TD="align:right"]41.33[/TD][TD="align:right"]45.18[/TD][TD="align:right"]1:42:57.00[/TD][TD="align:right"]53.86[/TD][TD="align:right"]41.22[/TD][/TR]
[TR][TD]Lithuanian Open 2013[/TD][TD]7x7 Cube[/TD][TD]f[/TD][TD]Atis Hermanis[/TD][TD="align:right"]47:36.00[/TD][TD="align:right"]47:36.00[/TD][TD="align:right"]DNS[/TD][TD="align:right"]DNS[/TD][TD="align:right"][/TD][TD="align:right"][/TD][/TR]
[TR][TD]SESC/Santos 2011[/TD][TD]7x7 Cube[/TD][TD]c[/TD][TD]Conrad Alberto Michelucci[/TD][TD="align:right"]44:02.00[/TD][TD="align:right"]44:02.00[/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][/TR]
[TR][TD]Polish Nationals 2013[/TD][TD]5x5 Cube[/TD][TD]d[/TD][TD]Wojciech Szatanowski[/TD][TD="align:right"]38:35.00[/TD][TD="align:right"]38:35.00[/TD][TD="align:right"]2:22.83[/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][/TR]
[TR][TD]Danish Special 2013[/TD][TD]3x3 with feet[/TD][TD]c[/TD][TD]Damien Støvring Rolighed[/TD][TD="align:right"]37:41.00[/TD][TD="align:right"]37:41.00[/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][/TR]
[TR][TD]German Open 2004[/TD][TD]3x3 blindfolded[/TD][TD]f[/TD][TD]Stefan Pochmann[/TD][TD="align:right"]35:00.00[/TD][TD="align:right"]35:00.00[/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][/TR]
[TR][TD]FLIP Open 2013[/TD][TD]7x7 Cube[/TD][TD]c[/TD][TD]Fabien Lebailly[/TD][TD="align:right"]34:59.00[/TD][TD="align:right"]34:59.00[/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][/TR]
[TR][TD]Brasília Open 2009[/TD][TD]7x7 Cube[/TD][TD]c[/TD][TD]Anders Larsson[/TD][TD="align:right"]33:44.00[/TD][TD="align:right"]33:44.00[/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][/TR]
[TR][TD]Big CubingItaly 2013[/TD][TD]5x5 Cube[/TD][TD]d[/TD][TD]Lorenzo Guazzo[/TD][TD="align:right"]31:32.00[/TD][TD="align:right"]31:32.00[/TD][TD="align:right"]3:19.33[/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][/TR]
[TR][TD]Barcelona Open 2010[/TD][TD]7x7 Cube[/TD][TD]c[/TD][TD]David Parra Meza[/TD][TD="align:right"]29:00.00[/TD][TD="align:right"]29:00.00[/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][/TR]
[TR][TD]French Open 2013[/TD][TD]7x7 Cube[/TD][TD]c[/TD][TD]Thomas Iyer[/TD][TD="align:right"]28:39.00[/TD][TD="align:right"]28:39.00[/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][/TR]
[TR][TD]France 2013[/TD][TD]7x7 Cube[/TD][TD]c[/TD][TD]Thomas Iyer[/TD][TD="align:right"]28:36.00[/TD][TD="align:right"]28:36.00[/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][/TR]
[TR][TD]Madrid Open 2010[/TD][TD]7x7 Cube[/TD][TD]c[/TD][TD]Javier Espinosa García[/TD][TD="align:right"]28:15.00[/TD][TD="align:right"]28:15.00[/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][/TR]
[TR][TD]France 2013[/TD][TD]7x7 Cube[/TD][TD]c[/TD][TD]Jérôme Tatti[/TD][TD="align:right"]27:25.00[/TD][TD="align:right"]27:25.00[/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][/TR]
[TR][TD]Ballerup Open 2013[/TD][TD]3x3 with feet[/TD][TD]f[/TD][TD]Christian Schiøtt[/TD][TD="align:right"]27:05.00[/TD][TD="align:right"]3:52.38[/TD][TD="align:right"]DNF[/TD][TD="align:right"]27:05.00[/TD][TD="align:right"][/TD][TD="align:right"][/TD][/TR]
[TR][TD]France 2013[/TD][TD]7x7 Cube[/TD][TD]c[/TD][TD]Fabien Lebailly[/TD][TD="align:right"]27:02.00[/TD][TD="align:right"]27:02.00[/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][/TR]
[TR][TD]Cachan Open 2011[/TD][TD]5x5 Cube[/TD][TD]c[/TD][TD]Clelia Valuy[/TD][TD="align:right"]26:53.00[/TD][TD="align:right"]26:53.00[/TD][TD="align:right"]14:38.00[/TD][TD="align:right"][/TD][TD="align:right"][/TD][TD="align:right"][/TD][/TR]
[/TABLE]

Spoiler: SQL

[NOPARSE]SELECT
  competitionId, eventId, roundId, personName, greatest(value1, value2, value3, value4, value5) 'Worst[T]',
  value1 'value1[T]', value2 'value2[T]', value3 'value3[T]', value4 'value4[T]', value5 'value5[T]'
FROM Results
WHERE eventId not in ('333mbf', '333mbo', '555bf', '444bf')
ORDER BY 5 desc
LIMIT 20;[/NOPARSE]

 

[Randomno]

Not my 2.5 hours 5x5 blindsolve. No, no, it's this feetsolve taking almost 91 hours:
https://www.worldcubeassociation.org/results/c.php?i=ChongqingOpen2014&allResults=1#333ft

The competition didn't even last 90 hours. How is that possible?

 

[Stefan]

If you ever feel like making an uber-complicated all-rounder ranking, have a look at this. That's page 1 of 6. The IAAF seems to have abandoned it, but this other site is using it. I found some old news talking about a "Top Performer of the Month" award, which sounds nice. I haven't read it all, but maybe someone else is interested and maybe there are useful ideas in it somewhere.

 

[henrysavich]

Similar to my last request, what's the largest CR-WR difference excluding Africa?

OK, I just went through and looked at this manually, so no guarantees it is correct, but Faz has the Oceanic record for clock single with an 8.81, which places him 122 in the world

 

[CyanSandwich]

OK, I just went through and looked at this manually, so no guarantees it is correct, but Faz has the Oceanic record for clock single with an 8.81, which places him 122 in the world

You should've looked just a smidge more because Brock's clock average is 188th in the world

Of course I was only looking at Oceanic records so no guarantees.

 

[henrysavich]

You should've looked just a smidge more because Brock's clock average is 188th in the world

Of course I was only looking at Oceanic records so no guarantees.

haha, I realized that I had forgot to look at clock averages after I posted. I do believe you are correct that would be the lowest ranked CR

 

[antoineccantin]

Sum of single and average ranks for 3x3 solving with different body parts (3x3+OH+Feet)?

 

[vcuber13]

You can do that with the sum of ranks program.

 

[antoineccantin]

You can do that with the sum of ranks program.

I didn't think you could combine single and average into one?

 

[Hssandwich]

Everybody should have looked more closely, Dene Beardsley, 3x3 WF mean 2:01.88, 249th in the world

 

[vcuber13]

I didn't think you could combine single and average into one?

I think you're right, but it shouldn't be hard to copy both of them into excel and then sort.

 

[Randomno]

Everybody should have looked more closely, Dene Beardsley, 3x3 WF mean 2:01.88, 249th in the world

That's not a CR though, only an NR.