{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Data Validation","Combined Functions","Combo Box","Unique Region","Filter","Text Box","Conditional Formatting"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Create a Filtering Search Box"]
[]
[null,"Customer Name","Region","Product"]
[null,"Rose","Manitoba","Perfume"]
[null,"Lily","Alberta","Watch"]
[null,"Bruce","British Columbia","Ring"]
[null,"Pitter","Ontario","Perfume"]
[null,"Harry","Manitoba","Bracelet"]
[null,"Jack","Ontario","Ring"]
[null,"Sirius","Alberta","Watch"]
[null,"James","Ontario","Perfume"]
[null,"Michel","Alberta","Watch"]

{"sheet":"Data Validation","index":1,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Applying Data Validation",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Customer Name","Region","Product",null,null,null,null,null,"Customer Name","Region","Product"]
[null,"Rose","Manitoba","Perfume",null,null,null,null,null,"Rose","Manitoba","Perfume"]
[null,"Lily","Alberta","Watch",null,null,null,null,null,"Lily","Alberta","Watch"]
[null,"Bruce","British Columbia","Ring",null,null,null,null,null,"Bruce","British Columbia","Ring"]
[null,"Pitter","Ontario","Perfume",null,null,null,null,null,"Pitter","Ontario","Perfume"]
[null,"Harry","Manitoba","Bracelet",null,null,null,null,null,"Harry","Manitoba","Bracelet"]
[null,"Jack","Ontario","Ring",null,null,null,null,null,"Jack","Ontario","Ring"]
[null,"Sirius","Alberta","Watch",null,null,null,null,null,"Sirius","Alberta","Watch"]
[null,"James","Ontario","Perfume",null,null,null,null,null,"James","Ontario","Perfume"]
[null,"Michel","Alberta","Watch",null,null,null,null,null,"Michel","Alberta","Watch"]
[]
[null,"Filtering Search Box","Manitoba"]

{"sheet":"Combined Functions","index":2,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,11]]}
[]
[null,"Use of Combined Functions",null,null,"Filtering Search Box","Alberta",null,null,null,"Do It Yourself"]
[]
[null,"Customer Name","Region",null,"Customer Name","Region",null,null,null,"Customer Name","Region","Product"]
[null,"Rose","Manitoba",null,{"$f":"_xlfn._xlws.FILTER(Salesinfo[],LEFT(Salesinfo[Region],LEN(F2))=F2,\"No Region Found\")","v":"Lily"},"Alberta",null,null,null,"Rose","Manitoba","Perfume"]
[null,"Lily","Alberta",null,"Sirius","Alberta",null,null,null,"Lily","Alberta","Watch"]
[null,"Bruce","British Columbia",null,"Michel","Alberta",null,null,null,"Bruce","British Columbia","Ring"]
[null,"Pitter","Ontario",null,null,null,null,null,null,"Pitter","Ontario","Perfume"]
[null,"Harry","Manitoba",null,null,null,null,null,null,"Harry","Manitoba","Bracelet"]
[null,"Jack","Ontario",null,null,null,null,null,null,"Jack","Ontario","Ring"]
[null,"Sirius","Alberta",null,null,null,null,null,null,"Sirius","Alberta","Watch"]
[null,"James","Ontario",null,null,null,null,null,null,"James","Ontario","Perfume"]
[null,"Michel","Alberta",null,null,null,null,null,null,"Michel","Alberta","Watch"]

