The Power of the NFL

[MemphisFlash]

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

[Bubace]

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

[MemphisFlash]

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]

Brilliant
thanks for that
wasnt sure if there was home and away stats involvd as well

[Bubace]

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?

[MemphisFlash]

maybe the website has changed their information. i'll have a look.

[Bubace]

That would be great

cheers

[MemphisFlash]

try this one

Revised NFL Team Stats - Power Query.xlsx

[Bubace]

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?

[MemphisFlash]

Revised NFL Team Stats - Power Query.xlsx

Ok try again

[Bubace]

Works perfect now

Thanks once agin for this

[zap]

how do I change the 2 teams in the projections tab?

[Bubace]

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]

ok thx

[MemphisFlash]

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