Understanding NFL Comeback Chances with Data

I’m a data nerd and a casual NFL fan.  Anyone who watches NFL games knows that broadcasters demonstrate knowledge of the most obscure statistics throughout the game.  But there’s one metric that broadcasters don’t have an incentive to tell you:

When is one team so far ahead that there’s a ~zero likelihood of a comeback?

(For the optimists: Tell me if my team still has a chance!)

I decided to answer my own question by building ComebackCeiling.com.

ComebackCeiling has processed >11,000 historical NFL games to identify the point differential between teams – and at each point in the game determine the largest margin that a team has ever come back from to win (or tie/force overtime).  Additionally, I’ve calculated how that margin changes based on if the team behind is playing at home or away, and/or possession of the ball.  (I also added another line for the largest point differential ever seen at each point in the game.)

I’m launching this now because the NFL season is starts in a matter of days and I want to have this available to me as a fan. 😀 Later this year I hope to spend some time hooking it up to live sources of data and have it tweet when a game has gone past the comeback ceiling.  If you have any suggestions, reach out!

Note: I want to credit Gemini and Claude for helping me develop this.  Wrangling data and all sorts of different edge cases is fun, but my scripting skills alone are much worse compared to what I can accomplish with the help of AI.  (Also, my CSS/JS skills are nonexistent compared to AI!)  I wrote a separate (longer) blog post about how I developed the tech behind ComebackCeiling if you’re interested in those details.

Rivian vs Tesla production ramp – a 2024 Mid-year update

It’s been about a year since my last post comparing Rivian and Tesla’s production ramp, and I wanted to share an update.

Specifically, this chart compares growth of deliveries quarter-by-quarter for each company based on when each started production (Tesla = 2012 Q3, Rivian = 2021 Q3).

Rivian continues to deliver more vehicles per quarter than Tesla at the equivalent point in development. Additionally, Rivian is producing three vehicles: the R1S (SUV), the R1T (pickup truck), and two sizes of delivery vans. Based on Rivian’s guidance for 2024 (purple dashed line on the chart), this will continue for probably at least another 6-12 months.

To be fair to Tesla, Rivian has taken advantage of Tesla proving that there’s a market for electric vehicles. Rivian was likely taken more seriously by suppliers because at least there was a new all-EV car manufacturer that had been founded in recent history.

Rivian, however, started production at possibly the worst time: just as the economy saw rocketing inflation and supply chain problems throughout the automotive sector. The effects of this certainly hit their early financial results, but they’ve been making great strides in efficiency and cost-cutting, particularly with the Generation 2 updated vehicles.

Looking forward to 2025-2026

Rivian is aiming to start production of R2 vehicles in the first half of 2026. This would mean that their lower-cost / mid-range vehicle would start deliveries approximately 3-6 months ahead of Tesla at the equivalent point in development.

Tesla started Model 3 deliveries in Q3 of 2017, which aligns to Year 6 – Quarter 1 in the timeline above. If Rivian starts deliveries in Q2 of 2026, that aligns to Year 5 – Quarter 4 on the same timeline.

With Rivian saying that they’re going to start R2 vehicle manufacturing at their existing Normal, IL plant, it certainly removes a lot of risk in achieving their goal of launching in the first half of 2026. There’s no risk of construction delays, no risk of poor knowledge transfer from experienced Rivian line workers, no risk of splitting effort across two very geographically-separated plants at a key milestone, etc.

That said, at some point Rivian will need to expand manufacturing space beyond the existing Normal, IL plant if they want to scale. (The existing plant can manufacture approximately 200k -ish vehicles per year; Tesla is currently manufacturing over 400k vehicles per quarter, over multiple plants.)

I believe the interesting test for Rivian will be their ability to ramp manufacturing in 2025. Will they be able to use the newly updated Generation 2 R1 platform to drive more throughput in manufacturing? How will preparations for manufacturing the R2 platform affect throughput?

Tesla was able to continue increasing production of the Model S and Model X in the four quarters before launching the Model 3. Will Rivian be able to do the same, or will they be limited by factory space in Normal?

