{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Sample data set","Split Pane_2","Split Pane_1","Freeze Pane_1","Freeze Pane_2","Applying VBA Code_2","Applying VBA Code_1"],"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":"Sample data set","index":0,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sample Data Set"]
[]
[null,"Order Date","Name","Item","Units"]
[null,"2021-01-20","Jordan","Pencil",50]
[null,"2021-03-20","Mike","Book",45]
[null,"2021-05-20","Robert","Pencil",90]
[null,"2021-07-20","Jill","Pencil",80]
[null,"2021-09-25","Jim","Pen",100]
[null,"2021-10-25","Robin","Binder",20]
[null,"2021-11-26","Henry","Book",120]
[null,"2021-12-27","Smith","Book",70]
[null,"2022-01-16","Jordan","Pencil",60]
[null,"2022-02-15","Mike","Book",40]
[null,"2022-03-21","Robert","Pencil",50]
[null,"2022-04-20","Smith","Book",55]
[null,"2022-05-13","Jones","Desk",95]
[null,"2022-06-19","Jim","Pen",150]
[null,"2022-07-22","Jones","Desk",45]
[null,"2022-08-12","Morgan","Binder",60]
[null,"2022-09-10","Jill","Pencil",130]
[null,"2022-10-17","Morgan","Binder",100]
[null,"2022-11-26","Mike","Book",50]
[null,"2022-12-23","Smith","Book",90]

