At many, many points this weekend, you will hear about how the Super Bowl will be won in the trenches. You’ll hear it during the pregame in between James Brown throwing it to a special commentary from Lou Dobbs. You’ll hear it during the game from Troy Aikman, because Aikman is a living soundboard of football clichés (“Tell you what Joe, someone needs to step up here”). And you’ll hear it during the postgame as the winning team gets bukkake’d by confetti. I glaze over that strain of commentary every time because A) it’s always been a fundamental given in this sport, and B) I can see, with my own two eyes, who’s winning in the trenches. I saw it all through the Niners’ playoff run, when Raheem Mostert was already four yards downfield before a defender even got to shake his hand. Their dominance along both lines was obvious. But then I thought to myself… can’t there be a stat for that?
Ladies and gentlemen of the internet, I have created one. I call it Scrimmage Ratio, and it’s a pretty good indicator of why the Chiefs have no business being favored to win this game.
Lemme explain how the ratio works. First of all, someone posts a really shitty tweet, and then … nah nah I’m just fucking with you. What I did was I went to Pro Football Focus and looked up the game grades for every O-lineman, D-lineman, linebacker, and tight end (the TEs’ blocking stats only). I did this for all four playoff games involving the Chiefs and Niners thus far. For each of those games, I listed the grades all down on a spreadsheet: The Chiefs’ offensive grades against the Texans’ defensive grades and vice versa, etc. Then I averaged out those grades on either side and calculated the differences, like so:
KC OFFENSE | HOU DEFENSE | KC DEFENSE | HOU OFFENSE | |
---|---|---|---|---|
70.5 | 72.5 | 68.9 | 74.8 | |
79.5 | 72.4 | 64.6 | 72.5 | |
78.9 | 63.7 | 59.8 | 71.4 | |
74.6 | 50.3 | 54 | 70.6 | |
64.3 | 49.6 | 47.5 | 57.5 | |
56.4 | 39 | 44.8 | 62.4 | |
424.2 | 57.5 | 51.2 | 409.2 | |
70.7 | 405 | 390.8 | 68.2 | |
57.9 | 55.8 | |||
RATIO | (+)12.8 | (-)12.4 | ||
NET RATIO | (+)0.4 |
To use this spreadsheet as an example, the Chiefs had a Scrimmage Ratio of +12.8 when they were on offense against Houston, and they had a Scrimmage Ratio of -12.4 when they were on defense. That gives them a net Scrimmage Ratio of +0.4 for the entire game. By contrast, here are how the ratios came out for the Niners in their thrashing of Minnesota:
SF OFFENSE | MIN DEFENSE | SF DEFENSE | MIN OFFENSE | |
---|---|---|---|---|
82.8 | 83.5 | 91.6 | 61.9 | |
78.8 | 67 | 91.2 | 57.1 | |
75.9 | 61.1 | 88.8 | 51.1 | |
73 | 53.2 | 79.5 | 50.7 | |
75.6 | 52.7 | 75.4 | 30.1 | |
66 | 52.5 | 72.4 | 61.3 | |
452.1 | 48.2 | 58.1 | 312.2 | |
75.4 | 418.2 | 557 | 52 | |
59.7 | 79.6 | |||
RATIO | (+)15.7 | (+)27.6 | ||
NET RATIO | (+)43.3 |
If you look at the NFC title game, the Niners ended up with a net Scrimmage Ratio of +18.9 after tearing the Packers limb from limb. The Chiefs, by contrast, actually LOST the ratio in the AFC title game by a difference of -2.9 to the Titans.
There are flaws in this metric, because of course there are. First of all, I’m going by PFF grades that, for all I know, Cris Collinsworth pulled out of his bengalhole. I also didn’t include situational players, such as designated third-down pass rushers. Also, I didn’t factor in fullbacks, because so many teams don’t use them. This does a disservice to the Niners, because Kyle Juszczyk is an All-Pro. I also used averages instead of medians. I could have tried it both ways, but honestly it was too much work. I feel like I just did my taxes.
This stat also doesn’t account for turnovers or special teams, which of course played a huge role in KC ripping off back-to-back hilarious comebacks to get here. The Chiefs are so good OFF the line of scrimmage that Pat Mahomes and his arsenal can help compensate when their line players are overmatched. They’ve gonna need to compensate again on Sunday because the ratio has the Niners at an advantage on both sides of the line, particularly, in a twist, on offense.
KC OFFENSE | SF DEFENSE | KC DEFENSE | SF OFFENSE | |
70.6 | 90 | 53.5 | 78.7 | |
70.3 | 88.7 | 63.9 | 67.9 | |
88 | 80.8 | 72.2 | 71.4 | |
63.5 | 63.3 | 61.2 | 63.8 | |
59.4 | 60.4 | 69.2 | 69.7 | |
70.6 | 66.6 | 46.3 | 70.5 | |
422.4 | 67.9 | 51.1 | 422 | |
70.4 | 517.7 | 417.4 | 70.3 | |
74 | 59.6 | |||
RATIO | (+)3.6 | (+)10.7 | ||
NET RATIO | SF (+)14.3 |
Those are season grades averaged out against one another. The Niners’ aggregate scrimmage ratio in the playoffs thus far has been +63.2. The Chiefs’ has been -2.5. One of these teams is pretty good in the trenches. One is provably, and visibly, better. This time around, the Chiefs won’t get the benefit of Bill O’Brien shitting his khakis on the sideline when it matters most. They’ll have to play beyond their means on both lines and hope the Niners’ beefers come out flat on the opposite side. They got away with being outplayed in there two weeks ago. They won’t this time. The ratio doesn’t lie. I know because I invented it.
NOoooooorm! says:
I just came in here to say that Chris Collinsworth’s Bengalhole is my new band name.
January 31, 2020 — 3:33 pm
Diminishing Skills says:
I never wanted to think about Chris Collinsworth’s Bengalhole but all I can now think about is Chris Collinsworth’s Bengalhole.
Chris Collinsworth’s Bengalhole thrashes in a Tuvaluan slitdrum cum Mongolian death metal screaming with a soupcon of Ska.
January 31, 2020 — 4:39 pm
Chris Collinsworth’s Bengalhole says:
Damnit, beat me to it
February 2, 2020 — 3:03 pm
SevereButthole says:
can we apply an analytics exercise to, like, poop or something
January 31, 2020 — 3:36 pm
xMRNUTTYx says:
*scrolls through, sees a table*
NERRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRD
January 31, 2020 — 3:37 pm
OldManInSeattle says:
10 If team has won the Super Bowl in last 3 years
8 if an opponent is going to their first Super Bowl
8 to the team that allows fewer defensive rushes
7 give to team with most offensive rushes
7 award the team with best overall record (straight up)
5 to the team with the lowest def. rush average per carry
4 give 4 pts. to the team with the better ATS record
4 to the team that has the superior NET penalty yards
4 to the team with the best NET kick-punt TD returns
3.5 team with the best yds per pass attempt
3.5 to the team that gave up the fewest points
3.5 allowed the fewest rushing TD’s
3 award 3 points to the team with the most sacks
2.5 team with the fewest offensive pass attempts
2 team with the best NET punts (total) on the season
1.5 add to the team with the best avg. per off. rush
1 add 1 to the team with the best completion percent
In honor of Hank Stram and the Chiefs making The Bowl after 50 years I’m using his formula to predict The Bowl winner. It returned a 48/11.5 score, a difference of 36.5 and 12 catagories to 3.
I’m the 1st to say the game has changes a lot since Hank’s day and what was once an undefeated formula has a few losses the last 20 years but still wins more than not.
For this reason I’m picking the 49ers to win and win big. I’ll take 3 scores and call it 48 – 27.
January 31, 2020 — 3:37 pm
RedMenace75 says:
Haven’t something like half the losses come in the last 4 years?
February 1, 2020 — 8:58 am
Anonymous says:
wait what? why are you going so deep on this random 49ers – Chiefs game when The Big Game is this Sunday? no one is going to watch this
January 31, 2020 — 3:40 pm
Brother Goodell says:
Drew is NOT a cancucklehead, which is why Deadspin no longer exists
January 31, 2020 — 6:48 pm
MemeWeaver says:
And they called it “Magary Ratio”.
January 31, 2020 — 3:41 pm
howdoimakeaburner says:
Why not call it the “rule of thumb”
…ok now quick someone post the gif.
January 31, 2020 — 3:56 pm
Hurt Reynolds says:
Ok, folks, pack it up. We’re done here.
February 1, 2020 — 11:33 pm
LacesOutDan says:
And the offensive linemen Excel nerds rejoiced
January 31, 2020 — 7:30 pm
Aquacow says:
Listen Drew, if either of these teams want to win then they’re going to have to score more points than the other team. That’s just football.
January 31, 2020 — 3:42 pm
Voodooman says:
I mean listen, if you want to water down football to simply who scores more points as an indicator of victory, that’s fine. But maybe leave the analysis to the real experts…and factors like Mahomes being 11-2 in games played under a waning moon, with Jupiter in ascendancy.
January 31, 2020 — 5:30 pm
LongbowMkII says:
+1
February 1, 2020 — 10:07 am
BRING BACK FOODSPIN TOO says:
It’s like Bill Simmons and Greggggg Easterbrooooook made a stat baby while we all watched. I feel dirty. And mathy.
January 31, 2020 — 3:42 pm
Caviar Smokeboy says:
Whats the ratio of cheesey poofs to beer that one needs to consume during each half of football.
January 31, 2020 — 3:48 pm
Got Metsmerized says:
If poofs are the only food you’re eating with your beer, there is no ratio that can save you. Unless you’re drinking Bud Light or lower ABV, in which case, why?
January 31, 2020 — 4:10 pm
Lee Carney says:
This is such a tough question, I instinctively went to write +++++++cheezy poofs, but then remembered the other option was beer….. such a tough choice
February 1, 2020 — 10:26 am
Classic says:
Yea! You are back!
January 31, 2020 — 3:49 pm
Blue Brain says:
This is not the hot take about the way to layer nachos or somesuch THAT I CAME HERE FOR.
January 31, 2020 — 3:49 pm
Garviel Loki says:
Aw, you can come up with statistics to prove anything, Drew.
January 31, 2020 — 3:54 pm
xMRNUTTYx says:
More seriously: as someone who deals with data on a pretty daily basis, the one thing you need to keep checking in your head while you do analysis is “does this result make sense?” Because you can try to find correlation between data sets, or multiply things or add things or whatever, and result in all sorts of crazy shit.
That’s one of the misconceptions about the “analytics” thing: that its just numbers out of a computer. But someone- and hopefully someone intelligent- has to be telling that computer what to do. There’s a human element of analyzing numbers that’s just fucking inherent in the process that Twitter Joe Morgans don’t understand.
My favorite example for this was back around 2010 when someone on a pretty major football site- I can’t remember if it was PFF or whatever- “developed” a new QB rating stat that showed Tim Tebow was the most efficient QB in the NFL. Mike Tanier- literally an ex-math teacher and one of the best NFL writers out there, IMHO- tore into that shit in a pretty amazing way on Football Outsiders. Essentially, the rating treated rushing attempts the same as completions, which is Trump-level stupid. Of course a QB who can’t throw a football is going to look better when you make a 1 yard QB keeper the same as a 10 yard completion. Tanier’s point was that if the result of your “analysis” is insane, then your analysis fucking sucks.
Anyway, this is all sorts of shitty, Drew. Go back to answering questions about how to wipe your ass.
Also, I miss Kinja and will never know how popular this extremely smart comment is.
January 31, 2020 — 3:54 pm
OldManInSeattle says:
Not that smart but have a star nonetheless. 😉
⭐
January 31, 2020 — 4:00 pm
LamarJacksonShellacsPats says:
Care to elaborate on why you think this is so shitty? You only get into why an unrelated metric sucks. As someone who also deals with data on a daily basis, I think this ratio is decent if unsophisticated.
It’s certainly not “insane,” like you implied, to think that the Niners have been better in the trenches this postseason than the Chiefs. The Chiefs strengths are their weapons and unbelievably gifted QB, not the O-line or front 7.
January 31, 2020 — 4:50 pm
Sn0wSlay3r says:
“Also, I miss Kinja”
Who ever thought that would be uttered in the past couple years…
January 31, 2020 — 5:05 pm
Commentor says:
Starred. Smartish.
January 31, 2020 — 5:33 pm
Gardner Minishew is my spirit animal. says:
+1 data set
February 1, 2020 — 9:46 pm
Chris says:
I really missed this writing staff.
January 31, 2020 — 3:58 pm
TC says:
now do Grit Quotient — based on #’s of undrafted free agents, former QBs playing a different position, players described as “gym rats” and players who refer to their team’s owner with an honorific, divided by #’s of players from an FCS school
January 31, 2020 — 4:00 pm
Adam Schwartz says:
Neither team has enough high motor, blue collar lunch pail players like Edelman, Welker, or Develin to qualify
February 2, 2020 — 11:55 am
Its Kduff says:
Drew “Nate Silver” Magary
January 31, 2020 — 4:01 pm
Robot Jerry Rice says:
Chiefs: *Come out of the locker room wearing robes.*
Drew: I was wrong about everything.
January 31, 2020 — 4:04 pm
Hank says:
I’m gonna fucking cry. My life has been so… empty without y’all.
January 31, 2020 — 6:10 pm
Arby's Clerk says:
Night Wolf!
January 31, 2020 — 11:52 pm
Jersey Jim says:
Drew; I cannot even pretend to fathom WTF you are talking about. Just please write oa column on Williams-Sonoma for us simpletons. Thanks
January 31, 2020 — 4:06 pm
Hurt Reynolds says:
In case you missed it:
https://www.vice.com/en_us/article/qjd4k3/the-2019-haters-guide-to-the-williams-sonoma-catalog
February 1, 2020 — 11:37 pm
jeomk says:
my god MY GOD are these articles ever fucking readable without five ads shoehorned in the middle
January 31, 2020 — 4:11 pm
Hit Bull Win Steak says:
I dont even KNOW where to buy insurance any more.
January 31, 2020 — 5:00 pm
Gardner Minishew is my spirit animal. says:
Or ear buds. Or towels. Or what the amazon gold box was.
February 1, 2020 — 9:48 pm
Chris Collinsworth’s Bengalhole says:
I did in fact create those statistics.
January 31, 2020 — 4:16 pm
CoastersPaul says:
This is good Unnamed Temporary Sports Blog Dot Com.
January 31, 2020 — 9:07 pm
Post Karl Malone says:
I came here to avoid spreadsheets, not get sucked into them. BOOOOOOO
January 31, 2020 — 4:21 pm
Old Fat Bald Guy says:
You might really have something here. It’s reasonably simple, it’s easy to understand, and it measures a key part of the game that has always been difficult to measure. In a quarterback-glorifying era, the question of “Team A has the better QB but Team B is better otherwise, now what?” has potential to promote what passes for enlightenment in this sport.
The next step would be to give it a building-block stat that anybody can figure out, rather than trusting what PFF has figured out.
January 31, 2020 — 4:36 pm
LongTimeReaderFirstTimeCommenter says:
To think Ben Baldwin almost had me convinced of anything else.
January 31, 2020 — 4:43 pm
Cryptkeeper Al Davis says:
I’m sure this is brilliant and correct, mostly because I too expect the Niners to win.
But also, when has Drew ever analyzed something and arrived at the completely wrong conclusion?
https://theconcourse.deadspin.com/donald-trump-is-going-to-get-his-ass-kicked-on-tuesday-1788618628
January 31, 2020 — 4:50 pm
Old Fat Bald Guy says:
Too soon.
January 31, 2020 — 4:51 pm
Cryptkeeper Al Davis says:
Actually I was too late. I just realized that joke was already made about half an hour prior in the vomiting hippo story. I don’t deserve this site.
January 31, 2020 — 6:49 pm
Rim Spamfelder says:
Numbers? Stats? Spreadsheets?
Don’t be alarmed, Drew, but I think you may have suffered a head injury.
January 31, 2020 — 4:54 pm
RedMenace75 says:
Yikes. +1
February 1, 2020 — 8:59 am
DimSmellofMoose says:
Thanks.
The Chiefs are only one point favorites for a reason. The Niners are very good.
All I’ve seen this week has been OMG MAHOMES IS AMAZING, LOL THE NINERS DIDN’T DRAFT MAHOMES, and GARAPPOLO IS A POOR MAN’S RYAN TANNEHILL.
January 31, 2020 — 5:14 pm
BasketCaseSensitive says:
I would say this broke Drew’s brain, but…
January 31, 2020 — 7:20 pm
CMBoourns says:
Get out of here with your maths and your numbers.
But seriously please don’t leave.
January 31, 2020 — 8:13 pm
Big Ted says:
I dunno bout all these dang nerd numbers, but I do know KC will have a hog’s shot in a quarry of stoppin the run.
I myself side on the interests of the Chieves, That said, if’n KC find ’emselves down as little as 7-0, I’m findin myself worrieder’n a hog in a dang quarry.
Thinkin an early deficit means the Niner defense holds ’em just enough for the dang Niners to keep it on the ground ‘n’ bully the way on home. Makes me sicker’n a hog in a quarry.
Niners 24-17’s what I’m worried about. Worried’r’n a mule in a tea shop.
January 31, 2020 — 8:21 pm
The 12th Stan says:
I’ve found it funny that all the talking heads say something along the lines of “I can’t believe the Chiefs are favored!” and then follow that up with “I’m picking the Chiefs.”
January 31, 2020 — 9:44 pm
Shankless Al says:
Lions fan here. I’m sorry but what room # is where to learn how to crisp bacon correctly?
January 31, 2020 — 9:49 pm
Gardner Minishew is my spirit animal. says:
420
February 1, 2020 — 9:53 pm
Bimmergal says:
I have missed all of you wonderful commenters.
January 31, 2020 — 10:38 pm
Fakename says:
I demand a video explanation of the scrimmage ratio, with sound, and I don’t want to click anything for it to play, and it should play each time I visit a page on the site
January 31, 2020 — 11:06 pm
Birdo says:
As much as I love playing with new statistics to see if they’re viable, in this case I have to hope your ratio will get ratioed. Also so glad the crew is back in action!
February 1, 2020 — 12:09 am
BCQCPANC says:
Dammit, line up your totals! Take that extra second to insert a blank line in the column with one fewer player. Where’s a spreadsheet copy editor when one?
February 1, 2020 — 2:01 am
Spreadsheet Copy Editor says:
Where’s a spreadsheet copy editor when (*you need) one?
February 1, 2020 — 10:12 am
Lane Dash, MD says:
I don’t know if you’re actually the same person commenting under different names, or two very cool friends teaming up for Good Content, but man what a wonderful tee’d up homerun.
February 1, 2020 — 8:24 pm
Gardner Minishew is my spirit animal. says:
This is good Unnamed Temporary Sportsblog.
February 1, 2020 — 9:54 pm
Space Monkey says:
Dammit Magary, you were so close. It’s not a ratio, because you subtracted instead of dividing. What you’ve got there is a Scrimmage Separation, or Offset, or Margin. Math and grammar pedants (*ahem*) everywhere will be outraged.
February 1, 2020 — 3:41 am
oldnumberseven says:
I have read all these comments on this excellent article in the voices of various ‘It’s Always Sunny in Philadelphia’ characters. I hope you are all happy with yourselves.
February 1, 2020 — 4:06 am
Ceramics says:
Drew! Great to read you again. I’ve missed your voice.
February 1, 2020 — 7:35 am
Carl Spackler says:
I thought that Big Game analysis was a dead topic, so it’s good to see someone put a new spin on it. This feller hopes that “temporary” spans the generations.
February 1, 2020 — 8:20 am
Nigel the pedant says:
Those aren’t ratios, those are differences.
February 1, 2020 — 8:58 am
Hurt Reynolds says:
I was just going to shame you for your pedantry, but I see you’ve preempted me. Well played.
February 1, 2020 — 11:43 pm
LongbowMkII says:
If there’s one thing Kyle Shanahan is known for its not shitting his khakis during the super bowl
February 1, 2020 — 10:02 am
John says:
Thank you. I miss this blog so damn much. I am writing to point out that Drew has calculated differentials, not ratios. The article and supporting spreadsheets make much more sense if you make this correction. Moreover, I hate to mention that Peter King made this same exact mistake when he referred to a qb’s td-int differential as a ratio in his old MMQB column.
February 1, 2020 — 11:56 am
David Dyte says:
I love this, except that it’s a difference and you are calling it a ratio.
February 1, 2020 — 3:56 pm
Burt Thaxton says:
PLS JUST KEEP THIS BLOG AND MONETIZE IT.
Drew we have this guy here in CLEVELAND named PAUL FUCKIN DEPODESTA and he will THINKOVATE the BROWNS to a title. He may be keen on you THINKOVATING this in the Browns front office.
KEY LEARNINGS AND INFOCISIONS BRO. BROWNS FOOTBALL.
February 1, 2020 — 9:19 pm
Adam Schwartz says:
For everyone else who also believes Russell Wilson is a robot, the events that took place five years ago have rendered the Seahawks as irrelevant as Rodgers and company up in Cheeseland. That is all
Signed
– 5 years later and still salty af about The Interception
February 2, 2020 — 12:00 pm