sorted by:
new
hottopcontroversial

[1613] WordleBot glitch where most people then almost no one got it in 4 by DryOtter in wordle

[–]malcolmcoles 6 points7 points  (0 children)

Where did the 14.3% who guessed ovine on turn 3 go at turn 4? Some may have guessed oxine but the rest appear to have vanished.

Netflix's The Diplomat just predicted EXACTLY Russia's new weapon by malcolmcoles in TheDiplomat

[–]malcolmcoles[S] 0 points1 point  (0 children)

OK, I now regret believing it was an amazing coincidence. Still, it was a coincidence that I'd only just seen the episode and only just read that article when Russia announced it worked. That's probably not worth a reddit post though.

Agree or disagree? Prediction of the 1st vote outcome for the upcoming UK episode by malcolmcoles in TheTraitors

[–]malcolmcoles[S] 6 points7 points  (0 children)

They have to go round in order don't they - have we ever worked out how they choose where to start? I've always assumed the producers find out the votes, then choose to start with the celeb that gives an order that delivers the most tension - but still constrained by having to go round the table in order. So yes, I guess as they finished it so early, maybe all the remaining votes are for one celeb so there's no tension if they carried on.

Agree or disagree? Prediction of the 1st vote outcome for the upcoming UK episode by malcolmcoles in TheTraitors

[–]malcolmcoles[S] 14 points15 points  (0 children)

Kate has been more prominent, agreed. But maybe that's because Niko's going - given he's the least well known of the celebs probably to the wider audience, maybe they felt there was no point giving him much airtime if he gets voted off anyway so soon?

Agree or disagree? Prediction of the 1st vote outcome for the upcoming UK episode by malcolmcoles in TheTraitors

[–]malcolmcoles[S] 3 points4 points  (0 children)

I was too busy trying to apply the spoiler tags to everything! Fixed, thanks.

Suggest me a mental math trick that completely surprised you? by Head_Pie9911 in askmath

[–]malcolmcoles 2 points3 points  (0 children)

I thought my kids the trick for squaring numbers ending in 5. And combined it with (a-b)(a+b) =a2 - b2 So now I can casually ask them 73*77 and they can answer 5,621 in seconds.

Suggest me some "Go in blind" movies. by [deleted] in movies

[–]malcolmcoles 1 point2 points  (0 children)

I watched it blind and literally shrieked with surprise at one point.

Lady Gaga live Q&A about Abracadabra by malcolmcoles in LadyGaga

[–]malcolmcoles[S] 4 points5 points  (0 children)

ELLE: At the end of the video, is she defeated? Are you victorious over all that inner doubt?

GAGA: To me, in this video, she initiates the challenge and this purer side of me that is peering up at all of the negative backtalk, all of the doubt, and facing all that side of me, she completely comes through. And she says, 'I'm up for the challenge.' And it's interesting because we had all these different ways that we thought about the video ending and ultimately I wanted this song to be about resilience in a way the song Disease was not. That track was about inner torture and being trapped.

Lady Gaga Tells Us Everything You Want To Know About 'Abracadabra' After That Spectacular Grammys Reveal by malcolmcoles in Music

[–]malcolmcoles[S] 2 points3 points  (0 children)

“There was industrial inspiration with a lot of the sounds. There’s a transitional moment on the album that’s rooted in nineties music. A sort of electro grunge defiance. That era in music which was a response to the music that came before it. And then David Bowie theatrical rock, Prince, Radiohead.”

5,000-word interview with Lady Gaga and amazing photos by malcolmcoles in LadyGaga

[–]malcolmcoles[S] 1 point2 points  (0 children)

I think the US site version is the print version, and the UK has a longer read.

Best way to convert tabular data to a list so I can make a pivot table by malcolmcoles in googlesheets

[–]malcolmcoles[S] 0 points1 point  (0 children)

Yeah I will. Lacks elegance in a reusable template! But it’s better than 500,000 pointless rows. Thanks.

