Hello,
Love the tool and concept! I do have a question and maybe it’s hidden somewhere but couldn’t find it. The tool was working fine until I had to miss a HRV reading one day and now it hasn’t plotted the HRV Z-score for more than a week.
Is there something I’m missing or does it require a long consecutive streak of dates for it to work?
Thanks!
I am aware of unpredicted behavior when some data is missing but haven’t got around to fixing this. Bare with me please, I’m totally new to any kind of programming and learning the hard way 
Your easiest workaround for now is to input an interpolated value for that day. In your case, just manually input 94 in the HRV wellness field on for 26/09 and you will be good.
That fixed the issue. I appreciate it!!
Which version are you using?
I tried to recreate your problem, and it works fine (in v1.3.2)
I was using v1.3.2. That’s interesting because I recreate it on my end it goes back to the same problem.
You have changed something to the formula’s because normally an empty field returns an N/A result in the HRV Z-Score. And that means no dot and no valid avg for 30 days…
I have to think how I’m going to handle this because, while you have a value (-21), it completely falls of the scale and you will not see a dot on the chart for that day. The off-scale value influences the 30 day avg and the SD quite a lot.
For those reasons, I can’t use N/A or 0. Needs to sink in, and we will see how to handle it.
Could you just interpolate between the last 2 measurements? Is not accurate but it will also not change the overall recomendation.
Something like IF the cell is blank, then average the previous 2 measurements.
Part of the problem is that the HRV cell contains a formula. And thus it isn´t blank 
.
Can be frustrating in MS Excel…
The correct way to do it is allowing blanks and exclude them for the average and SD calculation. That’s what I’m looking into. You should not get a dot for days without measurements.
I’m sending you a change to the file, which blanks out the value if the HRV value is missing for the day. The dot doesn’t appear on the chart.
Here are three different scenarios:
This should resolve the issue of the score changing, but I do notice it pushes the Orange (today) to a Green (today) as it doesn’t take into account my score from yesterday.
Ideally the chart should show what today’s training should be, which in this example is limit HIIT, which is borderline between the Green and Orange.
Nice!
Small changes in SD are no big problem. A value that significantly influences the HRV average on the other hand, is to be avoided because it shifts the whole graph. Remember that the averages determine the center point of the graph!
A borderline dot isn’t going to have a huge impact doing one or the other. That’s explained in the chart description.
I will have a look at your modified file as soon as I find some extra time. Probably the coming weekend.
Thanks for your input!
Hi
Thought I’d give this a whirl today but running into trouble 
I’m on this version of Office
I have downloaded excel sheet to laptop.
After I enter my athlete id and refresh all, I am not getting the ‘Access Web Content’ dialog.
So then I switched to try the more simple file using local data.
That pulls in the data from the local csv file but doesn’t update the chart.
Any ideas how to get both versions working? Ideally I’d be able to use the one that pulls from the api key
Thanks
D
Edit
I’m trying now to get data from web as per screenshot below
I’m having difficulties to use this excel file. I’m using office 2016 and I saw it supports data content… The step 3 didn’t appear to me.
Is this feature on your todo list to deploy in the intervals.icu @David?
Thanks.
Looks like something went wrong when trying to set the access permissions.
If you are on Windows, go to ‘Get Data’ - ‘Data Source Settings’. Select Global Permissions, Edit Permissions. Set Privacy level to None then Edit credentials, Basic. User is API_KEY and pw is your personal API-key.
That should do.
If you’re on Mac, there seems to be a security level that does not allow getting data in this way and you will be forced to use a local wellness file.
For the local file the data for RHR and hrv is correct but there is an issue with the date format. From the first screenshot I see that Office has the en-US regional setting. Do you have the same setting system wide? Is your date on the taskbar displayed in US format (yyyy-mm-dd)?
A local downloaded file comes in with this format but is interpreted using your regional system settings. And then is again interpreted by Excell to display it in the choosen date format. Check on the wellness tab if the date is correctly displayed.
EDIT: my mistake, I forgot to enter the source origin in that file. It’s done now, so it should display the dates correctly and be functional. Sorry about that.
Is this “chart” have some sort of copyright or things like that? Do you know? I’m thinking if it’s possible to incorporate it into my app.
It’s from iThlete but all the info to reconstruct it can be found for free on their own website. Haven’t seen any copyright or TM symbols.
To be honest, not 100% sure if I’m doing something illegal but I don’t think so, as long as I’m not commercializing this.
saw a Copyright symbol on the chart that says (c)HRV Fit Ltd on this page
What you indicated is a footnote in the footer of the page and it does not indicate what is covered by the patent, to what extent, under what number, etc.
Thanks for the reply. You’re a gent.
I’m not sure what was going on. Tried all you said there for the API connect and still wasn’t working. I deleted the file altogether and re downloaded. This time it works. Had to enter the api password on 4 occasions but then it just pulled all the data in.
Working now.
Thanks again
