{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["项目概述","任务详细信息"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"项目概述","index":0,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"项目概述"]
[]
[null,"项目","  ","进度"," 开始"," 结束","备注"]
[null,"计划假期",{"$f":"IFERROR((SUMIFS(任务[完成],任务[项目],项目[[#This Row],[项目]])/COUNTIFS(任务[项目],项目[[#This Row],[项目]]))+0.0001,0.0001)","v":0.50009999999999999},{"$f":"REPT(\"|\",项目[[  ]]*175)","v":"|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||"},{"$f":"MIN(IF((任务[项目]=项目[[#This Row],[项目]])*(任务[开始]>0),任务[开始]))","v":"2011-10-01"},{"$f":"MAX(IF((任务[项目]=项目[[#This Row],[项目]])*(任务[开始]>0),任务[[开始]:[结束]]))","v":"2011-12-31"},"我们将前往北京！"]
[null,"计划乐乐的惊喜聚会",{"$f":"IFERROR((SUMIFS(任务[完成],任务[项目],项目[[#This Row],[项目]])/COUNTIFS(任务[项目],项目[[#This Row],[项目]]))+0.0001,0.0001)","v":1.0001},{"$f":"REPT(\"|\",项目[[  ]]*175)","v":"|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||"},{"$f":"MIN(IF((任务[项目]=项目[[#This Row],[项目]])*(任务[开始]>0),任务[开始]))","v":"2011-09-10"},{"$f":"MAX(IF((任务[项目]=项目[[#This Row],[项目]])*(任务[开始]>0),任务[[开始]:[结束]]))","v":"2011-10-03"}]
[null,"马拉松赛跑训练",{"$f":"IFERROR((SUMIFS(任务[完成],任务[项目],项目[[#This Row],[项目]])/COUNTIFS(任务[项目],项目[[#This Row],[项目]]))+0.0001,0.0001)","v":0.28581428571428569},{"$f":"REPT(\"|\",项目[[  ]]*175)","v":"||||||||||||||||||||||||||||||||||||||||||||||||||"},{"$f":"MIN(IF((任务[项目]=项目[[#This Row],[项目]])*(任务[开始]>0),任务[开始]))","v":"2011-09-01"},{"$f":"MAX(IF((任务[项目]=项目[[#This Row],[项目]])*(任务[开始]>0),任务[[开始]:[结束]]))","v":"2012-04-18"},"4 月 18 日打破我的记录"]
[null,"为乐乐报名参加游泳课",{"$f":"IFERROR((SUMIFS(任务[完成],任务[项目],项目[[#This Row],[项目]])/COUNTIFS(任务[项目],项目[[#This Row],[项目]]))+0.0001,0.0001)","v":1E-4},{"$f":"REPT(\"|\",项目[[  ]]*175)","v":""},{"$f":"MIN(IF((任务[项目]=项目[[#This Row],[项目]])*(任务[开始]>0),任务[开始]))","v":"2011-10-01"},{"$f":"MAX(IF((任务[项目]=项目[[#This Row],[项目]])*(任务[开始]>0),任务[[开始]:[结束]]))","v":"2011-10-15"}]

{"sheet":"任务详细信息","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"任务详细信息"]
[]
[null,"开始","结束","项目","任务","完成","备注"]
[null,"2011-10-01","2011-10-15","计划假期","热带地区与温带地区之间选择",1,"选择温带地区。北京，我们来了！"]
[null,"2011-10-15","2011-12-31","计划假期","在线监控春季飞机票价费率"]
[null,"2011-10-15",null,"计划假期","研究北京的历史和文化"]
[null,"2011-10-15","2011-10-20","计划假期","了解度假圣地评论",1]
[null,"2011-10-20",null,"计划假期","预订度假胜地的酒店",1,"4 月 19 日至 4 月 30 日"]
[null,"2011-10-20","2011-11-15","计划假期","获取全家人的护照",null,"考虑紧急选择…"]
[null,"2011-09-01","2011-09-30","马拉松赛跑训练","一天 10 公里",1,"4 月 18 日赛跑"]
[null,"2011-10-01","2011-10-31","马拉松赛跑训练","一天 12 公里",1]
[null,"2011-11-01","2011-11-30","马拉松赛跑训练","一天 14 公里"]
[null,"2011-12-01","2012-04-15","马拉松赛跑训练","一天 15 公里"]
[null,"2012-04-16",null,"马拉松赛跑训练","马拉松赛跑"]
[null,"2012-04-16","2012-04-17","马拉松赛跑训练","检查课程",null,"每天慢跑 10 公里"]
[null,"2012-04-18",null,"马拉松赛跑训练","3 小时内到达终点线！",null,"现在前往北京！"]
[null,"2011-09-10",null,"计划乐乐的惊喜聚会","发送聚会请柬",1,"10 月 3 日惊喜的生日聚会"]
[null,"2011-09-20",null,"计划乐乐的惊喜聚会","预订酒席",1]
[null,"2011-09-22",null,"计划乐乐的惊喜聚会","确定文娱表演",1]
[null,"2011-10-03",null,"计划乐乐的惊喜聚会","聚会当天！",1,"棒极了。她的心情无以言表！"]
[null,"2011-10-01","2011-10-15","为乐乐报名参加游泳课","比较当地社区中心价格"]