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
3 жыл бұрын
Stefanos thank you very much
@lusheslou34
2 жыл бұрын
First off thank you for these videos! They’ve made a big difference in my programs! I’ve finished the whole tutorial but when I try to add more tests it messes up the trend reports. I can’t figure out how to fix it.
@DSMStrength
2 жыл бұрын
probably your named ranges have not updated
@alexo5190
Жыл бұрын
In order to do all this stuff, did you take a data analysis course? Or what textbooks did you read to understand all these concepts?
@DSMStrength
Жыл бұрын
Just figured it out by necessity... needed to create solutions for athletes and teams I have worked with.
@cademitchell6930
Жыл бұрын
Could you follow along this video in excel?
@stephanegervais8372
3 жыл бұрын
Awesome! Ok I'm done. Let's get part 2 :)
@DSMStrength
3 жыл бұрын
Haha its coming pal thanks
@Ethancraw6679
2 жыл бұрын
Any specific place to find those clipart headshots?
@markjan9577
3 жыл бұрын
Hi, having problem with the arrayformula (vlookup when we want the position from another sheet, cant copy/link "position" from athelete info to the data sheet.
@DSMStrength
3 жыл бұрын
from what you are explaining you shouldnt need to do an array formula for this.. simple vlookup should be enough
@markjan9577
3 жыл бұрын
@@DSMStrength Ok, I just followed your instructions in the video. From around 7.17 in the video everything went south and i get an error. Maybe my limited ability to express myself in english makes it harder too 😕
@alaeddinetaguia6536
3 жыл бұрын
@@DSMStrength I have the same issue when I try to add athlete info that’s make Error
@markjan9577
3 жыл бұрын
@@alaeddinetaguia6536 it worked for me when i changed , to ;
@user-cq6nz8vu6p
8 ай бұрын
Just purchased the Google Sheet from your website. Everything seems to be working correctly except the leaderboard is not populating the "athlete name". All testing data and other info on Leaderboard is correct, but the name boxes are blank. Any suggestions?
@canyonolsen8345
3 жыл бұрын
Thank you for the content. I have one quick question. The trend report works great, but when I go to add another test in the data sheet, the trend report equations stop working. Any idea on this?
@DSMStrength
2 жыл бұрын
some things to check 1. is there more than one value per date? if there is I believe the way the formula is set up will not work 2. is the references for your trend report looking at all of the data?
@kevinmarulandacasas3070
2 жыл бұрын
Amazing from colombia
@adamrankin1919
2 жыл бұрын
Coach, I have a large number of athletes. Is it possible to filter the athletes names by their sport on the KPI Dashboard to find athletes easier? In excel, I'm able to use the INDIRECT function within Data Validation, but with Google Sheets it won't let me. I've added a dropdown box for Sport on the KPI Dashboard and now trying to figure out how to make ONLY the athletes for the sport I select, show up in the drop down box in B3. THANKS!
@DSMStrength
Жыл бұрын
Need to create another range probably put it in controls
@ermogenescampos6300
3 жыл бұрын
Hi, from Brazil! Great job! Easy explanation. Thank you very so much. When will the part 2? Thank's
@DSMStrength
3 жыл бұрын
Wow.. thank you so much for watching the videos!! I am trying to release the second video Wednesday. Stay tuned!
@ermogenescampos6300
3 жыл бұрын
Thank you. Sorry my english. Very Nice job!
@lowbarmike
3 жыл бұрын
this is sick!!!! :)
@DSMStrength
3 жыл бұрын
Mike thanks so much man working on part 2 today!
@danostberg3967
2 жыл бұрын
I am trying to perform the array formula and I followed everything step by step, however I getting an error message. Do you have any suggestions on how to fix this?
@DSMStrength
2 жыл бұрын
Hi dan without seeing your sheet it is hard for me to troubleshoot for you. I assure you though that if you have followed the steps the formulas do work as intended. Make sure there are matches in your data, or that you dont have multiple matches for the variables you are trying to return etc. Thank you for watching
@danostberg3967
2 жыл бұрын
@@DSMStrength thank you for your reply. I've been looking at my formula and all the data. Here is what I have below: =arrayformula(if(A2:A"",arrayformula(vlookup(A2:A,'AthletesData'!A2:F,4,FALSE))"") I keep getting an error message instead of loading the position for that particular player.
@CoachArian
3 жыл бұрын
Great stuff!
@DSMStrength
3 жыл бұрын
Thanks for watching coach
@dubsondubs
2 жыл бұрын
Thanks for this coach! When I’m transferring data and tests, is it important to keep dates in a specific order? Also, there are many times when the date only has 1 test, so there are many empty cells. Is that ok?
@DSMStrength
2 жыл бұрын
1 yes unless you want to build sort functions into ur formula 2 yes no problem you could modify for your needs and have other data tabs if you wanted but empty cells are ok
@dubsondubs
2 жыл бұрын
Thank you!! So it’s best to have earliest date at the top and within that, alphabetically by name?
@hyoh
3 жыл бұрын
Amazing !
@DSMStrength
3 жыл бұрын
Thank you for checking out the video!
@Uiesegi
3 жыл бұрын
Amazing work! really helpful
@DSMStrength
3 жыл бұрын
Thank you!!
@MACStrengthPerformance
3 жыл бұрын
This is awesome!
@cahuelfranco2098
2 жыл бұрын
Hello Coach, thanks again for another amazing tool. Just a quick one, in the firs formula of the video =ARRAYFORMULA(if(A2:A "", ARRAYFORMULA(VLOOKUP(A2:A,'Athlete info'!A2:F,4, FALSE)), "")) it shows up as error saying: Did not find value '1' in VLOOKUP evaluation. Any idea? thanks again
@DSMStrength
Жыл бұрын
Looks like you have commas between f4 they shouldn't be there
@varunghosh2384
3 жыл бұрын
Hey great content. Can you do couple ones on wellness, training load and performance (e.g no. Of sprints or touchdown etc in sport) for Google sheets?
@DSMStrength
3 жыл бұрын
Hey coach thanks for checking it out I am going to finish the series on this dashboard and then maybe re explore training load calculations again.
@varunghosh2384
3 жыл бұрын
@@DSMStrength keep it up, I wish you all the best.
@varunghosh2384
3 жыл бұрын
I have come across couple of problems, one with the transponse and array formula. Got any clues to why?
@canyonolsen2388
3 жыл бұрын
What would the array formula look like on excel?
@DSMStrength
3 жыл бұрын
i havent made this particular dashboard in excel. But excel handles arrays much better with things like filter etc.
@alexouzounoglou9931
2 жыл бұрын
Can this be done on excel?
@pen3789
Жыл бұрын
on the data tab you only use 3 names and a lot of stats/dates. I have 18 athletes. I have to list each one with all those dates?? I'm only "testing" them 3-4 times a semester. so do i need dates of test for each individual athlete??
@DSMStrength
Жыл бұрын
I do not understand your question I am sorry.
@bryanhopper6872
Ай бұрын
Can I just buy this from you
@priceholmes2610
3 жыл бұрын
Coach, awesome work! I've completed all of the videos and it worked great(I just made up 10 athletes and put in numbers in each test). What is the easiest way for me to convert my current data(from google sheets) into the data page? For example, if I only have a Fly10yd from a particular group of 15 baseball players on, say "2020-02-04", will I leave all of the other data blank?
@DSMStrength
3 жыл бұрын
Yep that should work! Best advise is put ur dates in order as well you can use a sort function.
@priceholmes2610
3 жыл бұрын
@@DSMStrength Thanks for the quick reply! Is there another way to format my data page for entering the data? I have all of my data sorted by dates, but, will I expect to have several thousand rows of data on the main data tab? For example, if I have 65 football athletes, and have 15 different dates of a fly 10y, will I have 975 Rows of data for that one metric?
@DSMStrength
3 жыл бұрын
@@priceholmes2610 Hey Price, Great chatting on the phone today. Ill take a look at the info you sent me!
@priceholmes2610
3 жыл бұрын
@@DSMStrength Thank you so much for the help and the quick replies! GREATLY APPRECIATED!!!
@shockersportsperformance6270
2 жыл бұрын
@@priceholmes2610 any chance you could update me on the answer to your question on having hundreds of rows of data to enter? Thanks in advance!
@fullcircleathletics8183
Жыл бұрын
The only problem i'm having is with the dates. It does't track down the entire row. Only the first two.
@DSMStrength
Жыл бұрын
what are you referring to?
@Erock1275
Жыл бұрын
can you do one for excel
@DSMStrength
Жыл бұрын
I could.. Curious why you would prefer to use excel over Google sheet? The problem with excel is there are many versions between years, and operating systems and they all work a little differently
@Erock1275
Жыл бұрын
@DSMStrength Yeah sorry I'm loving your Excel series. Watched all your episodes. Makes sense with what you're saying though. I'll give it a go on Sheets
@trenerportal
Жыл бұрын
Hey! I have one question - is there any option to buy this Google Sheet Temple? :)
@DSMStrength
Жыл бұрын
yep! on my website
@Joseph_Principe
2 жыл бұрын
Can I buy this template from you?
@DSMStrength
2 жыл бұрын
Yes it's for sale on my website dsmstrength.com
@Joseph_Principe
2 жыл бұрын
I see you have 4 products, is it just the "Set & Rep Planner" I was hoping to get the spreadsheet that has the player profile section too. Like you have at the beginning of the video. Thanks.
@DSMStrength
2 жыл бұрын
@@Joseph_Principe google sheet dashboard
@Joseph_Principe
2 жыл бұрын
@@DSMStrength Perfect! Thank you.
@elizabethfalk8296
2 жыл бұрын
how do you add a new athlete?
@DSMStrength
2 жыл бұрын
You would enter their data in athlete info and put into data sheet
@lauolsen3282
Жыл бұрын
Hey from dk here. I have an error =ARRAYFORMULA(if(A2:A "", ARRAYFORMULA(LOPSLAG(A2:A 'Atlet info'!A2:F; 4; FALSE)); "")) can u see what the problem is. Vlookup/Lopslag in danish
Пікірлер: 74