{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Using Text to Column","User Defined Func","TEXT and MOD Functions","VBA","Custom Formatting","INT Function"],"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":"Using Text to Column","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Text to Columns Feature"]
[]
[null,"Decimal Degrees","Degrees","Minutes ","Seconds"]
[null,42.325600000000001,42,19,32.160000000005994]
[null,36.756,36,45,21.599999999999998]
[null,72.364999999999995,72,21,53.999999999982002]
[null,45.456000000000003,45,27,21.600000000011999]
[null,54.622999999999998,54,37,22.799999999994]
[null,78.256,78,15,21.599999999999998]
[null,47.365000000000002,47,21,54.000000000006004]
[null,34.784999999999997,34,47,5.9999999999879998]
[null,28.632999999999999,28,37,58.799999999994]

{"sheet":"User Defined Func","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using User Defined Function"]
[]
[null,"Decimal Degree","Degree Minutes Seconds"]
[null,42.325600000000001,{"$f":"Convert_Deg(B5)","v":" 42° 19 ' 32\""}]
[null,36.756,{"$f":"Convert_Deg(B6)","v":" 36° 45 ' 22\""}]
[null,72.364999999999995," 72° 21 ' 54\""]
[null,45.456000000000003," 45° 27 ' 22\""]
[null,54.622999999999998," 54° 37 ' 23\""]
[null,78.256," 78° 15 ' 22\""]
[null,47.365000000000002," 47° 21 ' 54\""]
[null,34.784999999999997," 34° 47 ' 6\""]
[null,28.632999999999999," 28° 37 ' 59\""]

{"sheet":"TEXT and MOD Functions","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combination of TEXT and MOD Functions"]
[]
[null,"Decimal Degree","Degree Minutes Seconds"]
[null,42.325600000000001,{"$f":"TEXT(MOD(B5,360)/24,\"[h]\\°mm'ss\\\"\"\")","v":"42°19'32\""}]
[null,36.756,{"$f":"TEXT(MOD(B6,360)/24,\"[h]\\°mm'ss\\\"\"\")","v":"36°45'22\""}]
[null,72.364999999999995,"72°21'54\""]
[null,45.456000000000003,"45°27'22\""]
[null,54.622999999999998,"54°37'23\""]
[null,78.256,"78°15'22\""]
[null,47.365000000000002,"47°21'54\""]
[null,34.784999999999997,"34°47'06\""]
[null,28.632999999999999,"28°37'59\""]

{"sheet":"VBA","index":3,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Embedding VBA Code"]
[]
[null,"Decimal Degree","Degree Minutes Seconds"]
[null,42.325600000000001,"42°19'32''"]
[null,36.756,"36°45'22''"]
[null,72.364999999999995,"72°21'54''"]
[null,45.456000000000003,"45°27'22''"]
[null,54.622999999999998,"54°37'23''"]
[null,78.256,"78°15'22''"]
[null,47.365000000000002,"47°21'54''"]
[null,34.784999999999997,"34°47'6''"]
[null,28.632999999999999,"28°37'59''"]

{"sheet":"Custom Formatting","index":4,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Custom Formatting"]
[]
[null,"Decimal Degree","Degree Minutes Seconds"]
[null,42.325600000000001,{"$f":"B5/24","v":1.7635666666666667}]
[null,36.756,{"$f":"B6/24","v":1.5315000000000001}]
[null,72.364999999999995,3.0152083333333333]
[null,45.456000000000003,1.8940000000000001]
[null,54.622999999999998,2.2759583333333331]
[null,78.256,3.2606666666666668]
[null,47.365000000000002,1.9735416666666667]
[null,34.784999999999997,1.4493749999999999]
[null,28.632999999999999,1.1930416666666666]

{"sheet":"INT Function","index":5,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Utilizing INT Function "]
[]
[null,"Decimal Degrees","Degrees","Fractions","Minutes","Seconds"]
[null,42.325600000000001,{"$f":"INT(B5)","v":42},{"$f":"(B5-C5)*60","v":19.536000000000087},{"$f":"INT(D5)","v":19},{"$f":"(D5-E5)*60","v":32.160000000005198}]
[null,36.756,{"$f":"INT(B6)","v":36},{"$f":"(B6-C6)*60","v":45.360000000000014},{"$f":"INT(D6)","v":45},{"$f":"(D6-E6)*60","v":21.600000000000819}]
[null,72.364999999999995,72,21.899999999999693,21,53.999999999981583]
[null,45.456000000000003,45,27.360000000000184,27,21.60000000001105]
[null,54.622999999999998,54,37.379999999999853,37,22.799999999991201]
[null,78.256,78,15.360000000000014,15,21.600000000000819]
[null,47.365000000000002,47,21.900000000000119,21,54.000000000007162]
[null,34.784999999999997,34,47.099999999999795,47,5.9999999999877218]
[null,28.632999999999999,28,37.979999999999947,37,58.799999999996828]