{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Представление календаря","Отсутствие сотрудников","Настройки"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Представление календаря","index":0,"n_rows":31,"n_cols":49,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,39,3,48],[4,39,5,48],[29,43,29,46],[30,43,30,46],[29,35,29,38],[30,35,30,38],[25,43,27,46],[25,35,27,38],[2,30,3,38],[4,30,5,38],[23,43,23,46],[23,34,23,39],[29,3,29,6],[30,3,30,6],[29,27,29,30],[30,27,30,30],[29,19,29,22],[30,19,30,22],[29,11,29,14],[30,11,30,14],[25,11,27,14],[25,3,27,6],[25,27,27,30],[25,19,27,22],[23,26,23,31],[23,19,23,22],[1,1,6,28],[18,2,18,6],[19,2,19,6],[23,3,23,6],[23,11,23,14],[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]]}
[]
[null,"ТАБЕЛЬ ПРИСУТСТВИЯ СОТРУДНИКОВ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Выберите сотрудника:",null,null,null,null,null,null,null,null,"Сотрудник 1"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Выберите год:",null,null,null,null,null,null,null,null,2012]
[]
[]
[null,null,null,null,null,null,null,"ВС","ПН","ВТ","СР","ЧТ","ПТ","СБ","ВС","ПН","ВТ","СР","ЧТ","ПТ","СБ","ВС","ПН","ВТ","СР","ЧТ","ПТ","СБ","ВС","ПН","ВТ","СР","ЧТ","ПТ","СБ","ВС","ПН","ВТ","СР","ЧТ","ПТ","СБ","ВС","ПН","ВТ","СР","ЧТ","ПТ","СБ"]
[null,null,{"$f":"DATE($AN$5,ROWS($C$9:C9),1)","v":"2012-01-01"},null,null,null,null,{"$f":"Календарь","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"},null,null,null,null,{"$f":"Календарь","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"},null,null,null,null,{"$f":"Календарь","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"},null,null,null,null,{"$f":"Календарь","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"},null,null,null,null,{"$f":"Календарь","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"},null,null,null,null,{"$f":"Календарь","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"},null,null,null,null,{"$f":"Календарь","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"},null,null,null,null,{"$f":"Календарь","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"},null,null,null,null,{"$f":"Календарь","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"},null,null,null,null,{"$f":"Календарь","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"},null,null,null,null,{"$f":"Календарь","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"},null,null,null,null,{"$f":"Календарь","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,"ОСНОВНАЯ СТАТИСТИКА"]
[]
[null,null,null,"Дней отсутствия",null,null,null,null,null,null,null,"Рабочих дней",null,null,null,null,null,null,null,"Больничный",null,null,null,null,null,null,"Отпуск",null,null,null,null,null,null,null,"Сем. Обстоятельства",null,null,null,null,null,null,null,null,"Другое"]
[]
[null,null,null,{"$f":"SUMIFS(tblОтсутствие[Дней],tblОтсутствие[Имя сотрудника],valSelСотрудник,tblОтсутствие[Начальная дата],\">=\"&DATE($AN$5,1,1),tblОтсутствие[Конечная дата],\"<\"&DATE($AN$5+1,1,1))","v":4},null,null,null,null,null,null,null,{"$f":"NETWORKDAYS(DATE($AN$5,1,1),EDATE(DATE($AN$5,1,1),12)-1)","v":261},null,null,null,null,null,null,null,{"$f":"SUMIFS(tblОтсутствие[Дней],tblОтсутствие[Имя сотрудника],valSelСотрудник,tblОтсутствие[Начальная дата],\">=\"&DATE($AN$5,1,1),tblОтсутствие[Конечная дата],\"<\"&DATE($AN$5+1,1,1),tblОтсутствие[Причина отсутствия],Настройки!$D$4)","v":1},null,null,null,null,null,null,null,{"$f":"SUMIFS(tblОтсутствие[Дней],tblОтсутствие[Имя сотрудника],valSelСотрудник,tblОтсутствие[Начальная дата],\">=\"&DATE($AN$5,1,1),tblОтсутствие[Конечная дата],\"<\"&DATE($AN$5+1,1,1),tblОтсутствие[Причина отсутствия],Настройки!$D$5)","v":0},null,null,null,null,null,null,null,{"$f":"SUMIFS(tblОтсутствие[Дней],tblОтсутствие[Имя сотрудника],valSelСотрудник,tblОтсутствие[Начальная дата],\">=\"&DATE($AN$5,1,1),tblОтсутствие[Конечная дата],\"<\"&DATE($AN$5+1,1,1),tblОтсутствие[Причина отсутствия],Настройки!$D$6)","v":3},null,null,null,null,null,null,null,{"$f":"SUMIFS(tblОтсутствие[Дней],tblОтсутствие[Имя сотрудника],valSelСотрудник,tblОтсутствие[Начальная дата],\">=\"&DATE($AN$5,1,1),tblОтсутствие[Конечная дата],\"<\"&DATE($AN$5+1,1,1),tblОтсутствие[Причина отсутствия],Настройки!$D$7)","v":0}]
[]
[]
[]
[null,null,null,{"$f":"SUMIFS(tblОтсутствие[Дней],tblОтсутствие[Имя сотрудника],valSelСотрудник,tblОтсутствие[Начальная дата],\">=\"&DATE($AN$5-1,1,1),tblОтсутствие[Конечная дата],\"<\"&DATE($AN$5,1,1))","v":14},null,null,null,null,null,null,null,{"$f":"NETWORKDAYS(DATE($AN$5-1,1,1),EDATE(DATE($AN$5-1,1,1),12)-1)","v":260},null,null,null,null,null,null,null,{"$f":"SUMIFS(tblОтсутствие[Дней],tblОтсутствие[Имя сотрудника],valSelСотрудник,tblОтсутствие[Начальная дата],\">=\"&DATE($AN$5-1,1,1),tblОтсутствие[Конечная дата],\"<\"&DATE($AN$5,1,1),tblОтсутствие[Причина отсутствия],Настройки!$D$4)","v":4},null,null,null,null,null,null,null,{"$f":"SUMIFS(tblОтсутствие[Дней],tblОтсутствие[Имя сотрудника],valSelСотрудник,tblОтсутствие[Начальная дата],\">=\"&DATE($AN$5-1,1,1),tblОтсутствие[Конечная дата],\"<\"&DATE($AN$5,1,1),tblОтсутствие[Причина отсутствия],Настройки!$D$5)","v":8},null,null,null,null,null,null,null,{"$f":"SUMIFS(tblОтсутствие[Дней],tblОтсутствие[Имя сотрудника],valSelСотрудник,tblОтсутствие[Начальная дата],\">=\"&DATE($AN$5-1,1,1),tblОтсутствие[Конечная дата],\"<\"&DATE($AN$5,1,1),tblОтсутствие[Причина отсутствия],Настройки!$D$6)","v":0},null,null,null,null,null,null,null,{"$f":"SUMIFS(tblОтсутствие[Дней],tblОтсутствие[Имя сотрудника],valSelСотрудник,tblОтсутствие[Начальная дата],\">=\"&DATE($AN$5-1,1,1),tblОтсутствие[Конечная дата],\"<\"&DATE($AN$5,1,1),tblОтсутствие[Причина отсутствия],Настройки!$D$7)","v":2}]
[null,null,null,{"$f":"IFERROR(IF(D26>D30,\"БОЛЬШЕ НА \", \"МЕНЬШЕ НА \")&TEXT(D26/D30-1,\"0%;0%\"),\"\")","v":"МЕНЬШЕ НА 71%"},null,null,null,null,null,null,null,{"$f":"IFERROR(IF(L26>L30,\"БОЛЬШЕ НА \", \"МЕНЬШЕ НА \")&TEXT(L26/L30-1,\"0%;0%\"),\"\")","v":"БОЛЬШЕ НА 0%"},null,null,null,null,null,null,null,{"$f":"IFERROR(IF(T26>T30,\"БОЛЬШЕ НА \", \"МЕНЬШЕ НА \")&TEXT(T26/T30-1,\"0%;0%\"),\"\")","v":"МЕНЬШЕ НА 75%"},null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AB26>AB30,\"БОЛЬШЕ НА \", \"МЕНЬШЕ НА \")&TEXT(AB26/AB30-1,\"0%;0%\"),\"\")","v":"МЕНЬШЕ НА 100%"},null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AJ26>AJ30,\"БОЛЬШЕ НА \", \"МЕНЬШЕ НА \")&TEXT(AJ26/AJ30-1,\"0%;0%\"),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AR26>AR30,\"БОЛЬШЕ НА \", \"МЕНЬШЕ НА \")&TEXT(AR26/AR30-1,\"0%;0%\"),\"\")","v":"МЕНЬШЕ НА 100%"}]

{"sheet":"Отсутствие сотрудников","index":1,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Имя сотрудника","Начальная дата","Конечная дата","Причина отсутствия","Дней"]
[null,"Сотрудник 1","2012-01-03","2012-01-03","Больничный",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":1}]
[null,"Сотрудник 2","2012-01-17","2012-01-18","Прочее",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":2}]
[null,"Сотрудник 3","2012-01-18","2012-01-21","Прочее",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":3}]
[null,"Сотрудник 5","2011-12-10","2011-12-16","Семейные обстоятельства",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":5}]
[null,"Сотрудник 4","2011-12-01","2011-12-02","Больничный",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":2}]
[null,"Сотрудник 1","2011-11-14","2011-11-18","Отпуск",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":5}]
[null,"Сотрудник 4","2012-01-31","2012-02-04","Больничный",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":4}]
[null,"Сотрудник 4","2011-12-01","2011-12-06","Прочее",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":4}]
[null,"Сотрудник 4","2011-12-10","2011-12-16","Прочее",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":5}]
[null,"Сотрудник 2","2012-01-13","2012-01-15","Больничный",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":1}]
[null,"Сотрудник 5","2012-01-15","2012-01-20","Больничный",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":5}]
[null,"Сотрудник 2","2012-06-13","2012-06-15","Семейные обстоятельства",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":3}]
[null,"Сотрудник 5","2012-01-27","2012-02-03","Семейные обстоятельства",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":6}]
[null,"Сотрудник 3","2012-01-17","2012-01-18","Отпуск",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":2}]
[null,"Сотрудник 3","2011-12-12","2011-12-17","Семейные обстоятельства",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":5}]
[null,"Сотрудник 1","2011-12-21","2011-12-22","Прочее",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":2}]
[null,"Сотрудник 1","2011-12-14","2011-12-16","Отпуск",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":3}]
[null,"Сотрудник 2","2011-11-29","2011-12-06","Семейные обстоятельства",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":6}]
[null,"Сотрудник 5","2011-12-03","2011-12-07","Отпуск",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":3}]
[null,"Сотрудник 1","2012-01-31","2012-02-02","Семейные обстоятельства",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":3}]
[null,"Сотрудник 1","2011-11-24","2011-11-29","Больничный",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":4}]
[null,"Сотрудник 2","2012-12-05","2012-12-09","Отпуск",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":3}]
[null,"Сотрудник 5","2012-04-11","2012-04-19","Отпуск",{"$f":"NETWORKDAYS(tblОтсутствие[[#This Row],[Начальная дата]],tblОтсутствие[[#This Row],[Конечная дата]],lstПраздники)","v":7}]

{"sheet":"Настройки","index":2,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Список сотрудников",null,"Причина отсутствия",null,"Выходные","Описание"]
[null,"Сотрудник 1",null,"Больничный",null,"2013-01-01","Новый год."]
[null,"Сотрудник 2",null,"Отпуск",null,"2013-01-07","Рождество Христово."]
[null,"Сотрудник 3",null,"Семейные обстоятельства",null,"2013-01-14","Старый Новый год."]
[null,"Сотрудник 4",null,"Прочее",null,"2013-02-02","День воинской славы России — День победы в Сталинградской битве в 1943 году."]
[null,"Сотрудник 5",null,null,null,"2013-02-14","День Святого Валентина."]
[null,null,null,null,null,"2013-02-23","День воинской славы России — День защитника Отечества."]
[null,null,null,null,null,"2013-03-08","Международный женский день"]
[null,null,null,null,null,"2013-03-17","Прощеное воскресенье."]
[null,null,null,null,null,"2013-03-19","День моряка-подводника."]
[null,null,null,null,null,"2013-05-01","Праздник весны и труда."]
[null,null,null,null,null,"2013-05-05","Пасха."]
[null,null,null,null,null,"2013-05-09","День Победы."]
[null,null,null,null,null,"2013-06-12","День России."]
[null,null,null,null,null,"2013-06-22","День памяти и скорби."]
[null,null,null,null,null,"2013-07-10","День воинской славы России — Полтавская битва (1709)."]
[null,null,null,null,null,"2013-10-05","День учителя."]
[null,null,null,null,null,"2013-11-04","День народного единства."]
[null,null,null,null,null,"2013-11-10","День российской милиции."]
[null,null,null,null,null,"2013-11-11","День памяти (окончание Первой мировой войны)."]
[null,null,null,null,null,"2013-12-12","День Конституции Российской Федерации."]
[null,null,null,null,null,"2013-12-15","День памяти журналистов, погибших при исполнении профессиональных обязанностей."]
[null,null,null,null,null,"2013-12-24","День воинской славы России — День взятия турецкой крепости Измаил."]