{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["项目日程安排","关于"],"not_rendered":{"images":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"项目日程安排","index":0,"n_rows":33,"n_cols":64,"rows_kept":33,"merged":[[2,2,2,3],[2,4,2,5],[3,2,3,3],[3,8,3,14],[3,15,3,21],[3,22,3,28],[3,29,3,35],[3,36,3,42],[3,43,3,49],[3,50,3,56],[3,57,3,63]]}
["在此工作表中创建项目日程安排。\n在单元格 B1 中输入此项目的标题。\n有关如何使用此工作表（包括屏幕阅读器的说明）以及此工作簿作者的信息包含在“关于”工作表中。\n继续向下浏览 A 列，获取进一步指示。","项目标题",{"$nulls":6},"Vertex42.com 提供的简单甘特图"]
["在单元格 B2 中输入公司名称。","公司名称",{"$nulls":6},"https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html"]
["在单元格 B3 中输入项目主管的姓名。在单元格 E3 中输入项目开始日期。项目开始：标签位于单元格 C3 中。","项目主管","项目开始：",null,{"$f":"TODAY()","v":"2022-02-16"}]
["单元格 E4 中的显示周数表示单元格 I4 中项目日程安排内显示的起始周数。项目开始日期视为第 1 周。要更改显示周数，只需单元格 E4 中输入新的周数。\n从单元格 E4 的显示周数开始，每周的开始日期从单元格 I4 开始并且说自动计算得出的。在该视图中，从单元格 I4 到单元格 BF4 共有 8 周的时间。\n请勿修改这些单元格。\n显示周数：标签位于单元格 C4 中。",null,"显示周数：",null,1,{"$nulls":3},{"$f":"I5","v":"2022-02-14"},{"$nulls":6},{"$f":"P5","v":"2022-02-21"},{"$nulls":6},{"$f":"W5","v":"2022-02-28"},{"$nulls":6},{"$f":"AD5","v":"2022-03-07"},{"$nulls":6},{"$f":"AK5","v":"2022-03-14"},{"$nulls":6},{"$f":"AR5","v":"2022-03-21"},{"$nulls":6},{"$f":"AY5","v":"2022-03-28"},{"$nulls":6},{"$f":"BF5","v":"2022-04-04"}]
["单元格 I5 到 BL5 包含每个日期单元格上方单元格块中表示的星期的日期数字并且是自动计算得出的。\n请勿修改这些单元格。\n今天的日期带有红色（十六进制 #AD3815）轮廓（从第 5 行中显示今天日期的列及至项目日程安排结尾的该列）。",{"$nulls":7},{"$f":"项目开始-WEEKDAY(项目开始,1)+2+7*(显示周数-1)","v":"2022-02-14"},{"$f":"I5+1","v":"2022-02-15"},{"$f":"J5+1","v":"2022-02-16"},"2022-02-17","2022-02-18","2022-02-19","2022-02-20",{"$f":"O5+1","v":"2022-02-21"},{"$f":"P5+1","v":"2022-02-22"},"2022-02-23","2022-02-24","2022-02-25","2022-02-26","2022-02-27",{"$f":"V5+1","v":"2022-02-28"},{"$f":"W5+1","v":"2022-03-01"},"2022-03-02","2022-03-03","2022-03-04","2022-03-05","2022-03-06",{"$f":"AC5+1","v":"2022-03-07"},{"$f":"AD5+1","v":"2022-03-08"},"2022-03-09","2022-03-10","2022-03-11","2022-03-12","2022-03-13",{"$f":"AJ5+1","v":"2022-03-14"},{"$f":"AK5+1","v":"2022-03-15"},"2022-03-16","2022-03-17","2022-03-18","2022-03-19","2022-03-20",{"$f":"AQ5+1","v":"2022-03-21"},{"$f":"AR5+1","v":"2022-03-22"},"2022-03-23","2022-03-24","2022-03-25","2022-03-26","2022-03-27",{"$f":"AX5+1","v":"2022-03-28"},{"$f":"AY5+1","v":"2022-03-29"},{"$f":"AZ5+1","v":"2022-03-30"},"2022-03-31","2022-04-01","2022-04-02","2022-04-03",{"$f":"BE5+1","v":"2022-04-04"},{"$f":"BF5+1","v":"2022-04-05"},{"$f":"BG5+1","v":"2022-04-06"},"2022-04-07","2022-04-08","2022-04-09","2022-04-10"]
["此行包含其后面的项目日程安排的标题。\n从 B6 浏览到 BL6 以获取内容。该标题上方日期一周中每一天的首字母，从单元格 I6 开始，直到单元格 BL6。\n所有项目日程表图表都是根据输入的开始和结束日期使用条件格式自动生成的。\n从单元格 I7 开始的列 I 之后，请勿修改列内单元格中的内容。","任务","分配到","进度","开始日期","结束日期",null,"天数",{"$f":"RIGHT(TEXT(I5,\"aaa\"),1)","v":"一"},{"$f":"RIGHT(TEXT(J5,\"aaa\"),1)","v":"二"},"三","四","五","六","日","一","二","三","四","五","六","日","一","二","三","四","五","六","日","一","二","三","四","五","六","日","一","二","三","四","五","六","日","一","二","三","四","五","六","日","一","二","三","四","五","六","日","一","二","三","四","五","六","日"]
["请勿删除此行。隐藏了此行，以保留用于突出显示项目日程安排中当天的公式。 ",{"$nulls":6},{"$f":"IF(OR(ISBLANK(task_start),ISBLANK(task_end)),\"\",task_end-task_start+1)","v":""}]
["单元格 B8 包含第 1 阶段示例标题。\n在单元格 B8 中输入新标题。\n如果适用于你的项目，请在单元格 C8 中输入名称以指定阶段。\n如果适用于你的项目，请在单元格 D8 中输入整个阶段的进度。\n如果适用于你的项目，请在单元格 E8 和 F8 中输入整个阶段的开始和结束日期。\n甘特图将根据输入的进度自动填充适当的日期和着色。\n要仅从任务中删除阶段和工作，只需删除此行即可。","阶段 1 标题",{"$nulls":5},{"$f":"IF(OR(ISBLANK(task_start),ISBLANK(task_end)),\"\",task_end-task_start+1)","v":""}]
["单元格 B9 包含示例任务“任务 1”。\n在单元格 B9 中输入新的任务名称。\n在单元格 C9 中输入任务负责人。\n在单元格 D9 中输入任务进度。进度条出现在单元格中，并根据单元格中的数字进行着色。例如，50% 的进度将着色一半的单元格。\n在单元格 E9 中输入任务开始日期。\n在单元格 F9 中输入任务结束日期。\n从单元格 I9 到 BL9 的块中显示输入日期的已着色状态栏。 ","任务 1","姓名",{"v":0.5,"d":"50%"},{"$f":"项目开始","v":"2022-02-16"},{"$f":"E9+3","v":"2022-02-19"},null,4]
["第 10 行到第 13 行重复第 9 行的模式。\n请对此工作表中的所有任务行重复单元格 A9 中的指令。覆盖任何示例数据。\n另一个阶段的示例从单元格 A14 开始。\n继续在单元格 A10 到 A13 中输入任务或转到单元格 A14 了解详细信息。","任务 2",null,{"v":0.6,"d":"60%"},{"$f":"F9","v":"2022-02-19"},{"$f":"E10+2","v":"2022-02-21"},null,3]
[null,"任务 3",null,{"v":0.5,"d":"50%"},{"$f":"F10","v":"2022-02-21"},{"$f":"E11+4","v":"2022-02-25"},null,5]
[null,"任务 4",null,{"v":0.25,"d":"25%"},{"$f":"F11","v":"2022-02-25"},{"$f":"E12+5","v":"2022-03-02"},null,6]
[null,"任务 5",null,null,{"$f":"E10+1","v":"2022-02-20"},{"$f":"E13+2","v":"2022-02-22"},null,3]
["右侧的单元格包含第 2 阶段示例标题。\n可随时在 B 列中创建新阶段。此项目日程安排不需要阶段。要删除阶段，只需删除该行即可。\n要在此行中创建新的阶段块，请在右侧的单元格中输入新的标题。\n要继续向上述阶段添加任务，请在此行上方输入一个新行，并按照单元格 A9 的指令填写任务数据。\n根据单元格 A8 的指令更新右侧单元格中的阶段详细信息。\n继续向下浏览 A 列单元格，了解更多信息。\n如果尚未在此工作表中添加任何新行，将在单元格 B20 和 B26 中找到已创建的 2 个其他示例阶段块。否则，请浏览 A 列单元格以查找其他块。\n在需要时重复单元格 A8 和 A9 的说明进行操作。","阶段 2 标题",{"$nulls":5},""]
[null,"任务 1",null,{"v":0.5,"d":"50%"},{"$f":"E13+1","v":"2022-02-21"},{"$f":"E15+4","v":"2022-02-25"},null,5]
[null,"任务 2",null,{"v":0.5,"d":"50%"},{"$f":"E15+2","v":"2022-02-23"},{"$f":"E16+5","v":"2022-02-28"},null,6]
[null,"任务 3",null,null,{"$f":"F16","v":"2022-02-28"},{"$f":"E17+3","v":"2022-03-03"},null,4]
[null,"任务 4",null,null,{"$f":"E17","v":"2022-02-28"},{"$f":"E18+2","v":"2022-03-02"},null,3]
[null,"任务 5",null,null,{"$f":"E18","v":"2022-02-28"},{"$f":"E19+3","v":"2022-03-03"},null,4]
["示例阶段标题块","阶段 3 标题",{"$nulls":5},""]
[null,"任务 1",null,null,{"$f":"E9+15","v":"2022-03-03"},{"$f":"E21+5","v":"2022-03-08"},null,6]
[null,"任务 2",null,null,{"$f":"F21+1","v":"2022-03-09"},{"$f":"E22+4","v":"2022-03-13"},null,5]
[null,"任务 3",null,null,{"$f":"E22+5","v":"2022-03-14"},{"$f":"E23+5","v":"2022-03-19"},null,6]
[null,"任务 4",null,null,{"$f":"F23+1","v":"2022-03-20"},{"$f":"E24+4","v":"2022-03-24"},null,5]
[null,"任务 5",null,null,{"$f":"E23","v":"2022-03-14"},{"$f":"E25+4","v":"2022-03-18"},null,5]
["示例阶段标题块","阶段 4 标题",{"$nulls":5},""]
[null,"任务 1",null,null,"日期","日期",null,{"$error":"#VALUE!"}]
[null,"任务 2",null,null,"日期","日期",null,{"$error":"#VALUE!"}]
[null,"任务 3",null,null,"日期","日期",null,{"$error":"#VALUE!"}]
[null,"任务 4",null,null,"日期","日期",null,{"$error":"#VALUE!"}]
[null,"任务 5",null,null,"日期","日期",null,{"$error":"#VALUE!"}]
["这是一个空行",{"$nulls":6},""]
["此行标记项目日程安排的结尾。请勿在此行中输入任何内容。\n在此行上方插入新行，以继续构建项目日程安排。","在此行上方插入新行",{"$nulls":5},""]

{"sheet":"关于","index":1,"n_rows":16,"n_cols":1,"rows_kept":16}
[]
["Vertex42.com 提供的简单甘特图"]
["https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html"]
["关于此模板"]
["此模板提供了一种创建甘特图的简单方法，可帮助直观呈现和跟踪项目。只需输入任务以及开始和结束日期 - 无需公式。甘特图中的条形表示任务的持续时间，并且使用条件格式显示。通过插入新行插入新任务。"]
["屏幕阅读器指南"]
["此工作簿中有 2 个工作表。\n\n考勤记录\n关于\n\n每个工作表的指示文本位于每个工作表中自单元格 A1 开始的 A 列中。这些指示都使用隐藏文本编写。每个步骤均提供相应指示，引导阅读者查看行中的相应信息。除非另有明确指示，否则会在单元格 A2、A3 等后续单元格中持续指示相应步骤。例如，指示文本可能显示为“转到单元格 A6”以执行下一步操作。\n\n将不会打印此隐藏文本。\n\n要从工作表删除这些指示，只需删除 A 列即可。"]
["更多帮助"]
["单击下面的链接以访问 vertex42.com 并了解有关如何使用此模板的更多信息，例如如何计算天数和工作天数、创建任务依赖关系、更改条形颜色、添加滚动条以更易于更改显示周数、延长图表中显示的日期范围等。"]
["如何使用简单甘特图"]
["更多项目管理模板"]
["请访问 Vertex42.com 下载其他项目管理模板，包括不同类型的项目日程安排、甘特图、任务列表等。"]
["项目管理模板"]
["了解 Vertex42"]
["Vertex42.com 为企业、家庭和教育提供超过 300 种专业设计的电子表格模板 - 其中大部分都可免费下载。这些集合包括各种日历、规划师和日程安排，以及用于预算、减免债务和分期偿还贷款的个人财务电子表格。"]
["企业可查找发票、时间表、库存跟踪表、财务报表和项目计划模板。教师和学生可查找诸如课程表、成绩簿和出勤表等资源。还可通过用餐规划师、清单和锻炼日志来组织家庭生活。通过来自数千名用户的反馈，每个模板都经过了深入的研究、完善和改进。"]