motodraconis | Reading

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!

oglaf_comic_feed

https://www.oglaf.com/beetroot/

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.

shehiemal posting in

addme

Name: Rhi, rhymes with sea, she/her

Age: early 30s

I mostly post about: Probably mostly books I read, music, fandom, and for the foreseeable future my much-planned writing project of noir biofuturistic middle-aged vampire lesbian erotica

My hobbies are: Writing, reading, music, being in nature (not "hiking" because I'm disabled but ykwim), watching video game letsplays

My fandoms are: Arthuriana, Skyrim, Baldur's Gate 3, Dragon Age (the first two), Homer, Dracula, Nero Wolfe, TTRPGs in general, a lot of random books

I'm looking to meet people who: I might gravitate toward accounts that also post about books, or post fandom meta...post about music...but I like hearing from people who have interests different from mine, too, as long as everyone's on a similar page on humans respecting each other as covered in the dealbreakers question :p

My posting schedule tends to be: Probably less than once a day and more than once a week

When I add people, my dealbreakers are:
My journal is 18+ only.
Bigotry including but not limited to racism, transphobia, ablism, sexism, or religious intolerance (including weirdos who hate atheists).
Strongly believing there is such a thing as "good art" and "bad art." Using "sees nuance" to mean "agrees with me."

Before adding me, you should know: I also have an Intro post here

thewayne

Heh. Actions can have consequences, who knew!

He applied for an Electronic Travel Authorization, basically a short-term entry visa to headline the Wireless Music Festival this summer in London. And the Home Office noped out of it, saying "Antisemitism in all its forms is abhorrent, and we recognise the real and personal impact these issues have had. As Ye said today, he acknowledges that words alone are not enough, and in spite of this still hopes to be given the opportunity to begin a conversation with the Jewish community in the UK."

Already purchased tickets will be refunded.

The UK has a policy that convicted felons will not be admitted, I wonder if it will be applied to a certain felon after he leaves office.... one can but hope.

https://www.bbc.com/news/articles/c4gxk3kxjr0o?utm_source=buzzfeed&utm_medium=iframely

nerdsorrow posting in

addme

NAME: just call me nerdsorrow for now <3.

AGE: I am thirty or forty years old! I don't mind being followed or messaged by the legally minor, the gen zees/gen alphas are doing a lot of good web art/retro revival stuff right now. my journal is gen atm, I will likely make a private community for writing if I start posting fic or other nsfw.

I MOSTLY POST ABOUT: Art (other people's) (especially smallweb and multimedia stuff), writing (other people's), music, movies, etc. There will be the inevitable diaryposting and a bit of personal art, but I want to share cool stuff I've found.

I AM LOOKING FOR: Do you post about art, music, movies, etc? If you ever do even a little bit at all of recs or reviews, comment here. If you share your own art of any kind, comment here! It's so hard to find good new things on this evil internet.

SUBSCRIPTION/ACCESS POLICY: Currently all my stuff is public, if I use this more intensively, I may make personal/diary posts private

thewayne

Here's a bit of irony. President 45 claimed the PRA as a defense for him keeping records to himself at the end of his first term, now he's got someone in the 'Justice' Dept to say that the law is unconstitutional. Now, the beauty of this is they're not filing a lawsuit in court challenging the law to get it overturned, they're just claiming it's not valid and therefore we're not going to follow it, neener neener.

Pretty clever way of trying to dodge that particular law, scumbags that they are.

The PRA was voted into law in 1978, four years after Richard 'Tricky Dick' Nixon resigned from office in the wake of the Watergate Scandal. The argument that this AAG is making is actually kind of humorous: "The PRA is not a valid exercise of Congress's Article I authority and unconstitutionally intrudes on the independence and autonomy of the President guaranteed by Article II," he found. "The Act establishes a permanent and burdensome regime of congressional regulation of the Presidency untethered from any valid and identifiable legislative purpose.". Funny how the eight presidents since Nixon, including four other Republicans, didn't seem to find it too terribly burdensome.

There's a basic flaw here, in my non-legal opinion. The Constitution and Bill of Rights (which is part of the Constitution) seemingly has always been interpreted sequentially. Amendment 1 (Freedom of Speech) prevails over subsequent Amendments in most cases. Seems to me that Article I authority should prevail over Article II authority: checks and balances.

But IANAL, much less a constitutional attorney. I don't know how people would go about challenging an opinion issued out of the blue. I thought that normally opinions were issued relevant to court cases, in support of one side or the other, or to illustrate a point of law. This opinion is just thrown out there: 'Not gonna do it!' If a case is in front of the SCOTUS and the Justice Dept issues an opinion, then others, such as the ACLU or EFF, can file an amicus brief with a counter-opinion saying 'The Justice Dept's opinion is full of crap and here's the reasons why'.

But what do they do when the opinion is just floated out there without it being attached to a specific case? It's just 'HEY! This is what we now believe!'

https://www.cbsnews.com/news/justice-department-presidential-records-act-unconstitutional/

oglaf_comic_feed

https://www.oglaf.com/papercuts/

computerghost posting in

addme

Name: I'm Nix/Nyx. (Either spelling is fine.) I also use "they/them" by default, but any pronouns are fine and good.

Age: 28.

I mostly post about: my personal life, which often means things that have happened recently or my mental or physical health. Sometimes I'll also post about hobbies and interests. I do want to post about my interests more, but sadly my health can take over my life quite a bit.

My hobbies and interests are: Music (particularly singing and learning bass right now), streaming (particularly VTubing), and playing video games are some of my main hobbies. I also try to read (mostly nonfiction) and want to get into writing again. I really like alt fashion and doing fun makeup, but sadly haven't been dressing up or touching makeup much lately. Oh, and I occasionally delve deep into researching psychology every now and then, so you might see something related to that. It's hard to name more specific interests right now, but I'm currently attempting to watch One Piece up to where I took a break from reading the manga, which is no small task. I've also been playing Arknights: Endfield, old MMORPGs, and Overwatch lately.

I'm looking to meet people who: have similar interests or also live with chronic illness, disability, mental health conditions, and/or are neurodivergent.

My posting schedule tends to be: very sporatic. I tend to use this site very sporatically in general.

When I add people, my dealbreakers are: At the very least, I would only like to add people who lean politically left. No right-wingers or centrists, please. I don't have the brain power to name all of my stances right now, but a few of them people might have problems with are being pro Palestine (and anti genocide in general) and rights for marginalized people in general. We don't have to agree on everything politically if you're comfortable with that. (It really depends on the specific things and the cirumstances.) I guess my main dealbreaker is not being left-leaning. Oh, and I don't want to add anyone under 18. Generally I'd prefer to add people who are 20 and up.

Before adding me, you should know: I post a lot about my life and health, which understandably isn't for everyone. I'm also very shy and often have trouble getting back to DMs or comments. While I try my best to comment, I can't always think of something to say or might be low on energy, so if it's okay with you, I might comment "❤︎" (or something similar) on posts I've read.

Edit: One more thing. I prefer to mutually subscribe before giving full access to my journal!

That's it I think! Thanks for reading. ❤︎

Current Mood: awake

fabiadrake posting in

addme

Name: S.

Age: 30s

Location: UK

I mostly post about: I try to keep it light, varied and enjoyable to other people; probably a focus on books, art and culture. I keep track of books I’m reading by posting excerpts. I treat the internet like I’m chatting with strangers in line at the grocery store / like I’m sending postcards to friends. (Things I don’t write about: people in my life, my job, my politics.)

My hobbies are: Writing, art and photography, STEM, history, vintage fashion, design, cooking, visiting museums/galleries, long walks in the countryside.

My fandoms are: I’ve sometimes written fic but for the most part I don’t really ‘do’ fandom. I like classic literature, British miniseries, old crime novels, genre fiction, war dramas, historical fiction, and (often obscure) character actors; I largely avoid YA and franchises.

I'm looking to meet people who: I like people who are kind, at ease with themselves, intellectually curious, and have mostly offline hobbies. I like to interact with mutuals regularly (I probably won’t comment on every entry and I don’t expect that everyone will comment on all of mine, but I like to maintain correspondence). We don’t need to know everything about each other. Also, I’m not truly a prude but to all intents and purposes please do treat me like one; I will do the same to everyone else.

My posting schedule tends to be: Variable, but approximately once a week.

When I add people, my dealbreakers are: Unsolicited advice, insufficient grass-touching, relentless negativity, too much fandom-posting (I just won’t have much to contribute!). I’d prefer not to add/be added by anyone under 18, even though my blog is very SFW.

Before adding me, you should know: Sometimes I’m very busy! And I’m Jewish.

Profile

motodraconis

February 2025

S	M	T	W	T	F	S
						1
2	3	4	5	6	7	8
9	10	11	12	13	14	15
16	17	18	19	20	21	22
23	24	25	26	27	28

Page Summary

Style Credit

Style: Modernity for Line Up by timeasmymeasure

Expand Cut Tags

No cut tags

Page generated Apr. 16th, 2026 11:37 pm

Treading a fine line between "cool" and "wanker".

Reading

I just found a cool Excel function!

Beetroot

The case of the missing notifications

(no subject)

Kanye blocked from entering the UK, festival cancelled

Talk to me about interesting stuff you found

Assistant Atty General issues opinion saying the Presidential Records Act is unconstitutional

Paper Cuts

(Hopefully) Returning to Dreamwidth

(no subject)

Profile

February 2025

Most Popular Tags

Page Summary

Style Credit

Expand Cut Tags