{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Табель","График отпусков","Праздники"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"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":56,"rows_kept":29,"cut":false,"hidden":false,"merged":[[9,42,9,50],[5,50,7,50],[5,43,5,45],[5,49,7,49],[5,0,7,0],[5,1,7,1],[5,2,7,2],[5,3,6,33],[5,47,5,48],[5,46,7,46],[5,42,7,42],[6,43,7,43],[6,44,6,45],[6,47,7,47],[6,48,7,48],[5,34,6,41],[8,34,8,41],[9,34,9,41],[9,3,9,33],[2,8,2,25],[3,10,3,16],[3,17,3,19],[3,20,3,21],[8,3,8,33]]}
[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,{"$f":"MAX(INDEX(#REF!,MATCH($A$10,#REF!,0)):INDEX(#REF!,1000))","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,"График работы персонала"]
[null,null,null,null,null,null,null,null,null,null,"участка связи № 5 НЦС на",null,null,null,null,null,null,"Февраль",null,null,2021,null,"г."]
[]
["Фамилия Имя Отчество","Табельный номер","Профессия/ Должность","Календарные дни месяца",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Следующий месяц",null,null,null,null,null,null,null,"Норма по календарю","Часы работы за месяц",null,null,"ОТ, ПМ,Б, У","Отклонение от нормы",null,"Норма по ПФРВ","Средне-месячная норма"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"всего по графику","из них",null,null,"за месяц","с начала учет. периода"]
[null,null,null,{"$f":"--(\"1-\"&R4&U4)","v":"2021-02-01"},{"$f":"D8+1","v":"2021-02-02"},{"$f":"E8+1","v":"2021-02-03"},"2021-02-04","2021-02-05","2021-02-06","2021-02-07","2021-02-08","2021-02-09","2021-02-10","2021-02-11","2021-02-12","2021-02-13","2021-02-14","2021-02-15","2021-02-16","2021-02-17","2021-02-18","2021-02-19","2021-02-20","2021-02-21","2021-02-22","2021-02-23","2021-02-24","2021-02-25","2021-02-26","2021-02-27","2021-02-28",{"$f":"IF(MONTH(AE8+1)<>MONTH($D8),\"х\",AE8+1)","v":"х"},{"$f":"IF(MONTH(AE8+2)<>MONTH($D8),\"х\",AE8+2)","v":"х"},{"$f":"IF(MONTH(AE8+3)<>MONTH($D8),\"х\",AE8+3)","v":"х"},{"$f":"EDATE(D8,1)","v":"2021-03-01"},{"$f":"EDATE(E8,1)","v":"2021-03-02"},"2021-03-03","2021-03-04","2021-03-05","2021-03-06","2021-03-07","2021-03-08",null,null,"ночных","праздничных"]
[1,2,3,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,6,7,8,9,10,11,12,13]
[{"$f":"R4","v":"Февраль"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(AI8,\"ММММ\")","v":"Март"}]
[null,1902910,{"$f":"IFERROR(VLOOKUP(B11,#REF!,3,0),\"\")","v":""},10,10,10,10,10,10,10,8,"ПП","в","в","в","в","в","в","в","в","в","в","в","в","ПП",8,10,10,10,10,10,null,null,null,null,null,null,null,null,null,null,null,151,136,0,8,0,-28.340000000000003,-54.680000000000007,164.34,164.34]
[null,1904068,{"$f":"IFERROR(VLOOKUP(B12,#REF!,3,0),\"\")","v":""},11,11,11,11,11,11,11,11,11,11,11,11,11,11,10,"ПП","в","в","в","в","в","в","в","в","в","в","в","в",null,null,null,null,null,null,null,null,null,null,null,151,164,0,0,0,-0.34000000000000341,-0.68000000000000682,164.34,164.34]
[null,1915704,{"$f":"IFERROR(VLOOKUP(B13,#REF!,3,0),\"\")","v":""},11.5,11.5,11.5,11.5,11.5,11.5,11.5,11.5,11.5,11.5,4,"7,5/4","7,5/4","7,5/4","7,5/4",7.5,"ПП","в","в","в","в","в","в","в","в","в","в","в",null,null,null,null,null,null,null,null,null,null,null,151,172.5,40,0,0,8.1599999999999966,4.8199999999999932,164.34,164.34]
[null,1915436,{"$f":"IFERROR(VLOOKUP(B14,#REF!,3,0),\"\")","v":""},4,"7,5/4","7,5/4","7,5/4","7,5/4",7.5,11.5,11.5,11.5,11.5,11,11,11,11,11,11,"ПП","в","в","в","в","в","в","в","в","в","в","в",null,null,null,null,null,null,null,null,null,null,null,151,169.5,40,0,0,5.1599999999999966,1.8199999999999932,164.34,164.34]
[null,1912510,{"$f":"IFERROR(VLOOKUP(B15,#REF!,3,0),\"\")","v":""},11,11,11,11,11,4,"7,5/4","7,5/4","7,5/4","7,5/4",7.5,11,11,11,7.9,"ПП","в","в","в","в","в","в","в","в","в","в","в","в",null,null,null,null,null,null,null,null,null,null,null,135.80000000000001,153.4,40,0,0,5.539999999999992,11.179999999999978,147.86000000000001,147.86000000000001]
[null,1912622,{"$f":"IFERROR(VLOOKUP(B16,#REF!,3,0),\"\")","v":""},11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,"ПП","в","в","в","в","в","в","в","в","в","в","в","в",null,null,null,null,null,null,null,null,null,null,null,151,165,0,0,0,0.65999999999999659,1.3199999999999932,164.34,164.34]
[null,1912114,{"$f":"IFERROR(VLOOKUP(B17,#REF!,3,0),\"\")","v":""},11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,"ПП","в","в","в","в","в","в","в","в","в","в","в","в",null,null,null,null,null,null,null,null,null,null,null,151,165,0,0,0,0.65999999999999659,0.81999999999999318,164.34,164.34]
[null,1925206,{"$f":"IFERROR(VLOOKUP(B18,#REF!,3,0),\"\")","v":""},10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,"ПП","в","в","в","в","в","в","в","в","в","в","в","в",null,null,null,null,null,null,null,null,null,null,null,135.80000000000001,150,0,0,0,2.1399999999999864,8.2799999999999727,147.86000000000001,147.86000000000001]
[null,1904059,{"$f":"IFERROR(VLOOKUP(B19,#REF!,3,0),\"\")","v":""},"в","в","в","в","в","в","ПП",8,11,11,11,11,11,11,11,11,11,10,11,11,11,11,8,"ПП","в","в","в","в",null,null,null,null,null,null,null,null,null,null,null,151,169,0,8,0,4.6599999999999966,8.3199999999999932,164.34,164.34]
[null,1912045,{"$f":"IFERROR(VLOOKUP(B20,#REF!,3,0),\"\")","v":""},"От","От","От","От","От","От","в","в","в","в","в","в","в","в","в","ПП",10,10,10,10,4,"7,5/4","7,5/4","7,5/4","7,5/4",7.5,10,10,null,null,null,null,null,null,null,null,null,null,null,135.80000000000001,117.5,40,11.5,36,5.6399999999999864,11.779999999999973,111.86000000000001,147.86000000000001]
[null,1912130,{"$f":"IFERROR(VLOOKUP(B21,#REF!,3,0),\"\")","v":""},"ПП","в","в","в","в","в","в","в","в","в","в","в","в","ПП",4,"7,5/4","7,5/4","7,5/4","7,5/4","7,5/4",7.5,10,10,10,10,10,10,10,null,null,null,null,null,null,null,null,null,null,null,151,139,48,10,0,-25.340000000000003,-18.180000000000007,164.34,164.34]
[null,1914551,{"$f":"IFERROR(VLOOKUP(B22,#REF!,3,0),\"\")","v":""},7.5,"ПП","в","в","в","в","в","в","в","в","в","в","в","в","ПП",10,10,10,10,10,10,10,10,10,10,4,"7,5/4","7,5/4",null,null,null,null,null,null,null,null,null,null,null,151,134.5,24,10,0,-29.840000000000003,-26.680000000000007,164.34,164.34]
[null,1912044,{"$f":"IFERROR(VLOOKUP(B23,#REF!,3,0),\"\")","v":""},"ПП","в","в","в","в","в","в","в","в","в","в","в","в","в","в","ПП",11,10,10,10,10,10,10,10,10,10,10,10,null,null,null,null,null,null,null,null,null,null,null,135.80000000000001,121,0,10,0,-26.860000000000014,-21.720000000000027,147.86000000000001,147.86000000000001]
[null,1927879,{"$f":"IFERROR(VLOOKUP(B24,#REF!,3,0),\"\")","v":""},"ПП","в","в","в","в","в","в","в","в","в","в","в","в","в","ПП",11.5,11,11,11,11,11,11,11,11,11,11,11,11,null,null,null,null,null,null,null,null,null,null,null,151,143.5,0,11,0,-20.840000000000003,-9.1800000000000068,164.34,164.34]
[null,1912037,{"$f":"IFERROR(VLOOKUP(B25,#REF!,3,0),\"\")","v":""},"ПП","в","в","в","в","в","в","в","в","в","в","в","в","в","ПП",8,11,11,11,11,11,11,11,11,11,11,11,11,null,null,null,null,null,null,null,null,null,null,null,151,140,0,11,0,-24.340000000000003,-18.680000000000007,164.34,164.34]
[null,1913850,{"$f":"IFERROR(VLOOKUP(B26,#REF!,3,0),\"\")","v":""},"ПП","в","в","в","в","в","в","в","в","в","в","в","в","в","в","ПП",10,10,10,10,10,10,10,10,10,10,10,10,null,null,null,null,null,null,null,null,null,null,null,135.80000000000001,120,0,10,0,-27.860000000000014,-25.720000000000027,147.86000000000001,147.86000000000001]
[]
[]
[null,null,null,11.5]

{"sheet":"График отпусков","index":1,"n_rows":23,"n_cols":54,"rows_kept":23,"cut":false,"hidden":true,"merged":[[4,97,4,98],[5,0,6,2],[5,3,6,5],[5,6,6,56],[4,29,4,32],[4,33,4,36],[4,37,4,40],[4,41,4,44],[4,45,4,48],[4,49,4,52],[4,25,4,28],[4,53,4,56],[3,3,3,5],[4,9,4,12],[4,13,4,16],[4,17,4,20],[4,21,4,24],[2,103,4,103],[0,9,0,49],[1,0,1,8],[1,9,1,49],[1,51,1,56],[2,0,2,5],[2,6,4,6],[2,8,4,8],[2,9,3,56],[3,0,3,2],[2,85,2,86],[2,87,2,93],[2,94,4,94],[2,95,2,101],[2,102,4,102],[2,7,4,7]]}
[null,null,null,null,null,null,null,null,null,"График отпусков участка связи №5  НЦС на  2021год "]
[]
["Отпуск",null,null,null,null,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,"декабрь"]
[]
[]
[52,"2021-06-22",{"$f":"ОТПУСК(B8,A8,Праздники)","v":{"$error":"#NAME?"}},null,null,{"$f":"ОТПУСК(E8,D8,Праздники)","v":{"$error":"#NAME?"}},{"$f":"IFERROR(INDEX(_Фамилия,MATCH(H8,_ТабНом,0)),\"\")","v":""},{"$f":"Табель!B11","v":1902910},{"$f":"IFERROR(VLOOKUP(H8,#REF!,3,0),\"\")","v":""}]
[52,"2021-05-01",{"$error":"#NAME?"},null,null,{"$f":"ОТПУСК(E9,D9,Праздники)","v":{"$error":"#NAME?"}},"",{"$f":"Табель!B12","v":1904068},{"$f":"IFERROR(VLOOKUP(H9,#REF!,3,0),\"\")","v":""}]
[52,"2021-05-01",{"$error":"#NAME?"},null,null,{"$error":"#NAME?"},"",{"$f":"Табель!B13","v":1915704},{"$f":"IFERROR(VLOOKUP(H10,#REF!,3,0),\"\")","v":""}]
[52,"2021-02-01",{"$error":"#NAME?"},null,null,{"$error":"#NAME?"},"",{"$f":"Табель!B14","v":1915436},{"$f":"IFERROR(VLOOKUP(H11,#REF!,3,0),\"\")","v":""}]
[52,"2021-10-01",{"$error":"#NAME?"},null,null,{"$error":"#NAME?"},"",{"$f":"Табель!B15","v":1912510},{"$f":"IFERROR(VLOOKUP(H12,#REF!,3,0),\"\")","v":""}]
[52,"2021-06-01",{"$error":"#NAME?"},null,null,{"$error":"#NAME?"},"",{"$f":"Табель!B16","v":1912622},{"$f":"IFERROR(VLOOKUP(H13,#REF!,3,0),\"\")","v":""}]
[52,"2021-08-01",{"$error":"#NAME?"},null,null,{"$error":"#NAME?"},"",{"$f":"Табель!B17","v":1912114},{"$f":"IFERROR(VLOOKUP(H14,#REF!,3,0),\"\")","v":""}]
[52,"2021-08-01",{"$error":"#NAME?"},null,null,{"$f":"ОТПУСК(E15,D15,Праздники)","v":{"$error":"#NAME?"}},"",{"$f":"Табель!B18","v":1925206},{"$f":"IFERROR(VLOOKUP(H15,#REF!,3,0),\"\")","v":""}]
[52,"2021-08-08",{"$error":"#NAME?"},null,null,{"$error":"#NAME?"},{"$f":"IFERROR(INDEX(_Фамилия,MATCH(H16,_ТабНом,0)),\"\")","v":""},{"$f":"Табель!B19","v":1904059},{"$f":"IFERROR(VLOOKUP(H16,#REF!,3,0),\"\")","v":""}]
[52,"2021-10-15",{"$error":"#NAME?"},null,null,{"$error":"#NAME?"},"",{"$f":"Табель!B20","v":1912045},{"$f":"IFERROR(VLOOKUP(H17,#REF!,3,0),\"\")","v":""}]
[52,"2021-06-15",{"$f":"ОТПУСК(B18,A18,Праздники)","v":{"$error":"#NAME?"}},null,null,{"$error":"#NAME?"},"",{"$f":"Табель!B21","v":1912130},{"$f":"IFERROR(VLOOKUP(H18,#REF!,3,0),\"\")","v":""}]
[52,"2021-08-15",{"$error":"#NAME?"},null,null,{"$error":"#NAME?"},"",{"$f":"Табель!B22","v":1914551},{"$f":"IFERROR(VLOOKUP(H19,#REF!,3,0),\"\")","v":""}]
[52,"2021-06-15",{"$error":"#NAME?"},null,null,{"$error":"#NAME?"},"",{"$f":"Табель!B23","v":1912044},{"$f":"IFERROR(VLOOKUP(H20,#REF!,3,0),\"\")","v":""}]
[40,"2021-05-15",{"$error":"#NAME?"},null,null,{"$error":"#NAME?"},"",{"$f":"Табель!B24","v":1927879},{"$f":"IFERROR(VLOOKUP(H21,#REF!,3,0),\"\")","v":""}]
[52,"2021-08-15",{"$error":"#NAME?"},null,null,{"$error":"#NAME?"},"",{"$f":"Табель!B25","v":1912037},{"$f":"IFERROR(VLOOKUP(H22,#REF!,3,0),\"\")","v":""}]
[52,"2021-08-15",{"$error":"#NAME?"},null,null,{"$error":"#NAME?"},"",{"$f":"Табель!B26","v":1913850},{"$f":"IFERROR(VLOOKUP(H23,#REF!,3,0),\"\")","v":""}]

{"sheet":"Праздники","index":2,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Месяц","Число","Год","Наименование праздников","Предпраздничные сокращенные дни","Нерабочий праздничный день","Перенесенные выходные дни","Рабочие выходные ","Норма муж. по календарю","Норма жен. по календарю","Норма муж.","Норма жен."]
[null,null,null,null,"Январь",1,2019,"Новый год",null,"2021-01-01",null,null,120,108,164.34,147.86000000000001]
[null,null,null,null,"Февраль",2,2020,"Новый год",null,"2021-01-02",null,null,151,135.80000000000001,164.34,147.86000000000001]
[null,null,null,null,"Март",3,2021,"Новый год",null,"2021-01-03",null,null,176,158.4,164.34,147.86000000000001]
[null,null,null,null,"Апрель",4,2022,"Новый год",null,"2021-01-04",null,null,175,157.4,164.34,147.86000000000001]
[null,null,null,null,"Май",5,2023,"Новый год",null,"2021-01-05",null,null,152,136.80000000000001,164.33,147.87]
[null,null,null,null,"Июнь",6,2024,"Новый год",null,"2021-01-06",null,null,167,150.19999999999999,164.33,147.87]
[null,null,null,null,"Июль",7,2025,"Рождество",null,"2021-01-07",null,null,176,158.4,164.33,147.87]
[null,null,null,null,"Август",8,2026,"Новый год",null,"2021-01-08",null,null,176,158.4,164.33,147.87]
[null,null,null,null,"Сентябрь",9,2027,"Защитник","2021-02-20","2021-02-23","2021-02-22",null,176,158.4,164.33,147.87]
[null,null,null,null,"Октябрь",10,2028,"Международный",null,"2021-03-08",null,null,168,151.19999999999999,164.33,147.87]
[null,null,null,null,"Ноябрь",11,2029,"Международный",null,null,null,null,159,143,164.33,147.87]
[null,null,null,null,"Декабрь",12,2030,null,"2021-04-30",null,null,null,176,158.4,164.33,147.87]
[null,null,null,null,null,null,null,"Весна и труд",null,"2021-05-01","2021-05-03"]
[null,null,null,null,null,null,null,"Весна и труд"]
[null,null,null,null,null,null,null,"День Победы","2021-05-08","2021-05-09","2021-05-10"]
[null,null,null,null,null,null,null,"День России"]
[null,null,null,null,null,null,null,"День России","2021-06-11","2021-06-12","2021-06-14"]
[null,null,null,null,null,null,null,"День единства","2021-11-03","2021-11-04","2021-11-05"]
[null,null,null,null,null,null,null,"Новый год",null,null,"2021-12-31"]
[null,null,null,null,null,null,null,null,null,null,null,"Итого",1971.9999999999998,1774.3999999999996,1972,1774.4000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,164.33333333333334,147.8666666666667]