We, @Gerald and myself, have been collaborating on making an MS Excel file that pulls the wellness and activity data from the Intervals API. We both think that we have some exciting and more advanced features that could maybe, one day, make it to Intervals natively. But given the fact that @david already has a long todo list, we wanted to make these features available in a user-friendly way. You will need a device running MS Excel and that’s pretty much all you need to use the file.
The ReadMe tab gives you the information on how to setup the API connection. The file uses Excel 's Power Query Editor to make the necessary transformations on the csv data. The csv data comes in as US formatted and needs formatting to be used in for example Central Europe (dates, decimal point/comma, …). It should work correctly all over the world.
The Wellness and Activities tabs will be populated as soon as you have the connection setup.
The template for an Annual Training plan and the Sweat loss calculator are entirely @Gerald 's work.
And there is a tab with the iThlete HRV chart that I was finally able to finish by upgrading my Excel knowledge . If you have RHR and RMSSD in your wellness data, you should immediately see some results. I’m pretty sure there will be bugs and unexpected behavior, but I only tested this on my own data. things that are already on the todo list for that chart are:
-
Adding the Adaptation information
-
Providing a way to look at historical results by selecting a date. For now, you will only see the results for today.
I’m now as a first priority going to work further on the guide section for Power and Pace and will pick up on the HRV chart after that, if there’s enough interest.
Post any questions/remarks in this thread and we will respond as best as we can.
Hope you like the functionality.
Here is the link to the file. If it opens in Google worksheets, select “Make a copy” and save it somewhere on your device or on a cloud space. It will not work in Google, you have to open in MS Excel.
https://drive.google.com/drive/folders/1WhIOf2XkGiZBEN_7tX2PSShmF-QXBnBF?usp=sharing