{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Sample Data","Find & Select","Filter","Get Cell","VBA","Practice"],"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":"Sample Data","index":0,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Count cells with specific Color"]
[]
[null,"Date","Product","Country","Quantity","Sales"]
[null,"2022-01-01","Mobile","US",20,200]
[null,"2022-01-02","Laptop","Canada",30,300]
[null,"2022-01-03","Monitor","Germany",40,400]
[null,"2022-01-04","Keyboard","US",50,500]
[null,"2022-01-05","Monitor","US",60,600]
[null,"2022-01-06","Laptop","Germany",70,700]
[null,"2022-01-07","Mobile","Canada",80,800]
[null,"2022-01-08","Keyboard","France",90,900]
[null,"2022-01-09","Laptop","Korea",95,1000]

{"sheet":"Find & Select","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Count cells with specific Color"]
[]
[null,"Date","Product","Country","Quantity","Sales"]
[null,"2022-01-01","Mobile","US",20,200]
[null,"2022-01-02","Laptop","Canada",30,300]
[null,"2022-01-03","Monitor","Germany",40,400]
[null,"2022-01-04","Keyboard","US",50,500]
[null,"2022-01-05","Monitor","US",60,600]
[null,"2022-01-06","Laptop","Germany",70,700]
[null,"2022-01-07","Mobile","Canada",80,800]
[null,"2022-01-08","Keyboard","France",90,900]
[null,"2022-01-09","Laptop","Korea",95,1000]

{"sheet":"Filter","index":2,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Count cells with specific Color"]
[]
[null,"Date","Product","Country","Quantity","Sales"]
[null,"2022-01-01","Mobile","US",20,200]
[null,"2022-01-02","Laptop","Canada",30,300]
[null,"2022-01-03","Monitor","Germany",40,400]
[null,"2022-01-04","Keyboard","US",50,500]
[null,"2022-01-05","Monitor","US",60,600]
[null,"2022-01-06","Laptop","Germany",70,700]
[null,"2022-01-07","Mobile","Canada",80,800]
[null,"2022-01-08","Keyboard","France",90,900]
[null,"2022-01-09","Laptop","Korea",95,1000]
[]
[null,null,null,null,null,{"$f":"SUBTOTAL(2,F5:F13)","v":9}]

{"sheet":"Get Cell","index":3,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Count cells with specific Color"]
[]
[null,"Date","Product","Country","Quantity","Sales","Get",null,"Color ","Count"]
[null,"2022-01-01","Mobile","US",20,200,{"$f":"GetSpecificColor","v":36},null,null,{"$f":"COUNTIF($G$5:$G$13,36)","v":3}]
[null,"2022-01-02","Laptop","Canada",30,300,{"$f":"GetSpecificColor","v":0},null,null,{"$f":"COUNTIF($G$5:$G$13,50)","v":1}]
[null,"2022-01-03","Monitor","Germany",40,400,{"$f":"GetSpecificColor","v":0}]
[null,"2022-01-04","Keyboard","US",50,500,{"$f":"GetSpecificColor","v":36}]
[null,"2022-01-05","Monitor","US",60,600,{"$f":"GetSpecificColor","v":36}]
[null,"2022-01-06","Laptop","Germany",70,700,{"$f":"GetSpecificColor","v":0}]
[null,"2022-01-07","Mobile","Canada",80,800,{"$f":"GetSpecificColor","v":0}]
[null,"2022-01-08","Keyboard","France",90,900,{"$f":"GetSpecificColor","v":50}]
[null,"2022-01-09","Laptop","Korea",95,1000,{"$f":"GetSpecificColor","v":0}]

{"sheet":"VBA","index":4,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Count cells with specific Color"]
[]
[null,"Date","Product","Country","Quantity","Sales",null,"Color ","Count"]
[null,"2022-01-01","Mobile","US",20,200,null,null,{"$f":"MyColorCount(B5:B13,H5)","v":3}]
[null,"2022-01-02","Laptop","Canada",30,300,null,null,{"$f":"MyColorCount(B5:B13,H6)","v":1}]
[null,"2022-01-03","Monitor","Germany",40,400]
[null,"2022-01-04","Keyboard","US",50,500]
[null,"2022-01-05","Monitor","US",60,600]
[null,"2022-01-06","Laptop","Germany",70,700]
[null,"2022-01-07","Mobile","Canada",80,800]
[null,"2022-01-08","Keyboard","France",90,900]
[null,"2022-01-09","Laptop","Korea",95,1000]

{"sheet":"Practice","index":5,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Count cells with specific Color"]
[]
[null,"Date","Product","Country","Quantity","Sales"]
[null,"2022-01-01","Mobile","US",20,200]
[null,"2022-01-02","Laptop","Canada",30,300]
[null,"2022-01-03","Monitor","Germany",40,400]
[null,"2022-01-04","Keyboard","US",50,500]
[null,"2022-01-05","Monitor","US",60,600]
[null,"2022-01-06","Laptop","Germany",70,700]
[null,"2022-01-07","Mobile","Canada",80,800]
[null,"2022-01-08","Keyboard","France",90,900]
[null,"2022-01-09","Laptop","Korea",95,1000]