trying to make something (in theory) that is a lot simpler than this. I'm wanting to calculate player's season data based off the data pulled from their matches. for example, their overall shooting percentage or attempted shots. I have all the data but have no idea how to add all the info together easily without manually sorting and grouping it. do you have a video on this? thank you
This is a great question. This is a relatively straightforward process. First, you will want to create a unique list of players using the UNIQUE (and potentially FILTER) functions. Then, once you have a list of players, you can use SUMIFS and/or AVERAGEIFS to aggregate the data for when the player in the dataset is the same as the player in that list. Here's a video on UNIQUE: ruclips.net/video/WWXT15VigGs/видео.html Here's a video on AVERAGEIFS: ruclips.net/video/ccdUnWFW8kU/видео.html I hope this helps! Let me know how it goes.
This is actually sweet. I did this for the NHL, so thank you! Quick question though - the "+/-" on the Dash reads an error. How would I go about fixing this?
Oh wow that's a great question. Are you saying that there's an error upon import or when you're trying to manipulate the +/- column? If you share your sheet with me, I'm happy to help you get it sorted: adam.virgile@gmail.com Thank you!
@@ReaganRust. That was an interesting issue. I'm glad that we figured it out! Thanks for sharing. PSA: If you're dealing with imported column headers that include a "+" sign alone or begin with the "+" sign followed by another mathematical symbol (e.g., "+-", "+/-", etc.), you must change the header name at some point to use it in drop-down menus.
Hello, thanks for this tutorial. I get a number like ".301" in 3P% and 2P% columns after the import html. On your side, I see that you get a 0 before (like 0.301 for example). Did you do something to get it ? On my side the chart isn't working correctly because of the missing 0.
Hi Julien! That's a great question. If those fields are giving you an issue, I would select the columns that these values are in and set the "Format" to "Number." The issue you're experiencing may be because the imported data is being treated as "Text." Please let me know if this helps! Thank you.
@@AdamVirgile34 thanks for your quick reply. It doesn't change anything unfortunately. If you look at the original data on the basketball website, there are no 0 in front of 3P% and 2P%. It's like my gsheet is importing data as is... Don't know how to fix it. PS: I have to use ";" instead of "," in all my formulas to make it work. I don't think it's related but I mention it in case of.
@@hellow0rld91 Would you mind sharing your sheet with me? I can try to help you get to the bottom of the issue. I just changed my IMPORTHTML to grab the 2021 totals and I still get the 0. Email: adam.virgile@gmail.com
@@AdamVirgile34 @Adam Virgile thanks for your help that's super cool :) I fixed it ! I was using french format in the sheets settings. I changed it for US format and it made the trick. So finally, it was related to my PS. I'm gonna follow the step 3 of your videos and will probably come back with new questions ahah. Again, thanks a lot for your amazing work.
Thank you, I never comment but you have saved me so much time truly thank you.
Thank you for your kind words!
Thank you so much for your insightful knowledge, it has helped me a lot with working on Google Sheet
Of course! Thanks for your kind words, Kenny!
Very helpful. Thanks for this!
Of course! Thanks for taking the time to take a peek!
Thank you very much. This tutorial helps me a lot!
Thank you for watching!
You are a life savor! Thank you!
Of course! I'm so glad it was helpful, Erica!
That's some impressive knowledge man. This helped me quite a lot
Thank you, Maruwan! Please don't hesitate to let me know if you have any questions - I'm happy to help however I can.
This was great, thank you!
Thank you!
Great tutorial!
Thank you, Sam!
trying to make something (in theory) that is a lot simpler than this. I'm wanting to calculate player's season data based off the data pulled from their matches. for example, their overall shooting percentage or attempted shots. I have all the data but have no idea how to add all the info together easily without manually sorting and grouping it. do you have a video on this? thank you
This is a great question.
This is a relatively straightforward process. First, you will want to create a unique list of players using the UNIQUE (and potentially FILTER) functions.
Then, once you have a list of players, you can use SUMIFS and/or AVERAGEIFS to aggregate the data for when the player in the dataset is the same as the player in that list.
Here's a video on UNIQUE:
ruclips.net/video/WWXT15VigGs/видео.html
Here's a video on AVERAGEIFS:
ruclips.net/video/ccdUnWFW8kU/видео.html
I hope this helps! Let me know how it goes.
@@AdamVirgile34 thank you for the quick reply Adam! I’ll give this a go!
This is actually sweet. I did this for the NHL, so thank you! Quick question though - the "+/-" on the Dash reads an error. How would I go about fixing this?
Oh wow that's a great question. Are you saying that there's an error upon import or when you're trying to manipulate the +/- column? If you share your sheet with me, I'm happy to help you get it sorted:
adam.virgile@gmail.com
Thank you!
@@AdamVirgile34 Thank you! Just shared
@@ReaganRust. That was an interesting issue. I'm glad that we figured it out! Thanks for sharing.
PSA: If you're dealing with imported column headers that include a "+" sign alone or begin with the "+" sign followed by another mathematical symbol (e.g., "+-", "+/-", etc.), you must change the header name at some point to use it in drop-down menus.
I’m trying to follow along with this for this years season and when I got 27:33 it came up with an error
Would you mind sharing your sheet with me? adam.virgile@gmail.com. I'll take a look (I haven't tried with this year's data).
@@AdamVirgile34 awesome thank you, I shared it with you I hope I did it right I’m still very new to google sheets
@@gambla9437 Thank you! There's just a minor mistype with your formula. Try going back to 27:33 - you'll see what I mean. Thanks again!
Hello, thanks for this tutorial. I get a number like ".301" in 3P% and 2P% columns after the import html. On your side, I see that you get a 0 before (like 0.301 for example). Did you do something to get it ? On my side the chart isn't working correctly because of the missing 0.
Hi Julien! That's a great question. If those fields are giving you an issue, I would select the columns that these values are in and set the "Format" to "Number." The issue you're experiencing may be because the imported data is being treated as "Text." Please let me know if this helps! Thank you.
@@AdamVirgile34 thanks for your quick reply. It doesn't change anything unfortunately. If you look at the original data on the basketball website, there are no 0 in front of 3P% and 2P%. It's like my gsheet is importing data as is... Don't know how to fix it.
PS: I have to use ";" instead of "," in all my formulas to make it work. I don't think it's related but I mention it in case of.
@@hellow0rld91 Would you mind sharing your sheet with me? I can try to help you get to the bottom of the issue. I just changed my IMPORTHTML to grab the 2021 totals and I still get the 0.
Email: adam.virgile@gmail.com
@@AdamVirgile34 @Adam Virgile thanks for your help that's super cool :)
I fixed it ! I was using french format in the sheets settings. I changed it for US format and it made the trick. So finally, it was related to my PS.
I'm gonna follow the step 3 of your videos and will probably come back with new questions ahah. Again, thanks a lot for your amazing work.
@@hellow0rld91 Sounds great! If you run into any other challenges, don’t hesitate to reach out. Great work so far!