{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["SETUP","HOME","Ngan sach","T1","T2","T3","T4","T5","T6","T7","T8","T9","T10","T11","T12","BKCT","No"],"not_rendered":{"charts":3,"images":2,"macros":1,"external_links":0,"defined_names":3,"comments":15,"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":"SETUP","index":0,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"URL"]
[null,null,null,null,null,null,"tccn.pro.vn"]

{"sheet":"HOME","index":1,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"HƯỚNG DẪN SỬ DỤNG PHẦN MỀM"]
[]
[]
[]
[null,"Khi mở phần mềm, nếu gặp thông báo sau => Bạn nhấn Enable content."]
[]
[]
[]
[]
[]
[]
[null,"1. Lập Ngân sách trong năm",null,null,null,null,null,null,null,null,null,"Click here"]
[null,"Lập ngân sách cho "]
[null,"+ Thu nhập"]
[null,"+ Chi tiêu: Chi thường xuyên, chi cố định, chi bất thường"]
[null,"+ Tiết kiệm - Đầu tư"]
[null,"+ Trả nợ: Trả cả nợ gốc + lãi (nếu có) mỗi tháng"]
[]
[null,"2. Theo dõi Chi tiêu thực tế",null,null,null,null,null,null,null,null,null,"Click here"]
[null,"+ Cập nhật số liệu chi tiêu thực tế mỗi ngày / các tháng tương ứng"]
[null,"+ Cảnh báo khi chi tiêu vượt ngân sách cho phép"]
[]
[null,"3. Lên danh sách, theo dõi các khoản vay",null,null,null,null,null,null,null,null,null,"Click here"]
[null,"Khi phát sinh các món vay, khoản nợ mới: "]
[null,"+ Cập nhật vào \"Bảng kê 02\" + Tên món vay"]
[null,"+ Cập nhật trả nợ gốc cho các món vay/Phát sinh tổng số tiền vay mới cho từng món - Bảng kê 01"]
[]
[null,"4. Báo cáo thực tế trong năm"]
[null,"+ Các dữ liệu về thu nhập, chi tiêu của năm sẽ chạy tự động khi cập nhật dữ liệu thực tế"]
[null,"+  Biểu đồ tháng: Chọn tháng -> Dữ liệu chạy tự động"]

{"sheet":"Ngan sach","index":2,"n_rows":56,"n_cols":22,"rows_kept":56,"cut":false,"hidden":false,"merged":[[21,1,23,1],[32,1,34,1],[3,17,4,19],[5,17,10,19],[9,23,10,28],[5,1,7,1],[13,1,15,1]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Đơn vị tính:","Nghìn đồng",null,"NGÂN SÁCH CHI TIÊU GIA ĐÌNH"]
[null,null,"Thu nhập","T1","T2","T3","T4","T5","T6","T7","T8","T9","T10","T11","T12","Tổng"]
[null,null,"Lương & Thưởng",15000,15000,15000,30000,15000,15000,19000,15000,15000,15000,15000,25000,{"$f":"SUM(D6:O6)","v":209000},null,"Ứng dụng này được phát triển và quản lý bởi WPRO.VN\nKhi bạn luyện tập thành thói quen trong việc kiểm soát chi tiêu bạn sẽ thấy cuộc đời bạn chuyển biến tích cực ra sao.\nEmail cho Trường tại hòm mail: webkynang.vn@gmail.com khi cần trợ giúp nhé."]
[null,null,"Ngoài giờ",2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,{"$f":"SUM(D7:O7)","v":24000}]
[null,null,"Lãi",500,500,500,500,500,500,500,500,500,500,500,500,6000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Total",{"$f":"+SUM(D6:D10)","v":17500},{"$f":"+SUM(E6:E10)","v":17500},17500,32500,17500,17500,21500,17500,17500,17500,17500,27500,239000]
[]
[null,null,"Chi cố định","T1","T2","T3","T4","T5","T6","T7","T8","T9","T10","T11","T12","Tổng",null,null,"Tổng hợp"]
[null,null,"Thuê nhà",2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,{"$f":"SUM(D14:O14)","v":30000},null,null,"Thu nhập",{"$f":"+P11","v":239000}]
[null,null,"Điện thoại",500,500,500,500,500,500,500,500,500,500,500,500,6000,null,null,"Chi tiêu",{"$f":"P19+P30+P38","v":118450}]
[null,null,"Mạng internet",300,300,300,300,300,300,300,300,300,300,300,300,3600,null,null,"Tiết kiệm - Đầu tư",{"$f":"+P53","v":56550}]
[null,null,"Tiền học cho con",1675,1675,1675,1675,1675,1675,1675,1675,1675,1675,1675,1675,20100,null,null,"Trả nợ",{"$f":"+P46","v":35000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Còn lại",{"$f":"+T14-SUM(T15:T17)","v":29000}]
[null,null,"Total",{"$f":"SUM(D14:D18)","v":4975},4975,4975,4975,4975,4975,4975,4975,4975,4975,4975,4975,59700]
[]
[null,null,"Chi thường xuyên","T1","T2","T3","T4","T5","T6","T7","T8","T9","T10","T11","T12","Tổng",null,null,"Các chỉ số quan trọng"]
[null,null,"Thức ăn",3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,{"$f":"SUM(D22:O22)","v":36000},null,null,"Tỉ lệ tiết kiệm",{"$f":"+T16/T14","v":0.23661087866108788},null,"Tỉ lệ tiết kiệm khuyến khích: > 50%"]
[null,null,"Điện",200,250,200,200,400,400,400,400,400,300,300,300,3750,null,null,"Tỉ lệ trả nợ/ thu nhập",{"$f":"+T17/T14","v":0.14644351464435146}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Total",{"$f":"SUM(D22:D29)","v":3200},{"$f":"SUM(E22:E29)","v":3250},{"$f":"SUM(F22:F29)","v":3200},{"$f":"SUM(G22:G29)","v":3200},{"$f":"SUM(H22:H29)","v":3400},{"$f":"SUM(I22:I29)","v":3400},{"$f":"SUM(J22:J29)","v":3400},{"$f":"SUM(K22:K29)","v":3400},{"$f":"SUM(L22:L29)","v":3400},{"$f":"SUM(M22:M29)","v":3300},{"$f":"SUM(N22:N29)","v":3300},{"$f":"SUM(O22:O29)","v":3300},39750]
[]
[null,null,"Chi bất thường","T1","T2","T3","T4","T5","T6","T7","T8","T9","T10","T11","T12","Tổng"]
[null,null,"Đi lại + về quê",200,200,200,200,200,200,200,200,200,200,200,200,{"$f":"SUM(D33:O33)","v":2400}]
[null,null,"Khám bệnh",500,500,500,500,500,500,500,500,500,500,500,500,6000]
[null,null,"Du lịch",200,200,200,200,200,null,null,null,null,null,null,null,1000]
[null,null,"Khác",1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,{"$f":"SUM(D36:O36)","v":12000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Total",{"$f":"SUM(D34:D37)","v":1700},1700,1700,1700,1700,1500,1500,1500,1500,1500,1500,1500,19000]
[]
[null,null,"Trả nợ","T1","T2","T3","T4","T5","T6","T7","T8","T9","T10","T11","T12","Tổng"]
[null,null,"Vay Mua nhà",null,null,null,null,null,5000,5000,5000,5000,5000,5000,5000,{"$f":"SUM(D41:O41)","v":35000}]
[null,null,"Mua xe",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Vay nợ cá nhân",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Thẻ tín dụng",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Total",{"$f":"SUM(D41:D43)","v":0},{"$f":"SUM(E41:E43)","v":0},0,0,0,5000,5000,5000,5000,5000,5000,5000,35000]
[]
[null,null,"Tiết kiệm & đầu tư","T1","T2","T3","T4","T5","T6","T7","T8","T9","T10","T11","T12","Tổng"]
[null,null,"TK Ngân hàng",7625,7575,7625,7625,7425,2625,2625,2625,2625,2725,2725,2725,{"$f":"SUM(D49:O49)","v":56550}]
[null,null,"Bảo hiểm",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Đầu tư",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Total",{"$f":"SUM(D49:D50)","v":7625},{"$f":"SUM(E49:E50)","v":7575},7625,7625,7425,2625,2625,2625,2625,2725,2725,2725,56550]
[]
[null,null,null,"T1","T2","T3","T4","T5","T6","T7","T8","T9","T10","T11","T12","Tổng"]
[null,null,"Chênh (Thu nhập - Chi)",{"$f":"+D11-D19-D30-D38-D46-D53","v":0},{"$f":"+E11-E19-E30-E38-E46-E53","v":0},0,15000,0,0,4000,0,0,0,0,10000,{"$f":"SUM(D56:O56)","v":29000}]

{"sheet":"T1","index":3,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[43,13,43,15],[38,13,38,15],[39,13,39,15],[40,13,40,15],[41,13,41,15],[42,13,42,15],[33,13,33,15],[34,13,34,15],[35,13,35,15],[36,13,36,15],[37,13,37,15],[28,13,28,15],[29,13,29,15],[30,13,30,15],[31,13,31,15],[32,13,32,15],[23,13,23,15],[24,13,24,15],[25,13,25,15],[26,13,26,15],[27,13,27,15],[18,13,18,15],[19,13,19,15],[20,13,20,15],[21,13,21,15],[22,13,22,15],[13,13,13,15],[14,13,14,15],[15,13,15,15],[16,13,16,15],[17,13,17,15],[4,9,6,12],[9,13,9,15],[10,13,10,15],[11,13,11,15],[12,13,12,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu nhập",{"$f":"+N52","v":18725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chi tiêu",{"$f":"+L42+K52+H52+E52+B52","v":18505}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chênh lệch",{"$f":"+R1-R2","v":220}]
[null,"Thu nhập","Chi T.xuyên","Chi cố định","Chi B.Thường","Trả nợ","T.kiệm & ĐT","Còn lại",null,{"$f":"+IF(L44+H54>=0,\"\",\"CẢNH BÁO: CHI THƯỜNG XUYÊN + CHI BÁT THƯỜNG VƯỢT NGÂN SÁCH\")","v":"CẢNH BÁO: CHI THƯỜNG XUYÊN + CHI BÁT THƯỜNG VƯỢT NGÂN SÁCH"}]
["Ngân sách",{"$f":"+N53","v":17500},{"$f":"+L43","v":3200},{"$f":"+B53","v":4975},{"$f":"+H53","v":1700},{"$f":"+E53","v":0},{"$f":"+K53","v":7625},{"$f":"+B6-SUM(C6:G6)","v":0}]
["Thực tế",{"$f":"+N52","v":18725},{"$f":"+L42","v":3450},{"$f":"+B52","v":4555},{"$f":"+H52","v":1500},{"$f":"+E52","v":0},{"$f":"+K52","v":9000},{"$f":"+B7-SUM(C7:G7)","v":220}]
["Chênh lêch",{"$f":"+B6-B7","v":-1225},{"$f":"+C6-C7","v":-250},420,200,0,-1375,null,null,null,null,null,null,null,null,"ĐVT: Nghìn đồng"]
[]
["Tháng 01",{"$f":"IF('Ngan sach'!C22=0, \"\", 'Ngan sach'!C22)","v":"Thức ăn"},{"$f":"IF('Ngan sach'!C23=0, \"\", 'Ngan sach'!C23)","v":"Điện"},{"$f":"IF('Ngan sach'!C24=0, \"\", 'Ngan sach'!C24)","v":""},{"$f":"IF('Ngan sach'!C25=0, \"\", 'Ngan sach'!C25)","v":""},{"$f":"IF('Ngan sach'!C26=0, \"\", 'Ngan sach'!C26)","v":""},{"$f":"IF('Ngan sach'!C27=0, \"\", 'Ngan sach'!C27)","v":""},{"$f":"IF('Ngan sach'!C28=0, \"\", 'Ngan sach'!C28)","v":""},{"$f":"IF('Ngan sach'!C29=0, \"\", 'Ngan sach'!C29)","v":""},null,null,"Tổng chi","Còn lại","Ghi chú"]
[1,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B11:K11)=0,\"\",SUM(B11:K11))","v":100},{"$f":"L43-SUM(B11:K11)","v":3100}]
[2,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B12:K12)=0,\" \",SUM(B12:K12))","v":100},{"$f":"M11-SUM(B12:K12)","v":3000}]
[3,100,null,null,null,null,null,null,null,null,null,100,{"$f":"M12-SUM(B13:K13)","v":2900}]
[4,100,100,null,null,null,null,null,null,null,null,200,2700]
[5,150,null,null,null,null,null,null,null,null,null,150,2550]
[6,100,null,null,null,null,null,null,null,null,null,100,2450]
[7,100,null,null,null,null,null,null,null,null,null,100,2350]
[8,100,null,null,null,null,null,null,null,null,null,100,2250]
[9,100,300,null,null,null,null,null,null,null,null,400,1850]
[10,100,null,null,null,null,null,null,null,null,null,100,1750]
[11,100,null,null,null,null,null,null,null,null,null,100,1650]
[12,200,null,null,null,null,null,null,null,null,null,200,1450]
[13,100,null,null,null,null,null,null,null,null,null,100,1350]
[14,100,null,null,null,null,null,null,null,null,null,100,1250]
[15,100,null,null,null,null,null,null,null,null,null,100,1150]
[16,100,null,null,null,null,null,null,null,null,null,100,1050]
[17,100,null,null,null,null,null,null,null,null,null,100,950]
[18,100,null,null,null,null,null,null,null,null,null,100,850]
[19,100,null,null,null,null,null,null,null,null,null,100,750]
[20,100,null,null,null,null,null,null,null,null,null,100,650]
[21,400,null,null,null,null,null,null,null,null,null,400,250]
[22,100,null,null,null,null,null,null,null,null,null,100,150]
[23,100,null,null,null,null,null,null,null,null,null,100,50]
[24,100,null,null,null,null,null,null,null,null,null,100,-50]
[25,100,null,null,null,null,null,null,null,null,null,100,-150]
[26,100,null,null,null,null,null,null,null,null,null,100,-250]
[27,null,null,null,null,null,null,null,null,null,null," ",-250]
[28,null,null,null,null,null,null,null,null,null,null," ",-250]
[29,null,null,null,null,null,null,null,null,null,null," ",-250]
[30,null,null,null,null,null,null,null,null,null,null," ",-250]
[31,null,null,null,null,null,null,null,null,null,null," ",-250]
["Đã chi",{"$f":"IF(SUM(B11:B41)=0,\"\",SUM(B11:B41))","v":3050},{"$f":"IF(SUM(C11:C41)=0,\"\",SUM(C11:C41))","v":400},{"$f":"IF(SUM(D11:D41)=0,\"\",SUM(D11:D41))","v":""},"","","","","","","",{"$f":"IF(SUM(L11:L41)=0,0,SUM(L11:L41))","v":3450},0]
["Ngân sách",{"$f":"'Ngan sach'!D22","v":3000},{"$f":"'Ngan sach'!D23","v":200},{"$f":"'Ngan sach'!D24","v":0},{"$f":"'Ngan sach'!D25","v":0},{"$f":"'Ngan sach'!D26","v":0},{"$f":"'Ngan sach'!D27","v":0},{"$f":"'Ngan sach'!D28","v":0},{"$f":"'Ngan sach'!D29","v":0},null,null,{"$f":"SUM(B43:K43)","v":3200},0]
["Còn lại",{"$f":"B43-SUM(B11:B41)","v":-50},{"$f":"C43-SUM(C11:C41)","v":-200},0,0,0,0,0,0,0,0,-250,0]
[]
["Cố định",null,null,"Trả nợ",null,null,"Bất thường",null,null,"Tiết kiệm & đầu tư",null,null,"Thu nhập thực tế"]
[{"$f":"IF('Ngan sach'!$C$14=0,\" \",'Ngan sach'!$C$14)","v":"Thuê nhà"},2500,null,{"$f":"IF('Ngan sach'!$C$41=0,\" \",'Ngan sach'!$C$41)","v":"Vay Mua nhà"},null,null,{"$f":"IF('Ngan sach'!$C$33=0,\" \",'Ngan sach'!$C$33)","v":"Đi lại + về quê"},1000,null,{"$f":"IF('Ngan sach'!$C$49=0,\" \",'Ngan sach'!$C$49)","v":"TK Ngân hàng"},9000,null,{"$f":"IF('Ngan sach'!$C$6=0,\" \",'Ngan sach'!$C$6)","v":"Lương & Thưởng"},16725]
[{"$f":"IF('Ngan sach'!$C$15=0,\" \",'Ngan sach'!$C$15)","v":"Điện thoại"},200,null,{"$f":"IF('Ngan sach'!$C$42=0,\" \",'Ngan sach'!$C$42)","v":"Mua xe"},null,null,{"$f":"IF('Ngan sach'!$C$34=0,\" \",'Ngan sach'!$C$34)","v":"Khám bệnh"},500,null,{"$f":"IF('Ngan sach'!$C$50=0,\" \",'Ngan sach'!$C$50)","v":"Bảo hiểm"},null,null,{"$f":"IF('Ngan sach'!$C$7=0,\" \",'Ngan sach'!$C$7)","v":"Ngoài giờ"},2000]
[{"$f":"IF('Ngan sach'!$C$16=0,\" \",'Ngan sach'!$C$16)","v":"Mạng internet"},200,null,{"$f":"IF('Ngan sach'!$C$43=0,\" \",'Ngan sach'!$C$43)","v":"Vay nợ cá nhân"},null,null,{"$f":"IF('Ngan sach'!$C$35=0,\" \",'Ngan sach'!$C$35)","v":"Du lịch"},null,null,{"$f":"IF('Ngan sach'!$C$51=0,\" \",'Ngan sach'!$C$51)","v":"Đầu tư"},null,null,{"$f":"IF('Ngan sach'!$C$8=0,\" \",'Ngan sach'!$C$8)","v":"Lãi"}]
[{"$f":"IF('Ngan sach'!$C$17=0,\" \",'Ngan sach'!$C$17)","v":"Tiền học cho con"},1655,null,{"$f":"IF('Ngan sach'!$C$44=0,\" \",'Ngan sach'!$C$44)","v":"Thẻ tín dụng"},null,null,{"$f":"IF('Ngan sach'!$C$36=0,\" \",'Ngan sach'!$C$36)","v":"Khác"},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
[{"$f":"IF('Ngan sach'!$C$18=0,\" \",'Ngan sach'!$C$18)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$45=0,\" \",'Ngan sach'!$C$45)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$37=0,\" \",'Ngan sach'!$C$37)","v":" "}]
["Tổng thực tế",{"$f":"SUM(B47:B51)","v":4555},null,"Tổng thực tế",{"$f":"SUM(E47:E51)","v":0},null,"Tổng thực tế",{"$f":"SUM(H47:H51)","v":1500},null,"Tổng thực tế",{"$f":"SUM(K47:K51)","v":9000},null,"Tổng thực tế",{"$f":"SUM(N47:N50)","v":18725}]
["Ngân sách",{"$f":"+'Ngan sach'!D19","v":4975},null,"Ngân sách",{"$f":"+'Ngan sach'!D46","v":0},null,"Ngân sách",{"$f":"+'Ngan sach'!D38","v":1700},null,"Ngân sách",{"$f":"+'Ngan sach'!D53","v":7625},null,"Ngân sách",{"$f":"+'Ngan sach'!D11","v":17500}]
["Chênh lệch",{"$f":"B53-B52","v":420},null,"Chênh lệch",{"$f":"E53-E52","v":0},null,"Chênh lệch",{"$f":"H53-H52","v":200},null,"Chênh lệch",{"$f":"K53-K52","v":-1375},null,"Chênh lệch",{"$f":"N53-N52","v":-1225}]

{"sheet":"T2","index":4,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[43,13,43,15],[38,13,38,15],[39,13,39,15],[40,13,40,15],[41,13,41,15],[42,13,42,15],[33,13,33,15],[34,13,34,15],[35,13,35,15],[36,13,36,15],[37,13,37,15],[28,13,28,15],[29,13,29,15],[30,13,30,15],[31,13,31,15],[32,13,32,15],[23,13,23,15],[24,13,24,15],[25,13,25,15],[26,13,26,15],[27,13,27,15],[4,9,6,12],[45,11,47,11],[9,13,9,15],[10,13,10,15],[11,13,11,15],[12,13,12,15],[13,13,13,15],[14,13,14,15],[15,13,15,15],[16,13,16,15],[17,13,17,15],[18,13,18,15],[19,13,19,15],[20,13,20,15],[21,13,21,15],[22,13,22,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu nhập",{"$f":"+N52","v":21725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chi tiêu",{"$f":"+B52+E52+H52+K52+L42","v":21555}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chênh lệch",{"$f":"+R1-R2","v":170}]
[]
[null,"Thu nhập","Chi T.xuyên","Chi cố định","Chi B.Thường","Trả nợ","T.kiệm & ĐT","Còn lại",null,{"$f":"+IF(L44+H54>=0,\"\",\"CẢNH BÁO: CHI THƯỜNG XUYÊN + CHI BẤT THƯỜNG VƯỢT NGÂN SÁCH\")","v":"CẢNH BÁO: CHI THƯỜNG XUYÊN + CHI BẤT THƯỜNG VƯỢT NGÂN SÁCH"}]
["Ngân sách",{"$f":"+N53","v":17500},{"$f":"+L43","v":3250},{"$f":"+B53","v":4975},{"$f":"+H53","v":1700},{"$f":"+E53","v":0},{"$f":"+K53","v":7575},{"$f":"+B6-SUM(C6:G6)","v":0}]
["Thực tế",{"$f":"+N52","v":21725},{"$f":"+L42","v":3000},{"$f":"+B52","v":4555},{"$f":"+H52","v":2000},{"$f":"+E52","v":0},{"$f":"+K52","v":12000},{"$f":"+B7-SUM(C7:G7)","v":170}]
["Chênh lêch",{"$f":"+B6-B7","v":-4225},{"$f":"+C6-C7","v":250},420,-300,0,-4425,null,null,null,null,null,null,null,null,"ĐVT: Nghìn đồng"]
[]
["Tháng 02",{"$f":"IF('Ngan sach'!C22=0, \"\", 'Ngan sach'!C22)","v":"Thức ăn"},{"$f":"IF('Ngan sach'!C23=0, \"\", 'Ngan sach'!C23)","v":"Điện"},{"$f":"IF('Ngan sach'!C24=0, \"\", 'Ngan sach'!C24)","v":""},{"$f":"IF('Ngan sach'!C25=0, \"\", 'Ngan sach'!C25)","v":""},{"$f":"IF('Ngan sach'!C26=0, \"\", 'Ngan sach'!C26)","v":""},{"$f":"IF('Ngan sach'!C27=0, \"\", 'Ngan sach'!C27)","v":""},{"$f":"IF('Ngan sach'!C28=0, \"\", 'Ngan sach'!C28)","v":""},{"$f":"IF('Ngan sach'!C29=0, \"\", 'Ngan sach'!C29)","v":""},null,null,null,"Còn lại","Ghi chú"]
[1,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B11:K11)=0,\"\",SUM(B11:K11))","v":100},{"$f":"L43-SUM(B11:K11)","v":3150}]
[2,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B12:K12)=0,\" \",SUM(B12:K12))","v":100},{"$f":"M11-SUM(B12:K12)","v":3050}]
[3,100,null,null,null,null,null,null,null,null,null,100,{"$f":"M12-SUM(B13:K13)","v":2950}]
[4,100,400,null,null,null,null,null,null,null,null,500,2450]
[5,100,null,null,null,null,null,null,null,null,null,100,2350]
[6,100,null,null,null,null,null,null,null,null,null,100,2250]
[7,100,null,null,null,null,null,null,null,null,null,100,2150]
[8,100,null,null,null,null,null,null,null,null,null,100,2050]
[9,100,null,null,null,null,null,null,null,null,null,100,1950]
[10,100,null,null,null,null,null,null,null,null,null,100,1850]
[11,100,null,null,null,null,null,null,null,null,null,100,1750]
[12,100,null,null,null,null,null,null,null,null,null,100,1650]
[13,100,null,null,null,null,null,null,null,null,null,100,1550]
[14,100,null,null,null,null,null,null,null,null,null,100,1450]
[15,100,null,null,null,null,null,null,null,null,null,100,1350]
[16,100,null,null,null,null,null,null,null,null,null,100,1250]
[17,100,null,null,null,null,null,null,null,null,null,100,1150]
[18,100,null,null,null,null,null,null,null,null,null,100,1050]
[19,100,null,null,null,null,null,null,null,null,null,100,950]
[20,100,null,null,null,null,null,null,null,null,null,100,850]
[21,100,null,null,null,null,null,null,null,null,null,100,750]
[22,100,null,null,null,null,null,null,null,null,null,100,650]
[23,100,null,null,null,null,null,null,null,null,null,100,550]
[24,100,null,null,null,null,null,null,null,null,null,100,450]
[25,100,null,null,null,null,null,null,null,null,null,100,350]
[26,100,null,null,null,null,null,null,null,null,null,100,250]
[27,null,null,null,null,null,null,null,null,null,null," ",250]
[28,null,null,null,null,null,null,null,null,null,null," ",250]
[null,null,null,null,null,null,null,null,null,null,null," ",250]
[null,null,null,null,null,null,null,null,null,null,null," ",250]
[null,null,null,null,null,null,null,null,null,null,null," ",250]
["Đã chi",{"$f":"IF(SUM(B11:B41)=0,\"\",SUM(B11:B41))","v":2600},{"$f":"IF(SUM(C11:C41)=0,\"\",SUM(C11:C41))","v":400},{"$f":"IF(SUM(D11:D41)=0,\"\",SUM(D11:D41))","v":""},"","","","","","","",{"$f":"IF(SUM(L11:L41)=0,0,SUM(L11:L41))","v":3000}]
["Ngân sách",{"$f":"'Ngan sach'!E22","v":3000},{"$f":"'Ngan sach'!E23","v":250},{"$f":"'Ngan sach'!E24","v":0},{"$f":"'Ngan sach'!E25","v":0},{"$f":"'Ngan sach'!E26","v":0},{"$f":"'Ngan sach'!E27","v":0},{"$f":"'Ngan sach'!E28","v":0},{"$f":"'Ngan sach'!E29","v":0},null,null,{"$f":"SUM(B43:K43)","v":3250}]
["Còn lại",{"$f":"B43-SUM(B11:B41)","v":400},{"$f":"C43-SUM(C11:C41)","v":-150},0,0,0,0,0,0,0,0,250]
[]
["Cố định",null,null,"Trả nợ",null,null,"Bất thường",null,null,"Tiết kiệm & đầu tư",null,null,"Thu nhập thực tế"]
[{"$f":"IF('Ngan sach'!$C$14=0,\" \",'Ngan sach'!$C$14)","v":"Thuê nhà"},2500,null,{"$f":"IF('Ngan sach'!$C$41=0,\" \",'Ngan sach'!$C$41)","v":"Vay Mua nhà"},null,null,{"$f":"IF('Ngan sach'!$C$33=0,\" \",'Ngan sach'!$C$33)","v":"Đi lại + về quê"},2000,null,{"$f":"IF('Ngan sach'!$C$49=0,\" \",'Ngan sach'!$C$49)","v":"TK Ngân hàng"},12000,null,{"$f":"IF('Ngan sach'!$C$6=0,\" \",'Ngan sach'!$C$6)","v":"Lương & Thưởng"},16725]
[{"$f":"IF('Ngan sach'!$C$15=0,\" \",'Ngan sach'!$C$15)","v":"Điện thoại"},200,null,{"$f":"IF('Ngan sach'!$C$42=0,\" \",'Ngan sach'!$C$42)","v":"Mua xe"},null,null,{"$f":"IF('Ngan sach'!$C$34=0,\" \",'Ngan sach'!$C$34)","v":"Khám bệnh"},null,null,{"$f":"IF('Ngan sach'!$C$50=0,\" \",'Ngan sach'!$C$50)","v":"Bảo hiểm"},null,null,{"$f":"IF('Ngan sach'!$C$7=0,\" \",'Ngan sach'!$C$7)","v":"Ngoài giờ"},5000]
[{"$f":"IF('Ngan sach'!$C$16=0,\" \",'Ngan sach'!$C$16)","v":"Mạng internet"},200,null,{"$f":"IF('Ngan sach'!$C$43=0,\" \",'Ngan sach'!$C$43)","v":"Vay nợ cá nhân"},null,null,{"$f":"IF('Ngan sach'!$C$35=0,\" \",'Ngan sach'!$C$35)","v":"Du lịch"},null,null,{"$f":"IF('Ngan sach'!$C$51=0,\" \",'Ngan sach'!$C$51)","v":"Đầu tư"},null,null,{"$f":"IF('Ngan sach'!$C$8=0,\" \",'Ngan sach'!$C$8)","v":"Lãi"}]
[{"$f":"IF('Ngan sach'!$C$17=0,\" \",'Ngan sach'!$C$17)","v":"Tiền học cho con"},1655,null,{"$f":"IF('Ngan sach'!$C$44=0,\" \",'Ngan sach'!$C$44)","v":"Thẻ tín dụng"},null,null,{"$f":"IF('Ngan sach'!$C$36=0,\" \",'Ngan sach'!$C$36)","v":"Khác"},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
[{"$f":"IF('Ngan sach'!$C$18=0,\" \",'Ngan sach'!$C$18)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$45=0,\" \",'Ngan sach'!$C$45)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$37=0,\" \",'Ngan sach'!$C$37)","v":" "},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
["Tổng thực tế",{"$f":"SUM(B47:B51)","v":4555},null,"Tổng thực tế",{"$f":"SUM(E47:E51)","v":0},null,"Tổng thực tế",{"$f":"SUM(H47:H51)","v":2000},null,"Tổng thực tế",{"$f":"SUM(K47:K51)","v":12000},null,"Tổng thực tế",{"$f":"SUM(N47:N50)","v":21725}]
["Ngân sách",{"$f":"+'Ngan sach'!E19","v":4975},null,"Ngân sách",{"$f":"+'Ngan sach'!E46","v":0},null,"Ngân sách",{"$f":"+'Ngan sach'!E38","v":1700},null,"Ngân sách",{"$f":"+'Ngan sach'!E53","v":7575},null,"Ngân sách",{"$f":"+'Ngan sach'!E11","v":17500}]
["Chênh lệch",{"$f":"B53-B52","v":420},null,"Chênh lệch",{"$f":"E53-E52","v":0},null,"Chênh lệch",{"$f":"H53-H52","v":-300},null,"Chênh lệch",{"$f":"K53-K52","v":-4425},null,"Chênh lệch",{"$f":"N53-N52","v":-4225}]

{"sheet":"T3","index":5,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[43,13,43,15],[38,13,38,15],[39,13,39,15],[40,13,40,15],[41,13,41,15],[42,13,42,15],[33,13,33,15],[34,13,34,15],[35,13,35,15],[36,13,36,15],[37,13,37,15],[28,13,28,15],[29,13,29,15],[30,13,30,15],[31,13,31,15],[32,13,32,15],[23,13,23,15],[24,13,24,15],[25,13,25,15],[26,13,26,15],[27,13,27,15],[4,9,6,12],[45,11,47,11],[9,13,9,15],[10,13,10,15],[11,13,11,15],[12,13,12,15],[13,13,13,15],[14,13,14,15],[15,13,15,15],[16,13,16,15],[17,13,17,15],[18,13,18,15],[19,13,19,15],[20,13,20,15],[21,13,21,15],[22,13,22,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu nhập",{"$f":"+N52","v":19725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chi tiêu",{"$f":"+B52+E52+H52+K52+L42","v":19555}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chênh lệch",{"$f":"+R1-R2","v":170}]
[null,"Thu nhập","Chi T.xuyên","Chi cố định","Chi B.Thường","Trả nợ","T.kiệm & ĐT","Còn lại",null,{"$f":"+IF(L44+H54>=0,\"\",\"CẢNH BÁO: CHI THƯỜNG XUYÊN + CHI BẤT THƯỜNG VƯỢT NGÂN SÁCH\")","v":""}]
["Ngân sách",{"$f":"+N53","v":17500},{"$f":"+L43","v":3200},{"$f":"+B53","v":4975},{"$f":"+H53","v":1700},{"$f":"+E53","v":0},{"$f":"+K53","v":7625},{"$f":"+B6-SUM(C6:G6)","v":0}]
["Thực tế",{"$f":"+N52","v":19725},{"$f":"+L42","v":3500},{"$f":"+B52","v":4555},{"$f":"+H52","v":0},{"$f":"+E52","v":0},{"$f":"+K52","v":11500},{"$f":"+B7-SUM(C7:G7)","v":170}]
["Chênh lêch",{"$f":"+B6-B7","v":-2225},{"$f":"+C6-C7","v":-300},420,1700,0,-3875,null,null,null,null,null,null,null,null,"ĐVT: Nghìn đồng"]
[]
["Tháng 03",{"$f":"IF('Ngan sach'!C22=0, \"\", 'Ngan sach'!C22)","v":"Thức ăn"},{"$f":"IF('Ngan sach'!C23=0, \"\", 'Ngan sach'!C23)","v":"Điện"},{"$f":"IF('Ngan sach'!C24=0, \"\", 'Ngan sach'!C24)","v":""},{"$f":"IF('Ngan sach'!C25=0, \"\", 'Ngan sach'!C25)","v":""},{"$f":"IF('Ngan sach'!C26=0, \"\", 'Ngan sach'!C26)","v":""},{"$f":"IF('Ngan sach'!C27=0, \"\", 'Ngan sach'!C27)","v":""},{"$f":"IF('Ngan sach'!C28=0, \"\", 'Ngan sach'!C28)","v":""},{"$f":"IF('Ngan sach'!C29=0, \"\", 'Ngan sach'!C29)","v":""},null,null,"Tổng chi","Còn lại","Ghi chú"]
[1,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B11:K11)=0,\"\",SUM(B11:K11))","v":100},{"$f":"L43-SUM(B11:K11)","v":3100}]
[2,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B12:K12)=0,\" \",SUM(B12:K12))","v":100},{"$f":"M11-SUM(B12:K12)","v":3000}]
[3,100,null,null,null,null,null,null,null,null,null,100,{"$f":"M12-SUM(B13:K13)","v":2900}]
[4,100,400,null,null,null,null,null,null,null,null,500,2400]
[5,100,null,null,null,null,null,null,null,null,null,100,2300]
[6,100,null,null,null,null,null,null,null,null,null,100,2200]
[7,100,null,null,null,null,null,null,null,null,null,100,2100]
[8,100,null,null,null,null,null,null,null,null,null,100,2000]
[9,100,null,null,null,null,null,null,null,null,null,100,1900]
[10,100,null,null,null,null,null,null,null,null,null,100,1800]
[11,100,null,null,null,null,null,null,null,null,null,100,1700]
[12,100,null,null,null,null,null,null,null,null,null,100,1600]
[13,100,null,null,null,null,null,null,null,null,null,100,1500]
[14,100,null,null,null,null,null,null,null,null,null,100,1400]
[15,100,null,null,null,null,null,null,null,null,null,100,1300]
[16,100,null,null,null,null,null,null,null,null,null,100,1200]
[17,100,null,null,null,null,null,null,null,null,null,100,1100]
[18,100,null,null,null,null,null,null,null,null,null,100,1000]
[19,100,null,null,null,null,null,null,null,null,null,100,900]
[20,100,null,null,null,null,null,null,null,null,null,100,800]
[21,100,null,null,null,null,null,null,null,null,null,100,700]
[22,100,null,null,null,null,null,null,null,null,null,100,600]
[23,100,null,null,null,null,null,null,null,null,null,100,500]
[24,100,null,null,null,null,null,null,null,null,null,100,400]
[25,100,null,null,null,null,null,null,null,null,null,100,300]
[26,100,null,null,null,null,null,null,null,null,null,100,200]
[27,100,null,null,null,null,null,null,null,null,null,100,100]
[28,100,null,null,null,null,null,null,null,null,null,100,0]
[29,100,null,null,null,null,null,null,null,null,null,100,-100]
[30,100,null,null,null,null,null,null,null,null,null,100,-200]
[31,100,null,null,null,null,null,null,null,null,null,100,-300]
["Đã chi",{"$f":"IF(SUM(B11:B41)=0,\"\",SUM(B11:B41))","v":3100},{"$f":"IF(SUM(C11:C41)=0,\"\",SUM(C11:C41))","v":400},{"$f":"IF(SUM(D11:D41)=0,\"\",SUM(D11:D41))","v":""},"","","","","","","",{"$f":"IF(SUM(L11:L41)=0,0,SUM(L11:L41))","v":3500}]
["Ngân sách",{"$f":"'Ngan sach'!F22","v":3000},{"$f":"'Ngan sach'!F23","v":200},{"$f":"'Ngan sach'!F24","v":0},{"$f":"'Ngan sach'!F25","v":0},{"$f":"'Ngan sach'!F26","v":0},{"$f":"'Ngan sach'!F27","v":0},{"$f":"'Ngan sach'!F28","v":0},{"$f":"'Ngan sach'!F29","v":0},null,null,{"$f":"SUM(B43:K43)","v":3200}]
["Còn lại",{"$f":"B43-SUM(B11:B41)","v":-100},{"$f":"C43-SUM(C11:C41)","v":-200},0,0,0,0,0,0,0,0,-300]
[]
["Cố định",null,null,"Trả nợ",null,null,"Bất thường",null,null,"Tiết kiệm & đầu tư",null,null,"Thu nhập thực tế"]
[{"$f":"IF('Ngan sach'!$C$14=0,\" \",'Ngan sach'!$C$14)","v":"Thuê nhà"},2500,null,{"$f":"IF('Ngan sach'!$C$41=0,\" \",'Ngan sach'!$C$41)","v":"Vay Mua nhà"},null,null,{"$f":"IF('Ngan sach'!$C$33=0,\" \",'Ngan sach'!$C$33)","v":"Đi lại + về quê"},null,null,{"$f":"IF('Ngan sach'!$C$49=0,\" \",'Ngan sach'!$C$49)","v":"TK Ngân hàng"},11500,null,{"$f":"IF('Ngan sach'!$C$6=0,\" \",'Ngan sach'!$C$6)","v":"Lương & Thưởng"},16725]
[{"$f":"IF('Ngan sach'!$C$15=0,\" \",'Ngan sach'!$C$15)","v":"Điện thoại"},200,null,{"$f":"IF('Ngan sach'!$C$42=0,\" \",'Ngan sach'!$C$42)","v":"Mua xe"},null,null,{"$f":"IF('Ngan sach'!$C$34=0,\" \",'Ngan sach'!$C$34)","v":"Khám bệnh"},null,null,{"$f":"IF('Ngan sach'!$C$50=0,\" \",'Ngan sach'!$C$50)","v":"Bảo hiểm"},null,null,{"$f":"IF('Ngan sach'!$C$7=0,\" \",'Ngan sach'!$C$7)","v":"Ngoài giờ"},3000]
[{"$f":"IF('Ngan sach'!$C$16=0,\" \",'Ngan sach'!$C$16)","v":"Mạng internet"},200,null,{"$f":"IF('Ngan sach'!$C$43=0,\" \",'Ngan sach'!$C$43)","v":"Vay nợ cá nhân"},null,null,{"$f":"IF('Ngan sach'!$C$35=0,\" \",'Ngan sach'!$C$35)","v":"Du lịch"},null,null,{"$f":"IF('Ngan sach'!$C$51=0,\" \",'Ngan sach'!$C$51)","v":"Đầu tư"},null,null,{"$f":"IF('Ngan sach'!$C$8=0,\" \",'Ngan sach'!$C$8)","v":"Lãi"}]
[{"$f":"IF('Ngan sach'!$C$17=0,\" \",'Ngan sach'!$C$17)","v":"Tiền học cho con"},1655,null,{"$f":"IF('Ngan sach'!$C$44=0,\" \",'Ngan sach'!$C$44)","v":"Thẻ tín dụng"},null,null,{"$f":"IF('Ngan sach'!$C$36=0,\" \",'Ngan sach'!$C$36)","v":"Khác"},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
[{"$f":"IF('Ngan sach'!$C$18=0,\" \",'Ngan sach'!$C$18)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$45=0,\" \",'Ngan sach'!$C$45)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$37=0,\" \",'Ngan sach'!$C$37)","v":" "},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
["Tổng thực tế",{"$f":"SUM(B47:B51)","v":4555},null,"Tổng thực tế",{"$f":"SUM(E47:E51)","v":0},null,"Tổng thực tế",{"$f":"SUM(H47:H51)","v":0},null,"Tổng thực tế",{"$f":"SUM(K47:K51)","v":11500},null,"Tổng thực tế",{"$f":"SUM(N47:N50)","v":19725}]
["Ngân sách",{"$f":"+'Ngan sach'!F19","v":4975},null,"Ngân sách",{"$f":"+'Ngan sach'!F46","v":0},null,"Ngân sách",{"$f":"+'Ngan sach'!F38","v":1700},null,"Ngân sách",{"$f":"+'Ngan sach'!F53","v":7625},null,"Ngân sách",{"$f":"+'Ngan sach'!F11","v":17500}]
["Chênh lệch",{"$f":"B53-B52","v":420},null,"Chênh lệch",{"$f":"E53-E52","v":0},null,"Chênh lệch",{"$f":"H53-H52","v":1700},null,"Chênh lệch",{"$f":"K53-K52","v":-3875},null,"Chênh lệch",{"$f":"N53-N52","v":-2225}]

{"sheet":"T4","index":6,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[43,13,43,15],[38,13,38,15],[39,13,39,15],[40,13,40,15],[41,13,41,15],[42,13,42,15],[33,13,33,15],[34,13,34,15],[35,13,35,15],[36,13,36,15],[37,13,37,15],[28,13,28,15],[29,13,29,15],[30,13,30,15],[31,13,31,15],[32,13,32,15],[23,13,23,15],[24,13,24,15],[25,13,25,15],[26,13,26,15],[27,13,27,15],[4,9,6,12],[45,11,47,11],[9,13,9,15],[10,13,10,15],[11,13,11,15],[12,13,12,15],[13,13,13,15],[14,13,14,15],[15,13,15,15],[16,13,16,15],[17,13,17,15],[18,13,18,15],[19,13,19,15],[20,13,20,15],[21,13,21,15],[22,13,22,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu nhập",{"$f":"+N52","v":31500}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chi tiêu",{"$f":"+B52+E52+H52+K52+L42","v":31555}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chênh lệch",{"$f":"+R1-R2","v":-55}]
[null,"Thu nhập","Chi T.xuyên","Chi cố định","Chi B.Thường","Trả nợ","T.kiệm & ĐT","Còn lại",null,{"$f":"+IF(L44+H54>=0,\"\",\"CẢNH BÁO: CHI THƯỜNG XUYÊN + CHI BẤT THƯỜNG VƯỢT NGÂN SÁCH\")","v":""}]
["Ngân sách",{"$f":"+N53","v":32500},{"$f":"+L43","v":3200},{"$f":"+B53","v":4975},{"$f":"+H53","v":1700},{"$f":"+E53","v":0},{"$f":"+K53","v":7625},{"$f":"+B6-SUM(C6:G6)","v":15000}]
["Thực tế",{"$f":"+N52","v":31500},{"$f":"+L42","v":3000},{"$f":"+B52","v":4555},{"$f":"+H52","v":0},{"$f":"+E52","v":0},{"$f":"+K52","v":24000},{"$f":"+B7-SUM(C7:G7)","v":-55}]
["Chênh lêch",{"$f":"+B6-B7","v":1000},{"$f":"+C6-C7","v":200},420,1700,0,-16375,null,null,null,null,null,null,null,null,"ĐVT: Nghìn đồng"]
[]
["Tháng 04",{"$f":"IF('Ngan sach'!C22=0, \"\", 'Ngan sach'!C22)","v":"Thức ăn"},{"$f":"IF('Ngan sach'!C23=0, \"\", 'Ngan sach'!C23)","v":"Điện"},{"$f":"IF('Ngan sach'!C24=0, \"\", 'Ngan sach'!C24)","v":""},{"$f":"IF('Ngan sach'!C25=0, \"\", 'Ngan sach'!C25)","v":""},{"$f":"IF('Ngan sach'!C26=0, \"\", 'Ngan sach'!C26)","v":""},{"$f":"IF('Ngan sach'!C27=0, \"\", 'Ngan sach'!C27)","v":""},{"$f":"IF('Ngan sach'!C28=0, \"\", 'Ngan sach'!C28)","v":""},{"$f":"IF('Ngan sach'!C29=0, \"\", 'Ngan sach'!C29)","v":""},null,null,"Tổng chi","Còn lại","Ghi chú"]
[1,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B11:K11)=0,\"\",SUM(B11:K11))","v":100},{"$f":"L43-SUM(B11:K11)","v":3100}]
[2,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B12:K12)=0,\" \",SUM(B12:K12))","v":100},{"$f":"M11-SUM(B12:K12)","v":3000}]
[3,100,null,null,null,null,null,null,null,null,null,100,{"$f":"M12-SUM(B13:K13)","v":2900}]
[4,100,400,null,null,null,null,null,null,null,null,500,2400]
[5,100,null,null,null,null,null,null,null,null,null,100,2300]
[6,100,null,null,null,null,null,null,null,null,null,100,2200]
[7,100,null,null,null,null,null,null,null,null,null,100,2100]
[8,100,null,null,null,null,null,null,null,null,null,100,2000]
[9,100,null,null,null,null,null,null,null,null,null,100,1900]
[10,100,null,null,null,null,null,null,null,null,null,100,1800]
[11,100,null,null,null,null,null,null,null,null,null,100,1700]
[12,100,null,null,null,null,null,null,null,null,null,100,1600]
[13,100,null,null,null,null,null,null,null,null,null,100,1500]
[14,100,null,null,null,null,null,null,null,null,null,100,1400]
[15,100,null,null,null,null,null,null,null,null,null,100,1300]
[16,100,null,null,null,null,null,null,null,null,null,100,1200]
[17,100,null,null,null,null,null,null,null,null,null,100,1100]
[18,100,null,null,null,null,null,null,null,null,null,100,1000]
[19,100,null,null,null,null,null,null,null,null,null,100,900]
[20,100,null,null,null,null,null,null,null,null,null,100,800]
[21,100,null,null,null,null,null,null,null,null,null,100,700]
[22,100,null,null,null,null,null,null,null,null,null,100,600]
[23,100,null,null,null,null,null,null,null,null,null,100,500]
[24,100,null,null,null,null,null,null,null,null,null,100,400]
[25,100,null,null,null,null,null,null,null,null,null,100,300]
[26,100,null,null,null,null,null,null,null,null,null,100,200]
[27,null,null,null,null,null,null,null,null,null,null," ",200]
[28,null,null,null,null,null,null,null,null,null,null," ",200]
[29,null,null,null,null,null,null,null,null,null,null," ",200]
[30,null,null,null,null,null,null,null,null,null,null," ",200]
[null,null,null,null,null,null,null,null,null,null,null," ",200]
["Đã chi",{"$f":"IF(SUM(B11:B41)=0,\"\",SUM(B11:B41))","v":2600},{"$f":"IF(SUM(C11:C41)=0,\"\",SUM(C11:C41))","v":400},{"$f":"IF(SUM(D11:D41)=0,\"\",SUM(D11:D41))","v":""},"","","","","","","",{"$f":"IF(SUM(L11:L41)=0,0,SUM(L11:L41))","v":3000}]
["Ngân sách",{"$f":"'Ngan sach'!G22","v":3000},{"$f":"'Ngan sach'!G23","v":200},{"$f":"'Ngan sach'!G24","v":0},{"$f":"'Ngan sach'!G25","v":0},{"$f":"'Ngan sach'!G26","v":0},{"$f":"'Ngan sach'!G27","v":0},{"$f":"'Ngan sach'!G28","v":0},{"$f":"'Ngan sach'!G29","v":0},null,null,{"$f":"SUM(B43:K43)","v":3200}]
["Còn lại",{"$f":"B43-SUM(B11:B41)","v":400},{"$f":"C43-SUM(C11:C41)","v":-200},0,0,0,0,0,0,0,0,200]
[]
["Cố định",null,null,"Trả nợ",null,null,"Bất thường",null,null,"Tiết kiệm & đầu tư",null,null,"Thu nhập thực tế"]
[{"$f":"IF('Ngan sach'!$C$14=0,\" \",'Ngan sach'!$C$14)","v":"Thuê nhà"},2500,null,{"$f":"IF('Ngan sach'!$C$41=0,\" \",'Ngan sach'!$C$41)","v":"Vay Mua nhà"},null,null,{"$f":"IF('Ngan sach'!$C$33=0,\" \",'Ngan sach'!$C$33)","v":"Đi lại + về quê"},null,null,{"$f":"IF('Ngan sach'!$C$49=0,\" \",'Ngan sach'!$C$49)","v":"TK Ngân hàng"},24000,null,{"$f":"IF('Ngan sach'!$C$6=0,\" \",'Ngan sach'!$C$6)","v":"Lương & Thưởng"},31500]
[{"$f":"IF('Ngan sach'!$C$15=0,\" \",'Ngan sach'!$C$15)","v":"Điện thoại"},200,null,{"$f":"IF('Ngan sach'!$C$42=0,\" \",'Ngan sach'!$C$42)","v":"Mua xe"},null,null,{"$f":"IF('Ngan sach'!$C$34=0,\" \",'Ngan sach'!$C$34)","v":"Khám bệnh"},null,null,{"$f":"IF('Ngan sach'!$C$50=0,\" \",'Ngan sach'!$C$50)","v":"Bảo hiểm"},null,null,{"$f":"IF('Ngan sach'!$C$7=0,\" \",'Ngan sach'!$C$7)","v":"Ngoài giờ"}]
[{"$f":"IF('Ngan sach'!$C$16=0,\" \",'Ngan sach'!$C$16)","v":"Mạng internet"},200,null,{"$f":"IF('Ngan sach'!$C$43=0,\" \",'Ngan sach'!$C$43)","v":"Vay nợ cá nhân"},null,null,{"$f":"IF('Ngan sach'!$C$35=0,\" \",'Ngan sach'!$C$35)","v":"Du lịch"},null,null,{"$f":"IF('Ngan sach'!$C$51=0,\" \",'Ngan sach'!$C$51)","v":"Đầu tư"},null,null,{"$f":"IF('Ngan sach'!$C$8=0,\" \",'Ngan sach'!$C$8)","v":"Lãi"}]
[{"$f":"IF('Ngan sach'!$C$17=0,\" \",'Ngan sach'!$C$17)","v":"Tiền học cho con"},1655,null,{"$f":"IF('Ngan sach'!$C$44=0,\" \",'Ngan sach'!$C$44)","v":"Thẻ tín dụng"},null,null,{"$f":"IF('Ngan sach'!$C$36=0,\" \",'Ngan sach'!$C$36)","v":"Khác"},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
[{"$f":"IF('Ngan sach'!$C$18=0,\" \",'Ngan sach'!$C$18)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$45=0,\" \",'Ngan sach'!$C$45)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$37=0,\" \",'Ngan sach'!$C$37)","v":" "},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
["Tổng thực tế",{"$f":"SUM(B47:B51)","v":4555},null,"Tổng thực tế",{"$f":"SUM(E47:E51)","v":0},null,"Tổng thực tế",{"$f":"SUM(H47:H51)","v":0},null,"Tổng thực tế",{"$f":"SUM(K47:K51)","v":24000},null,"Tổng thực tế",{"$f":"SUM(N47:N50)","v":31500}]
["Ngân sách",{"$f":"+'Ngan sach'!G19","v":4975},null,"Ngân sách",{"$f":"+'Ngan sach'!G46","v":0},null,"Ngân sách",{"$f":"+'Ngan sach'!G38","v":1700},null,"Ngân sách",{"$f":"+'Ngan sach'!G53","v":7625},null,"Ngân sách",{"$f":"+'Ngan sach'!G11","v":32500}]
["Chênh lệch",{"$f":"B53-B52","v":420},null,"Chênh lệch",{"$f":"E53-E52","v":0},null,"Chênh lệch",{"$f":"H53-H52","v":1700},null,"Chênh lệch",{"$f":"K53-K52","v":-16375},null,"Chênh lệch",{"$f":"N53-N52","v":1000}]

{"sheet":"T5","index":7,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[43,13,43,15],[38,13,38,15],[39,13,39,15],[40,13,40,15],[41,13,41,15],[42,13,42,15],[33,13,33,15],[34,13,34,15],[35,13,35,15],[36,13,36,15],[37,13,37,15],[28,13,28,15],[29,13,29,15],[30,13,30,15],[31,13,31,15],[32,13,32,15],[23,13,23,15],[24,13,24,15],[25,13,25,15],[26,13,26,15],[27,13,27,15],[4,9,6,12],[45,11,47,11],[9,13,9,15],[10,13,10,15],[11,13,11,15],[12,13,12,15],[13,13,13,15],[14,13,14,15],[15,13,15,15],[16,13,16,15],[17,13,17,15],[18,13,18,15],[19,13,19,15],[20,13,20,15],[21,13,21,15],[22,13,22,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu nhập",{"$f":"+N52","v":16725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chi tiêu",{"$f":"+B52+E52+H52+K52+L42","v":16555}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chênh lệch",{"$f":"+R1-R2","v":170}]
[null,"Thu nhập","Chi T.xuyên","Chi cố định","Chi B.Thường","Trả nợ","T.kiệm & ĐT","Còn lại",null,{"$f":"+IF(L44+H54>=0,\"\",\"CẢNH BÁO: CHI THƯỜNG XUYÊN + CHI BẤT THƯỜNG VƯỢT NGÂN SÁCH\")","v":""}]
["Ngân sách",{"$f":"+N53","v":17500},{"$f":"+L43","v":3400},{"$f":"+B53","v":4975},{"$f":"+H53","v":1700},{"$f":"+E53","v":0},{"$f":"+K53","v":7425},{"$f":"+B6-SUM(C6:G6)","v":0}]
["Thực tế",{"$f":"+N52","v":16725},{"$f":"+L42","v":3500},{"$f":"+B52","v":4555},{"$f":"+H52","v":0},{"$f":"+E52","v":0},{"$f":"+K52","v":8500},{"$f":"+B7-SUM(C7:G7)","v":170}]
["Chênh lêch",{"$f":"+B6-B7","v":775},{"$f":"+C6-C7","v":-100},420,1700,0,-1075,null,null,null,null,null,null,null,null,"ĐVT: Nghìn đồng"]
[]
["Tháng 05",{"$f":"IF('Ngan sach'!C22=0, \"\", 'Ngan sach'!C22)","v":"Thức ăn"},{"$f":"IF('Ngan sach'!C23=0, \"\", 'Ngan sach'!C23)","v":"Điện"},{"$f":"IF('Ngan sach'!C24=0, \"\", 'Ngan sach'!C24)","v":""},{"$f":"IF('Ngan sach'!C25=0, \"\", 'Ngan sach'!C25)","v":""},{"$f":"IF('Ngan sach'!C26=0, \"\", 'Ngan sach'!C26)","v":""},{"$f":"IF('Ngan sach'!C27=0, \"\", 'Ngan sach'!C27)","v":""},{"$f":"IF('Ngan sach'!C28=0, \"\", 'Ngan sach'!C28)","v":""},{"$f":"IF('Ngan sach'!C29=0, \"\", 'Ngan sach'!C29)","v":""},null,null,"Tổng chi","Còn lại","Ghi chú"]
[1,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B11:K11)=0,\"\",SUM(B11:K11))","v":100},{"$f":"L43-SUM(B11:K11)","v":3300}]
[2,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B12:K12)=0,\" \",SUM(B12:K12))","v":100},{"$f":"M11-SUM(B12:K12)","v":3200}]
[3,100,null,null,null,null,null,null,null,null,null,100,{"$f":"M12-SUM(B13:K13)","v":3100}]
[4,100,400,null,null,null,null,null,null,null,null,500,2600]
[5,100,null,null,null,null,null,null,null,null,null,100,2500]
[6,100,null,null,null,null,null,null,null,null,null,100,2400]
[7,100,null,null,null,null,null,null,null,null,null,100,2300]
[8,100,null,null,null,null,null,null,null,null,null,100,2200]
[9,100,null,null,null,null,null,null,null,null,null,100,2100]
[10,100,null,null,null,null,null,null,null,null,null,100,2000]
[11,100,null,null,null,null,null,null,null,null,null,100,1900]
[12,100,null,null,null,null,null,null,null,null,null,100,1800]
[13,100,null,null,null,null,null,null,null,null,null,100,1700]
[14,100,null,null,null,null,null,null,null,null,null,100,1600]
[15,100,null,null,null,null,null,null,null,null,null,100,1500]
[16,100,null,null,null,null,null,null,null,null,null,100,1400]
[17,100,null,null,null,null,null,null,null,null,null,100,1300]
[18,100,null,null,null,null,null,null,null,null,null,100,1200]
[19,100,null,null,null,null,null,null,null,null,null,100,1100]
[20,100,null,null,null,null,null,null,null,null,null,100,1000]
[21,100,null,null,null,null,null,null,null,null,null,100,900]
[22,100,null,null,null,null,null,null,null,null,null,100,800]
[23,100,null,null,null,null,null,null,null,null,null,100,700]
[24,100,null,null,null,null,null,null,null,null,null,100,600]
[25,100,null,null,null,null,null,null,null,null,null,100,500]
[26,100,null,null,null,null,null,null,null,null,null,100,400]
[27,100,null,null,null,null,null,null,null,null,null,100,300]
[28,100,null,null,null,null,null,null,null,null,null,100,200]
[29,100,null,null,null,null,null,null,null,null,null,100,100]
[30,100,null,null,null,null,null,null,null,null,null,100,0]
[31,100,null,null,null,null,null,null,null,null,null,100,-100]
["Đã chi",{"$f":"IF(SUM(B11:B41)=0,\"\",SUM(B11:B41))","v":3100},{"$f":"IF(SUM(C11:C41)=0,\"\",SUM(C11:C41))","v":400},{"$f":"IF(SUM(D11:D41)=0,\"\",SUM(D11:D41))","v":""},"","","","","","","",{"$f":"IF(SUM(L11:L41)=0,0,SUM(L11:L41))","v":3500}]
["Ngân sách",{"$f":"'Ngan sach'!H22","v":3000},{"$f":"'Ngan sach'!H23","v":400},{"$f":"'Ngan sach'!H24","v":0},{"$f":"'Ngan sach'!H25","v":0},{"$f":"'Ngan sach'!H26","v":0},{"$f":"'Ngan sach'!H27","v":0},{"$f":"'Ngan sach'!H28","v":0},{"$f":"'Ngan sach'!H29","v":0},null,null,{"$f":"SUM(B43:K43)","v":3400}]
["Còn lại",{"$f":"B43-SUM(B11:B41)","v":-100},{"$f":"C43-SUM(C11:C41)","v":0},0,0,0,0,0,0,0,0,-100]
[]
["Cố định",null,null,"Trả nợ",null,null,"Bất thường",null,null,"Tiết kiệm & đầu tư",null,null,"Thu nhập thực tế"]
[{"$f":"IF('Ngan sach'!$C$14=0,\" \",'Ngan sach'!$C$14)","v":"Thuê nhà"},2500,null,{"$f":"IF('Ngan sach'!$C$41=0,\" \",'Ngan sach'!$C$41)","v":"Vay Mua nhà"},null,null,{"$f":"IF('Ngan sach'!$C$33=0,\" \",'Ngan sach'!$C$33)","v":"Đi lại + về quê"},null,null,{"$f":"IF('Ngan sach'!$C$49=0,\" \",'Ngan sach'!$C$49)","v":"TK Ngân hàng"},8500,null,{"$f":"IF('Ngan sach'!$C$6=0,\" \",'Ngan sach'!$C$6)","v":"Lương & Thưởng"},16725]
[{"$f":"IF('Ngan sach'!$C$15=0,\" \",'Ngan sach'!$C$15)","v":"Điện thoại"},200,null,{"$f":"IF('Ngan sach'!$C$42=0,\" \",'Ngan sach'!$C$42)","v":"Mua xe"},null,null,{"$f":"IF('Ngan sach'!$C$34=0,\" \",'Ngan sach'!$C$34)","v":"Khám bệnh"},null,null,{"$f":"IF('Ngan sach'!$C$50=0,\" \",'Ngan sach'!$C$50)","v":"Bảo hiểm"},null,null,{"$f":"IF('Ngan sach'!$C$7=0,\" \",'Ngan sach'!$C$7)","v":"Ngoài giờ"}]
[{"$f":"IF('Ngan sach'!$C$16=0,\" \",'Ngan sach'!$C$16)","v":"Mạng internet"},200,null,{"$f":"IF('Ngan sach'!$C$43=0,\" \",'Ngan sach'!$C$43)","v":"Vay nợ cá nhân"},null,null,{"$f":"IF('Ngan sach'!$C$35=0,\" \",'Ngan sach'!$C$35)","v":"Du lịch"},null,null,{"$f":"IF('Ngan sach'!$C$51=0,\" \",'Ngan sach'!$C$51)","v":"Đầu tư"},null,null,{"$f":"IF('Ngan sach'!$C$8=0,\" \",'Ngan sach'!$C$8)","v":"Lãi"}]
[{"$f":"IF('Ngan sach'!$C$17=0,\" \",'Ngan sach'!$C$17)","v":"Tiền học cho con"},1655,null,{"$f":"IF('Ngan sach'!$C$44=0,\" \",'Ngan sach'!$C$44)","v":"Thẻ tín dụng"},null,null,{"$f":"IF('Ngan sach'!$C$36=0,\" \",'Ngan sach'!$C$36)","v":"Khác"},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
[{"$f":"IF('Ngan sach'!$C$18=0,\" \",'Ngan sach'!$C$18)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$45=0,\" \",'Ngan sach'!$C$45)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$37=0,\" \",'Ngan sach'!$C$37)","v":" "},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
["Tổng thực tế",{"$f":"SUM(B47:B51)","v":4555},null,"Tổng thực tế",{"$f":"SUM(E47:E51)","v":0},null,"Tổng thực tế",{"$f":"SUM(H47:H51)","v":0},null,"Tổng thực tế",{"$f":"SUM(K47:K51)","v":8500},null,"Tổng thực tế",{"$f":"SUM(N47:N50)","v":16725}]
["Ngân sách",{"$f":"+'Ngan sach'!H19","v":4975},null,"Ngân sách",{"$f":"+'Ngan sach'!H46","v":0},null,"Ngân sách",{"$f":"+'Ngan sach'!H38","v":1700},null,"Ngân sách",{"$f":"+'Ngan sach'!H53","v":7425},null,"Ngân sách",{"$f":"+'Ngan sach'!H11","v":17500}]
["Chênh lệch",{"$f":"B53-B52","v":420},null,"Chênh lệch",{"$f":"E53-E52","v":0},null,"Chênh lệch",{"$f":"H53-H52","v":1700},null,"Chênh lệch",{"$f":"K53-K52","v":-1075},null,"Chênh lệch",{"$f":"N53-N52","v":775}]

{"sheet":"T6","index":8,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[43,13,43,15],[38,13,38,15],[39,13,39,15],[40,13,40,15],[41,13,41,15],[42,13,42,15],[33,13,33,15],[34,13,34,15],[35,13,35,15],[36,13,36,15],[37,13,37,15],[28,13,28,15],[29,13,29,15],[30,13,30,15],[31,13,31,15],[32,13,32,15],[23,13,23,15],[24,13,24,15],[25,13,25,15],[26,13,26,15],[27,13,27,15],[4,9,6,12],[45,11,47,11],[9,13,9,15],[10,13,10,15],[11,13,11,15],[12,13,12,15],[13,13,13,15],[14,13,14,15],[15,13,15,15],[16,13,16,15],[17,13,17,15],[18,13,18,15],[19,13,19,15],[20,13,20,15],[21,13,21,15],[22,13,22,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu nhập",{"$f":"+N52","v":16725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chi tiêu",{"$f":"+B52+E52+H52+K52+L42","v":16455}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chênh lệch",{"$f":"+R1-R2","v":270}]
[null,"Thu nhập","Chi T.xuyên","Chi cố định","Chi B.Thường","Trả nợ","T.kiệm & ĐT","Còn lại",null,{"$f":"+IF(L44+H54>=0,\"\",\"CẢNH BÁO: CHI THƯỜNG XUYÊN + CHI BẤT THƯỜNG VƯỢT NGÂN SÁCH\")","v":""}]
["Ngân sách",{"$f":"+N53","v":17500},{"$f":"+L43","v":3400},{"$f":"+B53","v":4975},{"$f":"+H53","v":1500},{"$f":"+E53","v":5000},{"$f":"+K53","v":2625},{"$f":"+B6-SUM(C6:G6)","v":0}]
["Thực tế",{"$f":"+N52","v":16725},{"$f":"+L42","v":3400},{"$f":"+B52","v":4555},{"$f":"+H52","v":0},{"$f":"+E52","v":7500},{"$f":"+K52","v":1000},{"$f":"+B7-SUM(C7:G7)","v":270}]
["Chênh lêch",{"$f":"+B6-B7","v":775},{"$f":"+C6-C7","v":0},420,1500,-2500,1625,null,null,null,null,null,null,null,null,"ĐVT: Nghìn đồng"]
[]
["Tháng 06",{"$f":"IF('Ngan sach'!C22=0, \"\", 'Ngan sach'!C22)","v":"Thức ăn"},{"$f":"IF('Ngan sach'!C23=0, \"\", 'Ngan sach'!C23)","v":"Điện"},{"$f":"IF('Ngan sach'!C24=0, \"\", 'Ngan sach'!C24)","v":""},{"$f":"IF('Ngan sach'!C25=0, \"\", 'Ngan sach'!C25)","v":""},{"$f":"IF('Ngan sach'!C26=0, \"\", 'Ngan sach'!C26)","v":""},{"$f":"IF('Ngan sach'!C27=0, \"\", 'Ngan sach'!C27)","v":""},{"$f":"IF('Ngan sach'!C28=0, \"\", 'Ngan sach'!C28)","v":""},{"$f":"IF('Ngan sach'!C29=0, \"\", 'Ngan sach'!C29)","v":""},null,null,"Tổng chi","Còn lại","Ghi chú"]
[1,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B11:K11)=0,\"\",SUM(B11:K11))","v":100},{"$f":"L43-SUM(B11:K11)","v":3300}]
[2,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B12:K12)=0,\" \",SUM(B12:K12))","v":100},{"$f":"M11-SUM(B12:K12)","v":3200}]
[3,100,null,null,null,null,null,null,null,null,null,100,{"$f":"M12-SUM(B13:K13)","v":3100}]
[4,100,400,null,null,null,null,null,null,null,null,500,2600]
[5,100,null,null,null,null,null,null,null,null,null,100,2500]
[6,100,null,null,null,null,null,null,null,null,null,100,2400]
[7,100,null,null,null,null,null,null,null,null,null,100,2300]
[8,100,null,null,null,null,null,null,null,null,null,100,2200]
[9,100,null,null,null,null,null,null,null,null,null,100,2100]
[10,100,null,null,null,null,null,null,null,null,null,100,2000]
[11,100,null,null,null,null,null,null,null,null,null,100,1900]
[12,100,null,null,null,null,null,null,null,null,null,100,1800]
[13,100,null,null,null,null,null,null,null,null,null,100,1700]
[14,100,null,null,null,null,null,null,null,null,null,100,1600]
[15,100,null,null,null,null,null,null,null,null,null,100,1500]
[16,100,null,null,null,null,null,null,null,null,null,100,1400]
[17,100,null,null,null,null,null,null,null,null,null,100,1300]
[18,100,null,null,null,null,null,null,null,null,null,100,1200]
[19,100,null,null,null,null,null,null,null,null,null,100,1100]
[20,100,null,null,null,null,null,null,null,null,null,100,1000]
[21,100,null,null,null,null,null,null,null,null,null,100,900]
[22,100,null,null,null,null,null,null,null,null,null,100,800]
[23,100,null,null,null,null,null,null,null,null,null,100,700]
[24,100,null,null,null,null,null,null,null,null,null,100,600]
[25,100,null,null,null,null,null,null,null,null,null,100,500]
[26,100,null,null,null,null,null,null,null,null,null,100,400]
[27,100,null,null,null,null,null,null,null,null,null,100,300]
[28,100,null,null,null,null,null,null,null,null,null,100,200]
[29,100,null,null,null,null,null,null,null,null,null,100,100]
[30,100,null,null,null,null,null,null,null,null,null,100,0]
[null,null,null,null,null,null,null,null,null,null,null," ",0]
["Đã chi",{"$f":"IF(SUM(B11:B41)=0,\"\",SUM(B11:B41))","v":3000},{"$f":"IF(SUM(C11:C41)=0,\"\",SUM(C11:C41))","v":400},{"$f":"IF(SUM(D11:D41)=0,\"\",SUM(D11:D41))","v":""},"","","","","","","",{"$f":"IF(SUM(L11:L41)=0,0,SUM(L11:L41))","v":3400}]
["Ngân sách",{"$f":"'Ngan sach'!I22","v":3000},{"$f":"'Ngan sach'!I23","v":400},{"$f":"'Ngan sach'!I24","v":0},{"$f":"'Ngan sach'!I25","v":0},{"$f":"'Ngan sach'!I26","v":0},{"$f":"'Ngan sach'!I27","v":0},{"$f":"'Ngan sach'!I28","v":0},{"$f":"'Ngan sach'!I29","v":0},null,null,{"$f":"SUM(B43:K43)","v":3400}]
["Còn lại",{"$f":"B43-SUM(B11:B41)","v":0},{"$f":"C43-SUM(C11:C41)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Cố định",null,null,"Trả nợ",null,null,"Bất thường",null,null,"Tiết kiệm & đầu tư",null,null,"Thu nhập thực tế"]
[{"$f":"IF('Ngan sach'!$C$14=0,\" \",'Ngan sach'!$C$14)","v":"Thuê nhà"},2500,null,{"$f":"IF('Ngan sach'!$C$41=0,\" \",'Ngan sach'!$C$41)","v":"Vay Mua nhà"},5500,null,{"$f":"IF('Ngan sach'!$C$33=0,\" \",'Ngan sach'!$C$33)","v":"Đi lại + về quê"},null,null,{"$f":"IF('Ngan sach'!$C$49=0,\" \",'Ngan sach'!$C$49)","v":"TK Ngân hàng"},1000,null,{"$f":"IF('Ngan sach'!$C$6=0,\" \",'Ngan sach'!$C$6)","v":"Lương & Thưởng"},16725]
[{"$f":"IF('Ngan sach'!$C$15=0,\" \",'Ngan sach'!$C$15)","v":"Điện thoại"},200,null,{"$f":"IF('Ngan sach'!$C$42=0,\" \",'Ngan sach'!$C$42)","v":"Mua xe"},null,null,{"$f":"IF('Ngan sach'!$C$34=0,\" \",'Ngan sach'!$C$34)","v":"Khám bệnh"},null,null,{"$f":"IF('Ngan sach'!$C$50=0,\" \",'Ngan sach'!$C$50)","v":"Bảo hiểm"},null,null,{"$f":"IF('Ngan sach'!$C$7=0,\" \",'Ngan sach'!$C$7)","v":"Ngoài giờ"}]
[{"$f":"IF('Ngan sach'!$C$16=0,\" \",'Ngan sach'!$C$16)","v":"Mạng internet"},200,null,{"$f":"IF('Ngan sach'!$C$43=0,\" \",'Ngan sach'!$C$43)","v":"Vay nợ cá nhân"},2000,null,{"$f":"IF('Ngan sach'!$C$35=0,\" \",'Ngan sach'!$C$35)","v":"Du lịch"},null,null,{"$f":"IF('Ngan sach'!$C$51=0,\" \",'Ngan sach'!$C$51)","v":"Đầu tư"},null,null,{"$f":"IF('Ngan sach'!$C$8=0,\" \",'Ngan sach'!$C$8)","v":"Lãi"}]
[{"$f":"IF('Ngan sach'!$C$17=0,\" \",'Ngan sach'!$C$17)","v":"Tiền học cho con"},1655,null,{"$f":"IF('Ngan sach'!$C$44=0,\" \",'Ngan sach'!$C$44)","v":"Thẻ tín dụng"},null,null,{"$f":"IF('Ngan sach'!$C$36=0,\" \",'Ngan sach'!$C$36)","v":"Khác"},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
[{"$f":"IF('Ngan sach'!$C$18=0,\" \",'Ngan sach'!$C$18)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$45=0,\" \",'Ngan sach'!$C$45)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$37=0,\" \",'Ngan sach'!$C$37)","v":" "},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
["Tổng thực tế",{"$f":"SUM(B47:B51)","v":4555},null,"Tổng thực tế",{"$f":"SUM(E47:E51)","v":7500},null,"Tổng thực tế",{"$f":"SUM(H47:H51)","v":0},null,"Tổng thực tế",{"$f":"SUM(K47:K51)","v":1000},null,"Tổng thực tế",{"$f":"SUM(N47:N50)","v":16725}]
["Ngân sách",{"$f":"+'Ngan sach'!I19","v":4975},null,"Ngân sách",{"$f":"+'Ngan sach'!I46","v":5000},null,"Ngân sách",{"$f":"+'Ngan sach'!I38","v":1500},null,"Ngân sách",{"$f":"+'Ngan sach'!I53","v":2625},null,"Ngân sách",{"$f":"+'Ngan sach'!I11","v":17500}]
["Chênh lệch",{"$f":"B53-B52","v":420},null,"Chênh lệch",{"$f":"E53-E52","v":-2500},null,"Chênh lệch",{"$f":"H53-H52","v":1500},null,"Chênh lệch",{"$f":"K53-K52","v":1625},null,"Chênh lệch",{"$f":"N53-N52","v":775}]

{"sheet":"T7","index":9,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[43,13,43,15],[38,13,38,15],[39,13,39,15],[40,13,40,15],[41,13,41,15],[42,13,42,15],[33,13,33,15],[34,13,34,15],[35,13,35,15],[36,13,36,15],[37,13,37,15],[28,13,28,15],[29,13,29,15],[30,13,30,15],[31,13,31,15],[32,13,32,15],[23,13,23,15],[24,13,24,15],[25,13,25,15],[26,13,26,15],[27,13,27,15],[4,9,6,12],[45,11,47,11],[9,13,9,15],[10,13,10,15],[11,13,11,15],[12,13,12,15],[13,13,13,15],[14,13,14,15],[15,13,15,15],[16,13,16,15],[17,13,17,15],[18,13,18,15],[19,13,19,15],[20,13,20,15],[21,13,21,15],[22,13,22,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu nhập",{"$f":"+N52","v":22000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chi tiêu",{"$f":"+B52+E52+H52+K52+L42","v":22005}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chênh lệch",{"$f":"+R1-R2","v":-5}]
[null,"Thu nhập","Chi T.xuyên","Chi cố định","Chi B.Thường","Trả nợ","T.kiệm & ĐT","Còn lại",null,{"$f":"+IF(L44+H54>=0,\"\",\"CẢNH BÁO: CHI THƯỜNG XUYÊN + CHI BẤT THƯỜNG VƯỢT NGÂN SÁCH\")","v":""}]
["Ngân sách",{"$f":"+N53","v":21500},{"$f":"+L43","v":3400},{"$f":"+B53","v":4975},{"$f":"+H53","v":1500},{"$f":"+E53","v":5000},{"$f":"+K53","v":2625},{"$f":"+B6-SUM(C6:G6)","v":4000}]
["Thực tế",{"$f":"+N52","v":22000},{"$f":"+L42","v":3500},{"$f":"+B52","v":4555},{"$f":"+H52","v":1000},{"$f":"+E52","v":7450},{"$f":"+K52","v":5500},{"$f":"+B7-SUM(C7:G7)","v":-5}]
["Chênh lêch",{"$f":"+B6-B7","v":-500},{"$f":"+C6-C7","v":-100},420,500,-2450,-2875,null,null,null,null,null,null,null,null,"ĐVT: Nghìn đồng"]
[]
["Tháng 07",{"$f":"IF('Ngan sach'!C22=0, \"\", 'Ngan sach'!C22)","v":"Thức ăn"},{"$f":"IF('Ngan sach'!C23=0, \"\", 'Ngan sach'!C23)","v":"Điện"},{"$f":"IF('Ngan sach'!C24=0, \"\", 'Ngan sach'!C24)","v":""},{"$f":"IF('Ngan sach'!C25=0, \"\", 'Ngan sach'!C25)","v":""},{"$f":"IF('Ngan sach'!C26=0, \"\", 'Ngan sach'!C26)","v":""},{"$f":"IF('Ngan sach'!C27=0, \"\", 'Ngan sach'!C27)","v":""},{"$f":"IF('Ngan sach'!C28=0, \"\", 'Ngan sach'!C28)","v":""},{"$f":"IF('Ngan sach'!C29=0, \"\", 'Ngan sach'!C29)","v":""},null,null,"Tổng chi","Còn lại","Ghi chú"]
[1,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B11:K11)=0,\"\",SUM(B11:K11))","v":100},{"$f":"L43-SUM(B11:K11)","v":3300}]
[2,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B12:K12)=0,\" \",SUM(B12:K12))","v":100},{"$f":"M11-SUM(B12:K12)","v":3200}]
[3,100,null,null,null,null,null,null,null,null,null,100,{"$f":"M12-SUM(B13:K13)","v":3100}]
[4,100,400,null,null,null,null,null,null,null,null,500,2600]
[5,100,null,null,null,null,null,null,null,null,null,100,2500]
[6,100,null,null,null,null,null,null,null,null,null,100,2400]
[7,100,null,null,null,null,null,null,null,null,null,100,2300]
[8,100,null,null,null,null,null,null,null,null,null,100,2200]
[9,100,null,null,null,null,null,null,null,null,null,100,2100]
[10,100,null,null,null,null,null,null,null,null,null,100,2000]
[11,100,null,null,null,null,null,null,null,null,null,100,1900]
[12,100,null,null,null,null,null,null,null,null,null,100,1800]
[13,100,null,null,null,null,null,null,null,null,null,100,1700]
[14,100,null,null,null,null,null,null,null,null,null,100,1600]
[15,100,null,null,null,null,null,null,null,null,null,100,1500]
[16,100,null,null,null,null,null,null,null,null,null,100,1400]
[17,100,null,null,null,null,null,null,null,null,null,100,1300]
[18,100,null,null,null,null,null,null,null,null,null,100,1200]
[19,100,null,null,null,null,null,null,null,null,null,100,1100]
[20,100,null,null,null,null,null,null,null,null,null,100,1000]
[21,100,null,null,null,null,null,null,null,null,null,100,900]
[22,100,null,null,null,null,null,null,null,null,null,100,800]
[23,100,null,null,null,null,null,null,null,null,null,100,700]
[24,100,null,null,null,null,null,null,null,null,null,100,600]
[25,100,null,null,null,null,null,null,null,null,null,100,500]
[26,100,null,null,null,null,null,null,null,null,null,100,400]
[27,100,null,null,null,null,null,null,null,null,null,100,300]
[28,100,null,null,null,null,null,null,null,null,null,100,200]
[29,100,null,null,null,null,null,null,null,null,null,100,100]
[30,100,null,null,null,null,null,null,null,null,null,100,0]
[31,100,null,null,null,null,null,null,null,null,null,100,-100]
["Đã chi",{"$f":"IF(SUM(B11:B41)=0,\"\",SUM(B11:B41))","v":3100},{"$f":"IF(SUM(C11:C41)=0,\"\",SUM(C11:C41))","v":400},{"$f":"IF(SUM(D11:D41)=0,\"\",SUM(D11:D41))","v":""},"","","","","","","",{"$f":"IF(SUM(L11:L41)=0,0,SUM(L11:L41))","v":3500}]
["Ngân sách",{"$f":"'Ngan sach'!J22","v":3000},{"$f":"'Ngan sach'!J23","v":400},{"$f":"'Ngan sach'!J24","v":0},{"$f":"'Ngan sach'!J25","v":0},{"$f":"'Ngan sach'!J26","v":0},{"$f":"'Ngan sach'!J27","v":0},{"$f":"'Ngan sach'!J28","v":0},{"$f":"'Ngan sach'!J29","v":0},null,null,{"$f":"SUM(B43:K43)","v":3400}]
["Còn lại",{"$f":"B43-SUM(B11:B41)","v":-100},{"$f":"C43-SUM(C11:C41)","v":0},0,0,0,0,0,0,0,0,-100]
[]
["Cố định",null,null,"Trả nợ",null,null,"Bất thường",null,null,"Tiết kiệm & đầu tư",null,null,"Thu nhập thực tế"]
[{"$f":"IF('Ngan sach'!$C$14=0,\" \",'Ngan sach'!$C$14)","v":"Thuê nhà"},2500,null,{"$f":"IF('Ngan sach'!$C$41=0,\" \",'Ngan sach'!$C$41)","v":"Vay Mua nhà"},5450,null,{"$f":"IF('Ngan sach'!$C$33=0,\" \",'Ngan sach'!$C$33)","v":"Đi lại + về quê"},null,null,{"$f":"IF('Ngan sach'!$C$49=0,\" \",'Ngan sach'!$C$49)","v":"TK Ngân hàng"},5500,null,{"$f":"IF('Ngan sach'!$C$6=0,\" \",'Ngan sach'!$C$6)","v":"Lương & Thưởng"},15000]
[{"$f":"IF('Ngan sach'!$C$15=0,\" \",'Ngan sach'!$C$15)","v":"Điện thoại"},200,null,{"$f":"IF('Ngan sach'!$C$42=0,\" \",'Ngan sach'!$C$42)","v":"Mua xe"},null,null,{"$f":"IF('Ngan sach'!$C$34=0,\" \",'Ngan sach'!$C$34)","v":"Khám bệnh"},1000,null,{"$f":"IF('Ngan sach'!$C$50=0,\" \",'Ngan sach'!$C$50)","v":"Bảo hiểm"},null,null,{"$f":"IF('Ngan sach'!$C$7=0,\" \",'Ngan sach'!$C$7)","v":"Ngoài giờ"},7000]
[{"$f":"IF('Ngan sach'!$C$16=0,\" \",'Ngan sach'!$C$16)","v":"Mạng internet"},200,null,{"$f":"IF('Ngan sach'!$C$43=0,\" \",'Ngan sach'!$C$43)","v":"Vay nợ cá nhân"},2000,null,{"$f":"IF('Ngan sach'!$C$35=0,\" \",'Ngan sach'!$C$35)","v":"Du lịch"},null,null,{"$f":"IF('Ngan sach'!$C$51=0,\" \",'Ngan sach'!$C$51)","v":"Đầu tư"},null,null,{"$f":"IF('Ngan sach'!$C$8=0,\" \",'Ngan sach'!$C$8)","v":"Lãi"}]
[{"$f":"IF('Ngan sach'!$C$17=0,\" \",'Ngan sach'!$C$17)","v":"Tiền học cho con"},1655,null,{"$f":"IF('Ngan sach'!$C$44=0,\" \",'Ngan sach'!$C$44)","v":"Thẻ tín dụng"},null,null,{"$f":"IF('Ngan sach'!$C$36=0,\" \",'Ngan sach'!$C$36)","v":"Khác"},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
[{"$f":"IF('Ngan sach'!$C$18=0,\" \",'Ngan sach'!$C$18)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$45=0,\" \",'Ngan sach'!$C$45)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$37=0,\" \",'Ngan sach'!$C$37)","v":" "},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
["Tổng thực tế",{"$f":"SUM(B47:B51)","v":4555},null,"Tổng thực tế",{"$f":"SUM(E47:E51)","v":7450},null,"Tổng thực tế",{"$f":"SUM(H47:H51)","v":1000},null,"Tổng thực tế",{"$f":"SUM(K47:K51)","v":5500},null,"Tổng thực tế",{"$f":"SUM(N47:N50)","v":22000}]
["Ngân sách",{"$f":"+'Ngan sach'!J19","v":4975},null,"Ngân sách",{"$f":"+'Ngan sach'!J46","v":5000},null,"Ngân sách",{"$f":"+'Ngan sach'!J38","v":1500},null,"Ngân sách",{"$f":"+'Ngan sach'!J53","v":2625},null,"Ngân sách",{"$f":"+'Ngan sach'!J11","v":21500}]
["Chênh lệch",{"$f":"B53-B52","v":420},null,"Chênh lệch",{"$f":"E53-E52","v":-2450},null,"Chênh lệch",{"$f":"H53-H52","v":500},null,"Chênh lệch",{"$f":"K53-K52","v":-2875},null,"Chênh lệch",{"$f":"N53-N52","v":-500}]

{"sheet":"T8","index":10,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[43,13,43,15],[38,13,38,15],[39,13,39,15],[40,13,40,15],[41,13,41,15],[42,13,42,15],[33,13,33,15],[34,13,34,15],[35,13,35,15],[36,13,36,15],[37,13,37,15],[28,13,28,15],[29,13,29,15],[30,13,30,15],[31,13,31,15],[32,13,32,15],[23,13,23,15],[24,13,24,15],[25,13,25,15],[26,13,26,15],[27,13,27,15],[4,9,6,12],[45,11,47,11],[9,13,9,15],[10,13,10,15],[11,13,11,15],[12,13,12,15],[13,13,13,15],[14,13,14,15],[15,13,15,15],[16,13,16,15],[17,13,17,15],[18,13,18,15],[19,13,19,15],[20,13,20,15],[21,13,21,15],[22,13,22,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu nhập",{"$f":"+N52","v":21000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chi tiêu",{"$f":"+B52+E52+H52+K52+L42","v":20955}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chênh lệch",{"$f":"+R1-R2","v":45}]
[null,"Thu nhập","Chi T.xuyên","Chi cố định","Chi B.Thường","Trả nợ","T.kiệm & ĐT","Còn lại",null,{"$f":"+IF(L44+H54>=0,\"\",\"CẢNH BÁO: CHI THƯỜNG XUYÊN + CHI BẤT THƯỜNG VƯỢT NGÂN SÁCH\")","v":"CẢNH BÁO: CHI THƯỜNG XUYÊN + CHI BẤT THƯỜNG VƯỢT NGÂN SÁCH"}]
["Ngân sách",{"$f":"+N53","v":17500},{"$f":"+L43","v":3400},{"$f":"+B53","v":4975},{"$f":"+H53","v":1500},{"$f":"+E53","v":5000},{"$f":"+K53","v":2625},{"$f":"+B6-SUM(C6:G6)","v":0}]
["Thực tế",{"$f":"+N52","v":21000},{"$f":"+L42","v":3500},{"$f":"+B52","v":4555},{"$f":"+H52","v":1500},{"$f":"+E52","v":7400},{"$f":"+K52","v":4000},{"$f":"+B7-SUM(C7:G7)","v":45}]
["Chênh lêch",{"$f":"+B6-B7","v":-3500},{"$f":"+C6-C7","v":-100},420,0,-2400,-1375,null,null,null,null,null,null,null,null,"ĐVT: Nghìn đồng"]
[]
["Tháng 08",{"$f":"IF('Ngan sach'!C22=0, \"\", 'Ngan sach'!C22)","v":"Thức ăn"},{"$f":"IF('Ngan sach'!C23=0, \"\", 'Ngan sach'!C23)","v":"Điện"},{"$f":"IF('Ngan sach'!C24=0, \"\", 'Ngan sach'!C24)","v":""},{"$f":"IF('Ngan sach'!C25=0, \"\", 'Ngan sach'!C25)","v":""},{"$f":"IF('Ngan sach'!C26=0, \"\", 'Ngan sach'!C26)","v":""},{"$f":"IF('Ngan sach'!C27=0, \"\", 'Ngan sach'!C27)","v":""},{"$f":"IF('Ngan sach'!C28=0, \"\", 'Ngan sach'!C28)","v":""},{"$f":"IF('Ngan sach'!C29=0, \"\", 'Ngan sach'!C29)","v":""},null,null,"Tổng chi","Còn lại","Ghi chú"]
[1,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B11:K11)=0,\"\",SUM(B11:K11))","v":100},{"$f":"L43-SUM(B11:K11)","v":3300}]
[2,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B12:K12)=0,\" \",SUM(B12:K12))","v":100},{"$f":"M11-SUM(B12:K12)","v":3200}]
[3,100,null,null,null,null,null,null,null,null,null,100,{"$f":"M12-SUM(B13:K13)","v":3100}]
[4,100,400,null,null,null,null,null,null,null,null,500,2600]
[5,100,null,null,null,null,null,null,null,null,null,100,2500]
[6,100,null,null,null,null,null,null,null,null,null,100,2400]
[7,100,null,null,null,null,null,null,null,null,null,100,2300]
[8,100,null,null,null,null,null,null,null,null,null,100,2200]
[9,100,null,null,null,null,null,null,null,null,null,100,2100]
[10,100,null,null,null,null,null,null,null,null,null,100,2000]
[11,100,null,null,null,null,null,null,null,null,null,100,1900]
[12,100,null,null,null,null,null,null,null,null,null,100,1800]
[13,100,null,null,null,null,null,null,null,null,null,100,1700]
[14,100,null,null,null,null,null,null,null,null,null,100,1600]
[15,100,null,null,null,null,null,null,null,null,null,100,1500]
[16,100,null,null,null,null,null,null,null,null,null,100,1400]
[17,100,null,null,null,null,null,null,null,null,null,100,1300]
[18,100,null,null,null,null,null,null,null,null,null,100,1200]
[19,100,null,null,null,null,null,null,null,null,null,100,1100]
[20,100,null,null,null,null,null,null,null,null,null,100,1000]
[21,100,null,null,null,null,null,null,null,null,null,100,900]
[22,100,null,null,null,null,null,null,null,null,null,100,800]
[23,100,null,null,null,null,null,null,null,null,null,100,700]
[24,100,null,null,null,null,null,null,null,null,null,100,600]
[25,100,null,null,null,null,null,null,null,null,null,100,500]
[26,100,null,null,null,null,null,null,null,null,null,100,400]
[27,100,null,null,null,null,null,null,null,null,null,100,300]
[28,100,null,null,null,null,null,null,null,null,null,100,200]
[29,100,null,null,null,null,null,null,null,null,null,100,100]
[30,100,null,null,null,null,null,null,null,null,null,100,0]
[31,100,null,null,null,null,null,null,null,null,null,100,-100]
["Đã chi",{"$f":"IF(SUM(B11:B41)=0,\"\",SUM(B11:B41))","v":3100},{"$f":"IF(SUM(C11:C41)=0,\"\",SUM(C11:C41))","v":400},{"$f":"IF(SUM(D11:D41)=0,\"\",SUM(D11:D41))","v":""},"","","","","","","",{"$f":"IF(SUM(L11:L41)=0,0,SUM(L11:L41))","v":3500}]
["Ngân sách",{"$f":"'Ngan sach'!K22","v":3000},{"$f":"'Ngan sach'!K23","v":400},{"$f":"'Ngan sach'!K24","v":0},{"$f":"'Ngan sach'!K25","v":0},{"$f":"'Ngan sach'!K26","v":0},{"$f":"'Ngan sach'!K27","v":0},{"$f":"'Ngan sach'!K28","v":0},{"$f":"'Ngan sach'!K29","v":0},null,null,{"$f":"SUM(B43:K43)","v":3400}]
["Còn lại",{"$f":"B43-SUM(B11:B41)","v":-100},{"$f":"C43-SUM(C11:C41)","v":0},0,0,0,0,0,0,0,0,-100]
[]
["Cố định",null,null,"Trả nợ",null,null,"Bất thường",null,null,"Tiết kiệm & đầu tư",null,null,"Thu nhập thực tế"]
[{"$f":"IF('Ngan sach'!$C$14=0,\" \",'Ngan sach'!$C$14)","v":"Thuê nhà"},2500,null,{"$f":"IF('Ngan sach'!$C$41=0,\" \",'Ngan sach'!$C$41)","v":"Vay Mua nhà"},5400,null,{"$f":"IF('Ngan sach'!$C$33=0,\" \",'Ngan sach'!$C$33)","v":"Đi lại + về quê"},1500,null,{"$f":"IF('Ngan sach'!$C$49=0,\" \",'Ngan sach'!$C$49)","v":"TK Ngân hàng"},4000,null,{"$f":"IF('Ngan sach'!$C$6=0,\" \",'Ngan sach'!$C$6)","v":"Lương & Thưởng"},16000]
[{"$f":"IF('Ngan sach'!$C$15=0,\" \",'Ngan sach'!$C$15)","v":"Điện thoại"},200,null,{"$f":"IF('Ngan sach'!$C$42=0,\" \",'Ngan sach'!$C$42)","v":"Mua xe"},null,null,{"$f":"IF('Ngan sach'!$C$34=0,\" \",'Ngan sach'!$C$34)","v":"Khám bệnh"},null,null,{"$f":"IF('Ngan sach'!$C$50=0,\" \",'Ngan sach'!$C$50)","v":"Bảo hiểm"},null,null,{"$f":"IF('Ngan sach'!$C$7=0,\" \",'Ngan sach'!$C$7)","v":"Ngoài giờ"},5000]
[{"$f":"IF('Ngan sach'!$C$16=0,\" \",'Ngan sach'!$C$16)","v":"Mạng internet"},200,null,{"$f":"IF('Ngan sach'!$C$43=0,\" \",'Ngan sach'!$C$43)","v":"Vay nợ cá nhân"},2000,null,{"$f":"IF('Ngan sach'!$C$35=0,\" \",'Ngan sach'!$C$35)","v":"Du lịch"},null,null,{"$f":"IF('Ngan sach'!$C$51=0,\" \",'Ngan sach'!$C$51)","v":"Đầu tư"},null,null,{"$f":"IF('Ngan sach'!$C$8=0,\" \",'Ngan sach'!$C$8)","v":"Lãi"}]
[{"$f":"IF('Ngan sach'!$C$17=0,\" \",'Ngan sach'!$C$17)","v":"Tiền học cho con"},1655,null,{"$f":"IF('Ngan sach'!$C$44=0,\" \",'Ngan sach'!$C$44)","v":"Thẻ tín dụng"},null,null,{"$f":"IF('Ngan sach'!$C$36=0,\" \",'Ngan sach'!$C$36)","v":"Khác"},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
[{"$f":"IF('Ngan sach'!$C$18=0,\" \",'Ngan sach'!$C$18)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$45=0,\" \",'Ngan sach'!$C$45)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$37=0,\" \",'Ngan sach'!$C$37)","v":" "},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
["Tổng thực tế",{"$f":"SUM(B47:B51)","v":4555},null,"Tổng thực tế",{"$f":"SUM(E47:E51)","v":7400},null,"Tổng thực tế",{"$f":"SUM(H47:H51)","v":1500},null,"Tổng thực tế",{"$f":"SUM(K47:K51)","v":4000},null,"Tổng thực tế",{"$f":"SUM(N47:N50)","v":21000}]
["Ngân sách",{"$f":"+'Ngan sach'!K19","v":4975},null,"Ngân sách",{"$f":"+'Ngan sach'!K46","v":5000},null,"Ngân sách",{"$f":"+'Ngan sach'!K38","v":1500},null,"Ngân sách",{"$f":"+'Ngan sach'!K53","v":2625},null,"Ngân sách",{"$f":"+'Ngan sach'!K11","v":17500}]
["Chênh lệch",{"$f":"B53-B52","v":420},null,"Chênh lệch",{"$f":"E53-E52","v":-2400},null,"Chênh lệch",{"$f":"H53-H52","v":0},null,"Chênh lệch",{"$f":"K53-K52","v":-1375},null,"Chênh lệch",{"$f":"N53-N52","v":-3500}]

{"sheet":"T9","index":11,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[43,13,43,15],[38,13,38,15],[39,13,39,15],[40,13,40,15],[41,13,41,15],[42,13,42,15],[33,13,33,15],[34,13,34,15],[35,13,35,15],[36,13,36,15],[37,13,37,15],[28,13,28,15],[29,13,29,15],[30,13,30,15],[31,13,31,15],[32,13,32,15],[23,13,23,15],[24,13,24,15],[25,13,25,15],[26,13,26,15],[27,13,27,15],[4,9,6,12],[45,11,47,11],[9,13,9,15],[10,13,10,15],[11,13,11,15],[12,13,12,15],[13,13,13,15],[14,13,14,15],[15,13,15,15],[16,13,16,15],[17,13,17,15],[18,13,18,15],[19,13,19,15],[20,13,20,15],[21,13,21,15],[22,13,22,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu nhập",{"$f":"+N52","v":18725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chi tiêu",{"$f":"+B52+E52+H52+K52+L42","v":18805}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chênh lệch",{"$f":"+R1-R2","v":-80}]
[null,"Thu nhập","Chi T.xuyên","Chi cố định","Chi B.Thường","Trả nợ","T.kiệm & ĐT","Còn lại",null,{"$f":"+IF(L44+H54>=0,\"\",\"CẢNH BÁO: CHI THƯỜNG XUYÊN + CHI BẤT THƯỜNG VƯỢT NGÂN SÁCH\")","v":""}]
["Ngân sách",{"$f":"+N53","v":17500},{"$f":"+L43","v":3400},{"$f":"+B53","v":4975},{"$f":"+H53","v":1500},{"$f":"+E53","v":5000},{"$f":"+K53","v":2625},{"$f":"+B6-SUM(C6:G6)","v":0}]
["Thực tế",{"$f":"+N52","v":18725},{"$f":"+L42","v":3400},{"$f":"+B52","v":4555},{"$f":"+H52","v":0},{"$f":"+E52","v":7350},{"$f":"+K52","v":3500},{"$f":"+B7-SUM(C7:G7)","v":-80}]
["Chênh lêch",{"$f":"+B6-B7","v":-1225},{"$f":"+C6-C7","v":0},420,1500,-2350,-875,null,null,null,null,null,null,null,null,"ĐVT: Nghìn đồng"]
[]
["Tháng 09",{"$f":"IF('Ngan sach'!C22=0, \"\", 'Ngan sach'!C22)","v":"Thức ăn"},{"$f":"IF('Ngan sach'!C23=0, \"\", 'Ngan sach'!C23)","v":"Điện"},{"$f":"IF('Ngan sach'!C24=0, \"\", 'Ngan sach'!C24)","v":""},{"$f":"IF('Ngan sach'!C25=0, \"\", 'Ngan sach'!C25)","v":""},{"$f":"IF('Ngan sach'!C26=0, \"\", 'Ngan sach'!C26)","v":""},{"$f":"IF('Ngan sach'!C27=0, \"\", 'Ngan sach'!C27)","v":""},{"$f":"IF('Ngan sach'!C28=0, \"\", 'Ngan sach'!C28)","v":""},{"$f":"IF('Ngan sach'!C29=0, \"\", 'Ngan sach'!C29)","v":""},null,null,"Tổng chi","Còn lại","Ghi chú"]
[1,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B11:K11)=0,\"\",SUM(B11:K11))","v":100},{"$f":"L43-SUM(B11:K11)","v":3300}]
[2,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B12:K12)=0,\" \",SUM(B12:K12))","v":100},{"$f":"M11-SUM(B12:K12)","v":3200}]
[3,100,null,null,null,null,null,null,null,null,null,100,{"$f":"M12-SUM(B13:K13)","v":3100}]
[4,100,400,null,null,null,null,null,null,null,null,500,2600]
[5,100,null,null,null,null,null,null,null,null,null,100,2500]
[6,100,null,null,null,null,null,null,null,null,null,100,2400]
[7,100,null,null,null,null,null,null,null,null,null,100,2300]
[8,100,null,null,null,null,null,null,null,null,null,100,2200]
[9,100,null,null,null,null,null,null,null,null,null,100,2100]
[10,100,null,null,null,null,null,null,null,null,null,100,2000]
[11,100,null,null,null,null,null,null,null,null,null,100,1900]
[12,100,null,null,null,null,null,null,null,null,null,100,1800]
[13,100,null,null,null,null,null,null,null,null,null,100,1700]
[14,100,null,null,null,null,null,null,null,null,null,100,1600]
[15,100,null,null,null,null,null,null,null,null,null,100,1500]
[16,100,null,null,null,null,null,null,null,null,null,100,1400]
[17,100,null,null,null,null,null,null,null,null,null,100,1300]
[18,100,null,null,null,null,null,null,null,null,null,100,1200]
[19,100,null,null,null,null,null,null,null,null,null,100,1100]
[20,100,null,null,null,null,null,null,null,null,null,100,1000]
[21,100,null,null,null,null,null,null,null,null,null,100,900]
[22,100,null,null,null,null,null,null,null,null,null,100,800]
[23,100,null,null,null,null,null,null,null,null,null,100,700]
[24,100,null,null,null,null,null,null,null,null,null,100,600]
[25,100,null,null,null,null,null,null,null,null,null,100,500]
[26,100,null,null,null,null,null,null,null,null,null,100,400]
[27,100,null,null,null,null,null,null,null,null,null,100,300]
[28,100,null,null,null,null,null,null,null,null,null,100,200]
[29,100,null,null,null,null,null,null,null,null,null,100,100]
[30,100,null,null,null,null,null,null,null,null,null,100,0]
[null,null,null,null,null,null,null,null,null,null,null," ",0]
["Đã chi",{"$f":"IF(SUM(B11:B41)=0,\"\",SUM(B11:B41))","v":3000},{"$f":"IF(SUM(C11:C41)=0,\"\",SUM(C11:C41))","v":400},{"$f":"IF(SUM(D11:D41)=0,\"\",SUM(D11:D41))","v":""},"","","","","","","",{"$f":"IF(SUM(L11:L41)=0,0,SUM(L11:L41))","v":3400}]
["Ngân sách",{"$f":"'Ngan sach'!L22","v":3000},{"$f":"'Ngan sach'!L23","v":400},{"$f":"'Ngan sach'!L24","v":0},{"$f":"'Ngan sach'!L25","v":0},{"$f":"'Ngan sach'!L26","v":0},{"$f":"'Ngan sach'!L27","v":0},{"$f":"'Ngan sach'!L28","v":0},{"$f":"'Ngan sach'!L29","v":0},null,null,{"$f":"SUM(B43:K43)","v":3400}]
["Còn lại",{"$f":"B43-SUM(B11:B41)","v":0},{"$f":"C43-SUM(C11:C41)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Cố định",null,null,"Trả nợ",null,null,"Bất thường",null,null,"Tiết kiệm & đầu tư",null,null,"Thu nhập thực tế"]
[{"$f":"IF('Ngan sach'!$C$14=0,\" \",'Ngan sach'!$C$14)","v":"Thuê nhà"},2500,null,{"$f":"IF('Ngan sach'!$C$41=0,\" \",'Ngan sach'!$C$41)","v":"Vay Mua nhà"},5350,null,{"$f":"IF('Ngan sach'!$C$33=0,\" \",'Ngan sach'!$C$33)","v":"Đi lại + về quê"},null,null,{"$f":"IF('Ngan sach'!$C$49=0,\" \",'Ngan sach'!$C$49)","v":"TK Ngân hàng"},3500,null,{"$f":"IF('Ngan sach'!$C$6=0,\" \",'Ngan sach'!$C$6)","v":"Lương & Thưởng"},16725]
[{"$f":"IF('Ngan sach'!$C$15=0,\" \",'Ngan sach'!$C$15)","v":"Điện thoại"},200,null,{"$f":"IF('Ngan sach'!$C$42=0,\" \",'Ngan sach'!$C$42)","v":"Mua xe"},null,null,{"$f":"IF('Ngan sach'!$C$34=0,\" \",'Ngan sach'!$C$34)","v":"Khám bệnh"},null,null,{"$f":"IF('Ngan sach'!$C$50=0,\" \",'Ngan sach'!$C$50)","v":"Bảo hiểm"},null,null,{"$f":"IF('Ngan sach'!$C$7=0,\" \",'Ngan sach'!$C$7)","v":"Ngoài giờ"},2000]
[{"$f":"IF('Ngan sach'!$C$16=0,\" \",'Ngan sach'!$C$16)","v":"Mạng internet"},200,null,{"$f":"IF('Ngan sach'!$C$43=0,\" \",'Ngan sach'!$C$43)","v":"Vay nợ cá nhân"},2000,null,{"$f":"IF('Ngan sach'!$C$35=0,\" \",'Ngan sach'!$C$35)","v":"Du lịch"},null,null,{"$f":"IF('Ngan sach'!$C$51=0,\" \",'Ngan sach'!$C$51)","v":"Đầu tư"},null,null,{"$f":"IF('Ngan sach'!$C$8=0,\" \",'Ngan sach'!$C$8)","v":"Lãi"}]
[{"$f":"IF('Ngan sach'!$C$17=0,\" \",'Ngan sach'!$C$17)","v":"Tiền học cho con"},1655,null,{"$f":"IF('Ngan sach'!$C$44=0,\" \",'Ngan sach'!$C$44)","v":"Thẻ tín dụng"},null,null,{"$f":"IF('Ngan sach'!$C$36=0,\" \",'Ngan sach'!$C$36)","v":"Khác"},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
[{"$f":"IF('Ngan sach'!$C$18=0,\" \",'Ngan sach'!$C$18)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$45=0,\" \",'Ngan sach'!$C$45)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$37=0,\" \",'Ngan sach'!$C$37)","v":" "},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
["Tổng thực tế",{"$f":"SUM(B47:B51)","v":4555},null,"Tổng thực tế",{"$f":"SUM(E47:E51)","v":7350},null,"Tổng thực tế",{"$f":"SUM(H47:H51)","v":0},null,"Tổng thực tế",{"$f":"SUM(K47:K51)","v":3500},null,"Tổng thực tế",{"$f":"SUM(N47:N50)","v":18725}]
["Ngân sách",{"$f":"+'Ngan sach'!L19","v":4975},null,"Ngân sách",{"$f":"+'Ngan sach'!L46","v":5000},null,"Ngân sách",{"$f":"+'Ngan sach'!L38","v":1500},null,"Ngân sách",{"$f":"+'Ngan sach'!L53","v":2625},null,"Ngân sách",{"$f":"+'Ngan sach'!L11","v":17500}]
["Chênh lệch",{"$f":"B53-B52","v":420},null,"Chênh lệch",{"$f":"E53-E52","v":-2350},null,"Chênh lệch",{"$f":"H53-H52","v":1500},null,"Chênh lệch",{"$f":"K53-K52","v":-875},null,"Chênh lệch",{"$f":"N53-N52","v":-1225}]

{"sheet":"T10","index":12,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[43,13,43,15],[38,13,38,15],[39,13,39,15],[40,13,40,15],[41,13,41,15],[42,13,42,15],[33,13,33,15],[34,13,34,15],[35,13,35,15],[36,13,36,15],[37,13,37,15],[28,13,28,15],[29,13,29,15],[30,13,30,15],[31,13,31,15],[32,13,32,15],[23,13,23,15],[24,13,24,15],[25,13,25,15],[26,13,26,15],[27,13,27,15],[4,9,6,12],[45,11,47,11],[9,13,9,15],[10,13,10,15],[11,13,11,15],[12,13,12,15],[13,13,13,15],[14,13,14,15],[15,13,15,15],[16,13,16,15],[17,13,17,15],[18,13,18,15],[19,13,19,15],[20,13,20,15],[21,13,21,15],[22,13,22,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu nhập",{"$f":"+N52","v":16725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chi tiêu",{"$f":"+B52+E52+H52+K52+L42","v":16655}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chênh lệch",{"$f":"+R1-R2","v":70}]
[null,"Thu nhập","Chi T.xuyên","Chi cố định","Chi B.Thường","Trả nợ","T.kiệm & ĐT","Còn lại",null,{"$f":"+IF(L44+H54>=0,\"\",\"CẢNH BÁO: CHI THƯỜNG XUYÊN + CHI BẤT THƯỜNG VƯỢT NGÂN SÁCH\")","v":""}]
["Ngân sách",{"$f":"+N53","v":17500},{"$f":"+L43","v":3300},{"$f":"+B53","v":4975},{"$f":"+H53","v":1500},{"$f":"+E53","v":5000},{"$f":"+K53","v":2725},{"$f":"+B6-SUM(C6:G6)","v":0}]
["Thực tế",{"$f":"+N52","v":16725},{"$f":"+L42","v":3500},{"$f":"+B52","v":4555},{"$f":"+H52","v":0},{"$f":"+E52","v":7300},{"$f":"+K52","v":1300},{"$f":"+B7-SUM(C7:G7)","v":70}]
["Chênh lêch",{"$f":"+B6-B7","v":775},{"$f":"+C6-C7","v":-200},420,1500,-2300,1425,null,null,null,null,null,null,null,null,"ĐVT: Nghìn đồng"]
[]
["Tháng 10",{"$f":"IF('Ngan sach'!C22=0, \"\", 'Ngan sach'!C22)","v":"Thức ăn"},{"$f":"IF('Ngan sach'!C23=0, \"\", 'Ngan sach'!C23)","v":"Điện"},{"$f":"IF('Ngan sach'!C24=0, \"\", 'Ngan sach'!C24)","v":""},{"$f":"IF('Ngan sach'!C25=0, \"\", 'Ngan sach'!C25)","v":""},{"$f":"IF('Ngan sach'!C26=0, \"\", 'Ngan sach'!C26)","v":""},{"$f":"IF('Ngan sach'!C27=0, \"\", 'Ngan sach'!C27)","v":""},{"$f":"IF('Ngan sach'!C28=0, \"\", 'Ngan sach'!C28)","v":""},{"$f":"IF('Ngan sach'!C29=0, \"\", 'Ngan sach'!C29)","v":""},null,null,"Tổng chi","Còn lại","Ghi chú"]
[1,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B11:K11)=0,\"\",SUM(B11:K11))","v":100},{"$f":"L43-SUM(B11:K11)","v":3200}]
[2,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B12:K12)=0,\" \",SUM(B12:K12))","v":100},{"$f":"M11-SUM(B12:K12)","v":3100}]
[3,100,null,null,null,null,null,null,null,null,null,100,{"$f":"M12-SUM(B13:K13)","v":3000}]
[4,100,400,null,null,null,null,null,null,null,null,500,2500]
[5,100,null,null,null,null,null,null,null,null,null,100,2400]
[6,100,null,null,null,null,null,null,null,null,null,100,2300]
[7,100,null,null,null,null,null,null,null,null,null,100,2200]
[8,100,null,null,null,null,null,null,null,null,null,100,2100]
[9,100,null,null,null,null,null,null,null,null,null,100,2000]
[10,100,null,null,null,null,null,null,null,null,null,100,1900]
[11,100,null,null,null,null,null,null,null,null,null,100,1800]
[12,100,null,null,null,null,null,null,null,null,null,100,1700]
[13,100,null,null,null,null,null,null,null,null,null,100,1600]
[14,100,null,null,null,null,null,null,null,null,null,100,1500]
[15,100,null,null,null,null,null,null,null,null,null,100,1400]
[16,100,null,null,null,null,null,null,null,null,null,100,1300]
[17,100,null,null,null,null,null,null,null,null,null,100,1200]
[18,100,null,null,null,null,null,null,null,null,null,100,1100]
[19,100,null,null,null,null,null,null,null,null,null,100,1000]
[20,100,null,null,null,null,null,null,null,null,null,100,900]
[21,100,null,null,null,null,null,null,null,null,null,100,800]
[22,100,null,null,null,null,null,null,null,null,null,100,700]
[23,100,null,null,null,null,null,null,null,null,null,100,600]
[24,100,null,null,null,null,null,null,null,null,null,100,500]
[25,100,null,null,null,null,null,null,null,null,null,100,400]
[26,100,null,null,null,null,null,null,null,null,null,100,300]
[27,100,null,null,null,null,null,null,null,null,null,100,200]
[28,100,null,null,null,null,null,null,null,null,null,100,100]
[29,100,null,null,null,null,null,null,null,null,null,100,0]
[30,100,null,null,null,null,null,null,null,null,null,100,-100]
[31,100,null,null,null,null,null,null,null,null,null,100,-200]
["Đã chi",{"$f":"IF(SUM(B11:B41)=0,\"\",SUM(B11:B41))","v":3100},{"$f":"IF(SUM(C11:C41)=0,\"\",SUM(C11:C41))","v":400},{"$f":"IF(SUM(D11:D41)=0,\"\",SUM(D11:D41))","v":""},"","","","","","","",{"$f":"IF(SUM(L11:L41)=0,0,SUM(L11:L41))","v":3500}]
["Ngân sách",{"$f":"'Ngan sach'!M22","v":3000},{"$f":"'Ngan sach'!M23","v":300},{"$f":"'Ngan sach'!M24","v":0},{"$f":"'Ngan sach'!M25","v":0},{"$f":"'Ngan sach'!M26","v":0},{"$f":"'Ngan sach'!M27","v":0},{"$f":"'Ngan sach'!M28","v":0},{"$f":"'Ngan sach'!M29","v":0},null,null,{"$f":"SUM(B43:K43)","v":3300}]
["Còn lại",{"$f":"B43-SUM(B11:B41)","v":-100},{"$f":"C43-SUM(C11:C41)","v":-100},0,0,0,0,0,0,0,0,-200]
[]
["Cố định",null,null,"Trả nợ",null,null,"Bất thường",null,null,"Tiết kiệm & đầu tư",null,null,"Thu nhập thực tế"]
[{"$f":"IF('Ngan sach'!$C$14=0,\" \",'Ngan sach'!$C$14)","v":"Thuê nhà"},2500,null,{"$f":"IF('Ngan sach'!$C$41=0,\" \",'Ngan sach'!$C$41)","v":"Vay Mua nhà"},5300,null,{"$f":"IF('Ngan sach'!$C$33=0,\" \",'Ngan sach'!$C$33)","v":"Đi lại + về quê"},null,null,{"$f":"IF('Ngan sach'!$C$49=0,\" \",'Ngan sach'!$C$49)","v":"TK Ngân hàng"},1300,null,{"$f":"IF('Ngan sach'!$C$6=0,\" \",'Ngan sach'!$C$6)","v":"Lương & Thưởng"},16725]
[{"$f":"IF('Ngan sach'!$C$15=0,\" \",'Ngan sach'!$C$15)","v":"Điện thoại"},200,null,{"$f":"IF('Ngan sach'!$C$42=0,\" \",'Ngan sach'!$C$42)","v":"Mua xe"},null,null,{"$f":"IF('Ngan sach'!$C$34=0,\" \",'Ngan sach'!$C$34)","v":"Khám bệnh"},null,null,{"$f":"IF('Ngan sach'!$C$50=0,\" \",'Ngan sach'!$C$50)","v":"Bảo hiểm"},null,null,{"$f":"IF('Ngan sach'!$C$7=0,\" \",'Ngan sach'!$C$7)","v":"Ngoài giờ"}]
[{"$f":"IF('Ngan sach'!$C$16=0,\" \",'Ngan sach'!$C$16)","v":"Mạng internet"},200,null,{"$f":"IF('Ngan sach'!$C$43=0,\" \",'Ngan sach'!$C$43)","v":"Vay nợ cá nhân"},2000,null,{"$f":"IF('Ngan sach'!$C$35=0,\" \",'Ngan sach'!$C$35)","v":"Du lịch"},null,null,{"$f":"IF('Ngan sach'!$C$51=0,\" \",'Ngan sach'!$C$51)","v":"Đầu tư"},null,null,{"$f":"IF('Ngan sach'!$C$8=0,\" \",'Ngan sach'!$C$8)","v":"Lãi"}]
[{"$f":"IF('Ngan sach'!$C$17=0,\" \",'Ngan sach'!$C$17)","v":"Tiền học cho con"},1655,null,{"$f":"IF('Ngan sach'!$C$44=0,\" \",'Ngan sach'!$C$44)","v":"Thẻ tín dụng"},null,null,{"$f":"IF('Ngan sach'!$C$36=0,\" \",'Ngan sach'!$C$36)","v":"Khác"},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
[{"$f":"IF('Ngan sach'!$C$18=0,\" \",'Ngan sach'!$C$18)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$45=0,\" \",'Ngan sach'!$C$45)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$37=0,\" \",'Ngan sach'!$C$37)","v":" "},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
["Tổng thực tế",{"$f":"SUM(B47:B51)","v":4555},null,"Tổng thực tế",{"$f":"SUM(E47:E51)","v":7300},null,"Tổng thực tế",{"$f":"SUM(H47:H51)","v":0},null,"Tổng thực tế",{"$f":"SUM(K47:K51)","v":1300},null,"Tổng thực tế",{"$f":"SUM(N47:N50)","v":16725}]
["Ngân sách",{"$f":"+'Ngan sach'!M19","v":4975},null,"Ngân sách",{"$f":"+'Ngan sach'!M46","v":5000},null,"Ngân sách",{"$f":"+'Ngan sach'!M38","v":1500},null,"Ngân sách",{"$f":"+'Ngan sach'!M53","v":2725},null,"Ngân sách",{"$f":"+'Ngan sach'!M11","v":17500}]
["Chênh lệch",{"$f":"B53-B52","v":420},null,"Chênh lệch",{"$f":"E53-E52","v":-2300},null,"Chênh lệch",{"$f":"H53-H52","v":1500},null,"Chênh lệch",{"$f":"K53-K52","v":1425},null,"Chênh lệch",{"$f":"N53-N52","v":775}]

{"sheet":"T11","index":13,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[43,13,43,15],[38,13,38,15],[39,13,39,15],[40,13,40,15],[41,13,41,15],[42,13,42,15],[33,13,33,15],[34,13,34,15],[35,13,35,15],[36,13,36,15],[37,13,37,15],[28,13,28,15],[29,13,29,15],[30,13,30,15],[31,13,31,15],[32,13,32,15],[23,13,23,15],[24,13,24,15],[25,13,25,15],[26,13,26,15],[27,13,27,15],[4,9,6,12],[45,11,47,11],[9,13,9,15],[10,13,10,15],[11,13,11,15],[12,13,12,15],[13,13,13,15],[14,13,14,15],[15,13,15,15],[16,13,16,15],[17,13,17,15],[18,13,18,15],[19,13,19,15],[20,13,20,15],[21,13,21,15],[22,13,22,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu nhập",{"$f":"+N52","v":17725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chi tiêu",{"$f":"+B52+E52+H52+K52+L42","v":17575}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chênh lệch",{"$f":"+R1-R2","v":150}]
[null,"Thu nhập","Chi T.xuyên","Chi cố định","Chi B.Thường","Trả nợ","T.kiệm & ĐT","Còn lại",null,{"$f":"+IF(L44+H54>=0,\"\",\"CẢNH BÁO: CHI THƯỜNG XUYÊN + CHI BẤT THƯỜNG VƯỢT NGÂN SÁCH\")","v":""}]
["Ngân sách",{"$f":"+N53","v":17500},{"$f":"+L43","v":3300},{"$f":"+B53","v":4975},{"$f":"+H53","v":1500},{"$f":"+E53","v":5000},{"$f":"+K53","v":2725},{"$f":"+B6-SUM(C6:G6)","v":0}]
["Thực tế",{"$f":"+N52","v":17725},{"$f":"+L42","v":3400},{"$f":"+B52","v":4555},{"$f":"+H52","v":300},{"$f":"+E52","v":7320},{"$f":"+K52","v":2000},{"$f":"+B7-SUM(C7:G7)","v":150}]
["Chênh lêch",{"$f":"+B6-B7","v":-225},{"$f":"+C6-C7","v":-100},420,1200,-2320,725,null,null,null,null,null,null,null,null,"ĐVT: Nghìn đồng"]
[]
["Tháng 11",{"$f":"IF('Ngan sach'!C22=0, \"\", 'Ngan sach'!C22)","v":"Thức ăn"},{"$f":"IF('Ngan sach'!C23=0, \"\", 'Ngan sach'!C23)","v":"Điện"},{"$f":"IF('Ngan sach'!C24=0, \"\", 'Ngan sach'!C24)","v":""},{"$f":"IF('Ngan sach'!C25=0, \"\", 'Ngan sach'!C25)","v":""},{"$f":"IF('Ngan sach'!C26=0, \"\", 'Ngan sach'!C26)","v":""},{"$f":"IF('Ngan sach'!C27=0, \"\", 'Ngan sach'!C27)","v":""},{"$f":"IF('Ngan sach'!C28=0, \"\", 'Ngan sach'!C28)","v":""},{"$f":"IF('Ngan sach'!C29=0, \"\", 'Ngan sach'!C29)","v":""},null,null,"Tổng chi","Còn lại","Ghi chú"]
[1,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B11:K11)=0,\"\",SUM(B11:K11))","v":100},{"$f":"L43-SUM(B11:K11)","v":3200}]
[2,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B12:K12)=0,\" \",SUM(B12:K12))","v":100},{"$f":"M11-SUM(B12:K12)","v":3100}]
[3,100,null,null,null,null,null,null,null,null,null,100,{"$f":"M12-SUM(B13:K13)","v":3000}]
[4,100,400,null,null,null,null,null,null,null,null,500,2500]
[5,100,null,null,null,null,null,null,null,null,null,100,2400]
[6,100,null,null,null,null,null,null,null,null,null,100,2300]
[7,100,null,null,null,null,null,null,null,null,null,100,2200]
[8,100,null,null,null,null,null,null,null,null,null,100,2100]
[9,100,null,null,null,null,null,null,null,null,null,100,2000]
[10,100,null,null,null,null,null,null,null,null,null,100,1900]
[11,100,null,null,null,null,null,null,null,null,null,100,1800]
[12,100,null,null,null,null,null,null,null,null,null,100,1700]
[13,100,null,null,null,null,null,null,null,null,null,100,1600]
[14,100,null,null,null,null,null,null,null,null,null,100,1500]
[15,100,null,null,null,null,null,null,null,null,null,100,1400]
[16,100,null,null,null,null,null,null,null,null,null,100,1300]
[17,100,null,null,null,null,null,null,null,null,null,100,1200]
[18,100,null,null,null,null,null,null,null,null,null,100,1100]
[19,100,null,null,null,null,null,null,null,null,null,100,1000]
[20,100,null,null,null,null,null,null,null,null,null,100,900]
[21,100,null,null,null,null,null,null,null,null,null,100,800]
[22,100,null,null,null,null,null,null,null,null,null,100,700]
[23,100,null,null,null,null,null,null,null,null,null,100,600]
[24,100,null,null,null,null,null,null,null,null,null,100,500]
[25,100,null,null,null,null,null,null,null,null,null,100,400]
[26,100,null,null,null,null,null,null,null,null,null,100,300]
[27,100,null,null,null,null,null,null,null,null,null,100,200]
[28,100,null,null,null,null,null,null,null,null,null,100,100]
[29,100,null,null,null,null,null,null,null,null,null,100,0]
[30,100,null,null,null,null,null,null,null,null,null,100,-100]
[null,null,null,null,null,null,null,null,null,null,null," ",-100]
["Đã chi",{"$f":"IF(SUM(B11:B41)=0,\"\",SUM(B11:B41))","v":3000},{"$f":"IF(SUM(C11:C41)=0,\"\",SUM(C11:C41))","v":400},{"$f":"IF(SUM(D11:D41)=0,\"\",SUM(D11:D41))","v":""},"","","","","","","",{"$f":"IF(SUM(L11:L41)=0,0,SUM(L11:L41))","v":3400}]
["Ngân sách",{"$f":"'Ngan sach'!N22","v":3000},{"$f":"'Ngan sach'!N23","v":300},{"$f":"'Ngan sach'!N24","v":0},{"$f":"'Ngan sach'!N25","v":0},{"$f":"'Ngan sach'!N26","v":0},{"$f":"'Ngan sach'!N27","v":0},{"$f":"'Ngan sach'!N28","v":0},{"$f":"'Ngan sach'!N29","v":0},null,null,{"$f":"SUM(B43:K43)","v":3300}]
["Còn lại",{"$f":"B43-SUM(B11:B41)","v":0},{"$f":"C43-SUM(C11:C41)","v":-100},0,0,0,0,0,0,0,0,-100]
[]
["Cố định",null,null,"Trả nợ",null,null,"Bất thường",null,null,"Tiết kiệm & đầu tư",null,null,"Thu nhập thực tế"]
[{"$f":"IF('Ngan sach'!$C$14=0,\" \",'Ngan sach'!$C$14)","v":"Thuê nhà"},2500,null,{"$f":"IF('Ngan sach'!$C$41=0,\" \",'Ngan sach'!$C$41)","v":"Vay Mua nhà"},5320,null,{"$f":"IF('Ngan sach'!$C$33=0,\" \",'Ngan sach'!$C$33)","v":"Đi lại + về quê"},300,null,{"$f":"IF('Ngan sach'!$C$49=0,\" \",'Ngan sach'!$C$49)","v":"TK Ngân hàng"},2000,null,{"$f":"IF('Ngan sach'!$C$6=0,\" \",'Ngan sach'!$C$6)","v":"Lương & Thưởng"},16725]
[{"$f":"IF('Ngan sach'!$C$15=0,\" \",'Ngan sach'!$C$15)","v":"Điện thoại"},200,null,{"$f":"IF('Ngan sach'!$C$42=0,\" \",'Ngan sach'!$C$42)","v":"Mua xe"},null,null,{"$f":"IF('Ngan sach'!$C$34=0,\" \",'Ngan sach'!$C$34)","v":"Khám bệnh"},null,null,{"$f":"IF('Ngan sach'!$C$50=0,\" \",'Ngan sach'!$C$50)","v":"Bảo hiểm"},null,null,{"$f":"IF('Ngan sach'!$C$7=0,\" \",'Ngan sach'!$C$7)","v":"Ngoài giờ"},1000]
[{"$f":"IF('Ngan sach'!$C$16=0,\" \",'Ngan sach'!$C$16)","v":"Mạng internet"},200,null,{"$f":"IF('Ngan sach'!$C$43=0,\" \",'Ngan sach'!$C$43)","v":"Vay nợ cá nhân"},2000,null,{"$f":"IF('Ngan sach'!$C$35=0,\" \",'Ngan sach'!$C$35)","v":"Du lịch"},null,null,{"$f":"IF('Ngan sach'!$C$51=0,\" \",'Ngan sach'!$C$51)","v":"Đầu tư"},null,null,{"$f":"IF('Ngan sach'!$C$8=0,\" \",'Ngan sach'!$C$8)","v":"Lãi"}]
[{"$f":"IF('Ngan sach'!$C$17=0,\" \",'Ngan sach'!$C$17)","v":"Tiền học cho con"},1655,null,{"$f":"IF('Ngan sach'!$C$44=0,\" \",'Ngan sach'!$C$44)","v":"Thẻ tín dụng"},null,null,{"$f":"IF('Ngan sach'!$C$36=0,\" \",'Ngan sach'!$C$36)","v":"Khác"},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
[{"$f":"IF('Ngan sach'!$C$18=0,\" \",'Ngan sach'!$C$18)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$45=0,\" \",'Ngan sach'!$C$45)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$37=0,\" \",'Ngan sach'!$C$37)","v":" "},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
["Tổng thực tế",{"$f":"SUM(B47:B51)","v":4555},null,"Tổng thực tế",{"$f":"SUM(E47:E51)","v":7320},null,"Tổng thực tế",{"$f":"SUM(H47:H51)","v":300},null,"Tổng thực tế",{"$f":"SUM(K47:K51)","v":2000},null,"Tổng thực tế",{"$f":"SUM(N47:N50)","v":17725}]
["Ngân sách",{"$f":"+'Ngan sach'!N19","v":4975},null,"Ngân sách",{"$f":"+'Ngan sach'!N46","v":5000},null,"Ngân sách",{"$f":"+'Ngan sach'!N38","v":1500},null,"Ngân sách",{"$f":"+'Ngan sach'!N53","v":2725},null,"Ngân sách",{"$f":"+'Ngan sach'!N11","v":17500}]
["Chênh lệch",{"$f":"B53-B52","v":420},null,"Chênh lệch",{"$f":"E53-E52","v":-2320},null,"Chênh lệch",{"$f":"H53-H52","v":1200},null,"Chênh lệch",{"$f":"K53-K52","v":725},null,"Chênh lệch",{"$f":"N53-N52","v":-225}]

{"sheet":"T12","index":14,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[43,13,43,15],[38,13,38,15],[39,13,39,15],[40,13,40,15],[41,13,41,15],[42,13,42,15],[33,13,33,15],[34,13,34,15],[35,13,35,15],[36,13,36,15],[37,13,37,15],[28,13,28,15],[29,13,29,15],[30,13,30,15],[31,13,31,15],[32,13,32,15],[23,13,23,15],[24,13,24,15],[25,13,25,15],[26,13,26,15],[27,13,27,15],[4,9,6,12],[45,11,47,11],[9,13,9,15],[10,13,10,15],[11,13,11,15],[12,13,12,15],[13,13,13,15],[14,13,14,15],[15,13,15,15],[16,13,16,15],[17,13,17,15],[18,13,18,15],[19,13,19,15],[20,13,20,15],[21,13,21,15],[22,13,22,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu nhập",{"$f":"+N52","v":31000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chi tiêu",{"$f":"+B52+E52+H52+K52+L42","v":31355}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chênh lệch",{"$f":"+R1-R2","v":-355}]
[null,"Thu nhập","Chi T.xuyên","Chi cố định","Chi B.Thường","Trả nợ","T.kiệm & ĐT","Còn lại",null,{"$f":"+IF(L44+H54>=0,\"\",\"CẢNH BÁO: CHI THƯỜNG XUYÊN + CHI BẤT THƯỜNG VƯỢT NGÂN SÁCH\")","v":""}]
["Ngân sách",{"$f":"+N53","v":27500},{"$f":"+L43","v":3300},{"$f":"+B53","v":4975},{"$f":"+H53","v":1500},{"$f":"+E53","v":5000},{"$f":"+K53","v":2725},{"$f":"+B6-SUM(C6:G6)","v":10000}]
["Thực tế",{"$f":"+N52","v":31000},{"$f":"+L42","v":3500},{"$f":"+B52","v":4555},{"$f":"+H52","v":1000},{"$f":"+E52","v":7300},{"$f":"+K52","v":15000},{"$f":"+B7-SUM(C7:G7)","v":-355}]
["Chênh lêch",{"$f":"+B6-B7","v":-3500},{"$f":"+C6-C7","v":-200},420,500,-2300,-12275,null,null,null,null,null,null,null,null,"ĐVT: Nghìn đồng"]
[]
["Tháng 12",{"$f":"IF('Ngan sach'!C22=0, \"\", 'Ngan sach'!C22)","v":"Thức ăn"},{"$f":"IF('Ngan sach'!C23=0, \"\", 'Ngan sach'!C23)","v":"Điện"},{"$f":"IF('Ngan sach'!C24=0, \"\", 'Ngan sach'!C24)","v":""},{"$f":"IF('Ngan sach'!C25=0, \"\", 'Ngan sach'!C25)","v":""},{"$f":"IF('Ngan sach'!C26=0, \"\", 'Ngan sach'!C26)","v":""},{"$f":"IF('Ngan sach'!C27=0, \"\", 'Ngan sach'!C27)","v":""},{"$f":"IF('Ngan sach'!C28=0, \"\", 'Ngan sach'!C28)","v":""},{"$f":"IF('Ngan sach'!C29=0, \"\", 'Ngan sach'!C29)","v":""},null,null,"Tổng chi","Còn lại","Ghi chú"]
[1,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B11:K11)=0,\"\",SUM(B11:K11))","v":100},{"$f":"L43-SUM(B11:K11)","v":3200}]
[2,100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B12:K12)=0,\" \",SUM(B12:K12))","v":100},{"$f":"M11-SUM(B12:K12)","v":3100}]
[3,100,null,null,null,null,null,null,null,null,null,100,{"$f":"M12-SUM(B13:K13)","v":3000}]
[4,100,400,null,null,null,null,null,null,null,null,500,2500]
[5,100,null,null,null,null,null,null,null,null,null,100,2400]
[6,100,null,null,null,null,null,null,null,null,null,100,2300]
[7,100,null,null,null,null,null,null,null,null,null,100,2200]
[8,100,null,null,null,null,null,null,null,null,null,100,2100]
[9,100,null,null,null,null,null,null,null,null,null,100,2000]
[10,100,null,null,null,null,null,null,null,null,null,100,1900]
[11,100,null,null,null,null,null,null,null,null,null,100,1800]
[12,100,null,null,null,null,null,null,null,null,null,100,1700]
[13,100,null,null,null,null,null,null,null,null,null,100,1600]
[14,100,null,null,null,null,null,null,null,null,null,100,1500]
[15,100,null,null,null,null,null,null,null,null,null,100,1400]
[16,100,null,null,null,null,null,null,null,null,null,100,1300]
[17,100,null,null,null,null,null,null,null,null,null,100,1200]
[18,100,null,null,null,null,null,null,null,null,null,100,1100]
[19,100,null,null,null,null,null,null,null,null,null,100,1000]
[20,100,null,null,null,null,null,null,null,null,null,100,900]
[21,100,null,null,null,null,null,null,null,null,null,100,800]
[22,100,null,null,null,null,null,null,null,null,null,100,700]
[23,100,null,null,null,null,null,null,null,null,null,100,600]
[24,100,null,null,null,null,null,null,null,null,null,100,500]
[25,100,null,null,null,null,null,null,null,null,null,100,400]
[26,100,null,null,null,null,null,null,null,null,null,100,300]
[27,100,null,null,null,null,null,null,null,null,null,100,200]
[28,100,null,null,null,null,null,null,null,null,null,100,100]
[29,100,null,null,null,null,null,null,null,null,null,100,0]
[30,100,null,null,null,null,null,null,null,null,null,100,-100]
[31,100,null,null,null,null,null,null,null,null,null,100,-200]
["Đã chi",{"$f":"IF(SUM(B11:B41)=0,\"\",SUM(B11:B41))","v":3100},{"$f":"IF(SUM(C11:C41)=0,\"\",SUM(C11:C41))","v":400},{"$f":"IF(SUM(D11:D41)=0,\"\",SUM(D11:D41))","v":""},"","","","","","","",{"$f":"IF(SUM(L11:L41)=0,0,SUM(L11:L41))","v":3500}]
["Ngân sách",{"$f":"'Ngan sach'!O22","v":3000},{"$f":"'Ngan sach'!O23","v":300},{"$f":"'Ngan sach'!O24","v":0},{"$f":"'Ngan sach'!O25","v":0},{"$f":"'Ngan sach'!O26","v":0},{"$f":"'Ngan sach'!O27","v":0},{"$f":"'Ngan sach'!O28","v":0},{"$f":"'Ngan sach'!O29","v":0},null,null,{"$f":"SUM(B43:K43)","v":3300}]
["Còn lại",{"$f":"B43-SUM(B11:B41)","v":-100},{"$f":"C43-SUM(C11:C41)","v":-100},0,0,0,0,0,0,0,0,-200]
[]
["Cố định",null,null,"Trả nợ",null,null,"Bất thường",null,null,"Tiết kiệm & đầu tư",null,null,"Thu nhập thực tế"]
[{"$f":"IF('Ngan sach'!$C$14=0,\" \",'Ngan sach'!$C$14)","v":"Thuê nhà"},2500,null,{"$f":"IF('Ngan sach'!$C$41=0,\" \",'Ngan sach'!$C$41)","v":"Vay Mua nhà"},5300,null,{"$f":"IF('Ngan sach'!$C$33=0,\" \",'Ngan sach'!$C$33)","v":"Đi lại + về quê"},1000,null,{"$f":"IF('Ngan sach'!$C$49=0,\" \",'Ngan sach'!$C$49)","v":"TK Ngân hàng"},15000,null,{"$f":"IF('Ngan sach'!$C$6=0,\" \",'Ngan sach'!$C$6)","v":"Lương & Thưởng"},31000]
[{"$f":"IF('Ngan sach'!$C$15=0,\" \",'Ngan sach'!$C$15)","v":"Điện thoại"},200,null,{"$f":"IF('Ngan sach'!$C$42=0,\" \",'Ngan sach'!$C$42)","v":"Mua xe"},null,null,{"$f":"IF('Ngan sach'!$C$34=0,\" \",'Ngan sach'!$C$34)","v":"Khám bệnh"},null,null,{"$f":"IF('Ngan sach'!$C$50=0,\" \",'Ngan sach'!$C$50)","v":"Bảo hiểm"},null,null,{"$f":"IF('Ngan sach'!$C$7=0,\" \",'Ngan sach'!$C$7)","v":"Ngoài giờ"}]
[{"$f":"IF('Ngan sach'!$C$16=0,\" \",'Ngan sach'!$C$16)","v":"Mạng internet"},200,null,{"$f":"IF('Ngan sach'!$C$43=0,\" \",'Ngan sach'!$C$43)","v":"Vay nợ cá nhân"},2000,null,{"$f":"IF('Ngan sach'!$C$35=0,\" \",'Ngan sach'!$C$35)","v":"Du lịch"},null,null,{"$f":"IF('Ngan sach'!$C$51=0,\" \",'Ngan sach'!$C$51)","v":"Đầu tư"},null,null,{"$f":"IF('Ngan sach'!$C$8=0,\" \",'Ngan sach'!$C$8)","v":"Lãi"}]
[{"$f":"IF('Ngan sach'!$C$17=0,\" \",'Ngan sach'!$C$17)","v":"Tiền học cho con"},1655,null,{"$f":"IF('Ngan sach'!$C$44=0,\" \",'Ngan sach'!$C$44)","v":"Thẻ tín dụng"},null,null,{"$f":"IF('Ngan sach'!$C$36=0,\" \",'Ngan sach'!$C$36)","v":"Khác"},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
[{"$f":"IF('Ngan sach'!$C$18=0,\" \",'Ngan sach'!$C$18)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$45=0,\" \",'Ngan sach'!$C$45)","v":" "},null,null,{"$f":"IF('Ngan sach'!$C$37=0,\" \",'Ngan sach'!$C$37)","v":" "},null,null,null,null,null,{"$f":"IF('Ngan sach'!$C$9=0,\" \",'Ngan sach'!$C$8)","v":" "}]
["Tổng thực tế",{"$f":"SUM(B47:B51)","v":4555},null,"Tổng thực tế",{"$f":"SUM(E47:E51)","v":7300},null,"Tổng thực tế",{"$f":"SUM(H47:H51)","v":1000},null,"Tổng thực tế",{"$f":"SUM(K47:K51)","v":15000},null,"Tổng thực tế",{"$f":"SUM(N47:N50)","v":31000}]
["Ngân sách",{"$f":"+'Ngan sach'!O19","v":4975},null,"Ngân sách",{"$f":"+'Ngan sach'!O46","v":5000},null,"Ngân sách",{"$f":"+'Ngan sach'!O38","v":1500},null,"Ngân sách",{"$f":"+'Ngan sach'!O53","v":2725},null,"Ngân sách",{"$f":"+'Ngan sach'!O11","v":27500}]
["Chênh lệch",{"$f":"B53-B52","v":420},null,"Chênh lệch",{"$f":"E53-E52","v":-2300},null,"Chênh lệch",{"$f":"H53-H52","v":500},null,"Chênh lệch",{"$f":"K53-K52","v":-12275},null,"Chênh lệch",{"$f":"N53-N52","v":-3500}]

{"sheet":"BKCT","index":15,"n_rows":26,"n_cols":142,"rows_kept":26,"cut":false,"hidden":false,"merged":[[3,1,3,14]]}
[]
[]
[]
[null,"BÁO CÁO TỔNG QUAN TÌNH HÌNH TÀI CHÍNH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T1","T2","T3","T4","T5","T6","T7","T8","T9","T10","T11","T12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chi thường xuyên",{"$f":"+'T1'!$L$42","v":3450},{"$f":"+'T2'!$L$42","v":3000},{"$f":"+'T3'!$L$42","v":3500},{"$f":"+'T4'!$L$42","v":3000},{"$f":"+'T5'!$L$42","v":3500},{"$f":"+'T6'!$L$42","v":3400},{"$f":"+'T7'!$L$42","v":3500},{"$f":"+'T8'!$L$42","v":3500},{"$f":"+'T9'!$L$42","v":3400},{"$f":"+'T10'!$L$42","v":3500},{"$f":"+'T11'!$L$42","v":3400},{"$f":"+'T12'!$L$42","v":3500},{"$f":"+SUM(DZ6:EK6)","v":40650}]
[null,"Cơ cấu chi tiêu tháng",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chi cố định",{"$f":"+'T1'!$B$52","v":4555},{"$f":"+'T2'!$B$52","v":4555},{"$f":"+'T3'!$B$52","v":4555},{"$f":"+'T4'!$B$52","v":4555},{"$f":"+'T5'!$B$52","v":4555},{"$f":"+'T6'!$B$52","v":4555},{"$f":"+'T7'!$B$52","v":4555},{"$f":"+'T8'!$B$52","v":4555},{"$f":"+'T9'!$B$52","v":4555},{"$f":"+'T10'!$B$52","v":4555},{"$f":"+'T11'!$B$52","v":4555},{"$f":"+'T12'!$B$52","v":4555},{"$f":"+SUM(DZ7:EK7)","v":54660}]
[null,"Tháng",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chi bất thường",{"$f":"+'T1'!$H$52","v":1500},{"$f":"+'T2'!$H$52","v":2000},{"$f":"+'T3'!$H$52","v":0},{"$f":"+'T4'!$H$52","v":0},{"$f":"+'T5'!$H$52","v":0},{"$f":"+'T6'!$H$52","v":0},{"$f":"+'T7'!$H$52","v":1000},{"$f":"+'T8'!$H$52","v":1500},{"$f":"+'T9'!$H$52","v":0},{"$f":"+'T10'!$H$52","v":0},{"$f":"+'T11'!$H$52","v":300},{"$f":"+'T12'!$H$52","v":1000},{"$f":"+SUM(DZ8:EK8)","v":7300}]
[null,"Chi thường xuyên",{"$f":"+INDEX(DZ15:EK15,$C$8)","v":0.20926756352765322},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tiết kiệm",{"$f":"+'T1'!$K$52","v":9000},{"$f":"+'T2'!$K$52","v":12000},{"$f":"+'T3'!$K$52","v":11500},{"$f":"+'T4'!$K$52","v":24000},{"$f":"+'T5'!$K$52","v":8500},{"$f":"+'T6'!$K$52","v":1000},{"$f":"+'T7'!$K$52","v":5500},{"$f":"+'T8'!$K$52","v":4000},{"$f":"+'T9'!$K$52","v":3500},{"$f":"+'T10'!$K$52","v":1300},{"$f":"+'T11'!$K$52","v":2000},{"$f":"+'T12'!$K$52","v":15000},{"$f":"+SUM(DZ9:EK9)","v":97300}]
[null,"Chi cố định",{"$f":"+INDEX(DZ16:EK16,$C$8)","v":0.27234678624813152},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trả nợ",{"$f":"+'T1'!$E$52","v":0},{"$f":"+'T2'!$E$52","v":0},{"$f":"+'T3'!$E$52","v":0},{"$f":"+'T4'!$E$52","v":0},{"$f":"+'T5'!$E$52","v":0},{"$f":"+'T6'!$E$52","v":7500},{"$f":"+'T7'!$E$52","v":7450},{"$f":"+'T8'!$E$52","v":7400},{"$f":"+'T9'!$E$52","v":7350},{"$f":"+'T10'!$E$52","v":7300},{"$f":"+'T11'!$E$52","v":7320},{"$f":"+'T12'!$E$52","v":7300},{"$f":"+SUM(DZ10:EK10)","v":51620}]
[null,"Chi bất thường",{"$f":"+INDEX(DZ17:EK17,$C$8)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu nhập",{"$f":"+'T1'!$N$52","v":18725},{"$f":"+'T2'!$N$52","v":21725},{"$f":"+'T3'!$N$52","v":19725},{"$f":"+'T4'!$N$52","v":31500},{"$f":"+'T5'!$N$52","v":16725},{"$f":"+'T6'!$N$52","v":16725},{"$f":"+'T7'!$N$52","v":22000},{"$f":"+'T8'!$N$52","v":21000},{"$f":"+'T9'!$N$52","v":18725},{"$f":"+'T10'!$N$52","v":16725},{"$f":"+'T11'!$N$52","v":17725},{"$f":"+'T12'!$N$52","v":31000},{"$f":"+SUM(DZ11:EK11)","v":252300}]
[null,"Tiết kiệm",{"$f":"+INDEX(DZ18:EK18,$C$8)","v":7.7727952167414044E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tổng chi phí sinh hoạt",{"$f":"+DZ6+DZ7+DZ8","v":9505},{"$f":"+EA6+EA7+EA8","v":9555},8055,7555,8055,7955,9055,9555,7955,8055,8255,9055,102610]
[null,"Trả nợ",{"$f":"+INDEX(DZ19:EK19,$C$8)","v":0.43647234678624813}]
[null,"Còn lại",{"$f":"1-SUM(C9:C13)","v":4.1853512705530838E-3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tỷ trọng","T1","T2","T3","T4","T5","T6","T7","T8","T9","T10","T11","T12","Trung bình"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chi thường xuyên",{"$f":"+DZ6/DZ$11","v":0.18424566088117489},{"$f":"+EA6/EA$11","v":0.13808975834292289},0.17743979721166034,9.5238095238095233E-2,0.20926756352765322,0.20328849028400597,0.15909090909090909,0.16666666666666666,0.18157543391188252,0.20926756352765322,0.1918194640338505,0.11290322580645161,{"$f":"+EL6/$EL$22","v":0.1611177170035672}]
[null,"Cơ cấu chi tiêu cả năm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chi cố định",{"$f":"+DZ7/DZ$11","v":0.24325767690253672},0.20966628308400459,0.23092522179974651,0.14460317460317459,0.27234678624813152,0.27234678624813152,0.20704545454545453,0.21690476190476191,0.24325767690253672,0.27234678624813152,0.25698166431593794,0.14693548387096775,{"$f":"+EL7/$EL$22","v":0.21664684898929845}]
[null,"Cả năm",2017,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chi bất thường",8.0106809078771699E-2,9.2059838895281937E-2,0,0,0,0,4.5454545454545456E-2,7.1428571428571425E-2,0,0,1.6925246826516221E-2,3.2258064516129031E-2,{"$f":"+EL8/$EL$22","v":2.8933808957590169E-2}]
[null,"Thu nhập",{"$f":"+EL11","v":252300},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tiết kiệm",0.48064085447263016,0.55235903337169157,0.58301647655259825,0.76190476190476186,0.50822122571001493,5.9790732436472344E-2,0.25,0.19047619047619047,0.18691588785046728,7.7727952167414044E-2,0.11283497884344147,0.4838709677419355,{"$f":"+EL9/$EL$22","v":0.38565200158541418}]
[null,"Chi tiêu",{"$f":"+EL12","v":102610},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trả nợ",0,0,0,0,0,0.44843049327354262,0.33863636363636362,0.35238095238095241,0.3925233644859813,0.43647234678624813,0.41297602256699578,0.23548387096774193,{"$f":"+EL10/$EL$22","v":0.2045977011494253}]
[null,"Tiết kiệm - Đầu tư",{"$f":"+EL9","v":97300}]
[null,"Trả nợ",{"$f":"+EL10","v":51620},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu nhập","T1","T2","T3","T4","T5","T6","T7","T8","T9","T10","T11","T12","Total"]
[null,"Còn lại",{"$f":"+C18-SUM(C19:C21)","v":770},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thực tế",{"$f":"+'T1'!$N$52","v":18725},{"$f":"+'T2'!$N$52","v":21725},{"$f":"+'T3'!$N$52","v":19725},{"$f":"+'T4'!$N$52","v":31500},{"$f":"+'T5'!$N$52","v":16725},{"$f":"+'T6'!$N$52","v":16725},{"$f":"+'T7'!$N$52","v":22000},{"$f":"+'T8'!$N$52","v":21000},{"$f":"+'T9'!$N$52","v":18725},{"$f":"+'T10'!$N$52","v":16725},{"$f":"+'T11'!$N$52","v":17725},{"$f":"+'T12'!$N$52","v":31000},{"$f":"+SUM(DZ22:EK22)","v":252300}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ngân sách",{"$f":"+'Ngan sach'!D11","v":17500},{"$f":"+'Ngan sach'!E11","v":17500},{"$f":"+'Ngan sach'!F11","v":17500},{"$f":"+'Ngan sach'!G11","v":32500},{"$f":"+'Ngan sach'!H11","v":17500},{"$f":"+'Ngan sach'!I11","v":17500},{"$f":"+'Ngan sach'!J11","v":21500},{"$f":"+'Ngan sach'!K11","v":17500},{"$f":"+'Ngan sach'!L11","v":17500},{"$f":"+'Ngan sach'!M11","v":17500},{"$f":"+'Ngan sach'!N11","v":17500},{"$f":"+'Ngan sach'!O11","v":27500},{"$f":"+SUM(DZ23:EK23)","v":239000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chi tiêu","T1","T2","T3","T4","T5","T6","T7","T8","T9","T10","T11","T12","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thực tế",{"$f":"+SUM(DZ6:DZ8)","v":9505},{"$f":"+SUM(EA6:EA8)","v":9555},8055,7555,8055,7955,9055,9555,7955,8055,8255,9055,{"$f":"+SUM(DZ25:EK25)","v":102610}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ngân sách",{"$f":"+'Ngan sach'!D19+'Ngan sach'!D30+'Ngan sach'!D38","v":9875},{"$f":"+'Ngan sach'!E19+'Ngan sach'!E30+'Ngan sach'!E38","v":9925},{"$f":"+'Ngan sach'!F19+'Ngan sach'!F30+'Ngan sach'!F38","v":9875},{"$f":"+'Ngan sach'!G19+'Ngan sach'!G30+'Ngan sach'!G38","v":9875},{"$f":"+'Ngan sach'!H19+'Ngan sach'!H30+'Ngan sach'!H38","v":10075},{"$f":"+'Ngan sach'!I19+'Ngan sach'!I30+'Ngan sach'!I38","v":9875},{"$f":"+'Ngan sach'!J19+'Ngan sach'!J30+'Ngan sach'!J38","v":9875},{"$f":"+'Ngan sach'!K19+'Ngan sach'!K30+'Ngan sach'!K38","v":9875},{"$f":"+'Ngan sach'!L19+'Ngan sach'!L30+'Ngan sach'!L38","v":9875},{"$f":"+'Ngan sach'!M19+'Ngan sach'!M30+'Ngan sach'!M38","v":9775},{"$f":"+'Ngan sach'!N19+'Ngan sach'!N30+'Ngan sach'!N38","v":9775},{"$f":"+'Ngan sach'!O19+'Ngan sach'!O30+'Ngan sach'!O38","v":9775},{"$f":"+SUM(DZ26:EK26)","v":118450}]

{"sheet":"No","index":16,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Bảng kê 01",null,null,null,"Đơn vị tính: ","1.000 VNĐ",null,"Bảng kê 02",null,null,null,"Đơn vị tính: ","1.000 VNĐ"]
["Ngày tháng","Nội dung","Món vay","Phát sinh mới","Trả nợ","Ghi chú",null,"STT","Món vay","Nợ từ năm trước chuyển sang","Phát sinh thêm","Đã trả","Còn lại"]
["2017-01-01","Nợ mua nhà","Vay ngân hàng",300000,null,null,null,1,"Vay ngân hàng",null,{"$f":"+SUMIFS($D$6:$D$58,$C$6:$C$58,I6)","v":300000},{"$f":"++SUMIFS($E$6:$E$58,$C$6:$C$58,I6)","v":5000},{"$f":"+J6+K6-L6","v":295000}]
["2017-07-20","Trả nợ gốc lần 1","Vay ngân hàng",null,5000,null,null,2,"Vay mua xe",5000,{"$f":"+SUMIFS($D$6:$D$58,$C$6:$C$58,I7)","v":0},{"$f":"++SUMIFS($E$6:$E$58,$C$6:$C$58,I7)","v":0},{"$f":"+J7+K7-L7","v":5000}]
["2017-07-30","Nợ thẻ tín dụng tháng 7","Thẻ tín dụng",50000,null,null,null,3,"Vay A Hải",null,0,0,0]
[null,null,null,null,null,null,null,4,"Thẻ tín dụng",null,50000,0,50000]
[null,null,null,null,null,null,null,5,null,null,0,0,0]
[null,null,null,null,null,null,null,6,null,null,0,0,0]
[null,null,null,null,null,null,null,7,null,null,0,0,0]
[null,null,null,null,null,null,null,8,null,null,0,0,0]
[null,null,null,null,null,null,null,9,null,null,0,0,0]
[null,null,null,null,null,null,null,10,null,null,0,0,0]
[null,null,null,null,null,null,null,11,null,null,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[".",".",".",".",".",".",".",".",".","."]