{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Bảng điều khiển","Danh sách Thiết bị","Dữ liệu Pivot"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"comments":0,"pivot_tables":1},"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":"Bảng điều khiển","index":0,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"Bảng điều khiển"]
[]
[]
[null,null,null,null,null,"Tổng số"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Số lượng\",'Dữ liệu Pivot'!$B$11)","v":3}]
[]
[null,null,null,null,null,"Tổng Chi phí Hàng tháng"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Tổng của Tổng Chi phí Hàng tháng2\",'Dữ liệu Pivot'!$B$11)","v":36724361.512942836}]
[]
[null,null,null,null,null,"Chi phí Vận hành"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Chi phí Hoạt động\",'Dữ liệu Pivot'!$B$11)","v":12584000}]
[]
[null,null,null,null,null,"Khấu hao Hàng tháng"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Khấu hao Hàng tháng \",'Dữ liệu Pivot'!$B$11)","v":13722222.222222222}]
[]
[null,null,null,null,null,"Số tiền Thanh toán"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Số tiền Thanh toán\",'Dữ liệu Pivot'!$B$11)","v":24140361.512942839}]
[]
[null,null,null,null,null,"Giá trị Hiện tại"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Giá trị Hiện tại \",'Dữ liệu Pivot'!$B$11)","v":747294611.87214613}]

