{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Number Format","Custom Format","Conditional Formatting","Accounting Format","vba","overview","negative to positive","negative to 0"],"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":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dataset for Showing Negative Numbers"]
[]
[null,"Particulars","January (USD)","February (USD)","March (USD)"]
[null,"Initial Balance",96800,{"$f":"C10","v":102300},{"$f":"D10","v":97700}]
[null,"Operating Activities",13200,4200,5677]
[null,"Investing Activities",-4500,-3200,-2300]
[null,"Financing Activities",-3200,-5600,-2400]
[null,"Net Change",{"$f":"SUM(C6:C8)","v":5500},{"$f":"SUM(D6:D8)","v":-4600},977]
[null,"End Period Cash",{"$f":"SUM(C5,C9)","v":102300},{"$f":"SUM(D5,D9)","v":97700},98677]

{"sheet":"Number Format","index":1,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Formatting Negative Numbers with Parentheses",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Particulars","January (USD)","February (USD)","March (USD)",null,null,null,null,null,"Particulars","January (USD)","February (USD)","March (USD)"]
[null,"Initial Balance",96800,{"$f":"C10","v":102300},{"$f":"D10","v":97700},null,null,null,null,null,"Initial Balance",96800,{"$f":"L10","v":102300},{"$f":"M10","v":97700}]
[null,"Operating Activities",13200,4200,5677,null,null,null,null,null,"Operating Activities",13200,4200,5677]
[null,"Investing Activities",-4500,-3200,-2300,null,null,null,null,null,"Investing Activities",-4500,-3200,-2300]
[null,"Financing Activities",-3200,-5600,-2400,null,null,null,null,null,"Financing Activities",-3200,-5600,-2400]
[null,"Net Change",{"$f":"SUM(C6:C8)","v":5500},{"$f":"SUM(D6:D8)","v":-4600},977,null,null,null,null,null,"Net Change",{"$f":"SUM(L6:L8)","v":5500},{"$f":"SUM(M6:M8)","v":-4600},977]
[null,"End Period Cash",{"$f":"SUM(C5,C9)","v":102300},{"$f":"SUM(D5,D9)","v":97700},98677,null,null,null,null,null,"End Period Cash",{"$f":"SUM(L5,L9)","v":102300},{"$f":"SUM(M5,M9)","v":97700},98677]

{"sheet":"Custom Format","index":2,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Custom Formatting Negative Numbers",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Particulars","January (USD)","February (USD)","March (USD)",null,null,null,null,null,"Particulars","January (USD)","February (USD)","March (USD)"]
[null,"Initial Balance",96800,{"$f":"C10","v":102300},{"$f":"D10","v":97700},null,null,null,null,null,"Initial Balance",96800,{"$f":"L10","v":102300},{"$f":"M10","v":97700}]
[null,"Operating Activities",13200,4200,5677,null,null,null,null,null,"Operating Activities",13200,4200,5677]
[null,"Investing Activities",-4500,-3200,-2300,null,null,null,null,null,"Investing Activities",-4500,-3200,-2300]
[null,"Financing Activities",-3200,-5600,-2400,null,null,null,null,null,"Financing Activities",-3200,-5600,-2400]
[null,"Net Change",{"$f":"SUM(C6:C8)","v":5500},{"$f":"SUM(D6:D8)","v":-4600},{"$f":"SUM(E6:E8)","v":977},null,null,null,null,null,"Net Change",{"$f":"SUM(L6:L8)","v":5500},{"$f":"SUM(M6:M8)","v":-4600},977]
[null,"End Period Cash",{"$f":"SUM(C5,C9)","v":102300},{"$f":"SUM(D5,D9)","v":97700},98677,null,null,null,null,null,"End Period Cash",{"$f":"SUM(L5,L9)","v":102300},{"$f":"SUM(M5,M9)","v":97700},98677]

