terribleturnip

neonvincent

Watch on YouTube

Current Mood: tired
Current Location: House in the woods at the edge of town
Current Music: Rhaco_dactylus Twitch stream

neonvincent

Watch on YouTube

Current Mood: awake
Current Location: House in the woods at the edge of town
Current Music: Star Wars: The Old Republic

andrewducker

1. Your Backpack Got Worse On Purpose: (tags:design business OhForFucksSake )
2. God sleeps in the minerals (some extremely pretty rocks): (tags:rocks pretty photos )
3. The Accursèd Alphabetical Clock: (tags:clock language funny )

neonvincent

Watch on YouTube

Current Mood: awake
Current Location: House in the woods at the edge of town
Current Music: Sims 4

thewayne

Well, it's not a cool function, it's an option on a function. Specifically, the Weekday function.

I'm finishing up our taxes. Normally I'd finish them in February or March, but it's been a heck of a few months. One of the things that I do is dump all my prescription drug purchases into a spreadsheet and calculate the day of the week, so I can take a mileage deduction on my state taxes for weekend pickups since I'm not working those days.

Nevermind whether or not we're going to dinner or a movie....

Anyway, the function ends up being:

=IF(WEEKDAY(A1,2)>5,42,"")

A1 is my date field of when the transaction takes place. By default, i.e. without a number changing the day of the week for the date the starting DOW is Sunday = 1. By supplying the 2, you're telling Excel that Monday = 1, therefore if the DOW is greater than 5, it's Saturday or Sunday, therefore the weekend! If that's true, plug in 42 (round trip to Alamogordo and back), otherwise make it a blank cell.

Five trips for an additional 210 miles, at $0.21 per mile towards my state taxes! I have to manually eliminate dupes for multiple transactions on the same day, being multiple drugs refilled and picked up at the same time.

I use spreadsheets a fair amount, but not for anything particularly complex, just as a general purpose tool, so I was kinda chuffed to find this. The question is whether or not I'll remember it for next year!

neonvincent

Watch on YouTube

Current Mood: awake
Current Location: House in the woods at the edge of town
Current Music: Gremloe Twitch stream

neonvincent

Watch on YouTube

Current Mood: awake
Current Location: House in the woods at the edge of town
Current Music: Tinderly Twitch stream

andrewducker

1. Impact of Climate Change on Cherry Blossom Flowering: (tags:Japan flowers globalwarming )

neonvincent

I found a much shorter video from CBC News to open Artemis II for Yuri's Night.

NASA's Artemis II mission in 20 minutes.

Watch on YouTube

The monumental 10-day Artemis II mission, which sent four astronauts on a record-breaking flyby of the moon, has concluded. Watch highlights of the mission from NASA, from the launch countdown to the astronauts' recovery after splashing down in the Pacific Ocean.

Current Mood: busy
Current Location: House in the woods at the edge of town
Current Music: O'Hare Airport stream

andrewducker

1. More than 200 arrests at Palestine Action demonstration: (tags:UK freespeech law police protests labour )

denise posting in

dw_maintenance

I keep forgetting to post about this: we've been troubleshooting the "missing notifications" problem for the past few days. (Well, I say "we", really I mean Mark and Robby; I'm just the amanuensis.) It's been one of those annoying loops of "find a logical explanation for what could be causing the problem, fix that thing, observe that the problem gets better for some people but doesn't go away completely, go back to step one and start again", sigh.

Mark is hauling out the heavy debugging ordinance to try to find the root cause. Once he's done building all the extra logging tools he needs, he'll comment to this entry. After he does, if you find a comment that should have gone to your inbox and sent an email notification but didn't, leave him a link to the comment that should have sent the notification, as long as the comment itself was made after Mark says he's collecting them. (I'd wait and post this after he gets the debug code in but I need to go to sleep and he's not sure how long it will take!)

We're sorry about the hassle! Irregular/sporadic issues like this are really hard to troubleshoot because it's impossible to know if they're fixed or if they're just not happening while you're looking. With luck, this will give us enough information to figure out the root cause for real this time.