League Operator Asstance

cuetipper

Board Regular
Joined
Nov 9, 2018
Messages
63
I help run a small pool league. We have about 30 teams. I would like to generate a spreadsheet to assist with team scheduling. We are given a schedule from teh league with teams $'s that tell us for teh session who plays
who on what week. But we need to figure out the game tables for them. They do so manually each week. What I was hoping for was a macro that would do that for the season. Ideally no team would ever play on the same tables [each match is issued two table] until they play them all any ideas on how to accomplish this?
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
1,768
I used to run a pool league. I did create some code that created tables for each week of play. It's complicated. Our league, like most have Sponsors with a set number of tables and teams.

The code I created worked about 99% of the time. Where it failed is when there were too many teams per Sponsor. Each team should have one table at the Sponsor's site. Two tables, two teams. Seems simple; except that you add Alternate Away vs Home and other factors.

I didn't finish the table before "losing interest". You know, like not getting paid, Sponsors that think they should get preferential treatment, teams that don't want to play at the less desirable locations, etc.

I have a semi-mature set of tables and macros if you're interested. You would either have to manually resolve the problem of too many teams per sponsor or change the code yourself.

Jeff
 

cuetipper

Board Regular
Joined
Nov 9, 2018
Messages
63
Thank you i appreciate the offer. But as you are familiar with the initial structure maybe you can tweak it easily, if not I will give it a go. My requirements are simpler than what you started. 1 ] We have no Sponsors 2] we do not travel. So what i was looking for is where i enter the teams # per a given week ie week 1 [teams 1vs5 and 8vs15] for all the teams and it just assigns tables [two each]. It would be awesome that the table rotate so teams would work thru them all before repeating.
 

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
1,768
You are in luck. As long as the number of tables can support the number of teams, the macro I've created will work for you. It would take too much to download all the code, the tables, and the formulas.

The left table is the team list. The next table is the Sponsor or Tavern table. The next table is the actual schedule that gets generated by the macro. I also created a matrix of teams that shows the number of games played by each combination.

My gift to the site. If anybody develops this any further, I request that you share any improvements in this thread. I'm particularly interested in solving the problem of a lack tables at one site and having to switch to a site with open tables. I manually made the switch after generating.

https://drive.google.com/open?id=1KouHoGxDAmA0SZX8ul993tLEweZBgeWI

Jeff
 

Watch MrExcel Video

Forum statistics

Threads
1,109,549
Messages
5,529,471
Members
409,884
Latest member
Msinmath
Top