{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Список","Табель БЭМУ","Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":77,"n_cols":25,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,23,0,24],[0,15,0,16],[0,17,0,18],[0,19,0,20],[0,21,0,22],[0,11,0,12],[0,13,0,14],[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,0,10]]}
["№","УПРАВЛЕНИЕ",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,"Бабковский Константин Сергеевич","Электромонтажник 3 разряда"]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Батенев Владимир Николаевич","Электромонтажник 3 разряда"]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Блиц Евгений Иванович","Электромонтажник 3 разряда"]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Бубнов Павел Петрович","Электромонтажник 3 разряда"]
[5,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,"Витовтов Рустам Владимирович","Электромонтажник 3 разряда"]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Возжов Алексей Сергеевич","Электромонтажник 3 разряда"]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Вяткин Владимир Сергеевич","Электромонтажник 3 разряда"]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Гвоздева Людмила Григорьевна","Электромонтажник 5 разряда"]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Гридасов Роман Андреевич","Электромонтажник 3 разряда"]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Дударев Александр Васильевич","Электромонтажник 3 разряда"]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Елисов  Виталий Юрьевич","Мастер участка"]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Зайцев Олег Валентинович","Специалист по подготовке производства"]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Зюзин Алексей Артурович","Электромонтажник 4 разряда"]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Иванов Владимир Аркадьевич","Электромонтажник 3 разряда"]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Кагитина Любовь Ивановна","Уборщик служебных помещений"]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Капаев Сергей Александрович","Электромонтажник 5 разряда"]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Капаева Татьяна Анатольевна","Электромонтажник 3 разряда"]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Керносов Антон Сергеевич","Электромонтажник 3 разряда"]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Клочков Николай Геннадьевич","Электромонтажник 3 разряда"]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ковылин Александр Алексеевич","Электромонтажник 3 разряда"]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Кононенко Александр Викторович","Мастер участка"]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Красильников Роман Викторович","Электромонтажник 4 разряда"]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Кузнецов Александр Николаевич","Начальник участка "]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Кузнецова Наталья Викторовна","Офис-менеджер"]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Кузовлев Николай Николаевич","Электромонтажник 4 разряда"]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Кузьмин Виталий Анатольевич","Электромонтажник 5 разряда"]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Курганский Алексей Семенович","Электромонтажник 4 разряда"]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Кутищев Алексей Павлович","Электромонтажник 3 разряда"]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Мартынюк Владимир Николаевич","Электромонтажник 5 разряда"]
[31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Матюхин Анатолий Афанасьевич","Электромонтажник 5 разряда"]
[32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Матюхина Галина Александровна","Электромонтажник 5 разряда"]
[33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Метелкин Сергей Львович","Электромонтажник 5 разряда"]
[34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Мильян Леонид Иванович","Электромонтажник 5 разряда"]
[35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Милюков Юрий Виссарионович","Мастер участка"]
[36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Петренко Юрий Константинович","Монтажник по монтажу стальных и железобетонных конструкций 3 разряда"]
[37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Потехин Дмитрий Иванович","Производитель работ (прораб) "]
[38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Розенбах Денис Сергеевич","Электромонтажник 3 разряда"]
[39,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Рытов Игорь Викторович","Монтажник по монтажу стальных и железобетонных конструкций 4 разряда"]
[40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Сергеенко Максим Владимирович","Электромонтажник 5 разряда"]
[41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Симулин Сергей Владимирович","Электромонтажник 5 разряда"]
[42,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Сурков Владимир Владимирович","Монтажник по монтажу стальных и железобетонных конструкций 3 разряда"]
[43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Сусляков Сергей Александрович","Электромонтажник 3 разряда"]
[44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Суханов Дмитрий Викторович","Электромонтажник 5 разряда"]
[45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Тамбов Роман Евгеньевич","Монтажник по монтажу стальных и железобетонных конструкций 3 разряда"]
[46,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Терентьев Василий Владимирович","Электромонтажник 5 разряда"]
[47,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Уголев Дмитрий Викторович","Электромонтажник 3 разряда"]
[48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Шестаков Андрей Иванович","Электромонтажник 4 разряда"]
[49,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Шмыков Виктор Васильевич","Электромонтажник 5 разряда"]
[50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Эндерс Валерий Давыдович","Электромонтажник 4 разряда"]
[51,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Янкин Ярослав Александрович","Электромонтажник 3 разряда"]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[null,{"$f":"COUNTA(B2:B71)","v":0},null,{"$f":"COUNTA(D2:D71)","v":0},null,{"$f":"COUNTA(F2:F71)","v":0},null,{"$f":"COUNTA(H2:H71)","v":0},null,{"$f":"COUNTA(J2:J71)","v":0},null,{"$f":"COUNTA(L2:L71)","v":0},null,{"$f":"COUNTA(N2:N71)","v":0},null,{"$f":"COUNTA(P2:P71)","v":0},null,{"$f":"COUNTA(R2:R71)","v":0},null,{"$f":"COUNTA(T2:T71)","v":0},null,{"$f":"COUNTA(V2:V71)","v":0},null,{"$f":"COUNTA(X2:X71)","v":51}]
[]
[]
[null,"Год",2012]
[]
[null,"Объекты","Сокращенное наименование"]

{"sheet":"Табель БЭМУ","index":1,"n_rows":145,"n_cols":48,"rows_kept":145,"cut":false,"hidden":false,"merged":[[140,5,140,9],[139,5,139,9],[141,5,141,9],[142,5,142,9],[143,5,143,9],[134,5,134,9],[135,5,135,9],[60,0,61,0],[62,0,63,0],[64,0,65,0],[114,0,115,0],[116,0,117,0],[118,0,119,0],[136,5,136,9],[133,5,133,9],[137,5,137,9],[102,0,103,0],[104,0,105,0],[106,0,107,0],[108,0,109,0],[110,0,111,0],[112,0,113,0],[66,0,67,0],[68,0,69,0],[70,0,71,0],[72,0,73,0],[74,0,75,0],[76,0,77,0],[78,0,79,0],[80,0,81,0],[82,0,83,0],[42,0,43,0],[44,0,45,0],[10,1,11,1],[10,2,11,2],[6,7,8,7],[6,8,8,8],[6,9,8,9],[6,0,8,0],[6,1,8,1],[6,2,8,2],[6,5,8,5],[6,6,8,6],[6,4,8,4],[38,0,39,0],[40,0,41,0],[20,0,21,0],[22,0,23,0],[24,0,25,0],[26,0,27,0],[28,0,29,0],[18,0,19,0],[10,0,11,0],[30,0,31,0],[32,0,33,0],[34,0,35,0],[12,0,13,0],[14,0,15,0],[16,0,17,0],[36,0,37,0],[6,24,8,24],[6,16,8,16],[6,17,8,17],[6,18,8,18],[6,10,8,10],[6,11,8,11],[6,12,8,12],[6,19,8,19],[6,20,8,20],[6,21,8,21],[6,22,8,22],[6,23,8,23],[6,15,8,15],[6,13,8,13],[6,14,8,14],[6,42,6,47],[6,39,8,39],[6,34,8,34],[6,35,8,35],[6,36,8,36],[6,25,8,25],[6,26,8,26],[6,27,8,27],[6,28,8,28],[6,29,8,29],[6,30,8,30],[6,37,8,37],[6,31,8,31],[6,32,8,32],[6,33,8,33],[6,38,8,38],[46,1,47,1],[48,1,49,1],[50,1,51,1],[48,0,49,0],[50,0,51,0],[52,0,53,0],[54,0,55,0],[56,0,57,0],[58,0,59,0],[46,0,47,0],[52,1,53,1],[54,1,55,1],[56,1,57,1],[58,1,59,1],[88,0,89,0],[90,0,91,0],[92,0,93,0],[94,0,95,0],[96,0,97,0],[98,0,99,0],[100,0,101,0],[84,0,85,0],[86,0,87,0],[120,0,121,0],[122,0,123,0],[124,0,125,0],[126,0,127,0],[12,1,13,1],[14,1,15,1],[16,1,17,1],[18,1,19,1],[20,1,21,1],[22,1,23,1],[24,1,25,1],[26,1,27,1],[28,1,29,1],[30,1,31,1],[32,1,33,1],[34,1,35,1],[36,1,37,1],[38,1,39,1],[40,1,41,1],[42,1,43,1],[44,1,45,1],[118,1,119,1],[120,1,121,1],[122,1,123,1],[60,1,61,1],[62,1,63,1],[68,2,69,2],[70,2,71,2],[72,2,73,2],[64,1,65,1],[66,1,67,1],[68,1,69,1],[110,1,111,1],[92,2,93,2],[94,2,95,2],[96,2,97,2],[112,1,113,1],[114,1,115,1],[116,1,117,1],[70,1,71,1],[72,1,73,1],[74,1,75,1],[76,1,77,1],[78,1,79,1],[80,1,81,1],[82,1,83,1],[84,1,85,1],[86,1,87,1],[98,1,99,1],[100,1,101,1],[102,1,103,1],[104,1,105,1],[106,1,107,1],[108,1,109,1],[88,1,89,1],[90,1,91,1],[92,1,93,1],[94,1,95,1],[96,1,97,1],[124,1,125,1],[126,1,127,1],[12,2,13,2],[14,2,15,2],[16,2,17,2],[18,2,19,2],[20,2,21,2],[22,2,23,2],[24,2,25,2],[26,2,27,2],[28,2,29,2],[30,2,31,2],[32,2,33,2],[34,2,35,2],[36,2,37,2],[38,2,39,2],[40,2,41,2],[42,2,43,2],[44,2,45,2],[46,2,47,2],[48,2,49,2],[126,2,127,2],[98,2,99,2],[100,2,101,2],[56,2,57,2],[58,2,59,2],[60,2,61,2],[62,2,63,2],[64,2,65,2],[66,2,67,2],[50,2,51,2],[52,2,53,2],[54,2,55,2],[120,2,121,2],[122,2,123,2],[124,2,125,2],[74,2,75,2],[76,2,77,2],[78,2,79,2],[80,2,81,2],[82,2,83,2],[84,2,85,2],[86,2,87,2],[88,2,89,2],[90,2,91,2],[110,2,111,2],[112,2,113,2],[114,2,115,2],[116,2,117,2],[118,2,119,2],[102,2,103,2],[104,2,105,2],[106,2,107,2],[108,2,109,2],[138,1,138,2],[138,5,138,9]]}
[]
[]
[]
[]
[null,null,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,"Январь",{"$f":"DATE(Год,1,F5)","v":"2012-01-01"},"2012-01-02","2012-01-03","2012-01-04","2012-01-05","2012-01-06","2012-01-07","2012-01-08","2012-01-09","2012-01-10","2012-01-11","2012-01-12","2012-01-13","2012-01-14","2012-01-15","2012-01-16","2012-01-17","2012-01-18","2012-01-19","2012-01-20","2012-01-21","2012-01-22","2012-01-23","2012-01-24","2012-01-25","2012-01-26","2012-01-27","2012-01-28","2012-01-29","2012-01-30","2012-01-31",{"$f":"\"К-во раб.дней (Норма -\"&NETWORKDAYS(F7,EOMONTH(F7,0),Праздники)&\")\"","v":"К-во раб.дней (Норма -16)"},{"$f":"\"К-во часов (Норма -\"&PRODUCT(NETWORKDAYS(F7,EOMONTH(F7,0),Праздники),8)&\")\"","v":"К-во часов (Норма -128)"},"Заработная плата без НДФЛ","Заработная плата с НДФЛ",null,null,"Д н и   н е я в о к"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$f":"INDEX(Список!$B$2:$AZ$71,$A11,MATCH($B$10,отд,0))","v":"Бабковский Константин Сергеевич"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A11,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 3 разряда"},"Факт",null,"в",8,8,8,8,8,"в","в",8,8,null,null,null,"в","в",null,"к(8)","к(8)","к(8)","к(8)","в","в",8,8,8,8,8,"в","в",null,null,{"$f":"COUNTIF(F11:AJ11,\">=4\")+COUNTIF(F11:AJ11,\"к*\")","v":16},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F11:AJ11))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F11:AJ11)))","v":128},11111,{"$f":"AM11*0.87","v":9666.57},null,null,{"$f":"COUNTIF(F11:AJ11,\"в\")","v":9},{"$f":"COUNTIF(F11:AJ11,\"о\")","v":0},{"$f":"COUNTIF(F11:AJ11,\"п\")","v":0},{"$f":"COUNTIF(F11:AJ11,\"к*\")","v":4},{"$f":"COUNTIF(F11:AJ11,\"а\")","v":0},{"$f":"COUNTIF(F11:AJ11,\"б\")","v":0}]
[null,null,null,"Объект",null,"бв","бв","бв","бв","бв","бв","бв","бв","бв",null,null,null,null,null,null,null,"а","а","а","а",null,null,"бт","бт","бт","бт","бт","бт","бт",null,null,null,null,null,null,null,null,{"$f":"COUNTIF(F12:AJ12,\"бв\")","v":9},{"$f":"COUNTIF(F12:AJ12,\"бв\")","v":9},{"$f":"COUNTIF(F12:AJ12,\"а\")","v":4},{"$f":"COUNTIF(F12:AJ12,\"и\")","v":0}]
[2,{"$f":"INDEX(Список!$B$2:$AZ$71,$A13,MATCH($B$10,отд,0))","v":"Батенев Владимир Николаевич"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A13,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 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,{"$f":"COUNTIF(F13:AJ13,\">=4\")+COUNTIF(F13:AJ13,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F13:AJ13))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F13:AJ13)))","v":0},null,{"$f":"AM13*0.87","v":0},null,null,{"$f":"COUNTIF(F13:AJ13,\"в\")","v":0},{"$f":"COUNTIF(F13:AJ13,\"о\")","v":0},{"$f":"COUNTIF(F13:AJ13,\"п\")","v":0},{"$f":"COUNTIF(F13:AJ13,\"к*\")","v":0},{"$f":"COUNTIF(F13:AJ13,\"а\")","v":0},{"$f":"COUNTIF(F13:AJ13,\"б\")","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,{"$f":"COUNTIF(F14:AJ14,\"бв\")","v":0},{"$f":"COUNTIF(F14:AJ14,\"бв\")","v":0},{"$f":"COUNTIF(F14:AJ14,\"а\")","v":0},{"$f":"COUNTIF(F14:AJ14,\"и\")","v":0}]
[3,{"$f":"INDEX(Список!$B$2:$AZ$71,$A15,MATCH($B$10,отд,0))","v":"Блиц Евгений Иванович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A15,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 3 разряда"},"Факт",null,null,7,7,7,7,7,7,7,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(F15:AJ15,\">=4\")+COUNTIF(F15:AJ15,\"к*\")","v":8},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F15:AJ15))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F15:AJ15)))","v":56},11113,{"$f":"AM15*0.87","v":9668.31},null,null,{"$f":"COUNTIF(F15:AJ15,\"в\")","v":0},{"$f":"COUNTIF(F15:AJ15,\"о\")","v":0},{"$f":"COUNTIF(F15:AJ15,\"п\")","v":0},{"$f":"COUNTIF(F15:AJ15,\"к*\")","v":0},{"$f":"COUNTIF(F15:AJ15,\"а\")","v":0},{"$f":"COUNTIF(F15:AJ15,\"б\")","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,{"$f":"COUNTIF(F16:AJ16,\"бв\")","v":8},{"$f":"COUNTIF(F16:AJ16,\"бв\")","v":8},{"$f":"COUNTIF(F16:AJ16,\"а\")","v":0},{"$f":"COUNTIF(F16:AJ16,\"и\")","v":0}]
[4,{"$f":"INDEX(Список!$B$2:$AZ$71,$A17,MATCH($B$10,отд,0))","v":"Бубнов Павел Петрович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A17,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 3 разряда"},"Факт",null,null,"к(8)","к(8)","к(8)","к(8)","к(8)","к(8)","к(8)","к(8)",null,null,null,null,null,null,null,null,null,null,null,"к(7)","к(7)","к(7)","к(7)","к(7)","к(7)","к(7)",null,null,null,null,{"$f":"COUNTIF(F17:AJ17,\">=4\")+COUNTIF(F17:AJ17,\"к*\")","v":15},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F17:AJ17))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F17:AJ17)))","v":113},11114,{"$f":"AM17*0.87","v":9669.18},null,null,{"$f":"COUNTIF(F17:AJ17,\"в\")","v":0},{"$f":"COUNTIF(F17:AJ17,\"о\")","v":0},{"$f":"COUNTIF(F17:AJ17,\"п\")","v":0},{"$f":"COUNTIF(F17:AJ17,\"к*\")","v":15},{"$f":"COUNTIF(F17:AJ17,\"а\")","v":0},{"$f":"COUNTIF(F17:AJ17,\"б\")","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,{"$f":"COUNTIF(F18:AJ18,\"бв\")","v":0},{"$f":"COUNTIF(F18:AJ18,\"бв\")","v":0},{"$f":"COUNTIF(F18:AJ18,\"а\")","v":8},{"$f":"COUNTIF(F18:AJ18,\"и\")","v":0}]
[5,{"$f":"INDEX(Список!$B$2:$AZ$71,$A19,MATCH($B$10,отд,0))","v":"Верле Яков Эмануилович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A19,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 5 разряда"},"Факт",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(F19:AJ19,\">=4\")+COUNTIF(F19:AJ19,\"к*\")","v":8},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F19:AJ19))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F19:AJ19)))","v":0},11115,{"$f":"AM19*0.87","v":9670.0499999999993},null,null,{"$f":"COUNTIF(F19:AJ19,\"в\")","v":0},{"$f":"COUNTIF(F19:AJ19,\"о\")","v":0},{"$f":"COUNTIF(F19:AJ19,\"п\")","v":0},{"$f":"COUNTIF(F19:AJ19,\"к*\")","v":8},{"$f":"COUNTIF(F19:AJ19,\"а\")","v":0},{"$f":"COUNTIF(F19:AJ19,\"б\")","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,{"$f":"COUNTIF(F20:AJ20,\"бв\")","v":0},{"$f":"COUNTIF(F20:AJ20,\"бв\")","v":0},{"$f":"COUNTIF(F20:AJ20,\"а\")","v":0},{"$f":"COUNTIF(F20:AJ20,\"и\")","v":8}]
[6,{"$f":"INDEX(Список!$B$2:$AZ$71,$A21,MATCH($B$10,отд,0))","v":"Витовтов Рустам Владимирович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A21,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 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,{"$f":"COUNTIF(F21:AJ21,\">=4\")+COUNTIF(F21:AJ21,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F21:AJ21))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F21:AJ21)))","v":0},null,{"$f":"AM21*0.87","v":0},null,null,{"$f":"COUNTIF(F21:AJ21,\"в\")","v":0},{"$f":"COUNTIF(F21:AJ21,\"о\")","v":0},{"$f":"COUNTIF(F21:AJ21,\"п\")","v":0},{"$f":"COUNTIF(F21:AJ21,\"к*\")","v":0},{"$f":"COUNTIF(F21:AJ21,\"а\")","v":0},{"$f":"COUNTIF(F21:AJ21,\"б\")","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,{"$f":"COUNTIF(F22:AJ22,\"бв\")","v":0},{"$f":"COUNTIF(F22:AJ22,\"бв\")","v":0},{"$f":"COUNTIF(F22:AJ22,\"а\")","v":0},{"$f":"COUNTIF(F22:AJ22,\"и\")","v":0}]
[7,{"$f":"INDEX(Список!$B$2:$AZ$71,$A23,MATCH($B$10,отд,0))","v":"Возжов Алексей Сергеевич"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A23,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 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,{"$f":"COUNTIF(F23:AJ23,\">=4\")+COUNTIF(F23:AJ23,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F23:AJ23))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F23:AJ23)))","v":0},null,{"$f":"AM23*0.87","v":0},null,null,{"$f":"COUNTIF(F23:AJ23,\"в\")","v":0},{"$f":"COUNTIF(F23:AJ23,\"о\")","v":0},{"$f":"COUNTIF(F23:AJ23,\"п\")","v":0},{"$f":"COUNTIF(F23:AJ23,\"к*\")","v":0},{"$f":"COUNTIF(F23:AJ23,\"а\")","v":0},{"$f":"COUNTIF(F23:AJ23,\"б\")","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,{"$f":"COUNTIF(F24:AJ24,\"бв\")","v":0},{"$f":"COUNTIF(F24:AJ24,\"бв\")","v":0},{"$f":"COUNTIF(F24:AJ24,\"а\")","v":0},{"$f":"COUNTIF(F24:AJ24,\"и\")","v":0}]
[8,{"$f":"INDEX(Список!$B$2:$AZ$71,$A25,MATCH($B$10,отд,0))","v":"Вяткин Владимир Сергеевич"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A25,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 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,{"$f":"COUNTIF(F25:AJ25,\">=4\")+COUNTIF(F25:AJ25,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F25:AJ25))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F25:AJ25)))","v":0},null,{"$f":"AM25*0.87","v":0},null,null,{"$f":"COUNTIF(F25:AJ25,\"в\")","v":0},{"$f":"COUNTIF(F25:AJ25,\"о\")","v":0},{"$f":"COUNTIF(F25:AJ25,\"п\")","v":0},{"$f":"COUNTIF(F25:AJ25,\"к*\")","v":0},{"$f":"COUNTIF(F25:AJ25,\"а\")","v":0},{"$f":"COUNTIF(F25:AJ25,\"б\")","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,{"$f":"COUNTIF(F26:AJ26,\"бв\")","v":0},{"$f":"COUNTIF(F26:AJ26,\"бв\")","v":0},{"$f":"COUNTIF(F26:AJ26,\"а\")","v":0},{"$f":"COUNTIF(F26:AJ26,\"и\")","v":0}]
[9,{"$f":"INDEX(Список!$B$2:$AZ$71,$A27,MATCH($B$10,отд,0))","v":"Гвоздева Людмила Григорьевна"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A27,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 5 разряда"},"Факт",null,null,null,null,null,null,null,null,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(F27:AJ27,\">=4\")+COUNTIF(F27:AJ27,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F27:AJ27))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F27:AJ27)))","v":0},null,{"$f":"AM27*0.87","v":0},null,null,{"$f":"COUNTIF(F27:AJ27,\"в\")","v":0},{"$f":"COUNTIF(F27:AJ27,\"о\")","v":0},{"$f":"COUNTIF(F27:AJ27,\"п\")","v":0},{"$f":"COUNTIF(F27:AJ27,\"к*\")","v":0},{"$f":"COUNTIF(F27:AJ27,\"а\")","v":0},{"$f":"COUNTIF(F27:AJ27,\"б\")","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,{"$f":"COUNTIF(F28:AJ28,\"бв\")","v":0},{"$f":"COUNTIF(F28:AJ28,\"бв\")","v":0},{"$f":"COUNTIF(F28:AJ28,\"а\")","v":0},{"$f":"COUNTIF(F28:AJ28,\"и\")","v":0}]
[10,{"$f":"INDEX(Список!$B$2:$AZ$71,$A29,MATCH($B$10,отд,0))","v":"Гридасов Роман Андреевич"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A29,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 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,{"$f":"COUNTIF(F29:AJ29,\">=4\")+COUNTIF(F29:AJ29,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F29:AJ29))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F29:AJ29)))","v":0},null,{"$f":"AM29*0.87","v":0},null,null,{"$f":"COUNTIF(F29:AJ29,\"в\")","v":0},{"$f":"COUNTIF(F29:AJ29,\"о\")","v":0},{"$f":"COUNTIF(F29:AJ29,\"п\")","v":0},{"$f":"COUNTIF(F29:AJ29,\"к*\")","v":0},{"$f":"COUNTIF(F29:AJ29,\"а\")","v":0},{"$f":"COUNTIF(F29:AJ29,\"б\")","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,{"$f":"COUNTIF(F30:AJ30,\"бв\")","v":0},{"$f":"COUNTIF(F30:AJ30,\"бв\")","v":0},{"$f":"COUNTIF(F30:AJ30,\"а\")","v":0},{"$f":"COUNTIF(F30:AJ30,\"и\")","v":0}]
[11,{"$f":"INDEX(Список!$B$2:$AZ$71,$A31,MATCH($B$10,отд,0))","v":"Дударев Александр Васильевич"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A31,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 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,{"$f":"COUNTIF(F31:AJ31,\">=4\")+COUNTIF(F31:AJ31,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F31:AJ31))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F31:AJ31)))","v":0},null,{"$f":"AM31*0.87","v":0},null,null,{"$f":"COUNTIF(F31:AJ31,\"в\")","v":0},{"$f":"COUNTIF(F31:AJ31,\"о\")","v":0},{"$f":"COUNTIF(F31:AJ31,\"п\")","v":0},{"$f":"COUNTIF(F31:AJ31,\"к*\")","v":0},{"$f":"COUNTIF(F31:AJ31,\"а\")","v":0},{"$f":"COUNTIF(F31:AJ31,\"б\")","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,{"$f":"COUNTIF(F32:AJ32,\"бв\")","v":0},{"$f":"COUNTIF(F32:AJ32,\"бв\")","v":0},{"$f":"COUNTIF(F32:AJ32,\"а\")","v":0},{"$f":"COUNTIF(F32:AJ32,\"и\")","v":0}]
[12,{"$f":"INDEX(Список!$B$2:$AZ$71,$A33,MATCH($B$10,отд,0))","v":"Елисов  Виталий Юрьевич"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A33,MATCH($B$10,отд,0)+1)","v":"Мастер участка"},"Факт",null,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(F33:AJ33,\">=4\")+COUNTIF(F33:AJ33,\"к*\")","v":16},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F33:AJ33))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F33:AJ33)))","v":128},11122,{"$f":"AM33*0.87","v":9676.14},null,null,{"$f":"COUNTIF(F33:AJ33,\"в\")","v":0},{"$f":"COUNTIF(F33:AJ33,\"о\")","v":0},{"$f":"COUNTIF(F33:AJ33,\"п\")","v":0},{"$f":"COUNTIF(F33:AJ33,\"к*\")","v":0},{"$f":"COUNTIF(F33:AJ33,\"а\")","v":0},{"$f":"COUNTIF(F33:AJ33,\"б\")","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,{"$f":"COUNTIF(F34:AJ34,\"бв\")","v":0},{"$f":"COUNTIF(F34:AJ34,\"бв\")","v":0},{"$f":"COUNTIF(F34:AJ34,\"а\")","v":0},{"$f":"COUNTIF(F34:AJ34,\"и\")","v":0}]
[13,{"$f":"INDEX(Список!$B$2:$AZ$71,$A35,MATCH($B$10,отд,0))","v":"Зайцев Олег Валентинович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A35,MATCH($B$10,отд,0)+1)","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,{"$f":"COUNTIF(F35:AJ35,\">=4\")+COUNTIF(F35:AJ35,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F35:AJ35))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F35:AJ35)))","v":0},null,{"$f":"AM35*0.87","v":0},null,null,{"$f":"COUNTIF(F35:AJ35,\"в\")","v":0},{"$f":"COUNTIF(F35:AJ35,\"о\")","v":0},{"$f":"COUNTIF(F35:AJ35,\"п\")","v":0},{"$f":"COUNTIF(F35:AJ35,\"к*\")","v":0},{"$f":"COUNTIF(F35:AJ35,\"а\")","v":0},{"$f":"COUNTIF(F35:AJ35,\"б\")","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,{"$f":"COUNTIF(F36:AJ36,\"бв\")","v":0},{"$f":"COUNTIF(F36:AJ36,\"бв\")","v":0},{"$f":"COUNTIF(F36:AJ36,\"а\")","v":0},{"$f":"COUNTIF(F36:AJ36,\"и\")","v":0}]
[14,{"$f":"INDEX(Список!$B$2:$AZ$71,$A37,MATCH($B$10,отд,0))","v":"Зюзин Алексей Артурович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A37,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 4 разряда"},"Факт",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(F37:AJ37,\">=4\")+COUNTIF(F37:AJ37,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F37:AJ37))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F37:AJ37)))","v":0},null,{"$f":"AM37*0.87","v":0},null,null,{"$f":"COUNTIF(F37:AJ37,\"в\")","v":0},{"$f":"COUNTIF(F37:AJ37,\"о\")","v":0},{"$f":"COUNTIF(F37:AJ37,\"п\")","v":0},{"$f":"COUNTIF(F37:AJ37,\"к*\")","v":0},{"$f":"COUNTIF(F37:AJ37,\"а\")","v":0},{"$f":"COUNTIF(F37:AJ37,\"б\")","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,{"$f":"COUNTIF(F38:AJ38,\"бв\")","v":0},{"$f":"COUNTIF(F38:AJ38,\"бв\")","v":0},{"$f":"COUNTIF(F38:AJ38,\"а\")","v":0},{"$f":"COUNTIF(F38:AJ38,\"и\")","v":0}]
[15,{"$f":"INDEX(Список!$B$2:$AZ$71,$A39,MATCH($B$10,отд,0))","v":"Иванов Владимир Аркадьевич"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A39,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 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,{"$f":"COUNTIF(F39:AJ39,\">=4\")+COUNTIF(F39:AJ39,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F39:AJ39))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F39:AJ39)))","v":0},null,{"$f":"AM39*0.87","v":0},null,null,{"$f":"COUNTIF(F39:AJ39,\"в\")","v":0},{"$f":"COUNTIF(F39:AJ39,\"о\")","v":0},{"$f":"COUNTIF(F39:AJ39,\"п\")","v":0},{"$f":"COUNTIF(F39:AJ39,\"к*\")","v":0},{"$f":"COUNTIF(F39:AJ39,\"а\")","v":0},{"$f":"COUNTIF(F39:AJ39,\"б\")","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,{"$f":"COUNTIF(F40:AJ40,\"бв\")","v":0},{"$f":"COUNTIF(F40:AJ40,\"бв\")","v":0},{"$f":"COUNTIF(F40:AJ40,\"а\")","v":0},{"$f":"COUNTIF(F40:AJ40,\"и\")","v":0}]
[16,{"$f":"INDEX(Список!$B$2:$AZ$71,$A41,MATCH($B$10,отд,0))","v":"Кагитина Любовь Ивановна"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A41,MATCH($B$10,отд,0)+1)","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,{"$f":"COUNTIF(F41:AJ41,\">=4\")+COUNTIF(F41:AJ41,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F41:AJ41))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F41:AJ41)))","v":0},null,{"$f":"AM41*0.87","v":0},null,null,{"$f":"COUNTIF(F41:AJ41,\"в\")","v":0},{"$f":"COUNTIF(F41:AJ41,\"о\")","v":0},{"$f":"COUNTIF(F41:AJ41,\"п\")","v":0},{"$f":"COUNTIF(F41:AJ41,\"к*\")","v":0},{"$f":"COUNTIF(F41:AJ41,\"а\")","v":0},{"$f":"COUNTIF(F41:AJ41,\"б\")","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,{"$f":"COUNTIF(F42:AJ42,\"бв\")","v":0},{"$f":"COUNTIF(F42:AJ42,\"бв\")","v":0},{"$f":"COUNTIF(F42:AJ42,\"а\")","v":0},{"$f":"COUNTIF(F42:AJ42,\"и\")","v":0}]
[17,{"$f":"INDEX(Список!$B$2:$AZ$71,$A43,MATCH($B$10,отд,0))","v":"Капаев Сергей Александрович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A43,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 5 разряда"},"Факт",null,null,null,null,null,null,null,null,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(F43:AJ43,\">=4\")+COUNTIF(F43:AJ43,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F43:AJ43))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F43:AJ43)))","v":0},null,{"$f":"AM43*0.87","v":0},null,null,{"$f":"COUNTIF(F43:AJ43,\"в\")","v":0},{"$f":"COUNTIF(F43:AJ43,\"о\")","v":0},{"$f":"COUNTIF(F43:AJ43,\"п\")","v":0},{"$f":"COUNTIF(F43:AJ43,\"к*\")","v":0},{"$f":"COUNTIF(F43:AJ43,\"а\")","v":0},{"$f":"COUNTIF(F43:AJ43,\"б\")","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,{"$f":"COUNTIF(F44:AJ44,\"бв\")","v":0},{"$f":"COUNTIF(F44:AJ44,\"бв\")","v":0},{"$f":"COUNTIF(F44:AJ44,\"а\")","v":0},{"$f":"COUNTIF(F44:AJ44,\"и\")","v":0}]
[18,{"$f":"INDEX(Список!$B$2:$AZ$71,$A45,MATCH($B$10,отд,0))","v":"Капаева Татьяна Анатольевна"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A45,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 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,{"$f":"COUNTIF(F45:AJ45,\">=4\")+COUNTIF(F45:AJ45,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F45:AJ45))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F45:AJ45)))","v":0},null,{"$f":"AM45*0.87","v":0},null,null,{"$f":"COUNTIF(F45:AJ45,\"в\")","v":0},{"$f":"COUNTIF(F45:AJ45,\"о\")","v":0},{"$f":"COUNTIF(F45:AJ45,\"п\")","v":0},{"$f":"COUNTIF(F45:AJ45,\"к*\")","v":0},{"$f":"COUNTIF(F45:AJ45,\"а\")","v":0},{"$f":"COUNTIF(F45:AJ45,\"б\")","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,{"$f":"COUNTIF(F46:AJ46,\"бв\")","v":0},{"$f":"COUNTIF(F46:AJ46,\"бв\")","v":0},{"$f":"COUNTIF(F46:AJ46,\"а\")","v":0},{"$f":"COUNTIF(F46:AJ46,\"и\")","v":0}]
[19,{"$f":"INDEX(Список!$B$2:$AZ$71,$A47,MATCH($B$10,отд,0))","v":"Керносов Антон Сергеевич"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A47,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 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,{"$f":"COUNTIF(F47:AJ47,\">=4\")+COUNTIF(F47:AJ47,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F47:AJ47))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F47:AJ47)))","v":0},null,{"$f":"AM47*0.87","v":0},null,null,{"$f":"COUNTIF(F47:AJ47,\"в\")","v":0},{"$f":"COUNTIF(F47:AJ47,\"о\")","v":0},{"$f":"COUNTIF(F47:AJ47,\"п\")","v":0},{"$f":"COUNTIF(F47:AJ47,\"к*\")","v":0},{"$f":"COUNTIF(F47:AJ47,\"а\")","v":0},{"$f":"COUNTIF(F47:AJ47,\"б\")","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,{"$f":"COUNTIF(F48:AJ48,\"бв\")","v":0},{"$f":"COUNTIF(F48:AJ48,\"бв\")","v":0},{"$f":"COUNTIF(F48:AJ48,\"а\")","v":0},{"$f":"COUNTIF(F48:AJ48,\"и\")","v":0}]
[20,{"$f":"INDEX(Список!$B$2:$AZ$71,$A49,MATCH($B$10,отд,0))","v":"Клочков Николай Геннадьевич"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A49,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 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,{"$f":"COUNTIF(F49:AJ49,\">=4\")+COUNTIF(F49:AJ49,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F49:AJ49))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F49:AJ49)))","v":0},null,{"$f":"AM49*0.87","v":0},null,null,{"$f":"COUNTIF(F49:AJ49,\"в\")","v":0},{"$f":"COUNTIF(F49:AJ49,\"о\")","v":0},{"$f":"COUNTIF(F49:AJ49,\"п\")","v":0},{"$f":"COUNTIF(F49:AJ49,\"к*\")","v":0},{"$f":"COUNTIF(F49:AJ49,\"а\")","v":0},{"$f":"COUNTIF(F49:AJ49,\"б\")","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,{"$f":"COUNTIF(F50:AJ50,\"бв\")","v":0},{"$f":"COUNTIF(F50:AJ50,\"бв\")","v":0},{"$f":"COUNTIF(F50:AJ50,\"а\")","v":0},{"$f":"COUNTIF(F50:AJ50,\"и\")","v":0}]
[21,{"$f":"INDEX(Список!$B$2:$AZ$71,$A51,MATCH($B$10,отд,0))","v":"Ковылин Александр Алексеевич"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A51,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 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,{"$f":"COUNTIF(F51:AJ51,\">=4\")+COUNTIF(F51:AJ51,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F51:AJ51))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F51:AJ51)))","v":0},null,{"$f":"AM51*0.87","v":0},null,null,{"$f":"COUNTIF(F51:AJ51,\"в\")","v":0},{"$f":"COUNTIF(F51:AJ51,\"о\")","v":0},{"$f":"COUNTIF(F51:AJ51,\"п\")","v":0},{"$f":"COUNTIF(F51:AJ51,\"к*\")","v":0},{"$f":"COUNTIF(F51:AJ51,\"а\")","v":0},{"$f":"COUNTIF(F51:AJ51,\"б\")","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,{"$f":"COUNTIF(F52:AJ52,\"бв\")","v":0},{"$f":"COUNTIF(F52:AJ52,\"бв\")","v":0},{"$f":"COUNTIF(F52:AJ52,\"а\")","v":0},{"$f":"COUNTIF(F52:AJ52,\"и\")","v":0}]
[22,{"$f":"INDEX(Список!$B$2:$AZ$71,$A53,MATCH($B$10,отд,0))","v":"Кононенко Александр Викторович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A53,MATCH($B$10,отд,0)+1)","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,{"$f":"COUNTIF(F53:AJ53,\">=4\")+COUNTIF(F53:AJ53,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F53:AJ53))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F53:AJ53)))","v":0},null,{"$f":"AM53*0.87","v":0},null,null,{"$f":"COUNTIF(F53:AJ53,\"в\")","v":0},{"$f":"COUNTIF(F53:AJ53,\"о\")","v":0},{"$f":"COUNTIF(F53:AJ53,\"п\")","v":0},{"$f":"COUNTIF(F53:AJ53,\"к*\")","v":0},{"$f":"COUNTIF(F53:AJ53,\"а\")","v":0},{"$f":"COUNTIF(F53:AJ53,\"б\")","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,{"$f":"COUNTIF(F54:AJ54,\"бв\")","v":0},{"$f":"COUNTIF(F54:AJ54,\"бв\")","v":0},{"$f":"COUNTIF(F54:AJ54,\"а\")","v":0},{"$f":"COUNTIF(F54:AJ54,\"и\")","v":0}]
[23,{"$f":"INDEX(Список!$B$2:$AZ$71,$A55,MATCH($B$10,отд,0))","v":"Красильников Роман Викторович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A55,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 4 разряда"},"Факт",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(F55:AJ55,\">=4\")+COUNTIF(F55:AJ55,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F55:AJ55))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F55:AJ55)))","v":0},null,{"$f":"AM55*0.87","v":0},null,null,{"$f":"COUNTIF(F55:AJ55,\"в\")","v":0},{"$f":"COUNTIF(F55:AJ55,\"о\")","v":0},{"$f":"COUNTIF(F55:AJ55,\"п\")","v":0},{"$f":"COUNTIF(F55:AJ55,\"к*\")","v":0},{"$f":"COUNTIF(F55:AJ55,\"а\")","v":0},{"$f":"COUNTIF(F55:AJ55,\"б\")","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,{"$f":"COUNTIF(F56:AJ56,\"бв\")","v":0},{"$f":"COUNTIF(F56:AJ56,\"бв\")","v":0},{"$f":"COUNTIF(F56:AJ56,\"а\")","v":0},{"$f":"COUNTIF(F56:AJ56,\"и\")","v":0}]
[24,{"$f":"INDEX(Список!$B$2:$AZ$71,$A57,MATCH($B$10,отд,0))","v":"Кузнецов Александр Николаевич"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A57,MATCH($B$10,отд,0)+1)","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,{"$f":"COUNTIF(F57:AJ57,\">=4\")+COUNTIF(F57:AJ57,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F57:AJ57))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F57:AJ57)))","v":0},null,{"$f":"AM57*0.87","v":0},null,null,{"$f":"COUNTIF(F57:AJ57,\"в\")","v":0},{"$f":"COUNTIF(F57:AJ57,\"о\")","v":0},{"$f":"COUNTIF(F57:AJ57,\"п\")","v":0},{"$f":"COUNTIF(F57:AJ57,\"к*\")","v":0},{"$f":"COUNTIF(F57:AJ57,\"а\")","v":0},{"$f":"COUNTIF(F57:AJ57,\"б\")","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,{"$f":"COUNTIF(F58:AJ58,\"бв\")","v":0},{"$f":"COUNTIF(F58:AJ58,\"бв\")","v":0},{"$f":"COUNTIF(F58:AJ58,\"а\")","v":0},{"$f":"COUNTIF(F58:AJ58,\"и\")","v":0}]
[25,{"$f":"INDEX(Список!$B$2:$AZ$71,$A59,MATCH($B$10,отд,0))","v":"Кузнецова Наталья Викторовна"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A59,MATCH($B$10,отд,0)+1)","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,{"$f":"COUNTIF(F59:AJ59,\">=4\")+COUNTIF(F59:AJ59,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F59:AJ59))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F59:AJ59)))","v":0},null,{"$f":"AM59*0.87","v":0},null,null,{"$f":"COUNTIF(F59:AJ59,\"в\")","v":0},{"$f":"COUNTIF(F59:AJ59,\"о\")","v":0},{"$f":"COUNTIF(F59:AJ59,\"п\")","v":0},{"$f":"COUNTIF(F59:AJ59,\"к*\")","v":0},{"$f":"COUNTIF(F59:AJ59,\"а\")","v":0},{"$f":"COUNTIF(F59:AJ59,\"б\")","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,{"$f":"COUNTIF(F60:AJ60,\"бв\")","v":0},{"$f":"COUNTIF(F60:AJ60,\"бв\")","v":0},{"$f":"COUNTIF(F60:AJ60,\"а\")","v":0},{"$f":"COUNTIF(F60:AJ60,\"и\")","v":0}]
[26,{"$f":"INDEX(Список!$B$2:$AZ$71,$A61,MATCH($B$10,отд,0))","v":"Кузовлев Николай Николаевич"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A61,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 4 разряда"},"Факт",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(F61:AJ61,\">=4\")+COUNTIF(F61:AJ61,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F61:AJ61))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F61:AJ61)))","v":0},null,{"$f":"AM61*0.87","v":0},null,null,{"$f":"COUNTIF(F61:AJ61,\"в\")","v":0},{"$f":"COUNTIF(F61:AJ61,\"о\")","v":0},{"$f":"COUNTIF(F61:AJ61,\"п\")","v":0},{"$f":"COUNTIF(F61:AJ61,\"к*\")","v":0},{"$f":"COUNTIF(F61:AJ61,\"а\")","v":0},{"$f":"COUNTIF(F61:AJ61,\"б\")","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,{"$f":"COUNTIF(F62:AJ62,\"бв\")","v":0},{"$f":"COUNTIF(F62:AJ62,\"бв\")","v":0},{"$f":"COUNTIF(F62:AJ62,\"а\")","v":0},{"$f":"COUNTIF(F62:AJ62,\"и\")","v":0}]
[27,{"$f":"INDEX(Список!$B$2:$AZ$71,$A63,MATCH($B$10,отд,0))","v":"Кузьмин Виталий Анатольевич"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A63,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 5 разряда"},"Факт",null,null,null,null,null,null,null,null,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(F63:AJ63,\">=4\")+COUNTIF(F63:AJ63,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F63:AJ63))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F63:AJ63)))","v":0},null,{"$f":"AM63*0.87","v":0},null,null,{"$f":"COUNTIF(F63:AJ63,\"в\")","v":0},{"$f":"COUNTIF(F63:AJ63,\"о\")","v":0},{"$f":"COUNTIF(F63:AJ63,\"п\")","v":0},{"$f":"COUNTIF(F63:AJ63,\"к*\")","v":0},{"$f":"COUNTIF(F63:AJ63,\"а\")","v":0},{"$f":"COUNTIF(F63:AJ63,\"б\")","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,{"$f":"COUNTIF(F64:AJ64,\"бв\")","v":0},{"$f":"COUNTIF(F64:AJ64,\"бв\")","v":0},{"$f":"COUNTIF(F64:AJ64,\"а\")","v":0},{"$f":"COUNTIF(F64:AJ64,\"и\")","v":0}]
[28,{"$f":"INDEX(Список!$B$2:$AZ$71,$A65,MATCH($B$10,отд,0))","v":"Курганский Алексей Семенович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A65,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 4 разряда"},"Факт",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(F65:AJ65,\">=4\")+COUNTIF(F65:AJ65,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F65:AJ65))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F65:AJ65)))","v":0},null,{"$f":"AM65*0.87","v":0},null,null,{"$f":"COUNTIF(F65:AJ65,\"в\")","v":0},{"$f":"COUNTIF(F65:AJ65,\"о\")","v":0},{"$f":"COUNTIF(F65:AJ65,\"п\")","v":0},{"$f":"COUNTIF(F65:AJ65,\"к*\")","v":0},{"$f":"COUNTIF(F65:AJ65,\"а\")","v":0},{"$f":"COUNTIF(F65:AJ65,\"б\")","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,{"$f":"COUNTIF(F66:AJ66,\"бв\")","v":0},{"$f":"COUNTIF(F66:AJ66,\"бв\")","v":0},{"$f":"COUNTIF(F66:AJ66,\"а\")","v":0},{"$f":"COUNTIF(F66:AJ66,\"и\")","v":0}]
[29,{"$f":"INDEX(Список!$B$2:$AZ$71,$A67,MATCH($B$10,отд,0))","v":"Кутищев Алексей Павлович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A67,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 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,{"$f":"COUNTIF(F67:AJ67,\">=4\")+COUNTIF(F67:AJ67,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F67:AJ67))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F67:AJ67)))","v":0},null,{"$f":"AM67*0.87","v":0},null,null,{"$f":"COUNTIF(F67:AJ67,\"в\")","v":0},{"$f":"COUNTIF(F67:AJ67,\"о\")","v":0},{"$f":"COUNTIF(F67:AJ67,\"п\")","v":0},{"$f":"COUNTIF(F67:AJ67,\"к*\")","v":0},{"$f":"COUNTIF(F67:AJ67,\"а\")","v":0},{"$f":"COUNTIF(F67:AJ67,\"б\")","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,{"$f":"COUNTIF(F68:AJ68,\"бв\")","v":0},{"$f":"COUNTIF(F68:AJ68,\"бв\")","v":0},{"$f":"COUNTIF(F68:AJ68,\"а\")","v":0},{"$f":"COUNTIF(F68:AJ68,\"и\")","v":0}]
[30,{"$f":"INDEX(Список!$B$2:$AZ$71,$A69,MATCH($B$10,отд,0))","v":"Мартынюк Владимир Николаевич"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A69,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 5 разряда"},"Факт",null,null,null,null,null,null,null,null,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(F69:AJ69,\">=4\")+COUNTIF(F69:AJ69,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F69:AJ69))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F69:AJ69)))","v":0},null,{"$f":"AM69*0.87","v":0},null,null,{"$f":"COUNTIF(F69:AJ69,\"в\")","v":0},{"$f":"COUNTIF(F69:AJ69,\"о\")","v":0},{"$f":"COUNTIF(F69:AJ69,\"п\")","v":0},{"$f":"COUNTIF(F69:AJ69,\"к*\")","v":0},{"$f":"COUNTIF(F69:AJ69,\"а\")","v":0},{"$f":"COUNTIF(F69:AJ69,\"б\")","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,{"$f":"COUNTIF(F70:AJ70,\"бв\")","v":0},{"$f":"COUNTIF(F70:AJ70,\"бв\")","v":0},{"$f":"COUNTIF(F70:AJ70,\"а\")","v":0},{"$f":"COUNTIF(F70:AJ70,\"и\")","v":0}]
[31,{"$f":"INDEX(Список!$B$2:$AZ$71,$A71,MATCH($B$10,отд,0))","v":"Матюхин Анатолий Афанасьевич"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A71,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 5 разряда"},"Факт",null,null,null,null,null,null,null,null,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(F71:AJ71,\">=4\")+COUNTIF(F71:AJ71,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F71:AJ71))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F71:AJ71)))","v":0},null,{"$f":"AM71*0.87","v":0},null,null,{"$f":"COUNTIF(F71:AJ71,\"в\")","v":0},{"$f":"COUNTIF(F71:AJ71,\"о\")","v":0},{"$f":"COUNTIF(F71:AJ71,\"п\")","v":0},{"$f":"COUNTIF(F71:AJ71,\"к*\")","v":0},{"$f":"COUNTIF(F71:AJ71,\"а\")","v":0},{"$f":"COUNTIF(F71:AJ71,\"б\")","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,{"$f":"COUNTIF(F72:AJ72,\"бв\")","v":0},{"$f":"COUNTIF(F72:AJ72,\"бв\")","v":0},{"$f":"COUNTIF(F72:AJ72,\"а\")","v":0},{"$f":"COUNTIF(F72:AJ72,\"и\")","v":0}]
[32,{"$f":"INDEX(Список!$B$2:$AZ$71,$A73,MATCH($B$10,отд,0))","v":"Матюхина Галина Александровна"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A73,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 5 разряда"},"Факт",null,null,null,null,null,null,null,null,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(F73:AJ73,\">=4\")+COUNTIF(F73:AJ73,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F73:AJ73))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F73:AJ73)))","v":0},null,{"$f":"AM73*0.87","v":0},null,null,{"$f":"COUNTIF(F73:AJ73,\"в\")","v":0},{"$f":"COUNTIF(F73:AJ73,\"о\")","v":0},{"$f":"COUNTIF(F73:AJ73,\"п\")","v":0},{"$f":"COUNTIF(F73:AJ73,\"к*\")","v":0},{"$f":"COUNTIF(F73:AJ73,\"а\")","v":0},{"$f":"COUNTIF(F73:AJ73,\"б\")","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,{"$f":"COUNTIF(F74:AJ74,\"бв\")","v":0},{"$f":"COUNTIF(F74:AJ74,\"бв\")","v":0},{"$f":"COUNTIF(F74:AJ74,\"а\")","v":0},{"$f":"COUNTIF(F74:AJ74,\"и\")","v":0}]
[33,{"$f":"INDEX(Список!$B$2:$AZ$71,$A75,MATCH($B$10,отд,0))","v":"Метелкин Сергей Львович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A75,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 5 разряда"},"Факт",null,null,null,null,null,null,null,null,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(F75:AJ75,\">=4\")+COUNTIF(F75:AJ75,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F75:AJ75))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F75:AJ75)))","v":0},null,{"$f":"AM75*0.87","v":0},null,null,{"$f":"COUNTIF(F75:AJ75,\"в\")","v":0},{"$f":"COUNTIF(F75:AJ75,\"о\")","v":0},{"$f":"COUNTIF(F75:AJ75,\"п\")","v":0},{"$f":"COUNTIF(F75:AJ75,\"к*\")","v":0},{"$f":"COUNTIF(F75:AJ75,\"а\")","v":0},{"$f":"COUNTIF(F75:AJ75,\"б\")","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,{"$f":"COUNTIF(F76:AJ76,\"бв\")","v":0},{"$f":"COUNTIF(F76:AJ76,\"бв\")","v":0},{"$f":"COUNTIF(F76:AJ76,\"а\")","v":0},{"$f":"COUNTIF(F76:AJ76,\"и\")","v":0}]
[34,{"$f":"INDEX(Список!$B$2:$AZ$71,$A77,MATCH($B$10,отд,0))","v":"Мильян Леонид Иванович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A77,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 5 разряда"},"Факт",null,null,null,null,null,null,null,null,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(F77:AJ77,\">=4\")+COUNTIF(F77:AJ77,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F77:AJ77))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F77:AJ77)))","v":0},null,{"$f":"AM77*0.87","v":0},null,null,{"$f":"COUNTIF(F77:AJ77,\"в\")","v":0},{"$f":"COUNTIF(F77:AJ77,\"о\")","v":0},{"$f":"COUNTIF(F77:AJ77,\"п\")","v":0},{"$f":"COUNTIF(F77:AJ77,\"к*\")","v":0},{"$f":"COUNTIF(F77:AJ77,\"а\")","v":0},{"$f":"COUNTIF(F77:AJ77,\"б\")","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,{"$f":"COUNTIF(F78:AJ78,\"бв\")","v":0},{"$f":"COUNTIF(F78:AJ78,\"бв\")","v":0},{"$f":"COUNTIF(F78:AJ78,\"а\")","v":0},{"$f":"COUNTIF(F78:AJ78,\"и\")","v":0}]
[35,{"$f":"INDEX(Список!$B$2:$AZ$71,$A79,MATCH($B$10,отд,0))","v":"Милюков Юрий Виссарионович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A79,MATCH($B$10,отд,0)+1)","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,{"$f":"COUNTIF(F79:AJ79,\">=4\")+COUNTIF(F79:AJ79,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F79:AJ79))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F79:AJ79)))","v":0},null,{"$f":"AM79*0.87","v":0},null,null,{"$f":"COUNTIF(F79:AJ79,\"в\")","v":0},{"$f":"COUNTIF(F79:AJ79,\"о\")","v":0},{"$f":"COUNTIF(F79:AJ79,\"п\")","v":0},{"$f":"COUNTIF(F79:AJ79,\"к*\")","v":0},{"$f":"COUNTIF(F79:AJ79,\"а\")","v":0},{"$f":"COUNTIF(F79:AJ79,\"б\")","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,{"$f":"COUNTIF(F80:AJ80,\"бв\")","v":0},{"$f":"COUNTIF(F80:AJ80,\"бв\")","v":0},{"$f":"COUNTIF(F80:AJ80,\"а\")","v":0},{"$f":"COUNTIF(F80:AJ80,\"и\")","v":0}]
[36,{"$f":"INDEX(Список!$B$2:$AZ$71,$A81,MATCH($B$10,отд,0))","v":"Петренко Юрий Константинович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A81,MATCH($B$10,отд,0)+1)","v":"Монтажник по монтажу стальных и железобетонных конструкций 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,{"$f":"COUNTIF(F81:AJ81,\">=4\")+COUNTIF(F81:AJ81,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F81:AJ81))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F81:AJ81)))","v":0},null,{"$f":"AM81*0.87","v":0},null,null,{"$f":"COUNTIF(F81:AJ81,\"в\")","v":0},{"$f":"COUNTIF(F81:AJ81,\"о\")","v":0},{"$f":"COUNTIF(F81:AJ81,\"п\")","v":0},{"$f":"COUNTIF(F81:AJ81,\"к*\")","v":0},{"$f":"COUNTIF(F81:AJ81,\"а\")","v":0},{"$f":"COUNTIF(F81:AJ81,\"б\")","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,{"$f":"COUNTIF(F82:AJ82,\"бв\")","v":0},{"$f":"COUNTIF(F82:AJ82,\"бв\")","v":0},{"$f":"COUNTIF(F82:AJ82,\"а\")","v":0},{"$f":"COUNTIF(F82:AJ82,\"и\")","v":0}]
[37,{"$f":"INDEX(Список!$B$2:$AZ$71,$A83,MATCH($B$10,отд,0))","v":"Потехин Дмитрий Иванович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A83,MATCH($B$10,отд,0)+1)","v":"Производитель работ (прораб) "},"Факт",null,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(F83:AJ83,\">=4\")+COUNTIF(F83:AJ83,\"к*\")","v":16},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F83:AJ83))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F83:AJ83)))","v":128},11147,{"$f":"AM83*0.87","v":9697.89},null,null,{"$f":"COUNTIF(F83:AJ83,\"в\")","v":0},{"$f":"COUNTIF(F83:AJ83,\"о\")","v":0},{"$f":"COUNTIF(F83:AJ83,\"п\")","v":0},{"$f":"COUNTIF(F83:AJ83,\"к*\")","v":0},{"$f":"COUNTIF(F83:AJ83,\"а\")","v":0},{"$f":"COUNTIF(F83:AJ83,\"б\")","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,{"$f":"COUNTIF(F84:AJ84,\"бв\")","v":0},{"$f":"COUNTIF(F84:AJ84,\"бв\")","v":0},{"$f":"COUNTIF(F84:AJ84,\"а\")","v":0},{"$f":"COUNTIF(F84:AJ84,\"и\")","v":0}]
[38,{"$f":"INDEX(Список!$B$2:$AZ$71,$A85,MATCH($B$10,отд,0))","v":"Розенбах Денис Сергеевич"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A85,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 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,16,{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F85:AJ85))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F85:AJ85)))","v":0},5,{"$f":"AM85*0.87","v":4.3499999999999996},null,null,{"$f":"COUNTIF(F85:AJ85,\"в\")","v":0},{"$f":"COUNTIF(F85:AJ85,\"о\")","v":0},{"$f":"COUNTIF(F85:AJ85,\"п\")","v":0},{"$f":"COUNTIF(F85:AJ85,\"к*\")","v":0},{"$f":"COUNTIF(F85:AJ85,\"а\")","v":0},{"$f":"COUNTIF(F85:AJ85,\"б\")","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,{"$f":"COUNTIF(F86:AJ86,\"бв\")","v":0},{"$f":"COUNTIF(F86:AJ86,\"бв\")","v":0},{"$f":"COUNTIF(F86:AJ86,\"а\")","v":0},{"$f":"COUNTIF(F86:AJ86,\"и\")","v":0}]
[39,{"$f":"INDEX(Список!$B$2:$AZ$71,$A87,MATCH($B$10,отд,0))","v":"Рытов Игорь Викторович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A87,MATCH($B$10,отд,0)+1)","v":"Монтажник по монтажу стальных и железобетонных конструкций 4 разряда"},"Факт",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(F87:AJ87,\">=4\")+COUNTIF(F87:AJ87,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F87:AJ87))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F87:AJ87)))","v":0},null,{"$f":"AM87*0.87","v":0},null,null,{"$f":"COUNTIF(F87:AJ87,\"в\")","v":0},{"$f":"COUNTIF(F87:AJ87,\"о\")","v":0},{"$f":"COUNTIF(F87:AJ87,\"п\")","v":0},{"$f":"COUNTIF(F87:AJ87,\"к*\")","v":0},{"$f":"COUNTIF(F87:AJ87,\"а\")","v":0},{"$f":"COUNTIF(F87:AJ87,\"б\")","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,{"$f":"COUNTIF(F88:AJ88,\"бв\")","v":0},{"$f":"COUNTIF(F88:AJ88,\"бв\")","v":0},{"$f":"COUNTIF(F88:AJ88,\"а\")","v":0},{"$f":"COUNTIF(F88:AJ88,\"и\")","v":0}]
[40,{"$f":"INDEX(Список!$B$2:$AZ$71,$A89,MATCH($B$10,отд,0))","v":"Сергеенко Максим Владимирович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A89,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 5 разряда"},"Факт",null,null,null,null,null,null,null,null,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(F89:AJ89,\">=4\")+COUNTIF(F89:AJ89,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F89:AJ89))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F89:AJ89)))","v":0},null,{"$f":"AM89*0.87","v":0},null,null,{"$f":"COUNTIF(F89:AJ89,\"в\")","v":0},{"$f":"COUNTIF(F89:AJ89,\"о\")","v":0},{"$f":"COUNTIF(F89:AJ89,\"п\")","v":0},{"$f":"COUNTIF(F89:AJ89,\"к*\")","v":0},{"$f":"COUNTIF(F89:AJ89,\"а\")","v":0},{"$f":"COUNTIF(F89:AJ89,\"б\")","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,{"$f":"COUNTIF(F90:AJ90,\"бв\")","v":0},{"$f":"COUNTIF(F90:AJ90,\"бв\")","v":0},{"$f":"COUNTIF(F90:AJ90,\"а\")","v":0},{"$f":"COUNTIF(F90:AJ90,\"и\")","v":0}]
[41,{"$f":"INDEX(Список!$B$2:$AZ$71,$A91,MATCH($B$10,отд,0))","v":"Симулин Сергей Владимирович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A91,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 5 разряда"},"Факт",null,null,null,null,null,null,null,null,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(F91:AJ91,\">=4\")+COUNTIF(F91:AJ91,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F91:AJ91))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F91:AJ91)))","v":0},null,{"$f":"AM91*0.87","v":0},null,null,{"$f":"COUNTIF(F91:AJ91,\"в\")","v":0},{"$f":"COUNTIF(F91:AJ91,\"о\")","v":0},{"$f":"COUNTIF(F91:AJ91,\"п\")","v":0},{"$f":"COUNTIF(F91:AJ91,\"к*\")","v":0},{"$f":"COUNTIF(F91:AJ91,\"а\")","v":0},{"$f":"COUNTIF(F91:AJ91,\"б\")","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,{"$f":"COUNTIF(F92:AJ92,\"бв\")","v":0},{"$f":"COUNTIF(F92:AJ92,\"бв\")","v":0},{"$f":"COUNTIF(F92:AJ92,\"а\")","v":0},{"$f":"COUNTIF(F92:AJ92,\"и\")","v":0}]
[42,{"$f":"INDEX(Список!$B$2:$AZ$71,$A93,MATCH($B$10,отд,0))","v":"Сурков Владимир Владимирович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A93,MATCH($B$10,отд,0)+1)","v":"Монтажник по монтажу стальных и железобетонных конструкций 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,{"$f":"COUNTIF(F93:AJ93,\">=4\")+COUNTIF(F93:AJ93,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F93:AJ93))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F93:AJ93)))","v":0},null,{"$f":"AM93*0.87","v":0},null,null,{"$f":"COUNTIF(F93:AJ93,\"в\")","v":0},{"$f":"COUNTIF(F93:AJ93,\"о\")","v":0},{"$f":"COUNTIF(F93:AJ93,\"п\")","v":0},{"$f":"COUNTIF(F93:AJ93,\"к*\")","v":0},{"$f":"COUNTIF(F93:AJ93,\"а\")","v":0},{"$f":"COUNTIF(F93:AJ93,\"б\")","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,{"$f":"COUNTIF(F94:AJ94,\"бв\")","v":0},{"$f":"COUNTIF(F94:AJ94,\"бв\")","v":0},{"$f":"COUNTIF(F94:AJ94,\"а\")","v":0},{"$f":"COUNTIF(F94:AJ94,\"и\")","v":0}]
[43,{"$f":"INDEX(Список!$B$2:$AZ$71,$A95,MATCH($B$10,отд,0))","v":"Сусляков Сергей Александрович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A95,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 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,{"$f":"COUNTIF(F95:AJ95,\">=4\")+COUNTIF(F95:AJ95,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F95:AJ95))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F95:AJ95)))","v":0},null,{"$f":"AM95*0.87","v":0},null,null,{"$f":"COUNTIF(F95:AJ95,\"в\")","v":0},{"$f":"COUNTIF(F95:AJ95,\"о\")","v":0},{"$f":"COUNTIF(F95:AJ95,\"п\")","v":0},{"$f":"COUNTIF(F95:AJ95,\"к*\")","v":0},{"$f":"COUNTIF(F95:AJ95,\"а\")","v":0},{"$f":"COUNTIF(F95:AJ95,\"б\")","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,{"$f":"COUNTIF(F96:AJ96,\"бв\")","v":0},{"$f":"COUNTIF(F96:AJ96,\"бв\")","v":0},{"$f":"COUNTIF(F96:AJ96,\"а\")","v":0},{"$f":"COUNTIF(F96:AJ96,\"и\")","v":0}]
[44,{"$f":"INDEX(Список!$B$2:$AZ$71,$A97,MATCH($B$10,отд,0))","v":"Суханов Дмитрий Викторович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A97,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 5 разряда"},"Факт",null,null,null,null,null,null,null,null,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(F97:AJ97,\">=4\")+COUNTIF(F97:AJ97,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F97:AJ97))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F97:AJ97)))","v":0},null,{"$f":"AM97*0.87","v":0},null,null,{"$f":"COUNTIF(F97:AJ97,\"в\")","v":0},{"$f":"COUNTIF(F97:AJ97,\"о\")","v":0},{"$f":"COUNTIF(F97:AJ97,\"п\")","v":0},{"$f":"COUNTIF(F97:AJ97,\"к*\")","v":0},{"$f":"COUNTIF(F97:AJ97,\"а\")","v":0},{"$f":"COUNTIF(F97:AJ97,\"б\")","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,{"$f":"COUNTIF(F98:AJ98,\"бв\")","v":0},{"$f":"COUNTIF(F98:AJ98,\"бв\")","v":0},{"$f":"COUNTIF(F98:AJ98,\"а\")","v":0},{"$f":"COUNTIF(F98:AJ98,\"и\")","v":0}]
[45,{"$f":"INDEX(Список!$B$2:$AZ$71,$A99,MATCH($B$10,отд,0))","v":"Тамбов Роман Евгеньевич"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A99,MATCH($B$10,отд,0)+1)","v":"Монтажник по монтажу стальных и железобетонных конструкций 3 разряда"},"Факт",null,8,8,8,8,8,8,8,8,8,8,8,12,8,7,8,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(F99:AJ99,\">=4\")+COUNTIF(F99:AJ99,\"к*\")","v":16},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F99:AJ99))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F99:AJ99)))","v":133},11155,{"$f":"AM99*0.87","v":9704.85},null,null,{"$f":"COUNTIF(F99:AJ99,\"в\")","v":0},{"$f":"COUNTIF(F99:AJ99,\"о\")","v":0},{"$f":"COUNTIF(F99:AJ99,\"п\")","v":0},{"$f":"COUNTIF(F99:AJ99,\"к*\")","v":0},{"$f":"COUNTIF(F99:AJ99,\"а\")","v":0},{"$f":"COUNTIF(F99:AJ99,\"б\")","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,{"$f":"COUNTIF(F100:AJ100,\"бв\")","v":0},{"$f":"COUNTIF(F100:AJ100,\"бв\")","v":0},{"$f":"COUNTIF(F100:AJ100,\"а\")","v":0},{"$f":"COUNTIF(F100:AJ100,\"и\")","v":0}]
[46,{"$f":"INDEX(Список!$B$2:$AZ$71,$A101,MATCH($B$10,отд,0))","v":"Терентьев Василий Владимирович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A101,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 5 разряда"},"Факт",null,null,null,null,null,null,null,null,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(F101:AJ101,\">=4\")+COUNTIF(F101:AJ101,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F101:AJ101))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F101:AJ101)))","v":0},null,{"$f":"AM101*0.87","v":0},null,null,{"$f":"COUNTIF(F101:AJ101,\"в\")","v":0},{"$f":"COUNTIF(F101:AJ101,\"о\")","v":0},{"$f":"COUNTIF(F101:AJ101,\"п\")","v":0},{"$f":"COUNTIF(F101:AJ101,\"к*\")","v":0},{"$f":"COUNTIF(F101:AJ101,\"а\")","v":0},{"$f":"COUNTIF(F101:AJ101,\"б\")","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,{"$f":"COUNTIF(F102:AJ102,\"бв\")","v":0},{"$f":"COUNTIF(F102:AJ102,\"бв\")","v":0},{"$f":"COUNTIF(F102:AJ102,\"а\")","v":0},{"$f":"COUNTIF(F102:AJ102,\"и\")","v":0}]
[47,{"$f":"INDEX(Список!$B$2:$AZ$71,$A103,MATCH($B$10,отд,0))","v":"Уголев Дмитрий Викторович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A103,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 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,{"$f":"COUNTIF(F103:AJ103,\">=4\")+COUNTIF(F103:AJ103,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F103:AJ103))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F103:AJ103)))","v":0},null,{"$f":"AM103*0.87","v":0},null,null,{"$f":"COUNTIF(F103:AJ103,\"в\")","v":0},{"$f":"COUNTIF(F103:AJ103,\"о\")","v":0},{"$f":"COUNTIF(F103:AJ103,\"п\")","v":0},{"$f":"COUNTIF(F103:AJ103,\"к*\")","v":0},{"$f":"COUNTIF(F103:AJ103,\"а\")","v":0},{"$f":"COUNTIF(F103:AJ103,\"б\")","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,{"$f":"COUNTIF(F104:AJ104,\"бв\")","v":0},{"$f":"COUNTIF(F104:AJ104,\"бв\")","v":0},{"$f":"COUNTIF(F104:AJ104,\"а\")","v":0},{"$f":"COUNTIF(F104:AJ104,\"и\")","v":0}]
[48,{"$f":"INDEX(Список!$B$2:$AZ$71,$A105,MATCH($B$10,отд,0))","v":"Шестаков Андрей Иванович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A105,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 4 разряда"},"Факт",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(F105:AJ105,\">=4\")+COUNTIF(F105:AJ105,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F105:AJ105))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F105:AJ105)))","v":0},null,{"$f":"AM105*0.87","v":0},null,null,{"$f":"COUNTIF(F105:AJ105,\"в\")","v":0},{"$f":"COUNTIF(F105:AJ105,\"о\")","v":0},{"$f":"COUNTIF(F105:AJ105,\"п\")","v":0},{"$f":"COUNTIF(F105:AJ105,\"к*\")","v":0},{"$f":"COUNTIF(F105:AJ105,\"а\")","v":0},{"$f":"COUNTIF(F105:AJ105,\"б\")","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,{"$f":"COUNTIF(F106:AJ106,\"бв\")","v":0},{"$f":"COUNTIF(F106:AJ106,\"бв\")","v":0},{"$f":"COUNTIF(F106:AJ106,\"а\")","v":0},{"$f":"COUNTIF(F106:AJ106,\"и\")","v":0}]
[49,{"$f":"INDEX(Список!$B$2:$AZ$71,$A107,MATCH($B$10,отд,0))","v":"Шмыков Виктор Васильевич"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A107,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 5 разряда"},"Факт",null,null,null,null,null,null,null,null,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(F107:AJ107,\">=4\")+COUNTIF(F107:AJ107,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F107:AJ107))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F107:AJ107)))","v":0},null,{"$f":"AM107*0.87","v":0},null,null,{"$f":"COUNTIF(F107:AJ107,\"в\")","v":0},{"$f":"COUNTIF(F107:AJ107,\"о\")","v":0},{"$f":"COUNTIF(F107:AJ107,\"п\")","v":0},{"$f":"COUNTIF(F107:AJ107,\"к*\")","v":0},{"$f":"COUNTIF(F107:AJ107,\"а\")","v":0},{"$f":"COUNTIF(F107:AJ107,\"б\")","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,{"$f":"COUNTIF(F108:AJ108,\"бв\")","v":0},{"$f":"COUNTIF(F108:AJ108,\"бв\")","v":0},{"$f":"COUNTIF(F108:AJ108,\"а\")","v":0},{"$f":"COUNTIF(F108:AJ108,\"и\")","v":0}]
[50,{"$f":"INDEX(Список!$B$2:$AZ$71,$A109,MATCH($B$10,отд,0))","v":"Эндерс Валерий Давыдович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A109,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 4 разряда"},"Факт",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(F109:AJ109,\">=4\")+COUNTIF(F109:AJ109,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F109:AJ109))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F109:AJ109)))","v":0},null,{"$f":"AM109*0.87","v":0},null,null,{"$f":"COUNTIF(F109:AJ109,\"в\")","v":0},{"$f":"COUNTIF(F109:AJ109,\"о\")","v":0},{"$f":"COUNTIF(F109:AJ109,\"п\")","v":0},{"$f":"COUNTIF(F109:AJ109,\"к*\")","v":0},{"$f":"COUNTIF(F109:AJ109,\"а\")","v":0},{"$f":"COUNTIF(F109:AJ109,\"б\")","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,{"$f":"COUNTIF(F110:AJ110,\"бв\")","v":0},{"$f":"COUNTIF(F110:AJ110,\"бв\")","v":0},{"$f":"COUNTIF(F110:AJ110,\"а\")","v":0},{"$f":"COUNTIF(F110:AJ110,\"и\")","v":0}]
[51,{"$f":"INDEX(Список!$B$2:$AZ$71,$A111,MATCH($B$10,отд,0))","v":"Янкин Ярослав Александрович"},{"$f":"INDEX(Список!$B$2:$AZ$71,$A111,MATCH($B$10,отд,0)+1)","v":"Электромонтажник 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,{"$f":"COUNTIF(F111:AJ111,\">=4\")+COUNTIF(F111:AJ111,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F111:AJ111))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F111:AJ111)))","v":0},null,{"$f":"AM111*0.87","v":0},null,null,{"$f":"COUNTIF(F111:AJ111,\"в\")","v":0},{"$f":"COUNTIF(F111:AJ111,\"о\")","v":0},{"$f":"COUNTIF(F111:AJ111,\"п\")","v":0},{"$f":"COUNTIF(F111:AJ111,\"к*\")","v":0},{"$f":"COUNTIF(F111:AJ111,\"а\")","v":0},{"$f":"COUNTIF(F111:AJ111,\"б\")","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,{"$f":"COUNTIF(F112:AJ112,\"бв\")","v":0},{"$f":"COUNTIF(F112:AJ112,\"бв\")","v":0},{"$f":"COUNTIF(F112:AJ112,\"а\")","v":0},{"$f":"COUNTIF(F112:AJ112,\"и\")","v":0}]
[52,{"$f":"INDEX(Список!$B$2:$AZ$71,$A113,MATCH($B$10,отд,0))","v":0},{"$f":"INDEX(Список!$B$2:$AZ$71,$A113,MATCH($B$10,отд,0)+1)","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,{"$f":"COUNTIF(F113:AJ113,\">=4\")+COUNTIF(F113:AJ113,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F113:AJ113))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F113:AJ113)))","v":0},null,{"$f":"AM113*0.87","v":0},null,null,{"$f":"COUNTIF(F113:AJ113,\"в\")","v":0},{"$f":"COUNTIF(F113:AJ113,\"о\")","v":0},{"$f":"COUNTIF(F113:AJ113,\"п\")","v":0},{"$f":"COUNTIF(F113:AJ113,\"к*\")","v":0},{"$f":"COUNTIF(F113:AJ113,\"а\")","v":0},{"$f":"COUNTIF(F113:AJ113,\"б\")","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,{"$f":"COUNTIF(F114:AJ114,\"бв\")","v":0},{"$f":"COUNTIF(F114:AJ114,\"бв\")","v":0},{"$f":"COUNTIF(F114:AJ114,\"а\")","v":0},{"$f":"COUNTIF(F114:AJ114,\"и\")","v":0}]
[53,{"$f":"INDEX(Список!$B$2:$AZ$71,$A115,MATCH($B$10,отд,0))","v":0},{"$f":"INDEX(Список!$B$2:$AZ$71,$A115,MATCH($B$10,отд,0)+1)","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,{"$f":"COUNTIF(F115:AJ115,\">=4\")+COUNTIF(F115:AJ115,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F115:AJ115))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F115:AJ115)))","v":0},null,{"$f":"AM115*0.87","v":0},null,null,{"$f":"COUNTIF(F115:AJ115,\"в\")","v":0},{"$f":"COUNTIF(F115:AJ115,\"о\")","v":0},{"$f":"COUNTIF(F115:AJ115,\"п\")","v":0},{"$f":"COUNTIF(F115:AJ115,\"к*\")","v":0},{"$f":"COUNTIF(F115:AJ115,\"а\")","v":0},{"$f":"COUNTIF(F115:AJ115,\"б\")","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,{"$f":"COUNTIF(F116:AJ116,\"бв\")","v":0},{"$f":"COUNTIF(F116:AJ116,\"бв\")","v":0},{"$f":"COUNTIF(F116:AJ116,\"а\")","v":0},{"$f":"COUNTIF(F116:AJ116,\"и\")","v":0}]
[54,{"$f":"INDEX(Список!$B$2:$AZ$71,$A117,MATCH($B$10,отд,0))","v":0},{"$f":"INDEX(Список!$B$2:$AZ$71,$A117,MATCH($B$10,отд,0)+1)","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,{"$f":"COUNTIF(F117:AJ117,\">=4\")+COUNTIF(F117:AJ117,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F117:AJ117))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F117:AJ117)))","v":0},null,{"$f":"AM117*0.87","v":0},null,null,{"$f":"COUNTIF(F117:AJ117,\"в\")","v":0},{"$f":"COUNTIF(F117:AJ117,\"о\")","v":0},{"$f":"COUNTIF(F117:AJ117,\"п\")","v":0},{"$f":"COUNTIF(F117:AJ117,\"к*\")","v":0},{"$f":"COUNTIF(F117:AJ117,\"а\")","v":0},{"$f":"COUNTIF(F117:AJ117,\"б\")","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,{"$f":"COUNTIF(F118:AJ118,\"бв\")","v":0},{"$f":"COUNTIF(F118:AJ118,\"бв\")","v":0},{"$f":"COUNTIF(F118:AJ118,\"а\")","v":0},{"$f":"COUNTIF(F118:AJ118,\"и\")","v":0}]
[55,{"$f":"INDEX(Список!$B$2:$AZ$71,$A119,MATCH($B$10,отд,0))","v":0},{"$f":"INDEX(Список!$B$2:$AZ$71,$A119,MATCH($B$10,отд,0)+1)","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,{"$f":"COUNTIF(F119:AJ119,\">=4\")+COUNTIF(F119:AJ119,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F119:AJ119))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F119:AJ119)))","v":0},null,{"$f":"AM119*0.87","v":0},null,null,{"$f":"COUNTIF(F119:AJ119,\"в\")","v":0},{"$f":"COUNTIF(F119:AJ119,\"о\")","v":0},{"$f":"COUNTIF(F119:AJ119,\"п\")","v":0},{"$f":"COUNTIF(F119:AJ119,\"к*\")","v":0},{"$f":"COUNTIF(F119:AJ119,\"а\")","v":0},{"$f":"COUNTIF(F119:AJ119,\"б\")","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,{"$f":"COUNTIF(F120:AJ120,\"бв\")","v":0},{"$f":"COUNTIF(F120:AJ120,\"бв\")","v":0},{"$f":"COUNTIF(F120:AJ120,\"а\")","v":0},{"$f":"COUNTIF(F120:AJ120,\"и\")","v":0}]
[56,{"$f":"INDEX(Список!$B$2:$AZ$71,$A121,MATCH($B$10,отд,0))","v":0},{"$f":"INDEX(Список!$B$2:$AZ$71,$A121,MATCH($B$10,отд,0)+1)","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,{"$f":"COUNTIF(F121:AJ121,\">=4\")+COUNTIF(F121:AJ121,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F121:AJ121))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F121:AJ121)))","v":0},null,{"$f":"AM121*0.87","v":0},null,null,{"$f":"COUNTIF(F121:AJ121,\"в\")","v":0},{"$f":"COUNTIF(F121:AJ121,\"о\")","v":0},{"$f":"COUNTIF(F121:AJ121,\"п\")","v":0},{"$f":"COUNTIF(F121:AJ121,\"к*\")","v":0},{"$f":"COUNTIF(F121:AJ121,\"а\")","v":0},{"$f":"COUNTIF(F121:AJ121,\"б\")","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,{"$f":"COUNTIF(F122:AJ122,\"бв\")","v":0},{"$f":"COUNTIF(F122:AJ122,\"бв\")","v":0},{"$f":"COUNTIF(F122:AJ122,\"а\")","v":0},{"$f":"COUNTIF(F122:AJ122,\"и\")","v":0}]
[57,{"$f":"INDEX(Список!$B$2:$AZ$71,$A123,MATCH($B$10,отд,0))","v":0},{"$f":"INDEX(Список!$B$2:$AZ$71,$A123,MATCH($B$10,отд,0)+1)","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,{"$f":"COUNTIF(F123:AJ123,\">=4\")+COUNTIF(F123:AJ123,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F123:AJ123))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F123:AJ123)))","v":0},null,{"$f":"AM123*0.87","v":0},null,null,{"$f":"COUNTIF(F123:AJ123,\"в\")","v":0},{"$f":"COUNTIF(F123:AJ123,\"о\")","v":0},{"$f":"COUNTIF(F123:AJ123,\"п\")","v":0},{"$f":"COUNTIF(F123:AJ123,\"к*\")","v":0},{"$f":"COUNTIF(F123:AJ123,\"а\")","v":0},{"$f":"COUNTIF(F123:AJ123,\"б\")","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,{"$f":"COUNTIF(F124:AJ124,\"бв\")","v":0},{"$f":"COUNTIF(F124:AJ124,\"бв\")","v":0},{"$f":"COUNTIF(F124:AJ124,\"а\")","v":0},{"$f":"COUNTIF(F124:AJ124,\"и\")","v":0}]
[58,{"$f":"INDEX(Список!$B$2:$AZ$71,$A125,MATCH($B$10,отд,0))","v":0},{"$f":"INDEX(Список!$B$2:$AZ$71,$A125,MATCH($B$10,отд,0)+1)","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,{"$f":"COUNTIF(F125:AJ125,\">=4\")+COUNTIF(F125:AJ125,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F125:AJ125))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F125:AJ125)))","v":0},null,{"$f":"AM125*0.87","v":0},null,null,{"$f":"COUNTIF(F125:AJ125,\"в\")","v":0},{"$f":"COUNTIF(F125:AJ125,\"о\")","v":0},{"$f":"COUNTIF(F125:AJ125,\"п\")","v":0},{"$f":"COUNTIF(F125:AJ125,\"к*\")","v":0},{"$f":"COUNTIF(F125:AJ125,\"а\")","v":0},{"$f":"COUNTIF(F125:AJ125,\"б\")","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,{"$f":"COUNTIF(F126:AJ126,\"бв\")","v":0},{"$f":"COUNTIF(F126:AJ126,\"бв\")","v":0},{"$f":"COUNTIF(F126:AJ126,\"а\")","v":0},{"$f":"COUNTIF(F126:AJ126,\"и\")","v":0}]
[59,{"$f":"INDEX(Список!$B$2:$AZ$71,$A127,MATCH($B$10,отд,0))","v":0},{"$f":"INDEX(Список!$B$2:$AZ$71,$A127,MATCH($B$10,отд,0)+1)","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,{"$f":"COUNTIF(F127:AJ127,\">=4\")+COUNTIF(F127:AJ127,\"к*\")","v":0},{"$f":"IF(ISNA(SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F127:AJ127))),0,SUM(ИЗВЛЕЧЬЦЕЛЫЕ(F127:AJ127)))","v":0},null,{"$f":"AM127*0.87","v":0},null,null,{"$f":"COUNTIF(F127:AJ127,\"в\")","v":0},{"$f":"COUNTIF(F127:AJ127,\"о\")","v":0},{"$f":"COUNTIF(F127:AJ127,\"п\")","v":0},{"$f":"COUNTIF(F127:AJ127,\"к*\")","v":0},{"$f":"COUNTIF(F127:AJ127,\"а\")","v":0},{"$f":"COUNTIF(F127:AJ127,\"б\")","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,{"$f":"COUNTIF(F128:AJ128,\"бв\")","v":0},{"$f":"COUNTIF(F128:AJ128,\"бв\")","v":0},{"$f":"COUNTIF(F128:AJ128,\"а\")","v":0},{"$f":"COUNTIF(F128:AJ128,\"и\")","v":0}]
[]
[]
[]
[]
[null,"Статистика:"]
[null,"Количество рабочих дней в месяце",null,null,null,{"$f":"NETWORKDAYS(F7,EOMONTH(F7,0),Праздники)","v":16}]
[null,"Численность электромонтажников (по табелю):",null,null,null,{"$f":"COUNTIF(C11:C128,\"*монтажник*\")","v":43}]
[null,"Зарплата всех электромонтажников",null,null,null,{"$f":"SUMIF(C11:C128,\"*монтажник*\",AN11:AN128)","v":48383.31}]
[null,"Численность электромонтажников отработавших полный месяц",null,null,null,{"$f":"COUNTIFS(C11:C128,\"*монтажник*\",AK11:AK128,F134)","v":3}]
[null,"Заработная плата электромонтажников отработавших полный месяц",null,null,null,{"$f":"SUMIFS(AN11:AN128,C11:C128,\"*монтажник*\",AK11:AK128,F134)","v":19375.77}]
[null,"Средняя зарплата одного электромонтажника отработавшего полный месяц",null,null,null,{"$f":"F138/F137","v":6458.59}]
[null,"Количество человеко-часов за полный месяц",null,null,null,{"$f":"SUMIFS(AL11:AL128,C11:C128,\"*монтажник*\",AK11:AK128,F134)","v":261}]
[null,"Стоимость 1 чел/час за полный месяц",null,null,null,{"$f":"F138/F140","v":74.236666666666665}]
[null,"Средняя продолжительность рабочего дня за полный месяц",null,null,null,{"$f":"F140/(F137*F134)","v":5.4375}]
[null,"Интервал трудозатратности, час",null,null,null,{"$f":"\"От \"&MIN(AL11:AL128)&\" до \"&MAX(AL11:AL128)","v":"От 0 до 133"}]
[null,"Минимальная зарплата за полный месяц",null,null,null,{"$f":"MIN(IF(ISNUMBER(SEARCH(\"Электромонтажник\",C$11:C$128))*(AK$11:AK$128=NETWORKDAYS(F7,EOMONTH(F7,0),Праздники)),AM$11:AM$128))","v":5}]
[null,null,null,null,null,{"$f":"INDEX(B$1:B$128,MIN(IF(ISNUMBER(SEARCH(\"Электромонтажник\",C$11:C$128))*(AK$11:AK$128=NETWORKDAYS(F7,EOMONTH(F7,0),Праздники))*(F144=AM$11:AM$128),ROW(C$11:C$128))))","v":"Розенбах Денис Сергеевич"}]

{"sheet":"Лист1","index":2,"n_rows":24,"n_cols":34,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":"УПРАВЛЕНИЕ"}]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":"Отдел управления персоналом"},null,"Праздники",null,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]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":"БУХГАЛТЕРИЯ"},null,"2012-01-01"]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":"Отдел материально-технического снабжения"},null,"2012-01-02"]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":"Отдел автоматизации систем управления"},null,"2012-01-03"]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":"Производственно-технический отдел"},null,"2012-01-04"]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":"Сметно-договорной отдел"},null,"2012-01-05"]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":"Автотранспортный участок"},null,"2012-01-06"]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":"Отдел охраны труда и техники безопасности"},null,"2012-01-07"]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":"Административно-хозяйственный участок"},null,"2012-01-09"]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":"Томский электромонтажный участок"},null,"2012-02-23"]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":"Б электромонтажный участок"},null,"2012-03-08"]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":0},null,"2012-03-09"]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":0},null,"2012-04-30"]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":0},null,"2012-05-01"]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":0},null,"2012-05-07"]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":0},null,"2012-05-08"]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":0},null,"2012-05-09"]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":0},null,"2012-06-11"]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":0},null,"2012-06-12"]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":0},null,"2012-11-04"]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":0},null,"2012-11-05"]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":0},null,"2012-12-31"]
[{"$f":"INDEX(Список!$B$1:$AZ$1,(ROW()-1)*2+1)","v":0}]