1. Thank you for visiting our NYCFC forum! We invite you to REGISTER and join our growing member base in discussion! Registered members can join competitions and win monthly prizes. So what are you waiting for!? Join us! This is a great MLS community where you can discuss New York City Football Club and other MLS football teams as well as international and other domestic league teams.
  2. Use your NYCFC Forums Credits or 'Dan Bucks' to remove the ads.

    Use Credits or Become A Donor

NYCFC vs. Opponents - Record

Discussion in 'Team News and Rumors' started by Ernesto Estevez, Jul 19, 2018.

  1. Ernesto Estevez

    Ernesto Estevez Newbie Seasoned Supporter

    Messages:
    91
    Likes Received:
    114
    Trophy Points:
    33
    Hi, I am an usual visitor of this forums but mostly only to read and catch up.
    I had some time in hand and went through our games since 2015 and wanted to keep a record of how we do against each rival at home and away, hope to keep it updated week after week and you guys enjoy it.

    Note: this is only MLS regular season play. Home.PNG Away.PNG Total.PNG
     
    Rimil, Sabo, MumonA and 19 others like this.
  2. JayH

    JayH Senior Member Elite Donor Donor Seasoned Supporter

    Messages:
    4,637
    Likes Received:
    14,906
    Trophy Points:
    353
    Thanks for this. Though can you please change the font on the New Jersey GA and DIF to make it more difficult to read? :)
     
    Rimil, Kjbert, SoupInNYC and 5 others like this.
  3. adam

    adam Senior Member Elite Donor Donor Seasoned Supporter

    Messages:
    7,059
    Likes Received:
    16,710
    Trophy Points:
    353
    Location:
    LBNY
    The RSL record bugs me to no end. Because we all know we should have won those matches if our coach at the time didn’t screw it up.
     
  4. LionNYC

    LionNYC Senior Member Staff Member Elite Donor Seasoned Supporter

    Messages:
    14,574
    Likes Received:
    25,244
    Trophy Points:
    303
    Location:
    New York, NY
    This is some great work. I'd also do a data table without the 2015 season since that was just practice under Vieira arrived in 2016.
     
    Shwafta likes this.
  5. mgarbowski

    mgarbowski Senior Member Elite Donor Donor Seasoned Supporter

    Messages:
    10,915
    Likes Received:
    30,611
    Trophy Points:
    353
    Location:
    Queens, NY

    Good stuff. I have questions, though.

    What is the basis for the order teams are listed? You have the East first, then West, but within those groups it's not alphabetical, or sorted by any of the columns as best as I can tell. Alphabetical would probably be the most useful, either single table or split East/West.

    What do the percentages reflect?

    Same for the colors -- what do they mean? I generally see that green probably means a good NYC record, yellow mediocre, and red bad, but what specifically is the criteria. Some borderline cases seem on the wrong side no matter what criteria I pick.

    These are all quibbles, though. Well done.
     
  6. LionNYC

    LionNYC Senior Member Staff Member Elite Donor Seasoned Supporter

    Messages:
    14,574
    Likes Received:
    25,244
    Trophy Points:
    303
    Location:
    New York, NY
    From looking at it the percentage is points won. (i.e. 0W 1D 1L = 1 point out of 6 points = ~16.67%)
     
    Christopher Jee and Gotham Gator like this.
  7. Ernesto Estevez

    Ernesto Estevez Newbie Seasoned Supporter

    Messages:
    91
    Likes Received:
    114
    Trophy Points:
    33
    This was something I started on my phone on a subway ride so I just started typing the teams as they came to mind so no specific order yet.
    regarding the colors green=positive nycfc record, yellow = tie in wins for both teams and red=negative nycfc record.
    the % is the percentage of points obtained.

    Hopefully with next releases this can get better.
     
  8. LionNYC

    LionNYC Senior Member Staff Member Elite Donor Seasoned Supporter

    Messages:
    14,574
    Likes Received:
    25,244
    Trophy Points:
    303
    Location:
    New York, NY
    Also please fix the #DIV/0 error by using the =IFERROR formula

    And I'd prefer negative values in parenthesis. For example (5) vs. -5
     
    Rimil likes this.
  9. Gotham Gator

    Gotham Gator Senior Member Donor

    Messages:
    9,096
    Likes Received:
    18,398
    Trophy Points:
    353
    Location:
    Bronxville, NY
    And can we avoid sans serif font? Maybe Garamond or Georgia?
     
  10. SoupInNYC

    SoupInNYC Senior Member Elite Donor

    Messages:
    4,586
    Likes Received:
    10,385
    Trophy Points:
    303
    Location:
    UES
    Amazing that our record is 1 win and 3 losses and our GD is netting to 0.

    Edit: We all understand what's happened with NJ and why that GD is so huge, but another GD that is an interesting comparison to the W/L record is with Orlando, where we've won 4, drawn 2, and lost 5, but have a positive GD of 5.
     
  11. Christopher Jee

    Christopher Jee Senior Member Elite Donor Donor Seasoned Supporter

    Messages:
    2,930
    Likes Received:
    7,583
    Trophy Points:
    323
    Lol and I would prefer you apply all those changes on your smartphone only using your middle finger .
     
  12. Christopher Jee

    Christopher Jee Senior Member Elite Donor Donor Seasoned Supporter

    Messages:
    2,930
    Likes Received:
    7,583
    Trophy Points:
    323
    You know there is a typeface called Gotham right?
     
  13. mgarbowski

    mgarbowski Senior Member Elite Donor Donor Seasoned Supporter

    Messages:
    10,915
    Likes Received:
    30,611
    Trophy Points:
    353
    Location:
    Queens, NY
    Midas Mulligan, adam, Kjbert and 2 others like this.
  14. Shwafta

    Shwafta Active Member

    Messages:
    1,736
    Likes Received:
    2,335
    Trophy Points:
    223
    Location:
    Long Island
    comic sans!
     
  15. derek_villa

    derek_villa Active Member Seasoned Supporter

    Messages:
    2,787
    Likes Received:
    5,291
    Trophy Points:
    273
    And when y'all make a chart like this you can pick the font and how to format it.
    [​IMG]
     
    Rimil, LostAnvil, Kjbert and 4 others like this.
  16. engine46

    engine46 Junior Member Seasoned Supporter

    Messages:
    497
    Likes Received:
    960
    Trophy Points:
    93
    Location:
    LGA
    I’m sure it wasn’t meant that way, but the tone here seems a bit rude. Maybe simply suggest the other formula to use since maybe he’s not some Excel expert?

    But goal differentials are officially recorded the way he has it, so why change it?
     
    Christopher Jee likes this.
  17. Midas Mulligan

    Midas Mulligan Senior Member Elite Donor Donor Seasoned Supporter International Liaison

    Messages:
    10,564
    Likes Received:
    26,408
    Trophy Points:
    353
    Location:
    NYC
    Fuck you and your serifs. I fucking hate serifs.
     
    Gotham Gator and Christopher Jee like this.
  18. Midas Mulligan

    Midas Mulligan Senior Member Elite Donor Donor Seasoned Supporter International Liaison

    Messages:
    10,564
    Likes Received:
    26,408
    Trophy Points:
    353
    Location:
    NYC
    Funny. I thought you’d met LionNYCLionNYC.
     
    Christopher Jee likes this.
  19. LionNYC

    LionNYC Senior Member Staff Member Elite Donor Seasoned Supporter

    Messages:
    14,574
    Likes Received:
    25,244
    Trophy Points:
    303
    Location:
    New York, NY
    I mean you can just hardcode an "n/a" but I thought the IFERROR would be a teaching moment.
     
  20. Midas Mulligan

    Midas Mulligan Senior Member Elite Donor Donor Seasoned Supporter International Liaison

    Messages:
    10,564
    Likes Received:
    26,408
    Trophy Points:
    353
    Location:
    NYC
    Or set print options not to print errors. Which doesn’t solve your problem, but solves any problem that actually matters.

    I can’t waste processing power on iferror only to do away with div/0 or anything.

    Then again, thank god I don’t have to do this shit all the time anymore.
     
    Last edited: Jul 20, 2018

Share This Page