{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Using Mathematical Operation","Applying Paste Special","Use of ABS Function"," Employing IF Function","Using Go to Special","Applying 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":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Changing Positive Numbers to Negative"]
[]
[null,"Months","Loss"]
[null,"March ",200]
[null,"April",500]
[null,"May",50]
[null,"June",150]
[null,"July",10]

{"sheet":"Using Mathematical Operation","index":1,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Using Mathemetical Operation",null,null,null,null,"Do it Yourself"]
[]
[null,"Months","Loss","Profit",null,null,"Months","Loss","Profit"]
[null,"March ",200,{"$f":"C5*-1","v":-200},null,null,"March ",200]
[null,"April",500,{"$f":"C6*-1","v":-500},null,null,"April",500]
[null,"May",50,-50,null,null,"May",50]
[null,"June",150,-150,null,null,"June",150]
[null,"July",10,-10,null,null,"July",10]

{"sheet":"Applying Paste Special","index":2,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Applying Paste Special Feature",null,null,null,null,"Do it Yourself"]
[]
[null,"Months","Income","Expense",null,null,"Months","Income","Expense"]
[null,"March ",2000,-1000,null,null,"March ",2000,1000]
[null,"April",1500,-1200,null,null,"April",1500,1200]
[null,"May",2500,-2500,null,null,"May",2500,2500]
[null,"June",1500,-1000,null,null,"June",1500,1000]
[null,"July",3000,-1500,null,null,"July",3000,1500]

{"sheet":"Use of ABS Function","index":3,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Use of ABS Function",null,null,null,null,"Do it Yourself"]
[]
[null,"Months","Expense","Expense (Corrected)",null,null,"Months","Expense","Expense (Corrected)"]
[null,"March ",-1000,{"$f":"ABS(C5)*-1","v":-1000},null,null,"March ",-1000]
[null,"April",1200,{"$f":"ABS(C6)*-1","v":-1200},null,null,"April",1200]
[null,"May",-2500,-2500,null,null,"May",-2500]
[null,"June",1000,-1000,null,null,"June",1000]
[null,"July",1500,-1500,null,null,"July",1500]

{"sheet":" Employing IF Function","index":4,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null," Employing IF Function",null,null,null,null,"Do it Yourself"]
[]
[null,"Months","Expense","Expense (Corrected)",null,null,"Months","Expense","Expense (Corrected)"]
[null,"March ",-1000,{"$f":"IF(C5<0,C5,C5*-1)","v":-1000},null,null,"March ",-1000]
[null,"April",1200,{"$f":"IF(C6<0,C6,C6*-1)","v":-1200},null,null,"April",1200]
[null,"May",-2500,-2500,null,null,"May",-2500]
[null,"June",1000,-1000,null,null,"June",1000]
[null,"July",1500,-1500,null,null,"July",1500]

{"sheet":"Using Go to Special","index":5,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Using Go to Special Command",null,null,null,null,"Do it Yourself"]
[]
[null,"Category","Income","Expense",null,null,"Category","Income","Expense"]
[null,"Salary",5000,null,null,null,"Salary",5000]
[null,"Rent",null,-2000,null,null,"Rent",null,2000]
[null,"Profit",2500,null,null,null,"Profit",2500]
[null,"Utility",null,-1500,null,null,"Utility",null,1500]
[null,"Personal",null,-2500,null,null,"Personal",null,2500]

{"sheet":"Applying VBA","index":6,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Applying VBA",null,null,null,"Do it Yourself"]
[]
[null,"Months","Expense",null,null,"Months","Expense"]
[null,"March ",-1000,null,null,"March ",1000]
[null,"April",-1200,null,null,"April",1200]
[null,"May",-2500,null,null,"May",-2500]
[null,"June",-1500,null,null,"June",1500]
[null,"July",-1500,null,null,"July",-1500]