Convert XYZ to Lat Long

[nando88]

I want to convert XYZ to Lat Long and viceversa, but I don't know how.
I have found many spreadsheets on the internet, but none of the ones I've tried seem to work correctly.
Can someone please share with with me a spreadsheet that can do this the right way?
Thanks in advance.

 

[DRSteele]

Just what is XYZ? Could you please clarify what you're after?

I gather you wish to convert a decimal numeral to Hours/Minutes/Seconds and vv. If that is so, this ought to suffice:

	A	B	C	D	E	F	G	H	I
Calgary
Calgary

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #FFF2CC"]locale[/TD]
[TD="bgcolor: #FFF2CC"]hours[/TD]
[TD="bgcolor: #FFF2CC"]minutes[/TD]
[TD="bgcolor: #FFF2CC"]seconds[/TD]
[TD="bgcolor: #FFF2CC"]Latitude[/TD]
[TD="bgcolor: #FFF2CC"]h[/TD]
[TD="bgcolor: #FFF2CC"]m[/TD]
[TD="bgcolor: #FFF2CC"]s[/TD]
[TD="bgcolor: #FFF2CC"]Longitude[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]51[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]46[/TD]
[TD="bgcolor: #E2EFDA, align: right"]51.04611[/TD]
[TD="align: right"]114[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]24[/TD]
[TD="bgcolor: #E2EFDA, align: right"]114.05667[/TD]

[TD="align: center"]3[/TD]

[TD="bgcolor: #C6E0B4, align: right"]51.00000[/TD]
[TD="bgcolor: #C6E0B4, align: right"]2.00000[/TD]
[TD="bgcolor: #C6E0B4, align: right"]46[/TD]
[TD="align: right"]51.04611[/TD]
[TD="bgcolor: #C6E0B4, align: right"]114.0000[/TD]
[TD="bgcolor: #C6E0B4, align: right"]3.0000[/TD]
[TD="bgcolor: #C6E0B4, align: right"]24.0000[/TD]
[TD="align: right"]114.05667[/TD]

</tbody>

Sheet25​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10, bgcolor: #DAE7F5"]E2[/TH]
[TD="align: left"]=B2+C2/60+D2/3600[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #DAE7F5"]I2[/TH]
[TD="align: left"]=F2+G2/60+H2/3600[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #DAE7F5"]B3[/TH]
[TD="align: left"]=INT(E3)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #DAE7F5"]C3[/TH]
[TD="align: left"]=INT((E3-INT(E3))*60)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #DAE7F5"]D3[/TH]
[TD="align: left"]=((E3-INT(E3))*60-INT((E3-INT(E3))*60))*60[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #DAE7F5"]F3[/TH]
[TD="align: left"]=INT(I3)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #DAE7F5"]G3[/TH]
[TD="align: left"]=INT((I3-INT(I3))*60)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #DAE7F5"]H3[/TH]
[TD="align: left"]=((I3-INT(I3))*60-INT((I3-INT(I3))*60))*60[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[nando88]

Sorry for not explaining myself correctly.
I wish to convert UTM coordinates to Latitude and longitude in excel.
Can you please give me the formulas as you did above, so I can do this?
Thanks in advance.

 

[nando88]

If you could also show me a way of how to convert latitude and longitude to UTM, I would really appreciate it.

 

[mikerickson]

The formulas for converting between UTM and latitude and longitude can be found in Wikipedia.
https://en.wikipedia.org/wiki/Universal_Transverse_Mercator_coordinate_system#Simplified_formulas

How you would implement them in Excel depends on how your spreadsheet is set up.

 

[DRSteele]

Read through this and we'll see if it helps us along.
https://www.uwgb.edu/dutchs/UsefulData/UTMFormulas.HTM

 

[nando88]

Can someone please share with me a spreadsheet that I can use to make these conversions the right way?
I tried making my own, but had no luck.
Thanks.