{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["планировщик","сформировать график","ближайшие отпуска","унифицированная форма (3)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":12,"n_cols":54,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,52,2,53],[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],[11,9,12,9],[11,13,12,13],[11,17,12,17],[11,21,12,21],[11,25,12,25],[11,29,12,29],[7,17,8,17],[5,13,6,13],[5,17,6,17],[6,14,6,16],[6,18,6,20],[6,30,6,32],[5,21,6,21],[5,25,6,25],[5,29,6,29],[3,10,3,13],[8,26,8,28],[8,30,8,32],[7,13,8,13],[3,4,4,4],[3,3,4,3],[3,6,3,9],[3,5,4,5],[3,30,3,33],[3,22,3,25],[3,26,3,29],[6,10,6,12],[5,33,6,33],[6,26,6,28],[3,14,3,17],[3,18,3,21],[6,22,6,24],[11,0,12,0],[11,1,12,1],[9,0,10,0],[5,34,6,34],[7,25,8,25],[7,2,8,2],[7,21,8,21],[7,29,8,29],[7,33,8,33],[6,6,6,8],[5,2,6,2],[7,34,8,34],[8,10,8,12],[8,14,8,16],[8,18,8,20],[8,22,8,24],[0,0,1,4],[5,9,6,9],[8,6,8,8],[7,9,8,9],[3,0,4,0],[5,0,6,0],[5,3,6,3],[5,1,6,1],[7,0,8,0],[7,1,8,1],[3,1,4,1],[3,2,4,2],[9,1,10,1],[7,4,8,4],[5,4,6,4],[11,4,12,4],[7,5,8,5],[5,5,6,5],[11,5,12,5],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,10,5],[7,3,8,3],[11,3,12,3],[11,2,12,2],[9,9,10,9],[9,29,10,29],[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,13,10,13],[9,17,10,17],[9,21,10,21],[9,25,10,25]]}
[]
[]
["Наименование организации","ООО \"PPT.ru\"","Начальник отдела кадров","Пэпэтэшин П.П.","Должность руководителя организации","Генеральный директор","ФИО руководителя организации","Петров П.П.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Для диаграммы",null,null,null,null,null,null,null,null,null,null,null,null,null,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,3,"генеральный директор",28,"2025-02-03",28,"2025-03-03",{"$f":"IF(G6=\"\",\"\",G6-14)","v":"2025-01-20"},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":2590},{"$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,0]
[null,null,null,null,null,null,"кол-во дней отпуска авансом: 0"]
["Отдел кадров","Пэпэтэшин П.П.",null,15,"начальник отдела кадров",28,"2025-05-19",13,"2025-05-31","2025-05-05","2025-11-05",15,"2025-11-19","2025-10-22",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":2695},{"$f":"I8-G8","v":12},{"$f":"IF(K8=\"\",\"\",K8-I8)","v":158},{"$f":"IF(M8=\"\",\"\",M8-K8)","v":14},{"$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,null,null,"кол-во дней отпуска авансом: 0"]
["Бухгалтерия","Смирнова В.Ф.",null,44,"главный бухгалтер",28,"2025-03-10",14,"2025-03-23",{"$f":"IF(G10=\"\",\"\",G10-14)","v":"2025-02-24"},"2025-06-16",14,"2025-06-29",{"$f":"IF(K10=\"\",\"\",K10-14)","v":"2025-06-02"},null,null,null,{"$f":"IF(O10=\"\",\"\",O10-14)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H10+L10+P10+T10","v":28},null,{"$f":"G10-$AK$4","v":2625},{"$f":"I10-G10","v":13},{"$f":"IF(K10=\"\",\"\",K10-I10)","v":85},{"$f":"IF(M10=\"\",\"\",M10-K10)","v":13},{"$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,null,null,"кол-во дней отпуска авансом: 0"]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"G12-$AK$4","v":-43101},{"$f":"I12-G12","v":0},{"$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":""}]

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

{"sheet":"ближайшие отпуска","index":2,"n_rows":15,"n_cols":9,"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 день и меньше"]
["2025-01-01",null,null,null,"Структурное подразделение","Должность","Сотрудник","Дата начала отпуска","продолжительность отпуска"]
["2025-01-02"]
["2025-01-03"]
["2025-01-04"]
["2025-01-05"]
["2025-01-06"]
["2025-01-07"]
["2025-01-08"]
["2025-02-23"]
["2025-03-08"]
["2025-05-01"]
["2025-05-09"]
["2025-06-12"]
["2025-11-04"]

{"sheet":"унифицированная форма (3)","index":3,"n_rows":38,"n_cols":43,"rows_kept":38,"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],[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],[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],[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],[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],[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,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],[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],[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],[31,25,31,29],[31,30,31,36],[31,37,31,41],[31,0,31,4],[31,5,31,9],[31,10,31,17],[31,18,31,19],[31,20,31,22],[31,23,31,24],[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],[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],[37,0,37,11],[37,12,37,14],[37,16,37,18],[37,19,37,20],[37,21,37,40],[37,41,37,42],[33,37,33,41],[34,0,35,42],[36,0,36,11],[36,12,36,14],[36,16,36,18],[36,19,36,20],[36,21,36,40],[36,41,36,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]
["ООО \"PPT.ru\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"по ОКПО"]
["наименование организации"]
[]
["Мнение выборного профсоюзного органа",null,null,null,null,null,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,3,null,28,null,null,"2025-02-03"]
["Отдел кадров",null,null,null,null,"начальник отдела кадров",null,null,null,null,"Пэпэтэшин П.П.",null,null,null,null,null,null,null,15,null,13,null,null,"2025-05-19"]
["Отдел кадров",null,null,null,null,"начальник отдела кадров",null,null,null,null,"Пэпэтэшин П.П.",null,null,null,null,null,null,null,15,null,15,null,null,"2025-11-05"]
["Бухгалтерия",null,null,null,null,"главный бухгалтер",null,null,null,null,"Смирнова В.Ф.",null,null,null,null,null,null,null,44,null,14,null,null,"2025-03-10"]
["Бухгалтерия",null,null,null,null,"главный бухгалтер",null,null,null,null,"Смирнова В.Ф.",null,null,null,null,null,null,null,44,null,14,null,null,"2025-06-16"]
[]
[]
[]
[]
[]
[]
[]
[]
["Начальник отдела кадров",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Пэпэтэшин П.П."]
[null,null,null,null,null,null,null,null,null,null,null,null,"должность",null,null,null,"личная подпись",null,null,null,null,"расшифровка подписи"]