Google Sheets Athlete Dashboard | Part 3 | Team & Positional Averages

[@stefanosgiogos7618]

Dude... You are amazing! Thank you for the value you give us! I have just saved hundred of hours trying to create a monitoring system for my athletes, just by watching carefully and using your tips! Keep up the great work! The world needs people to contribute, just like you! Regards from Greece!

[@DSMStrength]

Thank you so much!

[@stephanegervais8372]

Awesome! I can see the light at the end of the tunnel ;)

[@DSMStrength]

Thanks man

[@juishah4222]

This is really helpful , big thank you! I have a question regarding Team Avg score: why do you subtract min value from average then divide it by the difference between max and min?

[@Calumc12]

Hey mate, around the 6:50-7:30 mark, you do the team avg. data, using the average(index(data, ,match(B5, Headers))) I get a error returned saying it cannot find the name of the test (in your example, CMJ) in the match evaluation.

[@pscott585]

@DSMStrengh I created my own athlete dashboard from your videos in the fall and it's been very helpful. I was wondering if there was a way to get the team average and position averages to change on the graph. In this version, the averages are always the same, no matter the date. Is there a way to show the changing team and position averages on the data reference page and on the graph? Thanks for all the help!

[@Calumc12]

My second question would be on the Standard formula =ARRAYFORMULA(IF(B10:B "", MROUND(ARRAYFORMULA(((B10:B-$B$6)/($B$7-$B$6))*100), 0.5),"" )). This is returning an #REF! - saying the array could not be expanded as it would delete data in the cell below Any help or guidance on these two would be great. Calum

[@KarenMacDonald-k4j]

Question on the team and position averages...at around the 7.5 min mark, don't I want the averages and average score in rows 10 and below to be the average/avg score for that test date as opposed to the entire data set? Aka I want to see my player's score on 2020-01-01 and her team's average from that day of testing. That way I can see our team trend and her personal trend over time. Is there a way to do this?

[@mctraining4233]

Hi! I’ve hit a roadblock while using the averageifs function for pos Avg. I’ve made sure the filters and named ranges look correct multiple times. Do you have a suggestion where else I could look? or another formula i could use? Thank You!

[@DSMStrength]

If you do things the way explained in the video it will work

[@bryangreen4702]

My dates aren’t switch when I copy and paste the table. I assume something with the switch from B cells and J cells and the formula. It says “no matches are found in filter evaluation”. Any tips on how to fix that?

[@chimao10]

Awesome work and greatly appreciated. I have got a quick Question. Everthing works just fine, but when i put the 5m or 10m Sprint in to the Dashboard, the Standard changes to 30 and 50 and no longer out of a 100 on left side of the chart?

[@DSMStrength]

set the max / min values of ur graph to 100 / 1

[@chimao10]

@@DSMStrength Thank you it worked and i completed the whole Dashboard now. Your Videos took me from an absolute Newbee to quite decent right now. But i still got a lot to learn. I am looking to add a Wellness Questionnaire, with Google Forms and RPE etc, would you recommend just to expand this Dashboard or just create a new one. Greetings from Germany

[@DSMStrength]

@@chimao10 Going to work on doing some new resources on this in the future!

[@craigatkins3869]

Thank you so much! These videos have been amazing, and I have learnt so much. I was wondering, is there a way to make the 'select start dates' in the KPI charts specific for the individual athlete? I work with a number of individual athletes and test on different dates, so worry that I might end up with a huge list of dates.

[@DSMStrength]

Hey Craig, Thanks so much for reaching out. I really appreciate you taking the time to watch my videos. To do what you asked you would just have to look up the start date from a master database or something, not really very difficult to do.

[@subrotoopal1158]

hii sir, i am getting an error in data reference sheet after entering formula in position avg . this is the error (Evaluation of function AVERAGEIFS caused a divide by zero error.)please can you solve my problem.

[@DSMStrength]

re-check your formula and evaluations often times this is a typo or spelling mistake somewhere. otherwise what you are trying to averageifs does not have data or has the wrong data

[@dw7859]

what is KPI

[@DSMStrength]

key performance indicator.. term used to represent something worth measuring