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

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

{"sheet":"February","index":1,"n_rows":12,"n_cols":33,"rows_kept":12,"merged":[[1,0,2,0],[1,1,1,31],[1,32,2,32],[10,0,10,32]]}
["Employee Absence Schedule"]
["February","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2013}]
[null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,1),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,2),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,3),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,4),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,5),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,6),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,7),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,8),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,9),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,10),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,11),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,12),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,13),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,14),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,15),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,16),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,17),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,18),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,19),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,20),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,21),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,22),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,23),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,24),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,25),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,26),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,27),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,28),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,29),1),\"aaa\")","v":"Fri"}]
["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"]
["Employee 1",null,null,"V","V","V","V",{"$nulls":6},"V",{"$nulls":18},{"$f":"COUNTA(tblFebruary[[#This Row],[1]:[29]])","v":5}]
["Employee 2",{"$nulls":4},"S","S",{"$nulls":4},"P",{"$nulls":8},"S",{"$nulls":4},"V","V","V",{"$nulls":4},{"$f":"COUNTA(tblFebruary[[#This Row],[1]:[29]])","v":7}]
["Employee 3",{"$nulls":31},{"$f":"COUNTA(tblFebruary[[#This Row],[1]:[29]])","v":0}]
["Employee 4",null,null,"S",{"$nulls":10},"S",{"$nulls":3},"P",{"$nulls":9},"S",{"$nulls":3},{"$f":"COUNTA(tblFebruary[[#This Row],[1]:[29]])","v":4}]
["Employee 5",{"$nulls":7},"V","V","V","V",{"$nulls":12},"S",{"$nulls":7},{"$f":"COUNTA(tblFebruary[[#This Row],[1]:[29]])","v":5}]
[{"$f":"MonthName&\" Total\"","v":"February Total"},{"$f":"SUBTOTAL(103,tblFebruary[1])","v":0},{"$f":"SUBTOTAL(103,tblFebruary[2])","v":0},{"$f":"SUBTOTAL(103,tblFebruary[3])","v":2},{"$f":"SUBTOTAL(103,tblFebruary[4])","v":1},{"$f":"SUBTOTAL(103,tblFebruary[5])","v":2},{"$f":"SUBTOTAL(103,tblFebruary[6])","v":2},{"$f":"SUBTOTAL(103,tblFebruary[7])","v":0},{"$f":"SUBTOTAL(103,tblFebruary[8])","v":1},{"$f":"SUBTOTAL(103,tblFebruary[9])","v":1},{"$f":"SUBTOTAL(103,tblFebruary[10])","v":1},{"$f":"SUBTOTAL(103,tblFebruary[11])","v":2},{"$f":"SUBTOTAL(103,tblFebruary[12])","v":0},{"$f":"SUBTOTAL(103,tblFebruary[13])","v":1},{"$f":"SUBTOTAL(103,tblFebruary[14])","v":1},{"$f":"SUBTOTAL(103,tblFebruary[15])","v":0},{"$f":"SUBTOTAL(103,tblFebruary[16])","v":0},{"$f":"SUBTOTAL(103,tblFebruary[17])","v":0},{"$f":"SUBTOTAL(103,tblFebruary[18])","v":1},{"$f":"SUBTOTAL(103,tblFebruary[19])","v":0},{"$f":"SUBTOTAL(103,tblFebruary[20])","v":1},{"$f":"SUBTOTAL(103,tblFebruary[21])","v":0},{"$f":"SUBTOTAL(103,tblFebruary[22])","v":0},{"$f":"SUBTOTAL(103,tblFebruary[23])","v":0},{"$f":"SUBTOTAL(103,tblFebruary[24])","v":1},{"$f":"SUBTOTAL(103,tblFebruary[25])","v":1},{"$f":"SUBTOTAL(103,tblFebruary[26])","v":1},{"$f":"SUBTOTAL(103,tblFebruary[27])","v":1},{"$f":"SUBTOTAL(103,tblFebruary[28])","v":1},{"$f":"SUBTOTAL(103,tblFebruary[29])","v":0},null,null,{"$f":"SUBTOTAL(109,tblFebruary[Total Days])","v":21}]
[]
[null,{"$f":"January!B12","v":"Color Key"},{"$nulls":4},{"$f":"KeyVacation","v":"V"},{"$f":"KeyVacationLabel","v":"Vacation"},null,null,{"$f":"KeyPersonal","v":"P"},{"$f":"KeyPersonalLabel","v":"Personal"},null,null,{"$f":"KeySick","v":"S"},{"$f":"KeySickLabel","v":"Sick"},null,null,{"$f":"KeyCustom1","v":0},{"$f":"KeyCustom1Label","v":"Custom 1"},null,null,{"$f":"KeyCustom2","v":0},{"$f":"KeyCustom2Label","v":"Custom 2"}]

