{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","ABS Function","IF Function","MAX MIN Function","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":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Speed vs Speeding Limits"]
[]
[null,"Permissible Speed Limit in Different States (MPH)","Vehicle Speed (MPH)"]
[null,65,80]
[null,75,70]
[null,55,78]
[null,80,95]
[null,70,60]
[null,65,80]

{"sheet":"ABS Function","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using ABS Function"]
[]
[null,"Permissible Speed Limit in Different States (MPH)","Vehicle Speed (MPH)","Normal Difference","Absolute Difference"]
[null,65,80,{"$f":"B5-C5","v":-15},{"$f":"ABS(B5-C5)","v":15}]
[null,75,70,{"$f":"B6-C6","v":5},{"$f":"ABS(B6-C6)","v":5}]
[null,55,78,-23,23]
[null,80,95,-15,15]
[null,70,60,10,10]
[null,65,80,-15,15]

{"sheet":"IF Function","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using IF Function"]
[]
[null,"Permissible Speed Limit in Different States (MPH)","Vehicle Speed (MPH)","Absolute Difference"]
[null,65,80,{"$f":"IF(C5>=B5,C5-B5,B5-C5)","v":15}]
[null,75,70,{"$f":"IF(C6>=B6,C6-B6,B6-C6)","v":5}]
[null,55,78,23]
[null,80,95,15]
[null,70,60,10]
[null,65,80,15]

{"sheet":"MAX MIN Function","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using MAX and MIN Function"]
[]
[null,"Permissible Speed Limit in Different States (MPH)","Vehicle Speed (MPH)","Absolute Difference"]
[null,65,80,{"$f":"MAX(B5,C5) - MIN(B5,C5)","v":15}]
[null,75,70,{"$f":"MAX(B6,C6) - MIN(B6,C6)","v":5}]
[null,55,78,23]
[null,80,95,15]
[null,70,60,10]
[null,65,80,15]

{"sheet":"VBA","index":4,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Custom VBA Function"]
[]
[null,"Permissible Speed Limit in Different States (MPH)","Average Daily Vehicle Speed (MPH)","Absolute Difference"]
[null,65,80,{"$f":"AbsoluteDifference(B5,C5)","v":15}]
[null,75,70,{"$f":"AbsoluteDifference(B6,C6)","v":5}]
[null,55,78,23]
[null,80,95,15]
[null,70,60,10]
[null,65,80,15]