{"sheet":"Combo Box","index":3,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,9,1,11]]}
[]
[null,"Applying Combo Box Feature",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Customer Name","Region","Helper 1","Helper 2","Helper 3",null,null,null,"Customer Name","Region","Product"]
[null,"Rose","Manitoba",{"$f":"ROW(D1)","v":1},{"$f":"IF(ISNUMBER(SEARCH($D$15,$C5)),D5,\"\")","v":""},{"$f":"IFERROR(SMALL($E$5:$E$13,ROWS($E$5:E5)),\" \")","v":4},null,null,null,"Rose","Manitoba","Perfume"]
[null,"Lily","Alberta",{"$f":"ROW(D2)","v":2},{"$f":"IF(ISNUMBER(SEARCH($D$15,$C6)),D6,\"\")","v":""},{"$f":"IFERROR(SMALL($E$5:$E$13,ROWS($E$5:E6)),\" \")","v":6},null,null,null,"Lily","Alberta","Watch"]
[null,"Bruce","British Columbia",3,"",{"$f":"IFERROR(SMALL($E$5:$E$13,ROWS($E$5:E7)),\" \")","v":8},null,null,null,"Bruce","British Columbia","Ring"]
[null,"Pitter","Ontario",4,4,{"$f":"IFERROR(SMALL($E$5:$E$13,ROWS($E$5:E8)),\" \")","v":" "},null,null,null,"Pitter","Ontario","Perfume"]
[null,"Harry","Manitoba",5,"",{"$f":"IFERROR(SMALL($E$5:$E$13,ROWS($E$5:E9)),\" \")","v":" "},null,null,null,"Harry","Manitoba","Bracelet"]
[null,"Jack","Ontario",6,6,{"$f":"IFERROR(SMALL($E$5:$E$13,ROWS($E$5:E10)),\" \")","v":" "},null,null,null,"Jack","Ontario","Ring"]
[null,"Sirius","Alberta",7,"",{"$f":"IFERROR(SMALL($E$5:$E$13,ROWS($E$5:E11)),\" \")","v":" "},null,null,null,"Sirius","Alberta","Watch"]
[null,"James","Ontario",8,8,{"$f":"IFERROR(SMALL($E$5:$E$13,ROWS($E$5:E12)),\" \")","v":" "},null,null,null,"James","Ontario","Perfume"]
[null,"Michel","Alberta",9,"",{"$f":"IFERROR(SMALL($E$5:$E$13,ROWS($E$5:E13)),\" \")","v":" "},null,null,null,"Michel","Alberta","Watch"]
[]
[null,"Filtering Search Box",null,"Ontario"]
[null,"Customer Name","Region"]
[null,{"$f":"IFERROR(INDEX($B$5:$C$13,$F5,COLUMNS($B$17:B17)),\"\")","v":"Pitter"},{"$f":"IFERROR(INDEX($B$5:$C$13,$F5,COLUMNS($B$17:C17)),\"\")","v":"Ontario"}]
[null,{"$f":"IFERROR(INDEX($B$5:$C$13,$F6,COLUMNS($B$17:B18)),\"\")","v":"Jack"},{"$f":"IFERROR(INDEX($B$5:$C$13,$F6,COLUMNS($B$17:C18)),\"\")","v":"Ontario"}]
[null,{"$f":"IFERROR(INDEX($B$5:$C$13,$F7,COLUMNS($B$17:B19)),\"\")","v":"James"},{"$f":"IFERROR(INDEX($B$5:$C$13,$F7,COLUMNS($B$17:C19)),\"\")","v":"Ontario"}]
[null,{"$f":"IFERROR(INDEX($B$5:$C$13,$F8,COLUMNS($B$17:B20)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$C$13,$F8,COLUMNS($B$17:C20)),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX($B$5:$C$13,$F9,COLUMNS($B$17:B21)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$C$13,$F9,COLUMNS($B$17:C21)),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX($B$5:$C$13,$F10,COLUMNS($B$17:B22)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$C$13,$F10,COLUMNS($B$17:C22)),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX($B$5:$C$13,$F11,COLUMNS($B$17:B23)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$C$13,$F11,COLUMNS($B$17:C23)),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX($B$5:$C$13,$F12,COLUMNS($B$17:B24)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$C$13,$F12,COLUMNS($B$17:C24)),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX($B$5:$C$13,$F13,COLUMNS($B$17:B25)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$C$13,$F13,COLUMNS($B$17:C25)),\"\")","v":""}]

{"sheet":"Unique Region","index":4,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Unique Region"]
[null,"Manitoba"]
[null,"Alberta"]
[null,"British Columbia"]
[null,"Ontario"]

{"sheet":"Filter","index":5,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using Filter Feature",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Customer Name","Region","Product",null,null,null,null,null,"Customer Name","Region","Product"]
[null,"Rose","Manitoba","Perfume",null,null,null,null,null,"Rose","Manitoba","Perfume"]
[null,"Lily","Alberta","Watch",null,null,null,null,null,"Lily","Alberta","Watch"]
[null,"Bruce","British Columbia","Ring",null,null,null,null,null,"Bruce","British Columbia","Ring"]
[null,"Pitter","Ontario","Perfume",null,null,null,null,null,"Pitter","Ontario","Perfume"]
[null,"Harry","Manitoba","Bracelet",null,null,null,null,null,"Harry","Manitoba","Bracelet"]
[null,"Jack","Ontario","Ring",null,null,null,null,null,"Jack","Ontario","Ring"]
[null,"Sirius","Alberta","Watch",null,null,null,null,null,"Sirius","Alberta","Watch"]
[null,"James","Ontario","Perfume",null,null,null,null,null,"James","Ontario","Perfume"]
[null,"Michel","Alberta","Watch",null,null,null,null,null,"Michel","Alberta","Watch"]

{"sheet":"Text Box","index":6,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,3],[16,1,16,3]]}
[]
[null,"Use of Text Box Feature",null,null,null,""]
[]
[null,"Customer Name","Region","Product"]
[null,"Rose","Manitoba","Perfume"]
[null,"Lily","Alberta","Watch"]
[null,"Bruce","British Columbia","Ring"]
[null,"Pitter","Ontario","Perfume"]
[null,"Harry","Manitoba","Bracelet"]
[null,"Jack","Ontario","Ring"]
[null,"Sirius","Alberta","Watch"]
[null,"James","Ontario","Perfume"]
[null,"Michel","Alberta","Watch"]
[]
[null,"Filtering Search Box","Wa"]
[]
[null,"Do It Yourself"]
[]
[null,"Customer Name","Region","Product"]
[null,"Rose","Manitoba","Perfume"]
[null,"Lily","Alberta","Watch"]
[null,"Bruce","British Columbia","Ring"]
[null,"Pitter","Ontario","Perfume"]
[null,"Harry","Manitoba","Bracelet"]
[null,"Jack","Ontario","Ring"]
[null,"Sirius","Alberta","Watch"]
[null,"James","Ontario","Perfume"]
[null,"Michel","Alberta","Watch"]

