There have been some discussions about the distribution of times in the WCA database earlier. After I had a 7.42 Clock Single at Duisburg Winter this weekend I noticed that there is some kind of sequence in my overall Clock Single results from 7.42 to 7.46.
So, here is the stats request: what is the largest sequence like this someone has done in an event?
And, a further question: are there any statistics on the distribution of times with gen-3 Stackmat timers? Are there maybe even noticeable changes in the distribution since they are used in competitions?
And, a further question: are there any statistics on the distribution of times with gen-3 Stackmat timers? Are there maybe even noticeable changes in the distribution since they are used in competitions?
Yes, looks like the "[post=372945]gap times[/post]" are getting closer to 40% again (yeah I should really learn how to do graphics):
How to read for example this line: 2012-07 259 31761 0.8
In July 2012 there were 31806 time results under ten minutes, 259 of them with centiseconds mod 25 being 1,4,7,10,12,14,17,20,23 or 24, the ones the second generation stackmat apparently couldn't get. That's 0.8%, but it should be about 40%.
SELECT month, gap_times, all_times, round(gap_times/all_times*100,1) percentage FROM(
SELECT concat(year,'-',lpad(month,2,'0')) AS month, sum(
(value1>0 and value1<60000 and mod(value1,25)in(1,4,7,10,12,14,17,20,23,24)) +
(value2>0 and value2<60000 and mod(value2,25)in(1,4,7,10,12,14,17,20,23,24)) +
(value3>0 and value3<60000 and mod(value3,25)in(1,4,7,10,12,14,17,20,23,24)) +
(value4>0 and value4<60000 and mod(value4,25)in(1,4,7,10,12,14,17,20,23,24)) +
(value5>0 and value5<60000 and mod(value5,25)in(1,4,7,10,12,14,17,20,23,24))
) gap_times,
sum((value1>0 and value1<60000)+(value2>0 and value2<60000)+(value3>0 and value3<60000)+(value4>0 and value4<60000)+(value5>0 and value5<60000)) all_times
FROM Results, Competitions, Events
WHERE Competitions.id = competitionId AND Events.id = eventId
AND Events.format = 'time'
GROUP BY year, month) tmp
ORDER BY month;
SELECT competitionId, gap_times, all_times, round(gap_times/all_times*100,3) percentage FROM(
SELECT competitionId, sum(
(value1>0 and value1<60000 and mod(value1,25)in(1,4,7,10,12,14,17,20,23,24)) +
(value2>0 and value2<60000 and mod(value2,25)in(1,4,7,10,12,14,17,20,23,24)) +
(value3>0 and value3<60000 and mod(value3,25)in(1,4,7,10,12,14,17,20,23,24)) +
(value4>0 and value4<60000 and mod(value4,25)in(1,4,7,10,12,14,17,20,23,24)) +
(value5>0 and value5<60000 and mod(value5,25)in(1,4,7,10,12,14,17,20,23,24))
) gap_times,
sum((value1>0 and value1<60000)+(value2>0 and value2<60000)+(value3>0 and value3<60000)+(value4>0 and value4<60000)+(value5>0 and value5<60000)) all_times
FROM Results, Events
WHERE competitionId rlike '^WC[0-9]{4}$'
AND Events.id = eventId AND Events.format = 'time'
GROUP BY competitionId) tmp
ORDER BY competitionId;
The following table shows the 3x3 single times from competitors that were (at that time) closest to the world record without breaking it. Sorted by percentage of time difference.
The following table shows the 3x3 single times from competitors that were (at that time) closest to the world record without breaking it. Sorted by percentage of time difference.
The following table shows the 3x3 single times from competitors that were (at that time) closest to the world record without breaking it. Sorted by percentage of time difference.
2x2 Single
0.96 Vincent Sheu
0.96 Rowe Hessler
0.96 Erik Akkersdijk
3.55 Mátyás Kuti Hungary
3.55 Anthony Hsu
3x3 Fewest Moves Single
22 István Kocza
22 Jimmy Coll
28 Zbigniew Zborowski
28 Mirek Goljan
3x3 Fewest Moves Average
30.67 Tomoaki Okayama (岡山友昭)
30.67 Kanneti Sae Han (คันธ์เนตี แซ่ห่าน)
Rubik's Magic Single
0.72 Yuxuan Wang (王宇轩)
0.72 Yuxuan Wang (王宇轩)
0.72 Yuxuan Wang (王宇轩)
0.77 Oskar Åsbrink
0.77 Tang Yiu Chun (鄧耀俊)
0.83 Yuxuan Wang (王宇轩)
0.83 Patrick Jameson
0.86 Mátyás Kuti Hungary
0.86 Mátyás Kuti
Rubik's Magic Average
0.80 Yuxuan Wang (王宇轩)
0.80 Yuxuan Wang (王宇轩)
0.90 Patrick Jameson
0.90 Tang Yiu Chun (鄧耀俊)
1.40 Milán Baticz
1.40 Bob Burton
Rubik's Master Magic Single
1.71 Ernie Pulchny
1.71 Yuxuan Wang (王宇轩)
