Convert the Address to Latitude/Longitude
-
Use a geocoding service like:
-
Google Maps
-
OpenStreetMap
-
Example: "Paris, France" → Latitude: 48.8566, Longitude: 2.3522.
Formula for UTM Zone
INT((Longitude + 180)/6) + 1
-
Longitudeis the decimal degree value of the location. -
This gives you the zone number (1 to 60).
Example
|
Address |
Latitude |
Longitude |
UTM Zone |
|---|---|---|---|
|
Paris |
48.8566 |
2.3522 |
=INT((2.3522+180)/6)+1 → 31 |
|
New York |
40.7128 |
-74.0060 |
=INT((-74.0060+180)/6)+1 → 18 |
|
Sydney |
-33.8688 |
151.2093 |
=INT((151.2093+180)/6)+1 → 56 |
Find Hemisphere
IF(Latitude>=0,"N","S")
So Paris → 31N, Sydney → 56S.