Calculating Distance to Devices in Excel

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

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...