creating a 20 peason matrix

tonylpcs@yahoo.co.uk · Jul 16, 2011

hi every one,

ok ive got an idea

i want to create a 20 peson matrix showing 19 weeks for a chess compatision.

each player needs to play each other player only once and naturaly each player can only play one game aweek.

im trying to create a play list but cant get it right.

can anyone help me please?

tony

sezuh · Jul 16, 2011

Hi ,
i dont know if it would help here is manually made list for 19 weeks;

Excel Workbook

A

B

C

D

E

F

G

H

I

J

K

1

WEEK 1

1, 2

3, 19

4, 18

5, 17

6, 16

7, 15

8, 14

9, 13

10, 12

11, 20

2

WEEK 2

1, 3

2, 20

4, 19

5, 18

6, 17

7, 16

8, 15

9, 14

10, 13

11, 12

3

WEEK 3

1, 4

2, 3

12, 20

5, 19

6, 18

7, 17

8, 16

9, 15

10, 14

11, 13

4

WEEK 4

1, 5

2, 4

3, 20

12, 13

6, 19

7, 18

8, 17

9, 16

10, 15

11, 14

5

WEEK 5

1, 6

2, 5

3, 4

12, 14

13, 20

7, 19

8, 18

9, 17

10, 16

11, 15

6

WEEK 6

1, 7

2, 6

3, 5

4, 20

12, 15

13, 14

8, 19

9, 18

10, 17

11, 16

7

WEEK 7

1, 8

2, 7

3, 6

4, 5

12, 16

13, 15

14, 20

9, 19

10, 18

11, 17

8

WEEK 8

1, 9

2, 8

3, 7

4, 6

5, 20

13, 16

14, 15

12, 17

10, 19

11, 18

9

WEEK 9

1, 10

2, 9

3, 8

4, 7

5, 6

13, 17

14, 16

12, 18

15, 20

11, 19

10

WEEK 10

1, 11

2, 10

3, 9

4, 8

5, 7

6, 20

14, 17

15, 16

12, 19

13, 18

11

WEEK 11

1, 12

2, 11

3, 10

4, 9

5, 8

6, 7

14, 18

15, 17

13, 19

16, 20

12

WEEK 12

1, 13

2, 12

3, 11

4, 10

5, 9

6, 8

7,20

15, 18

16, 17

14, 19

13

WEEK 13

1, 14

2, 13

3, 12

4, 11

5, 10

6, 9

7, 8

15, 19

16, 18

17, 20

14

WEEK 14

1, 15

2, 14

3, 13

4, 12

5, 11

6, 10

7, 9

8, 20

16, 19

17, 18

15

WEEK 15

1, 16

2, 15

3, 14

4, 13

5, 12

6, 11

7, 10

8, 9

18, 20

17, 19

16

WEEK 16

1, 17

2, 16

3, 15

4, 14

5, 13

6, 12

7, 11

8, 10

9, 20

18, 19

17

WEEK 17

1, 18

2, 17

3, 16

4, 15

5, 14

6, 13

7, 12

8, 11

9, 10

19, 20

18

WEEK 18

1, 19

2, 18

3, 17

4, 16

5, 15

6, 14

7, 13

8, 12

9, 11

10, 20

19

WEEK 19

1, 20

2, 19

3, 18

4, 17

5, 16

6, 15

7, 14

8, 13

9, 12

10, 11

Sheet3

tonylpcs@yahoo.co.uk · Jul 17, 2011

HI,

that is such a masive help thank you,

now you say it was a manauly made list?

if i need to make list for 2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19 players as well then this would solve my problem as i could just get it to use the relevent list, how can i creat all of these matrixes quickly and easily?

(if it did take you to long and at the sound of being very cheky, would you be able to do them for me?)

or even better is there a way to put in cell a1 the number of players and have excell create the matrix for that many people?

thank you so much for your help

Tony

tonylpcs@yahoo.co.uk · Jul 17, 2011

help!

sezuh · Jul 17, 2011

Hi Tony,
here lists for 12,14,16,and 18 players matrix,if there is mistake let me know.

Excel Workbook

A

B

C

D

E

F

G

H

I

J

1

List for 18

2

Week 1

1, 2

3, 17

4, 16

5, 15

6, 14

7, 13

8, 12

9, 11

10, 18

3

Week 2

1, 3

2, 18

4, 17

5, 16

6, 15

7, 14

8, 13

