Excel Formula for determining azimuth relative to true north between two sets of geographic coordina

[PJF]

Using the geographic coordinates for each, I've "translated" the FCC
procedure for determining the distance between two transmitters ( per FCC
73.208) into Excel formulas. Excel gives identical distance results to the
"fill-in" form provided in www.fcc.gov/mb/audio/bickel/distance.html . But
there is no comparable formula in the FCC R&R for determining the bearing
(azimuth) between the stations relative to true north, although the FCC's
fill-in form does provide azimuth.

My problem with using the fill-in form is that I have hundreds of
computations to make and I'd spend untold hours using the fill-in form for
one pair of stations at a time. If I can get a formula for determining the
azimuth relative to true north based on the geographic coordinate pairs, I
can whip this puppy in no time at all with Excel.

Any solutions or suggestions would be greatly appreciated.

Thanks and regards,

PJF

 

[Bernard Liengme]

A somewhat esoteric question for this group. Have a look at what Chip has to
say about lat & long on his site www.cpearson.com
best wishes

 

[PJF]

Thanks, Bernard. I will check Chip's site (as I have for many other Excel
related questions). That may be just the ticket!

Regrds,

PJF

 

[Dana DeLouis]

If you don't find it, perhaps this equation for the initial azimuth:

=ASIN(COS(Lat2)*SIN(Distance)/SIN(Long2-Long1))

The distance is in degrees that you calculated earlier. This assumes a
spherical earth, as I'm not familiar if the web site is using advances
calculations. I can't find my old notes, but you need to add that a
negative number is to the left of true north (360-n), and a positive number
is to the right of true north (0+n)
That web site doesn't display distance units, but it looks like the
distances are in "Statue Miles"

HTH :>)

 

[PJF]

Dana,

Many thanks. This helps to focus in on finding an equation that solves the
problem.

Kindest regards,

PJF