APPS in EXCEL - a guide to getting started

Really hope you find out a way to make this work, since it’d be a really useful spreadsheet. I’ve been experiencing the same problems described by @Artur_Chmielewski and would be happy to know how you fare this afternoon. Thank you both.

1 Like

Tomorrow we return to the topic, we will let you know how we finish.

2 Likes

Where can I find the Excel-version?

Let me know if you can´t get it. Link should still be valid.

Hi everyone, I am mostly doing trail running. Could this tool also help me building my training? Or is it very specific to cycling?

There were a few things covered by the Excel document, that has been superseded by the MATLAB application:

HRV tracking
Readiness to train

The annual training plan (ATP) and sweat rate calculator are the others, that can still be done using the Excel form.

Ok, so if I understood correctly, it is better to work with the MATLAB version since it has all the features?

If your HRV data is captured (manually or integrated through an app, eg. HRV4Training) in your wellness data, then the integration with Metlab will read and write suggested data back to Intervals.

The excel file was the first (alternative) iteration of the iThlete graph.

Ok, thank you a lot! I think for now I need to get around more with all the possibilities offered by Intervals.icu and once I found a workflow to add most of the metrics into Intervals I will look for the MATLAB tool.

Many thanks for your reply!

1 Like

The thread for the Matlab tool is here:

1 Like

Hi @Gerald and @MedTechCD If I just want to use a tool for ATP and sync activities to plan to check compliance I seem to be struggling with all options currently:

The online gSheet (copy) only imports my wellness not activities, the 1.6 Excel (download on Win11) version gives me Access to the resource is forbidden despite using the API_KEY and then my API as password. This is after ignoring privacy.

Is anyone else managed to get this working for ATP - I am not clear is the ImReady option has this functionality?

Thanks all - much appreciated.

The gSheet and the ImReady4 app don’t have the ATP. Only the Excel sheet has that. In the Excel sheet, you can ignore the iThlete tab. Both HRV options on the gSheet and in the Excel are now legacy because the ImReady4 app is much more user-friendly.
Once your connection is made correctly (see below points of attention), both the Activities and Wellness tabs should populate.

The 2 most common errors causing this sort of data access problems are:

image

First, in user name (above screenshot), you need to enter the string “API_KEY” literally. So NOT your api-key, but the exact string as it is here. Check the URL at the top of the dialog to confirm that the xxxxx is replaced with your AthleteID.

Second, the Password that you need is the api-key found on the settings page of Intervals:

If you have entered your AthleteID (also found on the settings page) and followed the rest of the instructions on the ReadMe page, you should have all your data coming in.

If you still have problems, get TeamViewer Quick Support and send me a PM. We will find a time window that suits us both and I will try to help you out remotely.

3 Likes

Have you managed to make it work for you, yet, using the advice from @MedTechCD ?

1 Like

Thanks both. I think it’s as my work laptop (personal is a Mac) and they don’t allow the remote support. I found a code for TP so will do the ATP on there and transfer it to Intervals.

Got the HRV side working now thanks.

1 Like

The ATP on TP is certainly much easier to use, providing you have a subscription, or you’re on a trial period to set it up.

The Excel file doesn’t work well on a Mac, due to limitations on the Power Query Editor. I use the file on my work PC (Win 11) as there are no restrictions when using Excel Get Data, even on a restricted-use PC.

1 Like

Hi @Gerald and @MedTechCD .
I updated my Athlete ID and API Key on Google Forms and no errors are reported in debug mode, but I can’t get the activities to download.Pls help



The Google Forms version is no longer being updated/maintained. The Excel version is the only one that is.

Tks,then where can I get the Excel version

Yep, getting started with apps in Excel can seem tricky at first, but it’s actually pretty straightforward once you get the hang of it. I played around with a couple of them for organizing my finances, and it made things way easier. If you’re just starting out, the Free Microsoft Excel Tutorials are a great place to learn the basics and get more comfortable. I used one of their guides to set up an app for tracking expenses, and it helped me understand how to connect everything in Excel. Super useful if you want to keep things simple but still get the most out of the features.