9, 12

10, 11

4

Week 3

1, 4

2, 3

11, 18

5, 17

6, 16

7, 15

8, 14

9, 13

10, 12

5

Week 4

1, 5

2, 4

3, 18

11, 12

6, 17

7, 16

8, 15

9, 14

10, 13

6

Week 5

1, 6

2, 5

3, 4

11, 13

12, 18

7, 17

8, 16

9, 15

10, 14

7

Week 6

1, 7

2, 6

3, 5

4, 18

12, 13

11, 14

8, 17

9, 16

10, 15

8

Week 7

1, 8

2, 7

3, 6

4, 5

12, 14

11, 15

13, 18

9, 17

10, 16

9

Week 8

1, 9

2, 8

3, 7

4, 6

5, 18

11, 16

12, 15

13, 14

10, 17

10

Week 9

1, 10

2, 9

3, 8

4, 7

5, 6

11, 17

12, 16

13, 15

14, 18

11

Week 10

1, 11

2, 10

3, 9

4, 8

5, 7

6, 18

12, 17

13, 16

14, 15

12

Week 11

1, 12

2, 11

3, 10

4, 9

5, 8

6, 7

15, 18

13, 17

14, 16

13

Week 12

1, 13

2, 12

3, 11

4, 10

5, 9

6, 8

7, 18

15, 16

14, 17

14

Week 13

1, 14

2, 13

3, 12

4, 11

5, 10

6, 9

7, 8

15, 17

16, 18

15

Week 14

1, 15

2, 14

3, 13

4, 12

5, 11

6, 10

7, 9

8, 18

16, 17

16

Week 15

1, 16

2, 15

3, 14

4, 13

5, 12

6, 11

7, 10

8, 9

17, 18

17

Week 16

1, 17

2, 16

3, 15

4, 14

5, 13

6, 12

7, 11

8, 10

9, 18

18

Week 17

1, 18

2, 17

3, 16

4, 15

5, 14

6, 13

7, 12

8, 11

9, 10

19

List for 16

20

Week 1

1, 2

3, 15

4, 14

5, 13

6, 12

7, 11

8, 10

9, 16

21

Week 2

1, 3

2, 16

4, 15

5, 14

6, 13

7, 12

8, 11

9, 10

22

Week 3

1, 4

2, 3

10, 16

5, 15

6, 14

7, 13

8, 12

9, 11

23

Week 4

1, 5

2, 4

3, 16

10, 11

6, 15

7, 14

8, 13

9, 12

24

Week 5

1, 6

2, 5

3, 4

10, 12

11, 16

7, 15

8, 14

9, 13

25

Week 6

1, 7

2, 6

3, 5

4, 16

10, 13

11, 12

8, 15

9, 14

26

Week 7

1, 8

2, 7

3, 6

4, 5

10, 14

11, 13

12, 16

9, 15

27

Week 8

1, 9

2, 8

3, 7

4, 6

5, 16

11, 14

10, 15

12, 13

28

Week 9

1, 10

2, 9

3, 8

4, 7

5, 6

11, 15

13, 16

12, 14

29

Week 10

1, 11

2, 10

3, 9

4, 8

5, 7

6, 16

13, 14

12, 15

30

Week 11

1, 12

2, 11

3, 10

4, 9

5, 8

6, 7

13, 15

14, 16

31

Week 12

1, 13

2, 12

3, 11

4, 10

5, 9

6, 8

7, 16

14, 15

32

Week 13

1, 14

2, 13

3, 12

4, 11

5, 10

6, 9

7, 8

15, 16

33

Week 14

1, 15

2, 14

3, 13

4, 12

5, 11

6, 10

7, 9

8, 16

34

Week 15

1, 16

2, 15

3, 14

4, 13

5, 12

6, 11

7, 10

8, 9

Sheet1

