Odd WCA stats/ Stats request Thread

[yoinneroid]

How about https://www.worldcubeassociation.org/results/p.php?i=2010HIDA01 ?
He got a 10.53 skewb avg on 5th Jan, which is sub AsR at that time, before yuxuan's 9.96, which is on 11th Jan, yet he only ends up with NR

 

[Sebastien]

Indeed, I just fixed that.

Thanks for bringing thus up, but in general it is more efficient to mail the results team for such issues.

 

[yoinneroid]

Noted

But then, is the fix suppose to appear immediately? Otherwise I can't see any change at all.

 

[Sebastien]

The website cache only gets autimatically updated periodically. We can do that manually as well but often don't do it for small fixes because of lazyness.

I just did it though: https://www.worldcubeassociation.org/results/p.php?i=2010HIDA01

 

[Carrot]

I don't think I understood it the way you think I understood it.

I just think that it makes no sense to ask for a fix for very recent inconsistencies, as people are likely aware of this anyway. So that wasn't even addressed to you in particular.

The background is, that our system computed your record as WR, which leaves the choice between WR and "Nothing" for the normal results poster. I marked the average as ER now manually in the database a couple of hours ago.

Fair enough then. (your use of the word 'yelling' came across wrong then)

I assumed the system worked somewhat like that, but in a case like this you shouldn't announce the winners etc. with the WCA post before those fixes has been done, so when you make the WCA announcement of the comp I of course assume you just overlooked/forgot it. (because then the post on WCA won't be crediting all the record holders)

Just because someone breaks a world record and another guy breaks it the same day (from another continent), does that really mean that the first guy to make it should receive no credit. (this is a general question for the future)

From my perspective I don't see why it was wrong to send the result team a mail about this.

 

[Tim Major]

I just think that it makes no sense to ask for a fix for very recent inconsistencies, as people are likely aware of this anyway. So that wasn't even addressed to you in particular.

If he didn't post about it, it may not be changed right now (he brought your attention to it)

If there's a serious car accident do you just assume someone has already called an ambulance and walk away? Personally I think two people reporting something is better than no one.

Anyway, glad that's fixed now. Was just a minor thing, I didn't really think Odder sounded upset about it/yelled about it anyway.

 

[TiLiMayor]

Is there a way/tool to sort competitions according to the number of competitors/events within a country/continent?

 

[Stefan]

Is there a way/tool to sort competitions according to the number of competitors/events within a country/continent?

Yes, for example MySQL.

 

[Carrot]

Yes, for example MySQL.

Funny, I was considering answering "Yes, SQL." when I first saw his post, but I decided not to.

 

[Riley]

List of people who have gotten a sub 10 3x3 average without any times between 8.99 and 10.00 seconds?

 

[Lid]

List of people who have gotten a sub 10 3x3 average without any times between 8.99 and 10.00 seconds?

At the moment there are 1150 sub10s 3x3x3 avgs, 150 of them fits your definition, for a total of 47 people.

Spoiler: Full list

