Bike statistics in a Data Studio report.
Bike statistics in a Data Studio report.

Flink And The Magic Of Google Sheets

I've been using the flink.run app to add my Strava data to a Google sheet with a bunch of additional tables that crunch the numbers. Each time I add an activity to Strava, flink.run adds a new row to the data table in my Google sheet. The stats in all the other calculated tables are therefore always up to date.

I sent my FortyFour Big Boy fat-bike into retirement and wanted to look up my first ride on it. On Strava there's no easy way to find the first activity with a specific gear. In my Google sheet it's a simple formula to look for the first occurrence of a specific gear within the activity table. Since I was at it, I added a first ride and last ride column to my gear table.

Table in Google Sheets.
Bike stats table in Google Sheets.

Of all the bikes I've used since joining Strava, I've done the most rides and spent the most hours on my good old 44 Big Boy. 258 rides and 907 hours. No other bike comes even close to that. When it comes to total distance and total elevation, it's obviously a road bike that takes the top spot. It's my red Volagi Viaje RD, which I sold last year.

Having the total distance and total time for each bike, one can also calculate the average speed for each bike, which reveals some interesting results. My stainless steel Ritte road bike with a weight of about 8.4 kg is my fastest bike. It even managed to beat a much more aero carbon Neilpryde Alize, which at 6.8 kg was considerably lighter too. That's kind of nice actually since I've gotten older as well. Older dude on heavier and less aero bike has managed to keep his average speed. Nice!

The same is actually the case for my 29er mountain bikes. I was faster on both my steel Kid Dangerous and Marauder than on the 2 kg lighter Niner Air 9 Carbon. I did however climb more per mile on the Niner than the Marauder for instance, which means that on average rides on that bike were steeper. On the other hand, the average ride distance on the Niner was less than on the Marauder.

Lastly, looking at the Volagi Viaje SL and RD one could say that I'm about 1 km/h slower than on a road bike with skinny tires. But since I ride alone and don't have to keep up with anyone, who cares? The 27 rides on the Albarda, many of them on icy or snow covered roads, aren't yet a representative sample of rides. Average speed of that bike currently is closer to the three bikes I primarily rode on gravel; the two Focus and the Viaje CX.

This article was updated on October 11, 2020

Patrick

Mountains are not stadiums where I satisfy my ambition to achieve, they are the cathedrals where I practice my religion; always on two wheels, no suspension and certainly no flipping motor.

Comments