[OZAPRS] re: Distance/bearing calculations

Barry akavk3 at austarnet.com.au
Mon Aug 30 13:05:25 EST 2004


Possibly the same one as available here??
http://nmml.afsc.noaa.gov/Software/ExcelGeoFunctions/excelgeofunc.htm

It is about 58k so is perhaps not the same version.

Barry vk3sw


-----Original Message-----
From: ozaprs-bounces at marconi.ics.mq.edu.au
[mailto:ozaprs-bounces at marconi.ics.mq.edu.au] On Behalf Of Ian Mills
Sent: Monday, 30 August 2004 12:44 PM
To: 'ozaprs at marconi.ics.mq.edu.au'
Subject: [OZAPRS] re: Distance/bearing calculations


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


_______________________________________________
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