DIY Third Down Stats

Hello persons from around the Internets. For context on the below, see Part I for an extensive discussion of what exactly is going on here (warning: math) and Part II for some examples of why I think this is a useful exercise.

(Performance note: generating these graphs is a dynamic process, so they can take several seconds if no one else has looked at the requested data recently. Cached ones should come up immediately.)

First: Third down efficiency. The thick line in the center is the NCAA average (e.g., approximately 68% of third and ones were converted last year). There is a second line that represents an individual team's third down efficiency. Where there is a gap between the lines that gap is filled in with either red or green depending on whether it is "good" or "bad". Being above the line is good for offenses--you convert more often. Being above the line is bad for defenses--you are converted upon more often. You want to see a lot of green in these graphs.

Second: Third down distance distribution. Again, the line in the center is the NCAA average and the thinner line is the individual team's. Green is just "above"; red just "below," since there's no clear distinction on good or bad based solely on what side of the line you're on.

Third: the raw numbers. The following graph shows the underlying data used to construct the first two. Each bar represents one yard line. Blue segments are failed conversions. Red segments resulted in first downs.

(A note on reproducing these graphs: feel free. Right click and "Save As" to get a static copy that won't break if I decide to change the URL... which I might. Please drop a link. Also: if the idea of maize and blue on your site is revolting, you can give me two other colors (specified in hex--ie, #A30924--, please) and get pretty team-color-appropriate ones.)