Fixture List Formula

[greasytony]

Does anyone have any clue about any kind of formula for creating a fixtures list for a sports league where every team plays each other once, one game per team per day, I'm there is a logical standard formula for this but I'm getting no-where with it!

"Do not attribute to Malice, what can easily be explained away by stupidity" REF 2002

 

[SkipVought]

GT,

No standard formula. It all depends on the number of teams, dosn't it?

What I'd suggest as a tool for doing this is to set up a matrix and fill in the game number something like this for 4 teams...
[tt]
1 2 3 4
1 - 7 10 12
2 1 - 8 11
3 4 2 - 9
4 6 6 3 -
[/tt]
for each team playing the other twice, one HOME and one AWAY.



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[SkipVought]

AND...

here's formulas to do a schedule using the above mentioned matrix

1) Select the Left-VERTICAL list of teams and Name the range Home
2) Select the Top-HORIZONTAL list of teams and Name the range Away
3) Select the games EXCLUDING the Top and Left list of teams and Name the range Games
4) Set up the Schedule Table
[tt]
Game Home Away
1
thru
12
[/tt]
5) past this formula in the first Home and Away row (in my case it's in B2 & C2)
[tt]
=SUMPRODUCT((Games=$A2)*Home)
=SUMPRODUCT((Games=$A2)*Away)
[/tt]
6) Copy these formulas down thru the games



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884