{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data","Find and Replace","Nested IF Formula","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Data","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset Overview"]
[]
[null,"Gender","Do You Watch Movies?","What Type of Movies Do You like?"]
[null,"Female","Yes","Thriller"]
[null,"Male","No","Comedy"]
[null,"Male","Yes","Sci-Fi"]
[null,"Female","Occasionally","Sci-Fi"]
[null,"Male","Yes","Comedy"]
[null,"Female","No","Comedy"]

{"sheet":"Find and Replace","index":1,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Use of Find and Replace Options",null,null,null,null,"Practice Yourself"]
[]
[null,"Gender","Do You Watch Movies?","What Type of Movies Do You like?",null,null,"Gender","Do You Watch Movies?","What Type of Movies Do You like?"]
[null,"Female","Yes","Thriller",null,null,"Female","Yes","Thriller"]
[null,"Male","No","Comedy",null,null,"Male","No","Comedy"]
[null,"Male","Yes","Sci-Fi",null,null,"Male","Yes","Sci-Fi"]
[null,"Female","Occasionally","Sci-Fi",null,null,"Female","Occasionally","Sci-Fi"]
[null,"Male","Yes","Comedy",null,null,"Male","Yes","Comedy"]
[null,"Female","No","Comedy",null,null,"Female","No","Comedy"]

{"sheet":"Nested IF Formula","index":2,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Use of Nested IF Formula",null,null,null,null,"Use of Nested IF Formula"]
[]
[null,"Gender","Do You Watch Movies?","What Type of Movies Do You like?",null,null,"Gender","Do You Watch Movies?","What Type of Movies Do You like?"]
[null,"Female","Yes","Thriller",null,null,"Female",{"$f":"IF(C5=\"Yes\",1,IF(C5=\"NO\",2,IF(C5=\"Occasionally\",3,0)))","v":1},{"$f":"IF(D5=\"Thriller\",4,IF(D5=\"Comedy\",5,IF(D5=\"Sci-Fi\",6,0)))","v":4}]
[null,"Male","No","Comedy",null,null,"Male",{"$f":"IF(C6=\"Yes\",1,IF(C6=\"NO\",2,IF(C6=\"Occasionally\",3,0)))","v":2},{"$f":"IF(D6=\"Thriller\",4,IF(D6=\"Comedy\",5,IF(D6=\"Sci-Fi\",6,0)))","v":5}]
[null,"Male","Yes","Sci-Fi",null,null,"Male",1,6]
[null,"Female","Occasionally","Sci-Fi",null,null,"Female",3,6]
[null,"Male","Yes","Comedy",null,null,"Male",1,5]
[null,"Female","No","Comedy",null,null,"Female",2,5]

{"sheet":"VBA","index":3,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Use of VBA Code",null,null,null,null,"Practice Yourself"]
[]
[null,"Gender","Do You Watch Movies?","What Type of Movies Do You like?",null,null,"Gender","Do You Watch Movies?","What Type of Movies Do You like?"]
[null,"Female","Yes","Thriller",null,null,"Female","Yes","Thriller"]
[null,"Male","No","Comedy",null,null,"Male","No","Comedy"]
[null,"Male","Yes","Sci-Fi",null,null,"Male","Yes","Sci-Fi"]
[null,"Female","Occasionally","Sci-Fi",null,null,"Female","Occasionally","Sci-Fi"]
[null,"Male","Yes","Comedy",null,null,"Male","Yes","Comedy"]
[null,"Female","No","Comedy",null,null,"Female","No","Comedy"]