I have been tracking various workout metrics like nutrition on the bike, liquid intake, time in aero, calorie intake, carb intake, calorie deficit, etc. Up until now I have used workout annotations, but for several reasons, I think I have grown out of it. Extracting data from it is a pain and I have to do several calculations by hand that I could automate in a simple spreadsheet or so. I’d like to see trends in nutrition (e. g. have I been fueling correctly, what about my calorie deficit). Ideally, I’d something quite flexible that allows me to add more fields in the future. I know there are feature requests, but I have no idea whether and when TR will release these. So I’d like to roll my own solution. Before I create my own spreadsheet or use Notes, I wanted to ask the combined wisdom of the forum and see what y’all have been using.

TrainingPeaks allows you to export data for free. You can connect the TrainerRoad sync and add whatever you need as annotations in the description/post workout info. The resulting dataset can be analyzed in a spreadsheet. Data from the description can be pulled with regular expressions if you need it. I’ve been doing this a while ago as I also wanted better data tracking for runs and swims. It’s a mess all together. I wish TrainerRoad was better with this.

https://intervals.icu lets you track some of that: [image] and the developer (@davidtinker) takes requests. It’s all per-day though, not per-activity.

Basic nutrition and hydration data is in every one of my Garmin activity fit files. Yesterday’s workout for example: [image] Haven’t really found much value from trending it, but it’s there.

Just to add a little detail, at the end of every ride, the Garmin will ask you how much liquid you drank and how many calories you consumed, which is what fills that data in.

Oh wow! I’m an intervals subscriber and haven’t noticed this yet. I need to add it to my routine. Thanks!

@WindWarrior I’m a Wahooligan, unfortunately. But nice to know that this is an option, too. @ellotheth Thanks. That looks very similar to what you can do with TrainingPeaks. How do you get the data out of it? Or can you graph these data points yourself from within the app? Also, I am surprised nobody has mentioned the use of spreadsheets yet.

I am a sports science analyst by trade so building dashboards around my own data has become a pastime! Haha. One method I have personally liked using is a GoogleSheets document integrated with JotForm. After some initial setting up, it now just takes me 1 minute daily to enter vital info, and then the dashboard does all the work for me. [image] [image] [image] [image] The JotForm allowed me to take the highlights from various data streams (a couple data points from Oura, a couple from TrainingPeaks, my lifting loads, a couple of wellness questions, and Sessions RPEs) and enter them with one survey each day. JotForm has an integration with GoogleSheets, so you can link it to your dashboard spreadsheet, and every time you hit submit on a survey, it will dump the data onto a sheet in the doc. Then, I set up the spreadsheet to run calculations in the background so I never have to touch it. Every day it updates on its own. I just pop open the survey, punch in the vitals, hit submit, and then use the Sheets app on my phone to see the visualizations. If I need to do a deeper dive into any one area (say, sleep data), I go to the source and check out Oura’s app or export the CSV.

I’d pay for that. That sounds like a great solution: you have a nice UI and direct access to the data in a common format. Because another thing I’d like to track is my strength workouts. Hmmm, perhaps a spreadsheet with some macros is not such a bad idea after all.

[image] OreoCookie: How do you get the data out of it? Or can you graph these data points yourself from within the app? You can graph it in the app on the /fitness page, and compare different periods on the /compare page. There are some CSVs you can download but I’m not sure if everything is included.

[image] OreoCookie: I’d pay for that. That sounds like a great solution: you have a nice UI and direct access to the data in a common format. Because another thing I’d like to track is my strength workouts. Hmmm, perhaps a spreadsheet with some macros is not such a bad idea after all. I’d be happy to share a copy of the GoogleSheet and a copy of the JotForm survey if you’d like. Of course, the back end stuff is a little messy, so it may need some explaining! I have built my dashes on Excel, Sheets, and Tableau (the latter of which used an API to automatically pull Strava data). But, Sheets has been the most practical. My next goal is to use my own data streams to learn R and get my Garmin (or Strava) and Oura data pulling via APIs so I literally don’t have to do anything each day except work my butt off and wear the devices (the dream! haha) I also have a Continuous Glucose Monitor coming in for a 2-week trial this upcoming week, so I am trying to figure out how to integrate that data.

Methods to keep track of training data (nutrition, etc.)

Training

killroy123 February 7, 2022, 1:56am 14

(Cough)

@IvyAudrain . People want this. Many people are saying this.

Topic		Replies	Views
Feature Request: Allow a connection of TrainerRoad to HealthFit App or allow fit file data export to Apple Health TrainerRoad Software feature-request	146	15777	October 20, 2026
Calendar Sync with Sporttracks.mobi TrainerRoad Software calendar , workout-sync	3	1599	January 16, 2019
Integrating other training data TrainerRoad Software feature-request	2	671	April 8, 2022
Any plans to add My fitness pal or HRV app links ot TR calendar? TrainerRoad Software	0	676	August 11, 2019
Training log/diary Training	14	1794	January 5, 2021

Methods to keep track of training data (nutrition, etc.)

Ask a Cycling Coach Podcast

We Are Here to Help!

Methods to keep track of training data (nutrition, etc.)

Related topics

Get Faster with Adaptive Training

Ask a Cycling Coach Podcast

We Are Here to Help!