Power Query - Example Spreadsheets (Indexed by Sport)

Post Reply
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

jamesg46 wrote:
Sat Dec 05, 2020 11:43 am
paspuggie48 wrote:
Sat Dec 05, 2020 11:13 am
Yes James, it's called banter bud..no more proving lessons to perform :D :) ;)
If you think "proving lessons" is banter then you're a lucky man that Memphis is still your friend, especially since you seem to want him to prove it infront of others.
Yep does seem to be quite a bit of 'hey, hey , look at me not him' , 'I'm the best', dunno if it's because Memphis took the idea and posted useful sheets without the need to continually express his gratitude or what. But I think most people have got the point by now and doesn't need to be confirmed i every other post tht paspuggie was there first, probably before even microsoft I'd guess.

At the end of the day it's just an excel function that Mepmphis has posted up some useful sheets for, hopefully anyone else posting up PQ sheets in the future won't have to include a list of people to thank everytime they post up a sheet.
jamesg46
Posts: 3769
Joined: Sat Jul 30, 2016 1:05 pm

spreadbetting wrote:
Sat Dec 05, 2020 11:51 am
jamesg46 wrote:
Sat Dec 05, 2020 11:43 am
paspuggie48 wrote:
Sat Dec 05, 2020 11:13 am
Yes James, it's called banter bud..no more proving lessons to perform :D :) ;)
If you think "proving lessons" is banter then you're a lucky man that Memphis is still your friend, especially since you seem to want him to prove it infront of others.
Yep does seem to be quite a bit of 'hey, hey , look at me not him' , 'I'm the best', dunno if it's because Memphis took the idea and posted useful sheets without the need to continually express his gratitude or what. But I think most people have got the point by now and doesn't need to be confirmed i every other post tht paspuggie was there first, probably before even microsoft I'd guess.
My admiration for Memphis has grown considerably, I dont think i could stomach having to constantly prove someone else's ego.
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

Certainly is a change from posting up the odd cherry picked pnl shot that's for sure.
User avatar
Redhead
Posts: 252
Joined: Wed Mar 20, 2013 11:01 am

Morning guys,

I'm wondering if we could doctor the NFL query sheet, into a NBA query sheet?

Obviously you have to change some variables to suit the sport or would it be easier just to start from scratch and a blank excel sheet?

Regards.
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

NBA Projections - Power Query.xlsx

you mean like this one
You do not have the required permissions to view the files attached to this post.
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.
Post Reply

Return to “Excel Power Query”