Power Query - Example Spreadsheets (Indexed by Sport)
- MemphisFlash
- Posts: 2161
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
not just me Paspuggie48 as well, he is the master.
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
Proper star wars thing going on here!
Just had a quick look around the sheet and I think it can be improved upon if we can pull the pace numbers. Pace is the total number of possessions a team uses in a game and if a team can play at pace efficiently it has a huge advantage.
I'm thinking of a Pace Calculation Formula like this =[240/(Team Minutes)]*(Possessionteam+Possessionopponent)/2
Team minutes is 240 (5×48= 5 players on the court for 48 minutes) in a regulation game. 265 (=5×53) in a 1 OT game. 290 (=5×58) in 2 OT game. 315 (=5×63) in a 3 OT game. 340 (=5×68) in a 4 OT game.
This would enhance the projections tab in my opinion.
I'm going to watch some power query videos after Cheltenham and hopefully i'll pick it up and we can pool ideas so we end up with the definitive sheet for the NBA
I'm thinking of a Pace Calculation Formula like this =[240/(Team Minutes)]*(Possessionteam+Possessionopponent)/2
Team minutes is 240 (5×48= 5 players on the court for 48 minutes) in a regulation game. 265 (=5×53) in a 1 OT game. 290 (=5×58) in 2 OT game. 315 (=5×63) in a 3 OT game. 340 (=5×68) in a 4 OT game.
This would enhance the projections tab in my opinion.
I'm going to watch some power query videos after Cheltenham and hopefully i'll pick it up and we can pool ideas so we end up with the definitive sheet for the NBA
- MemphisFlash
- Posts: 2161
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
at last, someone gets it.
Paspuggie48 gets a tip of the hat as well then. Respect to you two guys.
- MemphisFlash
- Posts: 2161
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
https://www.youtube.com/watch?v=dRjrMbk8-u4&t=8s
https://www.youtube.com/watch?v=BuXLaQt9oEo&t=376s
https://www.youtube.com/watch?v=ppsaPkIFdOc
https://www.youtube.com/watch?v=82TyVZgXH6s&t=31s
https://orange.biolab.si/
this might be useful to you as well
https://www.youtube.com/watch?v=BuXLaQt9oEo&t=376s
https://www.youtube.com/watch?v=ppsaPkIFdOc
https://www.youtube.com/watch?v=82TyVZgXH6s&t=31s
https://orange.biolab.si/
this might be useful to you as well
You do not have the required permissions to view the files attached to this post.
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
Much appreciated my man.MemphisFlash wrote: ↑Fri Dec 11, 2020 11:34 amhttps://www.youtube.com/watch?v=dRjrMbk8-u4&t=8s
https://www.youtube.com/watch?v=BuXLaQt9oEo&t=376s
https://www.youtube.com/watch?v=ppsaPkIFdOc
https://www.youtube.com/watch?v=82TyVZgXH6s&t=31s
https://orange.biolab.si/
Capture.JPG
this might be useful to you as well
- MemphisFlash
- Posts: 2161
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
be careful when scraping too much, lol
You do not have the required permissions to view the files attached to this post.
- paspuggie48
- Posts: 634
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
CrackingMemphisFlash wrote: ↑Fri Dec 11, 2020 11:11 amNBA Projections - Power Query.xlsx
you mean like this one
https://www.eloratings.net/fixtures
I've tried to get some some data from this site using power query - but it may be more advanced than my skill level
Any ideas?
Cheers
I've tried to get some some data from this site using power query - but it may be more advanced than my skill level
Any ideas?
Cheers
- MemphisFlash
- Posts: 2161
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
You do not have the required permissions to view the files attached to this post.
- paspuggie48
- Posts: 634
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Wow...Luke Skywalker has now turned into a full-on Jedi
Not sure how you did it but well done Tom.
I can't do it for sure, so it would be good to share the workbook when you get chance fella.
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
Have you been through these?....paspuggie48 wrote: ↑Fri Jun 25, 2021 7:32 pmI can't do it for sure, so it would be good to share the workbook when you get chance fella.
You do not have the required permissions to view the files attached to this post.