• Welcome to the Speedsolving.com, home of the web's largest puzzle community!
    You are currently viewing our forum as a guest which gives you limited access to join discussions and access our other features.

    Registration is fast, simple and absolutely free so please, join our community of 40,000+ people from around the world today!

    If you are already a member, simply login to hide this message and begin participating in the community!

Lid

Member
Joined
Jul 8, 2008
Messages
909
Location
Sweden
WCA
2008LIDS01
OK, error found, somehow it counted as one when there where both single & avg records. Data updated above!
Code:
225	2006BUUS01	Henrik Buus Aagaard (m), Denmark
202	2009ZEMD01	Feliks Zemdegs (m), Australia
190	2005AKKE01	Erik Akkersdijk (m), Netherlands
140	2005BATI01	Milán Baticz (m), Hungary
140	2010MOND01	Pablo Nicolás Oshiro Mondoñedo (m), Peru
135	2007COMP01	Emile Compion (m), South Africa
127	2008WEST02	Simon Westlund (m), Sweden
125	2008BARA01	Bence Barát (m), Hungary
124	2012BEAH01	Ciarán Beahan (m), Ireland
121	2011KUDA01	Nurym Kudaibergen (m), Kazakhstan
120	2004KRIG01	Gunnar Krig (m), Sweden
120	2010VYNN01	Ivan Vynnyk (Іван Винник) (m), Ukraine
117	2010OMUL02	Matic Omulec (m), Slovenia
116	2003VAND01	Lars Vandenbergh (m), Belgium
113	2009MAGN02	Hilmar Magnusson (m), Iceland
111	2012PATE01	Antonie Paterakis (m), Greece
102	2007GUIM01	Pedro Santos Guimarães (m), Brazil
101	2009BEAR01	Dene Beardsley (m), New Zealand
96	2009BALT02	Leandro Baltazar (m), Portugal
95	2009ROHR01	Michael Röhrer (m), Austria
93	2007VALL01	Breandan Vallance (m), United Kingdom
90	2007COHE01	Dan Cohen (m), USA
85	2012ADLO01	Aramayis Adloyan (Արամայիս Ադլոյան) (m), Armenia
84	2003POCH01	Stefan Pochmann (m), Germany
84	2010ARBO01	Morten Arborg (m), Norway
84	2011BENZ01	Boriss Benzerruki (m), Latvia
84	2013CONT01	Oscar Alberto Ceballos Contreras (m), Venezuela
83	2005VANH01	Anssi Vanhala (m), Finland
82	2006HALC01	Michał Halczuk (m), Poland
82	2006ORLA01	Bernett Orlando (m), India
81	2006ZAHR01	Martin Zahradník (m), Czech Republic
81	2010KOHL02	Erwan Kohler (m), Switzerland
80	2009KIMA01	Anatoly Kim (m), Belarus
79	2008HANK01	Kanneti Sae Han (คันธ์เนตี แซ่ห่าน) (m), France
78	2006GARR01	Lucas Garron (m), Germany
77	2008SEAR01	Anthony Brooks (m), USA
76	2008NUNE01	Gabriel Eduardo Núñez Serna (m), Argentina
75	2007HUBE01	Stefan Huber (m), Austria
74	2009BAUM01	Conor Baumann (m), Ireland
74	2009XIAN01	Teo Kai Xiang (m), Singapore
73	2009KRUU01	Uku Kruusamägi (m), Estonia
72	2003HARR01	Dan Harris (m), United Kingdom
72	2009CONT01	Giovanni Contardi (m), Italy
72	2010GREG01	Jure Gregorc (m), Slovenia
71	2009YAUR01	Robert Yau (m), United Kingdom

Own note "poor" Feliks only have 6 NRs, but 196 OcR+WR.
 

Stefan

Member
Joined
May 7, 2006
Messages
7,280
WCA
2003POCH01
YouTube
Visit Channel
£1.00. But actually can I take back that bet? Something tells me I'm wrong :p

Using data from WCA_export451_20140827 and Stefan's WCA statistics tool.

CompetitionEventThe Ladies
Swedish Open 20063x3 multi blind oldMimmi Leckius
Utah Fall 20094x4 blindfoldedShelley Chang
Berkeley Spring 20124x4 blindfoldedShelley Chang
Dual Games 20133x3 with feetCristina Orenes Conesa
Viking Summer 20144x4 blindfoldedMimmi Leckius
Ural Open 20144x4 blindfoldedLiliya Kamaltdinova, Yulia Kamaltdinova

