{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Табель","Февраль","Штрафы"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Табель","index":0,"n_rows":5,"n_cols":80,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,77,1,78],[0,79,1,79],[0,75,1,75],[0,76,1,76],[0,71,0,73],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,0,64],[0,74,4,74],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,76,3,76],[2,71,3,71],[2,72,3,72],[2,73,3,73]]}
["№ з/п","Прізвище І.Б. ","Професія (посада)","ЛЮТИЙ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Об'єкт/  Завдання",29,"Об'єкт/  Завдання",30,"Об'єкт/  Завдання",31,"Об'єкт/  Завдання","Кількість робочих днів у мысяці","Фактично ","Вихідні"]
[1,"Ландичев О.В.","Головний інженер",5,"ТП881",4,"Каманина",null,null,null,null,4,"инфоком",4,"Каманина",4,"Инфокс",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"СумЦвет(D3:BS3,$CB$1)+ СумЦвет(D4:BS4,$BZ$1)","v":{"$error":"#VALUE!"}},{"$f":"СумЦвет(D3:BM3,$CB$1)+СумЦвет(D4:BM4,$BZ$1)","v":{"$error":"#VALUE!"}},null,null,"Ландичев О.В."]
[null,null,null,3,"Офис",4,"Новотех",null,null,null,null,4,"Офис",4,"Офис",4,"Офис",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"СумЦвет((D3,F3,H3,J3,L3,N3,P3,R3,T3,V3,X3,Z3,AB3,AD3,AF3,AH3,AJ3,AL3,AN3,AP3,AR3,AT3,AV3,AX3,AZ3,BB3,BD3,BF3,BN3,BP3,BR3),$BZ$1)","v":0}]
[2,"Іванов О.В.","Прораб",8.5,"Новотех",8.5,"Новотех",null,null,null,null,8.5,"Новотех",8.5,"Новотех",8.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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"СумЦвет(D5:BS5,$CB$1)","v":{"$error":"#VALUE!"}},{"$f":"СумЦвет(D5:BS5,$BZ$1)","v":0},null,null,"Іванов О.В."]

