{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Báo cáo Chi phí"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Báo cáo Chi phí","index":0,"n_rows":45,"n_cols":10,"rows_kept":45,"merged":[[18,1,18,9],[27,1,27,9],[35,1,35,9],[40,1,43,4]]}
["TÊN CÔNG TY"]
["BÁO CÁO CHI PHÍ"]
[]
[null,"NHÂN VIÊN:","Kim Abercrombie",{"$nulls":3},"NGƯỜI PHÊ DUYỆT:"]
[null,"PHÒNG:","Bán hàng"]
[null,"KẾT THÚC TUẦN:","2013-03-07",{"$nulls":3},"NGÀY:"]
[null,"TỶ LỆ SỐ DẶM:",{"v":0.67,"d":"0.67 ₫"}]
[]
[null,null,{"$f":"UPPER(TEXT(C10,\"dddd\"))","v":"THỨ SÁU"},{"$f":"UPPER(TEXT(D10,\"dddd\"))","v":"THỨ BẢY"},"CHỦ NHẬT","THỨ HAI","THỨ BA","THỨ TƯ","THỨ NĂM"]
[null,"PHƯƠNG TIỆN ĐI LẠI",{"$f":"WeekEnding-6","v":"2013-03-01"},{"$f":"WeekEnding-5","v":"2013-03-02"},{"$f":"WeekEnding-4","v":"2013-03-03"},{"$f":"WeekEnding-3","v":"2013-03-04"},{"$f":"WeekEnding-2","v":"2013-03-05"},{"$f":"WeekEnding-1","v":"2013-03-06"},{"$f":"WeekEnding","v":"2013-03-07"},"TỔNG"]
[null,"Số Dặm đã Đi",{"v":3016000,"d":"3,016,000 "},{"$nulls":6},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":3016000,"d":"3,016,000 "}}]
[null,"Tiền hoàn theo dặm",{"$f":"C11*MileageRate","v":{"v":2020720.0000000002,"d":"2,020,720.00 ₫"}},{"v":0,"d":"0.00 ₫"},{"v":0,"d":"0.00 ₫"},{"v":0,"d":"0.00 ₫"},{"v":0,"d":"0.00 ₫"},{"v":0,"d":"0.00 ₫"},{"v":0,"d":"0.00 ₫"},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":2020720.0000000002,"d":"2,020,720.00 ₫"}}]
[null,"Đỗ xe và Phí cầu đường",{"$nulls":3},{"v":353600,"d":"353,600.00 ₫"},{"$nulls":3},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":353600,"d":"353,600.00 ₫"}}]
[null,"Thuê xe",{"v":1643200,"d":"1,643,200.00 ₫"},null,null,{"v":1643200,"d":"1,643,200.00 ₫"},{"$nulls":3},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":3286400,"d":"3,286,400.00 ₫"}}]
[null,"Taxi / Limo",{"$nulls":7},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"0.00 ₫"}}]
[null,"Chi phí khác (Tàu hỏa hoặc Xe buýt)",{"$nulls":7},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"0.00 ₫"}}]
[null,"Vé máy bay",{"$nulls":3},{"v":4888000,"d":"4,888,000.00 ₫"},{"$nulls":3},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":4888000,"d":"4,888,000.00 ₫"}}]
[null,"TỔNG",{"$f":"SUBTOTAL(109,C12:C17)","v":{"v":3663920,"d":"3,663,920.00 ₫"}},{"$f":"SUBTOTAL(109,D12:D17)","v":{"v":0,"d":"0.00 ₫"}},null,{"$f":"SUBTOTAL(109,F12:F17)","v":{"v":6884800,"d":"6,884,800.00 ₫"}},{"$f":"SUBTOTAL(109,G12:G17)","v":{"v":0,"d":"0.00 ₫"}},{"$f":"SUBTOTAL(109,H12:H17)","v":{"v":0,"d":"0.00 ₫"}},{"$f":"SUBTOTAL(109,I12:I17)","v":{"v":0,"d":"0.00 ₫"}},{"$f":"SUM(J12:J17)","v":{"v":10548720,"d":"10,548,720.00 ₫"}}]
[]
[null,"CHỖ Ở & BỮA ĂN"]
[null,"Chỗ ở",{"v":3016000,"d":"3,016,000.00 ₫"},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":3016000,"d":"3,016,000.00 ₫"}}]
[null,"Bữa sáng",{"v":238992,"d":"238,992.00 ₫"},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":238992,"d":"238,992.00 ₫"}}]
[null,"Bữa trưa",{"v":249600,"d":"249,600.00 ₫"},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":249600,"d":"249,600.00 ₫"}}]
[null,"Bữa tối",{"v":353600,"d":"353,600.00 ₫"},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":353600,"d":"353,600.00 ₫"}}]
[null,"Bữa ăn nhẹ",{"v":236912,"d":"236,912.00 ₫"},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":236912,"d":"236,912.00 ₫"}}]
[null,"Tổng phụ Bữa ăn",{"v":842192,"d":"842,192.00 ₫"},{"$f":"SUM(D22:D24)","v":{"v":0,"d":"0.00 ₫"}},{"v":0,"d":"0.00 ₫"},{"v":0,"d":"0.00 ₫"},{"v":0,"d":"0.00 ₫"},{"v":0,"d":"0.00 ₫"},{"v":0,"d":"0.00 ₫"},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":842192,"d":"842,192.00 ₫"}}]
[null,"TỔNG",{"$f":"SUBTOTAL(109,C21,C26)","v":{"v":3858192,"d":"3,858,192.00 ₫"}},{"$f":"SUBTOTAL(109,D21,D26)","v":{"v":0,"d":"0.00 ₫"}},{"v":0,"d":"0.00 ₫"},{"v":0,"d":"0.00 ₫"},{"v":0,"d":"0.00 ₫"},{"v":0,"d":"0.00 ₫"},{"v":0,"d":"0.00 ₫"},{"$f":"SUBTOTAL(109,J21,J26)","v":{"v":3858192,"d":"3,858,192.00 ₫"}}]
[]
[null,"LINH TINH"]
[null,"Vật tư",{"$nulls":7},{"$f":"SUM(Misc[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"0.00 ₫"}}]
[null,"Thiết bị",{"$nulls":7},{"$f":"SUM(Misc[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"0.00 ₫"}}]
[null,"Điện thoại, Fax, Internet",{"$nulls":7},{"$f":"SUM(Misc[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"0.00 ₫"}}]
[null,"Chi phí khác*",{"$nulls":7},{"$f":"SUM(Misc[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"0.00 ₫"}}]
[null,"Giải trí*",{"$nulls":3},{"v":4139200,"d":"4,139,200.00 ₫"},{"$nulls":3},{"$f":"SUM(Misc[[#This Row],[Day 1]:[Day 7]])","v":{"v":4139200,"d":"4,139,200.00 ₫"}}]
[null,"TỔNG",{"$f":"SUBTOTAL(109,Misc[Day 1])","v":{"v":0,"d":"0.00 ₫"}},{"$f":"SUBTOTAL(109,Misc[Day 2])","v":{"v":0,"d":"0.00 ₫"}},{"$f":"SUBTOTAL(109,Misc[Day 3])","v":{"v":0,"d":"0.00 ₫"}},{"$f":"SUBTOTAL(109,Misc[Day 4])","v":{"v":4139200,"d":"4,139,200.00 ₫"}},{"$f":"SUBTOTAL(109,Misc[Day 5])","v":{"v":0,"d":"0.00 ₫"}},{"$f":"SUBTOTAL(109,Misc[Day 6])","v":{"v":0,"d":"0.00 ₫"}},{"$f":"SUBTOTAL(109,Misc[Day 7])","v":{"v":0,"d":"0.00 ₫"}},{"$f":"SUBTOTAL(109,Misc[Total])","v":{"v":4139200,"d":"4,139,200.00 ₫"}}]
[]
[null,"TỔNG SỐ",{"$f":"SUM(Misc[[#Totals],[Day 1]],LodgingMeals[[#Totals],[Day 1]],Transportation[[#Totals],[Day 1]])","v":{"v":7522112,"d":"7,522,112.00 ₫"}},{"$f":"SUM(Misc[[#Totals],[Day 2]],LodgingMeals[[#Totals],[Day 2]],Transportation[[#Totals],[Day 2]])","v":{"v":0,"d":"0.00 ₫"}},{"$f":"SUM(Misc[[#Totals],[Day 3]],LodgingMeals[[#Totals],[Day 3]],Transportation[[#Totals],[Day 3]])","v":{"v":0,"d":"0.00 ₫"}},{"$f":"SUM(Misc[[#Totals],[Day 4]],LodgingMeals[[#Totals],[Day 4]],Transportation[[#Totals],[Day 4]])","v":{"v":11024000,"d":"11,024,000.00 ₫"}},{"$f":"SUM(Misc[[#Totals],[Day 5]],LodgingMeals[[#Totals],[Day 5]],Transportation[[#Totals],[Day 5]])","v":{"v":0,"d":"0.00 ₫"}},{"$f":"SUM(Misc[[#Totals],[Day 6]],LodgingMeals[[#Totals],[Day 6]],Transportation[[#Totals],[Day 6]])","v":{"v":0,"d":"0.00 ₫"}},{"$f":"SUM(Misc[[#Totals],[Day 7]],LodgingMeals[[#Totals],[Day 7]],Transportation[[#Totals],[Day 7]])","v":{"v":0,"d":"0.00 ₫"}},{"$f":"SUM(Misc[[#Totals],[Total]],LodgingMeals[[#Totals],[Total]],Transportation[[#Totals],[Total]])","v":{"v":18546112,"d":"18,546,112.00 ₫"}}]
[]
[{"$nulls":9},"TỔNG CHI PHÍ"]
[null,"*Mục đính Công việc đối với mục \"Giải trí\" và \"Chi phí khác\"",{"$nulls":7},{"$f":"SUM(J18,J27,J35)","v":{"v":18546112,"d":"18,546,112.00 ₫"}}]
[{"$nulls":9},"KHOẢN ỨNG TRƯỚC"]
[]
[{"$nulls":9},"TỔNG TIỀN HOÀN LẠI"]
[{"$nulls":9},{"$f":"J40-J42","v":{"v":18546112,"d":"18,546,112.00 ₫"}}]
[{"$nulls":9},"Vui lòng đính kèm tất cả các biên nhận"]