Identify nearest Planned Sites facing live Site Sectors

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?

2 Likes

I use QGIS for that, as I don’t have an Excel macro.

3 Likes

MapInfo’s default distance calculator can do this easily.

1 Like

Thanks.

But while the distance calculator identifies the nearest site, it does not include information about specific sectors (alpha, beta, gamma).

1 Like

You can use QGIS plugging mentioned in this post:

2 Likes

It will as it calculates the distance of the nearest object, be it cell (sectored object) or site (point object).

1 Like

I wrote down similar python script using AI.