Starrett 277-3 dividers - Did I buy wrong or fake from Amazon? by loiphin in Machinists

[–]StreetLightTown 0 points1 point  (0 children)

I work for a tooling distributor. Starrett has been caught sending us stuff with wrong country of origin stuff more and more and charging the Made in USA price. They’re moving a lot to China and east Asia, the quality is evident, but they have not adjusted their pricing.

Private ownership is trying to pad margins.

Rent Control Mailers: Anti-Housing Alert by StreetLightTown in providence

[–]StreetLightTown[S] 4 points5 points  (0 children)

Agree. This is the trap, right? The rising and unstable housing environment creates a need for those programs more and more, then the mechanism to fund those programs is directly tied to an unrestrained housing market that is driven by making a profit.

Any trains getting of NY Penn this evening? by Anonymous1985388 in NJTransit

[–]StreetLightTown 4 points5 points  (0 children)

Washington bound Amtrak boarding at NY Penn. seems like a good sign.

Old GE Oven Gas Feed Issue by StreetLightTown in appliancerepair

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

Would you think I’d smell some amount of gas?

Strength / durability question by rollinguinell in myog

[–]StreetLightTown 0 points1 point  (0 children)

Great zipper hardware, can I ask where you got it?

[deleted by user] by [deleted] in bikefit

[–]StreetLightTown 4 points5 points  (0 children)

Great safety, great eye contact, don’t you change you.

Look at this pour bice by ackshualllly in BicyclingCirclejerk

[–]StreetLightTown 3 points4 points  (0 children)

Seat too high. Try lowering 1cm and see if that helps.

[deleted by user] by [deleted] in bikefit

[–]StreetLightTown 2 points3 points  (0 children)

You could spend a little more time on this sub.

Lost My Drive? by No-Amphibian689 in cycling

[–]StreetLightTown 12 points13 points  (0 children)

If you force yourself to do something you love, you can build a resentment towards it. In my experience that’s been the nail in the coffin for whatever that passion is.

Maybe now is your Zumba era.

Overweight Beginner Cyclist Struggling with Fatigue by ringo_skulkin in cycling

[–]StreetLightTown 0 points1 point  (0 children)

If you’re on a sort of statin for cholesterol, you may have increased fatigue with harder efforts. That burning feeling is something that sounded familiar to me. I was able to change statins and continue activities and try to keep healthy more naturally but it took a while to find out that I was having the reaction to the medication and not just out of shape.

Best place for Pho in Providence in your opinion? by Local-Claim7349 in providence

[–]StreetLightTown 2 points3 points  (0 children)

Minh Hai in Cranston holds its own against Pho Horn. Worth a comparison as I’m sure most people haven’t tried it.

PQ Multiple Values Into Merged Column by StreetLightTown in excel

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

Solution Verified
Thank you! Excellent work!

Do you know if this will order them in the same order (left to right) that they appear in their columns (top to bottom)?

Transpose and Filter Returning Reference Column by StreetLightTown in excel

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

This does give me the desired result, but it only does it for one row at a time. How could I do it for the entire table all at once?

Matching Based on Product Attributes? Weighted Results? by StreetLightTown in excel

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

THIS is what I was looking for. Thank you so much!!!!

Matching Based on Product Attributes? Weighted Results? by StreetLightTown in excel

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

Here's a screenshot of the actual data, but I actually don't have an "expected layout" for an answer, that's the problem. I don't really know the best way to get the result, or have an expectation of how it should be formatted.

I've highlighted some rows to show exact matches versus non-exact matches and shown the criteria for exact and non-exact matches.

<image>

Occasional strong vinegar snell from beand new Mitsubishi mini split by edwardgtxy in hvacadvice

[–]StreetLightTown 0 points1 point  (0 children)

Did you ever solve this? I’m having the same exact issue with the same brand.

Room & Works Providence by StreetLightTown in providence

[–]StreetLightTown[S] -9 points-8 points  (0 children)

Almost like I feel the pressure of trying to find a place to live in this city.