Home Page Turkish Leagues Turkish Cups National Teams UEFA Cups Europeans World Cups
2004 2005
1.SUPER LEAGUE
1.Super League
Clubs
Fixture
Excel Database
Archives
46 Year Total
45 Top Scorers
 
OTHER LEAGUES
2.League - A
2.League - B
3.League
 
E-MAİL
Erdinç Sivritepe
Site Meter

NB 2003-2004 Excel Database


Turkish Leagues Database in Excel

I was making Downloadable Excel files for the Turkish Leagues' fixrtures for more than six years now. There were usually one file for each league/group.
This year all 4 leagues played in 9 groups are all combined into one Excel file. I added a lot of extra features to the file and it is not just a fixture file anymore. This was a long study this year and I am sure some mistakes will appear once a while. I would appreciate if you write to me the errors you find and I will correct the file and try it to make better.

Major changes to the file:
1 - The home and away games will be entered to the fixture in the same line. Since the first tie-breaker is head-to-head records, this will help to see the tie breaker decider right away.
2 - The tables are sorted automatically and you don't have to click a button to sort the tables anymore. This also eliminated the use of macros for virus protection.
3 - The security levels for the file is increased.
4 - The file will be re-released as mojor changes are made.
5 - The file is prepared in Turkish language, but if the time permits, an English version will be prepared as well.

The contents of the file:
The Top level (1L - First Super League):
01 - 1T Clubs Info - logos, full names, the city they are from with lots of statistical data.
02 - 1 Fixture. The page where the fixture score to be entered.
03 - 1P Table - The table for 1L.
04 - 1M Games - The scores in a grid.
05 - 1R Records - Some 1L records as All time, Champions', and Seasonal records.
06 - 47T Cumulative table for 47 years - Showing the 47 year totals also with home and away basis. It is updated and sorted with this year's scores as well.
07 - 47M All time scores - The scores of 1L games since its beginning in 1959 in a grid.
08 - 47P All Tables - The tables of the previous 46 yars.

The second level (2A - Second league Category A):
09 - 2A Fixture.
10 - 2AP Table.
11 - 2AM Games.
12 - 2G Second level set-ups since its beginning, including the promotion-relegation games to 1L in earlier years.

The third level (2B - Second league Category B):
13 - 2B Fixtures - for all three groups.
14 - 2BP Tables - all three groups.
15 - 2BM Games - all three groups.
16 - 3G Third level set-ups since its beginning

The fourth level (3L - Third League):
17 - 3 Fixtures - all four groups.
18 - 3P Tables - all four groups.
19 - 3M Games - all four groups.
20 - 4G Fourth level set-ups since its beginning.
Overall pages:
21 - TÜM All clubs in a year-by-year grid showing the league they played, by their province and the city/towns.
22 - ÖZET A summary of all clubs showing how many times they played at all levels with promotion/relegations numbers at each level.

Turkish Leagues' Database - Release 4.2 - Excel File 3.61 MB

Turkish Leagues Excel Database 2004-05 - Release 4.2

Corrections:
Corrections of the Ankaragücü-Gençlerbirliği game score at tables.
Corrections of Yimpaş Yozgatspor placements.

Turkish Leagues Excel Database 2004-05 - Release 4.1

Additions: Kayserispor's new logo. - Thanks to Ayhan Baynal.
Colour Codes at the Tab Selections.
Finishing orders of the 2nd and 3rd Levels from their starts until 1974-75 season. - Thanks to Metin Umar
Corrections:
3.League point calculations.

Turkish Leagues Excel Database 2004-05 - Release 4

Additions: 3rd fixtures - completing all the fixtures for the year.
BB Ankaraspor's new logo
The Average, Goal Difference, and Head-to-Head values of all 47 years' standings for the 1st level as the tie-breakers
Corrections:
Away points calculations of the 2B clubs.
A new algorithm for the 1st league, so that reversing the club names will calculate the home and away points properly.

Turkish Leagues Excel Database 2004-05 - Release 3

2nd League - Category B fixtures are added.
Checking out the past year results and tables are completed with some minor changes in 84-85 scores and 62-63, 86-87, and 00-01 tables. Thanks to Cem Pekin. We believe these parts of the database are published correctly in any internet source for the first time.

Turkish Leagues Excel Database 2004-05 - Release 2

2nd League - Category A fixtures are added with a new algorithm, thanks to Mustafa Yanık.
Corrections to historical results and tables for the seasons 60-61, 62-63, 77-78, 84-85, 86-87, 98-99, and 00-01 and some spelling mistakes. Thanks to Cem Pekin.
Cosmetic changes in the fixture pages for all leagues.

Turkish Leagues Excel Database 2004-05 - Release 1.1

Galatasaray's domestic championship records are corrected and the clubs of 2B and 3 are added after the realignment.

Home Page Turkish Leagues Turkish Cups National Teams UEFA Cups Europeans World Cups