{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["甘特","关于"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"甘特","index":0,"n_rows":34,"n_cols":64,"rows_kept":34,"merged":[[1,8,1,11],[1,13,1,16],[1,18,1,21],[1,23,1,26],[1,28,1,31],[2,3,2,4],[2,5,2,6],[3,3,3,4],[4,1,4,7]]}
["在此工作表中创建甘特图。\n在单元格 B1 中输入此项目的标题。\n图例​​标题位于单元格 I1 中。\n有关如何使用此工作表（包括屏幕阅读器的说明）以及此工作簿作者的信息包含在“关于”工作表中。\n继续向下浏览 A 列，获取进一步指示。","项目标题",{"$nulls":6},"图例："]
["在单元格 B2 中输入公司名称。\n图例位于单元格 I2 到 AC2 中。","公司名称",{"$nulls":6},"步入正轨",{"$nulls":4},"低风险",{"$nulls":4},"中等风险",{"$nulls":4},"高风险",{"$nulls":4},"未分配"]
["在单元格 B3 中输入项目负责人的姓名。在单元格 F3 中输入项目开始日期，或允许示例公式从“甘特数据”表中查找最小日期值。\n项目开始日期：标签位于单元格 D3 中。","项目主管",null,"项目开始日期：",null,{"$f":"IFERROR(IF(MIN(里程碑[开始日期])=0,TODAY(),MIN(里程碑[开始日期])),TODAY())","v":"2018-07-07"}]
["滚动增量位于单元格 F4 中。\n从单元格 I4 开始到单元格 BL4，显示第 5 行中日期的月份。\n请勿修改这些单元格。它们根据单元格 F3 中的项目开始日期自动更新。",null,null,"滚动增量：",null,0,null,null,{"$f":"TEXT(I5,\"m月\")","v":"7月"},{"$nulls":6},{"$f":"IF(TEXT(P5,\"m月\")=I4,\"\",TEXT(P5,\"m月\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(W5,\"m月\")=P4,TEXT(W5,\"m月\")=I4),\"\",TEXT(W5,\"m月\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AD5,\"m月\")=W4,TEXT(AD5,\"m月\")=P4,TEXT(AD5,\"m月\")=I4),\"\",TEXT(AD5,\"m月\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AK5,\"m月\")=AD4,TEXT(AK5,\"m月\")=W4,TEXT(AK5,\"m月\")=P4,TEXT(AK5,\"m月\")=I4),\"\",TEXT(AK5,\"m月\"))","v":"8月"},{"$nulls":6},{"$f":"IF(OR(TEXT(AR5,\"m月\")=AK4,TEXT(AR5,\"m月\")=AD4,TEXT(AR5,\"m月\")=W4,TEXT(AR5,\"m月\")=P4),\"\",TEXT(AR5,\"m月\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AY5,\"m月\")=AR4,TEXT(AY5,\"m月\")=AK4,TEXT(AY5,\"m月\")=AD4,TEXT(AY5,\"m月\")=W4),\"\",TEXT(AY5,\"m月\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(BF5,\"m月\")=AY4,TEXT(BF5,\"m月\")=AR4,TEXT(BF5,\"m月\")=AK4,TEXT(BF5,\"m月\")=AD4),\"\",TEXT(BF5,\"m月\"))","v":""}]
["单元格 I5 到 BL5 包含每个日期单元格上方单元格块中表示的“月”的当月日期数字，这些数字是自动计算得出的。\n请勿修改这些单元格。\n今天的日期带有红色（十六进制 #AD3815）轮廓（从第 5 行中显示今天日期的列及至项目安排结尾的该列）。",{"$nulls":7},{"$f":"IFERROR(项目开始日期+滚动增量,TODAY())","v":"2018-07-07"},{"$f":"I5+1","v":"2018-07-08"},{"$f":"J5+1","v":"2018-07-09"},"2018-07-10","2018-07-11","2018-07-12","2018-07-13",{"$f":"O5+1","v":"2018-07-14"},{"$f":"P5+1","v":"2018-07-15"},"2018-07-16","2018-07-17","2018-07-18","2018-07-19","2018-07-20",{"$f":"V5+1","v":"2018-07-21"},{"$f":"W5+1","v":"2018-07-22"},"2018-07-23","2018-07-24","2018-07-25","2018-07-26","2018-07-27",{"$f":"AC5+1","v":"2018-07-28"},{"$f":"AD5+1","v":"2018-07-29"},"2018-07-30","2018-07-31","2018-08-01","2018-08-02","2018-08-03",{"$f":"AJ5+1","v":"2018-08-04"},{"$f":"AK5+1","v":"2018-08-05"},"2018-08-06","2018-08-07","2018-08-08","2018-08-09","2018-08-10",{"$f":"AQ5+1","v":"2018-08-11"},{"$f":"AR5+1","v":"2018-08-12"},"2018-08-13","2018-08-14","2018-08-15","2018-08-16","2018-08-17",{"$f":"AX5+1","v":"2018-08-18"},{"$f":"AY5+1","v":"2018-08-19"},{"$f":"AZ5+1","v":"2018-08-20"},"2018-08-21","2018-08-22","2018-08-23","2018-08-24",{"$f":"BE5+1","v":"2018-08-25"},{"$f":"BF5+1","v":"2018-08-26"},{"$f":"BG5+1","v":"2018-08-27"},"2018-08-28","2018-08-29","2018-08-30","2018-08-31"]
["滚动条位于单元格 I6 到 BL6 中。数据分页增量定义为一次 2 页，可以在控制栏的设置中配置该增量。\n若要在时间线中向前或向后跳转，请在单元格 F4 中输入 0 或更大的值。\n值为 0 会转到图表的开头。"]
["此行包含其后面的项目安排的标题。\n从 B7 导航到 BL7 以听取内容。该标题上方日期一周中每一天的首字母，从单元格 I7 开始，直到单元格 BL7。\n所有项目时间线制图都是根据“里程碑”表中输入的类别、开始日期和天数自动生成的。","里程碑说明","类别","责任人","进度","开始日期","天数",null,{"$f":"LEFT(TEXT(I5,\"aaa\"),1)","v":"S"},"S","M","T","W","T","F","S","S","M","T","W","T","F","S","S","M","T","W","T","F","S","S","M","T","W","T","F","S","S","M","T",{"$f":"LEFT(TEXT(AO5,\"aaa\"),1)","v":"W"},"T","F","S","S","M","T","W","T","F","S","S","M","T","W","T","F","S","S","M","T","W","T","F"]
["请勿删除此行。隐藏了此行，以保留用于突出显示项目安排中当天的公式。 "]
["在单元格 B9 到 G9 中输入项目信息。\n示例数据位于单元格 B9 到 G33 中。\n输入“里程碑说明”，从下拉列表中选择一个类别，为某人分配责任人，输入进度、开始日期和任务的天数以开始制图。\n下一条指示位于单元格 A34 中。","标题 1",{"$nulls":6},{"$f":"IF(AND($C9=\"目标\",I$5>=$F9,I$5<=$F9+$G9-1),2,IF(AND($C9=\"里程碑\",I$5>=$F9,I$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"目标\",Y$5>=$F9,Y$5<=$F9+$G9-1),2,IF(AND($C9=\"里程碑\",Y$5>=$F9,Y$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"目标\",AO$5>=$F9,AO$5<=$F9+$G9-1),2,IF(AND($C9=\"里程碑\",AO$5>=$F9,AO$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"目标\",BE$5>=$F9,BE$5<=$F9+$G9-1),2,IF(AND($C9=\"里程碑\",BE$5>=$F9,BE$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","",""]
[null,"任务 1","目标","姓名",{"v":0.25,"d":"25%"},{"$f":"TODAY()","v":"2019-09-02"},{"v":3,"d":"3 "},null,{"$f":"IF(AND($C10=\"目标\",I$5>=$F10,I$5<=$F10+$G10-1),2,IF(AND($C10=\"里程碑\",I$5>=$F10,I$5<=$F10+$G10-1),1,\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($C10=\"目标\",S$5>=$F10,S$5<=$F10+$G10-1),2,IF(AND($C10=\"里程碑\",S$5>=$F10,S$5<=$F10+$G10-1),1,\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($C10=\"目标\",AC$5>=$F10,AC$5<=$F10+$G10-1),2,IF(AND($C10=\"里程碑\",AC$5>=$F10,AC$5<=$F10+$G10-1),1,\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($C10=\"目标\",AM$5>=$F10,AM$5<=$F10+$G10-1),2,IF(AND($C10=\"里程碑\",AM$5>=$F10,AM$5<=$F10+$G10-1),1,\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($C10=\"目标\",AW$5>=$F10,AW$5<=$F10+$G10-1),2,IF(AND($C10=\"里程碑\",AW$5>=$F10,AW$5<=$F10+$G10-1),1,\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($C10=\"目标\",BG$5>=$F10,BG$5<=$F10+$G10-1),2,IF(AND($C10=\"里程碑\",BG$5>=$F10,BG$5<=$F10+$G10-1),1,\"\"))","v":""},"","","","",""]
[null,"任务 2","里程碑",null,null,{"$f":"TODAY()+5","v":"2019-09-07"},{"v":1,"d":"1 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"任务 3","低风险",null,{"v":0.5,"d":"50%"},{"$f":"F10-3","v":"2019-08-30"},{"v":10,"d":"10 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"任务 4","里程碑",null,null,{"$f":"F10+20","v":"2019-09-22"},{"v":1,"d":"1 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"任务 5","中等风险",null,{"v":0.1,"d":"10%"},{"$f":"F10+6","v":"2019-09-08"},{"v":6,"d":"6 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"标题 2",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"任务 1","高风险",null,{"v":0.6,"d":"60%"},{"$f":"F10+6","v":"2019-09-08"},{"v":13,"d":"13 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"任务 2","步入正轨",null,{"v":0.5,"d":"50%"},{"$f":"F16+2","v":"2019-09-10"},{"v":9,"d":"9 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"任务 3","低风险",null,{"v":0.33,"d":"33%"},{"$f":"F17+5","v":"2019-09-15"},{"v":11,"d":"11 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"任务 4","里程碑",null,null,{"$f":"F18+2","v":"2019-09-17"},{"v":1,"d":"1 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"任务 5",{"$nulls":3},{"$f":"F19+1","v":"2019-09-18"},{"v":24,"d":"24 "},null,{"$f":"IF(AND($C20=\"目标\",I$5>=$F20,I$5<=$F20+$G20-1),2,IF(AND($C20=\"里程碑\",I$5>=$F20,I$5<=$F20+$G20-1),1,\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($C20=\"目标\",S$5>=$F20,S$5<=$F20+$G20-1),2,IF(AND($C20=\"里程碑\",S$5>=$F20,S$5<=$F20+$G20-1),1,\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($C20=\"目标\",AC$5>=$F20,AC$5<=$F20+$G20-1),2,IF(AND($C20=\"里程碑\",AC$5>=$F20,AC$5<=$F20+$G20-1),1,\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($C20=\"目标\",AM$5>=$F20,AM$5<=$F20+$G20-1),2,IF(AND($C20=\"里程碑\",AM$5>=$F20,AM$5<=$F20+$G20-1),1,\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($C20=\"目标\",AW$5>=$F20,AW$5<=$F20+$G20-1),2,IF(AND($C20=\"里程碑\",AW$5>=$F20,AW$5<=$F20+$G20-1),1,\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($C20=\"目标\",BG$5>=$F20,BG$5<=$F20+$G20-1),2,IF(AND($C20=\"里程碑\",BG$5>=$F20,BG$5<=$F20+$G20-1),1,\"\"))","v":""},"","","","",""]
[null,"标题 3",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"任务 1","步入正轨",null,null,{"$f":"F10+15","v":"2019-09-17"},{"v":4,"d":"4 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"任务 2","中等风险",null,null,{"$f":"F22+3","v":"2019-09-20"},{"v":14,"d":"14 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"任务 3","步入正轨",null,null,{"$f":"F23+15","v":"2019-10-05"},{"v":6,"d":"6 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"任务 4","目标",null,null,{"$f":"F19+22","v":"2019-10-09"},{"v":3,"d":"3 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"任务 5","低风险",null,null,{"$f":"F14","v":"2019-09-08"},{"v":19,"d":"19 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"标题 4",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"任务 1",{"$nulls":3},{"$f":"F25+3","v":"2019-10-12"},{"v":15,"d":"15 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"任务 2",{"$nulls":3},"2018-07-07",{"v":5,"d":"5 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"任务 3","里程碑",null,null,"2018-07-25",{"v":1,"d":"1 "},null,"","","","","","","","","","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"任务 4",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"任务 5",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["这是一个空行",{"$nulls":7},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["此行标记甘特里程碑数据的结尾。请勿在此行中输入任何内容。\n若要添加更多项目，请在此行上方插入新行。","若要添加更多数据，请在此行上方插入新行"]

{"sheet":"关于","index":1,"n_rows":5,"n_cols":1,"rows_kept":5}
["关于此模板"]
["此模板提供了一种创建甘特图的简单方法，可帮助直观呈现和跟踪项目。只需输入任务说明，选择一种类别（“目标”、“里程碑”、“步入正轨”、“低风险”、“中等风险”、“高风险”），然后输入任务完成百分比进度、开始日期和完成任务的天数。甘特图填充完毕，并经过颜色编码，可帮助区分各种类别。通过滚动条可滚动时间线。通过插入新行插入新任务。\n"]
["屏幕阅读器指南"]
["此工作簿中有 2 个工作表。\n\n甘特图\n关于\n\n每个工作表的指示文本位于每个工作表中自单元格 A1 开始的 A 列中。这些指示都使用隐藏文本编写。每个步骤均提供相应指示，引导阅读者查看行中的相应信息。除非另有明确指示，否则会在单元格 A2、A3 等后续单元格中持续指示相应步骤。例如，指示文本可能显示为“转到单元格 A6”以执行下一步操作。\n\n将不会打印此隐藏文本。\n\n若要从工作表删除这些指示，只需删除 A 列即可。"]
["这是此工作表中的最后一条指示。"]