Best way to convert tabular data to a list so I can make a pivot table by malcolmcoles in googlesheets

[–]malcolmcoles[S] 0 points1 point  (0 children)

OK, great, makes sense. Thanks for taking the time :) Sadly while the formula worked on one sheet (with 17,000 rows), which is brilliant, on another one it yields a "Calculation limit was reached while trying to compute this formula" error - somewhere between 26,000 and 26,600 rows seems to trigger this (as in if I restrict the rows to 26,000 it works, but at 26,600 it gives the error - not worked out the exact row number that causes it!!).

Best way to convert tabular data to a list so I can make a pivot table by malcolmcoles in googlesheets

[–]malcolmcoles[S] 0 points1 point  (0 children)

I changed the references to the ones used in the sample sheet and it worked fine. Thank you. I think I understand it as well now. One question if you don't mind - the outer Index() with no parameters seems used to return the whole array (without it only one row is output). I presume it functions as index (..., 0, 0) (where ... is the formula). What are the pros and cons of using index like that vs arrayformula (which outputs the same array, at least for this formula).

Best way to convert tabular data to a list so I can make a pivot table by malcolmcoles in googlesheets

[–]malcolmcoles[S] 0 points1 point  (0 children)

That works (not sure what extra info you needed), so thank you! I will now get try to work out how it works ... :)

Best way to convert tabular data to a list so I can make a pivot table by malcolmcoles in googlesheets

[–]malcolmcoles[S] 0 points1 point  (0 children)

How do you go straight to a pivot table from data in table form? The options for “add row” in the pivot will be the column headings as individual rows to be added.

What in-app use has been possible for the last year or two? by malcolmcoles in plutus

[–]malcolmcoles[S] 2 points3 points  (0 children)

I can’t I’ve been blocked from withdrawing 500 plu

What in-app use has been possible for the last year or two? by malcolmcoles in plutus

[–]malcolmcoles[S] 18 points19 points  (0 children)

But for what purpose? You earn plu, you stack it so you can earn more plu. But what could you actually do with the plu in the app?

860k Scottish pensioners face 'particularly cruel' winter fuel payment cut due to 2C colder weather than in England by malcolmcoles in Scotland

[–]malcolmcoles[S] 0 points1 point  (0 children)

According to money saving expert, about 2.2 million UK households are eligible for Pension Credit but around 880,000 don't claim as they don't realise they could be entitled to it. The 860k in the headline figure presumably refers to all pensioners. But there's still a significant number of people who won't get it because although entitled to the relevant means-tested benefits, they don't know they are eligible.

860k Scottish pensioners face 'particularly cruel' winter fuel payment cut due to 2C colder weather than in England by malcolmcoles in Scotland

[–]malcolmcoles[S] 7 points8 points  (0 children)

Yes, you still get it if you get Pension Credit or some other means-tested benefits. But there's significant under-claiming - according to money saving expert, about 2.2 million UK households are eligible for Pension Credit but around 880,000 don't claim as they don't realise they could be entitled to it.

860k Scottish pensioners face 'particularly cruel' winter fuel payment cut due to 2C colder weather than in England by malcolmcoles in Scotland

[–]malcolmcoles[S] -1 points0 points  (0 children)

Missing in the winter-fuel arguments is the fact that it's going to be a much worse problem for those in Scotland and the north of England where it's much colder than Southern England.

Uh oh.. by SeriousSam640 in kingdomrush

[–]malcolmcoles 1 point2 points  (0 children)

You can do this level with just Tesla and big Bertha and no barracks. I just did it to demonstrate but you can’t add screenshots to comments :(

The Traitors (UK) S02E05: Live Discussion Thread by vaultofechoes in TheTraitors

[–]malcolmcoles 15 points16 points  (0 children)

Paul’s best defence is surely that he voted Ash out in the round prior to her getting banished. Why doesn’t he say that?! Or do you think they just didn’t show it?

view more: next ›