-
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.
![Quote](images/misc/quote_icon.png)
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]
![Quote](images/misc/quote_icon.png)
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
![:(](http://www.finetopix.net/images/smilies/sad.gif)
Regards
Thanks
Bookmarks