{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset 1","Independent Drop-Down List","Dynamic Drop-Down List","Multiple Selections","Named Range","VBA Macro","Dataset 2","Single Criteria","Multiple Criteria","Unique List"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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 1","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Creating List from Range "]
[]
[null,"Book Name ","Movie Name "]
[null,"Lord of the Rings","The Godfather "]
[null,"Animal Farm ","The Dark Knight "]
[null,"Kafka on the Shore ","Metropolis "]
[null,"A Promised Land ","Vertigo "]
[null,"The Road Back ","The Rear Window "]
[null,"The Song of Ice And Fire ","The Shining "]
[null,"Alan and the Holy Flower ","The Good the Bad And the Ugly "]
[null,"The Ivory Child ","Unforgiven "]
[null,"The Valley of Fear ","Batman Begins "]
[null,"A Study in Scarlet ","Psycho "]

{"sheet":"Independent Drop-Down List","index":1,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Creating an Independent Drop-Down List ",null,null,null,null,null,null,"Practice Section"]
[]
[null,"Book Name ","Movie Name ",null,null,null,null,null,"Book Name ","Movie Name "]
[null,"Lord of the Rings","The Godfather ",null,null,null,null,null,"Lord of the Rings","The Godfather "]
[null,"Animal Farm ","The Dark Knight ",null,null,null,null,null,"Animal Farm ","The Dark Knight "]
[null,"Kafka on the Shore ","Metropolis ",null,null,null,null,null,"Kafka on the Shore ","Metropolis "]
[null,"A Promised Land ","Vertigo ",null,null,null,null,null,"A Promised Land ","Vertigo "]
[null,"The Road Back ","The Rear Window ",null,null,null,null,null,"The Road Back ","The Rear Window "]
[null,"The Song of Ice And Fire ","The Shining ",null,null,null,null,null,"The Song of Ice And Fire ","The Shining "]
[null,"Alan and the Holy Flower ","The Good the Bad And the Ugly ",null,null,null,null,null,"Alan and the Holy Flower ","The Good the Bad And the Ugly "]
[null,"The Ivory Child ","Unforgiven ",null,null,null,null,null,"The Ivory Child ","Unforgiven "]
[null,"The Valley of Fear ","Batman Begins ",null,null,null,null,null,"The Valley of Fear ","Batman Begins "]
[null,"A Study in Scarlet ","Psycho ",null,null,null,null,null,"A Study in Scarlet ","Psycho "]
[]
[null,"Book List","Movie List",null,null,null,null,null,"Book List","Movie List"]
[null,"The Road Back ","Vertigo "]

{"sheet":"Dynamic Drop-Down List","index":2,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Creating a Dynamic Drop-Down List",null,null,null,null,null,null,"Practice Section"]
[]
[null,"Book Name ","Movie Name ",null,null,null,null,null,"Book Name ","Movie Name "]
[null,"Lord of the Rings","The Godfather ",null,null,null,null,null,"Lord of the Rings","The Godfather "]
[null,"Animal Farm ","The Dark Knight ",null,null,null,null,null,"Animal Farm ","The Dark Knight "]
[null,"Kafka on the Shore ","Metropolis ",null,null,null,null,null,"Kafka on the Shore ","Metropolis "]
[null,"A Promised Land ","Vertigo ",null,null,null,null,null,"A Promised Land ","Vertigo "]
[null,"The Road Back ","The Rear Window ",null,null,null,null,null,"The Road Back ","The Rear Window "]
[null,"The Song of Ice And Fire ","The Shining ",null,null,null,null,null,"The Song of Ice And Fire ","The Shining "]
[null,"Alan and the Holy Flower ","The Good the Bad And the Ugly ",null,null,null,null,null,"Alan and the Holy Flower ","The Good the Bad And the Ugly "]
[null,"The Ivory Child ","Unforgiven ",null,null,null,null,null,"The Ivory Child ","Unforgiven "]
[null,"The Valley of Fear ","Batman Begins ",null,null,null,null,null,"The Valley of Fear ","Batman Begins "]
[null,"A Study in Scarlet ","Psycho ",null,null,null,null,null,"A Study in Scarlet ","Psycho "]
[]
[null,"Book List","Movie List",null,null,null,null,null,"Book List","Movie List"]
[null,"The Road Back ","Vertigo "]

{"sheet":"Multiple Selections","index":3,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Creating Drop-Down List with Multiple Selections",null,null,null,null,null,null,"Practice Section"]
[]
[null,"Book Name ",null,null,null,null,null,null,"Book Name "]
[null,"Lord of the Rings",null,null,null,null,null,null,"Lord of the Rings"]
[null,"Animal Farm ",null,null,null,null,null,null,"Animal Farm "]
[null,"Kafka on the Shore ",null,null,null,null,null,null,"Kafka on the Shore "]
[null,"A Promised Land ",null,null,null,null,null,null,"A Promised Land "]
[null,"The Road Back ",null,null,null,null,null,null,"The Road Back "]
[null,"The Song of Ice And Fire ",null,null,null,null,null,null,"The Song of Ice And Fire "]
[null,"Alan and the Holy Flower ",null,null,null,null,null,null,"Alan and the Holy Flower "]
[null,"The Ivory Child ",null,null,null,null,null,null,"The Ivory Child "]
[null,"The Valley of Fear ",null,null,null,null,null,null,"The Valley of Fear "]
[null,"A Study in Scarlet ",null,null,null,null,null,null,"A Study in Scarlet "]
[]
[null,"Book List",null,null,null,null,null,null,"Book List"]
[null,"The Road Back \r\nThe Song of Ice And Fire \r\nThe Ivory Child "]

{"sheet":"Named Range","index":4,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using Named Range",null,null,null,null,null,null,"Practice Section"]
[]
[null,"Book Name ","Movie Name ",null,null,null,null,null,"Book Name ","Movie Name "]
[null,"Lord of the Rings","The Godfather ",null,null,null,null,null,"Lord of the Rings","The Godfather "]
[null,"Animal Farm ","The Dark Knight ",null,null,null,null,null,"Animal Farm ","The Dark Knight "]
[null,"Kafka on the Shore ","Metropolis ",null,null,null,null,null,"Kafka on the Shore ","Metropolis "]
[null,"A Promised Land ","Vertigo ",null,null,null,null,null,"A Promised Land ","Vertigo "]
[null,"The Road Back ","The Rear Window ",null,null,null,null,null,"The Road Back ","The Rear Window "]
[null,"The Song of Ice And Fire ","The Shining ",null,null,null,null,null,"The Song of Ice And Fire ","The Shining "]
[null,"Alan and the Holy Flower ","The Good the Bad And the Ugly ",null,null,null,null,null,"Alan and the Holy Flower ","The Good the Bad And the Ugly "]
[null,"The Ivory Child ","Unforgiven ",null,null,null,null,null,"The Ivory Child ","Unforgiven "]
[null,"The Valley of Fear ","Batman Begins ",null,null,null,null,null,"The Valley of Fear ","Batman Begins "]
[null,"A Study in Scarlet ","Psycho ",null,null,null,null,null,"A Study in Scarlet ","Psycho "]
[]
[null,"Book List","Movie List",null,null,null,null,null,"Book List","Movie List"]
[null,"The Road Back ","Vertigo "]

{"sheet":"VBA Macro","index":5,"n_rows":24,"n_cols":15,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Using VBA Macro Feature",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Book Name ","Movie Name ",null,"Book & Movie Name ",null,null,null,null,null,null,"Book Name ","Movie Name ",null,"Book & Movie Name "]
[null,"Lord of the Rings","The Godfather ",null,"Lord of the Rings",null,null,null,null,null,null,"Lord of the Rings","The Godfather "]
[null,"Animal Farm ","The Dark Knight ",null,"The Godfather ",null,null,null,null,null,null,"Animal Farm ","The Dark Knight "]
[null,"Kafka on the Shore ","Metropolis ",null,"Animal Farm ",null,null,null,null,null,null,"Kafka on the Shore ","Metropolis "]
[null,"A Promised Land ","Vertigo ",null,"The Dark Knight ",null,null,null,null,null,null,"A Promised Land ","Vertigo "]
[null,"The Road Back ","The Rear Window ",null,"Kafka on the Shore ",null,null,null,null,null,null,"The Road Back ","The Rear Window "]
[null,"The Song of Ice And Fire ","The Shining ",null,"Metropolis ",null,null,null,null,null,null,"The Song of Ice And Fire ","The Shining "]
[null,"Alan and the Holy Flower ","The Good the Bad And the Ugly ",null,"A Promised Land ",null,null,null,null,null,null,"Alan and the Holy Flower ","The Good the Bad And the Ugly "]
[null,"The Ivory Child ","Unforgiven ",null,"Vertigo ",null,null,null,null,null,null,"The Ivory Child ","Unforgiven "]
[null,"The Valley of Fear ","Batman Begins ",null,"The Road Back ",null,null,null,null,null,null,"The Valley of Fear ","Batman Begins "]
[null,"A Study in Scarlet ","Psycho ",null,"The Rear Window ",null,null,null,null,null,null,"A Study in Scarlet ","Psycho "]
[null,null,null,null,"The Song of Ice And Fire "]
[null,null,null,null,"The Shining "]
[null,null,null,null,"Alan and the Holy Flower "]
[null,null,null,null,"The Good the Bad And the Ugly "]
[null,null,null,null,"The Ivory Child "]
[null,null,null,null,"Unforgiven "]
[null,null,null,null,"The Valley of Fear "]
[null,null,null,null,"Batman Begins "]
[null,null,null,null,"A Study in Scarlet "]
[null,null,null,null,"Psycho "]

{"sheet":"Dataset 2","index":6,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2],[15,1,17,1]]}
[]
[null,"List of Teams with Team Members"]
[]
[null,"Members","Team"]
[null,"Peter","A"]
[null,"Adam","A"]
[null,"Sarah","A"]
[null,"Harry","B"]
[null,"Kim","B"]
[null,"Sterling","B"]
[null,"James","C"]
[null,"Morgan","C"]
[null,"Lily","C"]
[]
[null,"Team","Members"]

{"sheet":"Single Criteria","index":7,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,2],[15,1,17,1],[1,8,1,9],[15,8,17,8]]}
[]
[null,"Creating List Based on Single Criteria",null,null,null,null,null,null,"Practice Section"]
[]
[null,"Members","Team",null,null,null,null,null,"Members","Team"]
[null,"Peter","A",null,null,null,null,null,"Peter","A"]
[null,"Adam","A",null,null,null,null,null,"Adam","A"]
[null,"Sarah","A",null,null,null,null,null,"Sarah","A"]
[null,"Harry","B",null,null,null,null,null,"Harry","B"]
[null,"Kim","B",null,null,null,null,null,"Kim","B"]
[null,"Sterling","B",null,null,null,null,null,"Sterling","B"]
[null,"James","C",null,null,null,null,null,"James","C"]
[null,"Morgan","C",null,null,null,null,null,"Morgan","C"]
[null,"Lily","C",null,null,null,null,null,"Lily","C"]
[]
[null,"Team","Members",null,null,null,null,null,"Team","Members"]
[null,"C","James",null,null,null,null,null,"A"]
[null,null,{"$f":"IFERROR(INDEX($B$2:$C$13,SMALL(IF($C$5:$C$13=$B$16,ROW($B$5:$B$13)),ROW(2:2))-1,1),\"\")","v":"Morgan"}]
[null,null,{"$f":"IFERROR(INDEX($B$2:$C$13,SMALL(IF($C$5:$C$13=$B$16,ROW($B$5:$B$13)),ROW(3:3))-1,1),\"\")","v":"Lily"}]

