excellent video! great job, inquiries: 1. What does the TSA mean? 2. The letter T_, what does it mean? 3. In regards to sprinting, how far is it applied? in 5 meters or 10 meters? sometimes I get lost in the language, but it is part of learning. God bless you!
Thank you for watching The T_ represents that we are calculating a T-Score which is just a z-score that has been scaled to be between 0-100 (easier for athletes to interpret) The distance of sprint is irrelevnat use whatever is useful for your population
Hi! First off, congratulations on your amazing work, it is truly great for coaches, but I believe there’s an error in t-scores for broad jump and sprints in the excel, given that when you expand the formulas for the t-scores, the input values of T_Broad and T_Sprint use Z_SQ and Z_DL for the calculations, so the values are the same as T_SQ and T_DL
Man great video and really really good to help the athletes to visualise their performance. Can i bother you with a question? Ive done it in excel and works perfect, but when I pass the doc into a Google Sheet version it does say error in the T and Z values formula, also the athlete names do not show up on the scroll arrow. Any suggestion?
Great video and help. Thanks. Quick question... Is it possible to create a main data sheet, where I load all the data collected (so i only fill in all tests and results and info in one place and always draw from here. Names, dates, test results, etc) and then have a smaller/secondary data table where I can choose the headers and based on the headers and names of athletes only the results for the tests ive selected pops up? Or if I change the date only results for those dates pop up? Not sure if there is a video that can help me on this? Not sure if its possible and hope it makes sense.
What if in my data set I have athletes that were not able to take part in a certain test (i.e. injury)? This affects my entire data set. What would I put into their cell under the test they were unable to take part in for it to not affect my data set?
Great Video - When I try to put in the formula for TSA Athlete I get a #SPILL! error message. Cannot seem to figure this out and was wondering if you or anyone had any isight? Thanks!
Love the video, what can Mac users do if we do not have the "Filter" Formula available? Apparently this is an issue with recent (2022) versions of Excel. Any advice?
i would do it in google sheets. I have several videos on google sheets dashboards. this is the main reason I moved away from excel there are to many differences between the versions for me to help the most people possible. but anything we used filter for you can do with index/match it is just way more cumbersome
Great Video! Thank you so much! My only question, right when I got to the very last step with the Team TSA chart. The horizontal bars are slightly below the athlete's name. How can I fix this? I tried centering the font, which fixed all, except for the red bar (i.e., the athlete who's name shows up in B2). Thank you again, great work. Cheers.
I solved it by making the bars wider. Is this what you'd recommend? I have a roster of only 13 players so it works fine and looks more balanced anyways
10/10 Extremely helpful. Athletes & Coaches love being able to objectively see where everyone stacks up.
Thank you very much for watching!!
I give you 100/100. It was a great help. Thanks
excellent video! great job, inquiries: 1. What does the TSA mean?
2. The letter T_, what does it mean?
3. In regards to sprinting, how far is it applied? in 5 meters or 10 meters? sometimes I get lost in the language, but it is part of learning. God bless you!
Thank you for watching
The T_ represents that we are calculating a T-Score which is just a z-score that has been scaled to be between 0-100 (easier for athletes to interpret)
The distance of sprint is irrelevnat use whatever is useful for your population
Hi! First off, congratulations on your amazing work, it is truly great for coaches, but I believe there’s an error in t-scores for broad jump and sprints in the excel, given that when you expand the formulas for the t-scores, the input values of T_Broad and T_Sprint use Z_SQ and Z_DL for the calculations, so the values are the same as T_SQ and T_DL
Great video! Any chance of showing how you would track this over time/season? And compare to the athletes previous best score in another radar plot?
MUCHAS GRACIAS POR LA INFORMACION
you are welcome
Great work 👏💪
thanks so much for checking out the videos coach!!
amazing!!! thanks👍👍👍👍
Thank you! Cheers!
Great vid
thank you
Great video
Glad you enjoyed it
Please share!
Do you have any models for Recovery Stress Questionnaires?
Man great video and really really good to help the athletes to visualise their performance.
Can i bother you with a question? Ive done it in excel and works perfect, but when I pass the doc into a Google Sheet version it does say error in the T and Z values formula, also the athlete names do not show up on the scroll arrow.
Any suggestion?
It will not work in Google sheets the way the video explains because the formulas we use are not the same in g sheet
I do have plenty of videos though on doing different types of dashboards and stuff in gsheets
@@DSMStrength I see now, thank you very much again and great stuff what you ve done and the way you share it.
Suppose in sprint column 6 athletes didn't perform( so zeros) ..how to deal with that?
Hi there, would you be able to type out the Equation used at minute 25:46? The screen I'm watching on can't seem to show it clearly :)
Great video and help. Thanks. Quick question... Is it possible to create a main data sheet, where I load all the data collected (so i only fill in all tests and results and info in one place and always draw from here. Names, dates, test results, etc) and then have a smaller/secondary data table where I can choose the headers and based on the headers and names of athletes only the results for the tests ive selected pops up? Or if I change the date only results for those dates pop up? Not sure if there is a video that can help me on this? Not sure if its possible and hope it makes sense.
What if in my data set I have athletes that were not able to take part in a certain test (i.e. injury)? This affects my entire data set. What would I put into their cell under the test they were unable to take part in for it to not affect my data set?
You can just put something like an x in there
Best athlete overall is 14 with tsa of 364 right?
Great Video - When I try to put in the formula for TSA Athlete I get a #SPILL! error message. Cannot seem to figure this out and was wondering if you or anyone had any isight? Thanks!
Thank you it means the results are trying to expand but there is something in the way. Clear the cells below the formula
@@DSMStrength thanks! Works seamlessly now!
anyone know how to fix the 'Filter' function when working on mac?
I am not sure as I do not work on mac but anything I did with the filter function can be accomplished with index(match)
when i type FILTER function the function is not available in the EXCEL, i can only see FILTERXML function, how could we solve this?
You do not have a version of excel that has filter. You should update your version of excel
Love the video, what can Mac users do if we do not have the "Filter" Formula available? Apparently this is an issue with recent (2022) versions of Excel. Any advice?
Basically, I'm asking if there is any alternative
i would do it in google sheets.
I have several videos on google sheets dashboards.
this is the main reason I moved away from excel there are to many differences between the versions for me to help the most people possible.
but anything we used filter for you can do with index/match it is just way more cumbersome
Great Video! Thank you so much! My only question, right when I got to the very last step with the Team TSA chart. The horizontal bars are slightly below the athlete's name. How can I fix this? I tried centering the font, which fixed all, except for the red bar (i.e., the athlete who's name shows up in B2). Thank you again, great work. Cheers.
I solved it by making the bars wider. Is this what you'd recommend? I have a roster of only 13 players so it works fine and looks more balanced anyways
Hey Shannon..
I'd need to see it but if it looks good to you then that is all that matters.
my excel has only the 'FILTERXML' comand how can i insert the 'FILTER' comand?
I believe you will need to upgrade to 365
What does it mean? I have to pay a subscription to Microsoft Office? Or I can simply download a free version? Thank you!
Great video, do you have a contact email?
thanks for checking out the video dsmstrength@gmail.com