The power of (2.718)
-
- Posts: 3266
- Joined: Thu Oct 24, 2019 8:25 am
- Location: Newport
So, i download Office 2019 Professional Plus but it still wont update after Refresh All.
You do not have the required permissions to view the files attached to this post.
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Interesting, it looks like you haven't got Power Query enabled. See my screenshot, albeit it's Office 2016 but there is a Get & Transform section
It may be you have to add it as an add-in; File > Options > Add-ins..... or simply Google it for your Office Suite version.You do not have the required permissions to view the files attached to this post.
- MemphisFlash
- Posts: 2208
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
575 views in 24 hours, that must be some kind of record!!!
how long is a piece of string...MemphisFlash wrote: ↑Wed Oct 28, 2020 12:19 pm575 views in 24 hours, that must be some kind of record!!!
- MemphisFlash
- Posts: 2208
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
twice the distance from the centre to the end,
So people either love the spreadsheet or Memphis pressed refresh page a few hundred times. Or both! Who cares, it still counts towards the new record!!!jimibt wrote: ↑Wed Oct 28, 2020 12:23 pmhow long is a piece of string...MemphisFlash wrote: ↑Wed Oct 28, 2020 12:19 pm575 views in 24 hours, that must be some kind of record!!!
Good wurk Memphis and everyone else, high fives all around
I reckon my tomato thread beat that.MemphisFlash wrote: ↑Wed Oct 28, 2020 12:19 pm575 views in 24 hours, that must be some kind of record!!!
It's easy to forget the 'click bate' factor. People click on any topic with an unusual or intriguing title.
talking of formulas and *bate*, maybe this is for next year: https://www.masterblend.com/4-18-38-tom ... %20systems.
masterblend away!!
-
- Posts: 3266
- Joined: Thu Oct 24, 2019 8:25 am
- Location: Newport
I got the spreadsheet working. Cheers all.
Bit the bullet and got Office 365. Think i can afford £5.99 a month as long as me dogs behave.
Bit the bullet and got Office 365. Think i can afford £5.99 a month as long as me dogs behave.
Every single refresh (F5) counts towards the views, just tested it
Well, unusual threads are becoming more usual, would make sense during these unusual times.
Keep seeing a ton of brand new members browsing the forum too, had a glance just now on the new registered members page and there are nearly 20 new members since yesterday Looks to be around 10 new ones per day or so, hardly surprising people are looking into trading more.
Which I'm sure Euler doesn't mind : https://www.youtube.com/watch?v=IR8gq_d ... l=Lexadrik
don't tell memphis -he'll be gutted!!
- firlandsfarm
- Posts: 2720
- Joined: Sat May 03, 2014 8:20 am
Hi MF ... great spreadsheet, thanks for posting it but ... how do I update the fixture/Fixture List? I did a Refresh All but it didn't change.MemphisFlash wrote: ↑Tue Oct 27, 2020 12:09 pmFollowing 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
I was amused to see that if you select Arsenal to play Arsenal there is a 54% probability that Arsenal will score!!