{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","-ABS","ABS with Multiplication","IF","Multiplication","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":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Opposite of ABS Function"]
[]
[null,"Categories","Expenses\\Income"]
[null,"Salary",30000]
[null,"Business Income",6000]
[null,"Rent",-8000]
[null,"Electricity Bill",-600]
[null,"Bank Profit",5000]
[null,"Food",-2500]
[null,"Passive Income",3000]
[null,"Shopping",-4000]
[null,"Over Time",8000]

{"sheet":"-ABS","index":1,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of ABS Function with Minus Sign",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Categories","Expenses\\Income"," Values as Negative",null,null,null,null,null,null,"Categories","Expenses\\Income"," Values as Negative"]
[null,"Salary",30000,{"$f":"-ABS(C5)","v":-30000},null,null,null,null,null,null,"Salary",30000]
[null,"Business Income",6000,{"$f":"-ABS(C6)","v":-6000},null,null,null,null,null,null,"Business Income",6000]
[null,"Rent",-8000,-8000,null,null,null,null,null,null,"Rent",-8000]
[null,"Electricity Bill",-600,-600,null,null,null,null,null,null,"Electricity Bill",-600]
[null,"Bank Profit",5000,-5000,null,null,null,null,null,null,"Bank Profit",5000]
[null,"Food",-2500,-2500,null,null,null,null,null,null,"Food",-2500]
[null,"Passive Income",3000,-3000,null,null,null,null,null,null,"Passive Income",3000]
[null,"Shopping",-4000,-4000,null,null,null,null,null,null,"Shopping",-4000]
[null,"Over Time",8000,-8000,null,null,null,null,null,null,"Over Time",8000]

{"sheet":"ABS with Multiplication","index":2,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Employing ABS Function with Multiplication",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Categories","Expenses\\Income"," Values as Negative",null,null,null,null,null,null,"Categories","Expenses\\Income"," Values as Negative"]
[null,"Salary",30000,{"$f":"ABS(C5)*-1","v":-30000},null,null,null,null,null,null,"Salary",30000]
[null,"Business Income",6000,{"$f":"ABS(C6)*-1","v":-6000},null,null,null,null,null,null,"Business Income",6000]
[null,"Rent",-8000,-8000,null,null,null,null,null,null,"Rent",-8000]
[null,"Electricity Bill",-600,-600,null,null,null,null,null,null,"Electricity Bill",-600]
[null,"Bank Profit",5000,-5000,null,null,null,null,null,null,"Bank Profit",5000]
[null,"Food",-2500,-2500,null,null,null,null,null,null,"Food",-2500]
[null,"Passive Income",3000,-3000,null,null,null,null,null,null,"Passive Income",3000]
[null,"Shopping",-4000,-4000,null,null,null,null,null,null,"Shopping",-4000]
[null,"Over Time",8000,-8000,null,null,null,null,null,null,"Over Time",8000]

{"sheet":"IF","index":3,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Applying IF Function",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Categories","Expenses\\Income"," Values as Negative",null,null,null,null,null,null,"Categories","Expenses\\Income"," Values as Negative"]
[null,"Salary",30000,{"$f":"IF(C5<0,C5,C5*-1)","v":-30000},null,null,null,null,null,null,"Salary",30000]
[null,"Business Income",6000,{"$f":"IF(C6<0,C6,C6*-1)","v":-6000},null,null,null,null,null,null,"Business Income",6000]
[null,"Rent",-8000,-8000,null,null,null,null,null,null,"Rent",-8000]
[null,"Electricity Bill",-600,-600,null,null,null,null,null,null,"Electricity Bill",-600]
[null,"Bank Profit",5000,-5000,null,null,null,null,null,null,"Bank Profit",5000]
[null,"Food",-2500,-2500,null,null,null,null,null,null,"Food",-2500]
[null,"Passive Income",3000,-3000,null,null,null,null,null,null,"Passive Income",3000]
[null,"Shopping",-4000,-4000,null,null,null,null,null,null,"Shopping",-4000]
[null,"Over Time",8000,-8000,null,null,null,null,null,null,"Over Time",8000]

{"sheet":"Multiplication","index":4,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Using Multiplication Operator",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Categories","Expenses\\Income"," Opposite Values",null,null,null,null,null,null,"Categories","Expenses\\Income"," Opposite Values"]
[null,"Salary",30000,{"$f":"C5*-1","v":-30000},null,null,null,null,null,null,"Salary",30000]
[null,"Business Income",6000,{"$f":"C6*-1","v":-6000},null,null,null,null,null,null,"Business Income",6000]
[null,"Rent",-8000,8000,null,null,null,null,null,null,"Rent",-8000]
[null,"Electricity Bill",-600,600,null,null,null,null,null,null,"Electricity Bill",-600]
[null,"Bank Profit",5000,-5000,null,null,null,null,null,null,"Bank Profit",5000]
[null,"Food",-2500,2500,null,null,null,null,null,null,"Food",-2500]
[null,"Passive Income",3000,-3000,null,null,null,null,null,null,"Passive Income",3000]
[null,"Shopping",-4000,4000,null,null,null,null,null,null,"Shopping",-4000]
[null,"Over Time",8000,-8000,null,null,null,null,null,null,"Over Time",8000]

{"sheet":"VBA","index":5,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of VBA",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Categories","Expenses\\Income"," Values as Negative",null,null,null,null,null,null,"Categories","Expenses\\Income"," Values as Negative"]
[null,"Salary",30000,-30000,null,null,null,null,null,null,"Salary",30000]
[null,"Business Income",6000,-6000,null,null,null,null,null,null,"Business Income",6000]
[null,"Rent",-8000,-8000,null,null,null,null,null,null,"Rent",-8000]
[null,"Electricity Bill",-600,-600,null,null,null,null,null,null,"Electricity Bill",-600]
[null,"Bank Profit",5000,-5000,null,null,null,null,null,null,"Bank Profit",5000]
[null,"Food",-2500,-2500,null,null,null,null,null,null,"Food",-2500]
[null,"Passive Income",3000,-3000,null,null,null,null,null,null,"Passive Income",3000]
[null,"Shopping",-4000,-4000,null,null,null,null,null,null,"Shopping",-4000]
[null,"Over Time",8000,-8000,null,null,null,null,null,null,"Over Time",8000]