UEFA Cups Handbook
I tried to make a handbook in Excel for the UEFA Cups.
The workbook has 8 visible worksheets. The first four are for the
competitions, that is UEFA Super Cup, UEFA Champions League, UEFA Cup,
and UEFA Intertoto Cup.
The next four worksheets are for several tables.
One for the UEFA Country rankings, another for the UEFA Club rankings,
another for the seeding in UCL, UEFA Cup, and UEFA Intertoto Cup, and
the last sheet has the detailed coefficiency calculations for the last
five years for all countries.
As the scores are entered to the competition pages, the winner of the
round is decided by the handbook and the next round fixtures updated for
already drawn fixtures.
After all these, the detailed coefficiency page recalculates the
coefficients after the new scores and UEFA Country and Club ranking
values are changed.
I tried to explain all these more in detail in a Word file called Manual
as well.
Both files are ready to download from my site. The size of the files are
557 KB (The version after UEFA Cup 2nd round draw) for the Handbook and 554 KB for the Manual.
UEFA Cups Handbook
Manual for the Handbook
|