{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["VBA Macro","GET.CELL","Find & Select","Table Option3","Filter Option","Manually","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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 Macro","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,"Product","Agent","Branch","Sales"]
[null,"Apple","Jhon","New York",1500]
[null,"Samsung","Yeats"," Crimea",3000]
[null,"Nokia","Milton","Virginia",4500]
[null,"Apple","Nixon"," Crimea",7500]
[null,"Nokia","Leo","New York",2500]
[null,"Apple","Kyle"," Crimea",2000]
[null,"Blackberry","Hugo"," Crimea",3000]
[null,"Apple","Carlo","New York",1800]

{"sheet":"GET.CELL","index":1,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Sales Data 2022"]
[]
[null,"Product","Agent","Branch","Sales"]
[null,"Apple","Jhon","New York",1500,{"$f":"color","v":0}]
[null,"Samsung","Yeats"," Crimea",3000,{"$f":"color","v":0}]
[null,"Nokia","Milton","Virginia",4500,{"$f":"color","v":0}]
[null,"Apple","Nixon"," Crimea",7500,{"$f":"color","v":0}]
[null,"Nokia","Leo","New York",2500,{"$f":"color","v":0}]
[null,"Apple","Kyle"," Crimea",2000,{"$f":"color","v":0}]
[null,"Blackberry","Hugo"," Crimea",3000,{"$f":"color","v":0}]
[null,"Apple","Carlo","New York",1800,{"$f":"color","v":0}]
[]
[null,"Total Sales",{"$f":"COUNTA(F6:F13)","v":8}]
[null,"Apple Product Sales",{"$f":"COUNTIF(F6:F13,\"Green\")","v":0}]
[null,"Percentage",{"$f":"C16/C15","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"get.cell","v":{"$error":"#NAME?"}}]

{"sheet":"Find & Select","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","Agent","Branch","Sales"]
[null,"Apple","Jhon","New York",1500]
[null,"Samsung","Yeats"," Crimea",3000]
[null,"Nokia","Milton","Virginia",4500]
[null,"Apple","Nixon"," Crimea",7500]
[null,"Nokia","Leo","New York",2500]
[null,"Apple","Kyle"," Crimea",2000]
[null,"Blackberry","Hugo"," Crimea",3000]
[null,"Apple","Carlo","New York",1800]

{"sheet":"Table Option3","index":3,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Sales Data 2022"]
[]
[null,"Product","Agent","Branch","Sales"]
[null,"Apple","Jhon","New York",1500]
[null,"Samsung","Yeats"," Crimea",3000]
[null,"Nokia","Milton","Virginia",4500]
[null,"Apple","Nixon"," Crimea",7500]
[null,"Nokia","Leo","New York",2500]
[null,"Apple","Kyle"," Crimea",2000]
[null,"Blackberry","Hugo"," Crimea",3000]
[null,"Apple","Carlo","New York",1800]
[]
[null,"Total Sales"]
[null," Product Sales"]
[null,"Percentage",{"$f":"C16/C15","v":{"$error":"#DIV/0!"}}]

{"sheet":"Filter Option","index":4,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Sales Data 2022"]
[]
[null,"Product","Agent","Branch","Sales"]
[null,"Apple","Jhon","New York",1500]
[null,"Samsung","Yeats"," Crimea",3000]
[null,"Nokia","Milton","Virginia",4500]
[null,"Apple","Nixon"," Crimea",7500]
[null,"Nokia","Leo","New York",2500]
[null,"Apple","Kyle"," Crimea",2000]
[null,"Blackberry","Hugo"," Crimea",3000]
[null,"Apple","Carlo","New York",1800]
[]
[null,"Total Sales",{"$f":"COUNTA(B6:B13)","v":8}]
[null,"Apple Product Sales",{"$f":"SUBTOTAL(3,B6:B13)","v":4}]
[null,"Percentage",{"$f":"C16/C15","v":0.5}]

{"sheet":"Manually","index":5,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Sales Data 2022"]
[]
[null,"Product","Agent","Branch","Sales","Color"]
[null,"Apple","Jhon","New York",1500,"Green"]
[null,"Samsung","Yeats"," Crimea",3000,"White"]
[null,"Nokia","Milton","Virginia",4500,"White"]
[null,"Apple","Nixon"," Crimea",7500,"Green"]
[null,"Nokia","Leo","New York",2500,"White"]
[null,"Apple","Kyle"," Crimea",2000,"Green"]
[null,"Blackberry","Hugo"," Crimea",3000,"White"]
[null,"Apple","Carlo","New York",1800,"Green"]
[]
[null,"Total Sales",{"$f":"COUNTA(F6:F13)","v":8}]
[null,"Apple Product Sales",{"$f":"COUNTIF(F6:F13,\"Green\")","v":4}]
[null,"Percentage",{"$f":"C16/C15","v":0.5}]

{"sheet":"Data","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,"Product","Agent","Branch","Sales"]
[null,"Apple","Jhon","New York",1500]
[null,"Samsung","Yeats"," Crimea",3000]
[null,"Nokia","Milton","Virginia",4500]
[null,"Apple","Nixon"," Crimea",7500]
[null,"Nokia","Leo","New York",2500]
[null,"Apple","Kyle"," Crimea",2000]
[null,"Blackberry","Hugo"," Crimea",3000]
[null,"Apple","Carlo","New York",1800]