{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Price Difference","Price Ratio","VBA"],"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":"Price Difference","index":0,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,7,2,10]]}
[]
[]
[null,"Calculating Discount Percentage with Formula",null,null,null,null,null,"For Practice"]
[]
[null,"Products","Listed Price","Selling price","Discount(%)",null,null,"Products","Listed Price","Selling price","Discount(%)"]
[null,"Eggs",150,130,{"$f":"(C6-D6)/C6","v":0.13333333333333333},null,null,"Eggs",150,130]
[null,"Bread",120,80,{"$f":"(C7-D7)/C7","v":0.33333333333333331},null,null,"Bread",120,80]
[null,"Milk",80,70,0.125,null,null,"Milk",80,70]
[null,"Cereal",75,60,0.2,null,null,"Cereal",75,60]
[null,"CHOCOLATE BARS",140,130,7.1428571428571425E-2,null,null,"CHOCOLATE BARS",140,130]

{"sheet":"Price Ratio","index":1,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,7,2,10]]}
[]
[]
[null,"Calculating Discount Percentage with Formula",null,null,null,null,null,"For Practice"]
[]
[null,"Products","Listed Price","Selling price","Discount(%)",null,null,"Products","Listed Price","Selling price","Discount(%)"]
[null,"Eggs",150,130,{"$f":"(1-(D6/C6))","v":0.1333333333333333},null,null,"Eggs",150,130]
[null,"Bread",120,80,{"$f":"(1-(D7/C7))","v":0.33333333333333337},null,null,"Bread",120,80]
[null,"Milk",80,70,0.125,null,null,"Milk",80,70]
[null,"Cereal",75,60,0.19999999999999996,null,null,"Cereal",75,60]
[null,"CHOCOLATE BARS",140,130,7.1428571428571397E-2,null,null,"CHOCOLATE BARS",140,130]

{"sheet":"VBA","index":2,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,7,2,10]]}
[]
[]
[null,"Calculating Discount Percentage with Formula",null,null,null,null,null,"For Practice"]
[]
[null,"Products","Listed Price","Selling price","Discount(%)",null,null,"Products","Listed Price","Selling price","Discount(%)"]
[null,"Eggs",150,130,{"$f":"1-(D6/C6)","v":0.1333333333333333},null,null,"Eggs",150,130]
[null,"Bread",120,80,{"$f":"1-(D7/C7)","v":0.33333333333333337},null,null,"Bread",120,80]
[null,"Milk",80,70,{"$f":"1-(D8/C8)","v":0.125},null,null,"Milk",80,70]
[null,"Cereal",75,60,{"$f":"1-(D9/C9)","v":0.19999999999999996},null,null,"Cereal",75,60]
[null,"CHOCOLATE BARS",140,130,{"$f":"1-(D10/C10)","v":7.1428571428571397E-2},null,null,"CHOCOLATE BARS",140,130]