{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Go to Replace","Find & Replace","VBA","Sample"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Go to Replace","index":0,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Apply the Go to Special Command"]
[]
[null,"Outlets","Alaska","California","Nevada","Michigan"]
[null,"Outlet No. 1 ",32,0,0,0]
[null,"Outlet No. 2",0,33,0,0]
[null,"Outlet No. 3",42,0,34,0]
[null,"Outlet No. 4",0,43,0,35]
[null,"Outlet No. 5",0,0,44,0]
[null,"Outlet No. 6",62,0,0,45]
[null,"Outlet No. 7",0,63,0,0]
[null,"Outlet No. 8",0,0,65,0]
[null,"Outlet No. 9",0,0,0,66]
[null,"Outlet No. 10",85,0,0,0]

{"sheet":"Find & Replace","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Use the Replace Command"]
[]
[null,"Outlets","Alaska","California","Nevada","Michigan"]
[null,"Outlet No. 1 ",32,0,0,0]
[null,"Outlet No. 2",0,33,0,0]
[null,"Outlet No. 3",42,0,34,0]
[null,"Outlet No. 4",0,43,0,35]
[null,"Outlet No. 5",0,0,44,0]
[null,"Outlet No. 6",62,0,0,45]
[null,"Outlet No. 7",0,63,0,0]
[null,"Outlet No. 8",0,0,65,0]
[null,"Outlet No. 9",0,0,0,66]
[null,"Outlet No. 10",85,0,0,0]

{"sheet":"VBA","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Run a VBA Code"]
[]
[null,"Outlets","Alaska","California","Nevada","Michigan"]
[null,"Outlet No. 1 ",32,0,0,0]
[null,"Outlet No. 2",0,33,0,0]
[null,"Outlet No. 3",42,0,34,0]
[null,"Outlet No. 4",0,43,0,35]
[null,"Outlet No. 5",0,0,44,0]
[null,"Outlet No. 6",62,0,0,45]
[null,"Outlet No. 7",0,63,0,0]
[null,"Outlet No. 8",0,0,65,0]
[null,"Outlet No. 9",0,0,0,66]
[null,"Outlet No. 10",85,0,0,0]

{"sheet":"Sample","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Sample Data Set to Fill Blank Cells with 0"]
[]
[null,"Outlets","Alaska","California","Nevada","Michigan"]
[null,"Outlet No. 1 ",32]
[null,"Outlet No. 2",null,33]
[null,"Outlet No. 3",42,null,34]
[null,"Outlet No. 4",null,43,null,35]
[null,"Outlet No. 5",null,null,44]
[null,"Outlet No. 6",62,null,null,45]
[null,"Outlet No. 7",null,63]
[null,"Outlet No. 8",null,null,65]
[null,"Outlet No. 9",null,null,null,66]
[null,"Outlet No. 10",85]