Recreate ithlete rHR/HRV chart?

Hello to all,

I’m trying google sheets but I can’t see the graph with the colours and data, I only see a blank sheet, I haven’t been able to find out how to do it, if someone can tell me how to do it.

Thanks

@Olly_Thomas file has an issue. The formula’s on the HRV clac sheet are missing. If you have no clue on how this all works, have a a little patience until a corrected version is posted.
If you do know how to handle this, just copy the formula’s from @Aindriu 's file in the same columns on Olly’s sheet.
This is a work of multiple members each doing the part they have knowledge on.

4 Likes

Replying to this post,specifically to keep Alan Couzens, Python and the below podcast together.

3 Likes

Can you post the link to the colour chart version? Thanks

Sorry work is manic at the moment and I need to update to slightly - bear with me I will do it ASAP. Thanks!

1 Like

hi,

Works using a computer, but how can I do this using an iOS device?

Tks,

1 Like

Still waiting on that as well. Browser based or iPad for me.

Well,
the sheet is there fully working on desktop and 90% on mobile but we don’t have the knowledge on Google Sheets to automatically refresh the data…
Someone else will have to come up with a solution for that. Just like anybody else we have limited time available and need to respect/protect our own priorities.
I thought the best way to keep things moving forward was to post it as it is and count on another helpful soul to solve that remaining issue.

6 Likes

appreciate your efforts.

tks,

Aagggghh
I was messing around with this this morning trying to get a copy I made of v1.5 to pull in custom wellness fields. I ended up having to delete the v1.5 file and now upon redownloading I cannot get it to work at all. Any help would be appreciated

I keep getting an access denied error.


Continually get the message below


image

I’ve deleted, redownloaded, closed, opened, done everything I can think of to get it working again but I can’t

In the data source settings dialog - Global Permissions - click on Edit permissions and re-enter Basic - user - Api_key

1 Like

Ya, did that but I will try again now and see

Did again and same result. All I’m getting upo refresh is

Clear all permissions, local and global. Then start over with a newly downloaded copy of the file.
The message clearly throws an error on authentication, so you have something wrong in there.

1 Like

The simple version of the file works so I have that working at least

I cannot figure it out. I have done everything you suggested there but still no luck. Ugh.

Get TeamViewer and install it on your computer.
Send me a PM with TeamViewer id and password in between 7 - 10 hours from now. I’m in Belgium and it is now exactly noon 12hr.
I will check remotely what is wrong if you agree that I take control of your computer.

1 Like

This sheet only works in “Google Sheets” right?
After creating a copy and then saving it in Excel format, entering the ID and password, it is not possible to trigger the macro because it is simply not on the list of macros :confused:

However, in “Google Sheets” after triggering the macro, it downloads data from “Interval.icu” and generates points, but there are no 28 of them as in the case of the sheet created by MedTechCD, only 19.
The layout of the points on the graph differs between the two sheets v1.5 and v3) although the wellness data is exactly the same.

greetings
Artur

Oh sweet Lord. I can’t read simple instruction. I kept inputting user as API and not API key, despite what @MedTechCD wrote above. It was ony when I found the page screenshot below that the penny finally dropped.

Yes, the Google sheets one only works in Google Sheets. Why would you want to use that one in Excel?
If you are missing something in Excel, just tell me and I well see what I can do.

In the Google Sheets version, @Aindriu choose to display 19 days of history. I can’t tell you why but it isn’t that important. Longer history is best viewed in the HRV4 chart.

The layout only ‘looks’ a bit different because the scaling horizontally differs from the vertical. That makes rectangles iso squares. The data is as far as I can see correctly plot.
In the Excel one, the chart background is constructed with data and formula, while in the Google Sheets version, the background is a fixed picture. In Excel you can resize and everything will stay correct because all items are coupled to the same axes. In the Google sheets version you would need to resize the chart and the picture background separately.

PS: I may have found a solution to refresh on the mobile version of the Google Sheets one, but need to test some more. Once I’m sure it works, I’ll tell you all how to do it.

2 Likes

Looks like @MedTechCD has kindly covered everything in your queries :grinning: