GPS coordinate to Map Ref. Coordinates

G'Day All

A fella gave me a .CSV file the other day with coordinates for over 7000 gold mines starting at 10.5 deg S 138 Deg E and ending at 29deg S 153 deg E. This was great till I went to put some points on a Toppo map of my area and it was all in Deg Min Sec and the coordinates in the spreadsheet were all Decimal Degrees (GPS). I found formulas for converting GPS to Map Coordinates at this site

https://www.fieldmuseum.org/science/blog/converting-dd-dms-excel

Saved a heap of work transposing coordinates.

Cheers
Stormy.

some of the old maps are a bit messy with the fact they changed grid formats,the main aus reference for this is here,check this out when ya get a chance:

http://www.ga.gov.au/scientific-top...odesy/geodetic-techniques/calculation-methods