Tournament Selection

%3CLINGO-SUB%20id%3D%22lingo-sub-1570717%22%20slang%3D%22en-US%22%3ETournament%20Selection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1570717%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20looking%20to%20run%20a%20bowls%20tournament.%3C%2FP%3E%3CP%3EI%20have%2036%20competitors%20each%20bowling%20as%20a%20single.%3C%2FP%3E%3CP%3EThe%20tournament%20consists%20of%204%20rounds%2C%20of%201%20game%20each.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20players%20play%20in%20pairs%2C%20against%20another%20pair.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%209%20%22venues%22%20available%20for%20the%20tournament%20so%20each%20%22venue%22%20will%20have%204%20bowlers%20per%20game.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20a%20routine%20that%20will%20build%20the%20tournament%20for%20me%20such%20that%3A-%3C%2FP%3E%3CP%3E-%20Each%20game%20every%20competitor%20will%20bowl%20with%20a%20unique%20bowler%20against%20two%20unique%20bowlers%20(so%20no-one%20competes%20against%20the%20same%20competitor%20more%20than%20once)%20in%20the%20tournament%3C%2FP%3E%3CP%3E-%20Additionally%20I%20want%20each%20competitor%20to%20change%20venues%20after%20each%20game%20(but%20they%20may%20return%20to%20an%20earlier%20venue%20later).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1570717%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1570895%22%20slang%3D%22en-US%22%3ERe%3A%20Tournament%20Selection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1570895%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F751459%22%20target%3D%22_blank%22%3E%40KeithWest%3C%2FA%3E%26nbsp%3B%20so%20in%20the%20attached%20I%20set%20it%20up%20for%20you.%26nbsp%3B%20Basically%20I%20shift%20player%20in%20position%201%20by%201%20venue%2C%20position%202%20by%202%20venue%2C%20...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1580145%22%20slang%3D%22en-US%22%3ERe%3A%20Tournament%20Selection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1580145%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F570951%22%20target%3D%22_blank%22%3E%40mtarler%3C%2FA%3E%26nbsp%3BThanks.%20I%20think%20you%20have%20cracked%20it%20for%20me%20with%20a%20little%20tweak%20here%20and%20there.%3C%2FP%3E%3CP%3EI%20couldn't%20get%20my%20head%20around%20how%20to%20do%20the%20shift.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I'm looking to run a bowls tournament.

I have 36 competitors each bowling as a single.

The tournament consists of 4 rounds, of 1 game each.

 

The players play in pairs, against another pair.

 

There are 9 "venues" available for the tournament so each "venue" will have 4 bowlers per game.

 

I need a routine that will build the tournament for me such that:-

- Each game every competitor will bowl with a unique bowler against two unique bowlers (so no-one competes against the same competitor more than once) in the tournament

- Additionally I want each competitor to change venues after each game (but they may return to an earlier venue later).

 

Can anyone help?

2 Replies

@KeithWest  so in the attached I set it up for you.  Basically I shift player in position 1 by 1 venue, position 2 by 2 venue, ...

 

@mtarler Thanks. I think you have cracked it for me with a little tweak here and there.

I couldn't get my head around how to do the shift.