{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Calendar View","Employee Leave Tracker","Settings"],"not_rendered":{"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Calendar View","index":0,"n_rows":31,"n_cols":49,"rows_kept":31,"merged":[[1,1,6,28],[2,30,3,38],[2,39,3,48],[4,30,5,38],[4,39,5,48],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[14,2,14,6],[15,2,15,6],[16,2,16,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[23,3,23,6],[23,11,23,14],[23,19,23,22],[23,26,23,31],[23,34,23,39],[23,43,23,46],[25,3,27,6],[25,11,27,14],[25,19,27,22],[25,27,27,30],[25,35,27,38],[25,43,27,46],[29,3,29,6],[29,11,29,14],[29,19,29,22],[29,27,29,30],[29,35,29,38],[29,43,29,46],[30,3,30,6],[30,11,30,14],[30,19,30,22],[30,27,30,30],[30,35,30,38],[30,43,30,46]]}
[]
[null,"EMPLOYEE ATTENDANCE RECORD"]
[{"$nulls":30},"Select an Employee:",{"$nulls":8},"Employee 1"]
[]
[{"$nulls":30},"Select a Year:",{"$nulls":8},2012]
[]
[]
[{"$nulls":7},"S","M","T","W","T","F","S","S","M","T","W","T","F","S","S","M","T","W","T","F","S","S","M","T","W","T","F","S","S","M","T","W","T","F","S","S","M","T","W","T","F","S"]
[null,null,{"$f":"DATE($AN$5,ROWS($C$9:C9),1)","v":"2012-01-01"},{"$nulls":4},{"$f":"calendar","v":"2011-12-25"},"2011-12-26","2011-12-27","2011-12-28","2011-12-29","2011-12-30","2011-12-31","2012-01-01","2012-01-02","2012-01-03","2012-01-04","2012-01-05","2012-01-06","2012-01-07","2012-01-08","2012-01-09","2012-01-10","2012-01-11","2012-01-12","2012-01-13","2012-01-14","2012-01-15","2012-01-16","2012-01-17","2012-01-18","2012-01-19","2012-01-20","2012-01-21","2012-01-22","2012-01-23","2012-01-24","2012-01-25","2012-01-26","2012-01-27","2012-01-28","2012-01-29","2012-01-30","2012-01-31","2012-02-01","2012-02-02","2012-02-03","2012-02-04"]
[null,null,{"$f":"DATE($AN$5,ROWS($C$9:C10),1)","v":"2012-02-01"},{"$nulls":4},{"$f":"calendar","v":"2012-01-29"},"2012-01-30","2012-01-31","2012-02-01","2012-02-02","2012-02-03","2012-02-04","2012-02-05","2012-02-06","2012-02-07","2012-02-08","2012-02-09","2012-02-10","2012-02-11","2012-02-12","2012-02-13","2012-02-14","2012-02-15","2012-02-16","2012-02-17","2012-02-18","2012-02-19","2012-02-20","2012-02-21","2012-02-22","2012-02-23","2012-02-24","2012-02-25","2012-02-26","2012-02-27","2012-02-28","2012-02-29","2012-03-01","2012-03-02","2012-03-03","2012-03-04","2012-03-05","2012-03-06","2012-03-07","2012-03-08","2012-03-09","2012-03-10"]
[null,null,{"$f":"DATE($AN$5,ROWS($C$9:C11),1)","v":"2012-03-01"},{"$nulls":4},{"$f":"calendar","v":"2012-02-26"},"2012-02-27","2012-02-28","2012-02-29","2012-03-01","2012-03-02","2012-03-03","2012-03-04","2012-03-05","2012-03-06","2012-03-07","2012-03-08","2012-03-09","2012-03-10","2012-03-11","2012-03-12","2012-03-13","2012-03-14","2012-03-15","2012-03-16","2012-03-17","2012-03-18","2012-03-19","2012-03-20","2012-03-21","2012-03-22","2012-03-23","2012-03-24","2012-03-25","2012-03-26","2012-03-27","2012-03-28","2012-03-29","2012-03-30","2012-03-31","2012-04-01","2012-04-02","2012-04-03","2012-04-04","2012-04-05","2012-04-06","2012-04-07"]
[null,null,{"$f":"DATE($AN$5,ROWS($C$9:C12),1)","v":"2012-04-01"},{"$nulls":4},{"$f":"calendar","v":"2012-03-25"},"2012-03-26","2012-03-27","2012-03-28","2012-03-29","2012-03-30","2012-03-31","2012-04-01","2012-04-02","2012-04-03","2012-04-04","2012-04-05","2012-04-06","2012-04-07","2012-04-08","2012-04-09","2012-04-10","2012-04-11","2012-04-12","2012-04-13","2012-04-14","2012-04-15","2012-04-16","2012-04-17","2012-04-18","2012-04-19","2012-04-20","2012-04-21","2012-04-22","2012-04-23","2012-04-24","2012-04-25","2012-04-26","2012-04-27","2012-04-28","2012-04-29","2012-04-30","2012-05-01","2012-05-02","2012-05-03","2012-05-04","2012-05-05"]
[null,null,{"$f":"DATE($AN$5,ROWS($C$9:C13),1)","v":"2012-05-01"},{"$nulls":4},{"$f":"calendar","v":"2012-04-29"},"2012-04-30","2012-05-01","2012-05-02","2012-05-03","2012-05-04","2012-05-05","2012-05-06","2012-05-07","2012-05-08","2012-05-09","2012-05-10","2012-05-11","2012-05-12","2012-05-13","2012-05-14","2012-05-15","2012-05-16","2012-05-17","2012-05-18","2012-05-19","2012-05-20","2012-05-21","2012-05-22","2012-05-23","2012-05-24","2012-05-25","2012-05-26","2012-05-27","2012-05-28","2012-05-29","2012-05-30","2012-05-31","2012-06-01","2012-06-02","2012-06-03","2012-06-04","2012-06-05","2012-06-06","2012-06-07","2012-06-08","2012-06-09"]
[null,null,{"$f":"DATE($AN$5,ROWS($C$9:C14),1)","v":"2012-06-01"},{"$nulls":4},{"$f":"calendar","v":"2012-05-27"},"2012-05-28","2012-05-29","2012-05-30","2012-05-31","2012-06-01","2012-06-02","2012-06-03","2012-06-04","2012-06-05","2012-06-06","2012-06-07","2012-06-08","2012-06-09","2012-06-10","2012-06-11","2012-06-12","2012-06-13","2012-06-14","2012-06-15","2012-06-16","2012-06-17","2012-06-18","2012-06-19","2012-06-20","2012-06-21","2012-06-22","2012-06-23","2012-06-24","2012-06-25","2012-06-26","2012-06-27","2012-06-28","2012-06-29","2012-06-30","2012-07-01","2012-07-02","2012-07-03","2012-07-04","2012-07-05","2012-07-06","2012-07-07"]
[null,null,{"$f":"DATE($AN$5,ROWS($C$9:C15),1)","v":"2012-07-01"},{"$nulls":4},{"$f":"calendar","v":"2012-06-24"},"2012-06-25","2012-06-26","2012-06-27","2012-06-28","2012-06-29","2012-06-30","2012-07-01","2012-07-02","2012-07-03","2012-07-04","2012-07-05","2012-07-06","2012-07-07","2012-07-08","2012-07-09","2012-07-10","2012-07-11","2012-07-12","2012-07-13","2012-07-14","2012-07-15","2012-07-16","2012-07-17","2012-07-18","2012-07-19","2012-07-20","2012-07-21","2012-07-22","2012-07-23","2012-07-24","2012-07-25","2012-07-26","2012-07-27","2012-07-28","2012-07-29","2012-07-30","2012-07-31","2012-08-01","2012-08-02","2012-08-03","2012-08-04"]
[null,null,{"$f":"DATE($AN$5,ROWS($C$9:C16),1)","v":"2012-08-01"},{"$nulls":4},{"$f":"calendar","v":"2012-07-29"},"2012-07-30","2012-07-31","2012-08-01","2012-08-02","2012-08-03","2012-08-04","2012-08-05","2012-08-06","2012-08-07","2012-08-08","2012-08-09","2012-08-10","2012-08-11","2012-08-12","2012-08-13","2012-08-14","2012-08-15","2012-08-16","2012-08-17","2012-08-18","2012-08-19","2012-08-20","2012-08-21","2012-08-22","2012-08-23","2012-08-24","2012-08-25","2012-08-26","2012-08-27","2012-08-28","2012-08-29","2012-08-30","2012-08-31","2012-09-01","2012-09-02","2012-09-03","2012-09-04","2012-09-05","2012-09-06","2012-09-07","2012-09-08"]
[null,null,{"$f":"DATE($AN$5,ROWS($C$9:C17),1)","v":"2012-09-01"},{"$nulls":4},{"$f":"calendar","v":"2012-08-26"},"2012-08-27","2012-08-28","2012-08-29","2012-08-30","2012-08-31","2012-09-01","2012-09-02","2012-09-03","2012-09-04","2012-09-05","2012-09-06","2012-09-07","2012-09-08","2012-09-09","2012-09-10","2012-09-11","2012-09-12","2012-09-13","2012-09-14","2012-09-15","2012-09-16","2012-09-17","2012-09-18","2012-09-19","2012-09-20","2012-09-21","2012-09-22","2012-09-23","2012-09-24","2012-09-25","2012-09-26","2012-09-27","2012-09-28","2012-09-29","2012-09-30","2012-10-01","2012-10-02","2012-10-03","2012-10-04","2012-10-05","2012-10-06"]
[null,null,{"$f":"DATE($AN$5,ROWS($C$9:C18),1)","v":"2012-10-01"},{"$nulls":4},{"$f":"calendar","v":"2012-09-30"},"2012-10-01","2012-10-02","2012-10-03","2012-10-04","2012-10-05","2012-10-06","2012-10-07","2012-10-08","2012-10-09","2012-10-10","2012-10-11","2012-10-12","2012-10-13","2012-10-14","2012-10-15","2012-10-16","2012-10-17","2012-10-18","2012-10-19","2012-10-20","2012-10-21","2012-10-22","2012-10-23","2012-10-24","2012-10-25","2012-10-26","2012-10-27","2012-10-28","2012-10-29","2012-10-30","2012-10-31","2012-11-01","2012-11-02","2012-11-03","2012-11-04","2012-11-05","2012-11-06","2012-11-07","2012-11-08","2012-11-09","2012-11-10"]
[null,null,{"$f":"DATE($AN$5,ROWS($C$9:C19),1)","v":"2012-11-01"},{"$nulls":4},{"$f":"calendar","v":"2012-10-28"},"2012-10-29","2012-10-30","2012-10-31","2012-11-01","2012-11-02","2012-11-03","2012-11-04","2012-11-05","2012-11-06","2012-11-07","2012-11-08","2012-11-09","2012-11-10","2012-11-11","2012-11-12","2012-11-13","2012-11-14","2012-11-15","2012-11-16","2012-11-17","2012-11-18","2012-11-19","2012-11-20","2012-11-21","2012-11-22","2012-11-23","2012-11-24","2012-11-25","2012-11-26","2012-11-27","2012-11-28","2012-11-29","2012-11-30","2012-12-01","2012-12-02","2012-12-03","2012-12-04","2012-12-05","2012-12-06","2012-12-07","2012-12-08"]
[null,null,{"$f":"DATE($AN$5,ROWS($C$9:C20),1)","v":"2012-12-01"},{"$nulls":4},{"$f":"calendar","v":"2012-11-25"},"2012-11-26","2012-11-27","2012-11-28","2012-11-29","2012-11-30","2012-12-01","2012-12-02","2012-12-03","2012-12-04","2012-12-05","2012-12-06","2012-12-07","2012-12-08","2012-12-09","2012-12-10","2012-12-11","2012-12-12","2012-12-13","2012-12-14","2012-12-15","2012-12-16","2012-12-17","2012-12-18","2012-12-19","2012-12-20","2012-12-21","2012-12-22","2012-12-23","2012-12-24","2012-12-25","2012-12-26","2012-12-27","2012-12-28","2012-12-29","2012-12-30","2012-12-31","2013-01-01","2013-01-02","2013-01-03","2013-01-04","2013-01-05"]
[]
[null,null,"KEY STATISTICS"]
[]
[{"$nulls":3},"Days on Leave",{"$nulls":7},"Working Days",{"$nulls":7},"# of Days Sick",{"$nulls":6},"on Vacation",{"$nulls":7},"on Bereavement",{"$nulls":8},"on Other"]
[]
[{"$nulls":3},{"$f":"SUMIFS(tblLeave[Days],tblLeave[Employee Name],valSelEmployee,tblLeave[Start Date],\">=\"&DATE($AN$5,1,1),tblLeave[End Date],\"<\"&DATE($AN$5+1,1,1))","v":4},{"$nulls":7},{"$f":"NETWORKDAYS(DATE($AN$5,1,1),EDATE(DATE($AN$5,1,1),12)-1)","v":261},{"$nulls":7},{"$f":"SUMIFS(tblLeave[Days],tblLeave[Employee Name],valSelEmployee,tblLeave[Start Date],\">=\"&DATE($AN$5,1,1),tblLeave[End Date],\"<\"&DATE($AN$5+1,1,1),tblLeave[Type of Leave],Settings!$D$4)","v":1},{"$nulls":7},{"$f":"SUMIFS(tblLeave[Days],tblLeave[Employee Name],valSelEmployee,tblLeave[Start Date],\">=\"&DATE($AN$5,1,1),tblLeave[End Date],\"<\"&DATE($AN$5+1,1,1),tblLeave[Type of Leave],Settings!$D$5)","v":0},{"$nulls":7},{"$f":"SUMIFS(tblLeave[Days],tblLeave[Employee Name],valSelEmployee,tblLeave[Start Date],\">=\"&DATE($AN$5,1,1),tblLeave[End Date],\"<\"&DATE($AN$5+1,1,1),tblLeave[Type of Leave],Settings!$D$6)","v":3},{"$nulls":7},{"$f":"SUMIFS(tblLeave[Days],tblLeave[Employee Name],valSelEmployee,tblLeave[Start Date],\">=\"&DATE($AN$5,1,1),tblLeave[End Date],\"<\"&DATE($AN$5+1,1,1),tblLeave[Type of Leave],Settings!$D$7)","v":0}]
[]
[]
[]
[{"$nulls":3},{"$f":"SUMIFS(tblLeave[Days],tblLeave[Employee Name],valSelEmployee,tblLeave[Start Date],\">=\"&DATE($AN$5-1,1,1),tblLeave[End Date],\"<\"&DATE($AN$5,1,1))","v":14},{"$nulls":7},{"$f":"NETWORKDAYS(DATE($AN$5-1,1,1),EDATE(DATE($AN$5-1,1,1),12)-1)","v":260},{"$nulls":7},{"$f":"SUMIFS(tblLeave[Days],tblLeave[Employee Name],valSelEmployee,tblLeave[Start Date],\">=\"&DATE($AN$5-1,1,1),tblLeave[End Date],\"<\"&DATE($AN$5,1,1),tblLeave[Type of Leave],Settings!$D$4)","v":4},{"$nulls":7},{"$f":"SUMIFS(tblLeave[Days],tblLeave[Employee Name],valSelEmployee,tblLeave[Start Date],\">=\"&DATE($AN$5-1,1,1),tblLeave[End Date],\"<\"&DATE($AN$5,1,1),tblLeave[Type of Leave],Settings!$D$5)","v":8},{"$nulls":7},{"$f":"SUMIFS(tblLeave[Days],tblLeave[Employee Name],valSelEmployee,tblLeave[Start Date],\">=\"&DATE($AN$5-1,1,1),tblLeave[End Date],\"<\"&DATE($AN$5,1,1),tblLeave[Type of Leave],Settings!$D$6)","v":0},{"$nulls":7},{"$f":"SUMIFS(tblLeave[Days],tblLeave[Employee Name],valSelEmployee,tblLeave[Start Date],\">=\"&DATE($AN$5-1,1,1),tblLeave[End Date],\"<\"&DATE($AN$5,1,1),tblLeave[Type of Leave],Settings!$D$7)","v":2}]
[{"$nulls":3},{"$f":"IFERROR(IF(D26>D30,\"UP \", \"DOWN \")&TEXT(D26/D30-1,\"0%;0%\"),\"\")","v":"DOWN 71%"},{"$nulls":7},{"$f":"IFERROR(IF(L26>L30,\"UP \", \"DOWN \")&TEXT(L26/L30-1,\"0%;0%\"),\"\")","v":"UP 0%"},{"$nulls":7},{"$f":"IFERROR(IF(T26>T30,\"UP \", \"DOWN \")&TEXT(T26/T30-1,\"0%;0%\"),\"\")","v":"DOWN 75%"},{"$nulls":7},{"$f":"IFERROR(IF(AB26>AB30,\"UP \", \"DOWN \")&TEXT(AB26/AB30-1,\"0%;0%\"),\"\")","v":"DOWN 100%"},{"$nulls":7},{"$f":"IFERROR(IF(AJ26>AJ30,\"UP \", \"DOWN \")&TEXT(AJ26/AJ30-1,\"0%;0%\"),\"\")","v":""},{"$nulls":7},{"$f":"IFERROR(IF(AR26>AR30,\"UP \", \"DOWN \")&TEXT(AR26/AR30-1,\"0%;0%\"),\"\")","v":"DOWN 100%"}]

{"sheet":"Employee Leave Tracker","index":1,"n_rows":26,"n_cols":6,"rows_kept":26}
[]
[]
[null,"Employee Name","Start Date","End Date","Type of Leave","Days"]
[null,"Employee 1","2012-01-03","2012-01-03","Sick Leave",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":1}]
[null,"Employee 2","2012-01-17","2012-01-18","Other",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":2}]
[null,"Employee 3","2012-01-18","2012-01-21","Other",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":3}]
[null,"Employee 5","2011-12-10","2011-12-16","Bereavement",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":5}]
[null,"Employee 4","2011-12-01","2011-12-02","Sick Leave",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":2}]
[null,"Employee 1","2011-11-14","2011-11-18","Vacation",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":5}]
[null,"Employee 4","2012-01-31","2012-02-04","Sick Leave",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":4}]
[null,"Employee 4","2011-12-01","2011-12-06","Other",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":4}]
[null,"Employee 4","2011-12-10","2011-12-16","Other",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":5}]
[null,"Employee 2","2012-01-13","2012-01-15","Sick Leave",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":1}]
[null,"Employee 5","2012-01-15","2012-01-20","Sick Leave",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":5}]
[null,"Employee 2","2012-06-13","2012-06-15","Bereavement",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":3}]
[null,"Employee 5","2012-01-27","2012-02-03","Bereavement",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":6}]
[null,"Employee 3","2012-01-17","2012-01-18","Vacation",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":2}]
[null,"Employee 3","2011-12-12","2011-12-17","Bereavement",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":5}]
[null,"Employee 1","2011-12-21","2011-12-22","Other",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":2}]
[null,"Employee 1","2011-12-14","2011-12-16","Vacation",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":3}]
[null,"Employee 2","2011-11-29","2011-12-06","Bereavement",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":6}]
[null,"Employee 5","2011-12-03","2011-12-07","Vacation",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":3}]
[null,"Employee 1","2012-01-31","2012-02-02","Bereavement",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":3}]
[null,"Employee 1","2011-11-24","2011-11-29","Sick Leave",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":4}]
[null,"Employee 2","2012-12-05","2012-12-09","Vacation",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":3}]
[null,"Employee 5","2012-04-11","2012-04-19","Vacation",{"$f":"NETWORKDAYS(tblLeave[[#This Row],[Start Date]],tblLeave[[#This Row],[End Date]],lstHolidays)","v":7}]

{"sheet":"Settings","index":2,"n_rows":10,"n_cols":7,"rows_kept":10}
[]
[]
[null,"List of Employees",null,"Type of Leave",null,"Company Holidays","Description"]
[null,"Employee 1",null,"Sick Leave",null,"2012-01-01","New Year's Day"]
[null,"Employee 2",null,"Vacation",null,"2012-07-04","Independence Day"]
[null,"Employee 3",null,"Bereavement",null,"2012-11-24","Thanksgiving"]
[null,"Employee 4",null,"Other",null,"2012-11-25","Thanksgiving"]
[null,"Employee 5",{"$nulls":3},"2012-12-24","Christmas"]
[{"$nulls":5},"2012-12-26","Christmas"]
[{"$nulls":5},"2012-12-31","New Year's Eve"]