{"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,2017]
[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,"2017-01-01","2017-03-06"]
[1,"Водитель автомобиля","Иванов ",14,"2017-01-11",{"$f":"ОТПУСК(E4,D4,Праздники)","v":"2017-01-24"},{"$f":"IF(F4,F4-E4+1,)","v":14},{"$f":"IF(F4,NETWORKDAYS(E4,F4,Праздники),)","v":10},{"$f":"MAX(K4-F4,0)","v":0},null,null,{"$f":"ОТПУСК(K4,J4,Праздники)","v":"00:00:00"},{"$f":"IF(L4,L4-K4+1,)","v":0},{"$f":"IF(L4,NETWORKDAYS(K4,L4,Праздники),)","v":0},{"$f":"MAX(Q4-L4,0)","v":0},null,null,{"$f":"ОТПУСК(Q4,P4,Праздники)","v":"00:00:00"},{"$f":"IF(R4,R4-Q4+1,)","v":0},{"$f":"IF(R4,NETWORKDAYS(Q4,R4,Праздники),)","v":0},null,"2017-01-02","2017-03-07"]
[2,"Механик","Петров",14,null,{"$f":"ОТПУСК(E5,D5,Праздники)","v":"00:00:00"},0,0,{"$f":"MAX(K5-F5,0)","v":0},null,null,"00:00:00",{"$f":"IF(L5,L5-K5+1,)","v":0},0,{"$f":"MAX(Q5-L5,0)","v":0},null,null,"00:00:00",{"$f":"IF(R5,R5-Q5+1,)","v":0},0,null,"2017-01-03","2017-03-08"]
[3,"Механик","Сидоров",14,"2017-02-15",{"$f":"ОТПУСК(E6,D6,Праздники)","v":"2017-03-03"},17,10,0,null,null,"00:00:00",0,0,0,null,null,"00:00:00",0,0,null,"2017-01-04","2017-04-30"]
[4,"Водитель автомобиля","Иванова ",14,null,"00:00:00",0,0,0,null,null,"00:00:00",0,0,0,null,null,"00:00:00",0,0,null,"2017-01-05","2017-05-01"]
[5,"Водитель автомобиля","Петрова",14,null,"00:00:00",0,0,0,null,null,"00:00:00",0,0,0,null,null,"00:00:00",0,0,null,"2017-01-06","2017-05-02"]
[6,"Механик","Сидорова",14,null,"00:00:00",0,0,0,null,null,"00:00:00",0,0,0,null,null,"00:00:00",0,0,null,"2017-01-07","2017-05-07"]
[7,"Водитель автомобиля","Васечкин",14,null,{"$f":"ОТПУСК(E10,D10,Праздники)","v":"00:00:00"},0,0,0,null,null,"00:00:00",0,0,0,null,null,"00:00:00",0,0,null,"2017-01-08","2017-05-08"]
[8,"Диспетчер","Васечкина",14,"2017-01-10",{"$f":"ОТПУСК(E11,D11,Праздники)","v":"2017-01-24"},{"$f":"IF(F11,F11-E11+1,)","v":15},10,0,null,null,"00:00:00",0,0,0,null,null,"00:00:00",0,0,null,"2017-01-09","2017-05-09"]
[9,null,null,null,null,"00:00:00",{"$f":"IF(F12,F12-E12+1,)","v":0},0,0,null,null,"00:00:00",0,0,0,null,null,{"$f":"ОТПУСК(Q12,P12,Праздники)","v":"00:00:00"},0,0,null,"2017-01-10","2017-06-11"]
[10,null,null,null,null,"00:00:00",0,0,0,null,null,"00:00:00",0,0,0,null,null,"00:00:00",0,0,null,"2017-02-20","2017-06-12"]
[11,null,null,null,null,"00:00:00",{"$f":"IF(F14,F14-E14+1,)","v":0},{"$f":"IF(F14,NETWORKDAYS(E14,F14,Праздники),)","v":0},{"$f":"MAX(K14-F14,0)","v":0},null,null,{"$f":"ОТПУСК(K14,J14,Праздники)","v":"00:00:00"},{"$f":"IF(L14,L14-K14+1,)","v":0},{"$f":"IF(L14,NETWORKDAYS(K14,L14,Праздники),)","v":0},{"$f":"MAX(Q14-L14,0)","v":0},null,null,{"$f":"ОТПУСК(Q14,P14,Праздники)","v":"00:00:00"},{"$f":"IF(R14,R14-Q14+1,)","v":0},{"$f":"IF(R14,NETWORKDAYS(Q14,R14,Праздники),)","v":0},null,"2017-02-21","2017-06-13"]
[12,null,null,null,null,"00:00:00",0,0,0,null,null,{"$f":"ОТПУСК(K15,J15,Праздники)","v":"00:00:00"},0,0,0,null,null,"00:00:00",0,0,null,"2017-02-22","2017-11-04"]