[table="class:grid"]
[tr][td]Competitor[/td][td="align:right"]times[/td][/tr]
[tr][td]Feliks Zemdegs[/td][td="align:right"]23[/td][/tr]
[tr][td]Mats Valk[/td][td="align:right"]15[/td][/tr]
[tr][td]Cornelius Dieckmann[/td][td="align:right"]8[/td][/tr]
[tr][td]Michał Pleskowicz[/td][td="align:right"]8[/td][/tr]
[tr][td]Rowe Hessler[/td][td="align:right"]8[/td][/tr]
[tr][td]Alexander Lau[/td][td="align:right"]7[/td][/tr]
[tr][td]Sebastian Weyer[/td][td="align:right"]7[/td][/tr]
[tr][td]Arifumi Fushimi (伏見有史)[/td][td="align:right"]4[/td][/tr]
[tr][td]Erik Akkersdijk[/td][td="align:right"]4[/td][/tr]
[tr][td]Morten Arborg[/td][td="align:right"]4[/td][/tr]
[tr][td]Richard Jay S. Apagar[/td][td="align:right"]4[/td][/tr]
[tr][td]Yumu Tabuchi (田渕雄夢)[/td][td="align:right"]4[/td][/tr]
[tr][td]Carlos Méndez García-Barroso[/td][td="align:right"]3[/td][/tr]
[tr][td]Gabriel Dechichi Barbar[/td][td="align:right"]3[/td][/tr]
[tr][td]Kevin Costello III[/td][td="align:right"]3[/td][/tr]
[tr][td]Paolo Moriello[/td][td="align:right"]3[/td][/tr]
[tr][td]Piti Pichedpan (ปิติ พิเชษฐพันธ์)[/td][td="align:right"]3[/td][/tr]
[tr][td]Sergey Ryabko[/td][td="align:right"]3[/td][/tr]
[tr][td]Andrew Ricci[/td][td="align:right"]2[/td][/tr]
[tr][td]Jules Desjardin[/td][td="align:right"]2[/td][/tr]
[tr][td]Kanneti Sae Han (คันธ์เนตี แซ่ห่าน)[/td][td="align:right"]2[/td][/tr]
[tr][td]Leon Schmidtchen[/td][td="align:right"]2[/td][/tr]
[tr][td]Lucas Etter[/td][td="align:right"]2[/td][/tr]
[tr][td]Mulun Yin (阴目仑)[/td][td="align:right"]2[/td][/tr]
[tr][td]Yu Nakajima (中島悠)[/td][td="align:right"]2[/td][/tr]
[tr][td]Bill Wang[/td][td="align:right"]1[/td][/tr]
[tr][td]Breandan Vallance[/td][td="align:right"]1[/td][/tr]
[tr][td]Dan Cohen[/td][td="align:right"]1[/td][/tr]
[tr][td]Daniil Lee[/td][td="align:right"]1[/td][/tr]
[tr][td]Eric Limeback[/td][td="align:right"]1[/td][/tr]
[tr][td]Giovanni Contardi[/td][td="align:right"]1[/td][/tr]
[tr][td]Haowei Fan (樊浩玮)[/td][td="align:right"]1[/td][/tr]
[tr][td]Ivan Vynnyk (Іван Винник)[/td][td="align:right"]1[/td][/tr]
[tr][td]Jakub Kipa[/td][td="align:right"]1[/td][/tr]
[tr][td]James Hamory[/td][td="align:right"]1[/td][/tr]
[tr][td]Jan Smarschevski[/td][td="align:right"]1[/td][/tr]
[tr][td]Jong-Ho Jeong (정종호)[/td][td="align:right"]1[/td][/tr]
[tr][td]Kevin Hays[/td][td="align:right"]1[/td][/tr]
[tr][td]Kirt Protacio[/td][td="align:right"]1[/td][/tr]
[tr][td]Marcin Zalewski[/td][td="align:right"]1[/td][/tr]
[tr][td]Philipp Weyer[/td][td="align:right"]1[/td][/tr]
[tr][td]Ravi Fernando[/td][td="align:right"]1[/td][/tr]
[tr][td]Riley Woo[/td][td="align:right"]1[/td][/tr]
[tr][td]Robert Yau[/td][td="align:right"]1[/td][/tr]
[tr][td]Seyyed Mohammad Hossein Fatemi (سید محمد حسین فاطمی)[/td][td="align:right"]1[/td][/tr]
[tr][td]Thanaporn Sichanugrist (ธนพร สิชฌนุกฤษฎ์)[/td][td="align:right"]1[/td][/tr]
[tr][td]Vincent Hartanto Utomo[/td][td="align:right"]1[/td][/tr]
[/table]

 

[Riley]

At the moment there are 1150 sub10s 3x3x3 avgs, 150 of them fits your definition, for a total of 47 people.

Spoiler: Full list

