{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Fill Color","Font Color","Count by Row","Conditional Formatting Color"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Fill Color","index":0,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,8,1,13]]}
[]
[null,"Counting Cells by Fill Color",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Physics","Chemistry",null,"Color","Count",null,"Name","Physics","Chemistry",null,"Color","Count"]
[null,"Ron",37,87,null,null,{"$f":"CountCellBy_FillColor($C$5:$D$11,F5)","v":6},null,"Ron",37,87]
[null,"Sam",88,48,null,null,null,null,"Sam",88,48]
[null,"Bob",79,85,null,null,null,null,"Bob",79,85]
[null,"Emma",76,44,null,null,null,null,"Emma",76,44]
[null,"Sara",82,72,null,null,null,null,"Sara",82,72]
[null,"Ron",39,93,null,null,null,null,"Ron",39,93]
[null,"Tim",95,69,null,null,null,null,"Tim",95,69]

{"sheet":"Font Color","index":1,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,8,1,13]]}
[]
[null,"Counting Cells by Font Color",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Physics","Chemistry",null,"Color","Count",null,"Name","Physics","Chemistry",null,"Color","Count"]
[null,"Ron",37,87,null,"Red",{"$f":"CountCellsBy_FontColor($C$5:$D$11,F5)","v":4},null,"Ron",37,87,null,"Green"]
[null,"Sam",88,48,null,null,null,null,"Sam",88,48,null,"Red"]
[null,"Bob",79,85,null,null,null,null,"Bob",79,85]
[null,"Emma",76,44,null,null,null,null,"Emma",76,44]
[null,"Sara",82,72,null,null,null,null,"Sara",82,72]
[null,"Ron",39,93,null,null,null,null,"Ron",39,93]
[null,"Tim",95,69,null,null,null,null,"Tim",95,69]

{"sheet":"Count by Row","index":2,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"Counting Colored Cells by Row",null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Physics","Chemistry","Mathematics","Output",null,"Name","Physics","Chemistry","Mathematics","Output"]
[null,"Ron",37,87,83,{"$f":"Colorby_Row(C5,D5,E5)","v":"1"},null,"Ron",37,87,83]
[null,"Sam",89,48,45,{"$f":"Colorby_Row(C6,D6,E6)","v":"0"},null,"Sam",89,48,45]
[null,"Bob",88,85,88,{"$f":"Colorby_Row(C7,D7,E7)","v":"1"},null,"Bob",88,85,88]
[null,"Emma",76,44,33,{"$f":"Colorby_Row(C8,D8,E8)","v":"0"},null,"Emma",76,44,33]
[null,"Sara",82,72,75,{"$f":"Colorby_Row(C9,D9,E9)","v":"0"},null,"Sara",82,72,75]
[null,"Ron",39,39,38,{"$f":"Colorby_Row(C10,D10,E10)","v":"0"},null,"Ron",39,39,38]
[null,"Tim",95,69,95,{"$f":"Colorby_Row(C11,D11,E11)","v":"1"},null,"Tim",95,69,95]

{"sheet":"Conditional Formatting Color","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Counting and Summing by Conditional Formatting Color"]
[]
[null,"Name","Physics","Chemistry"]
[null,"Ron",37,87]
[null,"Sam",88,48]
[null,"Bob",79,85]
[null,"Emma",76,44]
[null,"Sara",82,72]
[null,"Ron",39,93]
[null,"Tim",95,69]