PDA

View Full Version : Shuffleboard tournament math



wilg19
03-19-2017, 02:35 PM
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
03-19-2017, 04:19 PM
I have 16 players who over 12 weeks need to play each other once.
Does that not require 15 weeks?

SamT
03-19-2017, 04:33 PM
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
03-19-2017, 05:29 PM
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

18690

SamT
03-19-2017, 08:38 PM
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
03-20-2017, 05:22 AM
Hey .. I thought I did purtty gud for not knowing the rules

wilg19
03-20-2017, 06:35 AM
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,