I have been thinking about a "current rankings" system recently.
Average of official averages would be a decent and simple starting point, but maybe we can do better.
Some random thoughts:
- I like the idea of a system that would be as close to a predictor as possible. This means if everyone competed, what would the predicted finishing order be?
- How should very bad averages (e.g. DNF or in mo3 events you can easily get stupidly bad averages) be penalised?
- Using the last year means that you get a fair amount of "lag" in the results. i.e. hard to get to the top until you've been good for a year. Unless you only started competing when you were really good. This means people who compete while still improving are still being penalised once they get really good.
- Maybe use a linear weighting system going backwards in time (idea stolen from golf), because recent results are more indicative. But would this work well when everyone competes different amounts and often not for several months?
Lots more thinking to be done.
But average of averages could be a good basic thing to start with.
I think just using the "best average in the last 12 months" could work, and it wouldn't be complicated.
Would be kinda the WL (World Leading) they have in track and field, but we would be using "current year" as in the competitions list.
EDIT
Here's the query for what I meant:
Code:
SELECT Persons.id, Persons.name, min(Results.average) as best
FROM Results
JOIN Persons ON Persons.id = personId
JOIN Competitions ON Competitions.id = competitionId
WHERE eventId = '333'
AND average > 0
AND datediff(DATE(now()), concat(Competitions.YEAR,'-',LPAD(Competitions.endmonth,2,'00'),'-',LPAD(Competitions.endday,2,'00'))) < 365
GROUP BY personId
ORDER BY best
There is some interesting stuff on this list. 14737 out of the 16259 who competed in 3x3 in the past 12 months have set a new PB! That's 90,64%.
Feliks is the only one in the top-30 current ranks who didn't set a PB, and the top-20 except for him are all from the past 12 months:
[TABLE="class:grid,align:left"]
[TR][TD]Cur rank[/TD][TD]Id[/TD][TD]Name[/TD][TD]Cur time[/TD][TD]All time[/TD][TD]Difference[/TD][TD]Time ratio[/TD][/TR]
[TR][TD]1[/TD][TD]2009ZEMD01[/TD][TD]Feliks Zemdegs[/TD][TD]665[/TD][TD]1[/TD][TD]0[/TD][TD]1,016819572[/TD][/TR]
[TR][TD]2[/TD][TD]2011ETTE01[/TD][TD]Lucas Etter[/TD][TD]713[/TD][TD]2[/TD][TD]0[/TD][TD]1[/TD][/TR]
[TR][TD]3[/TD][TD]2011LAUA01[/TD][TD]Alexander Lau[/TD][TD]737[/TD][TD]3[/TD][TD]0[/TD][TD]1[/TD][/TR]
[TR][TD]4[/TD][TD]2007VALK01[/TD][TD]Mats Valk[/TD][TD]745[/TD][TD]4[/TD][TD]0[/TD][TD]1[/TD][/TR]
[TR][TD]5[/TD][TD]2010WANG68[/TD][TD]Bill Wang[/TD][TD]750[/TD][TD]5[/TD][TD]0[/TD][TD]1[/TD][/TR]
[TR][TD]6[/TD][TD]2009DIEC01[/TD][TD]Cornelius Dieckmann[/TD][TD]753[/TD][TD]6[/TD][TD]0[/TD][TD]1[/TD][/TR]
[TR][TD]7[/TD][TD]2011SANC02[/TD][TD]Dario Roa Sánchez[/TD][TD]756[/TD][TD]7[/TD][TD]0[/TD][TD]1[/TD][/TR]
[TR][TD]8[/TD][TD]2010WEYE01[/TD][TD]Philipp Weyer[/TD][TD]757[/TD][TD]8[/TD][TD]0[/TD][TD]1[/TD][/TR]
[TR][TD]9[/TD][TD]2012COST01[/TD][TD]Kevin Costello III[/TD][TD]769[/TD][TD]9[/TD][TD]0[/TD][TD]1[/TD][/TR]
[TR][TD]10[/TD][TD]2010BRAD01[/TD][TD]Drew Brads[/TD][TD]773[/TD][TD]10[/TD][TD]0[/TD][TD]1[/TD][/TR]
[TR][TD]11[/TD][TD]2009FANH01[/TD][TD]Haowei Fan (樊浩玮)[/TD][TD]785[/TD][TD]11[/TD][TD]0[/TD][TD]1[/TD][/TR]
[TR][TD]12[/TD][TD]2013KYOU01[/TD][TD]Hyeon Kyo Kyoung[/TD][TD]788[/TD][TD]12[/TD][TD]0[/TD][TD]1[/TD][/TR]
[TR][TD]13[/TD][TD]2010WEYE02[/TD][TD]Sebastian Weyer[/TD][TD]791[/TD][TD]13[/TD][TD]0[/TD][TD]1[/TD][/TR]
[TR][TD]14[/TD][TD]2011DOBR01[/TD][TD]Dmitry Dobrjakov[/TD][TD]791[/TD][TD]14[/TD][TD]0[/TD][TD]1[/TD][/TR]
[TR][TD]15[/TD][TD]2013NAHM01[/TD][TD]Seung Hyuk Nahm (남승혁)[/TD][TD]798[/TD][TD]15[/TD][TD]0[/TD][TD]1[/TD][/TR]
[TR][TD]16[/TD][TD]2008SEAR01[/TD][TD]Anthony Brooks[/TD][TD]798[/TD][TD]16[/TD][TD]0[/TD][TD]1[/TD][/TR]
[TR][TD]17[/TD][TD]2010CANT02[/TD][TD]Antoine Cantin[/TD][TD]798[/TD][TD]17[/TD][TD]0[/TD][TD]1[/TD][/TR]
[TR][TD]18[/TD][TD]2012PONC02[/TD][TD]Patrick Ponce[/TD][TD]803[/TD][TD]18[/TD][TD]0[/TD][TD]1[/TD][/TR]
[TR][TD]19[/TD][TD]2009PLES01[/TD][TD]Michał Pleskowicz[/TD][TD]804[/TD][TD]19[/TD][TD]0[/TD][TD]1[/TD][/TR]
[TR][TD]20[/TD][TD]2010BURN01[/TD][TD]Collin Burns[/TD][TD]806[/TD][TD]20[/TD][TD]0[/TD][TD]1[/TD][/TR]
[TR][TD]21[/TD][TD]2010APAG01[/TD][TD]Richard Jay S. Apagar[/TD][TD]809[/TD][TD]21[/TD][TD]0[/TD][TD]1[/TD][/TR]
[TR][TD]22[/TD][TD]2012ELLI01[/TD][TD]Keaton Ellis[/TD][TD]822[/TD][TD]23[/TD][TD]-1[/TD][TD]1[/TD][/TR]
[TR][TD]23[/TD][TD]2010WANG53[/TD][TD]Jiayu Wang (王佳宇)[/TD][TD]823[/TD][TD]24[/TD][TD]-1[/TD][TD]1[/TD][/TR]
[TR][TD]24[/TD][TD]2012KALE01[/TD][TD]Przemysław Kaleta[/TD][TD]824[/TD][TD]25[/TD][TD]-1[/TD][TD]1[/TD][/TR]
[TR][TD]25[/TD][TD]2013LEJE03[/TD][TD]Kennan LeJeune[/TD][TD]824[/TD][TD]26[/TD][TD]-1[/TD][TD]1[/TD][/TR]
[TR][TD]26[/TD][TD]2008JONG03[/TD][TD]Jong-Ho Jeong (정종호)[/TD][TD]827[/TD][TD]29[/TD][TD]-3[/TD][TD]1[/TD][/TR]
[TR][TD]27[/TD][TD]2013SEOH01[/TD][TD]Hyo-Min Seo[/TD][TD]829[/TD][TD]30[/TD][TD]-3[/TD][TD]1[/TD][/TR]
[TR][TD]28[/TD][TD]2010WUIF01[/TD][TD]Yi-Fan Wu (吳亦凡)[/TD][TD]830[/TD][TD]31[/TD][TD]-3[/TD][TD]1[/TD][/TR]
[TR][TD]29[/TD][TD]2011LINA01[/TD][TD]Anson Lin[/TD][TD]834[/TD][TD]33[/TD][TD]-4[/TD][TD]1[/TD][/TR]
[TR][TD]30[/TD][TD]2010RICC02[/TD][TD]Andrew Ricci[/TD][TD]835[/TD][TD]34[/TD][TD]-4[/TD][TD]1[/TD][/TR]
[/TABLE]
