{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","if","mid cells","change value","particular cells","Color","vba","find and replace","diy"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Clear Cell Contents Based on Condition"]
[]
[null,"Car Name","Company Name","Price","Max. Speed (Mph)"]
[null,"Taycan","Porsche",250000,225]
[null,"Cayman GT4","Porsche",220000,225]
[null,"Spyder","Porsche",250000,220]
[null,"Fiesta","Ford",275000,230]
[null,"Roadster","Tesla",280000,250]
[null,"Sedan","Ford",225000,215]
[null,"Carrera GT","Porsche",250000,230]
[null,"Aventador","Lamborgini",300000,220]
[null,"McLaren F1","McLaren Cars",250000,240]
[null,"Bugatti Veyron","Bugatti",275000,230]

{"sheet":"if","index":1,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using IF Function"]
[]
[null,"Car Name","Company Name","Price","Max. Speed (Mph)","Condition"]
[null,"Fiesta","Ford",275000,230,{"$f":"IF(E5>=230,\"Yes\",\"No\")","v":"Yes"}]
[null,"Roadster","Tesla",280000,250,"Yes"]
[null,"Carrera GT","Porsche",250000,230,"Yes"]
[null,"McLaren F1","McLaren Cars",250000,240,"Yes"]
[null,"Bugatti Veyron","Bugatti",275000,230,"Yes"]

{"sheet":"mid cells","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Clearing Mid Cells"]
[]
[null,"Car Name","Company Name","Price","Max. Speed (Mph)"]
[null,"Taycan","Porsche",250000,225]
[null,"Cayman GT4","Porsche",220000,225]
[null,"Spyder",null,null,220]
[null,"Fiesta",null,null,230]
[null,"Roadster",null,null,250]
[null,"Sedan",null,null,215]
[null,"Carrera GT","Porsche",250000,230]
[null,"Aventador","Lamborgini",300000,220]
[null,"McLaren F1","McLaren Cars",250000,240]
[null,"Bugatti Veyron","Bugatti",275000,230]

{"sheet":"change value","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
["Value","Clearing by Changing Cell Value"]
[]
[null,"Car Name","Company Name","Price","Max. Speed (Mph)"]
[null,"Taycan","Porsche",250000,225]
[null,"Cayman GT4","Porsche",220000,225]
[null,"Spyder",null,250000,220]
[null,"Fiesta",null,275000,230]
[null,"Roadster",null,280000,250]
[null,"Sedan",null,225000,215]
[null,"Carrera GT","Porsche",250000,230]
[null,"Aventador","Lamborgini",300000,220]
[null,"McLaren F1","McLaren Cars",250000,240]
[null,"Bugatti Veyron","Bugatti",275000,230]

{"sheet":"particular cells","index":4,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Clearing Particular Cells Based on Value"]
[]
[null,"Car Name","Company Name","Price","Max. Speed (Mph)"]
[null,"Taycan","Porsche",250000,225]
[null,"Cayman GT4","Porsche",220000,225]
[null,"Spyder","Porsche",250000,220]
[]
[]
[null,"Sedan","Ford",225000,215]
[null,"Carrera GT","Porsche",250000,230]
[]
[null,"McLaren F1","McLaren Cars",250000,240]

{"sheet":"Color","index":5,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Clearing Based on Color"]
[]
[null,"Car Name","Company Name","Price","Max. Speed (Mph)"]
[null,"Taycan","Porsche",250000,225]
[null,"Cayman GT4","Porsche",220000]
[null,"Spyder","Porsche",250000,220]
[null,"Fiesta","Ford",275000,230]
[null,"Roadster","Tesla",280000]
[null,"Sedan","Ford",225000,215]
[null,"Carrera GT","Porsche",250000,230]
[null,"Aventador","Lamborgini",300000]
[null,"McLaren F1","McLaren Cars",250000,240]
[null,"Bugatti Veyron","Bugatti",275000]

{"sheet":"vba","index":6,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using VBA"]
[]
[null,"Car Name","Company Name","Price","Max. Speed (Mph)"]
[null,"Taycan","Porsche",250000,225]
[null,"Cayman GT4","Porsche",220000,225]
[null,"Spyder","Porsche",250000,220]
[null,"Sedan","Ford",225000,215]
[null,"Carrera GT","Porsche",250000,230]
[null,"McLaren F1","McLaren Cars",250000,240]

{"sheet":"find and replace","index":7,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Find and Replace Feature"]
[]
[null,"Car Name","Company Name","Price","Max. Speed (Mph)"]
[null,"Taycan","  ",250000,225]
[null,"Cayman GT4","  ",220000,225]
[null,"Spyder","  ",250000,220]
[null,"Fiesta","Ford",275000,230]
[null,"Roadster","Tesla",280000,250]
[null,"Sedan","Ford",225000,215]
[null,"Carrera GT","  ",250000,230]
[null,"Aventador","Lamborgini",300000,220]
[null,"McLaren F1","McLaren Cars",250000,240]
[null,"Bugatti Veyron","Bugatti",275000,230]

{"sheet":"diy","index":8,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Do It Yourself"]
[]
[null,"Car Name","Company Name","Price","Max. Speed (Mph)"]
[null,"Taycan","Porsche",250000,225]
[null,"Cayman GT4","Porsche",220000,225]
[null,"Spyder","Porsche",250000,220]
[null,"Fiesta","Ford",275000,230]
[null,"Roadster","Tesla",280000,250]
[null,"Sedan","Ford",225000,215]
[null,"Carrera GT","Porsche",250000,230]
[null,"Aventador","Lamborgini",300000,220]
[null,"McLaren F1","McLaren Cars",250000,240]
[null,"Bugatti Veyron","Bugatti",275000,230]