Inter-Site Distance [Sector]

[justdream]

Dears,

Do you know how to calculate Inter-Site Distance but for each sector/ Azimuth
as it really differs from sector to sector especially in border sites

[isha]

Hi,
did you meant on a map view or excel ?
in excel it's just a formula for calculating distance.


Dears,

Do you know how to calculate Inter-Site Distance but for each sector/ Azimuth
as it really differs from sector to sector especially in border sites

[justdream]

Hi,
did you meant on a map view or excel ?
in excel it's just a formula for calculating distance.

Hi Friend,
in Excel
but calculation to be [each sector Azimuth] not for site.

Any idea!

[isha]

hi
can you mark on the map what you looking.

40897

[justdream]

Hi as shown below,
want to calculate the minimum distance for each sector separably

[isha]

hi friend,
try following in excel, refer the diagram

Angles-Radians, Distance-km

site A : (LonA,LatA), Azimuth : α, sector distance : x
site B : (LonB,LatB), Azimuth : β, sector distance : y

inter sector distance = d


location x = (Px,Qx)
location y = (Ry,Sy)


Qx = ASIN(SIN(LatA)*COS(x/6371) + COS(LatA)*SIN(x/6371)*COS(α))
Px = LonA + ATAN2(COS(x/6371)-SIN(LatA)*SIN(Qx), SIN(α)*SIN(x/6371)*COS(LatA))

Sy = ASIN(SIN(LatB)*COS(y/6371) + COS(LatB)*SIN(y/6371)*COS(β))
Ry = LonB + ATAN2(COS(y/6371)-SIN(LatB)*SIN(Sy), SIN(β)*SIN(y/6371)*COS(LatB))


d = ACOS(SIN(Qx)*SIN(Sy) + COS(Qx)*COS(Sy)*COS(Px-Ry)) * 6371

BR,
isha

40906

[NPERF]

Hai Friend

I too is also looking for the same as Just dream intended for

Will be great if you can make an small excel sheet with formula and sample sheet

:(

Regards
Thanks