{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["dataset","abs","multiply","if","imabs","combined","copy paste","format change","flash fill","find and replace","Table3","power query","vba","diy"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Make All Numbers Positive"]
[]
[null,"Numbers"]
[null,-4]
[null,-23]
[null,{"$f":"-5/3","v":-1.6666666666666667}]
[null,{"$f":"-SQRT(22)","v":-4.6904157598234297}]
[null,{"$f":"COMPLEX(7,9)","v":"7+9i"}]
[null,{"$f":"COMPLEX(2,-4)","v":"2-4i"}]
[null,{"$f":"COMPLEX(12,-5)","v":"12-5i"}]

{"sheet":"abs","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using ABS Function"]
[]
[null,"Numbers","Positive Numbers"]
[null,-4,{"$f":"ABS(B5)","v":4}]
[null,-23,{"$f":"ABS(B6)","v":23}]
[null,{"$f":"-5/3","v":-1.6666666666666667},1.6666666666666667]
[null,{"$f":"-SQRT(22)","v":-4.6904157598234297},4.6904157598234297]

{"sheet":"multiply","index":2,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Multiplying by -1"]
[]
[null,"Numbers","Positive Numbers"]
[null,-4,{"$f":"-1*B5","v":4}]
[null,-23,{"$f":"-1*B6","v":23}]
[null,{"$f":"-5/3","v":-1.6666666666666667},1.6666666666666667]
[null,{"$f":"-SQRT(22)","v":-4.6904157598234297},4.6904157598234297]

{"sheet":"if","index":3,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using IF Function"]
[]
[null,"Numbers","Positive Numbers"]
[null,-4,{"$f":"IF(B5<0,-1*B5,B5)","v":4}]
[null,23,{"$f":"IF(B6<0,-1*B6,B6)","v":23}]
[null,{"$f":"-5/3","v":-1.6666666666666667},1.6666666666666667]
[null,{"$f":"-SQRT(22)","v":-4.6904157598234297},4.6904157598234297]

{"sheet":"imabs","index":4,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using IMABS Function"]
[]
[null,"Numbers","Positive Numbers (Magnitude)"]
[null,{"$f":"COMPLEX(7,9)","v":"7+9i"},{"$f":"IMABS(B5)","v":11.401754250991379}]
[null,{"$f":"COMPLEX(2,-4)","v":"2-4i"},{"$f":"IMABS(B6)","v":4.4721359549995796}]
[null,{"$f":"COMPLEX(12,-5)","v":"12-5i"},13]

{"sheet":"combined","index":5,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Combined Functions"]
[]
[null,"Numbers","Positive Numbers (Magnitude)"]
[null,{"$f":"COMPLEX(7,9)","v":"7+9i"},{"$f":"SQRT(IMPRODUCT(B5,IMCONJUGATE(B5)))","v":11.401754250991379}]
[null,{"$f":"COMPLEX(2,-4)","v":"2-4i"},{"$f":"SQRT(IMPRODUCT(B6,IMCONJUGATE(B6)))","v":4.4721359549995796}]
[null,{"$f":"COMPLEX(12,-5)","v":"12-5i"},13]

{"sheet":"copy paste","index":6,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Copy & Paste Feature"]
[]
[null,"Numbers",null,"Multiplier"]
[null,4,null,-1]
[null,23]
[null,{"$f":"(-5/3)*-1","v":1.6666666666666667}]
[null,{"$f":"(-SQRT(22))*-1","v":4.6904157598234297}]

{"sheet":"format change","index":7,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Changing Number Format"]
[]
[null,"Numbers"]
[null,-4]
[null,-23]
[null,{"$f":"(-5/3)","v":-1.6666666666666667}]
[null,{"$f":"(-SQRT(22))","v":-4.6904157598234297}]

{"sheet":"flash fill","index":8,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Flash Fill"]
[]
[null,"Numbers","Positive Numbers"]
[null,-4,4]
[null,-23,23]
[null,{"$f":"-5/3","v":-1.6666666666666667},1.6666666670000001]
[null,{"$f":"-SQRT(22)","v":-4.6904157598234297},4.6904157599999996]

{"sheet":"find and replace","index":9,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Find & Replace"]
[]
[null,"Numbers"]
[null,4]
[null,23]
[null,{"$f":"  5/3","v":1.6666666666666667}]
[null,{"$f":"  SQRT(22)","v":4.6904157598234297}]

{"sheet":"Table3","index":10,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Numbers"]
[4]
[23]
[1.6666666666666667]
[4.6904157598234297]

{"sheet":"power query","index":11,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using Power Query"]
[]
[null,"Numbers"]
[null,-4]
[null,-23]
[null,{"$f":"-5/3","v":-1.6666666666666667}]
[null,{"$f":"-SQRT(22)","v":-4.6904157598234297}]

{"sheet":"vba","index":12,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using VBA"]
[]
[null,"Numbers"]
[null,4]
[null,23]
[null,1.6666666666666667]
[null,4.6904157598234297]

{"sheet":"diy","index":13,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"DO It Yourslef"]
[]
[null,"Numbers"]
[null,-4]
[null,-23]
[null,{"$f":"-5/3","v":-1.6666666666666667}]
[null,{"$f":"-SQRT(22)","v":-4.6904157598234297}]
[null,{"$f":"COMPLEX(7,9)","v":"7+9i"}]
[null,{"$f":"COMPLEX(2,-4)","v":"2-4i"}]
[null,{"$f":"COMPLEX(12,-5)","v":"12-5i"}]