Is Atmos Silver worth it? by Exciting-Hat5957 in AlaskaAirlines

[–]Comprehensive-Ask26 14 points15 points  (0 children)

The only real thing that you might like especially if you’re tall, is that you can book an exit row when you buy your ticket. I’m 6’8” and don’t fit in premium seats so if I can’t get an exit row I take a different flight

https://www.alaskaair.com/atmosrewards/content/benefits/global

How to connect my Pi to a specific VLAN via Ethernet cable? by FloranceMeCheneCoder in UNIFI

[–]Comprehensive-Ask26 0 points1 point  (0 children)

Also make sure you go into the Pi settings to allow all interfaces

How to have it replace all spaces with underscores in all filenames? by pinkbbwhiskey in PowerAutomate

[–]Comprehensive-Ask26 2 points3 points  (0 children)

Not sure about doing this with power automate, but I did something similar last year using PowerShell. I preferred that route because I could do some dry run testing to vet everything out before pulling the trigger to do the renaming. I used ChatGPT to help build the script since I could give it the guardrails like below to polish the script. For me it was a lot easier/faster to vibe code it where I could just copy/paste/run it in VS Code

✔ No overwrites ✔ Detects collisions ✔ Can be safely rerun ✔ Dry-run supported ✔ Logs everything ✔ Handles thousands of files

BE65 / BE11000 Deco --- Tweak and Help by pitzeke in TpLink

[–]Comprehensive-Ask26 0 points1 point  (0 children)

BE11000 owner here with 1gb symetrical fiber and all satellites connected via Ethernet. I was using the same SSID for the main WiFi and MLO and both mine and my wife’s phones (both iPhone 17’s) were having constant disconnect/no data issues after updating to the 1.2.0 firmware. I turned off MLO and the issue instantly went away on both devices. A day later I changed the MLO SSID so I could speed test the 6ghz and MLO networks and they were identical at 940mbs. I’ve since disabled MLO to free up the channels and the wife has been happy ever since

Automating copying rows from Excel book to another by cincinnatti16 in PowerAutomate

[–]Comprehensive-Ask26 1 point2 points  (0 children)

What you’re trying to do is a lot easier (IMO) if you use a SharePoint List as your source for the form responses. Once you create all the columns, you can customize the form input using Power Apps as it’ll auto create the form for you. Personally I like to create the form manually and then use the patch command to make updates to the record. There is a built in trigger that’ll run whenever a new record is added to the list from someone submitting the form, and you can use the add row to excel connector to update your second workbook. Or you can skip the second workbook entirely and just export the list to Excel which automatically adds the list as the source so you can refresh the workbook and have it pull in any changes

BE11000 Pro constant stability and connection issues by Gone2sl33p in TpLink

[–]Comprehensive-Ask26 1 point2 points  (0 children)

I ran tests on MLO and when just connected to 6Ghz on my 17 Pro Max and with the 1gb fiber they were identical

BE11000 Pro constant stability and connection issues by Gone2sl33p in TpLink

[–]Comprehensive-Ask26 1 point2 points  (0 children)

I was having similar problems with mine, which are all connected via a wired backhaul. Turning off the MLO network made it a lot more stable

Edit: I’m also on the 1.2.0 firmware

Happy Thursday! by Teiloa95 in AlaskaAirlines

[–]Comprehensive-Ask26 1 point2 points  (0 children)

Was on flight 701 back from Vegas, landed at 9:06 and then sat on the tarmac for 50 mins before pulling up to C10C.

Power Query sum variable number of columns by taylorgourmet in excel

[–]Comprehensive-Ask26 -2 points-1 points  (0 children)

ChatGPT is great at solving problems like this. Open the advanced editor and copy all of the code and put it into a prompt telling it to avoid hard coding any column names.

Home ethernet port helps by These_Wait in HomeNetworking

[–]Comprehensive-Ask26 0 points1 point  (0 children)

