WSG 84 ---> UTM conversion

[Fanatic GPS User]

I am working on a Excel spreadsheet were I need to convert WGS84 to UTM. I have seen it somewhere but lost it, the only thing I do remember it wasn't an easy conversion if I can recall correctly.

I know there are many web sites who offer the conversion between different geodetic datum but that's not what I need it should be imbedded in the spreadsheet.

Does anyone knows/has the formulae, if possible with a sample ?

 

[Burnie M]

Are you sure ?

WGS84 ia a datum and UTM is a projection/grid format

 

[Stichting ST]

I am working on a Excel spreadsheet were I need to convert WGS84 to UTM. I have seen it somewhere but lost it, the only thing I do remember it wasn't an easy conversion if I can recall correctly.

I know there are many web sites who offer the conversion between different geodetic datum but that's not what I need it should be imbedded in the spreadsheet.

Does anyone knows/has the formulae, if possible with a sample ?

This the link with source you want maybe:
http://www.gpsy.com/gpsinfo/geotoutm/

"Subject: Lat/Long to UTM
Karen -
I've a spreadsheet that does this - 1-2-3 for Windows, Excel will probably accept the file."....

Piet

 

[Fanatic GPS User]

This the link with source you want maybe:
http://www.gpsy.com/gpsinfo/geotoutm/

"Subject: Lat/Long to UTM
Karen -
I've a spreadsheet that does this - 1-2-3 for Windows, Excel will probably accept the file."....

Piet,

This is what I've been looking for, thanks a million.

 

[Sam Wormley]

I am working on a Excel spreadsheet were I need to convert WGS84 to UTM. I have seen it somewhere but lost it, the only thing I do remember it wasn't an easy conversion if I can recall correctly.

I know there are many web sites who offer the conversion between different geodetic datum but that's not what I need it should be imbedded in the spreadsheet.

Does anyone knows/has the formulae, if possible with a sample ?

http://www.ngs.noaa.gov/TOOLS/
http://www.ngs.noaa.gov/PC_PROD/pc_prod.shtml http://www.ngs.noaa.gov/TOOLS/program_descriptions.html#UTM

 

[Dave Patton]

WGS84 ia a datum and UTM is a projection/grid format

Actually, WGS84 isn't just a datum ;-)

WGS 84 stands for World Geodetic System 1984.
From the NIMA TECHNICAL REPORT 8350.2:
"The global geocentric reference frame and collection of models known as the World Geodetic System 1984 (WGS 84) has evolved significantly since its creation in the mid-1980s. The WGS 84 continues to provide a single, common, accessible 3-dimensional coordinate system for geospatial data collected from a broad spectrum of sources."

The term 'WGS 84' is ued as the name of the Horizontal Datum, the Verticam Datum, the Reference Frame, the Earth Gravitational Model, and the Geoid.