For my interest, I would like to know how many times the Rockies, Angels, and Yankees won on the same day in 2017. Can you tell me how to do this?
-
6I'm voting to close this question as off-topic because it is extremely limited in scope and unlikely to aid any future users.– Nij ♦May 25, 2017 at 5:52
-
1@Nij I expanded the scope a little, and wouldn't mind providing an answer to how to do this (using baseball-reference and a spreadsheet). Thinking teaching spreadsheet skills to sports fans might be of some use? Not sure it's useful enough to be on topic, but will defer to you guys for thoughts.– JeopardyTempestMay 25, 2017 at 20:02
-
I think, if you make that much more obviously the purpose of the question, with an example using three random teams like the Rockers, Angels and Yankees, that would be a great question.– Nij ♦May 25, 2017 at 20:05
-
1@JeopardyTempest That's exactly what this meta discussion is about..."how to find stats on [a topic]?" Your statement about teaching sports fans spreadsheet [and research] skills is on point with said discussion.– user527May 25, 2017 at 20:13
-
@ᴍᴀsᴛᴇʀᴍɪɴᴅ_ᴇᴅ Seems there's a Meta post for everything today!!! That's great! Still not sure what to make of Meta posts in the long run, as they often don't seem to reach a concluding "ok, then this is what we'll do", and typically, beyond a comment or two and votes, not sure what more I'd contribute. But will do my best to help :-)– JeopardyTempestMay 25, 2017 at 23:49
|
Show 1 more comment
1 Answer
The Rockies, Angels, and Yankees all won this year on April 4, 22, 28, May 6, 14, 16, 21, and 22.
I found this by going to the Data section on Massey Ratings and pulled up the results of all baseball games this year (http://www.masseyratings.com/scores.php?s=294524&sub=14342&all=1&mode=3&format=0).
I copied the entire table to excel, and used Text to Columns to make the data usable; Fixed Width is the best to use for Massey data. Starting with a lookup table of dates, I then used CountIfs to see if a certain team won on that day, and counted the number of times those three teams won on the same day. Here is a screenshot of the end result:
Formula used:
=CountIfs(Column of Dates, Specific Date, Column of Winners, Specific Winner).
This is used in the table on the right that returned either 0 or 1. The "All 3 Win?" column just asks if the sum of the row is equal to 3.