tag:blogger.com,1999:blog-1631997616728141521.post6654237396927193672..comments2024-11-09T01:07:45.914+01:00Comments on Football rankings: EURO 2012: Qualifying draw coefficients (21 August 2008)Edgarhttp://www.blogger.com/profile/03420252819752301980noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-1631997616728141521.post-70674582700856224082008-09-01T09:27:00.000+02:002008-09-01T09:27:00.000+02:00I agree with you that the amirbachar's idea is sim...I agree with you that the amirbachar's idea is simpler and easier to follow, while the mine is a little complicated.<BR/>Anyway, if you want, I post my list after every match day for a confrontation.<BR/><BR/>Have a nice day, EdgarAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-78997587466415970522008-09-01T08:57:00.000+02:002008-09-01T08:57:00.000+02:00Nice idea jos235!I took a look at the file you pos...Nice idea jos235!<BR/><BR/>I took a look at the file you posted. It's a bit too complicated for my taste, but I think you're right about the flaw in amirbachar's idea. However, I'll stick to his idea and here's why: first of all it's simpler and easier to follow, second: a country's coefficient can only go up with his method, thus it's easier to see who could you overtake in the rankings.<BR/><BREdgarhttps://www.blogger.com/profile/03420252819752301980noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-15360320578541018992008-09-01T08:46:00.000+02:002008-09-01T08:46:00.000+02:00Hi Edgar,As i promised I post the excel file(http:...Hi Edgar,<BR/>As i promised I post the excel file(http://europeancups.altervista.org/Teams/coefficients2012new.xls) with the ranking obtained from my "virtual formula".<BR/><BR/>It works pefectly!!<BR/>To update it after every match I have to sum the points gained with those already present in the column "WC2010Q", adding 1 match more in the "MP" column and the coefficient is done!(see KazakhstanAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-9264492880395759922008-08-29T10:01:00.000+02:002008-08-29T10:01:00.000+02:00Thanks jos235. A good day to you too!Thanks jos235. A good day to you too!Edgarhttps://www.blogger.com/profile/03420252819752301980noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-85964502370852175082008-08-29T09:47:00.000+02:002008-08-29T09:47:00.000+02:00Unfortunately, the defect has to be a bit complica...Unfortunately, the defect has to be a bit complicated....<BR/>I believe that a complete list will clarify things better.<BR/><BR/>I wish you a good day, Edgar :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-91909380138720345642008-08-29T09:34:00.000+02:002008-08-29T09:34:00.000+02:00OK then. Let me know when you'll post the entire l...OK then. Let me know when you'll post the entire list.Edgarhttps://www.blogger.com/profile/03420252819752301980noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-11329335313247927052008-08-29T09:31:00.000+02:002008-08-29T09:31:00.000+02:00Edgar,don't compare it with amirbachar's list! It'...Edgar,don't compare it with amirbachar's list! It's obviously that my coefficients are bigger than amirbachar's because for wc2010 you divide the points for 10 even if a team played only one match! But my coefficient are bigger for all nations, not only for KAZ because with this formula i made a final "distorted coefficient" while amirbachar's coeff increase after every single match until the endAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-12225737400598360012008-08-29T09:06:00.000+02:002008-08-29T09:06:00.000+02:00With 19258, Kazakhstan would be in the second pot....With 19258, Kazakhstan would be in the second pot. I still like amirbachar's idea better.<BR/><BR/>Good luck tough! ;)Edgarhttps://www.blogger.com/profile/03420252819752301980noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-19085855823890973622008-08-29T08:44:00.000+02:002008-08-29T08:44:00.000+02:00Hi Edgar,I've checked and in fact even this works ...Hi Edgar,<BR/>I've checked and in fact even this works well (Kazakhstan coefficient after one match is too hight).<BR/><BR/>But finally i found a solution and is simpler than that I adopted the first:<BR/><BR/>I use 100% uefa formula (1+2+2)/5;<BR/>For determining the WC2010 coefficient i proceed in this way:<BR/>-the EC2008 points is divided for MP (i.e. KAZ=235011/14=16786,5)we get the EC2008 Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-21504296238934168162008-08-29T07:22:00.000+02:002008-08-29T07:22:00.000+02:00Hi jos235!You're using the same formula, only you'...Hi jos235!<BR/><BR/>You're using the same formula, only you're writing it in a different way. :)<BR/><BR/>[(WC2006points/WC2006MP)*1+(EC2008points+WC2010points*AK)/(EC2008MP*2)*4]/5<BR/><BR/>=<BR/><BR/>[(WC2006points/WC2006MP)*1+(EC2008points/EC2008MP)*2+(WC2010points*AK/EC2008MP)*2]/5<BR/><BR/>= (replacing AK with EC2008MP/WC2010AMP)<BR/><BR/>[(WC2006points/WC2006MP)*1+(EC2008points/EC2008MP)*2+Edgarhttps://www.blogger.com/profile/03420252819752301980noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-37767513356059082682008-08-28T18:39:00.000+02:002008-08-28T18:39:00.000+02:00i forgot...now the AK coefficient should be calcul...i forgot...<BR/><BR/>now the AK coefficient should be calculated in this way:<BR/><BR/>EC2008MP/WC2010AMP (AMP= actual number of matches that a team played in the group)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-13099701704021679172008-08-28T18:27:00.000+02:002008-08-28T18:27:00.000+02:00HI Edgar,you're right, the formula was wrong.The c...HI Edgar,<BR/>you're right, the formula was wrong.<BR/><BR/>The correct formula is:<BR/>[(WC2006points/WC2006MP)*1+(EC2008points+WC2010points*AK)/(EC2008MP*2)*4]/5<BR/><BR/>I made a sample (calculation for ukraine at the end of EC2008qual):<BR/><BR/>UEFA formula (EC2004*1+WC2006*2+EC2008*2)/5:<BR/><BR/>((180511/8*1)+(549523/17*2)+(291018/12*2))/5=<B>27143</B><BR/><BR/>with my formula (AK=17/12=Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-87342948874642543972008-08-28T07:21:00.000+02:002008-08-28T07:21:00.000+02:00Hi jos235,I've been on holiday for three days with...Hi jos235,<BR/><BR/>I've been on holiday for three days with no internet access.<BR/><BR/>[(WC2006points/WC2006MP)*1+(EC2008points+WC2010points*AK)/(EC2008MP+WC2010MP)*2]/3<BR/><BR/>You have some errors in your formula.<BR/><BR/>The actual UEFA formula looks like this:<BR/><BR/>[(WC2006points/WC2006MP)*1+(EC2008points/EC2008MP)*2+(WC2010points/WC2010MP)*2]/5<BR/><BR/>Looking at your coefficient Edgarhttps://www.blogger.com/profile/03420252819752301980noreply@blogger.comtag:blogger.com,1999:blog-1631997616728141521.post-35360293334416969012008-08-25T11:48:00.000+02:002008-08-25T11:48:00.000+02:00HI Edgar,for my virtual calculations I will use th...HI Edgar,<BR/>for my virtual calculations I will use this modified formula:<BR/>[(WC2006points/WC2006MP)*1+(EC2008points+WC2010points*AK)/(EC2008MP+WC2010MP)*2]/3<BR/><BR/>-WC2006points: points earned in world cup 2006 matches (final phase + qualification).<BR/>-WC2006MP: matches played in world cup 2006 (final phase + qualification).<BR/>-EC2008points: points earned in european cup 2008 matches Anonymousnoreply@blogger.com