Excel Experts-up for a challenge ?

[rcoups]

I have an Excel file I downloaded from another forum. It is not my work. It generates a schedule for my 8 Ball league. I can input the # of teams and the number of weeks in the session, hit "generate" and I get a fairly balanced home and away schedule. I need to tweak the schedule, because some of our venues have more than 1 pool table and multiple teams, so there is an over-booking possibility to deal with. Also, we would like the schedule to pit most of the stronger teams (for ex. the top 10 or 12 teams from the previous session) against each other. Are these tweaks possible with Excel or do I need to find someone proficient in VB, C++ or C# to write an app for us ? Thanks in advance for any help you can provide.

 

[gevorg]

I have an Excel file I downloaded from another forum. It is not my work. It generates a schedule for my 8 Ball league. I can input the # of teams and the number of weeks in the session, hit "generate" and I get a fairly balanced home and away schedule. I need to tweak the schedule, because some of our venues have more than 1 pool table and multiple teams, so there is an over-booking possibility to deal with. Also, we would like the schedule to pit most of the stronger teams (for ex. the top 10 or 12 teams from the previous session) against each other. Are these tweaks possible with Excel or do I need to find someone proficient in VB, C++ or C# to write an app for us ? Thanks in advance for any help you can provide.

http://www.guru.com

 

[ringtail]

rcoups,

Yes, you can do that in Excel, or in a database.

Something quite like what you describe is presented as a training exercise in a database book I read, but it was so many years ago that I don't remember which.

If you want to use Excel, here's a resource for you.