{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Find and Replace","Table Format","COLORED"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"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 and Replace","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Count Colored Cells Using Find and Replace"]
[]
[null,"Name","Country"]
[null,"Amy","Canada"]
[null,"John","Sweden"]
[null,"Lisa","United States"]
[null,"Adam","Italy"]
[null,"Cathy","United States"]
[null,"Ted","Sweden"]
[null,"David","Italy"]
[null,"Lucy","Sweden"]
[null,"Bill","United States"]
[null,"Nathan","Canada"]

{"sheet":"Table Format","index":1,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Count Colored Cells Using Table Format"]
[]
[null,"Name","Country"]
[null,"Amy","Canada"]
[null,"John","Sweden"]
[null,"Lisa","United States"]
[null,"Adam","Italy"]
[null,"Cathy","United States"]
[null,"Ted","Sweden"]
[null,"David","Italy"]
[null,"Lucy","Sweden"]
[null,"Bill","United States"]
[null,"Nathan","Canada"]
[null,"Total",{"$f":"SUBTOTAL(103,Table1[Country])","v":3}]

{"sheet":"COLORED","index":2,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Count Colored Cells Using Name Manager"]
[]
[null,"Name","Country","Color Code"]
[null,"Amy","Canada",{"$f":"COLOREDCELL","v":3}]
[null,"John","Sweden",{"$f":"COLOREDCELL","v":44}]
[null,"Lisa","United States",{"$f":"COLOREDCELL","v":23},null,"Canada",{"$f":"COUNTIF($D$5:$D$14,COLOREDCELL)","v":2}]
[null,"Adam","Italy",{"$f":"COLOREDCELL","v":10},null,"Sweden",{"$f":"COUNTIF($D$5:$D$14,COLOREDCELL)","v":3}]
[null,"Cathy","United States",{"$f":"COLOREDCELL","v":23},null,"United States",{"$f":"COUNTIF($D$5:$D$14,COLOREDCELL)","v":3}]
[null,"Ted","Sweden",{"$f":"COLOREDCELL","v":44},null,"Italy",{"$f":"COUNTIF($D$5:$D$14,COLOREDCELL)","v":2}]
[null,"David","Italy",{"$f":"COLOREDCELL","v":10}]
[null,"Lucy","Sweden",{"$f":"COLOREDCELL","v":44}]
[null,"Bill","United States",{"$f":"COLOREDCELL","v":23}]
[null,"Nathan","Canada",{"$f":"COLOREDCELL","v":3}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"s"]