Klipfolio - Strava dashboard.
Klipfolio - Strava dashboard.

statistics (10)

Patrick

Flink And The Magic Of Google Sheets

Bike statistics in a Data Studio report.

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.

Continue reading...
Patrick

Cycling Statistics

Klipfolio Strava dashboard version 6 (last one).

I joined Strava in August of 2011 and have been using it ever since. I don't dig into the numbers much, nor do I ride with any particular goals. Cycling is mainly a way to stay in shape, enjoy the outdoors and have fun. Strava just offers a social connection with like-minded athletes all over the world. It's a great way to stay in touch with people I've ridden and a great place to make new connections. Besides the social aspect of the site, it's also a great activity journal. Based on the data Strava collects, I've maintained the following separate cycling statistics:

  • Bike Statistics: Yearly distance ridden, elevation climbed, hours ridden and number of rides grouped by bike used.
  • Yearly Statistics: Monthly distance ridden, elevation climbed, hours ridden and number of rides since 2012.
  • Two Year Comparison Statistics: Distance and time comparison between two years starting from 2012.
  • Ride Type Statistics: Number of rides between 2012 and the present based on type of ride (road, cross, mountain, fat).
Continue reading...