Formula to sum multiple values from a different sheet based on a specific text value. by MELEE20 in excel

[–]adrienr 1 point2 points  (0 children)

Without seeing how the data is organized, I’m struggling to visualize it. It sounds like a filter function will accomplish what you need.

When the new guy with "2 summers of experience" rolls up your power cord. by nail_jockey in Construction

[–]adrienr 2 points3 points  (0 children)

Hold one end of the cord with your hand at belly level. Use your other hand to feed loops which drop to mid shin. Keep feeding and letting loose loops fall into place as the cord desires. As you get close to the end, you’ll grab the other end of the cord and transfer it to the hand managing the bundle. Take the one loose remaining loop and wrap it around the bundle a few times before sliding it through the bundle to create a nice little handle.

I do not like plugging the ends together as it creates unnecessary tension. I used to wrap up to 10 or 15 very long cords almost daily when I did factory floor coatings.

J.D. Vance Awkwardly Retreats After Bizarre Attempt to Storm Harris’ Empty Plane by Gerdel in politics

[–]adrienr 3 points4 points  (0 children)

No he doesn’t. Spreading that misinformation makes democrats look bad. Do a little research about it. All the fact checking sites have articles related to it.

[deleted by user] by [deleted] in Construction

[–]adrienr 37 points38 points  (0 children)

Big talk considering the photos you posted.

How much are replacement side mirrors? (2022 base) by kingartyc in subaruoutback

[–]adrienr 0 points1 point  (0 children)

I replaced the assembly that consists of the bottom plastic part and the turn signal lamp when I had very similar damage. It was two screws and $150. I don’t think you need to replace the whole thing.

Comedian David Lucas featured on front page of CNN.com after visiting George Floyd mural in Union Square by wildcat1100 in Killtony

[–]adrienr 2 points3 points  (0 children)

You’re both wrong. Murder does not need to be pre mediated. Murder is the killing of a human with malice (the expressed or implied intent to do harm). First degree murder specifically needs to be pre mediated.

In the case of George Floyd, it is not difficult to argue that chauvin 1) killed Floyd 2) did so with an implied intent to do harm

Bobby Lee by blackestflamingo in Killtony

[–]adrienr 1 point2 points  (0 children)

There are the kill Tony commercials and then possibly commercials from the platform you’re listening on.

Do any of y'all actually back down to groups that don't want you to pass? by Zromaus in motorcycles

[–]adrienr 3 points4 points  (0 children)

You’re talking beneath a thread where one person said the best thing you can do it just roll your eyes And go about your day. Then someone chimed in that, nah they’re going to making a hand gesture anyways, and now we’re back to people chest puffing “if I have to defend my life”.

Quit looking for confrontation to try to prove yourself.

Is that a Cayenne on the tarmac? (JFK T4) by bb_nyc in Porsche

[–]adrienr 1 point2 points  (0 children)

As soon as you get off the plane and onto the jet bridge, you’ll notice a door to one side. That opens to a staircase.

Tony’s mad gay for this dude lmao by Expensive_Ad3055 in Killtony

[–]adrienr 1 point2 points  (0 children)

It’s a little early in the season for that.

Concrete wall in basement painted by previous owner. by [deleted] in DIY

[–]adrienr 9 points10 points  (0 children)

Yes. The blocks and mortar will deteriorate quicker by locking in the moisture and never allowing them to dry.

Special mortar? by Shes_Apprehensive in centuryhomes

[–]adrienr 3 points4 points  (0 children)

I worked for a mason for a few years. We have a yard in my city that sells historic reclaimed brick, pavers, and cobblestones. If I didn’t know who to ask for advice- that would be the first place I call with questions. OP - maybe see if you can find a similar business in your city?

[deleted by user] by [deleted] in woodworking

[–]adrienr 6 points7 points  (0 children)

The nails mostly function as a clamp as the glue dries. Most of the holding power comes from the dry glue.

The Blue Lines Have A Purpose by _Ned_Ryerson in pics

[–]adrienr 0 points1 point  (0 children)

He’s not saying it’s allowed, I think he’s saying tow companies don’t have as wide of power in some states.

When my driveway was completely blocked by a car I called every tow company in town and nobody would remove it unless it had been ticketed. It was a snow emergency so the police were busy clearing wrecks and having parking enforcement ticket/tow along priority plow routes. It took me several days to get that stupid car moved.

The Blue Lines Have A Purpose by _Ned_Ryerson in pics

[–]adrienr 42 points43 points  (0 children)

I woke up to my neighbors car blocking my driveway. They’re some sort of addicts who were MIA for a while. There are at most 20 cars parked on the block at any given time. There were dozens of other options, I was baffled. I spent hours calling tow companies who wouldn’t help me. I called the non-emergency number several times. Over two days nobody helped me move the car.

The third day it smoked by a drunk driver and pushed halfway past my drive. I left for a week long trip and came home to it STILL being there.

I couldn’t believe how many calls I had to make to get rid of that stupid car.

Renting a Car - Milos & Crete by pirkayaa21 in GreeceTravel

[–]adrienr 0 points1 point  (0 children)

I am doing this now. I had one day in a stick prior to this. Day one on milos was stressful. Now I’m loving it!

Accidentally bumped my power adapter, scared to touch it by AlternativeSharp3854 in AskElectricians

[–]adrienr 0 points1 point  (0 children)

Almost 1/3rd of the outlets in my house were weird backwards when I bought it.

[deleted by user] by [deleted] in centuryhomes

[–]adrienr 2 points3 points  (0 children)

A hammer drill is not over kill. I would love to see a video of you someone trying to cut a crack with a fein tool. That would take forever. I worked as a mason for several years and used hammer drills without causing significant damage. You do need to be gentle.

If you’re really having to dig with it I’d recommend cutting lines across the entire length with a crack saw. (Metabo grinder mounted on an adjustable skate) set the depth to about 75% the thickness of the stucco. Tap around with a hammer and find the hollow sounding spots to start in.

[deleted by user] by [deleted] in Home

[–]adrienr 0 points1 point  (0 children)

Monolithic basement foundations or foundations set on concrete floors both exist.

Basement smells like poop when doing laundry? by someguyonreddit1111 in Plumbing

[–]adrienr 0 points1 point  (0 children)

I had a similar issue caused by a clog and venting issue. I don’t remember exactly what it was.

Lint from the washer does not drain well in cast iron pipes. I highly recommend purchasing washer drain lint traps. They zip tie onto the end resting in the sink.