{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Табель","Календарь","Names","Коды"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":33,"comments":2,"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":329,"n_cols":62,"rows_kept":329,"cut":false,"hidden":false,"merged":[[279,36,280,36],[279,37,280,37],[279,38,280,38],[279,39,280,39],[279,40,280,40],[231,36,232,36],[231,37,232,37],[231,38,232,38],[231,39,232,39],[231,40,232,40],[254,36,255,36],[254,37,255,37],[254,38,255,38],[254,39,255,39],[254,40,255,40],[185,36,186,36],[185,37,186,37],[185,38,186,38],[185,39,186,39],[185,40,186,40],[208,36,209,36],[208,37,209,37],[208,38,209,38],[208,39,209,39],[208,40,209,40],[139,36,140,36],[139,37,140,37],[139,38,140,38],[139,39,140,39],[139,40,140,40],[162,36,163,36],[162,37,163,37],[162,38,163,38],[162,39,163,39],[162,40,163,40],[93,37,94,37],[93,38,94,38],[93,39,94,39],[93,40,94,40],[116,36,117,36],[116,37,117,37],[116,38,117,38],[116,39,117,39],[116,40,117,40],[47,39,48,39],[47,40,48,40],[70,36,71,36],[70,37,71,37],[70,38,71,38],[70,39,71,39],[70,40,71,40],[1,39,2,39],[1,40,2,40],[24,36,25,36],[24,37,25,37],[24,38,25,38],[24,39,25,39],[24,40,25,40],[279,1,280,1],[279,2,280,2],[279,3,280,3],[1,36,2,36],[1,37,2,37],[1,38,2,38],[47,36,48,36],[47,37,48,37],[47,38,48,38],[93,36,94,36],[231,1,232,1],[231,2,232,2],[231,3,232,3],[254,1,255,1],[254,2,255,2],[254,3,255,3],[185,1,186,1],[185,2,186,2],[185,3,186,3],[208,1,209,1],[208,2,209,2],[208,3,209,3],[139,1,140,1],[139,2,140,2],[139,3,140,3],[162,1,163,1],[162,2,163,2],[162,3,163,3],[93,1,94,1],[93,2,94,2],[93,3,94,3],[116,1,117,1],[116,2,117,2],[116,3,117,3],[47,1,48,1],[47,2,48,2],[47,3,48,3],[70,1,71,1],[70,2,71,2],[70,3,71,3],[1,1,2,1],[1,2,2,2],[1,3,2,3],[24,1,25,1],[24,2,25,2],[24,3,25,3]]}
[null,null,null,2025,{"$f":"IF(E2=TODAY(),МЕТКА,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","❶","ИТОГИ","ИТОГО за месяц",null,null,null,"❷","ОТЧЁТ за месяц",{"$f":"M$306","v":"В"},{"$f":"N$306","v":"ОТ"},"ДО","Б","НН","ПР","К","НОД","У",{"$f":"V$306","v":"ОЗ"},{"$f":"W$306","v":"Г"},"⓿","Метка:","↓"]
[null,"График",1,{"$f":"DATE(ГОД,C2,1)","v":"2025-01-01"},{"$f":"DATE(ГОД,C2,DAY(D2))","v":"2025-01-01"},{"$f":"IF(N(E2),IF(MONTH(E2+1)=$C2,E2+1,\"\"),\"\")","v":"2025-01-02"},"2025-01-03","2025-01-04","2025-01-05","2025-01-06","2025-01-07","2025-01-08","2025-01-09","2025-01-10","2025-01-11","2025-01-12","2025-01-13","2025-01-14","2025-01-15","2025-01-16","2025-01-17","2025-01-18","2025-01-19","2025-01-20","2025-01-21","2025-01-22","2025-01-23","2025-01-24","2025-01-25","2025-01-26","2025-01-27","2025-01-28","2025-01-29","2025-01-30",{"$f":"IF(N(AH2),IF(MONTH(AH2+1)=$C2,AH2+1,\"\"),\"\")","v":"2025-01-31"},null,"Не раб. дней","Раб. дней","Раб. час","Отпуск ПЛАН","Отгуляно на СЕГОДНЯ",null,{"$f":"$AQ$1","v":"ОТЧЁТ за месяц"}]
[{"$f":"DATE(ГОД,C2,1)","v":"2025-01-01"},null,null,null,{"$f":"E2","v":"2025-01-01"},"2025-01-02","2025-01-03","2025-01-04","2025-01-05","2025-01-06","2025-01-07","2025-01-08","2025-01-09","2025-01-10","2025-01-11","2025-01-12","2025-01-13","2025-01-14","2025-01-15","2025-01-16","2025-01-17","2025-01-18","2025-01-19","2025-01-20","2025-01-21","2025-01-22","2025-01-23","2025-01-24","2025-01-25","2025-01-26","2025-01-27","2025-01-28",{"$f":"AG2","v":"2025-01-29"},{"$f":"AH2","v":"2025-01-30"},{"$f":"AI2","v":"2025-01-31"},null,null,null,null,null,null,null,{"$f":"DATE(ГОД,C2,1)","v":"2025-01-01"},{"$f":"M$306","v":"В"},"ОТ","ДО","Б","НН","ПР","К","НОД","У","ОЗ","Г"]
[{"$f":"OFFSET(A4,-1,0)","v":"2025-01-01"},"4А",{"$f":"N(OFFSET(C4,-1,0))+1","v":1},"Алёхин А.А.",8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,{"$f":"SUM(- - ISTEXT(E4:AI4))","v":16},{"$f":"COUNT(E4:AI4)","v":15},{"$f":"SUM(E4:AI4)","v":158.5},{"$f":"COUNTIF(E4:AI4,\"ОТ\")","v":0},{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$2,0,IF(MONTH(TODAY())>$C$2,AN4,COUNTIF(OFFSET(E4,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,{"$f":"D4","v":"Алёхин А.А."},{"$f":"COUNTIF($E4:$AI4,M$306)","v":16},0,0,0,0,0,0,0,0,0,0]
[{"$f":"OFFSET(A5,-1,0)","v":"2025-01-01"},"4А",{"$f":"N(OFFSET(C5,-1,0))+1","v":2},"Борисов В.В.",8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,{"$f":"SUM(- - ISTEXT(E5:AI5))","v":16},{"$f":"COUNT(E5:AI5)","v":15},{"$f":"SUM(E5:AI5)","v":158.5},{"$f":"COUNTIF(E5:AI5,\"ОТ\")","v":0},0,null,{"$f":"D5","v":"Борисов В.В."},16,0,0,0,0,0,0,0,0,0,0]
["2025-01-01","4Б",3,"Володин В.В.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В",null,{"$f":"SUM(- - ISTEXT(E6:AI6))","v":15},16,172,{"$f":"COUNTIF(E6:AI6,\"ОТ\")","v":0},0,null,"Володин В.В.",15,0,0,0,0,0,0,0,0,0,0]
["2025-01-01","4Б",4,"Гаврилов Г.Г.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В",null,{"$f":"SUM(- - ISTEXT(E7:AI7))","v":15},16,172,{"$f":"COUNTIF(E7:AI7,\"ОТ\")","v":0},0,null,"Гаврилов Г.Г.",15,0,0,0,0,0,0,0,0,0,0]
["2025-01-01","4В",5,"Данилов Д.Д.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,null,{"$f":"SUM(- - ISTEXT(E8:AI8))","v":15},16,172,{"$f":"COUNTIF(E8:AI8,\"ОТ\")","v":0},0,null,"Данилов Д.Д.",15,0,0,0,0,0,0,0,0,0,0]
["2025-01-01","4В",6,"Ежов Е.Е.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,null,{"$f":"SUM(- - ISTEXT(E9:AI9))","v":15},16,172,0,0,null,"Ежов Е.Е.",15,0,0,0,0,0,0,0,0,0,0]
["2025-01-01","4Г",7,"Зуев З.З.","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,{"$f":"SUM(- - ISTEXT(E10:AI10))","v":16},15,164,0,0,null,"Зуев З.З.",16,0,0,0,0,0,0,0,0,0,0]
["2025-01-01","4Г",8,"Иванов И.И.","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,{"$f":"SUM(- - ISTEXT(E11:AI11))","v":16},15,164,0,0,null,"Иванов И.И.",16,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,9,"Козлов К.К.","В","В","В","В","В","В","В","В",8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,{"$f":"SUM(- - ISTEXT(E12:AI12))","v":14},17,135.25,0,0,null,"Козлов К.К.",14,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,10,"Львов Л.Л.","В","В","В","В","В","В","В","В",8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,{"$f":"SUM(- - ISTEXT(E13:AI13))","v":14},17,135.25,0,0,null,"Львов Л.Л.",14,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,11,"Мишин М.М.","В","В","В","В","В","В","В","В",8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,{"$f":"SUM(- - ISTEXT(E14:AI14))","v":14},17,135.25,0,0,null,"Мишин М.М.",14,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,12,"Носов Н.Н.","В","В","В","В","В","В","В","В",8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,{"$f":"SUM(- - ISTEXT(E15:AI15))","v":14},{"$f":"COUNT(E15:AI15)","v":17},135.25,0,0,null,"Носов Н.Н.",14,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,13,"Осин О.О.","В","В","В","В","В","В","В","В",8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,{"$f":"SUM(- - ISTEXT(E16:AI16))","v":14},17,135.25,0,0,null,"Осин О.О.",14,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,14,"Попов П.П.","В","В","В","В","В","В","В","В",8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,{"$f":"SUM(- - ISTEXT(E17:AI17))","v":14},17,135.25,0,0,null,"Попов П.П.",14,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,15,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E18:AI18))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,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,{"$f":"SUM(- - ISTEXT(E19:AI19))","v":0},0,{"$f":"SUM(E19:AI19)","v":0},{"$f":"COUNTIF(E19:AI19,\"ОТ\")","v":0},0,null,{"$f":"D19","v":0},0,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,17,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E20:AI20))","v":0},0,{"$f":"SUM(E20:AI20)","v":0},{"$f":"COUNTIF(E20:AI20,\"ОТ\")","v":0},0,null,{"$f":"D20","v":0},0,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,18,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E21:AI21))","v":0},0,{"$f":"SUM(E21:AI21)","v":0},{"$f":"COUNTIF(E21:AI21,\"ОТ\")","v":0},0,null,{"$f":"D21","v":0},0,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,19,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E22:AI22))","v":0},0,{"$f":"SUM(E22:AI22)","v":0},{"$f":"COUNTIF(E22:AI22,\"ОТ\")","v":0},0,null,{"$f":"D22","v":0},0,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,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,{"$f":"SUM(- - ISTEXT(E23:AI23))","v":0},0,{"$f":"SUM(E23:AI23)","v":0},{"$f":"COUNTIF(E23:AI23,\"ОТ\")","v":0},0,null,{"$f":"D23","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"IF(E25=TODAY(),МЕТКА,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"График",2,{"$f":"DATE(ГОД,C25,1)","v":"2025-02-01"},{"$f":"DATE(ГОД,C25,DAY(D25))","v":"2025-02-01"},{"$f":"IF(N(E25),IF(MONTH(E25+1)=$C25,E25+1,\"\"),\"\")","v":"2025-02-02"},"2025-02-03","2025-02-04","2025-02-05","2025-02-06","2025-02-07","2025-02-08","2025-02-09","2025-02-10","2025-02-11","2025-02-12","2025-02-13","2025-02-14","2025-02-15","2025-02-16","2025-02-17","2025-02-18","2025-02-19","2025-02-20","2025-02-21","2025-02-22","2025-02-23","2025-02-24","2025-02-25","2025-02-26","2025-02-27","2025-02-28","","",{"$f":"IF(N(AH25),IF(MONTH(AH25+1)=$C25,AH25+1,\"\"),\"\")","v":""},null,{"$f":"AK$2","v":"Не раб. дней"},{"$f":"AL$2","v":"Раб. дней"},{"$f":"AM$2","v":"Раб. час"},{"$f":"AN$2","v":"Отпуск ПЛАН"},{"$f":"AO$2","v":"Отгуляно на СЕГОДНЯ"},null,{"$f":"$AQ$1","v":"ОТЧЁТ за месяц"}]
[{"$f":"DATE(ГОД,C25,1)","v":"2025-02-01"},null,null,null,{"$f":"E25","v":"2025-02-01"},{"$f":"F25","v":"2025-02-02"},"2025-02-03","2025-02-04","2025-02-05","2025-02-06","2025-02-07","2025-02-08","2025-02-09","2025-02-10","2025-02-11","2025-02-12","2025-02-13","2025-02-14","2025-02-15","2025-02-16","2025-02-17","2025-02-18","2025-02-19","2025-02-20","2025-02-21","2025-02-22","2025-02-23","2025-02-24","2025-02-25","2025-02-26","2025-02-27",{"$f":"AF25","v":"2025-02-28"},{"$f":"AG25","v":""},{"$f":"AH25","v":""},{"$f":"AI25","v":""},null,null,null,null,null,null,null,{"$f":"DATE(ГОД,C25,1)","v":"2025-02-01"},{"$f":"M$306","v":"В"},"ОТ","ДО","Б","НН","ПР","К","НОД","У","ОЗ","Г"]
[{"$f":"OFFSET(A27,-1,0)","v":"2025-02-01"},"4А",{"$f":"N(OFFSET(C27,-1,0))+1","v":1},"Алёхин А.А.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,null,null,null,{"$f":"SUM(- - ISTEXT(E27:AI27))","v":14},{"$f":"COUNT(E27:AI27)","v":14},{"$f":"SUM(E27:AI27)","v":150.5},{"$f":"COUNTIF(E27:AI27,\"ОТ\")","v":0},{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$25,0,IF(MONTH(TODAY())>$C$25,AN27,COUNTIF(OFFSET(E27,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,{"$f":"D27","v":"Алёхин А.А."},{"$f":"COUNTIF($E27:$AI27,M$306)","v":14},0,0,0,0,0,0,0,0,0,0]
[{"$f":"OFFSET(A28,-1,0)","v":"2025-02-01"},"4А",{"$f":"N(OFFSET(C28,-1,0))+1","v":2},"Борисов В.В.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,null,null,null,{"$f":"SUM(- - ISTEXT(E28:AI28))","v":14},{"$f":"COUNT(E28:AI28)","v":14},{"$f":"SUM(E28:AI28)","v":150.5},{"$f":"COUNTIF(E28:AI28,\"ОТ\")","v":0},0,null,{"$f":"D28","v":"Борисов В.В."},14,0,0,0,0,0,0,0,0,0,0]
["2025-02-01","4Б",3,"Володин В.В.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В",null,null,null,null,{"$f":"SUM(- - ISTEXT(E29:AI29))","v":14},{"$f":"COUNT(E29:AI29)","v":14},{"$f":"SUM(E29:AI29)","v":150.5},{"$f":"COUNTIF(E29:AI29,\"ОТ\")","v":0},0,null,{"$f":"D29","v":"Володин В.В."},14,0,0,0,0,0,0,0,0,0,0]
["2025-02-01","4Б",4,"Гаврилов Г.Г.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В",null,null,null,null,{"$f":"SUM(- - ISTEXT(E30:AI30))","v":14},{"$f":"COUNT(E30:AI30)","v":14},{"$f":"SUM(E30:AI30)","v":150.5},{"$f":"COUNTIF(E30:AI30,\"ОТ\")","v":0},0,null,{"$f":"D30","v":"Гаврилов Г.Г."},14,0,0,0,0,0,0,0,0,0,0]
["2025-02-01","4Б",5,"Данилов Д.Д.","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,null,null,null,null,{"$f":"SUM(- - ISTEXT(E31:AI31))","v":14},14,150.5,0,0,null,"Данилов Д.Д.",14,0,0,0,0,0,0,0,0,0,0]
["2025-02-01","4В",6,"Ежов Е.Е.","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,null,null,null,null,{"$f":"SUM(- - ISTEXT(E32:AI32))","v":14},14,150.5,0,0,null,"Ежов Е.Е.",14,0,0,0,0,0,0,0,0,0,0]
["2025-02-01","4В",7,"Зуев З.З.",8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,null,null,null,{"$f":"SUM(- - ISTEXT(E33:AI33))","v":14},14,150.5,0,0,null,"Зуев З.З.",14,0,0,0,0,0,0,0,0,0,0]
["2025-02-01","4Г",8,"Иванов И.И.",8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,null,null,null,{"$f":"SUM(- - ISTEXT(E34:AI34))","v":14},14,150.5,0,0,null,"Иванов И.И.",14,0,0,0,0,0,0,0,0,0,0]
["2025-02-01","4Г",9,"Козлов К.К.","В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,null,null,null,{"$f":"SUM(- - ISTEXT(E35:AI35))","v":8},20,160,0,0,null,"Козлов К.К.",8,0,0,0,0,0,0,0,0,0,0]
["2025-02-01",1,10,"Львов Л.Л.","В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,null,null,null,{"$f":"SUM(- - ISTEXT(E36:AI36))","v":8},20,160,0,0,null,"Львов Л.Л.",8,0,0,0,0,0,0,0,0,0,0]
["2025-02-01",1,11,"Мишин М.М.","В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,null,null,null,{"$f":"SUM(- - ISTEXT(E37:AI37))","v":8},20,160,0,0,null,"Мишин М.М.",8,0,0,0,0,0,0,0,0,0,0]
["2025-02-01",1,12,"Носов Н.Н.","В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,null,null,null,{"$f":"SUM(- - ISTEXT(E38:AI38))","v":8},20,160,0,0,null,"Носов Н.Н.",8,0,0,0,0,0,0,0,0,0,0]
["2025-02-01",1,13,"Осин О.О.","В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,null,null,null,{"$f":"SUM(- - ISTEXT(E39:AI39))","v":8},20,160,0,0,null,"Осин О.О.",8,0,0,0,0,0,0,0,0,0,0]
["2025-02-01",1,14,"Попов П.П.","В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,null,null,null,{"$f":"SUM(- - ISTEXT(E40:AI40))","v":8},20,160,0,0,null,"Попов П.П.",8,0,0,0,0,0,0,0,0,0,0]
["2025-02-01",1,15,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E41:AI41))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-02-01",1,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,{"$f":"SUM(- - ISTEXT(E42:AI42))","v":0},{"$f":"COUNT(E42:AI42)","v":0},{"$f":"SUM(E42:AI42)","v":0},{"$f":"COUNTIF(E42:AI42,\"ОТ\")","v":0},0,null,{"$f":"D42","v":0},0,0,0,0,0,0,0,0,0,0,0]
["2025-02-01",1,17,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E43:AI43))","v":0},{"$f":"COUNT(E43:AI43)","v":0},{"$f":"SUM(E43:AI43)","v":0},{"$f":"COUNTIF(E43:AI43,\"ОТ\")","v":0},0,null,{"$f":"D43","v":0},0,0,0,0,0,0,0,0,0,0,0]
["2025-02-01",1,18,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E44:AI44))","v":0},{"$f":"COUNT(E44:AI44)","v":0},{"$f":"SUM(E44:AI44)","v":0},{"$f":"COUNTIF(E44:AI44,\"ОТ\")","v":0},0,null,{"$f":"D44","v":0},0,0,0,0,0,0,0,0,0,0,0]
["2025-02-01",1,19,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E45:AI45))","v":0},{"$f":"COUNT(E45:AI45)","v":0},{"$f":"SUM(E45:AI45)","v":0},{"$f":"COUNTIF(E45:AI45,\"ОТ\")","v":0},0,null,{"$f":"D45","v":0},0,0,0,0,0,0,0,0,0,0,0]
["2025-02-01",1,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,{"$f":"SUM(- - ISTEXT(E46:AI46))","v":0},{"$f":"COUNT(E46:AI46)","v":0},{"$f":"SUM(E46:AI46)","v":0},{"$f":"COUNTIF(E46:AI46,\"ОТ\")","v":0},0,null,{"$f":"D46","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"IF(E48=TODAY(),МЕТКА,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"График",3,{"$f":"DATE(ГОД,C48,1)","v":"2025-03-01"},{"$f":"DATE(ГОД,C48,DAY(D48))","v":"2025-03-01"},{"$f":"IF(N(E48),IF(MONTH(E48+1)=$C48,E48+1,\"\"),\"\")","v":"2025-03-02"},"2025-03-03","2025-03-04","2025-03-05","2025-03-06","2025-03-07","2025-03-08","2025-03-09","2025-03-10","2025-03-11","2025-03-12","2025-03-13","2025-03-14","2025-03-15","2025-03-16","2025-03-17","2025-03-18","2025-03-19","2025-03-20","2025-03-21","2025-03-22","2025-03-23","2025-03-24","2025-03-25","2025-03-26","2025-03-27","2025-03-28","2025-03-29","2025-03-30",{"$f":"IF(N(AH48),IF(MONTH(AH48+1)=$C48,AH48+1,\"\"),\"\")","v":"2025-03-31"},null,{"$f":"AK$2","v":"Не раб. дней"},{"$f":"AL$2","v":"Раб. дней"},{"$f":"AM$2","v":"Раб. час"},{"$f":"AN$2","v":"Отпуск ПЛАН"},{"$f":"AO$2","v":"Отгуляно на СЕГОДНЯ"},null,{"$f":"$AQ$1","v":"ОТЧЁТ за месяц"}]
[{"$f":"DATE(ГОД,C48,1)","v":"2025-03-01"},null,null,null,{"$f":"E48","v":"2025-03-01"},"2025-03-02","2025-03-03","2025-03-04","2025-03-05","2025-03-06","2025-03-07","2025-03-08","2025-03-09","2025-03-10","2025-03-11","2025-03-12","2025-03-13","2025-03-14","2025-03-15","2025-03-16","2025-03-17","2025-03-18","2025-03-19","2025-03-20","2025-03-21","2025-03-22","2025-03-23","2025-03-24","2025-03-25","2025-03-26","2025-03-27","2025-03-28",{"$f":"AG48","v":"2025-03-29"},{"$f":"AH48","v":"2025-03-30"},{"$f":"AI48","v":"2025-03-31"},null,null,null,null,null,null,null,{"$f":"DATE(ГОД,C48,1)","v":"2025-03-01"},{"$f":"M$306","v":"В"},"ОТ","ДО","Б","НН","ПР","К","НОД","У","ОЗ","Г"]
[{"$f":"OFFSET(A50,-1,0)","v":"2025-03-01"},"4А",{"$f":"N(OFFSET(C50,-1,0))+1","v":1},"Алёхин А.А.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В",null,{"$f":"SUM(- - ISTEXT(E50:AH50))","v":14},{"$f":"COUNT(E50:AH50)","v":16},{"$f":"SUM(E50:AH50)","v":172},{"$f":"COUNTIF(E50:AI50,\"ОТ\")","v":0},{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$48,0,IF(MONTH(TODAY())>$C$48,AN50,COUNTIF(OFFSET(E50,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,{"$f":"D50","v":"Алёхин А.А."},{"$f":"COUNTIF($E50:$AI50,M$306)","v":15},0,0,0,0,0,0,0,0,0,0]
[{"$f":"OFFSET(A51,-1,0)","v":"2025-03-01"},"4А",{"$f":"N(OFFSET(C51,-1,0))+1","v":2},"Борисов В.В.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В",null,{"$f":"SUM(- - ISTEXT(E51:AH51))","v":14},16,172,0,0,null,{"$f":"D51","v":"Борисов В.В."},15,0,0,0,0,0,0,0,0,0,0]
["2025-03-01","4Б",3,"Володин В.В.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,null,{"$f":"SUM(- - ISTEXT(E52:AH52))","v":15},15,164,0,0,null,"Володин В.В.",15,0,0,0,0,0,0,0,0,0,0]
["2025-03-01","4Б",4,"Гаврилов Г.Г.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,null,{"$f":"SUM(- - ISTEXT(E53:AH53))","v":15},15,164,0,0,null,"Гаврилов Г.Г.",15,0,0,0,0,0,0,0,0,0,0]
["2025-03-01","4В",5,"Данилов Д.Д.","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,{"$f":"SUM(- - ISTEXT(E54:AH54))","v":16},14,150.5,0,0,null,"Данилов Д.Д.",16,0,0,0,0,0,0,0,0,0,0]
["2025-03-01","4В",6,"Ежов Е.Е.","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,{"$f":"SUM(- - ISTEXT(E55:AH55))","v":16},14,150.5,0,0,null,"Ежов Е.Е.",16,0,0,0,0,0,0,0,0,0,0]
["2025-03-01","4Г",7,"Зуев З.З.",8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,{"$f":"SUM(- - ISTEXT(E56:AH56))","v":15},{"$f":"COUNT(E56:AH56)","v":15},{"$f":"SUM(E56:AH56)","v":158.5},{"$f":"COUNTIF(E56:AI56,\"ОТ\")","v":0},0,null,"Зуев З.З.",16,0,0,0,0,0,0,0,0,0,0]
["2025-03-01","4Г",8,"Иванов И.И.",8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,{"$f":"SUM(- - ISTEXT(E57:AH57))","v":15},{"$f":"COUNT(E57:AH57)","v":15},{"$f":"SUM(E57:AH57)","v":158.5},{"$f":"COUNTIF(E57:AI57,\"ОТ\")","v":0},0,null,"Иванов И.И.",16,0,0,0,0,0,0,0,0,0,0]
["2025-03-01",1,9,"Козлов К.К.","В","В",8.25,8.25,8.25,8.25,6,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,null,{"$f":"SUM(- - ISTEXT(E58:AH58))","v":10},20,159,0,0,null,"Козлов К.К.",10,0,0,0,0,0,0,0,0,0,0]
["2025-03-01",1,10,"Львов Л.Л.","В","В",8.25,8.25,8.25,8.25,6,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,null,{"$f":"SUM(- - ISTEXT(E59:AH59))","v":10},20,159,0,0,null,"Львов Л.Л.",10,0,0,0,0,0,0,0,0,0,0]
["2025-03-01",1,11,"Мишин М.М.","В","В",8.25,8.25,8.25,8.25,6,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,null,{"$f":"SUM(- - ISTEXT(E60:AH60))","v":10},20,159,0,0,null,"Мишин М.М.",10,0,0,0,0,0,0,0,0,0,0]
["2025-03-01",1,12,"Носов Н.Н.","В","В",8.25,8.25,8.25,8.25,6,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,null,{"$f":"SUM(- - ISTEXT(E61:AH61))","v":10},20,159,0,0,null,"Носов Н.Н.",10,0,0,0,0,0,0,0,0,0,0]
["2025-03-01",1,13,"Осин О.О.","В","В",8.25,8.25,8.25,8.25,6,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,null,{"$f":"SUM(- - ISTEXT(E62:AH62))","v":10},20,159,0,0,null,"Осин О.О.",10,0,0,0,0,0,0,0,0,0,0]
["2025-03-01",1,14,"Попов П.П.","В","В",8.25,8.25,8.25,8.25,6,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,null,{"$f":"SUM(- - ISTEXT(E63:AH63))","v":10},20,159,0,0,null,"Попов П.П.",10,0,0,0,0,0,0,0,0,0,0]
["2025-03-01",1,15,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E64:AH64))","v":0},{"$f":"COUNT(E64:AH64)","v":0},{"$f":"SUM(E64:AH64)","v":0},{"$f":"COUNTIF(E64:AI64,\"ОТ\")","v":0},0,null,{"$f":"D64","v":0},0,0,0,0,0,0,0,0,0,0,0]
["2025-03-01",1,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,{"$f":"SUM(- - ISTEXT(E65:AH65))","v":0},{"$f":"COUNT(E65:AH65)","v":0},{"$f":"SUM(E65:AH65)","v":0},0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-03-01",1,17,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E66:AI66))","v":0},{"$f":"COUNT(E66:AI66)","v":0},{"$f":"SUM(E66:AI66)","v":0},0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-03-01",1,18,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E67:AI67))","v":0},{"$f":"COUNT(E67:AI67)","v":0},{"$f":"SUM(E67:AI67)","v":0},0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-03-01",1,19,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E68:AI68))","v":0},{"$f":"COUNT(E68:AI68)","v":0},{"$f":"SUM(E68:AI68)","v":0},0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-03-01",1,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,{"$f":"SUM(- - ISTEXT(E69:AI69))","v":0},{"$f":"COUNT(E69:AI69)","v":0},{"$f":"SUM(E69:AI69)","v":0},0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[" ",null,null,null,{"$f":"IF(E71=TODAY(),МЕТКА,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"График",4,{"$f":"DATE(ГОД,C71,1)","v":"2025-04-01"},{"$f":"DATE(ГОД,C71,DAY(D71))","v":"2025-04-01"},{"$f":"IF(N(E71),IF(MONTH(E71+1)=$C71,E71+1,\"\"),\"\")","v":"2025-04-02"},"2025-04-03","2025-04-04","2025-04-05","2025-04-06","2025-04-07","2025-04-08","2025-04-09","2025-04-10","2025-04-11","2025-04-12","2025-04-13","2025-04-14","2025-04-15","2025-04-16","2025-04-17","2025-04-18","2025-04-19","2025-04-20","2025-04-21","2025-04-22","2025-04-23","2025-04-24","2025-04-25","2025-04-26","2025-04-27","2025-04-28","2025-04-29","2025-04-30",{"$f":"IF(N(AH71),IF(MONTH(AH71+1)=$C71,AH71+1,\"\"),\"\")","v":""},null,{"$f":"AK$2","v":"Не раб. дней"},{"$f":"AL$2","v":"Раб. дней"},{"$f":"AM$2","v":"Раб. час"},{"$f":"AN$2","v":"Отпуск ПЛАН"},{"$f":"AO$2","v":"Отгуляно на СЕГОДНЯ"},null,{"$f":"$AQ$1","v":"ОТЧЁТ за месяц"}]
[{"$f":"DATE(ГОД,C71,1)","v":"2025-04-01"},null,null,null,{"$f":"E71","v":"2025-04-01"},"2025-04-02","2025-04-03","2025-04-04","2025-04-05","2025-04-06","2025-04-07","2025-04-08","2025-04-09","2025-04-10","2025-04-11","2025-04-12","2025-04-13","2025-04-14","2025-04-15","2025-04-16","2025-04-17","2025-04-18","2025-04-19","2025-04-20","2025-04-21","2025-04-22","2025-04-23","2025-04-24","2025-04-25","2025-04-26","2025-04-27","2025-04-28",{"$f":"AG71","v":"2025-04-29"},{"$f":"AH71","v":"2025-04-30"},{"$f":"AI71","v":""},null,null,null,null,null,null,null,{"$f":"DATE(ГОД,C71,1)","v":"2025-04-01"},{"$f":"M$306","v":"В"},"ОТ","ДО","Б","НН","ПР","К","НОД","У","ОЗ","Г"]
[{"$f":"OFFSET(A73,-1,0)","v":"2025-04-01"},"4А",{"$f":"N(OFFSET(C73,-1,0))+1","v":1},"Алёхин А.А.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,null,{"$f":"SUM(- - ISTEXT(E73:AH73))","v":15},{"$f":"COUNT(E73:AH73)","v":15},{"$f":"SUM(E73:AH73)","v":164},{"$f":"COUNTIF(E73:AI73,\"ОТ\")","v":0},{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$48,0,IF(MONTH(TODAY())>$C$48,AN73,COUNTIF(OFFSET(E73,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,{"$f":"D73","v":"Алёхин А.А."},{"$f":"COUNTIF($E73:$AI73,M$306)","v":15},0,0,0,0,0,0,0,0,0,0]
[{"$f":"OFFSET(A74,-1,0)","v":"2025-04-01"},"4А",{"$f":"N(OFFSET(C74,-1,0))+1","v":2},"Борисов В.В.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,null,{"$f":"SUM(- - ISTEXT(E74:AH74))","v":15},{"$f":"COUNT(E74:AH74)","v":15},{"$f":"SUM(E74:AH74)","v":164},0,0,null,{"$f":"D74","v":"Борисов В.В."},15,0,0,0,0,0,0,0,0,0,0]
["2025-04-01","4Б",3,"Володин В.В.","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,null,{"$f":"SUM(- - ISTEXT(E75:AH75))","v":16},14,150.5,0,0,null,"Володин В.В.",16,0,0,0,0,0,0,0,0,0,0]
["2025-04-01","4Б",4,"Гаврилов Г.Г.","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,null,{"$f":"SUM(- - ISTEXT(E76:AH76))","v":16},14,150.5,0,0,null,"Гаврилов Г.Г.",16,0,0,0,0,0,0,0,0,0,0]
["2025-04-01","4В",5,"Данилов Д.Д.",8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В",null,null,{"$f":"SUM(- - ISTEXT(E77:AH77))","v":15},15,158.5,0,0,null,"Данилов Д.Д.",15,0,0,0,0,0,0,0,0,0,0]
["2025-04-01","4В",6,"Ежов Е.Е.",8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В",null,null,{"$f":"SUM(- - ISTEXT(E78:AH78))","v":15},15,158.5,0,0,null,"Ежов Е.Е.",15,0,0,0,0,0,0,0,0,0,0]
["2025-04-01","4Г",7,"Зуев З.З.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,null,null,{"$f":"SUM(- - ISTEXT(E79:AH79))","v":14},16,172,0,0,null,"Зуев З.З.",14,0,0,0,0,0,0,0,0,0,0]
["2025-04-01","4Г",8,"Иванов И.И.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,null,null,{"$f":"SUM(- - ISTEXT(E80:AH80))","v":14},16,172,0,0,null,"Иванов И.И.",14,0,0,0,0,0,0,0,0,0,0]
["2025-04-01",1,9,"Козлов К.К.",8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,7.25,null,null,{"$f":"SUM(- - ISTEXT(E81:AH81))","v":8},22,175.5,0,0,null,"Козлов К.К.",8,0,0,0,0,0,0,0,0,0,0]
["2025-04-01",1,10,"Львов Л.Л.",8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,7.25,null,null,{"$f":"SUM(- - ISTEXT(E82:AH82))","v":8},22,175.5,0,0,null,"Львов Л.Л.",8,0,0,0,0,0,0,0,0,0,0]
["2025-04-01",1,11,"Мишин М.М.",8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,7.25,null,null,{"$f":"SUM(- - ISTEXT(E83:AH83))","v":8},22,175.5,0,0,null,"Мишин М.М.",8,0,0,0,0,0,0,0,0,0,0]
["2025-04-01",1,12,"Носов Н.Н.",8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В","ОТ","ОТ","ОТ",null,null,{"$f":"SUM(- - ISTEXT(E84:AH84))","v":11},19,151.75,3,0,null,"Носов Н.Н.",8,3,0,0,0,0,0,0,0,0,0]
["2025-04-01",1,13,"Осин О.О.",8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,7.25,null,null,{"$f":"SUM(- - ISTEXT(E85:AH85))","v":8},22,175.5,0,0,null,"Осин О.О.",8,0,0,0,0,0,0,0,0,0,0]
["2025-04-01",1,14,"Попов П.П.",8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,7.25,null,null,{"$f":"SUM(- - ISTEXT(E86:AH86))","v":8},22,175.5,0,0,null,"Попов П.П.",8,0,0,0,0,0,0,0,0,0,0]
["2025-04-01",1,15,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E87:AH87))","v":0},{"$f":"COUNT(E87:AH87)","v":0},{"$f":"SUM(E87:AH87)","v":0},{"$f":"COUNTIF(E87:AI87,\"ОТ\")","v":0},0,null,{"$f":"D87","v":0},0,0,0,0,0,0,0,0,0,0,0]
["2025-04-01",1,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,{"$f":"SUM(- - ISTEXT(E88:AH88))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-04-01",1,17,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E89:AH89))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-04-01",1,18,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E90:AH90))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-04-01",1,19,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E91:AH91))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-04-01",1,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,{"$f":"SUM(- - ISTEXT(E92:AH92))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[" ",null,null,null,{"$f":"IF(E94=TODAY(),МЕТКА,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"График",5,{"$f":"DATE(ГОД,C94,1)","v":"2025-05-01"},{"$f":"DATE(ГОД,C94,DAY(D94))","v":"2025-05-01"},{"$f":"IF(N(E94),IF(MONTH(E94+1)=$C94,E94+1,\"\"),\"\")","v":"2025-05-02"},"2025-05-03","2025-05-04","2025-05-05","2025-05-06","2025-05-07","2025-05-08","2025-05-09","2025-05-10","2025-05-11","2025-05-12","2025-05-13","2025-05-14","2025-05-15","2025-05-16","2025-05-17","2025-05-18","2025-05-19","2025-05-20","2025-05-21","2025-05-22","2025-05-23","2025-05-24","2025-05-25","2025-05-26","2025-05-27","2025-05-28","2025-05-29","2025-05-30",{"$f":"IF(N(AH94),IF(MONTH(AH94+1)=$C94,AH94+1,\"\"),\"\")","v":"2025-05-31"},null,{"$f":"AK$2","v":"Не раб. дней"},{"$f":"AL$2","v":"Раб. дней"},{"$f":"AM$2","v":"Раб. час"},{"$f":"AN$2","v":"Отпуск ПЛАН"},{"$f":"AO$2","v":"Отгуляно на СЕГОДНЯ"},null,{"$f":"$AQ$1","v":"ОТЧЁТ за месяц"}]
[{"$f":"DATE(ГОД,C94,1)","v":"2025-05-01"},null,null,null,{"$f":"E94","v":"2025-05-01"},"2025-05-02","2025-05-03","2025-05-04","2025-05-05","2025-05-06","2025-05-07","2025-05-08","2025-05-09","2025-05-10","2025-05-11","2025-05-12","2025-05-13","2025-05-14","2025-05-15","2025-05-16","2025-05-17","2025-05-18","2025-05-19","2025-05-20","2025-05-21","2025-05-22","2025-05-23","2025-05-24","2025-05-25","2025-05-26","2025-05-27","2025-05-28",{"$f":"AG94","v":"2025-05-29"},{"$f":"AH94","v":"2025-05-30"},{"$f":"AI94","v":"2025-05-31"},null,null,null,null,null,null,null,{"$f":"DATE(ГОД,C94,1)","v":"2025-05-01"},{"$f":"M$306","v":"В"},"ОТ","ДО","Б","НН","ПР","К","НОД","У","ОЗ","Г"]
[{"$f":"OFFSET(A96,-1,0)","v":"2025-05-01"},"4А",{"$f":"N(OFFSET(C96,-1,0))+1","v":1},"Алёхин А.А.",8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,{"$f":"SUM(- - ISTEXT(E96:AH96))","v":15},{"$f":"COUNT(E96:AH96)","v":15},{"$f":"SUM(E96:AH96)","v":158.5},{"$f":"COUNTIF(E96:AI96,\"ОТ\")","v":0},{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$94,0,IF(MONTH(TODAY())>$C$94,AN96,COUNTIF(OFFSET(#REF!,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,{"$f":"D96","v":"Алёхин А.А."},{"$f":"COUNTIF($E96:$AI96,M$306)","v":16},0,0,0,0,0,0,0,0,0,0]
[{"$f":"OFFSET(A97,-1,0)","v":"2025-05-01"},"4А",{"$f":"N(OFFSET(C97,-1,0))+1","v":2},"Борисов В.В.",8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,{"$f":"SUM(- - ISTEXT(E97:AH97))","v":15},{"$f":"COUNT(E97:AH97)","v":15},{"$f":"SUM(E97:AH97)","v":158.5},{"$f":"COUNTIF(E97:AI97,\"ОТ\")","v":0},{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$94,0,IF(MONTH(TODAY())>$C$94,AN97,COUNTIF(OFFSET(#REF!,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,{"$f":"D97","v":"Борисов В.В."},16,0,0,0,0,0,0,0,0,0,0]
["2025-05-01","4Б",3,"Володин В.В.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В",null,{"$f":"SUM(- - ISTEXT(E98:AH98))","v":14},16,172,0,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$94,0,IF(MONTH(TODAY())>$C$94,AN98,COUNTIF(OFFSET(#REF!,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,"Володин В.В.",15,0,0,0,0,0,0,0,0,0,0]
["2025-05-01","4Б",4,"Гаврилов Г.Г.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В",null,{"$f":"SUM(- - ISTEXT(E99:AH99))","v":14},16,172,0,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$94,0,IF(MONTH(TODAY())>$C$94,AN99,COUNTIF(OFFSET(#REF!,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,"Гаврилов Г.Г.",15,0,0,0,0,0,0,0,0,0,0]
["2025-05-01","4В",5,"Данилов Д.Д.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,null,{"$f":"SUM(- - ISTEXT(E100:AH100))","v":15},15,164,0,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$94,0,IF(MONTH(TODAY())>$C$94,AN100,COUNTIF(OFFSET(#REF!,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,"Данилов Д.Д.",15,0,0,0,0,0,0,0,0,0,0]
["2025-05-01","4В",6,"Ежов Е.Е.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В","ОТ","ОТ",null,{"$f":"SUM(- - ISTEXT(E101:AH101))","v":16},14,150.5,2,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$94,0,IF(MONTH(TODAY())>$C$94,AN101,COUNTIF(OFFSET(#REF!,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,"Ежов Е.Е.",15,2,0,0,0,0,0,0,0,0,0]
["2025-05-01","4Г",7,"Зуев З.З.","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,{"$f":"SUM(- - ISTEXT(E102:AH102))","v":16},14,150.5,0,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$94,0,IF(MONTH(TODAY())>$C$94,AN102,COUNTIF(OFFSET(#REF!,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,"Зуев З.З.",16,0,0,0,0,0,0,0,0,0,0]
["2025-05-01","4Г",8,"Иванов И.И.","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,{"$f":"SUM(- - ISTEXT(E103:AH103))","v":16},14,150.5,0,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$94,0,IF(MONTH(TODAY())>$C$94,AN103,COUNTIF(OFFSET(#REF!,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,"Иванов И.И.",16,0,0,0,0,0,0,0,0,0,0]
["2025-05-01",1,9,"Козлов К.К.","В","В","В","В",8.25,8.25,8.25,"В","В","В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В",null,{"$f":"SUM(- - ISTEXT(E104:AH104))","v":12},18,144.75,0,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$94,0,IF(MONTH(TODAY())>$C$94,AN104,COUNTIF(OFFSET(#REF!,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,"Козлов К.К.",13,0,0,0,0,0,0,0,0,0,0]
["2025-05-01",1,10,"Львов Л.Л.","В","В","В","В",8.25,8.25,8.25,"В","В","В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В",null,{"$f":"SUM(- - ISTEXT(E105:AH105))","v":12},18,144.75,0,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$94,0,IF(MONTH(TODAY())>$C$94,AN105,COUNTIF(OFFSET(#REF!,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,"Львов Л.Л.",13,0,0,0,0,0,0,0,0,0,0]
["2025-05-01",1,11,"Мишин М.М.","В","В","В","В",8.25,8.25,8.25,"В","В","В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В",null,{"$f":"SUM(- - ISTEXT(E106:AH106))","v":12},18,144.75,0,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$94,0,IF(MONTH(TODAY())>$C$94,AN106,COUNTIF(OFFSET(#REF!,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,"Мишин М.М.",13,0,0,0,0,0,0,0,0,0,0]
["2025-05-01",1,12,"Носов Н.Н.","В","В","В","В",8.25,8.25,8.25,"В","В","В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В",null,{"$f":"SUM(- - ISTEXT(E107:AH107))","v":12},18,144.75,0,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$94,0,IF(MONTH(TODAY())>$C$94,AN107,COUNTIF(OFFSET(#REF!,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,"Носов Н.Н.",13,0,0,0,0,0,0,0,0,0,0]
["2025-05-01",1,13,"Осин О.О.","В","В","В","В",8.25,8.25,8.25,"В","В","В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В",null,{"$f":"SUM(- - ISTEXT(E108:AH108))","v":12},{"$f":"COUNT(E108:AH108)","v":18},{"$f":"SUM(E108:AH108)","v":144.75},0,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$94,0,IF(MONTH(TODAY())>$C$94,AN108,COUNTIF(OFFSET(#REF!,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,"Осин О.О.",13,0,0,0,0,0,0,0,0,0,0]
["2025-05-01",1,14,"Попов П.П.","В","В","В","В",8.25,8.25,8.25,"В","В","В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В",null,{"$f":"SUM(- - ISTEXT(E109:AH109))","v":12},{"$f":"COUNT(E109:AH109)","v":18},{"$f":"SUM(E109:AH109)","v":144.75},0,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$94,0,IF(MONTH(TODAY())>$C$94,AN109,COUNTIF(OFFSET(#REF!,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,"Попов П.П.",13,0,0,0,0,0,0,0,0,0,0]
["2025-05-01",1,15,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E110:AH110))","v":0},{"$f":"COUNT(E110:AH110)","v":0},{"$f":"SUM(E110:AH110)","v":0},{"$f":"COUNTIF(E110:AI110,\"ОТ\")","v":0},{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$94,0,IF(MONTH(TODAY())>$C$94,AN110,COUNTIF(OFFSET(#REF!,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,{"$f":"D110","v":0},0,0,0,0,0,0,0,0,0,0,0]
["2025-05-01",1,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,{"$f":"SUM(- - ISTEXT(E111:AH111))","v":0},{"$f":"COUNT(E111:AH111)","v":0},{"$f":"SUM(E111:AH111)","v":0},{"$f":"COUNTIF(E111:AI111,\"ОТ\")","v":0},{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$94,0,IF(MONTH(TODAY())>$C$94,AN111,COUNTIF(OFFSET(E111,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-05-01",1,17,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E112:AI112))","v":0},{"$f":"COUNT(E112:AI112)","v":0},{"$f":"SUM(E112:AI112)","v":0},0,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$94,0,IF(MONTH(TODAY())>$C$94,AN112,COUNTIF(OFFSET(E112,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-05-01",1,18,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E113:AI113))","v":0},{"$f":"COUNT(E113:AI113)","v":0},{"$f":"SUM(E113:AI113)","v":0},0,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$94,0,IF(MONTH(TODAY())>$C$94,AN113,COUNTIF(OFFSET(E113,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-05-01",1,19,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E114:AI114))","v":0},{"$f":"COUNT(E114:AI114)","v":0},{"$f":"SUM(E114:AI114)","v":0},0,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$94,0,IF(MONTH(TODAY())>$C$94,AN114,COUNTIF(OFFSET(E114,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-05-01",1,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,{"$f":"SUM(- - ISTEXT(E115:AI115))","v":0},{"$f":"COUNT(E115:AI115)","v":0},{"$f":"SUM(E115:AI115)","v":0},0,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$94,0,IF(MONTH(TODAY())>$C$94,AN115,COUNTIF(OFFSET(E115,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0]
[" ",null,null,null,{"$f":"IF(E117=TODAY(),МЕТКА,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"График",6,{"$f":"DATE(ГОД,C117,1)","v":"2025-06-01"},{"$f":"DATE(ГОД,C117,DAY(D117))","v":"2025-06-01"},{"$f":"IF(N(E117),IF(MONTH(E117+1)=$C117,E117+1,\"\"),\"\")","v":"2025-06-02"},"2025-06-03","2025-06-04","2025-06-05","2025-06-06","2025-06-07","2025-06-08","2025-06-09","2025-06-10","2025-06-11","2025-06-12","2025-06-13","2025-06-14","2025-06-15","2025-06-16","2025-06-17","2025-06-18","2025-06-19","2025-06-20","2025-06-21","2025-06-22","2025-06-23","2025-06-24","2025-06-25","2025-06-26","2025-06-27","2025-06-28","2025-06-29","2025-06-30",{"$f":"IF(N(AH117),IF(MONTH(AH117+1)=$C117,AH117+1,\"\"),\"\")","v":""},null,{"$f":"AK$2","v":"Не раб. дней"},{"$f":"AL$2","v":"Раб. дней"},{"$f":"AM$2","v":"Раб. час"},{"$f":"AN$2","v":"Отпуск ПЛАН"},{"$f":"AO$2","v":"Отгуляно на СЕГОДНЯ"},null,{"$f":"$AQ$1","v":"ОТЧЁТ за месяц"}]
[{"$f":"DATE(ГОД,C117,1)","v":"2025-06-01"},null,null,null,{"$f":"E117","v":"2025-06-01"},"2025-06-02","2025-06-03","2025-06-04","2025-06-05","2025-06-06","2025-06-07","2025-06-08","2025-06-09","2025-06-10","2025-06-11","2025-06-12","2025-06-13","2025-06-14","2025-06-15","2025-06-16","2025-06-17","2025-06-18","2025-06-19","2025-06-20","2025-06-21","2025-06-22","2025-06-23","2025-06-24","2025-06-25","2025-06-26","2025-06-27","2025-06-28",{"$f":"AG117","v":"2025-06-29"},{"$f":"AH117","v":"2025-06-30"},{"$f":"AI117","v":""},null,null,null,null,null,null,null,{"$f":"DATE(ГОД,C117,1)","v":"2025-06-01"},{"$f":"M$306","v":"В"},"ОТ","ДО","Б","НН","ПР","К","НОД","У","ОЗ","Г"]
[{"$f":"OFFSET(A119,-1,0)","v":"2025-06-01"},"4А",{"$f":"N(OFFSET(C119,-1,0))+1","v":1},"Алёхин А.А.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","В","В",13.5,8,"В","В",13.5,8,null,null,{"$f":"SUM(- - ISTEXT(E119:AH119))","v":18},{"$f":"COUNT(E119:AH119)","v":12},{"$f":"SUM(E119:AH119)","v":129},{"$f":"COUNTIF(E119:AI119,\"ОТ\")","v":6},{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$117,0,IF(MONTH(TODAY())>$C$117,AN119,COUNTIF(OFFSET(E119,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,{"$f":"D119","v":"Алёхин А.А."},{"$f":"COUNTIF($E119:$AI119,M$306)","v":12},6,0,0,0,0,0,0,0,0,0]
[{"$f":"OFFSET(A120,-1,0)","v":"2025-06-01"},"4А",{"$f":"N(OFFSET(C120,-1,0))+1","v":2},"Борисов В.В.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В","ОТ","ОТ",null,null,{"$f":"SUM(- - ISTEXT(E120:AH120))","v":16},14,150.5,2,0,null,{"$f":"D120","v":"Борисов В.В."},14,2,0,0,0,0,0,0,0,0,0]
["2025-06-01","4Б",3,"Володин В.В.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,null,{"$f":"SUM(- - ISTEXT(E121:AH121))","v":15},15,164,0,0,null,"Володин В.В.",15,0,0,0,0,0,0,0,0,0,0]
["2025-06-01","4Б",4,"Гаврилов Г.Г.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В","ОТ","ОТ","ОТ","ОТ","ОТ",null,null,{"$f":"SUM(- - ISTEXT(E122:AH122))","v":18},12,129,5,0,null,"Гаврилов Г.Г.",13,5,0,0,0,0,0,0,0,0,0]
["2025-06-01","4В",5,"Данилов Д.Д.","В","В","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,null,{"$f":"SUM(- - ISTEXT(E123:AH123))","v":24},6,64.5,14,0,null,"Данилов Д.Д.",10,14,0,0,0,0,0,0,0,0,0]
["2025-06-01","4В",6,"Ежов Е.Е.","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В","ОТ","ОТ","В","В",null,null,{"$f":"SUM(- - ISTEXT(E124:AH124))","v":18},12,129,2,0,null,"Ежов Е.Е.",16,2,0,0,0,0,0,0,0,0,0]
["2025-06-01","4Г",7,"Зуев З.З.",8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","В","В",13.5,8,"В",null,null,{"$f":"SUM(- - ISTEXT(E125:AH125))","v":19},11,115.5,8,0,null,"Зуев З.З.",11,8,0,0,0,0,0,0,0,0,0]
["2025-06-01","4Г",8,"Иванов И.И.",8,"В","В","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В",null,null,{"$f":"SUM(- - ISTEXT(E126:AH126))","v":19},11,115.5,6,0,null,"Иванов И.И.",13,6,0,0,0,0,0,0,0,0,0]
["2025-06-01",1,9,"Козлов К.К.","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,7.25,"В","В","В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,null,null,{"$f":"SUM(- - ISTEXT(E127:AH127))","v":11},19,152,0,0,null,"Козлов К.К.",11,0,0,0,0,0,0,0,0,0,0]
["2025-06-01",1,10,"Львов Л.Л.","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,7.25,"В","В","В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,null,null,{"$f":"SUM(- - ISTEXT(E128:AH128))","v":11},19,152,0,0,null,"Львов Л.Л.",11,0,0,0,0,0,0,0,0,0,0]
["2025-06-01",1,11,"Мишин М.М.","В",8.25,8.25,8.25,8.25,7,"В","В","ОТ","ОТ","ОТ","В","В","В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,null,null,{"$f":"SUM(- - ISTEXT(E129:AH129))","v":14},16,128.25,3,0,null,"Мишин М.М.",11,3,0,0,0,0,0,0,0,0,0]
["2025-06-01",1,12,"Носов Н.Н.","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,7.25,"В","В","В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,null,null,{"$f":"SUM(- - ISTEXT(E130:AH130))","v":11},19,152,0,0,null,"Носов Н.Н.",11,0,0,0,0,0,0,0,0,0,0]
["2025-06-01",1,13,"Осин О.О.","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,7.25,"В","В","В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,null,null,{"$f":"SUM(- - ISTEXT(E131:AH131))","v":11},19,152,0,0,null,"Осин О.О.",11,0,0,0,0,0,0,0,0,0,0]
["2025-06-01",1,14,"Попов П.П.","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,7.25,"В","В","В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,null,null,{"$f":"SUM(- - ISTEXT(E132:AH132))","v":11},19,152,0,0,null,"Попов П.П.",11,0,0,0,0,0,0,0,0,0,0]
["2025-06-01",1,15,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E133:AH133))","v":0},0,0,{"$f":"COUNTIF(E133:AI133,\"ОТ\")","v":0},0,null,{"$f":"D133","v":0},0,0,0,0,0,0,0,0,0,0,0]
["2025-06-01",1,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,{"$f":"SUM(- - ISTEXT(E134:AH134))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-06-01",1,17,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E135:AH135))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-06-01",1,18,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E136:AI136))","v":0},{"$f":"COUNT(E136:AI136)","v":0},{"$f":"SUM(E136:AI136)","v":0},0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-06-01",1,19,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E137:AI137))","v":0},{"$f":"COUNT(E137:AI137)","v":0},{"$f":"SUM(E137:AI137)","v":0},0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-06-01",1,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,{"$f":"SUM(- - ISTEXT(E138:AI138))","v":0},{"$f":"COUNT(E138:AI138)","v":0},{"$f":"SUM(E138:AI138)","v":0},0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[" ",null,null,null,{"$f":"IF(E140=TODAY(),МЕТКА,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"График",7,{"$f":"DATE(ГОД,C140,1)","v":"2025-07-01"},{"$f":"DATE(ГОД,C140,DAY(D140))","v":"2025-07-01"},{"$f":"IF(N(E140),IF(MONTH(E140+1)=$C140,E140+1,\"\"),\"\")","v":"2025-07-02"},"2025-07-03","2025-07-04","2025-07-05","2025-07-06","2025-07-07","2025-07-08","2025-07-09","2025-07-10","2025-07-11","2025-07-12","2025-07-13","2025-07-14","2025-07-15","2025-07-16","2025-07-17","2025-07-18","2025-07-19","2025-07-20","2025-07-21","2025-07-22","2025-07-23","2025-07-24","2025-07-25","2025-07-26","2025-07-27","2025-07-28","2025-07-29","2025-07-30",{"$f":"IF(N(AH140),IF(MONTH(AH140+1)=$C140,AH140+1,\"\"),\"\")","v":"2025-07-31"},null,{"$f":"AK$2","v":"Не раб. дней"},{"$f":"AL$2","v":"Раб. дней"},{"$f":"AM$2","v":"Раб. час"},{"$f":"AN$2","v":"Отпуск ПЛАН"},{"$f":"AO$2","v":"Отгуляно на СЕГОДНЯ"},null,{"$f":"$AQ$1","v":"ОТЧЁТ за месяц"}]
[{"$f":"DATE(ГОД,C140,1)","v":"2025-07-01"},null,null,null,{"$f":"E140","v":"2025-07-01"},"2025-07-02","2025-07-03","2025-07-04","2025-07-05","2025-07-06","2025-07-07","2025-07-08","2025-07-09","2025-07-10","2025-07-11","2025-07-12","2025-07-13","2025-07-14","2025-07-15","2025-07-16","2025-07-17","2025-07-18","2025-07-19","2025-07-20","2025-07-21","2025-07-22","2025-07-23","2025-07-24","2025-07-25","2025-07-26","2025-07-27","2025-07-28",{"$f":"AG140","v":"2025-07-29"},{"$f":"AH140","v":"2025-07-30"},{"$f":"AI140","v":"2025-07-31"},null,null,null,null,null,null,null,{"$f":"DATE(ГОД,C140,1)","v":"2025-07-01"},{"$f":"M$306","v":"В"},"ОТ","ДО","Б","НН","ПР","К","НОД","У","ОЗ","Г"]
[{"$f":"OFFSET(A142,-1,0)","v":"2025-07-01"},"4А",{"$f":"N(OFFSET(C142,-1,0))+1","v":1},"Алёхин А.А.","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В","ОТ","ОТ","ОТ","ОТ",13.5,null,{"$f":"SUM(- - ISTEXT(E142:AH142))","v":18},{"$f":"COUNT(E142:AH142)","v":12},{"$f":"SUM(E142:AH142)","v":129},{"$f":"COUNTIF(E142:AI142,\"ОТ\")","v":4},{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$117,0,IF(MONTH(TODAY())>$C$117,AN142,COUNTIF(OFFSET(E142,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,{"$f":"D142","v":"Алёхин А.А."},{"$f":"COUNTIF($E142:$AG142,M$306)","v":14},3,0,0,0,0,0,0,0,0,{"$f":"COUNTIF($E142:$AI142,W$306)","v":0}]
[{"$f":"OFFSET(A143,-1,0)","v":"2025-07-01"},"4А",{"$f":"N(OFFSET(C143,-1,0))+1","v":2},"Борисов В.В.","В","В",13.5,8,"В","В",13.5,8,"В","В","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","В","В",13.5,8,"В","В",13.5,null,{"$f":"SUM(- - ISTEXT(E143:AH143))","v":24},{"$f":"COUNT(E143:AH143)","v":6},{"$f":"SUM(E143:AH143)","v":64.5},{"$f":"COUNTIF(E143:AI143,\"ОТ\")","v":14},0,null,{"$f":"D143","v":"Борисов В.В."},9,14,0,0,0,0,0,0,0,0,0]
["2025-07-01","4Б",3,"Володин В.В.",8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,{"$f":"SUM(- - ISTEXT(E144:AH144))","v":15},{"$f":"COUNT(E144:AH144)","v":15},{"$f":"SUM(E144:AH144)","v":158.5},{"$f":"COUNTIF(E144:AI144,\"ОТ\")","v":0},0,null,"Володин В.В.",{"$f":"COUNTIF($E144:$AI144,M$306)","v":16},0,0,0,0,0,0,0,0,0,0]
["2025-07-01","4Б",4,"Гаврилов Г.Г.","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,{"$f":"SUM(- - ISTEXT(E145:AB145))","v":17},{"$f":"COUNT(E145:AB145)","v":7},{"$f":"SUM(E145:AB145)","v":78},{"$f":"COUNTIF(E145:AI145,\"ОТ\")","v":11},0,null,"Гаврилов Г.Г.",10,11,0,0,0,0,0,0,0,0,0]
["2025-07-01","4В",5,"Данилов Д.Д.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В",null,{"$f":"SUM(- - ISTEXT(E146:AH146))","v":14},{"$f":"COUNT(E146:AH146)","v":16},{"$f":"SUM(E146:AH146)","v":172},{"$f":"COUNTIF(E146:AI146,\"ОТ\")","v":0},0,null,"Данилов Д.Д.",15,0,0,0,0,0,0,0,0,0,0]
["2025-07-01","4В",6,"Ежов Е.Е.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В","ОТ","ОТ","В",null,{"$f":"SUM(- - ISTEXT(E147:AH147))","v":16},14,150.5,2,0,null,"Ежов Е.Е.",15,2,0,0,0,0,0,0,0,0,0]
["2025-07-01","4Г",7,"Зуев З.З.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ",null,{"$f":"SUM(- - ISTEXT(E148:AH148))","v":20},10,107.5,12,0,null,"Зуев З.З.",9,12,0,0,0,0,0,0,0,0,0]
["2025-07-01","4Г",8,"Иванов И.И.","В",13.5,8,"В","В","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,null,{"$f":"SUM(- - ISTEXT(E149:AH149))","v":23},7,78,14,0,null,"Иванов И.И.",9,14,0,0,0,0,0,0,0,0,0]
["2025-07-01",1,9,"Козлов К.К.",8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,null,{"$f":"SUM(- - ISTEXT(E150:AH150))","v":8},22,176.5,0,0,null,"Козлов К.К.",8,0,0,0,0,0,0,0,0,0,0]
["2025-07-01",1,10,"Львов Л.Л.",8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,null,{"$f":"SUM(- - ISTEXT(E151:AH151))","v":8},22,176.5,0,0,null,"Львов Л.Л.",8,0,0,0,0,0,0,0,0,0,0]
["2025-07-01",1,11,"Мишин М.М.",8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ",8.25,8.25,8.25,null,{"$f":"SUM(- - ISTEXT(E152:AH152))","v":19},11,88.25,15,0,null,"Мишин М.М.",4,15,0,0,0,0,0,0,0,0,0]
["2025-07-01",1,12,"Носов Н.Н.",8.25,8.25,8.25,7,"В","В","ОТ","ОТ","ОТ","ОТ","ОТ","В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,null,{"$f":"SUM(- - ISTEXT(E153:AH153))","v":13},17,136.5,5,0,null,"Носов Н.Н.",8,5,0,0,0,0,0,0,0,0,0]
["2025-07-01",1,13,"Осин О.О.",8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ",8.25,8.25,8.25,8.25,null,{"$f":"SUM(- - ISTEXT(E154:AH154))","v":18},12,96.5,14,0,null,"Осин О.О.",4,14,0,0,0,0,0,0,0,0,0]
["2025-07-01",1,14,"Попов П.П.",8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,null,{"$f":"SUM(- - ISTEXT(E155:AH155))","v":8},22,176.5,0,0,null,"Попов П.П.",8,0,0,0,0,0,0,0,0,0,0]
["2025-07-01",1,15,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E156:AH156))","v":0},{"$f":"COUNT(E156:AH156)","v":0},{"$f":"SUM(E156:AH156)","v":0},{"$f":"COUNTIF(E156:AI156,\"ОТ\")","v":0},0,null,{"$f":"D156","v":0},0,0,0,0,0,0,0,0,0,0,0]
["2025-07-01",1,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,{"$f":"SUM(- - ISTEXT(E157:AH157))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-07-01",1,17,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E158:AH158))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-07-01",1,18,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E159:AH159))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-07-01",1,19,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E160:AH160))","v":0},0,0,0,0,null,0,{"$f":"COUNTIF($E160:$AI160,M$306)","v":0},0,0,0,0,0,0,0,0,0,0]
["2025-07-01",1,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,{"$f":"SUM(- - ISTEXT(E161:AH161))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[" ",null,null,null,{"$f":"IF(E163=TODAY(),МЕТКА,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"График",8,{"$f":"DATE(ГОД,C163,1)","v":"2025-08-01"},{"$f":"DATE(ГОД,C163,DAY(D163))","v":"2025-08-01"},{"$f":"IF(N(E163),IF(MONTH(E163+1)=$C163,E163+1,\"\"),\"\")","v":"2025-08-02"},"2025-08-03","2025-08-04","2025-08-05","2025-08-06","2025-08-07","2025-08-08","2025-08-09","2025-08-10","2025-08-11","2025-08-12","2025-08-13","2025-08-14","2025-08-15","2025-08-16","2025-08-17","2025-08-18","2025-08-19","2025-08-20","2025-08-21","2025-08-22","2025-08-23","2025-08-24","2025-08-25","2025-08-26","2025-08-27","2025-08-28","2025-08-29","2025-08-30",{"$f":"IF(N(AH163),IF(MONTH(AH163+1)=$C163,AH163+1,\"\"),\"\")","v":"2025-08-31"},null,{"$f":"AK$2","v":"Не раб. дней"},{"$f":"AL$2","v":"Раб. дней"},{"$f":"AM$2","v":"Раб. час"},{"$f":"AN$2","v":"Отпуск ПЛАН"},{"$f":"AO$2","v":"Отгуляно на СЕГОДНЯ"},null,{"$f":"$AQ$1","v":"ОТЧЁТ за месяц"}]
[{"$f":"DATE(ГОД,C163,1)","v":"2025-08-01"},null,null,null,{"$f":"E163","v":"2025-08-01"},"2025-08-02","2025-08-03","2025-08-04","2025-08-05","2025-08-06","2025-08-07","2025-08-08","2025-08-09","2025-08-10","2025-08-11","2025-08-12","2025-08-13","2025-08-14","2025-08-15","2025-08-16","2025-08-17","2025-08-18","2025-08-19","2025-08-20","2025-08-21","2025-08-22","2025-08-23","2025-08-24","2025-08-25","2025-08-26","2025-08-27","2025-08-28",{"$f":"AG163","v":"2025-08-29"},{"$f":"AH163","v":"2025-08-30"},{"$f":"AI163","v":"2025-08-31"},null,null,null,null,null,null,null,{"$f":"DATE(ГОД,C163,1)","v":"2025-08-01"},{"$f":"M$306","v":"В"},"ОТ","ДО","Б","НН","ПР","К","НОД","У","ОЗ","Г"]
[{"$f":"OFFSET(A165,-1,0)","v":"2025-08-01"},"4А",{"$f":"N(OFFSET(C165,-1,0))+1","v":1},"Алёхин А.А.",8,"В","В",13.5,8,"В","В",13.5,8,"В","В","ОТ","ОТ","ОТ","ОТ",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,{"$f":"SUM(- - ISTEXT(E165:AH165))","v":17},{"$f":"COUNT(E165:AH165)","v":13},{"$f":"SUM(E165:AH165)","v":137},{"$f":"COUNTIF(E165:AI165,\"ОТ\")","v":4},{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$117,0,IF(MONTH(TODAY())>$C$117,AN165,COUNTIF(OFFSET(E165,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,{"$f":"D165","v":"Алёхин А.А."},{"$f":"COUNTIF($E165:$AI165,M$306)","v":14},4,0,0,0,0,0,0,0,0,0]
[{"$f":"OFFSET(A166,-1,0)","v":"2025-08-01"},"4А",{"$f":"N(OFFSET(C166,-1,0))+1","v":2},"Борисов В.В.",8,"В","В",13.5,8,"В","В","ОТ","ОТ","В","В",13.5,8,"В","В","ОТ","ОТ","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,{"$f":"SUM(- - ISTEXT(E166:AH166))","v":19},{"$f":"COUNT(E166:AH166)","v":11},{"$f":"SUM(E166:AH166)","v":115.5},{"$f":"COUNTIF(E166:AI166,\"ОТ\")","v":4},0,null,{"$f":"D166","v":"Борисов В.В."},16,4,0,0,0,0,0,0,0,0,0]
["2025-08-01","4Б",3,"Володин В.В.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","В",null,{"$f":"SUM(- - ISTEXT(E167:AH167))","v":22},{"$f":"COUNT(E167:AH167)","v":8},{"$f":"SUM(E167:AH167)","v":86},{"$f":"COUNTIF(E167:AI167,\"ОТ\")","v":14},0,null,"Володин В.В.",9,14,0,0,0,0,0,0,0,0,0]
["2025-08-01","4Б",4,"Гаврилов Г.Г.","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В",null,{"$f":"SUM(- - ISTEXT(E168:AH168))","v":18},{"$f":"COUNT(E168:AH168)","v":12},{"$f":"SUM(E168:AH168)","v":129},{"$f":"COUNTIF(E168:AI168,\"ОТ\")","v":8},0,null,"Гаврилов Г.Г.",11,8,0,0,0,0,0,0,0,0,0]
["2025-08-01","4В",5,"Данилов Д.Д.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,null,{"$f":"SUM(- - ISTEXT(E169:AH169))","v":15},{"$f":"COUNT(E169:AH169)","v":15},{"$f":"SUM(E169:AH169)","v":164},{"$f":"COUNTIF(E169:AI169,\"ОТ\")","v":0},0,null,"Данилов Д.Д.",15,0,0,0,0,0,0,0,0,0,0]
["2025-08-01","4В",6,"Ежов Е.Е.","В",13.5,8,"В","В",13.5,8,"В","В","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ",null,{"$f":"SUM(- - ISTEXT(E170:AH170))","v":26},4,43,22,0,null,"Ежов Е.Е.",5,22,0,0,0,0,0,0,0,0,0]
["2025-08-01","4Г",7,"Зуев З.З.","ОТ","ОТ",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,{"$f":"SUM(- - ISTEXT(E171:AH171))","v":16},14,150.5,2,0,null,"Зуев З.З.",14,2,0,0,0,0,0,0,0,0,0]
["2025-08-01","4Г",8,"Иванов И.И.","В","В","ОТ","ОТ","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В","ОТ",null,{"$f":"SUM(- - ISTEXT(E172:AH172))","v":18},12,129,3,0,null,"Иванов И.И.",16,3,0,0,0,0,0,0,0,0,0]
["2025-08-01",1,9,"Козлов К.К.",7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",null,{"$f":"SUM(- - ISTEXT(E173:AH173))","v":9},21,167,0,0,null,"Козлов К.К.",10,0,0,0,0,0,0,0,0,0,0]
["2025-08-01",1,10,"Львов Л.Л.",7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",null,{"$f":"SUM(- - ISTEXT(E174:AH174))","v":9},21,167,0,0,null,"Львов Л.Л.",10,0,0,0,0,0,0,0,0,0,0]
["2025-08-01",1,11,"Мишин М.М.",7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",null,{"$f":"SUM(- - ISTEXT(E175:AH175))","v":9},21,167,0,0,null,"Мишин М.М.",10,0,0,0,0,0,0,0,0,0,0]
["2025-08-01",1,12,"Носов Н.Н.",7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",null,{"$f":"SUM(- - ISTEXT(E176:AH176))","v":9},21,167,0,0,null,"Носов Н.Н.",10,0,0,0,0,0,0,0,0,0,0]
["2025-08-01",1,13,"Осин О.О.",7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",null,{"$f":"SUM(- - ISTEXT(E177:AH177))","v":9},21,167,0,0,null,"Осин О.О.",10,0,0,0,0,0,0,0,0,0,0]
["2025-08-01",1,14,"Попов П.П.",7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",null,{"$f":"SUM(- - ISTEXT(E178:AH178))","v":9},21,167,0,0,null,"Попов П.П.",10,0,0,0,0,0,0,0,0,0,0]
["2025-08-01",1,15,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E179:AH179))","v":0},{"$f":"COUNT(E179:AH179)","v":0},{"$f":"SUM(E179:AH179)","v":0},{"$f":"COUNTIF(E179:AI179,\"ОТ\")","v":0},0,null,{"$f":"D179","v":0},0,0,0,0,0,0,0,0,0,0,0]
["2025-08-01",1,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,{"$f":"SUM(- - ISTEXT(E180:AH180))","v":0},{"$f":"COUNT(E180:AH180)","v":0},{"$f":"SUM(E180:AH180)","v":0},{"$f":"COUNTIF(E180:AI180,\"ОТ\")","v":0},0,null,{"$f":"D180","v":0},0,0,0,0,0,0,0,0,0,0,0]
["2025-08-01",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,{"$f":"SUM(- - ISTEXT(E181:AI181))","v":0},{"$f":"COUNT(E181:AI181)","v":0},{"$f":"SUM(E181:AI181)","v":0},{"$f":"COUNTIF(E181:AI181,\"ОТ\")","v":0},0,null,{"$f":"D181","v":0},0,0,0,0,0,0,0,0,0,0,0]
["2025-08-01",1,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,{"$f":"COUNTIF($E182:$AI182,W$306)","v":0}]
["2025-08-01",1,2,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E183:AI183))","v":0},{"$f":"COUNT(E183:AI183)","v":0},{"$f":"SUM(E183:AI183)","v":0},{"$f":"COUNTIF(E183:AI183,\"ОТ\")","v":0},{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$117,0,IF(MONTH(TODAY())>$C$117,AN183,COUNTIF(OFFSET(E183,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,{"$f":"D183","v":0},{"$f":"COUNTIF($E183:$AI183,M$306)","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$f":"OFFSET(A183,-1,0)","v":"2025-08-01"},1,3,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E184:AI184))","v":0},{"$f":"COUNT(E184:AI184)","v":0},{"$f":"SUM(E184:AI184)","v":0},{"$f":"COUNTIF(E184:AI184,\"ОТ\")","v":0},{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$117,0,IF(MONTH(TODAY())>$C$117,AN184,COUNTIF(OFFSET(E184,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,{"$f":"D184","v":0},0,0,0,0,0,0,0,0,0,0,0]
[" ",null,null,null,{"$f":"IF(E186=TODAY(),МЕТКА,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"График",9,{"$f":"DATE(ГОД,C186,1)","v":"2025-09-01"},{"$f":"DATE(ГОД,C186,DAY(D186))","v":"2025-09-01"},{"$f":"IF(N(E186),IF(MONTH(E186+1)=$C186,E186+1,\"\"),\"\")","v":"2025-09-02"},"2025-09-03","2025-09-04","2025-09-05","2025-09-06","2025-09-07","2025-09-08","2025-09-09","2025-09-10","2025-09-11","2025-09-12","2025-09-13","2025-09-14","2025-09-15","2025-09-16","2025-09-17","2025-09-18","2025-09-19","2025-09-20","2025-09-21","2025-09-22","2025-09-23","2025-09-24","2025-09-25","2025-09-26","2025-09-27","2025-09-28","2025-09-29","2025-09-30",{"$f":"IF(N(AH186),IF(MONTH(AH186+1)=$C186,AH186+1,\"\"),\"\")","v":""},null,{"$f":"AK$2","v":"Не раб. дней"},{"$f":"AL$2","v":"Раб. дней"},{"$f":"AM$2","v":"Раб. час"},{"$f":"AN$2","v":"Отпуск ПЛАН"},{"$f":"AO$2","v":"Отгуляно на СЕГОДНЯ"},null,{"$f":"$AQ$1","v":"ОТЧЁТ за месяц"}]
[{"$f":"DATE(ГОД,C186,1)","v":"2025-09-01"},null,null,null,{"$f":"E186","v":"2025-09-01"},"2025-09-02","2025-09-03","2025-09-04","2025-09-05","2025-09-06","2025-09-07","2025-09-08","2025-09-09","2025-09-10","2025-09-11","2025-09-12","2025-09-13","2025-09-14","2025-09-15","2025-09-16","2025-09-17","2025-09-18","2025-09-19","2025-09-20","2025-09-21","2025-09-22","2025-09-23","2025-09-24","2025-09-25","2025-09-26","2025-09-27","2025-09-28",{"$f":"AG186","v":"2025-09-29"},{"$f":"AH186","v":"2025-09-30"},{"$f":"AI186","v":""},null,null,null,null,null,null,null,{"$f":"DATE(ГОД,C186,1)","v":"2025-09-01"},{"$f":"M$306","v":"В"},"ОТ","ДО","Б","НН","ПР","К","НОД","У","ОЗ","Г"]
[{"$f":"OFFSET(A188,-1,0)","v":"2025-09-01"},"4А",{"$f":"N(OFFSET(C188,-1,0))+1","v":1},"Алёхин А.А.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,null,null,{"$f":"SUM(- - ISTEXT(E188:AH188))","v":14},{"$f":"COUNT(E188:AH188)","v":16},{"$f":"SUM(E188:AH188)","v":172},{"$f":"COUNTIF(E188:AI188,\"ОТ\")","v":0},{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$117,0,IF(MONTH(TODAY())>$C$117,AN188,COUNTIF(OFFSET(E188,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,{"$f":"D188","v":"Алёхин А.А."},{"$f":"COUNTIF($E188:$AI188,M$306)","v":14},0,0,0,0,0,0,0,0,0,0]
[{"$f":"OFFSET(A189,-1,0)","v":"2025-09-01"},"4А",{"$f":"N(OFFSET(C189,-1,0))+1","v":2},"Борисов В.В.",13.5,8,"В","В",13.5,8,"В","В","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,null,null,{"$f":"SUM(- - ISTEXT(E189:AH189))","v":18},12,129,6,0,null,{"$f":"D189","v":"Борисов В.В."},12,6,0,0,0,0,0,0,0,0,0]
["2025-09-01","4Б",3,"Володин В.В.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,null,{"$f":"SUM(- - ISTEXT(E190:AH190))","v":15},15,164,0,0,null,"Володин В.В.",15,0,0,0,0,0,0,0,0,0,0]
["2025-09-01","4Б",4,"Гаврилов Г.Г.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,null,{"$f":"SUM(- - ISTEXT(E191:AH191))","v":15},15,164,0,0,null,"Гаврилов Г.Г.",15,0,0,0,0,0,0,0,0,0,0]
["2025-09-01","4В",5,"Данилов Д.Д.","В","В","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,null,{"$f":"SUM(- - ISTEXT(E192:AH192))","v":24},6,64.5,14,0,null,"Данилов Д.Д.",10,14,0,0,0,0,0,0,0,0,0]
["2025-09-01","4В",6,"Ежов Е.Е.","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,null,{"$f":"SUM(- - ISTEXT(E193:AH193))","v":16},14,150.5,0,0,null,"Ежов Е.Е.",16,0,0,0,0,0,0,0,0,0,0]
["2025-09-01","4Г",7,"Зуев З.З.",8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"ОТ","ОТ","ОТ","ОТ","ОТ","ОТ",13.5,8,"В",null,null,{"$f":"SUM(- - ISTEXT(E194:AH194))","v":17},13,137,6,0,null,"Зуев З.З.",11,6,0,0,0,0,0,0,0,0,0]
["2025-09-01","4Г",8,"Иванов И.И.","ОТ","ОТ","ОТ","ОТ","ОТ","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В",null,null,{"$f":"SUM(- - ISTEXT(E195:AH195))","v":18},12,129,5,0,null,"Иванов И.И.",13,5,0,0,0,0,0,0,0,0,0]
["2025-09-01",1,9,"Козлов К.К.",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,null,null,{"$f":"SUM(- - ISTEXT(E196:AH196))","v":8},22,176.5,0,0,null,"Козлов К.К.",8,0,0,0,0,0,0,0,0,0,0]
["2025-09-01",1,10,"Львов Л.Л.",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,null,null,{"$f":"SUM(- - ISTEXT(E197:AH197))","v":8},22,176.5,0,0,null,"Львов Л.Л.",8,0,0,0,0,0,0,0,0,0,0]
["2025-09-01",1,11,"Мишин М.М.",8.25,8.25,8.25,8.25,7,"В","В","ОТ","ОТ","ОТ","ОТ","ОТ","В","В","ОТ","ОТ","ОТ","ОТ","ОТ","В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,null,null,{"$f":"SUM(- - ISTEXT(E198:AH198))","v":18},12,96.5,10,0,null,"Мишин М.М.",8,10,0,0,0,0,0,0,0,0,0]
["2025-09-01",1,12,"Носов Н.Н.",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,"ОТ","ОТ","В","В","ОТ","ОТ",null,null,{"$f":"SUM(- - ISTEXT(E199:AH199))","v":12},18,144.75,4,0,null,"Носов Н.Н.",8,4,0,0,0,0,0,0,0,0,0]
["2025-09-01",1,13,"Осин О.О.",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,null,null,{"$f":"SUM(- - ISTEXT(E200:AH200))","v":8},22,176.5,0,0,null,"Осин О.О.",8,0,0,0,0,0,0,0,0,0,0]
["2025-09-01",1,14,"Попов П.П.",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,null,null,{"$f":"SUM(- - ISTEXT(E201:AI201))","v":8},{"$f":"COUNT(E201:AI201)","v":22},{"$f":"SUM(E201:AI201)","v":176.5},0,0,null,"Попов П.П.",8,0,0,0,0,0,0,0,0,0,0]
["2025-09-01",1,15,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E202:AI202))","v":0},{"$f":"COUNT(E202:AI202)","v":0},{"$f":"SUM(E202:AI202)","v":0},{"$f":"COUNTIF(E202:AI202,\"ОТ\")","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-09-01",1,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,{"$f":"SUM(- - ISTEXT(E203:AI203))","v":0},{"$f":"COUNT(E203:AI203)","v":0},{"$f":"SUM(E203:AI203)","v":0},0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-09-01",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,{"$f":"SUM(- - ISTEXT(E204:AI204))","v":0},{"$f":"COUNT(E204:AI204)","v":0},{"$f":"SUM(E204:AI204)","v":0},0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"OFFSET(A204,-1,0)","v":"2025-09-01"},1,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,{"$f":"SUM(- - ISTEXT(E205:AI205))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-09-01",1,2,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E206:AI206))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"OFFSET(A206,-1,0)","v":"2025-09-01"},1,3,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E207:AI207))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[" ",null,null,null,{"$f":"IF(E209=TODAY(),МЕТКА,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"График",10,{"$f":"DATE(ГОД,C209,1)","v":"2025-10-01"},{"$f":"DATE(ГОД,C209,DAY(D209))","v":"2025-10-01"},{"$f":"IF(N(E209),IF(MONTH(E209+1)=$C209,E209+1,\"\"),\"\")","v":"2025-10-02"},"2025-10-03","2025-10-04","2025-10-05","2025-10-06","2025-10-07","2025-10-08","2025-10-09","2025-10-10","2025-10-11","2025-10-12","2025-10-13","2025-10-14","2025-10-15","2025-10-16","2025-10-17","2025-10-18","2025-10-19","2025-10-20","2025-10-21","2025-10-22","2025-10-23","2025-10-24","2025-10-25","2025-10-26","2025-10-27","2025-10-28","2025-10-29","2025-10-30",{"$f":"IF(N(AH209),IF(MONTH(AH209+1)=$C209,AH209+1,\"\"),\"\")","v":"2025-10-31"},null,{"$f":"AK$2","v":"Не раб. дней"},{"$f":"AL$2","v":"Раб. дней"},{"$f":"AM$2","v":"Раб. час"},{"$f":"AN$2","v":"Отпуск ПЛАН"},{"$f":"AO$2","v":"Отгуляно на СЕГОДНЯ"},null,{"$f":"$AQ$1","v":"ОТЧЁТ за месяц"}]
[{"$f":"DATE(ГОД,C209,1)","v":"2025-10-01"},null,null,null,{"$f":"E209","v":"2025-10-01"},"2025-10-02","2025-10-03","2025-10-04","2025-10-05","2025-10-06","2025-10-07","2025-10-08","2025-10-09","2025-10-10","2025-10-11","2025-10-12","2025-10-13","2025-10-14","2025-10-15","2025-10-16","2025-10-17","2025-10-18","2025-10-19","2025-10-20","2025-10-21","2025-10-22","2025-10-23","2025-10-24","2025-10-25","2025-10-26","2025-10-27","2025-10-28",{"$f":"AG209","v":"2025-10-29"},{"$f":"AH209","v":"2025-10-30"},{"$f":"AI209","v":"2025-10-31"},null,null,null,null,null,null,null,{"$f":"DATE(ГОД,C209,1)","v":"2025-10-01"},{"$f":"M$306","v":"В"},"ОТ","ДО","Б","НН","ПР","К","НОД","У","ОЗ","Г"]
[{"$f":"OFFSET(A211,-1,0)","v":"2025-10-01"},"4А",{"$f":"N(OFFSET(C211,-1,0))+1","v":1},"Алёхин А.А.","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,{"$f":"SUM(- - ISTEXT(E211:AH211))","v":16},{"$f":"COUNT(E211:AH211)","v":14},{"$f":"SUM(E211:AH211)","v":150.5},{"$f":"COUNTIF(E211:AI211,\"ОТ\")","v":0},{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$117,0,IF(MONTH(TODAY())>$C$117,AN211,COUNTIF(OFFSET(E211,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,{"$f":"D211","v":"Алёхин А.А."},{"$f":"COUNTIF($E211:$AI211,M$306)","v":16},0,0,0,0,0,0,0,0,0,0]
[{"$f":"OFFSET(A212,-1,0)","v":"2025-10-01"},"4А",{"$f":"N(OFFSET(C212,-1,0))+1","v":2},"Борисов В.В.","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В","ОТ","ОТ","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,{"$f":"SUM(- - ISTEXT(E212:AH212))","v":18},12,129,2,0,null,{"$f":"D212","v":"Борисов В.В."},16,2,0,0,0,0,0,0,0,0,0]
["2025-10-01","4Б",3,"Володин В.В.",8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,{"$f":"SUM(- - ISTEXT(E213:AH213))","v":15},15,158.5,0,0,null,"Володин В.В.",16,0,0,0,0,0,0,0,0,0,0]
["2025-10-01","4Б",4,"Гаврилов Г.Г.",8,"В","В",13.5,8,"В","В","ОТ","ОТ","ОТ","ОТ",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,{"$f":"SUM(- - ISTEXT(E214:AH214))","v":17},13,137,4,0,null,"Гаврилов Г.Г.",14,4,0,0,0,0,0,0,0,0,0]
["2025-10-01","4В",5,"Данилов Д.Д.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В",null,{"$f":"SUM(- - ISTEXT(E215:AH215))","v":14},16,172,0,0,null,"Данилов Д.Д.",15,0,0,0,0,0,0,0,0,0,0]
["2025-10-01","4В",6,"Ежов Е.Е.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В",null,{"$f":"SUM(- - ISTEXT(E216:AH216))","v":14},16,172,0,0,null,"Ежов Е.Е.",15,0,0,0,0,0,0,0,0,0,0]
["2025-10-01","4Г",7,"Зуев З.З.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,null,{"$f":"SUM(- - ISTEXT(E217:AH217))","v":15},15,164,0,0,null,"Зуев З.З.",15,0,0,0,0,0,0,0,0,0,0]
["2025-10-01","4Г",8,"Иванов И.И.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,null,{"$f":"SUM(- - ISTEXT(E218:AH218))","v":15},15,164,0,0,null,"Иванов И.И.",15,0,0,0,0,0,0,0,0,0,0]
["2025-10-01",1,9,"Козлов К.К.",8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,{"$f":"SUM(- - ISTEXT(E219:AH219))","v":8},22,176.5,0,0,null,"Козлов К.К.",8,0,0,0,0,0,0,0,0,0,0]
["2025-10-01",1,10,"Львов Л.Л.",8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,{"$f":"SUM(- - ISTEXT(E220:AH220))","v":8},22,176.5,0,0,null,"Львов Л.Л.",8,0,0,0,0,0,0,0,0,0,0]
["2025-10-01",1,11,"Мишин М.М.",8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,{"$f":"SUM(- - ISTEXT(E221:AH221))","v":8},{"$f":"COUNT(E221:AH221)","v":22},{"$f":"SUM(E221:AH221)","v":176.5},0,0,null,"Мишин М.М.",8,0,0,0,0,0,0,0,0,0,0]
["2025-10-01",1,12,"Носов Н.Н.","ОТ",8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В","ОТ","ОТ","ОТ","ОТ","ОТ",null,{"$f":"SUM(- - ISTEXT(E222:AH222))","v":13},{"$f":"COUNT(E222:AH222)","v":17},{"$f":"SUM(E222:AH222)","v":135.25},6,0,null,"Носов Н.Н.",8,6,0,0,0,0,0,0,0,0,0]
["2025-10-01",1,13,"Осин О.О.",8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ",8.25,8.25,8.25,8.25,7,null,{"$f":"SUM(- - ISTEXT(E223:AH223))","v":18},{"$f":"COUNT(E223:AH223)","v":12},{"$f":"SUM(E223:AH223)","v":96.5},14,0,null,"Осин О.О.",4,14,0,0,0,0,0,0,0,0,0]
["2025-10-01",1,14,"Попов П.П.",8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,{"$f":"SUM(- - ISTEXT(E224:AI224))","v":8},{"$f":"COUNT(E224:AI224)","v":23},{"$f":"SUM(E224:AI224)","v":183.5},0,0,null,"Попов П.П.",8,0,0,0,0,0,0,0,0,0,0]
["2025-10-01",1,15,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E225:AI225))","v":0},0,0,{"$f":"COUNTIF(E225:AI225,\"ОТ\")","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"OFFSET(A223,-1,0)","v":"2025-10-01"},1,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,{"$f":"SUM(- - ISTEXT(E226:AI226))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-10-01",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,{"$f":"SUM(- - ISTEXT(E227:AI227))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"OFFSET(A225,-1,0)","v":"2025-10-01"},1,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,{"$f":"SUM(- - ISTEXT(E228:AI228))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-10-01",1,2,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E229:AI229))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"OFFSET(A229,-1,0)","v":"2025-10-01"},1,3,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E230:AI230))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[" ",null,null,null,{"$f":"IF(E232=TODAY(),МЕТКА,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"График",11,{"$f":"DATE(ГОД,C232,1)","v":"2025-11-01"},{"$f":"DATE(ГОД,C232,DAY(D232))","v":"2025-11-01"},{"$f":"IF(N(E232),IF(MONTH(E232+1)=$C232,E232+1,\"\"),\"\")","v":"2025-11-02"},"2025-11-03","2025-11-04","2025-11-05","2025-11-06","2025-11-07","2025-11-08","2025-11-09","2025-11-10","2025-11-11","2025-11-12","2025-11-13","2025-11-14","2025-11-15","2025-11-16","2025-11-17","2025-11-18","2025-11-19","2025-11-20","2025-11-21","2025-11-22","2025-11-23","2025-11-24","2025-11-25","2025-11-26","2025-11-27","2025-11-28","2025-11-29","2025-11-30",{"$f":"IF(N(AH232),IF(MONTH(AH232+1)=$C232,AH232+1,\"\"),\"\")","v":""},null,{"$f":"AK$2","v":"Не раб. дней"},{"$f":"AL$2","v":"Раб. дней"},{"$f":"AM$2","v":"Раб. час"},{"$f":"AN$2","v":"Отпуск ПЛАН"},{"$f":"AO$2","v":"Отгуляно на СЕГОДНЯ"},null,{"$f":"$AQ$1","v":"ОТЧЁТ за месяц"}]
[{"$f":"DATE(ГОД,C232,1)","v":"2025-11-01"},null,null,null,{"$f":"E232","v":"2025-11-01"},"2025-11-02","2025-11-03","2025-11-04","2025-11-05","2025-11-06","2025-11-07","2025-11-08","2025-11-09","2025-11-10","2025-11-11","2025-11-12","2025-11-13","2025-11-14","2025-11-15","2025-11-16","2025-11-17","2025-11-18","2025-11-19","2025-11-20","2025-11-21","2025-11-22","2025-11-23","2025-11-24","2025-11-25","2025-11-26","2025-11-27","2025-11-28",{"$f":"AG232","v":"2025-11-29"},{"$f":"AH232","v":"2025-11-30"},{"$f":"AI232","v":""},null,null,null,null,null,null,null,{"$f":"DATE(ГОД,C232,1)","v":"2025-11-01"},{"$f":"M$306","v":"В"},"ОТ","ДО","Б","НН","ПР","К","НОД","У","ОЗ","Г"]
[{"$f":"OFFSET(A234,-1,0)","v":"2025-11-01"},"4А",{"$f":"N(OFFSET(C234,-1,0))+1","v":1},"Алёхин А.А.",8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ",null,null,{"$f":"SUM(- - ISTEXT(E234:AH234))","v":19},{"$f":"COUNT(E234:AH234)","v":11},{"$f":"SUM(E234:AH234)","v":115.5},{"$f":"COUNTIF(E234:AI234,\"ОТ\")","v":7},{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$117,0,IF(MONTH(TODAY())>$C$117,AN234,COUNTIF(OFFSET(E234,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,{"$f":"D234","v":"Алёхин А.А."},{"$f":"COUNTIF($E234:$AI234,M$306)","v":12},7,0,0,0,0,0,0,0,0,0]
[{"$f":"OFFSET(A235,-1,0)","v":"2025-11-01"},"4А",{"$f":"N(OFFSET(C235,-1,0))+1","v":2},"Борисов В.В.",8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В",null,null,{"$f":"SUM(- - ISTEXT(E235:AH235))","v":15},15,158.5,0,0,null,{"$f":"D235","v":"Борисов В.В."},15,0,0,0,0,0,0,0,0,0,0]
["2025-11-01","4Б",3,"Володин В.В.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,null,null,{"$f":"SUM(- - ISTEXT(E236:AH236))","v":14},16,172,0,0,null,"Володин В.В.",14,0,0,0,0,0,0,0,0,0,0]
["2025-11-01","4Б",4,"Гаврилов Г.Г.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,null,null,{"$f":"SUM(- - ISTEXT(E237:AH237))","v":14},16,172,0,0,null,"Гаврилов Г.Г.",14,0,0,0,0,0,0,0,0,0,0]
["2025-11-01","4В",5,"Данилов Д.Д.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,null,{"$f":"SUM(- - ISTEXT(E238:AH238))","v":15},15,164,0,0,null,"Данилов Д.Д.",15,0,0,0,0,0,0,0,0,0,0]
["2025-11-01","4В",6,"Ежов Е.Е.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,null,{"$f":"SUM(- - ISTEXT(E239:AH239))","v":15},15,164,0,0,null,"Ежов Е.Е.",15,0,0,0,0,0,0,0,0,0,0]
["2025-11-01","4Г",7,"Зуев З.З.","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,null,{"$f":"SUM(- - ISTEXT(E240:AH240))","v":16},14,150.5,0,0,null,"Зуев З.З.",16,0,0,0,0,0,0,0,0,0,0]
["2025-11-01","4Г",8,"Иванов И.И.","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,null,{"$f":"SUM(- - ISTEXT(E241:AH241))","v":16},14,150.5,0,0,null,"Иванов И.И.",16,0,0,0,0,0,0,0,0,0,0]
["2025-11-01",1,9,"Козлов К.К.",7.25,"В","В","В",8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",null,null,{"$f":"SUM(- - ISTEXT(E242:AI242))","v":11},{"$f":"COUNT(E242:AI242)","v":19},{"$f":"SUM(E242:AI242)","v":150.75},0,0,null,"Козлов К.К.",11,0,0,0,0,0,0,0,0,0,0]
["2025-11-01",1,10,"Львов Л.Л.",7.25,"В","В","В",8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",null,null,{"$f":"SUM(- - ISTEXT(E243:AI243))","v":11},19,150.75,0,0,null,"Львов Л.Л.",11,0,0,0,0,0,0,0,0,0,0]
["2025-11-01",1,11,"Мишин М.М.",7.25,"В","В","В",8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",null,null,{"$f":"SUM(- - ISTEXT(E244:AI244))","v":11},19,150.75,0,0,null,"Мишин М.М.",11,0,0,0,0,0,0,0,0,0,0]
["2025-11-01",1,12,"Носов Н.Н.","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",null,null,{"$f":"SUM(- - ISTEXT(E245:AI245))","v":15},15,120,9,0,null,"Носов Н.Н.",6,9,0,0,0,0,0,0,0,0,0]
["2025-11-01",1,13,"Осин О.О.",7.25,"В","В","В",8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",null,null,{"$f":"SUM(- - ISTEXT(E246:AI246))","v":11},19,150.75,0,0,null,"Осин О.О.",11,0,0,0,0,0,0,0,0,0,0]
["2025-11-01",1,14,"Попов П.П.",7.25,"В","В","В",8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",null,null,{"$f":"SUM(- - ISTEXT(E247:AI247))","v":11},19,150.75,0,0,null,"Попов П.П.",11,0,0,0,0,0,0,0,0,0,0]
["2025-11-01",1,15,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E248:AI248))","v":0},0,0,{"$f":"COUNTIF(E248:AI248,\"ОТ\")","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-11-01",1,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,{"$f":"SUM(- - ISTEXT(E249:AI249))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-11-01",1,17,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E250:AI250))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-11-01",1,18,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E251:AI251))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-11-01",1,19,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E252:AI252))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"OFFSET(A252,-1,0)","v":"2025-11-01"},1,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,{"$f":"SUM(- - ISTEXT(E253:AI253))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[" ",null,null,null,{"$f":"IF(E255=TODAY(),МЕТКА,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"График",12,{"$f":"DATE(ГОД,C255,1)","v":"2025-12-01"},{"$f":"DATE(ГОД,C255,DAY(D255))","v":"2025-12-01"},{"$f":"IF(N(E255),IF(MONTH(E255+1)=$C255,E255+1,\"\"),\"\")","v":"2025-12-02"},"2025-12-03","2025-12-04","2025-12-05","2025-12-06","2025-12-07","2025-12-08","2025-12-09","2025-12-10","2025-12-11","2025-12-12","2025-12-13","2025-12-14","2025-12-15","2025-12-16","2025-12-17","2025-12-18","2025-12-19","2025-12-20","2025-12-21","2025-12-22","2025-12-23","2025-12-24","2025-12-25","2025-12-26","2025-12-27","2025-12-28","2025-12-29","2025-12-30",{"$f":"IF(N(AH255),IF(MONTH(AH255+1)=$C255,AH255+1,\"\"),\"\")","v":"2025-12-31"},null,{"$f":"AK$2","v":"Не раб. дней"},{"$f":"AL$2","v":"Раб. дней"},{"$f":"AM$2","v":"Раб. час"},{"$f":"AN$2","v":"Отпуск ПЛАН"},{"$f":"AO$2","v":"Отгуляно на СЕГОДНЯ"},null,{"$f":"$AQ$1","v":"ОТЧЁТ за месяц"}]
[{"$f":"DATE(ГОД,C255,1)","v":"2025-12-01"},null,null,null,{"$f":"E255","v":"2025-12-01"},"2025-12-02","2025-12-03","2025-12-04","2025-12-05","2025-12-06","2025-12-07","2025-12-08","2025-12-09","2025-12-10","2025-12-11","2025-12-12","2025-12-13","2025-12-14","2025-12-15","2025-12-16","2025-12-17","2025-12-18","2025-12-19","2025-12-20","2025-12-21","2025-12-22","2025-12-23","2025-12-24","2025-12-25","2025-12-26","2025-12-27","2025-12-28",{"$f":"AG255","v":"2025-12-29"},{"$f":"AH255","v":"2025-12-30"},{"$f":"AI255","v":"2025-12-31"},null,null,null,null,null,null,null,{"$f":"DATE(ГОД,C255,1)","v":"2025-12-01"},{"$f":"M$306","v":"В"},"ОТ","ДО","Б","НН","ПР","К","НОД","У","ОЗ","Г"]
[{"$f":"OFFSET(A257,-1,0)","v":"2025-12-01"},"4А",{"$f":"N(OFFSET(C257,-1,0))+1","v":1},"Алёхин А.А.","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,null,{"$f":"SUM(- - ISTEXT(E257:AH257))","v":19},{"$f":"COUNT(E257:AH257)","v":11},{"$f":"SUM(E257:AH257)","v":121},{"$f":"COUNTIF(E257:AI257,\"ОТ\")","v":7},{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$117,0,IF(MONTH(TODAY())>$C$117,AN257,COUNTIF(OFFSET(E257,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,{"$f":"D257","v":"Алёхин А.А."},{"$f":"COUNTIF($E257:$AI257,M$306)","v":12},7,0,0,0,0,0,0,0,0,0]
[{"$f":"OFFSET(A258,-1,0)","v":"2025-12-01"},"4А",{"$f":"N(OFFSET(C258,-1,0))+1","v":2},"Борисов В.В.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,null,{"$f":"SUM(- - ISTEXT(E258:AH258))","v":15},15,164,0,0,null,{"$f":"D258","v":"Борисов В.В."},15,0,0,0,0,0,0,0,0,0,0]
["2025-12-01","4Б",3,"Володин В.В.","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,{"$f":"SUM(- - ISTEXT(E259:AH259))","v":16},14,150.5,0,0,null,"Володин В.В.",16,0,0,0,0,0,0,0,0,0,0]
["2025-12-01","4Б",4,"Гаврилов Г.Г.","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,{"$f":"SUM(- - ISTEXT(E260:AH260))","v":16},14,150.5,0,0,null,"Гаврилов Г.Г.",16,0,0,0,0,0,0,0,0,0,0]
["2025-12-01","4В",5,"Данилов Д.Д.",8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,{"$f":"SUM(- - ISTEXT(E261:AH261))","v":15},15,158.5,0,0,null,"Данилов Д.Д.",16,0,0,0,0,0,0,0,0,0,0]
["2025-12-01","4В",6,"Ежов Е.Е.",8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,{"$f":"SUM(- - ISTEXT(E262:AH262))","v":15},15,158.5,0,0,null,"Ежов Е.Е.",16,0,0,0,0,0,0,0,0,0,0]
["2025-12-01","4Г",7,"Зуев З.З.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В",null,{"$f":"SUM(- - ISTEXT(E263:AH263))","v":14},16,172,0,0,null,"Зуев З.З.",15,0,0,0,0,0,0,0,0,0,0]
["2025-12-01","4Г",8,"Иванов И.И.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В",null,{"$f":"SUM(- - ISTEXT(E264:AH264))","v":14},16,172,0,0,null,"Иванов И.И.",15,0,0,0,0,0,0,0,0,0,0]
["2025-12-01",1,9,"Козлов К.К.",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,"В",null,{"$f":"SUM(- - ISTEXT(E265:AH265))","v":8},{"$f":"COUNT(E265:AH265)","v":22},{"$f":"SUM(E265:AH265)","v":176.5},0,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$117,0,IF(MONTH(TODAY())>$C$117,AN265,COUNTIF(OFFSET(#REF!,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,"Козлов К.К.",9,0,0,0,0,0,0,0,0,0,0]
["2025-12-01",1,10,"Львов Л.Л.",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,"В",null,{"$f":"SUM(- - ISTEXT(E266:AH266))","v":8},{"$f":"COUNT(E266:AH266)","v":22},{"$f":"SUM(E266:AH266)","v":176.5},0,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$117,0,IF(MONTH(TODAY())>$C$117,AN266,COUNTIF(OFFSET(#REF!,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,"Львов Л.Л.",9,0,0,0,0,0,0,0,0,0,0]
["2025-12-01",1,11,"Мишин М.М.",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,"В",null,{"$f":"SUM(- - ISTEXT(E267:AH267))","v":8},{"$f":"COUNT(E267:AH267)","v":22},{"$f":"SUM(E267:AH267)","v":176.5},0,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$117,0,IF(MONTH(TODAY())>$C$117,AN267,COUNTIF(OFFSET(#REF!,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,"Мишин М.М.",9,0,0,0,0,0,0,0,0,0,0]
["2025-12-01",1,12,"Носов Н.Н.",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,"ОТ","В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,"В",null,{"$f":"SUM(- - ISTEXT(E268:AH268))","v":9},{"$f":"COUNT(E268:AH268)","v":21},{"$f":"SUM(E268:AH268)","v":169.5},1,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$117,0,IF(MONTH(TODAY())>$C$117,AN268,COUNTIF(OFFSET(#REF!,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,"Носов Н.Н.",9,1,0,0,0,0,0,0,0,0,0]
["2025-12-01",1,13,"Осин О.О.",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,"В",null,{"$f":"SUM(- - ISTEXT(E269:AI269))","v":9},{"$f":"COUNT(E269:AI269)","v":22},{"$f":"SUM(E269:AI269)","v":176.5},0,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$117,0,IF(MONTH(TODAY())>$C$117,AN269,COUNTIF(OFFSET(#REF!,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,"Осин О.О.",9,0,0,0,0,0,0,0,0,0,0]
["2025-12-01",1,14,"Попов П.П.",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,"В",null,{"$f":"SUM(- - ISTEXT(E270:AI270))","v":9},22,176.5,0,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$117,0,IF(MONTH(TODAY())>$C$117,AN270,COUNTIF(OFFSET(#REF!,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,"Попов П.П.",9,0,0,0,0,0,0,0,0,0,0]
["2025-12-01",1,15,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E271:AI271))","v":0},0,0,0,{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$117,0,IF(MONTH(TODAY())>$C$117,AN271,COUNTIF(OFFSET(E271,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-12-01",1,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,{"$f":"SUM(- - ISTEXT(E272:AI272))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-12-01",1,17,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E273:AI273))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-12-01",1,18,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E274:AI274))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-12-01",1,19,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E275:AI275))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"OFFSET(A275,-1,0)","v":"2025-12-01"},1,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,{"$f":"SUM(- - ISTEXT(E276:AI276))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF($E276:$AI276,W$306)","v":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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Конец года:","End"]
[]
[" ",null,null,{"$f":"ГОД+1","v":2026},{"$f":"IF(E280=TODAY(),МЕТКА,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"График",1,{"$f":"DATE(ГОД+1,C280,1)","v":"2026-01-01"},{"$f":"DATE(ГОД,C280,DAY(D280))","v":"2025-01-01"},{"$f":"IF(N(E280),IF(MONTH(E280+1)=$C280,E280+1,\"\"),\"\")","v":"2025-01-02"},"2025-01-03","2025-01-04","2025-01-05","2025-01-06","2025-01-07","2025-01-08","2025-01-09","2025-01-10","2025-01-11","2025-01-12","2025-01-13","2025-01-14","2025-01-15","2025-01-16","2025-01-17","2025-01-18","2025-01-19","2025-01-20","2025-01-21","2025-01-22","2025-01-23","2025-01-24","2025-01-25","2025-01-26","2025-01-27","2025-01-28","2025-01-29","2025-01-30",{"$f":"IF(N(AH280),IF(MONTH(AH280+1)=$C280,AH280+1,\"\"),\"\")","v":"2025-01-31"},null,{"$f":"AK$2","v":"Не раб. дней"},{"$f":"AL$2","v":"Раб. дней"},{"$f":"AM$2","v":"Раб. час"},{"$f":"AN$2","v":"Отпуск ПЛАН"},{"$f":"AO$2","v":"Отгуляно на СЕГОДНЯ"},null,{"$f":"$AQ$1","v":"ОТЧЁТ за месяц"}]
[{"$f":"DATE(ГОД,C280,1)","v":"2025-01-01"},null,null,null,{"$f":"E280","v":"2025-01-01"},"2025-01-02","2025-01-03","2025-01-04","2025-01-05","2025-01-06","2025-01-07","2025-01-08","2025-01-09","2025-01-10","2025-01-11","2025-01-12","2025-01-13","2025-01-14","2025-01-15","2025-01-16","2025-01-17","2025-01-18","2025-01-19","2025-01-20","2025-01-21","2025-01-22","2025-01-23","2025-01-24","2025-01-25","2025-01-26","2025-01-27","2025-01-28",{"$f":"AG280","v":"2025-01-29"},{"$f":"AH280","v":"2025-01-30"},{"$f":"AI280","v":"2025-01-31"},null,null,null,null,null,null,null,{"$f":"DATE(ГОД+1,C280,1)","v":"2026-01-01"},{"$f":"M$306","v":"В"},"ОТ","ДО","Б","НН","ПР","К","НОД","У","ОЗ","Г"]
[{"$f":"OFFSET(A282,-1,0)","v":"2025-01-01"},"4А",{"$f":"N(OFFSET(C282,-1,0))+1","v":1},"Алёхин А.А.","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,{"$f":"SUM(- - ISTEXT(E282:AH282))","v":16},{"$f":"COUNT(E282:AH282)","v":14},{"$f":"SUM(E282:AH282)","v":150.5},{"$f":"COUNTIF(E282:AI282,\"ОТ\")","v":0},{"$f":"IF(ГОД=YEAR(TODAY()),IF(MONTH(TODAY())<$C$117,0,IF(MONTH(TODAY())>$C$117,AN282,COUNTIF(OFFSET(E282,0,0,,DAY(TODAY())),\"ОТ\"))),0)","v":0},null,{"$f":"D282","v":"Алёхин А.А."},{"$f":"COUNTIF($E282:$AI282,M$306)","v":16},0,0,0,0,0,0,0,0,0,0]
[{"$f":"OFFSET(A283,-1,0)","v":"2025-01-01"},"4А",{"$f":"N(OFFSET(C283,-1,0))+1","v":2},"Борисов В.В.","В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,null,{"$f":"SUM(- - ISTEXT(E283:AH283))","v":16},14,150.5,0,0,null,"Борисов В.В.",16,0,0,0,0,0,0,0,0,0,0]
["2025-01-01","4Б",3,"Володин В.В.",8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,{"$f":"SUM(- - ISTEXT(E284:AH284))","v":15},15,158.5,0,0,null,"Володин В.В.",16,0,0,0,0,0,0,0,0,0,0]
["2025-01-01","4Б",4,"Гаврилов Г.Г.",8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",null,{"$f":"SUM(- - ISTEXT(E285:AH285))","v":15},15,158.5,0,0,null,"Гаврилов Г.Г.",16,0,0,0,0,0,0,0,0,0,0]
["2025-01-01","4В",5,"Данилов Д.Д.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В",null,{"$f":"SUM(- - ISTEXT(E286:AH286))","v":14},16,172,0,0,null,"Данилов Д.Д.",15,0,0,0,0,0,0,0,0,0,0]
["2025-01-01","4В",6,"Ежов Е.Е.",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В",null,{"$f":"SUM(- - ISTEXT(E287:AH287))","v":14},16,172,0,0,null,"Ежов Е.Е.",15,0,0,0,0,0,0,0,0,0,0]
["2025-01-01","4Г",7,"Зуев З.З.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,null,{"$f":"SUM(- - ISTEXT(E288:AH288))","v":15},15,164,0,0,null,"Зуев З.З.",15,0,0,0,0,0,0,0,0,0,0]
["2025-01-01","4Г",8,"Иванов И.И.","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,"В","В",13.5,8,null,{"$f":"SUM(- - ISTEXT(E289:AH289))","v":15},15,164,0,0,null,"Иванов И.И.",15,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,9,"Козлов К.К.","В","В","В","В","В","В","В","В",8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,{"$f":"SUM(- - ISTEXT(E290:AH290))","v":14},16,128.25,0,0,null,"Козлов К.К.",14,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,10,"Львов Л.Л.","В","В","В","В","В","В","В","В",8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,{"$f":"SUM(- - ISTEXT(E291:AH291))","v":14},16,128.25,0,0,null,"Львов Л.Л.",14,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,11,"Мишин М.М.","В","В","В","В","В","В","В","В",8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,{"$f":"SUM(- - ISTEXT(E292:AH292))","v":14},{"$f":"COUNT(E292:AH292)","v":16},{"$f":"SUM(E292:AH292)","v":128.25},0,0,null,"Мишин М.М.",14,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,12,"Носов Н.Н.","В","В","В","В","В","В","В","В",8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,{"$f":"SUM(- - ISTEXT(E293:AH293))","v":14},{"$f":"COUNT(E293:AH293)","v":16},{"$f":"SUM(E293:AH293)","v":128.25},0,0,null,"Носов Н.Н.",14,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,13,"Осин О.О.","В","В","В","В","В","В","В","В",8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,{"$f":"SUM(- - ISTEXT(E294:AI294))","v":14},{"$f":"COUNT(E294:AI294)","v":17},{"$f":"SUM(E294:AI294)","v":135.25},0,0,null,"Осин О.О.",14,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,14,"Попов П.П.","В","В","В","В","В","В","В","В",8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,"В","В",8.25,8.25,8.25,8.25,7,null,{"$f":"SUM(- - ISTEXT(E295:AI295))","v":14},17,135.25,0,0,null,"Попов П.П.",14,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,15,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E296:AI296))","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,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,{"$f":"SUM(- - ISTEXT(E297:AI297))","v":0},0,0,{"$f":"COUNTIF(E297:AI297,\"ОТ\")","v":0},0,null,{"$f":"D297","v":0},0,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,17,"NNN",null,null,null,null,null,null,null,"В","ОТ","ДО","Б","НН","ПР","К","НОД","У","ОЗ","Г",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(- - ISTEXT(E298:AI298))","v":11},0,0,{"$f":"COUNTIF(E298:AI298,\"ОТ\")","v":1},0,null,{"$f":"D298","v":"NNN"},{"$f":"COUNTIF($E298:$AI298,M$306)","v":1},1,1,1,1,1,1,1,1,1,1]
["2025-01-01",1,18,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E299:AI299))","v":0},0,0,{"$f":"COUNTIF(E299:AI299,\"ОТ\")","v":0},0,null,{"$f":"D299","v":0},0,0,0,0,0,0,0,0,0,0,0]
["2025-01-01",1,19,null,null,null,null,null,null,null,null,null,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":"SUM(- - ISTEXT(E300:AI300))","v":0},0,0,{"$f":"COUNTIF(E300:AI300,\"ОТ\")","v":0},0,null,{"$f":"D300","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"OFFSET(A300,-1,0)","v":"2025-01-01"},1,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,{"$f":"SUM(- - ISTEXT(E301:AI301))","v":0},0,0,{"$f":"COUNTIF(E301:AI301,\"ОТ\")","v":0},0,null,{"$f":"D301","v":0},0,0,0,0,0,0,0,0,{"$f":"COUNTIF($E301:$AI301,U$306)","v":0},{"$f":"COUNTIF($E301:$AI301,V$306)","v":0},{"$f":"COUNTIF($E301:$AI301,W$306)","v":0}]
[" "]
[]
[]
[null,null,null,"ОТЧЁТ за ГОД",null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,10]
[null,null,null,null,"Отпуск должно быть","Отпуск запланировано",{"$f":"\"Отгуляно на \"& TEXT(TODAY(),\"ДД-ММ-ГГГГ\")","v":"Отгуляно на 25-10-2024"},"Рабочих дней","Не рабочих дней","Плановый остаток \nна конец года",null,null,"В","ОТ","ДО","Б","НН","ПР","К","НОД","У","ОЗ","Г"]
[null,null,{"$f":"OFFSET(C307,-1,0)+1","v":1},"Алёхин А.А.",28,{"$f":"SUMIF(ФИО,D307,Отпуск_Всего)","v":28},{"$f":"SUMIF(ФИО,D307,Отгуляно)","v":0},{"$f":"SUMIF(ФИО,D307,Раб_дни)","v":164},{"$f":"SUMIF(ФИО,D307,НЕ_раб_дни)","v":195},{"$f":"ROUND(E307-F307,0)","v":0},null,null,{"$f":"SUMIF(Учёт,$D307,OFFSET(Учёт,,M$305,,1))","v":170},27,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"OFFSET(C308,-1,0)+1","v":2},"Борисов В.В.",28,{"$f":"SUMIF(ФИО,D308,Отпуск_Всего)","v":28},{"$f":"SUMIF(ФИО,D308,Отгуляно)","v":0},{"$f":"SUMIF(ФИО,D308,Раб_дни)","v":160},{"$f":"SUMIF(ФИО,D308,НЕ_раб_дни)","v":199},{"$f":"ROUND(E308-F308,0)","v":0},null,null,173,28,0,0,0,0,0,0,0,0,0]
[null,null,3,"Володин В.В.",28,14,0,173,186,14,null,null,176,14,0,0,0,0,0,0,0,0,0]
[null,null,4,"Гаврилов Г.Г.",28,28,0,164,189,0,null,null,168,28,0,0,0,0,0,0,0,0,0]
[null,null,5,"Данилов Д.Д.",28,28,0,163,196,0,null,null,171,28,0,0,0,0,0,0,0,0,0]
[null,null,6,"Ежов Е.Е.",28,{"$f":"SUMIF(ФИО,D312,Отпуск_Всего)","v":28},{"$f":"SUMIF(ФИО,D312,Отгуляно)","v":0},{"$f":"SUMIF(ФИО,D312,Раб_дни)","v":163},{"$f":"SUMIF(ФИО,D312,НЕ_раб_дни)","v":196},{"$f":"ROUND(E312-F312,0)","v":0},null,null,173,28,0,0,0,0,0,0,0,0,0]
[null,null,7,"Зуев З.З.",28,28,0,167,192,0,null,null,167,28,0,0,0,0,0,0,0,0,0]
[null,null,8,"Иванов И.И.",28,28,0,161,198,0,null,null,173,28,0,0,0,0,0,0,0,0,0]
[null,null,9,"Козлов К.К.",28,0,0,244,115,28,null,null,118,0,0,0,0,0,0,0,0,0,0]
[null,null,10,"Львов Л.Л.",28,0,0,244,115,28,null,null,{"$f":"SUMIF(Учёт,$D316,OFFSET(Учёт,,M$305,,1))","v":118},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"OFFSET(C317,-1,0)+1","v":11},"Мишин М.М.",28,{"$f":"SUMIF(ФИО,D317,Отпуск_Всего)","v":28},{"$f":"SUMIF(ФИО,D317,Отгуляно)","v":0},{"$f":"SUMIF(ФИО,D317,Раб_дни)","v":220},{"$f":"SUMIF(ФИО,D317,НЕ_раб_дни)","v":139},{"$f":"ROUND(E317-F317,0)","v":0},null,null,{"$f":"SUMIF(Учёт,$D317,OFFSET(Учёт,,M$305,,1))","v":114},28,0,0,0,0,0,0,0,0,0]
[null,null,12,"Носов Н.Н.",28,28,0,222,137,0,null,null,113,28,0,0,0,0,0,0,0,0,0]
[null,null,13,"Осин О.О.",28,28,0,224,{"$f":"SUMIF(ФИО,D319,НЕ_раб_дни)","v":136},0,null,null,110,28,0,0,0,0,0,0,0,0,0]
[null,null,14,"Попов П.П.",28,0,0,245,{"$f":"SUMIF(ФИО,D320,НЕ_раб_дни)","v":116},28,null,null,118,0,0,0,0,0,0,0,0,0,0]
[null,null,15]
[null,null,16]
[null,null,17]
[null,null,18]
[null,null,19]
[null,null,20]
[]
[]
[null,null,null,"День месяца",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,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,"Начало отпуска","Конец отпуска","Кол-во дней"]

{"sheet":"Календарь","index":1,"n_rows":79,"n_cols":13,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
["Праздники",null,"Причина ВЫХОДНЫХ","Черные",null,"Причина РАБОЧИХ",null,"Профессиональные календари",null,null,"Производственный календарь"]
["2024-01-01",{"$f":"IF(A2,A2,\"\")","v":"2024-01-01"},"Новогодние каникулы",null,{"$f":"IF(D2,D2,\"\")","v":""},null,"2024-01-01","Новогодние каникулы","2024г."]
["2024-01-02","2024-01-02","Новогодние каникулы",null,"",null,"2024-01-02","Новогодние каникулы",null,"1, 2, 3, 4, 5, 6 и 8 января - Новогодние каникулы"]
["2024-01-03","2024-01-03","Новогодние каникулы",null,"",null,"2024-01-03","Новогодние каникулы",null,"7 января - Рождество Христово"]
["2024-01-04","2024-01-04","Новогодние каникулы",null,"",null,"2024-01-04","Новогодние каникулы",null,"23 февраля - День защитника Отечества"]
["2024-01-05","2024-01-05","Новогодние каникулы",null,"",null,"2024-01-05","Новогодние каникулы",null,"8 марта - Международный женский день"]
["2024-01-06","2024-01-06","Новогодние каникулы",null,"",null,"2024-01-06","Новогодние каникулы",null,"1 мая - Праздник Весны и Труда"]
["2024-01-07","2024-01-07","Рождество Христово",null,"",null,"2024-01-07","Рождество Христово",null,"9 мая - День Победы"]
["2024-01-08","2024-01-08","Новогодние каникулы",null,"",null,"2024-01-08","Новогодние каникулы",null,"12 июня - День России"]
["2024-02-23","2024-02-23","День защитника Отечества",null,"",null,"2024-02-23","День защитника Отечества",null,"4 ноября - День народного единства"]
["2024-03-08",{"$f":"IF(A11,A11,\"\")","v":"2024-03-08"},"Международный женский день",null,{"$f":"IF(D11,D11,\"\")","v":""},null,"2024-03-08","Международный женский день",null,null,"2024-02-22","—","предпраздничный день"]
["2024-05-01","2024-05-01","Праздник Весны и Труда",null,"",null,"2024-05-01","Праздник Весны и Труда",null,null,"2024-03-07","—","предпраздничный день"]
["2024-05-09","2024-05-09","День Победы",null,"",null,"2024-05-09","День Победы",null,null,"2024-05-08","—","предпраздничный день"]
["2024-06-12","2024-06-12","День России",null,"",null,"2024-06-12","День России",null,null,"2024-06-11","—","предпраздничный день"]
["2024-11-04","2024-11-04","День народного единства",null,"",null,"2024-11-04","День народного единства"]
["2024-05-10",{"$f":"IF(A16,A16,\"\")","v":"2024-05-10"},"за 06.01.2024",null,"",null,null,null,null,"Перенос выходных:","2024-01-06","→","2024-05-10"]
["2024-12-31","2024-12-31","за 07.01.2024",null,"",null,null,null,null,"Перенос выходных:","2024-01-07","→","2024-12-31"]
["2024-04-29","2024-04-29","за 27.04.2024","2024-04-27","2024-04-27","перенос на 29.04.2024",null,null,null,"Перенос выходных:","2024-04-27","→","2024-04-29"]
["2024-04-30","2024-04-30","за 02.11.2024","2024-11-02","2024-11-02","перенос на 30.04.2024",null,null,null,"Перенос выходных:","2024-11-02","→","2024-04-30"]
["2024-12-30","2024-12-30","за 28.12.2024","2024-12-28","2024-12-28","перенос на 30.12.2024",null,null,null,"Перенос выходных:","2024-12-28","→","2024-12-30"]
["2025-01-01","2025-01-01","Новогодние каникулы",null,"",null,"2025-01-01","Новогодние каникулы","2025г."]
["2025-01-02","2025-01-02","Новогодние каникулы",null,"",null,"2025-01-02","Новогодние каникулы",null,"1, 2, 3, 4, 5, 6 и 8 января - Новогодние каникулы"]
["2025-01-03","2025-01-03","Новогодние каникулы",null,"",null,"2025-01-03","Новогодние каникулы",null,"7 января - Рождество Христово"]
["2025-01-04","2025-01-04","Новогодние каникулы",null,"",null,"2025-01-04","Новогодние каникулы",null,"23 февраля - День защитника Отечества"]
["2025-01-05","2025-01-05","Новогодние каникулы",null,"",null,"2025-01-05","Новогодние каникулы",null,"8 марта - Международный женский день"]
["2025-01-06","2025-01-06","Новогодние каникулы",null,"",null,"2025-01-06","Новогодние каникулы",null,"1 мая - Праздник Весны и Труда"]
["2025-01-07","2025-01-07","Рождество Христово",null,"",null,"2025-01-07","Рождество Христово",null,"9 мая - День Победы"]
["2025-01-08","2025-01-08","Новогодние каникулы",null,"",null,"2025-01-08","Новогодние каникулы",null,"12 июня - День России"]
["2025-02-23","2025-02-23","День защитника Отечества",null,"",null,"2025-02-23","День защитника Отечества",null,"4 ноября - День народного единства"]
["2025-03-08",{"$f":"IF(A30,A30,\"\")","v":"2025-03-08"},"Международный женский день",null,{"$f":"IF(D30,D30,\"\")","v":""},null,"2025-03-08","Международный женский день",null,null,"2025-03-07","—","предпраздничный день"]
["2025-05-01",{"$f":"IF(A31,A31,\"\")","v":"2025-05-01"},"Праздник Весны и Труда",null,{"$f":"IF(D31,D31,\"\")","v":""},null,"2025-05-01","Праздник Весны и Труда",null,null,"2025-04-30","—","предпраздничный день"]
["2025-05-09",{"$f":"IF(A32,A32,\"\")","v":"2025-05-09"},"День Победы",null,{"$f":"IF(D32,D32,\"\")","v":""},null,"2025-05-09","День Победы",null,null,"2025-06-11","—","предпраздничный день"]
["2025-06-12",{"$f":"IF(A33,A33,\"\")","v":"2025-06-12"},"День России",null,{"$f":"IF(D33,D33,\"\")","v":""},null,"2025-06-12","День России",null,null,"2025-11-01","—","предпраздничный день"]
["2025-11-04",{"$f":"IF(A34,A34,\"\")","v":"2025-11-04"},"День народного единства",null,{"$f":"IF(D34,D34,\"\")","v":""},null,"2025-11-04","День народного единства"]
["2025-05-02","2025-05-02","за 04.01.2025",null,"",null,null,null,null,"Перенос выходных:","2025-01-04","→","2025-05-02"]
["2025-05-08","2025-05-08","за 23.02.2025",null,"",null,null,null,null,"Перенос выходных:","2025-02-23","→","2025-05-08"]
["2025-06-13","2025-06-13","за 08.03.2025",null,"",null,null,null,null,"Перенос выходных:","2025-03-08","→","2025-06-13"]
["2025-11-03","2025-11-03","за 01.01.2025","2025-11-01","2025-11-01","перенос на 03.11.2025",null,null,null,"Перенос выходных:","2025-11-01","→","2025-11-03"]
["2025-12-31","2025-12-31","за 05.01.2025",null,"",null,null,null,null,"Перенос выходных:","2025-01-05","→","2025-12-31"]
["2026-01-01","2026-01-01","Новогодние каникулы",null,"",null,"2026-01-01","Новогодние каникулы","2026г."]
["2026-01-02","2026-01-02","Новогодние каникулы",null,"",null,"2026-01-02","Новогодние каникулы",null,"1, 2, 3, 4, 5, 6 и 8 января - Новогодние каникулы"]
["2026-01-03",{"$f":"IF(A42,A42,\"\")","v":"2026-01-03"},"Новогодние каникулы",null,"",null,"2026-01-03","Новогодние каникулы",null,"7 января - Рождество Христово"]
["2026-01-04","2026-01-04","Новогодние каникулы",null,"",null,"2026-01-04","Новогодние каникулы",null,"23 февраля - День защитника Отечества"]
["2026-01-05","2026-01-05","Новогодние каникулы",null,{"$f":"IF(D44,D44,\"\")","v":""},null,"2026-01-05","Новогодние каникулы",null,"8 марта - Международный женский день"]
["2026-01-06","2026-01-06","Новогодние каникулы",null,"",null,"2026-01-06","Новогодние каникулы",null,"1 мая - Праздник Весны и Труда"]
["2026-01-07","2026-01-07","Рождество Христово",null,"",null,"2026-01-07","Рождество Христово",null,"9 мая - День Победы"]
["2026-01-08","2026-01-08","Новогодние каникулы",null,"",null,"2026-01-08","Новогодние каникулы",null,"12 июня - День России"]
["2026-02-23","2026-02-23","День защитника Отечества",null,null,null,"2026-02-23","День защитника Отечества",null,"4 ноября - День народного единства"]
["2026-03-08","2026-03-08","Международный женский день",null,null,null,"2026-03-08","Международный женский день"]
["2026-05-01","2026-05-01","Праздник Весны и Труда",null,null,null,"2026-05-01","Праздник Весны и Труда"]
["2026-05-09","2026-05-09","День Победы",null,null,null,"2026-05-09","День Победы"]
["2026-06-12","2026-06-12","День России",null,null,null,"2026-06-12","День России"]
["2026-11-04","2026-11-04","День народного единства",null,null,null,"2026-11-04","День народного единства"]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A66,A66,\"\")","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"Names","index":2,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["ГОД","=Табель!$D$1"]
["ИТОГИ","=Табель!$AK$1"]
["КОДЫ","=СМЕЩ(Коды!$A$1;1;0;СЧЁТЗ(Коды!$A$1:$A$20)-1;1)"]
["КОДЫ_ЗНАЧ","=СМЕЩ(Коды!$D$1;2;0;СЧЁТЗ(Коды!$D$1:$D$50)-2;3)"]
["Конец_года","=Табель!$BE$277"]
["МЕТКА","=Табель!$BE$1"]
["НЕ_раб_дни","=СМЕЩ(ИТОГИ;1;0;СТРОКА(Конец_года)-СТРОКА(ГОД))"]
["Отгуляно","=СМЕЩ(ИТОГИ;1;4;СТРОКА(Конец_года)-СТРОКА(ГОД))"]
["Отпуск_Всего","=СМЕЩ(ИТОГИ;1;3;СТРОКА(Конец_года)-СТРОКА(ГОД))"]
["ПРАЗДН_2024","=Календарь!$G$2:$G$15"]
["ПРАЗДН_2025","=Календарь!$G$21:$G$34"]
["ПРАЗДН_2026","=Календарь!$G$40:$G$53"]
["Праздники","=СМЕЩ(Календарь!$A$1;1;0;СЧЁТЗ(Календарь!$A$1:$A$889)-1;1)"]
["Раб_дни","=СМЕЩ(ИТОГИ;1;1;СТРОКА(Конец_года)-СТРОКА(ГОД))"]
["Учёт","=СМЕЩ(ГОД;1;39;СТРОКА(Конец_года)-СТРОКА(ГОД);11)"]
["ФИО","=СМЕЩ(ГОД;1;0;СТРОКА(Конец_года)-СТРОКА(ГОД))"]
["Черные","=СМЕЩ(Праздники;;3)"]

{"sheet":"Коды","index":3,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,5,1,5]]}
["КОД",null,null,"КОД",null,"Расшифровка"]
["Я","раб",null,"ШИФР","НОМЕР"]
["РВ","раб",null,"Я","01","Продолжительность работы в дневное время"]
["В","отс",null,"Н","02","Продолжительность работы в ночное время"]
["ОТ","отс",null,"РВ","03","Продолжительность работы в выходные и нерабочие праздничные дни"]
["ДО","отс",null,"С","04","Продолжительность сверхурочной работы"]
["Б","отс",null,"ВМ","05","Продолжительность работы вахтовым методом"]
["К","отс",null,"К","06","Служебная командировка"]
["НН","отс",null,"ПК","07","Повышение квалификации с отрывом от работы"]
["ПР","отс",null,"ПМ","08","Повышение квалификации с отрывом от работы в другой местности"]
["У","отс",null,"ОТ","09","Ежегодный основной оплачиваемый отпуск"]
["ОЗ","отс",null,"ОД","10","Ежегодный дополнительный оплачиваемый отпуск"]
["НОД","отс",null,"У","11","Дополнительный отпуск в связи с обучением с сохранением среднего заработка работникам, совмещающим работу с обучением"]
["Г","отс",null,"УВ","12","Сокращенная продолжительность рабочего времени для обучающихся без отрыва от производства с частичным сохранением заработной платы"]
[null,null,null,"УД","13","Дополнительный отпуск в связи с обучением без сохранения заработной платы"]
[null,null,null,"Р","14","Отпуск по беременности и родам (отпуск в связи с усыновлением новорожденного ребенка)"]
[null,null,null,"ОЖ","15","Отпуск по уходу за ребенком до достижения им возраста трех лет"]
[null,null,null,"ДО","16","Отпуск без сохранения заработной платы, предоставленный работнику по разрешению работодателя"]
[null,null,null,"ОЗ","17","Отпуск без сохранения заработной платы при условиях, предусмотренных действующим законодательством Российской Федерации"]
[null,null,null,"ДБ","18","Ежегодный дополнительный отпуск без сохранения заработной платы"]
[null,null,null,"Б","19","Временная нетрудоспособность (кроме случаев, предусмотренных кодом \"Т\") с назначением пособия согласно законодательству"]
[null,null,null,"Т","20","Временная нетрудоспособность без назначения пособия в случаях, предусмотренных законодательством"]
[null,null,null,"ЛЧ","21","Сокращенная продолжительность рабочего времени против нормальной продолжительности рабочего дня в случаях, предусмотренных законодательством"]
[null,null,null,"ПВ","22","Время вынужденного прогула в случае признания увольнения, перевода на другую работу или отстранения от работы незаконными с восстановлением на прежней работе"]
[null,null,null,"Г","23","Невыходы на время исполнения государственных или общественных обязанностей согласно законодательству"]
[null,null,null,"ПР","24","Прогулы (отсутствие на рабочем месте без уважительных причин в течение времени, установленного законодательством)"]
[null,null,null,"НС","25","Продолжительность работы в режиме неполного рабочего времени по инициативе работодателя в случаях, предусмотренных законодательством"]
[null,null,null,"В","26","Выходные дни (еженедельный отпуск) и нерабочие праздничные дни"]
[null,null,null,"ОВ","27","Дополнительные выходные дни (оплачиваемые)"]
[null,null,null,"НВ","28","Дополнительные выходные дни (без сохранения заработной платы)"]
[null,null,null,"ЗБ","29","Забастовка (при условиях и в порядке, предусмотренных законом)"]
[null,null,null,"НН","30","Неявки по невыясненным причинам (до выяснения обстоятельств)"]
[null,null,null,"РП","31","Время простоя по вине работодателя"]
[null,null,null,"НП","32","Время простоя по причинам, не зависящим от работодателя и работника"]
[null,null,null,"ВП","33","Время простоя по вине работника"]
[null,null,null,"НО","34","Отстранение от работы (недопущение к работе) с оплатой (пособием) в соответствии с законодательством"]
[null,null,null,"НБ","35","Отстранение от работы (недопущение к работе) по причинам, предусмотренным законодательством, без начисления заработной платы"]
[null,null,null,"НЗ","36","Время приостановки работы в случае задержки выплаты заработной платы"]
[null,null,null,"НОД",null,"Нерабочий оплачиваемый день по причинам, предусмотренным законодательством, с начислением заработной платы"]