{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dataset","Highlight Cells","Coloring Rows","Function"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Sales Amount"]
[]
[null,"Date","Sales Amount"]
[null,"2022-08-18",15000]
[null,"2022-08-19",13500]
[null,"2022-08-20",10700]
[null,"2022-08-21",17200]
[null,"2022-08-22",19500]
[null,"2022-08-23",10000]
[null,"2022-08-24",8500]
[null,"2022-08-25",14100]
[null,"2022-08-26",15300]
[null,"2022-08-27",15050]
[null,"2022-08-28",10000]
[null,"2022-08-29",13000]

{"sheet":"Highlight Cells","index":1,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Highlighting Cells"]
[]
[null,"Date","Sales Amount"]
[null,"2022-08-18",15000]
[null,"2022-08-19",13500]
[null,"2022-08-20",10700]
[null,"2022-08-21",17200]
[null,"2022-08-22",19500]
[null,"2022-08-23",10000]
[null,"2022-08-24",8500]
[null,"2022-08-25",14100]
[null,"2022-08-26",15300]
[null,"2022-08-27",15050]
[null,"2022-08-28",10000]
[null,"2022-08-29",13000]

{"sheet":"Coloring Rows","index":2,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Coloring Rows"]
[]
[null,"Date","Sales Amount"]
[null,"2022-08-18",15000]
[null,"2022-08-19",13500]
[null,"2022-08-20",10700]
[null,"2022-08-21",17200]
[null,"2022-08-22",19500]
[null,"2022-08-23",10000]
[null,"2022-08-24",8500]
[null,"2022-08-25",14100]
[null,"2022-08-26",15300]
[null,"2022-08-27",15050]
[null,"2022-08-28",10000]
[null,"2022-08-29",13000]

{"sheet":"Function","index":3,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Using VBA Custom Function"]
[]
[null,"Today's Date",{"$f":"TODAY()","v":"2022-08-29"}]
[]
[]
[]
[null,"Date","Sales Amount","Status"]
[null,"2021-07-28",15000,{"$f":"MnthYr(B8)","v":false}]
[null,"2022-07-29",13500,{"$f":"MnthYr(B9)","v":false}]
[null,"2022-07-30",10700,{"$f":"MnthYr(B10)","v":false}]
[null,"2022-07-31",17200,{"$f":"MnthYr(B11)","v":false}]
[null,"2022-08-01",19500,{"$f":"MnthYr(B12)","v":true}]
[null,"2022-08-02",10000,{"$f":"MnthYr(B13)","v":true}]
[null,"2022-08-03",8500,{"$f":"MnthYr(B14)","v":true}]
[null,"2022-08-04",14100,{"$f":"MnthYr(B15)","v":true}]
[null,"2022-08-05",15300,{"$f":"MnthYr(B16)","v":true}]
[null,"2022-08-06",15050,{"$f":"MnthYr(B17)","v":true}]
[null,"2022-08-07",10000,{"$f":"MnthYr(B18)","v":true}]
[null,"2022-08-08",13000,{"$f":"MnthYr(B19)","v":true}]