Just noticed that the BBC iPlayer volume goes up to 11. Well played. 🤘

Turns out that *in general*, arrays of difference sizes can't coexist nicely. *But*, using the new MAP function does let me take in multiple arrays and return strings based on a LAMBDA function, which can then be SPLIT, giving me arrays of different sizes. support.google.com/docs/answer

Show thread

I mean, just look at this cast. Look at their *clothes*! I’m fuming

Show thread

In cases like this I tend to take each part of the larger formula and test them separately. Doing that pretty quickly points us to the SEQUENCE formula, giving us the same numbers over and over.

Show thread

While we only have the coordinates for the vertices of the drawing, in theory we can take each line, look at a large number of points within that line, then reconstruct it so that it goes around the shape, giving the illusion that the square is "in front", obscuring the line.

Show thread

The first thing that comes to mind is that if we have our 2D shapes, we could try and see what points are inside a shape that is closer to the "camera". Take this simple 2D example of a square with a line through it:

Show thread

The problem I'd like to fix is that because it uses the SPARKLINE formula, everything on the screen is ultimately one line, which means lines might cross each other in weird ways, and that all objects are effectively transparent.

That's fine for simple shapes, but limits the options for more complex drawings/toys/games.

Show thread

We’re in Berlin but I’m a little concerned that this train might have taken us back in time

Gosh Darn

A tiny server for experimenting with fun things on the web.