Can you click the “dispensar” / details dialog and share what that says?
There is some github code this calls to which you need to provide permissions for in order for the sheet to function / receive data from the intervals api. That’s the only thing that I can think of that might be causing a problem now without more info about the specific error you are getting.
no further info in that…
thinking broadly 
Can’t it be due to date format or any other unit?
I live in Brazil.
date is DD/MM/YYYY
and the units are metric sistem.
Your sheet is view only and doesn’t allow to edit the red blocks, Athlete ID and API key.
Should those cells not be unprotected to allow the data to be changed?
The Import data button also is inactive.
Hi Gerald, you should be able to take a copy and then put in that info in your own version. Probably not a good idea to be putting that personal intervals.icu account info in a widely shared Google doc!
Ah that’s tricky. When I’ve had that dialog the details/dispensar bit has provided a bit more info as to what went wrong. Hard for me to troubleshoot further since the version with my intervals.icu account details in works fine…
That shouldn’t be an issue - since I understand you are getting the issue with the API call rather than any subsequent calcs.
It has “kind of” worked.
Tab “intervals_activities-export” has been populated but all others don’t show anything.
tks,
Glad to hear it’s at least pulling data from intervals.icu for you now! Did you do anything different from your previous attempts?
I’ve figured out why the other sheets are not populating - I was a bit over-zealous when clearing out my data to share the file. As you can see in your first screen shot Column A is blank, but this should have dates in it which are then used as references to pull data across to the other sheets. I have updated the shared file now with the formulae that should be in that column, If you go back to the shared file you need to copy across column A from the sheet “intervals.icu_activities-export”. Or copy the whole updated shared file and re-enter your details in the red boxes.
All sorted.
I saved a copy in my Google Drive, but I see I was trying to open your file, not the copy I made.
I will test and give my objective feedback.
Now it’s working. Tks to you and to @Andrii_Magalich.
I might have missed the explanation of the rational behind the “Potential Next Activity with training load of”.
What is it trying to accomplish? to keep you in the “optimal” Form(TSB) zone? any periodization ( going to fresh)?
Any possible input of Fitness CTL ramp rate?
Appreciate your work.
Best regards,
PS:
I’m confused:
I had a load yesterday but it shows zero for status as "Next activity Tomorrow and gives me a load for Next Activity Load.
If I choose status as Next activity Today it shows my today’s load and gives zero as load for Next Activity.
The way I understand it, the next load is 58; look a few rows below.
The workout suggestion is then shown below:
25min of VO2 work down to 58m of Endurance (L2, or Z2 as some refer to it).
Me too but look right bellow on “Prior daily Load”. It shows zero but I do have a load of 25 from yesterday.
And, If I change to “Next activity Today” “Prior daily Load” we get my today’s load of 109 and no prescription for the next activity.
I’m trying to understand “Next Activity Tomorrow” vs “Next Activity Today”.
Also, what is this recommendation based on?
William should answer the first part of your question, as I do see a Prior daily load if I have done something on the same day. The lookup is in row 5, when I believe it should be row 6.
The recommendation is based on the load needed to get to green. Load is dependent on the intensity and duration, which is what the table below the recommendation. The higher the intensity, the shorter the duration.
(1) The load from the last workout, providing it’s the same day
(2) The next activity load is the shortfall from keeping the form in green
(3) The various workout durations will give different loads.
Thank you
Thanks, I’ll add the other one later
Sorry for slow response, haven’t had a chance to reply until now.
@Gerald pretty much has it figured out. It’s just trying to hit a target Form% in the short term (next activity). That could have been achieved with ramp rate but I chose to target a Form value instead - over longer periods the two do relate to one another of course. There is an attempt to avoid training monotony rather than periodisation by looking at the intensity of recent activities to give a recommended intensity. I could have added some explainers to the sheet but I didn’t spend too much time on this to be honest. By all means modify your version to function more how you would like if you think some of the choices I made were strange
As for the “prior daily load”, I see the confusion, but that is not trying to give yesterday’s load, it is trying to give load already accrued today, e.g. if you do a double day and want to figure out after the first activity how hard you should go in the second activity to achieve your set form target. So whenever you set to “Next Activity Tomorrow” it will be zero, and should only be non-zero if you set to “Next Activity Today” and have already done an activity today. Hope that makes sense? Happy to update the template with a better descriptor / title of the cell though if you can think of one!
This seemed an appropriate place to share that I have made some updates to the above discussed Google Sheets doc that leverages the Intervals.icu API.
This is the Direct Link to take a copy from if you want to use it: Next Activity_icu v1.1 (shared) - Google Tabellen
And it is kept in this shared Google Drive folder, where I will put any further updates: Next Activity_icu – Google Drive
What’s new?
Below is a screenshot of how the Dashboard looks for me, with my intervals.icu data already pulled through the API.
Exactly what I needed to understand this all! 
