The power of (2.718)
- MemphisFlash
- Posts: 2208
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
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: 2720
- Joined: Sat May 03, 2014 8:20 am
Yes, as I said I did a Refresh All before posting. OK so is it intended only for use with Leicester?MemphisFlash wrote: ↑Thu Oct 29, 2020 8:21 amCapture.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.
- MemphisFlash
- Posts: 2208
- 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
the stats are for every team.
i'll work on that for every team fixtures shortly
- firlandsfarm
- Posts: 2720
- 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!
- MemphisFlash
- Posts: 2208
- 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
you don't input anything
- firlandsfarm
- Posts: 2720
- 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!
- MemphisFlash
- Posts: 2208
- 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
that should do it.
try it first on soccerstats website to make sure
-
- Posts: 3266
- Joined: Thu Oct 24, 2019 8:25 am
- Location: Newport
This is awesome stuff Memphis.
- MemphisFlash
- Posts: 2208
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
thanks
-
- Posts: 1
- Joined: Sun Nov 17, 2019 7:58 am
Great file thanks !!! Guess wont update on excel 2007 ;-(
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
I not entirely sure but I think you have to have Excel 2010 and abovegregory196 wrote: ↑Thu Oct 29, 2020 5:17 pmGreat file thanks !!! Guess wont update on excel 2007 ;-(
-
- Posts: 3266
- Joined: Thu Oct 24, 2019 8:25 am
- Location: Newport
I couldnt get it to work with anything apart from Office 365.paspuggie48 wrote: ↑Thu Oct 29, 2020 5:28 pmI not entirely sure but I think you have to have Excel 2010 and abovegregory196 wrote: ↑Thu Oct 29, 2020 5:17 pmGreat file thanks !!! Guess wont update on excel 2007 ;-(
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Strange Archery, I used to have Windows 7 and Excel 2010 with no problems.
-
- Posts: 3266
- Joined: Thu Oct 24, 2019 8:25 am
- Location: Newport
Well, could be me then. The other office versions i tried it either didnt update or just hung for like 20mins. Same machine, installed office 365 and the spreadsheet updated in less than 10 seconds. All fine now.paspuggie48 wrote: ↑Thu Oct 29, 2020 6:05 pmStrange Archery, I used to have Windows 7 and Excel 2010 with no problems.
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Brill Archery...Memphis loves it