{"sheet":"March","index":2,"n_rows":12,"n_cols":33,"rows_kept":12,"merged":[[1,0,2,0],[1,1,1,31],[1,32,2,32],[10,0,10,32]]}
["Employee Absence Schedule"]
["March","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2013}]
[null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,1),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,2),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,3),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,4),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,5),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,6),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,7),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,8),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,9),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,10),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,11),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,12),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,13),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,14),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,15),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,16),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,17),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,18),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,19),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,20),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,21),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,22),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,23),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,24),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,25),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,26),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,27),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,28),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,29),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,30),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,31),1),\"aaa\")","v":"Sun"}]
["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"]
["Employee 1",{"$nulls":31},{"$f":"COUNTA(tblMarch[[#This Row],[1]:[29]])","v":0}]
["Employee 2",{"$nulls":31},{"$f":"COUNTA(tblMarch[[#This Row],[1]:[29]])","v":0}]
["Employee 3",{"$nulls":31},{"$f":"COUNTA(tblMarch[[#This Row],[1]:[29]])","v":0}]
["Employee 4",{"$nulls":31},{"$f":"COUNTA(tblMarch[[#This Row],[1]:[29]])","v":0}]
["Employee 5",{"$nulls":31},{"$f":"COUNTA(tblMarch[[#This Row],[1]:[29]])","v":0}]
[{"$f":"MonthName&\" Total\"","v":"March Total"},{"$f":"SUBTOTAL(103,tblMarch[1])","v":0},{"$f":"SUBTOTAL(103,tblMarch[2])","v":0},{"$f":"SUBTOTAL(103,tblMarch[3])","v":0},{"$f":"SUBTOTAL(103,tblMarch[4])","v":0},{"$f":"SUBTOTAL(103,tblMarch[5])","v":0},{"$f":"SUBTOTAL(103,tblMarch[6])","v":0},{"$f":"SUBTOTAL(103,tblMarch[7])","v":0},{"$f":"SUBTOTAL(103,tblMarch[8])","v":0},{"$f":"SUBTOTAL(103,tblMarch[9])","v":0},{"$f":"SUBTOTAL(103,tblMarch[10])","v":0},{"$f":"SUBTOTAL(103,tblMarch[11])","v":0},{"$f":"SUBTOTAL(103,tblMarch[12])","v":0},{"$f":"SUBTOTAL(103,tblMarch[13])","v":0},{"$f":"SUBTOTAL(103,tblMarch[14])","v":0},{"$f":"SUBTOTAL(103,tblMarch[15])","v":0},{"$f":"SUBTOTAL(103,tblMarch[16])","v":0},{"$f":"SUBTOTAL(103,tblMarch[17])","v":0},{"$f":"SUBTOTAL(103,tblMarch[18])","v":0},{"$f":"SUBTOTAL(103,tblMarch[19])","v":0},{"$f":"SUBTOTAL(103,tblMarch[20])","v":0},{"$f":"SUBTOTAL(103,tblMarch[21])","v":0},{"$f":"SUBTOTAL(103,tblMarch[22])","v":0},{"$f":"SUBTOTAL(103,tblMarch[23])","v":0},{"$f":"SUBTOTAL(103,tblMarch[24])","v":0},{"$f":"SUBTOTAL(103,tblMarch[25])","v":0},{"$f":"SUBTOTAL(103,tblMarch[26])","v":0},{"$f":"SUBTOTAL(103,tblMarch[27])","v":0},{"$f":"SUBTOTAL(103,tblMarch[28])","v":0},{"$f":"SUBTOTAL(103,tblMarch[29])","v":0},null,null,{"$f":"SUBTOTAL(109,tblMarch[Total Days])","v":0}]
[]
[null,{"$f":"January!B12","v":"Color Key"},{"$nulls":4},{"$f":"KeyVacation","v":"V"},{"$f":"KeyVacationLabel","v":"Vacation"},null,null,{"$f":"KeyPersonal","v":"P"},{"$f":"KeyPersonalLabel","v":"Personal"},null,null,{"$f":"KeySick","v":"S"},{"$f":"KeySickLabel","v":"Sick"},null,null,{"$f":"KeyCustom1","v":0},{"$f":"KeyCustom1Label","v":"Custom 1"},null,null,{"$f":"KeyCustom2","v":0},{"$f":"KeyCustom2Label","v":"Custom 2"}]

{"sheet":"April","index":3,"n_rows":12,"n_cols":33,"rows_kept":12,"merged":[[1,0,2,0],[1,1,1,31],[1,32,2,32],[10,0,10,32]]}
["Employee Absence Schedule"]
["April","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2013}]
[null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,1),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,2),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,3),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,4),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,5),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,6),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,7),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,8),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,9),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,10),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,11),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,12),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,13),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,14),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,15),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,16),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,17),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,18),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,19),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,20),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,21),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,22),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,23),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,24),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,25),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,26),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,27),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,28),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,29),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,30),1),\"aaa\")","v":"Tue"}]
["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"," ","Total Days"]
["Employee 1",{"$nulls":31},{"$f":"COUNTA(tblApril[[#This Row],[1]:[29]])","v":0}]
["Employee 2",{"$nulls":31},{"$f":"COUNTA(tblApril[[#This Row],[1]:[29]])","v":0}]
["Employee 3",{"$nulls":31},{"$f":"COUNTA(tblApril[[#This Row],[1]:[29]])","v":0}]
["Employee 4",{"$nulls":31},{"$f":"COUNTA(tblApril[[#This Row],[1]:[29]])","v":0}]
["Employee 5",{"$nulls":31},{"$f":"COUNTA(tblApril[[#This Row],[1]:[29]])","v":0}]
[{"$f":"MonthName&\" Total\"","v":"April Total"},{"$f":"SUBTOTAL(103,tblApril[1])","v":0},{"$f":"SUBTOTAL(103,tblApril[2])","v":0},{"$f":"SUBTOTAL(103,tblApril[3])","v":0},{"$f":"SUBTOTAL(103,tblApril[4])","v":0},{"$f":"SUBTOTAL(103,tblApril[5])","v":0},{"$f":"SUBTOTAL(103,tblApril[6])","v":0},{"$f":"SUBTOTAL(103,tblApril[7])","v":0},{"$f":"SUBTOTAL(103,tblApril[8])","v":0},{"$f":"SUBTOTAL(103,tblApril[9])","v":0},{"$f":"SUBTOTAL(103,tblApril[10])","v":0},{"$f":"SUBTOTAL(103,tblApril[11])","v":0},{"$f":"SUBTOTAL(103,tblApril[12])","v":0},{"$f":"SUBTOTAL(103,tblApril[13])","v":0},{"$f":"SUBTOTAL(103,tblApril[14])","v":0},{"$f":"SUBTOTAL(103,tblApril[15])","v":0},{"$f":"SUBTOTAL(103,tblApril[16])","v":0},{"$f":"SUBTOTAL(103,tblApril[17])","v":0},{"$f":"SUBTOTAL(103,tblApril[18])","v":0},{"$f":"SUBTOTAL(103,tblApril[19])","v":0},{"$f":"SUBTOTAL(103,tblApril[20])","v":0},{"$f":"SUBTOTAL(103,tblApril[21])","v":0},{"$f":"SUBTOTAL(103,tblApril[22])","v":0},{"$f":"SUBTOTAL(103,tblApril[23])","v":0},{"$f":"SUBTOTAL(103,tblApril[24])","v":0},{"$f":"SUBTOTAL(103,tblApril[25])","v":0},{"$f":"SUBTOTAL(103,tblApril[26])","v":0},{"$f":"SUBTOTAL(103,tblApril[27])","v":0},{"$f":"SUBTOTAL(103,tblApril[28])","v":0},{"$f":"SUBTOTAL(103,tblApril[29])","v":0},null,null,{"$f":"SUBTOTAL(109,tblApril[Total Days])","v":0}]
[]
[null,{"$f":"January!B12","v":"Color Key"},{"$nulls":4},{"$f":"KeyVacation","v":"V"},{"$f":"KeyVacationLabel","v":"Vacation"},null,null,{"$f":"KeyPersonal","v":"P"},{"$f":"KeyPersonalLabel","v":"Personal"},null,null,{"$f":"KeySick","v":"S"},{"$f":"KeySickLabel","v":"Sick"},null,null,{"$f":"KeyCustom1","v":0},{"$f":"KeyCustom1Label","v":"Custom 1"},null,null,{"$f":"KeyCustom2","v":0},{"$f":"KeyCustom2Label","v":"Custom 2"}]

