{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["VBA1","VBA2","Condition1","Condition2","SUM1","SUM2","Paste Link1","Paste Link2","Equal1","Equal2","Plus1","Plus2","MASTER1","MASTER2"],"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":"VBA1","index":0,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Transfer Data Using VBA"]
[]
[null,"Smartphone","Price"]

{"sheet":"VBA2","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Transfer Data Using VBA"]
[]
[null,"Smartphone","Price"]
[null,"Galaxy A52S",449]
[null,"Xiaomi 11T Pro",759]
[null,"Galaxy A03S",160]
[null,"Motorola Ace",298]
[null,"Galaxy S22",999]
[null,"OnePlus N20",260]

{"sheet":"Condition1","index":2,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Linking Based On Condition",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Items","Sales",null,null,null,null,null,null,"Items","Sales"]
[null,"Mixed Nuts",1000,null,null,null,null,null,null,"Mixed Nuts",{"$f":"IF(Condition1!K5>=1000,Condition1!K5,\"\")","v":""}]
[null,"Chia Seeds",500,null,null,null,null,null,null,"Chia Seeds",{"$f":"IF(Condition1!K6>=1000,Condition1!K6,\"\")","v":""}]
[null,"Corn Flakes",2000,null,null,null,null,null,null,"Corn Flakes",{"$f":"IF(Condition1!K7>=1000,Condition1!K7,\"\")","v":""}]
[null,"Ramen",3000,null,null,null,null,null,null,"Ramen",{"$f":"IF(Condition1!K8>=1000,Condition1!K8,\"\")","v":""}]
[null,"Oats",4000,null,null,null,null,null,null,"Oats",{"$f":"IF(Condition1!K9>=1000,Condition1!K9,\"\")","v":""}]
[null,"Honey",600,null,null,null,null,null,null,"Honey",{"$f":"IF(Condition1!K10>=1000,Condition1!K10,\"\")","v":""}]

{"sheet":"Condition2","index":3,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Linking Based On Condition",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Items","Sales",null,null,null,null,"Items","Sales"]
[null,"Mixed Nuts",{"$f":"IF(Condition1!C5>=1000,Condition1!C5,\"\")","v":1000},null,null,null,null,"Mixed Nuts",{"$f":"IF(Condition1!I5>=1000,Condition1!I5,\"\")","v":""}]
[null,"Chia Seeds",{"$f":"IF(Condition1!C6>=1000,Condition1!C6,\"\")","v":""},null,null,null,null,"Chia Seeds",{"$f":"IF(Condition1!I6>=1000,Condition1!I6,\"\")","v":""}]
[null,"Corn Flakes",{"$f":"IF(Condition1!C7>=1000,Condition1!C7,\"\")","v":2000},null,null,null,null,"Corn Flakes",{"$f":"IF(Condition1!I7>=1000,Condition1!I7,\"\")","v":""}]
[null,"Ramen",{"$f":"IF(Condition1!C8>=1000,Condition1!C8,\"\")","v":3000},null,null,null,null,"Ramen",{"$f":"IF(Condition1!I8>=1000,Condition1!I8,\"\")","v":""}]
[null,"Oats",{"$f":"IF(Condition1!C9>=1000,Condition1!C9,\"\")","v":4000},null,null,null,null,"Oats",{"$f":"IF(Condition1!I9>=1000,Condition1!I9,\"\")","v":""}]
[null,"Honey",{"$f":"IF(Condition1!C10>=1000,Condition1!C10,\"\")","v":""},null,null,null,null,"Honey",{"$f":"IF(Condition1!I10>=1000,Condition1!I10,\"\")","v":""}]

{"sheet":"SUM1","index":4,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using SUM Function",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Items","Sales",null,null,null,null,null,"Items","Sales"]
[null,"Mixed Nuts",1000,null,null,null,null,null,"Mixed Nuts"]
[null,"Chia Seeds",500,null,null,null,null,null,"Chia Seeds"]
[null,"Corn Flakes",2000,null,null,null,null,null,"Corn Flakes"]
[null,"Ramen",3000,null,null,null,null,null,"Ramen"]
[null,"Oats",4000,null,null,null,null,null,"Oats"]
[null,"Honey",600,null,null,null,null,null,"Honey"]

{"sheet":"SUM2","index":5,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using SUM Function",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Items","Sales",null,null,null,null,null,"Items","Sales"]
[null,"Mixed Nuts",1000,null,null,null,null,null,"Mixed Nuts"]
[null,"Chia Seeds",500,null,null,null,null,null,"Chia Seeds"]
[null,"Corn Flakes",2000,null,null,null,null,null,"Corn Flakes"]
[null,"Ramen",3000,null,null,null,null,null,"Ramen"]
[null,"Oats",4000,null,null,null,null,null,"Oats"]
[null,"Total",{"$f":"SUM('SUM1'!C5:C9)","v":10500},null,null,null,null,null,"Honey"]

{"sheet":"Paste Link1","index":6,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Using Paste Link Option",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Items","Sales",null,null,null,null,null,null,"Items","Sales"]
[null,"Mixed Nuts",1000,null,null,null,null,null,null,"Mixed Nuts",{"$f":"IF(Condition1!K5>=1000,Condition1!K5,\"\")","v":""}]
[null,"Chia Seeds",500,null,null,null,null,null,null,"Chia Seeds",{"$f":"IF(Condition1!K6>=1000,Condition1!K6,\"\")","v":""}]
[null,"Corn Flakes",2000,null,null,null,null,null,null,"Corn Flakes",{"$f":"IF(Condition1!K7>=1000,Condition1!K7,\"\")","v":""}]
[null,"Ramen",3000,null,null,null,null,null,null,"Ramen",{"$f":"IF(Condition1!K8>=1000,Condition1!K8,\"\")","v":""}]
[null,"Oats",4000,null,null,null,null,null,null,"Oats",{"$f":"IF(Condition1!K9>=1000,Condition1!K9,\"\")","v":""}]
[null,"Honey",600,null,null,null,null,null,null,"Honey",{"$f":"IF(Condition1!K10>=1000,Condition1!K10,\"\")","v":""}]

{"sheet":"Paste Link2","index":7,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Using Paste Link Option",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Items","Sales",null,null,null,null,null,null,"Items","Sales"]
[null,"Mixed Nuts",null,null,null,null,null,null,null,"Mixed Nuts",{"$f":"IF(Condition1!K5>=1000,Condition1!K5,\"\")","v":""}]
[null,"Chia Seeds",null,null,null,null,null,null,null,"Chia Seeds",{"$f":"IF(Condition1!K6>=1000,Condition1!K6,\"\")","v":""}]
[null,"Corn Flakes",null,null,null,null,null,null,null,"Corn Flakes",{"$f":"IF(Condition1!K7>=1000,Condition1!K7,\"\")","v":""}]
[null,"Ramen",null,null,null,null,null,null,null,"Ramen",{"$f":"IF(Condition1!K8>=1000,Condition1!K8,\"\")","v":""}]
[null,"Oats",null,null,null,null,null,null,null,"Oats",{"$f":"IF(Condition1!K9>=1000,Condition1!K9,\"\")","v":""}]
[null,"Honey",null,null,null,null,null,null,null,"Honey",{"$f":"IF(Condition1!K10>=1000,Condition1!K10,\"\")","v":""}]

{"sheet":"Equal1","index":8,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Using Equal Sign",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Items","Sales",null,null,null,null,null,null,"Items","Sales"]
[null,"Mixed Nuts",1000,null,null,null,null,null,null,"Mixed Nuts",{"$f":"IF(Condition1!K5>=1000,Condition1!K5,\"\")","v":""}]
[null,"Chia Seeds",500,null,null,null,null,null,null,"Chia Seeds",{"$f":"IF(Condition1!K6>=1000,Condition1!K6,\"\")","v":""}]
[null,"Corn Flakes",2000,null,null,null,null,null,null,"Corn Flakes",{"$f":"IF(Condition1!K7>=1000,Condition1!K7,\"\")","v":""}]
[null,"Ramen",3000,null,null,null,null,null,null,"Ramen",{"$f":"IF(Condition1!K8>=1000,Condition1!K8,\"\")","v":""}]
[null,"Oats",4000,null,null,null,null,null,null,"Oats",{"$f":"IF(Condition1!K9>=1000,Condition1!K9,\"\")","v":""}]
[null,"Honey",600,null,null,null,null,null,null,"Honey",{"$f":"IF(Condition1!K10>=1000,Condition1!K10,\"\")","v":""}]

{"sheet":"Equal2","index":9,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Using Equal Sign",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Items","Sales",null,null,null,null,null,null,"Items","Sales"]
[null,"Mixed Nuts",{"$f":"Equal1!C5:C10","v":1000},null,null,null,null,null,null,"Mixed Nuts",{"$f":"IF(Condition1!K5>=1000,Condition1!K5,\"\")","v":""}]
[null,"Chia Seeds",500,null,null,null,null,null,null,"Chia Seeds",{"$f":"IF(Condition1!K6>=1000,Condition1!K6,\"\")","v":""}]
[null,"Corn Flakes",2000,null,null,null,null,null,null,"Corn Flakes",{"$f":"IF(Condition1!K7>=1000,Condition1!K7,\"\")","v":""}]
[null,"Ramen",3000,null,null,null,null,null,null,"Ramen",{"$f":"IF(Condition1!K8>=1000,Condition1!K8,\"\")","v":""}]
[null,"Oats",4000,null,null,null,null,null,null,"Oats",{"$f":"IF(Condition1!K9>=1000,Condition1!K9,\"\")","v":""}]
[null,"Honey",600,null,null,null,null,null,null,"Honey",{"$f":"IF(Condition1!K10>=1000,Condition1!K10,\"\")","v":""}]

{"sheet":"Plus1","index":10,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Using Plus Sign",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Items","Sales",null,null,null,null,null,null,"Items","Sales"]
[null,"Mixed Nuts",1000,null,null,null,null,null,null,"Mixed Nuts",{"$f":"IF(Condition1!K5>=1000,Condition1!K5,\"\")","v":""}]
[null,"Chia Seeds",500,null,null,null,null,null,null,"Chia Seeds",{"$f":"IF(Condition1!K6>=1000,Condition1!K6,\"\")","v":""}]
[null,"Corn Flakes",2000,null,null,null,null,null,null,"Corn Flakes",{"$f":"IF(Condition1!K7>=1000,Condition1!K7,\"\")","v":""}]
[null,"Ramen",3000,null,null,null,null,null,null,"Ramen",{"$f":"IF(Condition1!K8>=1000,Condition1!K8,\"\")","v":""}]
[null,"Oats",4000,null,null,null,null,null,null,"Oats",{"$f":"IF(Condition1!K9>=1000,Condition1!K9,\"\")","v":""}]
[null,"Honey",600,null,null,null,null,null,null,"Honey",{"$f":"IF(Condition1!K10>=1000,Condition1!K10,\"\")","v":""}]

{"sheet":"Plus2","index":11,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Using Plus Sign",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Items","Sales",null,null,null,null,null,null,"Items","Sales"]
[null,"Mixed Nuts",{"$f":"+Plus1!C5:C10","v":1000},null,null,null,null,null,null,"Mixed Nuts",{"$f":"IF(Condition1!K5>=1000,Condition1!K5,\"\")","v":""}]
[null,"Chia Seeds",500,null,null,null,null,null,null,"Chia Seeds",{"$f":"IF(Condition1!K6>=1000,Condition1!K6,\"\")","v":""}]
[null,"Corn Flakes",2000,null,null,null,null,null,null,"Corn Flakes",{"$f":"IF(Condition1!K7>=1000,Condition1!K7,\"\")","v":""}]
[null,"Ramen",3000,null,null,null,null,null,null,"Ramen",{"$f":"IF(Condition1!K8>=1000,Condition1!K8,\"\")","v":""}]
[null,"Oats",4000,null,null,null,null,null,null,"Oats",{"$f":"IF(Condition1!K9>=1000,Condition1!K9,\"\")","v":""}]
[null,"Honey",600,null,null,null,null,null,null,"Honey",{"$f":"IF(Condition1!K10>=1000,Condition1!K10,\"\")","v":""}]

{"sheet":"MASTER1","index":12,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Linking to Master Sheet",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Sheet Name","Link",null,null,null,null,null,"Sheet Name","Link"]
[null,"New York","MASTER2!B5",null,null,null,null,null,"New York"]
[null,"Boston","MASTER2!B6",null,null,null,null,null,"Boston"]
[null,"Los Angeles","MASTER2!B7",null,null,null,null,null,"Los Angeles"]
[null,"California","MASTER2!B8",null,null,null,null,null,"California"]
[null,"Chicago","MASTER2!B9",null,null,null,null,null,"Chicago"]

{"sheet":"MASTER2","index":13,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Linking to Master Sheet"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Sale"]
[null,"2021-12-06","Bran",50,1.87,93.5]
[null,"2021-12-07","Oatmeal Raisin",100,2.8400000000000003,284.00000000000006]
[null,"2021-12-13","Whole Wheat",90,3.49,314.10000000000002]
[null,"2021-12-15","Arrowroot",75,2.1800000000000002,163.5]
[null,"2021-12-16","Chocolate Chip",200,1.8699999999999999,374]