In a recent fit of paralyzing obsession, I devoted myself to the task of making an Excel formula that could calculate a quarterback's NFL passer rating (there's actually another formula for the NCAA passer rating, at least according to Wikipedia, that source of heinous lies).
The formula takes, as input, the quarterback's completion percentage, yards/attempt, touchdowns/attempt (%), interceptions/attempt (%).
Here's the formula:
B1 = completion percentage (%)
B2 = yards/attempt
B3 = touchdowns/attempt (%)
B4 = interceptions/attempt (%)
I thought that it was pretty cool. It's a quick and easy way to evaluate and compare quarterbacks not in the NFL (i.e. quarterbacks without calculated ratings at NFL.com). It was also a good way to learn about Excel conditional logic, which is probably one of those irritatingly "good-to-know" gems.
Have fun calculating NFL passer ratings! I'll have a research-heavy post up soon.