{"sheet":"May","index":4,"n_rows":12,"n_cols":33,"rows_kept":12,"merged":[[1,0,2,0],[1,1,1,31],[1,32,2,32],[10,0,10,32]]}
["Employee Absence Schedule"]
["May","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2013}]
[null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,1),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,2),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,3),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,4),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,5),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,6),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,7),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,8),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,9),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,10),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,11),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,12),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,13),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,14),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,15),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,16),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,17),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,18),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,19),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,20),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,21),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,22),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,23),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,24),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,25),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,26),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,27),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,28),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,29),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,30),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,31),1),\"aaa\")","v":"Fri"}]
["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"]
["Employee 1",{"$nulls":31},{"$f":"COUNTA(tblMay[[#This Row],[1]:[29]])","v":0}]
["Employee 2",{"$nulls":31},{"$f":"COUNTA(tblMay[[#This Row],[1]:[29]])","v":0}]
["Employee 3",{"$nulls":31},{"$f":"COUNTA(tblMay[[#This Row],[1]:[29]])","v":0}]
["Employee 4",{"$nulls":31},{"$f":"COUNTA(tblMay[[#This Row],[1]:[29]])","v":0}]
["Employee 5",{"$nulls":31},{"$f":"COUNTA(tblMay[[#This Row],[1]:[29]])","v":0}]
[{"$f":"MonthName&\" Total\"","v":"May Total"},{"$f":"SUBTOTAL(103,tblMay[1])","v":0},{"$f":"SUBTOTAL(103,tblMay[2])","v":0},{"$f":"SUBTOTAL(103,tblMay[3])","v":0},{"$f":"SUBTOTAL(103,tblMay[4])","v":0},{"$f":"SUBTOTAL(103,tblMay[5])","v":0},{"$f":"SUBTOTAL(103,tblMay[6])","v":0},{"$f":"SUBTOTAL(103,tblMay[7])","v":0},{"$f":"SUBTOTAL(103,tblMay[8])","v":0},{"$f":"SUBTOTAL(103,tblMay[9])","v":0},{"$f":"SUBTOTAL(103,tblMay[10])","v":0},{"$f":"SUBTOTAL(103,tblMay[11])","v":0},{"$f":"SUBTOTAL(103,tblMay[12])","v":0},{"$f":"SUBTOTAL(103,tblMay[13])","v":0},{"$f":"SUBTOTAL(103,tblMay[14])","v":0},{"$f":"SUBTOTAL(103,tblMay[15])","v":0},{"$f":"SUBTOTAL(103,tblMay[16])","v":0},{"$f":"SUBTOTAL(103,tblMay[17])","v":0},{"$f":"SUBTOTAL(103,tblMay[18])","v":0},{"$f":"SUBTOTAL(103,tblMay[19])","v":0},{"$f":"SUBTOTAL(103,tblMay[20])","v":0},{"$f":"SUBTOTAL(103,tblMay[21])","v":0},{"$f":"SUBTOTAL(103,tblMay[22])","v":0},{"$f":"SUBTOTAL(103,tblMay[23])","v":0},{"$f":"SUBTOTAL(103,tblMay[24])","v":0},{"$f":"SUBTOTAL(103,tblMay[25])","v":0},{"$f":"SUBTOTAL(103,tblMay[26])","v":0},{"$f":"SUBTOTAL(103,tblMay[27])","v":0},{"$f":"SUBTOTAL(103,tblMay[28])","v":0},{"$f":"SUBTOTAL(103,tblMay[29])","v":0},null,null,{"$f":"SUBTOTAL(109,tblMay[Total Days])","v":0}]
[]
[null,{"$f":"January!B12","v":"Color Key"},{"$nulls":4},{"$f":"KeyVacation","v":"V"},{"$f":"KeyVacationLabel","v":"Vacation"},null,null,{"$f":"KeyPersonal","v":"P"},{"$f":"KeyPersonalLabel","v":"Personal"},null,null,{"$f":"KeySick","v":"S"},{"$f":"KeySickLabel","v":"Sick"},null,null,{"$f":"KeyCustom1","v":0},{"$f":"KeyCustom1Label","v":"Custom 1"},null,null,{"$f":"KeyCustom2","v":0},{"$f":"KeyCustom2Label","v":"Custom 2"}]

