Dear experts,
Could anyone help me with an Excel macro to identify the nearest planned sites that are being faced by sectors of live sites?
In other words, I’m looking to find the nearest sectors (from live sites) that are pointing toward planned sites.
How to approach this in Excel?
I use QGIS for that, as I don’t have an Excel macro.
MapInfo’s default distance calculator can do this easily.
Thanks.
But while the distance calculator identifies the nearest site, it does not include information about specific sectors (alpha, beta, gamma).
You can use QGIS plugging mentioned in this post:
It will as it calculates the distance of the nearest object, be it cell (sectored object) or site (point object).
I wrote down similar python script using AI.
