{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset Overview","Using IF Function","Using ABS Function","Utilizing Paste Special Feature","Applying VBA Code","Highlighting Negative Numbers"],"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 Overview","index":0,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Dataset Overview",null,null,null,null,null,"Do it Yourself"]
[]
[null,"Numbers","Converted Numbers",null,null,null,null,"Numbers","Converted Numbers"]
[null,5,null,null,null,null,null,23]
[null,10,null,null,null,null,null,-388]
[null,283,null,null,null,null,null,12]
[null,27,null,null,null,null,null,-222]
[null,-90,null,null,null,null,null,90]
[null,-6,null,null,null,null,null,-66]

{"sheet":"Using IF Function","index":1,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Using IF Function",null,null,null,null,null,"Do it Yourself"]
[]
[null,"Numbers","Converted Numbers",null,null,null,null,"Numbers","Converted Numbers"]
[null,5,{"$f":"IF(B5>0,B5*-1,B5)","v":-5},null,null,null,null,23]
[null,10,{"$f":"IF(B6>0,B6*-1,B6)","v":-10},null,null,null,null,-388]
[null,283,-283,null,null,null,null,12]
[null,27,-27,null,null,null,null,-222]
[null,-90,-90,null,null,null,null,90]
[null,-6,-6,null,null,null,null,-66]

{"sheet":"Using ABS Function","index":2,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Using ABS Function",null,null,null,null,null,"Do it Yourself"]
[]
[null,"Numbers","Converted Numbers",null,null,null,null,"Numbers","Converted Numbers"]
[null,5,{"$f":"ABS(B5)*-1","v":-5},null,null,null,null,23]
[null,10,{"$f":"ABS(B6)*-1","v":-10},null,null,null,null,-388]
[null,283,-283,null,null,null,null,12]
[null,27,-27,null,null,null,null,-222]
[null,-90,-90,null,null,null,null,90]
[null,-6,-6,null,null,null,null,-66]

{"sheet":"Utilizing Paste Special Feature","index":3,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Utilizing Paste Special Feature",null,null,null,null,null,"Do it Yourself"]
[]
[null,"Numbers","Converted Numbers",null,null,null,null,"Numbers","Converted Numbers"]
[null,5,{"$f":"5*(-1)","v":-5},{"$f":"-1","v":-1},null,null,null,23]
[null,10,{"$f":"10*(-1)","v":-10},null,null,null,null,-388]
[null,283,{"$f":"283*(-1)","v":-283},null,null,null,null,12]
[null,27,{"$f":"27*(-1)","v":-27},null,null,null,null,-222]
[null,90,{"$f":"90*(-1)","v":-90},null,null,null,null,90]
[null,6,{"$f":"6*(-1)","v":-6},null,null,null,null,-66]

{"sheet":"Applying VBA Code","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,"Do it Yourself"]
[]
[null,"Numbers","Converted Numbers",null,null,null,null,"Numbers","Converted Numbers"]
[null,5,-5,null,null,null,null,23]
[null,10,-10,null,null,null,null,-388]
[null,283,-283,null,null,null,null,12]
[null,27,-27,null,null,null,null,-222]
[null,90,-90,null,null,null,null,90]
[null,6,-6,null,null,null,null,-66]

{"sheet":"Highlighting Negative Numbers","index":5,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Highlighting Negative Numbers",null,null,null,null,null,"Do it Yourself"]
[]
[null,"Numbers","Converted Numbers",null,null,null,null,"Numbers","Converted Numbers"]
[null,5,{"$f":"IF(B5>0,B5*-1,B5)","v":-5},null,null,null,null,23]
[null,10,{"$f":"IF(B6>0,B6*-1,B6)","v":-10},null,null,null,null,-388]
[null,283,-283,null,null,null,null,12]
[null,27,-27,null,null,null,null,-222]
[null,-90,-90,null,null,null,null,90]
[null,-6,-6,null,null,null,null,-66]