Need Excel Expert help

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

bcoups

Thread Starter
Joined
Dec 21, 2012
Messages
1
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.
 

Attachments

Joined
Jun 8, 2001
Messages
2,583
Welcome to TSG,
I checked out the spread sheet, Its pretty cool. There was a note in the help file:
Note that pairs of teams in the schedule have complementary home/away patterns, so this pattern can be used to advantage if there are pairs of teams that share the same venue.

So that should cover your multiple team at one venue issue.

As far as 'stacking the schedule' I would just look it over and assign team names to the numbers playing each other that satisfied your criteria. Its cool that you can put a team name in column A and it propagates to the schedule. Spin it till it makes a schedule you like. No system will be perfect. It would be quite an undertaking to add a Rank weight to the schedule.

You might try making two schedules with your top teams in one. In my opinion if there's not enough weeks for everyone to play each other at least once you should split the league.
 
Joined
Feb 10, 2002
Messages
5
Thanks for the reply. Regarding the venue problem, we have one location that has 3 tables and 5 teams, so a problem occurs when a fourth team from that venue would be scheduled to play there as the home team and NOT against one of the other teams from that venue. Another venue has 2 tables and 4 teams and there's one with 1 table and 2 teams. All the rest have 1 team and 1 table , which is no problem at all. I had resigned myself to just printing out some generated schedules as you suggested and then troubleshooting them, but I was hoping to avoid that. The league operator doesn't want to split the league into divisions either. Thanks again for the input.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Top