NYCFC vs. Opponents - Record

Ernesto Estevez

Registered
Seasoned Supporter
Jun 2, 2014
96
142
33
32
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
 
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.View attachment 8911 View attachment 8912 View attachment 8914
Thanks for this. Though can you please change the font on the New Jersey GA and DIF to make it more difficult to read? :)
 
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.View attachment 8911 View attachment 8912 View attachment 8914

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.
 
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.View attachment 8911 View attachment 8912 View attachment 8914

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.
 
  • Like
Reactions: Shwafta
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.View attachment 8911 View attachment 8912 View attachment 8914


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.
 
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.

From looking at it the percentage is points won. (i.e. 0W 1D 1L = 1 point out of 6 points = ~16.67%)
 
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.

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.
 
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.

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
 
  • Like
Reactions: Rimil
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.
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.
 
And when y'all make a chart like this you can pick the font and how to format it.
giphy.gif
 
Also please fix the #DIV/0 error by using the =IFERROR formula
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?

And I'd prefer negative values in parenthesis. For example (5) vs. -5
But goal differentials are officially recorded the way he has it, so why change it?
 
  • Like
Reactions: Christopher Jee
I mean you can just hardcode an "n/a" but I thought the IFERROR would be a teaching moment.
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: