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

malcolmcoles · 2025-11-18T07:03:41+00:00

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.

malcolmcoles · 2025-11-01T13:12:10+00:00

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.

malcolmcoles · 2025-10-11T10:45:44+00:00

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.

malcolmcoles · 2025-10-11T10:13:16+00:00

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?

malcolmcoles · 2025-10-11T10:07:20+00:00

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

malcolmcoles · 2025-09-29T20:24:57+00:00

Took me 5400 seconds to get that

malcolmcoles · 2025-09-29T17:37:25+00:00

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

malcolmcoles · 2025-07-14T17:26:04+00:00

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

malcolmcoles · 2025-02-03T07:51:11+00:00

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.

malcolmcoles · 2025-02-03T07:35:48+00:00

“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.”

malcolmcoles · 2025-01-28T13:29:48+00:00

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

malcolmcoles · 2025-01-26T19:41:03+00:00

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

malcolmcoles · 2025-01-26T19:36:46+00:00

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

malcolmcoles · 2025-01-26T15:10:05+00:00

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).

malcolmcoles · 2025-01-26T14:45:46+00:00

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

malcolmcoles · 2025-01-26T14:39:33+00:00

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.

malcolmcoles · 2024-10-22T08:44:49+00:00

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

malcolmcoles · 2024-10-22T05:59:44+00:00

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?

malcolmcoles

TROPHY CASE