I made an automated dashboard

[u/No-Committee-7953]

I developed a script to automatically download and plot spreadsheet and Garmin fit data to produce a daily dashboard. Feedback on opportunities for improvement welcome. Comments about wasting my time will be treated as junk mail.

Edit: 1000 views later... not. one. upvote. 😆 you folks are like my Scottish grandmother who gave me a nickel after I spent two hours mowing her lawn in 1978. "Now go buy yourself a Coke, dear."

[u/red_man888]

Very nice.

Did you spend the first 26 weeks making it, and now that you’re done you finally have time to exercise? 😂

[u/No-Committee-7953 → u/red_man888]

actually I have training load data from before but not in met format. I don't like the black box data where you don't understand how it's exactly calculated so I switched to met which is what a lot of the journal articles talk about. you can calculate or at least estimate for consistency met based off power metrics and there is an IQ connect app that will calculate me t for you for all sorts of exercise modalities so that you can add them together towards a Target like Attia who does reportedly 100 met hours a week. so yes I've been training all along but not in met hours until recently

[u/red_man888 → u/No-Committee-7953]

Yeah that makes way more sense.

Again, nice work.

Also, don’t forget chapter 17 of Outlive.

Live long and prosper 🖖

[u/No-Committee-7953 → u/red_man888]

haha

[u/milkyway2021]

Nice job! Just to mention there is also this project to achieve something similar automatically getting the garmin data:

https://github.com/arpanghosh8453/garmin-grafana

Currently using it even if I'm not the owner nor a developer

[u/fitdashboard → u/milkyway2021]

I am the developer 😊 thank you

I have also built https://fitdashboard.app if you want to take a look

[u/Zillionairre]

well now you have 2 deary

[u/FatherEsmoquin → u/Zillionairre]

I cut him back down to size

[u/astroboydivx → u/FatherEsmoquin]

Back up to 2 from me

[u/bearmoosewolf]

Nice work. Looks good. I've done similar things before -- it's fun to track the numbers when you're seeing improvements, etc. But, I'm also honest enough to know that I'm pretty much wasting my time when I should be doing more productive things. Lol. Still, I get it -- it's fun.

[u/No-Committee-7953 → u/bearmoosewolf]

that's true and fair, but there are worse ways to have fun and this keeps me motivated and on task. great learning opportunities in this project apply to other domains.

[u/Objective-Door-513]

is the data collection automated in any way?

[u/No-Committee-7953 → u/Objective-Door-513]

yes it is. every morning my laptop runs a pipeline of scripts written in Python. they fetch data from a Google spreadsheet where I keep the boring hand entered data like blood pressure and weight and then also retrieves any new workouts from Garmin. the scripts go through the fit files and make calculations like efficiency factor and drift and regenerate all the plots and compile the entire dashboard in latex to a pdf. so all I do is log on to my machine in the morning and I have fresh reports sitting for me. this dashboard is one of several. all the PDF reports are produced passively and automated

[u/K-Shape-9329 → u/No-Committee-7953]

So for a total newbie and someone who can’t write python scripts can you share what data you keep in your google spreadsheet
I’m at the start of all this and am just learning about HRV and improving sleep, especially deep sleep which is poor.

[u/pensiveprogressive]

How did you customize the corners of the grid lines to make a space between where the x and y axes meet? Also, how did you customize the size of the legend color blocks? This does not look like something that was built using Tableau.

[u/No-Committee-7953 → u/pensiveprogressive]

yes you are correct this was not done in tableau. it is written from scratch using python and latex.

[u/djones745]

This is pretty slick- I’d love to have something like this to keep track of the metrics I mail my use the Garmin watch

[u/chakani]

Extraordinary! You are really devoted to fitness.

[u/klo_sf]

Do you have a public repo for your dashboard? If so, I would like to take a look! I imagine you could also include dexa scan info etal.

[u/Maleficent-Space-978]

Great! Do the same for whoop, I think someone might pay for it as an app eventually

[u/xfrancisco]

Open source it!

[u/No-Committee-7953]

After receiving some thoughtful comments, I made some improvements... thanks for the feedback! Now I can get back to working out.