{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","between","VBA","TODAY ","FILTER","Last30Days","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"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":"Dataset","index":0,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Fruit Order Data"]
[]
[null,"Order Date","Fruit","Total Amount"]
[null,"2022-04-06","Mango",5000]
[null,"2022-04-13","Lichi",6500]
[null,"2022-04-21","Orange",7700]
[null,"2022-04-29","Pineapple",8500]
[null,"2022-05-06","Mango",9000]
[null,"2022-05-13","Watermelon",7800]
[null,"2022-05-21","Orange",8500]
[null,"2022-06-01","Grape",8230]
[null,"2022-06-09","Banana",7500]
[null,"2022-06-12","Mango",8450]
[null,"2022-06-13","Grape",9000]
[null,"2022-06-19","Watermelon",8500]

{"sheet":"between","index":1,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Fruit Order Data"]
[]
[null,"Order Date","Fruit","Total Amount"]
[null,"2022-04-06","Mango",5000]
[null,"2022-04-13","Lichi",6500]
[null,"2022-04-21","Orange",7700]
[null,"2022-04-29","Pineapple",8500]
[null,"2022-05-06","Mango",9000]
[null,"2022-05-13","Watermelon",7800]
[null,"2022-05-21","Orange",8500]
[null,"2022-06-01","Grape",8230]
[null,"2022-06-09","Banana",7500]
[null,"2022-06-12","Mango",8450]
[null,"2022-06-13","Grape",9000]
[null,"2022-06-19","Watermelon",8500]

{"sheet":"VBA","index":2,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Fruit Order Data"]
[]
[null,"Order Date","Fruit","Total Amount"]
[null,"2022-04-06","Mango",5000]
[null,"2022-04-13","Lichi",6500]
[null,"2022-04-21","Orange",7700]
[null,"2022-04-29","Pineapple",8500]
[null,"2022-05-06","Mango",9000]
[null,"2022-05-13","Watermelon",7800]
[null,"2022-05-21","Orange",8500]
[null,"2022-06-01","Grape",8230]
[null,"2022-06-09","Banana",7500]
[null,"2022-06-12","Mango",8450]
[null,"2022-06-13","Grape",9000]
[null,"2022-06-19","Watermelon",8500]

{"sheet":"TODAY ","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Fruit Order Data"]
[]
[null,"Order Date","Fruit","Total Amount","Helper Column"]
[null,"2022-04-06","Mango",5000,{"$f":"AND(B5>=(TODAY()-30),B5<TODAY())","v":false}]
[null,"2022-04-13","Lichi",6500,{"$f":"AND(B6>=(TODAY()-30),B6<TODAY())","v":false}]
[null,"2022-04-21","Orange",7700,false]
[null,"2022-04-29","Pineapple",8500,false]
[null,"2022-05-06","Mango",9000,false]
[null,"2022-05-13","Watermelon",7800,false]
[null,"2022-05-21","Orange",8500,true]
[null,"2022-06-01","Grape",8230,true]
[null,"2022-06-09","Banana",7500,true]
[null,"2022-06-12","Mango",8450,true]
[null,"2022-06-13","Grape",9000,true]
[null,"2022-06-19","Watermelon",8500,true]

{"sheet":"FILTER","index":4,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Fruit Order Data",null,null,null,"Filtered Data"]
[]
[null,"Order Date","Fruit","Total Amount",null,{"$f":"_xlfn._xlws.FILTER(B4:D16,B4:B16>=TODAY()-30,B4:B16<TODAY())","v":"Order Date"},"Fruit","Total Amount"]
[null,"2022-04-06","Mango",5000,null,"2022-05-21","Orange",8500]
[null,"2022-04-13","Lichi",6500,null,"2022-06-01","Grape",8230]
[null,"2022-04-21","Orange",7700,null,"2022-06-09","Banana",7500]
[null,"2022-04-29","Pineapple",8500,null,"2022-06-12","Mango",8450]
[null,"2022-05-06","Mango",9000,null,"2022-06-13","Grape",9000]
[null,"2022-05-13","Watermelon",7800,null,"2022-06-19","Watermelon",8500]
[null,"2022-05-21","Orange",8500]
[null,"2022-06-01","Grape",8230]
[null,"2022-06-09","Banana",7500]
[null,"2022-06-12","Mango",8450]
[null,"2022-06-13","Grape",9000]
[null,"2022-06-19","Watermelon",8500]

{"sheet":"Last30Days","index":5,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Order Date","Fruit","Total Amount"]
[null,"2022-05-21","Orange",8500]
[null,"2022-06-01","Grape",8230]
[null,"2022-06-09","Banana",7500]
[null,"2022-06-12","Mango",8450]
[null,"2022-06-13","Grape",9000]
[null,"2022-06-19","Watermelon",8500]

{"sheet":"Data","index":6,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Fruit Order Data"]
[]
[null,"Order Date","Fruit","Total Amount"]
[null,"2022-04-06","Mango",5000]
[null,"2022-04-13","Lichi",6500]
[null,"2022-04-21","Orange",7700]
[null,"2022-04-29","Pineapple",8500]
[null,"2022-05-06","Mango",9000]
[null,"2022-05-13","Watermelon",7800]
[null,"2022-05-21","Orange",8500]
[null,"2022-06-01","Grape",8230]
[null,"2022-06-09","Banana",7500]
[null,"2022-06-12","Mango",8450]
[null,"2022-06-13","Grape",9000]
[null,"2022-06-19","Watermelon",8500]