{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Find & Select","GetCell","Filter & Subtotal","VBA"],"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":"Find & Select","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sample Data"]
[]
[null,"Product Name","Category"]
[null,"Apple","Fruit"]
[null,"Rose","Flower"]
[null,"Burger","Food"]
[null,"Banana","Fruit"]
[null,"Orange","Fruit"]
[null,"Lily","Flower"]
[null,"Lotus","Flower"]
[null,"Chicken Fry","Food"]
[null,"Lemon","Fruit"]
[null,"Dahlia","Flower"]
[null,"Pasta","Food"]
[null,"Daisy","Flower"]

{"sheet":"GetCell","index":1,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,6,3,7],[1,1,1,7]]}
[]
[null,"Utilizing Get.Cell"]
[]
[null,"Product Name","Category",null,"Get Color Code",null,"Color Count"]
[null,"Apple","Fruit",null,{"$f":"GetColorCode","v":42},null,null,{"$f":"COUNTIF($E$5:$E$16,GetColorCode)","v":4}]
[null,"Rose","Flower",null,{"$f":"GetColorCode","v":46},null,null,{"$f":"COUNTIF($E$5:$E$16,GetColorCode)","v":5}]
[null,"Burger","Food",null,{"$f":"GetColorCode","v":0}]
[null,"Banana","Fruit",null,{"$f":"GetColorCode","v":42}]
[null,"Orange","Fruit",null,{"$f":"GetColorCode","v":42}]
[null,"Lily","Flower",null,{"$f":"GetColorCode","v":46}]
[null,"Lotus","Flower",null,{"$f":"GetColorCode","v":46}]
[null,"Chicken Fry","Food",null,{"$f":"GetColorCode","v":0}]
[null,"Lemon","Fruit",null,{"$f":"GetColorCode","v":42}]
[null,"Dahlia","Flower",null,{"$f":"GetColorCode","v":46}]
[null,"Pasta","Food",null,{"$f":"GetColorCode","v":0}]
[null,"Daisy","Flower",null,{"$f":"GetColorCode","v":46}]

{"sheet":"Filter & Subtotal","index":2,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying Filter And SUBTOTAL"]
[]
[null,"Product ID","Product Name","Category"]
[null,101,"Apple","Fruit"]
[null,102,"Rose","Flower"]
[null,103,"Burger","Food"]
[null,104,"Banana","Fruit"]
[null,105,"Orange","Fruit"]
[null,106,"Lily","Flower"]
[null,107,"Lotus","Flower"]
[null,108,"Chicken Fry","Food"]
[null,109,"Lemon","Fruit"]
[null,110,"Dahlia","Flower"]
[null,111,"Pasta","Food"]
[null,112,"Daisy","Flower"]
[]
[null,"Count",{"$f":"SUBTOTAL(102,B5:B16)","v":12}]

{"sheet":"VBA","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,4,3,5],[1,1,1,5]]}
[]
[null,"Implenting VBA Code"]
[]
[null,"Product Name","Category",null,"Color Count"]
[null,"Apple","Fruit",null,null,{"$f":"Count_Colored_Cells(E5,$B$5:$B$16)","v":4}]
[null,"Rose","Flower",null,null,{"$f":"Count_Colored_Cells(E6,$B$5:$B$16)","v":5}]
[null,"Burger","Food"]
[null,"Banana","Fruit"]
[null,"Orange","Fruit"]
[null,"Lily","Flower"]
[null,"Lotus","Flower"]
[null,"Chicken Fry","Food"]
[null,"Lemon","Fruit"]
[null,"Dahlia","Flower"]
[null,"Pasta","Food"]
[null,"Daisy","Flower"]