Excel Experts-up for a challenge ?

Discussion in 'Software for Windows' started by rcoups, Dec 21, 2012.

  1. rcoups

    rcoups Junior Member

    Joined:
    Dec 21, 2012
    Messages:
    1
    Likes Received:
    0
    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.
     
  2. gevorg

    gevorg Diamond Member

    Joined:
    Nov 3, 2004
    Messages:
    5,075
    Likes Received:
    0
    http://www.guru.com
     
  3. ringtail

    ringtail Senior member

    Joined:
    Mar 10, 2012
    Messages:
    899
    Likes Received:
    0
    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.
     
Loading...