Sheet2

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 11pt; FONT-FAMILY: Calibri,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="COLOR: #ff0000">list for 14</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD>Week 1</TD><TD style="TEXT-ALIGN: right">1, 2</TD><TD style="TEXT-ALIGN: right">3, 13</TD><TD style="TEXT-ALIGN: right">4, 12</TD><TD style="TEXT-ALIGN: right">5, 11</TD><TD style="TEXT-ALIGN: right">6, 10</TD><TD style="TEXT-ALIGN: right">7, 9</TD><TD style="TEXT-ALIGN: right">8, 14</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD>Week 2</TD><TD style="TEXT-ALIGN: right">1, 3</TD><TD style="TEXT-ALIGN: right">2, 14</TD><TD style="TEXT-ALIGN: right">4, 13</TD><TD style="TEXT-ALIGN: right">5, 12</TD><TD style="TEXT-ALIGN: right">6, 11</TD><TD style="TEXT-ALIGN: right">7, 10</TD><TD style="TEXT-ALIGN: right">8, 9</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD>Week 3</TD><TD style="TEXT-ALIGN: right">1, 4</TD><TD style="TEXT-ALIGN: right">2, 3</TD><TD style="TEXT-ALIGN: right">9, 14</TD><TD style="TEXT-ALIGN: right">5, 13</TD><TD style="TEXT-ALIGN: right">6, 12</TD><TD style="TEXT-ALIGN: right">7, 11</TD><TD style="TEXT-ALIGN: right">8, 10</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD>Week 4</TD><TD style="TEXT-ALIGN: right">1, 5</TD><TD style="TEXT-ALIGN: right">2, 4</TD><TD style="TEXT-ALIGN: right">3, 14</TD><TD style="TEXT-ALIGN: right">9, 10</TD><TD style="TEXT-ALIGN: right">6, 13</TD><TD style="TEXT-ALIGN: right">7, 12</TD><TD style="TEXT-ALIGN: right">8, 11</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD>Week 5</TD><TD style="TEXT-ALIGN: right">1, 6</TD><TD style="TEXT-ALIGN: right">2, 5</TD><TD style="TEXT-ALIGN: right">3, 4</TD><TD style="TEXT-ALIGN: right">9, 11</TD><TD style="TEXT-ALIGN: right">10, 14</TD><TD style="TEXT-ALIGN: right">7, 13</TD><TD style="TEXT-ALIGN: right">8, 12</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD>Week 6</TD><TD style="TEXT-ALIGN: right">1, 7</TD><TD style="TEXT-ALIGN: right">2, 6</TD><TD style="TEXT-ALIGN: right">3, 5</TD><TD style="TEXT-ALIGN: right">4, 14</TD><TD style="TEXT-ALIGN: right">9, 12</TD><TD style="TEXT-ALIGN: right">10, 11</TD><TD style="TEXT-ALIGN: right">8, 13</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD>Week 7</TD><TD style="TEXT-ALIGN: right">1, 8</TD><TD style="TEXT-ALIGN: right">2, 7</TD><TD style="TEXT-ALIGN: right">3, 6</TD><TD style="TEXT-ALIGN: right">4, 5</TD><TD style="TEXT-ALIGN: right">9, 13</TD><TD style="TEXT-ALIGN: right">10, 12</TD><TD style="TEXT-ALIGN: right">11, 14</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD>Week 8</TD><TD style="TEXT-ALIGN: right">1, 9</TD><TD style="TEXT-ALIGN: right">2, 8</TD><TD style="TEXT-ALIGN: right">3, 7</TD><TD style="TEXT-ALIGN: right">4, 6</TD><TD style="TEXT-ALIGN: right">5, 14</TD><TD style="TEXT-ALIGN: right">10, 13</TD><TD style="TEXT-ALIGN: right">11, 12</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD>Week 9</TD><TD style="TEXT-ALIGN: right">1, 10</TD><TD style="TEXT-ALIGN: right">2, 9</TD><TD style="TEXT-ALIGN: right">3, 8</TD><TD style="TEXT-ALIGN: right">4, 7</TD><TD style="TEXT-ALIGN: right">5, 6</TD><TD style="TEXT-ALIGN: right">12, 14</TD><TD style="TEXT-ALIGN: right">11, 13</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD>Week 10</TD><TD style="TEXT-ALIGN: right">1, 11</TD><TD style="TEXT-ALIGN: right">2, 10</TD><TD style="TEXT-ALIGN: right">3, 9</TD><TD style="TEXT-ALIGN: right">4, 8</TD><TD style="TEXT-ALIGN: right">5, 7</TD><TD style="TEXT-ALIGN: right">6, 14</TD><TD style="TEXT-ALIGN: right">12, 13</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD>Week 11</TD><TD style="TEXT-ALIGN: right">1, 12</TD><TD style="TEXT-ALIGN: right">2, 11</TD><TD style="TEXT-ALIGN: right">3, 10</TD><TD style="TEXT-ALIGN: right">4, 9</TD><TD style="TEXT-ALIGN: right">5, 8</TD><TD style="TEXT-ALIGN: right">6, 7</TD><TD>13, 14</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD>Week 12</TD><TD style="TEXT-ALIGN: right">1, 13</TD><TD style="TEXT-ALIGN: right">2, 12</TD><TD style="TEXT-ALIGN: right">3, 11</TD><TD style="TEXT-ALIGN: right">4, 10</TD><TD style="TEXT-ALIGN: right">5, 9</TD><TD style="TEXT-ALIGN: right">6, 8</TD><TD style="TEXT-ALIGN: right">7, 14</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD>Week 13</TD><TD style="TEXT-ALIGN: right">1, 14</TD><TD style="TEXT-ALIGN: right">2, 13</TD><TD style="TEXT-ALIGN: right">3, 12</TD><TD style="TEXT-ALIGN: right">4, 11</TD><TD style="TEXT-ALIGN: right">5, 10</TD><TD style="TEXT-ALIGN: right">6, 9</TD><TD style="TEXT-ALIGN: right">7, 8</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="COLOR: #ff0000">list for 12</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD>Week 1</TD><TD style="TEXT-ALIGN: right">1, 2</TD><TD style="TEXT-ALIGN: right">3, 11</TD><TD style="TEXT-ALIGN: right">4, 10</TD><TD style="TEXT-ALIGN: right">5, 9</TD><TD style="TEXT-ALIGN: right">6, 8</TD><TD style="TEXT-ALIGN: right">7, 12</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD>Week 2</TD><TD style="TEXT-ALIGN: right">1, 3</TD><TD style="TEXT-ALIGN: right">2, 12</TD><TD style="TEXT-ALIGN: right">4, 11</TD><TD style="TEXT-ALIGN: right">5, 10</TD><TD style="TEXT-ALIGN: right">6, 9</TD><TD style="TEXT-ALIGN: right">7, 8</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">18</TD><TD>Week 3</TD><TD style="TEXT-ALIGN: right">1, 4</TD><TD style="TEXT-ALIGN: right">2, 3</TD><TD style="TEXT-ALIGN: right">8, 12</TD><TD style="TEXT-ALIGN: right">5, 11</TD><TD style="TEXT-ALIGN: right">6, 10</TD><TD style="TEXT-ALIGN: right">7, 9</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">19</TD><TD>Week 4</TD><TD style="TEXT-ALIGN: right">1, 5</TD><TD style="TEXT-ALIGN: right">2, 4</TD><TD style="TEXT-ALIGN: right">3, 12</TD><TD style="TEXT-ALIGN: right">8, 9</TD><TD style="TEXT-ALIGN: right">6, 11</TD><TD style="TEXT-ALIGN: right">7, 10</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">20</TD><TD>Week 5</TD><TD style="TEXT-ALIGN: right">1, 6</TD><TD style="TEXT-ALIGN: right">2, 5</TD><TD style="TEXT-ALIGN: right">3, 4</TD><TD style="TEXT-ALIGN: right">8, 10</TD><TD style="TEXT-ALIGN: right">9, 12</TD><TD style="TEXT-ALIGN: right">7, 11</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">21</TD><TD>Week 6</TD><TD style="TEXT-ALIGN: right">1, 7</TD><TD style="TEXT-ALIGN: right">2, 6</TD><TD style="TEXT-ALIGN: right">3, 5</TD><TD style="TEXT-ALIGN: right">4, 12</TD><TD style="TEXT-ALIGN: right">9, 10</TD><TD style="TEXT-ALIGN: right">8, 11</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">22</TD><TD>Week 7</TD><TD style="TEXT-ALIGN: right">1, 8</TD><TD style="TEXT-ALIGN: right">2, 7</TD><TD style="TEXT-ALIGN: right">3, 6</TD><TD style="TEXT-ALIGN: right">4, 5</TD><TD style="TEXT-ALIGN: right">9, 11</TD><TD style="TEXT-ALIGN: right">10, 12</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">23</TD><TD>Week 8</TD><TD style="TEXT-ALIGN: right">1, 9</TD><TD style="TEXT-ALIGN: right">2, 8</TD><TD style="TEXT-ALIGN: right">3, 7</TD><TD style="TEXT-ALIGN: right">4, 6</TD><TD style="TEXT-ALIGN: right">5, 12</TD><TD style="TEXT-ALIGN: right">10, 11</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">24</TD><TD>Week 9</TD><TD style="TEXT-ALIGN: right">1, 10</TD><TD style="TEXT-ALIGN: right">2, 9</TD><TD style="TEXT-ALIGN: right">3, 8</TD><TD style="TEXT-ALIGN: right">4, 7</TD><TD style="TEXT-ALIGN: right">5, 6</TD><TD style="TEXT-ALIGN: right">11, 12</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">25</TD><TD>Week 10</TD><TD style="TEXT-ALIGN: right">1, 11</TD><TD style="TEXT-ALIGN: right">2, 10</TD><TD style="TEXT-ALIGN: right">3, 9</TD><TD style="TEXT-ALIGN: right">4, 8</TD><TD style="TEXT-ALIGN: right">5, 7</TD><TD style="TEXT-ALIGN: right">6, 12</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">26</TD><TD>Week 11</TD><TD style="TEXT-ALIGN: right">1, 12</TD><TD style="TEXT-ALIGN: right">2, 11</TD><TD style="TEXT-ALIGN: right">3, 10</TD><TD style="TEXT-ALIGN: right">4, 9</TD><TD style="TEXT-ALIGN: right">5, 8</TD><TD style="TEXT-ALIGN: right">6, 7</TD><TD> </TD></TR></TABLE>

