{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Data Set","Basic ABS Function","Absolute Variance","Variance with Condition","Square_Root","Tolerance","Ignore Sign","Identify Numbers","Sum of Negatives","Average","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":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Basic ABS Function"]
[]
[null,"Month"," Profit","Absolute Value"]
[null,"Jan",100,{"$f":"ABS(C5)","v":100}]
[null,"Feb",200,{"$f":"ABS(C6)","v":200}]
[null,"Mar",-150,150]
[null,"Apr",-100,100]
[null,"May",0,0]
[null,"Jun",30,30]

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

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

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

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

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

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

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

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

{"sheet":"VBA","index":10,"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]