lompik / garmin-tc-rstat

Analyse your workouts in R via Garmin Training Center

Analyse your workout in R

Since Garmin Training Center stores your data in a sqlite file, it’s now now easy to sweat while analysing your workouts.

Instructions

locating the backup files

• Usually, a *.tcd file is stored in

C:\Users\*USER*\AppData\Roaming\Garmin\TrainingCenter\Backups. You can request a new backup save via the File menu in the software.

obtaining the plots

• the backup located in the previous section is actually a SQLite file that we’ll feed to the R/graphs.R script.
• fill in your records in the R/load.R file - table Records

Example plots

Here’s a few examples based on the data from a person regularly training (running, biking, and swimming). Your imagination is the limit.

The classics

Plots similar to the one on Garmin Connect.

Total weekly distance

Monthly activity count

Activity count by year

Personal Best trends

The plots on this section outlines the PBs for Running and Biking (the red dots).

Avergare speed vs date - Running

other

HR vs Activity Starttime

Activity count by day of week

HR vs elapsed time

total distance by activity

Mosaic AvgSpeed / Avg HR per month (Running)

Notes

• Garming TC does not name on “other” activities. Those can include walking, swimming, etc
• Accuracy of the HR monitor can debated, especially after 1 year usage.
• this code is a bit old and lacking some styles that I learned later, namely pipes and javascript libs.
• Some plots needs the temperature during the activity. Look for a nearby temperature temperature station with open data. If you’re in the US there should be plenty.