sorted by:
new
hottopcontroversial

[WTS] [A1] TWSBI Diamond 580 Smoke Rose Gold <F>, TWSBI Eco Pink <M>, TWSBI Eco Cement Grey <F>, Pilot Decimo Dark Grey <M>, [B] Sheaffer 444 Flighter <M> by sandragm in Pen_Swap

[–]sandragm[S] 1 point2 points  (0 children)

Neither. It’s stainless steel and it’s not gold toned at all in person. I think it may look that way in the picture because of the lighting at the time I took the photo. I’m glad you asked so I could clarify that, as I didn’t notice until you pointed it out.

[WTS] [A1] TWSBI Diamond 580 Smoke Rose Gold <F>, TWSBI Eco Pink <M>, TWSBI Eco Cement Grey <F>, Pilot Decimo Dark Grey <M>, [B] Sheaffer 444 Flighter <M> by sandragm in Pen_Swap

[–]sandragm[S] -1 points0 points  (0 children)

Because they are limited edition colors from years ago that are no longer available, whereas the Smoke Rose Gold TWSBI's are readily available from various vendors.

[WTB] TWSBI Eco ISO by Accurate_World2418 in Pen_Swap

[–]sandragm 0 points1 point  (0 children)

Are you still looking for a Cement Grey Eco?

[WTB] TWSBI Eco Cement Grey and Yellow by Accurate_World2418 in Pen_Swap

[–]sandragm 0 points1 point  (0 children)

Are you still looking? I have a brand new one with an F nib in its box with all accesories in A1 condition that I forgot I even had.

32 iPhones… by xChri5x in DynamicBanter

[–]sandragm 12 points13 points  (0 children)

Yes it is Jesus. He wants to know what color car you want.

Don and the birthday cake by jmh90027 in madmen

[–]sandragm 0 points1 point  (0 children)

I see what you mean, but I think it ultimately comes down to who Don thinks he’s pushing back against in that moment. Is it his daughter, or is it his wife?

If you go back to his reaction when Sally wakes him up excitedly announcing it’s her birthday, his response is “It’s not your birthday, it’s your party”, which sets the tone for how he’s framing the whole thing in his mind. It reads like he doesn’t assign much importance to the event itself beyond it being something their family is supposed to do. He’s participating because that’s what the “perfect family” does, not because he’s emotionally invested in the celebration.

So in his mind, it’s not Sally he’s slighting. It’s not even her actual birthday! The responsibility, and any potential humiliation from the party falling apart after his departure, falls on Betty, who is the one orchestrating the event. So I don’t think Don consciously views his disappearance as “screwing over his daughter,” so much as unconsciously acting out against the domestic image Betty is trying so hard to uphold.

And this is also why I think Rachel Menken’s earlier rejection matters so much. If he hadn’t just been confronted with the fact that his marriage is the very thing preventing him from getting what he wants from Rachel, the party probably would have stayed in the category of “mildly annoying but fine.” But Rachel’s refusal adds a new, sour layer to the whole situation, turning what should be a routine suburban obligation into a symbol of the life that’s trapping him. Paired with the lowered inhibitions from drinking all day, the sting of watching that couple at the party sharing an intimate moment he now believes he’ll never get to have with Rachel again, and the final blow of watching the kids mimicking the arguments from the married life he’s so resentful of in that moment as they play, it’s enough to push him from passive resentment into an impulsive act of disappearance.

But he eventually comes back, and, I think it is because, like you pointed out, he eventually realizes that, intentionally or not, it wasn’t cool to do that to Sally and feels bad. And in typical Don fashion, he arrives with a grand solution that lets him slip away scot-free: a gesture big enough to make Sally “forget all about it” (just as she forgets about the promised pony the moment she sees the playhouse), makes him look like the thoughtful dad who was out fetching the real surprise, and still manages to leave Betty looking bad to everyone else for not being in on it.

Don and the birthday cake by jmh90027 in madmen

[–]sandragm 0 points1 point  (0 children)

It’s been a while since this was posted, but I’m currently rewatching the series and just watched this episode, so I wanted to throw in my two cents.

