{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["График отпусков"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":11,"comments":1,"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":21,"n_cols":30,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,2,1],[1,2,2,2]]}
[null,2017]
[null,"Должность","Ф.И.О.","Отпуск по плану (I часть)",null,null,null,null,null,"Отпуск по плану (II часть)",null,null,null,null,null,"Отпуск по плану (III часть)",null,null,null,null,null,"Отпуск по плану (IV часть)",null,null,null,null,null,null,"Праздники"]
[null,null,null,"Дней отп.","Начало","Окончание","Всего дней","Рабочих дней",{"$f":"D_2&2","v":"Начало2"},"Дней отп.","Начало","Окончание","Всего дней","Рабочих дней",{"$f":"D_3&3","v":"Начало3"},"Дней отп.","Начало","Окончание","Всего дней","Рабочих дней",null,"Дней отп.","Начало","Окончание","Всего дней","Рабочих дней",null,null,"2017-01-01","2017-02-23"]
[1,"Директор","Лобода А.В.",12,"2017-03-06",{"$f":"ОТПУСК(E4,D4,Праздники)","v":"2017-03-18"},12,{"$f":"IF(F4,NETWORKDAYS(E4,F4,Праздники),)","v":{"$error":"#NAME?"}},{"$f":"MAX(K4-F4-1,0)","v":113},15,"2017-07-10",{"$f":"ОТПУСК(K4,J4,Праздники)","v":"2017-07-24"},{"$f":"IF(L4,L4-K4+1,)","v":15},{"$f":"IF(L4,NETWORKDAYS(K4,L4,Праздники),)","v":{"$error":"#NAME?"}},{"$f":"MAX(Q4-L4-1,0)","v":90},9,"2017-10-23",{"$f":"ОТПУСК(Q4,P4,Праздники)","v":"2017-10-31"},{"$f":"IF(R4,R4-Q4+1,)","v":9},{"$f":"IF(R4,NETWORKDAYS(Q4,R4,Праздники),)","v":{"$error":"#NAME?"}},{"$f":"MAX(W4-R4-1,0)","v":40},5,"2017-12-11",{"$f":"ОТПУСК(W4,V4,Праздники)","v":"2017-12-15"},{"$f":"IF(X4,X4-W4+1,)","v":5},{"$f":"IF(X4,NETWORKDAYS(W4,X4,Праздники),)","v":{"$error":"#NAME?"}},null,null,"2017-01-02","2017-03-08"]
[2,"ЗДГИ","Татаринков А.В.",14,"2017-04-12","2017-04-25",14,{"$error":"#NAME?"},{"$f":"MAX(K5-F5-1,0)","v":110},18,"2017-08-14","2017-08-31",{"$f":"IF(L5,L5-K5+1,)","v":18},{"$error":"#NAME?"},{"$f":"MAX(Q5-L5-1,0)","v":41},9,"2017-10-12","2017-10-20",9,{"$error":"#NAME?"},{"$f":"MAX(W5-R5-1,0)","v":0},0,"00:00:00","00:00:00",{"$f":"IF(X5,X5-W5+1,)","v":0},0,null,null,"2017-01-03","2017-05-01"]
[3,"ЗГИ","Федерко С.А.",18,"2017-06-01","2017-06-19",{"$f":"IF(F6,F6-E6+1,)","v":19},{"$error":"#NAME?"},76,12,"2017-09-04","2017-09-15",12,{"$error":"#NAME?"},44,10,"2017-10-30","2017-11-09",11,{"$error":"#NAME?"},0,0,"00:00:00","00:00:00",0,0,null,null,"2017-01-04"]
[4,"ЗГИ","Львов А.П.",14,"2017-02-01","2017-02-14",14,{"$error":"#NAME?"},161,18,"2017-07-26","2017-08-12",18,{"$error":"#NAME?"},92,8,"2017-11-13","2017-11-20",8,{"$error":"#NAME?"},0,0,"00:00:00","00:00:00",0,0,null,null,"2017-01-05","2017-05-09"]
[5,"ОУПА","Полковников К.В.",14,"2017-02-24","2017-03-10",15,{"$error":"#NAME?"},52,4,"2017-05-02","2017-05-05",4,{"$error":"#NAME?"},51,5,"2017-06-26","2017-06-30",5,{"$error":"#NAME?"},51,12,"2017-08-21","2017-09-01",12,{"$error":"#NAME?"},null,null,"2017-01-06","2017-06-12"]
[6,"ГЭПС","Кладков А.В.",0,"00:00:00","00:00:00",0,0,0,0,"00:00:00","00:00:00",0,0,1,0,"1900-01-02","00:00:00",0,0,0,0,"00:00:00","00:00:00",0,0,null,null,"2017-01-07","2017-11-04"]
[7,"ОЭЛЭП","Павлюк Е.В.",0,"00:00:00","00:00:00",0,0,0,0,"00:00:00","00:00:00",0,0,2,0,"1900-01-03","00:00:00",0,0,0,0,"00:00:00","00:00:00",0,0,null,null,"2017-01-08"]
[8,"ООТиН","Цепаев Э.В.",0,"00:00:00","00:00:00",{"$f":"IF(F11,F11-E11+1,)","v":0},0,0,0,"00:00:00","00:00:00",0,0,3,0,"1900-01-04","00:00:00",0,0,0,0,"00:00:00","00:00:00",0,0]
[9,"СРЗА","Терещенков А.М.",0,"00:00:00","00:00:00",{"$f":"IF(F12,F12-E12+1,)","v":0},0,0,0,"00:00:00","00:00:00",0,0,4,0,"1900-01-05",{"$f":"ОТПУСК(Q12,P12,Праздники)","v":"00:00:00"},0,0,0,0,"00:00:00","00:00:00",0,0]
[10,"ООТЭ","Бурдастов А.Л.",0,"00:00:00","00:00:00",{"$f":"IF(F13,F13-E13+1,)","v":0},0,0,0,"00:00:00","00:00:00",0,0,5,0,"1900-01-06","00:00:00",0,0,0,0,"00:00:00","00:00:00",0,0]
[11,"ГД","Левченко А.А.",0,"00:00:00","00:00:00",{"$f":"IF(F14,F14-E14+1,)","v":0},0,0,0,"00:00:00",{"$f":"ОТПУСК(K14,J14,Праздники)","v":"00:00:00"},{"$f":"IF(L14,L14-K14+1,)","v":0},0,6,0,"1900-01-07","00:00:00",0,0,0,0,"00:00:00","00:00:00",0,0]
[12,"ОФБРПиУЭ","Татаринкова Г.В.",null,null,null,null,null,0,null,null,null,null,null,7,0,"1900-01-08","00:00:00",0,0,0,0,"00:00:00","00:00:00",0,0]
[13,"СИСиСС","Кисюк А.А.",null,null,null,null,null,0,null,null,null,null,null,8,0,"1900-01-09","00:00:00",0,0,0,0,"00:00:00","00:00:00",0,0]
[14,"СИСиСС","Заместитель",null,null,null,null,null,0,null,null,null,null,null,9,0,"1900-01-10","00:00:00",0,0,0,0,"00:00:00","00:00:00",0,0]
[15,"ЦУС","Сахарюк А.П.",null,null,null,null,null,0,null,null,null,null,null,10,0,"1900-01-11","00:00:00",0,0,0,0,"00:00:00","00:00:00",0,0]
[16,"ЦУС-ООР","Скоморохин С.В.",null,null,null,null,null,0,null,null,null,null,null,11,0,"1900-01-12","00:00:00",0,0,0,0,"00:00:00","00:00:00",0,0]
[17,"ГУИД","Нечаев К.С.",null,null,null,null,null,0,null,null,null,null,null,12,0,"1900-01-13","00:00:00",0,0,0,0,"00:00:00","00:00:00",0,0]
[18,"ОМО","Смирнов А.С.",0,"00:00:00",{"$f":"ОТПУСК(E21,D21,Праздники)","v":"00:00:00"},{"$f":"IF(F21,F21-E21+1,)","v":0},{"$f":"IF(F21,NETWORKDAYS(E21,F21,Праздники),)","v":0},0,0,"00:00:00",{"$f":"ОТПУСК(K21,J21,Праздники)","v":"00:00:00"},0,{"$f":"IF(L21,NETWORKDAYS(K21,L21,Праздники),)","v":0},13,0,"1900-01-14","00:00:00",0,0,0,0,"00:00:00","00:00:00",0,0]