{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Formula","VBA"],"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":"Formula","index":0,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Convert Easting Northing to Latitude Longitude"]
[]
[null,"Easting (m)","Northing (m)","Latitude (Decimal)","Longitude (Decimal)","Latitude (Degree, Minute & Second)","Longitude (Degree, Minute & Second)"]
[null,298365.56783000001,9675278.7674000002,{"$f":"ATANH(SIN(C5/6378137)/(COS(B5/6378137))) * (180/PI())","v":247.32489768132018},{"$f":"ATAN2(SIN(B5/6378137), COS(C5/6378137)) * (180/PI())","v":49.016883074449055},{"$f":"CONCATENATE(TEXT(INT(E5),\"0\"),\"° \", TEXT(INT(MOD(E5*60,60)),\"00\"),\"' \", TEXT(MOD(E5*3600,60),\"00.00\"), \"\"\"\")","v":"49° 01' 00.78\""},{"$f":"CONCATENATE(TEXT(INT(D5),\"0\"),\"° \", TEXT(INT(MOD(D5*60,60)),\"00\"),\"' \", TEXT(MOD(D5*3600,60),\"00.00\"), \"\"\"\")","v":"247° 19' 29.63\""}]
[null,298364.36783,9675277.5673999991,{"$f":"ATANH(SIN(C6/6378137)/(COS(B6/6378137))) * (180/PI())","v":247.323373541899},{"$f":"ATAN2(SIN(B6/6378137), COS(C6/6378137)) * (180/PI())","v":49.01709608871338},{"$f":"CONCATENATE(TEXT(INT(E6),\"0\"),\"° \", TEXT(INT(MOD(E6*60,60)),\"00\"),\"' \", TEXT(MOD(E6*3600,60),\"00.00\"), \"\"\"\")","v":"49° 01' 01.55\""},{"$f":"CONCATENATE(TEXT(INT(D6),\"0\"),\"° \", TEXT(INT(MOD(D6*60,60)),\"00\"),\"' \", TEXT(MOD(D6*3600,60),\"00.00\"), \"\"\"\")","v":"247° 19' 24.14\""}]
[null,298363.16782999999,9675279.3673999999,247.32388869754175,49.017061581278966,"49° 01' 01.42\"","247° 19' 26.00\""]
[null,298364.24783000001,9675278.2674000002,247.32377852986215,49.017049734201009,"49° 01' 01.38\"","247° 19' 25.60\""]
[null,298365.35782999999,9675277.1674000006,247.32368607271877,49.017035037071146,"49° 01' 01.33\"","247° 19' 25.27\""]
[null,298363.12783000001,9675278.4673999995,247.32325330689346,49.017139638216427,"49° 01' 01.70\"","247° 19' 23.71\""]
[null,298365.55783000001,9675279.5673999991,247.32543560955145,49.016818018377485,"49° 01' 00.54\"","247° 19' 31.57\""]
[null,298368.55783000001,9675273.2674000002,247.32292410750173,49.017052800458458,"49° 01' 01.39\"","247° 19' 22.53\""]
[null,298369.55783000001,9675272.5673999991,247.32303861522291,49.01701555149068,"49° 01' 01.26\"","247° 19' 22.94\""]
[null,298365.22782999999,9675271.5673999991,247.31980291150072,49.017509423012477,"49° 01' 03.03\"","247° 19' 11.29\""]
[null,298365.89782999997,9675279.7674000002,247.32577229879612,49.016769215327571,"49° 01' 00.37\"","247° 19' 32.78\""]

{"sheet":"VBA","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using VBA Code"]
[]
[null,"Easting (m)","Northing (m)","Latitude","Longitude"]
[null,298365.56783000001,9675278.7674000002,247.32489768132018,48.985831710618207]
[null,298364.36783,9675277.5673999991,247.323373541899,48.986045007226977]
[null,298363.16782999999,9675279.3673999999,247.32388869754175,48.986010744413718]
[null,298364.24783000001,9675278.2674000002,247.32377852986215,48.985998670638153]
[null,298365.35782999999,9675277.1674000006,247.32368607271877,48.985983740128468]
[null,298363.12783000001,9675278.4673999995,247.32325330689346,48.986088821576494]
[null,298365.55783000001,9675279.5673999991,247.32543560955145,48.985766646714794]
[null,298368.55783000001,9675273.2674000002,247.32292410750173,48.98600083986873]
[null,298369.55783000001,9675272.5673999991,247.32303861522291,48.985963376986831]
[null,298365.22782999999,9675271.5673999991,247.31980291150074,48.986458225441538]
[null,298365.89782999997,9675279.7674000002,247.32577229879612,48.985717765427715]