{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["helper","filter","list","indirect","Sheet2","Sheet1","vba1","vba2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"helper","index":0,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,13,1,15],[1,0,1,2]]}
[]
["Use of Helper Columns",null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
["Salesman","Product","Net Sales","Helper1","Helper2","Helper3","Drop Down",null,"Salesman","Product","Net Sales",null,null,"Salesman","Product","Net Sales"]
["Wilham","TV",2600,{"$f":"ROWS($B$5:B5)","v":1},{"$f":"IF(B5=$G$5,D5,\"\")","v":1},{"$f":"IFERROR(SMALL($E$5:$E$10,D5),\"\")","v":1},"TV",null,{"$f":"IFERROR(INDEX($A$5:$C$10,$F5,COLUMNS($I$5:I5)),\"\")","v":"Wilham"},{"$f":"IFERROR(INDEX($A$5:$C$10,$F5,COLUMNS($I$5:J5)),\"\")","v":"TV"},{"$f":"IFERROR(INDEX($A$5:$C$10,$F5,COLUMNS($I$5:K5)),\"\")","v":2600},null,null,"Wilham","Cable",2600]
["Simon","AC",11500,{"$f":"ROWS($B$5:B6)","v":2},{"$f":"IF(B6=$G$5,D6,\"\")","v":""},{"$f":"IFERROR(SMALL($E$5:$E$10,D6),\"\")","v":3},null,null,{"$f":"IFERROR(INDEX($A$5:$C$10,$F6,COLUMNS($I$5:I6)),\"\")","v":"Frank"},{"$f":"IFERROR(INDEX($A$5:$C$10,$F6,COLUMNS($I$5:J6)),\"\")","v":"TV"},{"$f":"IFERROR(INDEX($A$5:$C$10,$F6,COLUMNS($I$5:K6)),\"\")","v":13500},null,null,"Simon","AC",11500]
["Frank","TV",13500,{"$f":"ROWS($B$5:B7)","v":3},3,5,null,null,{"$f":"IFERROR(INDEX($A$5:$C$10,$F7,COLUMNS($I$5:I7)),\"\")","v":"Jaxson"},{"$f":"IFERROR(INDEX($A$5:$C$10,$F7,COLUMNS($I$5:J7)),\"\")","v":"TV"},{"$f":"IFERROR(INDEX($A$5:$C$10,$F7,COLUMNS($I$5:K7)),\"\")","v":5500},null,null,"Frank","TV",13500]
["Nathan","AC",17000,{"$f":"ROWS($B$5:B8)","v":4},"",6,null,null,{"$f":"IFERROR(INDEX($A$5:$C$10,$F8,COLUMNS($I$5:I8)),\"\")","v":"Anthony"},{"$f":"IFERROR(INDEX($A$5:$C$10,$F8,COLUMNS($I$5:J8)),\"\")","v":"TV"},{"$f":"IFERROR(INDEX($A$5:$C$10,$F8,COLUMNS($I$5:K8)),\"\")","v":10000},null,null,"Nathan","Fridge",17000]
["Jaxson","TV",5500,{"$f":"ROWS($B$5:B9)","v":5},{"$f":"IF(B9=$G$5,D9,\"\")","v":5},"",null,null,null,null,null,null,null,"Jaxson","Router",5500]
["Anthony","TV",10000,{"$f":"ROWS($B$5:B10)","v":6},6,"",null,null,null,null,null,null,null,"Anthony","Oven",10000]

{"sheet":"filter","index":1,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,1,2],[1,13,1,15]]}
[]
["Use of FILTER Function",null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
["Salesman","Product","Net Sales",null,"Product",null,"Salesman","Product","Net Sales",null,null,null,null,"Salesman","Product","Net Sales"]
["Wilham","TV",2600,null,"TV",null,{"$f":"_xlfn._xlws.FILTER(Table1[],Table1[Product]=E5)","v":"Wilham"},"TV",2600,null,null,null,null,"Wilham","Cable",2600]
["Simon","AC",11500,null,null,null,"Frank","TV",13500,null,null,null,null,"Simon","AC",11500]
["Frank","TV",13500,null,null,null,"Jaxson","TV",5500,null,null,null,null,"Frank","TV",13500]
["Nathan","AC",17000,null,null,null,"Anthony","TV",10000,null,null,null,null,"Nathan","Fridge",17000]
["Jaxson","TV",5500,null,null,null,null,null,null,null,null,null,null,"Jaxson","Router",5500]
["Anthony","TV",10000,null,null,null,null,null,null,null,null,null,null,"Anthony","Oven",10000]

{"sheet":"list","index":2,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"_xlfn.UNIQUE(Table1[Product])","v":"TV"}]
[null,"AC"]

{"sheet":"indirect","index":3,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,6,1,8],[1,1,1,2]]}
[]
[null,"Use of INDIRECT Function",null,null,null,null,"Practice Yourself"]
[]
[null,"Sheet Name","Sheet1",null,null,null,"Salesman","Product","Net Sales"]
[null,null,null,null,null,null,"Wilham","Cable",2600]
[null,"Total Sales",{"$f":"INDIRECT(\"'\"&C4&\"'!C11\")","v":56550},null,null,null,"Simon","AC",11500]
[null,null,null,null,null,null,"Frank","TV",13500]
[null,"List of Sheet Names","Sheet1",null,null,null,"Nathan","Fridge",17000]
[null,null,"Sheet2",null,null,null,"Jaxson","Router",5500]
[null,null,null,null,null,null,"Anthony","Oven",10000]