{"sheet":"June","index":5,"n_rows":12,"n_cols":33,"rows_kept":12,"merged":[[1,0,2,0],[1,1,1,31],[1,32,2,32],[10,0,10,32]]}
["Employee Absence Schedule"]
["June","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2013}]
[null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,1),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,2),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,3),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,4),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,5),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,6),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,7),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,8),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,9),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,10),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,11),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,12),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,13),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,14),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,15),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,16),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,17),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,18),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,19),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,20),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,21),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,22),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,23),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,24),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,25),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,26),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,27),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,28),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,29),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,30),1),\"aaa\")","v":"Sun"}]
["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"," ","Total Days"]
["Employee 1",{"$nulls":31},{"$f":"COUNTA(tblJune[[#This Row],[1]:[29]])","v":0}]
["Employee 2",{"$nulls":31},{"$f":"COUNTA(tblJune[[#This Row],[1]:[29]])","v":0}]
["Employee 3",{"$nulls":31},{"$f":"COUNTA(tblJune[[#This Row],[1]:[29]])","v":0}]
["Employee 4",{"$nulls":31},{"$f":"COUNTA(tblJune[[#This Row],[1]:[29]])","v":0}]
["Employee 5",{"$nulls":31},{"$f":"COUNTA(tblJune[[#This Row],[1]:[29]])","v":0}]
[{"$f":"MonthName&\" Total\"","v":"June Total"},{"$f":"SUBTOTAL(103,tblJune[1])","v":0},{"$f":"SUBTOTAL(103,tblJune[2])","v":0},{"$f":"SUBTOTAL(103,tblJune[3])","v":0},{"$f":"SUBTOTAL(103,tblJune[4])","v":0},{"$f":"SUBTOTAL(103,tblJune[5])","v":0},{"$f":"SUBTOTAL(103,tblJune[6])","v":0},{"$f":"SUBTOTAL(103,tblJune[7])","v":0},{"$f":"SUBTOTAL(103,tblJune[8])","v":0},{"$f":"SUBTOTAL(103,tblJune[9])","v":0},{"$f":"SUBTOTAL(103,tblJune[10])","v":0},{"$f":"SUBTOTAL(103,tblJune[11])","v":0},{"$f":"SUBTOTAL(103,tblJune[12])","v":0},{"$f":"SUBTOTAL(103,tblJune[13])","v":0},{"$f":"SUBTOTAL(103,tblJune[14])","v":0},{"$f":"SUBTOTAL(103,tblJune[15])","v":0},{"$f":"SUBTOTAL(103,tblJune[16])","v":0},{"$f":"SUBTOTAL(103,tblJune[17])","v":0},{"$f":"SUBTOTAL(103,tblJune[18])","v":0},{"$f":"SUBTOTAL(103,tblJune[19])","v":0},{"$f":"SUBTOTAL(103,tblJune[20])","v":0},{"$f":"SUBTOTAL(103,tblJune[21])","v":0},{"$f":"SUBTOTAL(103,tblJune[22])","v":0},{"$f":"SUBTOTAL(103,tblJune[23])","v":0},{"$f":"SUBTOTAL(103,tblJune[24])","v":0},{"$f":"SUBTOTAL(103,tblJune[25])","v":0},{"$f":"SUBTOTAL(103,tblJune[26])","v":0},{"$f":"SUBTOTAL(103,tblJune[27])","v":0},{"$f":"SUBTOTAL(103,tblJune[28])","v":0},{"$f":"SUBTOTAL(103,tblJune[29])","v":0},null,null,{"$f":"SUBTOTAL(109,tblJune[Total Days])","v":0}]
[]
[null,{"$f":"January!B12","v":"Color Key"},{"$nulls":4},{"$f":"KeyVacation","v":"V"},{"$f":"KeyVacationLabel","v":"Vacation"},null,null,{"$f":"KeyPersonal","v":"P"},{"$f":"KeyPersonalLabel","v":"Personal"},null,null,{"$f":"KeySick","v":"S"},{"$f":"KeySickLabel","v":"Sick"},null,null,{"$f":"KeyCustom1","v":0},{"$f":"KeyCustom1Label","v":"Custom 1"},null,null,{"$f":"KeyCustom2","v":0},{"$f":"KeyCustom2Label","v":"Custom 2"}]

