{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Sheet1","Sheet2","Sheet3","Sheet4","Sheet5","Sheet6"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"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":"Sheet1","index":0,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[12,1,12,4],[1,1,1,4]]}
[]
[null,"Apply VBA Advanced Filter for OR Criteria"]
[]
[null,"Product","Quantity","Price/Unit","Total Price"]
[null,"Cookies",152,0.65,{"$f":"C5*D5","v":98.8}]
[null,"Chocolate",36,1.5,{"$f":"C6*D6","v":54}]
[null,"Wafer",46,0.45,20.7]
[null,"Cookies",152,0.65,{"$f":"C8*D8","v":98.8}]
[null,"Beef",65,10,650]
[null,"Chicken",321,5,1605]
[null,"Sausage",142,2.2999999999999998,326.59999999999997]
[]
[null,"Criteria Range"]
[null,"Product","Quantity","Price/Unit","Total Price"]
[null,"Cookies"]
[null,"Chocolate"]

{"sheet":"Sheet2","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[12,1,12,4]]}
[]
[null,"Apply VBA Advanced Filter for AND Criteria"]
[]
[null,"Product","Quantity","Price/Unit","Total Price"]
[null,"Cookies",152,0.65,{"$f":"C5*D5","v":98.8}]
[null,"Chocolate",36,1.5,{"$f":"C6*D6","v":54}]
[null,"Wafer",46,0.45,20.7]
[null,"Cookies",152,0.65,{"$f":"C8*D8","v":98.8}]
[null,"Beef",65,10,650]
[null,"Chicken",321,5,1605]
[null,"Sausage",142,2.2999999999999998,326.59999999999997]
[]
[null,"Criteria Range"]
[null,"Product","Quantity","Price/Unit","Total Price"]
[null,"Cookies",null,0.65]

{"sheet":"Sheet3","index":2,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[12,1,12,4]]}
[]
[null,"Apply VBA Advanced Filter for OR with AND Criteria"]
[]
[null,"Product","Quantity","Price/Unit","Total Price"]
[null,"Cookies",152,0.65,{"$f":"C5*D5","v":98.8}]
[null,"Chocolate",36,1.5,{"$f":"C6*D6","v":54}]
[null,"Wafer",46,0.45,20.7]
[null,"Cookies",152,0.65,{"$f":"C8*D8","v":98.8}]
[null,"Beef",65,10,650]
[null,"Chicken",321,5,1605]
[null,"Sausage",142,2.2999999999999998,326.59999999999997]
[]
[null,"Criteria Range"]
[null,"Product","Quantity","Price/Unit","Total Price"]
[null,"Cookies",null,0.65]
[null,"Chocolate"]

{"sheet":"Sheet4","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[12,1,12,4]]}
[]
[null,"Apply VBA Advanced Filter for Unique Values"]
[]
[null,"Product","Quantity","Price/Unit","Total Price"]
[null,"Cookies",152,0.65,{"$f":"C5*D5","v":98.8}]
[null,"Chocolate",36,1.5,{"$f":"C6*D6","v":54}]
[null,"Wafer",46,0.45,20.7]
[null,"Cookies",152,0.65,{"$f":"C8*D8","v":98.8}]
[null,"Beef",65,10,650]
[null,"Chicken",321,5,1605]
[null,"Sausage",142,2.2999999999999998,326.59999999999997]
[]
[null,"Criteria Range"]
[null,"Product","Quantity","Price/Unit","Total Price"]
[null,"Cookies"]
[null,"Chocolate"]

{"sheet":"Sheet5","index":4,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[12,1,12,4]]}
[]
[null,"Apply VBA Advanced Filter for Condition"]
[]
[null,"Product","Quantity","Price/Unit","Total Price"]
[null,"Cookies",162,0.65,{"$f":"C5*D5","v":105.3}]
[null,"Chocolate",36,1.5,{"$f":"C6*D6","v":54}]
[null,"Wafer",46,0.45,20.7]
[null,"Cookies",152,0.65,{"$f":"C8*D8","v":98.8}]
[null,"Beef",65,10,650]
[null,"Chicken",321,5,1605]
[null,"Sausage",142,2.2999999999999998,326.59999999999997]
[]
[null,"Criteria Range"]
[null,"Product","Quantity","Price/Unit","Total Price"]
[null,null,null,null,">100"]

{"sheet":"Sheet6","index":5,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Product","Quantity","Price/Unit","Total Price"]
[null,"Cookies",162,0.65,105.3]
[null,"Beef",65,10,650]
[null,"Chicken",321,5,1605]
[null,"Sausage",142,2.2999999999999998,326.59999999999997]