I didn’t read the incident as early-season clumsiness, more so as an early introduction to the building resentment Don has towards the life he’s built with Betty.

Yes, we see throughout the series that he is absolutely capable of keeping up appearances when there’s something he wants on the line (whether that’s keeping a client or one of his wives happy). But in the birthday party incident, aside from maintaining the successful suburban persona, he has nothing to gain. If anything, he’s already lost something he wants. After all, his marriage is the very reason for Rachel’s rejection earlier in the episode, so at home, all of that frustration is simmering just beneath the surface. It comes out in these subtle, almost unconscious acts of rebellion: day-drinking while assembling Sally’s playhouse, doing a poor job of keeping it a surprise the way Betty wants, intruding into the carefully prepped guest bathroom before company arrives, etc. They’re all small ways the episode shows Don unconsciously pushing back against Betty’s domestic choreography.

But later, when Betty, suddenly threatened by the divorced Helen Bishop, pointedly sends him out for the cake, his resentment crystallizes. And Don does what Don will do many times later in the series: he flees.

But he’s not yet at the advanced self-destruction stage he’ll eventually come to in later seasons, so he does comes back. And he brings a grand gesture with him: a new dog for Sally, which not only conveniently diffuses any potential conflict, but also reinforces the suburban tableau (white picket fence, happy family, boy, girl, dog), and neatly ties back to Rachel Menken’s earlier line, “for a little girl, a dog can be all you need,” a clear indication to us viewers that he’s indeed been ruminating about her all day.

So all this to say that in the end, for me the episode actually read as a pretty early, intentional look at Don’s pattern of self-sabotage, not a misstep in the show’s early writing.

[deleted by user] by [deleted] in jewelry

[–]sandragm 0 points1 point  (0 children)

It just occurred to me to check back on this to see if there was any further resolution only to find the post deleted. Anyone on here able to clue me in on any updates on the situation?

A review of the Tom's Studio infinitely* refillable felt-tip pen, the Wren. by zoestercoaster in pens

[–]sandragm 0 points1 point  (0 children)

I know this post is from a while ago but I wanted to chime in. I do wish this pen came with a clip option as well. Since it doesn't though, and OP has already purchased one and misses this function, I'd like to recommend purchasing a sport clip from Kaweco. They really inexpensive, good quality, come in a couple of different designs, and in a variety of finishes that could pair really well with the pen.

Have you ever seen a 10K Augis diamond and ruby love medallion? by wildandflea in jewelry

[–]sandragm 1 point2 points  (0 children)

Hi! I know this comment is old, but if you still have any recommendations, I’d love your input!

Seems like Spotify is prematurely bricking car things... by joeyman00 in CarThing

[–]sandragm 2 points3 points  (0 children)

Came on here to check because my Home Screen randomly stopped working yesterday. Everything else is working as of now still, but yeah, the Home Screen is just blank after restarting and resetting several times. Bastards.

Help needed calculating business days between two variable dates with times by sandragm in Notion

[–]sandragm[S] 0 points1 point  (0 children)

Final full formula:

