{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sample","Formula","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Sample Dataset"]
[]
[null,"Employee ","Date","Product","Quantity Sold","Total Price"]
[null,"Andrew","2022-05-01","Printer",12,{"$f":"E5*500","v":6000}]
[null,"Roger","2022-05-31","Keyboard",26,{"$f":"E6*150","v":3900}]
[null,"Harry","2022-06-04","Scanner",9,{"$f":"E7*700","v":6300}]
[null,"Zack","2022-06-14","Earbuds",56,2450.5]
[null,"Andrew","2022-06-21","Keyboard",18,{"$f":"E9*150","v":2700}]
[null,"Roger","2022-07-06","Earbuds",68,3550]
[null,"Harry","2022-07-17","Scanner",4,{"$f":"E11*700","v":2800}]
[null,"Zack","2022-08-28","Keyboard",25,{"$f":"E12*150","v":3750}]
[null,"Andrew","2022-09-08","Printer",14,{"$f":"E13*500","v":7000}]
[null,"Roger","2022-09-10","Scanner",8,{"$f":"8*700","v":5600}]
[null,"Harry","2022-10-21","Printer",9,{"$f":"E15*500","v":4500}]
[null,"Zack","2022-11-12","Earbuds",46,2848]

{"sheet":"Formula","index":1,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12],[17,1,17,5]]}
[]
[null,"Calculating Total Price Using DSUM Function with Multiple Criteria"]
[]
[null,"Employee ","Date","Product","Quantity Sold","Total Price"]
[null,"Andrew","2022-05-01","Printer",12,{"$f":"E5*500","v":6000}]
[null,"Roger","2022-05-31","Keyboard",26,{"$f":"E6*150","v":3900}]
[null,"Harry","2022-06-04","Scanner",9,{"$f":"E7*700","v":6300}]
[null,"Zack","2022-06-14","Earbuds",56,2450]
[null,"Andrew","2022-06-21","Keyboard",18,{"$f":"E9*150","v":2700}]
[null,"Roger","2022-07-06","Earbuds",46,2848]
[null,"Harry","2022-07-17","Scanner",4,{"$f":"E11*700","v":2800}]
[null,"Zack","2022-08-28","Keyboard",25,{"$f":"E12*150","v":3750}]
[null,"Andrew","2022-09-08","Printer",14,{"$f":"E13*500","v":7000}]
[null,"Roger","2022-09-10","Scanner",8,{"$f":"8*700","v":5600}]
[null,"Harry","2022-10-21","Printer",9,{"$f":"E15*500","v":4500}]
[null,"Zack","2022-11-12","Earbuds",68,3550]
[]
[null,"All Imposed Criteria"]
[]
[null,"Employee ","Date","Product","Quantity Sold","Total Price"]
[null,"Zack",">31-05-2022","Earbuds",">=50",{"$f":"DSUM(B4:F16,\"Total Price\",B20:E21)","v":6000}]

{"sheet":"VBA","index":2,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12],[17,1,17,5]]}
[]
[null,"Calculating Total Price of Specified Entries Using VBA"]
[]
[null,"Employee ","Date","Product","Quantity Sold","Total Price"]
[null,"Andrew","2022-05-01","Printer",12,{"$f":"E5*500","v":6000}]
[null,"Roger","2022-05-31","Keyboard",26,{"$f":"E6*150","v":3900}]
[null,"Harry","2022-06-04","Scanner",9,{"$f":"E7*700","v":6300}]
[null,"Zack","2022-06-14","Earbuds",56,2450]
[null,"Andrew","2022-06-21","Keyboard",18,{"$f":"E9*150","v":2700}]
[null,"Roger","2022-07-06","Earbuds",46,2848]
[null,"Harry","2022-07-17","Scanner",4,{"$f":"E11*700","v":2800}]
[null,"Zack","2022-08-28","Keyboard",25,{"$f":"E12*150","v":3750}]
[null,"Andrew","2022-09-08","Printer",14,{"$f":"E13*500","v":7000}]
[null,"Roger","2022-09-10","Scanner",8,{"$f":"8*700","v":5600}]
[null,"Harry","2022-10-21","Printer",9,{"$f":"E15*500","v":4500}]
[null,"Zack","2022-11-12","Earbuds",68,3550]
[]
[null,"All Imposed Criteria"]
[]
[null,"Employee ","Date","Product","Quantity Sold","Total Price"]
[null,"Zack",">31-05-2022","Earbuds",">=50",6000]