Видео

This is awesome. That’s a lot of good info here. Thanks

THANK YOUI!! very helpful!

I have all the tabs together but now I want them to sort by date, which I have all the dates in one of the columns. How can I do this now? Thanks!

why in my excel LTSC pro plus 2021, dim pic as picture get error when I run it the code, its says: run-time error 13: type mismatch. can you explain that

many thanks. this video has saved me alot

Sick video, my tutor is going to love the piece I'm working on

Hello your video is awesome, however I have a question: How did you manage to specify the area to be included on the pdf?

I use excel on a Mac, and I don't see an option to create a UserForm when I right click. Any guidance?

I did one today that is very useful, using Apps Put a checkbox at Row 1 that adds a new row at the top of the sheet instead of working from the bottom of a long sheet (In my case row 3) It adds a new blank row with same formatting, your sheet always works from top down newest first instead of the opposite

Hi, I am filling along and at 11 minutes, I have issues with getting it to load. By chance do you offer to sell this excel sheet?

Hi. A few years out of you doing this video, so hope you're still active on here. I'm presuming you're doing this off of a 20m run? Do you know the formula for 15m, please? Also, my understanding is that females use a different formula. Do you know that one (again, for 15m ideally), please? Thank you 😊

at 10:00 iv got my J column as percentages , but the chart does not show the axis up to 100%. instead only to the highest score. How was J column set up, or how did you get the radaer/spider chart to show the full percent axis? thanks

If you are having an issue with N/A make sure you are using the right heading row for the match subformula. In the video his is the first row (A1:N1) but for me it was the 3rd row which made me have to change it to A3:N3 to get the right values

Hey mate, thanks for your work, and sharing it to us! I wanna ask you for the references that you used to discriminate the range of days for calculating acute and chronic load. Thanks you!

Thanks alot If I have several colums with a checklist in Excel, how can I copy the checked ones into true and un checked in False for all columns at once?! Thanks in advance

I want to (Training plan, individual profile dashboard, skill learning development analysis sheet) based on Gymnastics... if u can pls publish the video

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?

Thank you alott!

how to add checbox automatically if there is another new data?

Thank you this was so helpful!!

Thank you very much for sharing this. It did work without any issues. I just adapted it to my own code.

Math has been so good for my training. Thanks for sharing.

Great walkthrough, very specific and easy to follow

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

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.

Thanks for this excellent series of videos. One question - how do you enable the field labeled 'Periodization' to change with the dates as it scrolls to the new year? If it's in the video apologies but I;ve missed it. Thanks, and I really appreciate your work.

Thanks for making this! It's a great easy-to-follow explanation on how these different formula work

Hi great video. Can you send me a copy of this please

this is awesome. Quick question, When calculating the smallest worthwhile changes, are these changes based on the group or intra athlete? would the formula be different if I wanted to just focus on the individual athlete?. For example, I only work with one golf athlete

Extremely helpful

Thank you ❤

I have a doubt with the formula: When I perform the formula: =FILTER({INDEX(Datos; ;MATCH("Fecha"; Encabezado;false))/ INDEX(Datos; ;MATCH(B5; Encabezado;false))}; INDEX(Datos; ;MATCH("Fecha"; Encabezado;false))>=B4; INDEX(Datos; ;MATCH("Nombre Atleta"; Encabezado;false))=B2; INDEX(Datos;;MATCH(B5; Encabezado; false)) <> "") I get the date in the data column but I don't get the values

Thanks for sharing. But, I am going to make a sign up sheet for a event. however, there are a some criteria for application. e.g. there are total 6 events for 100 names but each name only can attend one event and each event has only 10 attendee. So, if the event is fully occupied, how to block the other person of checkbox in order to prevent exceed sign-up.

Amazing work! & I have a question coach, when I am at 21:30 and getting the curly brackets filled etc so it can only be the data points for the "Athlete Name" it still brings up other athletes data and multiple data even when shes logged twice. Any suggestions? Would love to hop on a consultation call too!

How to show pictures in user form from urls

thank you so much that was amazing

In my test version I had to put the range (Aa:Ab) in the formula under the conditional format in order to it to work

the last conditional format didn't work in my sample

Does this work on a MAC? I can't seem to use the IMPORTHTML function

Thanks for your sharing!

Not only an amazing tutorial, also an amazing spreadhseet bro!

For those of you that have a hard time seeing, like me, =query({Sheet1!A2:J;Sheet2!A2:J}, "select * where Col1 is not null")

Is there a way to do the same in MS Word?

Looks like this will work only in Office 365

Looks like this will work only in Office 365

I am not familiar with P,L+,L,B,D. How would you set up workloads for %s?

Thank you, very useful

Thank you!!! You taught me exactly what I was looking for!!

It worked for me but WITHOUT lock-in the Pos within the match subformula, it's seems that the program interpreted that has to change in order to match the different categories so to search for their correspondent values.

"I'm working on creating a leaderboard on Google Sheets with multiple testing dates. I've run into an issue where the same person is ranked multiple times because they're the strongest on the bench or whatever is being tested . Do you have any suggestions on how to modify the ranking formula to ensure only the highest score is considered for each athlete? Thanks for your help!