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.