Convert Latitude and Longitude to UTM (Choose Decimal or DD MM SS)

Lat Dec
N/S - E/W
Decimal
DD
MM
SS
##
Latitude
N
27
26
38.38 ###
Longitude
E
86
34
24.27
Latitude
27.4439944444
27
26
38.38 N
##
Longitude
86.5734083333
86
34
24.27 E
###
Easting
Northing

457,836.19
3,036,340.95

Zone
Zone CM

45 R
87

Datum
1 WGS 84
2 NAD 83
3 GRS 80
4 WGS 72
5 Australian 1965
6 Krasovsky 1940
7 North American 1927
8 International 1924
9 Hayford 1909
10 Clarke 1880
11 Clarke 1866
12 Airy 1830
13 Bessel 1841
14 Everest 1830
How to Use This Spreadsheet

a
b
f
1/f
6,378,137.0 6356752.3142 0.0033528107 298.2572236
6,378,137.0 6356752.3142 0.0033528107 298.2572236
6,378,137.0
6,356,752.3 0.0033528107 298.2572215
6,378,135.0
6,356,750.5 0.0033527826 298.2597208
6,378,160.0
6,356,774.7 0.0033528949 298.2497323
6,378,245.0
6,356,863.0 0.0033523328 298.2997381
6,378,206.4
6,356,583.8 0.0033900753 294.9786982
6,378,388.0
6,356,911.9 0.0033670106 296.9993621
6,378,388.0
6,356,911.9 0.0033670106 296.9993621
6,378,249.1
6,356,514.9 0.0034075496 293.4660167
6,378,206.4
6,356,583.8 0.0033900753 294.9786982
6,377,563.4
6,356,256.9 0.0033408527 299.3247788
6,377,397.2
6,356,079.0 0.0033427744 299.1527052
6,377,276.3
6,356,075.4 0.0033244443 300.8021499

LatZones
-90
-84
-72
-64
-56
-48
-40
-32
-24
-16
-8
0
8
16
24
32
40
48
56
64
72
84

Letter
A
C
D
E
F
G
H
J
K
L
M
N
P
Q
R
S
T
U
V
W
X
Z

S Bdy

100K E
-90
-84
-72
-64
-56
-48
-40
-32
-24
-16
-8
0
8
16
24
32
40
48
56
64
72
84

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

Letter E
A
B
C
D
E
F
G
H
J
K
L
M
N
P
Q
R
S
T
U
V
W
X
Y
Z

100K E

100K N
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

Letter N
V
A
B
C
D
E
F
G
H
J
K
L
M
N
P
Q
R
S
T
U
V

100K N
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

Symbol
Datum Constants
equatorial radius a
polar radius
b
flattening
f
inverse flattening 1/f
Mean radius
rm

Value
6377276
6356075
0.003324
300.8021
6366667

scale factor
eccentricity

k0
0.9999
e
0.081473
e'2
0.006682
n
0.001665
r curv 1
rho
6348367
r curv 2
nu
6381777
Calculate Meridional Arc Length
Meridional Arc
S
3036572
A0
6366680
B0
15900.59
C0
16.54653
D0
0.021428
E0
0.000302
Calculation Constants
Delta Long
p (rad)
-0.007445
Coefficients for UTM Coordinates
Ki
3036269
Kii
1304989
Kiii
409214.4
Kiv
5663017
Kv
546784.7
A6
0

Degrees
Latitude
Longitude
Zone
Zone CM

Northing
Easting

Long Ltr0
Lat Ltr0

27
86
45
87

Minutes
Seconds
26
38.38
34
24.27

3,036,340.95
457,836.19

17 S
1 A

Digraph
Digraph

Decimal
Radians
27.443994 0.478988
86.573408 1.510991
1.518436
Delta-Long -0.426592

20 V
11 L

Symbol
Datum Constants
Polar Axis b
Equ Rad
a
ecc
e
e'2
e1sq
Scale
k0

Value
6356075.4
6377276.3
0.08147292
0.006682192
0.9999

Calculate Footprint Latitude

Arc Length
3,094,727.27
mu
0.48608178
e1
0.00166499
C1
0.002497481
C2
3.63849E-006
C3
7.26006E-009
C4
1.64658E-011
footprint lat
0.488148355
Constants for Formulas
sin1"
sin1
0
C1
0.005212425
T1
0.281973794
N1
6381936.851
R1
6348843.979
D
0.012020956
Coefficients for Calculating Latitude
Fact1
0.533779907
Fact2
7.22517E-005
Fact3
5.07918E-009
Fact4
3.76442E-013
Coefficients for Calculating Longitude
LoFact1
0.012020956
LoFact2
4.54290E-007
LoFact3
3.10553E-011

