{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sheet1","Sheet3","Sheet2","Sheet4","Sheet5"],"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":"Sheet1","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Sample Dataset"]
[]
[null,"ID","First Name","Last Name","State","Salary"]
[null,null,"April","Beren","NY",2200]
[null,102,null,"Bale",null,2100]
[null,103,"Natasha ",null,"MI"]
[null,null,"Shane ","Lee",null,1800]
[null,105,null,"Moyes","OH"]
[null,106,"Gregory",null,"FL"]
[null,107,null,"Seinfeld","GA",2000]
[null,null,"Richard","Hockley",null,2600]

{"sheet":"Sheet3","index":1,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Find and Replace Tool"]
[]
[null,"ID","First Name","Last Name","State","Salary"]
[null,"Void","April","Beren","NY",2200]
[null,102,"Void","Bale","Void",2100]
[null,103,"Natasha ","Void","MI","Void"]
[null,"Void","Shane ","Lee","Void",1800]
[null,105,"Void","Moyes","OH","Void"]
[null,106,"Gregory","Void","FL","Void"]
[null,107,"Void","Seinfeld","GA",2000]
[null,"Void","Richard","Hockley","Void",2600]

{"sheet":"Sheet2","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Go To Special Function"]
[]
[null,"ID","First Name","Last Name","State","Salary"]
[null,"Void","April","Beren","NY",2200]
[null,102,"Void","Bale","Void",2100]
[null,103,"Natasha ","Void","MI","Void"]
[null,"Void","Shane ","Lee","Void",1800]
[null,105,"Void","Moyes","OH","Void"]
[null,106,"Gregory","Void","FL","Void"]
[null,107,"Void","Seinfeld","GA",2000]
[null,"Void","Richard","Hockley","Void",2600]

{"sheet":"Sheet4","index":3,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using IF & ISBLANK Function"]
[]
[null,"ID","First Name","Last Name","State","Salary"]
[null,{"$f":"IF(B5=\" \",\"Void\",B5)","v":0},"April","Beren","NY",2200]
[null,102,null,"Bale",null,2100]
[null,103,"Natasha ",null,"MI"]
[null,null,"Shane ","Lee",null,1800]
[null,105,null,"Moyes","OH"]
[null,106,"Gregory",null,"FL"]
[null,107,null,"Seinfeld","GA",2000]
[null,null,"Richard","Hockley",null,2600]

{"sheet":"Sheet5","index":4,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using VBA Codes"]
[]
[null,"ID","First Name","Last Name","State","Salary"]
[null,"Void","April","Beren","NY",2200]
[null,102,"Void","Bale","Void",2100]
[null,103,"Natasha ","Void","MI","Void"]
[null,"Void","Shane ","Lee","Void",1800]
[null,105,"Void","Moyes","OH","Void"]
[null,106,"Gregory","Void","FL","Void"]
[null,107,"Void","Seinfeld","GA",2000]
[null,"Void","Richard","Hockley","Void",2600]