# Recreate ithlete rHR/HRV chart? **URL:** \ **Category:** Uncategorized\ **Created:** [6 January 2022 03:23 UTC](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760 "2022-01-06T03:23:52Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Olly\_Thomas](https://forum.intervals.icu/user_avatar/forum.intervals.icu/olly_thomas/32/28972_2.png) [@Olly\_Thomas](https://forum.intervals.icu/u/Olly_Thomas)\ **Post date:** [21 September 2022 04:08 UTC](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760/21 "2022-09-21T04:08:58Z")
I had the same problem. To fix it go to your settings in intervals.icu and add a FTP value for running. I did this (just a random number as I don’t run) and pressed refresh all data in excel and it worked ---
**Author:** ![Luisma\_Gallego\_Soy\_P](https://forum.intervals.icu/user_avatar/forum.intervals.icu/luisma_gallego_soy_p/32/26303_2.png) [@Luisma\_Gallego\_Soy\_P](https://forum.intervals.icu/u/Luisma_Gallego_Soy_P)\ **Post date:** [21 September 2022 06:40 UTC](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760/22 "2022-09-21T06:40:10Z")
I have done the same ---
**Author:** ![Luisma\_Gallego\_Soy\_P](https://forum.intervals.icu/user_avatar/forum.intervals.icu/luisma_gallego_soy_p/32/26303_2.png) [@Luisma\_Gallego\_Soy\_P](https://forum.intervals.icu/u/Luisma_Gallego_Soy_P)\ **Post date:** [21 September 2022 06:49 UTC](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760/23 "2022-09-21T06:49:34Z")
I have tried it on another computer and I get this error when updating the data, on the laptop it works perfectly. ![image](https://forum.intervals.icu/uploads/default/original/2X/9/955d5605960449aa71c46bec66e5177fa27fceb5.png) ---
**Author:** ![MedTechCD](https://forum.intervals.icu/user_avatar/forum.intervals.icu/medtechcd/32/40383_2.png) [@MedTechCD](https://forum.intervals.icu/u/MedTechCD)\ **Post date:** [21 September 2022 07:31 UTC](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760/24 "2022-09-21T07:31:56Z")
The athentication with API\_KEY and your personal API-key needs to be done on any computer you want to use because the authentication is global within MS Excell. If you transfer the file with modified athlete ID, that will remain saved in the file and doesn’t need to be entered again. ---
**Author:** ![MedTechCD](https://forum.intervals.icu/user_avatar/forum.intervals.icu/medtechcd/32/40383_2.png) [@MedTechCD](https://forum.intervals.icu/u/MedTechCD)\ **Post date:** [21 September 2022 07:34 UTC](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760/25 "2022-09-21T07:34:02Z")
You are the second person with this error. I will check to see if I can find the source. If I understand correctly, you both had to add a value to the setting in Intervals? ---
**Author:** ![Olly\_Thomas](https://forum.intervals.icu/user_avatar/forum.intervals.icu/olly_thomas/32/28972_2.png) [@Olly\_Thomas](https://forum.intervals.icu/u/Olly_Thomas)\ **Post date:** [21 September 2022 07:35 UTC](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760/26 "2022-09-21T07:35:48Z")
Yes @MedTechCD - I didn’t have an FTP assigned to running in settings (as I don’t run 😬), but as soon as I set one and pressed refresh it works immediately. ---
**Author:** ![MedTechCD](https://forum.intervals.icu/user_avatar/forum.intervals.icu/medtechcd/32/40383_2.png) [@MedTechCD](https://forum.intervals.icu/u/MedTechCD)\ **Post date:** [21 September 2022 08:38 UTC](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760/27 "2022-09-21T08:38:34Z")
Most logical explanation is that the column Run\_eftp does not exist in the welllness.csv pulled from the API when there is no entry. Since the file uses Excel’s Power Query Editor to format the dates and numbers for all columns, the error is thrown by the editor because it can’t find that column in the source file. @david If above is correct, can you set the wellness.csv to always include Run\_eftp even when blank? There are other columns unpopulated that come through, so that should be possible? ---
**Author:** ![Howie](https://forum.intervals.icu/user_avatar/forum.intervals.icu/howie/32/41347_2.png) [@Howie](https://forum.intervals.icu/u/Howie)\ **Post date:** [21 September 2022 09:38 UTC](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760/28 "2022-09-21T09:38:42Z")
Wow, wow, wow @MedTechCD & @Gerald!! I’ve opened the spreadsheet in Excel but realised right away that I need to set aside some quiet, undistracted time to work my way through getting it setup. Thank you! Mahalo nui loa, for making this available. Having more input for making sound decisions is hugely appreciated. ---
**Author:** ![Gerald](https://forum.intervals.icu/user_avatar/forum.intervals.icu/gerald/32/28423_2.png) [@Gerald](https://forum.intervals.icu/u/Gerald)\ **Post date:** [21 September 2022 11:41 UTC](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760/29 "2022-09-21T11:41:27Z")
My own Excel file, which doesn’t show “run eFTP” is also now broken, which means the Wellness data is not downloading. Not sure if it’s related to the query you raised with David. ---
**Author:** ![MedTechCD](https://forum.intervals.icu/user_avatar/forum.intervals.icu/medtechcd/32/40383_2.png) [@MedTechCD](https://forum.intervals.icu/u/MedTechCD)\ **Post date:** [21 September 2022 12:11 UTC](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760/30 "2022-09-21T12:11:49Z")
If you don’t have any run activities and the Run-eFTP is not entered in settings, could you download the wellness.csv from the Calendar - Options - Wellness dialog? With the Include Fitness in csv option checked! Just to check if the column is present there? If you have the Power Query running when importing the data, the error is caused by that I think. ---
**Author:** ![Gerald](https://forum.intervals.icu/user_avatar/forum.intervals.icu/gerald/32/28423_2.png) [@Gerald](https://forum.intervals.icu/u/Gerald)\ **Post date:** [21 September 2022 15:45 UTC](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760/31 "2022-09-21T15:45:59Z")
My problem is fixed, but on my MASTER sheet only. I can download the Wellness data from the site, which has the run eFTP on it. Remember the query we spoke about converting from US to EU formatting? That specific code in the data link properties doesn’t show run eFTP. I have run data, and a made up FTP, it I don’t see an option to change eFTP, as I don’t have anything capable of recording running power. ---
**Author:** ![david](https://forum.intervals.icu/user_avatar/forum.intervals.icu/david/32/30189_2.png) [@david](https://forum.intervals.icu/u/david)\ **Post date:** [21 September 2022 16:38 UTC](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760/32 "2022-09-21T16:38:58Z")
The wellness CSV download includes eFTP for each sport that has an FTP set. That could be cycling, running, rowing, not sure what else. The idea is to not clutter the CSV with columns that will never have anything in them. ---
**Author:** ![MedTechCD](https://forum.intervals.icu/user_avatar/forum.intervals.icu/medtechcd/32/40383_2.png) [@MedTechCD](https://forum.intervals.icu/u/MedTechCD)\ **Post date:** [22 September 2022 11:13 UTC](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760/33 "2022-09-22T11:13:14Z")
I’m pretty sure that this is what is causing the error: ![image](https://forum.intervals.icu/uploads/default/original/2X/7/74136f4262c7e2bc4f4e091a95f79712cccc7dc3.png) The fact that the column name is in the transformations within the Power Query Editor kind of make it a mandatory column. Since we don’t know if the column will exist for a certain user, it might be best to just skip it in the transformations. But if it is there, it will be loaded as text for European users because the decimal dot is there. Taking this further, I wonder if athletes that only run and don’t ride will have this error for the ride\_eFTP? If those eFTP values would be integers, there would not be any problem. There’s very little I can do I think to solve this silently. I can off course add it to the ReadMe tab and instruct users to edit the Power Query which is in my opinion a more elegant solution then entering fake data in Intervals. What do others think? ---
**Author:** ![Ben](https://forum.intervals.icu/user_avatar/forum.intervals.icu/ben/32/28464_2.png) [@Ben](https://forum.intervals.icu/u/Ben)\ **Post date:** [22 September 2022 11:36 UTC](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760/34 "2022-09-22T11:36:59Z")
M has a function called `Table.HasColumns` that could be of use here ---
**Author:** ![Gerald](https://forum.intervals.icu/user_avatar/forum.intervals.icu/gerald/32/28423_2.png) [@Gerald](https://forum.intervals.icu/u/Gerald)\ **Post date:** [22 September 2022 11:39 UTC](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760/35 "2022-09-22T11:39:55Z")
My Master file doesn’t have that field showing in the query editor. ![image](https://forum.intervals.icu/uploads/default/original/2X/3/3bd3d1dbc9c9f98a623c15df2444798b1da49aa4.png) ---
**Author:** ![MedTechCD](https://forum.intervals.icu/user_avatar/forum.intervals.icu/medtechcd/32/40383_2.png) [@MedTechCD](https://forum.intervals.icu/u/MedTechCD)\ **Post date:** [22 September 2022 12:21 UTC](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760/36 "2022-09-22T12:21:21Z")
Thanks for the tip! Will try to implement that check. I’m very new to all of this, lots to learn… ---
**Author:** ![MedTechCD](https://forum.intervals.icu/user_avatar/forum.intervals.icu/medtechcd/32/40383_2.png) [@MedTechCD](https://forum.intervals.icu/u/MedTechCD)\ **Post date:** [22 September 2022 12:29 UTC](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760/37 "2022-09-22T12:29:32Z")
Confused… Your master file is throwing the same error even tough the column name isn’t present in the query? Didn’t you mention that your master file was working correctly? And @Olly_Thomas and @Luisma_Gallego_Soy_P added **FTP** in running settings, not eFTP. Not sure what @Val_tro edited. He was talking eFTP??? FTP is always available for editing in the running power settings. ---
**Author:** ![MedTechCD](https://forum.intervals.icu/user_avatar/forum.intervals.icu/medtechcd/32/40383_2.png) [@MedTechCD](https://forum.intervals.icu/u/MedTechCD)\ **Post date:** [22 September 2022 12:57 UTC](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760/38 "2022-09-22T12:57:45Z")
> [@MedTechCD](#): > > I will replace the date field by a date picker as soon as I get around the problems I’m having with it now. And after that a dropdown list to change the background to show Adaptation information. I already decided not to do the date picker and dropdown box, just to keep the file as simple as possible and avoid more complications when used in Excel for Mac and/or Google sheets. ---
**Author:** ![Gerald](https://forum.intervals.icu/user_avatar/forum.intervals.icu/gerald/32/28423_2.png) [@Gerald](https://forum.intervals.icu/u/Gerald)\ **Post date:** [22 September 2022 13:01 UTC](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760/39 "2022-09-22T13:01:54Z")
To stop the confusion, my master file is working. Seems when I have my master file open, as well as the v1.1 file at the same time, it shows as the error. When I have my master file open only, it works fine (but there is no run FTP showing in that connection). I have copied the iThlete file into my master, so I am working on my own file and not the v1.1. ---
**Author:** ![MedTechCD](https://forum.intervals.icu/user_avatar/forum.intervals.icu/medtechcd/32/40383_2.png) [@MedTechCD](https://forum.intervals.icu/u/MedTechCD)\ **Post date:** [22 September 2022 13:10 UTC](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760/40 "2022-09-22T13:10:55Z")
Ah, that makes sense. You can temporarely delete the run\_eFTp section in the query on the v1.1 and it should work. I will adapt the query following @Ben 's tip asap and make a new version available. [Previous page](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760.md?page=1) [Next page](https://forum.intervals.icu/t/recreate-ithlete-rhr-hrv-chart/5760.md?page=3)