Football data-science

The way the football data-science "program" works is we are given scrimmage
and practice data, in the form of a microsoft excell spreadsheet, of the team our school will be playing next Friday. We are then left to
analyze it as we see fit, looking for a pattern that could give our side some sort of edge. While it is an interesting
experiment in analytics and organizing info, I usually wind up doing the same 10 minute procedure every Friday because I don't know excell
that well and I also have other stuff to work on.

What I usually do is I use a pivot table to compare the team's off. form with it's off. play and figure out what's the % likelihood
that they would run this play in this formation. Here's an example of some data analysis on Kenston's team.
The words highlighted green are the off. forms and the words highlighted white are the off. plays.


Example: The offense have a 14.29% chance of running the play "Exchange seam"
when they are lined up in the "Empty" formation.