Formula For State Plane to Lat/Lon Conversion

50988
22
08-07-2014 10:20 AM
Labels (1)
GeorgePorto
New Contributor II

Does anyone know where I can find the equation to put into Excel that will convert CT State Plane coordinates to Lat/Lon?  I know ways to programmatically do this using ArcGIS but have a scenario/workflow where we may need to do this from within Excel.  Thanks!

22 Replies
SeanO_Halloran
New Contributor

I'm using a state plane zone that does not have values for Standard Parallel 1 & 2.  Do you use a value of 0 in these cases for the functions for calculating latitude and longitude?

0 Kudos
MelitaKennedy
Esri Notable Contributor

Hi Sean, 

The posted code is for Lambert conformal conic. It sounds like your zone (which one?) is using either transverse Mercator or Hotine oblique Mercator. Either of those projections would need to be implemented.

Melita

0 Kudos
SeanO_Halloran
New Contributor

Thanks Melita.  I'm looking at Idaho East NAD 83 US foot zone 1100 which is Transverse Mercator.

0 Kudos