{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Fill Color","Cell Styles","MOD & ROW","ISEVEN & ROW","Filter","VBA"],"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":"Dataset","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Alternate Row Colors"]
[]
[null,"Product","Sales","Profit","Status"]
[null,"Hand Bag",200,{"$f":"C5*15%","v":30},"Sold"]
[null,"Travel Bag",95,{"$f":"C6*15%","v":14.25},"In Stock"]
[null,"Backpack",70,10.5,"Sold"]
[null,"School Bag",80,12,"In Stock"]
[null,"Wallet",20,3,"Sold"]
[null,"Pouch",9,1.3499999999999999,"In Stock"]
[null,"Tote Bag",12,1.7999999999999998,"Sold"]
[null,"Clutch",100,15,"In Stock"]
[null,"Bucket Bag",80,12,"Sold"]
[null,"Doctor Bag",60,9,"In Stock"]

{"sheet":"Fill Color","index":1,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Use of Fill Color",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product","Sales","Profit","Status",null,null,null,null,null,null,"Product","Sales","Profit","Status"]
[null,"Hand Bag",200,{"$f":"C5*15%","v":30},"Sold",null,null,null,null,null,null,"Hand Bag",200,{"$f":"M5*15%","v":30},"Sold"]
[null,"Travel Bag",95,{"$f":"C6*15%","v":14.25},"In Stock",null,null,null,null,null,null,"Travel Bag",95,{"$f":"M6*15%","v":14.25},"In Stock"]
[null,"Backpack",70,10.5,"Sold",null,null,null,null,null,null,"Backpack",70,10.5,"Sold"]
[null,"School Bag",80,12,"In Stock",null,null,null,null,null,null,"School Bag",80,12,"In Stock"]
[null,"Wallet",20,3,"Sold",null,null,null,null,null,null,"Wallet",20,3,"Sold"]
[null,"Pouch",9,1.3499999999999999,"In Stock",null,null,null,null,null,null,"Pouch",9,1.3499999999999999,"In Stock"]
[null,"Tote Bag",12,1.7999999999999998,"Sold",null,null,null,null,null,null,"Tote Bag",12,1.7999999999999998,"Sold"]
[null,"Clutch",100,15,"In Stock",null,null,null,null,null,null,"Clutch",100,15,"In Stock"]
[null,"Bucket Bag",80,12,"Sold",null,null,null,null,null,null,"Bucket Bag",80,12,"Sold"]
[null,"Doctor Bag",60,9,"In Stock",null,null,null,null,null,null,"Doctor Bag",60,9,"In Stock"]

{"sheet":"Cell Styles","index":2,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Using Cell Styles Feature",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product","Sales","Profit","Status",null,null,null,null,null,null,"Product","Sales","Profit","Status"]
[null,"Hand Bag",200,{"$f":"C5*15%","v":30},"Sold",null,null,null,null,null,null,"Hand Bag",200,{"$f":"M5*15%","v":30},"Sold"]
[null,"Travel Bag",95,{"$f":"C6*15%","v":14.25},"In Stock",null,null,null,null,null,null,"Travel Bag",95,{"$f":"M6*15%","v":14.25},"In Stock"]
[null,"Backpack",70,10.5,"Sold",null,null,null,null,null,null,"Backpack",70,10.5,"Sold"]
[null,"School Bag",80,12,"In Stock",null,null,null,null,null,null,"School Bag",80,12,"In Stock"]
[null,"Wallet",20,3,"Sold",null,null,null,null,null,null,"Wallet",20,3,"Sold"]
[null,"Pouch",9,1.3499999999999999,"In Stock",null,null,null,null,null,null,"Pouch",9,1.3499999999999999,"In Stock"]
[null,"Tote Bag",12,1.7999999999999998,"Sold",null,null,null,null,null,null,"Tote Bag",12,1.7999999999999998,"Sold"]
[null,"Clutch",100,15,"In Stock",null,null,null,null,null,null,"Clutch",100,15,"In Stock"]
[null,"Bucket Bag",80,12,"Sold",null,null,null,null,null,null,"Bucket Bag",80,12,"Sold"]
[null,"Doctor Bag",60,9,"In Stock",null,null,null,null,null,null,"Doctor Bag",60,9,"In Stock"]

{"sheet":"MOD & ROW","index":3,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Applying MOD & ROW Functions",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product","Sales","Profit","Status",null,null,null,null,null,null,"Product","Sales","Profit","Status"]
[null,"Hand Bag",200,{"$f":"C5*15%","v":30},"Sold",null,null,null,null,null,null,"Hand Bag",200,{"$f":"M5*15%","v":30},"Sold"]
[null,"Travel Bag",95,{"$f":"C6*15%","v":14.25},"In Stock",null,null,null,null,null,null,"Travel Bag",95,{"$f":"M6*15%","v":14.25},"In Stock"]
[null,"Backpack",70,10.5,"Sold",null,null,null,null,null,null,"Backpack",70,10.5,"Sold"]
[null,"School Bag",80,12,"In Stock",null,null,null,null,null,null,"School Bag",80,12,"In Stock"]
[null,"Wallet",20,3,"Sold",null,null,null,null,null,null,"Wallet",20,3,"Sold"]
[null,"Pouch",9,1.3499999999999999,"In Stock",null,null,null,null,null,null,"Pouch",9,1.3499999999999999,"In Stock"]
[null,"Tote Bag",12,1.7999999999999998,"Sold",null,null,null,null,null,null,"Tote Bag",12,1.7999999999999998,"Sold"]
[null,"Clutch",100,15,"In Stock",null,null,null,null,null,null,"Clutch",100,15,"In Stock"]
[null,"Bucket Bag",80,12,"Sold",null,null,null,null,null,null,"Bucket Bag",80,12,"Sold"]
[null,"Doctor Bag",60,9,"In Stock",null,null,null,null,null,null,"Doctor Bag",60,9,"In Stock"]

{"sheet":"ISEVEN & ROW","index":4,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,10,1,13],[1,1,1,4]]}
[]
[null,"Employing ISEVEN & ROW Functions",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product","Sales","Profit","Status",null,null,null,null,null,"Product","Sales","Profit","Status"]
[null,"Hand Bag",200,{"$f":"C5*15%","v":30},"Sold",null,null,null,null,null,"Hand Bag",200,{"$f":"L5*15%","v":30},"Sold"]
[null,"Travel Bag",95,{"$f":"C6*15%","v":14.25},"In Stock",null,null,null,null,null,"Travel Bag",95,{"$f":"L6*15%","v":14.25},"In Stock"]
[null,"Backpack",70,10.5,"Sold",null,null,null,null,null,"Backpack",70,10.5,"Sold"]
[null,"School Bag",80,12,"In Stock",null,null,null,null,null,"School Bag",80,12,"In Stock"]
[null,"Wallet",20,3,"Sold",null,null,null,null,null,"Wallet",20,3,"Sold"]
[null,"Pouch",9,1.3499999999999999,"In Stock",null,null,null,null,null,"Pouch",9,1.3499999999999999,"In Stock"]
[null,"Tote Bag",12,1.7999999999999998,"Sold",null,null,null,null,null,"Tote Bag",12,1.7999999999999998,"Sold"]
[null,"Clutch",100,15,"In Stock",null,null,null,null,null,"Clutch",100,15,"In Stock"]
[null,"Bucket Bag",80,12,"Sold",null,null,null,null,null,"Bucket Bag",80,12,"Sold"]
[null,"Doctor Bag",60,9,"In Stock",null,null,null,null,null,"Doctor Bag",60,9,"In Stock"]

{"sheet":"Filter","index":5,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,11,1,14],[1,1,1,5]]}
[]
[null,"Employing Formula with Sort & Filter Command",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product","Sales","Profit","Status",null,null,null,null,null,null,"Product","Sales","Profit","Status"]
[null,"Hand Bag",200,{"$f":"C5*15%","v":30},"Sold",{"$f":"MOD(IF(ROW()=2,0,IF(E5=E4,F4, F4+1)), 2)","v":1},null,null,null,null,null,"Hand Bag",200,{"$f":"M5*15%","v":30},"Sold"]
[null,"Travel Bag",95,{"$f":"C6*15%","v":14.25},"Sold",{"$f":"MOD(IF(ROW()=2,0,IF(E6=E5,F5, F5+1)), 2)","v":1},null,null,null,null,null,"Travel Bag",95,{"$f":"M6*15%","v":14.25},"In Stock"]
[null,"Backpack",70,10.5,"Sold",1,null,null,null,null,null,"Backpack",70,10.5,"Sold"]
[null,"School Bag",80,12,"In Stock",0,null,null,null,null,null,"School Bag",80,12,"In Stock"]
[null,"Wallet",20,3,"Sold",1,null,null,null,null,null,"Wallet",20,3,"Sold"]
[null,"Pouch",9,1.3499999999999999,"Sold",1,null,null,null,null,null,"Pouch",9,1.3499999999999999,"In Stock"]
[null,"Tote Bag",12,1.7999999999999998,"Sold",1,null,null,null,null,null,"Tote Bag",12,1.7999999999999998,"Sold"]
[null,"Clutch",100,15,"In Stock",0,null,null,null,null,null,"Clutch",100,15,"In Stock"]
[null,"Bucket Bag",80,12,"In Stock",0,null,null,null,null,null,"Bucket Bag",80,12,"Sold"]
[null,"Doctor Bag",60,9,"In Stock",0,null,null,null,null,null,"Doctor Bag",60,9,"In Stock"]

{"sheet":"VBA","index":6,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Use of VBA",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product","Sales","Profit","Status",null,null,null,null,null,null,"Product","Sales","Profit","Status"]
[null,"Hand Bag",200,{"$f":"C5*15%","v":30},"Sold",null,null,null,null,null,null,"Hand Bag",200,{"$f":"M5*15%","v":30},"Sold"]
[null,"Travel Bag",95,{"$f":"C6*15%","v":14.25},"In Stock",null,null,null,null,null,null,"Travel Bag",95,{"$f":"M6*15%","v":14.25},"In Stock"]
[null,"Backpack",70,10.5,"Sold",null,null,null,null,null,null,"Backpack",70,10.5,"Sold"]
[null,"School Bag",80,12,"In Stock",null,null,null,null,null,null,"School Bag",80,12,"In Stock"]
[null,"Wallet",20,3,"Sold",null,null,null,null,null,null,"Wallet",20,3,"Sold"]
[null,"Pouch",9,1.3499999999999999,"In Stock",null,null,null,null,null,null,"Pouch",9,1.3499999999999999,"In Stock"]
[null,"Tote Bag",12,1.7999999999999998,"Sold",null,null,null,null,null,null,"Tote Bag",12,1.7999999999999998,"Sold"]
[null,"Clutch",100,15,"In Stock",null,null,null,null,null,null,"Clutch",100,15,"In Stock"]
[null,"Bucket Bag",80,12,"Sold",null,null,null,null,null,null,"Bucket Bag",80,12,"Sold"]
[null,"Doctor Bag",60,9,"In Stock",null,null,null,null,null,null,"Doctor Bag",60,9,"In Stock"]