Recreate ithlete rHR/HRV chart?

I’ve been working a bit on this but I lack the MS Excell knowledge to reconstruct the graph with colors and automatically select the last 14 days.
The logic for interpreting the “Z-Scores” seems to work well and correspond most of the time with the HRV interpretation from HRV4Training.
I’ve used lnRMSSD *2 just like iThlete is doing.
Anyone with a better knowledge of Excell who would like a copy of my file?

3 Likes

Send it to me and I’ll see what I can do on Excel.
Changing colours based on ranges is an easy fix, but would need to see the data first.

This looks really interesting! Thank you for sharing a snippet.

It just became more intresting :wink: . Check this:

image

8 Likes

This is awesome. Tx so much to you and @Gerald for putting this together.

Providing historical results was fairly simple, so that’s already done. Adaptation info isn’t ready yet!
If you have entered data in the ATP sheet, check the Readme tab for instructions! Don’t simply replace the file because you will loose information entered on the ATP sheet!
When you see the link was updated to reflect v1.1, the new version is available for download.

Link is Intervals_API_Tools – Google Drive

4 Likes

This morning’s data recommends limiting high intensity.
The coach in me says “listen to your body”, while the athlete would say “but I feel fine”.
The data says “take it easy”, so the decision is an easy one.


4 Likes

This is some seriously good work @MedTechCD and @Gerald - I think the forum owes you a coffee/ beer! Thank you very much for producing this and sharing it with us. I am going to digest more and collate some thoughts but thought I would share my chart “in action” to provide more evidence of it all working as expected…

4 Likes

For me, it’s part of the learning process; that never ends.
@MedTechCD did most of the work on the iThlete file, and I only helped with the scatter chart (the conditional formatting of the dots). As much as I helped him, he helped me learn a few things too.

I’m happy to share anything that is freely available to find on the internet, that helps make someone else’s life/decisions a little easier (to make). The only reason I can’t share the planned TSS/hours per week on the ATP is because it’s not mine. I don’t have permission from the owner to share it (or rather they won’t give permission to share).

2 Likes

Joined forces achieve more…
I want to thank @Howie for bringing this to our attention. The graph looked very inspiring and I started looking around to find more information on how it was build. I got to work and managed to “reverse engineer” the logic behind it but wasn’t able to graph it nicely. I got stuck. So I threw my work here in the forum and @Gerald picked it up and came back with a couple good ideas to implement it in Excel. That got me going again and I was able to make a first usable version.
I’m excited to see that some of you already have meaningfull results. Both graphs above show that HRV, measured correctly and consistently, can really help to make decisions that improve your planning. You both have most of your results in the “safe” zone and a couple of outliers. That’s, bottom line, the execution of a good training plan with some disturbing situations caused by daily life (bad night, work stress,…) , big efforts like races or hard workouts and/or mild sickness/stress. Keeping track of correlation with subjective feelings to put it into context is important to learn how your body reacts to different stressors.
It might sound strange, but the more boring the chart looks, the better you’re doing at managing life and training.
I will replace the date field by a date picker as soon as I get around the problems I’m having with it now. And after that a dropdown list to change the background to show Adaptation information.
Thanks @Olly_Thomas for your motivating reponse and @david for making the data easily available through the API.

4 Likes

Great job guys, I have this problem

I had the same problem. To fix it go to your settings in intervals.icu and add a FTP value for running. I did this (just a random number as I don’t run) and pressed refresh all data in excel and it worked

1 Like

I have done the same

I have tried it on another computer and I get this error when updating the data, on the laptop it works perfectly.

The athentication with API_KEY and your personal API-key needs to be done on any computer you want to use because the authentication is global within MS Excell.
If you transfer the file with modified athlete ID, that will remain saved in the file and doesn’t need to be entered again.

You are the second person with this error. I will check to see if I can find the source. If I understand correctly, you both had to add a value to the setting in Intervals?

Yes @MedTechCD - I didn’t have an FTP assigned to running in settings (as I don’t run :grimacing:), but as soon as I set one and pressed refresh it works immediately.

Most logical explanation is that the column Run_eftp does not exist in the welllness.csv pulled from the API when there is no entry.
Since the file uses Excel’s Power Query Editor to format the dates and numbers for all columns, the error is thrown by the editor because it can’t find that column in the source file.
@david If above is correct, can you set the wellness.csv to always include Run_eftp even when blank? There are other columns unpopulated that come through, so that should be possible?

1 Like

Wow, wow, wow @MedTechCD & @Gerald!!
I’ve opened the spreadsheet in Excel but realised right away that I need to set aside some quiet, undistracted time to work my way through getting it setup.

Thank you! Mahalo nui loa, for making this available. Having more input for making sound decisions is hugely appreciated.

My own Excel file, which doesn’t show “run eFTP” is also now broken, which means the Wellness data is not downloading.

Not sure if it’s related to the query you raised with David.