{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Overview","Dataset"," Calculation Options Automatic"," Calculation Options Manual","Manually Calculating Sheet","Adding Manual and Automatic","Using VBA Macro","Iterative Calculation","Setting Calculation Precision"],"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":"Overview","index":0,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[11,1,11,3],[13,1,13,4],[1,1,1,5]]}
[]
[null,"Overview of Using Excel Calculation Options"]
[]
[null,"Product","Price","Quantity","Sales","Formulas"]
[null,"Desktop",200,20,{"$f":"C5*D5","v":4000},{"$f":"_xlfn.FORMULATEXT(E5)","v":"=C5*D5"}]
[null,"Laptop",500,15,{"$f":"C6*D6","v":7500},{"$f":"_xlfn.FORMULATEXT(E6)","v":"=C6*D6"}]
[null,"Smartphone",400,14,5600,"=C7*D7"]
[null,"Keyboard",50,6,300,"=C8*D8"]
[null,"Mouse",20,10,200,"=C9*D9"]
[null,"Printer",100,15,1500,"=C10*D10"]
[null,"CPU",150,14,2100,"=C11*D11"]
[null,"Total Sales",null,null,{"$f":"SUM(E5:E11)","v":21200},"=SUM(E5:E11)"]
[]
[null,">>Changing Values in Cells D5 and D6 will Automatically Change Values in Cells E5, E6 and E12"]

{"sheet":"Dataset","index":1,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,1,11,3],[1,1,1,5]]}
[]
[null,"Dataset of Using Excel Calculation Options"]
[]
[null,"Product","Price","Quantity","Sales","Formulas"]
[null,"Desktop",200,25,{"$f":"C5*D5","v":5000},{"$f":"_xlfn.FORMULATEXT(E5)","v":"=C5*D5"}]
[null,"Laptop",500,20,{"$f":"C6*D6","v":10000},{"$f":"_xlfn.FORMULATEXT(E6)","v":"=C6*D6"}]
[null,"Smartphone",400,14,5600,"=C7*D7"]
[null,"Keyboard",50,6,300,"=C8*D8"]
[null,"Mouse",20,10,200,"=C9*D9"]
[null,"Printer",100,15,1500,"=C10*D10"]
[null,"CPU",150,14,2100,"=C11*D11"]
[null,"Total Sales",null,null,{"$f":"SUM(E5:E11)","v":24700},"=SUM(E5:E11)"]

