Season Plan (anual training plan)

[YvesTri]

Hi there,
I tried now for 1 hour to set up the connection. Filling in the permission with my API Key and ID at one point I end up at this screen.

When I fill in the credentials in basic and click connect it says that there is no permission. Can somebody help me?

[MedTechCD]

Choose ´Basic´
Enter API_KEY (literal - NOT your athlete id) as the user
Enter your personal api-key found in Settings page.
Your athlete id is in the URL and your personal api key makes sure that you can only acces your data. Everyone has API_KEY as user

[YvesTri]

Thank you for your fast reply @MedTechCD. I selected Basic, put in API Key as user name and password my password but then I hit enter. But still this showing up ! I tried also all different option… such as putting in my account e-mail and password, my API key and password my ID but it somehow does not want to work !

[MedTechCD]

API_KEY is the user you need to enter. EXACTLY like that. Uppercase API followed by an underscore and then uppercase KEY
The password is your personal API key found on the intervals settings page.

[YvesTri]

man… now I got a list, finally! Thanks for the support. Now that I have this I must see how to import and proceed. Cheers!!

[MedTechCD]

I don’t know which version of the excel file you downloaded but normally the activities and wellness tabs should immediately populate.
You can find the latest version here: it will only be fully functional in MS Office on Windows.

Training guidance tools using the API

The full featured file just got updated to version 1.5. Changes: 1.5 ----- Accepts blank values for RHR and/or HRV while keeping correct averages. If too much data is missing, a watermark is indicated over the chart. That’s if more then 2 days out of the last 7 are missing or more then 9 out of the last 28. You will still get results but be notified by the watermark. I will update the ‘Simple’ version later today. Link is still: Intervals_API_Tools – Google Drive

For questions on the anual training plan, adress @Gerald . He’s the author of that part.

[YvesTri]

I have an older version. I will download now this one and try it out with this one… thanks so far !

[YvesTri]

Ok with the this version I was able to import Wellness and Activities.

but on the annual training plan nothing comes out !? sorry but maybe i am missing a part

p.s. does somebody have an good IM 70.3 annual plan with goal 4h30 min - 5 Hrs race time ?

[MedTechCD]

It’s a tool for planning. It’s not a plan…

[YvesTri]

I know, based on the plan I would like to do my planning in the tool.

[YvesTri]

in my spreadsheet no week numbers are showing up in the activities and wellness and the annual training plan is empty… what is missing ?

[MedTechCD]

At some point there was a problem with week numbering. Looks like I removed the formula in this version.
You may find the correct formula when following this:

Training guidance tools using the API

Please can you click on the cell where this occurs, and send a screenshot of the page. I don’t have 2022-52 in my original ATP spreadsheet, so it could be wrong in the file where we’ve merged all tabs together. [image] I am using ISOWEEKNUM in the formula. WeekNum uses the week containing January 1 as the first week of the year. The result from this function can range from 1 to 54. ISOWeekNum uses the week containing the first Thursday of the year as the first week of the year. This follows…

Training guidance tools using the API

The formula I use, is as follows: =IF(G25="","",IF(YEAR(A25)<>YEAR(A26),YEAR(A26)&"-"&ISOWEEKNUM(activities[@[start_date_local]]),IFERROR(IF(activities[@[start_date_local]]="","",IF(C25<10,YEAR(activities[@[start_date_local]])&"-0"&C25,YEAR(activities[@[start_date_local]])&"-"&C25)),""))) [image]

[YvesTri]

tried the formula =IF(G25="","",IF(YEAR(A25)<>YEAR(A26),YEAR(A26)&"-"&ISOWEEKNUM(activities[@[start_date_local]]),IFERROR(IF(activities[@[start_date_local]]="","",IF(C25<10,YEAR(activities[@[start_date_local]])&"-0"&C25,YEAR(activities[@[start_date_local]])&"-"&C25)),""))) and substituted G24 to B5 but excel says:

[Gerald]

The formula for cell A5 should be:

=isoweeknum(b5)

It picks up the date in B5 and converts it to the week number.

Before that, =year(b5)&”-“&isoweeknum is used to create yyyy-weeknum so that you can sort by year.

However, weeks 1-9 will show a single digit, so the if(isoweeknum(b5)<10,year(b5)&”-0”&isoweeknum(b5),year(b5)&”-“&isoweeknum(b5)) is used to create a double digit week number after the year.

[Gerald]

The goal of the Excel file is to subtotal the total load, distance, etc., by week numbers.

[MedTechCD]

I have just uploaded a 1.6 version of the API_TOOLS excel file which has a formula for the week numbers (ISO format) and respects the format needed for the ATP plan (yyyy-ww).
It’s available at the same link.

[Gerald]

I’ve responded privately with YvesTri, but for general information to others, here is a general overview of the plan:

The plan is only a template, and needs to be created by you, based on your requirements.

• Insert the start date in cell K1;
• It has now created a year plan for the next 52 weeks (rows 9 & 10 show the calendar week and plan week; which can be different depending on the start date of the plan.
• Row 13 is the mesocycle week, eg. base1, base2, build1, taper & race, etc.
• Rows 14-15 are the sum of the planned weekly hours/load.
• Rows 19-20 are the sum of the actual weekly hours/load, that you would get from the activities tab.
• Row 16-17-18 are showing if you are compliant to the plan, eg. <50% (red), 50-85% (yellow), 85-115% (green) or 115-150% (yellow) or >150% (red).
• Rows 32-40 shows the testing and areas to target. 1 = primary goal, 2 = secondary goal
• the graph in row 41 will populate based on your data showing in rows 14-15 and 19-20.

For your planned duration and load (rows 14-15).
I don’t know your individual plan, and there’s not a one size fits all number to insert there.
You need to look at how you will train, and rest, and then workout the totals per week.
This gets transferred to the target hours/load in the Intervals calendar (activities page).
You can see my weekly planned load/hours will show up in the fitness graph (green/black chart).
The mesocycles (base1, base2, base3, etc., shows in the fitness graph to give a visual indication of the various cycles.

[YvesTri]

Thanks a lot @Gerald and @MedTechCD for your great support!! Now my graph is showing up in the ATP plan from Jan to June…

I will now input my goals, races, loads etc. Do you have a template for this planning that you can share with indication of the loads / duration ?

and the big question how to get this visualization?

@david it would be so cool to have all this built-in interval.icu directly

thanks again to everybody !!!
Yves

[Gerald]

@YvesTri

and the big question how to get this visualization?

1. On Activities Page
2. Click on the summary info (left or top, depending on your settings)
3. Click on the Bicycle icon (opens 4)
4. Add planned load (9) and planned duration (10), as well as distance.
5. Adding a note, allows to set for a mesocycle (add date range, and label). Once created, it shows on the fitness page (if block 8 has notes ticked).
6. On the Fitness page
7. Options opens block 8
8. Tick the graphs/charts you wish to view.
9. Training Load, for me, shows planned vs actual
10. Time in zones, for me, shows planned vs actual
11. there is no eleven
12. TiZ only shows in the future is a planned workout, using the workout builder shows details.
    
    

[YvesTri]

Thanks a lot Gerald! Now I must identify the loads for swim bike and run workouts… do you know if there is any template or suggestion for 70.3 races, goal 4.40h
And for this is there a template for this that you can share?