Shuffleboard tournament math

[wilg19]

Hi there.

I have a 12 week shuffleboard tournament to set up in which I have 16 players who over 12 weeks need to play each other once. Below is an eg. I need to randomly generate the teams so they are not the same each time and that as eg in lane 3 player 16 does not always play in lane 3.
I was hoping to randomly generate all teams and generate randomly lanes they play in so not too many repeats.

I hope this is enough info to go on. I have been trying many ways to solve with no success. All help is appreciated.

	HEAD	FOOT		HEAD	FOOT		HEAD	FOOT		HEAD	FOOT
	Lane 1	Lane 1		Lane 2	Lane 2		Lane 3	Lane 3		Lane 4	Lane 4
	1-2	1-2		3-4	3-4		5-6	5-6		7-8	7-8
Week 1 Jan. 27	3-2	10-13		12-5	4-8		16-9	1-14		6-7	15-11
Week 2 Feb. 3	4-13	11-14		3-6	5-9		16-10	2-15		7-8	1-12
Week 3 Feb. 10	5-14	12-15		4-7	6-10		16-11	3-1		8-9	2-13
Week 4 Feb. 17	7-1	14-2		6-9	8-12		16-13	5-3		10-11	4-15
Week 5 Feb. 24	8-2	15-3		7-10	9-13		16-14	6-4		11-12	5-1
Week 6 Mar. 3	9-3	1-4		8-11	10-14		16-15	7-5		12-13	6-2
Week 7 Mar. 10	10-4	2-5		9-12	11-15		16-1	8-6		13-14	7-3
Week 8 Mar. 17	11-5	3-6		10-13	12-1		16-2	9-7		14-15	8-4
Week 9 Mar. 24	12-6	4-7		11-14	13-2		16-3	10-8		15-1	9-5
Week 10 Mar. 31	14-8	6-9		13-1	15-4		16-5	12-10		2-3	11-7
Week 11 Apr. 7	15-9	7-10		14-2	1-5		16-6	13-11		3-4	12-8
Week 12 Apr. 14	1-10	8-11		15-3	2-6		16-7	14-12		4-5	13-9

[mdmackillop]

I have 16 players who over 12 weeks need to play each other once.

Does that not require 15 weeks?

[SamT]

To restate the problem
Given 16 variables, or Columns named, eg
L1HP1
L2HP1
L3HP1
...
L1HP2
L2HP2
...
L1FP1
...
L4FP2
...
Wherein L =Lane
H&F = Head and Foot
P1-2 = Player position at Head or Foot

Randomly fill all 16 variables or Columns with the numbers 1 to 16 without duplicates 12 times or down 12 rows, where the numbers represent game participants.

And, while we're at it,might as well go thru the list of 16 player names and substitute them for the Numbers in the Columns and Rows.

This must be done on multiple sheets, which will be selected one at a time.

Is that right?

I am assuming that the list of player names is in Range A4 to A19 and the list of Game Dates is in C4 to C19, and the table of player positions is D4 to the right and down

[Paul_Hossler]

If there are 16 players then there are 16 x 15 = 240 matches.

If there are 12 weeks, then you need to play 20 matches each week

So something like this

Capture.JPG

[SamT]

They play 4 to a board, so 1 player can play at least one time with each of the other 15 in just 5 games

[Paul_Hossler]

Hey .. I thought I did purtty gud for not knowing the rules

[wilg19]

Hi guys, your all amazing and correct. mdMackillop you were bang on with 15 weeks... don't know how you came up with that so fast. Thanks for your directions.. I actually took a different direction and used a link (while I cant post for some reason) which was "Individual-Pairs Tournament" link to set as a template then I shifted to use rand() to assign names randomly vs numbers randomly and worked very well.
Thanks sooooo much for your responses.. I's been a while since I came back to this forum and your quick responses we just as great as my experiences before.
Sincerely,