that was only an exemple.
you can do the math whit whatever ctl ramp / TSS avg you have int the moment.
Again from Alan: "…most folks can handle a ramp of 5-8 CTL per week. Perhaps it’s just me growing more and more cautious as the years pass, but I’ve found these numbers to be a little too aggressive over the long term among my sample of high performance (often working age group/‘high life stress’) athletes. I typically aim for a more conservative long term ramp of 3-5 CTL per week (or ~10-20 per 4 week block) as a good long term figure.
I did a formula to address the proportionality of Alan’s exemple:
For a 3w load 1w rest block:
“Desired BLOCK CTL Gain”, I will call it CTLg . let’s say (in my case) 4
“Initial CTL block value”, I will call it CTL. i.g.:54
“Daily load TSS to add”, I will call it dlTSS
dlTSS= CTLg times 5
dlTSS=4 times 5=20
“Week Load TSS”, I will call it wlTSS
wlTSS=(CTL+dlTSS) times 7
wlTSS=(54+20) times 7=518
so, making 3 weeks of 518TSS will take you to -20/-30 TSB
than you have the rest week where:
“Daily rest TSS on rest week” , I will call it drTSS
rdTSS=CTLg times 3
rdTSS=4 times 3=12
“Week rest TSS”, I will call it wrTSS
wrTSS=(CTL-rdTSS) times 7
wrTSS=(54-12) times 7=294TSS
so making the 294 in the rest week will take you to the fresh TSB
theoretically you end up the 4w block with a CTL 58
I made a local copy of the spread sheet, entered athlete ID: and API Key: but nothing has happened.
also import data botton at “Daily Record” tab is inoperante.
Appreciate any help.
What device did you try this on? Unfortunately those buttons (and scripts) can not be triggered on mobile devices - a limitation of Google sheets.
Solution I found for mobile use was to initially set up on a computer, and then set up a regular time-based trigger to run the script that the button initiates.
Running it in Excel is why it’s falling over. The script which calls the data from the API is Google Sheets specific, it will not run as an Excel macro.
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.
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…
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.
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.
