{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Source Data","Export Data","Sheet4","Source Data (2)","Source Data (3)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":1},"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":"Source Data","index":0,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Product Order Record"]
[]
[null,"Product","Amount","Country","Order Date","Ship Date"]
[null,"Apple",3000,"Canada","2022-12-06","2025-11-11"]
[null,"Blueberry",5000,"Spain","2022-07-11"]
[null,"Carrot",3000,"Spain","2022-05-05","2023-06-21"]
[null,"Banana",4000,"Canada","2023-03-29","5/22/20##"]
[null,"Cabbage",1000,"France","2022-08-19","2024-11-04"]
[null,"Orange",1000,"Spain","2022-09-15","2025-02-17"]
[null,"Broccoli",5000,"Canada","2023-01-09","12/*8/2023"]
[null,"Carrot",3000,"France","2022-08-21","2024-12-31"]
[null,"Grape",2000,"Canada","2022-12-30","2025-10-04"]
[null,"Cabbage",4000,"Spain","2023-05-11","../16/2024"]
[null,"Beans",2000,"France","2023-06-08","2023-10-27"]
[null,"Blueberry",4000,"Canada","2022-04-14"]
[null,"Broccoli",1000,"France","2022-11-30","2023-03-10"]
[null,"Orange",2000,"Canada","2022-02-24"]
[null,"Carrot",4000,"Canada","2022-11-02","2023-04-02"]
[null,"Avocados",4000,"Spain","2022-12-05","5/26/--24"]

{"sheet":"Export Data","index":1,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Detecting Error Using VBA"]
[]
[null,"Product","Amount","Country","Order Date","Ship Date","Data Type"]
[null,"Apple",3000,"Canada","2022-12-06","2025-11-11",{"$f":"ValueType(F5)","v":"Date"}]
[null,"Blueberry",5000,"Spain","2022-07-11",null,{"$f":"ValueType(F6)","v":"Blank"}]
[null,"Carrot",3000,"Spain","2022-05-05","2023-06-21","Date"]
[null,"Banana",4000,"Canada","2023-03-29","5/22/20##","Text"]
[null,"Cabbage",1000,"France","2022-08-19","2024-11-04","Date"]
[null,"Orange",1000,"Spain","2022-09-15","2025-02-17","Date"]
[null,"Broccoli",5000,"Canada","2023-01-09","12/*8/2023","Text"]
[null,"Carrot",3000,"France","2022-08-21","2024-12-31","Date"]
[null,"Grape",2000,"Canada","2022-12-30","2025-10-04","Date"]
[null,"Cabbage",4000,"Spain","2023-05-11","../16/2024","Text"]
[null,"Beans",2000,"France","2023-06-08","2023-10-27","Date"]
[null,"Blueberry",4000,"Canada","2022-04-14",null,"Blank"]
[null,"Broccoli",1000,"France","2022-11-30","2023-03-10","Date"]
[null,"Orange",2000,"Canada","2022-02-24",null,"Blank"]
[null,"Carrot",4000,"Canada","2022-11-02","2023-04-02","Date"]
[null,"Avocados",4000,"Spain","2022-12-05","5/26/--24",{"$f":"ValueType(F20)","v":"Text"}]

{"sheet":"Sheet4","index":2,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Row Labels","Sum of Amount"]
["Apple",3000]
["2025-11-11",3000]
["Avocados",4000]
["5/26/--24",4000]
["Banana",4000]
["5/22/20##",4000]
["Beans",2000]
["2023-10-27",2000]
["Blueberry",9000]
["(blank)",9000]
["Broccoli",6000]
["12/*8/2023",5000]
["2023-03-10",1000]
["Cabbage",5000]
["../16/2024",4000]
["2024-11-04",1000]
["Carrot",10000]
["2023-04-02",4000]
["2023-06-21",3000]
["2024-12-31",3000]
["Grape",2000]
["2025-10-04",2000]
["Orange",3000]
["2025-02-17",1000]
["(blank)",2000]
["Grand Total",48000]

{"sheet":"Source Data (2)","index":3,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Filling Up Blank Cells"]
[]
[null,"Product","Amount","Country","Order Date","Ship Date"]
[null,"Apple",3000,"Canada","2022-12-06","2025-11-11",null,{"$f":"ValueType(F5)","v":"Date"}]
[null,"Blueberry",5000,"Spain","2022-07-11",null,null,{"$f":"ValueType(F6)","v":"Blank"}]
[null,"Carrot",3000,"Spain","2022-05-05","2023-06-21",null,"Date"]
[null,"Banana",4000,"Canada","2023-03-29","2022-05-22",null,"Date"]
[null,"Cabbage",1000,"France","2022-08-19","2024-11-04",null,"Date"]
[null,"Orange",1000,"Spain","2022-09-15","2025-02-17",null,"Date"]
[null,"Broccoli",5000,"Canada","2023-01-09","2023-12-08",null,"Date"]
[null,"Carrot",3000,"France","2022-08-21","2024-12-31",null,"Date"]
[null,"Grape",2000,"Canada","2022-12-30","2025-10-04",null,"Date"]
[null,"Cabbage",4000,"Spain","2023-05-11","2024-11-16",null,"Date"]
[null,"Beans",2000,"France","2023-06-08","2023-10-27",null,"Date"]
[null,"Blueberry",4000,"Canada","2022-04-14",null,null,"Blank"]
[null,"Broccoli",1000,"France","2022-11-30","2023-03-10",null,"Date"]
[null,"Orange",2000,"Canada","2022-02-24",null,null,"Blank"]
[null,"Carrot",4000,"Canada","2022-11-02","2023-04-02",null,"Date"]
[null,"Avocados",4000,"Spain","2022-12-05","2024-05-26",null,"Date"]

{"sheet":"Source Data (3)","index":4,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Correcting Invalid Data"]
[]
[null,"Product","Amount","Country","Order Date","Ship Date"]
[null,"Apple",3000,"Canada","2022-12-06","2025-11-11",null,{"$f":"ValueType(F5)","v":"Date"}]
[null,"Blueberry",5000,"Spain","2022-07-11","2025-11-12",null,{"$f":"ValueType(F6)","v":"Date"}]
[null,"Carrot",3000,"Spain","2022-05-05","2023-06-21",null,"Date"]
[null,"Banana",4000,"Canada","2023-03-29","5/22/20##",null,"Text"]
[null,"Cabbage",1000,"France","2022-08-19","2024-11-04",null,"Date"]
[null,"Orange",1000,"Spain","2022-09-15","2025-02-17",null,"Date"]
[null,"Broccoli",5000,"Canada","2023-01-09","12/*8/2023",null,"Text"]
[null,"Carrot",3000,"France","2022-08-21","2024-12-31",null,"Date"]
[null,"Grape",2000,"Canada","2022-12-30","2025-10-04",null,"Date"]
[null,"Cabbage",4000,"Spain","2023-05-11","../16/2024",null,"Text"]
[null,"Beans",2000,"France","2023-06-08","2023-10-27",null,"Date"]
[null,"Blueberry",4000,"Canada","2022-04-14","2023-10-28",null,"Date"]
[null,"Broccoli",1000,"France","2022-11-30","2023-03-10",null,"Date"]
[null,"Orange",2000,"Canada","2022-02-24","2023-03-11",null,"Date"]
[null,"Carrot",4000,"Canada","2022-11-02","2023-04-02",null,"Date"]
[null,"Avocados",4000,"Spain","2022-12-05","5/26/--24",null,"Text"]