There ain't NO names on either spreadsheet.
CONTADOR & AXIOMATICS:
Let me start with this piece of advice:
“PULL YOUR HEADS OUT OF THOSE BARRELS OF WINE, WHISKEY, VODKA, ŢUICĂ...!”
You don’t know what you wanna know — hence all this confusion!
So, you want to group 8 teams 4 at a time AS IF representing a quarterfinal. But 4 teams do NOT represent a 4-match quarterfinal!
Indeed, C(8, 4) = (8 * 7 * 6 * 5) / (1 * 2 * 3 * 4) = 1680 / 24 = 70
But look what you get by running that grandiose piece of software known world-over as PermuteCombine.exe:
BAYERN MUNICH | BORUSSIA DORTMUND | CHELSEA FC | FC PORTO | *
BAYERN MUNICH | BORUSSIA DORTMUND | CHELSEA FC | LIVERPOOL FC |
BAYERN MUNICH | BORUSSIA DORTMUND | CHELSEA FC | MANCHESTER CITY |
BAYERN MUNICH | BORUSSIA DORTMUND | CHELSEA FC | PARIS SAINT-GERMAIN |
BAYERN MUNICH | BORUSSIA DORTMUND | CHELSEA FC | REAL MADRID |
BAYERN MUNICH | BORUSSIA DORTMUND | FC PORTO | LIVERPOOL FC |
BAYERN MUNICH | BORUSSIA DORTMUND | FC PORTO | MANCHESTER CITY |
BAYERN MUNICH | BORUSSIA DORTMUND | FC PORTO | PARIS SAINT-GERMAIN |
BAYERN MUNICH | BORUSSIA DORTMUND | FC PORTO | REAL MADRID |
BAYERN MUNICH | BORUSSIA DORTMUND | LIVERPOOL FC | MANCHESTER CITY |
BAYERN MUNICH | BORUSSIA DORTMUND | LIVERPOOL FC | PARIS SAINT-GERMAIN |
BAYERN MUNICH | BORUSSIA DORTMUND | LIVERPOOL FC | REAL MADRID |
BAYERN MUNICH | BORUSSIA DORTMUND | MANCHESTER CITY | PARIS SAINT-GERMAIN |
BAYERN MUNICH | BORUSSIA DORTMUND | MANCHESTER CITY | REAL MADRID |
BAYERN MUNICH | BORUSSIA DORTMUND | PARIS SAINT-GERMAIN | REAL MADRID |
BAYERN MUNICH | CHELSEA FC | FC PORTO | LIVERPOOL FC |
BAYERN MUNICH | CHELSEA FC | FC PORTO | MANCHESTER CITY |
BAYERN MUNICH | CHELSEA FC | FC PORTO | PARIS SAINT-GERMAIN |
BAYERN MUNICH | CHELSEA FC | FC PORTO | REAL MADRID |
BAYERN MUNICH | CHELSEA FC | LIVERPOOL FC | MANCHESTER CITY |
BAYERN MUNICH | CHELSEA FC | LIVERPOOL FC | PARIS SAINT-GERMAIN |
BAYERN MUNICH | CHELSEA FC | LIVERPOOL FC | REAL MADRID |
BAYERN MUNICH | CHELSEA FC | MANCHESTER CITY | PARIS SAINT-GERMAIN |
BAYERN MUNICH | CHELSEA FC | MANCHESTER CITY | REAL MADRID |
BAYERN MUNICH | CHELSEA FC | PARIS SAINT-GERMAIN | REAL MADRID |
BAYERN MUNICH | FC PORTO | LIVERPOOL FC | MANCHESTER CITY |
BAYERN MUNICH | FC PORTO | LIVERPOOL FC | PARIS SAINT-GERMAIN |
BAYERN MUNICH | FC PORTO | LIVERPOOL FC | REAL MADRID |
BAYERN MUNICH | FC PORTO | MANCHESTER CITY | PARIS SAINT-GERMAIN |
BAYERN MUNICH | FC PORTO | MANCHESTER CITY | REAL MADRID |
BAYERN MUNICH | FC PORTO | PARIS SAINT-GERMAIN | REAL MADRID |
BAYERN MUNICH | LIVERPOOL FC | MANCHESTER CITY | PARIS SAINT-GERMAIN |
BAYERN MUNICH | LIVERPOOL FC | MANCHESTER CITY | REAL MADRID |
BAYERN MUNICH | LIVERPOOL FC | PARIS SAINT-GERMAIN | REAL MADRID |
BAYERN MUNICH | MANCHESTER CITY | PARIS SAINT-GERMAIN | REAL MADRID |
BORUSSIA DORTMUND | CHELSEA FC | FC PORTO | LIVERPOOL FC |
BORUSSIA DORTMUND | CHELSEA FC | FC PORTO | MANCHESTER CITY |
BORUSSIA DORTMUND | CHELSEA FC | FC PORTO | PARIS SAINT-GERMAIN |
BORUSSIA DORTMUND | CHELSEA FC | FC PORTO | REAL MADRID |
BORUSSIA DORTMUND | CHELSEA FC | LIVERPOOL FC | MANCHESTER CITY |
BORUSSIA DORTMUND | CHELSEA FC | LIVERPOOL FC | PARIS SAINT-GERMAIN |
BORUSSIA DORTMUND | CHELSEA FC | LIVERPOOL FC | REAL MADRID |
BORUSSIA DORTMUND | CHELSEA FC | MANCHESTER CITY | PARIS SAINT-GERMAIN |
BORUSSIA DORTMUND | CHELSEA FC | MANCHESTER CITY | REAL MADRID |
BORUSSIA DORTMUND | CHELSEA FC | PARIS SAINT-GERMAIN | REAL MADRID |
BORUSSIA DORTMUND | FC PORTO | LIVERPOOL FC | MANCHESTER CITY |
BORUSSIA DORTMUND | FC PORTO | LIVERPOOL FC | PARIS SAINT-GERMAIN |
BORUSSIA DORTMUND | FC PORTO | LIVERPOOL FC | REAL MADRID |
BORUSSIA DORTMUND | FC PORTO | MANCHESTER CITY | PARIS SAINT-GERMAIN |
BORUSSIA DORTMUND | FC PORTO | MANCHESTER CITY | REAL MADRID |
BORUSSIA DORTMUND | FC PORTO | PARIS SAINT-GERMAIN | REAL MADRID |
BORUSSIA DORTMUND | LIVERPOOL FC | MANCHESTER CITY | PARIS SAINT-GERMAIN |
BORUSSIA DORTMUND | LIVERPOOL FC | MANCHESTER CITY | REAL MADRID |
BORUSSIA DORTMUND | LIVERPOOL FC | PARIS SAINT-GERMAIN | REAL MADRID |
BORUSSIA DORTMUND | MANCHESTER CITY | PARIS SAINT-GERMAIN | REAL MADRID |
CHELSEA FC | FC PORTO | LIVERPOOL FC | MANCHESTER CITY |
CHELSEA FC | FC PORTO | LIVERPOOL FC | PARIS SAINT-GERMAIN |
CHELSEA FC | FC PORTO | LIVERPOOL FC | REAL MADRID |
CHELSEA FC | FC PORTO | MANCHESTER CITY | PARIS SAINT-GERMAIN |
CHELSEA FC | FC PORTO | MANCHESTER CITY | REAL MADRID |
CHELSEA FC | FC PORTO | PARIS SAINT-GERMAIN | REAL MADRID |
CHELSEA FC | LIVERPOOL FC | MANCHESTER CITY | PARIS SAINT-GERMAIN |
CHELSEA FC | LIVERPOOL FC | MANCHESTER CITY | REAL MADRID |
CHELSEA FC | LIVERPOOL FC | PARIS SAINT-GERMAIN | REAL MADRID |
CHELSEA FC | MANCHESTER CITY | PARIS SAINT-GERMAIN | REAL MADRID |
FC PORTO | LIVERPOOL FC | MANCHESTER CITY | PARIS SAINT-GERMAIN |
FC PORTO | LIVERPOOL FC | MANCHESTER CITY | REAL MADRID |
FC PORTO | LIVERPOOL FC | PARIS SAINT-GERMAIN | REAL MADRID |
FC PORTO | MANCHESTER CITY | PARIS SAINT-GERMAIN | REAL MADRID |
LIVERPOOL FC | MANCHESTER CITY | PARIS SAINT-GERMAIN | REAL MADRID | *
I can see you can count, indeed. There are 70 4-team combinations. If they would group the 8 QF teams in groups, there must be 2 groups of 4 teams. You can select 2 combos from the 70 possible groupings; the condition: only unique teams must be selected. I selected one possible 2-group combo and I marked it by an *. You can select others. So, my QF-Group stage would look like:
Group A
BAYERN MUNICH
BORUSSIA DORTMUND
CHELSEA FC
FC PORTO
Group B
LIVERPOOL FC
MANCHESTER CITY
PARIS SAINT-GERMAIN
REAL MADRID
But that’s NOT how the quarterfinals are organized. The phase consists of matches between 2 teams. So, we have to go back to my first list of 28 pairings. From those, we select 4 pairings consisting of unique teams. Those 4 pairings represent the CL quarterfinals.
‘Quarter’ is related to number 4. ‘Semis’ is related to number 2: There are 2 matches in the semifinals. The previous round is known as ‘optimi de finala” in my native language. In English, they say ‘round of 16’; there are 16 teams playing 8 games (the ‘1/8 round’).
BAYERN MUNICH | BORUSSIA DORTMUND | **
BAYERN MUNICH | CHELSEA FC | ***
BAYERN MUNICH | FC PORTO |
BAYERN MUNICH | LIVERPOOL FC |
BAYERN MUNICH | MANCHESTER CITY |
BAYERN MUNICH | PARIS SAINT-GERMAIN | *
BAYERN MUNICH | REAL MADRID |
BORUSSIA DORTMUND | CHELSEA FC |
BORUSSIA DORTMUND | FC PORTO | ***
BORUSSIA DORTMUND | LIVERPOOL FC |
BORUSSIA DORTMUND | MANCHESTER CITY | *
BORUSSIA DORTMUND | PARIS SAINT-GERMAIN |
BORUSSIA DORTMUND | REAL MADRID |
CHELSEA FC | FC PORTO | *
CHELSEA FC | LIVERPOOL FC | **
CHELSEA FC | MANCHESTER CITY |
CHELSEA FC | PARIS SAINT-GERMAIN |
CHELSEA FC | REAL MADRID |
FC PORTO | LIVERPOOL FC |
FC PORTO | MANCHESTER CITY | **
FC PORTO | PARIS SAINT-GERMAIN |
FC PORTO | REAL MADRID |
LIVERPOOL FC | MANCHESTER CITY | ***
LIVERPOOL FC | PARIS SAINT-GERMAIN |
LIVERPOOL FC | REAL MADRID | *
MANCHESTER CITY | PARIS SAINT-GERMAIN |
MANCHESTER CITY | REAL MADRID |
PARIS SAINT-GERMAIN | REAL MADRID | ** ***
The * now represents the actual configuration of the QFs as officially drawn by UEFA, (UEFA stands for “Blood On Your Face” in one of the many languages involved in European football, aka soccer). In alphabetical order:
BAYERN MUNICH | PARIS SAINT-GERMAIN | *
BORUSSIA DORTMUND | MANCHESTER CITY | *
CHELSEA FC | FC PORTO | *
LIVERPOOL FC | REAL MADRID | *
Other QF matchups could have been drawn as well. I marked them by **, ***, (you can do it for more QF possible matchups)...
BAYERN MUNICH | BORUSSIA DORTMUND | **
CHELSEA FC | LIVERPOOL FC | **
FC PORTO | MANCHESTER CITY | **
PARIS SAINT-GERMAIN | REAL MADRID | **
After the ** QF, I have a hard time finding a third 4-match configuration... a unique configuration, without repeating any matchup... If you patient, try other configurations. In my case, I have PARIS SAINT-GERMAIN | REAL MADRID | ** *** twice... Maybe only 2 QF UNIQUE configurations are possible!
This thread started with a lot of confusion. Evidently, mathematics, specifically combinatorics, is NOT the strong suit of most posters. But, then again, methinks it is all about them barrels... as in that Frankish Sinatra song:
“They don’t see the big birdie I am
I fly high to the sky
To plunge hard in that barrel of whiskey
Like a meteor of my God.”