{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset 1","Mathematical Formula","SUMPRODUCT","VBA Macro","Dataset 2","Midpoint Rule"],"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 1","index":0,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,3],[20,1,20,2]]}
[]
[null,"Data Chart "]
[]
[null,"Distance (m)","Force (N)","Work Done (J) per Interval"]
[null,1,27]
[null,1.5,15]
[null,2,24]
[null,2.5,18]
[null,3,25]
[null,3.5,30]
[null,4,15]
[null,4.5,18]
[null,5,13]
[null,5.5,16]
[null,6,22]
[null,6.5,18]
[null,7,30]
[null,7.5,30]
[null,8,20]
[null,8.5,17]
[null,"Total Work Done (J)"]

{"sheet":"Mathematical Formula","index":1,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,1,20,2],[1,1,1,3],[1,9,1,11],[20,9,20,10]]}
[]
[null,"Using Mathematical Formula",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Distance (m)","Force (N)","Work Done (J) per Interval",null,null,null,null,null,"Distance (m)","Force (N)","Work Done (J) per Interval"]
[null,1,27,null,null,null,null,null,null,1,27]
[null,1.5,15,{"$f":"(B6-B5)*(C5+C6)/2","v":10.5},null,null,null,null,null,1.5,15]
[null,2,24,{"$f":"(B7-B6)*(C6+C7)/2","v":9.75},null,null,null,null,null,2,24]
[null,2.5,18,10.5,null,null,null,null,null,2.5,18]
[null,3,25,10.75,null,null,null,null,null,3,25]
[null,3.5,30,13.75,null,null,null,null,null,3.5,30]
[null,4,15,11.25,null,null,null,null,null,4,15]
[null,4.5,18,8.25,null,null,null,null,null,4.5,18]
[null,5,13,7.75,null,null,null,null,null,5,13]
[null,5.5,16,7.25,null,null,null,null,null,5.5,16]
[null,6,22,9.5,null,null,null,null,null,6,22]
[null,6.5,18,10,null,null,null,null,null,6.5,18]
[null,7,30,12,null,null,null,null,null,7,30]
[null,7.5,30,15,null,null,null,null,null,7.5,30]
[null,8,20,12.5,null,null,null,null,null,8,20]
[null,8.5,17,9.25,null,null,null,null,null,8.5,17]
[null,"Total Work Done (J)",null,{"$f":"SUM(D6:D20)","v":158},null,null,null,null,null,"Total Work Done (J)"]

{"sheet":"SUMPRODUCT","index":2,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,3,19,3],[1,10,1,12],[4,12,19,12]]}
[]
[null,"Applying SUMPRODUCT Function",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Distance (m)","Force (N)","Total Work Done (J)",null,null,null,null,null,null,"Distance (m)","Force (N)","Total Work Done (J)"]
[null,1,27,{"$f":"SUMPRODUCT(B6:B20-B5:B19,(C6:C20+C5:C19)/2)","v":158},null,null,null,null,null,null,1,27]
[null,1.5,15,null,null,null,null,null,null,null,1.5,15]
[null,2,24,null,null,null,null,null,null,null,2,24]
[null,2.5,18,null,null,null,null,null,null,null,2.5,18]
[null,3,25,null,null,null,null,null,null,null,3,25]
[null,3.5,30,null,null,null,null,null,null,null,3.5,30]
[null,4,15,null,null,null,null,null,null,null,4,15]
[null,4.5,18,null,null,null,null,null,null,null,4.5,18]
[null,5,13,null,null,null,null,null,null,null,5,13]
[null,5.5,16,null,null,null,null,null,null,null,5.5,16]
[null,6,22,null,null,null,null,null,null,null,6,22]
[null,6.5,18,null,null,null,null,null,null,null,6.5,18]
[null,7,30,null,null,null,null,null,null,null,7,30]
[null,7.5,30,null,null,null,null,null,null,null,7.5,30]
[null,8,20,null,null,null,null,null,null,null,8,20]
[null,8.5,17,null,null,null,null,null,null,null,8.5,17]

{"sheet":"VBA Macro","index":3,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,3,19,3],[1,10,1,12],[4,12,19,12]]}
[]
[null,"Utilizing VBA Macro",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Distance (m)","Force (N)","Total Work Done (J)",null,null,null,null,null,null,"Distance (m)","Force (N)","Total Work Done (J)"]
[null,1,27,{"$f":"TrapezoidalIntegration(B5:B20,C5:C20)","v":158},null,null,null,null,null,null,1,27]
[null,1.5,15,null,null,null,null,null,null,null,1.5,15]
[null,2,24,null,null,null,null,null,null,null,2,24]
[null,2.5,18,null,null,null,null,null,null,null,2.5,18]
[null,3,25,null,null,null,null,null,null,null,3,25]
[null,3.5,30,null,null,null,null,null,null,null,3.5,30]
[null,4,15,null,null,null,null,null,null,null,4,15]
[null,4.5,18,null,null,null,null,null,null,null,4.5,18]
[null,5,13,null,null,null,null,null,null,null,5,13]
[null,5.5,16,null,null,null,null,null,null,null,5.5,16]
[null,6,22,null,null,null,null,null,null,null,6,22]
[null,6.5,18,null,null,null,null,null,null,null,6.5,18]
[null,7,30,null,null,null,null,null,null,null,7,30]
[null,7.5,30,null,null,null,null,null,null,null,7.5,30]
[null,8,20,null,null,null,null,null,null,null,8,20]
[null,8.5,17,null,null,null,null,null,null,null,8.5,17]

{"sheet":"Dataset 2","index":4,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,4],[19,1,19,3]]}
[]
[null,"Applying Midpoint Rule"]
[]
[null,"n Value","x Value","f(x) Value","Integral Value"]
[null,1]
[null,{"$f":"1+B5","v":2}]
[null,{"$f":"1+B6","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,"Final Integral Value"]
[]
[null,"dx=(b-a)/15"]
[null,"dx/2"]

{"sheet":"Midpoint Rule","index":5,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[19,1,19,3],[1,1,1,4],[1,11,1,14],[19,11,19,13]]}
[]
[null,"Applying Midpoint Rule",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"n Value","x Value","f(x) Value","Integral Value",null,null,null,null,null,null,"n Value","x Value","f(x) Value","Integral Value"]
[null,1,{"$f":"1+C23","v":1.1333333333333333},{"$f":"(1+(C5^3))","v":2.4557037037037035},{"$f":"D5*$C$22","v":0.65485432098765428},null,null,null,null,null,null,1]
[null,{"$f":"1+B5","v":2},{"$f":"C5+$C$22","v":1.4},{"$f":"(1+(C6^3))","v":3.7439999999999993},0.99839999999999984,null,null,null,null,null,null,{"$f":"1+L5","v":2}]
[null,{"$f":"1+B6","v":3},1.6666666666666665,5.629629629629628,1.5012345679012342,null,null,null,null,null,null,{"$f":"1+L6","v":3}]
[null,4,1.9333333333333331,8.2263703703703683,2.1936987654320981,null,null,null,null,null,null,4]
[null,5,2.1999999999999997,11.647999999999996,3.1061333333333323,null,null,null,null,null,null,5]
[null,6,2.4666666666666663,16.00829629629629,4.2688790123456775,null,null,null,null,null,null,6]
[null,7,2.7333333333333329,21.421037037037028,5.7122765432098737,null,null,null,null,null,null,7]
[null,8,2.9999999999999996,27.999999999999986,7.4666666666666623,null,null,null,null,null,null,8]
[null,9,3.2666666666666662,35.858962962962948,9.5623901234567867,null,null,null,null,null,null,9]
[null,10,3.5333333333333328,45.111703703703682,12.029787654320982,null,null,null,null,null,null,10]
[null,11,3.7999999999999994,55.871999999999979,14.899199999999993,null,null,null,null,null,null,11]
[null,12,4.0666666666666664,68.253629629629614,18.200967901234563,null,null,null,null,null,null,12]
[null,13,4.333333333333333,82.370370370370352,21.965432098765426,null,null,null,null,null,null,13]
[null,14,4.5999999999999996,98.33599999999997,26.222933333333327,null,null,null,null,null,null,14]
[null,15,4.8666666666666663,116.26429629629627,31.003812345679005,null,null,null,null,null,null,15]
[null,"Final Integral Value",null,null,{"$f":"SUM(E5:E19)","v":159.7866666666666},null,null,null,null,null,null,"Final Integral Value"]
[]
[null,"dx=(b-a)/15",{"$f":"(5-1)/15","v":0.26666666666666666},null,null,null,null,null,null,null,null,"dx=(b-a)/15"]
[null,"dx/2",{"$f":"C22/2","v":0.13333333333333333},null,null,null,null,null,null,null,null,"dx/2"]