{"sheet":"Danh sách Thiết bị","index":1,"n_rows":9,"n_cols":20,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"Danh sách Thiết bị"]
[]
[null,null,null,"Tô sáng khi thanh toán hàng tháng còn lại ít hơn:",20]
[]
[null,"Tài sản hoặc\nSố Sê-ri","Mô tả Mặt hàng\n(Nhà sản xuất và Mẫu)","Địa điểm","Điều kiện","Nhà cung cấp","Năm\nSử dụng Còn lại ","Giá trị Ban đầu","Tiền trả trước","Ngày Mua\nhoặc Thuê","Thời hạn cho Vay (Năm)","Lãi suất cho Vay","Chi phí Vận hành\nHàng tháng","Giá trị Kỳ Vọng khi Hết Hợp đồng","Thanh toán Còn lại Hàng tháng","Thanh toán Hàng tháng","Tổng Chi phí Hàng tháng","Khấu hao Hàng năm\n(Đường Thẳng)","Khấu hao Hàng tháng\n(Đường Thẳng)","Giá trị Hiện tại"]
[null,123,"Nhà sản xuất Mẫu 1","Chi nhánh Chính","Tốt","Địa phương",5,624000000,104000000,"2011-01-15",4,0.1,4160000,416000000,{"$f":"IFERROR(SUMPRODUCT(--(DAY(ROW(OFFSET($A$1,,,DATE(YEAR(Equipment[[#This Row],[Ngày Mua\nhoặc Thuê]])+Equipment[[#This Row],[Thời hạn cho Vay (Năm)]],MONTH(Equipment[[#This Row],[Ngày Mua\nhoặc Thuê]])-1,DAY(Equipment[[#This Row],[Ngày Mua\nhoặc Thuê]]))-TODAY()))+DATE(YEAR(Equipment[[#This Row],[Ngày Mua\nhoặc Thuê]])+Equipment[[#This Row],[Thời hạn cho Vay (Năm)]],MONTH(Equipment[[#This Row],[Ngày Mua\nhoặc Thuê]]),DAY(Equipment[[#This Row],[Ngày Mua\nhoặc Thuê]]))-1)=DAY(Equipment[[#This Row],[Ngày Mua\nhoặc Thuê]]))),0)","v":23},{"$f":"IFERROR(-(Equipment[Giá trị Ban đầu]>0)*(Equipment[Giá trị Ban đầu]<>Equipment[Tiền trả trước])*PMT(Equipment[Lãi suất cho Vay]/MonthsInYear,Equipment[Thời hạn cho Vay (Năm)]*MonthsInYear,Equipment[Giá trị Ban đầu]-Equipment[Tiền trả trước]),0)","v":13188543.386068538},{"$f":"Equipment[[#This Row],[Thanh toán Hàng tháng]]+Equipment[Chi phí Vận hành\nHàng tháng]","v":17348543.386068538},{"$f":"IFERROR((Equipment[Giá trị Ban đầu]>0)*SLN(Equipment[Giá trị Ban đầu],Equipment[Giá trị Kỳ Vọng khi Hết Hợp đồng],Equipment[Thời hạn cho Vay (Năm)]),0)","v":52000000},{"$f":"IFERROR(Equipment[Khấu hao Hàng năm\n(Đường Thẳng)]/MonthsInYear,0)","v":4333333.333333333},{"$f":"IFERROR(Equipment[Giá trị Ban đầu]-(Equipment[Khấu hao Hàng năm\n(Đường Thẳng)]*((TODAY()-Equipment[Ngày Mua\nhoặc Thuê])/DaysInYear)),0)","v":517008219.17808223}]
[null,234,"Nhà sản xuất Mẫu 2","Chi nhánh Chính","Tốt","Địa phương",4,260000000,31200000,"2011-03-10",3,7.7499999999999999E-2,2496000,62400000,{"$f":"IFERROR(SUMPRODUCT(--(DAY(ROW(OFFSET($A$1,,,DATE(YEAR(Equipment[[#This Row],[Ngày Mua\nhoặc Thuê]])+Equipment[[#This Row],[Thời hạn cho Vay (Năm)]],MONTH(Equipment[[#This Row],[Ngày Mua\nhoặc Thuê]])-1,DAY(Equipment[[#This Row],[Ngày Mua\nhoặc Thuê]]))-TODAY()))+DATE(YEAR(Equipment[[#This Row],[Ngày Mua\nhoặc Thuê]])+Equipment[[#This Row],[Thời hạn cho Vay (Năm)]],MONTH(Equipment[[#This Row],[Ngày Mua\nhoặc Thuê]]),DAY(Equipment[[#This Row],[Ngày Mua\nhoặc Thuê]]))-1)=DAY(Equipment[[#This Row],[Ngày Mua\nhoặc Thuê]]))),0)","v":13},{"$f":"IFERROR(-(Equipment[Giá trị Ban đầu]>0)*(Equipment[Giá trị Ban đầu]<>Equipment[Tiền trả trước])*PMT(Equipment[Lãi suất cho Vay]/MonthsInYear,Equipment[Thời hạn cho Vay (Năm)]*MonthsInYear,Equipment[Giá trị Ban đầu]-Equipment[Tiền trả trước]),0)","v":7143402.2415999137},{"$f":"Equipment[[#This Row],[Thanh toán Hàng tháng]]+Equipment[Chi phí Vận hành\nHàng tháng]","v":9639402.2415999137},{"$f":"IFERROR((Equipment[Giá trị Ban đầu]>0)*SLN(Equipment[Giá trị Ban đầu],Equipment[Giá trị Kỳ Vọng khi Hết Hợp đồng],Equipment[Thời hạn cho Vay (Năm)]),0)","v":65866666.666666664},{"$f":"IFERROR(Equipment[Khấu hao Hàng năm\n(Đường Thẳng)]/MonthsInYear,0)","v":5488888.888888889},{"$f":"IFERROR(Equipment[Giá trị Ban đầu]-(Equipment[Khấu hao Hàng năm\n(Đường Thẳng)]*((TODAY()-Equipment[Ngày Mua\nhoặc Thuê])/DaysInYear)),0)","v":134221735.15981734}]
[null,345,"Nhà sản xuất Mẫu 2","Chi nhánh 1","Khá","Khác",1,208000000,52000000,"2010-09-15",4,0.08,5928000,20800000,{"$f":"IFERROR(SUMPRODUCT(--(DAY(ROW(OFFSET($A$1,,,DATE(YEAR(Equipment[[#This Row],[Ngày Mua\nhoặc Thuê]])+Equipment[[#This Row],[Thời hạn cho Vay (Năm)]],MONTH(Equipment[[#This Row],[Ngày Mua\nhoặc Thuê]])-1,DAY(Equipment[[#This Row],[Ngày Mua\nhoặc Thuê]]))-TODAY()))+DATE(YEAR(Equipment[[#This Row],[Ngày Mua\nhoặc Thuê]])+Equipment[[#This Row],[Thời hạn cho Vay (Năm)]],MONTH(Equipment[[#This Row],[Ngày Mua\nhoặc Thuê]]),DAY(Equipment[[#This Row],[Ngày Mua\nhoặc Thuê]]))-1)=DAY(Equipment[[#This Row],[Ngày Mua\nhoặc Thuê]]))),0)","v":19},{"$f":"IFERROR(-(Equipment[Giá trị Ban đầu]>0)*(Equipment[Giá trị Ban đầu]<>Equipment[Tiền trả trước])*PMT(Equipment[Lãi suất cho Vay]/MonthsInYear,Equipment[Thời hạn cho Vay (Năm)]*MonthsInYear,Equipment[Giá trị Ban đầu]-Equipment[Tiền trả trước]),0)","v":3808415.8852743874},{"$f":"Equipment[[#This Row],[Thanh toán Hàng tháng]]+Equipment[Chi phí Vận hành\nHàng tháng]","v":9736415.8852743879},{"$f":"IFERROR((Equipment[Giá trị Ban đầu]>0)*SLN(Equipment[Giá trị Ban đầu],Equipment[Giá trị Kỳ Vọng khi Hết Hợp đồng],Equipment[Thời hạn cho Vay (Năm)]),0)","v":46800000},{"$f":"IFERROR(Equipment[Khấu hao Hàng năm\n(Đường Thẳng)]/MonthsInYear,0)","v":3900000},{"$f":"IFERROR(Equipment[Giá trị Ban đầu]-(Equipment[Khấu hao Hàng năm\n(Đường Thẳng)]*((TODAY()-Equipment[Ngày Mua\nhoặc Thuê])/DaysInYear)),0)","v":96064657.534246579}]
[null,"Tổng cộng",null,null,null,null,{"$f":"SUBTOTAL(101,Equipment[Năm\nSử dụng Còn lại ])","v":3.3333333333333335},{"$f":"SUBTOTAL(109,Equipment[Giá trị Ban đầu])","v":1092000000},{"$f":"SUBTOTAL(109,Equipment[Tiền trả trước])","v":187200000},null,{"$f":"SUBTOTAL(101,Equipment[Thời hạn cho Vay (Năm)])","v":3.6666666666666665},{"$f":"SUBTOTAL(101,Equipment[Lãi suất cho Vay])","v":8.5833333333333331E-2},{"$f":"SUBTOTAL(109,Equipment[Chi phí Vận hành\nHàng tháng])","v":12584000},{"$f":"SUBTOTAL(109,Equipment[Giá trị Kỳ Vọng khi Hết Hợp đồng])","v":499200000},{"$f":"SUBTOTAL(101,Equipment[Thanh toán Còn lại Hàng tháng])","v":18.333333333333332},{"$f":"SUBTOTAL(109,Equipment[Thanh toán Hàng tháng])","v":24140361.512942839},{"$f":"SUBTOTAL(109,Equipment[Tổng Chi phí Hàng tháng])","v":36724361.512942836},{"$f":"SUBTOTAL(101,Equipment[Khấu hao Hàng năm\n(Đường Thẳng)])","v":54888888.888888888},{"$f":"SUBTOTAL(101,Equipment[Khấu hao Hàng tháng\n(Đường Thẳng)])","v":4574074.0740740737},{"$f":"SUBTOTAL(109,Equipment[Giá trị Hiện tại])","v":747294611.87214613}]

