{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Công cụ ước tính Tiết kiệm"],"not_rendered":{"charts":1,"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"Công cụ ước tính Tiết kiệm","index":0,"n_rows":28,"n_cols":7,"rows_kept":28,"merged":[[0,0,0,6],[4,2,4,4],[5,2,5,4],[5,5,5,6],[9,2,9,3],[10,2,10,3],[13,2,13,3],[17,2,17,3],[18,2,18,3]]}
["CHUYẾN ĐI NGHỈ ĐÔNG ĐẾN MÊ-HI-CÔ"]
[]
[]
[]
[null," Bắt đầu Tiết kiệm Vào:"," Kết thúc Tiết kiệm Vào:",{"$nulls":3}," Tiết kiệm Tiền:"]
[null,{"$f":"TODAY()-120","v":"2012-09-19"},{"$f":"DateSavingsBegin+180","v":"2013-03-18"},null,null,"Mỗi Hai Tuần"]
[]
[]
[]
[null,"CHI PHÍ CHUYẾN ĐI:",{"v":124800000,"d":"124,800,000 ₫"}]
[null,"KHOẢN TIẾT KIỆM TRƯỚC:",{"v":6240000,"d":"6,240,000 ₫"}]
[]
[]
[null,"MỤC TIÊU TIẾT KIỆM HIỆN TẠI:",{"$f":"EventCost-AmountSaved","v":{"v":118560000,"d":"118,560,000 ₫"}}]
[]
[]
[{"$f":"IF(SavingsPlanInfo>0,\" Nếu Tôi tiết kiệm \"&TEXT(SavingsPlanInfo,\" #.##0 ₫ \")&PROPER(SavingFrequency)&\", tính đến \"&TEXT(TODAY(),\"dd.mm.yy\"&\":\"),\"  Ngày Sự kiện Quá ngần cho \"&PROPER(SavingFrequency)&\" Kế hoạch Tiết kiệm\")","v":" Nếu Tôi tiết kiệm  9.880.000 ₫ MỗI Hai TuầN, tính đến 17.01.13:"}]
[null,"Tôi đã tiết kiệm:",{"$f":" IF(SavingsPlanInfo>0,IF(TODAY()>DateSavingsBegin,(TODAY()-DateSavingsBegin)*DailySavings,0)+AmountSaved,AmountSaved)","v":{"v":85280000,"d":"85,280,000.00 ₫"}}]
[null,"Tôi vẫn cần tiết kiệm:",{"$f":"MAX(0,EventCost-SavingsToDate)","v":{"v":39520000,"d":"39,520,000.00 ₫"}}]
[]
[]
[]
["CHI TIẾT KẾ HOẠCH TIẾT KIỆM"]
[null,"Khoảng Tiết kiệm","Hàng ngày","Hàng tuần","Mỗi Hai Tuần","Hàng tháng","Hàng năm"]
[null,"Số tiền cần tiết kiệm:",{"$f":"MIN(Goal,IF(DaysUntilEvent=\"\",0,Goal/DaysUntilEvent))","v":{"v":658666.6666666666,"d":"658,667 ₫"}},{"$f":"MIN(Goal,IF(WeeksUntilEvent=\"\",0,IF(ROUNDUP(WeeksUntilEvent,0)=0,0,Goal/WeeksUntilEvent)))","v":{"v":4610666.666666666,"d":"4,610,667 ₫"}},{"$f":"IF(OR(BiWeeksUntilEvent=0,BiWeeksUntilEvent=\"\"),0,MIN(Goal,IF(D25=\"\",0,Goal/BiWeeksUntilEvent)))","v":{"v":9880000,"d":"9,880,000 ₫"}},{"$f":"MIN(Goal,IF(Goal=\"\",0,IF(OR(MonthsUntilEvent=0,MonthsUntilEvent=\"\"),0,Goal/MonthsUntilEvent)))","v":{"v":23712000,"d":"23,712,000 ₫"}},{"$f":"IF(OR(Goal=\"\",Goal=0),0,IF(OR(YearsUntilEvent=0,YearsUntilEvent=\"\"),0,Goal/YearsUntilEvent))","v":{"v":0,"d":"0 ₫"}}]
[]
[null,"Khoảng Thời gian","Ngày","Tuần","Mỗi Hai Tuần","Tháng","Năm"]
[null,"Thời gian cho đến khi đạt được mục tiêu:",{"$f":"IF(DateSavingsBegin<>\"\",DATEDIF(DateSavingsBegin,EventDate,\"D\"),\"\")","v":180},{"$f":"IF(DaysUntilEvent<>\"\",DaysUntilEvent/7,\"\")","v":{"v":25.714285714285715,"d":"26"}},{"$f":"IF(OR(WeeksUntilEvent=0,WeeksUntilEvent=\"\"),0,ROUNDDOWN(WeeksUntilEvent/2,0))","v":12},{"$f":"IF(DateSavingsBegin<>\"\",DATEDIF(DateSavingsBegin,EventDate,\"M\"),\"\")","v":5},{"$f":"IF(DateSavingsBegin<>\"\",DATEDIF(DateSavingsBegin,EventDate,\"Y\"),\"\")","v":0}]