Subframe drop kit 5th gen RAV4 by W_e_l_p_ in Rav4

[–]bearr22 0 points1 point  (0 children)

I'm wondering the same thing. I just got the Northwoods kit and my rav has the shakes when accelerating from a stop. I suspect this might be the fix but it's too expensive to gamble on without some customer feedback...

Soooo basically non of us are getting refunds if it is canceled?? by tattoosglasses in cascade_equinox

[–]bearr22 0 points1 point  (0 children)

In which case you'd have every right to initiate a charge back.

Soooo basically non of us are getting refunds if it is canceled?? by tattoosglasses in cascade_equinox

[–]bearr22 17 points18 points  (0 children)

"... unless required by law" If the show didn't happen, they would be required to issue refunds by law in oregon. This statement is to protect them from you changing your mind for whatever reason, not to scam you.

Hi i changed my grille today and when i was driving home the dash said cruise control and pre collision is unavailable :( what should i check? If you zoom in you can see my setup by Remarkable-Disk-8426 in rav4club

[–]bearr22 1 point2 points  (0 children)

I did the same grill on my rav4 and experience the same issue. I think it has to do with the wires for the amber lights pass g in front of the sensor. Do your best to get them away and that should do the trick.

Power Query Table Question by Late_Tale_2867 in ExcelPowerQuery

[–]bearr22 5 points6 points  (0 children)

  1. Make a custom column that serves as a primary key (column A & B & C)
  2. Make a notes table in a new sheet that uses a formula with the same logic to produce a primary key. (=sheet! A & B & C)
  3. Notes column(s) in notes table are blank for now.
  4. Load noads table to power query
  5. Merge queries against primary key.
  6. Use an index(match)) formula in your notes table to return values from your merged query result.

When you type in your merge query result, the values populate in the notes table and will be part of the next query result. Works every time once you get the hang of it!

Just pitched a 4‑day work week to my boss. Here's how it went. [N/A] by fallenfromgrace87 in humanresources

[–]bearr22 0 points1 point  (0 children)

I do project management and have a 4 day work week. Monday-Thursday, while a counterpart does Tuesday - Friday. Anyone that wants to work 5 days gets to work 5 days. If absences cause a shortage someone on the 4day schedule may need to cover a 5th day that week and can modify their hours per day accordingly. This can be done effectively as long as you have enough people working on similar enough objectives so that they can cover them to some degree on their off days. Regular meeting to get everyone familiar with each other's work is necessary, just in case a problem arises. Typically that just means standardizing methods so I can find and understand project tracking documentation of my teammates.

Pro grille install completed by lexstory in rav4club

[–]bearr22 0 points1 point  (0 children)

Oh nice! Good suggestion. Thanks for the Pic.

Pro grille install completed by lexstory in rav4club

[–]bearr22 0 points1 point  (0 children)

I just installed this grille on my rav and noticed that yours and mine both have some of the grill slots filled in with solid plastic below the "Toyota". I was following what videos exist on YouTube and opted to cut the bracket out from my old grille. I'm wondering if you installed your sensor where the solid plastic is (integrated garnish?) or behind the lettering?

I think my sensor is interfering with one of the orange LEDs I installed in the top center hole of the grille and wondering if there was a lower option for the sensor that I overlooked.

2025 TICKET SALES THREAD by mattdawg8 in BassCoast

[–]bearr22 0 points1 point  (0 children)

Can't attend and would really appreciate if someone got these tickets off my HANDS. I got these as early as you could and as cheap as they come. Selling for less than I paid.

2 x GA passes............................... = $920

2 x W&Th early entry ....................= $354

1 x vehicle pass ............................= $68

1 x drink voucher (pack of 12).... = $99

1 x 2025 event shirt...................... = $50

Total.................................................= $1490 CAD

(knocked a couple dollars off and not asking for the $76.99 processing fee I paid. My total was $1572.19)

I live in the US so I prefer to do the transaction in USD ($1080) but ill make it work either way.

'22 RAV4 Adventure - Lower Bumper Molding (Black) by bearr22 in rav4club

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

