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

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Coefficients for Calculating Latitude |  |  |  | Coefficients for Calculating Longitude
How to Use This Spreadsheet |  |  | North or South Latitude | [NAME] | Northing | Easting | Corrected Northing | East Prime | Arc Length | mu | Footprint Latitude (phi) | C1 | T1 | N1 | R1 | D | Fact1 | Fact2 | Fact3 | [NAME] | LoFact1 | LoFact2 | LoFact3 | Delta-Long | Zone CM | Raw Latitude | Latitude | Longitude | Latitude-Degrees | Latitude-Minutes | Latitude-Seconds | [NAME] | Longitude-Minutes | Longitude-Seconds
Datum | North American 1927 |  | N | 14 | 7020000 | 300000 | 7020000 | 200000 | 7022809.123649459 | 1.10293203918643 | 1.104978737750433 | 0.001374806563612812 | 3.956904575729423 | 6395507.768534124 | 6386727.253985339 | 0.03128446391656315 | 1.991931728602167 | 0.0004893588412733709 | 6.714446238366058e-07 | 1.458835477563654e-09 | 0.03128446391656315 | 4.549516147215861e-05 | 1.227687317165418e-07 | 0.06955104742104573 | -99 | 63.25469115403702 | 63.25469115403702 | -102.9849814779402 | 63 | 15 | 16.88815453326811 | -102 | 59 | 5.933320584600965
 | Symbol | Value | S | 45 | 4041000 | 310000 | 5959000 | 190000 | 4042617.046818727 | 0.6348929302496242 | 0.6373274237694884 | 0.004401778054791083 | 0.5481891320026208 | 6385863.407219906 | 6357877.441821446 | 0.02976512623136653 | 0.7436570226291476 | 0.0004429813697845918 | 2.167445002711407e-07 | 1.192395612575851e-10 | 0.02976512623136653 | 9.233205860768163e-06 | 5.375020658118965e-09 | 0.03702414809231933 | 87 | 36.49728757842309 | -36.49728757842309 | 84.87867257424277 | -36 | 29 | 50.23528232312684 | 84 | 52 | 43.22126727397393
