{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Daily Schedule","Event Scheduler","Time Intervals"],"not_rendered":{"images":1,"defined_names":21},"read":"whole","date_system":"1900"}

{"sheet":"Daily Schedule","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,"Daily Schedule"]
[null,{"$f":"IFERROR(DAY(DateVal),\"\")","v":25},null,null,"Time",{"$f":"IFERROR(UPPER(TEXT(DATE(ReportYear,MonthNumber,ReportDay),\"dd mmmm yyyy\")),\"\")","v":"25 MAY 2017"},null,"WEEK AT A GLANCE",{"$nulls":3},"NOTES / TO DO LIST"]
[{"$nulls":4},{"$f":"'Time Intervals'!E3","v":"06:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":"Wake up"},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+1,\"dddd\"),\"\")","v":"Friday"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A1),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":"06:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A1),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":"Breakfast"},null,null,"Pick up dry cleaning"]
[{"$nulls":4},{"$f":"'Time Intervals'!E4","v":"06:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+1,\"d\"),\"\")","v":"26"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A2),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":"07:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A2),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":"Leave for work"}]
[{"$nulls":4},{"$f":"'Time Intervals'!E5","v":"06:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":"Shower"},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A3),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A3),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E6","v":"06:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(DateVal+1,\"\")","v":"2017-05-26"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A4),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A4),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""},null,null,"Call phone company"]
[null,{"$f":"IFERROR(TEXT(DateVal,\"dddd\"),\"\")","v":"Thursday"},null,null,{"$f":"'Time Intervals'!E7","v":"07:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A5),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A5),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E8","v":"07:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A6),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A6),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E9","v":"07:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":"Leave for work"},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+2,\"dddd\"),\"\")","v":"Saturday"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A1),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A1),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E10","v":"07:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+2,\"d\"),\"\")","v":"27"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A2),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A2),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,"VIEW SCHEDULE",null,null,{"$f":"'Time Intervals'!E11","v":"08:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":"Start shift"},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A3),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A3),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E12","v":"08:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(DateVal+2,\"\")","v":"2017-05-27"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A4),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A4),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,"Year",null,null,{"$f":"'Time Intervals'!E13","v":"08:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A5),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A5),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E14","v":"08:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A6),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A6),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,"Month",null,null,{"$f":"'Time Intervals'!E15","v":"09:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+3,\"dddd\"),\"\")","v":"Sunday"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A1),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A1),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E16","v":"09:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+3,\"d\"),\"\")","v":"28"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A2),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A2),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,"Day",null,null,{"$f":"'Time Intervals'!E17","v":"09:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A3),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A3),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E18","v":"09:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(DateVal+3,\"\")","v":"2017-05-28"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A4),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A4),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,"EDIT SCHEDULE",null,null,{"$f":"'Time Intervals'!E19","v":"10:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":"Break"},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A5),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A5),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E20","v":"10:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A6),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A6),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,"Select to edit time intervals",null,null,{"$f":"'Time Intervals'!E21","v":"10:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+4,\"dddd\"),\"\")","v":"Monday"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(A1),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(A1),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E22","v":"10:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+4,\"d\"),\"\")","v":"29"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(A2),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(A2),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,"Select to add a new event",null,null,{"$f":"'Time Intervals'!E23","v":"11:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(A3),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(A3),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E24","v":"11:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(DateVal+4,\"\")","v":"2017-05-29"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(A4),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(A4),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,"HIGHLIGHT IN SCHEDULE:",null,null,{"$f":"'Time Intervals'!E25","v":"11:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(A5),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(A5),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,"Break",null,null,{"$f":"'Time Intervals'!E26","v":"11:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+5,\"dddd\"),\"\")","v":"Tuesday"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A1),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A1),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E27","v":"12:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":"Lunch"},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+5,\"d\"),\"\")","v":"30"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A2),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A2),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E28","v":"12:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A3),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A3),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E29","v":"12:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(DateVal+5,\"\")","v":"2017-05-30"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A4),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A4),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E30","v":"12:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A5),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A5),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E31","v":"13:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+6,\"dddd\"),\"\")","v":"Wednesday"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(A1),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(A1),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E32","v":"13:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(TEXT(DATEVALUE(DateVal)+6,\"d\"),\"\")","v":"31"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(A2),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(A2),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E33","v":"13:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":"Call head office"},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(A3),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(A3),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E34","v":"13:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,{"$f":"IFERROR(DateVal+6,\"\")","v":"2017-05-31"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(A4),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(A4),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E35","v":"14:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(A5),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(A5),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E36","v":"14:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E37","v":"14:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E38","v":"14:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E39","v":"15:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":"Break"}]
[{"$nulls":4},{"$f":"'Time Intervals'!E40","v":"15:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E41","v":"15:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E42","v":"15:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E43","v":"16:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E44","v":"16:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E45","v":"16:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E46","v":"16:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E47","v":"17:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":"Home"}]
[{"$nulls":4},{"$f":"'Time Intervals'!E48","v":"17:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E49","v":"17:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E50","v":"17:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E51","v":"18:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":"Football practice"}]
[{"$nulls":4},{"$f":"'Time Intervals'!E52","v":"18:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E53","v":"18:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E54","v":"18:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E55","v":"19:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E56","v":"19:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E57","v":"19:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E58","v":"19:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E59","v":"20:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E60","v":"20:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E61","v":"20:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E62","v":"20:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E63","v":"21:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E64","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E65","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E66","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E67","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E68","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E69","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E70","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E71","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E72","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E73","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E74","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!E75","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]

{"sheet":"Event Scheduler","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,"Event Scheduler"]
[null,{"$f":"DAY(DateVal)","v":25},null,null,"DATE","TIME","DESCRIPTION","UNIQUE VALUE (CALCULATED)"]
[{"$nulls":4},{"$f":"TODAY()","v":"2017-05-25"},"06:00:00","Wake up",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E3,E3)","v":"42880|1"}]
[{"$nulls":4},{"$f":"TODAY()","v":"2017-05-25"},"06:30:00","Shower",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E4,E4)","v":"42880|2"}]
[{"$nulls":4},"2017-05-25","07:30:00","Leave for work",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E5,E5)","v":"42880|3"}]
[null,{"$f":"TEXT(DateVal,\"dddd\")","v":"Thursday"},null,null,"2017-05-25","08:00:00","Start shift",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E6,E6)","v":"42880|4"}]
[{"$nulls":4},"2017-05-25","10:00:00","Break",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E7,E7)","v":"42880|5"}]
[null,{"$f":"DateVal","v":"25 MAY 2017"},null,null,"2017-05-25","12:00:00","Lunch",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E8,E8)","v":"42880|6"}]
[{"$nulls":4},"2017-05-25","13:00:00","Return to work",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E9,E9)","v":"42880|7"}]
[null,"Select to edit time intervals",null,null,"2017-05-25","13:30:00","Call head office",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E10,E10)","v":"42880|8"}]
[{"$nulls":4},"2017-05-25","15:00:00","Break",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E11,E11)","v":"42880|9"}]
[null,"Select to view Daily Schedule",null,null,"2017-05-25","17:00:00","Home",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E12,E12)","v":"42880|10"}]
[{"$nulls":4},"2017-05-25","18:00:00","Football practice",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E13,E13)","v":"42880|11"}]
[{"$nulls":4},{"$f":"TODAY()+1","v":"2017-05-26"},"06:30:00","Breakfast",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E14,E14)","v":"42881|1"}]
[{"$nulls":4},{"$f":"TODAY()+1","v":"2017-05-26"},"07:30:00","Leave for work",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E15,E15)","v":"42881|2"}]

{"sheet":"Time Intervals","index":2,"n_rows":75,"n_cols":5,"rows_kept":75,"merged":[[1,1,1,2],[9,1,9,2]]}
[null,"Time Intervals"]
[null,"EDIT TIME TABLE",null,null,"Time"]
[{"$nulls":4},{"$f":"Start_time","v":"06:00:00"}]
[null,"Start time","06:00:00",null,{"$f":"IFERROR(IF($E3+Increment>EndTime,\"\",$E3+Increment),\"\")","v":"06:15:00"}]
[{"$nulls":4},"06:30:00"]
[null,"Interval","15 MIN",null,"06:45:00"]
[{"$nulls":4},"07:00:00"]
[null,"End time","21:00:00",null,"07:15:00"]
[{"$nulls":4},"07:30:00"]
[null,"VIEW SCHEDULE",null,null,"07:45:00"]
[{"$nulls":4},"08:00:00"]
[null,"Select to view Daily Schedule",null,null,"08:15:00"]
[{"$nulls":4},"08:30:00"]
[null,"Select to add a new event",null,null,"08:45:00"]
[{"$nulls":4},"09:00:00"]
[{"$nulls":4},"09:15:00"]
[{"$nulls":4},{"$f":"IFERROR(IF($E16+Increment>EndTime,\"\",$E16+Increment),\"\")","v":"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+Increment>EndTime,\"\",$E35+Increment),\"\")","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+Increment>EndTime,\"\",$E67+Increment),\"\")","v":""}]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]