The power of (2.718)

[Archery1969]

So, i download Office 2019 Professional Plus but it still wont update after Refresh All.

[paspuggie48]

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

Screenshot 2020-10-28 060937.png

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.

[MemphisFlash]

575 views in 24 hours, that must be some kind of record!!!

[jimibt]

575 views in 24 hours, that must be some kind of record!!!

how long is a piece of string...

[MemphisFlash]

twice the distance from the centre to the end,

[Kai]

575 views in 24 hours, that must be some kind of record!!!

how long is a piece of string...

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!!!

Good wurk Memphis and everyone else, high fives all around

[Derek27]

575 views in 24 hours, that must be some kind of record!!!

I reckon my tomato thread beat that.

[jimibt]

575 views in 24 hours, that must be some kind of record!!!

I reckon my tomato thread beat that.

at least something grew fast then

[Derek27]

575 views in 24 hours, that must be some kind of record!!!

I reckon my tomato thread beat that.

at least something grew fast then

It's easy to forget the 'click bate' factor. People click on any topic with an unusual or intriguing title.

[jimibt]

I reckon my tomato thread beat that.

at least something grew fast then

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!!

[Archery1969]

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.

[Kai]

I reckon my tomato thread beat that.

at least something grew fast then

It's easy to forget the 'click bate' factor. People click on any topic with an unusual or intriguing title.

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

[Derek27]

Every single refresh (F5) counts towards the views, just tested it

I discovered that when I started a thread and edited it a few times, noticed it had 5 views before realising they were mine!

[jimibt]

Every single refresh (F5) counts towards the views, just tested it

I discovered that when I started a thread and edited it a few times, noticed it had 5 views before realising they were mine!

don't tell memphis -he'll be gutted!!

[firlandsfarm]

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

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.

I was amused to see that if you select Arsenal to play Arsenal there is a 54% probability that Arsenal will score!!