{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["dataset","conditional formatting","vba","diy"],"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":"dataset","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Conditional Formatting Icon Set"]
[]
[null,"Name","Performance"]
[null,"Jon","Very Good"]
[null,"David","Excellent"]
[null,"Carl","Good"]
[null,"Boyd","Very Good"]
[null,"Timothy","Satisfactory"]
[null,"Raylan","Bad"]
[null,"Alberto","Good"]
[null,"Jason","Very Good"]
[null,"Ben","Excellent"]

{"sheet":"conditional formatting","index":1,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using Conditional Formatting Rule"]
[]
[null,"Name","Performance","Rating",null,"Performance","Helper Value"]
[null,"Jon","Very Good",{"$f":"VLOOKUP(C5,$F$5:$G$9,2,FALSE)","v":4},null,"Excellent",5]
[null,"David","Excellent",{"$f":"VLOOKUP(C6,$F$5:$G$9,2,FALSE)","v":5},null,"Very Good",4]
[null,"Carl","Good",3,null,"Good",3]
[null,"Boyd","Very Good",4,null,"Satisfactory",2]
[null,"Timothy","Satisfactory",2,null,"Bad",1]
[null,"Raylan","Bad",1]
[null,"Alberto","Good",3]
[null,"Jason","Very Good",4]
[null,"Ben","Excellent",5]

{"sheet":"vba","index":2,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using VBA"]
[]
[null,"Name","Performance","Rating",null,"Performance","Helper Value"]
[null,"Jon","Very Good",{"$f":"VLOOKUP(C5,$F$5:$G$9,2,FALSE)","v":4},null,"Excellent",5]
[null,"David","Excellent",{"$f":"VLOOKUP(C6,$F$5:$G$9,2,FALSE)","v":5},null,"Very Good",4]
[null,"Carl","Good",3,null,"Good",3]
[null,"Boyd","Very Good",4,null,"Satisfactory",2]
[null,"Timothy","Satisfactory",2,null,"Bad",1]
[null,"Raylan","Bad",1]
[null,"Alberto","Good",3]
[null,"Jason","Very Good",4]
[null,"Ben","Excellent",5]

{"sheet":"diy","index":3,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Do  It Yourself"]
[]
[null,"Name","Performance"]
[null,"Jon","Very Good"]
[null,"David","Excellent"]
[null,"Carl","Good"]
[null,"Boyd","Very Good"]
[null,"Timothy","Satisfactory"]
[null,"Raylan","Bad"]
[null,"Alberto","Good"]
[null,"Jason","Very Good"]
[null,"Ben","Excellent"]