[OZAPRS] re: Distance/bearing calculations

Ian Mills imills at awa.com.au
Mon Aug 30 12:44:16 EST 2004


Dave,
I have emailed you an excel addin that does a number of these conversions
and more. I use them daily at work, so I know they work.

If anyone else wants them, please advise and I'll upload to my server
space so you can download them. It is called geofunc.xla and is about 43k

- Ian VK2HIM

----------------------------------------------------------------------

Message: 1
Date: Sun, 29 Aug 2004 12:37:47 +1000 (EST)
From: Dave Horsfall <dave at horsfall.org>
Subject: [OZAPRS] Distance/bearing calculations
To: APRS in Oz <ozaprs at marconi.ics.mq.edu.au>
Message-ID: <Pine.BSI.4.58.0408291222500.17446 at dave.horsfall.org>
Content-Type: TEXT/PLAIN; charset=US-ASCII

I'm looking for algorithms to convert between UTM/D.M.S/etc, and to
calculate distance and bearing between any arbitrary pair.  If it matters,
assume WGS-84 and the Greater Sydney area.  It's for entry into a
spreadsheet (OpenOffice), so Wintendo binaries and Javascript etc are no
good.

Also, what's the "best" way to store position information?  The usual
XXXYYY grid reference is a little too coarse, as you can be 100m out, and
GPS easily beats that these days.  I'm guessing DDD.ddd for ease of
calculation?  Translating that to D.M.S is just base-60 arithmetic, but it
would be cool to convert from/to UTM, and Maidenhead...

-- Dave
_______________________________________________
ozaprs mailing list
ozaprs at marconi.ics.mq.edu.au
http://marconi.ics.mq.edu.au/cgi-bin/mailman/listinfo/ozaprs



More information about the Ozaprs mailing list