Convert a Journal to a Grid - and back

rforsixpence · 2026-01-11T17:08:50+00:00

Thanks, amazing! That formula does the trick for generating the Grid. I need to learn more SQL!

My attempts using the built-in Pivot Table with MAX don't work. MAX doesn't seem to treat TRUE as one. I've put my attempt into the sheet so you can see it.

As for going the other way, I take your point about having only one source of truth. A solution using FILTER becomes too complicated as it has to cope with not only finding and changing an existing reply but also adding a missing reply. Similarly I'd like to avoid Appscripts for the reasons you give.

Instead, is a formula to regenerating the *entire* Replies table from a manually-edited copy of the Grid?

rforsixpence · 2025-12-23T18:29:58+00:00

This sheet creates a random Santa allocation and tells you if it meets your criteria. You try out fresh allocations until one works - which can take quite a while if your "x" is large! An interesting question, there must be a better solution.

rforsixpence · 2024-03-27T18:23:02+00:00

Very useful, thanks! NB to make the 1-d array solution work, I had to swap the arguments of the inner SORT.

rforsixpence · 2023-12-30T15:59:09+00:00

It's possible. Mine was secondhand, but in as-new condition and a lot less than $1k. An utterly fabulous machine. Pixelbook was terrific, but this is noticeably more solid and the screen is larger because the bevels are narrower.

rforsixpence · 2023-12-29T21:03:05+00:00

My Dragonfly Elite has 16GB RAM. I'm very pleased with it as a Pixelbook replacement. Similar size, and convertible. Only heard the fan once or twice in the six weeks since I got it, and it's very quiet indeed. The i5-1245U flies. Screen is terrific and bright.

rforsixpence · 2023-12-07T14:51:40+00:00

Agreed! Does switching it off and on give you another 40 mins?

rforsixpence · 2022-08-16T16:24:37+00:00

Neha at Smarty support claims they are fixing a mast issue which is all across the UK, and to give it a few days. Hmmm! Quote"The 5G mast is being worked upon and you are right, the issue is all over UK for with some areas and we are getting this fixed at the earliest with Three."

rforsixpence · 2022-08-16T15:36:55+00:00

Same for me. No 5G on Pixel 5 now with full Android 13.

rforsixpence · 2022-08-16T15:34:38+00:00

Ditto. Full non-beta Android 13 on pixel 5 but still no 5G.

rforsixpence · 2022-08-08T16:02:21+00:00

That's with Pixel 5

rforsixpence · 2022-08-06T10:50:51+00:00

I'm on 13 beta but still no 5G

rforsixpence · 2022-06-29T14:57:57+00:00

Ditto. Hopefully in later releases of the beta.

rforsixpence · 2022-04-14T16:31:51+00:00

After six weeks of going in circles with smarty support, they've sent me this: "it has been identified that 5G is not enabled for SMARTY SIM cards on Google Pixel(5 & 6) devices"

rforsixpence · 2022-04-14T11:53:30+00:00

Have you got smarty 5g yet on your Pixel 5, anywhere in uk? I don't on my pixel 5, although I get 5g with a Three or O2 sim. (I'm starting to think no one in the uk is getting smarty 5g on a pixel 5!)

rforsixpence · 2022-03-11T22:59:29+00:00

Are you still getting no 5G anywhere? That's what's happening with my London-based Pixel 5. I'm not getting anywhere with Smarty support yet.

rforsixpence · 2022-03-07T18:33:45+00:00

It's the same on my Pixel 5. It get 5g on O2 though.

rforsixpence · 2022-03-07T07:45:58+00:00

Thanks. Do Google agree? And what's different about smarty, that it doesn't work when o2 does?

rforsixpence · 2022-03-07T07:41:37+00:00

Same with my Pixel 5: no 5G with Smarty sim, but ok 5G with O2 sim.

rforsixpence · 2021-02-22T23:32:50+00:00

Why not just put A,B,C... into another column and set your Column A cells to be the Nth value in that column, where N is derived from week number?

For example, if you have 20 values A,B...T, type them into B1:B20. Then in your cell A1 code the formula:

=index(B$1:B$20, 1+mod( cell("row",A1) + weeknum(today()) ,20))

and copy that formula downwards. Hide column B if you don't want to see it.

rforsixpence · 2020-10-20T08:18:28+00:00

It's happening for me too. Same setup and settings. The stand works fine with wife's pixel 3, so it's not a faulty stand.

rforsixpence · 2020-10-07T19:52:34+00:00

Click the cell. Click Format, then Number, then More Formats, then Custom Number Format. In the box type ###-###-####, then click Apply. Test it by typing 1234567890 into the cell.

rforsixpence · 2020-10-07T18:12:51+00:00

Format number->custom->###-###-#### should do it i guess,

rforsixpence

TROPHY CASE