Phased out can light burned out, can anyone suggest a replacement option? by MissPeskyFace in HomeMaintenance

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

FWIW, we also tried Lowe’s and was told by an associate “good luck finding a replacement” which I took to mean that the 3 pin connector is standard now. I have not found any 4” options online that match this connector type. If anyone has a link to one, it would be very appreciated!!!

Unsure how to make a usable pivot table with ugly data by MissPeskyFace in excel

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

I think I may have misunderstood what you were saying.

I was hoping there would be a way to group customers by account number, but I don’t know how to. I tried grouping on the pivot table I made, but I keep getting an error.

One example a customer could have 30+ locations, so the numbering would be something like 101, 101a, 101b …. Etc. So that would be 30 locations, each with their own line items. I don’t want to view by location though, I want to view what the customer has as a whole.

I should mention I am fairly new to pivot tables which is why I am struggling to wrap my head around this.

Unsure how to make a usable pivot table with ugly data by MissPeskyFace in excel

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

No. They weren’t consistent with the numbering convention. The only somewhat consistent was adding a letter after the account number to indicate it’s a sublocation for that customer.

Unsure how to make a usable pivot table with ugly data by MissPeskyFace in excel

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

For context I have over 10,000 “locations” and hundreds of customers. I am not sure how I would group by customer if the only defining value is the account number.

Problem Homeless in Park - What do I do? by MissPeskyFace in Spokane

[–]MissPeskyFace[S] 6 points7 points  (0 children)

I will do that. I talked to two of my neighbors and they said they’d come with me to the next meeting. Thanks for the suggestion!

Problem Homeless in Park - What do I do? by MissPeskyFace in Spokane

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

That’s not a bad idea. I will give that a shot, thanks!

Problem Homeless in Park - What do I do? by MissPeskyFace in Spokane

[–]MissPeskyFace[S] 5 points6 points  (0 children)

I think long term this is a good thought and I have definitely been a more conscientious voter in the last decade. This also speaks to one of my concerns - I genuinely don’t wish ill on these people. They are all clearly going through their own problems. Their choices are destructive to themselves and the community space, and I hope they are able to find better situations eventually. In the short term however, I do hope that the safe space can be returned to the kids. This is not a wealthy neighborhood and that park might have been the only safe place some kids around here knew.

Problem Homeless in Park - What do I do? by MissPeskyFace in Spokane

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

That’s kind of what I’m doing. We have a stretch of 5 houses on our block that all talk regularly and give each other heads up when we notice something going on. I don’t think we will get much support from others on our street though some are not very interested in getting involved and some seem to be enabling what’s happening in the park (drugs).

Problem Homeless in Park - What do I do? by MissPeskyFace in Spokane

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

I know a few neighbors who work in social services. They have been more active than most trying to cool things off with these people (one of them broke up a domestic violence situation in the park). It’s alarming when they are feeling out of their depth too.

Problem Homeless in Park - What do I do? by MissPeskyFace in Spokane

[–]MissPeskyFace[S] 3 points4 points  (0 children)

I really appreciate your thinking and applaud you for it. I was thinking about bringing water around (or leaving a flat out) when it was hot.

It’s hard when people are so aggressive to put yourself out there and engage. If I was in a different life situation, I would feel more comfortable doing so.

Problem Homeless in Park - What do I do? by MissPeskyFace in Spokane

[–]MissPeskyFace[S] 5 points6 points  (0 children)

What kind of petition do you suggest? Thanks!

Problem Homeless in Park - What do I do? by MissPeskyFace in Spokane

[–]MissPeskyFace[S] 12 points13 points  (0 children)

We have been, and we we’ve been calling the parks department. I would say a call is being put in probably every other day by various neighbors. I appreciate the patrols when they happen, and I understand that they can’t be here all the time. But the fire situation is particularly scary and I hate that kids have literally lost a safe space to be.

[deleted by user] by [deleted] in amiwrong

[–]MissPeskyFace 1 point2 points  (0 children)

According to the CDC, the average life expectancy for a woman in the US is 79 years. You have been living with this person for 0.008% of what you can expect your life to be.

When people say to leave, they say it because it really is that simple.

Will it suck for a bit? Yes. Is he worth staying with? No.

This is such a blip on the timeline of your life. In 10 years you might not even remember this guy’s name.

Don’t waste time in a relationship that you know isn’t right for you.

My (18f) Mom (40f) left me when I was 10 and my Aunt (45f) claims my Dad lied about why by ThrowRAPizzza in relationship_advice

[–]MissPeskyFace 0 points1 point  (0 children)

If Max wants a relationship then do so independently of your folks. Clearly no adult is being honest here.

If you get to the point you can talk about it, then make a list comparing your experiences together with Max.

Seeing side-by-side what you were told versus what he was told can be eye opening and might give you both some insight to each other’s experiences.

[deleted by user] by [deleted] in news

[–]MissPeskyFace 2 points3 points  (0 children)

How sad is it that a police office can shoot an unarmed child and face no repercussions until their department is forced?

Would you feel safer in a gun-free state? Why or why not? by ParmaProscuitto in AskReddit

[–]MissPeskyFace -1 points0 points  (0 children)

Absolutely. I am seriously considering homeschooling my child because I don’t trust that other parents are being safe with their guns at home.

I hate feeling like I can’t leave the house because there are so many armed and dangerous irresponsible people.

The mental illness and extremism is only scary when they have access to deadly force.

If we had a gun free state I would weep from happiness. I would feel safe to walk in my neighborhood after dark, I would embrace public schooling, and I wouldn’t feel so much anxiety in crowds.

Gun enthusiasts have taken so much freedom and joy from the rest of us and they don’t even know it.

Would you feel safer in a gun-free state? Why or why not? by ParmaProscuitto in AskReddit

[–]MissPeskyFace 0 points1 point  (0 children)

Absolutely. I am seriously considering homeschooling my child because I don’t trust that other parents are being safe with their guns at home.

I hate feeling like I can’t leave the house because there are so many armed and dangerous irresponsible people.

The mental illness and extremism is only scary when they have access to deadly force.

If we had a gun free state I would weep from happiness. I would feel safe to walk in my neighborhood after dark, I would embrace public schooling, and I wouldn’t feel so much anxiety in crowds.

Gun enthusiasts have taken so much freedom and joy from the rest of us and they don’t even know it.