The power of (2.718)

Example spreadsheets and comments on example spreadsheets.
User avatar
MemphisFlash
Posts: 1313
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Capture.JPG
you need to have the "DATA" tab activated, then click "refresh All".

if you can't see that tab you may have to load it as described earlier in this thread

the fixture list is only for leicester city, as i'm leicester. next match is against leeds so won't refresh. All the queries within will refresh the stats.
You do not have the required permissions to view the files attached to this post.
firlandsfarm
Posts: 1296
Joined: Sat May 03, 2014 8:20 am

MemphisFlash wrote:
Thu Oct 29, 2020 8:21 am
Capture.JPG

you need to have the "DATA" tab activated, then click "refresh All".

if you can't see that tab you may have to load it as described earlier in this thread

the fixture list is only for leicester city, as i'm leicester. next match is against leeds so won't refresh. All the queries within will refresh the stats.
Yes, as I said I did a Refresh All before posting. OK so is it intended only for use with Leicester?
User avatar
MemphisFlash
Posts: 1313
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

no thats just for me,
the stats are for every team.
i'll work on that for every team fixtures shortly
firlandsfarm
Posts: 1296
Joined: Sat May 03, 2014 8:20 am

Sorry to labour the point MF ... I can see the stats for all teams on the Team Statistics tab ... are you saying it's for the user to manually input the fixtures as a reminder, you're not downloading them from the Internet? I couldn't find any code to view, have you hidden it! :)
User avatar
MemphisFlash
Posts: 1313
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

there is no code. it is all done with a feature called power query, and yes it all comes from the internet.
you don't input anything
firlandsfarm
Posts: 1296
Joined: Sat May 03, 2014 8:20 am

yes, I found the Power Queries and Table 11 for Leicester's fixtures but I can't fathom where the filter for Leicester is ... I was hoping to spot it and change it to another team! :)
User avatar
MemphisFlash
Posts: 1313
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

you have to go ito advanced editor then use the team url's to find which team you want and then replace the numbers.
that should do it.
try it first on soccerstats website to make sure
Archery1969
Posts: 892
Joined: Thu Oct 24, 2019 8:25 am

This is awesome stuff Memphis. :D
User avatar
MemphisFlash
Posts: 1313
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Archery1969 wrote:
Thu Oct 29, 2020 12:11 pm
This is awesome stuff Memphis. :D

thanks
gregory196
Posts: 1
Joined: Sun Nov 17, 2019 7:58 am

Great file thanks !!! Guess wont update on excel 2007 ;-(
Post Reply

Return to “Bet Angel - Example spreadsheets”