Datum Constants |  |  | N | 15 | 1000000 | 320000 | 1000000 | 180000 | 1000400.160064026 | 0.157112826094933 | 0.1579022435457098 | 0.006646278579577582 | 0.02535349132902602 | 6378740.213829869 | 6336625.237248731 | 0.02823003019014742 | 0.1602860692697727 | 0.0003984673022683174 | 1.344573283899608e-07 | 4.469039861853451e-11 | 0.02823003019014742 | 3.96463204149654e-06 | 8.615522060201732e-10 | 0.02858164142476234 | -93 | 9.043471485333795 | 9.043471485333795 | -94.63760742519516 | 9 | 2 | 36.49734720166109 | -94 | 38 | 15.38673070256333
Polar Axis | b | 6356583.8 | S | 2 | 2000000 | 330000 | 8000000 | 170000 | 2000800.320128051 | 0.314225652189866 | 0.315726544285539 | 0.006157739418141045 | 0.1067023924134328 | 6380288.622240322 | 6341240.913109737 | 0.02665522475238245 | 0.3286647674821975 | 0.000355250503300011 | 1.119041257962871e-07 | 3.548490070258514e-11 | 0.02665522475238245 | 3.849460489837213e-06 | 9.310346219331933e-10 | 0.02803722742320672 | -171 | 18.08310660067326 | -18.08310660067326 | -172.6064148005982 | -18 | 4 | 59.18376242374052 | -172 | 36 | 23.09328215352715
[NAME] | a | 6378206.4 | N | 22 | 3000000 | 340000 | 3000000 | 160000 | 3001200.480192077 | 0.471338478284799 | 0.4734028375325228 | 0.005398258400224005 | 0.2624043609384108 | 6382698.01239324 | 6348427.559989314 | 0.02507780021856727 | 0.5150194761425219 | 0.0003144480319011864 | 9.524786885998119e-08 | 3.026487530890138e-11 | 0.02507780021856727 | 4.022233169838034e-06 | 1.16075711325091e-09 | 0.02817208819210139 | -51 | 27.11470291700021 | 27.11470291700021 | -52.61414175347775 | 27 | 6 | 52.93050120076342 | -52 | 36 | 50.91031251991134
ecc | e | 0.0822718542230039 | S | 43 | 4000000 | 350000 | 6000000 | 150000 | 4001600.640256102 | 0.628451304379732 | 0.630875947917809 | 0.004443745703568782 | 0.5335677152817777 | 6385729.998816892 | 6357478.978918792 | 0.02349927479511442 | 0.733703162090717 | 0.00027610795794815 | 8.365242092652473e-08 | 2.840227671082551e-11 | 0.02349927479511442 | 4.480367785240036e-06 | 1.601473061323886e-09 | 0.02909532130963753 | 75 | 36.13491864176631 | -36.13491864176631 | 73.33296088538073 | -36 | 8 | 5.707110358723078 | 73 | 19 | 58.65918737062321
e'2 | e1sq | 0.006814784945915193 | N | 32 | 5000000 | 360000 | 5000000 | 140000 | 5002000.800320128 | 0.785564130474665 | 0.7881109895174304 | 0.003388905237058193 | 1.010910447242516 | 6389085.705150353 | 6367506.82791423 | 0.0219211369000829 | 1.008847766832002 | 0.0002402681214960881 | 7.702212345119605e-08 | 3.040107050323267e-11 | 0.0219211369000829 | 5.311209972150788e-06 | 2.441523022808399e-09 | 0.03107808507027712 | 9 | 45.14154088262027 | 45.14154088262027 | 7.219356890124587 | 45 | 8 | 29.54717743296954 | 7 | 13 | 9.684804448512496
Scale | k0 | 0.9996 | S | 51 | 6000000 | 370000 | 4000000 | 130000 | 6002400.960384154 | 0.942676956569598 | 0.9450966286122915 | 0.00233749151570776 | 1.915426601602775 | 6392435.780219021 | 6377528.361782169 | 0.02034467381131319 | 1.387224442582597 | 0.0002069528762443664 | 7.643850852891801e-08 | 3.914462917107414e-11 | 0.02034467381131319 | 6.783203927754496e-06 | 4.261910435084599e-09 | 0.03472618336493433 | 123 | 54.13359292251766 | -54.13359292251766 | 121.0103362545918 | -54 | 8 | 0.9345210635910983 | 121 | 0 | 37.21051653065501
 |  |  | N | 23 | 7000000 | 380000 | 7000000 | 120000 | 7002801.120448179 | 1.099789782664531 | 1.101845950083896 | 0.00139198119978454 | 3.895744961907553 | 6395452.924381142 | 6386562.948825136 | 0.01877083931773285 | 1.976511603264873 | 0.0001761722043460727 | 8.607400101092226e-08 | 6.641983778047423e-11 | 0.01877083931773285 | 9.692394134323048e-06 | 9.28981428650652e-09 | 0.04151155407336349 | -45 | 63.11116210088428 | 63.11116210088428 | -47.37843684943283 | 63 | 6 | 40.18356318340407 | -47 | 22 | 42.37265795818994