{"sheet":"July","index":6,"n_rows":12,"n_cols":33,"rows_kept":12,"merged":[[1,0,2,0],[1,1,1,31],[1,32,2,32],[10,0,10,32]]}
["Employee Absence Schedule"]
["July","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2013}]
[null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,1),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,2),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,3),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,4),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,5),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,6),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,7),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,8),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,9),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,10),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,11),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,12),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,13),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,14),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,15),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,16),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,17),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,18),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,19),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,20),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,21),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,22),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,23),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,24),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,25),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,26),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,27),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,28),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,29),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,30),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,31),1),\"aaa\")","v":"Wed"}]
["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"]
["Employee 1",{"$nulls":31},{"$f":"COUNTA(tblJuly[[#This Row],[1]:[29]])","v":0}]
["Employee 2",{"$nulls":31},{"$f":"COUNTA(tblJuly[[#This Row],[1]:[29]])","v":0}]
["Employee 3",{"$nulls":31},{"$f":"COUNTA(tblJuly[[#This Row],[1]:[29]])","v":0}]
["Employee 4",{"$nulls":31},{"$f":"COUNTA(tblJuly[[#This Row],[1]:[29]])","v":0}]
["Employee 5",{"$nulls":31},{"$f":"COUNTA(tblJuly[[#This Row],[1]:[29]])","v":0}]
[{"$f":"MonthName&\" Total\"","v":"July Total"},{"$f":"SUBTOTAL(103,tblJuly[1])","v":0},{"$f":"SUBTOTAL(103,tblJuly[2])","v":0},{"$f":"SUBTOTAL(103,tblJuly[3])","v":0},{"$f":"SUBTOTAL(103,tblJuly[4])","v":0},{"$f":"SUBTOTAL(103,tblJuly[5])","v":0},{"$f":"SUBTOTAL(103,tblJuly[6])","v":0},{"$f":"SUBTOTAL(103,tblJuly[7])","v":0},{"$f":"SUBTOTAL(103,tblJuly[8])","v":0},{"$f":"SUBTOTAL(103,tblJuly[9])","v":0},{"$f":"SUBTOTAL(103,tblJuly[10])","v":0},{"$f":"SUBTOTAL(103,tblJuly[11])","v":0},{"$f":"SUBTOTAL(103,tblJuly[12])","v":0},{"$f":"SUBTOTAL(103,tblJuly[13])","v":0},{"$f":"SUBTOTAL(103,tblJuly[14])","v":0},{"$f":"SUBTOTAL(103,tblJuly[15])","v":0},{"$f":"SUBTOTAL(103,tblJuly[16])","v":0},{"$f":"SUBTOTAL(103,tblJuly[17])","v":0},{"$f":"SUBTOTAL(103,tblJuly[18])","v":0},{"$f":"SUBTOTAL(103,tblJuly[19])","v":0},{"$f":"SUBTOTAL(103,tblJuly[20])","v":0},{"$f":"SUBTOTAL(103,tblJuly[21])","v":0},{"$f":"SUBTOTAL(103,tblJuly[22])","v":0},{"$f":"SUBTOTAL(103,tblJuly[23])","v":0},{"$f":"SUBTOTAL(103,tblJuly[24])","v":0},{"$f":"SUBTOTAL(103,tblJuly[25])","v":0},{"$f":"SUBTOTAL(103,tblJuly[26])","v":0},{"$f":"SUBTOTAL(103,tblJuly[27])","v":0},{"$f":"SUBTOTAL(103,tblJuly[28])","v":0},{"$f":"SUBTOTAL(103,tblJuly[29])","v":0},null,null,{"$f":"SUBTOTAL(109,tblJuly[Total Days])","v":0}]
[]
[null,{"$f":"January!B12","v":"Color Key"},{"$nulls":4},{"$f":"KeyVacation","v":"V"},{"$f":"KeyVacationLabel","v":"Vacation"},null,null,{"$f":"KeyPersonal","v":"P"},{"$f":"KeyPersonalLabel","v":"Personal"},null,null,{"$f":"KeySick","v":"S"},{"$f":"KeySickLabel","v":"Sick"},null,null,{"$f":"KeyCustom1","v":0},{"$f":"KeyCustom1Label","v":"Custom 1"},null,null,{"$f":"KeyCustom2","v":0},{"$f":"KeyCustom2Label","v":"Custom 2"}]

{"sheet":"August","index":7,"n_rows":12,"n_cols":33,"rows_kept":12,"merged":[[1,0,2,0],[1,1,1,31],[1,32,2,32],[10,0,10,32]]}
["Employee Absence Schedule"]
["August","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2013}]
[null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,1),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,2),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,3),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,4),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,5),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,6),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,7),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,8),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,9),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,10),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,11),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,12),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,13),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,14),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,15),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,16),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,17),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,18),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,19),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,20),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,21),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,22),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,23),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,24),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,25),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,26),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,27),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,28),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,29),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,30),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,31),1),\"aaa\")","v":"Sat"}]
["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"]
["Employee 1",{"$nulls":31},{"$f":"COUNTA(tblAugust[[#This Row],[1]:[29]])","v":0}]
["Employee 2",{"$nulls":31},{"$f":"COUNTA(tblAugust[[#This Row],[1]:[29]])","v":0}]
["Employee 3",{"$nulls":31},{"$f":"COUNTA(tblAugust[[#This Row],[1]:[29]])","v":0}]
["Employee 4",{"$nulls":31},{"$f":"COUNTA(tblAugust[[#This Row],[1]:[29]])","v":0}]
["Employee 5",{"$nulls":31},{"$f":"COUNTA(tblAugust[[#This Row],[1]:[29]])","v":0}]
[{"$f":"MonthName&\" Total\"","v":"August Total"},{"$f":"SUBTOTAL(103,tblAugust[1])","v":0},{"$f":"SUBTOTAL(103,tblAugust[2])","v":0},{"$f":"SUBTOTAL(103,tblAugust[3])","v":0},{"$f":"SUBTOTAL(103,tblAugust[4])","v":0},{"$f":"SUBTOTAL(103,tblAugust[5])","v":0},{"$f":"SUBTOTAL(103,tblAugust[6])","v":0},{"$f":"SUBTOTAL(103,tblAugust[7])","v":0},{"$f":"SUBTOTAL(103,tblAugust[8])","v":0},{"$f":"SUBTOTAL(103,tblAugust[9])","v":0},{"$f":"SUBTOTAL(103,tblAugust[10])","v":0},{"$f":"SUBTOTAL(103,tblAugust[11])","v":0},{"$f":"SUBTOTAL(103,tblAugust[12])","v":0},{"$f":"SUBTOTAL(103,tblAugust[13])","v":0},{"$f":"SUBTOTAL(103,tblAugust[14])","v":0},{"$f":"SUBTOTAL(103,tblAugust[15])","v":0},{"$f":"SUBTOTAL(103,tblAugust[16])","v":0},{"$f":"SUBTOTAL(103,tblAugust[17])","v":0},{"$f":"SUBTOTAL(103,tblAugust[18])","v":0},{"$f":"SUBTOTAL(103,tblAugust[19])","v":0},{"$f":"SUBTOTAL(103,tblAugust[20])","v":0},{"$f":"SUBTOTAL(103,tblAugust[21])","v":0},{"$f":"SUBTOTAL(103,tblAugust[22])","v":0},{"$f":"SUBTOTAL(103,tblAugust[23])","v":0},{"$f":"SUBTOTAL(103,tblAugust[24])","v":0},{"$f":"SUBTOTAL(103,tblAugust[25])","v":0},{"$f":"SUBTOTAL(103,tblAugust[26])","v":0},{"$f":"SUBTOTAL(103,tblAugust[27])","v":0},{"$f":"SUBTOTAL(103,tblAugust[28])","v":0},{"$f":"SUBTOTAL(103,tblAugust[29])","v":0},null,null,{"$f":"SUBTOTAL(109,tblAugust[Total Days])","v":0}]
[]
[null,{"$f":"January!B12","v":"Color Key"},{"$nulls":4},{"$f":"KeyVacation","v":"V"},{"$f":"KeyVacationLabel","v":"Vacation"},null,null,{"$f":"KeyPersonal","v":"P"},{"$f":"KeyPersonalLabel","v":"Personal"},null,null,{"$f":"KeySick","v":"S"},{"$f":"KeySickLabel","v":"Sick"},null,null,{"$f":"KeyCustom1","v":0},{"$f":"KeyCustom1Label","v":"Custom 1"},null,null,{"$f":"KeyCustom2","v":0},{"$f":"KeyCustom2Label","v":"Custom 2"}]

