That part is pretty obviousā¦
The center of the graph is the long term mean for RHR and HRV. Vertical displacement is +/- 0-3xSD RHR and horizontal displacement is +/- 0-3xSD HRV. For RHR, the use of the daily value seems logical. For HRV, it could make more sense to use a multi-day avg. Not sure but daily HRV tends to fluctuate quite a bit, while a 7-day baseline is less jumpy but still gives a good picture of what is going on.
Maybe plotting both on a longer period of time gives some clarity on what is most usefull.
The limiting factor of this graph is that it isnāt showing any trend. In combination with the trend graphs that Iām already using, feedback should be more complete.
Just thinking outloud hereā¦
Thanks for thinking out loud! Agree 100% that it would be nice to see some trend data.
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?
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 . Check this:
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.
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.
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ā¦
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).
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.
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
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 ), 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?