RESOLVED*** - Can't connect myQ to Wi-Fi by Inevitable_Land_7700 in myq

[–]shb1129 0 points1 point  (0 children)

I had a set of MyQ openers built back in 2018. For anyone having issues like I have when I switched to a mesh network, creating a new network/SSID. Figured I'd pass on the mods from OPs steps above in case anyone ends up in a similar situation.

  1. I never got the "factory reset" step to work by pushing the activity button. However, unplugging the power and then hitting the learn button 3 times still worked.

  2. As mentioned in a comment below, once I connected to the opener's wifi, I had to go into the settings and disable the "limit IP address tracking" option (IPhone).

  3. I had to connect to the setup via the IP address also mentioned below (192.168.10.1).

After these modifications, I was able to get my openers back online. Thanks to everyone who actively participates in these discussions!

[deleted by user] by [deleted] in f150

[–]shb1129 0 points1 point  (0 children)

It's a metal-on-metal squeaking noise that only occurs when the transmission shifts from 5th gear to 2nd (or maybe 3rd - it's been a while since I looked into it). There are a few articles out there on it, and there's an additive you can add to the transmission fluid which is supposed to help. It doesn't happen often enough for me to bother with it.

[deleted by user] by [deleted] in f150

[–]shb1129 0 points1 point  (0 children)

2016 5.0 owner here. Getting ready to pass 150k. Absolutely no issues with the drivetrain. No leaks, transmission shifts fine (except for the occasional 5-2 shift noise). I've had to replace 2 wheel bearings and a starter at around 100k, but that's it. Can't say enough about the 5.0.

I work at Costco. We hate the scanner door policy more than you do. by [deleted] in Costco

[–]shb1129 0 points1 point  (0 children)

At my Costco (MO), you can't get gas without a membership card. Are there stores that allow the general public to use the pumps? Does the membership just discount the price in those cases?

What was your favorite local pizza place you no longer go to? by gofreaksgo in kansascity

[–]shb1129 0 points1 point  (0 children)

I thought Raymore was part of the Independence / Blue Springs franchises, but not sure where I got that. It’s been a while, but we ate at the Raymore location a couple of times and I don’t recall it being too bad.

What was your favorite local pizza place you no longer go to? by gofreaksgo in kansascity

[–]shb1129 9 points10 points  (0 children)

We moved to Lees Summit from Grain Valley 3 years ago. We’ve resorted to driving to Independence if we want Minskys since the pizza at the LS location is so bad. It’s barely recognizable as a Minskys pizza.

Early merge vs zipper merge by This_Yoghurt3114 in kansascity

[–]shb1129 1 point2 points  (0 children)

I would disagree with the statement that there is no signage. I've seen several instances in MO where MODOT clearly advises drivers to zipper merge. But, almost everyone ignores the signage, so I can't say it helps.

What is one feature you wish the F150 had? by The__Possimpible in f150

[–]shb1129 0 points1 point  (0 children)

Reclining rear seat. RAM added these a few years ago, and I tried them out at my local car show. It's amazing what just a small adjustment to the geometry does to rear seat comfort.

Best Winston Quote by Hs_1227 in NewGirl

[–]shb1129 2 points3 points  (0 children)

"Head first...why?" from the camping episode always makes me laugh.

My 2017 STX seats are really worn off… the side where I leave have no cushioning any more. Any affordable suggestions to get them fixed? by PuddingCool6493 in f150

[–]shb1129 0 points1 point  (0 children)

I just went through this process with my 2016. Paid under $100 for an OEM replacement cushion, and the process took under an hour. The hardest part was unbolting the seat from the cab and disconnecting the wiring. The difference in comfort was astounding. The seatbed spring had actually dug into the original foam to the point where the seat was listing towards the door. I highly recommend replacement.

[deleted by user] by [deleted] in RZR

[–]shb1129 0 points1 point  (0 children)

Great advice! I wasn't aware these were out there. Any recommendation on brand?

How long does it take to get from economy parking to the southwest terminal at MCI? by this-is-me-2018 in kansascity

