{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["项目时间线","calcs"],"not_rendered":{"charts":1,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"项目时间线","index":0,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[0,2,0,6],[1,2,1,6]]}
[null,null,"项目时间线"]
[null,null,"显示具有可滚动日程表的项目活动的图表位于此单元格中。"]
[null,null,"输入开始日期： ",{"$f":"TODAY()","v":"2019-07-05"}]
[null,"ID","活动","开始时间","结束时间","备注"]
[null,{"$f":"ROW(B5)-calcs!$D$5","v":-7},"项目开始",{"$f":"$D$3+3","v":"2019-07-08"}]
[null,{"$f":"ROW(B6)-calcs!$D$5","v":-6},"里程碑 1",{"$f":"D5+10","v":"2019-07-18"},{"$f":"活动[[#This Row],[开始时间]]+3","v":"2019-07-21"}]
[null,{"$f":"ROW(B7)-calcs!$D$5","v":-5},"里程碑 2",{"$f":"D6+1","v":"2019-07-19"},{"$f":"活动[[#This Row],[开始时间]]+3","v":"2019-07-22"}]
[null,{"$f":"ROW(B8)-calcs!$D$5","v":-4},"里程碑 3",{"$f":"D7+5","v":"2019-07-24"}]
[null,{"$f":"ROW(B9)-calcs!$D$5","v":-3},"里程碑 4",{"$f":"D8+10","v":"2019-08-03"},{"$f":"活动[[#This Row],[开始时间]]+2","v":"2019-08-05"}]
[null,{"$f":"ROW(B10)-calcs!$D$5","v":-2},"里程碑 5","2019-08-13",{"$f":"活动[[#This Row],[开始时间]]+2","v":"2019-08-15"}]
[null,{"$f":"ROW(B11)-calcs!$D$5","v":-1},"里程碑 6",{"$f":"D10+10","v":"2019-08-23"},{"$f":"活动[[#This Row],[开始时间]]+2","v":"2019-08-25"}]
[null,{"$f":"ROW(B12)-calcs!$D$5","v":0},"里程碑 7","2019-09-02"]
[null,{"$f":"ROW(B13)-calcs!$D$5","v":1},"里程碑 8",{"$f":"D12+10","v":"2019-09-12"},{"$f":"活动[[#This Row],[开始时间]]+2","v":"2019-09-14"}]
[null,{"$f":"ROW(B14)-calcs!$D$5","v":2},"里程碑 9","2019-09-22",{"$f":"活动[[#This Row],[开始时间]]+2","v":"2019-09-24"}]
[null,{"$f":"ROW(B15)-calcs!$D$5","v":3},"里程碑 10","2019-10-02",{"$f":"活动[[#This Row],[开始时间]]+2","v":"2019-10-04"}]
[null,{"$f":"ROW(B16)-calcs!$D$5","v":4},"项目结束",{"$f":"D15+10","v":"2019-10-12"}]

