{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["D.S Việc cần làm Dự án 1","Thiết đặt& Tính toán"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"D.S Việc cần làm Dự án 1","index":0,"n_rows":18,"n_cols":9,"rows_kept":18}
[{"$nulls":8}," "]
[{"$nulls":7}," "]
[null,"Danh sách Việc cần Làm cho Dự án"]
[]
[null,"Sẽ được hoàn thành vào:",null,null,"Hạn chót:",null,"Tô sáng Hoạt động"]
[null,"Kim Abercrombie",null,null,{"$f":"TODAY()+95","v":"2013-01-15"},null,"     Tuần này [18 tháng Sáu - 24 tháng Sáu]"]
[]
[null,"Dự án 1"]
[null,"Hoạt động","Đến hạn Vào","Ngân sách","Đã thực hiện %","Tiến độ","Ghi chú"," "]
[null,"Lập kế hoạch",{"$f":"TODAY()-90","v":"2012-07-14"},{"v":990080,"d":"990,080 ₫"},{"v":0.25,"d":"25%"},{"$f":"tblToDoList[[#This Row],[Đã thực hiện %]]","v":{"v":0.25,"d":"25%"}}]
[null,"Chuẩn bị",{"$f":"TODAY()-2","v":"2012-10-10"},{"v":626080,"d":"626,080 ₫"},{"v":0.1,"d":"10%"},{"$f":"tblToDoList[[#This Row],[Đã thực hiện %]]","v":{"v":0.1,"d":"10%"}}]
[null,"Nhiệm vụ A",{"$f":"TODAY()-7","v":"2012-10-05"},{"v":892320,"d":"892,320 ₫"},{"v":0,"d":"0%"},{"$f":"tblToDoList[[#This Row],[Đã thực hiện %]]","v":{"v":0,"d":"0%"}}]
[null,"Nhiệm vụ B",{"$f":"TODAY()+20","v":"2012-11-01"},{"v":690560,"d":"690,560 ₫"},{"v":0.7,"d":"70%"},{"$f":"tblToDoList[[#This Row],[Đã thực hiện %]]","v":{"v":0.7,"d":"70%"}}]
[null,"Nhiệm vụ C",{"$f":"TODAY()+40","v":"2012-11-21"},{"v":979680,"d":"979,680 ₫"},{"v":0.1,"d":"10%"},{"$f":"tblToDoList[[#This Row],[Đã thực hiện %]]","v":{"v":0.1,"d":"10%"}}]
[null,"Nhiệm vụ D",{"$f":"TODAY()+45","v":"2012-11-26"},{"v":869440,"d":"869,440 ₫"},{"v":1,"d":"100%"},{"$f":"tblToDoList[[#This Row],[Đã thực hiện %]]","v":{"v":1,"d":"100%"}}]
[null,"Công việc giấy tờ",{"$f":"TODAY()+55","v":"2012-12-06"},{"v":312000,"d":"312,000 ₫"},{"v":0,"d":"0%"},{"$f":"tblToDoList[[#This Row],[Đã thực hiện %]]","v":{"v":0,"d":"0%"}},"Bắt đầu Sau khi Nhiệm vụ B Hoàn tất"]
[null,"Chuyển",{"$f":"TODAY()+70","v":"2012-12-21"},{"v":686400,"d":"686,400 ₫"},{"v":0.25,"d":"25%"},{"$f":"tblToDoList[[#This Row],[Đã thực hiện %]]","v":{"v":0.25,"d":"25%"}}]
[null,"Theo dõi",{"$f":"TODAY()+90","v":"2013-01-10"},{"v":734240,"d":"734,240 ₫"},{"v":0.5,"d":"50%"},{"$f":"tblToDoList[[#This Row],[Đã thực hiện %]]","v":{"v":0.5,"d":"50%"}}]

{"sheet":"Thiết đặt& Tính toán","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[3,1,3,4]]}
[]
[{"$nulls":5}," "]
[null,"Tô sáng Thiết đặt"]
[null,"Các bảng dưới đây lưu trữ các thiết đặt và tính toán cho danh sách thả xuống Tô sáng Hoạt động. Bất kỳ thay đổi nào cũng có thể gây ra lỗi hoặc mất chức năng.\n"]
[null,"Không Tô sáng",null,null,{"$f":"B5","v":"Không Tô sáng"}]
[null,"Khoảng","Ngày Bắt đầu:","Ngày kết thúc:","Đến hạn:"]
[null,"     Tuần này",{"$f":"TODAY()-WEEKDAY(TODAY(),2)+1","v":"2012-10-08"},{"$f":"C7+6","v":"2012-10-14"},{"$f":"B7&\" [\"&TEXT(C7,\"d mmm\")&\" - \"&TEXT(D7,\"d mmm\")&\"]\"","v":"     Tuần này [8 Thg10 - 14 Thg10]"}]
[null,"     Tháng này",{"$f":"EOMONTH(TODAY(),-1)+1","v":"2012-10-01"},{"$f":"EDATE(C8,1)-1","v":"2012-10-31"},{"$f":"B8&\" [\"&TEXT(C8,\"d\")&\" - \"&TEXT(D8,\"d, mmm\")&\"]\"","v":"     Tháng này [1 - 31, Thg10]"}]
[null,"     Quý này",{"$f":"DATE(YEAR(TODAY()),INT(MONTH(TODAY())/3)+1,1)","v":"2012-04-01"},{"$f":"EDATE(C9,4)-1","v":"2012-07-31"},{"$f":"B9&\" [\"&TEXT(C9,\"d mmm\")&\" - \"&TEXT(D9,\"d mmm\")&\"]\"","v":"     Quý này [1 Thg4 - 31 Thg7]"}]
[null,"     Năm này",{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2012-01-01"},{"$f":"EDATE(C10,12)-1","v":"2012-12-31"},{"$f":"B10&\" [\"&TEXT(C10,\"yyyy\")&\"]\"","v":"     Năm này [2012]"}]
[null,"Khoảng",null,null,{"$f":"B11","v":"Khoảng"}]
[null,"     Tuần trước",{"$f":"C7-7","v":"2012-10-01"},{"$f":"C12+6","v":"2012-10-07"},{"$f":"B12&\" [\"&TEXT(C12,\"d mmm\")&\" - \"&TEXT(D12,\"d mmm\")&\"]\"","v":"     Tuần trước [1 Thg10 - 7 Thg10]"}]
[null,"     Tháng trước",{"$f":"EDATE(C8,-1)","v":"2012-09-01"},{"$f":"EDATE(C13,1)-1","v":"2012-09-30"},{"$f":"B13&\" [\"&TEXT(C13,\"d\")&\" - \"&TEXT(D13,\"d, mmm\")&\"]\"","v":"     Tháng trước [1 - 30, Thg9]"}]
[null,"     Quý trước",{"$f":"EDATE(C9,-3)","v":"2012-01-01"},{"$f":"EDATE(C14,3)-1","v":"2012-03-31"},{"$f":"B14&\" [\"&TEXT(C14,\"d mmm\")&\" - \"&TEXT(D14,\"d mmm\")&\"]\"","v":"     Quý trước [1 Thg1 - 31 Thg3]"}]
[null,"     Năm trước",{"$f":"EDATE(C10,-12)","v":"2011-01-01"},{"$f":"EDATE(C15,12)-1","v":"2011-12-31"},{"$f":"B15","v":"     Năm trước"}]
[]
[null,"Vùng Tô sáng Được chọn:",{"$f":"IFERROR(MATCH(HighlightActivities,lstToDoHighlights,0),\"\")-1","v":{"$error":"#VALUE!"}},{"$f":"HighlightActivities","v":"     Tuần này [18 tháng Sáu - 24 tháng Sáu]"},{"$f":"ISNUMBER(INDEX($C$6:$C$15,C17))","v":false}]
[null,"Tô sáng Ngày bắt đầu",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($C$6:$C$15,$C$17),\"\")),\"\")","v":""}]
[null,"Tô sáng Ngày kết thúc",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($D$6:$D$15,$C$17),\"\")),\"\")","v":""}]