[table="class:grid"]
[tr][td]Competitor[/td][td="align:right"]times[/td][/tr]
[tr][td]Feliks Zemdegs[/td][td="align:right"]23[/td][/tr]
[tr][td]Mats Valk[/td][td="align:right"]15[/td][/tr]
[tr][td]Cornelius Dieckmann[/td][td="align:right"]8[/td][/tr]
[tr][td]Michał Pleskowicz[/td][td="align:right"]8[/td][/tr]
[tr][td]Rowe Hessler[/td][td="align:right"]8[/td][/tr]
[tr][td]Alexander Lau[/td][td="align:right"]7[/td][/tr]
[tr][td]Sebastian Weyer[/td][td="align:right"]7[/td][/tr]
[tr][td]Arifumi Fushimi (伏見有史)[/td][td="align:right"]4[/td][/tr]
[tr][td]Erik Akkersdijk[/td][td="align:right"]4[/td][/tr]
[tr][td]Morten Arborg[/td][td="align:right"]4[/td][/tr]
[tr][td]Richard Jay S. Apagar[/td][td="align:right"]4[/td][/tr]
[tr][td]Yumu Tabuchi (田渕雄夢)[/td][td="align:right"]4[/td][/tr]
[tr][td]Carlos Méndez García-Barroso[/td][td="align:right"]3[/td][/tr]
[tr][td]Gabriel Dechichi Barbar[/td][td="align:right"]3[/td][/tr]
[tr][td]Kevin Costello III[/td][td="align:right"]3[/td][/tr]
[tr][td]Paolo Moriello[/td][td="align:right"]3[/td][/tr]
[tr][td]Piti Pichedpan (ปิติ พิเชษฐพันธ์)[/td][td="align:right"]3[/td][/tr]
[tr][td]Sergey Ryabko[/td][td="align:right"]3[/td][/tr]
[tr][td]Andrew Ricci[/td][td="align:right"]2[/td][/tr]
[tr][td]Jules Desjardin[/td][td="align:right"]2[/td][/tr]
[tr][td]Kanneti Sae Han (คันธ์เนตี แซ่ห่าน)[/td][td="align:right"]2[/td][/tr]
[tr][td]Leon Schmidtchen[/td][td="align:right"]2[/td][/tr]
[tr][td]Lucas Etter[/td][td="align:right"]2[/td][/tr]
[tr][td]Mulun Yin (阴目仑)[/td][td="align:right"]2[/td][/tr]
[tr][td]Yu Nakajima (中島悠)[/td][td="align:right"]2[/td][/tr]
[tr][td]Bill Wang[/td][td="align:right"]1[/td][/tr]
[tr][td]Breandan Vallance[/td][td="align:right"]1[/td][/tr]
[tr][td]Dan Cohen[/td][td="align:right"]1[/td][/tr]
[tr][td]Daniil Lee[/td][td="align:right"]1[/td][/tr]
[tr][td]Eric Limeback[/td][td="align:right"]1[/td][/tr]
[tr][td]Giovanni Contardi[/td][td="align:right"]1[/td][/tr]
[tr][td]Haowei Fan (樊浩玮)[/td][td="align:right"]1[/td][/tr]
[tr][td]Ivan Vynnyk (Іван Винник)[/td][td="align:right"]1[/td][/tr]
[tr][td]Jakub Kipa[/td][td="align:right"]1[/td][/tr]
[tr][td]James Hamory[/td][td="align:right"]1[/td][/tr]
[tr][td]Jan Smarschevski[/td][td="align:right"]1[/td][/tr]
[tr][td]Jong-Ho Jeong (정종호)[/td][td="align:right"]1[/td][/tr]
[tr][td]Kevin Hays[/td][td="align:right"]1[/td][/tr]
[tr][td]Kirt Protacio[/td][td="align:right"]1[/td][/tr]
[tr][td]Marcin Zalewski[/td][td="align:right"]1[/td][/tr]
[tr][td]Philipp Weyer[/td][td="align:right"]1[/td][/tr]
[tr][td]Ravi Fernando[/td][td="align:right"]1[/td][/tr]
[tr][td]Riley Woo[/td][td="align:right"]1[/td][/tr]
[tr][td]Robert Yau[/td][td="align:right"]1[/td][/tr]
[tr][td]Seyyed Mohammad Hossein Fatemi (سید محمد حسین فاطمی)[/td][td="align:right"]1[/td][/tr]
[tr][td]Thanaporn Sichanugrist (ธนพร สิชฌนุกฤษฎ์)[/td][td="align:right"]1[/td][/tr]
[tr][td]Vincent Hartanto Utomo[/td][td="align:right"]1[/td][/tr]
[/table]

Thank you very much! I forgot to mention that the sub-10 average had to be between 8.99 and 10.00 seconds though. If you could do that one too, I'd really appreciate it.

 

[Lid]

Here ya go, notice how Faz lost all of his avgs.

Spoiler: List for 9.xy avgs

[table="class:grid"]
[tr][td]Competitor[/td][td="align:right"]times[/td][/tr]
[tr][td]Mats Valk[/td][td="align:right"]5[/td][/tr]
[tr][td]Rowe Hessler[/td][td="align:right"]5[/td][/tr]
[tr][td]Sebastian Weyer[/td][td="align:right"]5[/td][/tr]
[tr][td]Erik Akkersdijk[/td][td="align:right"]4[/td][/tr]
[tr][td]Michał Pleskowicz[/td][td="align:right"]4[/td][/tr]
[tr][td]Arifumi Fushimi (伏見有史)[/td][td="align:right"]3[/td][/tr]
[tr][td]Cornelius Dieckmann[/td][td="align:right"]3[/td][/tr]
[tr][td]Gabriel Dechichi Barbar[/td][td="align:right"]3[/td][/tr]
[tr][td]Kevin Costello III[/td][td="align:right"]3[/td][/tr]
[tr][td]Morten Arborg[/td][td="align:right"]3[/td][/tr]
[tr][td]Paolo Moriello[/td][td="align:right"]3[/td][/tr]
[tr][td]Sergey Ryabko[/td][td="align:right"]3[/td][/tr]
[tr][td]Andrew Ricci[/td][td="align:right"]2[/td][/tr]
[tr][td]Jules Desjardin[/td][td="align:right"]2[/td][/tr]
[tr][td]Kanneti Sae Han (คันธ์เนตี แซ่ห่าน)[/td][td="align:right"]2[/td][/tr]
[tr][td]Leon Schmidtchen[/td][td="align:right"]2[/td][/tr]
[tr][td]Lucas Etter[/td][td="align:right"]2[/td][/tr]
[tr][td]Mulun Yin (阴目仑)[/td][td="align:right"]2[/td][/tr]
[tr][td]Piti Pichedpan (ปิติ พิเชษฐพันธ์)[/td][td="align:right"]2[/td][/tr]
[tr][td]Richard Jay S. Apagar[/td][td="align:right"]2[/td][/tr]
[tr][td]Yu Nakajima (中島悠)[/td][td="align:right"]2[/td][/tr]
[tr][td]Yumu Tabuchi (田渕雄夢)[/td][td="align:right"]2[/td][/tr]
[tr][td]Bill Wang[/td][td="align:right"]1[/td][/tr]
[tr][td]Carlos Méndez García-Barroso[/td][td="align:right"]1[/td][/tr]
[tr][td]Dan Cohen[/td][td="align:right"]1[/td][/tr]
[tr][td]Daniil Lee[/td][td="align:right"]1[/td][/tr]
[tr][td]Eric Limeback[/td][td="align:right"]1[/td][/tr]
[tr][td]Giovanni Contardi[/td][td="align:right"]1[/td][/tr]
[tr][td]Haowei Fan (樊浩玮)[/td][td="align:right"]1[/td][/tr]
[tr][td]Ivan Vynnyk (Іван Винник)[/td][td="align:right"]1[/td][/tr]
[tr][td]Jakub Kipa[/td][td="align:right"]1[/td][/tr]
[tr][td]James Hamory[/td][td="align:right"]1[/td][/tr]
[tr][td]Jan Smarschevski[/td][td="align:right"]1[/td][/tr]
[tr][td]Jong-Ho Jeong (정종호)[/td][td="align:right"]1[/td][/tr]
[tr][td]Kevin Hays[/td][td="align:right"]1[/td][/tr]
[tr][td]Kirt Protacio[/td][td="align:right"]1[/td][/tr]
[tr][td]Marcin Zalewski[/td][td="align:right"]1[/td][/tr]
[tr][td]Philipp Weyer[/td][td="align:right"]1[/td][/tr]
[tr][td]Ravi Fernando[/td][td="align:right"]1[/td][/tr]
[tr][td]Riley Woo[/td][td="align:right"]1[/td][/tr]
[tr][td]Seyyed Mohammad Hossein Fatemi (سید محمد حسین فاطمی)[/td][td="align:right"]1[/td][/tr]
[tr][td]Vincent Hartanto Utomo[/td][td="align:right"]1[/td][/tr]
[tr][td]Alexander Lau[/td][td="align:right"][/td][/tr]
[tr][td]Breandan Vallance[/td][td="align:right"][/td][/tr]
[tr][td]Feliks Zemdegs[/td][td="align:right"][/td][/tr]
[tr][td]Robert Yau[/td][td="align:right"][/td][/tr]
[tr][td]Thanaporn Sichanugrist (ธนพร สิชฌนุกฤษฎ์)[/td][td="align:right"][/td][/tr]
[/table]

 

