{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["total","marks","yearly sales","Increase by percent","Decrease","VBA","proportion","discount","actual price","Tax"],"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":"total","index":0,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Calculate Percentage of a Total"]
[]
[null,"Total Question","Correct Answer","Percentage"]
[null,50,35,{"$f":"C5/B5","v":0.7}]

{"sheet":"marks","index":1,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Calculate Percentage of Marks"]
[]
[null,"Name","Subject","Summer-22","Fall-22","Increase in Marks"]
[null,"Aaron","Math",35,40,{"$f":"(E5-D5)/D5","v":0.14285714285714285}]
[null,"Jason","Biology",40,55,{"$f":"(E6-D6)/D6","v":0.375}]
[null,"Max","Math",45,64,0.42222222222222222]
[null,"Stacy","Physics",44,59,0.34090909090909088]
[null,"Elizabeth","Chemistry",32,49,0.53125]
[null,"Robert","Math",67,78,0.16417910447761194]
[null,"Chris","Physics",72,89,0.2361111111111111]

{"sheet":"yearly sales","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Calculate Percentage Increase of Yearly Sales"]
[]
[null,"Year","Sales (in Million)","Increase in Yearly Sales"]
[null,2016,1.3]
[null,2017,2,{"$f":"(C6-C5)/C5","v":0.53846153846153844}]
[null,2018,2.2999999999999998,{"$f":"(C7-C6)/C6","v":0.14999999999999991}]
[null,2019,2.7,0.17391304347826103]
[null,2020,3,0.11111111111111104]
[null,2021,3.6,0.20000000000000004]
[null,2022,4,0.11111111111111108]

{"sheet":"Increase by percent","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Increase by Particular Percent"]
[]
[null,"Product","Original Value","Increase By","New Value"]
[null,"TV",500,0.05,{"$f":"C5+(C5*D5)","v":525}]
[null,"AC",700,0.04,{"$f":"C6+(C6*D6)","v":728}]
[null,"Fridge",550,0.1,605]
[null,"Mobile",120,0.12,134.4]
[null,"Laptop",300,0.09,327]
[null,"Computer",350,0.11,388.5]
[null,"Headphone",50,0.03,51.5]

{"sheet":"Decrease","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Calculate Percentage Decrease"]
[]
[null,"Product","October","November","Decrease"]
[null,"TV",500,450,{"$f":"(C5-D5)/C5","v":0.1}]
[null,"AC",700,660,{"$f":"(C6-D6)/C6","v":5.7142857142857141E-2}]
[null,"Fridge",550,540,1.8181818181818181E-2]
[null,"Mobile",120,113,5.8333333333333334E-2]
[null,"Laptop",300,256,0.14666666666666667]
[null,"Computer",350,300,0.14285714285714285]
[null,"Headphone",50,40,0.2]

{"sheet":"VBA","index":5,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Show Increase or Decrease"]
[]
[null,"Product","October","November","Decrease"]
[null,"TV",500,450,"10% Decrease"]
[null,"AC",700,720,"3% Increase"]
[null,"Fridge",550,550,"No change"]
[null,"Mobile",120,133,"11% Increase"]
[null,"Laptop",300,256,"15% Decrease"]
[null,"Computer",350,350,"No change"]
[null,"Headphone",50,60,"20% Increase"]

{"sheet":"proportion","index":6,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Percentage as a Proportion of a Number"]
[]
[null,"Amount","Paid","Payment Proportion","Due Proportion"]
[null,1000,725,{"$f":"C5/B5","v":0.72499999999999998},{"$f":"100%-D5","v":0.27500000000000002}]

{"sheet":"discount","index":7,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Calculate Dicount Percentage"]
[]
[null,"Amount","Status","Final Amount"]
[null,500,"VIP",{"$f":"IF(C5=\"VIP\",(1-30%)*B5,IF(C5=\"REGULAR\",(1-15%)*B5,B5))","v":350}]
[null,700,"NEW",{"$f":"IF(C6=\"VIP\",(1-30%)*B6,IF(C6=\"REGULAR\",(1-15%)*B6,B6))","v":700}]
[null,550,"REGULAR",467.5]
[null,120,"VIP",84]
[null,300,"REGULAR",255]
[null,350,"NEW",350]
[null,50,"VIP",35]

{"sheet":"actual price","index":8,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Find Actual Price"]
[]
[null,"Buying Price","Percentage ","Actual Price"]
[null,500,0.75,{"$f":"B5/C5","v":666.66666666666663}]

{"sheet":"Tax","index":9,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Calculate Flat Price"]
[]
[null,"Buying Price","Tax","Additional Amount"]
[null,150000,7.8E-2,{"$f":"B5*C5","v":11700}]