## StatePlaneToLatLon()

StatePlaneToLatLon(Easting, Northing, State_Code)

Converts input U.S. State Plane (NAD83) coordinates to latitude and longitude.

Input:      Easting = State Plane easting coordinate , in meters (number)

Northing = State Plane northing coordinate, in meters (number)

State_Code = U.S. State Plane code. (see below) (number)

Output:  Latitude and longitude in decimal degrees (vector)

Notes:

- If unfamiliar with Excel vector functions, see Vector Functions reference

- This function is an adaptation of the National Geodetic Survey's SPCS83 coordinate conversion tool.  Accordingly, the list of State Codes follows convention in SPCS83, reproduced here:

State     Region                 State Code   |   State        Region              State Code

 AL E 101 MS E 2301 W 102 W 2302 AK 1 5001 MO E 2401 2 5002 C 2402 3 5003 W 2403 4 5004 5 5005 MT 2500 6 5006 7 5007 NE 2600 8 5008 9 5009 NV E 2701 10 5010 C 2702 W 2703 AZ E 201 C 202 NH 2800 W 203 NJ 2900 AR N 301 S 302 NM E 3001 C 3002 CA 1 401 W 3003 2 402 3 403 4 404 NY E 3101 5 405 C 3102 6 406 W 3103 L 3104 NC 3200 CO N 501 C 502 ND N 3301 S 503 S 3302 CT 600 OH N 3401 S 3402 DE 700 OK N 3501 FL E 901 S 3502 W 902 N 903 OR N 3601 S 3602 GA E 1001 W 1002 PA N 3701 S 3702 HI 1 5101 2 5102 RI 3800 3 5103 4 5104 SC 3900 5 5105 SD N 4001 ID E 1101 S 4002 C 1102 W 1103 TN 4100 IL E 1201 TX N 4201 W 1202 NC 4202 C 4203 IN E 1301 SC 4204 W 1302 S 4205 IA N 1401 UT N 4301 S 1402 C 4302 S 4303 KS N 1501 S 1502 VT 4400 KY 1Z 1600 VA N 4501 N 1601 S 4501 S 1602 WA N 4601 LA N 1701 S 4602 S 1702 SH 1703 WV N 4701 S 4702 ME E 1801 W 1802 WI N 4801 C 4802 MD 1900 S 4803 MA M 2001 WY E 4901 I 2002 EC 4902 WC 4903 MI N 2111 W 4904 C 2112 S 2113 VI PR 5200 MN N 2201 C 2202 AS 5300 S 2203 GU 5400