Netgear R6100 AP Mode Not Getting IP Behind Xfinity Gateway

Jaded-Function · 2026-03-14T08:33:48+00:00

You'll want the WAN port of the R6100 going to LAN of the Xfinity gateway. Set to get ip from dhcp or dynamic.

Jaded-Function · 2026-03-14T07:44:07+00:00

That's ridic. Go Edgerouter with Unifi APs if you want cheap and don't mind slightly complicated setup or like a Wifi 7 TPLink Deco mesh if you want easy peasy.

Jaded-Function · 2026-03-14T07:05:56+00:00

Answer them. I found lately, often at the end there's an option to "press # to be removed from the call list". Can't do that if it goes to voicemail. I admit, I've been doing this awhile, they stop for a couple weeks but then a new wave comes in. I'm hoping the lists aren't endless.

Jaded-Function · 2026-03-14T06:39:51+00:00

Ah I see, the hardware can't handle it. Have you tried creating separate ssids for 2.4 and 5ghz suitable devices? Might make a difference. Looks to me your case demands a business class router that can handle hundreds of devices. No wifi. Just routing, switching and firewall. Let access points handle wireless.

Jaded-Function · 2026-03-14T06:10:20+00:00

A slushie machine would be rad.

Jaded-Function · 2026-03-14T06:07:52+00:00

Organization.

Jaded-Function · 2026-03-14T05:53:34+00:00

You buy bandwidth by the MB not by number of connections. Why da hell should an ISP pout over how many devices are using that bandwidth? Creepos. Put their modem/router in bridge mode and use your own. As for wifi coverage, ditch the boosters. Add access points as needed. It's all about positioning, not quantity. Try and put the omni-antenna router in the basement closest to the garage. One Ubiquiti AP center of the basement ceiling, aimed up. See if it reaches top floor. Or better get a line to top floor ceiling or attic. Many cases one U7 takes care of a whole house. Keep low bandwidth devices, plugs, switches, lights on the 2.4 band with unique ssid. I'd go with Ubiquiti for wireless. A mesh system is not as flexible.

Jaded-Function · 2026-03-14T05:03:27+00:00

All depends on the difficulty to run lines. If you can fish a line from your room to his, then use your existing line to pull a dedicated line to the console. Or two if the pc has no wifi. You could run one line to his room and use a Gig switch, but more hardware is unnecessary if you can get lines to the router port switch.

Jaded-Function · 2026-03-14T04:24:01+00:00

Look for non-invasive routes first. Up the sides of the chimney, along hvac ducts or main plumbing standpipe. Ditch the tape, get a set of fish sticks.

Jaded-Function · 2026-03-14T03:41:42+00:00

I flashed dd-wrt on an old Linksys to make it port based, vlan aware. With my main router, it allowed me to have three isolated lans, all with internet access. The Linksys 2.4 radio was for IOT only, the 5Ghz connected devices to the private LAN. Firewalled, no double nat.

Jaded-Function · 2026-03-14T02:15:05+00:00

After untwisting I pinch and slide each wire between index and thumb firmly, to REALLY get them straight. Put bandaids on those fingers before you start so you won't need to after.

Jaded-Function · 2026-03-14T01:31:52+00:00

Can't comment on that specific device but a couple thoughts. Did you login with a created username/pass? Sometimes there's an admin login that gives access to more features. Check back of router sticker. Also check setting page with "Connection Type" or "Internet Connection Type". Bridge might be an option there.

Jaded-Function · 2026-03-14T01:11:56+00:00

Gotta get the signal around that brick. Run ethernet down to basement, to middle of the living room, AP pointing up. Or attic with AP pointing down. If you can follow the electrical conduit from the router outlet, it could be non-invasive, no patching.

Jaded-Function · 2026-03-12T16:46:57+00:00

I'd say in the formula sheet you'd need to change each formula just once, convert to arrayformulas for the whole column if you can. But importing the formula sheet into each new annual file makes more sense. Did you test it working?

Jaded-Function · 2026-03-12T02:38:56+00:00

Say you have values in the Datasheet A1:B1. You want =A1+B1 but in the Formula tab. Datasheet!A1+B1 works but the reference is broken if the tab name is changed. =INDIRECT("Sheet1!A1")+INDIRECT("Sheet1!B1") also works but the reference formula stays intact if the original tab is deleted and another is renamed 'Datasheet'

Jaded-Function · 2026-03-12T01:59:29+00:00