{"sheet":"calcs","index":1,"n_rows":72,"n_cols":35,"rows_kept":72,"hidden":true}
["***此工作表应继续保持隐藏状态***"]
[]
[null,null,"今天：",{"$f":"TODAY()","v":"2019-07-05"}]
[{"$nulls":3},5]
[null,null,"行数",{"$f":"ROWS(活动[])","v":12}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"窗口活动：",{"$f":"SUMPRODUCT( ((活动[开始时间]>=StartDateWindow)+(活动[结束时间]>=StartDateWindow)>0)*(活动[开始时间]<=(StartDateWindow+WindowDays-1)) )","v":5},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":3},9,{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":3},{"$f":"D10-MIN(D10,D9)","v":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"INDEX(活动[ID],MATCH(1, ((活动[开始时间]>=StartDateWindow)+(活动[结束时间]>=StartDateWindow)>0)*(活动[开始时间]<=(StartDateWindow+WindowDays-1)), 0))","v":-7},{"$f":"OFFSET(E15,-$D$11,)","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"INDEX(活动[ID],MATCH(1, (活动[ID]>E15)*((活动[开始时间]>=StartDateWindow)+(活动[结束时间]>=StartDateWindow)>0)*(活动[开始时间]<=(StartDateWindow+WindowDays-1)), 0))","v":-6},{"$error":"#N/A"}]
[{"$nulls":4},{"$f":"INDEX(活动[ID],MATCH(1, (活动[ID]>E16)*((活动[开始时间]>=StartDateWindow)+(活动[结束时间]>=StartDateWindow)>0)*(活动[开始时间]<=(StartDateWindow+WindowDays-1)), 0))","v":-5},{"$error":"#N/A"}]
[{"$nulls":4},{"$f":"INDEX(活动[ID],MATCH(1, (活动[ID]>E17)*((活动[开始时间]>=StartDateWindow)+(活动[结束时间]>=StartDateWindow)>0)*(活动[开始时间]<=(StartDateWindow+WindowDays-1)), 0))","v":-4},{"$error":"#N/A"}]
[{"$nulls":4},{"$f":"INDEX(活动[ID],MATCH(1, (活动[ID]>E18)*((活动[开始时间]>=StartDateWindow)+(活动[结束时间]>=StartDateWindow)>0)*(活动[开始时间]<=(StartDateWindow+WindowDays-1)), 0))","v":-3},-7]
[{"$nulls":4},{"$f":"INDEX(活动[ID],MATCH(1, (活动[ID]>E19)*((活动[开始时间]>=StartDateWindow)+(活动[结束时间]>=StartDateWindow)>0)*(活动[开始时间]<=(StartDateWindow+WindowDays-1)), 0))","v":{"$error":"#N/A"}},-6]
[{"$nulls":4},{"$f":"INDEX(活动[ID],MATCH(1, (活动[ID]>E20)*((活动[开始时间]>=StartDateWindow)+(活动[结束时间]>=StartDateWindow)>0)*(活动[开始时间]<=(StartDateWindow+WindowDays-1)), 0))","v":{"$error":"#N/A"}},-5]
[{"$nulls":4},{"$f":"INDEX(活动[ID],MATCH(1, (活动[ID]>E21)*((活动[开始时间]>=StartDateWindow)+(活动[结束时间]>=StartDateWindow)>0)*(活动[开始时间]<=(StartDateWindow+WindowDays-1)), 0))","v":{"$error":"#N/A"}},-4]
[{"$nulls":4},{"$f":"INDEX(活动[ID],MATCH(1, (活动[ID]>E22)*((活动[开始时间]>=StartDateWindow)+(活动[结束时间]>=StartDateWindow)>0)*(活动[开始时间]<=(StartDateWindow+WindowDays-1)), 0))","v":{"$error":"#N/A"}},-3]
[]
[null,null,"Calc 窗口开始",{"$f":"StartDate+WindowOffset","v":"2019-07-05"}]
[null,null,"偏移",0]
[]
[null,null,"开始",{"$f":"项目时间线!D3","v":"2019-07-05"}]
[null,null,"窗口",30]
[]
["位置","系列","活动 ID","活动",{"$f":"StartDateWindow","v":"2019-07-05"},{"$f":"E31+1","v":"2019-07-06"},"2019-07-07","2019-07-08","2019-07-09","2019-07-10","2019-07-11","2019-07-12","2019-07-13","2019-07-14","2019-07-15","2019-07-16","2019-07-17","2019-07-18","2019-07-19","2019-07-20","2019-07-21","2019-07-22","2019-07-23","2019-07-24","2019-07-25","2019-07-26","2019-07-27","2019-07-28","2019-07-29","2019-07-30","2019-07-31","2019-08-01","2019-08-02","2019-08-03","2019-08-04"]
[11.3,1,{"$f":"F15","v":{"$error":"#N/A"}},{"$f":"INDEX(活动[活动],MATCH($C32,活动[ID],0))","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[{"$f":"A32-1","v":10.3},2,{"$error":"#N/A"},{"$f":"INDEX(活动[活动],MATCH($C33,活动[ID],0))","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[{"$f":"A33-1","v":9.3},3,{"$error":"#N/A"},{"$f":"INDEX(活动[活动],MATCH($C34,活动[ID],0))","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[8.3,4,{"$error":"#N/A"},{"$f":"INDEX(活动[活动],MATCH($C35,活动[ID],0))","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[7.300000000000001,5,-7,{"$f":"INDEX(活动[活动],MATCH($C36,活动[ID],0))","v":"项目开始"},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":7.300000000000001},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[6.300000000000001,6,-6,{"$f":"INDEX(活动[活动],MATCH($C37,活动[ID],0))","v":"里程碑 1"},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":6.300000000000001},{"$f":"GridCalc","v":6.300000000000001},{"$f":"GridCalc","v":6.300000000000001},{"$f":"GridCalc","v":6.300000000000001},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[5.300000000000001,7,-5,{"$f":"INDEX(活动[活动],MATCH($C38,活动[ID],0))","v":"里程碑 2"},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":5.300000000000001},{"$f":"GridCalc","v":5.300000000000001},{"$f":"GridCalc","v":5.300000000000001},{"$f":"GridCalc","v":5.300000000000001},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[4.300000000000001,8,-4,{"$f":"INDEX(活动[活动],MATCH($C39,活动[ID],0))","v":"里程碑 3"},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":4.300000000000001},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[3.3000000000000007,9,-3,{"$f":"INDEX(活动[活动],MATCH($C40,活动[ID],0))","v":"里程碑 4"},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":3.3000000000000007},{"$f":"GridCalc","v":3.3000000000000007}]
[]
[]
[{"$nulls":4},{"$f":"E31","v":"2019-07-05"},{"$f":"F31","v":"2019-07-06"},"2019-07-07","2019-07-08","2019-07-09","2019-07-10","2019-07-11","2019-07-12","2019-07-13","2019-07-14","2019-07-15","2019-07-16","2019-07-17","2019-07-18","2019-07-19","2019-07-20","2019-07-21","2019-07-22","2019-07-23","2019-07-24","2019-07-25","2019-07-26","2019-07-27","2019-07-28","2019-07-29","2019-07-30","2019-07-31","2019-08-01","2019-08-02","2019-08-03"]
[null,null,{"$f":"C32","v":{"$error":"#N/A"}},{"$f":"UPPER(INDEX(活动[活动],MATCH($C44,活动[ID],0)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(F32),E32,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"C33","v":{"$error":"#N/A"}},{"$f":"UPPER(INDEX(活动[活动],MATCH($C45,活动[ID],0)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(F33),E33,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$error":"#N/A"},{"$f":"UPPER(INDEX(活动[活动],MATCH($C46,活动[ID],0)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(F34),E34,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$error":"#N/A"},{"$f":"UPPER(INDEX(活动[活动],MATCH($C47,活动[ID],0)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(F35),E35,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,-7,{"$f":"UPPER(INDEX(活动[活动],MATCH($C48,活动[ID],0)))","v":"项目开始"},{"$f":"IF(ISERROR(F36),E36,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},7.300000000000001,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,-6,{"$f":"UPPER(INDEX(活动[活动],MATCH($C49,活动[ID],0)))","v":"里程碑 1"},{"$f":"IF(ISERROR(F37),E37,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},6.300000000000001,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,-5,{"$f":"UPPER(INDEX(活动[活动],MATCH($C50,活动[ID],0)))","v":"里程碑 2"},{"$f":"IF(ISERROR(F38),E38,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},5.300000000000001,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,-4,{"$f":"UPPER(INDEX(活动[活动],MATCH($C51,活动[ID],0)))","v":"里程碑 3"},{"$f":"IF(ISERROR(F39),E39,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},4.300000000000001,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,-3,{"$f":"UPPER(INDEX(活动[活动],MATCH($C52,活动[ID],0)))","v":"里程碑 4"},{"$f":"IF(ISERROR(F40),E40,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
[{"$nulls":4},{"$f":"E31","v":"2019-07-05"},{"$f":"F31","v":"2019-07-06"},"2019-07-07","2019-07-08","2019-07-09","2019-07-10","2019-07-11","2019-07-12","2019-07-13","2019-07-14","2019-07-15","2019-07-16","2019-07-17","2019-07-18","2019-07-19","2019-07-20","2019-07-21","2019-07-22","2019-07-23","2019-07-24","2019-07-25","2019-07-26","2019-07-27","2019-07-28","2019-07-29","2019-07-30","2019-07-31","2019-08-01","2019-08-02","2019-08-03"]
[{"$nulls":3},"当前日期",{"$f":"IF(E55=$D$3,5,NA())","v":5},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[{"$nulls":3},{"$f":"DATE(YEAR(MIN(E55:AH55)),MONTH(MIN(E55:AH55)),1)","v":"2019-07-01"},{"$f":"IF(MEDIAN($D58,E$55,EOMONTH($D58,0))=E$55,0.5,NA())","v":0.5},{"$f":"IF(MEDIAN($D58,F$55,EOMONTH($D58,0))=F$55,0.5,NA())","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":3},{"$f":"TEXT(D58,\"yyyy年m月\") & \" - 顶部区段\"","v":"2019年7月 - 顶部区段"},{"$f":"E58+12.5","v":13},{"$f":"F58+12.5","v":13},13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[{"$nulls":3},{"$f":"EOMONTH(D58,0)+1","v":"2019-08-01"},{"$f":"IF(MEDIAN($D61,E$55,EOMONTH($D61,0))=E$55,0.5,NA())","v":{"$error":"#N/A"}},{"$f":"IF(MEDIAN($D61,F$55,EOMONTH($D61,0))=F$55,0.5,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0.5,0.5,0.5]
[{"$nulls":3},{"$f":"TEXT(D61,\"yyyy年m月\") & \" -顶部区段\"","v":"2019年8月 -顶部区段"},{"$f":"E61+12.5","v":{"$error":"#N/A"}},{"$f":"F61+12.5","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13,13,13]
[]
[]
[{"$nulls":3},{"$f":"D58+1","v":"2019-07-02"},{"$f":"IF(MEDIAN($D65,E$55)=E$55,0.5,NA())","v":{"$error":"#N/A"}},{"$f":"IF(MEDIAN($D65,F$55)=F$55,0.5,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":3},{"$f":"D61+1","v":"2019-08-02"},{"$f":"IF(MEDIAN($D66,E$55)=E$55,0.5,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0.5,{"$error":"#N/A"}]
[]
[]
[{"$nulls":4},2.3,{"$f":"E69","v":2.3},{"$f":"F69","v":2.3},2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3]
[{"$nulls":3},3,{"$f":"LEFT(UPPER(TEXT(E55,\"aaa\")),$D70)","v":"FRI"},"SAT","SUN","MON","TUE","WED","THU","FRI","SAT","SUN","MON","TUE","WED","THU","FRI","SAT","SUN","MON","TUE","WED","THU","FRI","SAT","SUN","MON","TUE","WED","THU","FRI","SAT"]
[{"$nulls":4},1.3,{"$f":"E71","v":1.3},1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3]
[{"$nulls":4},{"$f":"TEXT(E55,\"dd\")","v":"05"},{"$f":"TEXT(F55,\"dd\")","v":"06"},"07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","01","02","03"]