{"sheet":"Conditional Formatting","index":7,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11],[4,5,4,6]]}
[]
[null,"Employing Conditional Formatting",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Customer Name","Region","Product",null,null,null,null,null,"Customer Name","Region","Product"]
[null,"Rose","Manitoba","Perfume",null,"Filtering Search Box",null,null,null,"Rose","Manitoba","Perfume"]
[null,"Lily","Alberta","Watch",null,"Region","Alberta",null,null,"Lily","Alberta","Watch"]
[null,"Bruce","British Columbia","Ring",null,"Product","Watch",null,null,"Bruce","British Columbia","Ring"]
[null,"Pitter","Ontario","Perfume",null,null,null,null,null,"Pitter","Ontario","Perfume"]
[null,"Harry","Manitoba","Bracelet",null,null,null,null,null,"Harry","Manitoba","Bracelet"]
[null,"Jack","Ontario","Ring",null,null,null,null,null,"Jack","Ontario","Ring"]
[null,"Sirius","Alberta","Watch",null,null,null,null,null,"Sirius","Alberta","Watch"]
[null,"James","Ontario","Perfume",null,null,null,null,null,"James","Ontario","Perfume"]
[null,"Michel","Alberta","Watch",null,null,null,null,null,"Michel","Alberta","Watch"]