{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["项目 1 待办事项列表","设置和计算"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":7,"comments":0,"pivot_tables":0},"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":"项目 1 待办事项列表","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,"项目待办事项列表"]
[]
[null,"完成者：",null,null,"截止时间：",null,"突出显示活动"]
[null,"郭爱明",null,null,{"$f":"TODAY()+95","v":"2012-12-31"},null,"     本周 [6 月 18 日 - 24 日]"]
[]
[null,"项目 1"]
[null,"活动","截止时间","预算","完成百分比","进度","备注"," "]
[null,"规划",{"$f":"TODAY()-90","v":"2012-06-29"},4760,0.25,{"$f":"tblToDoList[[#This Row],[完成百分比]]","v":0.25}]
[null,"准备",{"$f":"TODAY()-2","v":"2012-09-25"},3010,0.1,{"$f":"tblToDoList[[#This Row],[完成百分比]]","v":0.1}]
[null,"任务 A",{"$f":"TODAY()-7","v":"2012-09-20"},4290,0,{"$f":"tblToDoList[[#This Row],[完成百分比]]","v":0}]
[null,"任务 B",{"$f":"TODAY()+20","v":"2012-10-17"},3320,0.7,{"$f":"tblToDoList[[#This Row],[完成百分比]]","v":0.7}]
[null,"任务 C",{"$f":"TODAY()+40","v":"2012-11-06"},4710,0.1,{"$f":"tblToDoList[[#This Row],[完成百分比]]","v":0.1}]
[null,"任务 D",{"$f":"TODAY()+45","v":"2012-11-11"},4180,1,{"$f":"tblToDoList[[#This Row],[完成百分比]]","v":1}]
[null,"文书工作",{"$f":"TODAY()+55","v":"2012-11-21"},1500,0,{"$f":"tblToDoList[[#This Row],[完成百分比]]","v":0},"任务 B 之后开始，已完成"]
[null,"递交",{"$f":"TODAY()+70","v":"2012-12-06"},3300,0.25,{"$f":"tblToDoList[[#This Row],[完成百分比]]","v":0.25}]
[null,"后续工作",{"$f":"TODAY()+90","v":"2012-12-26"},3530,0.5,{"$f":"tblToDoList[[#This Row],[完成百分比]]","v":0.5}]

{"sheet":"设置和计算","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
[null,null,null,null,null," "]
[null,"突出显示设置"]
[null,"下面存储“突出显示活动”列表的设置和计算。\n任何更改将导致错误或功能丢失。"]
[null,"非突出显示",null,null,{"$f":"B5","v":"非突出显示"}]
[null,"间隔：","开始：","结束：","截止时间："]
[null,"     本周",{"$f":"TODAY()-WEEKDAY(TODAY(),2)+1","v":"2012-09-24"},{"$f":"C7+6","v":"2012-09-30"},{"$f":"B7&\" [\"&TEXT(C7,\"[$-804]m月d日\")&\" - \"&TEXT(D7,\"[$-804]m月d日\")&\"]\"","v":"     本周 [9月24日 - 9月30日]"}]
[null,"     本月",{"$f":"EOMONTH(TODAY(),-1)+1","v":"2012-09-01"},{"$f":"EDATE(C8,1)-1","v":"2012-09-30"},{"$f":"B8&\" [\"&TEXT(C8,\"d\")&\" - \"&TEXT(D8,\"[$-804]m月d日\")&\"]\"","v":"     本月 [1 - 9月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,\"[$-804]d日\")&\" - \"&TEXT(D9,\"[$-804]m月d日\")&\"]\"","v":"     本季度 [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,\"[$-804]yyyy年\")&\"]\"","v":"     本年 [2012年]"}]
[null,"间隔：",null,null,{"$f":"B11","v":"间隔："}]
[null,"     上周",{"$f":"C7-7","v":"2012-09-17"},{"$f":"C12+6","v":"2012-09-23"},{"$f":"B12&\" [\"&TEXT(C12,\"[$-804]m月d日\")&\" - \"&TEXT(D12,\"[$-804]m月d日\")&\"]\"","v":"     上周 [9月17日 - 9月23日]"}]
[null,"     上个月",{"$f":"EDATE(C8,-1)","v":"2012-08-01"},{"$f":"EDATE(C13,1)-1","v":"2012-08-31"},{"$f":"B13&\" [\"&TEXT(C13,\"[$-804]d日\")&\" - \"&TEXT(D13,\"[$-804]m月d日\")&\"]\"","v":"     上个月 [1日 - 8月31日]"}]
[null,"     上一季度",{"$f":"EDATE(C9,-3)","v":"2012-01-01"},{"$f":"EDATE(C14,3)-1","v":"2012-03-31"},{"$f":"B14&\" [\"&TEXT(C14,\"[$-804]m月d日\")&\" - \"&TEXT(D14,\"[$-804]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":""}]