Great Content ! I have only one question. What I have to do if an athlete doesn't participate to a session ? RPE=0 or I don't have to count him in that date/session ?
Hi John, awesome content as always. My only question is, what if you have multiple sessions on the same day, what would you then change to this spreadsheet?
Good question. There are 2 options depending on what your main objective was. If you want to daily reports, weekly reports etc then you don't need to do anything as the pivot tables will just give you daily totals regardless of whether there is 1 or multiple sessions per day. However, if you want to create session reports then you need a unique label for each session such as 23 February 2020 AM or 23 February 2020 Gym Session. I would add an extra column to the data table to allow for this unique label to be created (or manually typed in).
Awesome Video! Would you recommend any other of your videos in regards to basic athlete load monitoring or other ideas? I'm a strength and conditioning coach at a university and we have limited funding/budget, so a lot of equipment/technology unfortunately we cannot purchase (GPS, Heart rate monitors, Heart rate variability, etc...). Any thoughts or ideas, I would love to chat with you.
Best thing to do is get started! Collecting clean data and keeping it well organised is the number 1 priority. Watching video 88 might also be worthwhile.
@@JohnLythe thank you for the reply! I will definitely watch video 88. Do you have a template/video for calculating the beep test (yo-yo intermittent recovery test 1) for MAS (Maximal Aerobic Speed)?
hey data freaks 🤟🏻 anyone using Google forms to harvest acute chronic workload data? to Get a rolling average for Standard Deviation I need 4weeks of data. is It essential I get data every single day? lets Say they go hard then don’t record for 4days and go hard again how does it know theres been 4days rest? It would interpret same as if the Days were back to back (obviously more fatigue from back to back hard days than 4 days recovery) Am I making any sense or has excel finally scrambled me. Any nudges in the right direction or resources hugely appreciated. Peace, JT
Thank you, dude! That's was awesome gift for every Strength and conditioning coach.
Thank you for uploading this video, very helpful and you make it easy steps to follow
This deserves more love, thank you!!
This is great. Thank you for making really quality content!
Amazing! Thanks so much for this
Great Content ! I have only one question. What I have to do if an athlete doesn't participate to a session ? RPE=0 or I don't have to count him in that date/session ?
Very helpful.
DANKE...VERY USEFUL VIDEO....
Great tutorial! Thanks a lot :-)
thank you so much!!
Hi John, awesome content as always. My only question is, what if you have multiple sessions on the same day, what would you then change to this spreadsheet?
Good question. There are 2 options depending on what your main objective was. If you want to daily reports, weekly reports etc then you don't need to do anything as the pivot tables will just give you daily totals regardless of whether there is 1 or multiple sessions per day. However, if you want to create session reports then you need a unique label for each session such as 23 February 2020 AM or 23 February 2020 Gym Session. I would add an extra column to the data table to allow for this unique label to be created (or manually typed in).
@@JohnLythe Awesome John, thanks very much!
@@JohnLythe How do I enter an equation TRIMP and EDWARDS, it is rather difficult
Awesome Video! Would you recommend any other of your videos in regards to basic athlete load monitoring or other ideas? I'm a strength and conditioning coach at a university and we have limited funding/budget, so a lot of equipment/technology unfortunately we cannot purchase (GPS, Heart rate monitors, Heart rate variability, etc...). Any thoughts or ideas, I would love to chat with you.
Best thing to do is get started! Collecting clean data and keeping it well organised is the number 1 priority. Watching video 88 might also be worthwhile.
@@JohnLythe thank you for the reply! I will definitely watch video 88. Do you have a template/video for calculating the beep test (yo-yo intermittent recovery test 1) for MAS (Maximal Aerobic Speed)?
is this design suitable for 1 athlete?
As a concept yes but i would think a redesigned spreadsheet would be make sense for just 1 athlete
Muito bom, dicas muito boas.
PivotCharts seems to not working on Mac Excel 2016...
No they don't work yet on the mac. Microsoft are adding one feature at a time so hopefully it wont be too long
Okey. Thanks for your videos, they are great.
9:50
hey data freaks 🤟🏻 anyone using Google forms to harvest acute chronic workload data? to Get a rolling average for Standard Deviation I need 4weeks of data. is It essential I get data every single day? lets Say they go hard then don’t record for 4days and go hard again how does it know theres been 4days rest? It would interpret same as if the Days were back to back (obviously more fatigue from back to back hard days than 4 days recovery) Am I making any sense or has excel finally scrambled me. Any nudges in the right direction or resources hugely appreciated. Peace, JT
What is you email?
Email is listed 10 seconds from the beginning