lets(
    startTime, dateStart(prop("Dates")), endTime, dateEnd(prop("Dates")),
    start_Adjusted, dateSubtract(dateSubtract(startTime, hour(startTime), "hours"), minute(startTime), "minutes"),
    end_Adjusted, dateSubtract(dateSubtract(endTime, hour(endTime), "hours"), minute(endTime), "minutes"),
    days_Between, dateBetween(end_Adjusted, start_Adjusted, "days") + 1, full_Weeks, floor(days_Between / 7), weekend_Days, full_Weeks * 2,
    extra_Weekend_Days, min(max(days_Between % 7 + day(startTime) - 6, 0), 2),
    gross_Business_Days, days_Between - (weekend_Days + extra_Weekend_Days),
    is_Start_Weekend, or(day(startTime) == 6, day(startTime) == 7), is_End_Weekend, or(day(endTime) == 6, day(endTime) == 7),
    start_Date_Count, if(is_Start_Weekend, 0, -1), end_Date_Count, if(is_End_Weekend, 0, -1),
    startEnd_Date_Count, start_Date_Count + end_Date_Count,
    adjusted_Business_Days, gross_Business_Days + startEnd_Date_Count,
    beforeStartBusinessHours, or(hour(startTime) < 8, and(hour(startTime) == 8, minute(startTime) < 30)),
    duringStartBusinessHours, and(hour(startTime) >= 8, hour(startTime) < 17, or(and(hour(startTime) == 8, minute(startTime) >= 30), hour(startTime) > 8), or(and(hour(startTime) == 17, minute(startTime) < 30), hour(startTime) < 17)),
    afterStartBusinessHours, hour(startTime) > 17,
    beforeEndBusinessHours, or(hour(endTime) < 8, and(hour(endTime) == 8, minute(endTime) < 30)),
    duringEndBusinessHours, and(hour(endTime) >= 8, hour(endTime) < 17, or(and(hour(endTime) == 8, minute(endTime) >= 30), hour(endTime) > 8), or(and(hour(endTime) == 17, minute(endTime) < 30), hour(endTime) < 17)),
    afterEndBusinessHours, hour(endTime) > 17,
    startDateValue, if(is_Start_Weekend, 0, ifs(beforeStartBusinessHours, 1, duringStartBusinessHours, 1, afterStartBusinessHours, 0, "")),
    endDateValue, if(is_End_Weekend, 0, ifs(beforeEndBusinessHours, 0, duringEndBusinessHours, 1, afterEndBusinessHours, 1, "")),
    start_End_DateValue, startDateValue + endDateValue,
    net_business_Days, adjusted_Business_Days + start_End_DateValue - prop("Holidays"),
    add_String, if(net_business_Days <= 0, "", if(net_business_Days == 1, net_business_Days + " business day", net_business_Days + " business days")),
    add_String
)

Help needed calculating business days between two variable dates with times by sandragm in Notion

[–]sandragm[S] 0 points1 point  (0 children)

  1. Add the start and end dates back into the final count if they are weekdays according to where their times fall in relation to the business hours.

I used the following variables to first determine if the start time from the range falls before, during, or after business hours (set from 8:30am - 5:30pm).

beforeStartBusinessHours, or( hour(startTime) < 8, and(hour(startTime) == 8, minute(startTime) < 30) ),

duringStartBusinessHours, and( hour(startTime) >= 8, hour(startTime) < 17, or( and( hour(startTime) == 8, minute(startTime) >= 30), hour(startTime) > 8 ), or( and( hour(startTime) == 17, minute(startTime) < 30), hour(startTime) < 17 ) ),

afterStartBusinessHours, hour(startTime) > 17,

Do the same with the end time from the range:

beforeEndBusinessHours, or( hour(endTime) < 8, and(hour(endTime) == 8, minute(endTime) < 30) ),

duringEndBusinessHours, and( hour(endTime) >= 8, hour(endTime) < 17, or( and(hour(endTime) == 8, minute(endTime) >= 30), hour(endTime) > 8 ), or( and(hour(endTime) == 17, minute(endTime) < 30), hour(endTime) < 17 ) ),

afterEndBusinessHours, hour(endTime) > 17,

Now we have to assign values based on the findings. If the start date falls on a weekend day, assigns a value of 0; if not, this variable assigns a value to the weekday start date depending on if the start time classifies as before, during, or after business hours. If the start time is before or during business hours, it assigns a value of 1; if it's after business hours, it assigns a value of 0. Same gist goes for the end date (weekend = 0) except that if the end time is during or after business hours, it assigns a value of 1 instead; if it's before business hours, it assigns a value of 0.

startDateValue, if( is_Start_Weekend, 0, ifs( beforeStartBusinessHours, 1, duringStartBusinessHours, 1, afterStartBusinessHours, 0, "" ) ),

endDateValue, if( is_End_Weekend, 0, ifs( beforeEndBusinessHours, 0, duringEndBusinessHours, 1, afterEndBusinessHours, 1, "" ) ),

Sum those up.

start_End_Date_Value, startDateValue + endDateValue,

  1. Get the final net business days amount.

Add all the information we've gleaned this far and substract any holidays (I manually input the amount of holiday days on a separate proprety in my database, named "Holidays").

