I filled out the second row with your formulas and then ran down the line.
Here is the effect:
regards
Artur
Column A and B is working, so you need to copy the other formulae to column C, D, E and F. In row 2, the copy down.
I just entered your formulas in 5 cells:
You confused the columns a bit because you described from “B to F” and they should be from “A to E”
Column “C”:
Column “D”:
Column “E”:
I filled the lower lines with a series of dragging “from the top”.
I am beginning to suspect that the reason may be that in my language (Polish) the names of the functions are different from the English ones: /
For example, “Average” means “ŚREDNIA” in Polish.
Reload the test file and give me TeamViewer id and PW via pm. Don´t load any data yet.
I have a licenced Teamviewer and was going to ask if you were open to that.
I want to check the entire datalog.
I can make some time in about 15 min.
1 Like
I had a remote session with @Artur_Chmielewski and it showed there is still a problem with the logic I’m using for the existing/non-existing columns for run_eftp.
I will try to correct as soon as possible.
1 Like
Thank you very much for your time and remote help with your project.
Now I have an iThlete chart 
regards
Artur
1 Like
This time it should be correct and you should not get any more errors caused by non-existing Run_eftp.
Also slightly improved the start-up error description. You will now first get the site authorization and then an error about connection refused until your athlete ID is entered.
@Artur_Chmielewski , @Luisma_Gallego_Soy_P : Can you guys check the latest version v1.3.2? You both were having troubles, sorry for that.
Link remains the same.
3 Likes
Thank you for your hard work and help.
I will check v1.3.2 tomorrow morning and come back with the answer.
Good night
Artur
I will test it tomorrow and give feedback. Thanks for your work
Hello @MedTechCD
V1.3.2 works like gold !!
right after opening it asked to enter apikey / pass even before I entered my ID.
After entering the ID and refreshing the data - everything was imported without any problems. The iThlete HRV chart presents the parameters beautifully
The data in the “Wellness” sheet in this version is now correctly formatted.
Great respect for you and @Gerald because he probably took an active part in creating your project. You are great!
greetings
Artur
2 Likes
@MedTechCD i have a question.
Is the “ATP” worksheet working or is it a matter of the future and maybe you are working on it?
greetings
Artur
EDIT:
I already know this sheet will not work:
“I’m happy to share anything that is freely available to find on the internet, that helps make someone else’s life / decisions a little easier (to make). The only reason I can’t share the planned TSS / hours per week on the ATP is because it’s not mine. I don’t have permission from the owner to share it (or rather they won’t give permission to share).”
Greetings
Artur
@MedTechCD , the text file make reference to @Gerald’s MAC/Manual download version and @Daniel_Harris’ Google sheets dev work.
If I can get direct URL’s for all three versions I’ll edit the OP with them all. Or there could be one URL to rule them all which contains links that you guys can update.
I’ve just created the help guide page, with links to the latest versions.
The idea would be to explain how the graph/tabs work.
3 Likes
Hmm, I can’t edit the OP. Is there a time limit on post editing?
@Luisma_Gallego_Soy_P You are on Windows and Office 2016 or higher?If so, can I have a look with TeamViewer at your system too?
Pm me the Teamviewer id and password if you agree. I´m available the next 4 hours.
1 Like
The new version works fine for me. The privacy tick box caused issues, when opening. Thereafter, once input my athlete ID number, it syncs.
Here is my data from v1.3.2
@Luisma_Gallego_Soy_P has problems because he uses the file for different athletes. I will make some sort of manual on how to use the file with multiple athletes without mixing up the credentials. The credentials will have to be entered on each file separately iso Global in Excell.
Will try to explain in more detail after dinner.
4 Likes
Sorry guys, a family matter came up yesterday evening and I will have limited time available the rest of the week.
I will follow up as soon as it is sorted out.