{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["每日计划","活动规划","时间间隔"],"not_rendered":{"images":1,"defined_names":21},"read":"whole","date_system":"1900"}

{"sheet":"每日计划","index":0,"n_rows":75,"n_cols":13,"rows_kept":75,"merged":[[1,1,5,2],[2,12,4,12],[3,7,4,7],[5,12,7,12],[6,1,8,2],[8,12,10,12],[9,7,10,7],[10,1,10,2],[11,12,13,12],[14,12,16,12],[15,7,16,7],[17,12,19,12],[18,1,18,2],[20,12,22,12],[21,7,22,7],[23,12,25,12],[25,1,25,2],[26,7,27,7],[26,12,28,12],[29,12,31,12],[31,7,32,7],[32,12,34,12]]}
[null,"每日日程"]
[null,{"$f":"IFERROR(DAY(DateVal),\"\")","v":25},null,null,"时间",{"$f":"IFERROR(UPPER(TEXT(DATE(ReportYear,MonthNumber,ReportDay),\"[$-x-sysdate]dddd, mmmm dd, yyyy\")),\"\")","v":"2019年11月25日"},null,"每周一览表",{"$nulls":3},"备注/待办事项列表"]
[{"$nulls":4},{"$f":"时间间隔!E3","v":"06:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":"起床"},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+1,\"aaaa\"),\"\")","v":"星期二"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A1),EventScheduler[唯一值（已计算）],0),2),\"\")","v":"06:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A1),EventScheduler[唯一值（已计算）],0),3),\"\")","v":"早餐"},null,null,"取回干洗衣物"]
[{"$nulls":4},{"$f":"时间间隔!E4","v":"06:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+1,\"d\"),\"\")","v":"26"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A2),EventScheduler[唯一值（已计算）],0),2),\"\")","v":"07:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A2),EventScheduler[唯一值（已计算）],0),3),\"\")","v":"出发上班"}]
[{"$nulls":4},{"$f":"时间间隔!E5","v":"06:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":"洗澡"},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A3),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A3),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E6","v":"06:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(DateVal+1,\"\")","v":"2019-11-26"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A4),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A4),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""},null,null,"给有线电视公司打电话"]
[null,{"$f":"IFERROR(TEXT(DateVal,\"aaaa\"),\"\")","v":"星期一"},null,null,{"$f":"时间间隔!E7","v":"07:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A5),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A5),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E8","v":"07:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A6),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A6),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E9","v":"07:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":"出发上班"},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+2,\"aaaa\"),\"\")","v":"星期三"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A1),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A1),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E10","v":"07:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+2,\"d\"),\"\")","v":"27"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A2),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A2),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[null,"查看日程安排",null,null,{"$f":"时间间隔!E11","v":"08:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":"开始换班"},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A3),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A3),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E12","v":"08:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(DateVal+2,\"\")","v":"2019-11-27"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A4),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A4),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[null,"年",null,null,{"$f":"时间间隔!E13","v":"08:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A5),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A5),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E14","v":"08:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A6),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A6),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[null,"月",null,null,{"$f":"时间间隔!E15","v":"09:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+3,\"aaaa\"),\"\")","v":"星期四"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A1),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A1),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E16","v":"09:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+3,\"d\"),\"\")","v":"28"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A2),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A2),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[null,"日",null,null,{"$f":"时间间隔!E17","v":"09:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A3),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A3),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E18","v":"09:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(DateVal+3,\"\")","v":"2019-11-28"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A4),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A4),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[null,"编辑日程安排",null,null,{"$f":"时间间隔!E19","v":"10:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":"休息时间"},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A5),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A5),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E20","v":"10:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A6),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A6),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[null,"选择以编辑时间间隔",null,null,{"$f":"时间间隔!E21","v":"10:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+4,\"aaaa\"),\"\")","v":"星期五"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(A1),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(A1),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E22","v":"10:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+4,\"d\"),\"\")","v":"29"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(A2),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(A2),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[null,"选择以添加新事件",null,null,{"$f":"时间间隔!E23","v":"11:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(A3),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(A3),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E24","v":"11:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(DateVal+4,\"\")","v":"2019-11-29"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(A4),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(A4),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[null,"在日程安排中突出显示：",null,null,{"$f":"时间间隔!E25","v":"11:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(A5),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(A5),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[null,"休息时间",null,null,{"$f":"时间间隔!E26","v":"11:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+5,\"aaaa\"),\"\")","v":"星期六"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A1),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A1),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E27","v":"12:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":"午餐"},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+5,\"d\"),\"\")","v":"30"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A2),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A2),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E28","v":"12:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A3),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A3),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E29","v":"12:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(DateVal+5,\"\")","v":"2019-11-30"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A4),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A4),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E30","v":"12:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A5),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A5),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E31","v":"13:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+6,\"aaaa\"),\"\")","v":"星期日"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(A1),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(A1),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E32","v":"13:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+6,\"d\"),\"\")","v":"1"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(A2),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(A2),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E33","v":"13:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":"给公司打电话"},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(A3),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(A3),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E34","v":"13:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(DateVal+6,\"\")","v":"2019-12-01"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(A4),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(A4),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E35","v":"14:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(A5),EventScheduler[唯一值（已计算）],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(A5),EventScheduler[唯一值（已计算）],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E36","v":"14:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E37","v":"14:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E38","v":"14:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E39","v":"15:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":"休息时间"}]
[{"$nulls":4},{"$f":"时间间隔!E40","v":"15:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E41","v":"15:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E42","v":"15:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E43","v":"16:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E44","v":"16:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E45","v":"16:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E46","v":"16:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E47","v":"17:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":"回家"}]
[{"$nulls":4},{"$f":"时间间隔!E48","v":"17:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E49","v":"17:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E50","v":"17:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E51","v":"18:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":"足球训练"}]
[{"$nulls":4},{"$f":"时间间隔!E52","v":"18:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E53","v":"18:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E54","v":"18:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E55","v":"19:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E56","v":"19:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E57","v":"19:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E58","v":"19:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E59","v":"20:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E60","v":"20:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E61","v":"20:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E62","v":"20:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E63","v":"21:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E64","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E65","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E66","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E67","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E68","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E69","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E70","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E71","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E72","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E73","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E74","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"时间间隔!E75","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&每日计划[[#This Row],[时间]],LookUpDateAndTime,0),3),\"\")","v":""}]

{"sheet":"活动规划","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[1,1,4,2],[5,1,6,2],[7,1,7,2]]}
[null,"活动规划"]
[null,{"$f":"DAY(DateVal)","v":25},null,null,"日期","时间","说明","唯一值（已计算）"]
[{"$nulls":4},{"$f":"TODAY()","v":"2019-11-25"},"06:00:00","起床",{"$f":"EventScheduler[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E3,E3)","v":"43794|1"}]
[{"$nulls":4},{"$f":"TODAY()","v":"2019-11-25"},"06:30:00","洗澡",{"$f":"EventScheduler[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E4,E4)","v":"43794|2"}]
[{"$nulls":4},"2019-11-25","07:30:00","出发上班",{"$f":"EventScheduler[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E5,E5)","v":"43794|3"}]
[null,{"$f":"TEXT(DateVal,\"aaaa\")","v":"星期一"},null,null,"2019-11-25","08:00:00","开始换班",{"$f":"EventScheduler[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E6,E6)","v":"43794|4"}]
[{"$nulls":4},"2019-11-25","10:00:00","休息时间",{"$f":"EventScheduler[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E7,E7)","v":"43794|5"}]
[null,{"$f":"DateVal","v":"2019年11月25日"},null,null,"2019-11-25","12:00:00","午餐",{"$f":"EventScheduler[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E8,E8)","v":"43794|6"}]
[{"$nulls":4},"2019-11-25","13:00:00","继续工作",{"$f":"EventScheduler[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E9,E9)","v":"43794|7"}]
[null,"选择以编辑时间间隔",null,null,"2019-11-25","13:30:00","给公司打电话",{"$f":"EventScheduler[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E10,E10)","v":"43794|8"}]
[{"$nulls":4},"2019-11-25","15:00:00","休息时间",{"$f":"EventScheduler[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E11,E11)","v":"43794|9"}]
[null,"选择以查看每日计划",null,null,"2019-11-25","17:00:00","回家",{"$f":"EventScheduler[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E12,E12)","v":"43794|10"}]
[{"$nulls":4},"2019-11-25","18:00:00","足球训练",{"$f":"EventScheduler[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E13,E13)","v":"43794|11"}]
[{"$nulls":4},{"$f":"TODAY()+1","v":"2019-11-26"},"06:30:00","早餐",{"$f":"EventScheduler[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E14,E14)","v":"43795|1"}]
[{"$nulls":4},{"$f":"TODAY()+1","v":"2019-11-26"},"07:30:00","出发上班",{"$f":"EventScheduler[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E15,E15)","v":"43795|2"}]

{"sheet":"时间间隔","index":2,"n_rows":75,"n_cols":5,"rows_kept":75,"merged":[[9,1,9,2]]}
[null,"时间间隔"]
[null,"编辑时间表",null,null,"时间"]
[{"$nulls":4},{"$f":"开始时间","v":"06:00:00"}]
[null,"开始时间","06:00:00",null,{"$f":"IFERROR(IF($E3+增量>结束时间,\"\",$E3+增量),\"\")","v":"06:15:00"}]
[{"$nulls":4},"06:30:00"]
[null,"间隔","15 分钟",null,"06:45:00"]
[{"$nulls":4},"07:00:00"]
[null,"结束时间","21:00:00",null,"07:15:00"]
[{"$nulls":4},"07:30:00"]
[null,"查看日程安排",null,null,"07:45:00"]
[{"$nulls":4},"08:00:00"]
[null,"选择以查看每日计划",null,null,"08:15:00"]
[{"$nulls":4},"08:30:00"]
[null,"选择以添加新事件",null,null,"08:45:00"]
[{"$nulls":4},"09:00:00"]
[{"$nulls":4},"09:15:00"]
[{"$nulls":4},"09:30:00"]
[{"$nulls":4},"09:45:00"]
[{"$nulls":4},"10:00:00"]
[{"$nulls":4},"10:15:00"]
[{"$nulls":4},"10:30:00"]
[{"$nulls":4},"10:45:00"]
[{"$nulls":4},"11:00:00"]
[{"$nulls":4},"11:15:00"]
[{"$nulls":4},"11:30:00"]
[{"$nulls":4},"11:45:00"]
[{"$nulls":4},"12:00:00"]
[{"$nulls":4},"12:15:00"]
[{"$nulls":4},"12:30:00"]
[{"$nulls":4},"12:45:00"]
[{"$nulls":4},"13:00:00"]
[{"$nulls":4},"13:15:00"]
[{"$nulls":4},"13:30:00"]
[{"$nulls":4},"13:45:00"]
[{"$nulls":4},"14:00:00"]
[{"$nulls":4},{"$f":"IFERROR(IF($E35+增量>结束时间,\"\",$E35+增量),\"\")","v":"14:15:00"}]
[{"$nulls":4},"14:30:00"]
[{"$nulls":4},"14:45:00"]
[{"$nulls":4},"15:00:00"]
[{"$nulls":4},"15:15:00"]
[{"$nulls":4},"15:30:00"]
[{"$nulls":4},"15:45:00"]
[{"$nulls":4},"16:00:00"]
[{"$nulls":4},"16:15:00"]
[{"$nulls":4},"16:30:00"]
[{"$nulls":4},"16:45:00"]
[{"$nulls":4},"17:00:00"]
[{"$nulls":4},"17:15:00"]
[{"$nulls":4},"17:30:00"]
[{"$nulls":4},"17:45:00"]
[{"$nulls":4},"18:00:00"]
[{"$nulls":4},"18:15:00"]
[{"$nulls":4},"18:30:00"]
[{"$nulls":4},"18:45:00"]
[{"$nulls":4},"19:00:00"]
[{"$nulls":4},"19:15:00"]
[{"$nulls":4},"19:30:00"]
[{"$nulls":4},"19:45:00"]
[{"$nulls":4},"20:00:00"]
[{"$nulls":4},"20:15:00"]
[{"$nulls":4},"20:30:00"]
[{"$nulls":4},"20:45:00"]
[{"$nulls":4},"21:00:00"]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},{"$f":"IFERROR(IF($E67+增量>结束时间,\"\",$E67+增量),\"\")","v":""}]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]