{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["Settings","January","February","March","April","May","June","July","August","September","October","November","December","Holidays"],"not_rendered":{"defined_names":20},"read":"whole","date_system":"1900"}

{"sheet":"Settings","index":0,"n_rows":34,"n_cols":32,"rows_kept":34,"merged":[[1,17,2,23],[3,1,3,7],[3,8,3,10],[3,17,7,31],[4,1,4,7],[5,1,5,7],[8,1,8,7],[8,9,8,15],[8,17,8,23],[8,25,8,31],[9,1,9,7],[9,9,9,15],[9,17,9,23],[9,25,9,31],[17,1,17,7],[17,9,17,15],[17,17,17,23],[17,25,17,31],[18,1,18,7],[18,9,18,15],[18,17,18,23],[18,25,18,31],[26,1,26,7],[26,9,26,15],[26,17,26,23],[26,25,26,31],[27,1,27,7],[27,9,27,15],[27,17,27,23],[27,25,27,31]]}
[]
[null,"CALENDAR SETTINGS",{"$nulls":15},"YEAR"]
[]
[null,"WEEK START",{"$nulls":6},"SUNDAY",{"$nulls":8},2013]
[null,"SHOW HOLIDAYS",{"$nulls":6},true]
[null,"SHOW OBSERVED",{"$nulls":6},true]
[{"$nulls":8},{"$f":"IF(ShowHolidays,Observed,ShowHolidays)","v":true}]
[null,"ANNUAL VIEW"]
[null,{"$f":"DATE(CalYear,1,1)","v":41275},{"$nulls":7},{"$f":"DATE(CalYear,2,1)","v":41306},{"$nulls":7},{"$f":"DATE(CalYear,3,1)","v":41334},{"$nulls":7},{"$f":"DATE(CalYear,4,1)","v":41365}]
[null,{"$f":"UPPER(TEXT(B9,\"MMMM\"))","v":"JANUARY"},{"$nulls":7},{"$f":"UPPER(TEXT(J9,\"MMMM\"))","v":"FEBRUARY"},{"$nulls":7},{"$f":"UPPER(TEXT(R9,\"MMMM\"))","v":"MARCH"},{"$nulls":7},{"$f":"UPPER(TEXT(Z9,\"MMMM\"))","v":"APRIL"}]
[1,{"$f":"Days+DATE(CalYear,MONTH($B$9),1)-WEEKDAY(DATE(CalYear,MONTH($B$9),1),(WeekStart=\"Monday\")+1)+$A11*7-6","v":"2012-12-30"},"2012-12-31","2013-01-01","2013-01-02","2013-01-03","2013-01-04","2013-01-05",null,{"$f":"Days+DATE(CalYear,MONTH($J$9),1)-WEEKDAY(DATE(CalYear,MONTH($J$9),1),(WeekStart=\"Monday\")+1)+$A11*7-6","v":"2013-01-27"},"2013-01-28","2013-01-29","2013-01-30","2013-01-31","2013-02-01","2013-02-02",null,{"$f":"Days+DATE(CalYear,MONTH($R$9),1)-WEEKDAY(DATE(CalYear,MONTH($R$9),1),(WeekStart=\"Monday\")+1)+$A11*7-6","v":"2013-02-24"},"2013-02-25","2013-02-26","2013-02-27","2013-02-28","2013-03-01","2013-03-02",null,{"$f":"Days+DATE(CalYear,MONTH($Z$9),1)-WEEKDAY(DATE(CalYear,MONTH($Z$9),1),(WeekStart=\"Monday\")+1)+$A11*7-6","v":"2013-03-31"},"2013-04-01","2013-04-02","2013-04-03","2013-04-04","2013-04-05","2013-04-06"]
[2,{"$f":"Days+DATE(CalYear,MONTH($B$9),1)-WEEKDAY(DATE(CalYear,MONTH($B$9),1),(WeekStart=\"Monday\")+1)+$A12*7-6","v":"2013-01-06"},"2013-01-07","2013-01-08","2013-01-09","2013-01-10","2013-01-11","2013-01-12",null,{"$f":"Days+DATE(CalYear,MONTH($J$9),1)-WEEKDAY(DATE(CalYear,MONTH($J$9),1),(WeekStart=\"Monday\")+1)+$A12*7-6","v":"2013-02-03"},"2013-02-04","2013-02-05","2013-02-06","2013-02-07","2013-02-08","2013-02-09",null,{"$f":"Days+DATE(CalYear,MONTH($R$9),1)-WEEKDAY(DATE(CalYear,MONTH($R$9),1),(WeekStart=\"Monday\")+1)+$A12*7-6","v":"2013-03-03"},"2013-03-04","2013-03-05","2013-03-06","2013-03-07","2013-03-08","2013-03-09",null,{"$f":"Days+DATE(CalYear,MONTH($Z$9),1)-WEEKDAY(DATE(CalYear,MONTH($Z$9),1),(WeekStart=\"Monday\")+1)+$A12*7-6","v":"2013-04-07"},"2013-04-08","2013-04-09","2013-04-10","2013-04-11","2013-04-12","2013-04-13"]
[3,{"$f":"Days+DATE(CalYear,MONTH($B$9),1)-WEEKDAY(DATE(CalYear,MONTH($B$9),1),(WeekStart=\"Monday\")+1)+$A13*7-6","v":"2013-01-13"},"2013-01-14","2013-01-15","2013-01-16","2013-01-17","2013-01-18","2013-01-19",null,{"$f":"Days+DATE(CalYear,MONTH($J$9),1)-WEEKDAY(DATE(CalYear,MONTH($J$9),1),(WeekStart=\"Monday\")+1)+$A13*7-6","v":"2013-02-10"},"2013-02-11","2013-02-12","2013-02-13","2013-02-14","2013-02-15","2013-02-16",null,{"$f":"Days+DATE(CalYear,MONTH($R$9),1)-WEEKDAY(DATE(CalYear,MONTH($R$9),1),(WeekStart=\"Monday\")+1)+$A13*7-6","v":"2013-03-10"},"2013-03-11","2013-03-12","2013-03-13","2013-03-14","2013-03-15","2013-03-16",null,{"$f":"Days+DATE(CalYear,MONTH($Z$9),1)-WEEKDAY(DATE(CalYear,MONTH($Z$9),1),(WeekStart=\"Monday\")+1)+$A13*7-6","v":"2013-04-14"},"2013-04-15","2013-04-16","2013-04-17","2013-04-18","2013-04-19","2013-04-20"]
[4,{"$f":"Days+DATE(CalYear,MONTH($B$9),1)-WEEKDAY(DATE(CalYear,MONTH($B$9),1),(WeekStart=\"Monday\")+1)+$A14*7-6","v":"2013-01-20"},"2013-01-21","2013-01-22","2013-01-23","2013-01-24","2013-01-25","2013-01-26",null,{"$f":"Days+DATE(CalYear,MONTH($J$9),1)-WEEKDAY(DATE(CalYear,MONTH($J$9),1),(WeekStart=\"Monday\")+1)+$A14*7-6","v":"2013-02-17"},"2013-02-18","2013-02-19","2013-02-20","2013-02-21","2013-02-22","2013-02-23",null,{"$f":"Days+DATE(CalYear,MONTH($R$9),1)-WEEKDAY(DATE(CalYear,MONTH($R$9),1),(WeekStart=\"Monday\")+1)+$A14*7-6","v":"2013-03-17"},"2013-03-18","2013-03-19","2013-03-20","2013-03-21","2013-03-22","2013-03-23",null,{"$f":"Days+DATE(CalYear,MONTH($Z$9),1)-WEEKDAY(DATE(CalYear,MONTH($Z$9),1),(WeekStart=\"Monday\")+1)+$A14*7-6","v":"2013-04-21"},"2013-04-22","2013-04-23","2013-04-24","2013-04-25","2013-04-26","2013-04-27"]
[5,{"$f":"Days+DATE(CalYear,MONTH($B$9),1)-WEEKDAY(DATE(CalYear,MONTH($B$9),1),(WeekStart=\"Monday\")+1)+$A15*7-6","v":"2013-01-27"},"2013-01-28","2013-01-29","2013-01-30","2013-01-31","2013-02-01","2013-02-02",null,{"$f":"Days+DATE(CalYear,MONTH($J$9),1)-WEEKDAY(DATE(CalYear,MONTH($J$9),1),(WeekStart=\"Monday\")+1)+$A15*7-6","v":"2013-02-24"},"2013-02-25","2013-02-26","2013-02-27","2013-02-28","2013-03-01","2013-03-02",null,{"$f":"Days+DATE(CalYear,MONTH($R$9),1)-WEEKDAY(DATE(CalYear,MONTH($R$9),1),(WeekStart=\"Monday\")+1)+$A15*7-6","v":"2013-03-24"},"2013-03-25","2013-03-26","2013-03-27","2013-03-28","2013-03-29","2013-03-30",null,{"$f":"Days+DATE(CalYear,MONTH($Z$9),1)-WEEKDAY(DATE(CalYear,MONTH($Z$9),1),(WeekStart=\"Monday\")+1)+$A15*7-6","v":"2013-04-28"},"2013-04-29","2013-04-30","2013-05-01","2013-05-02","2013-05-03","2013-05-04"]
[6,{"$f":"Days+DATE(CalYear,MONTH($B$9),1)-WEEKDAY(DATE(CalYear,MONTH($B$9),1),(WeekStart=\"Monday\")+1)+$A16*7-6","v":"2013-02-03"},"2013-02-04","2013-02-05","2013-02-06","2013-02-07","2013-02-08","2013-02-09",null,{"$f":"Days+DATE(CalYear,MONTH($J$9),1)-WEEKDAY(DATE(CalYear,MONTH($J$9),1),(WeekStart=\"Monday\")+1)+$A16*7-6","v":"2013-03-03"},"2013-03-04","2013-03-05","2013-03-06","2013-03-07","2013-03-08","2013-03-09",null,{"$f":"Days+DATE(CalYear,MONTH($R$9),1)-WEEKDAY(DATE(CalYear,MONTH($R$9),1),(WeekStart=\"Monday\")+1)+$A16*7-6","v":"2013-03-31"},"2013-04-01","2013-04-02","2013-04-03","2013-04-04","2013-04-05","2013-04-06",null,{"$f":"Days+DATE(CalYear,MONTH($Z$9),1)-WEEKDAY(DATE(CalYear,MONTH($Z$9),1),(WeekStart=\"Monday\")+1)+$A16*7-6","v":"2013-05-05"},"2013-05-06","2013-05-07","2013-05-08","2013-05-09","2013-05-10","2013-05-11"]
[]
[null,{"$f":"DATE(CalYear,5,1)","v":41395},{"$nulls":7},{"$f":"DATE(CalYear,6,1)","v":41426},{"$nulls":7},{"$f":"DATE(CalYear,7,1)","v":41456},{"$nulls":7},{"$f":"DATE(CalYear,8,1)","v":41487}]
[null,{"$f":"UPPER(TEXT(B18,\"MMMM\"))","v":"MAY"},{"$nulls":7},{"$f":"UPPER(TEXT(J18,\"MMMM\"))","v":"JUNE"},{"$nulls":7},{"$f":"UPPER(TEXT(R18,\"MMMM\"))","v":"JULY"},{"$nulls":7},{"$f":"UPPER(TEXT(Z18,\"MMMM\"))","v":"AUGUST"}]
[1,{"$f":"Days+DATE(CalYear,MONTH($B$18),1)-WEEKDAY(DATE(CalYear,MONTH($B$18),1),(WeekStart=\"Monday\")+1)+$A20*7-6","v":"2013-04-28"},"2013-04-29","2013-04-30","2013-05-01","2013-05-02","2013-05-03","2013-05-04",null,{"$f":"Days+DATE(CalYear,MONTH($J$18),1)-WEEKDAY(DATE(CalYear,MONTH($J$18),1),(WeekStart=\"Monday\")+1)+$A20*7-6","v":"2013-05-26"},"2013-05-27","2013-05-28","2013-05-29","2013-05-30","2013-05-31","2013-06-01",null,{"$f":"Days+DATE(CalYear,MONTH($R$18),1)-WEEKDAY(DATE(CalYear,MONTH($R$18),1),(WeekStart=\"Monday\")+1)+$A20*7-6","v":"2013-06-30"},"2013-07-01","2013-07-02","2013-07-03","2013-07-04","2013-07-05","2013-07-06",null,{"$f":"Days+DATE(CalYear,MONTH($Z$18),1)-WEEKDAY(DATE(CalYear,MONTH($Z$18),1),(WeekStart=\"Monday\")+1)+$A20*7-6","v":"2013-07-28"},"2013-07-29","2013-07-30","2013-07-31","2013-08-01","2013-08-02","2013-08-03"]
[2,{"$f":"Days+DATE(CalYear,MONTH($B$18),1)-WEEKDAY(DATE(CalYear,MONTH($B$18),1),(WeekStart=\"Monday\")+1)+$A21*7-6","v":"2013-05-05"},"2013-05-06","2013-05-07","2013-05-08","2013-05-09","2013-05-10","2013-05-11",null,{"$f":"Days+DATE(CalYear,MONTH($J$18),1)-WEEKDAY(DATE(CalYear,MONTH($J$18),1),(WeekStart=\"Monday\")+1)+$A21*7-6","v":"2013-06-02"},"2013-06-03","2013-06-04","2013-06-05","2013-06-06","2013-06-07","2013-06-08",null,{"$f":"Days+DATE(CalYear,MONTH($R$18),1)-WEEKDAY(DATE(CalYear,MONTH($R$18),1),(WeekStart=\"Monday\")+1)+$A21*7-6","v":"2013-07-07"},"2013-07-08","2013-07-09","2013-07-10","2013-07-11","2013-07-12","2013-07-13",null,{"$f":"Days+DATE(CalYear,MONTH($Z$18),1)-WEEKDAY(DATE(CalYear,MONTH($Z$18),1),(WeekStart=\"Monday\")+1)+$A21*7-6","v":"2013-08-04"},"2013-08-05","2013-08-06","2013-08-07","2013-08-08","2013-08-09","2013-08-10"]
[3,{"$f":"Days+DATE(CalYear,MONTH($B$18),1)-WEEKDAY(DATE(CalYear,MONTH($B$18),1),(WeekStart=\"Monday\")+1)+$A22*7-6","v":"2013-05-12"},"2013-05-13","2013-05-14","2013-05-15","2013-05-16","2013-05-17","2013-05-18",null,{"$f":"Days+DATE(CalYear,MONTH($J$18),1)-WEEKDAY(DATE(CalYear,MONTH($J$18),1),(WeekStart=\"Monday\")+1)+$A22*7-6","v":"2013-06-09"},"2013-06-10","2013-06-11","2013-06-12","2013-06-13","2013-06-14","2013-06-15",null,{"$f":"Days+DATE(CalYear,MONTH($R$18),1)-WEEKDAY(DATE(CalYear,MONTH($R$18),1),(WeekStart=\"Monday\")+1)+$A22*7-6","v":"2013-07-14"},"2013-07-15","2013-07-16","2013-07-17","2013-07-18","2013-07-19","2013-07-20",null,{"$f":"Days+DATE(CalYear,MONTH($Z$18),1)-WEEKDAY(DATE(CalYear,MONTH($Z$18),1),(WeekStart=\"Monday\")+1)+$A22*7-6","v":"2013-08-11"},"2013-08-12","2013-08-13","2013-08-14","2013-08-15","2013-08-16","2013-08-17"]
[4,{"$f":"Days+DATE(CalYear,MONTH($B$18),1)-WEEKDAY(DATE(CalYear,MONTH($B$18),1),(WeekStart=\"Monday\")+1)+$A23*7-6","v":"2013-05-19"},"2013-05-20","2013-05-21","2013-05-22","2013-05-23","2013-05-24","2013-05-25",null,{"$f":"Days+DATE(CalYear,MONTH($J$18),1)-WEEKDAY(DATE(CalYear,MONTH($J$18),1),(WeekStart=\"Monday\")+1)+$A23*7-6","v":"2013-06-16"},"2013-06-17","2013-06-18","2013-06-19","2013-06-20","2013-06-21","2013-06-22",null,{"$f":"Days+DATE(CalYear,MONTH($R$18),1)-WEEKDAY(DATE(CalYear,MONTH($R$18),1),(WeekStart=\"Monday\")+1)+$A23*7-6","v":"2013-07-21"},"2013-07-22","2013-07-23","2013-07-24","2013-07-25","2013-07-26","2013-07-27",null,{"$f":"Days+DATE(CalYear,MONTH($Z$18),1)-WEEKDAY(DATE(CalYear,MONTH($Z$18),1),(WeekStart=\"Monday\")+1)+$A23*7-6","v":"2013-08-18"},"2013-08-19","2013-08-20","2013-08-21","2013-08-22","2013-08-23","2013-08-24"]
[5,{"$f":"Days+DATE(CalYear,MONTH($B$18),1)-WEEKDAY(DATE(CalYear,MONTH($B$18),1),(WeekStart=\"Monday\")+1)+$A24*7-6","v":"2013-05-26"},"2013-05-27","2013-05-28","2013-05-29","2013-05-30","2013-05-31","2013-06-01",null,{"$f":"Days+DATE(CalYear,MONTH($J$18),1)-WEEKDAY(DATE(CalYear,MONTH($J$18),1),(WeekStart=\"Monday\")+1)+$A24*7-6","v":"2013-06-23"},"2013-06-24","2013-06-25","2013-06-26","2013-06-27","2013-06-28","2013-06-29",null,{"$f":"Days+DATE(CalYear,MONTH($R$18),1)-WEEKDAY(DATE(CalYear,MONTH($R$18),1),(WeekStart=\"Monday\")+1)+$A24*7-6","v":"2013-07-28"},"2013-07-29","2013-07-30","2013-07-31","2013-08-01","2013-08-02","2013-08-03",null,{"$f":"Days+DATE(CalYear,MONTH($Z$18),1)-WEEKDAY(DATE(CalYear,MONTH($Z$18),1),(WeekStart=\"Monday\")+1)+$A24*7-6","v":"2013-08-25"},"2013-08-26","2013-08-27","2013-08-28","2013-08-29","2013-08-30","2013-08-31"]
[6,{"$f":"Days+DATE(CalYear,MONTH($B$18),1)-WEEKDAY(DATE(CalYear,MONTH($B$18),1),(WeekStart=\"Monday\")+1)+$A25*7-6","v":"2013-06-02"},"2013-06-03","2013-06-04","2013-06-05","2013-06-06","2013-06-07","2013-06-08",null,{"$f":"Days+DATE(CalYear,MONTH($J$18),1)-WEEKDAY(DATE(CalYear,MONTH($J$18),1),(WeekStart=\"Monday\")+1)+$A25*7-6","v":"2013-06-30"},"2013-07-01","2013-07-02","2013-07-03","2013-07-04","2013-07-05","2013-07-06",null,{"$f":"Days+DATE(CalYear,MONTH($R$18),1)-WEEKDAY(DATE(CalYear,MONTH($R$18),1),(WeekStart=\"Monday\")+1)+$A25*7-6","v":"2013-08-04"},"2013-08-05","2013-08-06","2013-08-07","2013-08-08","2013-08-09","2013-08-10",null,{"$f":"Days+DATE(CalYear,MONTH($Z$18),1)-WEEKDAY(DATE(CalYear,MONTH($Z$18),1),(WeekStart=\"Monday\")+1)+$A25*7-6","v":"2013-09-01"},"2013-09-02","2013-09-03","2013-09-04","2013-09-05","2013-09-06","2013-09-07"]
[]
[null,{"$f":"DATE(CalYear,9,1)","v":41518},{"$nulls":7},{"$f":"DATE(CalYear,10,1)","v":41548},{"$nulls":7},{"$f":"DATE(CalYear,11,1)","v":41579},{"$nulls":7},{"$f":"DATE(CalYear,12,1)","v":41609}]
[null,{"$f":"UPPER(TEXT(B27,\"MMMM\"))","v":"SEPTEMBER"},{"$nulls":7},{"$f":"UPPER(TEXT(J27,\"MMMM\"))","v":"OCTOBER"},{"$nulls":7},{"$f":"UPPER(TEXT(R27,\"MMMM\"))","v":"NOVEMBER"},{"$nulls":7},{"$f":"UPPER(TEXT(Z27,\"MMMM\"))","v":"DECEMBER"}]
[1,{"$f":"Days+DATE(CalYear,MONTH($B$27),1)-WEEKDAY(DATE(CalYear,MONTH($B$27),1),(WeekStart=\"Monday\")+1)+$A29*7-6","v":"2013-09-01"},"2013-09-02","2013-09-03","2013-09-04","2013-09-05","2013-09-06","2013-09-07",null,{"$f":"Days+DATE(CalYear,MONTH($J$27),1)-WEEKDAY(DATE(CalYear,MONTH($J$27),1),(WeekStart=\"Monday\")+1)+$A29*7-6","v":"2013-09-29"},"2013-09-30","2013-10-01","2013-10-02","2013-10-03","2013-10-04","2013-10-05",null,{"$f":"Days+DATE(CalYear,MONTH($R$27),1)-WEEKDAY(DATE(CalYear,MONTH($R$27),1),(WeekStart=\"Monday\")+1)+$A29*7-6","v":"2013-10-27"},"2013-10-28","2013-10-29","2013-10-30","2013-10-31","2013-11-01","2013-11-02",null,{"$f":"Days+DATE(CalYear,MONTH($Z$27),1)-WEEKDAY(DATE(CalYear,MONTH($Z$27),1),(WeekStart=\"Monday\")+1)+$A29*7-6","v":"2013-12-01"},"2013-12-02","2013-12-03","2013-12-04","2013-12-05","2013-12-06","2013-12-07"]
[2,{"$f":"Days+DATE(CalYear,MONTH($B$27),1)-WEEKDAY(DATE(CalYear,MONTH($B$27),1),(WeekStart=\"Monday\")+1)+$A30*7-6","v":"2013-09-08"},"2013-09-09","2013-09-10","2013-09-11","2013-09-12","2013-09-13","2013-09-14",null,{"$f":"Days+DATE(CalYear,MONTH($J$27),1)-WEEKDAY(DATE(CalYear,MONTH($J$27),1),(WeekStart=\"Monday\")+1)+$A30*7-6","v":"2013-10-06"},"2013-10-07","2013-10-08","2013-10-09","2013-10-10","2013-10-11","2013-10-12",null,{"$f":"Days+DATE(CalYear,MONTH($R$27),1)-WEEKDAY(DATE(CalYear,MONTH($R$27),1),(WeekStart=\"Monday\")+1)+$A30*7-6","v":"2013-11-03"},"2013-11-04","2013-11-05","2013-11-06","2013-11-07","2013-11-08","2013-11-09",null,{"$f":"Days+DATE(CalYear,MONTH($Z$27),1)-WEEKDAY(DATE(CalYear,MONTH($Z$27),1),(WeekStart=\"Monday\")+1)+$A30*7-6","v":"2013-12-08"},"2013-12-09","2013-12-10","2013-12-11","2013-12-12","2013-12-13","2013-12-14"]
[3,{"$f":"Days+DATE(CalYear,MONTH($B$27),1)-WEEKDAY(DATE(CalYear,MONTH($B$27),1),(WeekStart=\"Monday\")+1)+$A31*7-6","v":"2013-09-15"},"2013-09-16","2013-09-17","2013-09-18","2013-09-19","2013-09-20","2013-09-21",null,{"$f":"Days+DATE(CalYear,MONTH($J$27),1)-WEEKDAY(DATE(CalYear,MONTH($J$27),1),(WeekStart=\"Monday\")+1)+$A31*7-6","v":"2013-10-13"},"2013-10-14","2013-10-15","2013-10-16","2013-10-17","2013-10-18","2013-10-19",null,{"$f":"Days+DATE(CalYear,MONTH($R$27),1)-WEEKDAY(DATE(CalYear,MONTH($R$27),1),(WeekStart=\"Monday\")+1)+$A31*7-6","v":"2013-11-10"},"2013-11-11","2013-11-12","2013-11-13","2013-11-14","2013-11-15","2013-11-16",null,{"$f":"Days+DATE(CalYear,MONTH($Z$27),1)-WEEKDAY(DATE(CalYear,MONTH($Z$27),1),(WeekStart=\"Monday\")+1)+$A31*7-6","v":"2013-12-15"},"2013-12-16","2013-12-17","2013-12-18","2013-12-19","2013-12-20","2013-12-21"]
[4,{"$f":"Days+DATE(CalYear,MONTH($B$27),1)-WEEKDAY(DATE(CalYear,MONTH($B$27),1),(WeekStart=\"Monday\")+1)+$A32*7-6","v":"2013-09-22"},"2013-09-23","2013-09-24","2013-09-25","2013-09-26","2013-09-27","2013-09-28",null,{"$f":"Days+DATE(CalYear,MONTH($J$27),1)-WEEKDAY(DATE(CalYear,MONTH($J$27),1),(WeekStart=\"Monday\")+1)+$A32*7-6","v":"2013-10-20"},"2013-10-21","2013-10-22","2013-10-23","2013-10-24","2013-10-25","2013-10-26",null,{"$f":"Days+DATE(CalYear,MONTH($R$27),1)-WEEKDAY(DATE(CalYear,MONTH($R$27),1),(WeekStart=\"Monday\")+1)+$A32*7-6","v":"2013-11-17"},"2013-11-18","2013-11-19","2013-11-20","2013-11-21","2013-11-22","2013-11-23",null,{"$f":"Days+DATE(CalYear,MONTH($Z$27),1)-WEEKDAY(DATE(CalYear,MONTH($Z$27),1),(WeekStart=\"Monday\")+1)+$A32*7-6","v":"2013-12-22"},"2013-12-23","2013-12-24","2013-12-25","2013-12-26","2013-12-27","2013-12-28"]
[5,{"$f":"Days+DATE(CalYear,MONTH($B$27),1)-WEEKDAY(DATE(CalYear,MONTH($B$27),1),(WeekStart=\"Monday\")+1)+$A33*7-6","v":"2013-09-29"},"2013-09-30","2013-10-01","2013-10-02","2013-10-03","2013-10-04","2013-10-05",null,{"$f":"Days+DATE(CalYear,MONTH($J$27),1)-WEEKDAY(DATE(CalYear,MONTH($J$27),1),(WeekStart=\"Monday\")+1)+$A33*7-6","v":"2013-10-27"},"2013-10-28","2013-10-29","2013-10-30","2013-10-31","2013-11-01","2013-11-02",null,{"$f":"Days+DATE(CalYear,MONTH($R$27),1)-WEEKDAY(DATE(CalYear,MONTH($R$27),1),(WeekStart=\"Monday\")+1)+$A33*7-6","v":"2013-11-24"},"2013-11-25","2013-11-26","2013-11-27","2013-11-28","2013-11-29","2013-11-30",null,{"$f":"Days+DATE(CalYear,MONTH($Z$27),1)-WEEKDAY(DATE(CalYear,MONTH($Z$27),1),(WeekStart=\"Monday\")+1)+$A33*7-6","v":"2013-12-29"},"2013-12-30","2013-12-31","2014-01-01","2014-01-02","2014-01-03","2014-01-04"]
[6,{"$f":"Days+DATE(CalYear,MONTH($B$27),1)-WEEKDAY(DATE(CalYear,MONTH($B$27),1),(WeekStart=\"Monday\")+1)+$A34*7-6","v":"2013-10-06"},"2013-10-07","2013-10-08","2013-10-09","2013-10-10","2013-10-11","2013-10-12",null,{"$f":"Days+DATE(CalYear,MONTH($J$27),1)-WEEKDAY(DATE(CalYear,MONTH($J$27),1),(WeekStart=\"Monday\")+1)+$A34*7-6","v":"2013-11-03"},"2013-11-04","2013-11-05","2013-11-06","2013-11-07","2013-11-08","2013-11-09",null,{"$f":"Days+DATE(CalYear,MONTH($R$27),1)-WEEKDAY(DATE(CalYear,MONTH($R$27),1),(WeekStart=\"Monday\")+1)+$A34*7-6","v":"2013-12-01"},"2013-12-02","2013-12-03","2013-12-04","2013-12-05","2013-12-06","2013-12-07",null,{"$f":"Days+DATE(CalYear,MONTH($Z$27),1)-WEEKDAY(DATE(CalYear,MONTH($Z$27),1),(WeekStart=\"Monday\")+1)+$A34*7-6","v":"2014-01-05"},"2014-01-06","2014-01-07","2014-01-08","2014-01-09","2014-01-10","2014-01-11"]

