Posted this originally in the Random Thoughts thread but moving it to it's own thread by the suggestion of Boone.
After yesterday's game, I was questioning the lack of a commitment to the running game especially after we had some decent runs. This is nothing new, but being a numbers guy I decided if I could find a way to get more insight into what we've actually been doing from a play call perspective.
I found this site where someone has gotten all the play by play data from publicly available sources and created files since 2013. I've got access to some cool tools at work, so I took those files, merged them, and loaded them up to run some reports to see what I see. What I have below is a first pass at breaking down our play calls from the 2014-2016 seasons. There is more I want to do with this, but thought I'd throw what I have now to see if it sparks any ideas on how to break it down further. For example, I'd love to throw in some variables of how the score may dictate the calls. Unfortunately, the files don't have that information. I did however try to make an attempt at seeing if the calls changed based on end of half/end of game.
Like I said, I just started and plan to do more. If you have any thoughts on ways to slice the data let me know and I'll see what I can do.
This is a breakdown of all our plays on 1st, 2nd, and 3rd down. The left shows pure numbers, the left normalizes the data so you can visualize percentages and then further breaks it down by Distance. When I first looked at overall play calls on first down, I was surprised to see it was almost 50/50. That is one reason why I added the graph with the distance.
I tried to get these side by side, but when doing so it seemed kind of small. If anyone has any ideas on how to play and resize images with a post, let me know.
The next set filters out 'CrunchTime'. I defined this to be in the last 2 minutes of each half.
This is 'CrunchTime' only.
After yesterday's game, I was questioning the lack of a commitment to the running game especially after we had some decent runs. This is nothing new, but being a numbers guy I decided if I could find a way to get more insight into what we've actually been doing from a play call perspective.
I found this site where someone has gotten all the play by play data from publicly available sources and created files since 2013. I've got access to some cool tools at work, so I took those files, merged them, and loaded them up to run some reports to see what I see. What I have below is a first pass at breaking down our play calls from the 2014-2016 seasons. There is more I want to do with this, but thought I'd throw what I have now to see if it sparks any ideas on how to break it down further. For example, I'd love to throw in some variables of how the score may dictate the calls. Unfortunately, the files don't have that information. I did however try to make an attempt at seeing if the calls changed based on end of half/end of game.
Like I said, I just started and plan to do more. If you have any thoughts on ways to slice the data let me know and I'll see what I can do.
This is a breakdown of all our plays on 1st, 2nd, and 3rd down. The left shows pure numbers, the left normalizes the data so you can visualize percentages and then further breaks it down by Distance. When I first looked at overall play calls on first down, I was surprised to see it was almost 50/50. That is one reason why I added the graph with the distance.
I tried to get these side by side, but when doing so it seemed kind of small. If anyone has any ideas on how to play and resize images with a post, let me know.
The next set filters out 'CrunchTime'. I defined this to be in the last 2 minutes of each half.
This is 'CrunchTime' only.