mastodon 4.7.2+glitchLibrarian/Programmer. Lesbian. Disabled person. Supporter of multiple fandoms. General recluse, prone to commit random acts of spreadsheet-based kindness. Burnout survivor. Old enough to see the retirement light at the end of the tunnel, too young to be there yet.
AuDHD, very recently diagnosed.
By default, my posts are limited to followers. If you see an insight or comment that you'd like to share with other people, feel free to copy and re-use it with *anonymous* attribution.
I try to be good about CWs, but if you see something from me that you think should have a content warning (including inadvertent spoilers), please just say so!
Laughing at today's Clues by Sam, and sharing because today the joke isn't part of a larger, multi-day thread.
(Every day's puzzle is a mix of clues and non-clues - I'm listing the non-clues/joke in a reply so people who don't like logic puzzles can still see it.)
Edit: I decided to also record a multi-day joke, because I want the record myself before last week disappears next Monday. You can always get the puzzles from last week's and this-week-so-far if you make an account -- so far I haven't gotten any spam or other obnoxiousness from doing so.
@sasutina13@lgbtqia.space @AutisticInnovator@autistics.life I've gotten two toys from her store: a twisty fidget and the "wind" fidget spinner.
I've been using both for 2 years. They're good quality, and I get positive comments on their appearance & quality whenever I pull them out.
I've found that the twisty one is particularly good for dental visits - easy to play with even if I can't see it, and since I can just hook my fingers through it when I'm not actually using it (or even wind it around one of my fingers) I don't have to worry about getting distracted & dropping it.
The Kickstarter for the final part of a really good webcomic is in its final week, and only needs $121 more to hit the goal.
Love Not Found is a sweet webcomic by Gina Biggs about found family, and overcoming taboos that limit human connection, and using human connection to heal and grow past emotional trauma. I love that there's a whole gamut of personalities and body types, and everyone is treated as attractive & lovable. I love that there are antagonists that are brought around to friends. I love that people are flawed, but (nearly) everyone grows and becomes a better version of themselves.
CW for two narcissistic, manipulative mothers, still trying (and ultimately failing) to control their adult children. But it's not all "parents are evil" -- there's also a bunch of supportive parents/authority figures.
The SFW content can be read for free -- sexytimes are only detailed in purchasable side-stores.
Earlier today I was doing something very boring & repetitive - taking a unique identifier, going to the URL specified by that ID, and copying a single piece of information. 140 times.
So I used a spreadsheet to simplify the steps, automatically track my progress, and create motivation for myself.
Step 1: make the URL.
The IDs were in column A. In column B I used a formula to concatenate them into a URL. In B2, the formula is
=concatenate("http://example.com/",a2)
Step 2: Prevent risk of losing my place.
I copied the URL from a cell, pasted it into my browser, copied the info I need, and pasted it back into the same cell.
Voila: automatic tracking.
Step 3: See how many I have left to do.
In C2 I started with the formula
=if(isnumber(find("http",b2)),c3+1,"")
Or in other words once it's copied all the way down the column: if this row still has the url then the formula would show the total number of rows remaining. Otherwise, it showed a blank cell.
Step 4: Report on what I've already accomplished
Watching the number in column C decrease wasn't really doing it for me, so I changed that formula to add a report on what I'd accomplished so far:
=IF(isnumber(find("http",B2)),C3+1,IF(isnumber(find("http",B3)),1-C3/140,""))
That gave me 0.3429 for what I'd accomplished -- I was a bit over 1/3 of the way through.
Step 5: Make it pretty
Lastly I used conditional formatting to show all cells with a value < 1 as a percentage, so 0.3429 became 34.29%, but the number of rows left still showed as plain integers. I'm kinda proud of this because I never thought of it before.
(And yes, I did finish the task)
And a timely new (non-political) filk song from Tom Smith:
🎶 Welcome to May, all the flowers have bloomed,
But if you're in a folk song you’re probably doomed.
There's a few simple rules, stuff that you shouldn't do,
Or the next victim of the folk ballad curse
Just might be you. 🎶
