Folks
See below screenshot. Where do I find this HRV4Training chart?
Thanks
Thank you
Awesome thread! Looking at the original article and your @Gerald @MedTechCD implementation, I had one idea which could help with recognizing trends: how about the dots of the last week are coloured in such a way that today is darkest and the past 7 days progressively fade to gray? This way, one could, at a glance, follow the path through space and possibly visualize trends/directions. Or even some arrows/paths, but that would probably clutter it way too much.
Today’s and yesterday’s dots are already recognizable but doing so for 7 days would require making 5 more “series”. That will become complex and the graph might get slow. As it is now, there are already 34 series of data necessary
I have another color scheme from @Gerald that makes them stand-out better and will apply that in the next update.
I have been looking at changing the displayed text on mouse-over, but that can only be done with vba scripting and I’m not sure if I want to go that way.
Updated version released
Hi @MedTechCD @Gerald,
Nice work.
I bet you already know this GitHub - alan-couzens/python_for_coaches but I thought would be worth mentioning anyway.
Regards,
That would be where I would speak to my brother for assistance, as my coding skills are limited to creating macros in Excel (automation of repetitive tasks, or refreshing data after an upload).
What’s the status of the Google Sheets version?
I’ve given up on Excel for macOS. I installed the latest version of 365 but nothing looked as per the diagrams when I opened the macOS version of ‘APPS in Excel’. Additionally, I’m reluctant to subscribe to anything Ms, especially since this is the only spreadsheet that I want to use that I can’t run in Numbers.
Hi Guys,
First try and I’m getting a hard time to make Intervals_API_Tools_Office365_v1.5 to work.
- I’ve downloaded Intervals_API_Tools_Office365_v1.5
- I might have entered a wrong password (I suppose to be my Interval’s password) in the dialog bellow because it hasn’t worked.
But than I’ve tried unsuccessfully to repeat this step but it never show up again.
I have cleared and deleted all permissions in order to start over but the only dialog that appears to me is the next one bellow.
I have even deleted and downloaded it again saving with a different name but I no longer can get the dialog to enter my Key and password.
Thank you,
The password is your “PERSONAL APIKEY” found on the Intervals settings page.
Clear all permissions and re-authorize. Privacy levels can safely be ignored.
Are you on Windows with an Office version 2013 or later?
If so, if you keep having problems, download TeamViewer (Quick support is ok) and send me a PM. We will schedule a remote session. On Windows with a recent Office, this should be easy to setup. If it’s not, I would like to know what the problem is and work on it.
To re-authorize, goto Data - Get Data - Data Source Settings and check if the Intervals data source is under “this workbook” or under “Global”. Once you found the source, edit the permissions. Credentials - basic - edit. Enter API_KEY as user and the api-key found on the intervals settings page (create one if you haven’t yet). Then set Privacy level to public.
Howie, I will release an update on the ‘simple’ version which will only have the iThlete chart and will only download the data that is needed to populate the chart. (date, restingHR, hrv and just in case SDNN). Cutting down to a minimum to avoid as much problems as possible.
The data source can be the WebAPI (but that seems to be problematic on Mac) or the manually downloaded wellness csv file from Intervals. I may add a vba macro to run a cURL call later, but I don’t know if MacOS handles that correctly.
The updated file should be ready this evening. I’m working on the last details and will then upload.
Once you have this updated file, save it alongside the manually downloaded wellness file and let me know if you’re able to make it work.
If not, we may try a remote session but I have little to none experience with Mac.
Mahalo. IIUC, the version you’re talking about is Excel on macOS? I have v16.65 installed but the 365 license ought to have expired since I cancelled the subscription before the trial ran out. But did uninstall all the Ms update stuff so maybe it’ll run. Otherwise, as much as it pains me, Google Sheets is my next best option. TBH, I wish there was a remote/web version of this whole thing that we could use.
Google Sheets doesn’t have the option to create the graph; at least not at my skill level.
The best option is to use the plain Excel file, with no link to any other file. It would require exporting the csv files and then copy and paste into pre-defined tabs for the lookup formula to work.
I am going to give my humble opinion after working for a long time with hrv, dfa alpha, etc…, I have used dfa alpha for recoveries after covid, managing to adjust the intensities so that the athlete did not have an excessive internal load. With hrv I am working on some interesting projects. To base a training day on rmssd alone seems to me quite daring, however much some people predict it, I have a lot of data to be able to affirm this. rMSSD gives you an indication of your parasympathetic activation, but sDNN is giving you very valuable data of what kind of fatigue you may have, if we add to that HF and LF ratios we have very interesting information to make decisions about the athletes. I don’t know if @david could include the hrv4training capture of this data, Alan Couzens also uses both sdnn and hf and lf ratios to make decisions.
I just did the test a few days ago which I have again caught covid, being quite sick (muscularly) prevented me from walking and I had to go to the hospital with lumps in the legs and a lot of muscle inflammation, I have put these days in the iathlete sheet where the rmssd had fallen but not much and made me train, instead seeing the sdnn I had clear that I could not train (apart from own perceptions )
The logarithmic score given by hrv4training honestly does not seem accurate to me, look at what the rmssd says and the hrv4training score and look at the sdnn as it is in the fitness graph.
I’m not an expert in this matter but I found the graph very user friendly and clear. That’s why I invested time in this. Given the fact that Alan Couzens himself was at the base of the graph, it must have some credibility. And I have seen it working quite well for my own data. During the whole month of October, I went from one cold to another and was absolutely not in a good state of health. The graph showed that clearly with several days in the red zone. But after about 3 weeks, the graph became less meaningful. That’s because the average for the baseline is only 30 days. A longer period of sickness will tend to “normalise”.
I have read a couple of things on SDNN but haven’t been able to find something more explanatory.
I already taught about inputting the SDNN values in the same graph and see what it gives. But I have nothing to base interpretation on.
I will see if I can make a version of the file that allows switching between RMSSD and SDNN. If you could give some meaningful advice, that would be great.
All I have for now is a quote from Alan Couzens saying:
HRV within -1SD and 0 while SDNN low: only LIT
That’s a supplementary limitation, but I couldn’t find anything else.
I must be missing something basic. I’m able to do Data > Get Data (Power Query) but the operation just creates a new pages named athlete_ixxxxx_wellness and ixxxxx_activities instead of inputting the data into the existing Wellness and Activities pages.
Thoughts?
Update:
Instead of getting new data I changed the file path of the existing data sources to point to my own files. Activities are refreshed into the Activities page. However, the Wellness sheet throws this error.
Presumably the error comes from the fact that my CSV doesn’t have baevskySI, menstrualPhase or kcalConsumed
.
.
These are my column headers:
date,restingHR,hrv,hrvSDNN,readiness,sleepSecs,sleepScore,sleepQuality,avgSleepingHR,soreness,fatigue,stress,mood,injury,motivation,spO2,bloodGlucose,lactate,vo2max,ctl,atl,rampRate,ctlLoad,atlLoad,Ride_eftp,Run_eftp,Hike_eftp,Walk_eftp
Manually delete the column(s) you don’t have in your csv file, and try again. I tried adding the two custom fields (sweat rate and sodium loss) and go the same error message.
Yup, already tried that. Same error.
So, I copied and pasted my data into the Wellness page. That took some fiddling since things like the formula in the HRV column on the ‘iThlete HRV’ sheet appeared to be hard-coded for column F on the Wellness page. Although, that seemed to change after I fiddled with the columns. Yet, there’s still a call somewhere for ‘baevskySI’ since that error keeps popping up.
There’s also something weird with the iThlete HRV title. I didn’t know that November is ‘00’ month.
Now, as far as reading the chart. It seems to be working. I see dots at any rate. Curiously, hovering over any of the dots gives me ‘Series’ coordinates. It would be nice if it showed me the date so that I didn’t have to scan the z-score columns to find the associated data points.