{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Overview","Color Code","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Overview","index":0,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Overview of Dataset"]
[]
[null,"Name","Region","Color Code","Rev Earned"]
[null,"Rozar","Alaska",40,53759]
[null,"Philip","California",6,70836]
[null,"Michel","Florida",14,40110]
[null,"David","Iowa",15,51893]
[null,"James","Maryland",40,49281]
[null,"Keat","Mississippi",14,40877]
[null,"Alan","Nevada",6,48262]
[null,"Jennifer","New York",48,77721]
[null,"Alex","New Jersey",14,78998]
[null,"Miller","Ohio",3,42821]
[null,"Antonio","Texas",15,76146]

{"sheet":"Color Code","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Color Code to Filter by Multiple Colors"]
[]
[null,"Name","Region","Color Code","Rev Earned"]
[null,"Rozar","Alaska",40,53759]
[null,"Miller","Ohio",3,42821]
[null,"Michel","Florida",14,40110]
[null,"David","Iowa",15,51893]
[null,"James","Maryland",40,49281]
[null,"Keat","Mississippi",14,40877]
[null,"Alex","New Jersey",14,78998]
[null,"Jennifer","New York",48,77721]
[null,"Philip","California",6,70836]
[null,"Alan","Nevada",6,48262]
[null,"Antonio","Texas",15,76146]

{"sheet":"VBA","index":2,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Application of VBA Code"]
[]
[null,"Name","Region","Rev Earned","Color Index"]
[null,"Rozar","Alaska",53759,{"$f":"FindColor(D5)","v":6}]
[null,"Philip","California",70836,{"$f":"FindColor(D6)","v":40}]
[null,"Michel","Florida",40110,{"$f":"FindColor(D7)","v":15}]
[null,"David","Iowa",51893,{"$f":"FindColor(D8)","v":14}]
[null,"James","Maryland",49281,{"$f":"FindColor(D9)","v":37}]
[null,"Keat","Mississippi",40877,{"$f":"FindColor(D10)","v":6}]
[null,"Alan","Nevada",48262,{"$f":"FindColor(D11)","v":3}]
[null,"Jennifer","New York",77721,{"$f":"FindColor(D12)","v":15}]
[null,"Alex","New Jersey",78998,{"$f":"FindColor(D13)","v":48}]
[null,"Miller","Ohio",42821,{"$f":"FindColor(D14)","v":37}]
[null,"Antonio","Texas",76146,{"$f":"FindColor(D15)","v":14}]