^^^Ignore this, the file was too big^^^
Quote:
Originally Posted by p45cal
I realise that, the question is, how to handle it?
|
Yes, Is it possible to use dates? It would produce a much more valid and accurate data; but I imagine the current formula will still leave out teams if dates are used. It will rank teams 1-4 when 4 teams play on a certain date for example.
I also plan to calculate positions in international football. In International football a lot of times groups are made up of odd number of teams meaning one team will sit out every matchday. This formula would fail to recognise that there also.
Find the spreadsheet below. I basically copy-paste results of weeks from 'Data' onto A30 : D39 on 'Standings'. The results will then be copy-pasted to 'MinedData'
The table on 'Standings' would take date of 1st match of the week and calculate point totals, goal diffs and all of that for every team before that date and adjust rankings.
When there are PPD matches I do them separately. They usually stick out since they're played in midweek (Tue, Wed, Thu).
It usually takes 20-30 mins to calculate a regular season's whole data and a whole lot more for other competitions such as World Cup/Champions League etc....