{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["January","February","March","April","May","June","July","August","September","October","November","December","Employee Names"],"not_rendered":{"defined_names":50},"read":"whole","date_system":"1900"}

{"sheet":"January","index":0,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,"Employee Absence Schedule"]
[null,"Absence Type Key","H","Holiday",null,null,"P","Personal",null,null,"S","Sick",null,null,"Custom 1",{"$nulls":3},"Custom 2"]
[{"$nulls":33},"Enter year:"]
[null,"January","Dates of Absence",{"$nulls":30},2016]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,1),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,2),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,3),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,4),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,5),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,6),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,7),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,8),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,9),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,10),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,11),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,12),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,13),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,14),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,15),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,16),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,17),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,18),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,19),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,20),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,21),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,22),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,23),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,24),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,25),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,26),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,27),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,28),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,29),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,30),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,31),1),\"aaa\")","v":"Sun"}]
[null,"Employee Name","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total Days"]
[null,"Employee 1",null,null,"H","H","H","H",{"$nulls":6},"H",{"$nulls":18},{"$f":"COUNTA(January!$C7:$AG7)","v":5}]
[null,"Employee 2",{"$nulls":4},"S","S",{"$nulls":4},"P",{"$nulls":8},"S",{"$nulls":4},"H","H","H",{"$nulls":4},{"$f":"COUNTA(January!$C8:$AG8)","v":7}]
[null,"Employee 3",null,null,"P",{"$nulls":10},"S",{"$nulls":14},"S",null,null,{"$f":"COUNTA(January!$C9:$AG9)","v":3}]
[null,"Employee 4",{"$nulls":6},"P",{"$nulls":11},"H","H","H",{"$nulls":10},{"$f":"COUNTA(January!$C10:$AG10)","v":4}]
[null,"Employee 5",{"$nulls":3},"S","H","H",{"$nulls":10},"S",{"$nulls":6},"S",{"$nulls":6},"H",{"$f":"COUNTA(January!$C11:$AG11)","v":6}]
[null,{"$f":"MonthName&\" Total\"","v":"January Total"},{"$f":"SUBTOTAL(103,January!$C$7:$C$11)","v":0},{"$f":"SUBTOTAL(103,January!$D$7:$D$11)","v":0},{"$f":"SUBTOTAL(103,January!$E$7:$E$11)","v":2},{"$f":"SUBTOTAL(103,January!$F$7:$F$11)","v":2},{"$f":"SUBTOTAL(103,January!$G$7:$G$11)","v":3},{"$f":"SUBTOTAL(103,January!$H$7:$H$11)","v":3},{"$f":"SUBTOTAL(103,January!$I$7:$I$11)","v":1},{"$f":"SUBTOTAL(103,January!$J$7:$J$11)","v":0},{"$f":"SUBTOTAL(103,January!$K$7:$K$11)","v":0},{"$f":"SUBTOTAL(103,January!$L$7:$L$11)","v":0},{"$f":"SUBTOTAL(103,January!$M$7:$M$11)","v":1},{"$f":"SUBTOTAL(103,January!$N$7:$N$11)","v":0},{"$f":"SUBTOTAL(103,January!$O$7:$O$11)","v":1},{"$f":"SUBTOTAL(103,January!$P$7:$P$11)","v":1},{"$f":"SUBTOTAL(103,January!$Q$7:$Q$11)","v":0},{"$f":"SUBTOTAL(103,January!$R$7:$R$11)","v":0},{"$f":"SUBTOTAL(103,January!$S$7:$S$11)","v":1},{"$f":"SUBTOTAL(103,January!$T$7:$T$11)","v":0},{"$f":"SUBTOTAL(103,January!$U$7:$U$11)","v":1},{"$f":"SUBTOTAL(103,January!$V$7:$V$11)","v":2},{"$f":"SUBTOTAL(103,January!$W$7:$W$11)","v":1},{"$f":"SUBTOTAL(103,January!$X$7:$X$11)","v":0},{"$f":"SUBTOTAL(103,January!$Y$7:$Y$11)","v":0},{"$f":"SUBTOTAL(103,January!$Z$7:$Z$11)","v":1},{"$f":"SUBTOTAL(103,January!$AA$7:$AA$11)","v":1},{"$f":"SUBTOTAL(103,January!$AB$7:$AB$11)","v":1},{"$f":"SUBTOTAL(103,January!$AC$7:$AC$11)","v":1},{"$f":"SUBTOTAL(103,January!$AD$7:$AD$11)","v":0},{"$f":"SUBTOTAL(103,January!$AE$7:$AE$11)","v":1},{"$f":"SUBTOTAL(103,January!$AF$7:$AF$11)","v":0},{"$f":"SUBTOTAL(103,January!$AG$7:$AG$11)","v":1},{"$f":"SUBTOTAL(109,January[Total Days])","v":25}]