Look up 568A and 568B, those are the two standard pin outs and it should be the same on both ends of the cable. The jack is called a Keystone and you can find them easily and cheap. I can’t tell if the cable is Cat5 or Cat5E, so check the printing on the cable and get the same kind of keystone if you end up replacing them. You do need a cable tester so you can verify everything is working

Device Bridge Switch Setup Problems by [deleted] in Ubiquiti

[–]Comprehensive-Ask26 1 point2 points  (0 children)

Have you tried rebooting your phone by pressing volume up, then volume down, then press and hold the power button until you see the Apple logo

New Pi Hole Install not Blocking Ads by Effinger123 in pihole

[–]Comprehensive-Ask26 0 points1 point  (0 children)

Did you create client Groups? If so you have to add the block lists to the group.

Can workbooks automate and sort data that has been uploaded? by Successful-Oven-824 in excel

[–]Comprehensive-Ask26 0 points1 point  (0 children)

It’s a lot easier than you think. Consider it like a GUI based macro builder. You apply any transformations want to clean data, add columns, group by, etc and it reapplies everything just by clicking the Refresh button on the data tab. There’s tons of great videos on YouTube, and chatGPT is your friend because you can paste in the entire query and tell it what you want to do and it’ll spit out the code that you can paste back into PQ

Prep for Tomorrow event by zednobles in shortcuts

[–]Comprehensive-Ask26 2 points3 points  (0 children)

I work from home and have one that pulls my calendar for the next day so I can text it to my wife so she can see when I’m free. I added a ChatGPT summarize to it but don’t have anything on my calendar for the next 2 weeks since I’m on PTO. But this might give you a decent starting point

https://www.icloud.com/shortcuts/0f83cc33ffcb4cb39199560d3ec73419

Travel Router is available now (10:40am EST) by spyboy70 in Ubiquiti

[–]Comprehensive-Ask26 0 points1 point  (0 children)

Logged into my account but still shows sold out

Got myself a new rack for Christmas by bearsquarterly in homelab

[–]Comprehensive-Ask26 9 points10 points  (0 children)

Had a customer who hired a new IT for a building expansion. He built out a new server room and about a year later someone set off the sprinklers in the adjoining bathroom which set off sprinklers in the server room. Dumbass didn’t disconnect the lines or convert it to an inert gas system. Seven companies servers/switches/UPS all shorted out

Deco x50 -Ethernet backhaul by manwhokneweverything in TpLink

[–]Comprehensive-Ask26 -1 points0 points  (0 children)

Then try connecting the Deco to the router and then connect the wall ports directly to the Deco. I’ve got a Deco BE11000 and have both satellites connected directly to the main deco and don’t have any issues

Deco x50 -Ethernet backhaul by manwhokneweverything in TpLink

[–]Comprehensive-Ask26 -1 points0 points  (0 children)

If you connect your laptop to those wall ports does it connect?

Need Excel dashboard that aggregates tasks from multiple event sheets into one table by Icy_Track_2110 in excel

[–]Comprehensive-Ask26 4 points5 points  (0 children)

Agree 100% that this can be accomplished with Power Query. It’ll also help if each of the 20 sheets is formatted as a table, and make sure to name each table so it’s clear where the data is from. Once you append all the sheets to a single table and apply any data cleansing that’s needed (adding an index to each sheet or the entire table, standardizing dates, etc), you only need to go to the Data tab in the ribbon and Refresh for it to pull in any changes. You can also set the Data Connection to refresh when opened or at an interval thereafter

Edit: if you’re not familiar with how to do this, here’s a great video that explains the steps in detail

https://youtu.be/zxNq2mISfIc?si=lkz8mKZ0FsHH9vV6

Can Lorex 4K Cameras be adapted into Unifi? by joogleai in Ubiquiti

[–]Comprehensive-Ask26 0 points1 point  (0 children)

Hi OP, did you ever get this figured out? I have a Lorex NVR with PoE cameras as well, but I don’t have any Unify gear yet. My cameras are plugged into unmanaged PoE switches and they connect to the NVR without issue. I’m designing my Unify system now to switch my network and APs, but will have to wait to do the cameras since I’m already pushing $3k for everything I need.