{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","Markup","Margin ","ROUNDUP","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":"Dataset","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"List of Products"]
[]
[null,"Product Name","Cost"]
[null,"Apple",4]
[null,"Orange",8]
[null,"Guava",4]
[null,"Coconut",5]
[null,"Apricot",3]
[null,"Watermelon",7]
[null,"Jackfruit",9]
[null,"Kiwi",3]
[null,"Lemon",6]
[null,"Avocado",5]

{"sheet":"Markup","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Calculating Selling Price from Cost and Markup"]
[]
[null,"Product Name","Cost","Markup","Selling Price"]
[null,"Apple",4,0.25,{"$f":"C5*(1+D5)","v":5}]
[null,"Orange",8,0.25,{"$f":"C6*(1+D6)","v":10}]
[null,"Guava",4,0.25,5]
[null,"Coconut",5,0.25,6.25]
[null,"Apricot",3,0.25,3.75]
[null,"Watermelon",7,0.25,8.75]
[null,"Jackfruit",9,0.25,11.25]
[null,"Kiwi",3,0.25,3.75]
[null,"Lemon",6,0.25,7.5]
[null,"Avocado",5,0.25,6.25]

{"sheet":"Margin ","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Calculating Selling Price from Cost and Margin"]
[]
[null,"Product Name","Cost","Margin","Selling Price"]
[null,"Apple",4,0.2,{"$f":"C5/(1-D5)","v":5}]
[null,"Orange",8,0.2,{"$f":"C6/(1-D6)","v":10}]
[null,"Guava",4,0.2,5]
[null,"Coconut",5,0.2,6.25]
[null,"Apricot",3,0.2,3.75]
[null,"Watermelon",7,0.2,8.75]
[null,"Jackfruit",9,0.2,11.25]
[null,"Kiwi",3,0.2,3.75]
[null,"Lemon",6,0.2,7.5]
[null,"Avocado",5,0.2,6.25]

{"sheet":"ROUNDUP","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Calculating Selling Price Using ROUNDUP Function"]
[]
[null,"Product Name","Cost","Margin","Selling Price","Selling Price (Rounded)"]
[null,"Apple",4,0.2,{"$f":"C5/(1-D5)","v":5},{"$f":"ROUNDUP(E5,0)","v":5}]
[null,"Orange",8,0.2,{"$f":"C6/(1-D6)","v":10},{"$f":"ROUNDUP(E6,0)","v":10}]
[null,"Guava",4,0.2,5,5]
[null,"Coconut",5,0.2,6.25,7]
[null,"Apricot",3,0.2,3.75,4]
[null,"Watermelon",7,0.2,8.75,9]
[null,"Jackfruit",9,0.2,11.25,12]
[null,"Kiwi",3,0.2,3.75,4]
[null,"Lemon",6,0.2,7.5,8]
[null,"Avocado",5,0.2,6.25,7]

{"sheet":"VBA","index":4,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using VBA Code"]
[]
[null,"Product Name","Cost","Markup","Selling Price"]
[null,"Apple",4,0.25,{"$f":"Sellingprice(C5,D5)","v":5}]
[null,"Orange",8,0.25,{"$f":"Sellingprice(C6,D6)","v":10}]
[null,"Guava",4,0.25,{"$f":"Sellingprice(C7,D7)","v":5}]
[null,"Coconut",5,0.25,{"$f":"Sellingprice(C8,D8)","v":6.25}]
[null,"Apricot",3,0.25,{"$f":"Sellingprice(C9,D9)","v":3.75}]
[null,"Watermelon",7,0.25,{"$f":"Sellingprice(C10,D10)","v":8.75}]
[null,"Jackfruit",9,0.25,{"$f":"Sellingprice(C11,D11)","v":11.25}]
[null,"Kiwi",3,0.25,{"$f":"Sellingprice(C12,D12)","v":3.75}]
[null,"Lemon",6,0.25,{"$f":"Sellingprice(C13,D13)","v":7.5}]
[null,"Avocado",5,0.25,{"$f":"Sellingprice(C14,D14)","v":6.25}]