{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["String_to_NumberType","Mismatching_Operation","Wrong_Datatype_in_Range","Invalid_Object_Range","Invalid_Object_Arr","Invalid_Date","Invalid_Conversion","Invalid_Array_Conversion"],"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":"String_to_NumberType","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Setting String Value to Number Type Variable"]
[]
[null,"First Name","ID","Email ID"]
[null,"Adam","101A",{"$f":"CONCATENATE(LOWER(B5),C5,\"@gmail.com\")","v":"adam101A@gmail.com"}]
[null,"Barry ","105D",{"$f":"CONCATENATE(LOWER(B6),C6,\"@gmail.com\")","v":"barry 105D@gmail.com"}]
[null,"Alisa","103A","alisa103A@gmail.com"]
[null,"Lilly ","107F","lilly 107F@gmail.com"]
[null,"Bruce","111D","bruce111D@gmail.com"]
[null,"Martha","110F","martha110F@gmail.com"]

{"sheet":"Mismatching_Operation","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null," Using Operators on Mismatching Data Types"]
[]
[null,"First Name","ID","Email ID"]
[null,"Adam",101]
[null,"Barry ",105]
[null,"Alisa",103]
[null,"Lilly ",107]
[null,"Bruce",111]
[null,"Martha",110]

{"sheet":"Wrong_Datatype_in_Range","index":2,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Overview of Runtime Error 13 Type Mismatch in Excel VBA"]
[]
[null,"Fruits","Unit Price (Per Kg)","Max Sales","Revenue"]
[null,"Apple",1.1599999999999999,400]
[null,"Orange",2.2999999999999998,380]
[null,"Water Melon",2,110]
[null,"Guava","Two Dollar Five Cents",230]
[null,"Mango",1.81,310]
[null,"Cherry",5.54,180]
[null," Strawberry",3,250]
[null,"Peach",1.83,200]

{"sheet":"Invalid_Object_Range","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Mismatch Error for Range Object"]
[]
[null,"Fruits","Unit Price (Per Kg)","Max Sales"]
[null,"Apple",1.1599999999999999,400]
[null,"Orange",2.2999999999999998,380]
[null,"Water Melon",2,110]
[null,"Guava",2.54,230]
[null,"Mango",1.81,310]
[null,"Cherry",5.54,180]
[null," Strawberry",3,250]
[null,"Peach",1.83,200]

{"sheet":"Invalid_Object_Arr","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null," Mismatch Error for Array Object"]
[]
[null,"Fruits","Unit Price (Per Kg)","Max Sales"]
[null,"Apple",1.1599999999999999,400]
[null,"Orange",2.2999999999999998,380]
[null,"Water Melon",2,110]
[null,"Guava",2.54,230]
[null,"Mango",1.81,310]
[null,"Cherry",5.54,180]
[null," Strawberry",3,250]
[null,"Peach",1.83,200]

{"sheet":"Invalid_Date","index":5,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null," Using Operators on Mismatching Data Types"]
[]
[null,"Joining Date","Name","ID","Email ID"]
[null,"2023-02-12","Adam","101A",{"$f":"CONCATENATE(LOWER(C5),D5,\"@gmail.com\")","v":"adam101A@gmail.com"}]
[null,"2023-03-15","Barry ","105D",{"$f":"CONCATENATE(LOWER(C6),D6,\"@gmail.com\")","v":"barry 105D@gmail.com"}]
[null,"2023-08-25","Alisa","103A","alisa103A@gmail.com"]
[null,"2023-07-20","Lilly ","107F","lilly 107F@gmail.com"]
[null,"2023-09-12","Bruce","111D","bruce111D@gmail.com"]
[null,"14/14/2023","Martha","110F","martha110F@gmail.com"]

{"sheet":"Invalid_Conversion","index":6,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Trying to Convert Incompatible Data Types"]
[]
[null,"First Name","ID","Email ID"]
[null,"Adam","101A",{"$f":"CONCATENATE(LOWER(B5),C5,\"@gmail.com\")","v":"adam101A@gmail.com"}]
[null,"Barry ","105D",{"$f":"CONCATENATE(LOWER(B6),C6,\"@gmail.com\")","v":"barry 105D@gmail.com"}]
[null,"Alisa","103A","alisa103A@gmail.com"]
[null,"Lilly ","107F","lilly 107F@gmail.com"]
[null,"Bruce","111D","bruce111D@gmail.com"]
[null,"Martha","110F","martha110F@gmail.com"]

{"sheet":"Invalid_Array_Conversion","index":7,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Invalid Array Conversion from Range"]
[]
[null,"Fruits","Unit Price (Per Kg)","Max Sales"]
[null,"Apple",1.1599999999999999,400]
[null,"Orange",2.2999999999999998,380]
[null,"Water Melon",2,110]
[null,"Guava",2.54,230]
[null,"Mango",1.81,310]
[null,"Cherry",5.54,180]
[null," Strawberry",3,250]
[null,"Peach",1.83,200]