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

{"sheet":"Daily Schedule","index":0,"n_rows":36,"n_cols":14,"rows_kept":36,"merged":[[2,1,6,2],[2,7,2,9],[2,11,2,12],[3,11,5,11],[3,12,5,12],[4,7,5,7],[6,11,8,11],[6,12,8,12],[7,1,9,2],[9,11,11,11],[9,12,11,12],[10,7,11,7],[12,1,12,2],[12,11,14,11],[12,12,14,12],[15,11,17,11],[15,12,17,12],[16,7,17,7],[18,11,20,11],[18,12,20,12],[21,1,21,2],[21,11,23,11],[21,12,23,12],[22,7,23,7],[24,11,26,11],[24,12,26,12],[27,7,28,7],[27,11,29,11],[27,12,29,12],[28,1,28,2],[29,1,29,2],[30,11,32,11],[30,12,32,12],[32,7,33,7],[33,11,35,11],[33,12,35,12]]}
[]
[]
[null,{"$f":"DAY(DateVal)","v":10},{"$nulls":3},{"$f":"IFERROR(UPPER(TEXT(DATE(ReportYear,MonthNumber,ReportDay),\"MMMM D, YYYY\")),\"Invalid Date\")","v":"APRIL 10, 2012"},null,"WEEK AT A GLANCE",{"$nulls":3},"NOTES / TO DO LIST",null," "]
[{"$nulls":4},{"$f":"'Time Intervals'!B3","v":"06:00:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"Wake up"},null,{"$f":"TEXT(DATEVALUE(DateVal)+1,\"dddd\")","v":"Wednesday"},{"$f":"IFERROR(INDEX(Input[],MATCH($H$7&\"|\"&ROW(A1),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$7&\"|\"&ROW(A1),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""},null,"c","Pick up dry cleaning"]
[{"$nulls":4},{"$f":"'Time Intervals'!B4","v":"06:30:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"Shower"},null,{"$f":"TEXT(DATEVALUE(DateVal)+1,\"d\")","v":"11"},{"$f":"IFERROR(INDEX(Input[],MATCH($H$7&\"|\"&ROW(A2),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":"06:30:00"},{"$f":"IFERROR(INDEX(Input[],MATCH($H$7&\"|\"&ROW(A2),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":"Breakfast"}]
[{"$nulls":4},{"$f":"'Time Intervals'!B5","v":"07:00:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,null,{"$f":"IFERROR(INDEX(Input[],MATCH($H$7&\"|\"&ROW(A3),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$7&\"|\"&ROW(A3),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!B6","v":"07:30:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"Leave for work"},null,{"$f":"DateVal+1","v":"2012-04-11"},{"$f":"IFERROR(INDEX(Input[],MATCH($H$7&\"|\"&ROW(A4),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$7&\"|\"&ROW(A4),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""},null,"c","Call cable company"]
[null,{"$f":"TEXT(DateVal,\"dddd\")","v":"Tuesday"},null,null,{"$f":"'Time Intervals'!B7","v":"08:00:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"Start shift"},null,null,{"$f":"IFERROR(INDEX(Input[],MATCH($H$7&\"|\"&ROW(A5),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$7&\"|\"&ROW(A5),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!B8","v":"08:30:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,null,{"$f":"IFERROR(INDEX(Input[],MATCH($H$7&\"|\"&ROW(A6),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$7&\"|\"&ROW(A6),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!B9","v":"09:00:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,{"$f":"TEXT(DATEVALUE(DateVal)+2,\"dddd\")","v":"Thursday"},{"$f":"IFERROR(INDEX(Input[],MATCH($H$13&\"|\"&ROW(A1),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$13&\"|\"&ROW(A1),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""},null,"c"]
[{"$nulls":4},{"$f":"'Time Intervals'!B10","v":"09:30:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,{"$f":"TEXT(DATEVALUE(DateVal)+2,\"d\")","v":"12"},{"$f":"IFERROR(INDEX(Input[],MATCH($H$13&\"|\"&ROW(A2),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$13&\"|\"&ROW(A2),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!B11","v":"10:00:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"Break"},null,null,{"$f":"IFERROR(INDEX(Input[],MATCH($H$13&\"|\"&ROW(A3),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$13&\"|\"&ROW(A3),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,"VIEW SCHEDULE",null,null,{"$f":"'Time Intervals'!B12","v":"10:30:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,{"$f":"DateVal+2","v":"2012-04-12"},{"$f":"IFERROR(INDEX(Input[],MATCH($H$13&\"|\"&ROW(A4),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$13&\"|\"&ROW(A4),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""},null,"c"]
[{"$nulls":4},{"$f":"'Time Intervals'!B13","v":"11:00:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,null,{"$f":"IFERROR(INDEX(Input[],MATCH($H$13&\"|\"&ROW(A5),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$13&\"|\"&ROW(A5),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,2012,"Year",null,{"$f":"'Time Intervals'!B14","v":"11:30:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,null,{"$f":"IFERROR(INDEX(Input[],MATCH($H$13&\"|\"&ROW(A6),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$13&\"|\"&ROW(A6),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!B15","v":"12:00:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"Lunch"},null,{"$f":"TEXT(DATEVALUE(DateVal)+3,\"dddd\")","v":"Friday"},{"$f":"IFERROR(INDEX(Input[],MATCH($H$19&\"|\"&ROW(A1),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$19&\"|\"&ROW(A1),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""},null,"c"]
[null,{"$f":"CHOOSE(MonthNumber,\"January\",\"February\",\"March\",\"April\",\"May\",\"June\",\"July\",\"August\",\"September\",\"October\",\"November\",\"December\")","v":"April"},"Month",null,{"$f":"'Time Intervals'!B16","v":"12:30:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,{"$f":"TEXT(DATEVALUE(DateVal)+3,\"d\")","v":"13"},{"$f":"IFERROR(INDEX(Input[],MATCH($H$19&\"|\"&ROW(A2),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$19&\"|\"&ROW(A2),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,4,null,null,{"$f":"'Time Intervals'!B17","v":"13:00:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"Return to work"},null,null,{"$f":"IFERROR(INDEX(Input[],MATCH($H$19&\"|\"&ROW(A3),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$19&\"|\"&ROW(A3),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,10,"Day",null,{"$f":"'Time Intervals'!B18","v":"13:30:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"Call corporate"},null,{"$f":"DateVal+3","v":"2012-04-13"},{"$f":"IFERROR(INDEX(Input[],MATCH($H$19&\"|\"&ROW(A4),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$19&\"|\"&ROW(A4),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""},null,"c"]
[{"$nulls":4},{"$f":"'Time Intervals'!B19","v":"14:00:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,null,{"$f":"IFERROR(INDEX(Input[],MATCH($H$19&\"|\"&ROW(A5),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$19&\"|\"&ROW(A5),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!B20","v":"14:30:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,null,{"$f":"IFERROR(INDEX(Input[],MATCH($H$19&\"|\"&ROW(A6),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$19&\"|\"&ROW(A6),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,"EDIT SCHEDULE",null,null,{"$f":"'Time Intervals'!B21","v":"15:00:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"Break"},null,{"$f":"TEXT(DATEVALUE(DateVal)+4,\"dddd\")","v":"Saturday"},{"$f":"IFERROR(INDEX(Input[],MATCH($H$25&\"|\"&ROW(A1),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$25&\"|\"&ROW(A1),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""},null,"c"]
[{"$nulls":4},{"$f":"'Time Intervals'!B22","v":"15:30:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,{"$f":"TEXT(DATEVALUE(DateVal)+4,\"d\")","v":"14"},{"$f":"IFERROR(INDEX(Input[],MATCH($H$25&\"|\"&ROW(A2),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$25&\"|\"&ROW(A2),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!B23","v":"16:00:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,null,{"$f":"IFERROR(INDEX(Input[],MATCH($H$25&\"|\"&ROW(A3),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$25&\"|\"&ROW(A3),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!B24","v":"16:30:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,{"$f":"DateVal+4","v":"2012-04-14"},{"$f":"IFERROR(INDEX(Input[],MATCH($H$25&\"|\"&ROW(A4),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$25&\"|\"&ROW(A4),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""},null,"c"]
[{"$nulls":4},{"$f":"'Time Intervals'!B25","v":"17:00:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"Home"},null,null,{"$f":"IFERROR(INDEX(Input[],MATCH($H$25&\"|\"&ROW(A5),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$25&\"|\"&ROW(A5),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!B26","v":"17:30:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,{"$f":"TEXT(DATEVALUE(DateVal)+5,\"dddd\")","v":"Sunday"},{"$f":"IFERROR(INDEX(Input[],MATCH($H$30&\"|\"&ROW(A1),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$30&\"|\"&ROW(A1),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!B27","v":"18:00:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"Soccer practice"},null,{"$f":"TEXT(DATEVALUE(DateVal)+5,\"d\")","v":"15"},{"$f":"IFERROR(INDEX(Input[],MATCH($H$30&\"|\"&ROW(A2),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$30&\"|\"&ROW(A2),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""},null,"c"]
[null,"HIGHLIGHT IN SCHEDULE:",null,null,{"$f":"'Time Intervals'!B28","v":"18:30:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,null,{"$f":"IFERROR(INDEX(Input[],MATCH($H$30&\"|\"&ROW(A3),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$30&\"|\"&ROW(A3),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[null,"Break",null,null,{"$f":"'Time Intervals'!B29","v":"19:00:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,{"$f":"DateVal+5","v":"2012-04-15"},{"$f":"IFERROR(INDEX(Input[],MATCH($H$30&\"|\"&ROW(A4),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$30&\"|\"&ROW(A4),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!B30","v":"19:30:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,null,{"$f":"IFERROR(INDEX(Input[],MATCH($H$30&\"|\"&ROW(A5),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$30&\"|\"&ROW(A5),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""},null,"c"]
[{"$nulls":4},{"$f":"'Time Intervals'!B31","v":"20:00:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,{"$f":"TEXT(DATEVALUE(DateVal)+6,\"dddd\")","v":"Monday"},{"$f":"IFERROR(INDEX(Input[],MATCH($H$35&\"|\"&ROW(A1),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$35&\"|\"&ROW(A1),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!B32","v":"20:30:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,{"$f":"TEXT(DATEVALUE(DateVal)+6,\"d\")","v":"16"},{"$f":"IFERROR(INDEX(Input[],MATCH($H$35&\"|\"&ROW(A2),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$35&\"|\"&ROW(A2),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!B33","v":"21:00:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,null,{"$f":"IFERROR(INDEX(Input[],MATCH($H$35&\"|\"&ROW(A3),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$35&\"|\"&ROW(A3),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""},null,"c"]
[{"$nulls":4},{"$f":"'Time Intervals'!B34","v":"21:30:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,{"$f":"DateVal+6","v":"2012-04-16"},{"$f":"IFERROR(INDEX(Input[],MATCH($H$35&\"|\"&ROW(A4),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$35&\"|\"&ROW(A4),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]
[{"$nulls":4},{"$f":"'Time Intervals'!B35","v":"22:00:00"},{"$f":"IFERROR(INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[Time]],LookUpDateAndTime,0),3),\"-\")","v":"-"},null,null,{"$f":"IFERROR(INDEX(Input[],MATCH($H$35&\"|\"&ROW(A5),Input[UNIQUE VALUE (CALCULATED)],0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Input[],MATCH($H$35&\"|\"&ROW(A5),Input[UNIQUE VALUE (CALCULATED)],0),3),\"\")","v":""}]

{"sheet":"Event Scheduler","index":1,"n_rows":17,"n_cols":9,"rows_kept":17,"merged":[[0,1,5,2],[0,4,2,5],[6,1,7,2],[8,1,9,2]]}
[null,{"$f":"DAY(DateVal)","v":10},null,null,"Event Scheduler"]
[]
[{"$nulls":8}," "]
[{"$nulls":4},"DATE","TIME","DESCRIPTION","UNIQUE VALUE (CALCULATED)"," "]
[{"$nulls":4},"2012-04-10","06:00:00","Wake up",{"$f":"Input[[#This Row],[DATE]]&\"|\"&COUNTIF($E$5:E5,E5)","v":"41009|1"}]
[{"$nulls":4},"2012-04-10","06:30:00","Shower",{"$f":"Input[[#This Row],[DATE]]&\"|\"&COUNTIF($E$5:E6,E6)","v":"41009|2"}]
[null,{"$f":"TEXT(DateVal,\"dddd\")","v":"Tuesday"},null,null,"2012-04-10","07:30:00","Leave for work",{"$f":"Input[[#This Row],[DATE]]&\"|\"&COUNTIF($E$5:E7,E7)","v":"41009|3"}]
[{"$nulls":4},"2012-04-10","08:00:00","Start shift",{"$f":"Input[[#This Row],[DATE]]&\"|\"&COUNTIF($E$5:E8,E8)","v":"41009|4"}]
[null,{"$f":"DateVal","v":"APRIL 10, 2012"},null,null,"2012-04-10","10:00:00","Break",{"$f":"Input[[#This Row],[DATE]]&\"|\"&COUNTIF($E$5:E9,E9)","v":"41009|5"}]
[{"$nulls":4},"2012-04-10","12:00:00","Lunch",{"$f":"Input[[#This Row],[DATE]]&\"|\"&COUNTIF($E$5:E10,E10)","v":"41009|6"}]
[{"$nulls":4},"2012-04-10","13:00:00","Return to work",{"$f":"Input[[#This Row],[DATE]]&\"|\"&COUNTIF($E$5:E11,E11)","v":"41009|7"}]
[{"$nulls":4},"2012-04-10","13:30:00","Call corporate",{"$f":"Input[[#This Row],[DATE]]&\"|\"&COUNTIF($E$5:E12,E12)","v":"41009|8"}]
[{"$nulls":4},"2012-04-10","15:00:00","Break",{"$f":"Input[[#This Row],[DATE]]&\"|\"&COUNTIF($E$5:E13,E13)","v":"41009|9"}]
[{"$nulls":4},"2012-04-10","17:00:00","Home",{"$f":"Input[[#This Row],[DATE]]&\"|\"&COUNTIF($E$5:E14,E14)","v":"41009|10"}]
[{"$nulls":4},"2012-04-10","18:00:00","Soccer practice",{"$f":"Input[[#This Row],[DATE]]&\"|\"&COUNTIF($E$5:E15,E15)","v":"41009|11"}]
[{"$nulls":4},"2012-04-11","06:30:00","Breakfast",{"$f":"Input[[#This Row],[DATE]]&\"|\"&COUNTIF($E$5:E17,E16)","v":"41010|2"}]
[{"$nulls":4},"2012-04-11","07:30:00","Leave for work",{"$f":"Input[[#This Row],[DATE]]&\"|\"&COUNTIF($E$5:E17,E17)","v":"41010|2"}," "]

{"sheet":"Time Intervals","index":2,"n_rows":35,"n_cols":2,"rows_kept":35}
[]
[null,"TIME"]
[null,"06:00:00"]
[null,"06:30:00"]
[null,"07:00:00"]
[null,"07:30:00"]
[null,"08:00:00"]
[null,"08:30:00"]
[null,"09:00:00"]
[null,"09:30:00"]
[null,"10:00:00"]
[null,"10:30:00"]
[null,"11:00:00"]
[null,"11:30:00"]
[null,"12:00:00"]
[null,"12:30:00"]
[null,"13:00:00"]
[null,"13:30:00"]
[null,"14:00:00"]
[null,"14:30:00"]
[null,"15:00:00"]
[null,"15:30:00"]
[null,"16:00:00"]
[null,"16:30:00"]
[null,"17:00:00"]
[null,"17:30:00"]
[null,"18:00:00"]
[null,"18:30:00"]
[null,"19:00:00"]
[null,"19:30:00"]
[null,"20:00:00"]
[null,"20:30:00"]
[null,"21:00:00"]
[null,"21:30:00"]
[null,"22:00:00"]