Quote:
Originally Posted by p45cal
So we're looking for rankings after each 'round'?
It's clearly not easy to define rounds using dates.
How about ranking each team at the time they've played the same number of games?
In the attached, a graphical way of showing what you might want to call rounds:
In cell BE1 enter a game number, then conditional highlighting will highlight those teams having played that number of games, both in columns BE:BF and columns C .
Would it be useful to have a team ranking comparing all teams having played the same number of games?
Enter 36, or 37 or 38 in cell BE1 and you have neat clusters of 12 teams, but enter 35 and you'll still see 12 teams highlighted, but they're not contiguous. Is there, nevertheless, mileage in having rankings in corresponding cells? Clarified perhaps by also showing the count of games played so that people will know whether a team has a game 'in hand' or not next to its ranking?
|
In this revision i've highlighted the first instance of each round in the games played column for both teams. The first time a number is highlighted in either column signals the start of a new round. The number of fixtures per round can be quite variable. For example round 4 has 7 fixtures, and round 5 has 18 fixtures!