{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["отдел_управления_отделами"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"отдел_управления_отделами","index":0,"n_rows":65,"n_cols":77,"rows_kept":65,"cut":false,"hidden":false,"merged":[[48,46,49,46],[42,44,43,44],[42,45,43,45],[42,46,43,46],[57,1,58,1],[57,3,58,3],[60,21,60,29],[60,36,60,37],[51,46,52,46],[45,45,46,45],[45,46,46,46],[54,44,55,44],[54,45,55,45],[54,46,55,46],[27,46,28,46],[30,44,31,44],[30,45,31,45],[30,46,31,46],[45,44,46,44],[33,44,34,44],[33,45,34,45],[33,46,34,46],[36,44,37,44],[36,45,37,45],[36,46,37,46],[39,44,40,44],[39,45,40,45],[39,46,40,46],[18,46,19,46],[21,44,22,44],[21,45,22,45],[21,46,22,46],[24,44,25,44],[24,45,25,45],[24,46,25,46],[18,44,19,44],[18,45,19,45],[61,3,61,6],[61,8,61,12],[60,39,60,41],[30,1,31,1],[18,3,19,3],[21,3,22,3],[18,1,19,1],[21,1,22,1],[24,1,25,1],[27,1,28,1],[24,3,25,3],[39,37,40,37],[33,37,34,37],[51,3,52,3],[45,3,46,3],[48,3,49,3],[27,3,28,3],[39,3,40,3],[33,3,34,3],[36,3,37,3],[60,1,60,2],[60,3,60,6],[60,8,60,12],[60,43,60,45],[60,30,60,34],[54,1,55,1],[54,3,55,3],[24,38,25,38],[14,18,16,18],[27,44,28,44],[27,45,28,45],[51,45,52,45],[48,44,49,44],[48,45,49,45],[61,43,61,45],[54,38,55,38],[60,14,60,19],[61,30,61,34],[61,14,61,19],[30,37,31,37],[61,39,61,41],[61,36,61,38],[54,37,55,37],[51,44,52,44],[13,2,16,2],[11,25,11,29],[11,30,11,34],[13,3,16,3],[14,17,16,17],[13,46,16,46],[14,36,16,36],[14,21,16,21],[14,37,16,37],[14,30,16,30],[15,45,16,45],[13,43,16,43],[13,44,14,45],[14,23,16,23],[14,24,16,24],[15,44,16,44],[51,38,52,38],[48,37,49,37],[48,38,49,38],[51,37,52,37],[13,37,13,42],[24,37,25,37],[27,37,28,37],[15,39,15,42],[15,38,16,38],[14,38,14,42],[1,38,1,46],[5,1,5,40],[6,1,6,40],[7,1,7,45],[11,38,11,39],[10,38,10,39],[11,36,11,37],[8,1,8,40],[9,25,10,29],[9,30,10,34],[9,36,9,39],[10,36,10,37],[45,38,46,38],[27,38,28,38],[17,20,17,35],[18,37,19,37],[30,38,31,38],[45,37,46,37],[18,38,19,38],[21,38,22,38],[36,38,37,38],[33,38,34,38],[14,7,16,7],[14,4,16,4],[14,8,16,8],[21,37,22,37],[14,31,16,31],[14,5,16,5],[14,6,16,6],[14,34,16,34],[14,16,16,16],[14,20,16,20],[14,22,16,22],[14,13,16,13],[14,14,16,14],[14,35,16,35],[14,32,16,32],[14,9,16,9],[14,15,16,15],[14,11,16,11],[14,12,16,12],[14,27,16,27],[14,19,16,19],[14,25,16,25],[14,26,16,26],[14,33,16,33],[57,37,58,37],[57,38,58,38],[57,44,58,44],[57,45,58,45],[57,46,58,46],[0,1,0,3],[51,1,52,1],[45,1,46,1],[42,3,43,3],[36,1,37,1],[48,1,49,1],[42,1,43,1],[39,1,40,1],[13,1,16,1],[30,3,31,3],[42,38,43,38],[39,38,40,38],[42,37,43,37],[33,1,34,1],[36,37,37,37],[17,4,17,18],[14,28,16,28],[14,29,16,29],[14,10,16,10]]}
[null,"сокращенные дни указать насколько сокращены       (на всех сотрудников)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Форма № Т-12\n\n"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Код"]
[]
[]
[null,"(наименование организации)"]
[]
[null,"(наименование структурного подразделения)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Номер документа",null,null,null,null,"Дата составления",null,null,null,null,null,"Отчетный период"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"с",null,"по"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ТАБЕЛЬ  ",null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2016-08-30T12:35:22.730"},null,null,null,null,null,{"$f":"DATE(YEAR(AE12),MONTH(AE12),1)","v":"2016-08-01"},null,{"$f":"IF(DAY(AE12)<16,DATE(YEAR(AE12),MONTH(AE12),15),DATE(YEAR(AE12),MONTH(AE12)+1,1)-1)","v":"2016-08-31"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"учета  рабочего времени"]
[null,"Номер \nпо \nпорядку","Фамилия, инициалы,\nдолжность \n(специальность, \nпрофессия) ","Табельный\n номер","Отметки о явках и неявках на работу по числам месяца",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Итого отработано за месяц",null,null,null,null,null,"Количество неявок, дней (часов)","Из них по причинам",null,"Количество выходных и праздничных дней"]
[null,null,null,null,"1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","итого отработано за 1 половину месяца","16","17","18","19","20","21","22","23","24","25","26","27","28",{"$f":"IF(DAY(DATE(YEAR(AE12),MONTH(AE12)+1,1)-1)>=29,29,\"\")","v":29},{"$f":"IF(DAY(DATE(YEAR(AE12),MONTH(AE12)+1,1)-1)>=30,30,\"\")","v":30},{"$f":"IF(DAY(DATE(YEAR(AE12),MONTH(AE12)+1,1)-1)>30,31,\"\")","v":31},"итого отработано за 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,null,null,null,null,null,"всего","из них",null,null,null,null,"код","количество дней\n(часов)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"сверхурочных","ночных","выходных, праздничных",null,null,null,null,null,null,null,"НВ","ОТ","Р","ОД","Б","ДО","НН","ПК","Г","К","ОЖ",null,null,null,null,null,null,null,null,null,null,null,null,null,"AS1","AS2","AT1","AT2"]
[null,"1","2","3","4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5",6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,8,9,10,11,12,13,14,15,16,17]
[null,1,null,null,"ОТ","ОТ","ОТ","ОТ","Я","В","В","Я","Я","Я","Я","Я","В","В","Я",{"$f":"COUNTIF(E19:S19,\"Я\")+COUNTIF(E19:S19,\"РВ\")","v":7},"Я","Я","Я","Я","В","В","Я","Я","Я","Я","Я","В","В","Я","Я","Я",{"$f":"COUNTIF(U19:AJ19,\"Я\")+COUNTIF(U19:AJ19,\"РВ\")","v":12},{"$f":"T19+AK19","v":19},{"$f":"T20+AK20","v":152},null,null,{"$f":"COUNTIF($E19:$S19,\"РВ\")+COUNTIF($U19:$AJ19,\"РВ\")","v":0},null,{"$f":"IF(SUM($AX20:$BM20)>0,CONCATENATE(SUM($AX20:$BM20),\"(\",8*SUM($AX20:$BM20),\")\"),\"\")","v":"4(32)"},{"$f":"CONCATENATE(BV19,BW19)","v":"ОТ\n"},{"$f":"CONCATENATE(BX19,BY19)","v":"4(32)\n"},{"$f":"COUNTIF(U19:AJ19,\"В\")+COUNTIF(E19:S19,\"В\")+COUNTIF(U19:AJ19,\"РВ\")+COUNTIF(E19:S19,\"РВ\")","v":8},1,null,{"$f":"IF(AX20<>0,AX$17,\"\")","v":""},"ОТ","","","","","","","","","","","","","","",{"$f":"COUNTBLANK(AX19:BM19)","v":15},null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF(AX20>0,CONCATENATE(AX19,CHAR(10)),\"\"),IF(AY20>0,CONCATENATE(AY19,CHAR(10)),\"\"),IF(AZ20>0,CONCATENATE(AZ19,CHAR(10),),\"\"),IF(BA20>0,CONCATENATE(BA19,CHAR(10)),\"\"),IF(BB20>0,CONCATENATE(BB19,CHAR(10)),\"\"),IF(BC20>0,CONCATENATE(BC19,CHAR(10)),\"\"),IF(BD20>0,CONCATENATE(BD19,CHAR(10)),\"\"),IF(BE20>0,CONCATENATE(BE19,CHAR(10)),\"\"))","v":"ОТ\n"},{"$f":"CONCATENATE(IF(BF20>0,CONCATENATE(BF19,CHAR(10)),\"\"),IF(BG20>0,CONCATENATE(BG19,CHAR(10)),\"\"),IF(BH20>0,CONCATENATE(BH19,CHAR(10),),\"\"),IF(BI20>0,CONCATENATE(BI19,CHAR(10)),\"\"),IF(BJ20>0,CONCATENATE(BJ19,CHAR(10)),\"\"),IF(BK20>0,CONCATENATE(BK19,CHAR(10)),\"\"),IF(BL20>0,CONCATENATE(BL19,CHAR(10)),\"\"),IF(BM20>0,CONCATENATE(BM19,CHAR(10)),\"\"))","v":""},{"$f":"CONCATENATE(IF(AX20>0,CONCATENATE(AX20,\"(\",(8*AX20),\")\",CHAR(10)),\"\"),IF(AY20>0,CONCATENATE(AY20,\"(\",(8*AY20),\")\",CHAR(10)),\"\"),IF(AZ20>0,CONCATENATE(AZ20,\"(\",(8*AZ20),\")\",CHAR(10)),\"\"),IF(BA20>0,CONCATENATE(BA20,\"(\",(8*BA20),\")\",CHAR(10)),\"\"),IF(BB20>0,CONCATENATE(BB20,\"(\",(8*BB20),\")\",CHAR(10)),\"\"),IF(BC20>0,CONCATENATE(BC20,\"(\",(8*BC20),\")\",CHAR(10)),\"\"),IF(BD20>0,CONCATENATE(BD20,\"(\",(8*BD20),\")\",CHAR(10)),\"\"),IF(BE20>0,CONCATENATE(BE20,\"(\",(8*BE20),\")\",CHAR(10)),\"\"))","v":"4(32)\n"},{"$f":"CONCATENATE(IF(BF20>0,CONCATENATE(BF20,\"(\",(8*BF20),\")\",CHAR(10)),\"\"),IF(BG20>0,CONCATENATE(BG20,\"(\",(8*BG20),\")\",CHAR(10)),\"\"),IF(BH20>0,CONCATENATE(BH20,\"(\",(8*BH20),\")\",CHAR(10)),\"\"),IF(BI20>0,CONCATENATE(BI20,\"(\",(8*BI20),\")\",CHAR(10)),\"\"),IF(BJ20>0,CONCATENATE(BJ20,\"(\",(8*BJ20),\")\",CHAR(10)),\"\"),IF(BK20>0,CONCATENATE(BK20,\"(\",(8*BK20),\")\",CHAR(10)),\"\"),IF(BL20>0,CONCATENATE(BL20,\"(\",(8*BL20),\")\",CHAR(10)),\"\"),IF(BM20>0,CONCATENATE(BM20,\"(\",(8*BM20),\")\",CHAR(10)),\"\"))","v":""}]
[null,null,"Начальник Управления ",null,{"$f":"IF(E21+IF(E19=\"Я\",8, IF(E19=\"РВ\",8,0))-E$1<>0,E21+IF(E19=\"Я\",8, IF(E19=\"РВ\",8,0))-E$1,\"\")","v":""},"","","",8,"","",8,8,8,8,8,"","",8,{"$f":"SUM(E20:S20)","v":56},8,8,8,8,"","",8,8,8,8,8,"","",8,8,8,{"$f":"SUM(U20:AJ20)","v":96},null,null,null,null,{"$f":"IF(SUMIF(E19:AJ20,\"РВ\",E20:AJ20)<=0,\"\",SUMIF(E19:AJ20,\"РВ\",E20:AJ20))","v":""},null,null,null,null,null,1,null,{"$f":"COUNTIF($E19:$S19,AX$17)+COUNTIF($U19:$AJ19,AX$17)","v":0},4,{"$f":"COUNTIF($E19:$S19,AZ$17)+COUNTIF($U19:$AJ19,AZ$17)","v":0},0,0,{"$f":"COUNTIF($E19:$S19,BC$17)+COUNTIF($U19:$AJ19,BC$17)","v":0},{"$f":"COUNTIF($E19:$S19,BD$17)+COUNTIF($U19:$AJ19,BD$17)","v":0},{"$f":"COUNTIF($E19:$S19,BE$17)+COUNTIF($U19:$AJ19,BE$17)","v":0},{"$f":"COUNTIF($E19:$S19,BF$17)+COUNTIF($U19:$AJ19,BF$17)","v":0},{"$f":"COUNTIF($E19:$S19,BG$17)+COUNTIF($U19:$AJ19,BG$17)","v":0},0,0,{"$f":"COUNTIF($E19:$S19,BJ$17)+COUNTIF($U19:$AJ19,BJ$17)","v":0},0,{"$f":"COUNTIF($E19:$S19,BL$17)+COUNTIF($U19:$AJ19,BL$17)","v":0},0]
[null,null,"сверхурочная работа",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E21:S21)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U21:AJ21)","v":0},null,null,{"$f":"T21+AK21","v":0},null,null,null,null,null,null,null,{"$f":"IF(T21+AK21>0,1,0)","v":0}]
[null,2,null,null,"ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ",{"$f":"COUNTIF(E22:S22,\"Я\")+COUNTIF(E22:S22,\"РВ\")","v":0},"ОТ","ОТ","ОТ","Я","В","В","Я","Я","Я","Я","Я","В","РВ","НВ","Я","Я",{"$f":"COUNTIF(U22:AJ22,\"Я\")+COUNTIF(U22:AJ22,\"РВ\")","v":9},{"$f":"T22+AK22","v":9},{"$f":"T23+AK23","v":72},null,null,{"$f":"COUNTIF($E22:$S22,\"РВ\")+COUNTIF($U22:$AJ22,\"РВ\")","v":1},null,{"$f":"IF(SUM($AX23:$BM23)>0,CONCATENATE(SUM($AX23:$BM23),\"(\",8*SUM($AX23:$BM23),\")\"),\"\")","v":"19(152)"},{"$f":"CONCATENATE(BV22,BW22)","v":"НВ\nОТ\n"},{"$f":"CONCATENATE(BX22,BY22)","v":"1(8)\n18(144)\n"},{"$f":"COUNTIF(U22:AJ22,\"В\")+COUNTIF(E22:S22,\"В\")+COUNTIF(U22:AJ22,\"РВ\")+COUNTIF(E22:S22,\"РВ\")","v":4},1,null,{"$f":"IF(AX23<>0,AX$17,\"\")","v":"НВ"},"ОТ","","","","","","","","","","","","","","",{"$f":"COUNTBLANK(AX22:BM22)","v":14},null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF(AX23>0,CONCATENATE(AX22,CHAR(10)),\"\"),IF(AY23>0,CONCATENATE(AY22,CHAR(10)),\"\"),IF(AZ23>0,CONCATENATE(AZ22,CHAR(10),),\"\"),IF(BA23>0,CONCATENATE(BA22,CHAR(10)),\"\"),IF(BB23>0,CONCATENATE(BB22,CHAR(10)),\"\"),IF(BC23>0,CONCATENATE(BC22,CHAR(10)),\"\"),IF(BD23>0,CONCATENATE(BD22,CHAR(10)),\"\"),IF(BE23>0,CONCATENATE(BE22,CHAR(10)),\"\"))","v":"НВ\nОТ\n"},{"$f":"CONCATENATE(IF(BF23>0,CONCATENATE(BF22,CHAR(10)),\"\"),IF(BG23>0,CONCATENATE(BG22,CHAR(10)),\"\"),IF(BH23>0,CONCATENATE(BH22,CHAR(10),),\"\"),IF(BI23>0,CONCATENATE(BI22,CHAR(10)),\"\"),IF(BJ23>0,CONCATENATE(BJ22,CHAR(10)),\"\"),IF(BK23>0,CONCATENATE(BK22,CHAR(10)),\"\"),IF(BL23>0,CONCATENATE(BL22,CHAR(10)),\"\"),IF(BM23>0,CONCATENATE(BM22,CHAR(10)),\"\"))","v":""},{"$f":"CONCATENATE(IF(AX23>0,CONCATENATE(AX23,\"(\",(8*AX23),\")\",CHAR(10)),\"\"),IF(AY23>0,CONCATENATE(AY23,\"(\",(8*AY23),\")\",CHAR(10)),\"\"),IF(AZ23>0,CONCATENATE(AZ23,\"(\",(8*AZ23),\")\",CHAR(10)),\"\"),IF(BA23>0,CONCATENATE(BA23,\"(\",(8*BA23),\")\",CHAR(10)),\"\"),IF(BB23>0,CONCATENATE(BB23,\"(\",(8*BB23),\")\",CHAR(10)),\"\"),IF(BC23>0,CONCATENATE(BC23,\"(\",(8*BC23),\")\",CHAR(10)),\"\"),IF(BD23>0,CONCATENATE(BD23,\"(\",(8*BD23),\")\",CHAR(10)),\"\"),IF(BE23>0,CONCATENATE(BE23,\"(\",(8*BE23),\")\",CHAR(10)),\"\"))","v":"1(8)\n18(144)\n"},{"$f":"CONCATENATE(IF(BF23>0,CONCATENATE(BF23,\"(\",(8*BF23),\")\",CHAR(10)),\"\"),IF(BG23>0,CONCATENATE(BG23,\"(\",(8*BG23),\")\",CHAR(10)),\"\"),IF(BH23>0,CONCATENATE(BH23,\"(\",(8*BH23),\")\",CHAR(10)),\"\"),IF(BI23>0,CONCATENATE(BI23,\"(\",(8*BI23),\")\",CHAR(10)),\"\"),IF(BJ23>0,CONCATENATE(BJ23,\"(\",(8*BJ23),\")\",CHAR(10)),\"\"),IF(BK23>0,CONCATENATE(BK23,\"(\",(8*BK23),\")\",CHAR(10)),\"\"),IF(BL23>0,CONCATENATE(BL23,\"(\",(8*BL23),\")\",CHAR(10)),\"\"),IF(BM23>0,CONCATENATE(BM23,\"(\",(8*BM23),\")\",CHAR(10)),\"\"))","v":""}]
[null,null,"Зам.начальника Управления ",null,{"$f":"IF(E24+IF(E22=\"Я\",8, IF(E22=\"РВ\",8,0))-E$1<>0,E24+IF(E22=\"Я\",8, IF(E22=\"РВ\",8,0))-E$1,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"SUM(E23:S23)","v":0},{"$f":"IF(U24+IF(U22=\"Я\",8, IF(U22=\"РВ\",8,0))-U$1<>0,U24+IF(U22=\"Я\",8, IF(U22=\"РВ\",8,0))-U$1,\"\")","v":""},"","",8,"","",8,8,8,8,8,"",8,"",8,8,{"$f":"SUM(U23:AJ23)","v":72},null,null,null,null,{"$f":"IF(SUMIF(E22:AJ23,\"РВ\",E23:AJ23)<=0,\"\",SUMIF(E22:AJ23,\"РВ\",E23:AJ23))","v":8},null,null,null,null,null,1,null,{"$f":"COUNTIF($E22:$S22,AX$17)+COUNTIF($U22:$AJ22,AX$17)","v":1},18,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"сверхурочная работа",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E24:S24)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U24:AJ24)","v":0},null,null,{"$f":"T24+AK24","v":0},null,null,null,null,null,null,null,{"$f":"IF(T24+AK24>0,1,0)","v":0}]
[null,3,null,null,"Я","Я","Я","Я","Я","В","В","Я","Я","Я","Я","Я","В","В","Я",{"$f":"COUNTIF(E25:S25,\"Я\")+COUNTIF(E25:S25,\"РВ\")","v":11},"Я","Я","Я","Я","В","В","Я","Я","Я","Я","Я","В","В","НН","НН","НН",{"$f":"COUNTIF(U25:AJ25,\"Я\")+COUNTIF(U25:AJ25,\"РВ\")","v":9},{"$f":"T25+AK25","v":20},{"$f":"T26+AK26","v":160},null,null,{"$f":"COUNTIF($E25:$S25,\"РВ\")+COUNTIF($U25:$AJ25,\"РВ\")","v":0},null,{"$f":"IF(SUM($AX26:$BM26)>0,CONCATENATE(SUM($AX26:$BM26),\"(\",8*SUM($AX26:$BM26),\")\"),\"\")","v":"3(24)"},{"$f":"CONCATENATE(BV25,BW25)","v":"НН\n"},{"$f":"CONCATENATE(BX25,BY25)","v":"3(24)\n"},{"$f":"COUNTIF(U25:AJ25,\"В\")+COUNTIF(E25:S25,\"В\")+COUNTIF(U25:AJ25,\"РВ\")+COUNTIF(E25:S25,\"РВ\")","v":8},1,null,{"$f":"IF(AX26<>0,AX$17,\"\")","v":""},"","","","","","НН","","","","","","","","","",{"$f":"COUNTBLANK(AX25:BM25)","v":15},null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF(AX26>0,CONCATENATE(AX25,CHAR(10)),\"\"),IF(AY26>0,CONCATENATE(AY25,CHAR(10)),\"\"),IF(AZ26>0,CONCATENATE(AZ25,CHAR(10),),\"\"),IF(BA26>0,CONCATENATE(BA25,CHAR(10)),\"\"),IF(BB26>0,CONCATENATE(BB25,CHAR(10)),\"\"),IF(BC26>0,CONCATENATE(BC25,CHAR(10)),\"\"),IF(BD26>0,CONCATENATE(BD25,CHAR(10)),\"\"),IF(BE26>0,CONCATENATE(BE25,CHAR(10)),\"\"))","v":"НН\n"},{"$f":"CONCATENATE(IF(BF26>0,CONCATENATE(BF25,CHAR(10)),\"\"),IF(BG26>0,CONCATENATE(BG25,CHAR(10)),\"\"),IF(BH26>0,CONCATENATE(BH25,CHAR(10),),\"\"),IF(BI26>0,CONCATENATE(BI25,CHAR(10)),\"\"),IF(BJ26>0,CONCATENATE(BJ25,CHAR(10)),\"\"),IF(BK26>0,CONCATENATE(BK25,CHAR(10)),\"\"),IF(BL26>0,CONCATENATE(BL25,CHAR(10)),\"\"),IF(BM26>0,CONCATENATE(BM25,CHAR(10)),\"\"))","v":""},{"$f":"CONCATENATE(IF(AX26>0,CONCATENATE(AX26,\"(\",(8*AX26),\")\",CHAR(10)),\"\"),IF(AY26>0,CONCATENATE(AY26,\"(\",(8*AY26),\")\",CHAR(10)),\"\"),IF(AZ26>0,CONCATENATE(AZ26,\"(\",(8*AZ26),\")\",CHAR(10)),\"\"),IF(BA26>0,CONCATENATE(BA26,\"(\",(8*BA26),\")\",CHAR(10)),\"\"),IF(BB26>0,CONCATENATE(BB26,\"(\",(8*BB26),\")\",CHAR(10)),\"\"),IF(BC26>0,CONCATENATE(BC26,\"(\",(8*BC26),\")\",CHAR(10)),\"\"),IF(BD26>0,CONCATENATE(BD26,\"(\",(8*BD26),\")\",CHAR(10)),\"\"),IF(BE26>0,CONCATENATE(BE26,\"(\",(8*BE26),\")\",CHAR(10)),\"\"))","v":"3(24)\n"},{"$f":"CONCATENATE(IF(BF26>0,CONCATENATE(BF26,\"(\",(8*BF26),\")\",CHAR(10)),\"\"),IF(BG26>0,CONCATENATE(BG26,\"(\",(8*BG26),\")\",CHAR(10)),\"\"),IF(BH26>0,CONCATENATE(BH26,\"(\",(8*BH26),\")\",CHAR(10)),\"\"),IF(BI26>0,CONCATENATE(BI26,\"(\",(8*BI26),\")\",CHAR(10)),\"\"),IF(BJ26>0,CONCATENATE(BJ26,\"(\",(8*BJ26),\")\",CHAR(10)),\"\"),IF(BK26>0,CONCATENATE(BK26,\"(\",(8*BK26),\")\",CHAR(10)),\"\"),IF(BL26>0,CONCATENATE(BL26,\"(\",(8*BL26),\")\",CHAR(10)),\"\"),IF(BM26>0,CONCATENATE(BM26,\"(\",(8*BM26),\")\",CHAR(10)),\"\"))","v":""}]
[null,null,"Начальник отдела ",null,{"$f":"IF(E27+IF(E25=\"Я\",8, IF(E25=\"РВ\",8,0))-E$1<>0,E27+IF(E25=\"Я\",8, IF(E25=\"РВ\",8,0))-E$1,\"\")","v":8},8,8,8,8,"","",8,8,8,8,8,"","",8,{"$f":"SUM(E26:S26)","v":88},{"$f":"IF(U27+IF(U25=\"Я\",8, IF(U25=\"РВ\",8,0))-U$1<>0,U27+IF(U25=\"Я\",8, IF(U25=\"РВ\",8,0))-U$1,\"\")","v":8},8,8,8,"","",8,8,8,8,8,"","","","","",{"$f":"SUM(U26:AJ26)","v":72},null,null,null,null,{"$f":"IF(SUMIF(E25:AJ26,\"РВ\",E26:AJ26)<=0,\"\",SUMIF(E25:AJ26,\"РВ\",E26:AJ26))","v":""},null,null,null,null,null,1,null,{"$f":"COUNTIF($E25:$S25,AX$17)+COUNTIF($U25:$AJ25,AX$17)","v":0},0,0,0,0,0,3,0,0,0,0,0,0,0,0,0]
[null,null,"сверхурочная работа",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E27:S27)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U27:AJ27)","v":0},null,null,{"$f":"T27+AK27","v":0},null,null,null,null,null,null,null,{"$f":"IF(T27+AK27>0,1,0)","v":0}]
[null,4,null,null,"Я","Я","Я","Я","Я","В","В","Я","Я","Я","Я","Я","В","В","Я",{"$f":"COUNTIF(E28:S28,\"Я\")+COUNTIF(E28:S28,\"РВ\")","v":11},"Я","Я","Я","Я","В","В","Я","Я","Я","Я","Я","В","В","Я","Я","Я",{"$f":"COUNTIF(U28:AJ28,\"Я\")+COUNTIF(U28:AJ28,\"РВ\")","v":12},{"$f":"T28+AK28","v":23},{"$f":"T29+AK29","v":192},null,null,{"$f":"COUNTIF($E28:$S28,\"РВ\")+COUNTIF($U28:$AJ28,\"РВ\")","v":0},null,{"$f":"IF(SUM($AX29:$BM29)>0,CONCATENATE(SUM($AX29:$BM29),\"(\",8*SUM($AX29:$BM29),\")\"),\"\")","v":""},{"$f":"CONCATENATE(BV28,BW28)","v":""},{"$f":"CONCATENATE(BX28,BY28)","v":""},{"$f":"COUNTIF(U28:AJ28,\"В\")+COUNTIF(E28:S28,\"В\")+COUNTIF(U28:AJ28,\"РВ\")+COUNTIF(E28:S28,\"РВ\")","v":8},1,null,{"$f":"IF(AX29<>0,AX$17,\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"COUNTBLANK(AX28:BM28)","v":16},null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF(AX29>0,CONCATENATE(AX28,CHAR(10)),\"\"),IF(AY29>0,CONCATENATE(AY28,CHAR(10)),\"\"),IF(AZ29>0,CONCATENATE(AZ28,CHAR(10),),\"\"),IF(BA29>0,CONCATENATE(BA28,CHAR(10)),\"\"),IF(BB29>0,CONCATENATE(BB28,CHAR(10)),\"\"),IF(BC29>0,CONCATENATE(BC28,CHAR(10)),\"\"),IF(BD29>0,CONCATENATE(BD28,CHAR(10)),\"\"),IF(BE29>0,CONCATENATE(BE28,CHAR(10)),\"\"))","v":""},{"$f":"CONCATENATE(IF(BF29>0,CONCATENATE(BF28,CHAR(10)),\"\"),IF(BG29>0,CONCATENATE(BG28,CHAR(10)),\"\"),IF(BH29>0,CONCATENATE(BH28,CHAR(10),),\"\"),IF(BI29>0,CONCATENATE(BI28,CHAR(10)),\"\"),IF(BJ29>0,CONCATENATE(BJ28,CHAR(10)),\"\"),IF(BK29>0,CONCATENATE(BK28,CHAR(10)),\"\"),IF(BL29>0,CONCATENATE(BL28,CHAR(10)),\"\"),IF(BM29>0,CONCATENATE(BM28,CHAR(10)),\"\"))","v":""},{"$f":"CONCATENATE(IF(AX29>0,CONCATENATE(AX29,\"(\",(8*AX29),\")\",CHAR(10)),\"\"),IF(AY29>0,CONCATENATE(AY29,\"(\",(8*AY29),\")\",CHAR(10)),\"\"),IF(AZ29>0,CONCATENATE(AZ29,\"(\",(8*AZ29),\")\",CHAR(10)),\"\"),IF(BA29>0,CONCATENATE(BA29,\"(\",(8*BA29),\")\",CHAR(10)),\"\"),IF(BB29>0,CONCATENATE(BB29,\"(\",(8*BB29),\")\",CHAR(10)),\"\"),IF(BC29>0,CONCATENATE(BC29,\"(\",(8*BC29),\")\",CHAR(10)),\"\"),IF(BD29>0,CONCATENATE(BD29,\"(\",(8*BD29),\")\",CHAR(10)),\"\"),IF(BE29>0,CONCATENATE(BE29,\"(\",(8*BE29),\")\",CHAR(10)),\"\"))","v":""},{"$f":"CONCATENATE(IF(BF29>0,CONCATENATE(BF29,\"(\",(8*BF29),\")\",CHAR(10)),\"\"),IF(BG29>0,CONCATENATE(BG29,\"(\",(8*BG29),\")\",CHAR(10)),\"\"),IF(BH29>0,CONCATENATE(BH29,\"(\",(8*BH29),\")\",CHAR(10)),\"\"),IF(BI29>0,CONCATENATE(BI29,\"(\",(8*BI29),\")\",CHAR(10)),\"\"),IF(BJ29>0,CONCATENATE(BJ29,\"(\",(8*BJ29),\")\",CHAR(10)),\"\"),IF(BK29>0,CONCATENATE(BK29,\"(\",(8*BK29),\")\",CHAR(10)),\"\"),IF(BL29>0,CONCATENATE(BL29,\"(\",(8*BL29),\")\",CHAR(10)),\"\"),IF(BM29>0,CONCATENATE(BM29,\"(\",(8*BM29),\")\",CHAR(10)),\"\"))","v":""}]
[null,null,"ведущий инженер",null,{"$f":"IF(E30+IF(E28=\"Я\",8, IF(E28=\"РВ\",8,0))-E$1<>0,E30+IF(E28=\"Я\",8, IF(E28=\"РВ\",8,0))-E$1,\"\")","v":8},8,8,8,8,"","",10,10,8,12,8,"","",8,{"$f":"SUM(E29:S29)","v":96},{"$f":"IF(U30+IF(U28=\"Я\",8, IF(U28=\"РВ\",8,0))-U$1<>0,U30+IF(U28=\"Я\",8, IF(U28=\"РВ\",8,0))-U$1,\"\")","v":8},8,8,8,"","",8,8,8,8,8,"","",8,8,8,{"$f":"SUM(U29:AJ29)","v":96},null,null,null,null,{"$f":"IF(SUMIF(E28:AJ29,\"РВ\",E29:AJ29)<=0,\"\",SUMIF(E28:AJ29,\"РВ\",E29:AJ29))","v":""},null,null,null,null,null,1,null,{"$f":"COUNTIF($E28:$S28,AX$17)+COUNTIF($U28:$AJ28,AX$17)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"сверхурочная работа",null,null,null,null,null,null,null,null,2,2,null,4,null,null,null,null,{"$f":"SUM(E30:S30)","v":8},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U30:AJ30)","v":0},null,null,{"$f":"T30+AK30","v":8},null,null,null,null,null,null,null,{"$f":"IF(T30+AK30>0,1,0)","v":1}]
[null,5,null,null,"ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ",{"$f":"COUNTIF(E31:S31,\"Я\")+COUNTIF(E31:S31,\"РВ\")","v":0},"ОТ","ОТ","ОТ","Я","В","В","Я","ДО","Я","Я","Я","В","В","НН","НН","НН",{"$f":"COUNTIF(U31:AJ31,\"Я\")+COUNTIF(U31:AJ31,\"РВ\")","v":5},{"$f":"T31+AK31","v":5},{"$f":"T32+AK32","v":40},null,null,{"$f":"COUNTIF($E31:$S31,\"РВ\")+COUNTIF($U31:$AJ31,\"РВ\")","v":0},null,{"$f":"IF(SUM($AX32:$BM32)>0,CONCATENATE(SUM($AX32:$BM32),\"(\",8*SUM($AX32:$BM32),\")\"),\"\")","v":"22(176)"},{"$f":"CONCATENATE(BV31,BW31)","v":"ОТ\nДО\nНН\n"},{"$f":"CONCATENATE(BX31,BY31)","v":"18(144)\n1(8)\n3(24)\n"},{"$f":"COUNTIF(U31:AJ31,\"В\")+COUNTIF(E31:S31,\"В\")+COUNTIF(U31:AJ31,\"РВ\")+COUNTIF(E31:S31,\"РВ\")","v":4},1,null,{"$f":"IF(AX32<>0,AX$17,\"\")","v":""},"ОТ","","","","ДО","НН","","","","","","","","","",{"$f":"COUNTBLANK(AX31:BM31)","v":13},null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF(AX32>0,CONCATENATE(AX31,CHAR(10)),\"\"),IF(AY32>0,CONCATENATE(AY31,CHAR(10)),\"\"),IF(AZ32>0,CONCATENATE(AZ31,CHAR(10),),\"\"),IF(BA32>0,CONCATENATE(BA31,CHAR(10)),\"\"),IF(BB32>0,CONCATENATE(BB31,CHAR(10)),\"\"),IF(BC32>0,CONCATENATE(BC31,CHAR(10)),\"\"),IF(BD32>0,CONCATENATE(BD31,CHAR(10)),\"\"),IF(BE32>0,CONCATENATE(BE31,CHAR(10)),\"\"))","v":"ОТ\nДО\nНН\n"},{"$f":"CONCATENATE(IF(BF32>0,CONCATENATE(BF31,CHAR(10)),\"\"),IF(BG32>0,CONCATENATE(BG31,CHAR(10)),\"\"),IF(BH32>0,CONCATENATE(BH31,CHAR(10),),\"\"),IF(BI32>0,CONCATENATE(BI31,CHAR(10)),\"\"),IF(BJ32>0,CONCATENATE(BJ31,CHAR(10)),\"\"),IF(BK32>0,CONCATENATE(BK31,CHAR(10)),\"\"),IF(BL32>0,CONCATENATE(BL31,CHAR(10)),\"\"),IF(BM32>0,CONCATENATE(BM31,CHAR(10)),\"\"))","v":""},{"$f":"CONCATENATE(IF(AX32>0,CONCATENATE(AX32,\"(\",(8*AX32),\")\",CHAR(10)),\"\"),IF(AY32>0,CONCATENATE(AY32,\"(\",(8*AY32),\")\",CHAR(10)),\"\"),IF(AZ32>0,CONCATENATE(AZ32,\"(\",(8*AZ32),\")\",CHAR(10)),\"\"),IF(BA32>0,CONCATENATE(BA32,\"(\",(8*BA32),\")\",CHAR(10)),\"\"),IF(BB32>0,CONCATENATE(BB32,\"(\",(8*BB32),\")\",CHAR(10)),\"\"),IF(BC32>0,CONCATENATE(BC32,\"(\",(8*BC32),\")\",CHAR(10)),\"\"),IF(BD32>0,CONCATENATE(BD32,\"(\",(8*BD32),\")\",CHAR(10)),\"\"),IF(BE32>0,CONCATENATE(BE32,\"(\",(8*BE32),\")\",CHAR(10)),\"\"))","v":"18(144)\n1(8)\n3(24)\n"},{"$f":"CONCATENATE(IF(BF32>0,CONCATENATE(BF32,\"(\",(8*BF32),\")\",CHAR(10)),\"\"),IF(BG32>0,CONCATENATE(BG32,\"(\",(8*BG32),\")\",CHAR(10)),\"\"),IF(BH32>0,CONCATENATE(BH32,\"(\",(8*BH32),\")\",CHAR(10)),\"\"),IF(BI32>0,CONCATENATE(BI32,\"(\",(8*BI32),\")\",CHAR(10)),\"\"),IF(BJ32>0,CONCATENATE(BJ32,\"(\",(8*BJ32),\")\",CHAR(10)),\"\"),IF(BK32>0,CONCATENATE(BK32,\"(\",(8*BK32),\")\",CHAR(10)),\"\"),IF(BL32>0,CONCATENATE(BL32,\"(\",(8*BL32),\")\",CHAR(10)),\"\"),IF(BM32>0,CONCATENATE(BM32,\"(\",(8*BM32),\")\",CHAR(10)),\"\"))","v":""}]
[null,null,"Старший инженер  ",null,{"$f":"IF(E33+IF(E31=\"Я\",8, IF(E31=\"РВ\",8,0))-E$1<>0,E33+IF(E31=\"Я\",8, IF(E31=\"РВ\",8,0))-E$1,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"SUM(E32:S32)","v":0},{"$f":"IF(U33+IF(U31=\"Я\",8, IF(U31=\"РВ\",8,0))-U$1<>0,U33+IF(U31=\"Я\",8, IF(U31=\"РВ\",8,0))-U$1,\"\")","v":""},"","",8,"","",8,"",8,8,8,"","","","","",{"$f":"SUM(U32:AJ32)","v":40},null,null,null,null,{"$f":"IF(SUMIF(E31:AJ32,\"РВ\",E32:AJ32)<=0,\"\",SUMIF(E31:AJ32,\"РВ\",E32:AJ32))","v":""},null,null,null,null,null,1,null,{"$f":"COUNTIF($E31:$S31,AX$17)+COUNTIF($U31:$AJ31,AX$17)","v":0},18,0,0,0,1,3,0,0,0,0,0,0,0,0,0]
[null,null,"сверхурочная работа",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E33:S33)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U33:AJ33)","v":0},null,null,{"$f":"T33+AK33","v":0},null,null,null,null,null,null,null,{"$f":"IF(T33+AK33>0,1,0)","v":0}]
[null,6,null,null,"ОТ","ОТ","ОТ","ОТ","Я","В","В","Я","Я","Я","Я","Я","В","В","Я",{"$f":"COUNTIF(E34:S34,\"Я\")+COUNTIF(E34:S34,\"РВ\")","v":7},"Я","Я","Я","Я","В","В","Б","Б","Б","Б","Б","Б","Б","Б","Я","Я",{"$f":"COUNTIF(U34:AJ34,\"Я\")+COUNTIF(U34:AJ34,\"РВ\")","v":6},{"$f":"T34+AK34","v":13},{"$f":"T35+AK35","v":104},null,null,{"$f":"COUNTIF($E34:$S34,\"РВ\")+COUNTIF($U34:$AJ34,\"РВ\")","v":0},null,{"$f":"IF(SUM($AX35:$BM35)>0,CONCATENATE(SUM($AX35:$BM35),\"(\",8*SUM($AX35:$BM35),\")\"),\"\")","v":"12(96)"},{"$f":"CONCATENATE(BV34,BW34)","v":"ОТ\nБ\n"},{"$f":"CONCATENATE(BX34,BY34)","v":"4(32)\n8(64)\n"},{"$f":"COUNTIF(U34:AJ34,\"В\")+COUNTIF(E34:S34,\"В\")+COUNTIF(U34:AJ34,\"РВ\")+COUNTIF(E34:S34,\"РВ\")","v":6},1,null,{"$f":"IF(AX35<>0,AX$17,\"\")","v":""},"ОТ","","","Б","","","","","","","","","","","",{"$f":"COUNTBLANK(AX34:BM34)","v":14},null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF(AX35>0,CONCATENATE(AX34,CHAR(10)),\"\"),IF(AY35>0,CONCATENATE(AY34,CHAR(10)),\"\"),IF(AZ35>0,CONCATENATE(AZ34,CHAR(10),),\"\"),IF(BA35>0,CONCATENATE(BA34,CHAR(10)),\"\"),IF(BB35>0,CONCATENATE(BB34,CHAR(10)),\"\"),IF(BC35>0,CONCATENATE(BC34,CHAR(10)),\"\"),IF(BD35>0,CONCATENATE(BD34,CHAR(10)),\"\"),IF(BE35>0,CONCATENATE(BE34,CHAR(10)),\"\"))","v":"ОТ\nБ\n"},{"$f":"CONCATENATE(IF(BF35>0,CONCATENATE(BF34,CHAR(10)),\"\"),IF(BG35>0,CONCATENATE(BG34,CHAR(10)),\"\"),IF(BH35>0,CONCATENATE(BH34,CHAR(10),),\"\"),IF(BI35>0,CONCATENATE(BI34,CHAR(10)),\"\"),IF(BJ35>0,CONCATENATE(BJ34,CHAR(10)),\"\"),IF(BK35>0,CONCATENATE(BK34,CHAR(10)),\"\"),IF(BL35>0,CONCATENATE(BL34,CHAR(10)),\"\"),IF(BM35>0,CONCATENATE(BM34,CHAR(10)),\"\"))","v":""},{"$f":"CONCATENATE(IF(AX35>0,CONCATENATE(AX35,\"(\",(8*AX35),\")\",CHAR(10)),\"\"),IF(AY35>0,CONCATENATE(AY35,\"(\",(8*AY35),\")\",CHAR(10)),\"\"),IF(AZ35>0,CONCATENATE(AZ35,\"(\",(8*AZ35),\")\",CHAR(10)),\"\"),IF(BA35>0,CONCATENATE(BA35,\"(\",(8*BA35),\")\",CHAR(10)),\"\"),IF(BB35>0,CONCATENATE(BB35,\"(\",(8*BB35),\")\",CHAR(10)),\"\"),IF(BC35>0,CONCATENATE(BC35,\"(\",(8*BC35),\")\",CHAR(10)),\"\"),IF(BD35>0,CONCATENATE(BD35,\"(\",(8*BD35),\")\",CHAR(10)),\"\"),IF(BE35>0,CONCATENATE(BE35,\"(\",(8*BE35),\")\",CHAR(10)),\"\"))","v":"4(32)\n8(64)\n"},{"$f":"CONCATENATE(IF(BF35>0,CONCATENATE(BF35,\"(\",(8*BF35),\")\",CHAR(10)),\"\"),IF(BG35>0,CONCATENATE(BG35,\"(\",(8*BG35),\")\",CHAR(10)),\"\"),IF(BH35>0,CONCATENATE(BH35,\"(\",(8*BH35),\")\",CHAR(10)),\"\"),IF(BI35>0,CONCATENATE(BI35,\"(\",(8*BI35),\")\",CHAR(10)),\"\"),IF(BJ35>0,CONCATENATE(BJ35,\"(\",(8*BJ35),\")\",CHAR(10)),\"\"),IF(BK35>0,CONCATENATE(BK35,\"(\",(8*BK35),\")\",CHAR(10)),\"\"),IF(BL35>0,CONCATENATE(BL35,\"(\",(8*BL35),\")\",CHAR(10)),\"\"),IF(BM35>0,CONCATENATE(BM35,\"(\",(8*BM35),\")\",CHAR(10)),\"\"))","v":""}]
[null,null,"Старший инженер  ",null,{"$f":"IF(E36+IF(E34=\"Я\",8, IF(E34=\"РВ\",8,0))-E$1<>0,E36+IF(E34=\"Я\",8, IF(E34=\"РВ\",8,0))-E$1,\"\")","v":""},"","","",8,"","",8,8,8,8,8,"","",8,{"$f":"SUM(E35:S35)","v":56},{"$f":"IF(U36+IF(U34=\"Я\",8, IF(U34=\"РВ\",8,0))-U$1<>0,U36+IF(U34=\"Я\",8, IF(U34=\"РВ\",8,0))-U$1,\"\")","v":8},8,8,8,"","","","","","","","","","",8,8,{"$f":"SUM(U35:AJ35)","v":48},null,null,null,null,{"$f":"IF(SUMIF(E34:AJ35,\"РВ\",E35:AJ35)<=0,\"\",SUMIF(E34:AJ35,\"РВ\",E35:AJ35))","v":""},null,null,null,null,null,1,null,{"$f":"COUNTIF($E34:$S34,AX$17)+COUNTIF($U34:$AJ34,AX$17)","v":0},4,0,0,8,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"сверхурочная работа",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E36:S36)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U36:AJ36)","v":0},null,null,{"$f":"T36+AK36","v":0},null,null,null,null,null,null,null,{"$f":"IF(T36+AK36>0,1,0)","v":0}]
[null,7,null,null,"ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ",{"$f":"COUNTIF(E37:S37,\"Я\")+COUNTIF(E37:S37,\"РВ\")","v":0},"ОТ","ОТ","ОТ","Я","В","В","Я","Я","Я","Я","Я","В","В","Я","Я","Я",{"$f":"COUNTIF(U37:AJ37,\"Я\")+COUNTIF(U37:AJ37,\"РВ\")","v":9},{"$f":"T37+AK37","v":9},{"$f":"T38+AK38","v":72},null,null,{"$f":"COUNTIF($E37:$S37,\"РВ\")+COUNTIF($U37:$AJ37,\"РВ\")","v":0},null,{"$f":"IF(SUM($AX38:$BM38)>0,CONCATENATE(SUM($AX38:$BM38),\"(\",8*SUM($AX38:$BM38),\")\"),\"\")","v":"18(144)"},{"$f":"CONCATENATE(BV37,BW37)","v":"ОТ\n"},{"$f":"CONCATENATE(BX37,BY37)","v":"18(144)\n"},{"$f":"COUNTIF(U37:AJ37,\"В\")+COUNTIF(E37:S37,\"В\")+COUNTIF(U37:AJ37,\"РВ\")+COUNTIF(E37:S37,\"РВ\")","v":4},1,null,{"$f":"IF(AX38<>0,AX$17,\"\")","v":""},"ОТ","","","","","","","","","","","","","","",{"$f":"COUNTBLANK(AX37:BM37)","v":15},null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF(AX38>0,CONCATENATE(AX37,CHAR(10)),\"\"),IF(AY38>0,CONCATENATE(AY37,CHAR(10)),\"\"),IF(AZ38>0,CONCATENATE(AZ37,CHAR(10),),\"\"),IF(BA38>0,CONCATENATE(BA37,CHAR(10)),\"\"),IF(BB38>0,CONCATENATE(BB37,CHAR(10)),\"\"),IF(BC38>0,CONCATENATE(BC37,CHAR(10)),\"\"),IF(BD38>0,CONCATENATE(BD37,CHAR(10)),\"\"),IF(BE38>0,CONCATENATE(BE37,CHAR(10)),\"\"))","v":"ОТ\n"},{"$f":"CONCATENATE(IF(BF38>0,CONCATENATE(BF37,CHAR(10)),\"\"),IF(BG38>0,CONCATENATE(BG37,CHAR(10)),\"\"),IF(BH38>0,CONCATENATE(BH37,CHAR(10),),\"\"),IF(BI38>0,CONCATENATE(BI37,CHAR(10)),\"\"),IF(BJ38>0,CONCATENATE(BJ37,CHAR(10)),\"\"),IF(BK38>0,CONCATENATE(BK37,CHAR(10)),\"\"),IF(BL38>0,CONCATENATE(BL37,CHAR(10)),\"\"),IF(BM38>0,CONCATENATE(BM37,CHAR(10)),\"\"))","v":""},{"$f":"CONCATENATE(IF(AX38>0,CONCATENATE(AX38,\"(\",(8*AX38),\")\",CHAR(10)),\"\"),IF(AY38>0,CONCATENATE(AY38,\"(\",(8*AY38),\")\",CHAR(10)),\"\"),IF(AZ38>0,CONCATENATE(AZ38,\"(\",(8*AZ38),\")\",CHAR(10)),\"\"),IF(BA38>0,CONCATENATE(BA38,\"(\",(8*BA38),\")\",CHAR(10)),\"\"),IF(BB38>0,CONCATENATE(BB38,\"(\",(8*BB38),\")\",CHAR(10)),\"\"),IF(BC38>0,CONCATENATE(BC38,\"(\",(8*BC38),\")\",CHAR(10)),\"\"),IF(BD38>0,CONCATENATE(BD38,\"(\",(8*BD38),\")\",CHAR(10)),\"\"),IF(BE38>0,CONCATENATE(BE38,\"(\",(8*BE38),\")\",CHAR(10)),\"\"))","v":"18(144)\n"},{"$f":"CONCATENATE(IF(BF38>0,CONCATENATE(BF38,\"(\",(8*BF38),\")\",CHAR(10)),\"\"),IF(BG38>0,CONCATENATE(BG38,\"(\",(8*BG38),\")\",CHAR(10)),\"\"),IF(BH38>0,CONCATENATE(BH38,\"(\",(8*BH38),\")\",CHAR(10)),\"\"),IF(BI38>0,CONCATENATE(BI38,\"(\",(8*BI38),\")\",CHAR(10)),\"\"),IF(BJ38>0,CONCATENATE(BJ38,\"(\",(8*BJ38),\")\",CHAR(10)),\"\"),IF(BK38>0,CONCATENATE(BK38,\"(\",(8*BK38),\")\",CHAR(10)),\"\"),IF(BL38>0,CONCATENATE(BL38,\"(\",(8*BL38),\")\",CHAR(10)),\"\"),IF(BM38>0,CONCATENATE(BM38,\"(\",(8*BM38),\")\",CHAR(10)),\"\"))","v":""}]
[null,null,"инженер",null,{"$f":"IF(E39+IF(E37=\"Я\",8, IF(E37=\"РВ\",8,0))-E$1<>0,E39+IF(E37=\"Я\",8, IF(E37=\"РВ\",8,0))-E$1,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"SUM(E38:S38)","v":0},{"$f":"IF(U39+IF(U37=\"Я\",8, IF(U37=\"РВ\",8,0))-U$1<>0,U39+IF(U37=\"Я\",8, IF(U37=\"РВ\",8,0))-U$1,\"\")","v":""},"","",8,"","",8,8,8,8,8,"","",8,8,8,{"$f":"SUM(U38:AJ38)","v":72},null,null,null,null,{"$f":"IF(SUMIF(E37:AJ38,\"РВ\",E38:AJ38)<=0,\"\",SUMIF(E37:AJ38,\"РВ\",E38:AJ38))","v":""},null,null,null,null,null,1,null,{"$f":"COUNTIF($E37:$S37,AX$17)+COUNTIF($U37:$AJ37,AX$17)","v":0},18,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"сверхурочная работа",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E39:S39)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U39:AJ39)","v":0},null,null,{"$f":"T39+AK39","v":0},null,null,null,null,null,null,null,{"$f":"IF(T39+AK39>0,1,0)","v":0}]
[null,8,null,null,"Я","Я","Я","Я","Я","В","В","Я","Я","Я","Я","Я","В","В","Я",{"$f":"COUNTIF(E40:S40,\"Я\")+COUNTIF(E40:S40,\"РВ\")","v":11},"Я","Я","Я","Я","В","В","Я","Я","Я","Я","Я","В","В","Я","Я","Я",{"$f":"COUNTIF(U40:AJ40,\"Я\")+COUNTIF(U40:AJ40,\"РВ\")","v":12},{"$f":"T40+AK40","v":23},{"$f":"T41+AK41","v":184},null,null,{"$f":"COUNTIF($E40:$S40,\"РВ\")+COUNTIF($U40:$AJ40,\"РВ\")","v":0},null,{"$f":"IF(SUM($AX41:$BM41)>0,CONCATENATE(SUM($AX41:$BM41),\"(\",8*SUM($AX41:$BM41),\")\"),\"\")","v":""},{"$f":"CONCATENATE(BV40,BW40)","v":""},{"$f":"CONCATENATE(BX40,BY40)","v":""},{"$f":"COUNTIF(U40:AJ40,\"В\")+COUNTIF(E40:S40,\"В\")+COUNTIF(U40:AJ40,\"РВ\")+COUNTIF(E40:S40,\"РВ\")","v":8},1,null,{"$f":"IF(AX41<>0,AX$17,\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"COUNTBLANK(AX40:BM40)","v":16},null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF(AX41>0,CONCATENATE(AX40,CHAR(10)),\"\"),IF(AY41>0,CONCATENATE(AY40,CHAR(10)),\"\"),IF(AZ41>0,CONCATENATE(AZ40,CHAR(10),),\"\"),IF(BA41>0,CONCATENATE(BA40,CHAR(10)),\"\"),IF(BB41>0,CONCATENATE(BB40,CHAR(10)),\"\"),IF(BC41>0,CONCATENATE(BC40,CHAR(10)),\"\"),IF(BD41>0,CONCATENATE(BD40,CHAR(10)),\"\"),IF(BE41>0,CONCATENATE(BE40,CHAR(10)),\"\"))","v":""},{"$f":"CONCATENATE(IF(BF41>0,CONCATENATE(BF40,CHAR(10)),\"\"),IF(BG41>0,CONCATENATE(BG40,CHAR(10)),\"\"),IF(BH41>0,CONCATENATE(BH40,CHAR(10),),\"\"),IF(BI41>0,CONCATENATE(BI40,CHAR(10)),\"\"),IF(BJ41>0,CONCATENATE(BJ40,CHAR(10)),\"\"),IF(BK41>0,CONCATENATE(BK40,CHAR(10)),\"\"),IF(BL41>0,CONCATENATE(BL40,CHAR(10)),\"\"),IF(BM41>0,CONCATENATE(BM40,CHAR(10)),\"\"))","v":""},{"$f":"CONCATENATE(IF(AX41>0,CONCATENATE(AX41,\"(\",(8*AX41),\")\",CHAR(10)),\"\"),IF(AY41>0,CONCATENATE(AY41,\"(\",(8*AY41),\")\",CHAR(10)),\"\"),IF(AZ41>0,CONCATENATE(AZ41,\"(\",(8*AZ41),\")\",CHAR(10)),\"\"),IF(BA41>0,CONCATENATE(BA41,\"(\",(8*BA41),\")\",CHAR(10)),\"\"),IF(BB41>0,CONCATENATE(BB41,\"(\",(8*BB41),\")\",CHAR(10)),\"\"),IF(BC41>0,CONCATENATE(BC41,\"(\",(8*BC41),\")\",CHAR(10)),\"\"),IF(BD41>0,CONCATENATE(BD41,\"(\",(8*BD41),\")\",CHAR(10)),\"\"),IF(BE41>0,CONCATENATE(BE41,\"(\",(8*BE41),\")\",CHAR(10)),\"\"))","v":""},{"$f":"CONCATENATE(IF(BF41>0,CONCATENATE(BF41,\"(\",(8*BF41),\")\",CHAR(10)),\"\"),IF(BG41>0,CONCATENATE(BG41,\"(\",(8*BG41),\")\",CHAR(10)),\"\"),IF(BH41>0,CONCATENATE(BH41,\"(\",(8*BH41),\")\",CHAR(10)),\"\"),IF(BI41>0,CONCATENATE(BI41,\"(\",(8*BI41),\")\",CHAR(10)),\"\"),IF(BJ41>0,CONCATENATE(BJ41,\"(\",(8*BJ41),\")\",CHAR(10)),\"\"),IF(BK41>0,CONCATENATE(BK41,\"(\",(8*BK41),\")\",CHAR(10)),\"\"),IF(BL41>0,CONCATENATE(BL41,\"(\",(8*BL41),\")\",CHAR(10)),\"\"),IF(BM41>0,CONCATENATE(BM41,\"(\",(8*BM41),\")\",CHAR(10)),\"\"))","v":""}]
[null,null,"инженер",null,{"$f":"IF(E42+IF(E40=\"Я\",8, IF(E40=\"РВ\",8,0))-E$1<>0,E42+IF(E40=\"Я\",8, IF(E40=\"РВ\",8,0))-E$1,\"\")","v":8},8,8,8,8,"","",8,8,8,8,8,"","",8,{"$f":"SUM(E41:S41)","v":88},{"$f":"IF(U42+IF(U40=\"Я\",8, IF(U40=\"РВ\",8,0))-U$1<>0,U42+IF(U40=\"Я\",8, IF(U40=\"РВ\",8,0))-U$1,\"\")","v":8},8,8,8,"","",8,8,8,8,8,"","",8,8,8,{"$f":"SUM(U41:AJ41)","v":96},null,null,null,null,{"$f":"IF(SUMIF(E40:AJ41,\"РВ\",E41:AJ41)<=0,\"\",SUMIF(E40:AJ41,\"РВ\",E41:AJ41))","v":""},null,null,null,null,null,1,null,{"$f":"COUNTIF($E40:$S40,AX$17)+COUNTIF($U40:$AJ40,AX$17)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"сверхурочная работа",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E42:S42)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U42:AJ42)","v":0},null,null,{"$f":"T42+AK42","v":0},null,null,null,null,null,null,null,{"$f":"IF(T42+AK42>0,1,0)","v":0}]
[null,9,null,null,"Я","Я","Я","Я","Я","В","В","Я","Я","Я","Я","Я","В","В","Я",{"$f":"COUNTIF(E43:S43,\"Я\")+COUNTIF(E43:S43,\"РВ\")","v":11},"Я","Я","Я","Я","В","В","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ",{"$f":"COUNTIF(U43:AJ43,\"Я\")+COUNTIF(U43:AJ43,\"РВ\")","v":4},{"$f":"T43+AK43","v":15},{"$f":"T44+AK44","v":120},null,null,{"$f":"COUNTIF($E43:$S43,\"РВ\")+COUNTIF($U43:$AJ43,\"РВ\")","v":0},null,{"$f":"IF(SUM($AX44:$BM44)>0,CONCATENATE(SUM($AX44:$BM44),\"(\",8*SUM($AX44:$BM44),\")\"),\"\")","v":"10(80)"},{"$f":"CONCATENATE(BV43,BW43)","v":"ОТ\n"},{"$f":"CONCATENATE(BX43,BY43)","v":"10(80)\n"},{"$f":"COUNTIF(U43:AJ43,\"В\")+COUNTIF(E43:S43,\"В\")+COUNTIF(U43:AJ43,\"РВ\")+COUNTIF(E43:S43,\"РВ\")","v":6},1,null,{"$f":"IF(AX44<>0,AX$17,\"\")","v":""},"ОТ","","","","","","","","","","","","","","",{"$f":"COUNTBLANK(AX43:BM43)","v":15},null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF(AX44>0,CONCATENATE(AX43,CHAR(10)),\"\"),IF(AY44>0,CONCATENATE(AY43,CHAR(10)),\"\"),IF(AZ44>0,CONCATENATE(AZ43,CHAR(10),),\"\"),IF(BA44>0,CONCATENATE(BA43,CHAR(10)),\"\"),IF(BB44>0,CONCATENATE(BB43,CHAR(10)),\"\"),IF(BC44>0,CONCATENATE(BC43,CHAR(10)),\"\"),IF(BD44>0,CONCATENATE(BD43,CHAR(10)),\"\"),IF(BE44>0,CONCATENATE(BE43,CHAR(10)),\"\"))","v":"ОТ\n"},{"$f":"CONCATENATE(IF(BF44>0,CONCATENATE(BF43,CHAR(10)),\"\"),IF(BG44>0,CONCATENATE(BG43,CHAR(10)),\"\"),IF(BH44>0,CONCATENATE(BH43,CHAR(10),),\"\"),IF(BI44>0,CONCATENATE(BI43,CHAR(10)),\"\"),IF(BJ44>0,CONCATENATE(BJ43,CHAR(10)),\"\"),IF(BK44>0,CONCATENATE(BK43,CHAR(10)),\"\"),IF(BL44>0,CONCATENATE(BL43,CHAR(10)),\"\"),IF(BM44>0,CONCATENATE(BM43,CHAR(10)),\"\"))","v":""},{"$f":"CONCATENATE(IF(AX44>0,CONCATENATE(AX44,\"(\",(8*AX44),\")\",CHAR(10)),\"\"),IF(AY44>0,CONCATENATE(AY44,\"(\",(8*AY44),\")\",CHAR(10)),\"\"),IF(AZ44>0,CONCATENATE(AZ44,\"(\",(8*AZ44),\")\",CHAR(10)),\"\"),IF(BA44>0,CONCATENATE(BA44,\"(\",(8*BA44),\")\",CHAR(10)),\"\"),IF(BB44>0,CONCATENATE(BB44,\"(\",(8*BB44),\")\",CHAR(10)),\"\"),IF(BC44>0,CONCATENATE(BC44,\"(\",(8*BC44),\")\",CHAR(10)),\"\"),IF(BD44>0,CONCATENATE(BD44,\"(\",(8*BD44),\")\",CHAR(10)),\"\"),IF(BE44>0,CONCATENATE(BE44,\"(\",(8*BE44),\")\",CHAR(10)),\"\"))","v":"10(80)\n"},{"$f":"CONCATENATE(IF(BF44>0,CONCATENATE(BF44,\"(\",(8*BF44),\")\",CHAR(10)),\"\"),IF(BG44>0,CONCATENATE(BG44,\"(\",(8*BG44),\")\",CHAR(10)),\"\"),IF(BH44>0,CONCATENATE(BH44,\"(\",(8*BH44),\")\",CHAR(10)),\"\"),IF(BI44>0,CONCATENATE(BI44,\"(\",(8*BI44),\")\",CHAR(10)),\"\"),IF(BJ44>0,CONCATENATE(BJ44,\"(\",(8*BJ44),\")\",CHAR(10)),\"\"),IF(BK44>0,CONCATENATE(BK44,\"(\",(8*BK44),\")\",CHAR(10)),\"\"),IF(BL44>0,CONCATENATE(BL44,\"(\",(8*BL44),\")\",CHAR(10)),\"\"),IF(BM44>0,CONCATENATE(BM44,\"(\",(8*BM44),\")\",CHAR(10)),\"\"))","v":""}]
[null,null,"Слесарь КИП и А 6 разряд",null,{"$f":"IF(E45+IF(E43=\"Я\",8, IF(E43=\"РВ\",8,0))-E$1<>0,E45+IF(E43=\"Я\",8, IF(E43=\"РВ\",8,0))-E$1,\"\")","v":8},8,8,8,8,"","",8,8,8,8,8,"","",8,{"$f":"SUM(E44:S44)","v":88},{"$f":"IF(U45+IF(U43=\"Я\",8, IF(U43=\"РВ\",8,0))-U$1<>0,U45+IF(U43=\"Я\",8, IF(U43=\"РВ\",8,0))-U$1,\"\")","v":8},8,8,8,"","","","","","","","","","","","",{"$f":"SUM(U44:AJ44)","v":32},null,null,null,null,{"$f":"IF(SUMIF(E43:AJ44,\"РВ\",E44:AJ44)<=0,\"\",SUMIF(E43:AJ44,\"РВ\",E44:AJ44))","v":""},null,null,null,null,null,1,null,{"$f":"COUNTIF($E43:$S43,AX$17)+COUNTIF($U43:$AJ43,AX$17)","v":0},10,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"сверхурочная работа",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E45:S45)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U45:AJ45)","v":0},null,null,{"$f":"T45+AK45","v":0},null,null,null,null,null,null,null,{"$f":"IF(T45+AK45>0,1,0)","v":0}]
[null,10,null,null,"Я","Я","Я","Я","Я","В","В","Я","Я","Я","Я","Я","В","В","Я",{"$f":"COUNTIF(E46:S46,\"Я\")+COUNTIF(E46:S46,\"РВ\")","v":11},"Я","Я","Я","Я","В","В","Я","Я","Я","Я","Я","В","В","Я","Я","Я",{"$f":"COUNTIF(U46:AJ46,\"Я\")+COUNTIF(U46:AJ46,\"РВ\")","v":12},{"$f":"T46+AK46","v":23},{"$f":"T47+AK47","v":184},null,null,{"$f":"COUNTIF($E46:$S46,\"РВ\")+COUNTIF($U46:$AJ46,\"РВ\")","v":0},null,{"$f":"IF(SUM($AX47:$BM47)>0,CONCATENATE(SUM($AX47:$BM47),\"(\",8*SUM($AX47:$BM47),\")\"),\"\")","v":""},{"$f":"CONCATENATE(BV46,BW46)","v":""},{"$f":"CONCATENATE(BX46,BY46)","v":""},{"$f":"COUNTIF(U46:AJ46,\"В\")+COUNTIF(E46:S46,\"В\")+COUNTIF(U46:AJ46,\"РВ\")+COUNTIF(E46:S46,\"РВ\")","v":8},1,null,{"$f":"IF(AX47<>0,AX$17,\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"COUNTBLANK(AX46:BM46)","v":16},null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF(AX47>0,CONCATENATE(AX46,CHAR(10)),\"\"),IF(AY47>0,CONCATENATE(AY46,CHAR(10)),\"\"),IF(AZ47>0,CONCATENATE(AZ46,CHAR(10),),\"\"),IF(BA47>0,CONCATENATE(BA46,CHAR(10)),\"\"),IF(BB47>0,CONCATENATE(BB46,CHAR(10)),\"\"),IF(BC47>0,CONCATENATE(BC46,CHAR(10)),\"\"),IF(BD47>0,CONCATENATE(BD46,CHAR(10)),\"\"),IF(BE47>0,CONCATENATE(BE46,CHAR(10)),\"\"))","v":""},{"$f":"CONCATENATE(IF(BF47>0,CONCATENATE(BF46,CHAR(10)),\"\"),IF(BG47>0,CONCATENATE(BG46,CHAR(10)),\"\"),IF(BH47>0,CONCATENATE(BH46,CHAR(10),),\"\"),IF(BI47>0,CONCATENATE(BI46,CHAR(10)),\"\"),IF(BJ47>0,CONCATENATE(BJ46,CHAR(10)),\"\"),IF(BK47>0,CONCATENATE(BK46,CHAR(10)),\"\"),IF(BL47>0,CONCATENATE(BL46,CHAR(10)),\"\"),IF(BM47>0,CONCATENATE(BM46,CHAR(10)),\"\"))","v":""},{"$f":"CONCATENATE(IF(AX47>0,CONCATENATE(AX47,\"(\",(8*AX47),\")\",CHAR(10)),\"\"),IF(AY47>0,CONCATENATE(AY47,\"(\",(8*AY47),\")\",CHAR(10)),\"\"),IF(AZ47>0,CONCATENATE(AZ47,\"(\",(8*AZ47),\")\",CHAR(10)),\"\"),IF(BA47>0,CONCATENATE(BA47,\"(\",(8*BA47),\")\",CHAR(10)),\"\"),IF(BB47>0,CONCATENATE(BB47,\"(\",(8*BB47),\")\",CHAR(10)),\"\"),IF(BC47>0,CONCATENATE(BC47,\"(\",(8*BC47),\")\",CHAR(10)),\"\"),IF(BD47>0,CONCATENATE(BD47,\"(\",(8*BD47),\")\",CHAR(10)),\"\"),IF(BE47>0,CONCATENATE(BE47,\"(\",(8*BE47),\")\",CHAR(10)),\"\"))","v":""},{"$f":"CONCATENATE(IF(BF47>0,CONCATENATE(BF47,\"(\",(8*BF47),\")\",CHAR(10)),\"\"),IF(BG47>0,CONCATENATE(BG47,\"(\",(8*BG47),\")\",CHAR(10)),\"\"),IF(BH47>0,CONCATENATE(BH47,\"(\",(8*BH47),\")\",CHAR(10)),\"\"),IF(BI47>0,CONCATENATE(BI47,\"(\",(8*BI47),\")\",CHAR(10)),\"\"),IF(BJ47>0,CONCATENATE(BJ47,\"(\",(8*BJ47),\")\",CHAR(10)),\"\"),IF(BK47>0,CONCATENATE(BK47,\"(\",(8*BK47),\")\",CHAR(10)),\"\"),IF(BL47>0,CONCATENATE(BL47,\"(\",(8*BL47),\")\",CHAR(10)),\"\"),IF(BM47>0,CONCATENATE(BM47,\"(\",(8*BM47),\")\",CHAR(10)),\"\"))","v":""}]
[null,null,"Слесарь КИП и А 6 разряд",null,{"$f":"IF(E48+IF(E46=\"Я\",8, IF(E46=\"РВ\",8,0))-E$1<>0,E48+IF(E46=\"Я\",8, IF(E46=\"РВ\",8,0))-E$1,\"\")","v":8},8,8,8,8,"","",8,8,8,8,8,"","",8,{"$f":"SUM(E47:S47)","v":88},{"$f":"IF(U48+IF(U46=\"Я\",8, IF(U46=\"РВ\",8,0))-U$1<>0,U48+IF(U46=\"Я\",8, IF(U46=\"РВ\",8,0))-U$1,\"\")","v":8},8,8,8,"","",8,8,8,8,8,"","",8,8,8,{"$f":"SUM(U47:AJ47)","v":96},null,null,null,null,{"$f":"IF(SUMIF(E46:AJ47,\"РВ\",E47:AJ47)<=0,\"\",SUMIF(E46:AJ47,\"РВ\",E47:AJ47))","v":""},null,null,null,null,null,1,null,{"$f":"COUNTIF($E46:$S46,AX$17)+COUNTIF($U46:$AJ46,AX$17)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"сверхурочная работа",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E48:S48)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U48:AJ48)","v":0},null,null,{"$f":"T48+AK48","v":0},null,null,null,null,null,null,null,{"$f":"IF(T48+AK48>0,1,0)","v":0}]
[null,11,null,null,"Я","Я","Я","Я","Я","В","В","Я","Я","Я","Я","Б","Б","Б","Б",{"$f":"COUNTIF(E49:S49,\"Я\")+COUNTIF(E49:S49,\"РВ\")","v":9},"Я","Я","Я","Я","В","В","Я","Я","Я","Я","Я","В","В","Я","Я","Я",{"$f":"COUNTIF(U49:AJ49,\"Я\")+COUNTIF(U49:AJ49,\"РВ\")","v":12},{"$f":"T49+AK49","v":21},{"$f":"T50+AK50","v":168},null,null,{"$f":"COUNTIF($E49:$S49,\"РВ\")+COUNTIF($U49:$AJ49,\"РВ\")","v":0},null,{"$f":"IF(SUM($AX50:$BM50)>0,CONCATENATE(SUM($AX50:$BM50),\"(\",8*SUM($AX50:$BM50),\")\"),\"\")","v":"4(32)"},{"$f":"CONCATENATE(BV49,BW49)","v":"Б\n"},{"$f":"CONCATENATE(BX49,BY49)","v":"4(32)\n"},{"$f":"COUNTIF(U49:AJ49,\"В\")+COUNTIF(E49:S49,\"В\")+COUNTIF(U49:AJ49,\"РВ\")+COUNTIF(E49:S49,\"РВ\")","v":6},1,null,{"$f":"IF(AX50<>0,AX$17,\"\")","v":""},"","","","Б","","","","","","","","","","","",{"$f":"COUNTBLANK(AX49:BM49)","v":15},null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF(AX50>0,CONCATENATE(AX49,CHAR(10)),\"\"),IF(AY50>0,CONCATENATE(AY49,CHAR(10)),\"\"),IF(AZ50>0,CONCATENATE(AZ49,CHAR(10),),\"\"),IF(BA50>0,CONCATENATE(BA49,CHAR(10)),\"\"),IF(BB50>0,CONCATENATE(BB49,CHAR(10)),\"\"),IF(BC50>0,CONCATENATE(BC49,CHAR(10)),\"\"),IF(BD50>0,CONCATENATE(BD49,CHAR(10)),\"\"),IF(BE50>0,CONCATENATE(BE49,CHAR(10)),\"\"))","v":"Б\n"},{"$f":"CONCATENATE(IF(BF50>0,CONCATENATE(BF49,CHAR(10)),\"\"),IF(BG50>0,CONCATENATE(BG49,CHAR(10)),\"\"),IF(BH50>0,CONCATENATE(BH49,CHAR(10),),\"\"),IF(BI50>0,CONCATENATE(BI49,CHAR(10)),\"\"),IF(BJ50>0,CONCATENATE(BJ49,CHAR(10)),\"\"),IF(BK50>0,CONCATENATE(BK49,CHAR(10)),\"\"),IF(BL50>0,CONCATENATE(BL49,CHAR(10)),\"\"),IF(BM50>0,CONCATENATE(BM49,CHAR(10)),\"\"))","v":""},{"$f":"CONCATENATE(IF(AX50>0,CONCATENATE(AX50,\"(\",(8*AX50),\")\",CHAR(10)),\"\"),IF(AY50>0,CONCATENATE(AY50,\"(\",(8*AY50),\")\",CHAR(10)),\"\"),IF(AZ50>0,CONCATENATE(AZ50,\"(\",(8*AZ50),\")\",CHAR(10)),\"\"),IF(BA50>0,CONCATENATE(BA50,\"(\",(8*BA50),\")\",CHAR(10)),\"\"),IF(BB50>0,CONCATENATE(BB50,\"(\",(8*BB50),\")\",CHAR(10)),\"\"),IF(BC50>0,CONCATENATE(BC50,\"(\",(8*BC50),\")\",CHAR(10)),\"\"),IF(BD50>0,CONCATENATE(BD50,\"(\",(8*BD50),\")\",CHAR(10)),\"\"),IF(BE50>0,CONCATENATE(BE50,\"(\",(8*BE50),\")\",CHAR(10)),\"\"))","v":"4(32)\n"},{"$f":"CONCATENATE(IF(BF50>0,CONCATENATE(BF50,\"(\",(8*BF50),\")\",CHAR(10)),\"\"),IF(BG50>0,CONCATENATE(BG50,\"(\",(8*BG50),\")\",CHAR(10)),\"\"),IF(BH50>0,CONCATENATE(BH50,\"(\",(8*BH50),\")\",CHAR(10)),\"\"),IF(BI50>0,CONCATENATE(BI50,\"(\",(8*BI50),\")\",CHAR(10)),\"\"),IF(BJ50>0,CONCATENATE(BJ50,\"(\",(8*BJ50),\")\",CHAR(10)),\"\"),IF(BK50>0,CONCATENATE(BK50,\"(\",(8*BK50),\")\",CHAR(10)),\"\"),IF(BL50>0,CONCATENATE(BL50,\"(\",(8*BL50),\")\",CHAR(10)),\"\"),IF(BM50>0,CONCATENATE(BM50,\"(\",(8*BM50),\")\",CHAR(10)),\"\"))","v":""}]
[null,null,"Слесарь КИП и А 6 разряд",null,{"$f":"IF(E51+IF(E49=\"Я\",8, IF(E49=\"РВ\",8,0))-E$1<>0,E51+IF(E49=\"Я\",8, IF(E49=\"РВ\",8,0))-E$1,\"\")","v":8},8,8,8,8,"","",8,8,8,8,"","","","",{"$f":"SUM(E50:S50)","v":72},{"$f":"IF(U51+IF(U49=\"Я\",8, IF(U49=\"РВ\",8,0))-U$1<>0,U51+IF(U49=\"Я\",8, IF(U49=\"РВ\",8,0))-U$1,\"\")","v":8},8,8,8,"","",8,8,8,8,8,"","",8,8,8,{"$f":"SUM(U50:AJ50)","v":96},null,null,null,null,{"$f":"IF(SUMIF(E49:AJ50,\"РВ\",E50:AJ50)<=0,\"\",SUMIF(E49:AJ50,\"РВ\",E50:AJ50))","v":""},null,null,null,null,null,1,null,{"$f":"COUNTIF($E49:$S49,AX$17)+COUNTIF($U49:$AJ49,AX$17)","v":0},0,0,0,4,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"сверхурочная работа",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E51:S51)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U51:AJ51)","v":0},null,null,{"$f":"T51+AK51","v":0},null,null,null,null,null,null,null,{"$f":"IF(T51+AK51>0,1,0)","v":0}]
[null,12,null,null,"ОТ","ОТ","ОТ","ОТ","Я","В","В","Я","Я","Я","Я","Я","В","В","Я",{"$f":"COUNTIF(E52:S52,\"Я\")+COUNTIF(E52:S52,\"РВ\")","v":7},"Б","Б","Б","Б","Б","Б","Б","Я","Я","Я","Я","В","В","Я","Я","Я",{"$f":"COUNTIF(U52:AJ52,\"Я\")+COUNTIF(U52:AJ52,\"РВ\")","v":7},{"$f":"T52+AK52","v":14},{"$f":"T53+AK53","v":112},null,null,{"$f":"COUNTIF($E52:$S52,\"РВ\")+COUNTIF($U52:$AJ52,\"РВ\")","v":0},null,{"$f":"IF(SUM($AX53:$BM53)>0,CONCATENATE(SUM($AX53:$BM53),\"(\",8*SUM($AX53:$BM53),\")\"),\"\")","v":"11(88)"},{"$f":"CONCATENATE(BV52,BW52)","v":"ОТ\nБ\n"},{"$f":"CONCATENATE(BX52,BY52)","v":"4(32)\n7(56)\n"},{"$f":"COUNTIF(U52:AJ52,\"В\")+COUNTIF(E52:S52,\"В\")+COUNTIF(U52:AJ52,\"РВ\")+COUNTIF(E52:S52,\"РВ\")","v":6},1,null,{"$f":"IF(AX53<>0,AX$17,\"\")","v":""},"ОТ","","","Б","","","","","","","","","","","",{"$f":"COUNTBLANK(AX52:BM52)","v":14},null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF(AX53>0,CONCATENATE(AX52,CHAR(10)),\"\"),IF(AY53>0,CONCATENATE(AY52,CHAR(10)),\"\"),IF(AZ53>0,CONCATENATE(AZ52,CHAR(10),),\"\"),IF(BA53>0,CONCATENATE(BA52,CHAR(10)),\"\"),IF(BB53>0,CONCATENATE(BB52,CHAR(10)),\"\"),IF(BC53>0,CONCATENATE(BC52,CHAR(10)),\"\"),IF(BD53>0,CONCATENATE(BD52,CHAR(10)),\"\"),IF(BE53>0,CONCATENATE(BE52,CHAR(10)),\"\"))","v":"ОТ\nБ\n"},{"$f":"CONCATENATE(IF(BF53>0,CONCATENATE(BF52,CHAR(10)),\"\"),IF(BG53>0,CONCATENATE(BG52,CHAR(10)),\"\"),IF(BH53>0,CONCATENATE(BH52,CHAR(10),),\"\"),IF(BI53>0,CONCATENATE(BI52,CHAR(10)),\"\"),IF(BJ53>0,CONCATENATE(BJ52,CHAR(10)),\"\"),IF(BK53>0,CONCATENATE(BK52,CHAR(10)),\"\"),IF(BL53>0,CONCATENATE(BL52,CHAR(10)),\"\"),IF(BM53>0,CONCATENATE(BM52,CHAR(10)),\"\"))","v":""},{"$f":"CONCATENATE(IF(AX53>0,CONCATENATE(AX53,\"(\",(8*AX53),\")\",CHAR(10)),\"\"),IF(AY53>0,CONCATENATE(AY53,\"(\",(8*AY53),\")\",CHAR(10)),\"\"),IF(AZ53>0,CONCATENATE(AZ53,\"(\",(8*AZ53),\")\",CHAR(10)),\"\"),IF(BA53>0,CONCATENATE(BA53,\"(\",(8*BA53),\")\",CHAR(10)),\"\"),IF(BB53>0,CONCATENATE(BB53,\"(\",(8*BB53),\")\",CHAR(10)),\"\"),IF(BC53>0,CONCATENATE(BC53,\"(\",(8*BC53),\")\",CHAR(10)),\"\"),IF(BD53>0,CONCATENATE(BD53,\"(\",(8*BD53),\")\",CHAR(10)),\"\"),IF(BE53>0,CONCATENATE(BE53,\"(\",(8*BE53),\")\",CHAR(10)),\"\"))","v":"4(32)\n7(56)\n"},{"$f":"CONCATENATE(IF(BF53>0,CONCATENATE(BF53,\"(\",(8*BF53),\")\",CHAR(10)),\"\"),IF(BG53>0,CONCATENATE(BG53,\"(\",(8*BG53),\")\",CHAR(10)),\"\"),IF(BH53>0,CONCATENATE(BH53,\"(\",(8*BH53),\")\",CHAR(10)),\"\"),IF(BI53>0,CONCATENATE(BI53,\"(\",(8*BI53),\")\",CHAR(10)),\"\"),IF(BJ53>0,CONCATENATE(BJ53,\"(\",(8*BJ53),\")\",CHAR(10)),\"\"),IF(BK53>0,CONCATENATE(BK53,\"(\",(8*BK53),\")\",CHAR(10)),\"\"),IF(BL53>0,CONCATENATE(BL53,\"(\",(8*BL53),\")\",CHAR(10)),\"\"),IF(BM53>0,CONCATENATE(BM53,\"(\",(8*BM53),\")\",CHAR(10)),\"\"))","v":""}]
[null,null,"Слесарь КИП и А 6 разряд",null,{"$f":"IF(E54+IF(E52=\"Я\",8, IF(E52=\"РВ\",8,0))-E$1<>0,E54+IF(E52=\"Я\",8, IF(E52=\"РВ\",8,0))-E$1,\"\")","v":""},"","","",8,"","",8,8,8,8,8,"","",8,{"$f":"SUM(E53:S53)","v":56},{"$f":"IF(U54+IF(U52=\"Я\",8, IF(U52=\"РВ\",8,0))-U$1<>0,U54+IF(U52=\"Я\",8, IF(U52=\"РВ\",8,0))-U$1,\"\")","v":""},"","","","","","",8,8,8,8,"","",8,8,8,{"$f":"SUM(U53:AJ53)","v":56},null,null,null,null,{"$f":"IF(SUMIF(E52:AJ53,\"РВ\",E53:AJ53)<=0,\"\",SUMIF(E52:AJ53,\"РВ\",E53:AJ53))","v":""},null,null,null,null,null,1,null,{"$f":"COUNTIF($E52:$S52,AX$17)+COUNTIF($U52:$AJ52,AX$17)","v":0},4,0,0,7,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"сверхурочная работа",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E54:S54)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U54:AJ54)","v":0},null,null,{"$f":"T54+AK54","v":0},null,null,null,null,null,null,null,{"$f":"IF(T54+AK54>0,1,0)","v":0}]
[null,13,null,null,"ОЖ","ОЖ","ОЖ","ОЖ","ОЖ","ОЖ","ОЖ","ОЖ","ОЖ","ОЖ","ОЖ","ОЖ","ОЖ","ОЖ","ОЖ",{"$f":"COUNTIF(E55:S55,\"Я\")+COUNTIF(E55:S55,\"РВ\")","v":0},"ОЖ","ОЖ","ОЖ","ОЖ","ОЖ","ОЖ","ОЖ","ОЖ","ОЖ","ОЖ","ОЖ","ОЖ","ОЖ","ОЖ","ОЖ","ОЖ",{"$f":"COUNTIF(U55:AJ55,\"Я\")+COUNTIF(U55:AJ55,\"РВ\")","v":0},{"$f":"T55+AK55","v":0},{"$f":"T56+AK56","v":0},null,null,{"$f":"COUNTIF($E55:$S55,\"РВ\")+COUNTIF($U55:$AJ55,\"РВ\")","v":0},null,{"$f":"IF(SUM($AX56:$BM56)>0,CONCATENATE(SUM($AX56:$BM56),\"(\",8*SUM($AX56:$BM56),\")\"),\"\")","v":"31(248)"},{"$f":"CONCATENATE(BV55,BW55)","v":"ОЖ\n"},{"$f":"CONCATENATE(BX55,BY55)","v":"31(248)\n"},{"$f":"COUNTIF(U55:AJ55,\"В\")+COUNTIF(E55:S55,\"В\")+COUNTIF(U55:AJ55,\"РВ\")+COUNTIF(E55:S55,\"РВ\")","v":0},1,null,{"$f":"IF(AX56<>0,AX$17,\"\")","v":""},"","","","","","","","","","ОЖ","","","","","",{"$f":"COUNTBLANK(AX55:BM55)","v":15},null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF(AX56>0,CONCATENATE(AX55,CHAR(10)),\"\"),IF(AY56>0,CONCATENATE(AY55,CHAR(10)),\"\"),IF(AZ56>0,CONCATENATE(AZ55,CHAR(10),),\"\"),IF(BA56>0,CONCATENATE(BA55,CHAR(10)),\"\"),IF(BB56>0,CONCATENATE(BB55,CHAR(10)),\"\"),IF(BC56>0,CONCATENATE(BC55,CHAR(10)),\"\"),IF(BD56>0,CONCATENATE(BD55,CHAR(10)),\"\"),IF(BE56>0,CONCATENATE(BE55,CHAR(10)),\"\"))","v":""},{"$f":"CONCATENATE(IF(BF56>0,CONCATENATE(BF55,CHAR(10)),\"\"),IF(BG56>0,CONCATENATE(BG55,CHAR(10)),\"\"),IF(BH56>0,CONCATENATE(BH55,CHAR(10),),\"\"),IF(BI56>0,CONCATENATE(BI55,CHAR(10)),\"\"),IF(BJ56>0,CONCATENATE(BJ55,CHAR(10)),\"\"),IF(BK56>0,CONCATENATE(BK55,CHAR(10)),\"\"),IF(BL56>0,CONCATENATE(BL55,CHAR(10)),\"\"),IF(BM56>0,CONCATENATE(BM55,CHAR(10)),\"\"))","v":"ОЖ\n"},{"$f":"CONCATENATE(IF(AX56>0,CONCATENATE(AX56,\"(\",(8*AX56),\")\",CHAR(10)),\"\"),IF(AY56>0,CONCATENATE(AY56,\"(\",(8*AY56),\")\",CHAR(10)),\"\"),IF(AZ56>0,CONCATENATE(AZ56,\"(\",(8*AZ56),\")\",CHAR(10)),\"\"),IF(BA56>0,CONCATENATE(BA56,\"(\",(8*BA56),\")\",CHAR(10)),\"\"),IF(BB56>0,CONCATENATE(BB56,\"(\",(8*BB56),\")\",CHAR(10)),\"\"),IF(BC56>0,CONCATENATE(BC56,\"(\",(8*BC56),\")\",CHAR(10)),\"\"),IF(BD56>0,CONCATENATE(BD56,\"(\",(8*BD56),\")\",CHAR(10)),\"\"),IF(BE56>0,CONCATENATE(BE56,\"(\",(8*BE56),\")\",CHAR(10)),\"\"))","v":""},{"$f":"CONCATENATE(IF(BF56>0,CONCATENATE(BF56,\"(\",(8*BF56),\")\",CHAR(10)),\"\"),IF(BG56>0,CONCATENATE(BG56,\"(\",(8*BG56),\")\",CHAR(10)),\"\"),IF(BH56>0,CONCATENATE(BH56,\"(\",(8*BH56),\")\",CHAR(10)),\"\"),IF(BI56>0,CONCATENATE(BI56,\"(\",(8*BI56),\")\",CHAR(10)),\"\"),IF(BJ56>0,CONCATENATE(BJ56,\"(\",(8*BJ56),\")\",CHAR(10)),\"\"),IF(BK56>0,CONCATENATE(BK56,\"(\",(8*BK56),\")\",CHAR(10)),\"\"),IF(BL56>0,CONCATENATE(BL56,\"(\",(8*BL56),\")\",CHAR(10)),\"\"),IF(BM56>0,CONCATENATE(BM56,\"(\",(8*BM56),\")\",CHAR(10)),\"\"))","v":"31(248)\n"}]
[null,null,"Слесарь КИП и А 6 разряд",null,{"$f":"IF(E57+IF(E55=\"Я\",8, IF(E55=\"РВ\",8,0))-E$1<>0,E57+IF(E55=\"Я\",8, IF(E55=\"РВ\",8,0))-E$1,\"\")","v":""},"",""," ","","","","","","","","","","","",{"$f":"SUM(E56:S56)","v":0},{"$f":"IF(U57+IF(U55=\"Я\",8, IF(U55=\"РВ\",8,0))-U$1<>0,U57+IF(U55=\"Я\",8, IF(U55=\"РВ\",8,0))-U$1,\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"SUM(U56:AJ56)","v":0},null,null,null,null,{"$f":"IF(SUMIF(E55:AJ56,\"РВ\",E56:AJ56)<=0,\"\",SUMIF(E55:AJ56,\"РВ\",E56:AJ56))","v":""},null,null,null,null,null,1,null,{"$f":"COUNTIF($E55:$S55,AX$17)+COUNTIF($U55:$AJ55,AX$17)","v":0},0,0,0,0,0,0,0,0,0,31,0,0,0,0,0]
[null,null,"сверхурочная работа",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E57:S57)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U57:AJ57)","v":0},null,null,{"$f":"T57+AK57","v":0},null,null,null,null,null,null,null,{"$f":"IF(T57+AK57>0,1,0)","v":0}]
[null,14,null,null,"Я","Я","Я","Я","Я","В","В","Я","Я","Я","Я","Я","В","В","Я",{"$f":"COUNTIF(E58:S58,\"Я\")+COUNTIF(E58:S58,\"РВ\")","v":11},"Я","Я","Я","Я","В","В","Я","Я","Я","Я","Я","В","В","НН","НН","НН",{"$f":"COUNTIF(U58:AJ58,\"Я\")+COUNTIF(U58:AJ58,\"РВ\")","v":9},{"$f":"T58+AK58","v":20},{"$f":"T59+AK59","v":160},null,null,{"$f":"COUNTIF($E58:$S58,\"РВ\")+COUNTIF($U58:$AJ58,\"РВ\")","v":0},null,{"$f":"IF(SUM($AX59:$BM59)>0,CONCATENATE(SUM($AX59:$BM59),\"(\",8*SUM($AX59:$BM59),\")\"),\"\")","v":"3(24)"},{"$f":"CONCATENATE(BV58,BW58)","v":"НН\n"},{"$f":"CONCATENATE(BX58,BY58)","v":"3(24)\n"},{"$f":"COUNTIF(U58:AJ58,\"В\")+COUNTIF(E58:S58,\"В\")+COUNTIF(U58:AJ58,\"РВ\")+COUNTIF(E58:S58,\"РВ\")","v":8},1,null,{"$f":"IF(AX59<>0,AX$17,\"\")","v":""},"","","","","","НН","","","","","","","","","",{"$f":"COUNTBLANK(AX58:BM58)","v":15},null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF(AX59>0,CONCATENATE(AX58,CHAR(10)),\"\"),IF(AY59>0,CONCATENATE(AY58,CHAR(10)),\"\"),IF(AZ59>0,CONCATENATE(AZ58,CHAR(10),),\"\"),IF(BA59>0,CONCATENATE(BA58,CHAR(10)),\"\"),IF(BB59>0,CONCATENATE(BB58,CHAR(10)),\"\"),IF(BC59>0,CONCATENATE(BC58,CHAR(10)),\"\"),IF(BD59>0,CONCATENATE(BD58,CHAR(10)),\"\"),IF(BE59>0,CONCATENATE(BE58,CHAR(10)),\"\"))","v":"НН\n"},{"$f":"CONCATENATE(IF(BF59>0,CONCATENATE(BF58,CHAR(10)),\"\"),IF(BG59>0,CONCATENATE(BG58,CHAR(10)),\"\"),IF(BH59>0,CONCATENATE(BH58,CHAR(10),),\"\"),IF(BI59>0,CONCATENATE(BI58,CHAR(10)),\"\"),IF(BJ59>0,CONCATENATE(BJ58,CHAR(10)),\"\"),IF(BK59>0,CONCATENATE(BK58,CHAR(10)),\"\"),IF(BL59>0,CONCATENATE(BL58,CHAR(10)),\"\"),IF(BM59>0,CONCATENATE(BM58,CHAR(10)),\"\"))","v":""},{"$f":"CONCATENATE(IF(AX59>0,CONCATENATE(AX59,\"(\",(8*AX59),\")\",CHAR(10)),\"\"),IF(AY59>0,CONCATENATE(AY59,\"(\",(8*AY59),\")\",CHAR(10)),\"\"),IF(AZ59>0,CONCATENATE(AZ59,\"(\",(8*AZ59),\")\",CHAR(10)),\"\"),IF(BA59>0,CONCATENATE(BA59,\"(\",(8*BA59),\")\",CHAR(10)),\"\"),IF(BB59>0,CONCATENATE(BB59,\"(\",(8*BB59),\")\",CHAR(10)),\"\"),IF(BC59>0,CONCATENATE(BC59,\"(\",(8*BC59),\")\",CHAR(10)),\"\"),IF(BD59>0,CONCATENATE(BD59,\"(\",(8*BD59),\")\",CHAR(10)),\"\"),IF(BE59>0,CONCATENATE(BE59,\"(\",(8*BE59),\")\",CHAR(10)),\"\"))","v":"3(24)\n"},{"$f":"CONCATENATE(IF(BF59>0,CONCATENATE(BF59,\"(\",(8*BF59),\")\",CHAR(10)),\"\"),IF(BG59>0,CONCATENATE(BG59,\"(\",(8*BG59),\")\",CHAR(10)),\"\"),IF(BH59>0,CONCATENATE(BH59,\"(\",(8*BH59),\")\",CHAR(10)),\"\"),IF(BI59>0,CONCATENATE(BI59,\"(\",(8*BI59),\")\",CHAR(10)),\"\"),IF(BJ59>0,CONCATENATE(BJ59,\"(\",(8*BJ59),\")\",CHAR(10)),\"\"),IF(BK59>0,CONCATENATE(BK59,\"(\",(8*BK59),\")\",CHAR(10)),\"\"),IF(BL59>0,CONCATENATE(BL59,\"(\",(8*BL59),\")\",CHAR(10)),\"\"),IF(BM59>0,CONCATENATE(BM59,\"(\",(8*BM59),\")\",CHAR(10)),\"\"))","v":""}]
[null,null,"Слесарь КИП и А 6 разряд",null,{"$f":"IF(E60+IF(E58=\"Я\",8, IF(E58=\"РВ\",8,0))-E$1<>0,E60+IF(E58=\"Я\",8, IF(E58=\"РВ\",8,0))-E$1,\"\")","v":8},{"$f":"IF(F60+IF(F58=\"Я\",8, IF(F58=\"РВ\",8,0))-F$1<>0,F60+IF(F58=\"Я\",8, IF(F58=\"РВ\",8,0))-F$1,\"\")","v":8},{"$f":"IF(G60+IF(G58=\"Я\",8, IF(G58=\"РВ\",8,0))-G$1<>0,G60+IF(G58=\"Я\",8, IF(G58=\"РВ\",8,0))-G$1,\"\")","v":8},8,{"$f":"IF(I60+IF(I58=\"Я\",8, IF(I58=\"РВ\",8,0))-I$1<>0,I60+IF(I58=\"Я\",8, IF(I58=\"РВ\",8,0))-I$1,\"\")","v":8},"","",8,8,8,8,8,"","",8,{"$f":"SUM(E59:S59)","v":88},{"$f":"IF(U60+IF(U58=\"Я\",8, IF(U58=\"РВ\",8,0))-U$1<>0,U60+IF(U58=\"Я\",8, IF(U58=\"РВ\",8,0))-U$1,\"\")","v":8},8,8,8,"","",8,8,8,8,8,"","","","","",{"$f":"SUM(U59:AJ59)","v":72},null,null,null,null,{"$f":"IF(SUMIF(E58:AJ59,\"РВ\",E59:AJ59)<=0,\"\",SUMIF(E58:AJ59,\"РВ\",E59:AJ59))","v":""},null,null,null,null,null,1,null,{"$f":"COUNTIF($E58:$S58,AX$17)+COUNTIF($U58:$AJ58,AX$17)","v":0},0,0,0,0,0,3,0,0,0,0,0,0,0,0,0]
[null,null,"сверхурочная работа",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E60:S60)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U60:AJ60)","v":0},null,null,{"$f":"T60+AK60","v":0},null,null,null,null,null,null,null,{"$f":"IF(T60+AK60>0,1,0)","v":0}]
[null,"\n\nОтветственное лицо ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE12","v":"2016-08-30T12:35:22.730"},null,null,null,1]
[null,null,null,"должность",null,null,null,null,"личная подпись",null,null,null,null,null,"расшифровка подписи",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"должность",null,null,null,null,null,"личная подпись",null,null,"расшифровка подписи",null,null,null,"дата",null,null,null,1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BG63<>0,BG$17,\"\")","v":""},null,null,null,null,{"$f":"IF(BL63<>0,BL$17,\"\")","v":""},{"$f":"IF(BM63<>0,BM$17,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]