tag:blogger.com,1999:blog-1631997616728141521.post8169455560278639306..comments2020-12-03T07:58:19.890+01:00Comments on Football rankings: EURO 2012: Qualifying draw coefficients (21 May 2008)Edhttp://www.blogger.com/profile/06640136267487836463noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-1631997616728141521.post-56608349168733708582008-05-24T20:21:00.000+02:002008-05-24T20:21:00.000+02:00@amirA team gets 10,000 points for each match. The...@amir<BR/><BR/>A team gets 10,000 points for each match. Then 30,000 for a win and 10,000 for a draw.<BR/><BR/>I think you forgot the first 10,000. If you add this value for each match, you'll get the same result.Edgarhttps://www.blogger.com/profile/03420252819752301980noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-70573622803173743222008-05-24T18:04:00.000+02:002008-05-24T18:04:00.000+02:00I think you made a mistake in Austria rankings. On...I think you made a mistake in Austria rankings. Only WC2006 Q should be considered for them and they got 15 points (and +3 GD) in 10 matches, that is 15150 points.<BR/>How did you calculate their rankings?Amirhttps://www.blogger.com/profile/06469650958512209299noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-56612788362558283322008-05-23T14:00:00.000+02:002008-05-23T14:00:00.000+02:00Poland and Ukraine are not in the list, since they...Poland and Ukraine are not in the list, since they will be automatically qualified as hosts.Edgarhttps://www.blogger.com/profile/03420252819752301980noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-25079353777036378802008-05-23T13:54:00.000+02:002008-05-23T13:54:00.000+02:00Ohhh, Poland is not in Europe any more :(Ohhh, Poland is not in Europe any more :(Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-16598690430061116912008-05-23T12:29:00.000+02:002008-05-23T12:29:00.000+02:00Thanks Raoul :)I found the error.Portugal - Nether...Thanks Raoul :)<BR/><BR/>I found the error.<BR/><BR/>Portugal - Netherlands 2 - 1. I did count it as a defeat for the Netherlands, but I only registered one allowed goal instead of two.<BR/><BR/>I did the rounding at the end and now we have the same values (I hope).<BR/><BR/>Thanks again!Edgarhttps://www.blogger.com/profile/03420252819752301980noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-78373488795337581752008-05-23T11:57:00.000+02:002008-05-23T11:57:00.000+02:00OK, here's the whole program's output for the Neth...OK, here's the whole program's output for the Netherlands (minus the SQL which isn't that interesting), that should help you find the missing goal easier... The data should be correct as it comes out of my database, mind you, I entered that by hand over the years so you never know...<BR/><BR/>Cycle: [1]<BR/> Tournament: [79] From: [2002/01/01] To: [2003/12/31]<BR/>SQL: [...]<BR/>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-89120087391113768812008-05-23T11:54:00.000+02:002008-05-23T11:54:00.000+02:00In other words: Cycle 1 average points: [35002.2]C...In other words: <BR/><BR/>Cycle 1 average points: [35002.2]<BR/>Cycle 2 average points: [36845.625]<BR/>Cycle 3 average points: [32084.583333333332]<BR/><BR/>(35002.2*1 + 36845.625*2 + 32084.583333333332*2) / 5 = 172862.616667 / 5 = 34572.5233333<BR/><BR/>Rounded that is 34573.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-69195077891925779042008-05-23T11:50:00.000+02:002008-05-23T11:50:00.000+02:00Looking at Cycle 1, I have 525,533, you have 525,0...Looking at Cycle 1, I have 525,533, you have 525,033 - there must be a goal allowed that I didn't take into consideration.<BR/><BR/>Thanks, Raoul!Edgarhttps://www.blogger.com/profile/03420252819752301980noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-42496061495307224632008-05-23T11:45:00.000+02:002008-05-23T11:45:00.000+02:00Edgar, I think you need to do the rounding at the ...Edgar, I think you need to do the rounding at the end, rather than at each calculation, then you should get exactly what UEFA get (at least for the 2007 figures).<BR/><BR/>2 times 16,787 can be 33,573 rather than 33,574 if it was 16,786.56 for instance.<BR/><BR/>Here's my program's output for the Netherlands:<BR/><BR/>Cycle [1]<BR/> Total points: [525033]<BR/> Matches: [15]<BR/> Average points: [Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-83156308915802288602008-05-23T08:50:00.000+02:002008-05-23T08:50:00.000+02:00Raoul, two questions regarding the 2007 ranking.1....Raoul, two questions regarding the 2007 ranking.<BR/><BR/>1. Kazakhstan.<BR/><BR/>If you look at article 3.3.1 in the pdf document, you have this values:<BR/><BR/>2006: 118,506/12 = 9,876 (9,875.5)<BR/>2008: 235,011/14 = 16,787 (16,786.5)<BR/><BR/>So for, so good.<BR/><BR/>However, when they apply the weighting (2 in both cases), there's a problem with 2008.<BR/><BR/>16,787 * 2 = 33,573 (I get Edgarhttps://www.blogger.com/profile/03420252819752301980noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-18959332370031120182008-05-23T08:04:00.000+02:002008-05-23T08:04:00.000+02:00I didn't look into it yet. I only did a quick Exce...I didn't look into it yet. I only did a quick Excel hack :)<BR/>I think you got it right, because I didn't get exactly the same values as UEFA for the 2007 ranking.Edgarhttps://www.blogger.com/profile/03420252819752301980noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-26832385576319312562008-05-23T00:11:00.000+02:002008-05-23T00:11:00.000+02:00Hi there, well done, you got there one day before ...Hi there, well done, you got there one day before me. I finished my program yesterday to verify the rankings published by UEFA, and today I ran my program for the Euro 2012 qualifying. It will be nice to run the program during and afer Euro 2008 to see how things change. I basically have the same numbers except for the following rounding differences:<BR/><BR/>4 France, me: 34218, you: 34217<BR/>7Anonymousnoreply@blogger.com