{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Lat Long to UTM","UTM Easting","UTM Northing","UTM Zone","Dataset","Formulas for UTM Zone","Excel VBA for UTM Zone"],"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":"Lat Long to UTM","index":0,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,3,3,5],[1,1,1,5]]}
[]
[null,"Convert Lat Long to UTM in Excel"]
[]
[null,"Lat & Long",null,"UTM"]
[null,"Latitude","Longitude","UTM Easting","UTM Northing","UTM Zone"]
[null,49.382373000000001,-100.642606,{"$f":"CalculateUTMEasting(B6,C6)","v":380780.51},{"$f":"CalculateUTMNorthing(B6,C6)","v":5471261.1600000001},{"$f":"CalculateUTMZone(B6,C6)","v":"14U"}]
[null,34.929177000000003,-106.564617,{"$f":"CalculateUTMEasting(B7,C7)","v":357097.03},{"$f":"CalculateUTMNorthing(B7,C7)","v":3866306.45},{"$f":"CalculateUTMZone(B7,C7)","v":"13S"}]
[null,38.904713000000001,-77.022531000000001,{"$f":"CalculateUTMEasting(B8,C8)","v":324623.06},{"$f":"CalculateUTMNorthing(B8,C8)","v":4308147.01},{"$f":"CalculateUTMZone(B8,C8)","v":"18S"}]
[null,23.435025,89.886565000000004,{"$f":"CalculateUTMEasting(B9,C9)","v":794949},{"$f":"CalculateUTMNorthing(B9,C9)","v":2594634.8199999998},{"$f":"CalculateUTMZone(B9,C9)","v":"45Q"}]
[null,-13.786867000000001,21.687847999999999,{"$f":"CalculateUTMEasting(B10,C10)","v":574350.78},{"$f":"CalculateUTMNorthing(B10,C10)","v":8475738.5800000001},{"$f":"CalculateUTMZone(B10,C10)","v":"34L"}]
[null,-35.346044999999997,-66.180363999999997,{"$f":"CalculateUTMEasting(B11,C11)","v":756243.03},{"$f":"CalculateUTMNorthing(B11,C11)","v":6084931.4400000004},{"$f":"CalculateUTMZone(B11,C11)","v":"19H"}]
[null,4.495387,-7.1870029999999998,{"$f":"CalculateUTMEasting(B12,C12)","v":701158.06},{"$f":"CalculateUTMNorthing(B12,C12)","v":497135.07},{"$f":"CalculateUTMZone(B12,C12)","v":"29N"}]
[null,-4.5304310000000001,-77.321385000000006,{"$f":"CalculateUTMEasting(B13,C13)","v":242419.62},{"$f":"CalculateUTMNorthing(B13,C13)","v":9498828.4499999993},{"$f":"CalculateUTMZone(B13,C13)","v":"18M"}]

{"sheet":"UTM Easting","index":1,"n_rows":13,"n_cols":18,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,1,3,2],[3,3,3,5],[1,13,1,17],[3,13,3,14],[3,15,3,17]]}
[]
[null,"Converting Lat Long to UTM Easting",null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Lat & Long",null,"UTM",null,null,null,null,null,null,null,null,null,"Lat & Long",null,"UTM"]
[null,"Latitude","Longitude","UTM Easting","UTM Northing","UTM Zone",null,null,null,null,null,null,null,"Latitude","Longitude","UTM Easting","UTM Northing","UTM Zone"]
[null,49.382373000000001,-100.642606,{"$f":"CalculateUTMEasting(B6,C6)","v":380780.51},{"$f":"CalculateUTMNorthing(B6,C6)","v":5471261.1600000001},{"$f":"CalculateUTMZone(B6,C6)","v":"14U"},null,null,null,null,null,null,null,49.382373000000001,-100.642606]
[null,34.929177000000003,-106.564617,{"$f":"CalculateUTMEasting(B7,C7)","v":357097.03},{"$f":"CalculateUTMNorthing(B7,C7)","v":3866306.45},{"$f":"CalculateUTMZone(B7,C7)","v":"13S"},null,null,null,null,null,null,null,34.929177000000003,-106.564617]
[null,38.904713000000001,-77.022531000000001,{"$f":"CalculateUTMEasting(B8,C8)","v":324623.06},{"$f":"CalculateUTMNorthing(B8,C8)","v":4308147.01},{"$f":"CalculateUTMZone(B8,C8)","v":"18S"},null,null,null,null,null,null,null,38.904713000000001,-77.022531000000001]
[null,23.435025,89.886565000000004,{"$f":"CalculateUTMEasting(B9,C9)","v":794949},{"$f":"CalculateUTMNorthing(B9,C9)","v":2594634.8199999998},{"$f":"CalculateUTMZone(B9,C9)","v":"45Q"},null,null,null,null,null,null,null,23.435025,89.886565000000004]
[null,-13.786867000000001,21.687847999999999,{"$f":"CalculateUTMEasting(B10,C10)","v":574350.78},{"$f":"CalculateUTMNorthing(B10,C10)","v":8475738.5800000001},{"$f":"CalculateUTMZone(B10,C10)","v":"34L"},null,null,null,null,null,null,null,-13.786867000000001,21.687847999999999]
[null,-35.346044999999997,-66.180363999999997,{"$f":"CalculateUTMEasting(B11,C11)","v":756243.03},{"$f":"CalculateUTMNorthing(B11,C11)","v":6084931.4400000004},{"$f":"CalculateUTMZone(B11,C11)","v":"19H"},null,null,null,null,null,null,null,-35.346044999999997,-66.180363999999997]
[null,4.495387,-7.1870029999999998,{"$f":"CalculateUTMEasting(B12,C12)","v":701158.06},{"$f":"CalculateUTMNorthing(B12,C12)","v":497135.07},{"$f":"CalculateUTMZone(B12,C12)","v":"29N"},null,null,null,null,null,null,null,4.495387,-7.1870029999999998]
[null,-4.5304310000000001,-77.321385000000006,{"$f":"CalculateUTMEasting(B13,C13)","v":242419.62},{"$f":"CalculateUTMNorthing(B13,C13)","v":9498828.4499999993},{"$f":"CalculateUTMZone(B13,C13)","v":"18M"},null,null,null,null,null,null,null,-4.5304310000000001,-77.321385000000006]

{"sheet":"UTM Northing","index":2,"n_rows":13,"n_cols":18,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,1,3,2],[3,3,3,5],[1,13,1,17],[3,13,3,14],[3,15,3,17]]}
[]
[null,"Converting Lat Long to UTM Northing",null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Lat & Long",null,"UTM",null,null,null,null,null,null,null,null,null,"Lat & Long",null,"UTM"]
[null,"Latitude","Longitude","UTM Easting","UTM Northing","UTM Zone",null,null,null,null,null,null,null,"Latitude","Longitude","UTM Easting","UTM Northing","UTM Zone"]
[null,49.382373000000001,-100.642606,{"$f":"CalculateUTMEasting(B6,C6)","v":380780.51},{"$f":"CalculateUTMNorthing(B6,C6)","v":5471261.1600000001},{"$f":"CalculateUTMZone(B6,C6)","v":"14U"},null,null,null,null,null,null,null,49.382373000000001,-100.642606]
[null,34.929177000000003,-106.564617,{"$f":"CalculateUTMEasting(B7,C7)","v":357097.03},{"$f":"CalculateUTMNorthing(B7,C7)","v":3866306.45},{"$f":"CalculateUTMZone(B7,C7)","v":"13S"},null,null,null,null,null,null,null,34.929177000000003,-106.564617]
[null,38.904713000000001,-77.022531000000001,{"$f":"CalculateUTMEasting(B8,C8)","v":324623.06},{"$f":"CalculateUTMNorthing(B8,C8)","v":4308147.01},{"$f":"CalculateUTMZone(B8,C8)","v":"18S"},null,null,null,null,null,null,null,38.904713000000001,-77.022531000000001]
[null,23.435025,89.886565000000004,{"$f":"CalculateUTMEasting(B9,C9)","v":794949},{"$f":"CalculateUTMNorthing(B9,C9)","v":2594634.8199999998},{"$f":"CalculateUTMZone(B9,C9)","v":"45Q"},null,null,null,null,null,null,null,23.435025,89.886565000000004]
[null,-13.786867000000001,21.687847999999999,{"$f":"CalculateUTMEasting(B10,C10)","v":574350.78},{"$f":"CalculateUTMNorthing(B10,C10)","v":8475738.5800000001},{"$f":"CalculateUTMZone(B10,C10)","v":"34L"},null,null,null,null,null,null,null,-13.786867000000001,21.687847999999999]
[null,-35.346044999999997,-66.180363999999997,{"$f":"CalculateUTMEasting(B11,C11)","v":756243.03},{"$f":"CalculateUTMNorthing(B11,C11)","v":6084931.4400000004},{"$f":"CalculateUTMZone(B11,C11)","v":"19H"},null,null,null,null,null,null,null,-35.346044999999997,-66.180363999999997]
[null,4.495387,-7.1870029999999998,{"$f":"CalculateUTMEasting(B12,C12)","v":701158.06},{"$f":"CalculateUTMNorthing(B12,C12)","v":497135.07},{"$f":"CalculateUTMZone(B12,C12)","v":"29N"},null,null,null,null,null,null,null,4.495387,-7.1870029999999998]
[null,-4.5304310000000001,-77.321385000000006,{"$f":"CalculateUTMEasting(B13,C13)","v":242419.62},{"$f":"CalculateUTMNorthing(B13,C13)","v":9498828.4499999993},{"$f":"CalculateUTMZone(B13,C13)","v":"18M"},null,null,null,null,null,null,null,-4.5304310000000001,-77.321385000000006]

{"sheet":"UTM Zone","index":3,"n_rows":13,"n_cols":18,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,1,3,2],[3,3,3,5],[1,13,1,17],[3,13,3,14],[3,15,3,17]]}
[]
[null,"Converting Lat Long to UTM Zone",null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Lat & Long",null,"UTM",null,null,null,null,null,null,null,null,null,"Lat & Long",null,"UTM"]
[null,"Latitude","Longitude","UTM Easting","UTM Northing","UTM Zone",null,null,null,null,null,null,null,"Latitude","Longitude","UTM Easting","UTM Northing","UTM Zone"]
[null,49.382373000000001,-100.642606,{"$f":"CalculateUTMEasting(B6,C6)","v":380780.51},{"$f":"CalculateUTMNorthing(B6,C6)","v":5471261.1600000001},{"$f":"CalculateUTMZone(B6,C6)","v":"14U"},null,null,null,null,null,null,null,49.382373000000001,-100.642606]
[null,34.929177000000003,-106.564617,{"$f":"CalculateUTMEasting(B7,C7)","v":357097.03},{"$f":"CalculateUTMNorthing(B7,C7)","v":3866306.45},{"$f":"CalculateUTMZone(B7,C7)","v":"13S"},null,null,null,null,null,null,null,34.929177000000003,-106.564617]
[null,38.904713000000001,-77.022531000000001,{"$f":"CalculateUTMEasting(B8,C8)","v":324623.06},{"$f":"CalculateUTMNorthing(B8,C8)","v":4308147.01},{"$f":"CalculateUTMZone(B8,C8)","v":"18S"},null,null,null,null,null,null,null,38.904713000000001,-77.022531000000001]
[null,23.435025,89.886565000000004,{"$f":"CalculateUTMEasting(B9,C9)","v":794949},{"$f":"CalculateUTMNorthing(B9,C9)","v":2594634.8199999998},{"$f":"CalculateUTMZone(B9,C9)","v":"45Q"},null,null,null,null,null,null,null,23.435025,89.886565000000004]
[null,-13.786867000000001,21.687847999999999,{"$f":"CalculateUTMEasting(B10,C10)","v":574350.78},{"$f":"CalculateUTMNorthing(B10,C10)","v":8475738.5800000001},{"$f":"CalculateUTMZone(B10,C10)","v":"34L"},null,null,null,null,null,null,null,-13.786867000000001,21.687847999999999]
[null,-35.346044999999997,-66.180363999999997,{"$f":"CalculateUTMEasting(B11,C11)","v":756243.03},{"$f":"CalculateUTMNorthing(B11,C11)","v":6084931.4400000004},{"$f":"CalculateUTMZone(B11,C11)","v":"19H"},null,null,null,null,null,null,null,-35.346044999999997,-66.180363999999997]
[null,4.495387,-7.1870029999999998,{"$f":"CalculateUTMEasting(B12,C12)","v":701158.06},{"$f":"CalculateUTMNorthing(B12,C12)","v":497135.07},{"$f":"CalculateUTMZone(B12,C12)","v":"29N"},null,null,null,null,null,null,null,4.495387,-7.1870029999999998]
[null,-4.5304310000000001,-77.321385000000006,{"$f":"CalculateUTMEasting(B13,C13)","v":242419.62},{"$f":"CalculateUTMNorthing(B13,C13)","v":9498828.4499999993},{"$f":"CalculateUTMZone(B13,C13)","v":"18M"},null,null,null,null,null,null,null,-4.5304310000000001,-77.321385000000006]

{"sheet":"Dataset","index":4,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset"]
[]
[null,"Lat","Long","UTM"]
[null,39.5580146683984,-105.825836887357]
[null,39.912851756277803,-116.592437752599]
[null,46.852033076157902,-118.893392948875]
[null,32.303453356704097,-98.021062243530096]
[null,36.078838682116903,-114.08297298162699]
[null,-28.016567999999999,23.993333]

{"sheet":"Formulas for UTM Zone","index":5,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,13,1,15]]}
[]
[null,"Combination of IF, CONCATENATE and INT Functions",null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Lat","Long","UTM",null,null,null,null,null,null,null,null,null,"Lat","Long","UTM"]
[null,39.5580146683984,-105.825836887357,{"$f":"IF(B5>=0,CONCATENATE(INT(31+C5/6),\" N\"),\nCONCATENATE(INT(31+C5/6),\" S\"))","v":"13 N"},null,null,null,null,null,null,null,null,null,39.5580146683984,-105.825836887357]
[null,39.912851756277803,-116.592437752599,{"$f":"IF(B6>=0,CONCATENATE(INT(31+C6/6),\" N\"),\nCONCATENATE(INT(31+C6/6),\" S\"))","v":"11 N"},null,null,null,null,null,null,null,null,null,39.912851756277803,-116.592437752599]
[null,46.852033076157902,-118.893392948875,"11 N",null,null,null,null,null,null,null,null,null,46.852033076157902,-118.893392948875]
[null,32.303453356704097,-98.021062243530096,"14 N",null,null,null,null,null,null,null,null,null,32.303453356704097,-98.021062243530096]
[null,36.078838682116903,-114.08297298162699,"11 N",null,null,null,null,null,null,null,null,null,36.078838682116903,-114.08297298162699]
[null,-28.016567999999999,23.993333,"34 S",null,null,null,null,null,null,null,null,null,27.860613424667498,-81.306891170890495]

{"sheet":"Excel VBA for UTM Zone","index":6,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,13,1,15]]}
[]
[null,"Use of Excel VBA",null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Lat","Long","UTM",null,null,null,null,null,null,null,null,null,"Lat","Long","UTM"]
[null,39.5580146683984,-105.825836887357,"13 N",null,null,null,null,null,null,null,null,null,39.5580146683984,-105.825836887357]
[null,39.912851756277803,-116.592437752599,"12 N",null,null,null,null,null,null,null,null,null,39.912851756277803,-116.592437752599]
[null,46.852033076157902,-118.893392948875,"11 N",null,null,null,null,null,null,null,null,null,46.852033076157902,-118.893392948875]
[null,32.303453356704097,-98.021062243530096,"15 N",null,null,null,null,null,null,null,null,null,32.303453356704097,-98.021062243530096]
[null,36.078838682116903,-114.08297298162699,"12 N",null,null,null,null,null,null,null,null,null,36.078838682116903,-114.08297298162699]
[null,-28.016567999999999,23.993333,"35 S",null,null,null,null,null,null,null,null,null,27.860613424667498,-81.306891170890495]