[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