Spreadsheet: 120369d1315242768-latitude-and-longitude-to-eastings-and-northings-utmconversions1
Sheet: Batch Convert Lat Long To UTM

How to Use This Spreadsheet |  |  | Latitude Degrees | Latitude Minutes | Latitude Seconds | [NAME] | [NAME] | [NAME] | Latitude Converted to DD.dddd | [NAME] to DD.dddd | Lat DD.dddd | Long DD.ddd | Long Zone | Long Zone CM | Delta Long ([NAME]) | Lat Rad | Long Rad | r curv 1 = rho | r curv 2 = nu | Calculate Meridional Arc Length | [NAME] | Coefficients for UTM Coordinates | Ki | Kii | Kiii | Kiv | Kv | A6 | Raw Northing | Northing | Easting | Long Zone
Datum | North American 1927 |  | -79 | 60 |  | -179 | 60 |  | -80 | -180 | 60 | -120 | 11 | -117 | -0.05235987755982988 | 1.047197551196598 | -2.094395102393195 | 6383582.07809315 | 6394457.762854851 |  | 6653866.243762914 |  | 6651204.697265409 | 1384440.716514728 | 58104.3636370265 | 3195949.989874856 | -266102.2938241659 | -0.0005209495321500608 | 6655000.656815778 | 6655000.656815778 | 332698.6481823851 | 11
 |  |  |  |  |  |  |  |  | 0 | 0 | 30 | -88 | 16 | -87 | -0.0174532925199433 | 0.5235987755982988 | -1.53588974175501 | 6351148.462501223 | 6383609.745699868 |  | 3319933.369707737 |  | 3318605.396359854 | 1382092.051905501 | 406929.8681336282 | 5526156.860338957 | 464043.656436845 | 2.599032431894604e-06 | 3319026.443434357 | 3319026.443434357 | 403547.9006816125 | 16
Datum Constants | Symbol | Value |  |  |  |  |  |  | 0 | 0 | 17 | -22 | 27 | -21 | -0.0174532925199433 | 0.296705972839036 | -0.3839724354387525 | 6340536.592274768 | 6380052.394207788 |  | 1880193.0991411 |  | 1879441.021901444 | 891920.0056531357 | 337200.3891517335 | 6098833.938095109 | 848487.1400510628 | 3.341695806143525e-06 | 1879712.747561644 | 1879712.747561644 | 393550.7562007105 | 27
equatorial radius | a | 6378206.4 |  |  |  |  |  |  | 0 | 0 | 30 | 77 | 43 | 75 | 0.03490658503988659 | 0.5235987755982988 | 1.343903524035634 | 6351148.462501223 | 6383609.745699868 |  | 3319933.369707737 |  | 3318605.396359854 | 1382092.051905501 | 406929.8681336282 | 5526156.860338957 | 464043.656436845 | 0.0001663380756412546 | 3320290.03777479 | 3320290.03777479 | 692919.0013795767 | 43
polar radius | b | 6356583.8 |  |  |  |  |  |  | 0 | 0 | 60 | 121 | 51 | 123 | -0.03490658503988659 | 1.047197551196598 | 2.111848394913139 | 6383582.07809315 | 6394457.762854851 |  | 6653866.243762914 |  | 6651204.697265409 | 1384440.716514728 | 58104.3636370265 | 3195949.989874856 | -266102.2938241659 | -4.573493835062263e-05 | 6652891.682566768 | 6652891.682566768 | 388451.6179217485 | 51
flattening | f | 0.003390075303928791 |  |  |  |  |  |  | 0 | 0 | 40 | 149 | 55 | 147 | 0.03490658503988659 | 0.6981317007977318 | 2.600540585471551 | 6361702.985872617 | 6387143.944836133 |  | 4429318.9883205 |  | 4427547.260725171 | 1572527.2191199 | 332993.9135945018 | 4890878.991892211 | 143461.6543314412 | 5.660270990872891e-05 | 4429463.83184683 | 4429463.83184683 | 670729.9852496592 | 55
inverse flattening | 1/f | 294.9786982138982 |  |  |  |  |  |  | 0 | 0 | -38 | 133 | 53 | 135 | -0.03490658503988659 | -0.6632251157578452 | 2.321287905152458 | 6359492.532924268 | 6386404.09489734 |  | -4207292.339632639 |  | -4205609.422696786 | -1549175.149887603 | -354807.5783463367 | 5030542.081615646 | 205036.1970663087 | -7.87911286217539e-05 | -4207497.572416198 | 5792502.427583802 | 324392.2343056273 | 53
Mean radius | rm | 6367385.921655473 |  |  |  |  |  |  | 0 | 0 | -44 | 32 | 36 | 33 | -0.0174532925199433 | -0.767944870877505 | 0.5585053606381855 | 6366199.107502896 | 6388648.291153869 |  | -4873606.171681108 |  | -4871656.729212436 | -1596189.124807599 | -282033.0450782397 | 4593770.742598012 | 28117.08054896621 | -2.5655379443303e-07 | -4872142.982395472 | 5127857.017604528 | 419823.4259732579 | 36
 |  |  |  |  |  |  |  |  | 0 | 0 | -77 | 142 | 54 | 141 | 0.0174532925199433 | -1.343903524035634 | 2.478367537831948 | 6396593.483757877 | 6398799.338817281 |  | -8550048.292960586 |  | -8546628.273643402 | -701262.2510576302 | 40670.08828463106 | 1438840.891138652 | -215532.753040275 | 9.544420776743371e-08 | -8546841.886567064 | 1453158.113432936 | 525111.3650662354 | 54
