{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Daily Schedule","Event Scheduler","Time Intervals"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":21,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Daily Schedule","index":0,"n_rows":75,"n_cols":13,"rows_kept":75,"cut":false,"hidden":false,"merged":[[25,1,25,2],[31,7,32,7],[1,1,5,2],[23,12,25,12],[26,12,28,12],[29,12,31,12],[10,1,10,2],[18,1,18,2],[9,7,10,7],[15,7,16,7],[21,7,22,7],[3,7,4,7],[17,12,19,12],[6,1,8,2],[2,12,4,12],[5,12,7,12],[26,7,27,7],[11,12,13,12],[32,12,34,12],[8,12,10,12],[14,12,16,12],[20,12,22,12]]}
[null,"Daily Schedule"]
[null,{"$f":"IFERROR(DAY(DateVal),\"\")","v":6},null,null,"Time",{"$f":"IFERROR(UPPER(TEXT(DATE(ReportYear,MonthNumber,ReportDay),\"MMMM D, YYYY\")),\"\")","v":"DECEMBER 6, 2016"},null,"WEEK AT A GLANCE",null,null,null,"NOTES / TO DO LIST"]
[null,null,null,null,{"$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":"Wednesday"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A1),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A1),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""},null,null,"Pick up dry cleaning"]
[null,null,null,null,{"$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":"7"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(#REF!),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(#REF!),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,null,null,null,{"$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(A2),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":"06:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A2),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":"Breakfast"}]
[null,null,null,null,{"$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":"2016-12-07"},{"$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":""},null,null,"Call cable company"]
[null,{"$f":"IFERROR(TEXT(DateVal,\"dddd\"),\"\")","v":"Tuesday"},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(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,null,null,{"$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(A5),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$6&\"|\"&ROW(A5),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,null,null,null,{"$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":"Thursday"},{"$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":""}]
[null,null,null,null,{"$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":"8"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(#REF!),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(#REF!),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(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,null,null,null,{"$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":"2016-12-08"},{"$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":""}]
[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(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,null,null,null,{"$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(A5),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$12&\"|\"&ROW(A5),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":"Friday"},{"$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":""}]
[null,null,null,null,{"$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":"9"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(#REF!),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(#REF!),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(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,null,null,null,{"$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":"2016-12-09"},{"$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":""}]
[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(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,null,null,null,{"$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(A5),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$18&\"|\"&ROW(A5),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":"Saturday"},{"$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":""}]
[null,null,null,null,{"$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":"10"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(#REF!),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$24&\"|\"&ROW(#REF!),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(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,null,null,null,{"$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":"2016-12-10"},{"$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":""}]
[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(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,"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":"Sunday"},{"$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":""}]
[null,null,null,null,{"$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":"11"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(#REF!),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(#REF!),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,null,null,null,{"$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(A2),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A2),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,null,null,null,{"$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":"2016-12-11"},{"$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":""}]
[null,null,null,null,{"$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(A4),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$29&\"|\"&ROW(A4),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,null,null,null,{"$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":"Monday"},{"$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":""}]
[null,null,null,null,{"$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":"12"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(#REF!),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(#REF!),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E33","v":"13:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":"Call corporate"},null,null,{"$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":""}]
[null,null,null,null,{"$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":"2016-12-12"},{"$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":""}]
[null,null,null,null,{"$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(A4),EventScheduler[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH($H$34&\"|\"&ROW(A4),EventScheduler[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E36","v":"14:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E37","v":"14:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E38","v":"14:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E39","v":"15:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":"Break"}]
[null,null,null,null,{"$f":"'Time Intervals'!E40","v":"15:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E41","v":"15:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E42","v":"15:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E43","v":"16:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E44","v":"16:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E45","v":"16:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E46","v":"16:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E47","v":"17:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":"Home"}]
[null,null,null,null,{"$f":"'Time Intervals'!E48","v":"17:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E49","v":"17:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E50","v":"17:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E51","v":"18:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":"Soccer practice"}]
[null,null,null,null,{"$f":"'Time Intervals'!E52","v":"18:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E53","v":"18:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E54","v":"18:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E55","v":"19:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E56","v":"19:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E57","v":"19:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E58","v":"19:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E59","v":"20:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E60","v":"20:15:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E61","v":"20:30:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E62","v":"20:45:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E63","v":"21:00:00"},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E64","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E65","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E66","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E67","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E68","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E69","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E70","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E71","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E72","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E73","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$f":"'Time Intervals'!E74","v":""},{"$f":"IFERROR(INDEX(EventScheduler[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"\")","v":""}]
[null,null,null,null,{"$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,"cut":false,"hidden":false,"merged":[[7,1,7,2],[5,1,6,2],[1,1,4,2]]}
[null,"Event Scheduler"]
[null,{"$f":"DAY(DateVal)","v":6},null,null,"DATE","TIME","DESCRIPTION","UNIQUE VALUE (CALCULATED)"]
[null,null,null,null,{"$f":"TODAY()","v":"2016-12-06"},"06:00:00","Wake up",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E3,E3)","v":"42710|1"}]
[null,null,null,null,{"$f":"TODAY()","v":"2016-12-06"},"06:30:00","Shower",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E4,E4)","v":"42710|2"}]
[null,null,null,null,"2016-12-06","07:30:00","Leave for work",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E5,E5)","v":"42710|3"}]
[null,{"$f":"TEXT(DateVal,\"dddd\")","v":"Tuesday"},null,null,"2016-12-06","08:00:00","Start shift",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E6,E6)","v":"42710|4"}]
[null,null,null,null,"2016-12-06","10:00:00","Break",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E7,E7)","v":"42710|5"}]
[null,{"$f":"DateVal","v":"DECEMBER 6, 2016"},null,null,"2016-12-06","12:00:00","Lunch",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E8,E8)","v":"42710|6"}]
[null,null,null,null,"2016-12-06","13:00:00","Return to work",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E9,E9)","v":"42710|7"}]
[null,"Select to edit time intervals",null,null,"2016-12-06","13:30:00","Call corporate",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E10,E10)","v":"42710|8"}]
[null,null,null,null,"2016-12-06","15:00:00","Break",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E11,E11)","v":"42710|9"}]
[null,"Select to view Daily Schedule",null,null,"2016-12-06","17:00:00","Home",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E12,E12)","v":"42710|10"}]
[null,null,null,null,"2016-12-06","18:00:00","Soccer practice",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E13,E13)","v":"42710|11"}]
[null,null,null,null,{"$f":"TODAY()+1","v":"2016-12-07"},"06:30:00","Breakfast",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E15,E14)","v":"42711|2"}]
[null,null,null,null,{"$f":"TODAY()+1","v":"2016-12-07"},"07:30:00","Leave for work",{"$f":"EventScheduler[[#This Row],[DATE]]&\"|\"&COUNTIF($E$3:E15,E15)","v":"42711|2"}]

{"sheet":"Time Intervals","index":2,"n_rows":75,"n_cols":5,"rows_kept":75,"cut":false,"hidden":false,"merged":[[1,1,1,2],[9,1,9,2]]}
[null,"Time Intervals"]
[null,"EDIT TIME TABLE",null,null,"Time"]
[null,null,null,null,{"$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"}]
[null,null,null,null,"06:30:00"]
[null,"Interval","15 MIN",null,"06:45:00"]
[null,null,null,null,"07:00:00"]
[null,"End time","21:00:00",null,"07:15:00"]
[null,null,null,null,"07:30:00"]
[null,"VIEW SCHEDULE",null,null,"07:45:00"]
[null,null,null,null,"08:00:00"]
[null,"Select to View Daily Schedule",null,null,"08:15:00"]
[null,null,null,null,"08:30:00"]
[null,"Select to add a new event",null,null,"08:45:00"]
[null,null,null,null,"09:00:00"]
[null,null,null,null,"09:15:00"]
[null,null,null,null,"09:30:00"]
[null,null,null,null,"09:45:00"]
[null,null,null,null,"10:00:00"]
[null,null,null,null,"10:15:00"]
[null,null,null,null,"10:30:00"]
[null,null,null,null,"10:45:00"]
[null,null,null,null,"11:00:00"]
[null,null,null,null,"11:15:00"]
[null,null,null,null,"11:30:00"]
[null,null,null,null,"11:45:00"]
[null,null,null,null,"12:00:00"]
[null,null,null,null,"12:15:00"]
[null,null,null,null,"12:30:00"]
[null,null,null,null,"12:45:00"]
[null,null,null,null,"13:00:00"]
[null,null,null,null,"13:15:00"]
[null,null,null,null,"13:30:00"]
[null,null,null,null,"13:45:00"]
[null,null,null,null,"14:00:00"]
[null,null,null,null,{"$f":"IFERROR(IF($E35+Increment>EndTime,\"\",$E35+Increment),\"\")","v":"14:15:00"}]
[null,null,null,null,"14:30:00"]
[null,null,null,null,"14:45:00"]
[null,null,null,null,"15:00:00"]
[null,null,null,null,"15:15:00"]
[null,null,null,null,"15:30:00"]
[null,null,null,null,"15:45:00"]
[null,null,null,null,"16:00:00"]
[null,null,null,null,"16:15:00"]
[null,null,null,null,"16:30:00"]
[null,null,null,null,"16:45:00"]
[null,null,null,null,"17:00:00"]
[null,null,null,null,"17:15:00"]
[null,null,null,null,"17:30:00"]
[null,null,null,null,"17:45:00"]
[null,null,null,null,"18:00:00"]
[null,null,null,null,"18:15:00"]
[null,null,null,null,"18:30:00"]
[null,null,null,null,"18:45:00"]
[null,null,null,null,"19:00:00"]
[null,null,null,null,"19:15:00"]
[null,null,null,null,"19:30:00"]
[null,null,null,null,"19:45:00"]
[null,null,null,null,"20:00:00"]
[null,null,null,null,"20:15:00"]
[null,null,null,null,"20:30:00"]
[null,null,null,null,"20:45:00"]
[null,null,null,null,"21:00:00"]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,{"$f":"IFERROR(IF($E67+Increment>EndTime,\"\",$E67+Increment),\"\")","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]