{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["專案 1 待辦事項清單","設定和計算"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"專案 1 待辦事項清單","index":0,"n_rows":18,"n_cols":8,"rows_kept":18}
[{"$nulls":7}," "]
[{"$nulls":7}," "]
[null,"專案待辦事項清單"]
[]
[null,"執行人：",null,null,"期限：",null,"醒目提示活動"]
[null,"黃安東",null,null,{"$f":"TODAY()+95","v":"2013-03-01"},null,"     本週 [6 月 18 日 - 24 日]"]
[]
[null,"專案 1"]
[null,"活動","到期日","預算","完成 %","進度","附註"," "]
[null,"規劃",{"$f":"TODAY()-90","v":"2012-08-28"},{"v":14280,"d":"NT$14,280"},{"v":0.25,"d":"25%"},{"$f":"tblToDoList[[#This Row],[完成 %]]","v":{"v":0.25,"d":"25%"}}]
[null,"準備工作",{"$f":"TODAY()-2","v":"2012-11-24"},{"v":9030,"d":"NT$9,030"},{"v":0.1,"d":"10%"},{"$f":"tblToDoList[[#This Row],[完成 %]]","v":{"v":0.1,"d":"10%"}}]
[null,"工作 A",{"$f":"TODAY()-7","v":"2012-11-19"},{"v":12870,"d":"NT$12,870"},{"v":0,"d":"0%"},{"$f":"tblToDoList[[#This Row],[完成 %]]","v":{"v":0,"d":"0%"}}]
[null,"工作 B",{"$f":"TODAY()+20","v":"2012-12-16"},{"v":9960,"d":"NT$9,960"},{"v":0.7,"d":"70%"},{"$f":"tblToDoList[[#This Row],[完成 %]]","v":{"v":0.7,"d":"70%"}}]
[null,"工作 C",{"$f":"TODAY()+40","v":"2013-01-05"},{"v":14130,"d":"NT$14,130"},{"v":0.1,"d":"10%"},{"$f":"tblToDoList[[#This Row],[完成 %]]","v":{"v":0.1,"d":"10%"}}]
[null,"工作 D",{"$f":"TODAY()+45","v":"2013-01-10"},{"v":12540,"d":"NT$12,540"},{"v":1,"d":"100%"},{"$f":"tblToDoList[[#This Row],[完成 %]]","v":{"v":1,"d":"100%"}}]
[null,"文書作業",{"$f":"TODAY()+55","v":"2013-01-20"},{"v":4500,"d":"NT$4,500"},{"v":0,"d":"0%"},{"$f":"tblToDoList[[#This Row],[完成 %]]","v":{"v":0,"d":"0%"}},"在工作 B 完成後開始"]
[null,"移交",{"$f":"TODAY()+70","v":"2013-02-04"},{"v":9900,"d":"NT$9,900"},{"v":0.25,"d":"25%"},{"$f":"tblToDoList[[#This Row],[完成 %]]","v":{"v":0.25,"d":"25%"}}]
[null,"後續追蹤",{"$f":"TODAY()+90","v":"2013-02-24"},{"v":10590,"d":"NT$10,590"},{"v":0.5,"d":"50%"},{"$f":"tblToDoList[[#This Row],[完成 %]]","v":{"v":0.5,"d":"50%"}}]

{"sheet":"設定和計算","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[3,1,3,4]]}
[]
[{"$nulls":5}," "]
[null,"醒目提示設定"]
[null,"下表會儲存醒目提示活動下拉式清單的設定和計算。任何變更可能會導致錯誤或影響功能。"]
[null,"無醒目提示",null,null,{"$f":"B5","v":"無醒目提示"}]
[null,"間隔：","開始時間：","結束時間：","期限："]
[null,"     本週",{"$f":"TODAY()-WEEKDAY(TODAY(),2)+1","v":"2012-11-26"},{"$f":"C7+6","v":"2012-12-02"},{"$f":"B7&\" [\"&TEXT(C7,\"[$-404]m月d日\")&\" - \"&TEXT(D7,\"[$-404]m月d日\")&\"]\"","v":"     本週 [11月26日 - 12月2日]"}]
[null,"     本月",{"$f":"EOMONTH(TODAY(),-1)+1","v":"2012-11-01"},{"$f":"EDATE(C8,1)-1","v":"2012-11-30"},{"$f":"B8&\" [\"&TEXT(C8,\"[$-404]d\")&\" - \"&TEXT(D8,\"[$-404]m月d日\")&\"]\"","v":"     本月 [1 - 11月30日]"}]
[null,"     本季",{"$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,\"[$-404]m月d日\")&\" - \"&TEXT(D9,\"[$-404]m月d日\")&\"]\"","v":"     本季 [4月1日 - 7月31日]"}]
[null,"     本年",{"$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":"     本年 [2012年]"}]
[null,"間隔：",null,null,{"$f":"B11","v":"間隔："}]
[null,"     上週",{"$f":"C7-7","v":"2012-11-19"},{"$f":"C12+6","v":"2012-11-25"},{"$f":"B12&\" [\"&TEXT(C12,\"[$-404]m月d日\")&\" - \"&TEXT(D12,\"[$-404]m月d日\")&\"]\"","v":"     上週 [11月19日 - 11月25日]"}]
[null,"     上月",{"$f":"EDATE(C8,-1)","v":"2012-10-01"},{"$f":"EDATE(C13,1)-1","v":"2012-10-31"},{"$f":"B13&\" [\"&TEXT(C13,\"[$-404]d\")&\" - \"&TEXT(D13,\"[$-404]m月d日\")&\"]\"","v":"     上月 [1 - 10月31日]"}]
[null,"     上一季",{"$f":"EDATE(C9,-3)","v":"2012-01-01"},{"$f":"EDATE(C14,3)-1","v":"2012-03-31"},{"$f":"B14&\" [\"&TEXT(C14,\"[$-404]m月d日\")&\" - \"&TEXT(D14,\"[$-404]m月d日\")&\"]\"","v":"     上一季 [1月1日 - 3月31日]"}]
[null,"     去年",{"$f":"EDATE(C10,-12)","v":"2011-01-01"},{"$f":"EDATE(C15,12)-1","v":"2011-12-31"},{"$f":"B15","v":"     去年"}]
[]
[null,"選定醒目提示：",{"$f":"IFERROR(MATCH(HighlightActivities,lstToDoHighlights,0),\"\")","v":""},{"$f":"HighlightActivities","v":"     本週 [6 月 18 日 - 24 日]"},{"$f":"ISNUMBER(INDEX($C$6:$C$15,C17))","v":false}]
[null,"醒目提示開始時間",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($C$6:$C$15,$C$17),\"\")),\"\")","v":""}]
[null,"醒目提示結束",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($D$6:$D$15,$C$17),\"\")),\"\")","v":""}]