Complex excel - calling formulae result and setting as value of aspecific cell

  • Thread starter Thread starter Michael Harris
  • Start date Start date
M

Michael Harris

To cut a long story short, I need to convert mapping coordinates in a
specific projection (the Australian Map Grid, or AMG) to a Lat/Long in
degrees/minutes/seconds using Redfearn's Formula.

There is already an excel worksheet out there which converts these on
a one-by-one basis, which is available from:
http://www.ga.gov.au/geodesy/datums/redfearn.xls

What I'd like to do is set the value of a cell based on the formula
output, eg:

=redfearn_lat(X,Y,Z)
=redfearn_long(X,Y,Z)

With X being the cell reference for the easting value, Y for the
northing value, and Z being the Zone.

Any help appreciated.
 
Hi Michael,

If you unhide the hidden rows in that worksheet, you'll see there are numerous constants and intermediate formulae used to do the
transformation, some of which refer back to the 'Constants & Parameters' worksheet. Thus, what you've got is not so much a formula
as a set of lookup tables. Unless you've got access to the underlying formula, all these factors would need to be coded into your
UDF.
 
Back
Top