The power of (2.718)

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

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

Awesome. :o
Archery1969
Posts: 3192
Joined: Thu Oct 24, 2019 8:25 am
Location: Newport

What does the following error/message mean ? :roll:
You do not have the required permissions to view the files attached to this post.
User avatar
MemphisFlash
Posts: 2126
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.
Last edited by MemphisFlash on Tue Oct 27, 2020 1:16 pm, edited 1 time in total.
Archery1969
Posts: 3192
Joined: Thu Oct 24, 2019 8:25 am
Location: Newport

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 ?
User avatar
MemphisFlash
Posts: 2126
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.
Archery1969
Posts: 3192
Joined: Thu Oct 24, 2019 8:25 am
Location: Newport

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. 🤣
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

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

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 ?
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

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

Many thanks.
User avatar
Euler
Posts: 24700
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

Good work!
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 ?
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

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
Post Reply

Return to “Excel Power Query”