+ Reply to Thread
Results 1 to 4 of 4

Goal: Use Excel data to create a game schedule

  1. #1
    Registered User
    Join Date
    07-11-2013
    Location
    San Antonio, Texas
    MS-Off Ver
    Excel 2010
    Posts
    3

    Goal: Use Excel data to create a game schedule

    Hello! I was happy to find this forum when I Googled for Excel help and so here I am, a new member.

    I am trying to use Excel to generate a game schedule for my fantasy football league. Right now I handle this task manually but I figured there has to be a way for Excel to work it out.

    Let's say I have 16 teams playing 16 games. I have a table written out using numbers to represent the different teams. The x-axis has one team number per column while the y-axis has a week number in each row. The intersection of any column with each row shows the x-axis team's opponent for the week. What I want to do is substitute a team name or abbreviation for the team numbers in the body of the table and then generate a formula (or script? - I'm not sure of the correct terminology) to then produce a listing of the games each week. So the output would look something like this:

    Week 1
    BNS v ROC
    NYL v NFB
    WBB v TCF
    etc...

    Each 3 letter abbreviation represents a team name. This would significantly reduce the amount of manual work I have to do since Excel would generate the game schedule as above for each week and then I take that information and dump it into the software I use to run the League.

    So nothing serious such as a work project but a task nonetheless that I need to get done. Any input is appreciated!

    Thanks!
    Attached Files Attached Files
    Last edited by MrRipley; 07-11-2013 at 09:33 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: New to forum ... Can Excel do this?

    Well, to answer the question in your thread title, yes, Excel can do that.

    However, you will need to submit an example Excel workbook so that contributors can see how you data is laid out and play about with different approaches before returning a solution to you. Read the FAQ to find out how to attach a file to one of your posts.

    Pete

    EDIT: You should also change the title of your thread to make it more descriptive of your problem - see the Forum Rules.
    Last edited by Pete_UK; 07-11-2013 at 07:17 PM.

  3. #3
    Registered User
    Join Date
    07-11-2013
    Location
    San Antonio, Texas
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Goal: Use Excel data to create a game schedule

    Thanks for the tips. Title changed and file uploaded.

  4. #4
    Registered User
    Join Date
    07-11-2013
    Location
    San Antonio, Texas
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Goal: Use Excel data to create a game schedule

    I see several have looked but none have posted. Any tips for an Excel novice? Will check back in a few more days...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1