The Power of the NFL

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

Going on from The Power posts from paspuggie48 and myself
regarding power Query.
Here is one for all you NFL fans.
Capture.JPG
NFL Team Stats - Power Query.xlsx
You do not have the required permissions to view the files attached to this post.
Bubace
Posts: 74
Joined: Tue Jul 14, 2020 9:50 pm

Hi memphis

couple of questions, as this does look brilliant, and i love a bet on the NFL a sunday night

is the first team presumed as the home team, or is it the second team, like bears @the rams?

also how does this update the stats? is it automatically?

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

it doesnt matter which order you select your teams.
the calculations come from offence and defensive stats.
your comparing the offence of one team with the defence of the other, with the league averages factored into the equation as well.
to update the stats you should see a tab called data at the top of excel ribbon. within that there will be a refresh all, just click that and wait for the blue wheel to stop spinning then thats it, updated for another week.
Bubace
Posts: 74
Joined: Tue Jul 14, 2020 9:50 pm

Brilliant
thanks for that
wasnt sure if there was home and away stats involvd as well
Bubace
Posts: 74
Joined: Tue Jul 14, 2020 9:50 pm

Trying to refresh the stats for this

Its coming up with....

Expression.Error: The column 'Rk' of the table wasn't found.
Details: Rk

Anyone any ideas?
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

maybe the website has changed their information. i'll have a look.
Bubace
Posts: 74
Joined: Tue Jul 14, 2020 9:50 pm

That would be great

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

try this one
Revised NFL Team Stats - Power Query.xlsx
You do not have the required permissions to view the files attached to this post.
Bubace
Posts: 74
Joined: Tue Jul 14, 2020 9:50 pm

Thanks for that, but im going to be a pain in the arse here

The drop down team list doesnt seem to open on the new one?
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Revised NFL Team Stats - Power Query.xlsx

Ok try again
You do not have the required permissions to view the files attached to this post.
Bubace
Posts: 74
Joined: Tue Jul 14, 2020 9:50 pm

Works perfect now

Thanks once agin for this
zap
Posts: 2
Joined: Thu Nov 05, 2020 12:09 am

how do I change the 2 teams in the projections tab?
Bubace
Posts: 74
Joined: Tue Jul 14, 2020 9:50 pm

zap wrote:
Sun Nov 29, 2020 4:59 pm
how do I change the 2 teams in the projections tab?
just click on them, will bring down a dropdown and select who you want
zap
Posts: 2
Joined: Thu Nov 05, 2020 12:09 am

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

don't forget to hit "data>refresh all" from week to week also
Post Reply

Return to “Excel Power Query”