diff options
| author | emkael <emkael@tlen.pl> | 2014-11-06 00:15:00 +0100 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2014-11-06 00:15:00 +0100 |
| commit | a5ac24b43e60bfc2ab4ad60be6cd5e5cdd77a0f4 (patch) | |
| tree | 04f3fa8b1c7435254e3e0efee98888e98ea8b1c8 | |
| parent | d4f8f432aa22eaa61261af63e772a49487ff0534 (diff) | |
* todo list
| -rw-r--r-- | doc/ideas.txt | 11 |
1 files changed, 9 insertions, 2 deletions
diff --git a/doc/ideas.txt b/doc/ideas.txt index 1476ff6..f11e8b2 100644 --- a/doc/ideas.txt +++ b/doc/ideas.txt @@ -1,9 +1,16 @@ +Tables: + - all-time peak ratings + - top exit ratings (date < 2014) + - peak rating progression Charts: - rolling average and deviation of rankings - average ranking at the beginning of each championship season + - peak season ranking (MAX, MIN, AVG, STDDEV GROUP BY YEAR(date)) + - top 5 of every season (on average) by decade Calculation: - modifying disparity by time of year (or by ranking deviation from last 3-4 months) TODO: - - detect grid penalties (ergast.races.grid != eragst.qualifying.position || non-ergast.qualifying.position != ergast.races.grid) - - detect multi-heat races on chicanef1 + - detect grid penalties (ergast.races.grid != eragst.qualifying.position) -> ergast-qualifying.csv + - non-ergast.qualifying.position != ergast.races.grid (chicane-results.csv -> temp db -> chicane-results.csv) + - detect multi-heat (NC) races on chicanef1 |