Anybody know where I can get a team scheduling program?

[sumdumgai]

Hello again. Thought I would check this forum before trying to come up with program myself. I'm a member of American Legion. We have a seasonal golf league that plays golf once a week over some number of weeks at a local course. Teams are two players each and there may be up to 25 teams. Two teams play each other each week. I would like to find a program that does the scheduling for each week, where each team plays a different team every week, but plays them only once over the league's season. Of course, if there is an odd number of teams, each team would get a bye week. So, the inputs would be simply be the team names (or 'Team A', 'Team B', 'Team C', etc.), and the weekly schedule would be generated. The A.L. Post would much appreciate any help. Thanks.

[Keebellah]

Have you tried BFF Google?

One of the many hits

https://templates.office.com/en-us/S...ad=US&fromAR=1

Another one
https://www.template.net/business/roster/roster/

[sumdumgai]

Thanks. Looked at those in your template suggestions, but none seem to address the team scheduling that I need.

[ptmuldoon]

I remember needing to do something very similar.

This here was able to help me.

http://golfsoftware.com/tools/schedu...generator.html

[Keebellah]

This is just to help you with ideas, not THE answer but it can put you on the right track.

[Winon]

Hello sumdumgai,

Your requirement would involve quite a bit of work and time, as well as some other clarification/s, which I cannot do without compensation.
With this said, please consider posting your requirement in our Commercial Services Section of this Forum with a link to this Thread.

When you do that, you may include in your Thread Title, "For Winon", and I shall pick it up from there.

Kind Regards.

[sumdumgai]

Thanks. How about a sudoku solution that I can possibly modify? Anybody know of a free VBA sudoku solution?

[Logit]

.
That was quite a jump from TEAM GENERATOR to SODOKU...

Here are some sodoku resources :

https://excel-macro.tutorialhorizon....sudoku-solver/

http://www.nielshorn.net/prog/vba/vbaXL_sudoku.php

https://github.com/togademi/sudoku

http://www.excel-macros.co.uk/sudoku...or-and-solver/

http://vbaexcel.eu/vbaexcel/8-sudoku-solver

[sumdumgai]

Well, just to get started, I created a 6x6 matrix with 6 team names in column 1 and 6 game dates in row 1. Trying to get each team to play only one game per day and to play each of the other teams only once by manually updating each cell is not as easy as you'd think. It actually becomes a sudoku kind of a problem. Of course, there would be a lot more teams and game days. Thanks for the suggestions.