{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["NewYork","NewYork_Color"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"NewYork","index":0,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"New York City Sale Dec'21"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Sale",null,"Cell Count"]
[null,"2021-12-06","Bran",50,1.87,{"$f":"PRODUCT(D5,E5)","v":93.5},null,{"$f":"COUNT(B4:F13)","v":27}]
[null,"2021-12-07","Oatmeal Raisin"]
[null,"2021-12-13","Whole Wheat",90,3.49,{"$f":"PRODUCT(D7,E7)","v":314.10000000000002}]
[null,"2021-12-15","Arrowroot",75,2.1800000000000002,163.5]
[null,"2021-12-16","Chocolate Chip",200,1.8699999999999999,374]
[null,"2021-12-17","Whole Wheat"]
[null,"2021-12-18","Bran",25,1.87,46.75]
[null,"2021-12-19","Salt",55,2.84,156.19999999999999]
[null,null,null,null,"Total Sale",{"$f":"SUM(F5:F12)","v":1148.05}]

{"sheet":"NewYork_Color","index":1,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"New York City Sale Dec'21"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Sale",null,"Criteria","Colored Cells"]
[null,"2021-12-06","Bran",50,1.87,{"$f":"PRODUCT(D5,E5)","v":93.5},null,null,{"$f":"CountCellColored(B4:F13,H5)","v":16}]
[null,"2021-12-07","Oatmeal Raisin",100,2.8400000000000003,{"$f":"PRODUCT(D6,E6)","v":284.00000000000006}]
[null,"2021-12-13","Whole Wheat",90,3.49,314.10000000000002]
[null,"2021-12-15","Arrowroot",75,2.1800000000000002,163.5]
[null,"2021-12-16","Chocolate Chip",200,1.8699999999999999,374]
[null,"2021-12-17","Whole Wheat",45,3.49,157.05000000000001]
[null,"2021-12-18","Bran",25,1.87,46.75]
[null,"2021-12-19","Salt",55,2.84,156.19999999999999]
[null,null,null,null,"Total Sale",{"$f":"SUM(F5:F12)","v":1589.1000000000001}]