{"sheet":" Calculation Options Automatic","index":2,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,3],[13,1,13,4],[1,8,1,11],[11,8,11,10]]}
[]
[null,"Changing Calculation Options to Automatic",null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product","Price","Quantity","Sales",null,null,null,"Product","Price","Quantity","Sales"]
[null,"Desktop",200,20,{"$f":"C5*D5","v":4000},null,null,null,"Desktop",200,25,{"$f":"J5*K5","v":5000}]
[null,"Laptop",500,15,{"$f":"C6*D6","v":7500},null,null,null,"Laptop",500,20,{"$f":"J6*K6","v":10000}]
[null,"Smartphone",400,14,5600,null,null,null,"Smartphone",400,14,5600]
[null,"Keyboard",50,6,300,null,null,null,"Keyboard",50,6,300]
[null,"Mouse",20,10,200,null,null,null,"Mouse",20,10,200]
[null,"Printer",100,15,1500,null,null,null,"Printer",100,15,1500]
[null,"CPU",150,14,2100,null,null,null,"CPU",150,14,2100]
[null,"Total Sales",null,null,{"$f":"SUM(E5:E11)","v":21200},null,null,null,"Total Sales",null,null,{"$f":"SUM(L5:L11)","v":24700}]
[]
[null,">>Changing Values in Cells D5 and D6 will Automatically Change Values in Cells E5, E6 and E12"]

{"sheet":" Calculation Options Manual","index":3,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,3],[13,1,13,4],[1,8,1,11],[11,8,11,10]]}
[]
[null,"Changing Calculation Options to Manual",null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product","Price","Quantity","Sales",null,null,null,"Product","Price","Quantity","Sales"]
[null,"Desktop",200,20,{"$f":"C5*D5","v":4000},null,null,null,"Desktop",200,25,{"$f":"J5*K5","v":5000}]
[null,"Laptop",500,15,{"$f":"C6*D6","v":7500},null,null,null,"Laptop",500,20,{"$f":"J6*K6","v":10000}]
[null,"Smartphone",400,14,5600,null,null,null,"Smartphone",400,14,5600]
[null,"Keyboard",50,6,300,null,null,null,"Keyboard",50,6,300]
[null,"Mouse",20,10,200,null,null,null,"Mouse",20,10,200]
[null,"Printer",100,15,1500,null,null,null,"Printer",100,15,1500]
[null,"CPU",150,14,2100,null,null,null,"CPU",150,14,2100]
[null,"Total Sales",null,null,{"$f":"SUM(E5:E11)","v":21200},null,null,null,"Total Sales",null,null,{"$f":"SUM(L5:L11)","v":24700}]
[]
[null,">>Changing Values in Cells D5 and D6 will not Change Values in Cells E5, E6 and E12"]

{"sheet":"Manually Calculating Sheet","index":4,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,3],[13,1,13,4],[1,8,1,11],[11,8,11,10]]}
[]
[null,"Manually Calculating Sheet from Formulas Tab",null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product","Price","Quantity","Sales",null,null,null,"Product","Price","Quantity","Sales"]
[null,"Desktop",200,20,{"$f":"C5*D5","v":4000},null,null,null,"Desktop",200,25,{"$f":"J5*K5","v":5000}]
[null,"Laptop",500,15,{"$f":"C6*D6","v":7500},null,null,null,"Laptop",500,20,{"$f":"J6*K6","v":10000}]
[null,"Smartphone",400,14,5600,null,null,null,"Smartphone",400,14,5600]
[null,"Keyboard",50,6,300,null,null,null,"Keyboard",50,6,300]
[null,"Mouse",20,10,200,null,null,null,"Mouse",20,10,200]
[null,"Printer",100,15,1500,null,null,null,"Printer",100,15,1500]
[null,"CPU",150,14,2100,null,null,null,"CPU",150,14,2100]
[null,"Total Sales",null,null,{"$f":"SUM(E5:E11)","v":21200},null,null,null,"Total Sales",null,null,{"$f":"SUM(L5:L11)","v":24700}]
[]
[null,">>Change Values in Cells D5 and D6"]

{"sheet":"Adding Manual and Automatic","index":5,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,3],[1,8,1,11],[11,8,11,10]]}
[]
[null,"Adding Manual and Automatic Commands",null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product","Price","Quantity","Sales",null,null,null,"Product","Price","Quantity","Sales"]
[null,"Desktop",200,25,{"$f":"C5*D5","v":5000},null,null,null,"Desktop",200,25,{"$f":"J5*K5","v":5000}]
[null,"Laptop",500,20,{"$f":"C6*D6","v":10000},null,null,null,"Laptop",500,20,{"$f":"J6*K6","v":10000}]
[null,"Smartphone",400,14,5600,null,null,null,"Smartphone",400,14,5600]
[null,"Keyboard",50,6,300,null,null,null,"Keyboard",50,6,300]
[null,"Mouse",20,10,200,null,null,null,"Mouse",20,10,200]
[null,"Printer",100,15,1500,null,null,null,"Printer",100,15,1500]
[null,"CPU",150,14,2100,null,null,null,"CPU",150,14,2100]
[null,"Total Sales",null,null,{"$f":"SUM(E5:E11)","v":24700},null,null,null,"Total Sales",null,null,{"$f":"SUM(L5:L11)","v":24700}]

{"sheet":"Using VBA Macro","index":6,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,3],[1,7,1,10],[11,7,11,9]]}
[]
[null,"Using VBA Macro to Change Calculation Options",null,null,null,null,null,"Practice Section"]
[]
[null,"Product","Price","Quantity","Sales",null,null,"Product","Price","Quantity","Sales"]
[null,"Desktop",200,25,{"$f":"C5*D5","v":5000},null,null,"Desktop",200,25,{"$f":"I5*J5","v":5000}]
[null,"Laptop",200,15,{"$f":"C6*D6","v":3000},null,null,"Laptop",500,20,{"$f":"I6*J6","v":10000}]
[null,"Smartphone",400,14,5600,null,null,"Smartphone",400,14,5600]
[null,"Keyboard",50,6,300,null,null,"Keyboard",50,6,300]
[null,"Mouse",20,10,200,null,null,"Mouse",20,10,200]
[null,"Printer",100,15,1500,null,null,"Printer",100,15,1500]
[null,"CPU",150,14,2100,null,null,"CPU",150,14,2100]
[null,"Total Sales",null,null,{"$f":"SUM(E5:E11)","v":17700},null,null,"Total Sales",null,null,{"$f":"SUM(K5:K11)","v":24700}]

