statistics ⁽³⁾

Patrick January 27, 2022

Some Silly Strava Stats

As mentioned in my previous post, I recreated my Data Studio dashboard under a new Gmail account because Google’s G Suite legacy free edition, which became Google Workspace in 2020, will require a paid subscription this year. Three simple things needed to be done. First, I had to copy my Google sheet from the old account to my new account. Then, I had to create a new Zapier account, and share my zap from the old account with the new account. This was straightforward. Once logged into Zapier with my new account, I had to link the zap to my Strava account and also had to give the zap permission to modify my Google sheet. Pretty much the same procedure was necessary for the Data Studio report. I logged into the old account and shared the report with my new account. Then, I logged into the new account and had to replace the data sources to point to the Google sheet in my new Gmail account. Sounds complicated but was extremely simple.

Patrick January 5, 2021

Year 2020 In Review

In 2020 I rode 135 times or 300 hours, totaling 5’195 kilometers and climbing 144’439 meters. Due to our move in 2019, which saw my riding time greatly reduced for the second part of the year, I hoped to get back to a 2018 level in 2020. But that wasn’t possible. The pandemic had little to do with it. We had a few months with short time at work, which would have given me more time to ride. However, in early 2020 one of our cats was diagnosed with chronic kidney disease and her sister shows signs of it, too.

Patrick June 12, 2020

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.