{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Fill Handle","Fill Feature","Header & Footer","VLOOKUP","OFFSET","VBA for Print"],"not_rendered":{"charts":0,"images":1,"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":"Dataset","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Repeat Rows at Bottom"]
[]
[null,"Product ","Cost","Sales"]
[null,"Mocha Cake",25,30]
[null,"Carrot Cake",22,{"$f":"C6+5","v":27}]
[null,"Chiffon Cake",20,{"$f":"C7+5","v":25}]
[null,"Cheese Cake",21,26]
[null,"Sponge Cake",18,23]
[null,"Red Velvet",23,28]

{"sheet":"Fill Handle","index":1,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Use of Fill Handle Icon",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product ","Cost","Sales",null,null,null,null,null,"Product ","Cost","Sales"]
[null,"Mocha Cake",25,30,null,null,null,null,null,"Mocha Cake",25,30]
[null,"Carrot Cake",22,27,null,null,null,null,null,"Carrot Cake",22,{"$f":"K6+5","v":27}]
[null,"Chiffon Cake",20,25,null,null,null,null,null,"Chiffon Cake",20,{"$f":"K7+5","v":25}]
[null,"Cheese Cake",21,26,null,null,null,null,null,"Cheese Cake",21,26]
[null,"Sponge Cake",18,23,null,null,null,null,null,"Sponge Cake",18,23]
[null,"Red Velvet",23,28,null,null,null,null,null,"Red Velvet",23,28]
[null,"Red Velvet",23,28]
[null,"Red Velvet",23,28]
[null,"Red Velvet",23,28]
[null,"Red Velvet",23,28]

{"sheet":"Fill Feature","index":2,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Applying Fill Feature",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product ","Cost","Sales",null,null,null,null,null,"Product ","Cost","Sales"]
[null,"Mocha Cake",25,30,null,null,null,null,null,"Mocha Cake",25,30]
[null,"Carrot Cake",22,27,null,null,null,null,null,"Carrot Cake",22,{"$f":"K6+5","v":27}]
[null,"Chiffon Cake",20,25,null,null,null,null,null,"Chiffon Cake",20,{"$f":"K7+5","v":25}]
[null,"Cheese Cake",21,26,null,null,null,null,null,"Cheese Cake",21,26]
[null,"Sponge Cake",18,23,null,null,null,null,null,"Sponge Cake",18,23]
[null,"Red Velvet",23,28,null,null,null,null,null,"Red Velvet",23,28]
[null,"Red Velvet",23,28]
[null,"Red Velvet",23,28]
[null,"Red Velvet",23,28]
[null,"Red Velvet",23,28]

{"sheet":"Header & Footer","index":3,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Use of Header & Footer Command",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product ","Cost","Sales",null,null,null,null,null,"Product ","Cost","Sales"]
[null,"Mocha Cake",25,30,null,null,null,null,null,"Mocha Cake",25,30]
[null,"Carrot Cake",22,27,null,null,null,null,null,"Carrot Cake",22,{"$f":"K6+5","v":27}]
[null,"Chiffon Cake",20,25,null,null,null,null,null,"Chiffon Cake",20,{"$f":"K7+5","v":25}]
[null,"Cheese Cake",21,26,null,null,null,null,null,"Cheese Cake",21,26]
[null,"Sponge Cake",18,23,null,null,null,null,null,"Sponge Cake",18,23]
[null,"Red Velvet",23,28,null,null,null,null,null,"Red Velvet",23,28]

{"sheet":"VLOOKUP","index":4,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,10],[1,4,1,5]]}
[]
[null,"Employing VLOOKUP Function",null,null,"Table Array"]
[]
[null,"Look Up Value","Repeat",null,"Product No.","Product "]
[null,1,{"$f":"VLOOKUP($B$5,$E$5:$F$10,2,0)","v":"Mocha Cake"},null,1,"Mocha Cake"]
[null,2,{"$f":"VLOOKUP($B$5,$B$5:$C$10,2,0)","v":"Mocha Cake"},null,2,"Carrot Cake"]
[null,3,{"$f":"VLOOKUP($B$5,$B$5:$C$10,2,0)","v":"Mocha Cake"},null,3,"Chiffon Cake"]
[null,4,{"$f":"VLOOKUP($B$5,$B$5:$C$10,2,0)","v":"Mocha Cake"},null,4,"Cheese Cake"]
[null,5,{"$f":"VLOOKUP($B$5,$B$5:$C$10,2,0)","v":"Mocha Cake"},null,5,"Sponge Cake"]
[null,6,{"$f":"VLOOKUP($B$5,$B$5:$C$10,2,0)","v":"Mocha Cake"},null,6,"Red Velvet"]

{"sheet":"OFFSET","index":5,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Use of OFFSET Function",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product ","Cost","Sales",null,null,null,null,null,"Product ","Cost","Sales"]
[null,"Mocha Cake",25,30,null,null,null,null,null,"Mocha Cake",25,30]
[null,"Carrot Cake",22,27,null,null,null,null,null,"Carrot Cake",22,{"$f":"K6+5","v":27}]
[null,"Chiffon Cake",20,25,null,null,null,null,null,"Chiffon Cake",20,{"$f":"K7+5","v":25}]
[null,"Cheese Cake",21,26,null,null,null,null,null,"Cheese Cake",21,26]
[null,"Sponge Cake",18,23,null,null,null,null,null,"Sponge Cake",18,23]
[null,"Red Velvet",23,28,null,null,null,null,null,"Red Velvet",23,28]
[null,{"$f":"OFFSET(B7,0,0,4,3)","v":"Chiffon Cake"},20,25]
[null,"Cheese Cake",21,26]
[null,"Sponge Cake",18,23]
[null,"Red Velvet",23,28]

{"sheet":"VBA for Print","index":6,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Use of VBA Code",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product ","Cost","Sales",null,null,null,null,null,"Product ","Cost","Sales"]
[null,"Mocha Cake",25,30,null,null,null,null,null,"Mocha Cake",25,30]
[null,"Carrot Cake",22,27,null,null,null,null,null,"Carrot Cake",22,{"$f":"K6+5","v":27}]
[null,"Chiffon Cake",20,25,null,null,null,null,null,"Chiffon Cake",20,{"$f":"K7+5","v":25}]
[null,"Cheese Cake",21,26,null,null,null,null,null,"Cheese Cake",21,26]
[null,"Sponge Cake",18,23,null,null,null,null,null,"Sponge Cake",18,23]
[null,"Red Velvet",23,28,null,null,null,null,null,"Red Velvet",23,28]