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 
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
I have Excel installed and use it every day.
I have to open google sheets from a web browser, which is less convenient and non-ergonomic.
Writing about “different layout between your sheet v1.5 and sheet Aindriju (v3)” I meant missing points more than 20 days from today.
But ok - the fixed 19 days overlap.
However, I can’t find the “today” point on the chart.
In your sheet, it is a dot in a circle, a large readable one.
Today’s status is not displayed in the Aindriju sheet. Only in cell “A2” there is a description of the possible nature of today’s training.
Yesterday’s day and status in Aindriju sheet is displayed as “triangle”?
I attach two screenshots, the first from Andriju’s sheet and the second from yours. Both sheets have the state of wellness data for today.
regards
Artur
Big session ahead of you today 
sure
1 Like
I have seen the missing point for today also on the Google sheet. Don’t know what but something went wrong. I don’t understand the script and macro in Google sheet because the scripting is totally different then in Excel. App script uses Javascript. Can’t help you with that. I have started over with a new copy of the latest version and it has now been working correctly for a couple of days.
Today’s value is normally a colored diamond, yesterday a colored triangle and the rest of the last week are colored dots.
1 Like
I’ve just saved a Google Sheets version and updated with data. Seems to be the same as my Excel version.
There are always going to be differences I’m afraid and perfection may not always be possible.
When I get some time I will have a look at my v3 file graphics and check that is not obscuring anything.
Having not used the excel version for a while you soon get used to the visual differences very quickly but when I do check the data and recommendations do match between the two.
Unfortunately, I am not displayed a rhombus illustrating the state “for today”.
I also saved the sheet and only then did I put ID and Pass, then liberated the macro and downloaded Wellness data. But no rhombus is displayed:/
I run Google Sheets in a tab in my Chrome browser, and I find that after running the macro to download the wellness data it helps to refresh the Google Sheets tab. If you haven’t tried that already try it and see if it helps.
FWIW my version downloaded the other day works exactly as expected, as does one I bodged together myself, based on Olly’s earlier file.
I’m finding the graph display to be quite helpful in deciding what training to do - many thanks to all involved in this.
Robert
2 Likes
@Olly_Thomas confirmed that this is working, so here we go:
- Open the sheet on a desktop and go to Extensions - Apps Script
- On the Left side menu, click on Triggers
- Bottom Right: Click Add Trigger
- Select ImportintervalsICU, Time Based - Hour (or what you want). I set it to trigger every 2 hours.
- Save it
From now on, the Import script will run every 2 hours (or what you set) and it will run server-side. This means that you don’t have to do anything and your data will be updated every 2 hours. Just open the sheet on any device and you will see the values from the last update.
Don’t ask millions of questions, I don’t know anymore about it . Just Google if you have other wishes.
5 Likes
Does it show today’s data in the columns A, B, C, etc?