SELECT Competitions.cellName Competition, Events.cellName Event, group_concat(Persons.name order by pos separator ', ') 'The Ladies'
FROM Results join Persons on Persons.id = personId join Competitions on Competitions.id = competitionId join Events on Events.id = eventId
WHERE roundId in ('f', 'c') and pos <= 3 and best > 0
GROUP BY competitionId, eventId
HAVING group_concat(distinct gender) = 'f'
ORDER BY year, month, day
 

Stefan

Member
Joined
May 7, 2006
Messages
7,280
WCA
2003POCH01
YouTube
Visit Channel
Consistently around 2/3 are DNFs, but at least we've also consistently been getting faster.

Using data from WCA_export451_20140827 and Stefan's WCA forum statistics tool.

YearAttemptsDNFsAverageBestWorst
2003333.33%315.50236.00395.00
20045868.97%536.35190.542100.00
200524561.22%363.52106.471198.00
200665164.52%296.0888.821114.00
2007137268.37%255.4770.27904.00
2008354769.19%224.1448.05914.00
2009500870.35%217.2335.96921.00
2010713070.21%207.8330.901204.00
2011912568.68%197.3730.58967.00
2012967767.29%195.5726.361538.00
20131266865.80%177.0023.801589.00
20141044165.21%168.5923.191141.00

SELECT
year Year,
solves+DNFs Attempts,
concat(round(100*DNFs/(solves+DNFs), 2), '%') DNFs,
round(total/solves/100, 2) Average,
round(best/100, 2) Best,
round(worst/100, 2) Worst
FROM
(SELECT
year,
sum((value1>0)+(value2>0)+(value3>0)+(value4>0)+(value5>0)) solves,
sum((value1=-1)+(value2=-1)+(value3=-1)+(value4=-1)+(value5=-1)) DNFs,
sum(if(value1>0,value1,0)+if(value2>0,value2,0)+if(value3>0,value3,0)+if(value4>0,value4,0)+if(value5>0,value5,0)) total,
min(least(if(value1>0,value1,999999),if(value2>0,value2,999999),if(value3>0,value3,999999),if(value4>0,value4,999999),if(value5>0,value5,999999))) best,
max(greatest(value1,value2,value3,value4,value5)) worst
FROM Results JOIN Competitions ON Competitions.id = competitionId
WHERE eventId = '333bf'
GROUP BY year) tmp
ORDER BY year;
 
Last edited:

Tim Reynolds

Premium Member
Joined
Jun 28, 2006
Messages
995
Location
Boston, MA
WCA
2005REYN01
YouTube
Visit Channel
Most consecutive competitions, starting with your first competition, with at least 1 personal best:

Mats Valk 47
Sébastien Auroux 42
Tim Reynolds 41
Milan Baticz 39
Bence Barat 39
Jan Bentlage 38
Wojciech Szatanowski 38
Mike Hughey 38
Gael Dusser 38
Thompson Clarke 37 (ongoing)
Geert Bicler 37
Evan Liu 36 (ongoing)
Kevin Costello III 36 (ongoing)
Daniel Sheppard 36
Christopher Olson 35 (ongoing)
Michael Röhrer 34
Kit Clement 34 (ongoing)
 
Joined
Sep 8, 2008
Messages
1,786
Location
Emmaus, PA
WCA
2010KOTC01
YouTube
Visit Channel
Most consecutive competitions, starting with your first competition, with at least 1 personal best:

Mats Valk 47
Sébastien Auroux 42
Tim Reynolds 41
Milan Baticz 39
Bence Barat 39
Jan Bentlage 38
Wojciech Szatanowski 38
Mike Hughey 38
Gael Dusser 38
Thompson Clarke 37 (ongoing)
Geert Bicler 37
Evan Liu 36 (ongoing)
Kevin Costello III 36 (ongoing)
Daniel Sheppard 36
Christopher Olson 35 (ongoing)
Michael Röhrer 34
Kit Clement 34 (ongoing)

Argh, missed the list by 1 with my streak ending at Worlds, a comp with every event. No practice ftw.
 

Sebastien

Premium Member
Joined
Apr 22, 2008
Messages
800
WCA
2008AURO01
Most consecutive competitions, starting with your first competition, with at least 1 personal best:

