{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["VBA","Keyboard Shortcut","Go To Special Feature","SUBSTITUTE Function","REPLACE Function"," Excel Formula ","Find & Select Feature","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":1,"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":"VBA","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Sales Data 2022"]
[]
[null,"Company","Product","Branch","Sales"]
[null,"Nokia",null,"New York",1500]
[null,"Apple",null," Crimea",3000]
[null,"Xiaomi",null,"Virginia",4500]
[null,"Apple",null," Crimea",7500]
[null,"Nokia",null,"New York",2500]
[null,"Xiaomi","Tab"," Crimea",2000]
[null,"Xiaomi","Tab"," Crimea",3000]
[null,"Apple","Laptop","New York",1800]

{"sheet":"Keyboard Shortcut","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Sales Data 2022"]
[]
[null,"Company","Product","Branch","Sales"]
[null,"Nokia",null,"New York",1500]
[null,"Apple",null," Crimea",3000]
[null,"Xiaomi",null,"Virginia",4500]
[null,"Apple","Laptop"," Crimea",7500]
[null,"Nokia","Phone","New York",2500]
[null,"Xiaomi","Tab"," Crimea",2000]
[null,"Xiaomi","Tab"," Crimea",3000]
[null,"Apple","Laptop","New York",1800]

{"sheet":"Go To Special Feature","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Sales Data 2022"]
[]
[null,"Product","Quantity","Unit Price","Total"]
[null,"Phone",2,100,{"$f":"\"\"","v":""}]
[null,"Laptop",3,120,{"$f":"\"\"","v":""}]
[null,"Tab",5,100,{"$f":"\"\"","v":""}]
[null,"Headphone",1,20,{"$f":"\"\"","v":""}]
[null,"Speaker",4,50,{"$f":"\"\"","v":""}]
[null,"CPU",2,180,{"$f":"\"\"","v":""}]
[null,"Ram",3,50,{"$f":"\"\"","v":""}]
[null,"Router",6,15,{"$f":"\"\"","v":""}]

{"sheet":"SUBSTITUTE Function","index":3,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Sales Data 2022"]
[]
[null,"Company","Product","Branch","Sales","Output"]
[null,"Nokia","Phone","New York",1500,{"$f":"SUBSTITUTE(C6,\"Phone\",\"\")","v":""}]
[null,"Apple","Laptop"," Crimea",3000,{"$f":"SUBSTITUTE(C7,\"Phone\",\"\")","v":"Laptop"}]
[null,"Xiaomi","Tab","Virginia",4500,"Tab",null,null,null,null,{"$f":"SUBSTITUTE(C6,\"Phone\",\"\")","v":""}]
[null,"Apple","Laptop"," Crimea",7500,"Laptop"]
[null,"Nokia","Phone","New York",2500,""]
[null,"Xiaomi","Tab"," Crimea",2000,"Tab"]
[null,"Xiaomi","Tab"," Crimea",3000,"Tab"]
[null,"Apple","Laptop","New York",1800,"Laptop"]
[]
[null,null,null,null,{"$f":"SUBSTITUTE(B15,\"Phone\",\"\")","v":""}]

{"sheet":"REPLACE Function","index":4,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Sales Data 2022"]
[]
[null,"Company","Product","Branch","Sales","Output"]
[null,"Nokia","Phone","New York",1500,{"$f":"REPLACE(C6,1,5,\"\")","v":""}]
[null,"Apple","Laptop"," Crimea",3000,"Laptop"]
[null,"Xiaomi","Tab","Virginia",4500,"Tab"]
[null,"Apple","Laptop"," Crimea",7500,"Laptop"]
[null,"Nokia","Phone","New York",2500,{"$f":"REPLACE(C10,1,5,\"\")","v":""}]
[null,"Xiaomi","Tab"," Crimea",2000,"Tab"]
[null,"Xiaomi","Tab"," Crimea",3000,"Tab"]
[null,"Apple","Laptop","New York",1800,"Laptop"]

{"sheet":" Excel Formula ","index":5,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Sales Data 2022"]
[]
[null,"Company","Product","Branch","Sales"]
[null,"Nokia","Phone","New York",1500]
[null,"Apple","Laptop"," Crimea",3000]
[null,"Xiaomi",{"$f":"\"\"","v":""},"Virginia",4500]
[null,"Apple","Laptop"," Crimea",7500]
[null,"Nokia","Phone","New York",2500]
[null,"Xiaomi",{"$f":"\"\"","v":""}," Crimea",2000]
[null,"Xiaomi",{"$f":"\"\"","v":""}," Crimea",3000]
[null,"Apple","Laptop","New York",1800]

{"sheet":"Find & Select Feature","index":6,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Sales Data 2022"]
[]
[null,"Company","Product","Branch","Sales"]
[null,"Nokia","Phone","New York",1500]
[null,"Apple","Laptop"," Crimea",3000]
[null,"Xiaomi",null,"Virginia",4500]
[null,"Apple","Laptop"," Crimea",7500]
[null,"Nokia","Phone","New York",2500]
[null,"Xiaomi",null," Crimea",2000]
[null,"Xiaomi",null," Crimea",3000]
[null,"Apple","Laptop","New York",1800]

{"sheet":"Data","index":7,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Sales Data 2022"]
[]
[null,"Company","Product","Branch","Sales"]
[null,"Nokia","Phone","New York",1500]
[null,"Apple","Laptop"," Crimea",3000]
[null,"Xiaomi","Tab","Virginia",4500]
[null,"Apple","Laptop"," Crimea",7500]
[null,"Nokia","Phone","New York",2500]
[null,"Xiaomi","Tab"," Crimea",2000]
[null,"Xiaomi","Tab"," Crimea",3000]
[null,"Apple","Laptop","New York",1800]