{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Останов","БДМ№1","БДМ№2","Всего по сменам","Формулы","Список"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":17,"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":45,"n_cols":36,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,35,3,35],[0,14,0,30],[2,1,3,1],[2,4,2,34],[44,18,44,21],[44,22,44,26],[2,2,3,3],[44,8,44,13],[0,8,0,13],[0,1,0,2],[19,7,25,15]]}
[null,null,null,null,null,null,null,null,"Останов БДМ",null,null,null,null,null,"Для бригадного расчёта",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"бумажный цех"]
[]
[null,"Таб№","Фамилия, Имя, Отчество",null,"Отработано часов по числам месяца",null,null,null,null,null,null,null,null,null,null,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,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,{"$f":"IFERROR(VLOOKUP(C5,Список!$B$2:$C$150,2,0),\"\")","v":465},{"$f":"IFERROR(f(ROW(A1),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":"Рудницкий С.Н."},{"$f":"IFERROR(f(ROW(B1),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","v":"Разм. брака 2 р."},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,{"$f":"SUM(IF(RIGHTB(D5)=\"%\",TEXT(INDEX(E$5:AI5,MATCH(LEFTB(C5,SEARCH(\"%\",D5)),(C$5:C5),),),\"0;0;12\")*E5:AI5%,E5:AI5))","v":1}]
[null,{"$f":"IFERROR(VLOOKUP(C6,Список!$B$2:$C$150,2,0),\"\")","v":465},{"$f":"IFERROR(f(ROW(A2),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":"Рудницкий С.Н."},{"$f":"IFERROR(f(ROW(B2),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","v":"Разм. брака 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,{"$f":"SUM(IF(RIGHTB(D6)=\"%\",TEXT(INDEX(E$5:AI6,MATCH(LEFTB(C6,SEARCH(\"%\",D6)),(C$5:C6),),),\"0;0;12\")*E6:AI6%,E6:AI6))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C7,Список!$B$2:$C$150,2,0),\"\")","v":761},{"$f":"IFERROR(f(ROW(A3),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":"Сацук А.Л."},{"$f":"IFERROR(f(ROW(B3),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D7)=\"%\",TEXT(INDEX(E$5:AI7,MATCH(LEFTB(C7,SEARCH(\"%\",D7)),(C$5:C7),),),\"0;0;12\")*E7:AI7%,E7:AI7))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C8,Список!$B$2:$C$150,2,0),\"\")","v":761},{"$f":"IFERROR(f(ROW(A4),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":"Сацук А.Л."},{"$f":"IFERROR(f(ROW(B4),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D8)=\"%\",TEXT(INDEX(E$5:AI8,MATCH(LEFTB(C8,SEARCH(\"%\",D8)),(C$5:C8),),),\"0;0;12\")*E8:AI8%,E8:AI8))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C9,Список!$B$2:$C$150,2,0),\"\")","v":643},{"$f":"IFERROR(f(ROW(A5),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":"Буракова Т.А."},{"$f":"IFERROR(f(ROW(B5),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D9)=\"%\",TEXT(INDEX(E$5:AI9,MATCH(LEFTB(C9,SEARCH(\"%\",D9)),(C$5:C9),),),\"0;0;12\")*E9:AI9%,E9:AI9))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C10,Список!$B$2:$C$150,2,0),\"\")","v":1179},{"$f":"IFERROR(f(ROW(A6),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":"Брикун М.А."},{"$f":"IFERROR(f(ROW(B6),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D10)=\"%\",TEXT(INDEX(E$5:AI10,MATCH(LEFTB(C10,SEARCH(\"%\",D10)),(C$5:C10),),),\"0;0;12\")*E10:AI10%,E10:AI10))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C11,Список!$B$2:$C$150,2,0),\"\")","v":1179},{"$f":"IFERROR(f(ROW(A7),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":"Брикун М.А."},{"$f":"IFERROR(f(ROW(B7),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D11)=\"%\",TEXT(INDEX(E$5:AI11,MATCH(LEFTB(C11,SEARCH(\"%\",D11)),(C$5:C11),),),\"0;0;12\")*E11:AI11%,E11:AI11))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C12,Список!$B$2:$C$150,2,0),\"\")","v":1291},{"$f":"IFERROR(f(ROW(A8),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":"Лысковец А.Н."},{"$f":"IFERROR(f(ROW(B8),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D12)=\"%\",TEXT(INDEX(E$5:AI12,MATCH(LEFTB(C12,SEARCH(\"%\",D12)),(C$5:C12),),),\"0;0;12\")*E12:AI12%,E12:AI12))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C13,Список!$B$2:$C$150,2,0),\"\")","v":1379},{"$f":"IFERROR(f(ROW(A9),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":"Кадевич О.В."},{"$f":"IFERROR(f(ROW(B9),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","v":"Маш.уп. маш. 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,{"$f":"SUM(IF(RIGHTB(D13)=\"%\",TEXT(INDEX(E$5:AI13,MATCH(LEFTB(C13,SEARCH(\"%\",D13)),(C$5:C13),),),\"0;0;12\")*E13:AI13%,E13:AI13))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C14,Список!$B$2:$C$150,2,0),\"\")","v":589},{"$f":"IFERROR(f(ROW(A10),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":"Хомич Н.Н."},{"$f":"IFERROR(f(ROW(B10),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","v":"Маш.уп. маш. 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,{"$f":"SUM(IF(RIGHTB(D14)=\"%\",TEXT(INDEX(E$5:AI14,MATCH(LEFTB(C14,SEARCH(\"%\",D14)),(C$5:C14),),),\"0;0;12\")*E14:AI14%,E14:AI14))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C15,Список!$B$2:$C$150,2,0),\"\")","v":589},{"$f":"IFERROR(f(ROW(A11),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":"Хомич Н.Н."},{"$f":"IFERROR(f(ROW(B11),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D15)=\"%\",TEXT(INDEX(E$5:AI15,MATCH(LEFTB(C15,SEARCH(\"%\",D15)),(C$5:C15),),),\"0;0;12\")*E15:AI15%,E15:AI15))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C16,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A12),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":""},{"$f":"IFERROR(f(ROW(B12),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D16)=\"%\",TEXT(INDEX(E$5:AI16,MATCH(LEFTB(C16,SEARCH(\"%\",D16)),(C$5:C16),),),\"0;0;12\")*E16:AI16%,E16:AI16))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C17,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A13),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":""},{"$f":"IFERROR(f(ROW(B13),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D17)=\"%\",TEXT(INDEX(E$5:AI17,MATCH(LEFTB(C17,SEARCH(\"%\",D17)),(C$5:C17),),),\"0;0;12\")*E17:AI17%,E17:AI17))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C18,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A14),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":""},{"$f":"IFERROR(f(ROW(B14),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D18)=\"%\",TEXT(INDEX(E$5:AI18,MATCH(LEFTB(C18,SEARCH(\"%\",D18)),(C$5:C18),),),\"0;0;12\")*E18:AI18%,E18:AI18))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C19,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A15),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":""},{"$f":"IFERROR(f(ROW(B15),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D19)=\"%\",TEXT(INDEX(E$5:AI19,MATCH(LEFTB(C19,SEARCH(\"%\",D19)),(C$5:C19),),),\"0;0;12\")*E19:AI19%,E19:AI19))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C20,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A16),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":""},{"$f":"IFERROR(f(ROW(B16),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","v":""},null,null,null,"на этот лист копируется весь список фамилий с листа БДМ№1 и БДМ№2 кроме фамилий у которых профессия заканчивается знаком \"%\". Строки которых быть не должно подсвечены красным цветом.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D20)=\"%\",TEXT(INDEX(E$5:AI20,MATCH(LEFTB(C20,SEARCH(\"%\",D20)),(C$5:C20),),),\"0;0;12\")*E20:AI20%,E20:AI20))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C21,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A17),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":""},{"$f":"IFERROR(f(ROW(B17),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D21)=\"%\",TEXT(INDEX(E$5:AI21,MATCH(LEFTB(C21,SEARCH(\"%\",D21)),(C$5:C21),),),\"0;0;12\")*E21:AI21%,E21:AI21))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C22,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A18),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":""},{"$f":"IFERROR(f(ROW(B18),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D22)=\"%\",TEXT(INDEX(E$5:AI22,MATCH(LEFTB(C22,SEARCH(\"%\",D22)),(C$5:C22),),),\"0;0;12\")*E22:AI22%,E22:AI22))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C23,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A19),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":""},{"$f":"IFERROR(f(ROW(B19),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D23)=\"%\",TEXT(INDEX(E$5:AI23,MATCH(LEFTB(C23,SEARCH(\"%\",D23)),(C$5:C23),),),\"0;0;12\")*E23:AI23%,E23:AI23))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C24,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A20),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":""},{"$f":"IFERROR(f(ROW(B20),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D24)=\"%\",TEXT(INDEX(E$5:AI24,MATCH(LEFTB(C24,SEARCH(\"%\",D24)),(C$5:C24),),),\"0;0;12\")*E24:AI24%,E24:AI24))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C25,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A21),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":""},{"$f":"IFERROR(f(ROW(B21),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D25)=\"%\",TEXT(INDEX(E$5:AI25,MATCH(LEFTB(C25,SEARCH(\"%\",D25)),(C$5:C25),),),\"0;0;12\")*E25:AI25%,E25:AI25))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C26,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A22),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":""},{"$f":"IFERROR(f(ROW(B22),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D26)=\"%\",TEXT(INDEX(E$5:AI26,MATCH(LEFTB(C26,SEARCH(\"%\",D26)),(C$5:C26),),),\"0;0;12\")*E26:AI26%,E26:AI26))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C27,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A23),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":""},{"$f":"IFERROR(f(ROW(B23),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D27)=\"%\",TEXT(INDEX(E$5:AI27,MATCH(LEFTB(C27,SEARCH(\"%\",D27)),(C$5:C27),),),\"0;0;12\")*E27:AI27%,E27:AI27))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C28,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A24),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":""},{"$f":"IFERROR(f(ROW(B24),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D28)=\"%\",TEXT(INDEX(E$5:AI28,MATCH(LEFTB(C28,SEARCH(\"%\",D28)),(C$5:C28),),),\"0;0;12\")*E28:AI28%,E28:AI28))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C29,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A25),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":""},{"$f":"IFERROR(f(ROW(B25),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D29)=\"%\",TEXT(INDEX(E$5:AI29,MATCH(LEFTB(C29,SEARCH(\"%\",D29)),(C$5:C29),),),\"0;0;12\")*E29:AI29%,E29:AI29))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C30,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A26),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91),\"\")","v":""},{"$f":"IFERROR(f(ROW(B26),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D30)=\"%\",TEXT(INDEX(E$5:AI30,MATCH(LEFTB(C30,SEARCH(\"%\",D30)),(C$5:C30),),),\"0;0;12\")*E30:AI30%,E30:AI30))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C31,Список!$B$2:$C$150,2,0),\"\")","v":300},{"$f":"IFERROR(f(ROW(A1),БДМ№2!$C$5:$C$43,БДМ№2!$C$53:$C$91),\"\")","v":"Мишук Р.В."},{"$f":"IFERROR(f(ROW(B1),БДМ№2!$D$5:$D$43,БДМ№2!$D$53:$D$91),\"\")","v":"Машинист 6 р."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D31)=\"%\",TEXT(INDEX(E$5:AI31,MATCH(LEFTB(C31,SEARCH(\"%\",D31)),(C$5:C31),),),\"0;0;12\")*E31:AI31%,E31:AI31))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C32,Список!$B$2:$C$150,2,0),\"\")","v":300},{"$f":"IFERROR(f(ROW(A2),БДМ№2!$C$5:$C$43,БДМ№2!$C$53:$C$91),\"\")","v":"Мишук Р.В."},{"$f":"IFERROR(f(ROW(B2),БДМ№2!$D$5:$D$43,БДМ№2!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D32)=\"%\",TEXT(INDEX(E$5:AI32,MATCH(LEFTB(C32,SEARCH(\"%\",D32)),(C$5:C32),),),\"0;0;12\")*E32:AI32%,E32:AI32))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C33,Список!$B$2:$C$150,2,0),\"\")","v":2108},{"$f":"IFERROR(f(ROW(A3),БДМ№2!$C$5:$C$43,БДМ№2!$C$53:$C$91),\"\")","v":"Макрицкий Ю.В."},{"$f":"IFERROR(f(ROW(B3),БДМ№2!$D$5:$D$43,БДМ№2!$D$53:$D$91),\"\")","v":"Машинист 6 р."}]
[null,{"$f":"IFERROR(VLOOKUP(C34,Список!$B$2:$C$150,2,0),\"\")","v":2108},{"$f":"IFERROR(f(ROW(A4),БДМ№2!$C$5:$C$43,БДМ№2!$C$53:$C$91),\"\")","v":"Макрицкий Ю.В."},{"$f":"IFERROR(f(ROW(B4),БДМ№2!$D$5:$D$43,БДМ№2!$D$53:$D$91),\"\")","v":"Маш.уп. маш. 2 р. %"}]
[null,{"$f":"IFERROR(VLOOKUP(C35,Список!$B$2:$C$150,2,0),\"\")","v":338},{"$f":"IFERROR(f(ROW(A5),БДМ№2!$C$5:$C$43,БДМ№2!$C$53:$C$91),\"\")","v":"Романчук В.В."},{"$f":"IFERROR(f(ROW(B5),БДМ№2!$D$5:$D$43,БДМ№2!$D$53:$D$91),\"\")","v":"Разм. РПО 5 р."}]
[null,{"$f":"IFERROR(VLOOKUP(C36,Список!$B$2:$C$150,2,0),\"\")","v":338},{"$f":"IFERROR(f(ROW(A6),БДМ№2!$C$5:$C$43,БДМ№2!$C$53:$C$91),\"\")","v":"Романчук В.В."},{"$f":"IFERROR(f(ROW(B6),БДМ№2!$D$5:$D$43,БДМ№2!$D$53:$D$91),\"\")","v":"Разм. РПО 4 р. %"}]
[null,{"$f":"IFERROR(VLOOKUP(C37,Список!$B$2:$C$150,2,0),\"\")","v":2255},{"$f":"IFERROR(f(ROW(A7),БДМ№2!$C$5:$C$43,БДМ№2!$C$53:$C$91),\"\")","v":"Петровых В.В."},{"$f":"IFERROR(f(ROW(B7),БДМ№2!$D$5:$D$43,БДМ№2!$D$53:$D$91),\"\")","v":"Резчик ПРС 4 р."}]
[null,{"$f":"IFERROR(VLOOKUP(C38,Список!$B$2:$C$150,2,0),\"\")","v":2255},{"$f":"IFERROR(f(ROW(A8),БДМ№2!$C$5:$C$43,БДМ№2!$C$53:$C$91),\"\")","v":"Петровых В.В."},{"$f":"IFERROR(f(ROW(B8),БДМ№2!$D$5:$D$43,БДМ№2!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D38)=\"%\",TEXT(INDEX(E$5:AI38,MATCH(LEFTB(C38,SEARCH(\"%\",D38)),(C$5:C38),),),\"0;0;12\")*E38:AI38%,E38:AI38))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C39,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A9),БДМ№2!$C$5:$C$43,БДМ№2!$C$53:$C$91),\"\")","v":""},{"$f":"IFERROR(f(ROW(B9),БДМ№2!$D$5:$D$43,БДМ№2!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D39)=\"%\",TEXT(INDEX(E$5:AI39,MATCH(LEFTB(C39,SEARCH(\"%\",D39)),(C$5:C39),),),\"0;0;12\")*E39:AI39%,E39:AI39))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C40,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A10),БДМ№2!$C$5:$C$43,БДМ№2!$C$53:$C$91),\"\")","v":""},{"$f":"IFERROR(f(ROW(B10),БДМ№2!$D$5:$D$43,БДМ№2!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D40)=\"%\",TEXT(INDEX(E$5:AI40,MATCH(LEFTB(C40,SEARCH(\"%\",D40)),(C$5:C40),),),\"0;0;12\")*E40:AI40%,E40:AI40))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C41,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A11),БДМ№2!$C$5:$C$43,БДМ№2!$C$53:$C$91),\"\")","v":""},{"$f":"IFERROR(f(ROW(B11),БДМ№2!$D$5:$D$43,БДМ№2!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D34)=\"%\",TEXT(INDEX(E$5:AI41,MATCH(LEFTB(C34,SEARCH(\"%\",D34)),(C$5:C40),),),\"0;0;12\")*E41:AI41%,E41:AI41))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C42,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A12),БДМ№2!$C$5:$C$43,БДМ№2!$C$53:$C$91),\"\")","v":""},{"$f":"IFERROR(f(ROW(B12),БДМ№2!$D$5:$D$43,БДМ№2!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D42)=\"%\",TEXT(INDEX(E$5:AI42,MATCH(LEFTB(C42,SEARCH(\"%\",D42)),(C$5:C42),),),\"0;0;12\")*E42:AI42%,E42:AI42))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C43,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A13),БДМ№2!$C$5:$C$43,БДМ№2!$C$53:$C$91),\"\")","v":""},{"$f":"IFERROR(f(ROW(B13),БДМ№2!$D$5:$D$43,БДМ№2!$D$53:$D$91),\"\")","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,{"$f":"SUM(IF(RIGHTB(D43)=\"%\",TEXT(INDEX(E$5:AI43,MATCH(LEFTB(C43,SEARCH(\"%\",D43)),(C$5:C43),),),\"0;0;12\")*E43:AI43%,E43:AI43))","v":0}]
[]
[null,null,null,null,"Мастер смены:",null,null,null,null,null,null,null,null,null,"___________",null,null,null,{"$f":"TODAY()","v":"2015-06-15"}]

{"sheet":"БДМ№1","index":1,"n_rows":93,"n_cols":36,"rows_kept":93,"cut":false,"hidden":false,"merged":[[48,1,48,2],[48,3,48,7],[48,8,48,13],[48,14,48,30],[50,1,51,1],[50,2,51,3],[50,4,50,34],[0,8,0,13],[0,14,0,30],[50,35,51,35],[92,8,92,13],[92,18,92,21],[92,22,92,26],[2,1,3,1],[2,2,3,3],[2,4,2,34],[2,35,3,35],[44,8,44,13],[44,18,44,21],[44,22,44,26]]}
[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,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,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,{"$f":"IFERROR(VLOOKUP(C5,Список!$B$2:$C$150,2,0),\"\")","v":465},"Рудницкий С.Н.","Разм. брака 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,{"$f":"SUM(IF(RIGHTB(D5)=\"%\",TEXT(INDEX(E$5:AI5,MATCH(LEFTB(C5,SEARCH(\"%\",D5)),(C$5:C5),),),\"0;0;12\")*E5:AI5%,E5:AI5))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C6,Список!$B$2:$C$150,2,0),\"\")","v":465},"Рудницкий С.Н.","Разм. брака 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,{"$f":"SUM(IF(RIGHTB(D6)=\"%\",TEXT(INDEX(E$5:AI6,MATCH(LEFTB(C6,SEARCH(\"%\",D6)),(C$5:C6),),),\"0;0;12\")*E6:AI6%,E6:AI6))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C7,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D7)=\"%\",TEXT(INDEX(E$5:AI7,MATCH(LEFTB(C7,SEARCH(\"%\",D7)),(C$5:C7),),),\"0;0;12\")*E7:AI7%,E7:AI7))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C8,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D8)=\"%\",TEXT(INDEX(E$5:AI8,MATCH(LEFTB(C8,SEARCH(\"%\",D8)),(C$5:C8),),),\"0;0;12\")*E8:AI8%,E8:AI8))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C9,Список!$B$2:$C$150,2,0),\"\")","v":761},"Сацук А.Л.","Ап.пр.хим.р-в 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,{"$f":"SUM(IF(RIGHTB(D9)=\"%\",TEXT(INDEX(E$5:AI9,MATCH(LEFTB(C9,SEARCH(\"%\",D9)),(C$5:C9),),),\"0;0;12\")*E9:AI9%,E9:AI9))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C10,Список!$B$2:$C$150,2,0),\"\")","v":761},"Сацук А.Л.","Ап.пр.хим.р-в 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,{"$f":"SUM(IF(RIGHTB(D10)=\"%\",TEXT(INDEX(E$5:AI10,MATCH(LEFTB(C10,SEARCH(\"%\",D10)),(C$5:C10),),),\"0;0;12\")*E10:AI10%,E10:AI10))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C11,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D11)=\"%\",TEXT(INDEX(E$5:AI11,MATCH(LEFTB(C11,SEARCH(\"%\",D11)),(C$5:C11),),),\"0;0;12\")*E11:AI11%,E11:AI11))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C12,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D12)=\"%\",TEXT(INDEX(E$5:AI12,MATCH(LEFTB(C12,SEARCH(\"%\",D12)),(C$5:C12),),),\"0;0;12\")*E12:AI12%,E12:AI12))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C13,Список!$B$2:$C$150,2,0),\"\")","v":643},"Буракова Т.А.","Перссовщик 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,{"$f":"SUM(IF(RIGHTB(D13)=\"%\",TEXT(INDEX(E$5:AI13,MATCH(LEFTB(C13,SEARCH(\"%\",D13)),(C$5:C13),),),\"0;0;12\")*E13:AI13%,E13:AI13))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C14,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D14)=\"%\",TEXT(INDEX(E$5:AI14,MATCH(LEFTB(C14,SEARCH(\"%\",D14)),(C$5:C14),),),\"0;0;12\")*E14:AI14%,E14:AI14))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C15,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D15)=\"%\",TEXT(INDEX(E$5:AI15,MATCH(LEFTB(C15,SEARCH(\"%\",D15)),(C$5:C15),),),\"0;0;12\")*E15:AI15%,E15:AI15))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C16,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D16)=\"%\",TEXT(INDEX(E$5:AI16,MATCH(LEFTB(C16,SEARCH(\"%\",D16)),(C$5:C16),),),\"0;0;12\")*E16:AI16%,E16:AI16))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C17,Список!$B$2:$C$150,2,0),\"\")","v":1179},"Брикун М.А.","Сушильщик 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,{"$f":"SUM(IF(RIGHTB(D17)=\"%\",TEXT(INDEX(E$5:AI17,MATCH(LEFTB(C17,SEARCH(\"%\",D17)),(C$5:C17),),),\"0;0;12\")*E17:AI17%,E17:AI17))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C18,Список!$B$2:$C$150,2,0),\"\")","v":1179},"Брикун М.А.","Перссовщик 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,{"$f":"SUM(IF(RIGHTB(D18)=\"%\",TEXT(INDEX(E$5:AI18,MATCH(LEFTB(C18,SEARCH(\"%\",D18)),(C$5:C18),),),\"0;0;12\")*E18:AI18%,E18:AI18))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C19,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D19)=\"%\",TEXT(INDEX(E$5:AI19,MATCH(LEFTB(C19,SEARCH(\"%\",D19)),(C$5:C19),),),\"0;0;12\")*E19:AI19%,E19:AI19))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C20,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D20)=\"%\",TEXT(INDEX(E$5:AI20,MATCH(LEFTB(C20,SEARCH(\"%\",D20)),(C$5:C20),),),\"0;0;12\")*E20:AI20%,E20:AI20))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C21,Список!$B$2:$C$150,2,0),\"\")","v":1291},"Лысковец А.Н.","Накатчик 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,{"$f":"SUM(IF(RIGHTB(D21)=\"%\",TEXT(INDEX(E$5:AI21,MATCH(LEFTB(C21,SEARCH(\"%\",D21)),(C$5:C21),),),\"0;0;12\")*E21:AI21%,E21:AI21))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C22,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D22)=\"%\",TEXT(INDEX(E$5:AI22,MATCH(LEFTB(C22,SEARCH(\"%\",D22)),(C$5:C22),),),\"0;0;12\")*E22:AI22%,E22:AI22))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C23,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D23)=\"%\",TEXT(INDEX(E$5:AI23,MATCH(LEFTB(C23,SEARCH(\"%\",D23)),(C$5:C23),),),\"0;0;12\")*E23:AI23%,E23:AI23))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C24,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D24)=\"%\",TEXT(INDEX(E$5:AI24,MATCH(LEFTB(C24,SEARCH(\"%\",D24)),(C$5:C24),),),\"0;0;12\")*E24:AI24%,E24:AI24))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C25,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D25)=\"%\",TEXT(INDEX(E$5:AI25,MATCH(LEFTB(C25,SEARCH(\"%\",D25)),(C$5:C25),),),\"0;0;12\")*E25:AI25%,E25:AI25))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C26,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D26)=\"%\",TEXT(INDEX(E$5:AI26,MATCH(LEFTB(C26,SEARCH(\"%\",D26)),(C$5:C26),),),\"0;0;12\")*E26:AI26%,E26:AI26))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C27,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D27)=\"%\",TEXT(INDEX(E$5:AI27,MATCH(LEFTB(C27,SEARCH(\"%\",D27)),(C$5:C27),),),\"0;0;12\")*E27:AI27%,E27:AI27))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C28,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D28)=\"%\",TEXT(INDEX(E$5:AI28,MATCH(LEFTB(C28,SEARCH(\"%\",D28)),(C$5:C28),),),\"0;0;12\")*E28:AI28%,E28:AI28))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C29,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D29)=\"%\",TEXT(INDEX(E$5:AI29,MATCH(LEFTB(C29,SEARCH(\"%\",D29)),(C$5:C29),),),\"0;0;12\")*E29:AI29%,E29:AI29))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C30,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D30)=\"%\",TEXT(INDEX(E$5:AI30,MATCH(LEFTB(C30,SEARCH(\"%\",D30)),(C$5:C30),),),\"0;0;12\")*E30:AI30%,E30:AI30))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C31,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D31)=\"%\",TEXT(INDEX(E$5:AI31,MATCH(LEFTB(C31,SEARCH(\"%\",D31)),(C$5:C31),),),\"0;0;12\")*E31:AI31%,E31:AI31))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C32,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D32)=\"%\",TEXT(INDEX(E$5:AI32,MATCH(LEFTB(C32,SEARCH(\"%\",D32)),(C$5:C32),),),\"0;0;12\")*E32:AI32%,E32:AI32))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C33,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D33)=\"%\",TEXT(INDEX(E$5:AI33,MATCH(LEFTB(C33,SEARCH(\"%\",D33)),(C$5:C33),),),\"0;0;12\")*E33:AI33%,E33:AI33))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C34,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D34)=\"%\",TEXT(INDEX(E$5:AI34,MATCH(LEFTB(C34,SEARCH(\"%\",D34)),(C$5:C34),),),\"0;0;12\")*E34:AI34%,E34:AI34))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C35,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D35)=\"%\",TEXT(INDEX(E$5:AI35,MATCH(LEFTB(C35,SEARCH(\"%\",D35)),(C$5:C35),),),\"0;0;12\")*E35:AI35%,E35:AI35))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C36,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D36)=\"%\",TEXT(INDEX(E$5:AI36,MATCH(LEFTB(C36,SEARCH(\"%\",D36)),(C$5:C36),),),\"0;0;12\")*E36:AI36%,E36:AI36))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C37,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D37)=\"%\",TEXT(INDEX(E$5:AI37,MATCH(LEFTB(C37,SEARCH(\"%\",D37)),(C$5:C37),),),\"0;0;12\")*E37:AI37%,E37:AI37))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C38,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D38)=\"%\",TEXT(INDEX(E$5:AI38,MATCH(LEFTB(C38,SEARCH(\"%\",D38)),(C$5:C38),),),\"0;0;12\")*E38:AI38%,E38:AI38))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C39,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D39)=\"%\",TEXT(INDEX(E$5:AI39,MATCH(LEFTB(C39,SEARCH(\"%\",D39)),(C$5:C39),),),\"0;0;12\")*E39:AI39%,E39:AI39))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C40,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D40)=\"%\",TEXT(INDEX(E$5:AI40,MATCH(LEFTB(C40,SEARCH(\"%\",D40)),(C$5:C40),),),\"0;0;12\")*E40:AI40%,E40:AI40))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C41,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D41)=\"%\",TEXT(INDEX(E$5:AI41,MATCH(LEFTB(C41,SEARCH(\"%\",D41)),(C$5:C41),),),\"0;0;12\")*E41:AI41%,E41:AI41))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C42,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D42)=\"%\",TEXT(INDEX(E$5:AI42,MATCH(LEFTB(C42,SEARCH(\"%\",D42)),(C$5:C42),),),\"0;0;12\")*E42:AI42%,E42:AI42))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C43,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D43)=\"%\",TEXT(INDEX(E$5:AI43,MATCH(LEFTB(C43,SEARCH(\"%\",D43)),(C$5:C43),),),\"0;0;12\")*E43:AI43%,E43:AI43))","v":0}]
[]
[null,null,null,null,"Мастер смены:",null,null,null,null,null,null,null,null,null,"___________",null,null,null,{"$f":"TODAY()","v":"2015-06-15"}]
[]
[]
[]
[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,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,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,{"$f":"IFERROR(VLOOKUP(C53,Список!$B$2:$C$150,2,0),\"\")","v":1379},"Кадевич О.В.","Маш.уп. маш. 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,{"$f":"SUM(IF(RIGHTB(D53)=\"%\",TEXT(INDEX(E$53:AI53,MATCH(LEFTB(C53,SEARCH(\"%\",D53)),(C$53:C53),),),\"0;0;12\")*E53:AI53%,E53:AI53))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C54,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D54)=\"%\",TEXT(INDEX(E$53:AI54,MATCH(LEFTB(C54,SEARCH(\"%\",D54)),(C$53:C54),),),\"0;0;12\")*E54:AI54%,E54:AI54))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C55,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D55)=\"%\",TEXT(INDEX(E$53:AI55,MATCH(LEFTB(C55,SEARCH(\"%\",D55)),(C$53:C55),),),\"0;0;12\")*E55:AI55%,E55:AI55))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C56,Список!$B$2:$C$150,2,0),\"\")","v":589},"Хомич Н.Н.","Маш.уп. маш. 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,{"$f":"SUM(IF(RIGHTB(D56)=\"%\",TEXT(INDEX(E$53:AI56,MATCH(LEFTB(C56,SEARCH(\"%\",D56)),(C$53:C56),),),\"0;0;12\")*E56:AI56%,E56:AI56))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C57,Список!$B$2:$C$150,2,0),\"\")","v":589},"Хомич Н.Н.","Ап.пр.хим.р-в 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,{"$f":"SUM(IF(RIGHTB(D57)=\"%\",TEXT(INDEX(E$53:AI57,MATCH(LEFTB(C57,SEARCH(\"%\",D57)),(C$53:C57),),),\"0;0;12\")*E57:AI57%,E57:AI57))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C58,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D58)=\"%\",TEXT(INDEX(E$53:AI58,MATCH(LEFTB(C58,SEARCH(\"%\",D58)),(C$53:C58),),),\"0;0;12\")*E58:AI58%,E58:AI58))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C59,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D59)=\"%\",TEXT(INDEX(E$53:AI59,MATCH(LEFTB(C59,SEARCH(\"%\",D59)),(C$53:C59),),),\"0;0;12\")*E59:AI59%,E59:AI59))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C60,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D60)=\"%\",TEXT(INDEX(E$53:AI60,MATCH(LEFTB(C60,SEARCH(\"%\",D60)),(C$53:C60),),),\"0;0;12\")*E60:AI60%,E60:AI60))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C61,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D61)=\"%\",TEXT(INDEX(E$53:AI61,MATCH(LEFTB(C61,SEARCH(\"%\",D61)),(C$53:C61),),),\"0;0;12\")*E61:AI61%,E61:AI61))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C62,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D62)=\"%\",TEXT(INDEX(E$53:AI62,MATCH(LEFTB(C62,SEARCH(\"%\",D62)),(C$53:C62),),),\"0;0;12\")*E62:AI62%,E62:AI62))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C63,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D63)=\"%\",TEXT(INDEX(E$53:AI63,MATCH(LEFTB(C63,SEARCH(\"%\",D63)),(C$53:C63),),),\"0;0;12\")*E63:AI63%,E63:AI63))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C64,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D64)=\"%\",TEXT(INDEX(E$53:AI64,MATCH(LEFTB(C64,SEARCH(\"%\",D64)),(C$53:C64),),),\"0;0;12\")*E64:AI64%,E64:AI64))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C65,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D65)=\"%\",TEXT(INDEX(E$53:AI65,MATCH(LEFTB(C65,SEARCH(\"%\",D65)),(C$53:C65),),),\"0;0;12\")*E65:AI65%,E65:AI65))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C66,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D66)=\"%\",TEXT(INDEX(E$53:AI66,MATCH(LEFTB(C66,SEARCH(\"%\",D66)),(C$53:C66),),),\"0;0;12\")*E66:AI66%,E66:AI66))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C67,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D67)=\"%\",TEXT(INDEX(E$53:AI67,MATCH(LEFTB(C67,SEARCH(\"%\",D67)),(C$53:C67),),),\"0;0;12\")*E67:AI67%,E67:AI67))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C68,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D68)=\"%\",TEXT(INDEX(E$53:AI68,MATCH(LEFTB(C68,SEARCH(\"%\",D68)),(C$53:C68),),),\"0;0;12\")*E68:AI68%,E68:AI68))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C69,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D69)=\"%\",TEXT(INDEX(E$53:AI69,MATCH(LEFTB(C69,SEARCH(\"%\",D69)),(C$53:C69),),),\"0;0;12\")*E69:AI69%,E69:AI69))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C70,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D70)=\"%\",TEXT(INDEX(E$53:AI70,MATCH(LEFTB(C70,SEARCH(\"%\",D70)),(C$53:C70),),),\"0;0;12\")*E70:AI70%,E70:AI70))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C71,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D71)=\"%\",TEXT(INDEX(E$53:AI71,MATCH(LEFTB(C71,SEARCH(\"%\",D71)),(C$53:C71),),),\"0;0;12\")*E71:AI71%,E71:AI71))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C72,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D72)=\"%\",TEXT(INDEX(E$53:AI72,MATCH(LEFTB(C72,SEARCH(\"%\",D72)),(C$53:C72),),),\"0;0;12\")*E72:AI72%,E72:AI72))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C73,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D73)=\"%\",TEXT(INDEX(E$53:AI73,MATCH(LEFTB(C73,SEARCH(\"%\",D73)),(C$53:C73),),),\"0;0;12\")*E73:AI73%,E73:AI73))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C74,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D74)=\"%\",TEXT(INDEX(E$53:AI74,MATCH(LEFTB(C74,SEARCH(\"%\",D74)),(C$53:C74),),),\"0;0;12\")*E74:AI74%,E74:AI74))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C75,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D75)=\"%\",TEXT(INDEX(E$53:AI75,MATCH(LEFTB(C75,SEARCH(\"%\",D75)),(C$53:C75),),),\"0;0;12\")*E75:AI75%,E75:AI75))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C76,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D76)=\"%\",TEXT(INDEX(E$53:AI76,MATCH(LEFTB(C76,SEARCH(\"%\",D76)),(C$53:C76),),),\"0;0;12\")*E76:AI76%,E76:AI76))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C77,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D77)=\"%\",TEXT(INDEX(E$53:AI77,MATCH(LEFTB(C77,SEARCH(\"%\",D77)),(C$53:C77),),),\"0;0;12\")*E77:AI77%,E77:AI77))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C78,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D78)=\"%\",TEXT(INDEX(E$53:AI78,MATCH(LEFTB(C78,SEARCH(\"%\",D78)),(C$53:C78),),),\"0;0;12\")*E78:AI78%,E78:AI78))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C79,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D79)=\"%\",TEXT(INDEX(E$53:AI79,MATCH(LEFTB(C79,SEARCH(\"%\",D79)),(C$53:C79),),),\"0;0;12\")*E79:AI79%,E79:AI79))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C80,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D80)=\"%\",TEXT(INDEX(E$53:AI80,MATCH(LEFTB(C80,SEARCH(\"%\",D80)),(C$53:C80),),),\"0;0;12\")*E80:AI80%,E80:AI80))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C81,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D81)=\"%\",TEXT(INDEX(E$53:AI81,MATCH(LEFTB(C81,SEARCH(\"%\",D81)),(C$53:C81),),),\"0;0;12\")*E81:AI81%,E81:AI81))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C82,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D82)=\"%\",TEXT(INDEX(E$53:AI82,MATCH(LEFTB(C82,SEARCH(\"%\",D82)),(C$53:C82),),),\"0;0;12\")*E82:AI82%,E82:AI82))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C83,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D83)=\"%\",TEXT(INDEX(E$53:AI83,MATCH(LEFTB(C83,SEARCH(\"%\",D83)),(C$53:C83),),),\"0;0;12\")*E83:AI83%,E83:AI83))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C84,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D84)=\"%\",TEXT(INDEX(E$53:AI84,MATCH(LEFTB(C84,SEARCH(\"%\",D84)),(C$53:C84),),),\"0;0;12\")*E84:AI84%,E84:AI84))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C85,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D85)=\"%\",TEXT(INDEX(E$53:AI85,MATCH(LEFTB(C85,SEARCH(\"%\",D85)),(C$53:C85),),),\"0;0;12\")*E85:AI85%,E85:AI85))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C86,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D86)=\"%\",TEXT(INDEX(E$53:AI86,MATCH(LEFTB(C86,SEARCH(\"%\",D86)),(C$53:C86),),),\"0;0;12\")*E86:AI86%,E86:AI86))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C87,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D87)=\"%\",TEXT(INDEX(E$53:AI87,MATCH(LEFTB(C87,SEARCH(\"%\",D87)),(C$53:C87),),),\"0;0;12\")*E87:AI87%,E87:AI87))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C88,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D88)=\"%\",TEXT(INDEX(E$53:AI88,MATCH(LEFTB(C88,SEARCH(\"%\",D88)),(C$53:C88),),),\"0;0;12\")*E88:AI88%,E88:AI88))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C89,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D89)=\"%\",TEXT(INDEX(E$53:AI89,MATCH(LEFTB(C89,SEARCH(\"%\",D89)),(C$53:C89),),),\"0;0;12\")*E89:AI89%,E89:AI89))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C90,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D90)=\"%\",TEXT(INDEX(E$53:AI90,MATCH(LEFTB(C90,SEARCH(\"%\",D90)),(C$53:C90),),),\"0;0;12\")*E90:AI90%,E90:AI90))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C91,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D91)=\"%\",TEXT(INDEX(E$53:AI91,MATCH(LEFTB(C91,SEARCH(\"%\",D91)),(C$53:C91),),),\"0;0;12\")*E91:AI91%,E91:AI91))","v":0}]
[]
[null,null,null,null,"Мастер смены:",null,null,null,null,null,null,null,null,null,"___________",null,null,null,{"$f":"TODAY()","v":"2015-06-15"}]

{"sheet":"БДМ№2","index":2,"n_rows":45,"n_cols":36,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,35,3,35],[44,8,44,13],[44,18,44,21],[44,22,44,26],[0,1,0,2],[0,3,0,7],[0,8,0,13],[0,14,0,30],[2,1,3,1],[2,2,3,3],[2,4,2,34]]}
[null,null,null,null,null,null,null,null,"БДМ № 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,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,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,{"$f":"IFERROR(VLOOKUP(C5,Список!$B$2:$C$150,2,0),\"\")","v":300},"Мишук Р.В.","Машинист 6 р.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D5)=\"%\",TEXT(INDEX(E$5:AI5,MATCH(LEFTB(C5,SEARCH(\"%\",D5)),(C$5:C5),),),\"0;0;12\")*E5:AI5%,E5:AI5))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C6,Список!$B$2:$C$150,2,0),\"\")","v":300},"Мишук Р.В.","Ап.пр.хим.р-в 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,{"$f":"SUM(IF(RIGHTB(D6)=\"%\",TEXT(INDEX(E$5:AI6,MATCH(LEFTB(C6,SEARCH(\"%\",D6)),(C$5:C6),),),\"0;0;12\")*E6:AI6%,E6:AI6))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C7,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D7)=\"%\",TEXT(INDEX(E$5:AI7,MATCH(LEFTB(C7,SEARCH(\"%\",D7)),(C$5:C7),),),\"0;0;12\")*E7:AI7%,E7:AI7))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C8,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D8)=\"%\",TEXT(INDEX(E$5:AI8,MATCH(LEFTB(C8,SEARCH(\"%\",D8)),(C$5:C8),),),\"0;0;12\")*E8:AI8%,E8:AI8))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C9,Список!$B$2:$C$150,2,0),\"\")","v":2108},"Макрицкий Ю.В.","Машинист 6 р.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D9)=\"%\",TEXT(INDEX(E$5:AI9,MATCH(LEFTB(C9,SEARCH(\"%\",D9)),(C$5:C9),),),\"0;0;12\")*E9:AI9%,E9:AI9))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C10,Список!$B$2:$C$150,2,0),\"\")","v":2108},"Макрицкий Ю.В.","Маш.уп. маш. 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,{"$f":"SUM(IF(RIGHTB(D10)=\"%\",TEXT(INDEX(E$5:AI10,MATCH(LEFTB(C10,SEARCH(\"%\",D10)),(C$5:C10),),),\"0;0;12\")*E10:AI10%,E10:AI10))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C11,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D11)=\"%\",TEXT(INDEX(E$5:AI11,MATCH(LEFTB(C11,SEARCH(\"%\",D11)),(C$5:C11),),),\"0;0;12\")*E11:AI11%,E11:AI11))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C12,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D12)=\"%\",TEXT(INDEX(E$5:AI12,MATCH(LEFTB(C12,SEARCH(\"%\",D12)),(C$5:C12),),),\"0;0;12\")*E12:AI12%,E12:AI12))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C13,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D13)=\"%\",TEXT(INDEX(E$5:AI13,MATCH(LEFTB(C13,SEARCH(\"%\",D13)),(C$5:C13),),),\"0;0;12\")*E13:AI13%,E13:AI13))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C14,Список!$B$2:$C$150,2,0),\"\")","v":338},"Романчук В.В.","Разм. РПО 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,{"$f":"SUM(IF(RIGHTB(D14)=\"%\",TEXT(INDEX(E$5:AI14,MATCH(LEFTB(C14,SEARCH(\"%\",D14)),(C$5:C14),),),\"0;0;12\")*E14:AI14%,E14:AI14))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C15,Список!$B$2:$C$150,2,0),\"\")","v":338},"Романчук В.В.","Разм. РПО 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,{"$f":"SUM(IF(RIGHTB(D15)=\"%\",TEXT(INDEX(E$5:AI15,MATCH(LEFTB(C15,SEARCH(\"%\",D15)),(C$5:C15),),),\"0;0;12\")*E15:AI15%,E15:AI15))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C16,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D16)=\"%\",TEXT(INDEX(E$5:AI16,MATCH(LEFTB(C16,SEARCH(\"%\",D16)),(C$5:C16),),),\"0;0;12\")*E16:AI16%,E16:AI16))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C17,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D17)=\"%\",TEXT(INDEX(E$5:AI17,MATCH(LEFTB(C17,SEARCH(\"%\",D17)),(C$5:C17),),),\"0;0;12\")*E17:AI17%,E17:AI17))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C18,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D18)=\"%\",TEXT(INDEX(E$5:AI18,MATCH(LEFTB(C18,SEARCH(\"%\",D18)),(C$5:C18),),),\"0;0;12\")*E18:AI18%,E18:AI18))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C19,Список!$B$2:$C$150,2,0),\"\")","v":2255},"Петровых В.В.","Резчик ПРС 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,{"$f":"SUM(IF(RIGHTB(D19)=\"%\",TEXT(INDEX(E$5:AI19,MATCH(LEFTB(C19,SEARCH(\"%\",D19)),(C$5:C19),),),\"0;0;12\")*E19:AI19%,E19:AI19))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C20,Список!$B$2:$C$150,2,0),\"\")","v":2255},"Петровых В.В.","Резчик ПРС 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,{"$f":"SUM(IF(RIGHTB(D20)=\"%\",TEXT(INDEX(E$5:AI20,MATCH(LEFTB(C20,SEARCH(\"%\",D20)),(C$5:C20),),),\"0;0;12\")*E20:AI20%,E20:AI20))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C21,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D21)=\"%\",TEXT(INDEX(E$5:AI21,MATCH(LEFTB(C21,SEARCH(\"%\",D21)),(C$5:C21),),),\"0;0;12\")*E21:AI21%,E21:AI21))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C22,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D22)=\"%\",TEXT(INDEX(E$5:AI22,MATCH(LEFTB(C22,SEARCH(\"%\",D22)),(C$5:C22),),),\"0;0;12\")*E22:AI22%,E22:AI22))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C23,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D23)=\"%\",TEXT(INDEX(E$5:AI23,MATCH(LEFTB(C23,SEARCH(\"%\",D23)),(C$5:C23),),),\"0;0;12\")*E23:AI23%,E23:AI23))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C24,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D24)=\"%\",TEXT(INDEX(E$5:AI24,MATCH(LEFTB(C24,SEARCH(\"%\",D24)),(C$5:C24),),),\"0;0;12\")*E24:AI24%,E24:AI24))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C25,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D25)=\"%\",TEXT(INDEX(E$5:AI25,MATCH(LEFTB(C25,SEARCH(\"%\",D25)),(C$5:C25),),),\"0;0;12\")*E25:AI25%,E25:AI25))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C26,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D26)=\"%\",TEXT(INDEX(E$5:AI26,MATCH(LEFTB(C26,SEARCH(\"%\",D26)),(C$5:C26),),),\"0;0;12\")*E26:AI26%,E26:AI26))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C27,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D27)=\"%\",TEXT(INDEX(E$5:AI27,MATCH(LEFTB(C27,SEARCH(\"%\",D27)),(C$5:C27),),),\"0;0;12\")*E27:AI27%,E27:AI27))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C28,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D28)=\"%\",TEXT(INDEX(E$5:AI28,MATCH(LEFTB(C28,SEARCH(\"%\",D28)),(C$5:C28),),),\"0;0;12\")*E28:AI28%,E28:AI28))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C29,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D29)=\"%\",TEXT(INDEX(E$5:AI29,MATCH(LEFTB(C29,SEARCH(\"%\",D29)),(C$5:C29),),),\"0;0;12\")*E29:AI29%,E29:AI29))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C30,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D30)=\"%\",TEXT(INDEX(E$5:AI30,MATCH(LEFTB(C30,SEARCH(\"%\",D30)),(C$5:C30),),),\"0;0;12\")*E30:AI30%,E30:AI30))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C31,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D31)=\"%\",TEXT(INDEX(E$5:AI31,MATCH(LEFTB(C31,SEARCH(\"%\",D31)),(C$5:C31),),),\"0;0;12\")*E31:AI31%,E31:AI31))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C32,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D32)=\"%\",TEXT(INDEX(E$5:AI32,MATCH(LEFTB(C32,SEARCH(\"%\",D32)),(C$5:C32),),),\"0;0;12\")*E32:AI32%,E32:AI32))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C33,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D33)=\"%\",TEXT(INDEX(E$5:AI33,MATCH(LEFTB(C33,SEARCH(\"%\",D33)),(C$5:C33),),),\"0;0;12\")*E33:AI33%,E33:AI33))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C34,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D34)=\"%\",TEXT(INDEX(E$5:AI34,MATCH(LEFTB(C34,SEARCH(\"%\",D34)),(C$5:C34),),),\"0;0;12\")*E34:AI34%,E34:AI34))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C35,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D35)=\"%\",TEXT(INDEX(E$5:AI35,MATCH(LEFTB(C35,SEARCH(\"%\",D35)),(C$5:C35),),),\"0;0;12\")*E35:AI35%,E35:AI35))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C36,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D36)=\"%\",TEXT(INDEX(E$5:AI36,MATCH(LEFTB(C36,SEARCH(\"%\",D36)),(C$5:C36),),),\"0;0;12\")*E36:AI36%,E36:AI36))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C37,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D37)=\"%\",TEXT(INDEX(E$5:AI37,MATCH(LEFTB(C37,SEARCH(\"%\",D37)),(C$5:C37),),),\"0;0;12\")*E37:AI37%,E37:AI37))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C38,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D38)=\"%\",TEXT(INDEX(E$5:AI38,MATCH(LEFTB(C38,SEARCH(\"%\",D38)),(C$5:C38),),),\"0;0;12\")*E38:AI38%,E38:AI38))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C39,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D39)=\"%\",TEXT(INDEX(E$5:AI39,MATCH(LEFTB(C39,SEARCH(\"%\",D39)),(C$5:C39),),),\"0;0;12\")*E39:AI39%,E39:AI39))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C40,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D40)=\"%\",TEXT(INDEX(E$5:AI40,MATCH(LEFTB(C40,SEARCH(\"%\",D40)),(C$5:C40),),),\"0;0;12\")*E40:AI40%,E40:AI40))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C41,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D41)=\"%\",TEXT(INDEX(E$5:AI41,MATCH(LEFTB(C41,SEARCH(\"%\",D41)),(C$5:C41),),),\"0;0;12\")*E41:AI41%,E41:AI41))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C42,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D42)=\"%\",TEXT(INDEX(E$5:AI42,MATCH(LEFTB(C42,SEARCH(\"%\",D42)),(C$5:C42),),),\"0;0;12\")*E42:AI42%,E42:AI42))","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C43,Список!$B$2:$C$150,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D43)=\"%\",TEXT(INDEX(E$5:AI43,MATCH(LEFTB(C43,SEARCH(\"%\",D43)),(C$5:C43),),),\"0;0;12\")*E43:AI43%,E43:AI43))","v":0}]
[]
[null,null,null,null,"Мастер смены:",null,null,null,null,null,null,null,null,null,"___________",null,null,null,{"$f":"TODAY()","v":"2015-06-15"}]

{"sheet":"Всего по сменам","index":3,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[24,4,31,6],[7,11,22,15],[1,1,1,2],[1,6,1,12],[1,3,1,4],[2,11,3,16],[3,2,3,3]]}
[]
[]
[]
[null,"Таб№","Фамилия, Имя, Отчество",null,"БВГ","Наряд,час","СЛА","БАВ","ХНН","Всего по сменам","Общий табель "]
[null,{"$f":"IFERROR(VLOOKUP(C5,Список!$B$2:$C$150,2,0),\"\")","v":465},{"$f":"IFERROR(f(ROW(A1),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":"Рудницкий С.Н."},{"$f":"IFERROR(f(ROW(A1),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":"Разм. брака 2 р."},null,null,null,null,null,{"$f":"SUM(E5:I5)","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C6,Список!$B$2:$C$150,2,0),\"\")","v":465},{"$f":"IFERROR(f(ROW(A2),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":"Рудницкий С.Н."},{"$f":"IFERROR(f(ROW(A2),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":"Разм. брака 2 р. %"},{"$f":"SUMIFS(Останов!$AJ$5:$AJ$43,Останов!$C$5:$C$43,C6,Останов!$D$5:$D$43,D6)+SUMIFS(БДМ№1!$AJ$5:$AJ$91,БДМ№1!$C$5:$C$91,C6,БДМ№1!$D$5:$D$91,D6)+SUMIFS(БДМ№2!$AJ$5:$AJ$91,БДМ№2!$C$5:$C$91,C6,БДМ№2!$D$5:$D$91,D6)","v":0},null,null,null,null,{"$f":"SUM(E6:I6)","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C7,Список!$B$2:$C$150,2,0),\"\")","v":761},{"$f":"IFERROR(f(ROW(A3),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":"Сацук А.Л."},{"$f":"IFERROR(f(ROW(A3),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":"Ап.пр.хим.р-в 3 р."},{"$f":"SUMIFS(Останов!$AJ$5:$AJ$43,Останов!$C$5:$C$43,C7,Останов!$D$5:$D$43,D7)+SUMIFS(БДМ№1!$AJ$5:$AJ$91,БДМ№1!$C$5:$C$91,C7,БДМ№1!$D$5:$D$91,D7)+SUMIFS(БДМ№2!$AJ$5:$AJ$91,БДМ№2!$C$5:$C$91,C7,БДМ№2!$D$5:$D$91,D7)","v":0},null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C8,Список!$B$2:$C$150,2,0),\"\")","v":761},{"$f":"IFERROR(f(ROW(A4),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":"Сацук А.Л."},{"$f":"IFERROR(f(ROW(A4),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":"Ап.пр.хим.р-в 3 р. %"},{"$f":"SUMIFS(Останов!$AJ$5:$AJ$43,Останов!$C$5:$C$43,C8,Останов!$D$5:$D$43,D8)+SUMIFS(БДМ№1!$AJ$5:$AJ$91,БДМ№1!$C$5:$C$91,C8,БДМ№1!$D$5:$D$91,D8)+SUMIFS(БДМ№2!$AJ$5:$AJ$91,БДМ№2!$C$5:$C$91,C8,БДМ№2!$D$5:$D$91,D8)","v":0},null,null,null,null,0,null,"Здравствуйте! Подскажите как исправить или дополнить. В столбец C и D с листа БДМ№1 и БДМ№2 копируются все фамилии с профессиями кроме тех фамилий с профессиями у которых есть знак \"%\". Для примера: красной строки не должно быть. Таким же образом формируется список на лист \"Останов\" с небольшим произвольным разрывом  (12-15 строк). Не получается: 1. связать все три таблицы (\"БДМ№1\"-2 шт. и \"БДМ№2\"-1 шт.) одной формулой. 2. В листе \"Всего по сменам\"убрать из списка строку со знаком \"%\" не сместив фамилии. 3. Продолжить список фамилий с листа \"БДМ№2\" в листе Останов."]
[null,{"$f":"IFERROR(VLOOKUP(C9,Список!$B$2:$C$150,2,0),\"\")","v":643},{"$f":"IFERROR(f(ROW(A5),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":"Буракова Т.А."},{"$f":"IFERROR(f(ROW(A5),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":"Перссовщик 3 р."},{"$f":"SUMIFS(Останов!$AJ$5:$AJ$43,Останов!$C$5:$C$43,C9,Останов!$D$5:$D$43,D9)+SUMIFS(БДМ№1!$AJ$5:$AJ$91,БДМ№1!$C$5:$C$91,C9,БДМ№1!$D$5:$D$91,D9)+SUMIFS(БДМ№2!$AJ$5:$AJ$91,БДМ№2!$C$5:$C$91,C9,БДМ№2!$D$5:$D$91,D9)","v":0},null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C10,Список!$B$2:$C$150,2,0),\"\")","v":1179},{"$f":"IFERROR(f(ROW(A6),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":"Брикун М.А."},{"$f":"IFERROR(f(ROW(A6),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":"Сушильщик 4 р."},{"$f":"SUMIFS(Останов!$AJ$5:$AJ$43,Останов!$C$5:$C$43,C10,Останов!$D$5:$D$43,D10)+SUMIFS(БДМ№1!$AJ$5:$AJ$91,БДМ№1!$C$5:$C$91,C10,БДМ№1!$D$5:$D$91,D10)+SUMIFS(БДМ№2!$AJ$5:$AJ$91,БДМ№2!$C$5:$C$91,C10,БДМ№2!$D$5:$D$91,D10)","v":0},null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C11,Список!$B$2:$C$150,2,0),\"\")","v":1179},{"$f":"IFERROR(f(ROW(A7),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":"Брикун М.А."},{"$f":"IFERROR(f(ROW(A7),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":"Перссовщик 3 р. %"},{"$f":"SUMIFS(Останов!$AJ$5:$AJ$43,Останов!$C$5:$C$43,C11,Останов!$D$5:$D$43,D11)+SUMIFS(БДМ№1!$AJ$5:$AJ$91,БДМ№1!$C$5:$C$91,C11,БДМ№1!$D$5:$D$91,D11)+SUMIFS(БДМ№2!$AJ$5:$AJ$91,БДМ№2!$C$5:$C$91,C11,БДМ№2!$D$5:$D$91,D11)","v":0},null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C12,Список!$B$2:$C$150,2,0),\"\")","v":1291},{"$f":"IFERROR(f(ROW(A8),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":"Лысковец А.Н."},{"$f":"IFERROR(f(ROW(A8),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":"Накатчик 3 р."},{"$f":"SUMIFS(Останов!$AJ$5:$AJ$43,Останов!$C$5:$C$43,C12,Останов!$D$5:$D$43,D12)+SUMIFS(БДМ№1!$AJ$5:$AJ$91,БДМ№1!$C$5:$C$91,C12,БДМ№1!$D$5:$D$91,D12)+SUMIFS(БДМ№2!$AJ$5:$AJ$91,БДМ№2!$C$5:$C$91,C12,БДМ№2!$D$5:$D$91,D12)","v":0},null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C13,Список!$B$2:$C$150,2,0),\"\")","v":1379},{"$f":"IFERROR(f(ROW(A9),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":"Кадевич О.В."},{"$f":"IFERROR(f(ROW(A9),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":"Маш.уп. маш. 2 р."},{"$f":"SUMIFS(Останов!$AJ$5:$AJ$43,Останов!$C$5:$C$43,C13,Останов!$D$5:$D$43,D13)+SUMIFS(БДМ№1!$AJ$5:$AJ$91,БДМ№1!$C$5:$C$91,C13,БДМ№1!$D$5:$D$91,D13)+SUMIFS(БДМ№2!$AJ$5:$AJ$91,БДМ№2!$C$5:$C$91,C13,БДМ№2!$D$5:$D$91,D13)","v":0},null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C14,Список!$B$2:$C$150,2,0),\"\")","v":589},{"$f":"IFERROR(f(ROW(A10),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":"Хомич Н.Н."},{"$f":"IFERROR(f(ROW(A10),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":"Маш.уп. маш. 2 р."},{"$f":"SUMIFS(Останов!$AJ$5:$AJ$43,Останов!$C$5:$C$43,C14,Останов!$D$5:$D$43,D14)+SUMIFS(БДМ№1!$AJ$5:$AJ$91,БДМ№1!$C$5:$C$91,C14,БДМ№1!$D$5:$D$91,D14)+SUMIFS(БДМ№2!$AJ$5:$AJ$91,БДМ№2!$C$5:$C$91,C14,БДМ№2!$D$5:$D$91,D14)","v":0},null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C15,Список!$B$2:$C$150,2,0),\"\")","v":589},{"$f":"IFERROR(f(ROW(A11),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":"Хомич Н.Н."},{"$f":"IFERROR(f(ROW(A11),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":"Ап.пр.хим.р-в 3 р. %"},{"$f":"SUMIFS(Останов!$AJ$5:$AJ$43,Останов!$C$5:$C$43,C15,Останов!$D$5:$D$43,D15)+SUMIFS(БДМ№1!$AJ$5:$AJ$91,БДМ№1!$C$5:$C$91,C15,БДМ№1!$D$5:$D$91,D15)+SUMIFS(БДМ№2!$AJ$5:$AJ$91,БДМ№2!$C$5:$C$91,C15,БДМ№2!$D$5:$D$91,D15)","v":0},null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C16,Список!$B$2:$C$150,2,0),\"\")","v":300},{"$f":"IFERROR(f(ROW(A12),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":"Мишук Р.В."},{"$f":"IFERROR(f(ROW(A12),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":"Машинист 6 р."},{"$f":"SUMIFS(Останов!$AJ$5:$AJ$43,Останов!$C$5:$C$43,C16,Останов!$D$5:$D$43,D16)+SUMIFS(БДМ№1!$AJ$5:$AJ$91,БДМ№1!$C$5:$C$91,C16,БДМ№1!$D$5:$D$91,D16)+SUMIFS(БДМ№2!$AJ$5:$AJ$91,БДМ№2!$C$5:$C$91,C16,БДМ№2!$D$5:$D$91,D16)","v":0},null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C17,Список!$B$2:$C$150,2,0),\"\")","v":300},{"$f":"IFERROR(f(ROW(A13),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":"Мишук Р.В."},{"$f":"IFERROR(f(ROW(A13),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":"Ап.пр.хим.р-в 3 р. %"},{"$f":"SUMIFS(Останов!$AJ$5:$AJ$43,Останов!$C$5:$C$43,C17,Останов!$D$5:$D$43,D17)+SUMIFS(БДМ№1!$AJ$5:$AJ$91,БДМ№1!$C$5:$C$91,C17,БДМ№1!$D$5:$D$91,D17)+SUMIFS(БДМ№2!$AJ$5:$AJ$91,БДМ№2!$C$5:$C$91,C17,БДМ№2!$D$5:$D$91,D17)","v":0},null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C18,Список!$B$2:$C$150,2,0),\"\")","v":2108},{"$f":"IFERROR(f(ROW(A14),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":"Макрицкий Ю.В."},{"$f":"IFERROR(f(ROW(A14),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":"Машинист 6 р."},{"$f":"SUMIFS(Останов!$AJ$5:$AJ$43,Останов!$C$5:$C$43,C18,Останов!$D$5:$D$43,D18)+SUMIFS(БДМ№1!$AJ$5:$AJ$91,БДМ№1!$C$5:$C$91,C18,БДМ№1!$D$5:$D$91,D18)+SUMIFS(БДМ№2!$AJ$5:$AJ$91,БДМ№2!$C$5:$C$91,C18,БДМ№2!$D$5:$D$91,D18)","v":0},null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C19,Список!$B$2:$C$150,2,0),\"\")","v":2108},{"$f":"IFERROR(f(ROW(A15),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":"Макрицкий Ю.В."},{"$f":"IFERROR(f(ROW(A15),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":"Маш.уп. маш. 2 р. %"},{"$f":"SUMIFS(Останов!$AJ$5:$AJ$43,Останов!$C$5:$C$43,C19,Останов!$D$5:$D$43,D19)+SUMIFS(БДМ№1!$AJ$5:$AJ$91,БДМ№1!$C$5:$C$91,C19,БДМ№1!$D$5:$D$91,D19)+SUMIFS(БДМ№2!$AJ$5:$AJ$91,БДМ№2!$C$5:$C$91,C19,БДМ№2!$D$5:$D$91,D19)","v":0},null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C20,Список!$B$2:$C$150,2,0),\"\")","v":338},{"$f":"IFERROR(f(ROW(A16),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":"Романчук В.В."},{"$f":"IFERROR(f(ROW(A16),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":"Разм. РПО 5 р."},{"$f":"SUMIFS(Останов!$AJ$5:$AJ$43,Останов!$C$5:$C$43,C20,Останов!$D$5:$D$43,D20)+SUMIFS(БДМ№1!$AJ$5:$AJ$91,БДМ№1!$C$5:$C$91,C20,БДМ№1!$D$5:$D$91,D20)+SUMIFS(БДМ№2!$AJ$5:$AJ$91,БДМ№2!$C$5:$C$91,C20,БДМ№2!$D$5:$D$91,D20)","v":0},null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C21,Список!$B$2:$C$150,2,0),\"\")","v":338},{"$f":"IFERROR(f(ROW(A17),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":"Романчук В.В."},{"$f":"IFERROR(f(ROW(A17),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":"Разм. РПО 4 р. %"},{"$f":"SUMIFS(Останов!$AJ$5:$AJ$43,Останов!$C$5:$C$43,C21,Останов!$D$5:$D$43,D21)+SUMIFS(БДМ№1!$AJ$5:$AJ$91,БДМ№1!$C$5:$C$91,C21,БДМ№1!$D$5:$D$91,D21)+SUMIFS(БДМ№2!$AJ$5:$AJ$91,БДМ№2!$C$5:$C$91,C21,БДМ№2!$D$5:$D$91,D21)","v":0},null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C22,Список!$B$2:$C$150,2,0),\"\")","v":2255},{"$f":"IFERROR(f(ROW(A18),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":"Петровых В.В."},{"$f":"IFERROR(f(ROW(A18),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":"Резчик ПРС 4 р."},{"$f":"SUMIFS(Останов!$AJ$5:$AJ$43,Останов!$C$5:$C$43,C22,Останов!$D$5:$D$43,D22)+SUMIFS(БДМ№1!$AJ$5:$AJ$91,БДМ№1!$C$5:$C$91,C22,БДМ№1!$D$5:$D$91,D22)+SUMIFS(БДМ№2!$AJ$5:$AJ$91,БДМ№2!$C$5:$C$91,C22,БДМ№2!$D$5:$D$91,D22)","v":0},null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C23,Список!$B$2:$C$150,2,0),\"\")","v":2255},{"$f":"IFERROR(f(ROW(A19),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":"Петровых В.В."},{"$f":"IFERROR(f(ROW(A19),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":"Резчик ПРС 4 р. %"},{"$f":"SUMIFS(Останов!$AJ$5:$AJ$43,Останов!$C$5:$C$43,C23,Останов!$D$5:$D$43,D23)+SUMIFS(БДМ№1!$AJ$5:$AJ$91,БДМ№1!$C$5:$C$91,C23,БДМ№1!$D$5:$D$91,D23)+SUMIFS(БДМ№2!$AJ$5:$AJ$91,БДМ№2!$C$5:$C$91,C23,БДМ№2!$D$5:$D$91,D23)","v":0},{"$f":"IF(RIGHT(D23)<>\"%\",IFERROR(f(ROW(B19),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\"),IFERROR(f(ROW()+ROW($D$5:$D$5)+1+COUNTBLANK($D$5:$D$34),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\"))","v":""},null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C24,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A20),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":""},{"$f":"IFERROR(f(ROW(A20),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":""},{"$f":"SUMIFS(Останов!$AJ$5:$AJ$43,Останов!$C$5:$C$43,C24,Останов!$D$5:$D$43,D24)+SUMIFS(БДМ№1!$AJ$5:$AJ$91,БДМ№1!$C$5:$C$91,C24,БДМ№1!$D$5:$D$91,D24)+SUMIFS(БДМ№2!$AJ$5:$AJ$91,БДМ№2!$C$5:$C$91,C24,БДМ№2!$D$5:$D$91,D24)","v":0},{"$f":"IF(RIGHT(D24)<>\"%\",IFERROR(f(ROW(B20),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\"),IFERROR(f(ROW()+ROW($D$5:$D$5)+1+COUNTBLANK($D$5:$D$34),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\"))","v":""},null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C25,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A21),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":""},{"$f":"IFERROR(f(ROW(A21),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":""},"на этот лист копируется весь список фамилий с листа БДМ№1 и БДМ№2 кроме фамилий у которых профессия заканчивается знаком \"%\". Строки которых быть не должно подсвечены красным цветом.",null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C26,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A22),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":""},{"$f":"IFERROR(f(ROW(A22),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C27,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A23),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":""},{"$f":"IFERROR(f(ROW(A23),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":""},null,null,null,null,null,{"$f":"SUM(E27:I27)","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(C28,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A24),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":""},{"$f":"IFERROR(f(ROW(A24),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C29,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A25),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":""},{"$f":"IFERROR(f(ROW(A25),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C30,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A26),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":""},{"$f":"IFERROR(f(ROW(A26),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C31,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A27),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":""},{"$f":"IFERROR(f(ROW(A27),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C32,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A28),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":""},{"$f":"IFERROR(f(ROW(A28),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C33,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A29),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":""},{"$f":"IFERROR(f(ROW(A29),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":""},{"$f":"SUMIFS(Останов!$AJ$5:$AJ$43,Останов!$C$5:$C$43,C33,Останов!$D$5:$D$43,D33)+SUMIFS(БДМ№1!$AJ$5:$AJ$91,БДМ№1!$C$5:$C$91,C33,БДМ№1!$D$5:$D$91,D33)+SUMIFS(БДМ№2!$AJ$5:$AJ$91,БДМ№2!$C$5:$C$91,C33,БДМ№2!$D$5:$D$91,D33)","v":0},{"$f":"IF(RIGHT(D33)<>\"%\",IFERROR(f(ROW(B29),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\"),IFERROR(f(ROW()+ROW($D$5:$D$5)+1+COUNTBLANK($D$5:$D$34),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\"))","v":""},null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(C34,Список!$B$2:$C$150,2,0),\"\")","v":""},{"$f":"IFERROR(f(ROW(A30),БДМ№1!$C$5:$C$43,БДМ№1!$C$53:$C$91,БДМ№2!$C$5:$C$43),\"\")","v":""},{"$f":"IFERROR(f(ROW(A30),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91,БДМ№2!$D$5:$D$43),\"\")","v":""},{"$f":"SUMIFS(Останов!$AJ$5:$AJ$43,Останов!$C$5:$C$43,C34,Останов!$D$5:$D$43,D34)+SUMIFS(БДМ№1!$AJ$5:$AJ$91,БДМ№1!$C$5:$C$91,C34,БДМ№1!$D$5:$D$91,D34)+SUMIFS(БДМ№2!$AJ$5:$AJ$91,БДМ№2!$C$5:$C$91,C34,БДМ№2!$D$5:$D$91,D34)","v":0},{"$f":"IF(RIGHT(D34)<>\"%\",IFERROR(f(ROW(B30),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\"),IFERROR(f(ROW()+ROW($D$5:$D$5)+1+COUNTBLANK($D$5:$D$34),БДМ№1!$D$5:$D$43,БДМ№1!$D$53:$D$91),\"\"))","v":""},null,null,null,{"$f":"SUM(E34:I34)","v":0}]

{"sheet":"Формулы","index":4,"n_rows":36,"n_cols":36,"rows_kept":36,"cut":false,"hidden":true,"merged":[[29,35,30,35],[29,4,29,34],[5,35,6,35],[1,1,1,6],[25,6,25,18],[5,1,6,1],[5,4,5,34],[29,1,30,1],[5,2,6,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[18,2,18,3],[22,2,22,3],[23,2,23,3],[29,2,30,3]]}
[]
[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,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,300,"Мишук Р.В. Машинист 6 р.",null,null,10,null,null,10,12,null,null,8,8,null,null,null,null,null,null,null,8,null,null,null,null,null,null,8,8,null,null,null,null,null,{"$f":"SUM(E8:AI8)","v":72}]
[null,300,"Мишук Р.В. Сушильщик 4 р.",null,null,null,null,null,50,50,null,null,null,null,null,null,null,null,null,null,null,50,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E8*E9/100+F8*F9/100+G8*G9/100+H8*H9/100+I8*I9/100+J8*J9/100+K8*K9/100+L8*L9/100+M8*M9/100+N8*N9/100+O8*O9/100+P8*P9/100+Q8*Q9/100+R8*R9/100+S8*S9/100+T8*T9/100+U8*U9/100+V8*V9/100+W8*W9/100+X8*X9/100+Y8*Y9/100+Z8*Z9/100+AA8*AA9/100+AB8*AB9/100+AC8*AC9/100+AD8*AD9/100+AE8*AE9/100+AF8*AF9/100+AG8*AG9/100+AH8*AH9/100+AI8*AI9/100","v":15}]
[]
[null,"2. Два совмещения . (т.е. формула считает две строки совмещения)."]
[]
[null,2108,"Макрицкий Ю.В. Машинист 6 р.",null,12,10,null,null,10,12,null,null,12,12,null,null,12,null,null,null,null,12,null,null,12,9.5,null,null,12,12,null,null,null,null,null,{"$f":"SUM(E13:AI13)","v":137.5}]
[null,2108,"Макрицкий Ю.В. Размольщик 4 р.%",null,20,20,null,null,null,null,null,null,20,20,null,null,20,null,null,null,null,null,null,null,null,null,null,null,20,20,null,null,null,null,null,{"$f":"E13*E14/100+F13*F14/100+G13*G14/100+H13*H14/100+I13*I14/100+J13*J14/100+K13*K14/100+L13*L14/100+M13*M14/100+N13*N14/100+O13*O14/100+P13*P14/100+Q13*Q14/100+R13*R14/100+S13*S14/100+T13*T14/100+U13*U14/100+V13*V14/100+W13*W14/100+X13*X14/100+Y13*Y14/100+Z13*Z14/100+AA13*AA14/100+AB13*AB14/100+AC13*AC14/100+AD13*AD14/100+AE13*AE14/100+AF13*AF14/100+AG13*AG14/100+AH13*AH14/100+AI13*AI14/100","v":16.400000000000002}]
[null,2108,"Макрицкий Ю.В. Сушильщик 4 р.%",null,null,null,null,null,50,50,null,null,null,null,null,null,null,null,null,null,null,50,null,null,50,50,null,null,null,null,null,null,null,null,null,{"$f":"E13*E15/100+F13*F15/100+G13*G15/100+H13*H15/100+I13*I15/100+J13*J15/100+K13*K15/100+L13*L15/100+M13*M15/100+N13*N15/100+O13*O15/100+P13*P15/100+Q13*Q15/100+R13*R15/100+S13*S15/100+T13*T15/100+U13*U15/100+V13*V15/100+W13*W15/100+X13*X15/100+Y13*Y15/100+Z13*Z15/100+AA13*AA15/100+AB13*AB15/100+AC13*AC15/100+AD13*AD15/100+AE13*AE15/100+AF13*AF15/100+AG13*AG15/100+AH13*AH15/100+AI13*AI15/100","v":27.75}]
[]
[null,"3. Совмещение при резке рулонов другой смены. Выглядит так : общая сумма/сто процентов*12."]
[]
[null,2255,"Петровых В.В. Резчик 4 р. %",null,null,null,null,null,100,100,null,null,null,null,null,null,100,null,null,null,null,null,null,null,50,100,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E19:AI19)*0.12","v":54}]
[]
[null,"4. Формула переводит числовое значение в сумму прописью (ячейки под числами дня доступны для редактирования)"]
[]
[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,1,"Рудницкий С.Н. Машинист 6 р.",null,null,null,null,null,null,2,null,1,1,1,1,2,null,null,2,null,null,5,55,null,8,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E24:AI24)","v":78}]
[]
[null,null,null,null,null,null,"Всего по отраслевым нормам выдано: ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX({\"\",\"сто \",\"двести \",\"триста \",\"четыреста \",\"пятьсот \",\"шестьсот \",\"семьсот \",\"восемьсот \",\"девятьсот \"},MOD(TRUNC(AJ24/10^8),10)+1)&CHOOSE(MOD(TRUNC(AJ24/10^7),10)+1,\"\",INDEX({\"десять \",\"одиннадцать \",\"двенадцать \",\"тринадцать \",\"четырнадцать \",\"пятнадцать \",\"шестнадцать \",\"семнадцать \",\"восемнадцать \",\"девятнадцать \"},MOD(TRUNC(AJ24/10^6),10)+1),\"двадцать \",\"тридцать \",\"сорок \",\"пятьдесят \",\"шестьдесят \",\"семьдесят \",\"восемьдесят \",\"девяносто \")&IF(MOD(TRUNC(AJ24/10^7),10)<>1,INDEX({\"\",\"один \",\"два \",\"три \",\"четыре \",\"пять \",\"шесть \",\"семь \",\"восемь \",\"девять \"},MOD(TRUNC(AJ24/10^6),10)+1),\"\")&IF(MOD(TRUNC(AJ24/10^6),1000),\"миллион\"&IF(MOD(TRUNC(AJ24/10^7),10)=1,\"ов \",VLOOKUP(MOD(TRUNC(AJ24/10^6),10),{0,\"ов \";1,\" \";2,\"а \";5,\"ов \"},2)),\"\")&INDEX({\"\",\"сто \",\"двести \",\"триста \",\"четыреста \",\"пятьсот \",\"шестьсот \",\"семьсот \",\"восемьсот \",\"девятьсот \"},MOD(TRUNC(AJ24/10^5),10)+1)&CHOOSE(MOD(TRUNC(AJ24/10^4),10)+1,\"\",INDEX({\"десять \",\"одиннадцать \",\"двенадцать \",\"тринадцать \",\"четырнадцать \",\"пятнадцать \",\"шестнадцать \",\"семнадцать \",\"восемнадцать \",\"девятнадцать \"},MOD(TRUNC(AJ24/1000),10)+1),\"двадцать \",\"тридцать \",\"сорок \",\"пятьдесят \",\"шестьдесят \",\"семьдесят \",\"восемьдесят \",\"девяносто \")&IF(MOD(TRUNC(AJ24/10^4),10)<>1,INDEX({\"\",\"одна \",\"две \",\"три \",\"четыре \",\"пять \",\"шесть \",\"семь \",\"восемь \",\"девять \"},MOD(TRUNC(AJ24/1000),10)+1),\"\")&IF(MOD(TRUNC(AJ24/1000),1000),\"тысяч\"&IF(MOD(TRUNC(AJ24/10^4),10)=1,\" \",VLOOKUP(MOD(TRUNC(AJ24/1000),10),{0,\" \";1,\"а \";2,\"и \";5,\" \"},2)),\"\")&INDEX({\"\",\"сто \",\"двести \",\"триста \",\"четыреста \",\"пятьсот \",\"шестьсот \",\"семьсот \",\"восемьсот \",\"девятьсот \"},MOD(TRUNC(AJ24/100),10)+1)&CHOOSE(MOD(TRUNC(AJ24/10),10)+1,\"\",INDEX({\"десять \",\"одиннадцать \",\"двенадцать \",\"тринадцать \",\"четырнадцать \",\"пятнадцать \",\"шестнадцать \",\"семнадцать \",\"восемнадцать \",\"девятнадцать \"},MOD(TRUNC(AJ24),10)+1),\"двадцать \",\"тридцать \",\"сорок \",\"пятьдесят \",\"шестьдесят \",\"семьдесят \",\"восемьдесят \",\"девяносто \")&IF(TRUNC(AJ24)=0,\"ноль \",IF(MOD(TRUNC(AJ24/10),10)<>1,INDEX({\"\",\"один \",\"два \",\"три \",\"четыре \",\"пять \",\"шесть \",\"семь \",\"восемь \",\"девять \"},MOD(TRUNC(AJ24),10)+1),\"\"))&\"талон\"&IF(MOD(TRUNC(AJ24/10),10)=1,\"ов\",VLOOKUP(MOD(TRUNC(AJ24),10),{0,\"ов\";1,\"ь\";2,\"а\";5,\"ов\"},2))&TEXT(TRUNC((AJ24-TRUNC(AJ24)+0.00001)*100),)","v":"семьдесят восемь талонов"}]
[]
[null,"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,"Часы"]
[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":"IFERROR(VLOOKUP(C32,Список!$B$2:$C$150,2,0),\"\")","v":465},"Рудницкий С.Н.","Машинист 6 р.",null,null,null,null,null,null,null,null,null,null,null,12,null,null,12,12,null,null,12,12,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D32)=\"%\",TEXT(INDEX(E$32:AI32,MATCH(LEFTB(C32,SEARCH(\"%\",D32)),(C$32:C32),),),\"0;0;12\")*E32:AI32%,E32:AI32))","v":60}]
[null,{"$f":"IFERROR(VLOOKUP(C33,Список!$B$2:$C$150,2,0),\"\")","v":465},"Рудницкий С.Н.","Ап.пр.хим.р-в 3 р. %",null,null,null,null,null,null,null,null,null,null,null,25,null,null,25,25,null,null,25,25,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D33)=\"%\",TEXT(INDEX(E$32:AI33,MATCH(LEFTB(C33,SEARCH(\"%\",D33)),(C$32:C33),),),\"0;0;12\")*E33:AI33%,E33:AI33))","v":15}]
[null,{"$f":"IFERROR(VLOOKUP(C34,Список!$B$2:$C$150,2,0),\"\")","v":465},"Рудницкий С.Н.","Маш.уп. маш. 2 р. %",null,null,null,null,null,null,null,null,null,null,null,50,null,null,50,50,null,null,50,50,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D34)=\"%\",TEXT(INDEX(E$32:AI34,MATCH(LEFTB(C34,SEARCH(\"%\",D34)),(C$32:C34),),),\"0;0;12\")*E34:AI34%,E34:AI34))","v":30}]
[null,{"$f":"IFERROR(VLOOKUP(C35,Список!$B$2:$C$150,2,0),\"\")","v":465},"Рудницкий С.Н.","Накатчик 3 р. %",null,null,null,null,null,null,null,null,null,null,null,100,null,null,100,100,null,null,100,100,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(D35)=\"%\",TEXT(INDEX(E$32:AI35,MATCH(LEFTB(C35,SEARCH(\"%\",D35)),(C$32:C35),),),\"0;0;12\")*E35:AI35%,E35:AI35))","v":60}]
[null,{"$f":"IFERROR(VLOOKUP(C36,Список!$B$2:$C$150,2,0),\"\")","v":0},"Адамюк Е.В.",null,null,null,null,null,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,{"$f":"SUM(IF(RIGHTB(D36)=\"%\",TEXT(INDEX(E$32:AI36,MATCH(LEFTB(C36,SEARCH(\"%\",D36)),(C$32:C36),),),\"0;0;12\")*E36:AI36%,E36:AI36))","v":2}]

{"sheet":"Список","index":5,"n_rows":151,"n_cols":17,"rows_kept":151,"cut":false,"hidden":true,"merged":[]}
["№","ФИО","Таб.№","Конт-т","Кол.дог.","Проф.м.","За рук.бриг.","За сложн.","Вр.зач.БФГ","Стаж","Профессия","Час.т.ставка","Знаки","Месяц","Мастера смен","Наряды","Расценка за ед."]
[1,"Амосова Т.Ф.",{"$f":"IF(B2=\"Амосова Т.Ф.\",342)","v":342},null,null,null,null,null,null,{"$f":"IF(I2=\"\",\"\",SUM(TODAY()-I2)/365)","v":""},"Ап.пр.хим.р-в 3 р.",{"$f":"IF(K2=\"Ап.пр.хим.р-в 3 р.\",5481)","v":5481},1,"Январь, 2016 г.","см. Буйко В.Г.","в том числе связывание канатика",{"$f":"IF(P2=\"в том числе связывание канатика\",16309)","v":16309}]
[2,"Адамюк Е.В.",null,null,null,null,null,null,null,{"$f":"IF(I3=\"\",\"\",SUM(TODAY()-I3)/365)","v":""},"Ап.пр.хим.р-в 3 р. %",{"$f":"IF(K3=\"Ап.пр.хим.р-в 3 р. %\",5481)","v":5481},2,"Февраль, 2016 г.","см. Булавский А.В.","композиционного, оборотного брака, сгущеной целлюлозы",{"$f":"IF(P3=\"композиционного, оборотного брака, сгущеной целлюлозы\",32283)","v":32283}]
[3,"Аниськович А.П.",{"$f":"IF(B4=\"Аниськович А.П.\",1339)","v":1339},null,null,null,null,null,null,"","Мастер смены",2022566,3,"Март, 2016 г.","см. Кузьбар И.Н.","Переупаковка ролевой бумаги",{"$f":"IF(P4=\"Переупаковка ролевой бумаги\",7536)","v":7536}]
[4,"Апет И.В.",{"$f":"IF(B5=\"Апет И.В.\",2234)","v":2234},null,null,null,null,null,null,"","Маш.уп. маш. 2 р.",{"$f":"IF(K5=\"Маш.уп. маш. 2 р.\",4710)","v":4710},4,"Апрель, 2016 г.","см. Сандульская Л.А.","Промывка и чистка сгустителя",{"$f":"IF(P5=\"Промывка и чистка сгустителя\",10688)","v":10688}]
[5,"Богодяж Т.А.",{"$f":"IF(B6=\"Богодяж Т.А.\",1609)","v":1609},null,null,null,null,null,null,"","Маш.уп. маш. 2 р. %",{"$f":"IF(K6=\"Маш.уп. маш. 2 р. %\",4710)","v":4710},5,"Май, 2015 г.","см. Хомич Н.Н.","Промывка и чистка флотоловушки",{"$f":"IF(P6=\"Промывка и чистка флотоловушки\",36134)","v":36134}]
[6,"Брикун М.А.",{"$f":"IF(B7=\"Брикун М.А.\",1179)","v":1179},null,null,null,null,null,null,"","Машинист 6 р.",{"$f":"IF(K7=\"Машинист 6 р.\",7715)","v":7715},6,"Июнь, 2015 г.",null,"Резка и упаковка ленты бумажной для плоттеров 70 г/м2, ф. 1000 мм",{"$f":"IF(P7=\"Резка и упаковка ленты бумажной для плоттеров 70 г/м2, ф. 1000 мм\",4874)","v":4874}]
[7,"Буйко В.Г.",{"$f":"IF(B8=\"Буйко В.Г.\",1241)","v":1241},null,null,null,null,null,null,"","Накатчик 3 р.",{"$f":"IF(K8=\"Накатчик 3 р.\",5481)","v":5481},7,"Июль, 2015 г.",null,"Резка и упаковка ленты бумажной для плоттеров 70 г/м2, ф. 1500 мм",{"$f":"IF(P8=\"Резка и упаковка ленты бумажной для плоттеров 70 г/м2, ф. 1500 мм\",8356)","v":8356}]
[8,"Булавский А.В.",{"$f":"IF(B9=\"Булавский А.В.\",1515)","v":1515},null,null,null,null,null,null,"","Накатчик 3 р. %",{"$f":"IF(K9=\"Накатчик 3 р. %\",5481)","v":5481},8,"Август, 2015 г.",null,"Резка и упаковка ленты бумажной для плоттеров 70 г/м2, ф. 1510 мм",{"$f":"IF(P9=\"Резка и упаковка ленты бумажной для плоттеров 70 г/м2, ф. 1510 мм\",8356)","v":8356}]
[9,"Буракова Т.А.",{"$f":"IF(B10=\"Буракова Т.А.\",643)","v":643},null,null,null,null,null,null,"","Оклад",null,9,"Сентябрь, 2015 г.",null,"Резка и упаковка ленты бумажной для плоттеров 70 г/м2, ф. 1600 мм",{"$f":"IF(P10=\"Резка и упаковка ленты бумажной для плоттеров 70 г/м2, ф. 1600 мм\",8356)","v":8356}]
[10,"Бурдыко Е.А.",{"$f":"IF(B11=\"Бурдыко Е.А.\",2269)","v":2269},null,null,null,null,null,null,"","Перссовщик 3 р.",{"$f":"IF(K11=\"Перссовщик 3 р.\",5481)","v":5481},10,"Октябрь, 2015 г.",null,"Резка и упаковка ленты бумажной для плоттеров 70 г/м2, ф. 1680 мм",{"$f":"IF(P11=\"Резка и упаковка ленты бумажной для плоттеров 70 г/м2, ф. 1680 мм\",8356)","v":8356}]
[11,"Бурыхин С.А.",{"$f":"IF(B12=\"Бурыхин С.А.\",1501)","v":1501},null,null,null,null,null,null,"","Перссовщик 3 р. %",{"$f":"IF(K12=\"Перссовщик 3 р. %\",5481)","v":5481},11,"Ноябрь, 2015 г.",null,"Резка и упаковка ленты бумажной для плоттеров 70 г/м2, ф. 1800 мм",{"$f":"IF(P12=\"Резка и упаковка ленты бумажной для плоттеров 70 г/м2, ф. 1800 мм\",8356)","v":8356}]
[12,"Буслов А.А.",{"$f":"IF(B13=\"Буслов А.А.\",2150)","v":2150},null,null,null,null,null,null,"","Разм. брака 2 р.",{"$f":"IF(K13=\"Разм. брака 2 р.\",4710)","v":4710},12,"Декабрь, 2015 г.",null,"Резка и упаковка ленты бумажной для плоттеров 70 г/м2, ф. 1900 мм",{"$f":"IF(P13=\"Резка и упаковка ленты бумажной для плоттеров 70 г/м2, ф. 1900 мм\",8356)","v":8356}]
[13,"Бушкин В.Д.",{"$f":"IF(B14=\"Бушкин В.Д.\",1430)","v":1430},null,null,null,null,null,null,"","Разм. брака 2 р. %",{"$f":"IF(K14=\"Разм. брака 2 р. %\",4710)","v":4710},"1'","Прочее",null,"Резка и упаковка ленты бумажной для плоттеров 70 г/м2, ф. 2000 мм",{"$f":"IF(P14=\"Резка и упаковка ленты бумажной для плоттеров 70 г/м2, ф. 2000 мм\",8356)","v":8356}]
[14,"Бушкина Т.П.",{"$f":"IF(B15=\"Бушкина Т.П.\",531)","v":531},null,null,null,null,null,null,"","Разм. ГРВ 3 р.",{"$f":"IF(K15=\"Разм. ГРВ 3 р.\",5481)","v":5481},"12'","Останов БДМ",null,"Резка и упаковка ленты бумажной для плоттеров 80 г/м2, ф. 1000 мм",{"$f":"IF(P15=\"Резка и упаковка ленты бумажной для плоттеров 80 г/м2, ф. 1000 мм\",4874)","v":4874}]
[15,"Буяновская В.П.",{"$f":"IF(B16=\"Буяновская В.П.\",489)","v":489},null,null,null,null,null,null,"","Разм. ПО 3 р.",{"$f":"IF(K16=\"Разм. ПО 3 р.\",5481)","v":5481},"2'","БДМ № 1",null,"Резка и упаковка ленты бумажной для плоттеров 80 г/м2, ф. 1500 мм",{"$f":"IF(P16=\"Резка и упаковка ленты бумажной для плоттеров 80 г/м2, ф. 1500 мм\",8356)","v":8356}]
[16,"Ваньков С.П.",{"$f":"IF(B17=\"Ваньков С.П.\",115)","v":115},null,null,null,null,null,null,"","Разм. ПО 3 р. %",{"$f":"IF(K17=\"Разм. ПО 3 р. %\",5481)","v":5481},"3'","БДМ № 2",null,"Резка и упаковка ленты бумажной для плоттеров 80 г/м2, ф. 1510 мм",{"$f":"IF(P17=\"Резка и упаковка ленты бумажной для плоттеров 80 г/м2, ф. 1510 мм\",8356)","v":8356}]
[17,"Ванькова Л.Е.",{"$f":"IF(B18=\"Ванькова Л.Е.\",365)","v":365},null,null,null,null,null,null,"","Разм. РПО 3 р.",{"$f":"IF(K18=\"Разм. РПО 3 р.\",5481)","v":5481},"4'","Бумажный цех",null,"Резка и упаковка ленты бумажной для плоттеров 80 г/м2, ф. 1680 мм",{"$f":"IF(P18=\"Резка и упаковка ленты бумажной для плоттеров 80 г/м2, ф. 1680 мм\",8356)","v":8356}]
[18,"Васильева О.А.",{"$f":"IF(B19=\"Васильева О.А.\",1560)","v":1560},null,null,null,null,null,null,"","Разм. РПО 3 р. %",{"$f":"IF(K19=\"Разм. РПО 3 р. %\",5481)","v":5481},"5'",null,null,"Резка и упаковка ленты бумажной для плоттеров 80 г/м2, ф. 1800 мм",{"$f":"IF(P19=\"Резка и упаковка ленты бумажной для плоттеров 80 г/м2, ф. 1800 мм\",8356)","v":8356}]
[19,"Волегов А.Г.",{"$f":"IF(B20=\"Волегов А.Г.\",208)","v":208},null,null,null,null,null,null,"","Разм. РПО 4 р.",{"$f":"IF(K20=\"Разм. РПО 4 р.\",6375)","v":6375},"6'",null,null,"Резка и упаковка ленты бумажной для плоттеров 80 г/м2, ф. 1900 мм",{"$f":"IF(P20=\"Резка и упаковка ленты бумажной для плоттеров 80 г/м2, ф. 1900 мм\",8356)","v":8356}]
[20,"Волегова Г.И.",{"$f":"IF(B21=\"Волегова Г.И.\",707)","v":707},null,null,null,null,null,null,"","Разм. РПО 4 р. %",{"$f":"IF(K21=\"Разм. РПО 4 р. %\",6375)","v":6375},"7'",null,null,"Резка и упаковка ленты бумажной для плоттеров 80 г/м2, ф. 2000 мм",{"$f":"IF(P21=\"Резка и упаковка ленты бумажной для плоттеров 80 г/м2, ф. 2000 мм\",8356)","v":8356}]
[21,"Воронцевич М.П.",{"$f":"IF(B22=\"Воронцевич М.П.\",298)","v":298},null,null,null,null,null,null,"","Разм. РПО 5 р.",{"$f":"IF(K22=\"Разм. РПО 5 р.\",7024)","v":7024},"8'",null,null,"Смена верхних сушильных сеток 1-5-й сушильных групп",{"$f":"IF(P22=\"Смена верхних сушильных сеток 1-5-й сушильных групп\",168705)","v":168705}]
[22,"Гарбузов Г.Л.",{"$f":"IF(B23=\"Гарбузов Г.Л.\",381)","v":381},null,null,null,null,null,null,"","Резчик ПРС 3 р.",{"$f":"IF(K23=\"Резчик ПРС 3 р.\",5481)","v":5481},"А",null,null,"Смена канатика",{"$f":"IF(P23=\"Смена канатика\",53279)","v":53279}]
[23,"Гвоздь М.П.",{"$f":"IF(B24=\"Гвоздь М.П.\",561)","v":561},null,null,null,null,null,null,"","Резчик ПРС 3 р. %",{"$f":"IF(K24=\"Резчик ПРС 3 р. %\",5481)","v":5481},"Б",null,null,"Смена нижних сушильных сеток 1-5-й сушильных групп",{"$f":"IF(P24=\"Смена нижних сушильных сеток 1-5-й сушильных групп\",171505)","v":171505}]
[24,"Гендик Н.В.",{"$f":"IF(B25=\"Гендик Н.В.\",552)","v":552},null,null,null,null,null,null,"","Резчик ПРС 4 р.",{"$f":"IF(K25=\"Резчик ПРС 4 р.\",6375)","v":6375},"В","Ед.изм",null,"Смена прессовых сукон БДМ№2",{"$f":"IF(P25=\"Смена прессовых сукон БДМ№2\",43914)","v":43914}]
[25,"Гончарук А.В.",{"$f":"IF(B26=\"Гончарук А.В.\",652)","v":652},null,null,null,null,null,null,"","Резчик ПРС 4 р. %",{"$f":"IF(K26=\"Резчик ПРС 4 р. %\",6375)","v":6375},"Г","Шт",null,"Смена прессовых сукон марки Гешмай со снятием сукна вруч-ю",{"$f":"IF(P26=\"Смена прессовых сукон марки Гешмай со снятием сукна вруч-ю\",139841)","v":139841}]
[26,"Гончарук Т.И.",{"$f":"IF(B27=\"Гончарук Т.И.\",479)","v":479},null,null,null,null,null,null,"","Сушильщик 4 р.",{"$f":"IF(K27=\"Сушильщик 4 р.\",6375)","v":6375},"К","Кг",null,"Смена сетки БДМ",{"$f":"IF(P27=\"Смена сетки БДМ\",285830)","v":285830}]
[27,"Гридюшко П.А.",{"$f":"IF(B28=\"Гридюшко П.А.\",1499)","v":1499},null,null,null,null,null,null,"","Сушильщик 4 р. %",{"$f":"IF(K28=\"Сушильщик 4 р. %\",6375)","v":6375},"О","Т",null,"Смена сетки БДМ№2",{"$f":"IF(P28=\"Смена сетки БДМ№2\",203513)","v":203513}]
[28,"Грузд Н.Н.",{"$f":"IF(B29=\"Грузд Н.Н.\",1311)","v":1311},null,null,null,null,null,null,"","Тран.мат-ов",null,"Ос",null,null,"Смена сушильных сеток БДМ№2",{"$f":"IF(P29=\"Смена сушильных сеток БДМ№2\",83586)","v":83586}]
[29,"Дворянкина Е.Л.",{"$f":"IF(B30=\"Дворянкина Е.Л.\",508)","v":508},null,null,null,null,null,null,"","Уб.быт.пом-й",null,"Оу",null,null,"Снятие сетки БДМ вручную",{"$f":"IF(P30=\"Снятие сетки БДМ вручную\",240807)","v":240807}]
[30,"Дик А.С.",{"$f":"IF(B31=\"Дик А.С.\",1089)","v":1089},null,null,null,null,null,null,"",null,null,"Пр",null,null,"Снятие сукна марки Гешмай",{"$f":"IF(P31=\"Снятие сукна марки Гешмай\",70261)","v":70261}]
[31,"Дорц Д.В.",{"$f":"IF(B32=\"Дорц Д.В.\",1147)","v":1147},null,null,null,null,null,null,"",null,null,"9'",null,null,"Упаковка ролевой бумаги",{"$f":"IF(P32=\"Упаковка ролевой бумаги\",3646)","v":3646}]
[32,"Драгун В.В.",{"$f":"IF(B33=\"Драгун В.В.\",481)","v":481},null,null,null,null,null,null,"",null,null,"10'",null,null,"Упаковка ролевой документной бумаги",{"$f":"IF(P33=\"Упаковка ролевой документной бумаги\",2512)","v":2512}]
[33,"Драпезо Ю.Н.",{"$f":"IF(B34=\"Драпезо Ю.Н.\",548)","v":548},null,null,null,null,null,null,"",null,null,"11'",null,null,"Установка иглопробивного сукна",{"$f":"IF(P34=\"Установка иглопробивного сукна\",83288)","v":83288}]
[34,"Драч М.В.",{"$f":"IF(B35=\"Драч М.В.\",1659)","v":1659},null,null,null,null,null,null,"",null,null,null,null,null,"Чистка ГРВ и ГРГ",{"$f":"IF(P35=\"Чистка ГРВ и ГРГ\",36134)","v":36134}]
[35,"Дроздецкий В.С.",{"$f":"IF(B36=\"Дроздецкий В.С.\",1335)","v":1335},null,null,null,null,null,null,"",null,null,null,null,null,"Чистка скребками и промывка бассейнов: машинного,массного",{"$f":"IF(P36=\"Чистка скребками и промывка бассейнов: машинного,массного\",43026)","v":43026}]
[36,"Дунаев С.Е.",{"$f":"IF(B37=\"Дунаев С.Е.\",2035)","v":2035},null,null,null,null,null,null,"",null,null,null,null,null,"Чистка скребками и промывка бассейнов: приёмный, размольный",{"$f":"IF(P37=\"Чистка скребками и промывка бассейнов: приёмный, размольный\",32283)","v":32283}]
[37,"Жавранок И.Г.",{"$f":"IF(B38=\"Жавранок И.Г.\",712)","v":712},null,null,null,null,null,null,"",null,null,null,null,null,"Чистка скребками и промывка бассейнов:избыт. и регистр.воды",{"$f":"IF(P38=\"Чистка скребками и промывка бассейнов:избыт. и регистр.воды\",32283)","v":32283}]
[38,"Жердочкина А.М.",{"$f":"IF(B39=\"Жердочкина А.М.\",1141)","v":1141},null,null,null,null,null,null,""]
[39,"Жизневская Т.Ф.",{"$f":"IF(B40=\"Жизневская Т.Ф.\",491)","v":491},null,null,null,null,null,null,""]
[40,"Жудрак Л.В.",{"$f":"IF(B41=\"Жудрак Л.В.\",1500)","v":1500},null,null,null,null,null,null,""]
[41,"Залан А.В.",{"$f":"IF(B42=\"Залан А.В.\",856)","v":856},null,null,null,null,null,null,""]
[42,"Захаров С.А.",{"$f":"IF(B43=\"Захаров С.А.\",853)","v":853},null,null,null,null,null,null,""]
[43,"Заяц Т.Л.",{"$f":"IF(B44=\"Заяц Т.Л.\",509)","v":509},null,null,null,null,null,null,""]
[44,"Зеленкевич  Нат.В.",{"$f":"IF(B45=\"Зеленкевич  Нат.В.\",501)","v":501},null,null,null,null,null,null,""]
[45,"Зеленкевич  Ник.В.",{"$f":"IF(B46=\"Зеленкевич  Ник.В.\",1083)","v":1083},null,null,null,null,null,null,""]
[46,"Зеленко В.Л.",{"$f":"IF(B47=\"Зеленко В.Л.\",1360)","v":1360},null,null,null,null,null,null,""]
[47,"Кадевич О.В.",{"$f":"IF(B48=\"Кадевич О.В.\",1379)","v":1379},null,null,null,null,null,null,""]
[48,"Каляпина К.А.",{"$f":"IF(B49=\"Каляпина К.А.\",1537)","v":1537},null,null,null,null,null,null,""]
[49,"Карась А.Н.",{"$f":"IF(B50=\"Карась А.Н.\",2100)","v":2100},null,null,null,null,null,null,""]
[50,"Кирилуша С.В.",{"$f":"IF(B51=\"Кирилуша С.В.\",497)","v":497},null,null,null,null,null,null,""]
[51,"Ковалёв Д.А.",{"$f":"IF(B52=\"Ковалёв Д.А.\",1538)","v":1538},null,null,null,null,null,null,""]
[52,"Коваль О.Г.",{"$f":"IF(B53=\"Коваль О.Г.\",1497)","v":1497},null,null,null,null,null,null,""]
[53,"Козаков С.Л.",{"$f":"IF(B54=\"Козаков С.Л.\",1404)","v":1404},null,null,null,null,null,null,""]
[54,"Комадей Д.В.",{"$f":"IF(B55=\"Комадей Д.В.\",1454)","v":1454},null,null,null,null,null,null,""]
[55,"Конон Н.В.",{"$f":"IF(B56=\"Конон Н.В.\",2338)","v":2338},null,null,null,null,null,null,""]
[56,"Короленко А.В.",{"$f":"IF(B57=\"Короленко А.В.\",532)","v":532},null,null,null,null,null,null,""]
[57,"Костин А.М.",{"$f":"IF(B58=\"Костин А.М.\",1653)","v":1653},null,null,null,null,null,null,""]
[58,"Кудревич О.М.",{"$f":"IF(B59=\"Кудревич О.М.\",170)","v":170},null,null,null,null,null,null,""]
[59,"Кузьбар И.Н.",{"$f":"IF(B60=\"Кузьбар И.Н.\",1637)","v":1637},null,null,null,null,null,null,""]
[60,"Курносова О.Ф.",{"$f":"IF(B61=\"Курносова О.Ф.\",478)","v":478},null,null,null,null,null,null,""]
[61,"Кучинская Е.М.",{"$f":"IF(B62=\"Кучинская Е.М.\",708)","v":708},null,null,null,null,null,null,""]
[62,"Лебедев О.Л.",{"$f":"IF(B63=\"Лебедев О.Л.\",514)","v":514},null,null,null,null,null,null,""]
[63,"Ливанович С.В.",{"$f":"IF(B64=\"Ливанович С.В.\",536)","v":536},null,null,null,null,null,null,""]
[64,"Лысковец А.Н.",{"$f":"IF(B65=\"Лысковец А.Н.\",1291)","v":1291},null,null,null,null,null,null,""]
[65,"Лысковец О.И.",{"$f":"IF(B66=\"Лысковец О.И.\",1517)","v":1517},null,null,null,null,null,null,""]
[66,"Макатерчик А.Н.",{"$f":"IF(B67=\"Макатерчик А.Н.\",1307)","v":1307},null,null,null,null,null,null,{"$f":"IF(I67=\"\",\"\",SUM(TODAY()-I67)/365)","v":""}]
[67,"Макрицкий Ю.В.",{"$f":"IF(B68=\"Макрицкий Ю.В.\",2108)","v":2108},null,null,null,null,null,null,""]
[68,"Маркелов Д.Н.",{"$f":"IF(B69=\"Маркелов Д.Н.\",1675)","v":1675},null,null,null,null,null,null,""]
[69,"Мисник Ю.А.",{"$f":"IF(B70=\"Мисник Ю.А.\",603)","v":603},null,null,null,null,null,null,""]
[70,"Мишук А.В.",{"$f":"IF(B71=\"Мишук А.В.\",1677)","v":1677},null,null,null,null,null,null,""]
[71,"Мишук В.В.",{"$f":"IF(B72=\"Мишук В.В.\",2037)","v":2037},null,null,null,null,null,null,""]
[72,"Мишук О.В.",{"$f":"IF(B73=\"Мишук О.В.\",2127)","v":2127},null,null,null,null,null,null,""]
[73,"Мишук Р.В.",{"$f":"IF(B74=\"Мишук Р.В.\",300)","v":300},null,null,null,null,null,null,""]
[74,"Мороз А.П.",{"$f":"IF(B75=\"Мороз А.П.\",1503)","v":1503},null,null,null,null,null,null,""]
[75,"Новоселов А.В.",{"$f":"IF(B76=\"Новоселов А.В.\",1508)","v":1508},null,null,null,null,null,null,""]
[76,"Орловский А.М.",{"$f":"IF(B77=\"Орловский А.М.\",1674)","v":1674},null,null,null,null,null,null,""]
[77,"Пантелей А.В.",{"$f":"IF(B78=\"Пантелей А.В.\",833)","v":833},null,null,null,null,null,null,""]
[78,"Петров В.А.",{"$f":"IF(B79=\"Петров В.А.\",1393)","v":1393},null,null,null,null,null,null,""]
[79,"Петровых В.В.",{"$f":"IF(B80=\"Петровых В.В.\",2255)","v":2255},null,null,null,null,null,null,""]
[80,"Поплавский В.И.",{"$f":"IF(B81=\"Поплавский В.И.\",255)","v":255},null,null,null,null,null,null,""]
[81,"Пресняков Г.В.",{"$f":"IF(B82=\"Пресняков Г.В.\",1676)","v":1676},null,null,null,null,null,null,""]
[82,"Раловец Л.П.",{"$f":"IF(B83=\"Раловец Л.П.\",572)","v":572},null,null,null,null,null,null,""]
[83,"Романов В.В.",{"$f":"IF(B84=\"Романов В.В.\",2095)","v":2095},null,null,null,null,null,null,""]
[84,"Романчук В.В.",{"$f":"IF(B85=\"Романчук В.В.\",338)","v":338},null,null,null,null,null,null,""]
[85,"Ротченкова С.С.",{"$f":"IF(B86=\"Ротченкова С.С.\",231)","v":231},null,null,null,null,null,null,""]
[86,"Рощупкина Л.И.",{"$f":"IF(B87=\"Рощупкина Л.И.\",1608)","v":1608},null,null,null,null,null,null,""]
[87,"Рудницкий С.Н.",{"$f":"IF(B88=\"Рудницкий С.Н.\",465)","v":465},null,null,null,null,null,null,""]
[88,"Рябов О.С.",{"$f":"IF(B89=\"Рябов О.С.\",462)","v":462},null,null,null,null,null,null,""]
[89,"Савельева Н.И.",{"$f":"IF(B90=\"Савельева Н.И.\",534)","v":534},null,null,null,null,null,null,""]
[90,"Сандульская Л.А.",{"$f":"IF(B91=\"Сандульская Л.А.\",420)","v":420},null,null,null,null,null,null,""]
[91,"Сацук А.Л.",{"$f":"IF(B92=\"Сацук А.Л.\",761)","v":761},null,null,null,null,null,null,""]
[92,"Сацукевич С.П.",{"$f":"IF(B93=\"Сацукевич С.П.\",265)","v":265},null,null,null,null,null,null,""]
[93,"Свидрицкая В.С.",{"$f":"IF(B94=\"Свидрицкая В.С.\",1256)","v":1256},null,null,null,null,null,null,""]
[94,"Серий В.А.",{"$f":"IF(B95=\"Серий В.А.\",515)","v":515},null,null,null,null,null,null,""]
[95,"Симонова Т.В.",{"$f":"IF(B96=\"Симонова Т.В.\",519)","v":519},null,null,null,null,null,null,""]
[96,"Скачек А.В.",{"$f":"IF(B97=\"Скачек А.В.\",1649)","v":1649},null,null,null,null,null,null,""]
[97,"Хомич Н.Н.",{"$f":"IF(B98=\"Хомич Н.Н.\",589)","v":589},null,null,null,null,null,null,""]
[98,"Хомодеев В.В.",{"$f":"IF(B99=\"Хомодеев В.В.\",2325)","v":2325},null,null,null,null,null,null,""]
[99,"Цедрик Т.Н.",{"$f":"IF(B100=\"Цедрик Т.Н.\",1140)","v":1140},null,null,null,null,null,null,""]
[100,"Шаповалов В.А.",{"$f":"IF(B101=\"Шаповалов В.А.\",1316)","v":1316},null,null,null,null,null,null,""]
[101,"Шерий Д.В.",{"$f":"IF(B102=\"Шерий Д.В.\",563)","v":563},null,null,null,null,null,null,""]
[102,"Ясинский В.С.",{"$f":"IF(B103=\"Ясинский В.С.\",70)","v":70},null,null,null,null,null,null,""]
[103,null,null,null,null,null,null,null,null,""]
[104]
[105,null,null,null,null,null,null,null,null,{"$f":"IF(I106=\"\",\"\",SUM(TODAY()-I106)/365)","v":""}]
[106,null,null,null,null,null,null,null,null,""]
[107,null,null,null,null,null,null,null,null,""]
[108,null,null,null,null,null,null,null,null,""]
[109,null,null,null,null,null,null,null,null,""]
[110,null,null,null,null,null,null,null,null,""]
[111,null,null,null,null,null,null,null,null,""]
[112,null,null,null,null,null,null,null,null,""]
[113,null,null,null,null,null,null,null,null,""]
[114,null,null,null,null,null,null,null,null,""]
[115,null,null,null,null,null,null,null,null,""]
[116,null,null,null,null,null,null,null,null,""]
[117,null,null,null,null,null,null,null,null,""]
[118,null,null,null,null,null,null,null,null,""]
[119,null,null,null,null,null,null,null,null,""]
[120,null,null,null,null,null,null,null,null,""]
[121,null,null,null,null,null,null,null,null,""]
[122,null,null,null,null,null,null,null,null,""]
[123,null,null,null,null,null,null,null,null,""]
[124,null,null,null,null,null,null,null,null,""]
[125,null,null,null,null,null,null,null,null,""]
[126,null,null,null,null,null,null,null,null,""]
[127,null,null,null,null,null,null,null,null,""]
[128,null,null,null,null,null,null,null,null,""]
[129,null,null,null,null,null,null,null,null,""]
[130,null,null,null,null,null,null,null,null,{"$f":"IF(I131=\"\",\"\",SUM(TODAY()-I131)/365)","v":""}]
[131,null,null,null,null,null,null,null,null,""]
[132,null,null,null,null,null,null,null,null,""]
[133,null,null,null,null,null,null,null,null,""]
[134,null,null,null,null,null,null,null,null,""]
[135,null,null,null,null,null,null,null,null,""]
[136,null,null,null,null,null,null,null,null,""]
[137,null,null,null,null,null,null,null,null,""]
[138,null,null,null,null,null,null,null,null,""]
[139,null,null,null,null,null,null,null,null,""]
[140,null,null,null,null,null,null,null,null,""]
[141,null,null,null,null,null,null,null,null,""]
[142,null,null,null,null,null,null,null,null,""]
[143,null,null,null,null,null,null,null,null,""]
[144,null,null,null,null,null,null,null,null,""]
[145,null,null,null,null,null,null,null,null,""]
[146,null,null,null,null,null,null,null,null,""]
[147,null,null,null,null,null,null,null,null,""]
[148,null,null,null,null,null,null,null,null,""]
[149,null,null,null,null,null,null,null,null,""]
[150,null,null,null,null,null,null,null,null,""]