{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Product Sales","Test_WS","MySheet","Find and Color Format","Find and Modify","First Blank"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Product Sales","index":0,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Dataset for Finding Blank cells"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Price"]
[null,"2022-02-02","Whole Wheat",30,3.49,{"$f":"PRODUCT(D5,E5)","v":104.7}]
[null,"2022-02-02","Carrot",null,1.77]
[null,"2022-02-02","Bran",57,1.87,{"$f":"PRODUCT(D7,E7)","v":106.59}]
[null,"2022-02-02","Potato Chips",null,1.68]
[null,"2022-02-03","Chocolate Chip",24,1.87,44.88]
[null,"2022-02-03","Bran",null,1.87]
[null,"2022-02-03","Oatmeal Raisin",124,2.8400000000000003,352.16]
[null,"2022-02-04","Carrot",137,1.77,242.49]
[null,"2022-02-04","Arrowroot",146,2.1799999999999997,318.27999999999997]
[null,"2022-02-04","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-02-05","Carrot",null,1.77]
[null,"2022-02-05","Arrowroot",139,2.1799999999999997,303.02]
[null,"2022-02-05","Chocolate Chip",211,1.8699999999999999,394.57]

{"sheet":"Test_WS","index":1,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Find Blank Cells"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Price"]
[null,"2022-02-02","Whole Wheat",30,3.49,{"$f":"PRODUCT(D5,E5)","v":104.7}]
[null,"2022-02-02","Carrot",null,1.77]
[null,"2022-02-02","Bran",57,1.87,{"$f":"PRODUCT(D7,E7)","v":106.59}]
[null,"2022-02-02","Potato Chips",null,1.68]
[null,"2022-02-03","Chocolate Chip",24,1.87,44.88]
[null,"2022-02-03","Bran",null,1.87]
[null,"2022-02-03","Oatmeal Raisin",124,2.8400000000000003,352.16]
[null,"2022-02-04","Carrot",137,1.77,242.49]
[null,"2022-02-04","Arrowroot",146,2.1799999999999997,318.27999999999997]
[null,"2022-02-04","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-02-05","Carrot",null,1.77]
[null,"2022-02-05","Arrowroot",139,2.1799999999999997,303.02]
[null,"2022-02-05","Chocolate Chip",211,1.8699999999999999,394.57]

{"sheet":"MySheet","index":2,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Find Blank Cells"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Price"]
[null,"2022-02-02","Whole Wheat",30,3.49,{"$f":"PRODUCT(D5,E5)","v":104.7}]
[null,"2022-02-02","Carrot",null,1.77]
[null,"2022-02-02","Bran",57,1.87,{"$f":"PRODUCT(D7,E7)","v":106.59}]
[null,"2022-02-02","Potato Chips",null,1.68]
[null,"2022-02-03","Chocolate Chip",24,1.87,44.88]
[null,"2022-02-03","Bran",null,1.87]
[null,"2022-02-03","Oatmeal Raisin",124,2.8400000000000003,352.16]
[null,"2022-02-04","Carrot",137,1.77,242.49]
[null,"2022-02-04","Arrowroot",146,2.1799999999999997,318.27999999999997]
[null,"2022-02-04","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-02-05","Carrot",null,1.77]
[null,"2022-02-05","Arrowroot",139,2.1799999999999997,303.02]
[null,"2022-02-05","Chocolate Chip",211,1.8699999999999999,394.57]

{"sheet":"Find and Color Format","index":3,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Find Blank Cells and Color Format"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Price"]
[null,"2022-02-02","Whole Wheat",30,3.49,{"$f":"PRODUCT(D5,E5)","v":104.7}]
[null,"2022-02-02","Carrot",null,1.77]
[null,"2022-02-02","Bran",57,1.87,{"$f":"PRODUCT(D7,E7)","v":106.59}]
[null,"2022-02-02","Potato Chips",null,1.68]
[null,"2022-02-03","Chocolate Chip",24,1.87,44.88]
[null,"2022-02-03","Bran",null,1.87]
[null,"2022-02-03","Oatmeal Raisin",124,2.8400000000000003,352.16]
[null,"2022-02-04","Carrot",137,1.77,242.49]
[null,"2022-02-04","Arrowroot",146,2.1799999999999997,318.27999999999997]
[null,"2022-02-04","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-02-05","Carrot",null,1.77]
[null,"2022-02-05","Arrowroot",139,2.1799999999999997,303.02]
[null,"2022-02-05","Chocolate Chip",211,1.8699999999999999,394.57]

{"sheet":"Find and Modify","index":4,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Find and Modify Blank Cells"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Price"]
[null,"2022-02-02","Whole Wheat",30,3.49,{"$f":"PRODUCT(D5,E5)","v":104.7}]
[null,"2022-02-02","Carrot","Blank_Cell",1.77,"Blank_Cell"]
[null,"2022-02-02","Bran",57,1.87,{"$f":"PRODUCT(D7,E7)","v":106.59}]
[null,"2022-02-02","Potato Chips","Blank_Cell",1.68,"Blank_Cell"]
[null,"2022-02-03","Chocolate Chip",24,1.87,44.88]
[null,"2022-02-03","Bran","Blank_Cell",1.87,"Blank_Cell"]
[null,"2022-02-03","Oatmeal Raisin",124,2.8400000000000003,352.16]
[null,"2022-02-04","Carrot",137,1.77,242.49]
[null,"2022-02-04","Arrowroot",146,2.1799999999999997,318.27999999999997]
[null,"2022-02-04","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-02-05","Carrot","Blank_Cell",1.77,"Blank_Cell"]
[null,"2022-02-05","Arrowroot",139,2.1799999999999997,303.02]
[null,"2022-02-05","Chocolate Chip",211,1.8699999999999999,394.57]

{"sheet":"First Blank","index":5,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"Order Date","Product","Quantity","Unit Price","Total Price"]
[null,"2022-02-02","Whole Wheat",30,3.49,{"$f":"PRODUCT(D2,E2)","v":104.7}]
[null,"2022-02-02","Carrot",null,1.77]
[null,"2022-02-02","Bran",57,1.87,{"$f":"PRODUCT(D4,E4)","v":106.59}]
[null,"2022-02-02","Potato Chips",null,1.68]
[null,"2022-02-03","Chocolate Chip",24,1.87,44.88]
[null,"2022-02-03","Bran",null,1.87]
[null,"2022-02-03","Oatmeal Raisin",124,2.8400000000000003,352.16]
[null,"2022-02-04","Carrot",137,1.77,242.49]
[null,"2022-02-04","Arrowroot",146,2.1799999999999997,318.27999999999997]
[null,"2022-02-04","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-02-05","Carrot",null,1.77]
[null,"2022-02-05","Arrowroot",139,2.1799999999999997,303.02]
[null,"2022-02-05","Chocolate Chip",211,1.8699999999999999,394.57]