{"sheet":"January","index":1,"n_rows":17,"n_cols":8,"rows_kept":17,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2013-01-13"}]
[]
[null,{"$f":"WeekStart","v":"SUNDAY"},{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
[null,{"$f":"Days+DATE(CalYear,1,1)-WEEKDAY(DATE(CalYear,1,1),(WeekStart=\"Monday\")+1)+1","v":"2012-12-30"},"2012-12-31","2013-01-01","2013-01-02","2013-01-03","2013-01-04","2013-01-05"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"New Years Day"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,1,1)-WEEKDAY(DATE(CalYear,1,1),(WeekStart=\"Monday\")+1)+8","v":"2013-01-06"},"2013-01-07","2013-01-08","2013-01-09","2013-01-10","2013-01-11","2013-01-12"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,1,1)-WEEKDAY(DATE(CalYear,1,1),(WeekStart=\"Monday\")+1)+15","v":"2013-01-13"},"2013-01-14","2013-01-15","2013-01-16","2013-01-17","2013-01-18","2013-01-19"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,1,1)-WEEKDAY(DATE(CalYear,1,1),(WeekStart=\"Monday\")+1)+22","v":"2013-01-20"},"2013-01-21","2013-01-22","2013-01-23","2013-01-24","2013-01-25","2013-01-26"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"Martin Luther King, Jr. Day *"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,1,1)-WEEKDAY(DATE(CalYear,1,1),(WeekStart=\"Monday\")+1)+29","v":"2013-01-27"},"2013-01-28","2013-01-29","2013-01-30","2013-01-31","2013-02-01","2013-02-02"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,1,1)-WEEKDAY(DATE(CalYear,1,1),(WeekStart=\"Monday\")+1)+36","v":"2013-02-03"},"2013-02-04","NOTES"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"IF(Holidays!$C$6=\"Martin Luther King, Jr. Day *\",\"* Martin Luther King Jr. Day and Inaguration Day\", \"\")","v":"* Martin Luther King Jr. Day and Inaguration Day"}]

{"sheet":"February","index":2,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2013-02-10"}]
[]
[null,"SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
[null,{"$f":"Days+DATE(CalYear,2,1)-WEEKDAY(DATE(CalYear,2,1),(WeekStart=\"Monday\")+1)+1","v":"2013-01-27"},"2013-01-28","2013-01-29","2013-01-30","2013-01-31","2013-02-01","2013-02-02"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,2,1)-WEEKDAY(DATE(CalYear,2,1),(WeekStart=\"Monday\")+1)+8","v":"2013-02-03"},"2013-02-04","2013-02-05","2013-02-06","2013-02-07","2013-02-08","2013-02-09"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,2,1)-WEEKDAY(DATE(CalYear,2,1),(WeekStart=\"Monday\")+1)+15","v":"2013-02-10"},"2013-02-11","2013-02-12","2013-02-13","2013-02-14","2013-02-15","2013-02-16"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,2,1)-WEEKDAY(DATE(CalYear,2,1),(WeekStart=\"Monday\")+1)+22","v":"2013-02-17"},"2013-02-18","2013-02-19","2013-02-20","2013-02-21","2013-02-22","2013-02-23"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"Presidents Day"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,2,1)-WEEKDAY(DATE(CalYear,2,1),(WeekStart=\"Monday\")+1)+29","v":"2013-02-24"},"2013-02-25","2013-02-26","2013-02-27","2013-02-28","2013-03-01","2013-03-02"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,2,1)-WEEKDAY(DATE(CalYear,2,1),(WeekStart=\"Monday\")+1)+36","v":"2013-03-03"},"2013-03-04","NOTES"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"March","index":3,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2013-03-10"}]
[]
[null,"SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
[null,{"$f":"Days+DATE(CalYear,3,1)-WEEKDAY(DATE(CalYear,3,1),(WeekStart=\"Monday\")+1)+1","v":"2013-02-24"},"2013-02-25","2013-02-26","2013-02-27","2013-02-28","2013-03-01","2013-03-02"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,3,1)-WEEKDAY(DATE(CalYear,3,1),(WeekStart=\"Monday\")+1)+8","v":"2013-03-03"},"2013-03-04","2013-03-05","2013-03-06","2013-03-07","2013-03-08","2013-03-09"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,3,1)-WEEKDAY(DATE(CalYear,3,1),(WeekStart=\"Monday\")+1)+15","v":"2013-03-10"},"2013-03-11","2013-03-12","2013-03-13","2013-03-14","2013-03-15","2013-03-16"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,3,1)-WEEKDAY(DATE(CalYear,3,1),(WeekStart=\"Monday\")+1)+22","v":"2013-03-17"},"2013-03-18","2013-03-19","2013-03-20","2013-03-21","2013-03-22","2013-03-23"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,3,1)-WEEKDAY(DATE(CalYear,3,1),(WeekStart=\"Monday\")+1)+29","v":"2013-03-24"},"2013-03-25","2013-03-26","2013-03-27","2013-03-28","2013-03-29","2013-03-30"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,3,1)-WEEKDAY(DATE(CalYear,3,1),(WeekStart=\"Monday\")+1)+36","v":"2013-03-31"},"2013-04-01","NOTES"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"April","index":4,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2013-04-14"}]
[]
[null,"SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
[null,{"$f":"Days+DATE(CalYear,4,1)-WEEKDAY(DATE(CalYear,4,1),(WeekStart=\"Monday\")+1)+1","v":"2013-03-31"},"2013-04-01","2013-04-02","2013-04-03","2013-04-04","2013-04-05","2013-04-06"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,4,1)-WEEKDAY(DATE(CalYear,4,1),(WeekStart=\"Monday\")+1)+8","v":"2013-04-07"},"2013-04-08","2013-04-09","2013-04-10","2013-04-11","2013-04-12","2013-04-13"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,4,1)-WEEKDAY(DATE(CalYear,4,1),(WeekStart=\"Monday\")+1)+15","v":"2013-04-14"},"2013-04-15","2013-04-16","2013-04-17","2013-04-18","2013-04-19","2013-04-20"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,4,1)-WEEKDAY(DATE(CalYear,4,1),(WeekStart=\"Monday\")+1)+22","v":"2013-04-21"},"2013-04-22","2013-04-23","2013-04-24","2013-04-25","2013-04-26","2013-04-27"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,4,1)-WEEKDAY(DATE(CalYear,4,1),(WeekStart=\"Monday\")+1)+29","v":"2013-04-28"},"2013-04-29","2013-04-30","2013-05-01","2013-05-02","2013-05-03","2013-05-04"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,4,1)-WEEKDAY(DATE(CalYear,4,1),(WeekStart=\"Monday\")+1)+36","v":"2013-05-05"},"2013-05-06","NOTES"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"May","index":5,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2013-05-12"}]
[]
[null,"SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
[null,{"$f":"Days+DATE(CalYear,5,1)-WEEKDAY(DATE(CalYear,5,1),(WeekStart=\"Monday\")+1)+1","v":"2013-04-28"},"2013-04-29","2013-04-30","2013-05-01","2013-05-02","2013-05-03","2013-05-04"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,5,1)-WEEKDAY(DATE(CalYear,5,1),(WeekStart=\"Monday\")+1)+8","v":"2013-05-05"},"2013-05-06","2013-05-07","2013-05-08","2013-05-09","2013-05-10","2013-05-11"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,5,1)-WEEKDAY(DATE(CalYear,5,1),(WeekStart=\"Monday\")+1)+15","v":"2013-05-12"},"2013-05-13","2013-05-14","2013-05-15","2013-05-16","2013-05-17","2013-05-18"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,5,1)-WEEKDAY(DATE(CalYear,5,1),(WeekStart=\"Monday\")+1)+22","v":"2013-05-19"},"2013-05-20","2013-05-21","2013-05-22","2013-05-23","2013-05-24","2013-05-25"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,5,1)-WEEKDAY(DATE(CalYear,5,1),(WeekStart=\"Monday\")+1)+29","v":"2013-05-26"},"2013-05-27","2013-05-28","2013-05-29","2013-05-30","2013-05-31","2013-06-01"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"Memorial Day"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,5,1)-WEEKDAY(DATE(CalYear,5,1),(WeekStart=\"Monday\")+1)+36","v":"2013-06-02"},"2013-06-03","NOTES"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"June","index":6,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2013-06-09"}]
[]
[null,"SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
[null,{"$f":"Days+DATE(CalYear,6,1)-WEEKDAY(DATE(CalYear,6,1),(WeekStart=\"Monday\")+1)+1","v":"2013-05-26"},"2013-05-27","2013-05-28","2013-05-29","2013-05-30","2013-05-31","2013-06-01"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,6,1)-WEEKDAY(DATE(CalYear,6,1),(WeekStart=\"Monday\")+1)+8","v":"2013-06-02"},"2013-06-03","2013-06-04","2013-06-05","2013-06-06","2013-06-07","2013-06-08"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,6,1)-WEEKDAY(DATE(CalYear,6,1),(WeekStart=\"Monday\")+1)+15","v":"2013-06-09"},"2013-06-10","2013-06-11","2013-06-12","2013-06-13","2013-06-14","2013-06-15"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,6,1)-WEEKDAY(DATE(CalYear,6,1),(WeekStart=\"Monday\")+1)+22","v":"2013-06-16"},"2013-06-17","2013-06-18","2013-06-19","2013-06-20","2013-06-21","2013-06-22"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,6,1)-WEEKDAY(DATE(CalYear,6,1),(WeekStart=\"Monday\")+1)+29","v":"2013-06-23"},"2013-06-24","2013-06-25","2013-06-26","2013-06-27","2013-06-28","2013-06-29"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,6,1)-WEEKDAY(DATE(CalYear,6,1),(WeekStart=\"Monday\")+1)+36","v":"2013-06-30"},"2013-07-01","NOTES"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"July","index":7,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2013-07-14"}]
[]
[null,"SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
[null,{"$f":"Days+DATE(CalYear,7,1)-WEEKDAY(DATE(CalYear,7,1),(WeekStart=\"Monday\")+1)+1","v":"2013-06-30"},"2013-07-01","2013-07-02","2013-07-03","2013-07-04","2013-07-05","2013-07-06"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"Independence Day"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,7,1)-WEEKDAY(DATE(CalYear,7,1),(WeekStart=\"Monday\")+1)+8","v":"2013-07-07"},"2013-07-08","2013-07-09","2013-07-10","2013-07-11","2013-07-12","2013-07-13"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,7,1)-WEEKDAY(DATE(CalYear,7,1),(WeekStart=\"Monday\")+1)+15","v":"2013-07-14"},"2013-07-15","2013-07-16","2013-07-17","2013-07-18","2013-07-19","2013-07-20"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,7,1)-WEEKDAY(DATE(CalYear,7,1),(WeekStart=\"Monday\")+1)+22","v":"2013-07-21"},"2013-07-22","2013-07-23","2013-07-24","2013-07-25","2013-07-26","2013-07-27"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,7,1)-WEEKDAY(DATE(CalYear,7,1),(WeekStart=\"Monday\")+1)+29","v":"2013-07-28"},"2013-07-29","2013-07-30","2013-07-31","2013-08-01","2013-08-02","2013-08-03"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,7,1)-WEEKDAY(DATE(CalYear,7,1),(WeekStart=\"Monday\")+1)+36","v":"2013-08-04"},"2013-08-05","NOTES"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"August","index":8,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2013-08-11"}]
[]
[null,"SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
[null,{"$f":"Days+DATE(CalYear,8,1)-WEEKDAY(DATE(CalYear,8,1),(WeekStart=\"Monday\")+1)+1","v":"2013-07-28"},"2013-07-29","2013-07-30","2013-07-31","2013-08-01","2013-08-02","2013-08-03"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,8,1)-WEEKDAY(DATE(CalYear,8,1),(WeekStart=\"Monday\")+1)+8","v":"2013-08-04"},"2013-08-05","2013-08-06","2013-08-07","2013-08-08","2013-08-09","2013-08-10"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,8,1)-WEEKDAY(DATE(CalYear,8,1),(WeekStart=\"Monday\")+1)+15","v":"2013-08-11"},"2013-08-12","2013-08-13","2013-08-14","2013-08-15","2013-08-16","2013-08-17"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,8,1)-WEEKDAY(DATE(CalYear,8,1),(WeekStart=\"Monday\")+1)+22","v":"2013-08-18"},"2013-08-19","2013-08-20","2013-08-21","2013-08-22","2013-08-23","2013-08-24"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,8,1)-WEEKDAY(DATE(CalYear,8,1),(WeekStart=\"Monday\")+1)+29","v":"2013-08-25"},"2013-08-26","2013-08-27","2013-08-28","2013-08-29","2013-08-30","2013-08-31"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,8,1)-WEEKDAY(DATE(CalYear,8,1),(WeekStart=\"Monday\")+1)+36","v":"2013-09-01"},"2013-09-02","NOTES"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"Labor Day"}]

{"sheet":"September","index":9,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2013-09-15"}]
[]
[null,"SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
[null,{"$f":"Days+DATE(CalYear,9,1)-WEEKDAY(DATE(CalYear,9,1),(WeekStart=\"Monday\")+1)+1","v":"2013-09-01"},"2013-09-02","2013-09-03","2013-09-04","2013-09-05","2013-09-06","2013-09-07"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"Labor Day"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,9,1)-WEEKDAY(DATE(CalYear,9,1),(WeekStart=\"Monday\")+1)+8","v":"2013-09-08"},"2013-09-09","2013-09-10","2013-09-11","2013-09-12","2013-09-13","2013-09-14"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,9,1)-WEEKDAY(DATE(CalYear,9,1),(WeekStart=\"Monday\")+1)+15","v":"2013-09-15"},"2013-09-16","2013-09-17","2013-09-18","2013-09-19","2013-09-20","2013-09-21"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,9,1)-WEEKDAY(DATE(CalYear,9,1),(WeekStart=\"Monday\")+1)+22","v":"2013-09-22"},"2013-09-23","2013-09-24","2013-09-25","2013-09-26","2013-09-27","2013-09-28"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,9,1)-WEEKDAY(DATE(CalYear,9,1),(WeekStart=\"Monday\")+1)+29","v":"2013-09-29"},"2013-09-30","2013-10-01","2013-10-02","2013-10-03","2013-10-04","2013-10-05"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,9,1)-WEEKDAY(DATE(CalYear,9,1),(WeekStart=\"Monday\")+1)+36","v":"2013-10-06"},"2013-10-07","NOTES"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"October","index":10,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2013-10-13"}]
[]
[null,"SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
[null,{"$f":"Days+DATE(CalYear,10,1)-WEEKDAY(DATE(CalYear,10,1),(WeekStart=\"Monday\")+1)+1","v":"2013-09-29"},"2013-09-30","2013-10-01","2013-10-02","2013-10-03","2013-10-04","2013-10-05"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,10,1)-WEEKDAY(DATE(CalYear,10,1),(WeekStart=\"Monday\")+1)+8","v":"2013-10-06"},"2013-10-07","2013-10-08","2013-10-09","2013-10-10","2013-10-11","2013-10-12"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,10,1)-WEEKDAY(DATE(CalYear,10,1),(WeekStart=\"Monday\")+1)+15","v":"2013-10-13"},"2013-10-14","2013-10-15","2013-10-16","2013-10-17","2013-10-18","2013-10-19"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"Columbus Day"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,10,1)-WEEKDAY(DATE(CalYear,10,1),(WeekStart=\"Monday\")+1)+22","v":"2013-10-20"},"2013-10-21","2013-10-22","2013-10-23","2013-10-24","2013-10-25","2013-10-26"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,10,1)-WEEKDAY(DATE(CalYear,10,1),(WeekStart=\"Monday\")+1)+29","v":"2013-10-27"},"2013-10-28","2013-10-29","2013-10-30","2013-10-31","2013-11-01","2013-11-02"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,10,1)-WEEKDAY(DATE(CalYear,10,1),(WeekStart=\"Monday\")+1)+36","v":"2013-11-03"},"2013-11-04","NOTES"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"November","index":11,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2013-11-10"}]
[]
[null,"SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
[null,{"$f":"Days+DATE(CalYear,11,1)-WEEKDAY(DATE(CalYear,11,1),(WeekStart=\"Monday\")+1)+1","v":"2013-10-27"},"2013-10-28","2013-10-29","2013-10-30","2013-10-31","2013-11-01","2013-11-02"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,11,1)-WEEKDAY(DATE(CalYear,11,1),(WeekStart=\"Monday\")+1)+8","v":"2013-11-03"},"2013-11-04","2013-11-05","2013-11-06","2013-11-07","2013-11-08","2013-11-09"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,11,1)-WEEKDAY(DATE(CalYear,11,1),(WeekStart=\"Monday\")+1)+15","v":"2013-11-10"},"2013-11-11","2013-11-12","2013-11-13","2013-11-14","2013-11-15","2013-11-16"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"Veterans Day"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,11,1)-WEEKDAY(DATE(CalYear,11,1),(WeekStart=\"Monday\")+1)+22","v":"2013-11-17"},"2013-11-18","2013-11-19","2013-11-20","2013-11-21","2013-11-22","2013-11-23"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,11,1)-WEEKDAY(DATE(CalYear,11,1),(WeekStart=\"Monday\")+1)+29","v":"2013-11-24"},"2013-11-25","2013-11-26","2013-11-27","2013-11-28","2013-11-29","2013-11-30"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"Thanksgiving Day"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,11,1)-WEEKDAY(DATE(CalYear,11,1),(WeekStart=\"Monday\")+1)+36","v":"2013-12-01"},"2013-12-02","NOTES"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"December","index":12,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2013-12-15"}]
[]
[null,"SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
[null,{"$f":"Days+DATE(CalYear,12,1)-WEEKDAY(DATE(CalYear,12,1),(WeekStart=\"Monday\")+1)+1","v":"2013-12-01"},"2013-12-02","2013-12-03","2013-12-04","2013-12-05","2013-12-06","2013-12-07"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,12,1)-WEEKDAY(DATE(CalYear,12,1),(WeekStart=\"Monday\")+1)+8","v":"2013-12-08"},"2013-12-09","2013-12-10","2013-12-11","2013-12-12","2013-12-13","2013-12-14"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,12,1)-WEEKDAY(DATE(CalYear,12,1),(WeekStart=\"Monday\")+1)+15","v":"2013-12-15"},"2013-12-16","2013-12-17","2013-12-18","2013-12-19","2013-12-20","2013-12-21"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,12,1)-WEEKDAY(DATE(CalYear,12,1),(WeekStart=\"Monday\")+1)+22","v":"2013-12-22"},"2013-12-23","2013-12-24","2013-12-25","2013-12-26","2013-12-27","2013-12-28"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"Christmas Day"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,12,1)-WEEKDAY(DATE(CalYear,12,1),(WeekStart=\"Monday\")+1)+29","v":"2013-12-29"},"2013-12-30","2013-12-31","2014-01-01","2014-01-02","2014-01-03","2014-01-04"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"New Years Day"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"Days+DATE(CalYear,12,1)-WEEKDAY(DATE(CalYear,12,1),(WeekStart=\"Monday\")+1)+36","v":"2014-01-05"},"2014-01-06","NOTES"]
[null,{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),6),INDEX(tblHolidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,tblHolidays[CORRECTED],tblHolidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"Holidays","index":13,"n_rows":15,"n_cols":8,"rows_kept":15}
[]
[null,"US Holidays",{"$nulls":5}," "]
[]
[null,"DAY","HOLIDAY","FALLS ON","WEEKDAY","CORRECTED","SHOW"]
[null,{"$f":"DATE(CalYear,1,1)","v":"2013-01-01"},"New Years Day","January 1",{"$f":"IFERROR(WEEKDAY(tblHolidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":3},{"$f":"IF(ISTEXT(tblHolidays[[#This Row],[DAY]]),\"Not Observed\",IF(tblHolidays[[#This Row],[WEEKDAY]]=1,tblHolidays[[#This Row],[DAY]]+1,IF(tblHolidays[[#This Row],[WEEKDAY]]=7,tblHolidays[[#This Row],[DAY]]-1,tblHolidays[[#This Row],[DAY]])))","v":"2013-01-01"},true]
[null,{"$f":"DATE(CalYear,1,1+((3-(2>=WEEKDAY(DATE(CalYear,1,1))))*7)+(2-WEEKDAY(DATE(CalYear,1,1))))","v":"2013-01-21"},{"$f":"IF(COUNTIF(tblHolidays[DAY],tblHolidays[[#This Row],[DAY]])>1,\"Martin Luther King, Jr. Day *\",\"Martin Luther King, Jr. Day\")","v":"Martin Luther King, Jr. Day *"},"Third Monday of January",{"$f":"IFERROR(WEEKDAY(tblHolidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":2},{"$f":"IF(ISTEXT(tblHolidays[[#This Row],[DAY]]),\"Not Observed\",IF(tblHolidays[[#This Row],[WEEKDAY]]=1,tblHolidays[[#This Row],[DAY]]+1,IF(tblHolidays[[#This Row],[WEEKDAY]]=7,tblHolidays[[#This Row],[DAY]]-1,tblHolidays[[#This Row],[DAY]])))","v":"2013-01-21"},true]
[null,{"$f":"IF(MOD(CalYear,4)=1,DATE(CalYear,1,20)+(WEEKDAY(DATE(CalYear,1,20))=1),\"Not observed\")","v":"2013-01-21"},"Inaguration Day","January 20, every fourth year, following Presidential election",{"$f":"IFERROR(WEEKDAY(tblHolidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":2},{"$f":"IF(ISTEXT(tblHolidays[[#This Row],[DAY]]),\"Not Observed\",IF(tblHolidays[[#This Row],[WEEKDAY]]=1,tblHolidays[[#This Row],[DAY]]+1,IF(tblHolidays[[#This Row],[WEEKDAY]]=7,tblHolidays[[#This Row],[DAY]]-1,tblHolidays[[#This Row],[DAY]])))","v":"2013-01-21"},true]
[null,{"$f":"DATE(CalYear,2,1+((3-(2>=WEEKDAY(DATE(CalYear,2,1))))*7)+(2-WEEKDAY(DATE(CalYear,2,1))))","v":"2013-02-18"},"Presidents Day","Third Monday in February",{"$f":"IFERROR(WEEKDAY(tblHolidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":2},{"$f":"IF(ISTEXT(tblHolidays[[#This Row],[DAY]]),\"Not Observed\",IF(tblHolidays[[#This Row],[WEEKDAY]]=1,tblHolidays[[#This Row],[DAY]]+1,IF(tblHolidays[[#This Row],[WEEKDAY]]=7,tblHolidays[[#This Row],[DAY]]-1,tblHolidays[[#This Row],[DAY]])))","v":"2013-02-18"},true]
[null,{"$f":"DATE(CalYear,5,1+((MayMondays-(2>=WEEKDAY(DATE(CalYear,5,1))))*7)+(2-WEEKDAY(DATE(CalYear,5,1))))","v":"2013-05-27"},"Memorial Day","Last Monday in May",{"$f":"IFERROR(WEEKDAY(tblHolidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":2},{"$f":"IF(ISTEXT(tblHolidays[[#This Row],[DAY]]),\"Not Observed\",IF(tblHolidays[[#This Row],[WEEKDAY]]=1,tblHolidays[[#This Row],[DAY]]+1,IF(tblHolidays[[#This Row],[WEEKDAY]]=7,tblHolidays[[#This Row],[DAY]]-1,tblHolidays[[#This Row],[DAY]])))","v":"2013-05-27"},true]
[null,{"$f":"DATE(CalYear,7,4)","v":"2013-07-04"},"Independence Day","July 4",{"$f":"IFERROR(WEEKDAY(tblHolidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":5},{"$f":"IF(ISTEXT(tblHolidays[[#This Row],[DAY]]),\"Not Observed\",IF(tblHolidays[[#This Row],[WEEKDAY]]=1,tblHolidays[[#This Row],[DAY]]+1,IF(tblHolidays[[#This Row],[WEEKDAY]]=7,tblHolidays[[#This Row],[DAY]]-1,tblHolidays[[#This Row],[DAY]])))","v":"2013-07-04"},true]
[null,{"$f":"DATE(CalYear,9,1+((1-(2>=WEEKDAY(DATE(CalYear,9,1))))*7)+(2-WEEKDAY(DATE(CalYear,9,1))))","v":"2013-09-02"},"Labor Day","First Monday in September",{"$f":"IFERROR(WEEKDAY(tblHolidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":2},{"$f":"IF(ISTEXT(tblHolidays[[#This Row],[DAY]]),\"Not Observed\",IF(tblHolidays[[#This Row],[WEEKDAY]]=1,tblHolidays[[#This Row],[DAY]]+1,IF(tblHolidays[[#This Row],[WEEKDAY]]=7,tblHolidays[[#This Row],[DAY]]-1,tblHolidays[[#This Row],[DAY]])))","v":"2013-09-02"},true]
[null,{"$f":"DATE(CalYear,10,1+((2-(2>=WEEKDAY(DATE(CalYear,10,1))))*7)+(2-WEEKDAY(DATE(CalYear,10,1))))","v":"2013-10-14"},"Columbus Day","Second Monday in October",{"$f":"IFERROR(WEEKDAY(tblHolidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":2},{"$f":"IF(ISTEXT(tblHolidays[[#This Row],[DAY]]),\"Not Observed\",IF(tblHolidays[[#This Row],[WEEKDAY]]=1,tblHolidays[[#This Row],[DAY]]+1,IF(tblHolidays[[#This Row],[WEEKDAY]]=7,tblHolidays[[#This Row],[DAY]]-1,tblHolidays[[#This Row],[DAY]])))","v":"2013-10-14"},true]
[null,{"$f":"DATE(CalYear,11,11)","v":"2013-11-11"},"Veterans Day","November 11",{"$f":"IFERROR(WEEKDAY(tblHolidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":2},{"$f":"IF(ISTEXT(tblHolidays[[#This Row],[DAY]]),\"Not Observed\",IF(tblHolidays[[#This Row],[WEEKDAY]]=1,tblHolidays[[#This Row],[DAY]]+1,IF(tblHolidays[[#This Row],[WEEKDAY]]=7,tblHolidays[[#This Row],[DAY]]-1,tblHolidays[[#This Row],[DAY]])))","v":"2013-11-11"},true]
[null,{"$f":"DATE(CalYear,11,1+((4-(5>=WEEKDAY(DATE(CalYear,11,1))))*7)+(5-WEEKDAY(DATE(CalYear,11,1))))","v":"2013-11-28"},"Thanksgiving Day","Fourth Thursday in November",{"$f":"IFERROR(WEEKDAY(tblHolidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":5},{"$f":"IF(ISTEXT(tblHolidays[[#This Row],[DAY]]),\"Not Observed\",IF(tblHolidays[[#This Row],[WEEKDAY]]=1,tblHolidays[[#This Row],[DAY]]+1,IF(tblHolidays[[#This Row],[WEEKDAY]]=7,tblHolidays[[#This Row],[DAY]]-1,tblHolidays[[#This Row],[DAY]])))","v":"2013-11-28"},true]
[null,{"$f":"DATE(CalYear,12,25)","v":"2013-12-25"},"Christmas Day","December 25",{"$f":"IFERROR(WEEKDAY(tblHolidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":4},{"$f":"IF(ISTEXT(tblHolidays[[#This Row],[DAY]]),\"Not Observed\",IF(tblHolidays[[#This Row],[WEEKDAY]]=1,tblHolidays[[#This Row],[DAY]]+1,IF(tblHolidays[[#This Row],[WEEKDAY]]=7,tblHolidays[[#This Row],[DAY]]-1,tblHolidays[[#This Row],[DAY]])))","v":"2013-12-25"},true]