Going on from The Power posts from paspuggie48 and myself
regarding power Query.
Here is one for all you NFL fans.
The Power of the NFL
- MemphisFlash
- Posts: 2159
- 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.
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
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
- Posts: 2159
- 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.
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.
- MemphisFlash
- Posts: 2159
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
maybe the website has changed their information. i'll have a look.
- MemphisFlash
- Posts: 2159
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
try this one
You do not have the required permissions to view the files attached to this post.
- MemphisFlash
- Posts: 2159
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
Ok try again
You do not have the required permissions to view the files attached to this post.
- MemphisFlash
- Posts: 2159
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
don't forget to hit "data>refresh all" from week to week also