{"sheet":"February","index":1,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Employee Absence Schedule"}]
[null,"Absence Type Key","H","Holiday",null,null,"P","Personal",null,null,"S","Sick",null,null,"Custom 1",{"$nulls":3},"Custom 2"]
[]
[null,"February","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,1),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,2),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,3),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,4),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,5),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,6),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,7),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,8),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,9),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,10),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,11),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,12),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,13),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,14),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,15),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,16),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,17),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,18),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,19),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,20),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,21),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,22),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,23),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,24),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,25),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,26),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,27),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,28),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,29),1),\"aaa\")","v":"Mon"}]
[null,"Employee Name","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29"," ","  ","Total Days"]
[null,"Employee 1",null,null,"H","H","H","H",{"$nulls":6},"H",{"$nulls":18},{"$f":"COUNTA(February[[#This Row],[1]:[29]])","v":5}]
[null,"Employee 2",{"$nulls":4},"S","S",{"$nulls":4},"P",{"$nulls":8},"S",{"$nulls":4},"H","H","H",{"$nulls":4},{"$f":"COUNTA(February[[#This Row],[1]:[29]])","v":7}]
[null,"Employee 3",{"$nulls":31},{"$f":"COUNTA(February[[#This Row],[1]:[29]])","v":0}]
[null,"Employee 4",null,null,"S",{"$nulls":10},"S",{"$nulls":3},"P",{"$nulls":9},"S",{"$nulls":3},{"$f":"COUNTA(February[[#This Row],[1]:[29]])","v":4}]
[null,"Employee 5",{"$nulls":7},"H","H","H","H",{"$nulls":12},"S",{"$nulls":7},{"$f":"COUNTA(February[[#This Row],[1]:[29]])","v":5}]
[null,{"$f":"MonthName&\" Total\"","v":"February Total"},{"$f":"SUBTOTAL(103,February[1])","v":0},{"$f":"SUBTOTAL(103,February[2])","v":0},{"$f":"SUBTOTAL(103,February[3])","v":2},{"$f":"SUBTOTAL(103,February[4])","v":1},{"$f":"SUBTOTAL(103,February[5])","v":2},{"$f":"SUBTOTAL(103,February[6])","v":2},{"$f":"SUBTOTAL(103,February[7])","v":0},{"$f":"SUBTOTAL(103,February[8])","v":1},{"$f":"SUBTOTAL(103,February[9])","v":1},{"$f":"SUBTOTAL(103,February[10])","v":1},{"$f":"SUBTOTAL(103,February[11])","v":2},{"$f":"SUBTOTAL(103,February[12])","v":0},{"$f":"SUBTOTAL(103,February[13])","v":1},{"$f":"SUBTOTAL(103,February[14])","v":1},{"$f":"SUBTOTAL(103,February[15])","v":0},{"$f":"SUBTOTAL(103,February[16])","v":0},{"$f":"SUBTOTAL(103,February[17])","v":0},{"$f":"SUBTOTAL(103,February[18])","v":1},{"$f":"SUBTOTAL(103,February[19])","v":0},{"$f":"SUBTOTAL(103,February[20])","v":1},{"$f":"SUBTOTAL(103,February[21])","v":0},{"$f":"SUBTOTAL(103,February[22])","v":0},{"$f":"SUBTOTAL(103,February[23])","v":0},{"$f":"SUBTOTAL(103,February[24])","v":1},{"$f":"SUBTOTAL(103,February[25])","v":1},{"$f":"SUBTOTAL(103,February[26])","v":1},{"$f":"SUBTOTAL(103,February[27])","v":1},{"$f":"SUBTOTAL(103,February[28])","v":1},{"$f":"SUBTOTAL(103,February[29])","v":0},null,null,{"$f":"SUBTOTAL(109,February[Total Days])","v":21}]

