วีดีโอ

Hi Tanner. That's a great observation. Dates are finicky. Typically, this occurs when the data in the database is not actually being stored as dates (they are stored as text or some other format). Obviously I'm not quite sure what's going on in your specific situation, but I hope this helps. Thank you!

@@AdamVirgile34 Hi Adam, thanks for the response. When I was editing the data set and used the filter function I did notice the dates came out as random numbers that excel spits out. I changed that by formatting the cells back to dates.. not sure if that was the right thing to do. But once I did change the cell format so it does look like a regular date (11/6/24) it still was not working

@@tannerlaske1911 thank you for the update! That is helpful. With your initial description: "my date ranges do not seem to be working", it is difficult to pinpoint what the issue may be. I would use the DATE or ISDATE function to confirm that the values are, in fact, dates. I would then ensure that, if your formula is not as simple as a FILTER for dates only, that other areas within the formula are investigated. I hope this helps. Thank you.

Hi there! These are fantastic thoughts. Thank you for sharing them. Depending on the situation, having different sensations displayed on the body map could definitely be helpful (such as burning, numb, etc.). I also think that being able to view how this information changes over time would be helpful. In other words, I agree! Thank you for watching.

That is a great question. I would include logic in the formula to ignore blank values (using IF criteria). I hope this helps. Thank you!

yeah i figured it out

Hi there! I cannot, but feel free to copy the structure and contents of what you see into your own file. I hope this helps.

Hi Steven. My apologies for the delay. Were you able to get this sorted out? Your troubleshooting sequence is spot-on - the issue is likely due to the data (or lack thereof) in your TestingData sheet. The error may occur because there is no data for one or more elements of your formula criteria. In any case, I would definitely check the data source first and identify the data points that match your search criteria. I hope this helps. Again, my apologies for the delay!

Hi! I have tested these functions recently and they continue to work on my end. Could you give me an example? Thank you!

I do, but it is not free: adamvirgile.com/product/body-map-dashboard/

@AdamVirgile34 How much is the spreadsheet? And can the value be changed or additional data collected?

Awesome 👌 just saw the link. I am very interested in purchasing it. Would it affects the data if titles such as "Athletes" are renamed or the overall value of the pain level is changed? Or would you custom fit it?.... if so, how much would it be.

@@hectorazul7462 the file on the website is literally the Excel file that is produced in this video. It will operate as described in this video. If your data format differs from what is described in this video, it will not be a great option for you. I would encourage you to watch the video to understand how the body map works prior to making a decision. Thank you!

Thank you, my friend! I appreciate you!

Hi there! There could be many reasons why this is happening. To recap, what you are telling the formula to do is: - Search through all of the data that is in Testing Data B:B and Testing Data H:H whereby the data in Testing Data A:A equals the contents in the cell A4. - Only include unique combinations of Testing Data B:B and Testing Data H:H. - Sort the unique combinations that you found. I would first check your data sources to confirm that you expect a different result from what you have generated. I would then consider whether or not the formula is an appropriate one for your specific needs. I hope this helps. Thank you!

Of course! I'm glad it was helpful.

Curious what you mean about "injury type"... Would you have to add more data such as numb, tingling, sprain, strain, etc.?

Thank you for your kind words!

Thank you for your kind words! Unfortunately, the organization of the data will dictate the setup and formulas used. On my website, I have a tutorial for long and wide data formats (e.g., it seems like yours is long, and mine is wide in this video) alongside a free body map dashboard in Google Sheets. I believe it requires a paid membership though. In case you're interested in checking: adamvirgile.com/interactive-body-map-dashboard-tutorial/ I hope this helps. Thank you!

Unfortunately, I have not filmed a video on way(s) to develop a scoring system using user-defined benchmarks. There is a lot of nuance to this question, which is great, because there is a lot of flexibility in how you may decide to develop the system based around your specific criteria. I apologize that this answer is not very helpful.

@@AdamVirgile34 do you have one using if(And()) functions to have the cell report a "pass" or "fail" if it falls within a given criteria range?

Thank you. I appreciate your kind words!

My apologies. I know it is a complicated formula. My suggestion is to create an environment that mimics the one I use in the video and apply the formula to that. Then, look for differences between what you've done and what you're trying to do in your sheet. I hope this helps.

Hi! Thank you for your kind words. There certainly is. There are a few steps: 1. Have a cell whereby you enter the age of the athletes of interest. You can also enter the specific age of interest directly into the formula below - this will make the leaderboard more dynamic. Let's say the cell you choose for the age entry is cell A1. 2. Use the FILTER function inside of the SORTN function to filter the data for only what you type into cell A1. Let's say that your ages are stored in column A. - Cell for age entry = A1 - Ages stored in column A Using my example at 7:24 in the video: =SORTN(FILTER({A:A,B:B,C:C},A:A=A1),10,FALSE,3,FALSE) I hope this helps! Thank you.

I agree. In fact, there are far more efficient methods to complete these tasks in newer versions of Excel (this video is from nearly 5 years ago).

Hi Lachie. Are your images .jpg or .png? I'm not sure whether having the images be .png (with transparent background) will maintain the fill color of the cell in which the image resides, but it is worth a shot, perhaps.