scale factor | k0 | 0.9996 |  |  |  |  |  |  | 0 | 0 | -65 | -142 | 7 | -141 | -0.0174532925199433 | -1.134464013796314 | -2.478367537831948 | 6388235.718870515 | 6396011.241809046 |  | -7211146.012366856 |  | -7208261.55396191 | -1224907.217478583 | -7509.224980451369 | 2701989.924626077 | -289369.7086404263 | 5.707463237565161e-07 | -7208634.682734771 | 2791365.317265229 | 452842.91791588 | 7
eccentricity | e | 0.0822718542230039 |  |  |  |  |  |  | 0 | 0 | -10 | -20 | 27 | -21 | 0.0174532925199433 | -0.1745329251994329 | -0.3490658503988659 | 6336974.468097471 | 6378857.395655228 |  | -1105785.442693501 |  | -1105343.128516424 | -545424.4301790007 | -221578.0631862311 | 6279435.43931309 | 990165.053773729 | -2.452721068734637e-06 | -1105509.294859655 | 8894490.705140345 | 609602.087871116 | 27
 | e'2 | 0.006814784945915193 |  |  |  |  |  |  | 0 | 0 | -55 | -79 | 17 | -81 | 0.03490658503988659 | -0.9599310885968813 | -1.37881010907552 | 6378439.881680457 | 6392740.315900147 |  | -6097014.998997692 |  | -6094576.192998094 | -1501802.725362987 | -122671.2885493828 | 3665258.518828103 | -208481.4618889125 | 4.412334234527158e-05 | -6096406.276209189 | 3903593.723790811 | 627932.79091879 | 17
 | n | 0.001697915682976902 |  |  |  |  |  |  | 0 | 0 | 0 | 3 | 31 | 3 | 0 | 0 | 0.05235987755982988 | 6335034.502242266 | 6378206.4 |  | 0 |  | 0 | 0 | 0 | 6375655.117440001 | 1069850.63932578 | 0 | 0 | 0 | 500000 | 31
[NAME] |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 31 | 3 | -0.05235987755982988 | 0 | 0 | 6335034.502242266 | 6378206.4 |  | 0 |  | 0 | 0 | 0 | 6375655.117440001 | 1069850.63932578 | 0 | 0 | 0 | 166017.9042198724 | 31
A0 | 6367399.689169782
B0 | 16216.86233998753
C0 | 17.20937118099185
D0 | 0.02272671026573846
E0 | 0.0003268627299192521
Calculation Constants
Sin1" | 4.84813681109536e-06