On odd weeks all teams are paired, buy on even weeks only teams with
odd numbers are paired, and they are paired twice.

This can not be the expected result from the pairing.

Lars-Åke

On Mon, 27 Jul 2009 04:27:01 -0700, Stefi
wrote:

Earlier there was a similar thread, maybe you can make use of my answer given
to that post. I copy here the thread:


Do you mean something like this:
A B C D E F
week pair1 pair2 pair3 pair4 pair5
1 t1-t2 t3-t4 t5-t6 t7-t8 t9-t10
2 t1-t3 t3-t5 t5-t7 t7-t9 t9-t1
3 t1-t4 t3-t6 t5-t8 t7-t10 t9-t2
4 t1-t5 t3-t7 t5-t9 t7-t1 t9-t3
5 t1-t6 t3-t8 t5-t10 t7-t2 t9-t4
6 t1-t7 t3-t9 t5-t1 t7-t3 t9-t5
7 t1-t8 t3-t10 t5-t2 t7-t4 t9-t6
8 t1-t9 t3-t1 t5-t3 t7-t5 t9-t7
9 t1-t10 t3-t2 t5-t4 t7-t6 t9-t8

The formula in B2:

="t"&INT(2*COLUMN()-1/2)-2&"-t"&IF(MOD((INT(2*COLUMN()-1/2)-1)+ROW()-2,10)0,MOD((INT(2*COLUMN()-1/2)-1)+ROW()-2,10),10)

Fill it to the right and down!

t1, t2, etc. stands for team1, team2, etc.

Regards,
Stefi


„manchester united” ezt írta:

I need help trying to set a format for 10 teams playing each other in 10
weeks. eg...team1 vs team 2, team 3 vs team 4, team 5 vs team 6...etc...
Also for 12 teams playing against each other for 10 weeks.

Thanks for your help....


„DubboPete” ezt írta:

Hi all,

I have been racking my brains for the last three days trying to work a
logical sequence to setting up fixtures for a 19 week league
competition for 20 players.

Here's what I want to do:

20 players (numbered 1 thru 20 for ease of use) each play a game per
week, so there's 10 games per week. Each player only plays an
opponent once every 19 weeks. Each player obviously plays 19 games -
one player plays 19 opponents.

I just can't work out a formula to set the fixtures automatically
without any duplications. Can anyone help or point me in the right
direction?

cheers in anticipation

DubboPete