Here you go, Mike. You can copy and paste this into Excel without issue, I think. This excludes postseason but should cover everything you need.
Here’s how to read the say, Aaron Rodgers line. His first year was 2005. He has thrown 297 TD passes. He is a HOFer with an asterisk since he, Brady, Manning, and Brees are not yet in. He has 19 TD passes from the 1, 15 from the 2, 20 from the 3, 15 from the 4, and 22 from the 5. The next five columns show his percentage of TD passes, which is just that number divided by 297. So he has 5.05% of his TD passes come from exactly the 4-yard line. Finally, the last column shows that he has 18.2% of his TD passes come from within 3 yards, which of course is just the sum of the numbers in columns 1-3.
1st yr | Player | TDs | HOF | 1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 4 | 5 | # from within 3 | Rk |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2009 | Matthew Stafford | 187 | 0 | 20 | 13 | 11 | 6 | 13 | 0.107 | 0.07 | 0.059 | 0.032 | 0.07 | 0.235 | 1 |
1997 | Jake Plummer | 161 | 0 | 16 | 13 | 8 | 10 | 5 | 0.099 | 0.081 | 0.05 | 0.062 | 0.031 | 0.23 | 2 |
2008 | Matt Ryan | 240 | 0 | 21 | 14 | 14 | 19 | 12 | 0.088 | 0.058 | 0.058 | 0.079 | 0.05 | 0.204 | 3 |
1999 | Donovan McNabb | 234 | 0 | 16 | 19 | 10 | 14 | 11 | 0.068 | 0.081 | 0.043 | 0.06 | 0.047 | 0.192 | 4 |
1998 | Kurt Warner | 208 | 1 | 18 | 15 | 7 | 13 | 16 | 0.087 | 0.072 | 0.034 | 0.063 | 0.077 | 0.192 | 5 |
2005 | Aaron Rodgers | 297 | 1* | 19 | 15 | 20 | 15 | 22 | 0.064 | 0.051 | 0.067 | 0.051 | 0.074 | 0.182 | 6 |
2001 | Drew Brees | 465 | 1* | 32 | 28 | 24 | 22 | 18 | 0.069 | 0.06 | 0.052 | 0.047 | 0.039 | 0.181 | 7 |
2000 | Tom Brady | 456 | 1* | 35 | 36 | 10 | 23 | 33 | 0.077 | 0.079 | 0.022 | 0.05 | 0.072 | 0.178 | 8 |
2004 | Carson Palmer | 285 | 0 | 20 | 10 | 20 | 16 | 15 | 0.07 | 0.035 | 0.07 | 0.056 | 0.053 | 0.175 | 9 |
1993 | Drew Bledsoe | 251 | 0 | 10 | 21 | 13 | 13 | 15 | 0.04 | 0.084 | 0.052 | 0.052 | 0.06 | 0.175 | 10 |
1999 | Matt Hasselbeck | 212 | 0 | 9 | 16 | 12 | 13 | 9 | 0.042 | 0.075 | 0.057 | 0.061 | 0.042 | 0.175 | 11 |
1994 | Brad Johnson | 166 | 0 | 10 | 5 | 13 | 5 | 10 | 0.06 | 0.03 | 0.078 | 0.03 | 0.06 | 0.169 | 12 |
2006 | Jay Cutler | 208 | 0 | 14 | 10 | 11 | 8 | 10 | 0.067 | 0.048 | 0.053 | 0.038 | 0.048 | 0.168 | 13 |
1991 | Brett Favre | 508 | 1 | 37 | 25 | 23 | 28 | 24 | 0.073 | 0.049 | 0.045 | 0.055 | 0.047 | 0.167 | 14 |
1998 | Peyton Manning | 539 | 1* | 38 | 23 | 29 | 29 | 34 | 0.071 | 0.043 | 0.054 | 0.054 | 0.063 | 0.167 | 15 |
1997 | Jon Kitna | 169 | 0 | 12 | 8 | 8 | 11 | 6 | 0.071 | 0.047 | 0.047 | 0.065 | 0.036 | 0.166 | 16 |
2005 | Ryan Fitzpatrick | 166 | 0 | 8 | 11 | 8 | 7 | 9 | 0.048 | 0.066 | 0.048 | 0.042 | 0.054 | 0.163 | 17 |
2004 | Eli Manning | 320 | 0.5 | 18 | 17 | 17 | 20 | 15 | 0.056 | 0.053 | 0.053 | 0.063 | 0.047 | 0.163 | 18 |
1983 | Dan Marino | 420 | 1 | 23 | 24 | 20 | 21 | 23 | 0.055 | 0.057 | 0.048 | 0.05 | 0.055 | 0.16 | 19 |
1994 | Mark Brunell | 184 | 0 | 6 | 10 | 13 | 10 | 7 | 0.033 | 0.054 | 0.071 | 0.054 | 0.038 | 0.158 | 20 |
2004 | Ben Roethlisberger | 299 | 0.5 | 20 | 15 | 12 | 20 | 15 | 0.067 | 0.05 | 0.04 | 0.067 | 0.05 | 0.157 | 21 |
1985 | Steve Young | 232 | 1 | 14 | 11 | 11 | 10 | 12 | 0.06 | 0.047 | 0.047 | 0.043 | 0.052 | 0.155 | 22 |
2005 | Alex Smith | 157 | 0 | 6 | 10 | 8 | 6 | 8 | 0.038 | 0.064 | 0.051 | 0.038 | 0.051 | 0.153 | 23 |
1995 | Kerry Collins | 208 | 0 | 16 | 11 | 4 | 6 | 13 | 0.077 | 0.053 | 0.019 | 0.029 | 0.063 | 0.149 | 24 |
1997 | Trent Green | 162 | 0 | 9 | 3 | 12 | 4 | 4 | 0.056 | 0.019 | 0.074 | 0.025 | 0.025 | 0.148 | 25 |
1984 | Warren Moon | 291 | 1 | 5 | 20 | 18 | 9 | 15 | 0.017 | 0.069 | 0.062 | 0.031 | 0.052 | 0.148 | 26 |
1987 | Vinny Testaverde | 275 | 0 | 20 | 8 | 12 | 11 | 15 | 0.073 | 0.029 | 0.044 | 0.04 | 0.055 | 0.145 | 27 |
1977 | Tommy Kramer | 159 | 0 | 6 | 9 | 8 | 5 | 5 | 0.038 | 0.057 | 0.05 | 0.031 | 0.031 | 0.145 | 28 |
1995 | Steve McNair | 174 | 0 | 10 | 9 | 6 | 14 | 8 | 0.057 | 0.052 | 0.034 | 0.08 | 0.046 | 0.144 | 29 |
2004 | Tony Romo | 248 | 0.5 | 11 | 16 | 8 | 16 | 10 | 0.044 | 0.065 | 0.032 | 0.065 | 0.04 | 0.141 | 30 |
1979 | Joe Montana | 273 | 1 | 13 | 16 | 8 | 11 | 11 | 0.048 | 0.059 | 0.029 | 0.04 | 0.04 | 0.136 | 31 |
1985 | Randall Cunningham | 207 | 0 | 7 | 10 | 11 | 9 | 9 | 0.034 | 0.048 | 0.053 | 0.043 | 0.043 | 0.135 | 32 |
1989 | Troy Aikman | 165 | 1 | 6 | 10 | 6 | 8 | 12 | 0.036 | 0.061 | 0.036 | 0.048 | 0.073 | 0.133 | 33 |
1986 | Jim Everett | 203 | 0 | 12 | 8 | 7 | 14 | 6 | 0.059 | 0.039 | 0.034 | 0.069 | 0.03 | 0.133 | 34 |
1986 | Jim Kelly | 237 | 1 | 11 | 10 | 10 | 9 | 3 | 0.046 | 0.042 | 0.042 | 0.038 | 0.013 | 0.131 | 35 |
1999 | Jeff Garcia | 161 | 0 | 7 | 4 | 10 | 9 | 10 | 0.043 | 0.025 | 0.062 | 0.056 | 0.062 | 0.13 | 36 |
1983 | John Elway | 300 | 1 | 14 | 11 | 14 | 13 | 13 | 0.047 | 0.037 | 0.047 | 0.043 | 0.043 | 0.13 | 37 |
1987 | Rich Gannon | 180 | 0 | 4 | 12 | 7 | 10 | 9 | 0.022 | 0.067 | 0.039 | 0.056 | 0.05 | 0.128 | 38 |
1990 | Jeff George | 154 | 0 | 7 | 5 | 7 | 7 | 10 | 0.045 | 0.032 | 0.045 | 0.045 | 0.065 | 0.123 | 39 |
2004 | Philip Rivers | 314 | 0.5 | 17 | 9 | 12 | 15 | 18 | 0.054 | 0.029 | 0.038 | 0.048 | 0.057 | 0.121 | 40 |
1984 | Boomer Esiason | 247 | 0 | 10 | 9 | 10 | 8 | 14 | 0.04 | 0.036 | 0.04 | 0.032 | 0.057 | 0.117 | 41 |
1978 | Steve DeBerg | 196 | 0 | 11 | 4 | 8 | 10 | 9 | 0.056 | 0.02 | 0.041 | 0.051 | 0.046 | 0.117 | 42 |
1971 | Ken Anderson | 197 | 0 | 5 | 7 | 10 | 6 | 6 | 0.025 | 0.036 | 0.051 | 0.03 | 0.03 | 0.112 | 43 |
2008 | Joe Flacco | 182 | 0 | 10 | 4 | 6 | 4 | 10 | 0.055 | 0.022 | 0.033 | 0.022 | 0.055 | 0.11 | 44 |
1971 | Jim Plunkett | 164 | 0 | 4 | 7 | 7 | 5 | 4 | 0.024 | 0.043 | 0.043 | 0.03 | 0.024 | 0.11 | 45 |
1976 | Danny White | 155 | 0 | 6 | 7 | 4 | 6 | 5 | 0.039 | 0.045 | 0.026 | 0.039 | 0.032 | 0.11 | 46 |
1970 | Ken Stabler | 194 | 1 | 4 | 6 | 10 | 8 | 5 | 0.021 | 0.031 | 0.052 | 0.041 | 0.026 | 0.103 | 47 |
1974 | Joe Theismann | 160 | 0 | 6 | 2 | 8 | 9 | 6 | 0.038 | 0.013 | 0.05 | 0.056 | 0.038 | 0.1 | 48 |
1970 | Terry Bradshaw | 212 | 1 | 5 | 6 | 9 | 5 | 11 | 0.024 | 0.028 | 0.042 | 0.024 | 0.052 | 0.094 | 49 |
1980 | Dave Krieg | 261 | 0 | 7 | 10 | 7 | 12 | 16 | 0.027 | 0.038 | 0.027 | 0.046 | 0.061 | 0.092 | 50 |
1973 | Joe Ferguson | 196 | 0 | 5 | 4 | 8 | 10 | 11 | 0.026 | 0.02 | 0.041 | 0.051 | 0.056 | 0.087 | 51 |
1973 | Dan Fouts | 254 | 1 | 8 | 3 | 10 | 10 | 10 | 0.031 | 0.012 | 0.039 | 0.039 | 0.039 | 0.083 | 52 |
1969 | Roger Staubach | 152 | 1 | 3 | 6 | 3 | 9 | 4 | 0.02 | 0.039 | 0.02 | 0.059 | 0.026 | 0.079 | 53 |
1988 | Chris Chandler | 170 | 0 | 4 | 3 | 6 | 7 | 7 | 0.024 | 0.018 | 0.035 | 0.041 | 0.041 | 0.076 | 54 |
1974 | Ron Jaworski | 179 | 0 | 2 | 6 | 5 | 6 | 9 | 0.011 | 0.034 | 0.028 | 0.034 | 0.05 | 0.073 | 55 |
1974 | Brian Sipe | 154 | 0 | 2 | 4 | 5 | 8 | 8 | 0.013 | 0.026 | 0.032 | 0.052 | 0.052 | 0.071 | 56 |
1975 | Steve Grogan | 182 | 0 | 3 | 5 | 3 | 8 | 6 | 0.016 | 0.027 | 0.016 | 0.044 | 0.033 | 0.06 | 57 |
1979 | Phil Simms | 199 | 0 | 4 | 4 | 4 | 8 | 7 | 0.02 | 0.02 | 0.02 | 0.04 | 0.035 | 0.06 | 58 |
1975 | Steve Bartkowski | 156 | 0 | 2 | 1 | 4 | 4 | 6 | 0.013 | 0.006 | 0.026 | 0.026 | 0.038 | 0.045 | 59 |
Average | 231.9 | 11.8 | 10.8 | 10.3 | 11.1 | 11.3 | 0.051 | 0.047 | 0.044 | 0.048 | 0.049 | 0.142 |
Other note: I included Staubach (whose career started in ’69, when he threw 1 TD): he is the only pre-70 QB on here, but I did it just because. I excluded his 1 TD from 1969.