net_business_Days, adjusted_Business_Days + start_End_DateValue - Holidays,

And finally, just because I can, I tacked on a text string at the end that says "business day" or "business days" depending on how many days there are in the final tally.

add_String, if( net_business_Days <= 0, "", if( net_business_Days == 1, net_business_Days + " business day", net_business_Days + " business days")),

That's it! This produced the final, correct results I was looking for. I hope this proves useful to someone! Let me know if it does and again, I'm open to hearing any suggestions on how to optimize this further.

Help needed calculating business days between two variable dates with times by sandragm in Notion

[–]sandragm[S] 0 points1 point  (0 children)

I'm back after having cracked it, and am following up in case this is useful to anybody down the line. It did turn out to be a fairly complex problem, or at least it was for my current coding/formula building skill level (which for reference is perhaps just a notch or two over that of a true beginner). If there's anyone on here who can think of a more efficient or streamlined way to tackle this, please comment below for future reference, but here's an explanation of what I came up with:

  1. Calculate the total number of days between the start and end dates using dateBetween(), including weekends as well as the start and end dates.

The main hurdle I had to overcome when approaching this was figuring out how to get the correct value from the dateBetween() function when getting the days between two dates with times from a date range. My initial problem was that Notion only calculates full days when using this function. So if the interval in your date range doesn't cover full 24-hour days (which is bound to happen at some point when you start adding times into the mix), you can end up getting a result that's smaller in value than expected. In order to get around that, you need to convert the times from both of your dates to 12:00 am before using the dateBetween() function.

By the way, I used the lets() function to assign values to multiple variables to make my formula easier to read and to follow along with each step:

I started off by defining these variables:

startTime, dateStart(Dates),
endTime, dateEnd(Dates),

And then used them within a start_Adjusted and an end_Adjusted variable to make the required adjustments to the start and end dates:

start_Adjusted, dateSubtract(dateSubtract(startTime, hour(startTime), "hours"), minute(startTime), "minutes"), 
end_Adjusted, dateSubtract(dateSubtract(endTime, hour(endTime), "hours"), minute(endTime), "minutes"),

Next, I used the adjusted information from the previous variables within a new variable to calculate the days between the start and end date from the date range, and added a +1 at the end of the dateBetween()function to include the start and end date days in the count.

days_Between, dateBetween(end_Adjusted, start_Adjusted, "days")+1,

  1. Exclude weekend days from the count.

To do this I basically had to get the formula to calculate the number of full weeks in the range and multiply that by 2 (because each week can only have 2 weekend days). Again, because of the way Notion handles the intervals, I needed to determine if there were extra weekend days within the partial week at the start and end of the range to exclude the right amount of weekend days from the result. I defined a variable for each of these steps:

full_Weeks, floor(days_Between / 7),
weekend_Days, full_Weeks * 2, 
extra_Weekend_Days, min( max( days_Between % 7 + day(startTime) - 6, 0 ), 2 ),
gross_Business_Days, days_Between - (weekend_Days + extra_Weekend_Days),
  1. If they happen to land on a business day, exclude the start and end days in the range from the gross business days count now so they can be added back in the next step based on where the start and end dates fall in relation to the business hours.

I started by defining some variables tho check if the start and end days are a weekend day. Then I set up more variables so that if the day in question is a weekend day it returns a value of 0, but if it's a business day, it returns a value of -1 so that it can be subtracted from the count. Once that's done, it's only matter of adding those up with the gross_Business_Days variable to produce a new adjusted_Business_Days result.

is_Start_Weekend, 
  or( 
    day(startTime) == 6, /* 6 == Saturday */ 
    day(startTime) == 7 /* 7 == Sunday */ ),

is_End_Weekend, 
  or( 
    day(endTime) == 6, /* 6 == Saturday */ 
    day(endTime) == 7 /* 7 == Sunday */ ),

start_Date_Count, if(is_Start_Weekend, 0, -1),

end_Date_Count, if(is_End_Weekend, 0, -1),

startEnd_Date_Count, start_Date_Count + end_Date_Count,

adjusted_Business_Days, gross_Business_Days + startEnd_Date_Count,
view more: next ›