Northing
Easting
Zone CM

3,094,417.80
423,290.69 E'
87

Latitude
Longitude

Decimal
dd
27.96663065
86.22019718

Footprint Lat
Dec
dd
27.96884051

27

Delta-Long
D-Long-dec dd
0.779802817

27
86

mm
58

mm
46

76709.31

mm

ss
57 59.87035
13 12.70986

ss
7.8258232443

0.0136101267
ss
47.2901408798

Symbol
Datum Constants
Polar Axis b
Equ Rad a
ecc
e
e'2
e1sq
Scale
k0

Value
6356075.4
6377276.3
0.08147292
0.006682192
0.9999

Calculate Footprint Latitude

Arc Length
2,900,290.03
mu
0.455541964
e1
0.00166499
C1
0.002497481
C2
3.6385E-006
C3
7.2601E-009
C4
1.6466E-011
footprint latphi1
0.457518921
Constants for Formulas
C1
0.005378365
T1
0.242420781
N1
6381410.153
R1
6347272.209
D
-0.04411629
Coefficients for Calculating Latitude
Fact1
0.494888005
Fact2
0.000973124
Fact3
9.0290E-007
Fact4
8.7423E-010
Coefficients for Calculating Longitude
LoFact1
-0.04411629
LoFact2 -2.1325E-005
LoFact3 -1.8439E-008

Long Zone
Long Zone CM
Digraph Ltr E
Index E'ing
Zone Mod 3
Start E Index
Easting Add
Easting
E from ZC

10
-123
g
7
2
0
700000
781496
-281496

Lat Zone
S Lat Bdy
Dist S Bdy From Equator
Location Next Letter Zone
Digraph Ltr N
Index N
Start Letter Equator
Start Index Equator
Northing Add

s
32
3555555.5556
2000000
q
15
F
6
2900000

Correction S Lat
Northing
Lat from origin
Latitude
Long

2900000
2900000
26.1862847
26.1862847
-120.1839122

Lat Zone
Valid?
Digraph 1st char
Valid?
Digraph 2nd char
Valid?
Digraph Overall Valid?

S
1
G
1
Q

Delta-Long
D-Long-dec
dd
-2.8160877539

1
1

mm
-3

-0.04915
ss
11 2.084086

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

0.3 ### ###

0.3 ### ###
0.3 ### ###
0.3 ### ###
0.3 ### ###
0.3 ### ###
0.3 ### ###
0 ### ###
0 ### ###
0 ### ###
0 ### ###
0 ### ###
0 ### ###
0 ### ###
0 ### ###
0 ### ###

R1

N1

0.5
0.5
0.5
0.5
0.5
0.5
0.5
0
0
0
0
0
0
0
0
0

T1

0.5
0.5
0.5
0.5
0.5
0.5
0.5
0
0
0
0
0
0
0
0
0

C1

Footprint Latitude (phi)

Easting
457,766.17 ### ### ###
457,789.64 ### ### ###
457,762.10 ### ### ###
457,955.67 ### ### ###
457,953.35 ### ### ###
458,050.15 ### ### ###
457,609.95 ### ### ###
### ### 0
### ### 0
### ### 0
### ### 0
### ### 0
### ### 0
### ### 0
### ### 0
### ### 0

mu

Arc Length

14
45
45
2
22
43
32
51
23
27
18
52
37
28
19
16

East Prime

N
S
N
S
N
S
N
S
N
S
N
S
N
S
N
S

Northing
3,040,421.72
3,040,174.67
3,037,535.38
3,037,139.77
3,036,751.18
3,036,393.86
3,038,937.38

Corrected Northing

Longitude Zone

Calculate Footprint Latitude

e1
0.001665
C1
0.002497
C2
3.6E-006
C3
7.3E-009
C4
1.6E-011
Constants for Formulas
sin1"
sin1
0

North or South Latitude

How to Use This Spreadsheet

Datum
Everest 1830
Symbol
Value
Datum Constants
Polar Axis b
6356075
Equ Rad a
6377276
ecc
e
0.081473
e'2
e1sq
0.006682
Scale
k0
0.9999

0
0
0
0
0
0
0
0.1
0.1
0.1
0.1
0.1
0.1
0.1
0.1
0.1

27
27
27
27
27
27
27
0
0
0
0
0
0
0
0
0

Longitude-Seconds

Longitude-Minutes

28
28
27
27
26
26
28
0
0
0
0
0
0
0
0
0

Longitude-Degrees

27
-27
27
-27
27
-27
27
0
0
0
0
0
0
0
0
0

Latitude-Seconds