{"sheet":"Sheet2","index":4,"n_rows":11,"n_cols":16,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,0,1,2],[1,13,1,15]]}
[]
["Use of INDIRECT Function",null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
["Salesman","Product","Net Sales",null,null,null,null,null,null,null,null,null,null,"Salesman","Product","Net Sales"]
["Wilham","TV",3000,null,null,null,null,null,null,null,null,null,null,"Wilham","Cable",2600]
["Simon","AC",11500,null,null,null,null,null,null,null,null,null,null,"Simon","AC",11500]
["Frank","TV",13500,null,null,null,null,null,null,null,null,null,null,"Frank","TV",13500]
["Nathan","AC",15550,null,null,null,null,null,null,null,null,null,null,"Nathan","Fridge",17000]
["Jaxson","TV",5500,null,null,null,null,null,null,null,null,null,null,"Jaxson","Router",5500]
["Anthony","TV",6500,null,null,null,null,null,null,null,null,null,null,"Anthony","Oven",10000]
[null,"Total Sales",{"$f":"SUM(C5:C10)","v":55550}]

{"sheet":"Sheet1","index":5,"n_rows":11,"n_cols":16,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,0,1,2],[1,13,1,15]]}
[]
["Use of INDIRECT Function",null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
["Salesman","Product","Net Sales",null,null,null,null,null,null,null,null,null,null,"Salesman","Product","Net Sales"]
["Wilham","TV",3500,null,null,null,null,null,null,null,null,null,null,"Wilham","Cable",2600]
["Simon","AC",11500,null,null,null,null,null,null,null,null,null,null,"Simon","AC",11500]
["Frank","TV",13500,null,null,null,null,null,null,null,null,null,null,"Frank","TV",13500]
["Nathan","AC",12550,null,null,null,null,null,null,null,null,null,null,"Nathan","Fridge",17000]
["Jaxson","TV",5500,null,null,null,null,null,null,null,null,null,null,"Jaxson","Router",5500]
["Anthony","TV",10000,null,null,null,null,null,null,null,null,null,null,"Anthony","Oven",10000]
[null,"Total Sales",{"$f":"SUM(C5:C10)","v":56550}]

{"sheet":"vba1","index":6,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,13,1,15]]}
["Product","Net Sales"]
["TV",2600,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
["AC",11500]
["TV",13500,null,null,null,null,null,null,null,null,null,null,null,"Salesman","Product","Net Sales"]
["AC",17000,null,null,null,null,null,null,null,null,null,null,null,"Wilham","Cable",2600]
["TV",5500,null,null,null,null,null,null,null,null,null,null,null,"Simon","AC",11500]
["TV",10000,null,null,null,null,null,null,null,null,null,null,null,"Frank","TV",13500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Nathan","Fridge",17000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Jaxson","Router",5500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Anthony","Oven",10000]

{"sheet":"vba2","index":7,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Drop Down"]
["AC"]