[Sajwo]

longest sub10/sub9/sub8/sub7 3x3 streak?

 

[kcl]

Fastest official 2x2 average with no sub 3 single? I suspect I have it.

 

[kinch2002]

Fastest official 2x2 average with no sub 3 single? I suspect I have it.

Sorry, but you don't. Close though!

Here are the winners for each second up to 10 (ignoring sub-1)
[table="width: 400, class: grid, align: left"]
[tr][td]Name[/td] [td]Country[/td] [td]Single[/td] [td]Average[/td][/tr]
[tr][td]SeungBeom Cho[/td] [td]Korea[/td] [td]2.02[/td] [td]2.21[/td][/tr]
[tr][td]Arvind Tatiparti[/td] [td]India[/td] [td]3.01[/td] [td]3.48[/td][/tr]
[tr][td]Jin Yang (杨晋)[/td] [td]China[/td] [td]4.19[/td] [td]4.47[/td][/tr]
[tr][td]Alexander Laiche[/td] [td]USA[/td] [td]5.13[/td] [td]5.26[/td][/tr]
[tr][td]Joshua Brown[/td] [td]USA[/td] [td]6.02[/td] [td]6.19[/td][/tr]
[tr][td]Muhammad Fahrul Saifullah[/td] [td]Indonesia[/td] [td]7.02[/td] [td]7.21[/td][/tr]
[tr][td]John Nowak[/td] [td]USA[/td] [td]8.15[/td] [td]8.29[/td][/tr]
[tr][td]Lê Trịnh Quốc Anh[/td] [td]Vietnam[/td] [td]9.00[/td] [td]9.53[/td][/tr]
[tr][td]Nobuhiro Kinjo (金城亘洋)[/td] [td]Japan[/td] [td]10.02[/td] [td]10.63[/td][/tr]
[/table]

 

[kcl]

Sorry, but you don't. Close though!

Here are the winners for each second up to 10 (ignoring sub-1)
[table="width: 400, class: grid, align: left"]
[tr][td]Name[/td][td]Country[/td][td]Single[/td][td]Average[/td][/tr]
[tr][td]SeungBeom Cho[/td][td]Korea[/td][td]2.02[/td][td]2.21[/td][/tr]
[tr][td]Arvind Tatiparti[/td][td]India[/td][td]3.01[/td][td]3.48[/td][/tr]
[tr][td]Jin Yang (杨晋)[/td][td]China[/td][td]4.19[/td][td]4.47[/td][/tr]
[tr][td]Alexander Laiche[/td][td]USA[/td][td]5.13[/td][td]5.26[/td][/tr]
[tr][td]Joshua Brown[/td][td]USA[/td][td]6.02[/td][td]6.19[/td][/tr]
[tr][td]Muhammad Fahrul Saifullah[/td][td]Indonesia[/td][td]7.02[/td][td]7.21[/td][/tr]
[tr][td]John Nowak[/td][td]USA[/td][td]8.15[/td][td]8.29[/td][/tr]
[tr][td]Lê Trịnh Quốc Anh[/td][td]Vietnam[/td][td]9.00[/td][td]9.53[/td][/tr]
[tr][td]Nobuhiro Kinjo (金城亘洋)[/td][td]Japan[/td][td]10.02[/td][td]10.63[/td][/tr]
[/table]

Ahhh, I figured Steve had fastest with no sub 2. The others I had no clue about lol.

 

[Mikel]

5x5 Blindfolded finally has a top 100!

It was at 99 people before this weekend, and is now 102!

Congratulations to the 3 people who pushed it past 100 with their achievements this weekend.

Callum Hales-Jepp 14:30.00
Evan Liu 26:46.00
Chung Tze Yang 34:40.00

https://www.worldcubeassociation.or...gionId=&years=&show=100+Persons&single=Single

 

[Stefan]

Congratulations to the 3 people who pushed it past 100 with their achievements this weekend.

Callum Hales-Jepp 14:30.00
Evan Liu 26:46.00
Chung Tze Yang 34:40.00

Screw these guys!

 

[vcuber13]

Why, because you are no longer in the top 100?