{"sheet":"September","index":8,"n_rows":12,"n_cols":33,"rows_kept":12,"merged":[[1,0,2,0],[1,1,1,31],[1,32,2,32],[10,0,10,32]]}
["Employee Absence Schedule"]
["September","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2013}]
[null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,1),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,2),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,3),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,4),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,5),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,6),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,7),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,8),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,9),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,10),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,11),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,12),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,13),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,14),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,15),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,16),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,17),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,18),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,19),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,20),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,21),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,22),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,23),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,24),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,25),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,26),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,27),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,28),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,29),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,30),1),\"aaa\")","v":"Mon"}]
["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"," ","Total Days"]
["Employee 1",{"$nulls":31},{"$f":"COUNTA(tblSeptember[[#This Row],[1]:[29]])","v":0}]
["Employee 2",{"$nulls":31},{"$f":"COUNTA(tblSeptember[[#This Row],[1]:[29]])","v":0}]
["Employee 3",{"$nulls":31},{"$f":"COUNTA(tblSeptember[[#This Row],[1]:[29]])","v":0}]
["Employee 4",{"$nulls":31},{"$f":"COUNTA(tblSeptember[[#This Row],[1]:[29]])","v":0}]
["Employee 5",{"$nulls":31},{"$f":"COUNTA(tblSeptember[[#This Row],[1]:[29]])","v":0}]
[{"$f":"MonthName&\" Total\"","v":"September Total"},{"$f":"SUBTOTAL(103,tblSeptember[1])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[2])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[3])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[4])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[5])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[6])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[7])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[8])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[9])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[10])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[11])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[12])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[13])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[14])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[15])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[16])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[17])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[18])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[19])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[20])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[21])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[22])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[23])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[24])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[25])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[26])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[27])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[28])","v":0},{"$f":"SUBTOTAL(103,tblSeptember[29])","v":0},null,null,{"$f":"SUBTOTAL(109,tblSeptember[Total Days])","v":0}]
[]
[null,{"$f":"January!B12","v":"Color Key"},{"$nulls":4},{"$f":"KeyVacation","v":"V"},{"$f":"KeyVacationLabel","v":"Vacation"},null,null,{"$f":"KeyPersonal","v":"P"},{"$f":"KeyPersonalLabel","v":"Personal"},null,null,{"$f":"KeySick","v":"S"},{"$f":"KeySickLabel","v":"Sick"},null,null,{"$f":"KeyCustom1","v":0},{"$f":"KeyCustom1Label","v":"Custom 1"},null,null,{"$f":"KeyCustom2","v":0},{"$f":"KeyCustom2Label","v":"Custom 2"}]

