Downloads

Updates every month

All programs will be refreshed with the full results entered to each file.
Last refreshment was done to on Dec 9th.

2011-2012 UEFA Cups - Updated Turkish Clubs

Latest modifications:
14 September
1 - Corrections on coefficient calculations for the UCL participants.

An Excel program to follow the UEFA Champions League and UEFA Europa Leaguea of 2011-2012.
The program has 10 pages:
1 - CD - UCL Draws
2 - ED - UEL Draws
3 - CQ - UCL - Qualifying Rounds
4 - EQ - UEL - Qualifying Rounds
5 - CG - UCL - Group Stage
6 - EG - UEL - Group Stage
7 - CF - UCL - Round of 16 and the Finals
8 - EF - UEL - Rounds of 32 and 16 and the Finals
9 - N - UEFA Rankings of Nations and berths for 2013-2014 Cups (assuming the current structure)
10 - C - UEFA Rankings of Clubs which will be used for seeding the clubs in 2012-2013

The file is in Excel 2007 format.

The draws for the Qualifying Rounds 1 and 2 are entered to the file.
You will start using the file by entering the match results for these rounds.
When you enter the scores for QR1, the winners will be decided and placed in QR2 fixtures.
When new draws are made you will enter result of the draws and the fixtures for the new round will be setup for you. Then you will enter the result for that round and the next round draw is there for you again.
While entering the results the program will calculate the nations and clubs rankings for the year.

This program is one of the most complex one I have written in Excel and thisis the first try.
Please be tolerant and report any problems you see, so I can prepare a better program next time.

2011-2012 UEFA Cups - 630 KB

Turkish Leagues 2011-2012

The following changes are done to the Turkish Leagues Excel program:
1 - The results will be entered to the match table directly.
2 - All groups of the same league will be at the same sheet. You have to use "pg dn" keys to go one page down and vice versa.
3 - The play-off stages of all leagues, Turkish Cup, and Bölgesel Amatör Ligler will be added to the file later.

2011-2012 Turkish Leagues - 860 KB

2014 World Cup Qualifiers

An Excel program to follow the WC2012 World Cup Qualifiers.
You will enter the game results. The program will calculate tables for the group games and the winner at elimination rounds. The program will eventually calculate all nations qualifying to the Finals.

WC2014 Worl Cup Qualifiers - 477 KB

2011-2012 European Leagues and Cups - Updated Greece clubs

An Excel program to follow all 52 domestic leagues and 53 cups of UEFA countries. Aug 11
You will enter the match scores for the league games.
All clubs are marked originally with a "C" for the cup competitions, that shows the clubs is still playing in the cup competition. If a club gets eliminated, erase the "C" in front of that club. Replace the "C" with a "F" for the club losing the cup final.
For England and France the league cups can be followed the same way. If a clubs gets eliminated from the league cup, erase the "LC" in front of club name. Erase the "LC" also from the the loser at final and do not enter anything.
When you do those thing, the program will calculate the table for that country, UEFA club competitions qualifications, and relegation and/or relegation play-off conditions.
The program is using the specific league structures, tie-breaks, play-offs for uefa competitions, championship, and relegation rules for each leagues. The tie-breaks are given at the bottom line of each country. The program doesn't calculate the comparison of the head-to-head games won, which is used by a few countries.
The points to start the play-offs in Belgium and Greece will be entered to PO box for those countries.

I tried to use the original club names rather than the English names we usually see at the media.

You can go crazy like me and try to follow all 53 cups and 52 leagues, or just try to follow the leagues you like. The program doesn't force you to follow all leagues.

Some compulsory updates will follow in cases of the last club from Greece is decided and the bribery allegations changes to the league structure in Turkey, if any.

2011-2012 European Leagues and Cups - 1.50 MB

EURO2012 Qualifiers

EURO2012 Qualifiers is written in Excel 2007.

Latest changes 29.03.2011:
1 - Max points calculations are corrected for the five nation groups.

2012 EURO2012 Qualifiers - 97 KB

Previous Excel Sheets

2010-2011 Turkish Leagues (4 levels) and Turkish Cup
2011-2012 Bölgesel Amatör Lig (Turkish toplevel amateur leagues in 12 groups
EURO2008 Finals,
2007-08 Turkish Leagues,
EURO2008 Qualifiers (in English), EURO2008 Elemeleri (Türkçe),
UEFA Cups 06-07 (in English),
WC2006 (in English), WC2006 (Türkçe)