Hi Jackson. That's a great question. The best approach (IMO) is to normalize your data. Perhaps the most common normalization methods in the "high performance" space are Z-Socre and Percentile normalizations. If you decide to create Z-Scores and/or Percentiles for your data, you can invert the values for the metrics whereby "lower is better." Z-Score: Multiple the Z-Score by -1 for these metrics. Percentile: Subtract the percentile from 1 for these metrics (e.g., 1-percentile). Another benefit of doing this is that you can display all of your data on the same scale. In other words, you can display data for all metrics on the same chart and maintain high-quality data interpretation potential. I hope this helps. Thank you!

Hi Muhammad. That's a great question! All you would need to do is add an OR statement within the IF statement. In the OR statement, you would note all conditions that you would want to include in the list. Per your question, if you wanted to get the Good Guys and Bad Guys in the same column, the code would look like this: =IFERROR(INDEX(Table1[Athlete Name],MATCH(0,IF(OR($M$2=Table1[Team],$N$2=Table1[Team]),COUNTIF($M$2:M2,Table1[Athlete Name])),0)),"") $N$2 is the word combination "Bad Guys" in this example. I have not tested the code because I don't have the file used to create the video, but I hope this helps and makes sense. Thank you!

Thank you for reaching out! It's a pleasure to e-meet you. I offer the workbook on my website: adamvirgile.com/product/kpi-monitoring-dashboard/

Hi there! You might decide to include FILTER to specify your criteria. Imagine your "yes/no" is in Column C and your values are in Column B. =COUNT(UNIQUE(FILTER(B1:B10,C1:C10="yes"))) This formula should give you a count of the unique values in column B whereby the value is also "yes" in column C. I hope this helps.

Thank you, Bill!

Thank you for your kind words! Keep looking for free online resources and I think you will be able to accomplish your goals.

Thanks for your kind words! Ultimately, your ability to do this will come down to how the web pages are organized (by the website's developers). I will try to give a use case without a tutorial. At ~2 minutes in to this tutorial, I get data from a website: th-cam.com/video/uQdfcbyzWA8/w-d-xo.htmlsi=PuL7CHIaS27FtYLy If I wanted to change a year in a cell in my Google Sheet and have the data for that year come along for the ride, I would separate parameterize the URL. Here is the starting URL: "www.basketball-reference.com/leagues/NBA_2021_totals.html" We could separate this into: "www.basketball-reference.com/leagues/NBA_" AND "_totals.html" THEN Let's say in cell A1, we could have a spot for us to insert the year. The URL in the formula would end up looking something like: "www.basketball-reference.com/leagues/NBA_"&A1&"_totals.html" I hope this example helps a bit. Thank you!

This made my day! Great job, coach!

My guess is that there are differences between range sizes within the formula. For example, if you have a formula that includes something like "A:A" and "B1:B" or "C3:C20", the formula may not work (depending on other contextual information pertaining to the formula). There are many possible causes, but this one is the most likely in my opinion. I hope this helps. Thank you!

@@AdamVirgile34 thanks for the reply Adam! Would it be possible for me to send over my document so u can have a look at it please? Average works instead of averageifs so I’m really confused tbh!

@@adilmirza4074 I love your enthusiasm! Unfortunately, I cannot take a look at your document, but I trust that you will find the solutions you need using free online resources. You got this! Thank you.

Hi there! I would not use slicers. You will want to implement logic that likely uses the FILTER function with your data to see the data for only a group of athletes (or multiple groups of athletes) that you specify. I would create a drop-down list of teams/groups and use logic with the FILTER function to say "only show me the data with the group I pick in cell [A1], but if cell [A1] is blank, show me data for all athletes in my database (who fall under the other FILTER criteria I specified in the formula). I hope this helps. Thank you!

Hi Tarun. I don't fully understand your question. If you have time to elaborate on the task, I might be able to offer better support. Thank you!

Hi Leo. Yes, that can/will happen in this instance. You can format that cell differently if you'd like (e.g., Format --> "Short Date"). I hope this helps. Thank you!

Thank you for your kind words!

Thank you for your kind words, Amaan! I have a few videos on INDEX-MATCH with Google Sheets. Here is one: th-cam.com/video/ePkLzjC21HQ/w-d-xo.htmlsi=-BeGlqEzQykqmegh

Hi Leon. Wow, you cruised through! Huge congrats. And thank you so much for the kind words. I'm glad that you'll be modifying yours to optimize it for your needs - words cannot express how much joy this brings me. Thank you for your support and for paying such great attention that you can take this framework to support your specific goals!

Hi Blake. Thank you for your kind words, and this is a great question. The first step I take is finding the dates with the most recent data. You can use either MAXIFS or MAX(FILTER( to get the maximum date for the client of interest. Or, if you want the last 3 sessions, you could use SORTN(FILTER( to get highest X number of dates for that client. I hope this helps!

Hi Mate, great question! It depends on what you want to show. If total sRPE, you could use SUMIFS instead of AVERAGEIFS. Or if you wanted to show the highest sRPE, you could use MAXIFS. I hope this helps!

Thank you!