{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","CONVERT","INT & ROUND","Arithmetic 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":"Dataset","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset"]
[]
[null,"Name","Height (mm)"]
[null,"Jhon",1676.4]
[null,"Smith",1859.28]
[null,"Eva",1524]
[null,"Noah",1557.528]
[null,"Oliver",1584.96]
[null,"Emma",1463.04]

{"sheet":"CONVERT","index":1,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Use of CONVERT Function",null,null,null,null,null,null,"For Practice"]
[]
[null,"Name","Height (mm)","Height (ft)","Height (in)",null,null,null,"Name","Height (mm)","Height (ft)","Height (in)"]
[null,"Jhon",1676.4,{"$f":"CONVERT(C5,\"mm\",\"ft\")&\"'  \"","v":"5.5'  "},{"$f":"CONVERT(C5,\"mm\",\"in\")&\"\"\"\"","v":"66\""},null,null,null,"Jhon",1676.4]
[null,"Smith",1859.28,{"$f":"CONVERT(C6,\"mm\",\"ft\")&\"'  \"","v":"6.1'  "},{"$f":"CONVERT(C6,\"mm\",\"in\")&\"\"\"\"","v":"73.2\""},null,null,null,"Smith",1859.28]
[null,"Eva",1524,"5'  ","60\"",null,null,null,"Eva",1524]
[null,"Noah",1557.528,"5.11'  ","61.32\"",null,null,null,"Noah",1557.528]
[null,"Oliver",1584.96,"5.2'  ","62.4\"",null,null,null,"Oliver",1584.96]
[null,"Emma",1463.04,"4.8'  ","57.6\"",null,null,null,"Emma",1463.04]

{"sheet":"INT & ROUND","index":2,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Combination of INT & ROUND Functions",null,null,null,null,null,null,"For Practice"]
[]
[null,"Name","Height (mm)","Height (ft)","Height (in)",null,null,null,"Name","Height (mm)","Height (ft)","Height (in)"]
[null,"Jhon",1676.4,{"$f":"INT(ROUND(C5*0.03937,0)/12)&\"' \"","v":"5' "},{"$f":"INT(C5/25.4)&\"\"\"\"","v":"66\""},null,null,null,"Jhon",1676.4]
[null,"Smith",1859.28,{"$f":"INT(ROUND(C6*0.03937,0)/12)&\"' \"","v":"6' "},{"$f":"INT(C6/25.4)&\"\"\"\"","v":"73\""},null,null,null,"Smith",1859.28]
[null,"Eva",1524,{"$f":"INT(ROUND(C7*0.03937,0)/12)&\"' \"","v":"5' "},"60\"",null,null,null,"Eva",1524]
[null,"Noah",1557.528,{"$f":"INT(ROUND(C8*0.03937,0)/12)&\"' \"","v":"5' "},"61\"",null,null,null,"Noah",1557.528]
[null,"Oliver",1584.96,{"$f":"INT(ROUND(C9*0.03937,0)/12)&\"' \"","v":"5' "},"62\"",null,null,null,"Oliver",1584.96]
[null,"Emma",1463.04,{"$f":"INT(ROUND(C10*0.03937,0)/12)&\"' \"","v":"4' "},"57\"",null,null,null,"Emma",1463.04]

{"sheet":"Arithmetic Formula","index":3,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Use of Arithmetic Formula",null,null,null,null,null,null,"For Practice"]
[]
[null,"Name","Height (mm)","Height (in)","Height (ft)",null,null,null,"Name","Height (mm)","Height (in)","Height (ft)"]
[null,"Jhon",1676.4,{"$f":" C5/25.4","v":66.000000000000014},{"$f":"D5/12","v":5.5000000000000009},null,null,null,"Jhon",1676.4]
[null,"Smith",1859.28,{"$f":" C6/25.4","v":73.2},{"$f":"D6/12","v":6.1000000000000005},null,null,null,"Smith",1859.28]
[null,"Eva",1524,{"$f":" C7/25.4","v":60},5,null,null,null,"Eva",1524]
[null,"Noah",1557.528,{"$f":" C8/25.4","v":61.320000000000007},5.1100000000000003,null,null,null,"Noah",1557.528]
[null,"Oliver",1584.96,{"$f":" C9/25.4","v":62.400000000000006},5.2,null,null,null,"Oliver",1584.96]
[null,"Emma",1463.04,{"$f":" C10/25.4","v":57.6},4.8,null,null,null,"Emma",1463.04]

{"sheet":"VBA","index":4,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Use of Excel VBA",null,null,null,null,null,null,"For Practice"]
[]
[null,"Name","Height (mm)","Height (ft)","Height (in)",null,null,null,"Name","Height (mm)","Height (ft)","Height (in)"]
[null,"Jhon",1676.4,5.5,66,null,null,null,"Jhon",1676.4]
[null,"Smith",1859.28,6.1000000000000005,73.2,null,null,null,"Smith",1859.28]
[null,"Eva",1524,5,60,null,null,null,"Eva",1524]
[null,"Noah",1557.528,5.1100000000000003,61.32,null,null,null,"Noah",1557.528]
[null,"Oliver",1584.96,5.2,62.4,null,null,null,"Oliver",1584.96]
[null,"Emma",1463.04,4.8,57.6,null,null,null,"Emma",1463.04]