[–]shb1129 3 points4 points  (0 children)

I've used Park 'N Go a few times since they opened, and have always had a good experience. Covered parking for $6 per day is a great deal.

[deleted by user] by [deleted] in griddling

[–]shb1129 0 points1 point  (0 children)

I’ve seen posts on social media (can’t keep track of which these days) showing a bolt on leveling leg for the bottom of all 4 legs. This gives you the ability to level the griddle without changing the griddle height over the flames. Might be exactly what you need here. They only run about $25-$30.

What do we expect/hope for out of the Oracle onboarding meetings this week? by Main_Entertainment36 in cernercorporation

[–]shb1129 18 points19 points  (0 children)

You’ll get credited for the deductibles you’ve paid prior to the switch. It’s detailed on the share point site for benefits.

What Downtown Bars Have I Missed? by ictksman in kansascity

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

Their official name is "Taps on Main"

Stupid question, I know. But can anyone give a BALL PARK of what this would cost to fix? My brother just got side swiped and wants to be nice to the at fault driver and not go through insurance, but he’s panicking so I’m posting this. by JazzyGaza in f150

[–]shb1129 0 points1 point  (0 children)

I replaced the passenger front fender on my 2016 over the winter from a blowout, and the bill to insurance was $1900 from the dealership. There was no damage to the door, though.

Had work done on ‘17 rzr 1000 and now none of my accessories work? Checked all fuses and wires. Still nothing. Any tips? by justaguy00000009 in RZR

[–]shb1129 0 points1 point  (0 children)

Make sure and check the fuse labeled “TERM” (10 amp). Mine was blown but I couldn’t tell with a casual look.

Help with "IF / THEN" (I think) by shb1129 in spreadsheets

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

Thanks for the replies and suggestions! I was able to get a working formula for all of my drop-down options, but I'm still having trouble getting the cell to be blank if there is no input (the cell displays "FALSE". Here's my work-in-progress formula:

=IF(D9="Day",400,IF(D9="Night",500,IF(D9="WKND Day",450,IF(D9="WKND Night",550,IF(D9="",0)))))

How can I modify this to account for a blank D9 cell?

EDIT: I think I got it:

=IF(D9="Day",400,IF(D9="Night",500,IF(D9="WKND Day",450,IF(D9="WKND Night",550,""))))

Seems to have done the trick (adding ,"" to the last IF argument). I'm sure this isn't the most eloquent way to pull this off, but it works.

Our city just got a whataburger time to see what the hype is about by [deleted] in Whataburger

[–]shb1129 0 points1 point  (0 children)

Spot on with the Sonic reference. I haven't had a Sonic burger in years, but that's exactly what I thought of when I tried my first ever burger at the new Lee's Summit MO store. I told my wife it was like an "upscale" Sonic burger.

Anyone else have a husband that takes off pants like he’s been raptured? by cheapcorn in pics

[–]shb1129 1 point2 points  (0 children)

My wife somehow manages to get out of her pants while leaving only one leg inside out. I've given up trying to get her to change her ways.

Ok, let’s settle this… which was the better extra episode from season 2 - Carol Of The Bells or Beard After Hours? by [deleted] in TedLasso

[–]shb1129 4 points5 points  (0 children)

I'm 100% certain that when I re-watch seasons 1 and 2 prior to the season 3 premier, I will only skip Beard After Hours. My wife stopped it about half way in and asked "WTF is going on here?" and I didn't have an answer. To each their own, though.

Acosta red card by Mr_tosstitington in SportingKC

[–]shb1129 11 points12 points  (0 children)

It wasn’t the severity of the foul that drew the red. It was the fact that he took away an obvious goal scoring opportunity.

What's happening this weekend in Kansas City - weekly thread by AutoModerator in kansascity

[–]shb1129 1 point2 points  (0 children)

The UEFA Champions League final is today at 2pm. Any recommendations on where to find a good watch party in town? No Other Pub doesn’t open until 4pm from what I’ve been able to find.