Power Query - Example Spreadsheets (Indexed by Sport)

Post Reply
User avatar
Redhead
Posts: 252
Joined: Wed Mar 20, 2013 11:01 am

Many thanks Memphis, I tip my hat to you sir.
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

not just me Paspuggie48 as well, he is the master.
User avatar
Realrocknrolla
Posts: 1903
Joined: Fri Jun 05, 2020 7:15 pm

MemphisFlash wrote:
Fri Dec 11, 2020 11:14 am
not just me Paspuggie48 as well, he is the master.
Proper star wars thing going on here! 🤣🤣
User avatar
Redhead
Posts: 252
Joined: Wed Mar 20, 2013 11:01 am

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
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

at last, someone gets it. :D :D :D ;)
User avatar
Redhead
Posts: 252
Joined: Wed Mar 20, 2013 11:01 am

MemphisFlash wrote:
Fri Dec 11, 2020 11:14 am
not just me Paspuggie48 as well, he is the master.
Paspuggie48 gets a tip of the hat as well then. Respect to you two guys.
User avatar
MemphisFlash
Posts: 2126
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.
User avatar
Realrocknrolla
Posts: 1903
Joined: Fri Jun 05, 2020 7:15 pm

MemphisFlash wrote:
Fri Dec 11, 2020 11:24 am
at last, someone gets it. :D :D :D ;)
👍👍👍
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Capture2.JPG

be careful when scraping too much, lol
You do not have the required permissions to view the files attached to this post.
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

MemphisFlash wrote:
Fri Dec 11, 2020 11:11 am
NBA Projections - Power Query.xlsx


you mean like this one
Cracking ;)
makkad
Posts: 81
Joined: Thu Sep 22, 2016 10:38 pm

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
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Capture.JPG
You do not have the required permissions to view the files attached to this post.
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

MemphisFlash wrote:
Sun Jun 06, 2021 12:03 am
Capture.JPG
Wow...Luke Skywalker has now turned into a full-on Jedi 8-)

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.
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

paspuggie48 wrote:
Fri Jun 25, 2021 7:32 pm
I can't do it for sure, so it would be good to share the workbook when you get chance fella.
Have you been through these?....
Screenshot_11.jpg
You do not have the required permissions to view the files attached to this post.
Post Reply

Return to “Excel Power Query”