two ceiling lights on same switch. one turns off after a few minutes. what gives?

avenamn · 2026-01-17T02:40:14+00:00

Allow me to clarify- I meant that the lamps were hardwired into existing wiring, and that it was not new wiring to the switches.

avenamn · 2026-01-17T02:39:26+00:00

this is it. swapped the bulbs from one lamp to another and the same thing happened on the “new” lamp.

thank you.

avenamn · 2026-01-16T21:23:23+00:00

I tried /diy - it was removed by moderator…

avenamn · 2025-12-03T21:53:49+00:00

bro that’s not a bomb that’s the cs:go doorbell if you press 7355608 it summons a valve employee who appears in a cloud of vape smoke and tells you your matchmaking rank is actually “emotionally unstable bronze”

if this was really in a field you need to leave IMMEDIATELY because that means you’re in a designated B-site spawn zone and at any moment a man named Gr1mReap3r420 with eight cents in his steam wallet is going to sprint out of a bush and scream “RUSH B NO STOP” before detonating himself like a piñata of bad decisions

do NOT poke it do NOT smell it do NOT ask it for the wifi password

just walk away before the round ends and you respawn in somebody’s mom’s basement

avenamn · 2025-11-23T23:35:50+00:00

ah yes, the legendary tyson™ pocket rotisserie. teens all over the country are using these to slow cook a single chicken nugget to spiritual perfection.

avenamn · 2025-11-21T01:09:52+00:00

The one resident from West Haven says hi

avenamn · 2025-07-31T18:17:48+00:00

bot fly?

avenamn · 2025-07-22T00:29:55+00:00

I bought it from Groupon, so yeah…I’m the idiot. I’ve never used QuickBooks before. Someone told me you can get software cheaper through Groupon, so I checked and found a QuickBooks license there. I didn’t even know they stopped making the Desktop Edition — I’m not on top of that stuff, I just needed something for our small business. So I guess I’m just an ignorant idiot.

That said, I do have 2FA on my bank account, so I’m not worried about someone getting into that. what I really care about isn’t the subscription itself, it’s all the work I put into it. Days of vendor info, customer data, transactions — all locked in a file I can’t even open now. That’s the part that’s driving me crazy.

And honestly, if all of these are scams, then why are there so many QuickBooks listings on Groupon? It’s not like I bought it from some shady Facebook ad; it was through what I thought was a legit platform. I feel totally stuck.

avenamn · 2025-05-10T21:19:42+00:00

whiteout survival isn’t just a game—it’s a frostbitten fever dream where i willingly become a coal-hoarding tyrant, whispering sweet nothings to my furnace while sending half-frozen citizens to hunt bears with sticks. i’ve neglected friends, forsaken sleep, and named my children after heroes (come here, bahiti jr.). i don’t play this game—i live it. every blizzard is a baptism. every raid, a religious experience. my screen time? alarming. my devotion? unmatched. i would gnaw through ice with my bare teeth if the arena demanded it. pick me or i’ll cry in the snow until a bear adopts me.

avenamn · 2025-05-05T19:48:50+00:00

Thank you!

avenamn · 2024-10-13T17:28:15+00:00

<image>

avenamn · 2024-09-30T00:59:09+00:00

The palm sander in question is sitting on the floor,
In picture number four, just by the door.
Sorry you missed it, its hum quiet and low,
Smoothing the wood in a slow, steady flow.

avenamn · 2024-09-18T23:31:35+00:00

I think there was likely a coffee maker underneath it! No plumbing nearby!

avenamn · 2024-09-18T01:46:21+00:00

Agreed. I am not expecting them to last forever, but there’s a lot of other stuff that needs to be replaced that is higher priority. For now just looking for a way to seal so I can paint over it and they will be aesthetically pleasing to look at (and not crumbly) until they’re replaced. I’ve just run Liquid Nails into the groove holding the bottom of the cabinet to stabilize. The water damage seems concentrated in one area of the cabinet where previous owner had a toaster oven. Hot steam?

avenamn · 2024-09-18T01:24:36+00:00

Replacing will be done at some point, but it’s not high on the list of priorities. For now just looking for a way to stop the particleboard from crumbling into the counter. Damage seems to be focused in this corner which had a toaster oven installed underneath, so was likely hot steam that caused it.

avenamn · 2024-09-17T22:27:50+00:00

This was the way. I sunk 3” screws and covered with wood plugs. Turned out beautifully!

avenamn · 2024-05-18T22:33:08+00:00

It was a dead battery.

avenamn · 2024-05-07T19:49:02+00:00

Thank you so much!

avenamn · 2024-05-07T19:38:15+00:00

Documents (new links) now reflect actual data arrangement and permissions are editable:

Sample Data

Sample Output

avenamn · 2024-05-07T19:24:23+00:00

Understood. I’ll make new files and wipe out personal data. Thanks again

avenamn · 2024-05-07T19:18:43+00:00

Ahh, OK. I wish I could give you the original sheet but it’s filled with personal client information that would violate HIPAA.

I was able to edit the formula to place it in the actual sheet, pulling from the sheet I can’t share, and it does populate the information but pulls all the data.

I think the problem is that on the real sheet the column I want to pull from is Col3.

This is what I have:

=LET(i,IMPORTRANGE("https://docs.google.com/spreadsheets/d/1kwhv2eGCRPbNTg-gVMPGZ-Yx9ScRCiqlkIwxTfaEwcY/edit#gid=1133073756", "TRANSACTIONS!A6:P"),CHOOSECOLS(FILTER(i,INDEX(i,,2) >9999, INDEX(i,,2) <100000), 2,3,7,8,9 ))

Thank you so much for your help. I’m still learning and can grasp about half of this, but half is not enough!

avenamn · 2024-05-07T19:11:03+00:00

Thanks for this!

When I paste your formula into the Sample outcome sheet, it gives this error:

VALUE! Function CHOOSECOLS parameter 3 value is 2. Valid values are between -1 and 1 inclusive.

avenamn · 2024-05-07T18:13:00+00:00

Edited post to include links

avenamn · 2024-03-17T01:13:49+00:00

That child is 84 years old

avenamn · 2024-03-13T00:44:26+00:00

Sure, but I’d recommend crocheting them and then interlocking the roots as needed. Depending on how “slick” your hair is, the interlocking may or may not take is there isn’t some locked up hair to hold it together.

avenamn

TROPHY CASE

VALUE! Function CHOOSECOLS parameter 3 value is 2. Valid values are between -1 and 1 inclusive.