{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","range","function","Comparison","practice"],"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":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"\"X\" College"]
[]
[null,"Student ID","Student Name","Marks/Grades"]
[null,12101,"Daniel",85]
[null,12102,"Joseph",97]
[null,12103,"Michael","B"]
[null,12104,"Sheldon",68]
[null,12105,"Jenny","C"]
[null,12106,"Amy",89]
[null,12107,"Katherine","A"]

{"sheet":"range","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Checking for a Range of Values"]
[]
[null,"Student ID","Student Name","Marks/Grades","Check"]
[null,12101,"Daniel",85,true]
[null,12102,"Joseph",97,true]
[null,12103,"Michael","B",false]
[null,12104,"Sheldon",68,true]
[null,12105,"Jenny","C",false]
[null,12106,"Amy",89,true]
[null,12107,"Katherine","A",false]

{"sheet":"function","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,4,10,4]]}
[]
[null,"Counting Non-Numeric Values"]
[]
[null,"Student ID","Student Name","Marks/Grades","Count"]
[null,12101,"Daniel",85,{"$f":"countnonnumeric(D5:D11)","v":3}]
[null,12102,"Joseph",97]
[null,12103,"Michael","B"]
[null,12104,"Sheldon",68]
[null,12105,"Jenny","C"]
[null,12106,"Amy",89]
[null,12107,"Katherine","A"]

{"sheet":"Comparison","index":3,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Comparison"]
[]
[null,"Input","Fomula","VBA ISNUMERIC","Formula","Excel ISNUMBER"]
[null,300,{"$f":"_xlfn.FORMULATEXT(D5)","v":"=IsNumericTest(B5)"},{"$f":"IsNumericTest(B5)","v":true},{"$f":"_xlfn.FORMULATEXT(F5)","v":"=ISNUMBER(B5)"},{"$f":"ISNUMBER(B5)","v":true}]
[null,"\"300\"",{"$f":"_xlfn.FORMULATEXT(D6)","v":"=IsNumericTest(B6)"},{"$f":"IsNumericTest(B6)","v":false},{"$f":"_xlfn.FORMULATEXT(F6)","v":"=ISNUMBER(B6)"},{"$f":"ISNUMBER(B6)","v":false}]
[null,"\"Alaska\"","=IsNumericTest(B7)",{"$f":"IsNumericTest(B7)","v":false},"=ISNUMBER(B7)",false]
[null,"2022-02-02","=IsNumericTest(B8)",{"$f":"IsNumericTest(B8)","v":false},"=ISNUMBER(B8)",true]
[null,"\"2/2/2022\"","=IsNumericTest(B9)",{"$f":"IsNumericTest(B9)","v":false},"=ISNUMBER(B9)",false]
[null,"09:30:00","=IsNumericTest(B10)",{"$f":"IsNumericTest(B10)","v":true},"=ISNUMBER(B10)",true]
[null,"\"10:30:00 AM\"","=IsNumericTest(B11)",{"$f":"IsNumericTest(B11)","v":false},"=ISNUMBER(B11)",false]
[null,"\" \"","=IsNumericTest(B12)",{"$f":"IsNumericTest(B12)","v":false},"=ISNUMBER(B12)",false]

{"sheet":"practice","index":4,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Practice"]
[]
[null,"Student ID","Student Name","Marks/Grades"]
[null,12101,"Daniel",85]
[null,12102,"Joseph",97]
[null,12103,"Michael","B"]
[null,12104,"Sheldon",68]
[null,12105,"Jenny","C"]
[null,12106,"Amy",89]
[null,12107,"Katherine","A"]