Calculating Distance to Devices in Excel

by | Nov 15, 2023 | Tech

Here is the Excel based Distance Calculation for selecting devices within a range on a central location. =ACOS(SIN(RADIANS($C$2))*SIN(RADIANS(C4))+COS(RADIANS($C$2))*COS(RADIANS(C4))*COS(RADIANS(D4)-RADIANS($D$2)))*6371 Excel Formula Notes: $C$2 is Central Latitude C4...

Accelerated Admin with Copilot

by | Nov 14, 2023 | Tech

GitHub Copilot is definitely helping me speed up software development and system admin support. Using VS Code, I can now use chatbot (as I call it) to get terminal window help. For example, I need to move a set of device location data from a production server to a...

by | Jan 20, 2022 | Tech

5GHz Channels for USA Using “Auto” for 5GHz Ubiquiti NanoStation5 loco proved to be not reliable. Set the Channel List: 5160,5180,5200,5220,5240,5745,5765,5785,5805,5825 Also, don’t forget to disable the AirMax...
Channel Map for LoRaWAN

Channel Map for LoRaWAN

by | Jan 29, 2021 | Tech

Channel Maps in the US902-928 Frequency (aka US915). Fact is that most LoRaWAN gateways are NOT going to be implementing 64(125KHz) + 8(500KHz) channel plans as permitted in the Regional Parameters. Most gateways will only support 8+1 uplinks. That means you need to...