The power of (2.718)

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

[MemphisFlash]

Capture.JPG

you need to have the "DATA" tab activated, then click "refresh All".

if you can't see that tab you may have to load it as described earlier in this thread

the fixture list is only for leicester city, as i'm leicester. next match is against leeds so won't refresh. All the queries within will refresh the stats.

[firlandsfarm]

Capture.JPG

you need to have the "DATA" tab activated, then click "refresh All".

if you can't see that tab you may have to load it as described earlier in this thread

the fixture list is only for leicester city, as i'm leicester. next match is against leeds so won't refresh. All the queries within will refresh the stats.

Yes, as I said I did a Refresh All before posting. OK so is it intended only for use with Leicester?

[MemphisFlash]

no thats just for me,
the stats are for every team.
i'll work on that for every team fixtures shortly

[firlandsfarm]

Sorry to labour the point MF ... I can see the stats for all teams on the Team Statistics tab ... are you saying it's for the user to manually input the fixtures as a reminder, you're not downloading them from the Internet? I couldn't find any code to view, have you hidden it!

[MemphisFlash]

there is no code. it is all done with a feature called power query, and yes it all comes from the internet.
you don't input anything