{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["БДМ№1","Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":47,"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":"БДМ№1","index":0,"n_rows":49,"n_cols":37,"rows_kept":49,"cut":false,"hidden":false,"merged":[[2,35,3,35],[48,8,48,13],[48,18,48,21],[48,22,48,26],[0,1,0,2],[0,8,0,13],[0,14,0,30],[2,1,3,1],[2,2,3,3],[2,4,2,34]]}
[null,{"$f":"[1]Начальная!C12","v":"2015-08-01"},null,{"$f":"[1]Начальная!C10","v":"см. Хомич Н.Н."},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,{"$f":"[1]Начальная!C12","v":"2015-08-01"},{"$f":"E4+1","v":"2015-08-02"},{"$f":"F4+1","v":"2015-08-03"},"2015-08-04","2015-08-05","2015-08-06","2015-08-07","2015-08-08","2015-08-09","2015-08-10","2015-08-11","2015-08-12","2015-08-13","2015-08-14","2015-08-15","2015-08-16","2015-08-17","2015-08-18","2015-08-19","2015-08-20","2015-08-21","2015-08-22","2015-08-23","2015-08-24","2015-08-25","2015-08-26","2015-08-27","2015-08-28","2015-08-29","2015-08-30","2015-08-31"]
[1,{"$f":"IFERROR(VLOOKUP(C5,[1]Список!$B$2:$C$150,2,0),\"\")","v":465},"Рудницкий С.Н.","Машинист 6 р.",null,null,null,null,8,null,null,null,null,null,null,7,7.5,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(SUM(IF(RIGHTB(D5)=\"%\",TEXT(INDEX(E$5:AI5,MATCH(LEFTB(C5,SEARCH(\"%\",D5)),(C$5:C5),),),\"0;0;12\")*E5:AI5%,E5:AI5))),\"\",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":30.5}]
[null,{"$f":"IFERROR(VLOOKUP(C6,[1]Список!$B$2:$C$150,2,0),\"\")","v":465},"Рудницкий С.Н.","Сушильщик 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":"IF(ISNA(SUM(IF(RIGHTB(D6)=\"%\",TEXT(INDEX(E$5:AI6,MATCH(LEFTB(C6,SEARCH(\"%\",D6)),(C$5:C6),),),\"0;0;12\")*E6:AI6%,E6:AI6))),\"\",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,[1]Список!$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":"IF(ISNA(SUM(IF(RIGHTB(D7)=\"%\",TEXT(INDEX(E$5:AI7,MATCH(LEFTB(C7,SEARCH(\"%\",D7)),(C$5:C7),),),\"0;0;12\")*E7:AI7%,E7:AI7))),\"\",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,[1]Список!$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":"IF(ISNA(SUM(IF(RIGHTB(D8)=\"%\",TEXT(INDEX(E$5:AI8,MATCH(LEFTB(C8,SEARCH(\"%\",D8)),(C$5:C8),),),\"0;0;12\")*E8:AI8%,E8:AI8))),\"\",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}]
[2.0300000000000002,{"$f":"IFERROR(VLOOKUP(C9,[1]Список!$B$2:$C$150,2,0),\"\")","v":761},"Сацук А.Л.","Машинист 6 р.",null,null,null,null,12,null,null,12,12,null,null,9.5,11.5,null,null,null,12,null,null,12,11,null,null,12,12,null,null,null,null,null,null,{"$f":"IF(ISNA(SUM(IF(RIGHTB(D9)=\"%\",TEXT(INDEX(E$5:AI9,MATCH(LEFTB(C9,SEARCH(\"%\",D9)),(C$5:C9),),),\"0;0;12\")*E9:AI9%,E9:AI9))),\"\",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":116},{"$f":"SEARCH(\"%\",D10)","v":15}]
[null,{"$f":"IFERROR(VLOOKUP(C10,[1]Список!$B$2:$C$150,2,0),\"\")","v":761},"Сацук А.Л.","Накатчик 3 р. %",null,null,null,null,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(SUM(IF(RIGHTB(D10)=\"%\",TEXT(INDEX(E$5:AI10,MATCH(LEFTB(C10,SEARCH(\"%\",D10)),(C$5:C10),),),\"0;0;12\")*E10:AI10%,E10:AI10))),\"\",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":6}]
[null,{"$f":"IFERROR(VLOOKUP(C11,[1]Список!$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":"IF(ISNA(SUM(IF(RIGHTB(D11)=\"%\",TEXT(INDEX(E$5:AI11,MATCH(LEFTB(C11,SEARCH(\"%\",D11)),(C$5:C11),),),\"0;0;12\")*E11:AI11%,E11:AI11))),\"\",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,[1]Список!$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":"IF(ISNA(SUM(IF(RIGHTB(D12)=\"%\",TEXT(INDEX(E$5:AI12,MATCH(LEFTB(C12,SEARCH(\"%\",D12)),(C$5:C12),),),\"0;0;12\")*E12:AI12%,E12:AI12))),\"\",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}]
[3,{"$f":"IFERROR(VLOOKUP(C13,[1]Список!$B$2:$C$150,2,0),\"\")","v":1674},"Орловский А.М.","Перссовщик 3 р.",null,null,null,12,12,null,null,12,12,null,null,9.5,11.5,null,null,12,12,null,null,12,11,null,null,12,12,null,null,null,null,null,null,{"$f":"IF(ISNA(SUM(IF(RIGHTB(D13)=\"%\",TEXT(INDEX(E$5:AI13,MATCH(LEFTB(C13,SEARCH(\"%\",D13)),(C$5:C13),),),\"0;0;12\")*E13:AI13%,E13:AI13))),\"\",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":140},{"$f":"ISERROR(SEARCH(\"%\",D13))","v":true}]
[null,{"$f":"IFERROR(VLOOKUP(C14,[1]Список!$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":"IF(ISNA(SUM(IF(RIGHTB(D14)=\"%\",TEXT(INDEX(E$5:AI14,MATCH(LEFTB(C14,SEARCH(\"%\",D14)),(C$5:C14),),),\"0;0;12\")*E14:AI14%,E14:AI14))),\"\",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,[1]Список!$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":"IF(ISNA(SUM(IF(RIGHTB(D15)=\"%\",TEXT(INDEX(E$5:AI15,MATCH(LEFTB(C15,SEARCH(\"%\",D15)),(C$5:C15),),),\"0;0;12\")*E15:AI15%,E15:AI15))),\"\",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,[1]Список!$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":"IF(ISNA(SUM(IF(RIGHTB(D16)=\"%\",TEXT(INDEX(E$5:AI16,MATCH(LEFTB(C16,SEARCH(\"%\",D16)),(C$5:C16),),),\"0;0;12\")*E16:AI16%,E16:AI16))),\"\",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}]
[4,{"$f":"IFERROR(VLOOKUP(C17,[1]Список!$B$2:$C$150,2,0),\"\")","v":1179},"Брикун М.А.","Сушильщик 4 р.",null,null,null,null,12,null,null,12,12,null,null,9.5,11.5,null,null,null,12,null,null,12,11,null,null,12,12,null,null,null,null,null,null,{"$f":"IF(ISNA(SUM(IF(RIGHTB(D17)=\"%\",TEXT(INDEX(E$5:AI17,MATCH(LEFTB(C17,SEARCH(\"%\",D17)),(C$5:C17),),),\"0;0;12\")*E17:AI17%,E17:AI17))),\"\",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":116}]
[null,{"$f":"IFERROR(VLOOKUP(C18,[1]Список!$B$2:$C$150,2,0),\"\")","v":1179},"Брикун М.А.","Накатчик 3 р. %",null,null,null,null,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(SUM(IF(RIGHTB(D18)=\"%\",TEXT(INDEX(E$5:AI18,MATCH(LEFTB(C18,SEARCH(\"%\",D18)),(C$5:C18),),),\"0;0;12\")*E18:AI18%,E18:AI18))),\"\",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":6}]
[null,{"$f":"IFERROR(VLOOKUP(C19,[1]Список!$B$2:$C$150,2,0),\"\")","v":1179},"Брикун М.А.","Разм. брака 2 р. %",null,null,null,null,null,null,null,50,50,null,null,50,50,null,null,null,50,null,null,50,50,null,null,50,50,null,null,null,null,null,null,{"$f":"IF(ISNA(SUM(IF(RIGHTB(D19)=\"%\",TEXT(INDEX(E$5:AI19,MATCH(LEFTB(C19,SEARCH(\"%\",D19)),(C$5:C19),),),\"0;0;12\")*E19:AI19%,E19:AI19))),\"\",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":52.5}]
[null,{"$f":"IFERROR(VLOOKUP(C20,[1]Список!$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":"IF(ISNA(SUM(IF(RIGHTB(D20)=\"%\",TEXT(INDEX(E$5:AI20,MATCH(LEFTB(C20,SEARCH(\"%\",D20)),(C$5:C20),),),\"0;0;12\")*E20:AI20%,E20:AI20))),\"\",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}]
[5,{"$f":"IFERROR(VLOOKUP(C21,[1]Список!$B$2:$C$150,2,0),\"\")","v":1291},"Лысковец А.Н.","Накатчик 3 р.",null,null,null,null,null,null,null,12,12,null,null,9.5,11.5,null,null,null,12,null,null,12,11,null,null,12,12,null,null,null,null,null,null,{"$f":"IF(ISNA(SUM(IF(RIGHTB(D21)=\"%\",TEXT(INDEX(E$5:AI21,MATCH(LEFTB(C21,SEARCH(\"%\",D21)),(C$5:C21),),),\"0;0;12\")*E21:AI21%,E21:AI21))),\"\",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":104}]
[]
[null,{"$f":"IFERROR(VLOOKUP(C23,[1]Список!$B$2:$C$150,2,0),\"\")","v":1339},"Аниськович А.П.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(SUM(IF(RIGHTB(D23)=\"%\",TEXT(INDEX(E$5:AI23,MATCH(LEFTB(C23,SEARCH(\"%\",D23)),(C$5:C23),),),\"0;0;12\")*E23:AI23%,E23:AI23))),\"\",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,[1]Список!$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":"IF(ISNA(SUM(IF(RIGHTB(D24)=\"%\",TEXT(INDEX(E$5:AI24,MATCH(LEFTB(C24,SEARCH(\"%\",D24)),(C$5:C24),),),\"0;0;12\")*E24:AI24%,E24:AI24))),\"\",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}]
[6,{"$f":"IFERROR(VLOOKUP(C25,[1]Список!$B$2:$C$150,2,0),\"\")","v":491},"Жизневская Т.Ф.","Разм. РПО 4 р.",null,null,null,12,12,null,null,12,12,null,null,9.5,11.5,null,null,12,12,null,null,12,11,null,null,12,12,null,null,null,null,null,null,{"$f":"IF(ISNA(SUM(IF(RIGHTB(D25)=\"%\",TEXT(INDEX(E$5:AI25,MATCH(LEFTB(C25,SEARCH(\"%\",D25)),(C$5:C25),),),\"0;0;12\")*E25:AI25%,E25:AI25))),\"\",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":140}]
[null,{"$f":"IFERROR(VLOOKUP(C26,[1]Список!$B$2:$C$150,2,0),\"\")","v":491},"Жизневская Т.Ф.","Разм. РПО 3 р. %",null,null,null,100,100,null,null,100,100,null,null,100,100,null,null,100,100,null,null,100,100,null,null,100,100,null,null,null,null,null,null,{"$f":"IF(ISNA(SUM(IF(RIGHTB(D26)=\"%\",TEXT(INDEX(E$5:AI26,MATCH(LEFTB(C26,SEARCH(\"%\",D26)),(C$5:C26),),),\"0;0;12\")*E26:AI26%,E26:AI26))),\"\",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":141}]
[null,{"$f":"IFERROR(VLOOKUP(C27,[1]Список!$B$2:$C$150,2,0),\"\")","v":491},"Жизневская Т.Ф.","Ап.пр.хим.р-в 3 р. %",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,null,null,null,{"$f":"IF(ISNA(SUM(IF(RIGHTB(D27)=\"%\",TEXT(INDEX(E$5:AI27,MATCH(LEFTB(C27,SEARCH(\"%\",D27)),(C$5:C27),),),\"0;0;12\")*E27:AI27%,E27:AI27))),\"\",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":58}]
[null,{"$f":"IFERROR(VLOOKUP(C28,[1]Список!$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":"IF(ISNA(SUM(IF(RIGHTB(D28)=\"%\",TEXT(INDEX(E$5:AI28,MATCH(LEFTB(C28,SEARCH(\"%\",D28)),(C$5:C28),),),\"0;0;12\")*E28:AI28%,E28:AI28))),\"\",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,[1]Список!$B$2:$C$150,2,0),\"\")","v":856},"Залан А.В.","Разм. РПО 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":"IF(ISNA(SUM(IF(RIGHTB(D29)=\"%\",TEXT(INDEX(E$5:AI29,MATCH(LEFTB(C29,SEARCH(\"%\",D29)),(C$5:C29),),),\"0;0;12\")*E29:AI29%,E29:AI29))),\"\",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,[1]Список!$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":"IF(ISNA(SUM(IF(RIGHTB(D30)=\"%\",TEXT(INDEX(E$5:AI30,MATCH(LEFTB(C30,SEARCH(\"%\",D30)),(C$5:C30),),),\"0;0;12\")*E30:AI30%,E30:AI30))),\"\",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,[1]Список!$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":"IF(ISNA(SUM(IF(RIGHTB(D31)=\"%\",TEXT(INDEX(E$5:AI31,MATCH(LEFTB(C31,SEARCH(\"%\",D31)),(C$5:C31),),),\"0;0;12\")*E31:AI31%,E31:AI31))),\"\",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,[1]Список!$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":"IF(ISNA(SUM(IF(RIGHTB(D32)=\"%\",TEXT(INDEX(E$5:AI32,MATCH(LEFTB(C32,SEARCH(\"%\",D32)),(C$5:C32),),),\"0;0;12\")*E32:AI32%,E32:AI32))),\"\",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}]
[7,{"$f":"IFERROR(VLOOKUP(C33,[1]Список!$B$2:$C$150,2,0),\"\")","v":1311},"Грузд Н.Н.","Ап.пр.хим.р-в 3 р.",null,null,null,null,null,null,null,null,null,null,null,9.5,null,null,null,12,12,null,null,12,11,null,null,12,12,null,null,null,null,null,null,{"$f":"IF(ISNA(SUM(IF(RIGHTB(D33)=\"%\",TEXT(INDEX(E$5:AI33,MATCH(LEFTB(C33,SEARCH(\"%\",D33)),(C$5:C33),),),\"0;0;12\")*E33:AI33%,E33:AI33))),\"\",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":80.5}]
[null,{"$f":"IFERROR(VLOOKUP(C34,[1]Список!$B$2:$C$150,2,0),\"\")","v":1311},"Грузд Н.Н.","Разм. ПО 3 р. %",null,null,null,null,null,null,null,null,null,null,null,50,null,null,null,100,100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(SUM(IF(RIGHTB(D34)=\"%\",TEXT(INDEX(E$5:AI34,MATCH(LEFTB(C34,SEARCH(\"%\",D34)),(C$5:C34),),),\"0;0;12\")*E34:AI34%,E34:AI34))),\"\",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":29}]
[null,{"$f":"IFERROR(VLOOKUP(C35,[1]Список!$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":"IF(ISNA(SUM(IF(RIGHTB(D35)=\"%\",TEXT(INDEX(E$5:AI35,MATCH(LEFTB(C35,SEARCH(\"%\",D35)),(C$5:C35),),),\"0;0;12\")*E35:AI35%,E35:AI35))),\"\",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,[1]Список!$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":"IF(ISNA(SUM(IF(RIGHTB(D36)=\"%\",TEXT(INDEX(E$5:AI36,MATCH(LEFTB(C36,SEARCH(\"%\",D36)),(C$5:C36),),),\"0;0;12\")*E36:AI36%,E36:AI36))),\"\",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}]
[8,{"$f":"IFERROR(VLOOKUP(C37,[1]Список!$B$2:$C$150,2,0),\"\")","v":170},"Кудревич О.М.","Ап.пр.хим.р-в 3 р.",null,null,null,12,12,null,null,12,12,null,null,9.5,11.5,null,null,12,12,null,null,12,11,null,null,12,12,null,null,null,null,null,null,{"$f":"IF(ISNA(SUM(IF(RIGHTB(D37)=\"%\",TEXT(INDEX(E$5:AI37,MATCH(LEFTB(C37,SEARCH(\"%\",D37)),(C$5:C37),),),\"0;0;12\")*E37:AI37%,E37:AI37))),\"\",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":140}]
[null,{"$f":"IFERROR(VLOOKUP(C38,[1]Список!$B$2:$C$150,2,0),\"\")","v":170},"Кудревич О.М.","Ап.пр.хим.р-в 3 р. %",null,null,null,100,100,null,null,100,100,null,null,null,100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(SUM(IF(RIGHTB(D38)=\"%\",TEXT(INDEX(E$5:AI38,MATCH(LEFTB(C38,SEARCH(\"%\",D38)),(C$5:C38),),),\"0;0;12\")*E38:AI38%,E38:AI38))),\"\",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":60}]
[null,{"$f":"IFERROR(VLOOKUP(C39,[1]Список!$B$2:$C$150,2,0),\"\")","v":170},"Кудревич О.М.","Разм. ПО 3 р. %",null,null,null,null,null,null,null,null,null,null,null,50,null,null,null,100,100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(SUM(IF(RIGHTB(D39)=\"%\",TEXT(INDEX(E$5:AI39,MATCH(LEFTB(C39,SEARCH(\"%\",D39)),(C$5:C39),),),\"0;0;12\")*E39:AI39%,E39:AI39))),\"\",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":29}]
[null,{"$f":"IFERROR(VLOOKUP(C40,[1]Список!$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":"IF(ISNA(SUM(IF(RIGHTB(D40)=\"%\",TEXT(INDEX(E$5:AI40,MATCH(LEFTB(C40,SEARCH(\"%\",D40)),(C$5:C40),),),\"0;0;12\")*E40:AI40%,E40:AI40))),\"\",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}]
[9,{"$f":"IFERROR(VLOOKUP(C41,[1]Список!$B$2:$C$150,2,0),\"\")","v":509},"Заяц Т.Л.","Резчик ПРС 4 р.",null,null,null,12,12,null,null,12,12,null,null,9.5,11.5,null,null,12,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(SUM(IF(RIGHTB(D41)=\"%\",TEXT(INDEX(E$5:AI41,MATCH(LEFTB(C41,SEARCH(\"%\",D41)),(C$5:C41),),),\"0;0;12\")*E41:AI41%,E41:AI41))),\"\",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":93}]
[null,{"$f":"IFERROR(VLOOKUP(C42,[1]Список!$B$2:$C$150,2,0),\"\")","v":509},"Заяц Т.Л.","Резчик ПРС 3 р. %",null,null,null,100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(SUM(IF(RIGHTB(D42)=\"%\",TEXT(INDEX(E$5:AI42,MATCH(LEFTB(C42,SEARCH(\"%\",D42)),(C$5:C42),),),\"0;0;12\")*E42:AI42%,E42:AI42))),\"\",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":12}]
[null,{"$f":"IFERROR(VLOOKUP(C43,[1]Список!$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":"IF(ISNA(SUM(IF(RIGHTB(D43)=\"%\",TEXT(INDEX(E$5:AI43,MATCH(LEFTB(C43,SEARCH(\"%\",D43)),(C$5:C43),),),\"0;0;12\")*E43:AI43%,E43:AI43))),\"\",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,{"$f":"IFERROR(VLOOKUP(C44,[1]Список!$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":"IF(ISNA(SUM(IF(RIGHTB(D44)=\"%\",TEXT(INDEX(E$5:AI44,MATCH(LEFTB(C44,SEARCH(\"%\",D44)),(C$5:C44),),),\"0;0;12\")*E44:AI44%,E44:AI44))),\"\",SUM(IF(RIGHTB(D44)=\"%\",TEXT(INDEX(E$5:AI44,MATCH(LEFTB(C44,SEARCH(\"%\",D44)),(C$5:C44),),),\"0;0;12\")*E44:AI44%,E44:AI44)))","v":0}]
[10,{"$f":"IFERROR(VLOOKUP(C45,[1]Список!$B$2:$C$150,2,0),\"\")","v":1538},"Ковалёв Д.А.","Резчик ПРС 3 р.",null,null,null,null,12,null,null,12,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(SUM(IF(RIGHTB(D45)=\"%\",TEXT(INDEX(E$5:AI45,MATCH(LEFTB(C45,SEARCH(\"%\",D45)),(C$5:C45),),),\"0;0;12\")*E45:AI45%,E45:AI45))),\"\",SUM(IF(RIGHTB(D45)=\"%\",TEXT(INDEX(E$5:AI45,MATCH(LEFTB(C45,SEARCH(\"%\",D45)),(C$5:C45),),),\"0;0;12\")*E45:AI45%,E45:AI45)))","v":36}]
[null,{"$f":"IFERROR(VLOOKUP(C46,[1]Список!$B$2:$C$150,2,0),\"\")","v":1538},"Ковалёв Д.А.","Разм. брака 2 р. %",null,null,null,null,100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(SUM(IF(RIGHTB(D46)=\"%\",TEXT(INDEX(E$5:AI46,MATCH(LEFTB(C46,SEARCH(\"%\",D46)),(C$5:C46),),),\"0;0;12\")*E46:AI46%,E46:AI46))),\"\",SUM(IF(RIGHTB(D46)=\"%\",TEXT(INDEX(E$5:AI46,MATCH(LEFTB(C46,SEARCH(\"%\",D46)),(C$5:C46),),),\"0;0;12\")*E46:AI46%,E46:AI46)))","v":12}]
[null,{"$f":"IFERROR(VLOOKUP(C47,[1]Список!$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":"IF(ISNA(SUM(IF(RIGHTB(D47)=\"%\",TEXT(INDEX(E$5:AI47,MATCH(LEFTB(C47,SEARCH(\"%\",D47)),(C$5:C47),),),\"0;0;12\")*E47:AI47%,E47:AI47))),\"\",SUM(IF(RIGHTB(D47)=\"%\",TEXT(INDEX(E$5:AI47,MATCH(LEFTB(C47,SEARCH(\"%\",D47)),(C$5:C47),),),\"0;0;12\")*E47:AI47%,E47:AI47)))","v":0}]
[]
[null,null,null,null,"Мастер смены:",null,null,null,{"$f":"[1]Начальная!C8","v":"Хомич Н.Н."},null,null,null,null,null,"___________",null,null,null,{"$f":"TODAY()","v":"2015-08-27"}]

{"sheet":"Лист1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист3","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}