{"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(日期值),\"\")","v":9},null,null,"時間",{"$f":"IFERROR(UPPER(TEXT(DATE(報告年,月份數字,報告日),\"yyyy/m/d\")),\"\")","v":"2019/9/9"},null,"一週摘要",{"$nulls":3},"備註/待辦事項清單"]
[{"$nulls":4},{"$f":"時間間隔!E3","v":"06:00:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":"起床"},null,{"$f":"IFERROR(TEXT(DATEVALUE(日期值)+1,\"aaaa\"),\"\")","v":"星期二"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$6&\"|\"&ROW(A1),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":"06:30:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$6&\"|\"&ROW(A1),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":"早餐"},null,null,"拿乾洗衣物"]
[{"$nulls":4},{"$f":"時間間隔!E4","v":"06:15:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(日期值)+1,\"d\"),\"\")","v":"10"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$6&\"|\"&ROW(A2),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":"07:30:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$6&\"|\"&ROW(A2),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":"出門工作"}]
[{"$nulls":4},{"$f":"時間間隔!E5","v":"06:30:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":"沖澡"},null,null,{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$6&\"|\"&ROW(A3),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$6&\"|\"&ROW(A3),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E6","v":"06:45:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,{"$f":"IFERROR(日期值+1,\"\")","v":"2019-09-10"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$6&\"|\"&ROW(A4),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$6&\"|\"&ROW(A4),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""},null,null,"打電話給有線電視公司"]
[null,{"$f":"IFERROR(TEXT(日期值,\"aaaa\"),\"\")","v":"星期一"},null,null,{"$f":"時間間隔!E7","v":"07:00:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$6&\"|\"&ROW(A5),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$6&\"|\"&ROW(A5),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E8","v":"07:15:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$6&\"|\"&ROW(A6),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$6&\"|\"&ROW(A6),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E9","v":"07:30:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":"出門工作"},null,{"$f":"IFERROR(TEXT(DATEVALUE(日期值)+2,\"aaaa\"),\"\")","v":"星期三"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$12&\"|\"&ROW(A1),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$12&\"|\"&ROW(A1),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E10","v":"07:45:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(日期值)+2,\"d\"),\"\")","v":"11"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$12&\"|\"&ROW(A2),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$12&\"|\"&ROW(A2),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[null,"檢視排程",null,null,{"$f":"時間間隔!E11","v":"08:00:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":"開始輪班"},null,null,{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$12&\"|\"&ROW(A3),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$12&\"|\"&ROW(A3),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E12","v":"08:15:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,{"$f":"IFERROR(日期值+2,\"\")","v":"2019-09-11"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$12&\"|\"&ROW(A4),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$12&\"|\"&ROW(A4),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[null,"年份",null,null,{"$f":"時間間隔!E13","v":"08:30:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$12&\"|\"&ROW(A5),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$12&\"|\"&ROW(A5),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E14","v":"08:45:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$12&\"|\"&ROW(A6),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$12&\"|\"&ROW(A6),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[null,"月份",null,null,{"$f":"時間間隔!E15","v":"09:00:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(日期值)+3,\"aaaa\"),\"\")","v":"星期四"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$18&\"|\"&ROW(A1),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$18&\"|\"&ROW(A1),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E16","v":"09:15:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(日期值)+3,\"d\"),\"\")","v":"12"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$18&\"|\"&ROW(A2),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$18&\"|\"&ROW(A2),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[null,"日",null,null,{"$f":"時間間隔!E17","v":"09:30:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$18&\"|\"&ROW(A3),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$18&\"|\"&ROW(A3),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E18","v":"09:45:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,{"$f":"IFERROR(日期值+3,\"\")","v":"2019-09-12"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$18&\"|\"&ROW(A4),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$18&\"|\"&ROW(A4),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[null,"編輯排程",null,null,{"$f":"時間間隔!E19","v":"10:00:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":"休息"},null,null,{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$18&\"|\"&ROW(A5),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$18&\"|\"&ROW(A5),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E20","v":"10:15:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$18&\"|\"&ROW(A6),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$18&\"|\"&ROW(A6),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[null,"選取即可編輯時間間隔",null,null,{"$f":"時間間隔!E21","v":"10:30:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(日期值)+4,\"aaaa\"),\"\")","v":"星期五"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$24&\"|\"&ROW(A1),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$24&\"|\"&ROW(A1),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E22","v":"10:45:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(日期值)+4,\"d\"),\"\")","v":"13"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$24&\"|\"&ROW(A2),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$24&\"|\"&ROW(A2),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[null,"選取即可新增活動",null,null,{"$f":"時間間隔!E23","v":"11:00:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$24&\"|\"&ROW(A3),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$24&\"|\"&ROW(A3),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E24","v":"11:15:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,{"$f":"IFERROR(日期值+4,\"\")","v":"2019-09-13"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$24&\"|\"&ROW(A4),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$24&\"|\"&ROW(A4),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[null,"在排程中醒目提示︰",null,null,{"$f":"時間間隔!E25","v":"11:30:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$24&\"|\"&ROW(A5),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$24&\"|\"&ROW(A5),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[null,"休息",null,null,{"$f":"時間間隔!E26","v":"11:45:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(日期值)+5,\"aaaa\"),\"\")","v":"星期六"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$29&\"|\"&ROW(A1),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$29&\"|\"&ROW(A1),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E27","v":"12:00:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":"午餐"},null,{"$f":"IFERROR(TEXT(DATEVALUE(日期值)+5,\"d\"),\"\")","v":"14"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$29&\"|\"&ROW(A2),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$29&\"|\"&ROW(A2),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E28","v":"12:15:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$29&\"|\"&ROW(A3),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$29&\"|\"&ROW(A3),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E29","v":"12:30:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,{"$f":"IFERROR(日期值+5,\"\")","v":"2019-09-14"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$29&\"|\"&ROW(A4),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$29&\"|\"&ROW(A4),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E30","v":"12:45:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$29&\"|\"&ROW(A5),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$29&\"|\"&ROW(A5),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E31","v":"13:00:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(日期值)+6,\"aaaa\"),\"\")","v":"星期日"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$34&\"|\"&ROW(A1),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$34&\"|\"&ROW(A1),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E32","v":"13:15:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(日期值)+6,\"d\"),\"\")","v":"15"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$34&\"|\"&ROW(A2),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$34&\"|\"&ROW(A2),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E33","v":"13:30:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":"打電話給公司"},null,null,{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$34&\"|\"&ROW(A3),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$34&\"|\"&ROW(A3),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E34","v":"13:45:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,{"$f":"IFERROR(日期值+6,\"\")","v":"2019-09-15"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$34&\"|\"&ROW(A4),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$34&\"|\"&ROW(A4),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E35","v":"14:00:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$34&\"|\"&ROW(A5),活動排程器[唯一的值 (已計算)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH($H$34&\"|\"&ROW(A5),活動排程器[唯一的值 (已計算)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E36","v":"14:15:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E37","v":"14:30:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E38","v":"14:45:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E39","v":"15:00:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":"休息"}]
[{"$nulls":4},{"$f":"時間間隔!E40","v":"15:15:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E41","v":"15:30:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E42","v":"15:45:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E43","v":"16:00:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E44","v":"16:15:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E45","v":"16:30:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E46","v":"16:45:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E47","v":"17:00:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":"回家"}]
[{"$nulls":4},{"$f":"時間間隔!E48","v":"17:15:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E49","v":"17:30:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E50","v":"17:45:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E51","v":"18:00:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":"練習足球"}]
[{"$nulls":4},{"$f":"時間間隔!E52","v":"18:15:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E53","v":"18:30:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E54","v":"18:45:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E55","v":"19:00:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E56","v":"19:15:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E57","v":"19:30:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E58","v":"19:45:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E59","v":"20:00:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E60","v":"20:15:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E61","v":"20:30:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E62","v":"20:45:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E63","v":"21:00:00"},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E64","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E65","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E66","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E67","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E68","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E69","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E70","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E71","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E72","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E73","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E74","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"時間間隔!E75","v":""},{"$f":"IFERROR(INDEX(活動排程器[],MATCH(DATEVALUE(日期值)&每日排程[[#This Row],[時間]],查詢日期和時間,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(日期值)","v":9},null,null,"日期","時間","描述","唯一的值 (已計算)"]
[{"$nulls":4},{"$f":"TODAY()","v":"2019-09-09"},"06:00:00","起床",{"$f":"活動排程器[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E3,E3)","v":"43717|1"}]
[{"$nulls":4},{"$f":"TODAY()","v":"2019-09-09"},"06:30:00","沖澡",{"$f":"活動排程器[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E4,E4)","v":"43717|2"}]
[{"$nulls":4},"2019-09-09","07:30:00","出門工作",{"$f":"活動排程器[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E5,E5)","v":"43717|3"}]
[null,{"$f":"TEXT(日期值,\"aaaa\")","v":"星期一"},null,null,"2019-09-09","08:00:00","開始輪班",{"$f":"活動排程器[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E6,E6)","v":"43717|4"}]
[{"$nulls":4},"2019-09-09","10:00:00","休息",{"$f":"活動排程器[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E7,E7)","v":"43717|5"}]
[null,{"$f":"日期值","v":"2019/9/9"},null,null,"2019-09-09","12:00:00","午餐",{"$f":"活動排程器[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E8,E8)","v":"43717|6"}]
[{"$nulls":4},"2019-09-09","13:00:00","回來繼續工作",{"$f":"活動排程器[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E9,E9)","v":"43717|7"}]
[null,"選取即可編輯時間間隔",null,null,"2019-09-09","13:30:00","打電話給公司",{"$f":"活動排程器[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E10,E10)","v":"43717|8"}]
[{"$nulls":4},"2019-09-09","15:00:00","休息",{"$f":"活動排程器[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E11,E11)","v":"43717|9"}]
[null,"選取即可檢視每日排程",null,null,"2019-09-09","17:00:00","回家",{"$f":"活動排程器[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E12,E12)","v":"43717|10"}]
[{"$nulls":4},"2019-09-09","18:00:00","練習足球",{"$f":"活動排程器[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E13,E13)","v":"43717|11"}]
[{"$nulls":4},{"$f":"TODAY()+1","v":"2019-09-10"},"06:30:00","早餐",{"$f":"活動排程器[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E14,E14)","v":"43718|1"}]
[{"$nulls":4},{"$f":"TODAY()+1","v":"2019-09-10"},"07:30:00","出門工作",{"$f":"活動排程器[[#This Row],[日期]]&\"|\"&COUNTIF($E$3:E15,E15)","v":"43718|2"}]

{"sheet":"時間間隔","index":2,"n_rows":75,"n_cols":5,"rows_kept":75,"merged":[[1,1,1,2],[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},""]