From a5ac24b43e60bfc2ab4ad60be6cd5e5cdd77a0f4 Mon Sep 17 00:00:00 2001 From: emkael Date: Thu, 6 Nov 2014 00:15:00 +0100 Subject: * todo list --- doc/ideas.txt | 11 +++++++++-- 1 file changed, 9 insertions(+), 2 deletions(-) (limited to 'doc') 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 -- cgit v1.2.3