{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Select Casae using Function","Case Is in Select Function","Select Case between Strings","Multiple condition Select Case","Two ranges in Select Case","Nested Select Case"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Select Casae using Function","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Select Case in a Custom Function"]
[]
[null,"Name","Number","Grade"]
[null,"John",65]
[null,"Miller",73]
[null,"Riley",93]
[null,"Dwaine",54]
[null,"Chris",31]
[null,"Jonathon",85]
[null,"Andrew",42]
[null,"David",56]

{"sheet":"Case Is in Select Function","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Compare Values Using Case Is"]
[]
[null,"Location","Temperature","Comment"]
[null,"Minnesota",-15]
[null,"Dubai",25]
[null,"Mexico City",15]
[null,"Moscow",-8]
[null,"Rio de Janerio",24]
[null,"Reykjavik",1]
[null,"Nairobi",19,"Below Room Temperature"]
[null,"Toronto",-1]
[null,"Los Angeles",27]

{"sheet":"Select Case between Strings","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Select Case Between Stirngs"]
[]
[null,"Serial No.","Month Name","Season"]
[null,1,"December","Winter"]
[null,2,"February","Winter"]
[null,3,"August","Other seasons"]
[null,4,"September","Other seasons"]
[null,5,"November","Other seasons"]
[null,6,"July","Other seasons"]
[null,7,"March","Other seasons"]
[null,8,"May","Other seasons"]

{"sheet":"Multiple condition Select Case","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Select Multiple Condition"]
[]
[null,"Customer Name","Purchase Quantity"]
[null,"Rowan",5]
[null,"John",2]
[null,"Kate",1]
[null,"Chris",3]
[null,"Roussow",6]
[null,"David",4]
[null,"Watson",8]

{"sheet":"Two ranges in Select Case","index":4,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Selsct Case two Ranges"]
[]
[null,"Patient Name","Temperature in Fahrenheit"]
[null,"Bob",99.5]
[null,"Morgan",96.8]
[null,"Taylor",100.4]
[null,"Casey",97.2]
[null,"Robin",102]
[null,"Alex",95.5]
[null,"Andrea",103.5]

{"sheet":"Nested Select Case","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Nested Select Case"]
[]
[null,"Student Name","Gender ","Favorite Subject"]
[null,"Rojer","Male","Physics"]
[null,"Jacob","Male","Commerce"]
[null,"Milly","Female","Mathematics"]
[null,"Sara","Female","Business Studies"]
[null,"Robert","Male","Chemistry"]
[null,"Ron","Male","Drawing"]