FIFA Ranking, UEFA national team coefficients, various seeding info
Immediately picked it up :)Only had Bosnia's results thus far, thanks to Ed, now Jeroen gives us the lot conveniently in one file, Thanks man!
Jeroen,some remarks: the way you determine the dates for each time frame in your sheet is not completely correct.The dates for each time frame are (as an example for the July 2013 ranking with publishing date thursday 4-7-2013 and deadline date sunday 30-6-2013):1: matches played between 30-6-2013 and 4-7-2012 (including)2: matches played between 3-7-2012 and 4-7-2011 (including)3: matches played between 3-7-2011 and 4-7-2010 (including)4: matches played between 3-7-2010 and 4-7-2009 (including)And then there are some other anomalies about which ranking to use to determine the opponents strength. Sometimes matches played on the same day use different rankings in the FIFA calculation. Most recent example of this phenomenon are the matches for the WCQ OFC stage 2 (early June 2012) that are calculated with the June 2012 ranking while other matches played on the same day are calculated with the May 2012 ranking.These issues cause differences for ca. 90 countries between your results and the official July ranking, sometimes as much as 211 pts (Bahamas, you calculate 264 points, they had 53 in the July ranking). Other examples include Afghanistan, St. Kitts and of the top 60 for instance Libya, Cape Verde, France and Norway.So be careful to spread this sheet around, it is not flawless and can not be a reliable source without some major improvements.
Jeroen, you are also not applying the rule about a minimum of 5 matches per time frame. The average points per time frame are determined as the sum of match points for all matches played in the time frame divided by the number of matches played in the time frame EXCEPT when this number is less than 5. Then a minimum of 5 matches is used as the denominator.
Jeroen and others who are interested,here is an excel-sheet (3.7 MB) with a breakdown of detailed match points for all countries in the FIFA ranking. And that for all rankings from September 2011 until now.Each time frame average of each country is checked against the FIFA-site with two decimals accuracy.http://www.filedropper.com/breakdownfifaranking11091307
I tried to calculate the points for the last 4 years, and I got all points correct for the years 2-4, but there are still 3 countries with wrong points in year 1 (last year), and unfortunately I can't load your file, so maybe you could help me out here?MalaysiaQatar_06/02/2013 -> Points=0Yemen_22/03/2013 -> Points=322,5China PR_10/09/2013 -> Points=0Bahrain_15/10/2013 -> Points=169,85Kuwait_08/11/2013 -> Points=0Bahrain_15/11/2013 -> Points=0Qatar_19/11/2013 -> Points=0Palestine_26/03/2013 -> Points=0-> 492,35 / 8 = 61,544 Pts, but it should be 70,34PalestineIndia_06/02/2013 -> Points=129Bangladesh_02/03/2013 -> Points=322,5Nepal_06/03/2013 -> Points=107,5Kuwait_21/03/2013 -> Points=0Qatar_17/04/2013 -> Points=0Qatar_25/12/2013 -> Points=0Malaysia_26/03/2013 -> Points=129-> 688 / 7 = 98,286 Pts, but it should be 93,17BotswanaZimbabwe_06/02/2013 -> Points=0Malawi_19/03/2013 -> Points=234,78Ethiopia_24/03/2013 -> Points=0Ethiopia_08/06/2013 -> Points=677,25Central African Republic_15/06/2013 -> Points=909,45Swaziland_07/07/2013 -> Points=43Lesotho_09/07/2013 -> Points=43Kenya_11/07/2013 -> Points=198,66Zambia_27/07/2013 -> Points=120,4Zambia_03/08/2013 -> Points=0Uganda_31/08/2013 -> Points=0South Africa_07/09/2013 -> Points=0Burkina Faso_30/09/2013 -> Points=384,42Malawi_03/09/2013 -> Points=201,24-> 2812,2 / 14 = 200,871 Pts, but it should be 200,45
Malaysia: the match against Palestine should be excluded.Palestine: the match against Malaysia should be excluded.Botswana: the match against Malawi on 3/9/13 should be excluded. Furthermore the other Malawi-match (19/3/13) delivered 229.62 match points: 3 * 1 * 89 * 0.86 (M * I * T * C).
hey, i knew i was only starting ;). There are some other errors which i was trying to look for (like the SAF's problem in the Italy ranking). But as for now i'm just enjoying the Dutch Maas region on holiday :)). Edgar asked (while being on a roadtrip) if he could post my excel, i don't think he checked it for 100% accuracy). To be honest the 5 games per year rule, i don't care for, since i'm only trying to calculate Belgian's ranking and their opponents :). If someone wants to improve my excel-file for general use, be free to do it :).
Ok Jeroen,I understand the purpose of your sheet better now. It's clearly not meant as a 'full-blooded' ranking sheet.Sorry if I sounded a bit harsh.Enjoy your holiday !
i've adapted the excel-file in order to be a complete FIFA-ranking calculation table. There are still some errors, but they are minor and most of them will in fact be rules broken by FIFA. 23 countries still have a different fifa-ranking, most of them just by 1 point margin. I'm currently checking those (most of them will be due to different opponent's strength used by FIFA), but it takes some time to figure out :). If anyone want to see/adapt the new file, i can share the table on dropbox (send me a mess-age via "fifaranking+telenet.be" (+ should be changed by @)) and i'll gladly share.
what is the current top 10 according to your calculation
This is the September release with all matches until then canceled:Spain - 1530Argentina - 1223Germany - 1211Colombia - 1167Italy - 1124Belgium - 1092Netherlands - 1092Croatia - 1086Brazil - 1080Portugal - 1037
Thanks Ryan and Jeroen!