{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Method 1","Method 2","Method 3","Method 4","Method 5","Method 6","Method 7"],"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":"Method 1","index":0,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,8,2,9]]}
[]
[]
[null,"Assigning Value if a Cell Contains Word",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Genre","Collection status",null,null,null,null,null,"Genre","Collection status"]
[null,"Mythology",{"$f":"IF(B6=\"MYTHOLOGY\",\"Collected\",\"Not Collected\")","v":"Collected"},null,null,null,null,null,"Mythological"]
[null,"Adventure",{"$f":"IF(B7=\"MYTHOLOGY\",\"Collected\",\"Not Collected\")","v":"Not Collected"},null,null,null,null,null,"Adventure"]
[null,"Detective","Not Collected",null,null,null,null,null,"Detective"]
[null,"Mythology","Collected",null,null,null,null,null,"Mythological"]
[null,"Romance","Not Collected",null,null,null,null,null,"Romance"]
[null,"Horror","Not Collected",null,null,null,null,null,"Horror"]
[null,"Mythology","Collected",null,null,null,null,null,"Mythological"]
[null,"Fiction","Not Collected",null,null,null,null,null,"Fiction"]
[null,"Mythology","Collected",null,null,null,null,null,"Mythological"]

{"sheet":"Method 2","index":1,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,8,2,9]]}
[]
[]
[null,"Assigning Value if a Cell Contains Word",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Genre","Collection status",null,null,null,null,null,"Genre","Collection status"]
[null,"Mythology",{"$f":"IF(ISTEXT(B6),\"Collected\",\"Not Found\")","v":"Collected"},null,null,null,null,null,"Mythological"]
[null,1,{"$f":"IF(ISTEXT(B7),\"Collected\",\"Not Found\")","v":"Not Found"},null,null,null,null,null,1]
[null,2,"Not Found",null,null,null,null,null,2]
[null,"Romantic","Collected",null,null,null,null,null,"Mythological"]
[null,3,"Not Found",null,null,null,null,null,3]
[null,4,"Not Found",null,null,null,null,null,4]
[null,"Detective","Collected",null,null,null,null,null,"Mythological"]
[null,7,"Not Found",null,null,null,null,null,7]
[null,"Adventure","Collected",null,null,null,null,null,"Mythological"]

{"sheet":"Method 3","index":2,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,8,2,9]]}
[]
[]
[null,"Assigning Value if a Cell Contains Word",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Books ","Genre",null,null,null,null,null,"Books ","Genre"]
[null,"Classical Mythology A to Z",{"$f":"IF(ISNUMBER(FIND(\"Mythology\",B6)),\"Mythology\",\"History\")","v":"Mythology"},null,null,null,null,null,"Classical Mythology A to Z"]
[null,"Iran: A Modern History",{"$f":"IF(ISNUMBER(FIND(\"Mythology\",B7)),\"Mythology\",\"History\")","v":"History"},null,null,null,null,null,"Iran: A Modern History"]
[null,"A History of American People","History",null,null,null,null,null,"A History of American People"]
[null,"The Library of Greek Mythology","Mythology",null,null,null,null,null,"The Library of Greek Mythology"]
[null,"The History of the Ancient World","History",null,null,null,null,null,"The History of the Ancient World"]
[null,"Mythology: Timeless Tales of Gods and Heroes","Mythology",null,null,null,null,null,"Mythology: Timeless Tales of Gods and Heroes"]
[null,"The Crusades: The Authoritative History of the War for the Holy Land","History",null,null,null,null,null,"The Crusades: The Authoritative History of the War for the Holy Land"]
[null,"The Mythology Book","Mythology",null,null,null,null,null,"The Mythology Book"]
[null,"SPQR: A History of Ancient Rome","History",null,null,null,null,null,"SPQR: A History of Ancient Rome"]
[null,"Norse Mythology","Mythology",null,null,null,null,null,"Norse Mythology"]

{"sheet":"Method 4","index":3,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,8,2,9]]}
[]
[]
[null,"Assigning Value if a Cell Contains Word",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Books ","Genre",null,null,null,null,null,"Books ","Genre"]
[null,"Classical Mythology A to Z",{"$f":"IF(ISERROR(SEARCH(\"mythology\",B6)),\"History\",\"Mythology\")","v":"Mythology"},null,null,null,null,null,"Classical Mythology A to Z"]
[null,"Iran: A Modern History",{"$f":"IF(ISERROR(SEARCH(\"mythology\",B7)),\"History\",\"Mythology\")","v":"History"},null,null,null,null,null,"Iran: A Modern History"]
[null,"A History of American People","History",null,null,null,null,null,"A History of American People"]
[null,"The Library of Greek Mythology","Mythology",null,null,null,null,null,"The Library of Greek Mythology"]
[null,"The History of the Ancient World","History",null,null,null,null,null,"The History of the Ancient World"]
[null,"Mythology: Timeless Tales of Gods and Heroes","Mythology",null,null,null,null,null,"Mythology: Timeless Tales of Gods and Heroes"]
[null,"The Crusades: The Authoritative History of the War for the Holy Land","History",null,null,null,null,null,"The Crusades: The Authoritative History of the War for the Holy Land"]
[null,"The Mythology Book","Mythology",null,null,null,null,null,"The Mythology Book"]
[null,"SPQR: A History of Ancient Rome","History",null,null,null,null,null,"SPQR: A History of Ancient Rome"]
[null,"Norse Mythology","Mythology",null,null,null,null,null,"Norse Mythology"]

{"sheet":"Method 5","index":4,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,8,2,9]]}
[]
[]
[null,"Assigning Value if a Cell Contains Word",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Books ","Settings",null,null,null,null,null,"Books ","Settings"]
[null,"Norse Mythology",{"$f":"IF(COUNTIF(B6,\"*Egypt*\"),\"Egypt\",\"Norse\")","v":"Norse"},null,null,null,null,null,"Norse Mythology"]
[null,"Tales of Ancient Egypt",{"$f":"IF(COUNTIF(B7,\"*Egypt*\"),\"Egypt\",\"Norse\")","v":"Egypt"},null,null,null,null,null,"Tales of Ancient Egypt"]
[null,"The Mind of Egypt: \nHistory And Meaning in The Time of The Pharaohs","Egypt",null,null,null,null,null,"The Mind of Egypt: \nHistory And Meaning in The Time of The Pharaohs"]
[null,"Penguin book of the Norse myths","Norse",null,null,null,null,null,"Penguin book of the Norse myths"]
[null,"Egyptian Book of The Dead","Egypt",null,null,null,null,null,"Egyptian Book of The Dead"]
[null,"Gods and Myths of Northern Europe","Norse",null,null,null,null,null,"Gods and Myths of Northern Europe"]
[null,"Egyptology","Egypt",null,null,null,null,null,"Egyptology"]

{"sheet":"Method 6","index":5,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,8,2,9]]}
[]
[]
[null,"Assigning Value if a Cell Contains Word",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Genre","Collection status",null,null,null,null,null,"Genre","Collection status"]
[null,"Mythology",{"$f":"IFERROR(IF(VLOOKUP($B$6,$B6,1,TRUE)=\"Mythology\",\n\"Collected\",\"Not Collected\"),\"Not Found\")","v":"Collected"},null,null,null,null,null,"Mythology"]
[null,"Adventure",{"$f":"IFERROR(IF(VLOOKUP($B$6,$B7,1,TRUE)=\"Mythology\",\n\"Collected\",\"Not Collected\"),\"Not Found\")","v":"Not Collected"},null,null,null,null,null,"Adventure"]
[null,"Detective","Not Collected",null,null,null,null,null,"Detective"]
[null,null,"Not Found"]
[null,"Mythology","Collected",null,null,null,null,null,"Mythology"]
[null,"Action","Not Collected",null,null,null,null,null,"Action"]
[null,"Horror","Not Collected",null,null,null,null,null,"Horror"]
[null,"Mythology","Collected",null,null,null,null,null,"Mythology"]
[null,"Fiction","Not Collected",null,null,null,null,null,"Fiction"]
[null,"Mythology","Collected",null,null,null,null,null,"Mythology"]
[null,null,"Not Found"]

{"sheet":"Method 7","index":6,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,7,2,8]]}
[]
[]
[null,"Assigning Value if a Cell Contains Word",null,null,null,null,null,"Assigning Value if a Cell Contains Word"]
[]
[null,"Books ","Settings",null,null,null,null,"Books ","Settings"]
[null,"Norse Mythology","Norse",null,null,null,null,"Norse Mythology"]
[null,"Tales of Ancient Egypt","Egypt",null,null,null,null,"Tales of Ancient Egypt"]
[null,"The Mind of Egypt: \nHistory And Meaning in The Time of The Pharaohs","Egypt",null,null,null,null,"The Mind of Egypt: \nHistory And Meaning in The Time of The Pharaohs"]
[null,"Penguin book of the Norse myths","Norse",null,null,null,null,"Penguin book of the Norse myths"]
[null,"Egyptian Book of The Dead","Egypt",null,null,null,null,"Egyptian Book of The Dead"]
[null,"Gods and Myths of Northern Europe","Norse",null,null,null,null,"Gods and Myths of Northern Europe"]
[null,"Egyptology","Egypt",null,null,null,null,"Egyptology"]