mirabeau · Jul 19, 2011

Hi Tony,

If you'd like to try a macro to do this, you can run the following.

You can change the number of players in line 4 of the macro from n=20 to n=100 or whatever you like.
It shouldn't take long to execute.

Code:

Sub all_play_all()
Dim c() As Variant, u() As Variant, flg as byte
Dim i As Long, j As Long, n As Long
n = 20
If n Mod 2 = 1 Then n = n + 1: flg = 1
ReDim c(1 To n, 1 To n / 2 + 1), u(1 To n)
For i = 1 To n - 1
If flg = 1 Then u(n) = "bye" Else u(n) = n
For j = 1 To n - 1
    u(j) = i + j - 1
    If u(j) > n - 1 Then u(j) = u(j) - n + 1
Next j
For j = 1 To n / 2
    c(i, j + 1) = u(j) & "  " & u(n - j + 1)
Next j
c(i, 1) = "Week " & i
Next i
Range("A1").Resize(n, n / 2 + 1) = c
End Sub

tonylpcs@yahoo.co.uk · Jul 19, 2011

Hi thank you so much,

that is going to come in very useful,

thank you

Tony

sezuh · Jul 19, 2011

Mirabeau, that is absolutly brilliant code i'm saving it for future use..

But i can not resist asking,is there any where in the net have similar code but for threesome,foursome or fivesome scheduling arrangement?
I can provide examples if you need.
thanks again

