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!
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.
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 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 😕
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!
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?
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?
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?
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?
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
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?
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
@@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.
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 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?
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??
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
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
@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
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.
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
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!
Stefanos thank you very much
Awesome!
Ok I'm done.
Let's get part 2 :)
Haha its coming pal thanks
Amazing from colombia
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.
probably your named ranges have not updated
Great stuff!
Thanks for watching coach
Amazing !
Thank you for checking out the video!
This is awesome!
this is sick!!!! :)
Mike thanks so much man working on part 2 today!
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?
Just figured it out by necessity... needed to create solutions for athletes and teams I have worked with.
Amazing work! really helpful
Thank you!!
Hi, from Brazil! Great job! Easy explanation. Thank you very so much. When will the part 2? Thank's
Wow.. thank you so much for watching the videos!!
I am trying to release the second video Wednesday. Stay tuned!
Thank you. Sorry my english. Very Nice job!
Could you follow along this video in excel?
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.
from what you are explaining you shouldnt need to do an array formula for this.. simple vlookup should be enough
@@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 😕
@@DSMStrength I have the same issue when I try to add athlete info that’s make Error
@@alaeddinetaguia6536 it worked for me when i changed , to ;
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!
Need to create another range probably put it in controls
Any specific place to find those clipart headshots?
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?
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?
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?
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?
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
Thank you!! So it’s best to have earliest date at the top and within that, alphabetically by name?
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?
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.
@@DSMStrength keep it up, I wish you all the best.
I have come across couple of problems, one with the transponse and array formula. Got any clues to why?
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?
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
@@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.
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?
Yep that should work! Best advise is put ur dates in order as well you can use a sort function.
@@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?
@@priceholmes2610 Hey Price,
Great chatting on the phone today. Ill take a look at the info you sent me!
@@DSMStrength Thank you so much for the help and the quick replies! GREATLY APPRECIATED!!!
@@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!
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??
I do not understand your question I am sorry.
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
Looks like you have commas between f4 they shouldn't be there
What would the array formula look like on excel?
i havent made this particular dashboard in excel. But excel handles arrays much better with things like filter etc.
Can this be done on excel?
Can I just buy this from you
The only problem i'm having is with the dates. It does't track down the entire row. Only the first two.
what are you referring to?
can you do one for excel
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
@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
Hey! I have one question - is there any option to buy this Google Sheet Temple? :)
yep! on my website
Can I buy this template from you?
Yes it's for sale on my website dsmstrength.com
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.
@@Joseph_Principe google sheet dashboard
@@DSMStrength Perfect! Thank you.
how do you add a new athlete?
You would enter their data in athlete info and put into data sheet
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