{"sheet":"Iterative Calculation","index":7,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Enabling Iterative Calculation from File Tab",null,null,null,null,null,"Practice Section"]
[]
[null,"Product","Delivered Status","Delivery Time",null,null,null,"Product","Delivered Status","Delivery Time"]
[null,"Desktop",null,{"$f":"IF(C5=\"yes\", IF(D5=\"\",NOW(), D5), \"\")","v":""},null,null,null,"Desktop"]
[null,"Laptop","Yes",{"$f":"IF(C6=\"yes\", IF(D6=\"\",NOW(), D6), \"\")","v":"2023-07-23T16:09:48.890"},null,null,null,"Laptop","Yes"]
[null,"Smartphone",null,"",null,null,null,"Smartphone"]
[null,"Keyboard","Yes","2023-07-23T16:09:48.900",null,null,null,"Keyboard","Yes"]
[null,"Mouse",null,"",null,null,null,"Mouse"]
[null,"Printer","Yes","2023-07-23T16:09:48.900",null,null,null,"Printer","Yes"]
[null,"CPU",null,"",null,null,null,"CPU"]

{"sheet":"Setting Calculation Precision","index":8,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[12,1,12,3],[14,1,14,4],[1,9,1,12],[12,9,12,11]]}
[]
[null,"Setting Calculation Precision from File Tab",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product","Price","Quantity","Sales",null,null,null,null,"Product","Price","Quantity","Sales"]
[null,"Desktop",200.00200000000001,25,{"$f":"C5*D5","v":5000.05},null,null,null,null,"Desktop",200.00200000000001,25,{"$f":"K5*L5","v":5000.05}]
[null,"Laptop",200.00299999999999,15,{"$f":"C6*D6","v":3000.0449999999996},null,null,null,null,"Laptop",200.00299999999999,20,{"$f":"K6*L6","v":4000.0599999999995}]
[null,"Smartphone",400,14,5600,null,null,null,null,"Smartphone",400,14,5600]
[null,"Keyboard",50,6,300,null,null,null,null,"Keyboard",50,6,300]
[null,"Mouse",20,10,200,null,null,null,null,"Mouse",20,10,200]
[null,"Printer",100,15,1500,null,null,null,null,"Printer",100,15,1500]
[null,"CPU",150,14,2100,null,null,null,null,"CPU",150,14,2100]
[]
[null,"Total Price of Desktop and Laptop",null,null,{"$f":"C5+C6","v":400.005},{"$f":"_xlfn.FORMULATEXT(E13)","v":"=C5+C6"},null,null,null,"Total Price of Desktop and Laptop",null,null,{"$f":"K5+K6","v":400.005}]
[]
[null,">>We Put 200.002 in Cell C5 and 200.003 in Cell C6 then Displayed them upto 2 Decimal Places\nSo it is showing 400.01 in Cell E13 instead of 400.00"]