{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Title","Seminars","Sheet7","Wrap Up","Outtake"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":1,"defined_names":18,"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2067]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: Meditations / Pixabay"]

{"sheet":"Seminars","index":1,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"http://www.mrexcel.com/pressappearances.shtml"]

{"sheet":"Sheet7","index":2,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,96,67,71,78,null,null,null,"Score","Rating"]
[null,80,77,68,90,null,null,null,86,{"$f":"VLOOKUP(I3,$M$3:$O$5,3)","v":0},null,null,0,"Fail",-1]
[null,91,62,64,80,null,null,null,97,{"$f":"VLOOKUP(I4,$M$3:$O$5,3)","v":1},null,null,70,"Average",0]
[null,70,81,76,84,null,null,null,80,0,null,null,90,"Great",1]
[null,96,81,78,68,null,null,null,95,1]
[null,77,64,99,68,null,null,null,91,1]
[null,96,61,61,79,null,null,null,60,-1]
[null,78,80,62,63,null,null,null,97,1]
[null,61,61,91,69,null,null,null,81,0]
[null,89,65,71,95,null,null,null,74,0]
[null,91,97,74,75,null,null,null,79,0]
[null,72,79,71,95,null,null,null,70,0]
[null,74,62,83,73,null,null,null,76,0]
[null,96,66,66,69,null,null,null,87,0]
[null,67,62,91,70,null,null,null,96,1]

{"sheet":"Wrap Up","index":3,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"Can you apply Conditional Formatting Icon Sets to Text?"]
[null,"No"]
[null,"But, if you have three (or less) ratings, you can use the trick in this episode."]
[null,"Convert your text ratings to 1, 0, and -1"]
[null,"Apply the Icon set"]
[null,"Use a custom number format of \"positive\";\"negative\";\"zero\""]
[null,"This will get words to appear instead of numbers"]

{"sheet":"Outtake","index":4,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[1,{"$f":"RANDBETWEEN(1,5)","v":4},2,3,2]
[2,5,2,3,3,null,null,null,1,"Down Arrow"]
[3,5,4,4,3,null,null,null,2,"Red Diamond"]
[4,1,3,3,5,null,null,null,3,"Yellow Flag"]
[5,1,4,1,5,null,null,null,4,"Green Flag"]
[null,null,null,null,null,null,null,null,5,"Gold Star"]
[]
[null,null,null,null,null,null,null,null,"Assign to all cells:"]
[null,null,null,null,null,null,null,null,"[<2]\"Down Arrow\";[<3]\"Red Diamond\";\"Yellow Flag\""]
[]
[null,null,null,null,null,null,null,null,"Conditional Format"]
[null,null,null,null,null,null,null,null,"If >=4 then use this numeric formatting"]
[null,null,null,null,null,null,null,null,"[<5]\"Green Flag\";\"Gold Star\""]