ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
General remarks
2
ATP sheet: Rows 21-31 must not be hidden otherwise the graph data will not show. The current row height is 0.1, so it looks hidden
3
Protected sheets can be unprotected without pasword. It's simply to avoid accidental changes. We have nothing to hide.
4
When updating to a more recent version: check "Update remarks" below
5
6
Getting started
7
Mac OS users will need to manually download the WELLNESS.csv and ACTIVTIES.csv data from Intervals.icu on the ACTIVTIES page.
8
The download files must be saved in the same location each time a new download is processed. In most instances, the Downloads folder is the default.
9
10
11
12
13
14
15
16
If you move the file to another location, you can change the location in the Data > Get Data (Power Query) option.
17
Click on Change file path, and browse to the location where the file is saved.
18
The file name needs to be the same. When downloading, the file might be renamed with (2) or (002) or _2 depending on your computer setup.
19
Delete the original file, then rename the new file so that it shows the following (replace xxxxxxx with your athlete ID):
20
Wellness:
athlete_xxxxxxx_wellness.csv
21
Activities:
xxxxxx_activities.csv
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
To update the data in the file, once the download is in the correct location, use Data > Refresh All
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
Update Remarks
52
If you are using the ATP sheet, don't simply replace your current workbook with the updated one because you will loose all data entered on the ATP!
53
The other sheets do not contain user entered data, so that's no problem.
54
Instead, follow this step-by step instructions to only update the iThlete HRV sheet.
55
Open both workbooks, your current one and the new updated one. You will only be able to do that if they are named differently!
56
In the View menu, section Window, select View Side by Side
57
In your current workbook, delete the iThlete HRV sheet
58
Hold "ctrl" and drag the iThlete HRV sheet from the new updated workbook to your current workbook in the same location to copy the sheet
59
Unprotect the sheet by rightclicking on its name
60
While on the iThlete HRV sheet, in the Data menu, section Queries & Connections, click on Edit links
61
Once done, make sure to protect the sheet again to avoid accidental changes
62
Your Athlete ID and API key is not required in this version, as you're using a manual download option.
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100