{"sheet":"Февраль","index":1,"n_rows":48,"n_cols":27,"rows_kept":48,"cut":false,"hidden":true,"merged":[[38,0,38,26],[43,0,43,26],[2,8,3,8],[4,0,4,25],[13,0,13,26],[17,0,17,26],[20,0,20,26],[0,23,3,23],[0,24,3,24],[0,25,3,25],[0,10,2,12],[0,13,2,13],[0,14,3,14],[0,15,2,17],[0,18,2,19],[10,0,10,26],[23,0,23,26],[47,0,47,1],[27,0,27,26],[0,26,4,26],[0,20,3,20],[0,21,3,21],[0,0,3,0],[0,1,3,1],[0,2,3,2],[0,3,3,3],[0,9,3,9],[0,4,1,8],[2,4,3,4],[2,5,3,5],[2,6,2,7],[0,22,3,22]]}
["№","Сотрудник","Оклад","Ставка","Ставки",null,null,null,null,"Предоплата","Аванс",null,null,"Выплачено","Недоплата/переплата","Остаток",null,null,"Выплачено",null,"Недоплата/переплата","Доп. Выплаты ","Штрафы","Премия","Отпускные","ИТОГО ЗА МЕСЯЦ"]
[]
[null,null,null,null,"В день","В выходной день","Переработка",null,"В больн./отпуск"]
[null,null,null,null,null,null,"раб. часы","вых. часы",null,null,"официально","на руки","всего","наличными",null,"официально","на руки","всего","наличными","на карточку"]
["ЯНВАРЬ"]
[1,"Ржепишевский К.К.",4200,0,{"$f":"D6/Табель!$BT$3","v":0},{"$f":"E6*1.5","v":0},{"$f":"E6/8","v":0},0,{"$f":"E6/2","v":0},0,null,0,{"$f":"K6","v":0},0,0,null,0,{"$f":"S6+T6+P6","v":0},0,{"$f":"IF((Q6-S6)<0, 0,Q6-S6)","v":0},{"$f":"Q6-(S6+T6)","v":0},null,null,0,null,{"$f":"J6+M6+R6+V6+X6+Y6","v":0},"Ржепишевский К.К."]
[2,"Ржепишевский Е.К.",4050,0,{"$f":"D7/Табель!$BT$3","v":0},0,0,0,0,0,null,0,{"$f":"K7","v":0},0,0,null,0,{"$f":"S7+T7+P7","v":0},0,{"$f":"IF((Q7-S7)<0, 0,Q7-S7)","v":0},{"$f":"Q7-(S7+T7)","v":0},null,null,0,null,{"$f":"J7+M7+R7+V7+X7+Y7","v":0},"Ржепишевский Е.К."]
[3,"Островский А.Н.",4100,0,{"$f":"D8/Табель!$BT$3","v":0},0,0,0,0,0,null,0,0,0,0,null,0,0,0,0,0,null,null,0,null,{"$f":"J8+M8+R8+V8+X8+Y8","v":0},"Островский А.Н."]
[4,"Лежанин В.",4700,0,{"$f":"D9/Табель!$BT$3","v":0},{"$f":"E9*1.5","v":0},{"$f":"E9/8","v":0},{"$f":"F9/8","v":0},{"$f":"E9/2","v":0},0,null,{"$f":"D9*0.25-J9","v":0},{"$f":"J9+K9+L9","v":0},0,0,null,0,0,0,0,0,null,null,0,null,{"$f":"J9+M9+R9+V9+X9+Y9","v":0},{"$f":"B9","v":"Лежанин В."}]
[5,"Деркач О. М.",3723,0,{"$f":"D10/Табель!$BT$3","v":0},{"$f":"E10*1.5","v":0},{"$f":"E10/8","v":0},{"$f":"F10/8","v":0},{"$f":"E10/2","v":0},0,null,0,0,0,0,null,0,{"$f":"S10+T10+P10","v":0},0,{"$f":"IF((Q10-S10)<0, 0,Q10-S10)","v":0},{"$f":"Q10-(S10+T10)","v":0},null,null,0,null,{"$f":"J10+M10+R10+V10+X10+Y10","v":0},"Деркач О. М."]
["              Інженери"]
[1,"Ландычев О.В.",4000,20000,{"$f":"D12/Табель!$BT$3","v":1000},1500,125,187.5,{"$f":"E12/2","v":500},0,null,{"$f":"D12/2-K12-J12","v":10000},{"$f":"J12+K12+L12","v":10000},null,{"$f":"M12-J12-K12-N12","v":10000},null,{"$f":"D12/2-P12+O12-#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},null,null,0,null,{"$f":"J12+M12+R12+V12+X12+Y12","v":{"$error":"#REF!"}},"Ландычев О.В."]
[2,"Иванов О.В.",0,15000,{"$f":"D13/Табель!$BT$3","v":750},1125,93.75,140.625,{"$f":"E13/2","v":375},0,0,{"$f":"D13/2-K13-J13","v":7500},{"$f":"J13+K13+L13","v":7500},null,{"$f":"M13-J13-K13-N13","v":7500},null,{"$f":"D13/2-P13+O13-#REF!-J13+Табель!BV5*F13+Табель!#REF!*G13+Табель!#REF!*H13-Табель!#REF!*E13-Табель!#REF!*I13-Табель!#REF!*I13-Табель!#REF!*E13","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,{"$f":"IF((Q13-S13)<0, 0,Q13-S13)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,0,null,{"$f":"J13+M13+R13+V13+X13+Y13","v":{"$error":"#REF!"}},"Иванов О.В."]
["            Господарська група"]
[3,"Димов Андрей",4000,6000,{"$f":"D15/Табель!$BT$3","v":300},{"$f":"E15*1.5","v":450},{"$f":"E15/8","v":37.5},{"$f":"F15/8","v":56.25},{"$f":"E15/2","v":150},0,null,{"$f":"D15/2-K15-J15","v":3000},{"$f":"J15+K15+L15","v":3000},null,{"$f":"M15-J15-K15-N15","v":3000},null,{"$f":"D15/2-P15+O15-#REF!-J15+Табель!#REF!*F15+Табель!#REF!*G15+Табель!#REF!*H15-Табель!#REF!*E15-Табель!#REF!*I15-Табель!#REF!*I15-Табель!#REF!*E15","v":{"$error":"#REF!"}},{"$f":"S15+T15+P15","v":{"$error":"#REF!"}},0,{"$f":"IF((Q15-S15)<0, 0,Q15-S15)","v":{"$error":"#REF!"}},{"$f":"Q15-(S15+T15)","v":{"$error":"#REF!"}},null,null,0,null,{"$f":"J15+M15+R15+V15+X15+Y15","v":{"$error":"#REF!"}},"Димов Андрей"]
[4,"Синика В.В.",0,12000,{"$f":"D16/Табель!$BT$3","v":600},900,75,112.5,300,0,null,{"$f":"D16/2-K16-J16","v":6000},{"$f":"J16+K16+L16","v":6000},null,{"$f":"M16-J16-K16-N16","v":6000},null,{"$f":"D16/2-P16+O16-#REF!-J16+Табель!#REF!*F16+Табель!#REF!*G16+Табель!#REF!*H16-Табель!#REF!*E16-Табель!#REF!*I16-Табель!#REF!*I16-Табель!#REF!*E16","v":{"$error":"#REF!"}},{"$f":"S16+T16+P16","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"},null,null,0,null,{"$f":"J16+M16+R16+V16+X16+Y16","v":{"$error":"#REF!"}},"Синика"]
[5,"Белоус А",0,6000,{"$f":"D17/Табель!$BT$3","v":300},450,37.5,56.25,150,0,0,{"$f":"D17/2-K17-J17","v":3000},{"$f":"J17+K17+L17","v":3000},null,3000,null,{"$f":"D17/2-P17+O17-#REF!-J17+Табель!#REF!*F17+Табель!#REF!*G17+Табель!#REF!*H17-Табель!#REF!*E17-Табель!#REF!*I17-Табель!#REF!*I17-Табель!#REF!*E17","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},null,null,0,null,{"$f":"J17+M17+R17+V17+X17+Y17","v":{"$error":"#REF!"}},"Белоус"]
["                ГНБ "]
[6,"Пуха Е.А.",3840,8000,{"$f":"D19/Табель!$BT$3","v":400},{"$f":"E19*1.5","v":600},{"$f":"E19/8","v":50},{"$f":"F19/8","v":75},{"$f":"E19/2","v":200},0,null,{"$f":"D19*0.25-J19","v":2000},{"$f":"J19+K19+L19","v":2000},null,2000,null,{"$f":"D19-M19-P19+O19-#REF!-J19+Табель!#REF!*F19+Табель!#REF!*G19+Табель!#REF!*H19-Табель!#REF!*E19-Табель!#REF!*I19-Табель!#REF!*I19-Табель!#REF!*E19","v":{"$error":"#REF!"}},{"$f":"S19+T19+P19","v":{"$error":"#REF!"}},0,{"$f":"IF((Q19-S19)<0, 0,Q19-S19)","v":{"$error":"#REF!"}},{"$f":"Q19-(S19+T19)","v":{"$error":"#REF!"}},null,null,0,null,{"$f":"J19+M19+R19+V19+X19+Y19","v":{"$error":"#REF!"}},"Пуха Е.А."]
[7,"Колбаса С.А.",1600,10000,{"$f":"D20/Табель!$BT$3","v":500},{"$f":"E20*1.5","v":750},{"$f":"E20/8","v":62.5},{"$f":"F20/8","v":93.75},{"$f":"E20/2","v":250},0,null,{"$f":"D20*0.25-J20","v":2500},2500,null,2500,null,{"$f":"D20-M20-P20+O20-#REF!-J20+Табель!#REF!*F20+Табель!#REF!*G20+Табель!#REF!*H20-Табель!#REF!*E20-Табель!#REF!*I20-Табель!#REF!*I20-Табель!#REF!*E20","v":{"$error":"#REF!"}},{"$f":"S20+T20+P20","v":{"$error":"#REF!"}},0,{"$f":"IF((Q20-S20)<0, 0,Q20-S20)","v":{"$error":"#REF!"}},{"$f":"Q20-(S20+T20)","v":{"$error":"#REF!"}},null,null,0,null,{"$f":"J20+M20+R20+V20+X20+Y20","v":{"$error":"#REF!"}},"Колбаса С.А."]
["                СМтаЕ"]
[8,"Морозюк Н.",{"$f":"3900/2","v":1950},10000,{"$f":"D22/Табель!$BT$3","v":500},{"$f":"E22*1.5","v":750},{"$f":"E22/8","v":62.5},{"$f":"F22/8","v":93.75},{"$f":"E22/2","v":250},0,null,{"$f":"D22*0.25-J22","v":2500},{"$f":"J22+K22+L22","v":2500},null,2500,null,{"$f":"D22-M22-P22-#REF!-J22+O22+Табель!#REF!*F22+Табель!#REF!*G22+Табель!#REF!*H22-Табель!#REF!*E22-Табель!#REF!*I22-Табель!#REF!*I22-Табель!#REF!*E22","v":{"$error":"#REF!"}},{"$f":"S22+T22+P22","v":{"$error":"#REF!"}},0,{"$f":"IF((Q22-S22)<0, 0,Q22-S22)","v":{"$error":"#REF!"}},{"$f":"Q22-(S22+T22)","v":{"$error":"#REF!"}},null,null,0,null,{"$f":"J22+M22+R22+V22+X22+Y22","v":{"$error":"#REF!"}},"Морозюк Н."]
[9,"Плющев А.С.",{"$f":"3840","v":3840},8000,{"$f":"D23/Табель!$BT$3","v":400},{"$f":"E23*1.5","v":600},{"$f":"E23/8","v":50},75,{"$f":"E23/2","v":200},0,null,{"$f":"D23*0.25-J23","v":2000},{"$f":"J23+K23+L23","v":2000},null,2000,null,{"$f":"D23-M23-P23-#REF!-J23+O23+Табель!#REF!*F23+Табель!#REF!*G23+Табель!#REF!*H23-Табель!#REF!*E23-Табель!#REF!*I23-Табель!#REF!*I23-Табель!#REF!*E23","v":{"$error":"#REF!"}},{"$f":"S23+T23+P23","v":{"$error":"#REF!"}},0,{"$f":"IF((Q23-S23)<0, 0,Q23-S23)","v":{"$error":"#REF!"}},{"$f":"Q23-(S23+T23)","v":{"$error":"#REF!"}},null,null,0,null,{"$f":"J23+M23+R23+V23+X23+Y23","v":{"$error":"#REF!"}},"Плющев А.С."]
["               ЕТЛ"]
[10,"Кривошея Андрей",3300,8000,{"$f":"D25/Табель!$BT$3","v":400},{"$f":"E25*1.5","v":600},{"$f":"E25/8","v":50},{"$f":"F25/8","v":75},{"$f":"E25/2","v":200},0,null,{"$f":"D25*0.25-J25","v":2000},{"$f":"J25+K25+L25","v":2000},null,2000,null,{"$f":"D25-M25-P25-#REF!-J25+O25+Табель!#REF!*F25+Табель!#REF!*G25+Табель!#REF!*H25-Табель!#REF!*E25-Табель!#REF!*I25-Табель!#REF!*I25-Табель!#REF!*E25","v":{"$error":"#REF!"}},{"$f":"P25+S25+T25","v":{"$error":"#REF!"}},0,{"$f":"IF((Q25-S25)<0, 0,Q25-S25)","v":{"$error":"#REF!"}},{"$f":"Q25-(S25+T25)","v":{"$error":"#REF!"}},null,null,0,null,{"$f":"J25+M25+R25+V25+X25+Y25","v":{"$error":"#REF!"}},"Кривошея Андрей"]
[11,"Корж И.И.",3520,10000,{"$f":"D26/Табель!$BT$3","v":500},{"$f":"E26*1.5","v":750},{"$f":"E26/8","v":62.5},{"$f":"F26/8","v":93.75},{"$f":"E26/2","v":250},0,null,{"$f":"D26*0.25-J26","v":2500},{"$f":"J26+K26+L26","v":2500},null,2500,null,{"$f":"D26-M26-P26-#REF!-J26+O26+Табель!#REF!*F26+Табель!#REF!*G26+Табель!#REF!*H26-Табель!#REF!*E26-Табель!#REF!*I26-Табель!#REF!*I26-Табель!#REF!*E26","v":{"$error":"#REF!"}},{"$f":"P26+S26+T26","v":{"$error":"#REF!"}},0,{"$f":"IF((Q26-S26)<0, 0,Q26-S26)","v":{"$error":"#REF!"}},{"$f":"Q26-(S26+T26)","v":{"$error":"#REF!"}},null,null,0,null,{"$f":"J26+M26+R26+V26+X26+Y26","v":{"$error":"#REF!"}},"Корж И.И."]
[12,"Карпов Д.П.",0,null,{"$f":"D27/Табель!$BT$3","v":0},0,0,0,{"$f":"E27/2","v":0},0,0,{"$f":"D27*0.25-J27","v":0},{"$f":"J27+K27+L27","v":0},null,0]
["               РМВЛ"]
[13,"Колпаков Денис",4700,15000,{"$f":"D29/Табель!$BT$3","v":750},{"$f":"E29*1.5","v":1125},{"$f":"E29/8","v":93.75},{"$f":"F29/8","v":140.625},{"$f":"E29/2","v":375},0,null,null,{"$f":"J29+K29+L29","v":0},null,0,null,{"$f":"#REF!-#REF!-J29","v":{"$error":"#REF!"}},{"$f":"P29+S29+T29","v":{"$error":"#REF!"}},0,{"$f":"IF((Q29-S29)<0, 0,Q29-S29)","v":{"$error":"#REF!"}},{"$f":"Q29-(S29+T29)","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"J29+M29+R29+V29+X29+Y29","v":{"$error":"#REF!"}},"Колпаков Денис"]
[14,"Чистяков А.",0,0,550,{"$f":"E30*1.5","v":825},68.75,{"$f":"F30/8","v":103.125},{"$f":"E30/2","v":275},0,0,null,{"$f":"J30+K30+L30","v":0},null,0,null,{"$f":"#REF!-#REF!-J30","v":{"$error":"#REF!"}},{"$f":"P30+S30+T30","v":{"$error":"#REF!"}},0,{"$f":"IF((Q30-S30)<0, 0,Q30-S30)","v":{"$error":"#REF!"}},{"$f":"Q30-(S30+T30)","v":{"$error":"#REF!"}},null,null,null,null,{"$error":"#REF!"},"Чистяков А."]
[15,"Пукас Н.",4103,0,550,825,68.75,103.125,275,0,null,null,0,null,0,null,{"$f":"#REF!-#REF!-J31","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,{"$error":"#REF!"},"Пукас Н."]
[16,"Петлюк В.",0,0,550,825,68.75,103.125,275,0,0,null,0,null,0,null,{"$f":"#REF!-#REF!-J32","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,{"$error":"#REF!"},"Петлюк В."]
[17,"Слободянюк А.",0,0,350,525,43.75,65.625,175,0,0,null,0,null,0,null,{"$f":"#REF!-#REF!-J33","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,{"$error":"#REF!"},"Горшков С.Ф."]
[18,"Сыдько",0,0,450,675,56.25,84.375,225,0,0,null,0,null,0,null,{"$f":"#REF!-#REF!-J34","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,{"$error":"#REF!"},"Слободянюк А."]
[19,"Трембич",0,0,450,675,56.25,84.375,225,0,0,null,0,null,0,null,{"$f":"#REF!-#REF!-J35","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,{"$error":"#REF!"},"Погорляк И."]
[20,"Русин",0,0,450,675,56.25,84.375,225,0,0,null,0,null,0,null,{"$f":"#REF!-#REF!-J36","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,{"$error":"#REF!"},"Платонов Ю.В."]
[21,"Булдик О.О.",0,0,450,675,56.25,84.375,225,0,0,null,0,null,0]
[22,"Булдик О.В.",0,0,450,675,56.25,84.375,225,0,0,null,0,null,0]
["               ПТГ"]
[23,"Красовский Д.Н.",3950,20000,{"$f":"D40/Табель!$BT$3","v":1000},{"$f":"E40*1.5","v":1500},{"$f":"E40/8","v":125},{"$f":"F40/8","v":187.5},{"$f":"E40/2","v":500},0,null,{"$f":"D40/2-K40-J40","v":10000},{"$f":"J40+K40+L40","v":10000},null,10000,null,{"$f":"D40/2-P40+O40-#REF!-J40","v":{"$error":"#REF!"}},{"$f":"S40+T40+P40","v":{"$error":"#REF!"}},0,{"$f":"IF((Q40-S40)<0, 0,Q40-S40)","v":{"$error":"#REF!"}},{"$f":"Q40-(S40+T40)","v":{"$error":"#REF!"}},null,null,0,null,{"$f":"J40+M40+R40+V40+X40+Y40","v":{"$error":"#REF!"}},"Красовский"]
[24,"Скальский А.В.",3550,10000,{"$f":"D41/Табель!$BT$3","v":500},{"$f":"E41*1.5","v":750},{"$f":"E41/8","v":62.5},{"$f":"F41/8","v":93.75},{"$f":"E41/2","v":250},0,null,{"$f":"D41/2-K41-J41","v":5000},{"$f":"J41+K41+L41","v":5000},null,5000,null,{"$f":"D41/2-P41+O41-#REF!-J41","v":{"$error":"#REF!"}},{"$f":"S41+T41+P41","v":{"$error":"#REF!"}},0,{"$f":"IF((Q41-S41)<0, 0,Q41-S41)","v":{"$error":"#REF!"}},{"$f":"Q41-(S41+T41)","v":{"$error":"#REF!"}},null,null,0,null,{"$f":"J41+M41+R41+V41+X41+Y41","v":{"$error":"#REF!"}},"Скальский А.В."]
[25,"Федій М.О.",4200,null,{"$f":"D42/Табель!$BT$3","v":0},0,0,0,0,0,null,0,0,null,0]
[26,"Коптяева Лена",3900,12000,{"$f":"D43/Табель!$BT$3","v":600},900,75,112.5,300,0,null,6000,6000,null,6000,null,{"$f":"D43/2-P43+O43-#REF!-J43","v":{"$error":"#REF!"}},{"$f":"S43+T43+P43","v":{"$error":"#REF!"}},0,{"$f":"IF((Q43-S43)<0, 0,Q43-S43)","v":{"$error":"#REF!"}},{"$f":"Q43-(S43+T43)","v":{"$error":"#REF!"}},null,null,0,null,{"$f":"J43+M43+R43+V43+X43+Y43","v":{"$error":"#REF!"}},"Коптяева Лена"]
["             Бухгалтерія "]
[27,"Гузенко Марина",3840,8000,{"$f":"D45/Табель!$BT$3","v":400},{"$f":"E45*1.5","v":600},{"$f":"E45/8","v":50},75,{"$f":"E45/2","v":200},0,null,{"$f":"D45/2-K45-J45","v":4000},{"$f":"J45+K45+L45","v":4000},null,4000,null,{"$f":"D45/2-P45+O45-#REF!-J45","v":{"$error":"#REF!"}},{"$f":"S45+T45+P45","v":{"$error":"#REF!"}},0,{"$f":"IF((Q45-S45)<0, 0,Q45-S45)","v":{"$error":"#REF!"}},{"$f":"Q45-(S45+T45)","v":{"$error":"#REF!"}},null,null,0,null,{"$f":"J45+M45+R45+V45+X45+Y45","v":{"$error":"#REF!"}},"Гузенко Марина"]
[28,"Рябова К.",1675,6000,{"$f":"D46/Табель!$BT$3","v":300},{"$f":"E46*1.5","v":450},37.5,56.25,{"$f":"E46/2","v":150},0,null,{"$f":"D46/2-K46-J46","v":3000},{"$f":"J46+K46+L46","v":3000},null,3000,null,{"$f":"D46/2-P46+O46-#REF!-J46","v":{"$error":"#REF!"}},{"$f":"S46+T46+P46","v":{"$error":"#REF!"}},0,{"$f":"IF((Q46-S46)<0, 0,Q46-S46)","v":{"$error":"#REF!"}},{"$f":"Q46-(S46+T46)","v":{"$error":"#REF!"}},null,null,0,null,{"$f":"J46+M46+R46+V46+X46+Y46","v":{"$error":"#REF!"}},"Рябова О."]
[29,"Дондук А.",0,6000,{"$f":"D47/Табель!$BT$3","v":300},{"$f":"E47*1.5","v":450},37.5,56.25,{"$f":"E47/2","v":150},0,null,3000,{"$f":"J47+K47+L47","v":3000},null,3000,null,{"$f":"D47/2-P47+O47-#REF!-J47","v":{"$error":"#REF!"}},{"$f":"S47+T47+P47","v":{"$error":"#REF!"}},0,{"$f":"IF((Q47-S47)<0, 0,Q47-S47)","v":{"$error":"#REF!"}},{"$f":"Q47-(S47+T47)","v":{"$error":"#REF!"}},null,null,0,null,{"$f":"J47+M47+R47+V47+X47+Y47","v":{"$error":"#REF!"}},"Дондук Анна"]
["Всего",null,{"$f":"SUM(C6:C47)","v":76741},{"$f":"SUM(D6:D47)","v":190000},null,null,null,null,null,{"$f":"SUM(J6:J36)","v":0},{"$f":"SUM(K6:K47)","v":0},{"$f":"SUM(L6:L47)","v":74000},{"$f":"SUM(M6:M47)","v":74000},{"$f":"SUM(N6:N47)","v":0},{"$f":"SUM(O6:O47)","v":74000},{"$f":"SUM(P6:P36)","v":0},{"$f":"SUM(Q6:Q36)","v":{"$error":"#REF!"}},{"$f":"SUM(R6:R26)","v":{"$error":"#REF!"}},{"$f":"SUM(S6:S36)","v":0},{"$error":"#REF!"},{"$error":"#REF!"},0,null,0,0,{"$error":"#REF!"}]

{"sheet":"Штрафы","index":2,"n_rows":172,"n_cols":6,"rows_kept":172,"cut":false,"hidden":true,"merged":[[0,3,0,4],[0,5,1,5],[0,0,1,0],[0,1,1,1],[0,2,1,2]]}
["№","Ф.И.О.","Дата","Штраф/Поощрение %",null,"Комментарии"]
[null,null,null,"Штраф","Поощрение"]
[1,"Ландичев О.В.",null,{"$f":"SUM(D4:D8)","v":0},{"$f":"SUM(E4:E8)","v":0}]
[]
[]
[]
[]
[]
[2,"Іванов О.В.",null,{"$f":"SUM(D10:D14)","v":0},{"$f":"SUM(E10:E14)","v":0}]
[]
[]
[]
[]
[]
[3,"Димов А.В.",null,{"$f":"SUM(D16:D20)","v":0},{"$f":"SUM(E16:E20)","v":0}]
[]
[]
[]
[]
[]
[4,"Сініка В.В.",null,{"$f":"SUM(D22:D26)","v":0},{"$f":"SUM(E22:E26)","v":0}]
[]
[]
[]
[]
[]
[5,"Белоус А.",null,{"$f":"SUM(D28:D32)","v":0},{"$f":"SUM(E28:E32)","v":0}]
[]
[]
[]
[]
[]
[6,"Пуха Є.А.",null,{"$f":"SUM(D34:D38)","v":0},{"$f":"SUM(E34:E38)","v":0}]
[]
[]
[]
[]
[]
[7,"Колбаса С.А.",null,{"$f":"SUM(D40:D44)","v":0},{"$f":"SUM(E40:E44)","v":0}]
[]
[]
[]
[]
[]
[8,"Морозюк М.А.",null,{"$f":"SUM(D46:D50)","v":0},{"$f":"SUM(E46:E50)","v":0}]
[]
[]
[]
[]
[]
[9,"Плющев А.С.",null,{"$f":"SUM(D52:D56)","v":0},{"$f":"SUM(E52:E56)","v":0}]
[]
[]
[]
[]
[]
[10,"Кривошея А.В.",null,{"$f":"SUM(D58:D62)","v":0},{"$f":"SUM(E58:E62)","v":0}]
[]
[]
[]
[]
[]
[11,"Корж І.І.",null,{"$f":"SUM(D64:D68)","v":0},{"$f":"SUM(E64:E68)","v":0}]
[]
[]
[]
[]
[]
[12,"Карпов Д.П.",null,{"$f":"SUM(D70:D74)","v":0},{"$f":"SUM(E70:E74)","v":0}]
[]
[]
[]
[]
[]
[13,"Колпаков Д.А.",null,{"$f":"SUM(D76:D80)","v":0},{"$f":"SUM(E76:E80)","v":0}]
[]
[]
[]
[]
[]
[14,"Чистяков А.А.",null,{"$f":"SUM(D82:D86)","v":0},{"$f":"SUM(E82:E86)","v":0}]
[]
[]
[]
[]
[]
[15,"Пукас М.М.",null,{"$f":"SUM(D88:D92)","v":0},{"$f":"SUM(E88:E92)","v":0}]
[]
[]
[]
[]
[]
[16,"Петлюк В.П.",null,{"$f":"SUM(D94:D98)","v":0},{"$f":"SUM(E94:E98)","v":0}]
[]
[]
[]
[]
[]
[17,"Слободянюк А.В.",null,{"$f":"SUM(D100:D104)","v":0},{"$f":"SUM(E100:E104)","v":0}]
[]
[]
[]
[]
[]
[18,"Сидько І.А.",null,{"$f":"SUM(D106:D110)","v":0},{"$f":"SUM(E106:E110)","v":0}]
[]
[]
[]
[]
[]
[19,"Трембич С.К.",null,{"$f":"SUM(D112:D116)","v":0},{"$f":"SUM(E112:E116)","v":0}]
[]
[]
[]
[]
[]
[20,"Русин Н.Ф.",null,{"$f":"SUM(D118:D122)","v":0},{"$f":"SUM(E118:E122)","v":0}]
[]
[]
[]
[]
[]
[21,"Булдик О.О.",null,{"$f":"SUM(D124:D128)","v":0},{"$f":"SUM(E124:E128)","v":0}]
[]
[]
[]
[]
[]
[22,"Булдик О.Ф.",null,{"$f":"SUM(D130:D134)","v":0},{"$f":"SUM(E130:E134)","v":0}]
[]
[]
[]
[]
[]
[22,null,null,{"$f":"SUM(D136:D140)","v":0},{"$f":"SUM(E136:E140)","v":0}]
[]
[]
[]
[]
[]
[22,null,null,{"$f":"SUM(D142:D146)","v":0},{"$f":"SUM(E142:E146)","v":0}]
[]
[]
[]
[]
[]
[22,null,null,{"$f":"SUM(D148:D152)","v":0},{"$f":"SUM(E148:E152)","v":0}]
[]
[]
[]
[]
[]
[]
[21,"Коптяєва О.В.",null,{"$f":"SUM(D155:D159)","v":0},{"$f":"SUM(E155:E159)","v":0}]
[]
[]
[]
[]
[]
[22,"Гузенко М.В.",null,{"$f":"SUM(D161:D165)","v":0},{"$f":"SUM(E161:E165)","v":0}]
[]
[]
[]
[]
[]
[23,"Рябова К.С.",null,{"$f":"SUM(D167:D171)","v":0},{"$f":"SUM(E167:E171)","v":0}]
[]
[]
[]
[]
[]
[24,"Дондук Г.В.",null,{"$f":"SUM(D173:D177)","v":0},{"$f":"SUM(E173:E177)","v":0}]