{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["планировщик","унифицированная форма","ближайшие отпуска","сформировать график","унифицированная форма (1)","пересечение отпусков"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":29,"n_cols":54,"rows_kept":29,"cut":false,"hidden":false,"merged":[[25,4,26,4],[27,5,28,5],[7,5,8,5],[13,5,14,5],[15,5,16,5],[5,5,6,5],[9,5,10,5],[11,5,12,5],[19,5,20,5],[17,5,18,5],[23,5,24,5],[21,5,22,5],[25,5,26,5],[7,4,8,4],[5,4,6,4],[9,4,10,4],[11,4,12,4],[13,4,14,4],[15,4,16,4],[17,4,18,4],[19,4,20,4],[21,4,22,4],[25,0,26,0],[25,1,26,1],[27,3,28,3],[5,3,6,3],[7,3,8,3],[9,3,10,3],[11,3,12,3],[13,3,14,3],[15,3,16,3],[17,3,18,3],[19,3,20,3],[21,3,22,3],[23,3,24,3],[25,3,26,3],[5,1,6,1],[7,0,8,0],[7,1,8,1],[9,0,10,0],[9,1,10,1],[11,0,12,0],[11,1,12,1],[13,0,14,0],[13,1,14,1],[27,2,28,2],[27,9,28,9],[27,13,28,13],[27,17,28,17],[28,6,28,8],[27,0,28,0],[27,1,28,1],[27,4,28,4],[27,21,28,21],[27,25,28,25],[27,29,28,29],[28,10,28,12],[28,14,28,16],[28,18,28,20],[28,22,28,24],[27,33,28,33],[27,34,28,34],[28,26,28,28],[28,30,28,32],[0,0,1,4],[5,9,6,9],[8,6,8,8],[7,9,8,9],[5,34,6,34],[7,25,8,25],[7,2,8,2],[7,21,8,21],[7,29,8,29],[7,33,8,33],[3,0,4,0],[3,10,3,13],[3,4,4,4],[3,3,4,3],[3,6,3,9],[3,1,4,1],[3,5,4,5],[3,2,4,2],[6,6,6,8],[5,2,6,2],[3,30,3,33],[3,22,3,25],[3,26,3,29],[6,10,6,12],[5,13,6,13],[5,17,6,17],[6,14,6,16],[6,18,6,20],[6,22,6,24],[6,30,6,32],[5,21,6,21],[5,25,6,25],[5,29,6,29],[5,33,6,33],[6,26,6,28],[3,14,3,17],[3,18,3,21],[5,0,6,0],[7,34,8,34],[8,10,8,12],[8,14,8,16],[8,18,8,20],[8,22,8,24],[8,26,8,28],[8,30,8,32],[7,13,8,13],[7,17,8,17],[9,2,10,2],[9,33,10,33],[9,34,10,34],[10,6,10,8],[10,10,10,12],[10,14,10,16],[10,18,10,20],[10,22,10,24],[10,26,10,28],[10,30,10,32],[9,9,10,9],[9,13,10,13],[9,17,10,17],[9,21,10,21],[9,25,10,25],[9,29,10,29],[11,2,12,2],[11,9,12,9],[11,13,12,13],[11,17,12,17],[11,21,12,21],[11,25,12,25],[11,29,12,29],[11,33,12,33],[11,34,12,34],[12,6,12,8],[12,10,12,12],[12,14,12,16],[12,18,12,20],[12,22,12,24],[12,26,12,28],[12,30,12,32],[13,13,14,13],[13,17,14,17],[13,21,14,21],[13,25,14,25],[13,29,14,29],[13,2,14,2],[13,33,14,33],[13,34,14,34],[14,6,14,8],[14,10,14,12],[14,14,14,16],[14,18,14,20],[14,22,14,24],[14,26,14,28],[14,30,14,32],[13,9,14,9],[15,2,16,2],[15,9,16,9],[15,13,16,13],[15,17,16,17],[15,0,16,0],[15,1,16,1],[15,21,16,21],[15,25,16,25],[15,29,16,29],[15,33,16,33],[15,34,16,34],[16,6,16,8],[16,10,16,12],[16,14,16,16],[16,18,16,20],[16,22,16,24],[16,26,16,28],[16,30,16,32],[17,13,18,13],[17,17,18,17],[17,21,18,21],[17,25,18,25],[17,29,18,29],[17,2,18,2],[17,33,18,33],[17,34,18,34],[18,6,18,8],[18,10,18,12],[18,14,18,16],[18,18,18,20],[18,22,18,24],[18,26,18,28],[18,30,18,32],[17,9,18,9],[17,0,18,0],[17,1,18,1],[19,2,20,2],[19,9,20,9],[19,13,20,13],[19,17,20,17],[19,0,20,0],[19,1,20,1],[19,21,20,21],[19,25,20,25],[19,29,20,29],[19,33,20,33],[19,34,20,34],[20,6,20,8],[20,10,20,12],[20,14,20,16],[20,18,20,20],[20,22,20,24],[20,26,20,28],[20,30,20,32],[21,13,22,13],[21,17,22,17],[21,21,22,21],[21,25,22,25],[21,29,22,29],[21,2,22,2],[21,33,22,33],[21,34,22,34],[22,6,22,8],[22,10,22,12],[22,14,22,16],[22,18,22,20],[22,22,22,24],[22,26,22,28],[22,30,22,32],[21,9,22,9],[21,0,22,0],[21,1,22,1],[23,2,24,2],[23,9,24,9],[23,13,24,13],[23,17,24,17],[24,14,24,16],[23,0,24,0],[23,1,24,1],[23,4,24,4],[24,18,24,20],[24,22,24,24],[24,26,24,28],[24,30,24,32],[25,13,26,13],[25,17,26,17],[25,21,26,21],[25,25,26,25],[25,29,26,29],[2,52,2,53],[25,2,26,2],[25,33,26,33],[25,34,26,34],[26,6,26,8],[26,10,26,12],[26,14,26,16],[26,18,26,20],[26,22,26,24],[26,26,26,28],[26,30,26,32],[25,9,26,9],[23,21,24,21],[23,25,24,25],[23,29,24,29],[23,33,24,33],[23,34,24,34],[24,6,24,8],[24,10,24,12]]}
[null,null,null,null,null,{"$f":"100/12","v":8.3333333333333339}]
[]
["Наименование организации","ООО \"Стройкомплект\"","Руководитель кадровой службы","Орлова Е.А.","Должность руководителя организации","генеральный директор","ФИО руководителя организации","Иванов И.И.",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,"Для точного определения отпусков, используемых авансом, укажите следующие данные"]
["Структурное подразделение","ФИО ","Начало рабочего года","Табельный номер","Должность, профессия","Общая продолжительность отпуска с учетом дополнительных отпусков и неотгулянных дней ","Первая часть отпуска",null,null,null,"Вторая часть отпуска",null,null,null,"Третья часть отпуска",null,null,null,"Четвертая часть отпуска",null,null,null,"Пятая часть отпуска",null,null,null,"Шестая часть отпуска",null,null,null,"Седьмая часть отпуска",null,null,null,"Итого количество запланированных дней отпуска",null,"2018-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Количество дней, которые не учитываются в рабочем году","Неучтенный отпуск прошлого года"]
[null,null,null,null,null,null,"Дата начала ","Продолжительность","Дата окончания","Дата предупреждения работника о начале отпуска","Дата начала ","Продолжительность","Дата окончания","Дата предупреждения работника о начале отпуска","Дата начала ","Продолжительность","Дата окончания","Дата предупреждения работника о начале отпуска","Дата начала ","Продолжительность","Дата окончания","Дата предупреждения работника о начале отпуска","Дата начала ","Продолжительность","Дата окончания","Дата предупреждения работника о начале отпуска","Дата начала ","Продолжительность","Дата окончания","Дата предупреждения работника о начале отпуска","Дата начала ","Продолжительность","Дата окончания","Дата предупреждения работника о начале отпуска","Проверьте совпадает ли общая продолжительность отпуска с запланированной. Если значения не совпадают ячейка подкрасится желтым или розовым цветом ",null,"до 1-го отпуска","1-й отпуск","до 2-го","2-й отпуск","до 3-го","3-й отпуск","до 4-го","4-й отпуск","до 5-го","5-й отпуск","до 6-го","6-й отпуск","до 7-го","7-й отпуск",null,null,"укажите количество дней, на которые смещается окончание рабочего года, например кол-во дней отпуска за свой счет, превыщающие 14 дней в рабочем году и другие периоды (ст. 121 ТК РФ)"," укажите сколько дней отпуска уже использовал работник с начала рабочего года"]
["Администрация","Иванов Иван Иванович",null,1,"слесарь",28,"2018-03-05",28,"2018-04-02",{"$f":"IF(G6=\"\",\"\",G6-14)","v":"2018-02-19"},null,null,null,{"$f":"IF(K6=\"\",\"\",K6-14)","v":""},null,null,null,{"$f":"IF(O6=\"\",\"\",O6-14)","v":""},null,null,null,{"$f":"IF(S6=\"\",\"\",S6-14)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H6+L6+P6+T6+X6+AB6+AF6","v":28},null,{"$f":"G6-$AK$4","v":63},{"$f":"I6-G6","v":28},{"$f":"IF(K6=\"\",\"\",K6-I6)","v":""},{"$f":"IF(M6=\"\",\"\",M6-K6)","v":""},{"$f":"IF(O6=\"\",\"\",O6-M6)","v":""},{"$f":"IF(Q6=\"\",\"\",Q6-O6)","v":""},{"$f":"IF(S6=\"\",\"\",S6-Q6)","v":""},{"$f":"IF(U6=\"\",\"\",U6-S6)","v":""},{"$f":"IF(W6=\"\",\"\",W6-U6)","v":""},{"$f":"IF(Y6=\"\",\"\",Y6-W6)","v":""},{"$f":"IF(AA6=\"\",\"\",AA6-Y6)","v":""},{"$f":"IF(AC6=\"\",\"\",AC6-AA6)","v":""},{"$f":"IF(AE6=\"\",\"\",AE6-AC6)","v":""},{"$f":"IF(AG6=\"\",\"\",AG6-AE6)","v":""},null,null,0,10]
[null,null,null,null,null,null,"кол-во дней отпуска авансом: 10"]
["Секретариат ","Петров Петр Петрович",null,2,"администратор",28,"2018-03-05",28,"2018-04-02","2018-02-19",null,null,null,"",null,null,null,{"$f":"IF(O8=\"\",\"\",O8-14)","v":""},null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H8+L8+P8+T8","v":28},null,{"$f":"G8-$AK$4","v":63},{"$f":"I8-G8","v":28},{"$f":"IF(K8=\"\",\"\",K8-I8)","v":""},{"$f":"IF(M8=\"\",\"\",M8-K8)","v":""},{"$f":"IF(O8=\"\",\"\",O8-M8)","v":""},{"$f":"IF(Q8=\"\",\"\",Q8-O8)","v":""},{"$f":"IF(S8=\"\",\"\",S8-Q8)","v":""},{"$f":"IF(U8=\"\",\"\",U8-S8)","v":""},{"$f":"IF(W8=\"\",\"\",W8-U8)","v":""},{"$f":"IF(Y8=\"\",\"\",Y8-W8)","v":""},{"$f":"IF(AA8=\"\",\"\",AA8-Y8)","v":""},{"$f":"IF(AC8=\"\",\"\",AC8-AA8)","v":""},{"$f":"IF(AE8=\"\",\"\",AE8-AC8)","v":""},{"$f":"IF(AG8=\"\",\"\",AG8-AE8)","v":""}]
[null,null,null,null,null,null,"кол-во дней отпуска авансом: 0"]
["Бухгалтерия","Сидоров Сидор Сидорович",null,3,"главный бухгалтер",28,"2018-03-05",28,"2018-04-02","2018-02-19",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,null,{"$f":"G10-$AK$4","v":63},{"$f":"I10-G10","v":28},{"$f":"IF(K10=\"\",\"\",K10-I10)","v":""},{"$f":"IF(M10=\"\",\"\",M10-K10)","v":""},{"$f":"IF(O10=\"\",\"\",O10-M10)","v":""},{"$f":"IF(Q10=\"\",\"\",Q10-O10)","v":""},{"$f":"IF(S10=\"\",\"\",S10-Q10)","v":""},{"$f":"IF(U10=\"\",\"\",U10-S10)","v":""},{"$f":"IF(W10=\"\",\"\",W10-U10)","v":""},{"$f":"IF(Y10=\"\",\"\",Y10-W10)","v":""},{"$f":"IF(AA10=\"\",\"\",AA10-Y10)","v":""},{"$f":"IF(AC10=\"\",\"\",AC10-AA10)","v":""},{"$f":"IF(AE10=\"\",\"\",AE10-AC10)","v":""},{"$f":"IF(AG10=\"\",\"\",AG10-AE10)","v":""}]
[null,null,null,null,null,null,"кол-во дней отпуска авансом: 0"]
["Отдел кадров","Романов Роман Романович",null,4,"специалист ",28,"2018-03-05",28,"2018-04-02","2018-02-19",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,28,null,{"$f":"G12-$AK$4","v":63},{"$f":"I12-G12","v":28},{"$f":"IF(K12=\"\",\"\",K12-I12)","v":""},{"$f":"IF(M12=\"\",\"\",M12-K12)","v":""},{"$f":"IF(O12=\"\",\"\",O12-M12)","v":""},{"$f":"IF(Q12=\"\",\"\",Q12-O12)","v":""},{"$f":"IF(S12=\"\",\"\",S12-Q12)","v":""},{"$f":"IF(U12=\"\",\"\",U12-S12)","v":""},{"$f":"IF(W12=\"\",\"\",W12-U12)","v":""},{"$f":"IF(Y12=\"\",\"\",Y12-W12)","v":""},{"$f":"IF(AA12=\"\",\"\",AA12-Y12)","v":""},{"$f":"IF(AC12=\"\",\"\",AC12-AA12)","v":""},{"$f":"IF(AE12=\"\",\"\",AE12-AC12)","v":""},{"$f":"IF(AG12=\"\",\"\",AG12-AE12)","v":""}]
[null,null,null,null,null,null,"кол-во дней отпуска авансом: 0"]
["Производственный отдел","Степанов Степан Степанович",null,7,"главный инженер",28,"2018-03-05",28,"2018-04-02","2018-02-19",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,28,null,{"$f":"G14-$AK$4","v":63},{"$f":"I14-G14","v":28},{"$f":"IF(K14=\"\",\"\",K14-I14)","v":""},{"$f":"IF(M14=\"\",\"\",M14-K14)","v":""},{"$f":"IF(O14=\"\",\"\",O14-M14)","v":""},{"$f":"IF(Q14=\"\",\"\",Q14-O14)","v":""},{"$f":"IF(S14=\"\",\"\",S14-Q14)","v":""},{"$f":"IF(U14=\"\",\"\",U14-S14)","v":""},{"$f":"IF(W14=\"\",\"\",W14-U14)","v":""},{"$f":"IF(Y14=\"\",\"\",Y14-W14)","v":""},{"$f":"IF(AA14=\"\",\"\",AA14-Y14)","v":""},{"$f":"IF(AC14=\"\",\"\",AC14-AA14)","v":""},{"$f":"IF(AE14=\"\",\"\",AE14-AC14)","v":""},{"$f":"IF(AG14=\"\",\"\",AG14-AE14)","v":""}]
[null,null,null,null,null,null,"кол-во дней отпуска авансом: 0"]
["Секретариат ","Алексеев Алексей Алексеевич",null,8,"секретарь",28,"2018-03-05",28,"2018-04-02","2018-02-19",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,28,null,{"$f":"G16-$AK$4","v":63},{"$f":"I16-G16","v":28},{"$f":"IF(K16=\"\",\"\",K16-I16)","v":""},{"$f":"IF(M16=\"\",\"\",M16-K16)","v":""},{"$f":"IF(O16=\"\",\"\",O16-M16)","v":""},{"$f":"IF(Q16=\"\",\"\",Q16-O16)","v":""},{"$f":"IF(S16=\"\",\"\",S16-Q16)","v":""},{"$f":"IF(U16=\"\",\"\",U16-S16)","v":""},{"$f":"IF(W16=\"\",\"\",W16-U16)","v":""},{"$f":"IF(Y16=\"\",\"\",Y16-W16)","v":""},{"$f":"IF(AA16=\"\",\"\",AA16-Y16)","v":""},{"$f":"IF(AC16=\"\",\"\",AC16-AA16)","v":""},{"$f":"IF(AE16=\"\",\"\",AE16-AC16)","v":""},{"$f":"IF(AG16=\"\",\"\",AG16-AE16)","v":""}]
[null,null,null,null,null,null,"кол-во дней отпуска авансом: 0"]
["Производственный отдел","Борисов Борис Борисович",null,9,"слесарь",28,"2018-03-05",28,"2018-04-02","2018-02-19",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,28,null,{"$f":"G18-$AK$4","v":63},{"$f":"I18-G18","v":28},{"$f":"IF(K18=\"\",\"\",K18-I18)","v":""},{"$f":"IF(M18=\"\",\"\",M18-K18)","v":""},{"$f":"IF(O18=\"\",\"\",O18-M18)","v":""},{"$f":"IF(Q18=\"\",\"\",Q18-O18)","v":""},{"$f":"IF(S18=\"\",\"\",S18-Q18)","v":""},{"$f":"IF(U18=\"\",\"\",U18-S18)","v":""},{"$f":"IF(W18=\"\",\"\",W18-U18)","v":""},{"$f":"IF(Y18=\"\",\"\",Y18-W18)","v":""},{"$f":"IF(AA18=\"\",\"\",AA18-Y18)","v":""},{"$f":"IF(AC18=\"\",\"\",AC18-AA18)","v":""},{"$f":"IF(AE18=\"\",\"\",AE18-AC18)","v":""},{"$f":"IF(AG18=\"\",\"\",AG18-AE18)","v":""}]
[null,null,null,null,null,null,"кол-во дней отпуска авансом: 0"]
["Отдел кадров","Данилов Даниил Даниилович",null,10,"начальник отдела кадров",28,"2018-03-05",28,"2018-04-02","2018-02-19",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,28,null,{"$f":"G20-$AK$4","v":63},{"$f":"I20-G20","v":28},{"$f":"IF(K20=\"\",\"\",K20-I20)","v":""},{"$f":"IF(M20=\"\",\"\",M20-K20)","v":""},{"$f":"IF(O20=\"\",\"\",O20-M20)","v":""},{"$f":"IF(Q20=\"\",\"\",Q20-O20)","v":""},{"$f":"IF(S20=\"\",\"\",S20-Q20)","v":""},{"$f":"IF(U20=\"\",\"\",U20-S20)","v":""},{"$f":"IF(W20=\"\",\"\",W20-U20)","v":""},{"$f":"IF(Y20=\"\",\"\",Y20-W20)","v":""},{"$f":"IF(AA20=\"\",\"\",AA20-Y20)","v":""},{"$f":"IF(AC20=\"\",\"\",AC20-AA20)","v":""},{"$f":"IF(AE20=\"\",\"\",AE20-AC20)","v":""},{"$f":"IF(AG20=\"\",\"\",AG20-AE20)","v":""}]
[null,null,null,null,null,null,"кол-во дней отпуска авансом: 0"]
["Отдел кадров","Захаров Захар Захарович",null,11,"специалист ",28,"2018-03-05",28,"2018-04-02","2018-02-19",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,28,null,{"$f":"G22-$AK$4","v":63},{"$f":"I22-G22","v":28},{"$f":"IF(K22=\"\",\"\",K22-I22)","v":""},{"$f":"IF(M22=\"\",\"\",M22-K22)","v":""},{"$f":"IF(O22=\"\",\"\",O22-M22)","v":""},{"$f":"IF(Q22=\"\",\"\",Q22-O22)","v":""},{"$f":"IF(S22=\"\",\"\",S22-Q22)","v":""},{"$f":"IF(U22=\"\",\"\",U22-S22)","v":""},{"$f":"IF(W22=\"\",\"\",W22-U22)","v":""},{"$f":"IF(Y22=\"\",\"\",Y22-W22)","v":""},{"$f":"IF(AA22=\"\",\"\",AA22-Y22)","v":""},{"$f":"IF(AC22=\"\",\"\",AC22-AA22)","v":""},{"$f":"IF(AE22=\"\",\"\",AE22-AC22)","v":""},{"$f":"IF(AG22=\"\",\"\",AG22-AE22)","v":""}]
[null,null,null,null,null,null,"кол-во дней отпуска авансом: 0"]
["Производственный отдел","Федоров Федор Федорович",null,12,"сварщик",28,"2018-03-05",28,"2018-04-02",{"$f":"IF(G24=\"\",\"\",G24-14)","v":"2018-02-19"},null,null,null,"",null,null,null,{"$f":"IF(O24=\"\",\"\",O24-14)","v":""},null,null,null,{"$f":"IF(S24=\"\",\"\",S24-14)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,28,null,{"$f":"G24-$AK$4","v":63},{"$f":"I24-G24","v":28},{"$f":"IF(K24=\"\",\"\",K24-I24)","v":""},{"$f":"IF(M24=\"\",\"\",M24-K24)","v":""},{"$f":"IF(O24=\"\",\"\",O24-M24)","v":""},{"$f":"IF(Q24=\"\",\"\",Q24-O24)","v":""},{"$f":"IF(S24=\"\",\"\",S24-Q24)","v":""},{"$f":"IF(U24=\"\",\"\",U24-S24)","v":""},{"$f":"IF(W24=\"\",\"\",W24-U24)","v":""},{"$f":"IF(Y24=\"\",\"\",Y24-W24)","v":""},{"$f":"IF(AA24=\"\",\"\",AA24-Y24)","v":""},{"$f":"IF(AC24=\"\",\"\",AC24-AA24)","v":""},{"$f":"IF(AE24=\"\",\"\",AE24-AC24)","v":""},{"$f":"IF(AG24=\"\",\"\",AG24-AE24)","v":""}]
[null,null,null,null,null,null,"кол-во дней отпуска авансом: 0"]
["Производственный отдел","Павлов Павел Павлович",null,13,"слесарь",28,"2018-03-05",28,"2018-04-02",{"$f":"IF(G26=\"\",\"\",G26-14)","v":"2018-02-19"},null,null,null,"",null,null,null,{"$f":"IF(O26=\"\",\"\",O26-14)","v":""},null,null,null,{"$f":"IF(S26=\"\",\"\",S26-14)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,28,null,{"$f":"G26-$AK$4","v":63},{"$f":"I26-G26","v":28},{"$f":"IF(K26=\"\",\"\",K26-I26)","v":""},{"$f":"IF(M26=\"\",\"\",M26-K26)","v":""},{"$f":"IF(O26=\"\",\"\",O26-M26)","v":""},{"$f":"IF(Q26=\"\",\"\",Q26-O26)","v":""},{"$f":"IF(S26=\"\",\"\",S26-Q26)","v":""},{"$f":"IF(U26=\"\",\"\",U26-S26)","v":""},{"$f":"IF(W26=\"\",\"\",W26-U26)","v":""},{"$f":"IF(Y26=\"\",\"\",Y26-W26)","v":""},{"$f":"IF(AA26=\"\",\"\",AA26-Y26)","v":""},{"$f":"IF(AC26=\"\",\"\",AC26-AA26)","v":""},{"$f":"IF(AE26=\"\",\"\",AE26-AC26)","v":""},{"$f":"IF(AG26=\"\",\"\",AG26-AE26)","v":""}]
[null,null,null,null,null,null,"кол-во дней отпуска авансом: 0"]
["Производственный отдел","Максимов Максим Максимович",null,14,"сварщик",28,"2018-03-05",28,"2018-04-02",{"$f":"IF(G28=\"\",\"\",G28-14)","v":"2018-02-19"},null,null,null,{"$f":"IF(K28=\"\",\"\",K28-14)","v":""},null,null,null,{"$f":"IF(O28=\"\",\"\",O28-14)","v":""},null,null,null,{"$f":"IF(S28=\"\",\"\",S28-14)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H28+L28+P28+T28","v":28},null,{"$f":"G28-$AK$4","v":63},{"$f":"I28-G28","v":28},{"$f":"IF(K28=\"\",\"\",K28-I28)","v":""},{"$f":"IF(M28=\"\",\"\",M28-K28)","v":""},{"$f":"IF(O28=\"\",\"\",O28-M28)","v":""},{"$f":"IF(Q28=\"\",\"\",Q28-O28)","v":""},{"$f":"IF(S28=\"\",\"\",S28-Q28)","v":""},{"$f":"IF(U28=\"\",\"\",U28-S28)","v":""},{"$f":"IF(W28=\"\",\"\",W28-U28)","v":""},{"$f":"IF(Y28=\"\",\"\",Y28-W28)","v":""},{"$f":"IF(AA28=\"\",\"\",AA28-Y28)","v":""},{"$f":"IF(AC28=\"\",\"\",AC28-AA28)","v":""},{"$f":"IF(AE28=\"\",\"\",AE28-AC28)","v":""},{"$f":"IF(AG28=\"\",\"\",AG28-AE28)","v":""}]
[null,null,null,null,null,null,"кол-во дней отпуска авансом: 0"]

{"sheet":"унифицированная форма","index":1,"n_rows":42,"n_cols":43,"rows_kept":42,"cut":false,"hidden":false,"merged":[[5,0,5,28],[5,29,5,37],[5,38,5,42],[6,0,6,32],[6,33,6,37],[6,38,6,42],[0,0,0,42],[1,0,1,42],[2,0,2,42],[3,0,3,42],[4,0,4,37],[4,38,4,42],[10,4,10,5],[10,9,10,10],[10,11,10,12],[10,14,10,26],[10,27,10,33],[10,34,10,42],[7,0,8,32],[7,33,8,37],[7,38,8,42],[9,0,9,13],[9,14,9,26],[9,27,9,42],[11,0,11,13],[11,14,11,26],[11,27,11,33],[11,34,11,42],[12,0,12,13],[12,14,12,16],[12,17,12,21],[12,22,12,23],[12,24,12,25],[12,36,12,42],[12,27,12,34],[14,0,14,13],[14,14,14,26],[14,28,14,30],[14,32,14,38],[14,40,14,41],[15,0,15,42],[13,0,13,13],[13,14,13,16],[13,17,13,21],[13,22,13,23],[13,24,13,25],[13,27,13,34],[13,36,13,42],[22,0,22,4],[22,5,22,9],[22,10,22,17],[22,18,22,19],[22,20,22,22],[22,23,22,24],[19,20,19,22],[20,20,20,22],[21,20,21,22],[16,5,21,9],[16,10,21,17],[17,23,17,29],[16,18,21,19],[16,20,16,41],[17,20,17,22],[18,20,18,22],[21,37,21,41],[21,30,21,36],[18,37,18,41],[20,37,20,41],[22,25,22,29],[22,30,22,36],[22,37,22,41],[17,30,17,41],[18,23,18,24],[19,23,19,24],[20,23,20,24],[21,23,21,24],[18,25,21,29],[19,37,19,41],[18,30,18,36],[19,30,19,36],[20,30,20,36],[23,0,23,4],[23,5,23,9],[23,10,23,17],[23,18,23,19],[23,20,23,22],[23,23,23,24],[23,25,23,29],[23,30,23,36],[23,37,23,41],[24,0,24,4],[24,5,24,9],[24,10,24,17],[24,18,24,19],[24,20,24,22],[24,23,24,24],[24,25,24,29],[24,30,24,36],[24,37,24,41],[25,0,25,4],[25,5,25,9],[25,10,25,17],[25,18,25,19],[25,20,25,22],[25,23,25,24],[25,25,25,29],[25,30,25,36],[25,37,25,41],[26,25,26,29],[26,30,26,36],[26,37,26,41],[27,0,27,4],[27,5,27,9],[27,10,27,17],[27,18,27,19],[27,20,27,22],[27,23,27,24],[27,25,27,29],[26,0,26,4],[26,5,26,9],[26,10,26,17],[26,18,26,19],[26,20,26,22],[26,23,26,24],[27,30,27,36],[27,37,27,41],[28,0,28,4],[28,5,28,9],[28,10,28,17],[28,18,28,19],[28,20,28,22],[28,23,28,24],[28,25,28,29],[28,30,28,36],[28,37,28,41],[29,0,29,4],[29,5,29,9],[29,10,29,17],[29,18,29,19],[29,20,29,22],[29,23,29,24],[29,25,29,29],[29,30,29,36],[29,37,29,41],[30,0,30,4],[30,5,30,9],[30,10,30,17],[30,18,30,19],[30,20,30,22],[30,23,30,24],[30,25,30,29],[30,30,30,36],[30,37,30,41],[33,25,33,29],[33,30,33,36],[33,37,33,41],[31,30,31,36],[31,37,31,41],[32,0,32,4],[32,5,32,9],[32,10,32,17],[32,18,32,19],[32,20,32,22],[32,23,32,24],[32,25,32,29],[32,30,32,36],[31,0,31,4],[31,5,31,9],[31,10,31,17],[31,18,31,19],[31,20,31,22],[31,23,31,24],[31,25,31,29],[35,18,35,19],[35,20,35,22],[35,23,35,24],[32,37,32,41],[33,0,33,4],[33,5,33,9],[33,10,33,17],[33,18,33,19],[33,20,33,22],[33,23,33,24],[35,25,35,29],[34,0,34,4],[34,5,34,9],[34,10,34,17],[34,18,34,19],[34,20,34,22],[34,23,34,24],[35,0,35,4],[35,5,35,9],[35,10,35,17],[34,25,34,29],[34,30,34,36],[34,37,34,41],[35,30,35,36],[35,37,35,41],[36,5,36,9],[36,10,36,17],[36,18,36,19],[36,20,36,22],[36,23,36,24],[16,0,21,4],[41,0,41,11],[41,12,41,14],[41,16,41,18],[41,19,41,20],[41,21,41,40],[37,0,37,4],[37,5,37,9],[37,10,37,17],[37,18,37,19],[41,41,41,42],[38,0,39,42],[40,0,40,11],[40,12,40,14],[40,16,40,18],[40,19,40,20],[40,21,40,40],[40,41,40,42],[37,20,37,22],[37,23,37,24],[37,25,37,29],[37,30,37,36],[37,37,37,41],[36,0,36,4],[36,30,36,36],[36,37,36,41],[36,25,36,29]]}
["Унифицированная форма N Т-7"]
["Утверждена постановлением Госкомстата России"]
["от 05.01.2004 N 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,"Код"]
[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,301020]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"УТВЕРЖДАЮ"]
["от","\"",null,"\"",null,null,20,null,"г.","N",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,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,"ГРАФИК ОТПУСКОВ",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,null,null,null,null,"\"",null,null,null,"\"",null,null,null,null,null,null,null,20,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,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,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,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,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,null,null,null,null,null,"отпуска"]
[1,null,null,null,null,2,null,null,null,null,3,null,null,null,null,null,null,null,4,null,5,null,null,6,null,7,null,null,null,null,8,null,null,null,null,null,null,9,null,null,null,null,10]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Руководитель кадровой службы"]
[null,null,null,null,null,null,null,null,null,null,null,null,"должность",null,null,null,"личная подпись",null,null,null,null,"расшифровка подписи"]

{"sheet":"ближайшие отпуска","index":2,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,8,5,9],[0,4,0,7],[1,8,1,9],[3,8,3,9],[2,8,2,9],[4,8,4,9]]}
["Праздничные дни, которые учитывает таблица",null,null,null,"Сотрудники, до отпуска которых осталось 21 день и меньше",null,null,null,null,"C:\\Users\\Avas\\Desktop\\Вячеслав - макрос отпусков\\Уведомление о начале отпуска.doc"]
["2018-01-01",43101,null,null,"Структурное подразделение","Должность","Сотрудник","Дата начала отпуска","продолжительность отпуска"]
["2018-01-02"]
["2018-01-03"]
["2018-01-04"]
["2018-01-05"]
["2018-01-06"]
["2018-01-07"]
["2018-01-08"]
["2018-02-23"]
["2018-03-08"]
["2018-05-01"]
["2018-05-09"]
["2018-06-12"]
["2018-11-04"]

{"sheet":"сформировать график","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"унифицированная форма (1)","index":4,"n_rows":42,"n_cols":43,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,0,41,11],[41,12,41,14],[41,16,41,18],[41,19,41,20],[41,21,41,40],[41,41,41,42],[37,37,37,41],[38,0,39,42],[40,0,40,11],[40,12,40,14],[40,16,40,18],[40,19,40,20],[40,21,40,40],[40,41,40,42],[36,30,36,36],[36,37,36,41],[37,0,37,4],[37,5,37,9],[37,10,37,17],[37,18,37,19],[37,20,37,22],[37,23,37,24],[37,25,37,29],[37,30,37,36],[35,25,35,29],[35,30,35,36],[35,37,35,41],[36,0,36,4],[36,5,36,9],[36,10,36,17],[36,18,36,19],[36,20,36,22],[36,23,36,24],[36,25,36,29],[35,0,35,4],[35,5,35,9],[35,10,35,17],[35,18,35,19],[35,20,35,22],[35,23,35,24],[33,37,33,41],[34,0,34,4],[34,5,34,9],[34,10,34,17],[34,18,34,19],[34,20,34,22],[34,23,34,24],[34,25,34,29],[34,30,34,36],[34,37,34,41],[32,30,32,36],[32,37,32,41],[33,0,33,4],[33,5,33,9],[33,10,33,17],[33,18,33,19],[33,20,33,22],[33,23,33,24],[33,25,33,29],[33,30,33,36],[31,25,31,29],[31,30,31,36],[31,37,31,41],[32,0,32,4],[32,5,32,9],[32,10,32,17],[32,18,32,19],[32,20,32,22],[32,23,32,24],[32,25,32,29],[31,0,31,4],[31,5,31,9],[31,10,31,17],[31,18,31,19],[31,20,31,22],[31,23,31,24],[29,37,29,41],[30,0,30,4],[30,5,30,9],[30,10,30,17],[30,18,30,19],[30,20,30,22],[30,23,30,24],[30,25,30,29],[30,30,30,36],[30,37,30,41],[28,30,28,36],[28,37,28,41],[29,0,29,4],[29,5,29,9],[29,10,29,17],[29,18,29,19],[29,20,29,22],[29,23,29,24],[29,25,29,29],[29,30,29,36],[27,25,27,29],[27,30,27,36],[27,37,27,41],[28,0,28,4],[28,5,28,9],[28,10,28,17],[28,18,28,19],[28,20,28,22],[28,23,28,24],[28,25,28,29],[27,0,27,4],[27,5,27,9],[27,10,27,17],[27,18,27,19],[27,20,27,22],[27,23,27,24],[25,37,25,41],[26,0,26,4],[26,5,26,9],[26,10,26,17],[26,18,26,19],[26,20,26,22],[26,23,26,24],[26,25,26,29],[26,30,26,36],[26,37,26,41],[24,30,24,36],[24,37,24,41],[25,0,25,4],[25,5,25,9],[25,10,25,17],[25,18,25,19],[25,20,25,22],[25,23,25,24],[25,25,25,29],[25,30,25,36],[23,25,23,29],[23,30,23,36],[23,37,23,41],[24,0,24,4],[24,5,24,9],[24,10,24,17],[24,18,24,19],[24,20,24,22],[24,23,24,24],[24,25,24,29],[22,23,22,24],[22,25,22,29],[22,30,22,36],[22,37,22,41],[23,0,23,4],[23,5,23,9],[23,10,23,17],[23,18,23,19],[23,20,23,22],[23,23,23,24],[20,37,20,41],[21,20,21,22],[21,23,21,24],[21,30,21,36],[21,37,21,41],[22,0,22,4],[22,5,22,9],[22,10,22,17],[22,18,22,19],[22,20,22,22],[18,25,21,29],[18,30,18,36],[18,37,18,41],[19,20,19,22],[19,23,19,24],[19,30,19,36],[19,37,19,41],[20,20,20,22],[20,23,20,24],[20,30,20,36],[16,0,21,4],[16,5,21,9],[16,10,21,17],[16,18,21,19],[16,20,16,41],[17,20,17,22],[17,23,17,29],[17,30,17,41],[18,20,18,22],[18,23,18,24],[14,0,14,13],[14,14,14,26],[14,28,14,30],[14,32,14,38],[14,40,14,41],[15,0,15,42],[12,36,12,42],[13,0,13,13],[13,14,13,16],[13,17,13,21],[13,22,13,23],[13,24,13,25],[13,27,13,34],[13,36,13,42],[11,0,11,13],[11,14,11,26],[11,27,11,33],[11,34,11,42],[12,0,12,13],[12,14,12,16],[12,17,12,21],[12,22,12,23],[12,24,12,25],[12,27,12,34],[10,4,10,5],[10,9,10,10],[10,11,10,12],[10,14,10,26],[10,27,10,33],[10,34,10,42],[7,0,8,32],[7,33,8,37],[7,38,8,42],[9,0,9,13],[9,14,9,26],[9,27,9,42],[5,0,5,28],[5,29,5,37],[5,38,5,42],[6,0,6,32],[6,33,6,37],[6,38,6,42],[0,0,0,42],[1,0,1,42],[2,0,2,42],[3,0,3,42],[4,0,4,37],[4,38,4,42]]}
["Унифицированная форма N Т-7"]
["Утверждена постановлением Госкомстата России"]
["от 05.01.2004 N 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,"Код"]
[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,301020]
["ООО \"Стройкомплект\"",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"УТВЕРЖДАЮ"]
["от","\"",null,"\"",null,null,20,null,"г.","N",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,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,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,null,null,null,null,null,null,null,null,null,null,"\"",null,null,null,"\"",null,null,null,null,null,null,null,20,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,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,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,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,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,null,null,null,null,null,"отпуска"]
[1,null,null,null,null,2,null,null,null,null,3,null,null,null,null,null,null,null,4,null,5,null,null,6,null,7,null,null,null,null,8,null,null,null,null,null,null,9,null,null,null,null,10]
["Администрация",null,null,null,null,"слесарь",null,null,null,null,"Иванов Иван Иванович",null,null,null,null,null,null,null,1,null,28,null,null,"2018-03-05"]
["Секретариат ",null,null,null,null,"администратор",null,null,null,null,"Петров Петр Петрович",null,null,null,null,null,null,null,2,null,28,null,null,"2018-03-05"]
["Бухгалтерия",null,null,null,null,"главный бухгалтер",null,null,null,null,"Сидоров Сидор Сидорович",null,null,null,null,null,null,null,3,null,28,null,null,"2018-03-05"]
["Отдел кадров",null,null,null,null,"специалист ",null,null,null,null,"Романов Роман Романович",null,null,null,null,null,null,null,4,null,28,null,null,"2018-03-05"]
["Производственный отдел",null,null,null,null,"главный инженер",null,null,null,null,"Степанов Степан Степанович",null,null,null,null,null,null,null,7,null,28,null,null,"2018-03-05"]
["Секретариат ",null,null,null,null,"секретарь",null,null,null,null,"Алексеев Алексей Алексеевич",null,null,null,null,null,null,null,8,null,28,null,null,"2018-03-05"]
["Производственный отдел",null,null,null,null,"слесарь",null,null,null,null,"Борисов Борис Борисович",null,null,null,null,null,null,null,9,null,28,null,null,"2018-03-05"]
["Отдел кадров",null,null,null,null,"начальник отдела кадров",null,null,null,null,"Данилов Даниил Даниилович",null,null,null,null,null,null,null,10,null,28,null,null,"2018-03-05"]
["Отдел кадров",null,null,null,null,"специалист ",null,null,null,null,"Захаров Захар Захарович",null,null,null,null,null,null,null,11,null,28,null,null,"2018-03-05"]
["Производственный отдел",null,null,null,null,"сварщик",null,null,null,null,"Федоров Федор Федорович",null,null,null,null,null,null,null,12,null,28,null,null,"2018-03-05"]
["Производственный отдел",null,null,null,null,"слесарь",null,null,null,null,"Павлов Павел Павлович",null,null,null,null,null,null,null,13,null,28,null,null,"2018-03-05"]
["Производственный отдел",null,null,null,null,"сварщик",null,null,null,null,"Максимов Максим Максимович",null,null,null,null,null,null,null,14,null,28,null,null,"2018-03-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,"расшифровка подписи"]

{"sheet":"пересечение отпусков","index":5,"n_rows":15,"n_cols":453,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,65,12,93],[13,65,13,93],[14,65,14,93],[3,65,3,93],[4,65,4,93],[5,65,5,93],[6,65,6,93],[7,65,7,93],[1,92,1,121],[1,122,1,152],[1,153,1,182],[2,61,2,65],[1,2,1,32],[1,33,1,60],[2,28,2,32],[2,2,2,6],[2,33,2,37],[2,56,2,60],[2,87,2,91],[2,92,2,96],[2,122,2,126],[2,153,2,157],[2,117,2,121],[2,148,2,152],[1,183,1,213],[2,183,2,187],[2,178,2,182],[2,209,2,213],[1,426,1,456],[2,367,2,371],[2,393,2,397],[2,398,2,402],[2,421,2,425],[2,426,2,430],[2,452,2,456],[1,214,1,244],[2,214,2,218],[2,240,2,244],[1,245,1,274],[2,270,2,274],[1,367,1,397],[1,398,1,425],[2,301,2,305],[1,306,1,335],[2,306,2,310],[2,331,2,335],[1,336,1,366],[2,336,2,340],[2,362,2,366],[1,275,1,305],[2,275,2,279],[1,61,1,91],[2,245,2,249],[8,65,8,93],[9,65,9,93],[10,65,10,93],[11,65,11,93]]}
[null,null,{"$f":"планировщик!AK4","v":"2018-01-01"},"2017-01-02","2017-01-03","2017-01-04","2017-01-05","2017-01-06","2017-01-07","2017-01-08","2017-01-09","2017-01-10","2017-01-11","2017-01-12","2017-01-13","2017-01-14","2017-01-15","2017-01-16","2017-01-17","2017-01-18","2017-01-19","2017-01-20","2017-01-21","2017-01-22","2017-01-23","2017-01-24","2017-01-25","2017-01-26","2017-01-27","2017-01-28","2017-01-29","2017-01-30","2017-01-31","2017-02-01","2017-02-02","2017-02-03","2017-02-04","2017-02-05","2017-02-06","2017-02-07","2017-02-08","2017-02-09","2017-02-10","2017-02-11","2017-02-12","2017-02-13","2017-02-14","2017-02-15","2017-02-16","2017-02-17","2017-02-18","2017-02-19","2017-02-20","2017-02-21","2017-02-22","2017-02-23","2017-02-24","2017-02-25","2017-02-26","2017-02-27","2017-02-28","2017-03-01","2017-03-02","2017-03-03","2017-03-04","2017-03-05","2017-03-06","2017-03-07","2017-03-08","2017-03-09","2017-03-10","2017-03-11","2017-03-12","2017-03-13","2017-03-14","2017-03-15","2017-03-16","2017-03-17","2017-03-18","2017-03-19","2017-03-20","2017-03-21","2017-03-22","2017-03-23","2017-03-24","2017-03-25","2017-03-26","2017-03-27","2017-03-28","2017-03-29","2017-03-30","2017-03-31","2017-04-01","2017-04-02","2017-04-03","2017-04-04","2017-04-05","2017-04-06","2017-04-07","2017-04-08","2017-04-09","2017-04-10","2017-04-11","2017-04-12","2017-04-13","2017-04-14","2017-04-15","2017-04-16","2017-04-17","2017-04-18","2017-04-19","2017-04-20","2017-04-21","2017-04-22","2017-04-23","2017-04-24","2017-04-25","2017-04-26","2017-04-27","2017-04-28","2017-04-29","2017-04-30","2017-05-01","2017-05-02","2017-05-03","2017-05-04","2017-05-05","2017-05-06","2017-05-07","2017-05-08","2017-05-09","2017-05-10","2017-05-11","2017-05-12","2017-05-13","2017-05-14","2017-05-15","2017-05-16","2017-05-17","2017-05-18","2017-05-19","2017-05-20","2017-05-21","2017-05-22","2017-05-23","2017-05-24","2017-05-25","2017-05-26","2017-05-27","2017-05-28","2017-05-29","2017-05-30","2017-05-31","2017-06-01","2017-06-02","2017-06-03","2017-06-04","2017-06-05","2017-06-06","2017-06-07","2017-06-08","2017-06-09","2017-06-10","2017-06-11","2017-06-12","2017-06-13","2017-06-14","2017-06-15","2017-06-16","2017-06-17","2017-06-18","2017-06-19","2017-06-20","2017-06-21","2017-06-22","2017-06-23","2017-06-24","2017-06-25","2017-06-26","2017-06-27","2017-06-28","2017-06-29","2017-06-30","2017-07-01","2017-07-02","2017-07-03","2017-07-04","2017-07-05","2017-07-06","2017-07-07","2017-07-08","2017-07-09","2017-07-10","2017-07-11","2017-07-12","2017-07-13","2017-07-14","2017-07-15","2017-07-16","2017-07-17","2017-07-18","2017-07-19","2017-07-20","2017-07-21","2017-07-22","2017-07-23","2017-07-24","2017-07-25","2017-07-26","2017-07-27","2017-07-28","2017-07-29","2017-07-30","2017-07-31","2017-08-01","2017-08-02","2017-08-03","2017-08-04","2017-08-05","2017-08-06","2017-08-07","2017-08-08","2017-08-09","2017-08-10","2017-08-11","2017-08-12","2017-08-13","2017-08-14","2017-08-15","2017-08-16","2017-08-17","2017-08-18","2017-08-19","2017-08-20","2017-08-21","2017-08-22","2017-08-23","2017-08-24","2017-08-25","2017-08-26","2017-08-27","2017-08-28","2017-08-29","2017-08-30","2017-08-31","2017-09-01","2017-09-02","2017-09-03","2017-09-04","2017-09-05","2017-09-06","2017-09-07","2017-09-08","2017-09-09","2017-09-10","2017-09-11"]
[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,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,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,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,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,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,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,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,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,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,31,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,28,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,31,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,30,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,31,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,30,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,30,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,31,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,30,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,31,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,30,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,31,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,31,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,28,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,31]
["Иванов Иван Иванович","слесарь",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"28 дней"]
["Петров Петр Петрович","администратор",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"28 дней"]
["Сидоров Сидор Сидорович","главный бухгалтер",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"28 дней"]
["Романов Роман Романович","специалист ",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"28 дней"]
["Степанов Степан Степанович","главный инженер",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"28 дней"]
["Алексеев Алексей Алексеевич","секретарь",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"28 дней"]
["Борисов Борис Борисович","слесарь",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"28 дней"]
["Данилов Даниил Даниилович","начальник отдела кадров",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"28 дней"]
["Захаров Захар Захарович","специалист ",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"28 дней"]
["Федоров Федор Федорович","сварщик",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"28 дней"]
["Павлов Павел Павлович","слесарь",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"28 дней"]
["Максимов Максим Максимович","сварщик",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"28 дней"]