fantasy football schedule analysis
i created a spreadsheet that automatically counts the number of favorable and unfavorable matchups as indicated by each team's color code.
favorable and unfavorable matchups were determined through a balance of factors including DVOA, yards per game, QBR (for passing) and yards per carry (for rushing).
this sheet allows a user (playing fantasy football) to determine a player's strength of schedule and make decisions based on that knowledge from matchups that have passed and of those in the future. for example, the user might see that a player's increased production coincides with a string of favorable matchups. seeing that matchups ahead are much more unfavorable, the user may opt to trade his player at the peak of his value, knowing that it will likely decrease in the near future.
program used: microsoft excel