{"sheet":"Dữ liệu Pivot","index":2,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[null,"Dữ liệu Pivot"]
[null,"Trang tính này nên được để ẩn. Thay đổi cấu trúc PivotTable trên trang này có thể gây ra lỗi ở Slicers Bảng điều khiển."]
[]
[null,"Mô tả Mặt hàng\n(Nhà sản xuất và Mẫu)","(Tất cả)"]
[null,"Địa điểm","(Tất cả)"]
[null,"Điều kiện","(Tất cả)"]
[null,"Nhà cung cấp","(Tất cả)"]
[null,"Năm \nSử dụng Còn lại ","(Tất cả)"]
[null,"Thời hạn cho Vay (Năm)","(Tất cả)"]
[]
[null,"Tài sản","Số lượng","Chi phí Hoạt động","Số tiền Thanh toán","Tổng của Tổng Chi phí Hàng tháng2","Khấu hao Hàng tháng ","Giá trị Hiện tại "]
[null,123,1,4160000,13188543.386068538,17348543.386068538,4333333.333333333,517008219.17808223]
[null,234,1,2496000,7143402.2415999137,9639402.2415999137,5488888.888888889,134221735.15981734]
[null,345,1,5928000,3808415.8852743874,9736415.8852743879,3900000,96064657.534246579]
[null,"Tổng Cuối",3,12584000,24140361.512942839,36724361.512942836,13722222.222222222,747294611.87214613]