Google Sheets Athlete Dashboard | Part 6 | Percent Change & Trend Graph
HTML-код
- Опубликовано: 22 авг 2024
- In part 6 of the google sheets athlete dashboard series we finish off the dashboard by adding sparklines, and a percent change calculation. We finally made it great work!
► Support the Google Sheets Dashboard Series HERE: www.buymeacoff...
►Purchase the Set & Rep Planner HERE: bit.ly/35PfOhz
SUBSCRIBE TO DSMSTRENGTH: bit.ly/3xRrNH7
[Books I Love] Support the Channel
►Periodization: amzn.to/2mOiBDA
►Strength Coach Guide to Excel amzn.to/2xAEZ4p
►Strength Coach Playbook: amzn.to/2mY9crI
►Principles and Practice of Resistance Training: amzn.to/2mM1Jf6
►High Performance Training for Sport: amzn.to/2mqWb74
[Connect with Me]
►See all Strength Coach Tutorials: bit.ly/2mLU5Bf
►Check our website: www.dsmstrength...
[Social Media]
►Instagram: / dsmstrength
►Twitter: / dsmstrength
►Facebook Page: / dsmstrength
Dave, thank you. These videos are incredibly helpful and have raised my programming game significantly just from watching a handful of these video series. Very admirable that you not only sell the finished product, but you also post these videos showing coaches how to construct these resources for themselves. Keep up the great work.
Hey Sam,
thank you so much for taking the time to check out the videos. I hope that I am helping coaches create things that are useful to them. Just trying to grow this channel any help you can give sharing would be appreciated
Dave, this series of videos has been incredible. As an S&C coach, these should be part of the coaches curriculum. Awsome, thank you so much.
Fantastic series of videos with the Athlete Dashboard. Walked through them all and set up my own variation based on what you laid out. Thank you so much for the great content!
This was awesome. Thanks so much for sharing your skills, Dave!
Amazing work sincerely ! Congrats from France !
you are welcome
Thank you very much for this valuable tutorial. You helped me learn a lot of new Google spreadsheet skills. Each of the six lessons was repeated after you and everything worked out. Great job!
Спасибо большое за этот ценный урок. Вы помогли мне освоить много новых навыков в работе с гугл таблицей. Каждый из шести уроков повторял за вами и всё получилось. Отличная работа!
Very helpful...thank you so much
Thanks man, really good video and channel all around, keep it up!
Thank you man! You are amazing! Thanks for the help!
Wow thank you so much for the comment.
I am glad that you liked the videos!
Thank you for making these dashboard series, it is really helpfull!!!
Thank you from William Penn University!!
Thank you too much!! Help me a lot!!
great glad to hear it!
This was great! Thank you for sharing!!
Sick! Thank you so much :)
Thank you very much !! :)
Is there a way to print all the athletes of at once? (instead of cycling through each athlete) Would be a great help for larger teams.
Thank you for the content! Great stuff.
Yes there is but it's far to complicated for a tutorial.
Great content and very easy to follow. The only issue I’m having is that I can’t seem to get the score figures above the dates in the Trend section which then leads to not showing an increase or decrease in the % box. I have my Sparkline graph. Any suggestions please
Hi, first of all, thanks for this great series! I’ve had an issue with the trend line section, I keep having an error, google sheets tells me the index function can take only 3 arguments, and this is more. Just wondering if you had any solutions? Thank you ☺️
This dashboard is amazing. Thank you for sharing this info. I have one issue though, when I made the sparkline trend lines, the line is opposite of the percent change. For example, if the percent change for bench press is positive, the trend line goes down. But if the percent change is negative, the trend line goes up. Any suggestions to fix this?
These videos were extremely helpful, thank you for posting them. As I add to my roster can you tell me how I would be able to make some athletes inactive so that I am only able to view athletes on the current roster?
some sort of selection box that gives them this value, then just in your filter formulas filter out their data based on whether or not they are active / in active
Hi, how can change from 150 to 343 in a squat can be only 56.27% change?
Formula should divide by G21, not h21
yep you are correct my mistake
Hey man, how can the team average score and position average score always be the same over time? It shows as a straight line
because it is an overall average not just for the specific date
i need help. How do you do the sparkline on excel???
Do you know how maybe we could extract images during those dates marked on the kpi trend report? if maybe we wanted to upload a body comp pic to the data tab every test they completed
You would just have to manually enter the picture and do a vlookup same way we did for the athlete headshot
@@DSMStrength will do, thanks
@@DSMStrength I actually ended up using the one we used for our results in the score cell, this way it pulls my images from that specific start date and then i added another one for the end date.
it ended up being sthg like this (i put my athlete name in b2)
=SI.ERROR(FILTER(INDICE(DATA,,COINCIDIR("Foto 2",Cabezales,)), INDICE(DATA,,COINCIDIR("Nombre del atleta",Cabezales,))=$B$2, INDICE(DATA,,COINCIDIR("fecha",Cabezales,))=G22), "No hay prueba")
Hi I changed the name of the metrics and it shows me no test but the trend lines are visible
make sure that all your formula references are correct, and that you have the test set up sheet correct
How do I flio the sparkline so that for values that low is better it is an increase on the graph
Same question here, did you ever figure this out? Thanks in advance!
manipulate the data first by multiplying by -1 or taking the inverse, then create sparkline on inversed data.
of you could do the calculation in the formula you use to pull your data with
Hey! First of all - DSMStrength - you rock!!! This one is a HUUUUGE masterpiece :)
Back to the question asked. After many failed attempts to implement this for my coaches, because of this issue, I finally figured it out. And then - I was like - "So, that simple?!" :D
Will reference formulas used in this video.
Key formula is in the cell "I21" --- if(vlookup(F21, 'Test Set Up'!A:B, 2, false) = TRUE, -1, 1) ---
Then I inserted it in sparkline formula like this --- =iferror(if(vlookup(F21, 'Test Set Up'!A:B, 2, false) = TRUE, sparkline(filter(index(Data * -1,, match(F21, headers,)) etc.
So - for value if true (for if statement) - comes all that long sparkline formula but for first index you multiply DATA by -1.
Then for value if false (for if statement) - copy/paste all that long sparkline formula as it was originally. Mine looks like this:
=iferror(if(vlookup(G21, 'Test Set Up'!A:B, 2, false) = TRUE, sparkline(filter(index(Data * -1,, match(G21, Headers,)),
index(Data,, match("Athlete", Headers,)) = $C$3,
index(Data,, match("Date", Headers,)) >=H22,
index(Data,,match("Date", Headers,)) =H22,
index(Data,match("Data", Headers,))
I have bought the document.... if I want 10 athletes or more, can I easily create more athletes? or how can i do it?
you should be able to.
if you have purchased the document you should be able to log into my website for private questions in the customers forum
Wow really cool and inspirational videos. Do you have a template of this Google sheets as well? I couldn't find it in the links.
For sale on my website @ dsmstrength.com
Thank you for watching
@@DSMStrength Thanks for you super fast response! It wasn't immediately clear that it was the same sheet. Looking forward to using it!
Is it possible to add males and females and have the dashboard compare averages to the corresponding gender? TIA!
yes once you have created you can filter for whatever you want
hello, how can i do the down and up triangle on excel??
nevermind i found it
Hi! This is posible to do in excel?
It is but not the same way