{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Data Set","Basic ABS Function","Absolute Variance","Variance with Condition","Square_Root","Tolerance","Ignore Sign","Identify Numbers","Sum of Negatives","Average","MAX and MIN Functions","Identify Closest Value","Closest Even Value","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":"Data Set","index":0,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of ABS Function"]
[]
[null,"Random Data","Output"]
[null,-15,{"$f":"ABS(B5)","v":15},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=ABS(B5)"}]
[null,63,{"$f":"ABS(B6)","v":63},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=ABS(B6)"}]
[null,0,0,"=ABS(B7)"]

{"sheet":"Basic ABS Function","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Use of Basic ABS Function",null,null,null,"Practice Yourself"]
[]
[null,"Month"," Profit","Absolute Value",null,"Month"," Profit","Absolute Value"]
[null,"Jan",100,{"$f":"ABS(C5)","v":100},null,"Jan",100]
[null,"Feb",200,{"$f":"ABS(C6)","v":200},null,"Feb",200]
[null,"Mar",-150,150,null,"Mar",-150]
[null,"Apr",-100,100,null,"Apr",-100]
[null,"May",0,0,null,"May",0]
[null,"Jun",30,30,null,"Jun",30]

{"sheet":"Absolute Variance","index":2,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Find Absolute Variance",null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Actual","Expected","Error",null,"Name","Actual","Expected","Error"]
[null,"Jan",500,600,{"$f":"ABS(D5-C5)","v":100},null,"Jan",500,600]
[null,"Feb",400,600,{"$f":"ABS(D6-C6)","v":200},null,"Feb",400,600]
[null,"Mar",630,480,150,null,"Mar",630,480]
[null,"Apr",465,365,100,null,"Apr",465,365]
[null,"May",520,520,0,null,"May",520,520]
[null,"Jun",600,630,30,null,"Jun",600,630]

{"sheet":"Variance with Condition","index":3,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Find Conditional Variance",null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Actual","Expected","Result",null,"Name","Actual","Expected","Result"]
[null,"Jan",500,600,{"$f":"SUMPRODUCT(--(ABS(D5-C5)>100))","v":0},null,"Jan",500,600]
[null,"Feb",400,600,{"$f":"SUMPRODUCT(--(ABS(D6-C6)>100))","v":1},null,"Feb",400,600]
[null,"Mar",630,480,1,null,"Mar",630,480]
[null,"Apr",465,365,0,null,"Apr",465,365]
[null,"May",520,520,0,null,"May",520,520]
[null,"Jun",600,630,0,null,"Jun",600,630]

{"sheet":"Square_Root","index":4,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Search Square Root",null,null,"Practice Yourself"]
[]
[null,"Random Data","Result",null,"Random Data","Result"]
[null,25,{"$f":"SQRT(ABS(B5))","v":5},null,25]
[null,-9,{"$f":"SQRT(ABS(B6))","v":3},null,-9]
[null,-144,12,null,-144]
[null,-81,9,null,-81]
[null,-225,15,null,-225]
[null,0,0,null,0]

{"sheet":"Tolerance","index":5,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Calculate Tolerance",null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Actual","Expected","Result",null,"Name","Actual","Expected","Result"]
[null,"Jan",500,600,{"$f":"IF(ABS(D6-C6)<=100,\"OK\",\"Fail\")","v":"Fail"},null,"Jan",500,600]
[null,"Feb",400,600,{"$f":"IF(ABS(D7-C7)<=100,\"OK\",\"Fail\")","v":"Fail"},null,"Feb",400,600]
[null,"Mar",630,480,"OK",null,"Mar",630,480]
[null,"Apr",465,365,"OK",null,"Apr",465,365]
[null,"May",520,520,"OK",null,"May",520,520]
[null,"Jun",600,630,"OK",null,"Jun",600,630]

{"sheet":"Ignore Sign","index":6,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Sum Ignoring Sign",null,null,"Practice Yourself"]
[]
[null,"Random Data",null,null,"Random Data"]
[null,25,null,null,25]
[null,-9,null,null,-9]
[null,-144,null,null,-144]
[null,-81,null,null,-81]
[null,-225,null,null,-225]
[null,0,null,null,0]
[]
[null,{"$f":"SUM(ABS(B5:B10))","v":484}]

{"sheet":"Identify Numbers","index":7,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Identify Numbers",null,null,null,"Practice Yourself"]
[]
[null,"Data","Result",null,null,"Data","Result"]
[null,25,{"$f":"IF(B5<0,ABS(B5),\"Positive\")","v":"Positive"},null,null,25]
[null,-9,{"$f":"IF(B6<0,ABS(B6),\"Positive\")","v":9},null,null,-9]
[null,-144,{"$f":"IF(B7<0,ABS(B7),\"Positive\")","v":144},null,null,-144]
[null,-81,81,null,null,-81]
[null,-225,225,null,null,-225]
[null,0,"Positive",null,null,0]

{"sheet":"Sum of Negatives","index":8,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"SUM only Negative Numbers",null,null,"Practice Yourself"]
[]
[null,"Month"," Profit",null,"Month"," Profit"]
[null,"Jan",100,null,"Jan",100]
[null,"Feb",200,null,"Feb",200]
[null,"Mar",-150,null,"Mar",-150]
[null,"Apr",-100,null,"Apr",-100]
[null,"May",0,null,"May",0]
[null,"Jun",30,null,"Jun",30]
[]
[null,"Total",{"$f":"SUM(IF(C5:C10<0,ABS(C5:C10),0))","v":250},null,"Total"]

{"sheet":"Average","index":9,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Find Average with ABS Function",null,null,"Practice Yourself"]
[]
[null,"Month"," Profit",null,"Month"," Profit"]
[null,"Jan",100,null,"Jan",100]
[null,"Feb",200,null,"Feb",200]
[null,"Mar",-150,null,"Mar",-150]
[null,"Apr",-100,null,"Apr",-100]
[null,"May",0,null,"May",0]
[null,"Jun",30,null,"Jun",30]
[]
[null,"Total",{"$f":"AVERAGE(ABS(C5:C10))","v":96.666666666666671},null,"Total"]

{"sheet":"MAX and MIN Functions","index":10,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Using MAX and MIN Functions",null,null,null,"Practice Yourself"]
[]
[null,"State","Temp (°C)",null,null,"State","Temp (°C)"]
[null,"Alaska",-2.2000000000000002,null,null,"Alaska",-2.2000000000000002]
[null,"North Dakota",-4.4000000000000004,null,null,"North Dakota",-4.4000000000000004]
[null,"Florida",21.9,null,null,"Florida",21.9]
[null,"Louisiana",19.600000000000001,null,null,"Louisiana",19.600000000000001]
[null,"Minnesota",-10,null,null,"Minnesota",-10]
[null,"Georgia",17.899999999999999,null,null,"Georgia",17.899999999999999]
[]
[null,"Maximum Temp",{"$f":"MAX(ABS(C5:C10))","v":21.9},"=MAX(ABS(C5:C10))",null,"Maximum Temp"]
[null,"Minimum Temp",{"$f":"MIN(ABS(C5:C10))","v":2.2000000000000002},"=MIN(ABS(C5:C10))",null,"Minimum Temp"]

{"sheet":"Identify Closest Value","index":11,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Using INDEX, MATCH, MIN and ABS Functions",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"State","Temp (°C)",null,"Value",2,null,null,"State","Temp (°C)",null,"Value",2]
[null,"Alaska",-2.2000000000000002,null,"Match",{"$f":"INDEX(C5:C10,MATCH(MIN(ABS(F4-C5:C10)),ABS(F4-C5:C10),0))","v":-2.2000000000000002},null,null,"Alaska",-2.2000000000000002,null,"Match"]
[null,"North Dakota",-4.4000000000000004,null,null,null,null,null,"North Dakota",-4.4000000000000004]
[null,"Florida",21.9,null,null,null,null,null,"Florida",21.9]
[null,"Louisiana",19.600000000000001,null,null,null,null,null,"Louisiana",19.600000000000001]
[null,"Minnesota",-10,null,null,null,null,null,"Minnesota",-10]
[null,"Georgia",17.899999999999999,null,null,null,null,null,"Georgia",17.899999999999999]

{"sheet":"Closest Even Value","index":12,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Using ABS, EVEN and IF Functions",null,null,null,null,"Practice Yourself"]
[]
[null,"State","Temp (°C)","Closest Even Value",null,null,"State","Temp (°C)","Closest Even Value"]
[null,"Alaska",-2.2000000000000002,{"$f":"IF(ABS(EVEN(C5)-C5)>1,IF(C5 < 0, EVEN(C5)+2,EVEN(C5)-2),EVEN(C5))","v":-2},null,null,"Alaska",-2.2000000000000002]
[null,"North Dakota",-4.4000000000000004,{"$f":"IF(ABS(EVEN(C6)-C6)>1,IF(C6 < 0, EVEN(C6)+2,EVEN(C6)-2),EVEN(C6))","v":-4},null,null,"North Dakota",-4.4000000000000004]
[null,"Florida",21.9,22,null,null,"Florida",21.9]
[null,"Louisiana",19.600000000000001,20,null,null,"Louisiana",19.600000000000001]
[null,"Minnesota",-10,-10,null,null,"Minnesota",-10]
[null,"Georgia",17.899999999999999,18,null,null,"Georgia",17.899999999999999]

{"sheet":"VBA","index":13,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"VBA MACROS"]
[]
[null,"Month"," Profit"]
[null,"Jan",100]
[null,"Feb",200]
[null,"Mar",-150]
[null,"Apr",-100]
[null,"May",0]
[null,"Jun",30]