{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Ngân sách Chi phí"],"not_rendered":{"charts":2,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Ngân sách Chi phí","index":0,"n_rows":47,"n_cols":7,"rows_kept":47,"merged":[[0,1,0,4],[0,5,0,6],[16,1,16,6],[47,1,47,6]]}
[null,"Ngân sách Chi phí",{"$nulls":3},"CONTOSO, 2013"]
[]
[]
[null," NGÂN SÁCH NHÂN VIÊN"]
{"$rows_empty":7}
[null,"TRẠNG THÁI","NHÂN VIÊN","NGÂN SÁCH","THỰC TẾ","CHÊNH LỆCH (₫)","CHÊNH LỆCH (%)"]
[null,{"$f":"IFERROR(tblPersonnelExpenses[[#This Row],[THỰC TẾ]]/tblPersonnelExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":{"v":1.13,"d":"$1.13"}},"Văn phòng",{"v":10400000,"d":"10,400,000.00 ₫"},{"v":11752000,"d":"11,752,000.00 ₫"},{"$f":"tblPersonnelExpenses[[#This Row],[NGÂN SÁCH]]-tblPersonnelExpenses[[#This Row],[THỰC TẾ]]","v":{"v":-1352000,"d":"-1,352,000 ₫"}},{"$f":"IFERROR(tblPersonnelExpenses[CHÊNH LỆCH (₫)]/tblPersonnelExpenses[NGÂN SÁCH],\"\")","v":{"v":-0.13,"d":"-13%"}}]
[null,{"$f":"IFERROR(tblPersonnelExpenses[[#This Row],[THỰC TẾ]]/tblPersonnelExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":{"v":1.2,"d":"$1.20"}},"Cửa hàng",{"v":2600000,"d":"2,600,000.00 ₫"},{"v":3120000,"d":"3,120,000.00 ₫"},{"$f":"tblPersonnelExpenses[[#This Row],[NGÂN SÁCH]]-tblPersonnelExpenses[[#This Row],[THỰC TẾ]]","v":{"v":-520000,"d":"-520,000 ₫"}},{"$f":"IFERROR(tblPersonnelExpenses[CHÊNH LỆCH (₫)]/tblPersonnelExpenses[NGÂN SÁCH],\"\")","v":{"v":-0.2,"d":"-20%"}}]
[null,{"$f":"IFERROR(tblPersonnelExpenses[[#This Row],[THỰC TẾ]]/tblPersonnelExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":{"v":1,"d":"$1.00"}},"Nhân viên bán hàng",{"v":2080000,"d":"2,080,000.00 ₫"},{"v":2080000,"d":"2,080,000.00 ₫"},{"$f":"tblPersonnelExpenses[[#This Row],[NGÂN SÁCH]]-tblPersonnelExpenses[[#This Row],[THỰC TẾ]]","v":{"v":0,"d":"0 ₫"}},{"$f":"IFERROR(tblPersonnelExpenses[CHÊNH LỆCH (₫)]/tblPersonnelExpenses[NGÂN SÁCH],\"\")","v":{"v":0,"d":"0%"}}]
[null,{"$f":"IFERROR(tblPersonnelExpenses[[#This Row],[THỰC TẾ]]/tblPersonnelExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":{"v":0.9,"d":"$0.90"}},"Khác",{"v":2080000,"d":"2,080,000.00 ₫"},{"v":1872000,"d":"1,872,000.00 ₫"},{"$f":"tblPersonnelExpenses[[#This Row],[NGÂN SÁCH]]-tblPersonnelExpenses[[#This Row],[THỰC TẾ]]","v":{"v":208000,"d":"208,000 ₫"}},{"$f":"IFERROR(tblPersonnelExpenses[CHÊNH LỆCH (₫)]/tblPersonnelExpenses[NGÂN SÁCH],\"\")","v":{"v":0.1,"d":"10%"}}]
[]
[]
[null," NGÂN SÁCH HOẠT ĐỘNG"]
{"$rows_empty":7}
[null,"TRẠNG THÁI","HOẠT ĐỘNG","NGÂN SÁCH","THỰC TẾ","CHÊNH LỆCH (₫)","CHÊNH LỆCH (%)"]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[THỰC TẾ]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":{"v":0.98,"d":"$0.98"}},"Quảng cáo",{"v":5200000,"d":"5,200,000 ₫"},{"v":5096000,"d":"5,096,000 ₫"},{"$f":"tblOperatingExpenses[[#This Row],[NGÂN SÁCH]]-tblOperatingExpenses[[#This Row],[THỰC TẾ]]","v":{"v":104000,"d":"104,000 ₫"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[CHÊNH LỆCH (₫)]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":{"v":0.02,"d":"2%"}}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[THỰC TẾ]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":{"v":1.2,"d":"$1.20"}},"Nợ",{"v":2600000,"d":"2,600,000 ₫"},{"v":3120000,"d":"3,120,000 ₫"},{"$f":"tblOperatingExpenses[[#This Row],[NGÂN SÁCH]]-tblOperatingExpenses[[#This Row],[THỰC TẾ]]","v":{"v":-520000,"d":"-520,000 ₫"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[CHÊNH LỆCH (₫)]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":{"v":-0.2,"d":"-20%"}}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[THỰC TẾ]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":{"v":1,"d":"$1.00"}},"Phúc lợi",{"v":2080000,"d":"2,080,000 ₫"},{"v":2080000,"d":"2,080,000 ₫"},{"$f":"tblOperatingExpenses[[#This Row],[NGÂN SÁCH]]-tblOperatingExpenses[[#This Row],[THỰC TẾ]]","v":{"v":0,"d":"0 ₫"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[CHÊNH LỆCH (₫)]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":{"v":0,"d":"0%"}}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[THỰC TẾ]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":{"v":0.9,"d":"$0.90"}},"Vật dụng",{"v":2080000,"d":"2,080,000 ₫"},{"v":1872000,"d":"1,872,000 ₫"},{"$f":"tblOperatingExpenses[[#This Row],[NGÂN SÁCH]]-tblOperatingExpenses[[#This Row],[THỰC TẾ]]","v":{"v":208000,"d":"208,000 ₫"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[CHÊNH LỆCH (₫)]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":{"v":0.1,"d":"10%"}}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[THỰC TẾ]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""},"Bưu phí",null,null,{"$f":"tblOperatingExpenses[[#This Row],[NGÂN SÁCH]]-tblOperatingExpenses[[#This Row],[THỰC TẾ]]","v":{"v":0,"d":"0 ₫"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[CHÊNH LỆCH (₫)]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[THỰC TẾ]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""},"Phí thuê hoặc mua nhà trả góp",null,null,{"$f":"tblOperatingExpenses[[#This Row],[NGÂN SÁCH]]-tblOperatingExpenses[[#This Row],[THỰC TẾ]]","v":{"v":0,"d":"0 ₫"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[CHÊNH LỆCH (₫)]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[THỰC TẾ]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""},"Chi phí kinh doanh",null,null,{"$f":"tblOperatingExpenses[[#This Row],[NGÂN SÁCH]]-tblOperatingExpenses[[#This Row],[THỰC TẾ]]","v":{"v":0,"d":"0 ₫"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[CHÊNH LỆCH (₫)]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[THỰC TẾ]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""},"Thuế",null,null,{"$f":"tblOperatingExpenses[[#This Row],[NGÂN SÁCH]]-tblOperatingExpenses[[#This Row],[THỰC TẾ]]","v":{"v":0,"d":"0 ₫"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[CHÊNH LỆCH (₫)]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[THỰC TẾ]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""},"Phí tiện ích",null,null,{"$f":"tblOperatingExpenses[[#This Row],[NGÂN SÁCH]]-tblOperatingExpenses[[#This Row],[THỰC TẾ]]","v":{"v":0,"d":"0 ₫"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[CHÊNH LỆCH (₫)]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[THỰC TẾ]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""},"Khác",null,null,{"$f":"tblOperatingExpenses[[#This Row],[NGÂN SÁCH]]-tblOperatingExpenses[[#This Row],[THỰC TẾ]]","v":{"v":0,"d":"0 ₫"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[CHÊNH LỆCH (₫)]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[THỰC TẾ]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""},"Bảo hiểm",null,null,{"$f":"tblOperatingExpenses[[#This Row],[NGÂN SÁCH]]-tblOperatingExpenses[[#This Row],[THỰC TẾ]]","v":{"v":0,"d":"0 ₫"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[CHÊNH LỆCH (₫)]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[THỰC TẾ]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""},"Lãi",null,null,{"$f":"tblOperatingExpenses[[#This Row],[NGÂN SÁCH]]-tblOperatingExpenses[[#This Row],[THỰC TẾ]]","v":{"v":0,"d":"0 ₫"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[CHÊNH LỆCH (₫)]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[THỰC TẾ]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""},"Điện thoại",null,null,{"$f":"tblOperatingExpenses[[#This Row],[NGÂN SÁCH]]-tblOperatingExpenses[[#This Row],[THỰC TẾ]]","v":{"v":0,"d":"0 ₫"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[CHÊNH LỆCH (₫)]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[THỰC TẾ]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""},"Bảo trì và sửa chữa",null,null,{"$f":"tblOperatingExpenses[[#This Row],[NGÂN SÁCH]]-tblOperatingExpenses[[#This Row],[THỰC TẾ]]","v":{"v":0,"d":"0 ₫"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[CHÊNH LỆCH (₫)]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[THỰC TẾ]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""},"Phí Pháp lý",null,null,{"$f":"tblOperatingExpenses[[#This Row],[NGÂN SÁCH]]-tblOperatingExpenses[[#This Row],[THỰC TẾ]]","v":{"v":0,"d":"0 ₫"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[CHÊNH LỆCH (₫)]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[THỰC TẾ]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""},"Khấu hao",null,null,{"$f":"tblOperatingExpenses[[#This Row],[NGÂN SÁCH]]-tblOperatingExpenses[[#This Row],[THỰC TẾ]]","v":{"v":0,"d":"0 ₫"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[CHÊNH LỆCH (₫)]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[THỰC TẾ]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""},"Vận chuyển",null,null,{"$f":"tblOperatingExpenses[[#This Row],[NGÂN SÁCH]]-tblOperatingExpenses[[#This Row],[THỰC TẾ]]","v":{"v":0,"d":"0 ₫"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[CHÊNH LỆCH (₫)]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[THỰC TẾ]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""},"Kho",null,null,{"$f":"tblOperatingExpenses[[#This Row],[NGÂN SÁCH]]-tblOperatingExpenses[[#This Row],[THỰC TẾ]]","v":{"v":0,"d":"0 ₫"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[CHÊNH LỆCH (₫)]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[THỰC TẾ]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""},"Khác",null,null,{"$f":"tblOperatingExpenses[[#This Row],[NGÂN SÁCH]]-tblOperatingExpenses[[#This Row],[THỰC TẾ]]","v":{"v":0,"d":"0 ₫"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[CHÊNH LỆCH (₫)]]/tblOperatingExpenses[[#This Row],[NGÂN SÁCH]],\"\")","v":""}]
[null,null,"Tổng Chi phí",{"$f":"SUBTOTAL(109,tblOperatingExpenses[NGÂN SÁCH],tblPersonnelExpenses[NGÂN SÁCH])","v":{"v":29120000,"d":"29,120,000 ₫"}},{"$f":"SUBTOTAL(109,tblOperatingExpenses[THỰC TẾ],tblPersonnelExpenses[THỰC TẾ])","v":{"v":30992000,"d":"30,992,000 ₫"}},{"$f":"SUBTOTAL(109,tblOperatingExpenses[CHÊNH LỆCH (₫)],tblPersonnelExpenses[CHÊNH LỆCH (₫)])","v":{"v":-1872000,"d":"-1,872,000 ₫"}},{"$f":"IFERROR(SUM(tblOperatingExpenses[[#Totals],[CHÊNH LỆCH (₫)]]/tblOperatingExpenses[[#Totals],[NGÂN SÁCH]]),\"\")","v":{"v":-0.06428571428571428,"d":"-6%"}}]