Following on from peter's latest video, link here
https://www.youtube.com/watch?v=a50y9g7 ... G1mPODE49x
and the previous one
https://www.youtube.com/watch?v=V-PKglUoPt4
i thought i would create a simple spreadsheet to share with you guys.
This has data from Soccerstats, ( as reccomended by peter ) and has 41 power queries involved in it.
To refresh data, go to Data>Refresh, and thats all you have to do.
enjoy.
The power of (2.718)
- MemphisFlash
- Posts: 2218
- 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.
Last edited by MemphisFlash on Tue Oct 27, 2020 12:31 pm, edited 1 time in total.
Nice work - thanks MFMemphisFlash wrote: ↑Tue Oct 27, 2020 12:09 pmi thought i would create a simple spreadsheet to share with you guys.
-
- Posts: 3271
- Joined: Thu Oct 24, 2019 8:25 am
- Location: Newport
What does the following error/message mean ?
You do not have the required permissions to view the files attached to this post.
- MemphisFlash
- Posts: 2218
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
good question. i've not seen that myself before.
i would suggest closing it down and re-open.
then go to the ribbon at the top, go to DATA and then REFRESH ALL.
wait for the blue circle to stop spinning, then it should have updated from soccerstats.
i would suggest closing it down and re-open.
then go to the ribbon at the top, go to DATA and then REFRESH ALL.
wait for the blue circle to stop spinning, then it should have updated from soccerstats.
Last edited by MemphisFlash on Tue Oct 27, 2020 1:16 pm, edited 1 time in total.
-
- Posts: 3271
- Joined: Thu Oct 24, 2019 8:25 am
- Location: Newport
I have done that a few times now. Strange. Is it an Excel version thingy ?MemphisFlash wrote: ↑Tue Oct 27, 2020 1:01 pmgood question. i've not seen that myself before.
i would suggest closing it down and re-open.
then go to the ribbon at the top, go to DATA and then REFRESH ALL.
wait for theblue circle to stop spinning, then it should have updated from soccerstats.
- MemphisFlash
- Posts: 2218
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
ah yeah, it could be. i use MICROSOFT 365, so i am on the latest version.
There is a new dynamic formula within the spreadsheet called "FILTER".
that might have something to do with it.
There is a new dynamic formula within the spreadsheet called "FILTER".
that might have something to do with it.
-
- Posts: 3271
- Joined: Thu Oct 24, 2019 8:25 am
- Location: Newport
Ah yes, I am stuck on 2007. Might be time for an upgrade then.MemphisFlash wrote: ↑Tue Oct 27, 2020 1:05 pmah yeah, it could be. i use MICROSOFT 365, so i am on the latest version.
There is a new dynamic formula within the spreadsheet called "FILTER".
that might have something to do with it.
- MemphisFlash
- Posts: 2218
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
you'll be amazed at what it can do now!!!
-
- Posts: 3271
- Joined: Thu Oct 24, 2019 8:25 am
- Location: Newport
Do you think it will work with Office 2019 Professional Plus ?
- MemphisFlash
- Posts: 2218
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
i would imagine so, those new functions came out in 2018.
-
- Posts: 20
- Joined: Fri May 24, 2019 9:41 pm
looks great !! - do I need credentials for soccerstats ? - once I click refresh it tries anonymous access but keeps failing ?
- paspuggie48
- Posts: 676
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
That's nice Memphis..how did you know how to do all this?
Some won't have Dynamic Arrays for sure, nor the latest version of PQ to operate (depends on their Office Suite subscription). As you know I had some issues with your spreadsheets too.
Still, you're a good student
Some won't have Dynamic Arrays for sure, nor the latest version of PQ to operate (depends on their Office Suite subscription). As you know I had some issues with your spreadsheets too.
Still, you're a good student