Fancy MLS Spreadsheet Table

Discussion in 'MLS: General' started by La Rikardo, May 28, 2012.

  1. La Rikardo

    La Rikardo Moderator

    May 9, 2011
    nj
    I've spent the past several hours creating this rather intricate MLS table on an Excel workbook. The tables for each conference are on the first two worksheets and each team has its own worksheet. When match results are entered into teams' worksheets, the conference tables automatically sort with tiebreakers and all (couldn't figure out how to get head-to-head to sort, so the tiebreaker just skips that one and goes straight to GD).

    All that is nothing fancy, but here's the cool part. The cells at the top left of the table worksheets marked "Game #" and "Date" allow you to enter X number of games or any given date and the table will automatically change and sort to how the table looked after each team played X number of games or how the the table looked on any given date. Call me crazy, but I think that's pretty neat.

    Let me know if I made any mistakes in entering the teams' schedules or anything. Enjoy!

    http://dl.dropbox.com/u/278788/ultra_mls_table_2012.xlsx
     
    Jough, Kappa74 and MLSFan123 repped this.
  2. DonJuego

    DonJuego Member+

    Aug 19, 2005
    Austin, TX
    Club:
    Houston Dynamo
    Nat'l Team:
    United States
    No offense. But has anyone verified this thing is safe?
     
  3. La Rikardo

    La Rikardo Moderator

    May 9, 2011
    nj
    Lol, I thought someone might ask that. I guess there's not really any way to prove its safety. I can tell you that I don't even know how I'd go about making something malicious out of an Excel file, I'm not that smart :p
     
  4. DC06

    DC06 Member+

    Oct 9, 2006
    Within amile of home
    Club:
    DC United
    Nat'l Team:
    United States
    Amusingly enough I received a "#REF! Error" when I tried to open it

    [​IMG]
     
  5. La Rikardo

    La Rikardo Moderator

    May 9, 2011
    nj
    I was puzzled for a second when I saw this, but I just realized what happened here. This spreadsheet uses cells that aren't available in Excel 2003 and earlier. So it'll only work in Excel 2007 or newer. That was an oversight on my part. I can go in and fix it if you want me to.
     
  6. DC06

    DC06 Member+

    Oct 9, 2006
    Within amile of home
    Club:
    DC United
    Nat'l Team:
    United States
    No harm done, I just like to imagine your avatar saying "REF! REF! REF!" at each one of these.
     
  7. La Rikardo

    La Rikardo Moderator

    May 9, 2011
    nj
    Haha. The spreadsheet is fixed for earlier Excel versions if you wanna try it again.
     

Share This Page