{"sheet":"March","index":2,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Employee Absence Schedule"}]
[null,"Absence Type Key","H","Holiday",null,null,"P","Personal",null,null,"S","Sick",null,null,"Custom 1",{"$nulls":3},"Custom 2"]
[]
[null,"March","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,1),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,2),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,3),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,4),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,5),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,6),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,7),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,8),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,9),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,10),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,11),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,12),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,13),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,14),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,15),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,16),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,17),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,18),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,19),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,20),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,21),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,22),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,23),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,24),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,25),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,26),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,27),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,28),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,29),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,30),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,31),1),\"aaa\")","v":"Thu"}]
[null,"Employee Name","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total Days"]
[null,"Employee 1",{"$nulls":31},{"$f":"COUNTA(March[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 2",{"$nulls":31},{"$f":"COUNTA(March[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 3",{"$nulls":31},{"$f":"COUNTA(March[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 4",{"$nulls":31},{"$f":"COUNTA(March[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 5",{"$nulls":31},{"$f":"COUNTA(March[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"MonthName&\" Total\"","v":"March Total"},{"$f":"SUBTOTAL(103,March[1])","v":0},{"$f":"SUBTOTAL(103,March[2])","v":0},{"$f":"SUBTOTAL(103,March[3])","v":0},{"$f":"SUBTOTAL(103,March[4])","v":0},{"$f":"SUBTOTAL(103,March[5])","v":0},{"$f":"SUBTOTAL(103,March[6])","v":0},{"$f":"SUBTOTAL(103,March[7])","v":0},{"$f":"SUBTOTAL(103,March[8])","v":0},{"$f":"SUBTOTAL(103,March[9])","v":0},{"$f":"SUBTOTAL(103,March[10])","v":0},{"$f":"SUBTOTAL(103,March[11])","v":0},{"$f":"SUBTOTAL(103,March[12])","v":0},{"$f":"SUBTOTAL(103,March[13])","v":0},{"$f":"SUBTOTAL(103,March[14])","v":0},{"$f":"SUBTOTAL(103,March[15])","v":0},{"$f":"SUBTOTAL(103,March[16])","v":0},{"$f":"SUBTOTAL(103,March[17])","v":0},{"$f":"SUBTOTAL(103,March[18])","v":0},{"$f":"SUBTOTAL(103,March[19])","v":0},{"$f":"SUBTOTAL(103,March[20])","v":0},{"$f":"SUBTOTAL(103,March[21])","v":0},{"$f":"SUBTOTAL(103,March[22])","v":0},{"$f":"SUBTOTAL(103,March[23])","v":0},{"$f":"SUBTOTAL(103,March[24])","v":0},{"$f":"SUBTOTAL(103,March[25])","v":0},{"$f":"SUBTOTAL(103,March[26])","v":0},{"$f":"SUBTOTAL(103,March[27])","v":0},{"$f":"SUBTOTAL(103,March[28])","v":0},{"$f":"SUBTOTAL(103,March[29])","v":0},{"$f":"SUBTOTAL(103,March[30])","v":0},{"$f":"SUBTOTAL(109,March[31])","v":0},{"$f":"SUBTOTAL(109,March[Total Days])","v":0}]

{"sheet":"April","index":3,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Employee Absence Schedule"}]
[null,"Absence Type Key","H","Holiday",null,null,"P","Personal",null,null,"S","Sick",null,null,"Custom 1",{"$nulls":3},"Custom 2"]
[]
[null,"April","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,1),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,2),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,3),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,4),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,5),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,6),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,7),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,8),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,9),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,10),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,11),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,12),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,13),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,14),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,15),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,16),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,17),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,18),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,19),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,20),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,21),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,22),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,23),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,24),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,25),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,26),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,27),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,28),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,29),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,30),1),\"aaa\")","v":"Sat"}]
[null,"Employee Name","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total Days"]
[null,"Employee 1",{"$nulls":31},{"$f":"COUNTA(April[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 2",{"$nulls":31},{"$f":"COUNTA(April[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 3",{"$nulls":31},{"$f":"COUNTA(April[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 4",{"$nulls":31},{"$f":"COUNTA(April[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 5",{"$nulls":31},{"$f":"COUNTA(April[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"MonthName&\" Total\"","v":"April Total"},{"$f":"SUBTOTAL(103,April[1])","v":0},{"$f":"SUBTOTAL(103,April[2])","v":0},{"$f":"SUBTOTAL(103,April[3])","v":0},{"$f":"SUBTOTAL(103,April[4])","v":0},{"$f":"SUBTOTAL(103,April[5])","v":0},{"$f":"SUBTOTAL(103,April[6])","v":0},{"$f":"SUBTOTAL(103,April[7])","v":0},{"$f":"SUBTOTAL(103,April[8])","v":0},{"$f":"SUBTOTAL(103,April[9])","v":0},{"$f":"SUBTOTAL(103,April[10])","v":0},{"$f":"SUBTOTAL(103,April[11])","v":0},{"$f":"SUBTOTAL(103,April[12])","v":0},{"$f":"SUBTOTAL(103,April[13])","v":0},{"$f":"SUBTOTAL(103,April[14])","v":0},{"$f":"SUBTOTAL(103,April[15])","v":0},{"$f":"SUBTOTAL(103,April[16])","v":0},{"$f":"SUBTOTAL(103,April[17])","v":0},{"$f":"SUBTOTAL(103,April[18])","v":0},{"$f":"SUBTOTAL(103,April[19])","v":0},{"$f":"SUBTOTAL(103,April[20])","v":0},{"$f":"SUBTOTAL(103,April[21])","v":0},{"$f":"SUBTOTAL(103,April[22])","v":0},{"$f":"SUBTOTAL(103,April[23])","v":0},{"$f":"SUBTOTAL(103,April[24])","v":0},{"$f":"SUBTOTAL(103,April[25])","v":0},{"$f":"SUBTOTAL(103,April[26])","v":0},{"$f":"SUBTOTAL(103,April[27])","v":0},{"$f":"SUBTOTAL(103,April[28])","v":0},{"$f":"SUBTOTAL(103,April[29])","v":0},{"$f":"SUBTOTAL(109,April[30])","v":0},{"$f":"SUBTOTAL(109,April[31])","v":0},{"$f":"SUBTOTAL(109,April[Total Days])","v":0}]

{"sheet":"May","index":4,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Employee Absence Schedule"}]
[null,"Absence Type Key","H","Holiday",null,null,"P","Personal",null,null,"S","Sick",null,null,"Custom 1",{"$nulls":3},"Custom 2"]
[]
[null,"May","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,1),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,2),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,3),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,4),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,5),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,6),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,7),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,8),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,9),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,10),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,11),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,12),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,13),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,14),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,15),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,16),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,17),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,18),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,19),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,20),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,21),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,22),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,23),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,24),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,25),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,26),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,27),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,28),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,29),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,30),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,31),1),\"aaa\")","v":"Tue"}]
[null,"Employee Name","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total Days"]
[null,"Employee 1",{"$nulls":31},{"$f":"COUNTA(May[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 2",{"$nulls":31},{"$f":"COUNTA(May[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 3",{"$nulls":31},{"$f":"COUNTA(May[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 4",{"$nulls":31},{"$f":"COUNTA(May[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 5",{"$nulls":31},{"$f":"COUNTA(May[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"MonthName&\" Total\"","v":"May Total"},{"$f":"SUBTOTAL(103,May[1])","v":0},{"$f":"SUBTOTAL(103,May[2])","v":0},{"$f":"SUBTOTAL(103,May[3])","v":0},{"$f":"SUBTOTAL(103,May[4])","v":0},{"$f":"SUBTOTAL(103,May[5])","v":0},{"$f":"SUBTOTAL(103,May[6])","v":0},{"$f":"SUBTOTAL(103,May[7])","v":0},{"$f":"SUBTOTAL(103,May[8])","v":0},{"$f":"SUBTOTAL(103,May[9])","v":0},{"$f":"SUBTOTAL(103,May[10])","v":0},{"$f":"SUBTOTAL(103,May[11])","v":0},{"$f":"SUBTOTAL(103,May[12])","v":0},{"$f":"SUBTOTAL(103,May[13])","v":0},{"$f":"SUBTOTAL(103,May[14])","v":0},{"$f":"SUBTOTAL(103,May[15])","v":0},{"$f":"SUBTOTAL(103,May[16])","v":0},{"$f":"SUBTOTAL(103,May[17])","v":0},{"$f":"SUBTOTAL(103,May[18])","v":0},{"$f":"SUBTOTAL(103,May[19])","v":0},{"$f":"SUBTOTAL(103,May[20])","v":0},{"$f":"SUBTOTAL(103,May[21])","v":0},{"$f":"SUBTOTAL(103,May[22])","v":0},{"$f":"SUBTOTAL(103,May[23])","v":0},{"$f":"SUBTOTAL(103,May[24])","v":0},{"$f":"SUBTOTAL(103,May[25])","v":0},{"$f":"SUBTOTAL(103,May[26])","v":0},{"$f":"SUBTOTAL(103,May[27])","v":0},{"$f":"SUBTOTAL(103,May[28])","v":0},{"$f":"SUBTOTAL(103,May[29])","v":0},{"$f":"SUBTOTAL(109,May[30])","v":0},{"$f":"SUBTOTAL(109,May[31])","v":0},{"$f":"SUBTOTAL(109,May[Total Days])","v":0}]

{"sheet":"June","index":5,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Employee Absence Schedule"}]
[null,"Absence Type Key","H","Holiday",null,null,"P","Personal",null,null,"S","Sick",null,null,"Custom 1",{"$nulls":3},"Custom 2"]
[]
[null,"June","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,1),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,2),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,3),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,4),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,5),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,6),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,7),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,8),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,9),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,10),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,11),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,12),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,13),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,14),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,15),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,16),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,17),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,18),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,19),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,20),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,21),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,22),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,23),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,24),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,25),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,26),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,27),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,28),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,29),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,30),1),\"aaa\")","v":"Thu"}]
[null,"Employee Name","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total Days"]
[null,"Employee 1",{"$nulls":31},{"$f":"COUNTA(June[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 2",{"$nulls":31},{"$f":"COUNTA(June[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 3",{"$nulls":31},{"$f":"COUNTA(June[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 4",{"$nulls":31},{"$f":"COUNTA(June[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 5",{"$nulls":31},{"$f":"COUNTA(June[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"MonthName&\" Total\"","v":"June Total"},{"$f":"SUBTOTAL(103,June[1])","v":0},{"$f":"SUBTOTAL(103,June[2])","v":0},{"$f":"SUBTOTAL(103,June[3])","v":0},{"$f":"SUBTOTAL(103,June[4])","v":0},{"$f":"SUBTOTAL(103,June[5])","v":0},{"$f":"SUBTOTAL(103,June[6])","v":0},{"$f":"SUBTOTAL(103,June[7])","v":0},{"$f":"SUBTOTAL(103,June[8])","v":0},{"$f":"SUBTOTAL(103,June[9])","v":0},{"$f":"SUBTOTAL(103,June[10])","v":0},{"$f":"SUBTOTAL(103,June[11])","v":0},{"$f":"SUBTOTAL(103,June[12])","v":0},{"$f":"SUBTOTAL(103,June[13])","v":0},{"$f":"SUBTOTAL(103,June[14])","v":0},{"$f":"SUBTOTAL(103,June[15])","v":0},{"$f":"SUBTOTAL(103,June[16])","v":0},{"$f":"SUBTOTAL(103,June[17])","v":0},{"$f":"SUBTOTAL(103,June[18])","v":0},{"$f":"SUBTOTAL(103,June[19])","v":0},{"$f":"SUBTOTAL(103,June[20])","v":0},{"$f":"SUBTOTAL(103,June[21])","v":0},{"$f":"SUBTOTAL(103,June[22])","v":0},{"$f":"SUBTOTAL(103,June[23])","v":0},{"$f":"SUBTOTAL(103,June[24])","v":0},{"$f":"SUBTOTAL(103,June[25])","v":0},{"$f":"SUBTOTAL(103,June[26])","v":0},{"$f":"SUBTOTAL(103,June[27])","v":0},{"$f":"SUBTOTAL(103,June[28])","v":0},{"$f":"SUBTOTAL(103,June[29])","v":0},{"$f":"SUBTOTAL(109,June[30])","v":0},{"$f":"SUBTOTAL(109,June[31])","v":0},{"$f":"SUBTOTAL(109,June[Total Days])","v":0}]

{"sheet":"July","index":6,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Employee Absence Schedule"}]
[null,"Absence Type Key","H","Holiday",null,null,"P","Personal",null,null,"S","Sick",null,null,"Custom 1",{"$nulls":3},"Custom 2"]
[]
[null,"July","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,1),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,2),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,3),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,4),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,5),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,6),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,7),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,8),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,9),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,10),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,11),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,12),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,13),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,14),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,15),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,16),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,17),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,18),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,19),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,20),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,21),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,22),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,23),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,24),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,25),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,26),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,27),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,28),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,29),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,30),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,31),1),\"aaa\")","v":"Sun"}]
[null,"Employee Name","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total Days"]
[null,"Employee 1",{"$nulls":31},{"$f":"COUNTA(July[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 2",{"$nulls":31},{"$f":"COUNTA(July[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 3",{"$nulls":31},{"$f":"COUNTA(July[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 4",{"$nulls":31},{"$f":"COUNTA(July[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 5",{"$nulls":31},{"$f":"COUNTA(July[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"MonthName&\" Total\"","v":"July Total"},{"$f":"SUBTOTAL(103,July[1])","v":0},{"$f":"SUBTOTAL(103,July[2])","v":0},{"$f":"SUBTOTAL(103,July[3])","v":0},{"$f":"SUBTOTAL(103,July[4])","v":0},{"$f":"SUBTOTAL(103,July[5])","v":0},{"$f":"SUBTOTAL(103,July[6])","v":0},{"$f":"SUBTOTAL(103,July[7])","v":0},{"$f":"SUBTOTAL(103,July[8])","v":0},{"$f":"SUBTOTAL(103,July[9])","v":0},{"$f":"SUBTOTAL(103,July[10])","v":0},{"$f":"SUBTOTAL(103,July[11])","v":0},{"$f":"SUBTOTAL(103,July[12])","v":0},{"$f":"SUBTOTAL(103,July[13])","v":0},{"$f":"SUBTOTAL(103,July[14])","v":0},{"$f":"SUBTOTAL(103,July[15])","v":0},{"$f":"SUBTOTAL(103,July[16])","v":0},{"$f":"SUBTOTAL(103,July[17])","v":0},{"$f":"SUBTOTAL(103,July[18])","v":0},{"$f":"SUBTOTAL(103,July[19])","v":0},{"$f":"SUBTOTAL(103,July[20])","v":0},{"$f":"SUBTOTAL(103,July[21])","v":0},{"$f":"SUBTOTAL(103,July[22])","v":0},{"$f":"SUBTOTAL(103,July[23])","v":0},{"$f":"SUBTOTAL(103,July[24])","v":0},{"$f":"SUBTOTAL(103,July[25])","v":0},{"$f":"SUBTOTAL(103,July[26])","v":0},{"$f":"SUBTOTAL(103,July[27])","v":0},{"$f":"SUBTOTAL(103,July[28])","v":0},{"$f":"SUBTOTAL(103,July[29])","v":0},{"$f":"SUBTOTAL(109,July[30])","v":0},{"$f":"SUBTOTAL(109,July[31])","v":0},{"$f":"SUBTOTAL(109,July[Total Days])","v":0}]

{"sheet":"August","index":7,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Employee Absence Schedule"}]
[null,"Absence Type Key","H","Holiday",null,null,"P","Personal",null,null,"S","Sick",null,null,"Custom 1",{"$nulls":3},"Custom 2"]
[]
[null,"August","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,1),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,2),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,3),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,4),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,5),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,6),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,7),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,8),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,9),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,10),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,11),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,12),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,13),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,14),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,15),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,16),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,17),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,18),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,19),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,20),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,21),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,22),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,23),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,24),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,25),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,26),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,27),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,28),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,29),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,30),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,31),1),\"aaa\")","v":"Wed"}]
[null,"Employee Name","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total Days"]
[null,"Employee 1",{"$nulls":31},{"$f":"COUNTA(August[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 2",{"$nulls":31},{"$f":"COUNTA(August[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 3",{"$nulls":31},{"$f":"COUNTA(August[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 4",{"$nulls":31},{"$f":"COUNTA(August[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 5",{"$nulls":31},{"$f":"COUNTA(August[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"MonthName&\" Total\"","v":"August Total"},{"$f":"SUBTOTAL(103,August[1])","v":0},{"$f":"SUBTOTAL(103,August[2])","v":0},{"$f":"SUBTOTAL(103,August[3])","v":0},{"$f":"SUBTOTAL(103,August[4])","v":0},{"$f":"SUBTOTAL(103,August[5])","v":0},{"$f":"SUBTOTAL(103,August[6])","v":0},{"$f":"SUBTOTAL(103,August[7])","v":0},{"$f":"SUBTOTAL(103,August[8])","v":0},{"$f":"SUBTOTAL(103,August[9])","v":0},{"$f":"SUBTOTAL(103,August[10])","v":0},{"$f":"SUBTOTAL(103,August[11])","v":0},{"$f":"SUBTOTAL(103,August[12])","v":0},{"$f":"SUBTOTAL(103,August[13])","v":0},{"$f":"SUBTOTAL(103,August[14])","v":0},{"$f":"SUBTOTAL(103,August[15])","v":0},{"$f":"SUBTOTAL(103,August[16])","v":0},{"$f":"SUBTOTAL(103,August[17])","v":0},{"$f":"SUBTOTAL(103,August[18])","v":0},{"$f":"SUBTOTAL(103,August[19])","v":0},{"$f":"SUBTOTAL(103,August[20])","v":0},{"$f":"SUBTOTAL(103,August[21])","v":0},{"$f":"SUBTOTAL(103,August[22])","v":0},{"$f":"SUBTOTAL(103,August[23])","v":0},{"$f":"SUBTOTAL(103,August[24])","v":0},{"$f":"SUBTOTAL(103,August[25])","v":0},{"$f":"SUBTOTAL(103,August[26])","v":0},{"$f":"SUBTOTAL(103,August[27])","v":0},{"$f":"SUBTOTAL(103,August[28])","v":0},{"$f":"SUBTOTAL(103,August[29])","v":0},{"$f":"SUBTOTAL(109,August[30])","v":0},{"$f":"SUBTOTAL(109,August[31])","v":0},{"$f":"SUBTOTAL(109,August[Total Days])","v":0}]

{"sheet":"September","index":8,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Employee Absence Schedule"}]
[null,"Absence Type Key","H","Holiday",null,null,"P","Personal",null,null,"S","Sick",null,null,"Custom 1",{"$nulls":3},"Custom 2"]
[]
[null,"September","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,1),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,2),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,3),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,4),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,5),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,6),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,7),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,8),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,9),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,10),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,11),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,12),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,13),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,14),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,15),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,16),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,17),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,18),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,19),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,20),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,21),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,22),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,23),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,24),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,25),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,26),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,27),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,28),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,29),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,30),1),\"aaa\")","v":"Fri"}]
[null,"Employee Name","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total Days"]
[null,"Employee 1",{"$nulls":31},{"$f":"COUNTA(September[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 2",{"$nulls":31},{"$f":"COUNTA(September[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 3",{"$nulls":31},{"$f":"COUNTA(September[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 4",{"$nulls":31},{"$f":"COUNTA(September[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 5",{"$nulls":31},{"$f":"COUNTA(September[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"MonthName&\" Total\"","v":"September Total"},{"$f":"SUBTOTAL(103,September[1])","v":0},{"$f":"SUBTOTAL(103,September[2])","v":0},{"$f":"SUBTOTAL(103,September[3])","v":0},{"$f":"SUBTOTAL(103,September[4])","v":0},{"$f":"SUBTOTAL(103,September[5])","v":0},{"$f":"SUBTOTAL(103,September[6])","v":0},{"$f":"SUBTOTAL(103,September[7])","v":0},{"$f":"SUBTOTAL(103,September[8])","v":0},{"$f":"SUBTOTAL(103,September[9])","v":0},{"$f":"SUBTOTAL(103,September[10])","v":0},{"$f":"SUBTOTAL(103,September[11])","v":0},{"$f":"SUBTOTAL(103,September[12])","v":0},{"$f":"SUBTOTAL(103,September[13])","v":0},{"$f":"SUBTOTAL(103,September[14])","v":0},{"$f":"SUBTOTAL(103,September[15])","v":0},{"$f":"SUBTOTAL(103,September[16])","v":0},{"$f":"SUBTOTAL(103,September[17])","v":0},{"$f":"SUBTOTAL(103,September[18])","v":0},{"$f":"SUBTOTAL(103,September[19])","v":0},{"$f":"SUBTOTAL(103,September[20])","v":0},{"$f":"SUBTOTAL(103,September[21])","v":0},{"$f":"SUBTOTAL(103,September[22])","v":0},{"$f":"SUBTOTAL(103,September[23])","v":0},{"$f":"SUBTOTAL(103,September[24])","v":0},{"$f":"SUBTOTAL(103,September[25])","v":0},{"$f":"SUBTOTAL(103,September[26])","v":0},{"$f":"SUBTOTAL(103,September[27])","v":0},{"$f":"SUBTOTAL(103,September[28])","v":0},{"$f":"SUBTOTAL(103,September[29])","v":0},{"$f":"SUBTOTAL(109,September[30])","v":0},{"$f":"SUBTOTAL(109,September[31])","v":0},{"$f":"SUBTOTAL(109,September[Total Days])","v":0}]

{"sheet":"October","index":9,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Employee Absence Schedule"}]
[null,"Absence Type Key","H","Holiday",null,null,"P","Personal",null,null,"S","Sick",null,null,"Custom 1",{"$nulls":3},"Custom 2"]
[]
[null,"October","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,1),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,2),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,3),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,4),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,5),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,6),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,7),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,8),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,9),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,10),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,11),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,12),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,13),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,14),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,15),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,16),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,17),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,18),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,19),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,20),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,21),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,22),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,23),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,24),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,25),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,26),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,27),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,28),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,29),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,30),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,31),1),\"aaa\")","v":"Mon"}]
[null,"Employee Name","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total Days"]
[null,"Employee 1",{"$nulls":31},{"$f":"COUNTA(October[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 2",{"$nulls":31},{"$f":"COUNTA(October[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 3",{"$nulls":31},{"$f":"COUNTA(October[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 4",{"$nulls":31},{"$f":"COUNTA(October[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 5",{"$nulls":31},{"$f":"COUNTA(October[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"MonthName&\" Total\"","v":"October Total"},{"$f":"SUBTOTAL(103,October[1])","v":0},{"$f":"SUBTOTAL(103,October[2])","v":0},{"$f":"SUBTOTAL(103,October[3])","v":0},{"$f":"SUBTOTAL(103,October[4])","v":0},{"$f":"SUBTOTAL(103,October[5])","v":0},{"$f":"SUBTOTAL(103,October[6])","v":0},{"$f":"SUBTOTAL(103,October[7])","v":0},{"$f":"SUBTOTAL(103,October[8])","v":0},{"$f":"SUBTOTAL(103,October[9])","v":0},{"$f":"SUBTOTAL(103,October[10])","v":0},{"$f":"SUBTOTAL(103,October[11])","v":0},{"$f":"SUBTOTAL(103,October[12])","v":0},{"$f":"SUBTOTAL(103,October[13])","v":0},{"$f":"SUBTOTAL(103,October[14])","v":0},{"$f":"SUBTOTAL(103,October[15])","v":0},{"$f":"SUBTOTAL(103,October[16])","v":0},{"$f":"SUBTOTAL(103,October[17])","v":0},{"$f":"SUBTOTAL(103,October[18])","v":0},{"$f":"SUBTOTAL(103,October[19])","v":0},{"$f":"SUBTOTAL(103,October[20])","v":0},{"$f":"SUBTOTAL(103,October[21])","v":0},{"$f":"SUBTOTAL(103,October[22])","v":0},{"$f":"SUBTOTAL(103,October[23])","v":0},{"$f":"SUBTOTAL(103,October[24])","v":0},{"$f":"SUBTOTAL(103,October[25])","v":0},{"$f":"SUBTOTAL(103,October[26])","v":0},{"$f":"SUBTOTAL(103,October[27])","v":0},{"$f":"SUBTOTAL(103,October[28])","v":0},{"$f":"SUBTOTAL(103,October[29])","v":0},{"$f":"SUBTOTAL(109,October[30])","v":0},{"$f":"SUBTOTAL(109,October[31])","v":0},{"$f":"SUBTOTAL(109,October[Total Days])","v":0}]

{"sheet":"November","index":10,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Employee Absence Schedule"}]
[null,"Absence Type Key","H","Holiday",null,null,"P","Personal",null,null,"S","Sick",null,null,"Custom 1",{"$nulls":3},"Custom 2"]
[]
[null,"November","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,1),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,2),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,3),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,4),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,5),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,6),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,7),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,8),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,9),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,10),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,11),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,12),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,13),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,14),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,15),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,16),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,17),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,18),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,19),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,20),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,21),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,22),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,23),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,24),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,25),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,26),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,27),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,28),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,29),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,30),1),\"aaa\")","v":"Wed"}]
[null,"Employee Name","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total Days"]
[null,"Employee 1",{"$nulls":31},{"$f":"COUNTA(November[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 2",{"$nulls":31},{"$f":"COUNTA(November[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 3",{"$nulls":31},{"$f":"COUNTA(November[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 4",{"$nulls":31},{"$f":"COUNTA(November[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 5",{"$nulls":31},{"$f":"COUNTA(November[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"MonthName&\" Total\"","v":"November Total"},{"$f":"SUBTOTAL(103,November[1])","v":0},{"$f":"SUBTOTAL(103,November[2])","v":0},{"$f":"SUBTOTAL(103,November[3])","v":0},{"$f":"SUBTOTAL(103,November[4])","v":0},{"$f":"SUBTOTAL(103,November[5])","v":0},{"$f":"SUBTOTAL(103,November[6])","v":0},{"$f":"SUBTOTAL(103,November[7])","v":0},{"$f":"SUBTOTAL(103,November[8])","v":0},{"$f":"SUBTOTAL(103,November[9])","v":0},{"$f":"SUBTOTAL(103,November[10])","v":0},{"$f":"SUBTOTAL(103,November[11])","v":0},{"$f":"SUBTOTAL(103,November[12])","v":0},{"$f":"SUBTOTAL(103,November[13])","v":0},{"$f":"SUBTOTAL(103,November[14])","v":0},{"$f":"SUBTOTAL(103,November[15])","v":0},{"$f":"SUBTOTAL(103,November[16])","v":0},{"$f":"SUBTOTAL(103,November[17])","v":0},{"$f":"SUBTOTAL(103,November[18])","v":0},{"$f":"SUBTOTAL(103,November[19])","v":0},{"$f":"SUBTOTAL(103,November[20])","v":0},{"$f":"SUBTOTAL(103,November[21])","v":0},{"$f":"SUBTOTAL(103,November[22])","v":0},{"$f":"SUBTOTAL(103,November[23])","v":0},{"$f":"SUBTOTAL(103,November[24])","v":0},{"$f":"SUBTOTAL(103,November[25])","v":0},{"$f":"SUBTOTAL(103,November[26])","v":0},{"$f":"SUBTOTAL(103,November[27])","v":0},{"$f":"SUBTOTAL(103,November[28])","v":0},{"$f":"SUBTOTAL(103,November[29])","v":0},{"$f":"SUBTOTAL(109,November[30])","v":0},{"$f":"SUBTOTAL(109,November[31])","v":0},{"$f":"SUBTOTAL(109,November[Total Days])","v":0}]

{"sheet":"December","index":11,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Employee Absence Schedule"}]
[null,"Absence Type Key","H","Holiday",null,null,"P","Personal",null,null,"S","Sick",null,null,"Custom 1",{"$nulls":3},"Custom 2"]
[]
[null,"December","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,1),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,2),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,3),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,4),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,5),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,6),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,7),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,8),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,9),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,10),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,11),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,12),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,13),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,14),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,15),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,16),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,17),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,18),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,19),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,20),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,21),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,22),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,23),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,24),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,25),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,26),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,27),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,28),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,29),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,30),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,31),1),\"aaa\")","v":"Sat"}]
[null,"Employee Name","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total Days"]
[null,"Employee 1",{"$nulls":31},{"$f":"COUNTA(December[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 2",{"$nulls":31},{"$f":"COUNTA(December[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 3",{"$nulls":31},{"$f":"COUNTA(December[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 4",{"$nulls":31},{"$f":"COUNTA(December[[#This Row],[1]:[31]])","v":0}]
[null,"Employee 5",{"$nulls":31},{"$f":"COUNTA(December[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"MonthName&\" Total\"","v":"December Total"},{"$f":"SUBTOTAL(103,December[1])","v":0},{"$f":"SUBTOTAL(103,December[2])","v":0},{"$f":"SUBTOTAL(103,December[3])","v":0},{"$f":"SUBTOTAL(103,December[4])","v":0},{"$f":"SUBTOTAL(103,December[5])","v":0},{"$f":"SUBTOTAL(103,December[6])","v":0},{"$f":"SUBTOTAL(103,December[7])","v":0},{"$f":"SUBTOTAL(103,December[8])","v":0},{"$f":"SUBTOTAL(103,December[9])","v":0},{"$f":"SUBTOTAL(103,December[10])","v":0},{"$f":"SUBTOTAL(103,December[11])","v":0},{"$f":"SUBTOTAL(103,December[12])","v":0},{"$f":"SUBTOTAL(103,December[13])","v":0},{"$f":"SUBTOTAL(103,December[14])","v":0},{"$f":"SUBTOTAL(103,December[15])","v":0},{"$f":"SUBTOTAL(103,December[16])","v":0},{"$f":"SUBTOTAL(103,December[17])","v":0},{"$f":"SUBTOTAL(103,December[18])","v":0},{"$f":"SUBTOTAL(103,December[19])","v":0},{"$f":"SUBTOTAL(103,December[20])","v":0},{"$f":"SUBTOTAL(103,December[21])","v":0},{"$f":"SUBTOTAL(103,December[22])","v":0},{"$f":"SUBTOTAL(103,December[23])","v":0},{"$f":"SUBTOTAL(103,December[24])","v":0},{"$f":"SUBTOTAL(103,December[25])","v":0},{"$f":"SUBTOTAL(103,December[26])","v":0},{"$f":"SUBTOTAL(103,December[27])","v":0},{"$f":"SUBTOTAL(103,December[28])","v":0},{"$f":"SUBTOTAL(103,December[29])","v":0},{"$f":"SUBTOTAL(109,December[30])","v":0},{"$f":"SUBTOTAL(109,December[31])","v":0},{"$f":"SUBTOTAL(109,December[Total Days])","v":0}]

{"sheet":"Employee Names","index":12,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"Employee Names"]
[]
[null,"Employee Names"]
[null,"Employee 1"]
[null,"Employee 2"]
[null,"Employee 3"]
[null,"Employee 4"]
[null,"Employee 5"]