Calculate league standings in a fixture list

p45cal · #1 09-27-2023, 05:03 PM

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:D.

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?

DRU · #2 09-28-2023, 12:28 AM

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?

It's a deceptively tricky task.
The purpose of the spreadsheet requires league standings by "round" which incorporates dates of matches and the number of matches played.
There isn't an easy way to do it. Initially, I imagined ranking 6 fixtures and calling that a round would be fine. However, it's not really because a round doesn't always amount to 6 fixtures. The very first round has 10 fixtures, for example.
The ultimate goal, no awful pun intended, is to track league positions for each team throughout the entire season.

DRU · #3 09-28-2023, 01:24 AM

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?

Actually, there is a way to confirm the start of a fresh round of fixtures. I added the no of games played by the home team and away team in columns E & G. When the number increments in any column, a fresh round of fixtures begins. It doesn't matter if the match numbers are not the same. The highest number of games played confirms which round of fixtures it belongs in.

DRU · #4 09-28-2023, 03:27 AM

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!

DRU · #5 09-28-2023, 05:55 AM

Quote:

Originally Posted by DRU

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!

Yep, I screwed this up. When I've made a correction I'll repost the spreadsheet.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cross-reference with full context a numbered list inside another multilevel list (list style)	MatLcq	Word	0	02-01-2021 06:00 AM
Calculate a Date	shawn.low@cox.net	Mail Merge	5	12-12-2019 03:22 PM
are there any good free golf league programs out there	kener40	Other Software	0	03-28-2014 05:54 PM
calculate age	userman	Excel	8	06-02-2012 10:59 PM
Calculate formula base of list menu	rkeles	Excel	4	09-22-2010 12:38 AM