Calculate Footprint Latitude |  |  | S | 27 | 8000000 | 390000 | 2000000 | 110000 | 8003201.280512204 | 1.256902608759464 | 1.25839493645605 | 0.0006437297099573127 | 9.586407370209926 | 6397843.641863756 | 6393727.809315519 | 0.01720017302188803 | 3.098185509806255 | 0.0001479229759914423 | 1.229152165638724e-07 | 1.818941741589956e-10 | 0.01720017302188803 | 1.710911538010809e-05 | 3.110059849093235e-08 | 0.05590822345335865 | -21 | 72.07443872382127 | -72.07443872382127 | -24.20330524395177 | -72 | 4 | 27.97940575658572 | -24 | 12 | 11.89887822638862
e1 | 0.001697915682976889 |  | N | 18 | 1000000 | 400000 | 1000000 | 100000 | 1000400.160064026 | 0.157112826094933 | 0.1579022435457098 | 0.006646278579577582 | 0.02535349132902602 | 6378740.213829869 | 6336625.237248731 | 0.01568335010563746 | 0.1602860692697727 | 0.0001229837352679992 | 1.28083874780865e-08 | 1.31395108471985e-12 | 0.01568335010563746 | 6.798065914774589e-07 | 4.559519456405767e-11 | 0.01588023119158795 | -75 | 9.046002565566113 | 9.046002565566113 | -75.90987022496999 | 9 | 2 | 45.60923603800575 | -75 | 54 | 35.53280989197325
C1 | 0.002546869394350326 |  | S | 52 | 2000000 | 410000 | 8000000 | 90000 | 2000800.320128051 | 0.314225652189866 | 0.315726544285539 | 0.006157739418141045 | 0.1067023924134328 | 6380288.622240322 | 6341240.913109737 | 0.01411158957479071 | 0.3286647674821975 | 9.956848016367092e-05 | 8.790639112911e-09 | 7.812771499185586e-13 | 0.01411158957479071 | 5.711900462225377e-07 | 3.871985938762365e-11 | 0.01484478059978682 | 129 | 18.08792331784931 | -18.08792331784931 | 128.1494567238345 | -18 | 5 | 16.52394425752705 | 128 | 8 | 58.04420580431725
C2 | 3.783815152380242e-06 |  | N | 37 | 3000000 | 420000 | 3000000 | 80000 | 3001200.480192077 | 0.471338478284799 | 0.4734028375325228 | 0.005398258400224005 | 0.2624043609384108 | 6382698.01239324 | 6348427.559989314 | 0.01253890010928364 | 0.5150194761425219 | 7.86120079752966e-05 | 5.952991803748824e-09 | 4.728886767015841e-13 | 0.01253890010928364 | 5.027791462297542e-07 | 3.627365978909094e-11 | 0.01408773820392839 | 39 | 27.12166470654813 | 27.12166470654813 | 38.19283205802969 | 27 | 7 | 17.99294357327198 | 38 | 11 | 34.19540890689864
[NAME] | 7.699350197089746e-09 |  | S | 28 | 3000000 | 430000 | 7000000 | 70000 | 3001200.480192077 | 0.471338478284799 | 0.4734028375325228 | 0.005398258400224005 | 0.2624043609384108 | 6382698.01239324 | 6348427.559989314 | 0.01097153759562318 | 0.5150194761425219 | 6.018731860608646e-05 | 3.489534502148665e-09 | 2.122302243242824e-13 | 0.01097153759562318 | 3.368227483531361e-07 | 1.860508423081213e-11 | 0.01232688676362642 | -15 | 27.12220846313268 | -27.12220846313268 | -15.70627858609147 | -27 | 7 | 19.95046727763309 | -15 | 42 | 22.6029099292977
C4 | 1.780742589097072e-11 |  | N | 19 | 4000000 | 440000 | 4000000 | 60000 | 4001600.640256102 | 0.628451304379732 | 0.630875947917809 | 0.004443745703568782 | 0.5335677152817777 | 6385729.998816892 | 6357478.978918792 | 0.009399709918045769 | 0.733703162090717 | 4.4177273271704e-05 | 2.141501975719033e-09 | 1.163357254075413e-13 | 0.009399709918045769 | 2.867435382553623e-07 | 1.639908414795659e-11 | 0.01163999200203432 | -69 | 36.14467199358293 | 36.14467199358293 | -69.6669224152826 | 36 | 8 | 40.81917689853015 | -69 | 40 | 0.9206950173564987
Constants for [NAME] |  |  | S | 16 | 5002000 | 450000 | 4998000 | 50000 | 5004001.600640256 | 0.7858783561268549 | 0.7884252093795776 | 0.003386763931581512 | 1.012181859611604 | 6389092.522549886 | 6367527.21105811 | 0.007828969110504961 | 1.009479822254115 | 3.064637866662042e-05 | 1.253681532821892e-09 | 6.316012300745255e-14 | 0.007828969110504961 | 2.421489389261975e-07 | 1.421013124555762e-11 | 0.01110515851767949 | -87 | 45.17166433280063 | -45.17166433280063 | -87.6362787138868 | -45 | 10 | 17.99159808227276 | -87 | 38 | 10.60336999246498
sin1" | sin1 | 0