The Power of the NFL

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
User avatar
MemphisFlash
Posts: 1313
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: 48
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: 1313
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: 48
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: 48
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: 1313
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

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

That would be great

cheers
User avatar
MemphisFlash
Posts: 1313
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: 48
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: 1313
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.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”