this post was submitted on 20 Oct 2023
23 points (100.0% liked)

Chat

7498 readers
2 users here now

Relaxed section for discussion and debate that doesn't fit anywhere else. Whether it's advice, how your week is going, a link that's at the back of your mind, or something like that, it can likely go here.


Subcommunities on Beehaw:


This community's icon was made by Aaron Schneider, under the CC-BY-NC-SA 4.0 license.

founded 2 years ago
MODERATORS
 

Lip balms here usually have a cap that you just pull to open, and that's what I had been doing with the latest one I bought. Several times in the several weeks since I first opened it, I thought it's really too hard an action. Today, maybe because I'm sick and weaker, I stopped to consider my repeated internal criticism and easily screwed the cap off.

So, I ask all of you to tell me of a moment when you realized that hammering a problem was not the best solution.

top 4 comments
sorted by: hot top controversial new old
[–] Ix9 8 points 1 year ago (1 children)

I can’t take credit for this one, that goes to my brother:

He once tried to smoosh a house fly with a literal ball peen hammer. Suffice to say, the fly dodged with ease, the glass window it was sitting on not so much.

[–] SamVimes 6 points 1 year ago

When I was <5, I was a firefighter for Halloween. Apparently my mom wanted me to stop bothering her and she told me to go fight a fire. Apparently plastic axes can break windows, at least thin ones on a greenhouse. That is what firefighters do though...

[–] SamVimes 5 points 1 year ago

Second tangentially off topic reply by me, but hey, it's chat.

Something I encounter more often is rather the opposite. When people come to you with problems, (especially technology related, but it fits all types) it's often "what's the solution to this weird specific thing?" and that weird specific thing turns out to be a result of them being part way through solving a problem their own weird way, because they neglected to consider the hammer situation.

In your case I'd be like if you asked me for skateboard grip tape to attach to the cap because it's too hard to pull off.

A good technique is to do what you did, recognize something might be wrong here, and try re-understand the original problem, feel good about recognizing it, not foolish for misunderstanding at first.

[–] blindsight 4 points 1 year ago

I worry that I do this in my Excel sheets.

I've figured out a set of formulas to filter sheets by specific content, identifying the rows using IFs, then using INDIRECTs to pull the values. I should probably just be using Excel's integrated filtering tool, but I haven't bothered figuring out if you can do complex filters with formulas, and with how easy it is to maintain going forward.

So I just keep hammering away, cluttering my spreadsheets with lots of "helper" columns to slowly filter down my results one layer at a time.

Or, really, I should probably be using databases for most of these things.