The power of (2.718)

Post Reply
User avatar
MemphisFlash
Posts: 2335
Joined: Fri May 16, 2014 10:12 pm

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.


Calculations to determine if Both Teams To Score (BTTS) Has Value Or Not - Power Query.xlsx
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.
Top
Jukebox
Posts: 1576
Joined: Thu Sep 06, 2012 8:07 pm

MemphisFlash wrote: ↑
Tue Oct 27, 2020 12:09 pm
 i thought i would create a simple spreadsheet to share with you guys.
Nice work - thanks MF
Top
Archery1969
Posts: 4478
Joined: Thu Oct 24, 2019 8:25 am

Awesome. :o
Top
Archery1969
Posts: 4478
Joined: Thu Oct 24, 2019 8:25 am

What does the following error/message mean ? :roll:
You do not have the required permissions to view the files attached to this post.
Top
User avatar
MemphisFlash
Posts: 2335
Joined: Fri May 16, 2014 10:12 pm

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.
Last edited by MemphisFlash on Tue Oct 27, 2020 1:16 pm, edited 1 time in total.
Top
Archery1969
Posts: 4478
Joined: Thu Oct 24, 2019 8:25 am

MemphisFlash wrote: ↑
Tue Oct 27, 2020 1:01 pm
 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 theblue circle to stop spinning, then it should have updated from soccerstats.
I have done that a few times now. Strange. Is it an Excel version thingy ?
Top
User avatar
MemphisFlash
Posts: 2335
Joined: Fri May 16, 2014 10:12 pm

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.
Top
Archery1969
Posts: 4478
Joined: Thu Oct 24, 2019 8:25 am

MemphisFlash wrote: ↑
Tue Oct 27, 2020 1:05 pm
 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.
Ah yes, I am stuck on 2007. Might be time for an upgrade then. 🤣
Top
User avatar
MemphisFlash
Posts: 2335
Joined: Fri May 16, 2014 10:12 pm

you'll be amazed at what it can do now!!! :shock: :shock: :shock: :shock: ;)
Top
Archery1969
Posts: 4478
Joined: Thu Oct 24, 2019 8:25 am

MemphisFlash wrote: ↑
Tue Oct 27, 2020 1:19 pm
 you'll be amazed at what it can do now!!! :shock: :shock: :shock: :shock: ;)
Do you think it will work with Office 2019 Professional Plus ?
Top
User avatar
MemphisFlash
Posts: 2335
Joined: Fri May 16, 2014 10:12 pm

i would imagine so, those new functions came out in 2018.
Top
Archery1969
Posts: 4478
Joined: Thu Oct 24, 2019 8:25 am

Many thanks.
Top
User avatar
Euler
Posts: 26198
Joined: Wed Nov 10, 2010 1:39 pm

Good work!
Top
bigtimesmallshot
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 ?
Top
User avatar
paspuggie48
Posts: 737
Joined: Thu Jun 20, 2013 9:22 am

That's nice Memphis..how did you know how to do all this? :D :)

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 :P
Top
Post Reply

Return to “Excel Power Query”