{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Formula","VBA","Dataset"],"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":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Combination of IF, CONCATENATE and INT Functions",null,null,null,null,null,"Try Yourself"]
[]
[null,"Lat","Long","UTM",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,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,39.912851756277803,-116.592437752599]
[null,46.852033076157902,-118.893392948875,"11 N",null,null,null,46.852033076157902,-118.893392948875]
[null,32.303453356704097,-98.021062243530096,"14 N",null,null,null,32.303453356704097,-98.021062243530096]
[null,36.078838682116903,-114.08297298162699,"11 N",null,null,null,36.078838682116903,-114.08297298162699]
[null,-28.016567999999999,23.993333,"34 S",null,null,null,27.860613424667498,-81.306891170890495]
[]
[null,null,null,{"$f":"_xlfn.FORMULATEXT(O15)","v":"=IF(B5>=0,CONCATENATE(INT(31+C5/6),\" N\"),CONCATENATE(INT(31+C5/6),\" S\"))"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B5>=0,CONCATENATE(INT(31+C5/6),\" N\"),CONCATENATE(INT(31+C5/6),\" S\"))","v":"13 N"}]

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

{"sheet":"Dataset","index":2,"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]