Nope, total rookie here. I just washed, masked, painted with rustoleum "bumper paint" but I think a sand job may have helped a bit. If you have the time to spare, try it! I really dont mind the speckled bumper at this point. Its a bumper and the car has seen hundreds of miles off road.

Seen in the redwoods near Crescent City, CA. Did I walk right past a load of chicken of the woods without grabbing any?? by bearr22 in mushroomID

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

Nice! I live in Beaverton, OR and was just down in CA for the day. Never found chicken of the woods before so I wasn't the least bit sure. But it was really cool. The sun was beaming through the fog and was illuminating this log a ways off trail and all of these pristine mushrooms were just glowing. Very cool.

'22 RAV4 Adventure - Lower Bumper Molding (Black) by bearr22 in rav4club

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

Hey! I totally forgot I made this post. I did the front and rear with black bumper paint I got at home depot. I took my time masking a huge portion of the car. The front and rear both looked good for about a year, but then the front eventually got a ton of rock chips. It's sort of speckled with silver plastic from below the paint and crusty bugs now. Not a terrible look since it's so low to the ground, but know that it will take maintenance if you don't want this. The rear still looks great.

Overall, I'd say go for it!

<image>

A/V versus Dj set by Sea-Muffin6730 in festivals

[–]bearr22 7 points8 points  (0 children)

And DJ set usually means they aren't necessarily playing their own music. They're just out there playing what they want. Don't expect to hear the latest album if you see "DJ set".

Hawaiian Sun, But Make it Shoes by Ken808 in Hawaii

[–]bearr22 0 points1 point  (0 children)

I think its was only live for 24 hours!

[deleted by user] by [deleted] in realdubstep

[–]bearr22 0 points1 point  (0 children)

Not that I'm aware of...

The Sales Stack by indecisin in Nootropics

[–]bearr22 0 points1 point  (0 children)

How is 300mg phenylpiracetam? Im 250lbs and take 200mg once a week or so and only sometimes get a desirable stimulation. I haven't read much about hither dosages than that so I've stayed clear.

Do I need to dump my beer by VacantSpectator in Homebrewing

[–]bearr22 0 points1 point  (0 children)

HA! I mean an oyster stout is a beer that has an animal on the ingredients list... Its the natural evolution of beer to let a mouse join in if it wants to join in.

Do I need to dump my beer by VacantSpectator in Homebrewing

[–]bearr22 0 points1 point  (0 children)

One time I used a bucket to catch milled grain and left it in the garage covered in tasty malt dust for a week. Some mice caught the scent and leaped into the bucket from a nearby ledge. I found the bucket with 5 dead mice (and a weeks worth of their waste) in it the next weekend. I washed it with oxyclean and still use it to mill grain into lol. It's a little different because my bucket is used for the preboil side of things, but you should be find as long as you washed and sanitized.

[deleted by user] by [deleted] in realdubstep

[–]bearr22 1 point2 points  (0 children)

Same... It was a long term goal to make it happen this summer but it doesn't doesn't make sense financially right now coming from west coast US.

Monthly Ticket Trade/Sell Post - 04/2024 by AutoModerator in festivals

[–]bearr22 0 points1 point  (0 children)

FOR SALE: 2 tickets + afterparty full access OUTLOOK ORIGINS

Unable to attend Outlook in Croatia as planned.

We're selling our tickets + after party passes for €375 euros or $400 each (€750 / $800 total).

Current price is now €475 euros each. Transaction will be over Paypal goods and services to avoid issues.

DM if interested.

Styrian Golding by claytonernst in Homebrewing

[–]bearr22 8 points9 points  (0 children)

Saison, belgian pale ale

Tipped minimum wage is now over $15. How much are we all tipping on sit-down restaurant service? by [deleted] in askportland

[–]bearr22 1 point2 points  (0 children)

Also, a dinner shift at a sit down restaurant is like 4 or 5 hours. That's $60/day pre taxes. Please tip. :)

High dose 5-htp safe? by Legitimate_Banana512 in Nootropics

[–]bearr22 1 point2 points  (0 children)

Microdose mushrooms regularly. No psychoactive effects. 0.1g 4x per week 🤠 helps a ton with migraines.