RandyMossIsBoss Posted July 26, 2020 Share Posted July 26, 2020 Pass Rush and Tackles since 2018 ProFootballReference since 2018 has had these cool advanced stats. All their defensive ones are here, and included on every player page. In the above excel doc, I put the top 100 in sacks in each of the past 2 seasons, and then all players with at least 50 tackles for each season. For pass rush, I set it up so we could assign 1 number to a players pass rush proficiency. You can sort by pressures (sacks + knockdowns + hurries) on PFR, but the issue there is that a sack is worth much more than a hurry. How much? Well that's why I left the document editable, you can play around with it and assign your own value to each stats. I didn't put too much thought into it, but I went with 1 a for sack, 0.5 for a knockdown and 0.3 for a hurry. I also added positions (roughly accurate) so you can sort by that as well. (not very excel savvy, couldn't figure out how to involve the multiplier unless it was part of the table... if somebody wants to go in and change that feel free. I envisioned a few cells at the top of the workbook with the multipliers, and then the formula for the totals could just reference those multipliers so you only have to edit those 3 cells rather than edit the multipliers cells and then paste them across whole table. Could only figure out how to do it manually for every row.) Top 10 pass rushers since 2018 (1*sack, 0.5*QBKd, 0.3*hurry) Player Tm Pos Games Sk QBKD Hrry 1 2 3 Total Per Game 1 Aaron Donald LAR 3-4 DE 32 33 28 62 1.0 0.5 0.3 67 2.11 2 J.J. Watt HOU 3-4 DE 24 20 23 39 1.0 0.5 0.3 44 1.85 3 Myles Garrett CLE 4-3 DE 26 23.5 22 29 1.0 0.5 0.3 44 1.70 4 T.J. Watt PIT 3-4 OLB 32 27.5 26 41 1.0 0.5 0.3 54 1.69 5 Joey Bosa LAC 4-3 DE 23 17 19 33 1.0 0.5 0.3 37 1.63 6 Chris Jones KAN 4-3 DT 29 24.5 24 26 1.0 0.5 0.3 45 1.55 7 Khalil Mack CHI 3-4 OLB 30 21 14 56 1.0 0.5 0.3 46 1.55 8 Cameron Jordan NOR 4-3 DE 32 25.5 13 51 1.0 0.5 0.3 49 1.53 9 Chandler Jones ARI 3-4 OLB 32 32 11 34 1.0 0.5 0.3 49 1.52 10 Za'Darius Smith 2 3-4 OLB 32 22 35 25 1.0 0.5 0.3 48 1.49 Top 10 tacklers since 2018 (min 100 tackles) Player Tm Pos Tackles Missed Missed% 1 Lawrence Guy NWE DT 120 3 2.4% 2 Taylor Rapp LAR S 100 3 2.9% 3 Bobby Wagner SEA ILB 297 11 3.6% 4 Rashaan Melvin DET CB 124 6 4.6% 5 De'Vondre Campbell ATL OLB 223 11 4.7% 6 Michael Brockers LAR DE 117 6 4.9% 7 Kevin Byard TEN S 174 9 4.9% 8 Cameron Heyward* PIT DE 134 7 5.0% 9 Kenny Vaccaro TEN S 142 8 5.3% 10 Cory Littleton LAR ILB 259 15 5.5% 2 Quote Link to comment Share on other sites More sharing options...
BleedTheClock Posted July 26, 2020 Share Posted July 26, 2020 Not at all surprised to see Taylor Rapp up there. Love that dude. He’s going to be a great safety for a long time. Quote Link to comment Share on other sites More sharing options...
Daniel Posted July 26, 2020 Share Posted July 26, 2020 Titans fans keep telling yall Byard is the best. 17 Ints since 2018 and one of the NFL’s best tacklers. Nice. 2 Quote Link to comment Share on other sites More sharing options...
ET80 Posted July 26, 2020 Share Posted July 26, 2020 JJ Watt is 2nd behind Donald since 2018!? That's the last thing I expected. I mean, I know he's still great, but I didn't think he was still that productive since his litany of injuries... Kind of makes you wonder if he didn't have those back/core injuries to deal with back in 2016 - what would he be now? Quote Link to comment Share on other sites More sharing options...
Shanedorf Posted July 26, 2020 Share Posted July 26, 2020 5 hours ago, ET80 said: Kind of makes you wonder if he didn't have those back/core injuries to deal with back in 2016 - what would he be now? A Green Bay Packer Quote Link to comment Share on other sites More sharing options...
ET80 Posted July 26, 2020 Share Posted July 26, 2020 2 minutes ago, Shanedorf said: A Green Bay Packer If he ain't there now, he ain't ever gonna be. He's headed to Pittsburgh if anything... Quote Link to comment Share on other sites More sharing options...
scar988 Posted July 27, 2020 Share Posted July 27, 2020 16 hours ago, ET80 said: If he ain't there now, he ain't ever gonna be. He's headed to Pittsburgh if anything... naw man. He's running his ultimate tag league. He's retiring before he would leave Houston to do that. Quote Link to comment Share on other sites More sharing options...
ET80 Posted July 27, 2020 Share Posted July 27, 2020 3 minutes ago, scar988 said: naw man. He's running his ultimate tag league. He's retiring before he would leave Houston to do that. "Staying in Houston" is still on top of the leaderboard, I'll admit that. He could run for Mayor here and probably win unanimously (unless Hakeem Olaijuwon or Nolan Ryan ran against him...) Pittsburgh would be a long shot, but I'd put that over GB. Darkhorse contender would be Chicago - Kealia is still playing, so he'd probably want to be closer to her. Quote Link to comment Share on other sites More sharing options...
scar988 Posted July 28, 2020 Share Posted July 28, 2020 On 7/27/2020 at 9:51 AM, ET80 said: "Staying in Houston" is still on top of the leaderboard, I'll admit that. He could run for Mayor here and probably win unanimously (unless Hakeem Olaijuwon or Nolan Ryan ran against him...) Pittsburgh would be a long shot, but I'd put that over GB. Darkhorse contender would be Chicago - Kealia is still playing, so he'd probably want to be closer to her. I think if he's moving to Chicago, it's because he's retiring. He's entering his 10th season. That's a long-enough career. I don't see him leaving Houston unless it's because he's coaching. Quote Link to comment Share on other sites More sharing options...
ET80 Posted July 28, 2020 Share Posted July 28, 2020 Just now, scar988 said: I think if he's moving to Chicago, it's because he's retiring. He's entering his 10th season. That's a long-enough career. I don't see him leaving Houston unless it's because he's coaching. Retirement is Wisconsin ...or Los Angeles to start up a movie career. John Krasinkski, Emily Blunt, Zac Efron and JJ Watt as the Fantastic 4 in the MCU? Eh? Quote Link to comment Share on other sites More sharing options...
scar988 Posted July 28, 2020 Share Posted July 28, 2020 1 minute ago, ET80 said: Retirement is Wisconsin ...or Los Angeles to start up a movie career. John Krasinkski, Emily Blunt, Zac Efron and JJ Watt as the Fantastic 4 in the MCU? Eh? I think it's Chicago until his wife is retired from soccer. Once she's done, it's probably NY for TV. He seems to have a blast doing the ultimate tag thing. I wonder if he could just be the goofy sports guy. Quote Link to comment Share on other sites More sharing options...
ET80 Posted July 28, 2020 Share Posted July 28, 2020 Just now, scar988 said: I think it's Chicago until his wife is retired from soccer. Once she's done, it's probably NY for TV. He seems to have a blast doing the ultimate tag thing. I wonder if he could just be the goofy sports guy. He's got inroads with Schwarzenegger and Dwayne Johnson - he might not plan on a Hollywood career, but he'll be in some action movie within the next 10 years. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.