{"sheet":"October","index":9,"n_rows":12,"n_cols":33,"rows_kept":12,"merged":[[1,0,2,0],[1,1,1,31],[1,32,2,32],[10,0,10,32]]}
["Employee Absence Schedule"]
["October","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2013}]
[null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,1),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,2),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,3),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,4),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,5),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,6),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,7),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,8),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,9),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,10),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,11),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,12),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,13),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,14),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,15),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,16),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,17),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,18),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,19),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,20),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,21),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,22),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,23),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,24),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,25),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,26),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,27),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,28),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,29),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,30),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,31),1),\"aaa\")","v":"Thu"}]
["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"]
["Employee 1",{"$nulls":31},{"$f":"COUNTA(tblOctober[[#This Row],[1]:[29]])","v":0}]
["Employee 2",{"$nulls":31},{"$f":"COUNTA(tblOctober[[#This Row],[1]:[29]])","v":0}]
["Employee 3",{"$nulls":31},{"$f":"COUNTA(tblOctober[[#This Row],[1]:[29]])","v":0}]
["Employee 4",{"$nulls":31},{"$f":"COUNTA(tblOctober[[#This Row],[1]:[29]])","v":0}]
["Employee 5",{"$nulls":31},{"$f":"COUNTA(tblOctober[[#This Row],[1]:[29]])","v":0}]
[{"$f":"MonthName&\" Total\"","v":"October Total"},{"$f":"SUBTOTAL(103,tblOctober[1])","v":0},{"$f":"SUBTOTAL(103,tblOctober[2])","v":0},{"$f":"SUBTOTAL(103,tblOctober[3])","v":0},{"$f":"SUBTOTAL(103,tblOctober[4])","v":0},{"$f":"SUBTOTAL(103,tblOctober[5])","v":0},{"$f":"SUBTOTAL(103,tblOctober[6])","v":0},{"$f":"SUBTOTAL(103,tblOctober[7])","v":0},{"$f":"SUBTOTAL(103,tblOctober[8])","v":0},{"$f":"SUBTOTAL(103,tblOctober[9])","v":0},{"$f":"SUBTOTAL(103,tblOctober[10])","v":0},{"$f":"SUBTOTAL(103,tblOctober[11])","v":0},{"$f":"SUBTOTAL(103,tblOctober[12])","v":0},{"$f":"SUBTOTAL(103,tblOctober[13])","v":0},{"$f":"SUBTOTAL(103,tblOctober[14])","v":0},{"$f":"SUBTOTAL(103,tblOctober[15])","v":0},{"$f":"SUBTOTAL(103,tblOctober[16])","v":0},{"$f":"SUBTOTAL(103,tblOctober[17])","v":0},{"$f":"SUBTOTAL(103,tblOctober[18])","v":0},{"$f":"SUBTOTAL(103,tblOctober[19])","v":0},{"$f":"SUBTOTAL(103,tblOctober[20])","v":0},{"$f":"SUBTOTAL(103,tblOctober[21])","v":0},{"$f":"SUBTOTAL(103,tblOctober[22])","v":0},{"$f":"SUBTOTAL(103,tblOctober[23])","v":0},{"$f":"SUBTOTAL(103,tblOctober[24])","v":0},{"$f":"SUBTOTAL(103,tblOctober[25])","v":0},{"$f":"SUBTOTAL(103,tblOctober[26])","v":0},{"$f":"SUBTOTAL(103,tblOctober[27])","v":0},{"$f":"SUBTOTAL(103,tblOctober[28])","v":0},{"$f":"SUBTOTAL(103,tblOctober[29])","v":0},null,null,{"$f":"SUBTOTAL(109,tblOctober[Total Days])","v":0}]
[]
[null,{"$f":"January!B12","v":"Color Key"},{"$nulls":4},{"$f":"KeyVacation","v":"V"},{"$f":"KeyVacationLabel","v":"Vacation"},null,null,{"$f":"KeyPersonal","v":"P"},{"$f":"KeyPersonalLabel","v":"Personal"},null,null,{"$f":"KeySick","v":"S"},{"$f":"KeySickLabel","v":"Sick"},null,null,{"$f":"KeyCustom1","v":0},{"$f":"KeyCustom1Label","v":"Custom 1"},null,null,{"$f":"KeyCustom2","v":0},{"$f":"KeyCustom2Label","v":"Custom 2"}]

{"sheet":"November","index":10,"n_rows":12,"n_cols":33,"rows_kept":12,"merged":[[1,0,2,0],[1,1,1,31],[1,32,2,32],[10,0,10,32]]}
["Employee Absence Schedule"]
["November","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2013}]
[null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,1),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,2),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,3),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,4),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,5),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,6),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,7),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,8),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,9),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,10),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,11),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,12),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,13),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,14),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,15),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,16),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,17),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,18),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,19),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,20),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,21),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,22),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,23),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,24),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,25),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,26),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,27),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,28),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,29),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,30),1),\"aaa\")","v":"Sat"}]
["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"," ","Total Days"]
["Employee 1",{"$nulls":31},{"$f":"COUNTA(tblNovember[[#This Row],[1]:[29]])","v":0}]
["Employee 2",{"$nulls":31},{"$f":"COUNTA(tblNovember[[#This Row],[1]:[29]])","v":0}]
["Employee 3",{"$nulls":31},{"$f":"COUNTA(tblNovember[[#This Row],[1]:[29]])","v":0}]
["Employee 4",{"$nulls":31},{"$f":"COUNTA(tblNovember[[#This Row],[1]:[29]])","v":0}]
["Employee 5",{"$nulls":31},{"$f":"COUNTA(tblNovember[[#This Row],[1]:[29]])","v":0}]
[{"$f":"MonthName&\" Total\"","v":"November Total"},{"$f":"SUBTOTAL(103,tblNovember[1])","v":0},{"$f":"SUBTOTAL(103,tblNovember[2])","v":0},{"$f":"SUBTOTAL(103,tblNovember[3])","v":0},{"$f":"SUBTOTAL(103,tblNovember[4])","v":0},{"$f":"SUBTOTAL(103,tblNovember[5])","v":0},{"$f":"SUBTOTAL(103,tblNovember[6])","v":0},{"$f":"SUBTOTAL(103,tblNovember[7])","v":0},{"$f":"SUBTOTAL(103,tblNovember[8])","v":0},{"$f":"SUBTOTAL(103,tblNovember[9])","v":0},{"$f":"SUBTOTAL(103,tblNovember[10])","v":0},{"$f":"SUBTOTAL(103,tblNovember[11])","v":0},{"$f":"SUBTOTAL(103,tblNovember[12])","v":0},{"$f":"SUBTOTAL(103,tblNovember[13])","v":0},{"$f":"SUBTOTAL(103,tblNovember[14])","v":0},{"$f":"SUBTOTAL(103,tblNovember[15])","v":0},{"$f":"SUBTOTAL(103,tblNovember[16])","v":0},{"$f":"SUBTOTAL(103,tblNovember[17])","v":0},{"$f":"SUBTOTAL(103,tblNovember[18])","v":0},{"$f":"SUBTOTAL(103,tblNovember[19])","v":0},{"$f":"SUBTOTAL(103,tblNovember[20])","v":0},{"$f":"SUBTOTAL(103,tblNovember[21])","v":0},{"$f":"SUBTOTAL(103,tblNovember[22])","v":0},{"$f":"SUBTOTAL(103,tblNovember[23])","v":0},{"$f":"SUBTOTAL(103,tblNovember[24])","v":0},{"$f":"SUBTOTAL(103,tblNovember[25])","v":0},{"$f":"SUBTOTAL(103,tblNovember[26])","v":0},{"$f":"SUBTOTAL(103,tblNovember[27])","v":0},{"$f":"SUBTOTAL(103,tblNovember[28])","v":0},{"$f":"SUBTOTAL(103,tblNovember[29])","v":0},null,null,{"$f":"SUBTOTAL(109,tblNovember[Total Days])","v":0}]
[]
[null,{"$f":"January!B12","v":"Color Key"},{"$nulls":4},{"$f":"KeyVacation","v":"V"},{"$f":"KeyVacationLabel","v":"Vacation"},null,null,{"$f":"KeyPersonal","v":"P"},{"$f":"KeyPersonalLabel","v":"Personal"},null,null,{"$f":"KeySick","v":"S"},{"$f":"KeySickLabel","v":"Sick"},null,null,{"$f":"KeyCustom1","v":0},{"$f":"KeyCustom1Label","v":"Custom 1"},null,null,{"$f":"KeyCustom2","v":0},{"$f":"KeyCustom2Label","v":"Custom 2"}]

