{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Example 1","Example 2","Example 3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"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":"Example 1","index":0,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,3],[1,10,1,13],[11,10,11,12]]}
[]
[null,"Calculating Net Price",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Product","Quantity","Color Code","Net Price",null,null,null,null,null,"Product","Quantity","Color Code","Net Price"]
[null,"T-shirt",590,{"$f":"CellColor","v":36},{"$f":"IF(CellColor=40,C5*$E$12,\"-\")","v":"-"},null,null,null,null,null,"T-shirt",590]
[null,"Hoodie",740,{"$f":"CellColor","v":40},{"$f":"IF(CellColor=40,C6*$E$12,\"-\")","v":3700},null,null,null,null,null,"Hoodie",740]
[null,"Pant",540,{"$f":"CellColor","v":36},{"$f":"IF(CellColor=40,C7*$E$12,\"-\")","v":"-"},null,null,null,null,null,"Pant",540]
[null,"Jacket",410,{"$f":"CellColor","v":40},{"$f":"IF(CellColor=40,C8*$E$12,\"-\")","v":2050},null,null,null,null,null,"Jacket",410]
[null,"Blazer",320,{"$f":"CellColor","v":42},{"$f":"IF(CellColor=40,C9*$E$12,\"-\")","v":"-"},null,null,null,null,null,"Blazer",320]
[null,"Sweater",400,{"$f":"CellColor","v":40},{"$f":"IF(CellColor=40,C10*$E$12,\"-\")","v":2000},null,null,null,null,null,"Sweater",400]
[]
[null,"Per Piece Price for Hoodie, Jacket & Sweater",null,null,5,null,null,null,null,null,"Per Piece Price for Hoodie, Jacket & Sweater",null,null,5]

{"sheet":"Example 2","index":1,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,3],[1,10,1,13],[11,10,11,12]]}
[]
[null,"Calculating Discounted Price",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Item","Price","Color Code","Discounted Price",null,null,null,null,null,"Item","Price","Color Code","Discounted Price"]
[null,"Rice",2.5,{"$f":"ColorCell","v":39},{"$f":"IF(ColorCell=39,C5-C5*$E$12,\"No Discount\")","v":2.25},null,null,null,null,null,"Rice",2.5]
[null,"Wheat",1.7,{"$f":"ColorCell","v":42},{"$f":"IF(ColorCell=39,C6-C6*$E$12,\"No Discount\")","v":"No Discount"},null,null,null,null,null,"Wheat",1.7]
[null,"Oil",4.2,{"$f":"ColorCell","v":39},{"$f":"IF(ColorCell=39,C7-C7*$E$12,\"No Discount\")","v":3.7800000000000002},null,null,null,null,null,"Oil",4.2]
[null,"Honey",5,{"$f":"ColorCell","v":42},{"$f":"IF(ColorCell=39,C8-C8*$E$12,\"No Discount\")","v":"No Discount"},null,null,null,null,null,"Honey",5]
[null,"Corn",1.2,{"$f":"ColorCell","v":18},{"$f":"IF(ColorCell=39,C9-C9*$E$12,\"No Discount\")","v":"No Discount"},null,null,null,null,null,"Corn",1.2]
[null,"Milk",2,{"$f":"ColorCell","v":39},{"$f":"IF(ColorCell=39,C10-C10*$E$12,\"No Discount\")","v":1.8},null,null,null,null,null,"Milk",2]
[]
[null,"Discount on Selected Items",null,null,0.1,null,null,null,null,null,"Discount on Selected Items",null,null,0.1]

{"sheet":"Example 3","index":2,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,3],[1,10,1,13],[11,10,11,12]]}
[]
[null,"Calculating Bonus on Sales",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Sales","Color Code","Bonus",null,null,null,null,null,"Name","Sales","Color Code","Bonus"]
[null,"Adam",8000,{"$f":"ColorCode","v":37},{"$f":"IF(CellColor=40,C5*$E$12,0)","v":0},null,null,null,null,null,"Adam",8000]
[null,"John",10000,{"$f":"ColorCode","v":40},{"$f":"IF(CellColor=40,C6*$E$12,0)","v":1200},null,null,null,null,null,"John",10000]
[null,"Chris",5000,{"$f":"ColorCode","v":37},{"$f":"IF(CellColor=40,C7*$E$12,0)","v":0},null,null,null,null,null,"Chris",5000]
[null,"Bob",11000,{"$f":"ColorCode","v":40},{"$f":"IF(CellColor=40,C8*$E$12,0)","v":1320},null,null,null,null,null,"Bob",11000]
[null,"Clary",2500,{"$f":"ColorCode","v":19},{"$f":"IF(CellColor=40,C9*$E$12,0)","v":0},null,null,null,null,null,"Clary",2500]
[null,"Edmond",15000,{"$f":"ColorCode","v":40},{"$f":"IF(CellColor=40,C10*$E$12,0)","v":1800},null,null,null,null,null,"Edmond",15000]
[]
[null,"Percentage of Bonus on Sales",null,null,0.12,null,null,null,null,null,"Percentage of Bonus on Sales",null,null,0.12]