{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","DELTA","ABS","SQRT","IF","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":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"List of Marks"]
[]
[null,"Student","Test 1","Test 2"]
[null,"Jonas",37,40]
[null,"Harry",49,39]
[null,"Nick",48,41]
[null,"Sara",44,44]
[null,"John",31,50]
[null,"Leon",33,48]
[null,"Tom",35,35]
[null,"Hardy",50,28]
[null,"Mark",48,49]
[null,"Chris",37,30]

{"sheet":"DELTA","index":1,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,9,1,13]]}
[]
[null,"Using DELTA Function",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Student","Test 1","Test 2","Result","Difference",null,null,null,"Student","Test 1","Test 2","Result","Difference"]
[null,"Jonas",37,40,{"$f":"DELTA(C5,D5)","v":0},{"$f":"IF(E5=0,\"YES\",\"NO\")","v":"YES"},null,null,null,"Adani",40,37]
[null,"Harry",49,39,{"$f":"DELTA(C6,D6)","v":0},{"$f":"IF(E6=0,\"YES\",\"NO\")","v":"YES"},null,null,null,"Harry",39,49]
[null,"Nick",48,41,0,"YES",null,null,null,"Nick",41,48]
[null,"Sara",44,44,1,"NO",null,null,null,"Kiara",44,44]
[null,"John",31,50,0,"YES",null,null,null,"John",50,31]
[null,"Leon",33,48,0,"YES",null,null,null,"Neon",48,33]
[null,"Tom",35,35,1,"NO",null,null,null,"Tom",35,35]
[null,"Hardy",50,28,0,"YES",null,null,null,"Hardy",28,50]
[null,"Mark",48,49,0,"YES",null,null,null,"Mack",49,48]
[null,"Chris",37,30,0,"YES",null,null,null,"Bums",30,37]

{"sheet":"ABS","index":2,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Utilizing ABS Function",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Student","Test 1","Test 2","Difference",null,null,null,"Student","Test 1","Test 2","Difference"]
[null,"Jonas",37,40,{"$f":"ABS(C5-D5)","v":3},null,null,null,"Monash",40,37]
[null,"Harry",49,39,{"$f":"ABS(C6-D6)","v":10},null,null,null,"Harry",39,49]
[null,"Nick",48,41,7,null,null,null,"Nicky",41,48]
[null,"Sara",44,44,0,null,null,null,"Jara",44,44]
[null,"John",31,50,19,null,null,null,"Johnson",50,31]
[null,"Leon",33,48,15,null,null,null,"Leon",48,33]
[null,"Tom",35,35,0,null,null,null,"Tom",35,35]
[null,"Hardy",50,28,22,null,null,null,"Hardy",28,50]
[null,"Mark",48,49,1,null,null,null,"Mark",49,48]
[null,"Chris",37,30,7,null,null,null,"Chris",30,37]

{"sheet":"SQRT","index":3,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Inserting SQRT Function",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Student","Test 1","Test 2","Difference",null,null,null,"Student","Test 1","Test 2","Difference"]
[null,"Jonas",37,40,{"$f":"SQRT((C5-D5)^2)","v":3},null,null,null,"Monash",40,37]
[null,"Harry",49,39,{"$f":"SQRT((C6-D6)^2)","v":10},null,null,null,"Harry",39,49]
[null,"Nick",48,41,7,null,null,null,"Nicky",41,48]
[null,"Sara",44,44,0,null,null,null,"Jara",44,44]
[null,"John",31,50,19,null,null,null,"Johnson",50,31]
[null,"Leon",33,48,15,null,null,null,"Leon",48,33]
[null,"Tom",35,35,0,null,null,null,"Tom",35,35]
[null,"Hardy",50,28,22,null,null,null,"Hardy",28,50]
[null,"Mark",48,49,1,null,null,null,"Mark",49,48]
[null,"Chris",37,30,7,null,null,null,"Chris",30,37]

{"sheet":"IF","index":4,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Employing IF Function",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Student","Test 1","Test 2","Difference",null,null,null,"Student","Test 1","Test 2","Difference"]
[null,"Jonas",37,40,{"$f":"IF(C5>D5,C5-D5,D5-C5)","v":3},null,null,null,"Monash",40,37]
[null,"Harry",49,39,{"$f":"IF(C6>D6,C6-D6,D6-C6)","v":10},null,null,null,"Harry",39,49]
[null,"Nick",48,41,7,null,null,null,"Nicky",41,48]
[null,"Sara",44,44,0,null,null,null,"Jara",44,44]
[null,"John",31,50,19,null,null,null,"Johnson",50,31]
[null,"Leon",33,48,15,null,null,null,"Leon",48,33]
[null,"Tom",35,35,0,null,null,null,"Tom",35,35]
[null,"Hardy",50,28,22,null,null,null,"Hardy",28,50]
[null,"Mark",48,49,1,null,null,null,"Mark",49,48]
[null,"Chris",37,30,7,null,null,null,"Chris",30,37]

{"sheet":"VBA","index":5,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Student","Test 1","Test 2","Difference",null,null,null,"Student","Test 1","Test 2","Difference"]
[null,"Jonas",37,40,{"$f":"Cal_Delta(C5,D5)","v":3},null,null,null,"Monash",40,37]
[null,"Harry",49,39,{"$f":"Cal_Delta(C6,D6)","v":10},null,null,null,"Harry",39,49]
[null,"Nick",48,41,{"$f":"Cal_Delta(C7,D7)","v":7},null,null,null,"Nicky",41,48]
[null,"Sara",44,44,{"$f":"Cal_Delta(C8,D8)","v":0},null,null,null,"Jara",44,44]
[null,"John",31,50,{"$f":"Cal_Delta(C9,D9)","v":19},null,null,null,"Johnson",50,31]
[null,"Leon",33,48,{"$f":"Cal_Delta(C10,D10)","v":15},null,null,null,"Leon",48,33]
[null,"Tom",35,35,{"$f":"Cal_Delta(C11,D11)","v":0},null,null,null,"Tom",35,35]
[null,"Hardy",50,28,{"$f":"Cal_Delta(C12,D12)","v":22},null,null,null,"Hardy",28,50]
[null,"Mark",48,49,{"$f":"Cal_Delta(C13,D13)","v":1},null,null,null,"Mark",49,48]
[null,"Chris",37,30,{"$f":"Cal_Delta(C14,D14)","v":7},null,null,null,"Chris",30,37]