-
Senior Member
Reputation: 491
Inter-Site Distance [Sector]
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
-
2017-10-02 05:20 AM
# ADS
Circuit advertisement
-
Member
Reputation: 241
Re: Inter-Site Distance [Sector]
Hi,
did you meant on a map view or excel ?
in excel it's just a formula for calculating distance.
Originally Posted by
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
-
Senior Member
Reputation: 491
Re: Inter-Site Distance [Sector]
Originally Posted by
isha
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!
-
Member
Reputation: 241
Re: Inter-Site Distance [Sector]
hi
can you mark on the map what you looking.
dis.jpg
-
Post Thanks - 1 Thanks
-
Senior Member
Reputation: 491
Re: Inter-Site Distance [Sector]
Hi as shown below,
want to calculate the minimum distance for each sector separably
-
Member
Reputation: 241
Re: Inter-Site Distance [Sector]
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
sector_distance.jpg
-
Post Thanks - 1 Thanks
-
Member
Reputation: 127
Re: Inter-Site Distance [Sector]
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
Bookmarks