Excel spreadsheets to assist with data transformation, conversion and geodetic computations
Switch branches/tags
Nothing to show
Clone or download
SimonHine Update README.md
Grid Calculations added
Latest commit a602a11 Oct 11, 2018

README.md

Datum Spreadsheets

Excel spreadsheets to assist with :

  • transformation of spatial data between geodetic datums (e.g. GDA94 to GDA2020)
  • conversion of coordinate systems (e.g. Geographic (lat, lon) to Cartesian),
  • projection of data to a map grid
  • common geodetic computations (e.g. azimuths, distances)

Detailed information about these spreadsheets and the geodetic operations they support is contained in the Geocentric Datum of Australia 2020 Technical Manual www.icsm.gov.au. More general explanations of the concepts and terminology are available at the ICSM Fundamentals of mapping site www.icsm.gov.au/mapping/index.html

// Coordinate Transformations //

  • Transformation_Conversion.xlsx: 7-parameter similarity transformation and coordinate conversion between Cartesian and Geographic coordinate systems.

// Coordinate Conversions //

  • Krueger n-series.xlsx: Geographic to Grid and Grid to Geographic (recommended for working outside beyond a single MGA / UTM zone).
  • Krueger lambda series.xlsx: also known as Redfearn's equations. Accurate within a single MGA / UTM zone.
  • Transformation_Conversion.xlsx: 7-parameter similarity transformation and coordinate conversion between Cartesian and Geographic coordinate systems.

// Ellipsoid Computations //

  • Vincentys.xlsx: Direct and Indirect methods to calculate accurate geodetic positions, azimuths and distances on the ellipsoid.

// Grid Calculations //

  • GridCalc_GDA94_NSW.zip: contains GridCalc_GDA94_NSW.xlsm (macro enabled spreadsheet) and GridCalc_GDA94_NSW_UG.pdf (user guide).

    GridCalc_GDA94_NSW.xlsm provides output of various geodetic quantities between two points given input of the MGA94 co-ordinates, AHD values and MGA zone of two points within New South Wales.