Geodetic Calculator Spreadsheets

This is a suite of spreadsheets, which have been modified slightly from those available at the Geodetic Datum of Australia Technical Manual to perform calculations on the ACT Grid.

Please note the conditions of use attached to these spreadsheets  

Combined Scale and Height Factors

This spreadsheet has been developed from the NSW LPI’s product. As well as calculating elevation-dependent line scale factors for MGA, it has a tab for calculating them on the ACT Standard Grid.

Combined scale and height factors spreadsheet (37.0 KB)

Distance Reduction (ACT)

This is the same ICSM spreadsheet as found in the Geodetic Datum of Australia Technical Manual but with “ACT spheroid” details added, to enable one to perform calculations “on the surface” of that modified ellipsoid.

An additional tab has been added to enable one to “reconstruct” a slope distance that emulates a field-observed distance that has been corrected for ambient weather conditions. In effect, this is the reverse of the previous operation.

Distance reduction (ACT) spreadsheet (67.0 KB)

Rigorous Formulae between Ellipsoid and Grid

This spreadsheet allows for the computation, by Redfearn’s Formulae, of easting, northing, grid convergence and point scale factor from latitude and longitude, and the converse, viz. latitude, longitude, grid convergence and point scale factor from easting and northing.

It is identical to the ICSM spreadsheet, but with additional information to allow calculations between the ACT Standard Grid Co-ordinates (SGC) and AGD66.

Rigorous formulae between ellipsoid and grid spreadsheet (86.5 KB)

Formulae on the Grid

This spreadsheet essentially allows you to radiate via grid bearing and distance from a known mark to generate co-ordinates for another, or to calculate a join between them, with geodetic corrections and terrain differences accounted for.

Although based on that given in the GDA Technical manual, this spreadsheet has been optimised for the ACT situation (610 metres has been added to the ANS semi-major axis length). Detailed explanatory notes are given in the "Parameters and Notes" tab.

Formulae on the grid spreadsheet (36.3 KB)

Formulae on the Ellipsoid

This is the same as the ICSM spreadsheet, but with the ACT Ellipsoid’s parameters added (a=6,378770m, f=1/298.25: Note that 610 metres has been added to the ANS semi-major axis length) to enable calculation of latitude, longitude and reverse azimuth from a mark and given the azimuth and spheroidal distance. Conversely, given the latitude and longitude of two marks, it calculates the spheroidal distance and forward and reverse azimuths between them. The formulae are those of Vincenty.

Formulae on the ellipsoid spreadsheet (107.5 KB)

The ACT Government is committed to improving the accessibility of web content. To provide feedback or request an accessible version of a document please contact us or phone 13 22 81.