As a Rivian fan, I’m looking forward to seeing how the company will execute. (And really hoping they’re able to pull forward product development on the R3X – that’s a really exciting car!)

Pity Bowl – 2023 edition

College football is great – I’ve been blessed to be a Michigan alum & fan over the past three years, with three straight trips to the College Football Playoffs. #GoBlue!

But here’s what irritates me about college bowl games – there’s too damn many of them that they don’t mean much. Don’t get me wrong, it’s great around the holidays to watch football – especially when compared to the standard “nothing else good on television” fare. But I think it’s important for a football team to HAVE A WINNING RECORD to go to a bowl game.

Out of the 43 Bowl games being played by FBS schools, there are 11 bowl games where one or both teams don’t have a winning record. (Just like last year.) There are five teams below that have 7-5 (winning!) records, so 3 of the 11 games could be salvaged. That’s certainly what I would recommend.

The 2023 “Pity Bowls”

Pity Bowl GameDateTeamTeam
Independence Bowl16 DecCal (6-6)Texas Tech (6-6)
Famous Toastery Bowl18 DecWestern Kentucky (7-5)Old Dominion (6-6)
Boca Raton Bowl21 DecSouth Florida (6-6)Syracuse (6-6)
Gasparilla Bowl22 DecUCF (6-6)Georgia Tech (6-6)
Camellia Bowl23 DecArkansas State (6-6)Northern Illinois (6-6)
Famous Idaho Potato Bowl23 DecGeorgia State (6-6)Utah State (6-6)
68 Ventures Bowl23 DecSouth Alabama (6-6)Eastern Michigan (6-6)
Quick Lane Bowl26 DecBowling Green (7-5)Minnesota (5-7)
First Responder Bowl26 DecTexas State (7-5)Rice (6-6)
Pinstripe Bowl28 DecRutgers (6-6)Miami (FL) (7-5)
Music City Bowl30 DecMaryland (7-5)Auburn (6-6)

EV production ramp: Rivian, Tesla, and Lucid (2023 Q2 edition)

It’s been about four months since my last post comparing the data on the production ramp comparing the early history of Tesla and Rivian. Crucially:

  • two more quarters of data have been released
  • I’ve updated the charts so they’re more clear on the timeline
  • I’ve added Lucid Motors as an additional comparison

Production Ramp Data

Rivian continues to outpace Tesla’s production at the equivalent point in their histories, delivering >12.5k vehicles in Y2Q4, compared to Tesla’s production of >7.5k vehicles. Rivian also continues to state they’re on track to produce 50,000 vehicles in 2023, which is modeled with the “Rivian – projected” line in the chart below. (In a very naive sense of “modeled”.) Rivian should continue to outpace Tesla’s manufacturing benchmark for many quarters to come.

Lucid Motors unfortunately continues to lag behind both Tesla and Rivian at the equivalent point, only delivering 1404 vehicles in the last quarter. At the same point in their history, Rivian delivered >7900 vehicles and Tesla delivered >6400 vehicles. Lucid’s vehicles seem to be pretty fantastic and I’ve definitely seen some on the roads in the SF/Bay Area. I sincerely hope they’re able to grow.

The thing I’m perhaps most excited about for the future of Rivian is that they’re producing at least 4 different vehicles across 2 different platforms. Consumers can purchase the R1T (pickup) or R1S (SUV), and Amazon is purchasing thousands of delivery vans across two different models. At the same point in their history, Tesla was only producing the Model S.

That Rivian has managed to continue a production ramp despite the complexity of multiple vehicles and platforms speaks well to their future ability to manage a growing family of vehicles and options.

Not a neutral observer

I need to admit I’m not a neutral observer. A long-time good friend of mine was an early hire at Rivian so I’ve had positive feelings for the company for years. Also, I’m one of those 12.5k deliveries for Rivian in Q2 2023! My wife and I took delivery of our R1S (Forest Green, Forest Edge interior, 21″ wheels) in May, and we absolutely love it.