{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Convert Manually","CONVERT Function","Insert Option","VBA Code","TRUNC,MOD and ROUND Functions","Several Functions","Common Errors"],"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":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Cable Length of Land Owner's"]
[]
[null,"Owner","Cable Length (Meter)"]
[null,"Robin",5]
[null,"Mary",8.4]
[null,"Jones",7.86]
[null,"Susan",12]
[null,"James",5.76]
[null,"Frank",8.7799999999999994]
[null,"Jennifer",5.4]
[null,"Thomas",10]
[null,"Mark",3]
[null,"Sandra",5.65]

{"sheet":"Convert Manually","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Converting Manually"]
[]
[null,"Owner","Cable Length (Meter)","Cable Length (Feet)"]
[null,"Robin",5,{"$f":"C5*3.28084","v":16.404199999999999}]
[null,"Mary",8.4,{"$f":"C6*3.28084","v":27.559056000000002}]
[null,"Jones",7.86,25.787402400000001]
[null,"Susan",12,39.370080000000002]
[null,"James",5.76,18.897638399999998]
[null,"Frank",8.7799999999999994,28.805775199999999]
[null,"Jennifer",5.4,17.716536000000001]
[null,"Thomas",10,32.808399999999999]
[null,"Mark",3,9.8425200000000004]
[null,"Sandra",5.65,18.536746000000001]

{"sheet":"CONVERT Function","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using CONVERT Function"]
[]
[null,"Owner","Cable Length (Meter)","Cable Length (Feet)"]
[null,"Robin",5,{"$f":"CONVERT(C5,\"m\",\"ft\")","v":16.404199475065617}]
[null,"Mary",8.4,{"$f":"CONVERT(C6,\"m\",\"ft\")","v":27.559055118110237}]
[null,"Jones",7.86,25.787401574803148]
[null,"Susan",12,39.370078740157481]
[null,"James",5.76,18.897637795275589]
[null,"Frank",8.7799999999999994,28.805774278215225]
[null,"Jennifer",5.4,17.716535433070867]
[null,"Thomas",10,32.808398950131235]
[null,"Mark",3,9.8425196850393704]
[null,"Sandra",5.65,{"$f":"CONVERT(C14,\"m\",\"ft\")","v":18.536745406824146}]

{"sheet":"Insert Option","index":3,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Employing Insert Function"]
[]
[null,"Owner","Cable Length (Meter)","Cable Length (Feet)"]
[null,"Robin",5,{"$f":"CONVERT(C5,\"m\",\"ft\")","v":16.404199475065617}]
[null,"Mary",8.4,{"$f":"CONVERT(C6,\"m\",\"ft\")","v":27.559055118110237}]
[null,"Jones",7.86,25.787401574803148]
[null,"Susan",12,39.370078740157481]
[null,"James",5.76,18.897637795275589]
[null,"Frank",8.7799999999999994,28.805774278215225]
[null,"Jennifer",5.4,17.716535433070867]
[null,"Thomas",10,32.808398950131235]
[null,"Mark",3,9.8425196850393704]
[null,"Sandra",5.65,18.536745406824146]

{"sheet":"VBA Code","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying VBA"]
[]
[null,"Owner","Cable Length (Meter)","Cable Length (Feet)"]
[null,"Robin",5,16.404199475065617]
[null,"Mary",8.4,27.559055118110237]
[null,"Jones",7.86,25.787401574803148]
[null,"Susan",12,39.370078740157481]
[null,"James",5.76,18.897637795275589]
[null,"Frank",8.7799999999999994,28.805774278215225]
[null,"Jennifer",5.4,17.716535433070867]
[null,"Thomas",10,32.808398950131235]
[null,"Mark",3,9.8425196850393704]
[null,"Sandra",5.65,18.536745406824146]

{"sheet":"TRUNC,MOD and ROUND Functions","index":5,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Implementing TRUNC, MOD and ROUND Functions"]
[]
[null,"Owner","Cable Length (Meter)","Cable Length (Feet)"]
[null,"Robin",5,{"$f":"TRUNC(C5*100/2.54/12)&\"' \"&ROUND(MOD(C5*100/2.54,12),0)&\"\"\"\"","v":"16' 5\""}]
[null,"Mary",8.4,{"$f":"TRUNC(C6*100/2.54/12)&\"' \"&ROUND(MOD(C6*100/2.54,12),0)&\"\"\"\"","v":"27' 7\""}]
[null,"Jones",7.86,"25' 9\""]
[null,"Susan",12,"39' 4\""]
[null,"James",5.76,"18' 11\""]
[null,"Frank",8.7799999999999994,"28' 10\""]
[null,"Jennifer",5.4,"17' 9\""]
[null,"Thomas",10,"32' 10\""]
[null,"Mark",3,"9' 10\""]
[null,"Sandra",5.65,"18' 6\""]

{"sheet":"Several Functions","index":6,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using INT,TEXT and MOD with CONVERT Functions"]
[]
[null,"Owner","Cable Length (Meter)","Cable Length (Feet)"]
[null,"Robin",5,{"$f":"INT(CONVERT(C5,\"m\",\"ft\")) & \" ft. \" &TEXT(MOD(CONVERT(C5,\"m\",\"in\"), 12), \"0 \"\"in.\"\"\")","v":"16 ft. 5 in."}]
[null,"Mary",8.4,{"$f":"INT(CONVERT(C6,\"m\",\"ft\")) & \" ft. \" &TEXT(MOD(CONVERT(C6,\"m\",\"in\"), 12), \"0 \"\"in.\"\"\")","v":"27 ft. 7 in."}]
[null,"Jones",7.86,"25 ft. 9 in."]
[null,"Susan",12,"39 ft. 4 in."]
[null,"James",5.76,"18 ft. 11 in."]
[null,"Frank",8.7799999999999994,"28 ft. 10 in."]
[null,"Jennifer",5.4,"17 ft. 9 in."]
[null,"Thomas",10,"32 ft. 10 in."]
[null,"Mark",3,"9 ft. 10 in."]
[null,"Sandra",5.65,"18 ft. 6 in."]

{"sheet":"Common Errors","index":7,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Common CONVERT Function Errors"]
[]
[null,"Name","Height (m)","Height (ft)"]
[null,"Robin",1.7,{"$f":"CONVERT(C5,\"M\",\"ft\")","v":{"$error":"#N/A"}}]
[]
[]
[null,"Name","Height (m)","Weight (kg)"]
[null,"Robin",1.7,{"$f":"CONVERT(C9,\"m\",\"kg\")","v":{"$error":"#N/A"}}]
[]
[]
[null,"Name","Height (m)","Height (ft)"]
[null,"Robin","Two",{"$f":"CONVERT(C13,\"M\",\"ft\")","v":{"$error":"#VALUE!"}}]