{"sheet":"December","index":11,"n_rows":12,"n_cols":33,"rows_kept":12,"merged":[[1,0,2,0],[1,1,1,31],[1,32,2,32],[10,0,10,32]]}
["Employee Absence Schedule"]
["December","Dates of Absence",{"$nulls":30},{"$f":"CalendarYear","v":2013}]
[null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,1),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,2),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,3),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,4),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,5),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,6),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,7),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,8),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,9),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,10),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,11),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,12),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,13),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,14),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,15),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,16),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,17),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,18),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,19),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,20),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,21),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,22),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,23),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,24),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,25),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,26),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,27),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,28),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,29),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,30),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,31),1),\"aaa\")","v":"Tue"}]
["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"]
["Employee 1",{"$nulls":31},{"$f":"COUNTA(tblDecember[[#This Row],[1]:[29]])","v":0}]
["Employee 2",{"$nulls":31},{"$f":"COUNTA(tblDecember[[#This Row],[1]:[29]])","v":0}]
["Employee 3",{"$nulls":31},{"$f":"COUNTA(tblDecember[[#This Row],[1]:[29]])","v":0}]
["Employee 4",{"$nulls":31},{"$f":"COUNTA(tblDecember[[#This Row],[1]:[29]])","v":0}]
["Employee 5",{"$nulls":31},{"$f":"COUNTA(tblDecember[[#This Row],[1]:[29]])","v":0}]
[{"$f":"MonthName&\" Total\"","v":"December Total"},{"$f":"SUBTOTAL(103,tblDecember[1])","v":0},{"$f":"SUBTOTAL(103,tblDecember[2])","v":0},{"$f":"SUBTOTAL(103,tblDecember[3])","v":0},{"$f":"SUBTOTAL(103,tblDecember[4])","v":0},{"$f":"SUBTOTAL(103,tblDecember[5])","v":0},{"$f":"SUBTOTAL(103,tblDecember[6])","v":0},{"$f":"SUBTOTAL(103,tblDecember[7])","v":0},{"$f":"SUBTOTAL(103,tblDecember[8])","v":0},{"$f":"SUBTOTAL(103,tblDecember[9])","v":0},{"$f":"SUBTOTAL(103,tblDecember[10])","v":0},{"$f":"SUBTOTAL(103,tblDecember[11])","v":0},{"$f":"SUBTOTAL(103,tblDecember[12])","v":0},{"$f":"SUBTOTAL(103,tblDecember[13])","v":0},{"$f":"SUBTOTAL(103,tblDecember[14])","v":0},{"$f":"SUBTOTAL(103,tblDecember[15])","v":0},{"$f":"SUBTOTAL(103,tblDecember[16])","v":0},{"$f":"SUBTOTAL(103,tblDecember[17])","v":0},{"$f":"SUBTOTAL(103,tblDecember[18])","v":0},{"$f":"SUBTOTAL(103,tblDecember[19])","v":0},{"$f":"SUBTOTAL(103,tblDecember[20])","v":0},{"$f":"SUBTOTAL(103,tblDecember[21])","v":0},{"$f":"SUBTOTAL(103,tblDecember[22])","v":0},{"$f":"SUBTOTAL(103,tblDecember[23])","v":0},{"$f":"SUBTOTAL(103,tblDecember[24])","v":0},{"$f":"SUBTOTAL(103,tblDecember[25])","v":0},{"$f":"SUBTOTAL(103,tblDecember[26])","v":0},{"$f":"SUBTOTAL(103,tblDecember[27])","v":0},{"$f":"SUBTOTAL(103,tblDecember[28])","v":0},{"$f":"SUBTOTAL(103,tblDecember[29])","v":0},null,null,{"$f":"SUBTOTAL(109,tblDecember[Total Days])","v":0}]
[]
[null,{"$f":"January!B12","v":"Color Key"},{"$nulls":4},{"$f":"KeyVacation","v":"V"},{"$f":"KeyVacationLabel","v":"Vacation"},null,null,{"$f":"KeyPersonal","v":"P"},{"$f":"KeyPersonalLabel","v":"Personal"},null,null,{"$f":"KeySick","v":"S"},{"$f":"KeySickLabel","v":"Sick"},null,null,{"$f":"KeyCustom1","v":0},{"$f":"KeyCustom1Label","v":"Custom 1"},null,null,{"$f":"KeyCustom2","v":0},{"$f":"KeyCustom2Label","v":"Custom 2"}]