Mats Valk 47
Sébastien Auroux 42
Tim Reynolds 41
Milan Baticz 39
Bence Barat 39
Jan Bentlage 38
Wojciech Szatanowski 38
Mike Hughey 38
Gael Dusser 38
Thompson Clarke 37 (ongoing)
Geert Bicler 37
Evan Liu 36 (ongoing)
Kevin Costello III 36 (ongoing)
Daniel Sheppard 36
Christopher Olson 35 (ongoing)
Michael Röhrer 34
Kit Clement 34 (ongoing)

wait....WHAT?! I have never searched for such a streak myself but I have always been under the impression that I only set competition PBs quite rarely. If you had asked me about the longest streak for me, I would have estimated something like 5. :D

Could you share the code you used to generate that list? And could you possibly include first and last competition of thoses streaks?
 

kinch2002

Premium Member
Joined
Dec 22, 2008
Messages
2,504
Location
Guildford! UK!
WCA
2009SHEP01
YouTube
Visit Channel
Has anyone gotten a success on there 1st 3BLD attempt?
This is probably quite common. People often do a super safe solve on their first official attempt. Myself included
I'd be interested to see what the success rate on first attempt is like though, compared to overall success rate (Stefan already did this a few posts back).
4bld and 5bld too
 

SolveThatCube

Member
Joined
Jan 4, 2014
Messages
1,223
WCA
2014ADCO01
YouTube
Visit Channel
This is probably quite common. People often do a super safe solve on their first official attempt. Myself included
I'd be interested to see what the success rate on first attempt is like though, compared to overall success rate (Stefan already did this a few posts back).
4bld and 5bld too

I meant their first EVER attempt.
 

Tim Reynolds

Premium Member
Joined
Jun 28, 2006
Messages
995
Location
Boston, MA
WCA
2005REYN01
YouTube
Visit Channel
wait....WHAT?! I have never searched for such a streak myself but I have always been under the impression that I only set competition PBs quite rarely. If you had asked me about the longest streak for me, I would have estimated something like 5. :D

Could you share the code you used to generate that list? And could you possibly include first and last competition of thoses streaks?

One note about this stat is that it includes the first time you compete in an event. You got personal bests at your first 42 competitions. An example from each one:
GermanOpen2008 222 single 986
DutchMasters2008 222 single 552
DutchOpen2008 222 single 440
Germany2008 333 single 2141
GenevaOpen2008 333bf single 14547
Netherlands2008 333 single 2090
TheHagueOpen2008 333 single 2066
AachenOpen2009 333 single 2006
BeneluxOpen2009 333 single 1872
FrenchOpen2009 222 average 684
GermanOpen2009 333 single 1788
WC2009 333 single 1693
DutchOpen2009 333 single 1397
Germany2009 222 single 436
AachenOpen2010 333bf single 13333
ToulouseOpen2010 222 average 606
BeneluxOpen2010 333 average 1492
DanishOpen2010 222 single 419
MontpellierOpen2010 222 single 391
BristolSpring2010 333bf single 11822
GermanOpen2010 444bf single 87200
BelgianOpen2010 333bf single 11403
CologneOpen2010 555 average 11443
AlaniaOpen2010 444 average 6285
DusseldorfOpen2010 clock single 981
AustrianOpen2010 333fm single 27
EastGermanOpen2010 222 single 328
LemgoOpen2010 333bf single 11197
Germany2010 333oh average 2577
MunichOpen2010 555 average 11351
DutchOpen2010 333bf single 10333
VCUBESpiel2010 555 average 11192
DutchNationals2010 222 average 543
MPEIOpen2010 555 single 9821
AachenOpen2011 333oh single 1878
Altbier2011 222 single 291
FrenchOpen2011 333 average 1371
NemoAmsterdamOpen2011 444 single 5408
GermanOpen2011 555 average 11002
DanishOpen2011 333bf single 10086
HamburgOpen2011 222 average 451
BelgianOpen2011 magic single 100
AlaniaOpen2011 333oh average 2556
SchleswigHolstein2011 333oh average 2404
CzechOpen2011 333ft single 10205
DusseldorfOpen2011 333bf average 12302
DanishSpecial2011 333ft single 9430
AmstelveenOpen2011 222 single 272
WC2011 clock average 1135
 
Top