{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Dataset","UTM to Lat Long","Degree, Minute and Second"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Dataset","index":0,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,1,3,3],[3,4,3,5]]}
[]
[null,"Convert UTM to Lat Long in Excel"]
[]
[null,"UTM",null,null,"Lat & Long"]
[null,"UTM Easting","UTM Northing","UTM Zone","Latitude","Longitude"]
[null,209245.6,2664886.02,"46R"]
[null,357097.03,3866306.45,"13S"]
[null,324623.06,4308147.01,"18S"]
[null,794949,2594634.8199999998,"45Q"]
[null,574350.78,8475738.5800000001,"34L"]
[null,756243.03,6084931.4400000004,"19H"]
[null,701158.06,497135.07,"29N"]
[null,242419.62,9498828.4499999993,"18M"]
[null,691609.5,5334764.67,"32U"]
[null,673681.76,2726051.36,"38R"]
[null,585302.30000000005,27464684.41,"39Z"]

{"sheet":"UTM to Lat Long","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,4,3,5],[3,1,3,3],[1,1,1,5]]}
[]
[null,"Convert UTM to Lat Long in Excel"]
[]
[null,"UTM",null,null,"Lat & Long"]
[null,"UTM Easting","UTM Northing","UTM Zone","Latitude","Longitude"]
[null,209245.6,2664886.02,"46R",{"$f":"UTMToLatLong($B6, $C6, $D6)","v":24.069537997918903},90.140628074904399]
[null,357097.03,3866306.45,"13S",{"$f":"UTMToLatLong($B7, $C7, $D7)","v":34.929177036134597},-106.5646170377711]
[null,324623.06,4308147.01,"18S",{"$f":"UTMToLatLong($B8, $C8, $D8)","v":38.904713033559609},-77.022530998220745]
[null,794949,2594634.8199999998,"45Q",{"$f":"UTMToLatLong($B9, $C9, $D9)","v":23.435024995513817},89.886564936665678]
[null,574350.78,8475738.5800000001,"34L",{"$f":"UTMToLatLong($B10, $C10, $D10)","v":-13.78686697953956},21.687847977689373]
[null,756243.03,6084931.4400000004,"19H",{"$f":"UTMToLatLong($B11, $C11, $D11)","v":-35.346045020969314},-66.180363980728899]
[null,701158.06,497135.07,"29N",{"$f":"UTMToLatLong($B12, $C12, $D12)","v":4.4953870025787346},-7.1870030476319657]
[null,242419.62,9498828.4499999993,"18M",{"$f":"UTMToLatLong($B13, $C13, $D13)","v":-4.5304309953061255},-77.321384931601798]
[null,691609.5,5334764.67,"32U",{"$f":"UTMToLatLong($B14, $C14, $D14)","v":48.137259989618478},11.575579942525877]
[null,673681.76,2726051.36,"38R",{"$f":"UTMToLatLong($B15, $C15, $D15)","v":24.638919976299967},46.716009971287697]
[null,585302.30000000005,27464684.41,"39Z",{"$f":"UTMToLatLong($B16, $C16, $D16)","v":247.32303899128388},49.017016039693303]

{"sheet":"Degree, Minute and Second","index":2,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,1,3,3],[3,4,3,5],[3,6,3,7],[1,1,1,7]]}
[]
[null,"Convert UTM to Lat Long in Excel"]
[]
[null,"UTM",null,null,"Lat & Long",null,"Degree, Minute and Second"]
[null,"UTM Easting","UTM Northing","UTM Zone","Latitude","Longitude","Latitude","Longitude"]
[null,209245.6,2664886.02,"46R",{"$f":"UTMToLatLong($B6, $C6, $D6)","v":24.069537997918903},90.140628074904399,{"$f":"CONCATENATE(TEXT(INT(E6),\"0\"),\"° \", TEXT(INT(MOD(E6*60,60)),\"00\"),\"' \", TEXT(MOD(E6*3600,60),\"00.00\"), \"\"\"\")","v":"24° 04' 10.34\""},{"$f":"CONCATENATE(TEXT(INT(F6),\"0\"),\"° \", TEXT(INT(MOD(F6*60,60)),\"00\"),\"' \", TEXT(MOD(F6*3600,60),\"00.00\"), \"\"\"\")","v":"90° 08' 26.26\""}]
[null,357097.03,3866306.45,"13S",{"$f":"UTMToLatLong($B7, $C7, $D7)","v":34.929177036134597},-106.5646170377711,{"$f":"CONCATENATE(TEXT(INT(E7),\"0\"),\"° \", TEXT(INT(MOD(E7*60,60)),\"00\"),\"' \", TEXT(MOD(E7*3600,60),\"00.00\"), \"\"\"\")","v":"34° 55' 45.04\""},{"$f":"CONCATENATE(TEXT(INT(F7),\"0\"),\"° \", TEXT(INT(MOD(F7*60,60)),\"00\"),\"' \", TEXT(MOD(F7*3600,60),\"00.00\"), \"\"\"\")","v":"-107° 26' 07.38\""}]
[null,324623.06,4308147.01,"18S",{"$f":"UTMToLatLong($B8, $C8, $D8)","v":38.904713033559609},-77.022530998220745,"38° 54' 16.97\"","-78° 58' 38.89\""]
[null,794949,2594634.8199999998,"45Q",{"$f":"UTMToLatLong($B9, $C9, $D9)","v":23.435024995513817},89.886564936665678,"23° 26' 06.09\"","89° 53' 11.63\""]
[null,574350.78,8475738.5800000001,"34L",{"$f":"UTMToLatLong($B10, $C10, $D10)","v":-13.78686697953956},21.687847977689373,"-14° 12' 47.28\"","21° 41' 16.25\""]
[null,756243.03,6084931.4400000004,"19H",{"$f":"UTMToLatLong($B11, $C11, $D11)","v":-35.346045020969314},-66.180363980728899,"-36° 39' 14.24\"","-67° 49' 10.69\""]
[null,701158.06,497135.07,"29N",{"$f":"UTMToLatLong($B12, $C12, $D12)","v":4.4953870025787346},-7.1870030476319657,"4° 29' 43.39\"","-8° 48' 46.79\""]
[null,242419.62,9498828.4499999993,"18M",{"$f":"UTMToLatLong($B13, $C13, $D13)","v":-4.5304309953061255},-77.321384931601798,"-5° 28' 10.45\"","-78° 40' 43.01\""]
[null,691609.5,5334764.67,"32U",{"$f":"UTMToLatLong($B14, $C14, $D14)","v":48.137259989618478},11.575579942525877,"48° 08' 14.14\"","11° 34' 32.09\""]
[null,673681.76,2726051.36,"38R",{"$f":"UTMToLatLong($B15, $C15, $D15)","v":24.638919976299967},46.716009971287697,"24° 38' 20.11\"","46° 42' 57.64\""]
[null,585302.30000000005,27464684.41,"39Z",{"$f":"UTMToLatLong($B16, $C16, $D16)","v":247.32303899128388},49.017016039693303,"247° 19' 22.94\"","49° 01' 01.26\""]