{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["代办事项列表","图表数据","如何使用此模板"],"not_rendered":{"charts":1,"images":5,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"代办事项列表","index":0,"n_rows":6,"n_cols":8,"rows_kept":6,"merged":[[0,1,0,5],[2,7,11,7]]}
[null,{"$f":"CONCATENATE(如何使用此模板!D3,\"待办事项列表\" )","v":"名称待办事项列表"},{"$nulls":5},"汇总"]
[{"$nulls":6},"到期项目​​数："]
[null,"项目","说明","截止日期","优先级","状态",null,"条形图，显示今天、明天和本周到期的任务数量。"]
[null,"了解 Excel","了解 Excel 表格",{"$f":"TODAY()","v":"2018-06-26"},"高","待完成","描述待完成项目和到期时间的簇状条形图位于此单元格。"]
[null,"了解 Excel","了解 Excel 迷你图​​",{"$f":"TODAY()+1","v":"2018-06-27"},"高","待完成"]
[null,"了解 Excel","了解 Excel​​ 条件格式",{"$f":"TODAY()+1","v":"2018-06-27"},"高","待完成"]

{"sheet":"图表数据","index":1,"n_rows":3,"n_cols":3,"rows_kept":3,"hidden":true,"merged":[[0,0,0,2]]}
["图表数据:请勿删除下方各行"]
["本周","明天","今天"]
[{"$f":"SUM(IF(ToDoList[截止日期]>=(TODAY()-WEEKDAY(TODAY(),2)+1),IF(ToDoList[截止日期]<(TODAY()-WEEKDAY(TODAY(),2)+1+7),1,0),0))","v":3},{"$f":"COUNTIF(ToDoList[截止日期],TODAY()+1)","v":2},{"$f":"COUNTIF(ToDoList[截止日期],TODAY())","v":1}]

{"sheet":"如何使用此模板","index":2,"n_rows":9,"n_cols":4,"rows_kept":9}
[]
[null,null,"请按以下步骤操作，处理待办事项列表："]
[null,"1)","若要个性化设置待办事项列表，请在右侧单元格中输入名称：","名称"]
[null,"2)","在“代办事项列表”工作表的 Excel 表中输入每个项目的项目详细信息。"]
[null,"3)","在“优先级”和“状态”列中，可使用箭头从预定义条目中选择。"]
[null,"4)","若要在表的末尾添加新行，请选择最后一行的最后一个单元格，然后按 Tab。\n提示：\n也可在表格下方一行的第一个单元中键入内容。"]
[null,"5)","若要在表格中插入行，请在要在其上方插入行的行上按住 Shift 并按 F10。现在，选择“插入”，然后选择“在上方插入表行”。\n提示：\n也可以按这种方式插入新列，但必须对线条边框进行适当的调整。可将线条拖到所需的位置。"]
[null,"6)","如果输入的日期在当天、第二天或同一周内，则条目将显示在图表中。"]
[null,null,"注意：\n行和列标题不显示在“代办事项列表”工作表中。如果需要调整列宽，可以临时显示标题（“视图”选项卡，“显示”组，“标题”复选框）。 "]