{"sheet":"Conditional Formatting","index":3,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Applying Conditional Formatting on Negative Numbers",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Particulars","January (USD)","February (USD)","March (USD)",null,null,null,null,null,null,"Particulars","January (USD)","February (USD)","March (USD)"]
[null,"Initial Balance",96800,{"$f":"C10","v":102300},{"$f":"D10","v":97700},null,null,null,null,null,null,"Initial Balance",96800,{"$f":"M10","v":102300},{"$f":"N10","v":97700}]
[null,"Operating Activities",13200,4200,-6621,null,null,null,null,null,null,"Operating Activities",13200,4200,5677]
[null,"Investing Activities",-4500,-3200,-2300,null,null,null,null,null,null,"Investing Activities",-4500,-3200,-2300]
[null,"Financing Activities",-3200,-5600,-2400,null,null,null,null,null,null,"Financing Activities",-3200,-5600,-2400]
[null,"Net Change",{"$f":"SUM(C6:C8)","v":5500},{"$f":"SUM(D6:D8)","v":-4600},-11321,null,null,null,null,null,null,"Net Change",{"$f":"SUM(M6:M8)","v":5500},{"$f":"SUM(N6:N8)","v":-4600},977]
[null,"End Period Cash",{"$f":"SUM(C5,C9)","v":102300},{"$f":"SUM(D5,D9)","v":97700},86379,null,null,null,null,null,null,"End Period Cash",{"$f":"SUM(M5,M9)","v":102300},{"$f":"SUM(N5,N9)","v":97700},98677]

{"sheet":"Accounting Format","index":4,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Using Accounting Format to Show Negative Numbers",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Particulars","January (USD)","February (USD)","March (USD)",null,null,null,null,null,"Particulars","January (USD)","February (USD)","March (USD)"]
[null,"Initial Balance",96800,{"$f":"C10","v":102300},{"$f":"D10","v":97700},null,null,null,null,null,"Initial Balance",96800,{"$f":"L10","v":102300},{"$f":"M10","v":97700}]
[null,"Operating Activities",13200,4200,5677,null,null,null,null,null,"Operating Activities",13200,4200,5677]
[null,"Investing Activities",-4500,-3200,-2300,null,null,null,null,null,"Investing Activities",-4500,-3200,-2300]
[null,"Financing Activities",-3200,-5600,-2400,null,null,null,null,null,"Financing Activities",-3200,-5600,-2400]
[null,"Net Change",{"$f":"SUM(C6:C8)","v":5500},{"$f":"SUM(D6:D8)","v":-4600},977,null,null,null,null,null,"Net Change",{"$f":"SUM(L6:L8)","v":5500},{"$f":"SUM(M6:M8)","v":-4600},977]
[null,"End Period Cash",{"$f":"SUM(C5,C9)","v":102300},{"$f":"SUM(D5,D9)","v":97700},98677,null,null,null,null,null,"End Period Cash",{"$f":"SUM(L5,L9)","v":102300},{"$f":"SUM(M5,M9)","v":97700},98677]

{"sheet":"vba","index":5,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Using VBA to Change Font Color of  Negative Numbers",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Particulars","January (USD)","February (USD)","March (USD)",null,null,null,null,null,null,"Particulars","January (USD)","February (USD)","March (USD)"]
[null,"Initial Balance",96800,{"$f":"C10","v":102300},{"$f":"D10","v":97700},null,null,null,null,null,null,"Initial Balance",96800,{"$f":"M10","v":102300},{"$f":"N10","v":97700}]
[null,"Operating Activities",13200,4200,5677,null,null,null,null,null,null,"Operating Activities",13200,4200,5677]
[null,"Investing Activities",-4500,-3200,-2300,null,null,null,null,null,null,"Investing Activities",-4500,-3200,-2300]
[null,"Financing Activities",-3200,-5600,-2400,null,null,null,null,null,null,"Financing Activities",-3200,-5600,-2400]
[null,"Net Change",{"$f":"SUM(C6:C8)","v":5500},{"$f":"SUM(D6:D8)","v":-4600},977,null,null,null,null,null,null,"Net Change",{"$f":"SUM(M6:M8)","v":5500},{"$f":"SUM(N6:N8)","v":-4600},977]
[null,"End Period Cash",{"$f":"SUM(C5,C9)","v":102300},{"$f":"SUM(D5,D9)","v":97700},98677,null,null,null,null,null,null,"End Period Cash",{"$f":"SUM(M5,M9)","v":102300},{"$f":"SUM(N5,N9)","v":97700},98677]