Longitude
-99.42744205
86.572804004
86.572617277
-171.4254105
-51.42542046
74.575571187
8.5710287282
118.51199544
-49.48800456
-25.48800456
-79.48800456
124.51199544
34.511995436
-19.48800456
-73.48800456
-91.48800456

Latitude-Minutes

0 ###
0 87
0 87
0 ##
0 ###
0 75
0 9
0.1 ###
0.1 ###
0.1 ###
0.1 ###
0.1 ###
0.1 39
0.1 ###
0.1 ###
0.1 ###

Raw Latitude

Zone CM

Delta-Long

LoFact3

LoFact2

0 ### ###
0 ### ###
0 ### ###
0 ### ###
0 ### ###
0 ### ###
0 ### ###
0.1 ### ###
0.1 ### ###
0.1 ### ###
0.1 ### ###
0.1 ### ###
0.1 ### ###
0.1 ### ###
0.1 ### ###
0.1 ### ###

Latitude
27.48083
-27.4786
27.45477
-27.45121
27.4477
-27.44448
27.46742
0
0
0
0
0
0
0
0
0

Latitude-Degrees

1 ### ### ###

1 ### ### ###
1 ### ### ###
1 ### ### ###
1 ### ### ###
1 ### ### ###
1 ### ### ###
0 0 ### ###
0 0 ### ###
0 0 ### ###
0 0 ### ###
0 0 ### ###
0 0 ### ###
0 0 ### ###
0 0 ### ###
0 0 ### ###

LoFact1

Fact4

Fact3

Fact2

Fact1

Coefficients fo Coefficients for Calculating Longitude

50.97184 -99 25 38.79137

42.94679 86 34 22.09441
17.1846 86 34 21.4222
4.351501 -171 25 31.47789
51.72469 -51 25 31.51365
40.12486 74 34 32.05627
2.72321
8 34 15.70342
0 118 30 43.18357
0 -49 29 16.81643
0 -25 29 16.81643
0 -79 29 16.81643
0 124 30 43.18357
0 34 30 43.18357
0 -19 29 16.81643
0 -73 29 16.81643
0 -91 29 16.81643

###
###
###
###
###
###
###
###
###
###
###
###
0
0

Kiv

Kiii

Kii

Ki

Coefficients for UTM Coordinates

Meridional Arc S

-2 ### ###
-2 ### ###
0 ### ###
1 ### ###
2 ### ###
3 ### ###
2 ### ###
1 ### ###
2 ### ###
-2 ### ###
0 ### ###
-1 ### ###
0.1 ### ###
0 ### ###

Calculate Meridional Arc Length

1
1
0.3
1
1
1
-1
-1
-1
-1
0
-1
0
0

r curv 2 = nu

0
0
0
0
0
0
0
0
0
0
0
0
0
0

r curv 1 = rho

Long Rad

11 ###
16 ###
27 ###
43 75
51 ###
55 ###
53 ###
36 33
54 ###
7 ##
27 ###
17 ###
31 3
31 3

Long Zone

Lat Rad

k0
0.9996
e
0.081473
e'2
0.006682
n
0.001665
Meridional Arc Constants
A0
6366680
B0
15900.59
C0
16.54653
D0
0.021428
E0
0.000302
Calculation Constants
Sin1"
4.8E-006

###
-88
-22
77
121
149
133
32
142
###
-20
-79
3
0

Delta Long (Rad)

Value
6377276
6356075
0.003324
300.8021
6366667

60
30
17
30
60
40
-38
-44
-77
-65
-10
-55
0
0

Long Zone CM

scale factor
eccentricity

Symbol
a
b
f
1/f
rm

Long DD.ddd

Datum Constants
equatorial radius
polar radius
flattening
inverse flattening
Mean radius

Lat DD.dddd

How to Use This Spreadsheet

Datum
Everest 1830

### ### ### ###

### ### ### ###
### ### ### ###
### ### ### ###
### ### ### ###
### ### ### ###
### ### ### ###
### ### ### ###
### ### ### ###
### ### ### ###
### ### ### ###
### ### ### ###
0 0 0 ###
0 0 0 ###

Northing
6656517
3319919
1880240
3321182
6654409
4430601
5791411
5126631
1451421
2789775
8894177
3902158
0
0

Easting
332681.1
403534.6
393534.9
692945.6
388439.9
670751.7
324369.5
419813.6
525113.7
452838.2
609618.8
627946.9
500000
165966.4

Long Zone

Raw Northing

A6

Kv

### 0 ###
### ### ###
### ### ###
### 0 ###
### ### ###
### ### ###
### ### ###
### ### ###
### ### ###
### ### ###
### ### ###
### ### ###
### 0 0
### 0 0

11
16
27
43
51
55
53
36
54
7
27
17
31
31