{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["График отпусков"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":12,"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":15,"n_cols":23,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,2,1],[1,2,2,2]]}
[null,2015]
[null,"Должность","Ф.И.О.","Отпуск по плану (I часть)",null,null,null,null,null,"Отпуск по плану (II часть)",null,null,null,null,null,"Отпуск по плану (III часть)",null,null,null,null,null,"Праздники"]
[null,null,null,"Дней отп.","Начало","Окончание","Всего дней","Рабочих дней",{"$f":"D_2&2","v":"Начало2"},"Дней отп.","Начало","Окончание","Всего дней","Рабочих дней",{"$f":"D_3&3","v":"Начало3"},"Дней отп.","Начало","Окончание","Всего дней","Рабочих дней",null,"2015-01-01","2015-02-23"]
[1,"Мастер","Иванов",14,"2015-04-17",{"$f":"ОТПУСК(E4,D4,Праздники)","v":"2015-04-30"},{"$f":"IF(F4,F4-E4+1,)","v":14},{"$f":"IF(F4,NETWORKDAYS(E4,F4,Праздники),)","v":10},{"$f":"MAX(K4-F4,0)","v":62},36,"2015-07-01",{"$f":"ОТПУСК(K4,J4,Праздники)","v":"2015-08-05"},{"$f":"IF(L4,L4-K4+1,)","v":36},{"$f":"IF(L4,NETWORKDAYS(K4,L4,Праздники),)","v":26},{"$f":"MAX(Q4-L4,0)","v":0},0,"00:00:00",{"$f":"ОТПУСК(Q4,P4,Праздники)","v":"00:00:00"},{"$f":"IF(R4,R4-Q4+1,)","v":0},{"$f":"IF(R4,NETWORKDAYS(Q4,R4,Праздники),)","v":0},null,"2015-01-02","2015-03-08"]
[2,"Инж. прог.","Петров",10,"2015-01-01",{"$f":"ОТПУСК(E5,D5,Праздники)","v":"2015-01-19"},19,6,{"$f":"MAX(K5-F5,0)","v":0},0,"00:00:00","00:00:00",{"$f":"IF(L5,L5-K5+1,)","v":0},0,{"$f":"MAX(Q5-L5,0)","v":0},0,"00:00:00","00:00:00",{"$f":"IF(R5,R5-Q5+1,)","v":0},0,null,"2015-01-03","2015-05-01"]
[3,"ДИП","Сидоров",52,"2015-05-01","2015-06-25",56,38,0,0,"00:00:00","00:00:00",0,0,0,0,"00:00:00","00:00:00",0,0,null,"2015-01-04","2015-05-02"]
[4,"ДИП","Смирнов",28,"2015-02-15","2015-03-16",30,20,151,24,"2015-08-14","2015-09-06",24,16,0,0,"00:00:00","00:00:00",0,0,null,"2015-01-05","2015-05-09"]
[5,"ДИП","Хохлов",52,"2015-09-01","2015-10-22",52,38,0,0,"00:00:00","00:00:00",0,0,0,0,"00:00:00","00:00:00",0,0,null,"2015-01-06","2015-06-12"]
[6,"ДИП","Кузнецов",28,"2015-04-01","2015-04-28",28,20,70,24,"2015-07-07","2015-07-30",24,18,0,0,"00:00:00","00:00:00",0,0,null,"2015-01-07","2015-11-04"]
[7,"ДИП","Волков",30,"2015-03-04",{"$f":"ОТПУСК(E10,D10,Праздники)","v":"2015-04-03"},31,23,0,0,"00:00:00","00:00:00",0,0,0,0,"00:00:00","00:00:00",0,0,null,"2015-01-08"]
[8,"ДИП","Зайцев",0,"00:00:00",{"$f":"ОТПУСК(E11,D11,Праздники)","v":"00:00:00"},{"$f":"IF(F11,F11-E11+1,)","v":0},0,0,0,"00:00:00","00:00:00",0,0,0,0,"00:00:00","00:00:00",0,0,null,"2015-01-09"]
[9,"ДИП","Белкин",14,"2015-03-02","2015-03-16",{"$f":"IF(F12,F12-E12+1,)","v":15},11,113,7,"2015-07-07","2015-07-13",7,5,114,7,"2015-11-04",{"$f":"ОТПУСК(Q12,P12,Праздники)","v":"2015-11-11"},8,5]
[10,"ДИП","Краснов",14,"2015-04-27","2015-05-13",17,12,0,0,"00:00:00","00:00:00",0,0,0,0,"00:00:00","00:00:00",0,0]
[11,"ДИП","Зернов",14,"2015-06-08","2015-06-22",{"$f":"IF(F14,F14-E14+1,)","v":15},{"$f":"IF(F14,NETWORKDAYS(E14,F14,Праздники),)","v":10},{"$f":"MAX(K14-F14,0)","v":132},14,"2015-11-01",{"$f":"ОТПУСК(K14,J14,Праздники)","v":"2015-11-15"},{"$f":"IF(L14,L14-K14+1,)","v":15},{"$f":"IF(L14,NETWORKDAYS(K14,L14,Праздники),)","v":9},{"$f":"MAX(Q14-L14,0)","v":0},0,"00:00:00",{"$f":"ОТПУСК(Q14,P14,Праздники)","v":"00:00:00"},{"$f":"IF(R14,R14-Q14+1,)","v":0},{"$f":"IF(R14,NETWORKDAYS(Q14,R14,Праздники),)","v":0}]
[12,"ДИП","Богачев",14,"2015-04-13","2015-04-26",14,10,190,14,"2015-11-02",{"$f":"ОТПУСК(K15,J15,Праздники)","v":"2015-11-16"},15,10,0,0,"00:00:00","00:00:00",0,0]