mirabeau · Jul 19, 2011

tonylpcs@yahoo.co.uk said:
Hi thank you so much,

that is going to come in very useful,

thank you

Tony

Hi tony,

Good that you found it useful. I'd rather hoped that you would.

sezuh said:
Mirabeau, that is absolutly brilliant code i'm saving it for future use..
But i can not resist asking,is there any where in the net have similar code but for threesome,foursome or fivesome scheduling arrangement?
I can provide examples if you need.
thanks again

Hi sezuh,

Thanks for the kind comments.

No I don't know of any similar code on the web. I did the above one on an ad hoc (=for this particular purpose) basis, and had only checked with the graphical "round-robin" algorithm on Wikipedia. But that's only a 2-dimensional thing and would I guess get rapidly more complicated with groups of 3, 4 or more.

You've probably looked yourself on the web, but for me I actually have very little knowledge of other code on the web (apart from odd bits on this forum). It's not really my area of interest. You might (once again) note the sentiments implied in my signature quote below.

Sorry that I can't be of more help.

creating a 20 peason matrix

tonylpcs@yahoo.co.uk

Active Member

Excel Facts

sezuh

Well-known Member

tonylpcs@yahoo.co.uk

Active Member

tonylpcs@yahoo.co.uk

Active Member

sezuh

Well-known Member

mirabeau

Banned user

tonylpcs@yahoo.co.uk

Active Member

sezuh

Well-known Member

mirabeau

Banned user

Similar threads

Forum statistics

Share this page

creating a 20 peason matrix

Active Member

Excel Facts

Well-known Member

Active Member

Active Member

Well-known Member

Banned user

Active Member

Well-known Member

Banned user

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock