tag:blogger.com,1999:blog-1631997616728141521.post2958927221336009234..comments2024-03-28T17:34:31.597+01:00Comments on Football rankings: FIFA Ranking: Excel file with FIFA points since March 2009Edhttp://www.blogger.com/profile/06640136267487836463noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-1631997616728141521.post-30368136872442803412015-04-02T11:00:50.878+02:002015-04-02T11:00:50.878+02:00Ed and Jeroen, it seems that your files are (under...Ed and Jeroen, it seems that your files are (understandably) no longer uploaded. Would you be so kind to upload them again if it's not too much trouble? nogomethttps://www.blogger.com/profile/05823873287034305449noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-40288463281870894962014-03-07T12:18:57.253+01:002014-03-07T12:18:57.253+01:00Thanks Ed!Thanks Ed!Edgarhttps://www.blogger.com/profile/03420252819752301980noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-59686801550589777572014-02-14T13:47:11.596+01:002014-02-14T13:47:11.596+01:00Malaysia: the match against Palestine should be ex...Malaysia: the match against Palestine should be excluded.<br /><br />Palestine: the match against Malaysia should be excluded.<br /><br />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).Edhttps://www.blogger.com/profile/06640136267487836463noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-69258301580425552202014-02-08T23:57:12.560+01:002014-02-08T23:57:12.560+01:00I tried to calculate the points for the last 4 yea...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?<br /><br />Malaysia<br /><br />Qatar_06/02/2013 -> Points=0<br />Yemen_22/03/2013 -> Points=322,5<br />China PR_10/09/2013 -> PointsAnonymoushttps://www.blogger.com/profile/17700194892648382717noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-19941698256033859172013-08-23T09:39:39.093+02:002013-08-23T09:39:39.093+02:00Thanks Ryan and Jeroen!Thanks Ryan and Jeroen!Edgarhttps://www.blogger.com/profile/03420252819752301980noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-7576992756472154522013-08-15T19:49:44.512+02:002013-08-15T19:49:44.512+02:00This is the September release with all matches unt...This is the September release with all matches until then canceled:<br />Spain - 1530<br />Argentina - 1223<br />Germany - 1211<br />Colombia - 1167<br />Italy - 1124<br />Belgium - 1092<br />Netherlands - 1092<br />Croatia - 1086<br />Brazil - 1080<br />Portugal - 1037Ryanhttps://www.blogger.com/profile/03524206222936844199noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-10162103867948181502013-08-15T13:38:20.576+02:002013-08-15T13:38:20.576+02:00what is the current top 10 according to your calcu...what is the current top 10 according to your calculationAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-49277885638817127512013-08-14T09:25:12.929+02:002013-08-14T09:25:12.929+02:00i've adapted the excel-file in order to be a c...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 Jeroenhttps://www.blogger.com/profile/08288240548153401070noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-36533340756051508882013-07-17T13:44:00.508+02:002013-07-17T13:44:00.508+02:00Ok Jeroen,
I understand the purpose of your sheet...Ok Jeroen,<br /><br />I understand the purpose of your sheet better now. It's clearly not meant as a 'full-blooded' ranking sheet.<br />Sorry if I sounded a bit harsh.<br /><br />Enjoy your holiday !Edhttps://www.blogger.com/profile/06640136267487836463noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-42428898158205140372013-07-17T12:46:02.982+02:002013-07-17T12:46:02.982+02:00hey, i knew i was only starting ;). There are some...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 :)). <br /><br />Edgar asked (while being on a roadtrip) if he could post my excel, i don't think he checked it for 100% accuracy). <br /><br />To be honest the 5 games per year Jeroenhttps://www.blogger.com/profile/08288240548153401070noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-79117704973382329362013-07-16T14:14:07.158+02:002013-07-16T14:14:07.158+02:00Jeroen, you are also not applying the rule about a...Jeroen, you are also not applying the rule about a minimum of 5 matches per time frame. <br />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.Edhttps://www.blogger.com/profile/06640136267487836463noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-37874888031737204432013-07-16T12:54:48.834+02:002013-07-16T12:54:48.834+02:00Jeroen,
some remarks: the way you determine the d...Jeroen,<br /><br />some remarks: the way you determine the dates for each time frame in your sheet is not completely correct.<br /><br />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):<br />1: matches played between 30-6-2013 and 4-7-2012 (including)<br />2: matches played between 3-7-2012 and Edhttps://www.blogger.com/profile/06640136267487836463noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-26948001667144854422013-07-13T10:53:42.360+02:002013-07-13T10:53:42.360+02:00Immediately picked it up :)
Only had Bosnia's...Immediately picked it up :)<br /><br />Only had Bosnia's results thus far, thanks to Ed, now Jeroen gives us the lot conveniently in one file, Thanks man!vedadpasichttps://www.blogger.com/profile/00853220947262293206noreply@blogger.com