{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Datasheet","Method 1","Method 2","Method 3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":"Datasheet","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Counting Blank Coloured Cells"]
[]
[null,"Delivered Items","January","February","March"]
[null,"Smartphones"]
[null,"Airpods"]
[null,"Headphones"]
[null,"Smartwatches"]
[null,"VR Goggles"]
[null,"Keyboards"]
[null,"Bluetooth Speakers"]
[null,"Mouse"]
[null,"Action Cameras"]

{"sheet":"Method 1","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Counting Blank Coloured Cells"]
[]
[null,"Delivered Items","January","February","March"]
[null,"Smartphones"]
[null,"Airpods"]
[null,"Headphones"]
[null,"Smartwatches"]
[null,"VR Goggles"]
[null,"Keyboards"]
[null,"Bluetooth Speakers"]
[null,"Mouse"]
[null,"Action Cameras"]

{"sheet":"Method 2","index":2,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,1,2,7],[4,5,4,7]]}
[]
[]
[null,"Counting Blank Coloured Cells"]
[]
[null,"Delivered Items","January","February","March","Color Codes"]
[null,"Smartphones",null,null,null,{"$f":"NumColor","v":53},{"$f":"NumColor","v":23},{"$f":"NumColor","v":10}]
[null,"Airpods",null,null,null,{"$f":"NumColor","v":10},{"$f":"NumColor","v":29},{"$f":"NumColor","v":53}]
[null,"Headphones",null,null,null,{"$f":"NumColor","v":29},{"$f":"NumColor","v":53},{"$f":"NumColor","v":10}]
[null,"Smartwatches",null,null,null,{"$f":"NumColor","v":23},{"$f":"NumColor","v":29},{"$f":"NumColor","v":29}]
[null,"VR Goggles",null,null,null,{"$f":"NumColor","v":53},{"$f":"NumColor","v":10},{"$f":"NumColor","v":23}]
[null,"Keyboards",null,null,null,{"$f":"NumColor","v":46},{"$f":"NumColor","v":29},{"$f":"NumColor","v":53}]
[null,"Bluetooth Speakers",null,null,null,{"$f":"NumColor","v":23},{"$f":"NumColor","v":53},{"$f":"NumColor","v":29}]
[null,"Mouse",null,null,null,{"$f":"NumColor","v":10},{"$f":"NumColor","v":29},{"$f":"NumColor","v":10}]
[null,"Action Cameras",null,null,null,{"$f":"NumColor","v":46},{"$f":"NumColor","v":23},{"$f":"NumColor","v":53}]
[]
[null,null,{"$f":"COUNTIF($F$6:$H$14,53)","v":7}]
[null,null,{"$f":"COUNTIF($F$6:$H$14,10)","v":6}]
[null,null,{"$f":"COUNTIF($F$6:$H$14,23)","v":5}]
[null,null,{"$f":"COUNTIF($F$6:$H$14,29)","v":7}]
[null,null,{"$f":"COUNTIF($F$6:$H$14,46)","v":2}]

{"sheet":"Method 3","index":3,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Counting Blank Coloured Cells"]
[]
[null,"Delivered Items","January","February","March"]
[null,"Smartphones"]
[null,"Airpods"]
[null,"Headphones"]
[null,"Smartwatches"]
[null,"VR Goggles"]
[null,"Keyboards"]
[null,"Bluetooth Speakers"]
[null,"Mouse"]
[null,"Action Cameras"]
[]
[null,null,{"$f":"CountBlankColoredCell($C$6:$E$14,C6)","v":7}]
[null,null,{"$f":"CountBlankColoredCell($C$6:$E$14,C7)","v":6}]
[null,null,{"$f":"CountBlankColoredCell($C$6:$E$14,D6)","v":5}]
[null,null,{"$f":"CountBlankColoredCell($C$6:$E$14,C8)","v":7}]
[null,null,{"$f":"CountBlankColoredCell($C$6:$E$14,C11)","v":2}]