{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Sheet1","Sheet3","Sheet9","Sheet10","Sheet5","Sheet6","Sheet7","Sheet4","Sheet2","Sheet8","Sheet11"],"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":"Sheet1","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sample Data Set"]
[]
[null,"A","Result"]
[null,50]
[null,100]
[null,150]
[null,200]
[null,250]
[null,600]
[null,750]
[null,500]
[null,450]
[null,900]

{"sheet":"Sheet3","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Copying Formula"]
[]
[null,"A","B","Result","Formula"]
[null,50,5,10,{"$f":"B5/C5","v":10}]
[null,100,10,10,{"$f":"B6/C6","v":10}]
[null,150,5,30,30]
[null,200,20,10,10]
[null,250,25,10,10]
[null,600,30,20,20]
[null,750,25,30,30]
[null,500,20,25,25]
[null,450,22.5,20,20]
[null,900,45,20,20]

{"sheet":"Sheet9","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying Array formula"]
[]
[null,"A","B","Result","Formula"]
[null,50,5,10,{"$f":"B5:B14/C5:C14","v":10}]
[null,100,10,10,10]
[null,150,5,30,30]
[null,200,20,10,10]
[null,250,25,10,10]
[null,600,30,20,20]
[null,750,25,30,30]
[null,500,20,25,25]
[null,450,22.5,20,20]
[null,900,45,20,20]

{"sheet":"Sheet10","index":3,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying VBA Code"]
[]
[null,"A","B","Result"]
[null,50,5,{"$f":"B5/C5","v":10}]
[null,100,10,10]
[null,150,5,30]
[null,200,20,10]
[null,250,25,10]
[null,600,30,20]
[null,750,25,30]
[null,500,20,25]
[null,450,22.5,20]
[null,900,45,20]

{"sheet":"Sheet5","index":4,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Utilizing Paste Special Feature"]
[null,"Divide by",50]
[null,"A"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,12]
[null,15]
[null,10]
[null,9]
[null,18]

{"sheet":"Sheet6","index":5,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Inserting QUOTIENT Function"]
[]
[null,"A","B","Result","Formula 1","Result (QUOTIENT Function)","Formula 2 (QUOTIENT Function)"]
[null,50,29,1.72,{"$f":"B5/C5","v":1.7241379310344827},1,{"$f":"QUOTIENT(B5,C5)","v":1}]
[null,100,15,6.67,{"$f":"B6/C6","v":6.666666666666667},6,{"$f":"QUOTIENT(B6,C6)","v":6}]
[null,150,44,3.41,3.4090909090909092,3,{"$f":"QUOTIENT(B7,C7)","v":3}]
[null,200,50,4,4,4,4]
[null,250,50,5,5,5,5]
[null,600,13,46.15,46.153846153846153,46,46]
[null,750,31,24.19,24.193548387096776,24,24]
[null,500,40,12.5,12.5,12,12]
[null,450,27,16.670000000000002,16.666666666666668,16,16]
[null,900,34,26.47,26.470588235294116,26,26]

{"sheet":"Sheet7","index":6,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null," Using Percentage "]
[]
[null,"A","Result"]
[null,50,{"$f":"B5/25%","v":200}]
[null,100,{"$f":"B6/25%","v":400}]
[null,150,600]
[null,200,800]
[null,250,1000]
[null,600,2400]
[null,750,3000]
[null,500,2000]
[null,450,1800]
[null,900,3600]

{"sheet":"Sheet4","index":7,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Formula (Hard-coded Number)"]
[]
[null,"A","Dividing Column A by Number 10","Formula"]
[null,50,5,{"$f":"B5/10","v":5}]
[null,100,10,{"$f":"B6/10","v":10}]
[null,150,15,15]
[null,200,20,20]
[null,250,25,25]
[null,600,60,60]
[null,750,75,75]
[null,500,50,50]
[null,450,45,45]
[null,900,90,90]

{"sheet":"Sheet2","index":8,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Formula (Dynamic Method)"]
[]
[null,"A","B","Result","Formula"]
[null,50,10,5,{"$f":"B5/$C$5","v":5}]
[null,100,10,10,{"$f":"B6/$C$5","v":10}]
[null,150,10,15,15]
[null,200,10,20,20]
[null,250,10,25,25]
[null,600,10,60,60]
[null,750,10,75,75]
[null,500,10,50,50]
[null,450,10,45,45]
[null,900,10,90,90]

{"sheet":"Sheet8","index":9,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null," Incorporating IFERROR Function"]
[]
[null,"A","B","Result ","Formula"]
[null,50,0,"Not Allowed",{"$f":"IFERROR(B5/C5,\"Not Allowed\")","v":"Not Allowed"}]
[null,100,10,10,{"$f":"IFERROR(B6/C6,\"Not Allowed\")","v":10}]
[null,150,5,30,30]
[null,200,20,10,10]
[null,250,25,10,10]
[null,600,30,20,20]
[null,750,25,30,30]
[null,500,20,25,25]
[null,450,22.5,20,20]
[null,900,45,20,20]

{"sheet":"Sheet11","index":10,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null," Incorporating IF Function"]
[]
[null,"A","B","Result","Formula"]
[null,50,0,"Not Allowed ",{"$f":"IF(C5=0,\"Not Allowed\",B5/C5)","v":"Not Allowed"}]
[null,100,10,10,{"$f":"IF(C6=0,\"Not Allowed\",B6/C6)","v":10}]
[null,150,5,30,30]
[null,200,20,10,10]
[null,250,25,10,10]
[null,600,30,20,20]
[null,750,25,30,30]
[null,500,20,25,25]
[null,450,22.5,20,20]
[null,900,45,20,20]