{"sheet":"Multiple Criteria","index":8,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,9,1,11],[15,9,16,9],[15,10,16,10],[15,1,16,1],[15,2,16,2],[1,1,1,3]]}
[]
[null,"Creating List Based on Multiple Criteria",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Members","Team","Role",null,null,null,null,null,"Members","Team","Role"]
[null,"Peter","A","Manager",null,null,null,null,null,"Peter","A","Manager"]
[null,"Adam","A","Executive",null,null,null,null,null,"Adam","A","Executive"]
[null,"Sarah","A","Executive",null,null,null,null,null,"Sarah","A","Executive"]
[null,"Harry","B","Manager",null,null,null,null,null,"Harry","B","Manager"]
[null,"Kim","B","Executive",null,null,null,null,null,"Kim","B","Executive"]
[null,"Sterling","B","Executive",null,null,null,null,null,"Sterling","B","Executive"]
[null,"James","C","Manager",null,null,null,null,null,"James","C","Manager"]
[null,"Morgan","C","Executive",null,null,null,null,null,"Morgan","C","Executive"]
[null,"Lily","C","Executive",null,null,null,null,null,"Lily","C","Executive"]
[]
[null,"Team","Role","Members",null,null,null,null,null,"Team","Role","Members"]
[null,"A","Executive",{"$f":"IFERROR(INDEX($B$2:$D$13,SMALL(IF(($C$5:$C$13=$B$16)*($D$5:$D$13=$C$16),ROW($B$5:$B$13)),ROW(1:1))-1,1),\"\")","v":"Adam"},null,null,null,null,null,"B","Executive"]
[null,null,null,{"$f":"IFERROR(INDEX($B$2:$D$13,SMALL(IF(($C$5:$C$13=$B$16)*($D$5:$D$13=$C$16),ROW($B$5:$B$13)),ROW(2:2))-1,1),\"\")","v":"Sarah"}]

{"sheet":"Unique List","index":9,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Creating Unique List from Range",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Book And Movie Name ",null,"Unique List ",null,null,null,null,null,"Book And Movie Name ",null,"Unique List "]
[null,"Lord of the Rings",null,{"$f":"_xlfn.UNIQUE(B5:B25)","v":"Lord of the Rings"},null,null,null,null,null,"Lord of the Rings"]
[null,"Animal Farm ",null,"Animal Farm ",null,null,null,null,null,"Animal Farm "]
[null,"Kafka on the Shore ",null,"Kafka on the Shore ",null,null,null,null,null,"Kafka on the Shore "]
[null,"A Promised Land ",null,"A Promised Land ",null,null,null,null,null,"A Promised Land "]
[null,"The Road Back ",null,"The Road Back ",null,null,null,null,null,"The Road Back "]
[null,"The Song of Ice And Fire ",null,"The Song of Ice And Fire ",null,null,null,null,null,"The Song of Ice And Fire "]
[null,"A Promised Land ",null,"Alan and the Holy Flower ",null,null,null,null,null,"A Promised Land "]
[null,"A Promised Land ",null,"The Raging Bull ",null,null,null,null,null,"A Promised Land "]
[null,"Lord of the Rings",null,"A Study in Scarlet ",null,null,null,null,null,"Lord of the Rings"]
[null,"Alan and the Holy Flower ",null,"The Godfather ",null,null,null,null,null,"Alan and the Holy Flower "]
[null,"Animal Farm ",null,"The Dark Knight ",null,null,null,null,null,"Animal Farm "]
[null,"The Raging Bull ",null,"The Good the Bad And the Ugly ",null,null,null,null,null,"The Raging Bull "]
[null,"A Study in Scarlet ",null,"The Shining ",null,null,null,null,null,"A Study in Scarlet "]
[null,"The Godfather ",null,"Metropolis ",null,null,null,null,null,"The Godfather "]
[null,"The Dark Knight ",null,null,null,null,null,null,null,"The Dark Knight "]
[null,"The Godfather ",null,null,null,null,null,null,null,"The Godfather "]
[null,"The Good the Bad And the Ugly ",null,null,null,null,null,null,null,"The Good the Bad And the Ugly "]
[null,"The Raging Bull ",null,null,null,null,null,null,null,"The Raging Bull "]
[null,"The Good the Bad And the Ugly ",null,null,null,null,null,null,null,"The Good the Bad And the Ugly "]
[null,"The Shining ",null,null,null,null,null,null,null,"The Shining "]
[null,"Metropolis ",null,null,null,null,null,null,null,"Metropolis "]