{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Sample","Text","Colon","Case","Like","Numbers","Range","Multi","Nested","Function","Compare","OddEven","Day"],"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":"Sample","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Sample Dataset"]
[]
[null,"Students","Student ID","Birthdate","Score","Grade"]
[null,"John",1803131,"1999-11-01",78,"A"]
[null,"Alex",1803132,"1998-01-05",95,"A+"]
[null,"Wendy",1803133,"1999-05-13",34,"F"]
[null,"Gary",1803134,"1997-02-09",81,"A+"]
[null,"Claire",1803135,"1999-11-05",45,"D"]
[null,"Drew",1803146,"1998-12-26",59,"C"]
[null,"Robert",1803147,"1998-10-07",31,"F"]
[null,"Paige",1803148,"1997-11-19",66,"B"]

{"sheet":"Text","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Select Case True with Text String"]
[]
[null,"Students","Score","Grade"]
[null,"John",78,"A"]
[null,"Alex",95,"A+"]
[null,"Wendy",34,"F"]
[null,"Gary",81,"A+"]
[null,"Claire",45,"D"]
[null,"Drew",59,"C"]
[null,"Robert",31,"F"]
[null,"Paige",66,"B"]

{"sheet":"Colon","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Select Case with Colon"]
[]
[null,"Students","Score","Grade"]
[null,"John",78,"A"]
[null,"Alex",95,"A+"]
[null,"Wendy",34,"F"]
[null,"Gary",81,"A+"]
[null,"Claire",45,"D"]
[null,"Drew",59,"C"]
[null,"Robert",31,"F"]
[null,"Paige",66,"B"]

{"sheet":"Case","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Select Case to Make Text Case Insensitive"]
[]
[null,"Students","Score","Grade"]
[null,"John",78,"A"]
[null,"Alex",95,"A+"]
[null,"Wendy",34,"F"]
[null,"Gary",81,"A+"]
[null,"Claire",45,"D"]
[null,"Drew",59,"C"]
[null,"Robert",31,"F"]
[null,"Paige",66,"B"]

{"sheet":"Like","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Select Case True Like "]
[]
[null,"Students","Score","Grade"]
[null,"John",78,"A"]
[null,"Alex",95,"A+"]
[null,"Wendy",34,"F"]
[null,"Gary",81,"A+"]
[null,"Claire",45,"D"]
[null,"Drew",59,"C"]
[null,"Robert",31,"F"]
[null,"Paige",66,"B"]

{"sheet":"Numbers","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Select Case with Numbers"]
[]
[null,"Students","Score","Grade"]
[null,"John",78,"A"]
[null,"Alex",95,"A+"]
[null,"Wendy",34,"F"]
[null,"Gary",81,"A+"]
[null,"Claire",45,"D"]
[null,"Drew",59,"C"]
[null,"Robert",31,"F"]
[null,"Paige",66,"B"]

{"sheet":"Range","index":6,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Application of Select Case with a Range of Numbers"]
[]
[null,"Students","Score","Grade"]
[null,"John",78,"A"]
[null,"Alex",95,"A+"]
[null,"Wendy",34,"F"]
[null,"Gary",81,"A+"]
[null,"Claire",45,"D"]
[null,"Drew",59,"C"]
[null,"Robert",31,"F"]
[null,"Paige",66,"B"]

{"sheet":"Multi","index":7,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Application of Multiple Conditions Using Select Case True"]
[]
[null,"Students","Score","Grade"]
[null,"John",78,"A"]
[null,"Alex",95,"A+"]
[null,"Wendy",34,"F"]
[null,"Gary",81,"A+"]
[null,"Claire",45,"D"]
[null,"Drew",59,"C"]
[null,"Robert",31,"F"]
[null,"Paige",66,"B"]

{"sheet":"Nested","index":8,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Creating Nested Conditions Using Select Case True"]
[]
[null,"Students","Student ID","Score","Grade"]
[null,"John",1803131,78,"A","A"]
[null,"Alex",1703132,95,"Pass","Pass"]
[null,"Wendy",1803133,34,"F","F"]
[null,"Gary",1803134,81,"A+","A+"]
[null,"Claire",1703135,45,"Fail","Fail"]
[null,"Drew",1803146,59,"C","C"]
[null,"Robert",1703177,31,"Fail","Fail"]
[null,"Paige",1803148,66,"B","B"]

{"sheet":"Function","index":9,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Creating VBA Function Using Select Case"]
[]
[null,"Students","Score","Grade"]
[null,"John",78,{"$f":"GradeScore(C5)","v":"A"}]
[null,"Alex",95,{"$f":"GradeScore(C6)","v":"A+"}]
[null,"Wendy",34,{"$f":"GradeScore(C7)","v":"F"}]
[null,"Gary",81,{"$f":"GradeScore(C8)","v":"A+"}]
[null,"Claire",45,{"$f":"GradeScore(C9)","v":"D"}]
[null,"Drew",59,{"$f":"GradeScore(C10)","v":"C"}]
[null,"Robert",31,{"$f":"GradeScore(C11)","v":"F"}]
[null,"Paige",66,{"$f":"GradeScore(C12)","v":"B"}]

{"sheet":"Compare","index":10,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Comparing Upper and Lower Case Using Select Case"]
[]
[null,"Students","Score","Grade"]
[null,"John",78]
[null,"Alex",95]
[null,"Wendy",34]
[null,"Gary",81]
[null,"Claire",45]
[null,"Drew",59]
[null,"Robert",31]
[null,"Paige",66]

{"sheet":"OddEven","index":11,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Select Case true to Check If a Number is Odd or Even"]
[]
[null,"Students","Student ID","Odd/Even"]
[null,"John",1803131,"odd"]
[null,"Alex",1803132,"even"]
[null,"Wendy",1803133,"odd"]
[null,"Gary",1803134,"even"]
[null,"Claire",1803135,"odd"]
[null,"Drew",1803146,"even"]
[null,"Robert",1803147,"odd"]
[null,"Paige",1803148,"even"]

{"sheet":"Day","index":12,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Determining Day of the Week from a Date Using Select Case"]
[]
[null,"Students","Birthdate","Day"]
[null,"John","1999-11-01","Monday"]
[null,"Alex","1998-01-05","Monday"]
[null,"Wendy","1999-05-13","Thursday"]
[null,"Gary","1997-02-09","Sunday"]
[null,"Claire","1999-11-05","Friday"]
[null,"Drew","1998-12-26","Saturday"]
[null,"Robert","1998-10-07","Wednesday"]
[null,"Paige","1997-11-19","Wednesday"]