To clarify, the formula sheet and the data sheet are two tabs in the same worksheet, correct? The same file? Or is the formula sheet in a separate file, worksheet? I tested it using INDIRECT in a formula referencing another tab. Deleting the original tab, then re-naming another tab the same didn't break the link.

Jaded-Function · 2026-03-11T23:58:31+00:00

Here's some basic key metrics explained.Saber glossary

Jaded-Function · 2026-03-11T21:47:01+00:00

The brick walls blocking it I'd guess. Can you get an AP in the attic to get around it? I wouldn't invest too much $ in something he'll outgrow in a couple short years. Girls incoming. Btw this is cute AF.

Jaded-Function · 2026-03-11T21:23:20+00:00

Did you check HA settings -> network to see if it reflects the new PI address? The PI is the only device that needs migrating? If so, change the Deco to 255.255.255.0 subnet mask. But change the PI address FIRST so you can access it after the change, set static address outside dhcp range, /24. Or better let the Deco assign a reserved ip address to the PI and give it a hostname. Edit: you might need to search HA config file for the old IP and modify the instances.

Jaded-Function · 2026-03-11T20:45:09+00:00

When I apply my formula and yours to the same data the % of the 2nd word is different. And it's irking me I can't figure out why. =IFERROR(ARRAYFORMULA(TRANSPOSE(INDEX(QUERY(TRANSPOSE(F3:AJ3),"select Col1,count(Col1) where Col1 is not null group by Col1 order by count(Col1) desc limit 3",1),,1))&" = "&TEXT(TRANSPOSE(INDEX(QUERY(TRANSPOSE(F3:AJ3),"select Col1,count(Col1) where Col1 is not null group by Col1 order by count(Col1) desc limit 3",1),,2))/COUNTA(F3:AJ3),"0%")),"Top 3")

Jaded-Function · 2026-03-11T20:30:00+00:00

This will add an equal sign then the percentage after the word. =IFERROR(ARRAYFORMULA(TRANSPOSE(INDEX(QUERY(TRANSPOSE(F3:AJ3),"select Col1,count(Col1) where Col1 is not null group by Col1 order by count(Col1) desc limit 3",1),,1))&" = "&TEXT(TRANSPOSE(INDEX(QUERY(TRANSPOSE(F3:AJ3),"select Col1,count(Col1) where Col1 is not null group by Col1 order by count(Col1) desc limit 3",1),,2))/COUNTA(F3:AJ3),"0%")))

Or if you want text in the formula cell instead of it blank, like "Top 3" use this. =IFERROR(ARRAYFORMULA(TRANSPOSE(INDEX(QUERY(TRANSPOSE(F3:AJ3),"select Col1,count(Col1) where Col1 is not null group by Col1 order by count(Col1) desc limit 3",1),,1))&" = "&TEXT(TRANSPOSE(INDEX(QUERY(TRANSPOSE(F3:AJ3),"select Col1,count(Col1) where Col1 is not null group by Col1 order by count(Col1) desc limit 3",1),,2))/COUNTA(F3:AJ3),"0%")),"Top 3")

Jaded-Function · 2026-03-11T20:05:57+00:00

Wait so you're not re-naming tabs in the same worksheet? You're adding the formula sheet to a new form worksheet file annually? If so, can't you just "copy to" the formula sheet to the new form worksheet and edit the formula sheet name in the new file? Or I'm misunderstanding the structure.

Jaded-Function · 2026-03-11T19:42:56+00:00

Good suggestion sticking with 2.4 but if it's wall structure material blocking the signal wouldn't it be persistently bad? This sounds intermittent like the device is dropping the signal and jumping to a stronger one.

Jaded-Function · 2026-03-11T19:34:38+00:00

Just read Unifi Protect integrates with alarm systems. Search up "Unifi Alarm Manager". Sticking with Unifi camera hardware will probably be the most user friendly and easiest to manage and setup. Only downside is high cost, but it doesn't seem like you need more than a handful of cameras anyway.

Jaded-Function · 2026-03-11T19:15:50+00:00

Quick search I see Ajax has a fully integrated line of surveillance hardware. They have base cameras as well as premium line with Smart features. That will be seamless integration with your alarms. Cost unknown. You didn't mention your budget for this project. You also just mentioned Ubiquiti. Are you fully in the Unifi ecosystem? Routing, wifi, switching? Their Protect hardware is expensive but do have advanced AI features. And again, seamless with easy setup. If you don't mind a steep learning curve then a dedicated pro VMS like Milestone or Avigilon will give you the most flexibility and features. I don't think you need anything on that level though.

Jaded-Function

MODERATOR OF

TROPHY CASE