{"sheet":"overview","index":6,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Overview of Showing Negative Numbers"]
[]
[null,"Particulars","January (USD)","February (USD)","March (USD)"]
[null,"Initial Balance",96800,{"$f":"C10","v":102300},{"$f":"D10","v":97700}]
[null,"Operating Activities",13200,4200,5677]
[null,"Investing Activities",-4500,-3200,-2300]
[null,"Financing Activities",-3200,-5600,-2400]
[null,"Net Change",{"$f":"SUM(C6:C8)","v":5500},{"$f":"SUM(D6:D8)","v":-4600},977]
[null,"End Period Cash",{"$f":"SUM(C5,C9)","v":102300},{"$f":"SUM(D5,D9)","v":97700},98677]
[]
[]
[null,"Particulars","January (USD)","February (USD)","March (USD)"]
[null,"Initial Balance",96800,{"$f":"C19","v":102300},{"$f":"D19","v":97700}]
[null,"Operating Activities",13200,4200,5677]
[null,"Investing Activities",-4500,-3200,-2300]
[null,"Financing Activities",-3200,-5600,-2400]
[null,"Net Change",{"$f":"SUM(C15:C17)","v":5500},{"$f":"SUM(D15:D17)","v":-4600},977]
[null,"End Period Cash",{"$f":"SUM(C14,C18)","v":102300},{"$f":"SUM(D14,D18)","v":97700},98677]

{"sheet":"negative to positive","index":7,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Converting Negative Numbers to Positive"]
[]
[null,"Particulars","January (USD)","February (USD)","March (USD)"]
[null,"Initial Balance",96800,{"$f":"C10","v":102300},{"$f":"D10","v":97700}]
[null,"Operating Activities",13200,4200,5677]
[null,"Investing Activities",-4500,-3200,-2300]
[null,"Financing Activities",-3200,-5600,-2400]
[null,"Net Change",{"$f":"SUM(C6:C8)","v":5500},{"$f":"SUM(D6:D8)","v":-4600},977]
[null,"End Period Cash",{"$f":"SUM(C5,C9)","v":102300},{"$f":"SUM(D5,D9)","v":97700},98677]
[]
[]
[null,"Particulars","January (USD)","February (USD)","March (USD)"]
[null,"Initial Balance",{"$f":"ABS(C5)","v":96800},{"$f":"ABS(D5)","v":102300},97700]
[null,"Operating Activities",{"$f":"ABS(C6)","v":13200},4200,5677]
[null,"Investing Activities",4500,3200,2300]
[null,"Financing Activities",3200,5600,2400]
[null,"Net Change",5500,4600,977]
[null,"End Period Cash",102300,97700,98677]

{"sheet":"negative to 0","index":8,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Converting Negative Numbers to Zero"]
[]
[null,"Particulars","January (USD)","February (USD)","March (USD)"]
[null,"Initial Balance",96800,{"$f":"C10","v":102300},{"$f":"D10","v":97700}]
[null,"Operating Activities",13200,4200,5677]
[null,"Investing Activities",-4500,-3200,-2300]
[null,"Financing Activities",-3200,-5600,-2400]
[null,"Net Change",{"$f":"SUM(C6:C8)","v":5500},{"$f":"SUM(D6:D8)","v":-4600},977]
[null,"End Period Cash",{"$f":"SUM(C5,C9)","v":102300},{"$f":"SUM(D5,D9)","v":97700},98677]
[]
[]
[null,"Particulars","January (USD)","February (USD)","March (USD)"]
[null,"Initial Balance",{"$f":"MAX(0,C5)","v":96800},{"$f":"MAX(0,D5)","v":102300},97700]
[null,"Operating Activities",{"$f":"MAX(0,C6)","v":13200},4200,5677]
[null,"Investing Activities",0,0,0]
[null,"Financing Activities",0,0,0]
[null,"Net Change",5500,0,977]
[null,"End Period Cash",102300,97700,98677]