{"sheet":"Split Pane_2","index":1,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Split Pane"]
[]
[null,"Order Date","Name","Item","Units"]
[null,"2021-01-20","Jordan","Pencil",50," "]
[null,"2021-03-20","Mike","Book",45]
[null,"2021-05-20","Robert","Pencil",90]
[null,"2021-07-20","Jill","Pencil",80]
[null,"2021-09-25","Jim","Pen",100]
[null,"2021-10-25","Robin","Binder",20]
[null,"2021-11-26","Henry","Book",120]
[null,"2021-12-27","Smith","Book",70]
[null,"2022-01-16","Jordan","Pencil",60]
[null,"2022-02-15","Mike","Book",40]
[null,"2022-03-21","Robert","Pencil",50]
[null,"2022-04-20","Smith","Book",55]
[null,"2022-05-13","Jones","Desk",95]
[null,"2022-06-19","Jim","Pen",150]
[null,"2022-07-22","Jones","Desk",45]
[null,"2022-08-12","Morgan","Binder",60]
[null,"2022-09-10","Jill","Pencil",130]
[null,"2022-10-17","Morgan","Binder",100]
[null,"2022-11-26","Mike","Book",50]
[null,"2022-12-23","Smith","Book",90]

{"sheet":"Split Pane_1","index":2,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Split Pane"]
[]
[null,"Order Date","Name","Item","Units"]
[null,"2021-01-20","Jordan","Pencil",50]
[null,"2021-03-20","Mike","Book",45]
[null,"2021-05-20","Robert","Pencil",90]
[null,"2021-07-20","Jill","Pencil",80]
[null,"2021-09-25","Jim","Pen",100]
[null,"2021-10-25","Robin","Binder",20]
[null,"2021-11-26","Henry","Book",120]
[null,"2021-12-27","Smith","Book",70]
[null,"2022-01-16","Jordan","Pencil",60]
[null,"2022-02-15","Mike","Book",40]
[null,"2022-03-21","Robert","Pencil",50]
[null,"2022-04-20","Smith","Book",55]
[null,"2022-05-13","Jones","Desk",95]
[null,"2022-06-19","Jim","Pen",150]
[null,"2022-07-22","Jones","Desk",45]
[null,"2022-08-12","Morgan","Binder",60]
[null,"2022-09-10","Jill","Pencil",130]
[null,"2022-10-17","Morgan","Binder",100]
[null,"2022-11-26","Mike","Book",50]
[null,"2022-12-23","Smith","Book",90]

{"sheet":"Freeze Pane_1","index":3,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Utilizing Freeze Panes"]
[]
[null,"Order Date","Name","Item","Units"]
[null,"2021-01-20","Jordan","Pencil",50]
[null,"2021-03-20","Mike","Book",45]
[null,"2021-05-20","Robert","Pencil",90]
[null,"2021-07-20","Jill","Pencil",80]
[null,"2021-09-25","Jim","Pen",100]
[null,"2021-10-25","Robin","Binder",20]
[null,"2021-11-26","Henry","Book",120]
[null,"2021-12-27","Smith","Book",70]
[null,"2022-01-16","Jordan","Pencil",60]
[null,"2022-02-15","Mike","Book",40]
[null,"2022-03-21","Robert","Pencil",50]
[null,"2022-04-20","Smith","Book",55]
[null,"2022-05-13","Jones","Desk",95]
[null,"2022-06-19","Jim","Pen",150]
[null,"2022-07-22","Jones","Desk",45]
[null,"2022-08-12","Morgan","Binder",60]
[null,"2022-09-10","Jill","Pencil",130]
[null,"2022-10-17","Morgan","Binder",100]
[null,"2022-11-26","Mike","Book",50]
[null,"2022-12-23","Smith","Book",90]

{"sheet":"Freeze Pane_2","index":4,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Utilizing Freeze Panes"]
[]
[null,"Order Date","Name","Item","Units"]
[null,"2021-01-20","Jordan","Pencil",50]
[null,"2021-03-20","Mike","Book",45]
[null,"2021-05-20","Robert","Pencil",90]
[null,"2021-07-20","Jill","Pencil",80]
[null,"2021-09-25","Jim","Pen",100]
[null,"2021-10-25","Robin","Binder",20]
[null,"2021-11-26","Henry","Book",120]
[null,"2021-12-27","Smith","Book",70]
[null,"2022-01-16","Jordan","Pencil",60]
[null,"2022-02-15","Mike","Book",40]
[null,"2022-03-21","Robert","Pencil",50]
[null,"2022-04-20","Smith","Book",55]
[null,"2022-05-13","Jones","Desk",95]
[null,"2022-06-19","Jim","Pen",150]
[null,"2022-07-22","Jones","Desk",45]
[null,"2022-08-12","Morgan","Binder",60]
[null,"2022-09-10","Jill","Pencil",130]
[null,"2022-10-17","Morgan","Binder",100]
[null,"2022-11-26","Mike","Book",50]
[null,"2022-12-23","Smith","Book",90]

{"sheet":"Applying VBA Code_2","index":5,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Order Date","Name","Item","Units"]
[null,"2021-01-20","Jordan","Pencil",50]
[null,"2021-03-20","Mike","Book",45]
[null,"2021-05-20","Robert","Pencil",90]
[null,"2021-07-20","Jill","Pencil",80]
[null,"2021-09-25","Jim","Pen",100]
[null,"2021-10-25","Robin","Binder",20]
[null,"2021-11-26","Henry","Book",120]
[null,"2021-12-27","Smith","Book",70]
[null,"2022-01-16","Jordan","Pencil",60]
[null,"2022-02-15","Mike","Book",40]
[null,"2022-03-21","Robert","Pencil",50]
[null,"2022-04-20","Smith","Book",55]
[null,"2022-05-13","Jones","Desk",95]
[null,"2022-06-19","Jim","Pen",150]
[null,"2022-07-22","Jones","Desk",45]
[null,"2022-08-12","Morgan","Binder",60]
[null,"2022-09-10","Jill","Pencil",130]
[null,"2022-10-17","Morgan","Binder",100]
[null,"2022-11-26","Mike","Book",50]
[null,"2022-12-23","Smith","Book",90]

{"sheet":"Applying VBA Code_1","index":6,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Order Date","Name","Item","Units"]
[null,"2021-01-20","Jordan","Pencil",50]
[null,"2021-03-20","Mike","Book",45]
[null,"2021-05-20","Robert","Pencil",90]
[null,"2021-07-20","Jill","Pencil",80]
[null,"2021-09-25","Jim","Pen",100]
[null,"2021-10-25","Robin","Binder",20]
[null,"2021-11-26","Henry","Book",120]
[null,"2021-12-27","Smith","Book",70]
[null,"2022-01-16","Jordan","Pencil",60]
[null,"2022-02-15","Mike","Book",40]
[null,"2022-03-21","Robert","Pencil",50]
[null,"2022-04-20","Smith","Book",55]
[null,"2022-05-13","Jones","Desk",95]
[null,"2022-06-19","Jim","Pen",150]
[null,"2022-07-22","Jones","Desk",45]
[null,"2022-08-12","Morgan","Binder",60]
[null,"2022-09-10","Jill","Pencil",130]
[null,"2022-10-17","Morgan","Binder",100]
[null,"2022-11-26","Mike","Book",50]
[null,"2022-12-23","Smith","Book",90]