{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ТАБЕЛЬ","норма"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":41,"n_cols":49,"rows_kept":41,"cut":false,"hidden":false,"merged":[[38,35,38,37],[38,17,38,26],[9,43,9,45],[9,46,9,48],[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,6,10,6],[9,7,10,7],[9,8,10,8],[9,9,10,9],[9,10,10,10],[9,11,10,11],[9,12,10,12],[9,13,10,13],[9,14,10,14],[37,12,37,16],[36,17,36,26],[37,17,37,26],[36,27,36,37],[37,27,37,37],[36,12,36,16],[37,0,37,1],[36,2,36,4],[36,5,36,7],[36,8,36,11],[37,2,37,4],[37,5,37,7],[37,8,37,11],[36,0,36,1],[9,15,10,15],[9,16,10,16],[9,17,10,17],[2,0,2,11],[3,0,3,3],[3,4,4,33],[7,0,11,0],[7,1,11,1],[7,2,11,2],[7,3,8,33],[9,24,10,24],[9,25,10,25],[9,26,10,26],[9,27,10,27],[5,2,5,34],[6,4,6,16],[6,17,6,19],[6,20,6,21],[9,18,10,18],[8,35,11,35],[8,37,11,37],[7,34,7,35],[7,36,11,36],[9,19,10,19],[9,20,10,20],[9,21,10,21],[9,22,10,22],[9,23,10,23],[0,20,0,30],[8,34,11,34],[9,33,10,33],[9,28,10,28],[9,29,10,29],[9,30,10,30],[9,31,10,31],[9,32,10,32],[1,6,1,12],[1,13,1,19],[0,0,1,1],[0,2,1,4],[0,5,1,5],[0,6,0,12],[0,13,0,19]]}
["ОТЧЁТНЫЙ ПЕРИОД",null,{"$f":"--(1&\"/\"&F1&\"/\"&норма!$A$1)","v":"2024-11-01"},null,null,11,"Рабочий выходной день",null,null,null,null,null,null,"Предпраздничный",null,null,null,null,null,null,"Праздничные"]
[null,null,null,null,null,null,{"$f":"IFERROR(--(INDEX(норма!$P$3:$P$14,$F1)&\"/\"&$F1),\"\")","v":"2024-11-02"},null,null,null,null,null,null,{"$f":"IFERROR(--(INDEX(норма!$M$3:$M$14,$F1)&\"/\"&$F1),\"\")","v":""},null,null,null,null,null,null,{"$f":"IFERROR(--(INDEX(норма!D$3:D$14,$F1)&\"/\"&$F1),\"\")","v":"2024-11-04"},{"$f":"IFERROR(--(INDEX(норма!E$3:E$14,$F1)&\"/\"&$F1),\"\")","v":""},{"$f":"IFERROR(--(INDEX(норма!F$3:F$14,$F1)&\"/\"&$F1),\"\")","v":""},{"$f":"IFERROR(--(INDEX(норма!G$3:G$14,$F1)&\"/\"&$F1),\"\")","v":""},{"$f":"IFERROR(--(INDEX(норма!H$3:H$14,$F1)&\"/\"&$F1),\"\")","v":""},{"$f":"IFERROR(--(INDEX(норма!I$3:I$14,$F1)&\"/\"&$F1),\"\")","v":""},{"$f":"IFERROR(--(INDEX(норма!J$3:J$14,$F1)&\"/\"&$F1),\"\")","v":""},{"$f":"IFERROR(--(INDEX(норма!K$3:K$14,$F1)&\"/\"&$F1),\"\")","v":""},{"$f":"IFERROR(--(INDEX(норма!L$3:L$14,$F1)&\"/\"&$F1),\"\")","v":""},{"$f":"IFERROR(--(INDEX(норма!M$3:M$14,$F1)&\"/\"&$F1),\"\")","v":""},{"$f":"IFERROR(--(INDEX(норма!N$3:N$14,$F1)&\"/\"&$F1),\"\")","v":""}]
[]
[null,null,null,null,"Г Р А Ф И К"]
[]
[]
[null,null,null,null,"на",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C1","v":"2024-11-01"},null,null,{"$f":"норма!A1&\" г.\"","v":"2024 г."}]
["№","Фамилия, И., О.","Таб№","ЧИСЛА МЕСЯЦА",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Количество часов",null,"Переработка","Ознакомление"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"по календарю пятидневки","по графику",null,"Подпись "]
[null,null,null,{"$f":"C1","v":"2024-11-01"},{"$f":"D10+1","v":"2024-11-02"},{"$f":"E10+1","v":"2024-11-03"},"2024-11-04","2024-11-05","2024-11-06","2024-11-07","2024-11-08","2024-11-09","2024-11-10","2024-11-11","2024-11-12","2024-11-13","2024-11-14","2024-11-15","2024-11-16","2024-11-17","2024-11-18","2024-11-19","2024-11-20","2024-11-21","2024-11-22","2024-11-23","2024-11-24","2024-11-25","2024-11-26","2024-11-27","2024-11-28",{"$f":"IF(DAY(AE$10+1)>DAY($AE10),$AE10+1,\"\")","v":"2024-11-29"},{"$f":"IF(DAY(AE$10+2)>DAY($AE10),$AE10+2,\"\")","v":"2024-11-30"},{"$f":"IF(DAY(AE$10+3)>DAY($AE10),$AE10+3,\"\")","v":""},null,null,null,null,null,null,null,null,null,"С",null,null,"Д"]
[]
[null,null,null,{"$f":"D10","v":"2024-11-01"},{"$f":"E10","v":"2024-11-02"},"2024-11-03","2024-11-04","2024-11-05","2024-11-06","2024-11-07","2024-11-08","2024-11-09","2024-11-10","2024-11-11","2024-11-12","2024-11-13","2024-11-14","2024-11-15","2024-11-16","2024-11-17","2024-11-18","2024-11-19","2024-11-20","2024-11-21","2024-11-22","2024-11-23","2024-11-24","2024-11-25","2024-11-26","2024-11-27","2024-11-28","2024-11-29","2024-11-30",""]
[{"$f":"IF($C13=\"\",\"\",MAX($M$3:M3)+1)","v":1},"Иванов",519,"С",null,null,"С","8/6",null,null,"С","8/6","С","8/6",null,null,"С",null,"Д",null,"С",null,null,"С","8/6",null,"С","8/6",null,null,"С","8/6",null,"С",{"$f":"IF(C13>0,VLOOKUP($F$1,норма!$B$19:$G$30,4,FALSE)-(COUNTIF(D13:AH13,\"О\")*8)-(COUNTIF(D13:AH13,\"Э\")*8)-(COUNTIF(D13:AH13,\"Ж\")*8)-(COUNTIF(D13:AH13,\"Д,\")*8)-(COUNTIF(D13:AH13,\"К\")*8),\"-\")","v":167},{"$f":"SUMPRODUCT(--TEXT(MID(D13:AH13&IF(ISBLANK(D13:AH13),\"\",),1,SEARCH(\"/\",SUBSTITUTE(SUBSTITUTE(D13:AH13,\".\",\",\"),\"я\",)&\"0/\")-1),\"0;;0;\\0\"))+AT13-SUMPRODUCT(--TEXT(MID(D13:AH13&IF(ISBLANK(D13:AH13),\"\",),1,SEARCH(\"/\",SUBSTITUTE(SUBSTITUTE(D13:AH13,\".\",\",\"),\"я\",)&\"0/\")-1),\"0;;0;\\0\"))","v":240},{"$f":"IF(AJ13>0,AJ13-AI13,\"\")","v":73},null,null,null,null,null,null,{"$f":"COUNTIFS(D13:AH13,\"С\")","v":10},24,{"$f":"AR13*AS13","v":240},{"$f":"COUNTIFS(G13:AK13,\"Д\")","v":1},8,{"$f":"AU13*AV13","v":8}]
[{"$f":"IF($C14=\"\",\"\",MAX($A$13:A13)+1)","v":2},"Иванов",383,"8/6",null,"С","8/6",null,null,"С","8/6","С","8/6","С","8/6",null,null,"С","8/6","С",null,null,"С",null,null,"С","8/6",null,"С","8/6",null,null,"С","8/6",{"$f":"IF(C14>0,VLOOKUP($F$1,норма!$B$19:$G$30,4,FALSE)-(COUNTIF(D14:AH14,\"О\")*8)-(COUNTIF(D14:AH14,\"Э\")*8)-(COUNTIF(D14:AH14,\"Ж\")*8)-(COUNTIF(D14:AH14,\"Д,\")*8)-(COUNTIF(D14:AH14,\"К\")*8),\"-\")","v":167},240,73,null,null,null,null,null,null,10,24,{"$f":"AR14*AS14","v":240},0,8,{"$f":"AU14*AV14","v":0}]
[{"$f":"IF($C15=\"\",\"\",MAX($A$13:A14)+1)","v":3},"Иванов",511,"О","О","О","О",null,null,"О","О","О","О","О",null,null,"О","О","О","О","О","С",null,null,"С","8/6",null,"С","8/6",null,null,"С","8/6",null,{"$f":"IF(C15>0,VLOOKUP($F$1,норма!$B$19:$G$30,4,FALSE)-(COUNTIF(D15:AH15,\"О\")*8)-(COUNTIF(D15:AH15,\"Э\")*8)-(COUNTIF(D15:AH15,\"Ж\")*8)-(COUNTIF(D15:AH15,\"Д,\")*8)-(COUNTIF(D15:AH15,\"К\")*8),\"-\")","v":55},96,41,null,null,null,null,null,null,4,24,96,0,8,0]
[{"$f":"IF($C16=\"\",\"\",MAX($A$13:A15)+1)","v":4},"Иванов",312,null,"С","8/6",null,"С","8/6",null,"С","8/6",null,"С","8/6",null,"С",null,null,"С","8/6",null,"С",null,null,"С","8/6",null,"С",null,null,"С","8/6",null,{"$f":"IF(C16>0,VLOOKUP($F$1,норма!$B$19:$G$30,4,FALSE)-(COUNTIF(D16:AH16,\"О\")*8)-(COUNTIF(D16:AH16,\"Э\")*8)-(COUNTIF(D16:AH16,\"Ж\")*8)-(COUNTIF(D16:AH16,\"Д,\")*8)-(COUNTIF(D16:AH16,\"К\")*8),\"-\")","v":167},240,73,null,null,null,null,null,null,10,24,{"$f":"AR16*AS16","v":240},0,8,0]
[{"$f":"IF($C17=\"\",\"\",MAX($A$13:A16)+1)","v":5},"Иванов",152,null,null,null,null,null,null,null,"С","8/6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C17>0,VLOOKUP($F$1,норма!$B$19:$G$30,4,FALSE)-(COUNTIF(D17:AH17,\"О\")*8)-(COUNTIF(D17:AH17,\"Э\")*8)-(COUNTIF(D17:AH17,\"Ж\")*8)-(COUNTIF(D17:AH17,\"Д,\")*8)-(COUNTIF(D17:AH17,\"К\")*8),\"-\")","v":167},24,{"$f":"IF(AJ17>0,AJ17-AI17,\"\")","v":-143},null,null,null,null,null,null,1,24,24,0,8,0]
[{"$f":"IF($C18=\"\",\"\",MAX($A$13:A17)+1)","v":6},"Иванов",454,null,null,null,null,null,null,null,null,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(C18>0,VLOOKUP($F$1,норма!$B$19:$G$30,4,FALSE)-(COUNTIF(D18:AH18,\"О\")*8)-(COUNTIF(D18:AH18,\"Э\")*8)-(COUNTIF(D18:AH18,\"Ж\")*8)-(COUNTIF(D18:AH18,\"Д,\")*8)-(COUNTIF(D18:AH18,\"К\")*8),\"-\")","v":167},0,{"$f":"IF(AJ18>0,AJ18-AI18,\"\")","v":""},null,null,null,null,null,null,0,24,0,0,8,0]
[{"$f":"IF($C19=\"\",\"\",MAX($A$13:A18)+1)","v":7},"Иванов",611,null,null,null,null,null,null,null,null,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(C19>0,VLOOKUP($F$1,норма!$B$19:$G$30,4,FALSE)-(COUNTIF(D19:AH19,\"О\")*8)-(COUNTIF(D19:AH19,\"Э\")*8)-(COUNTIF(D19:AH19,\"Ж\")*8)-(COUNTIF(D19:AH19,\"Д,\")*8)-(COUNTIF(D19:AH19,\"К\")*8),\"-\")","v":167},0,"",null,null,null,null,null,null,0,24,0,0,8,0]
[{"$f":"IF($C20=\"\",\"\",MAX($A$13:A19)+1)","v":8},"Иванов",628,null,null,null,null,null,null,null,null,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(C20>0,VLOOKUP($F$1,норма!$B$19:$G$30,4,FALSE)-(COUNTIF(D20:AH20,\"О\")*8)-(COUNTIF(D20:AH20,\"Э\")*8)-(COUNTIF(D20:AH20,\"Ж\")*8)-(COUNTIF(D20:AH20,\"Д,\")*8)-(COUNTIF(D20:AH20,\"К\")*8),\"-\")","v":167},0,"",null,null,null,null,null,null,0,24,0,0,8,0]
[{"$f":"IF($C21=\"\",\"\",MAX($A$13:A20)+1)","v":9},"Иванов",466,null,null,null,null,null,null,null,null,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(C21>0,VLOOKUP($F$1,норма!$B$19:$G$30,4,FALSE)-(COUNTIF(D21:AH21,\"О\")*8)-(COUNTIF(D21:AH21,\"Э\")*8)-(COUNTIF(D21:AH21,\"Ж\")*8)-(COUNTIF(D21:AH21,\"Д,\")*8)-(COUNTIF(D21:AH21,\"К\")*8),\"-\")","v":167},0,"",null,null,null,null,null,null,0,24,0,0,8,0]
[{"$f":"IF($C22=\"\",\"\",MAX($A$13:A21)+1)","v":10},"Иванов",374,null,null,null,null,null,null,null,null,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(C22>0,VLOOKUP($F$1,норма!$B$19:$G$30,4,FALSE)-(COUNTIF(D22:AH22,\"О\")*8)-(COUNTIF(D22:AH22,\"Э\")*8)-(COUNTIF(D22:AH22,\"Ж\")*8)-(COUNTIF(D22:AH22,\"Д,\")*8)-(COUNTIF(D22:AH22,\"К\")*8),\"-\")","v":167},0,"",null,null,null,null,null,null,0,24,0,0,8,0]
[{"$f":"IF($C23=\"\",\"\",MAX($A$13:A22)+1)","v":11},"Иванов",355,null,null,null,null,null,null,null,null,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(C23>0,VLOOKUP($F$1,норма!$B$19:$G$30,4,FALSE)-(COUNTIF(D23:AH23,\"О\")*8)-(COUNTIF(D23:AH23,\"Э\")*8)-(COUNTIF(D23:AH23,\"Ж\")*8)-(COUNTIF(D23:AH23,\"Д,\")*8)-(COUNTIF(D23:AH23,\"К\")*8),\"-\")","v":167},0,"",null,null,null,null,null,null,0,24,0,0,8,0]
[{"$f":"IF($C24=\"\",\"\",MAX($A$13:A23)+1)","v":12},"Иванов",474,null,null,null,null,null,null,null,null,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(C24>0,VLOOKUP($F$1,норма!$B$19:$G$30,4,FALSE)-(COUNTIF(D24:AH24,\"О\")*8)-(COUNTIF(D24:AH24,\"Э\")*8)-(COUNTIF(D24:AH24,\"Ж\")*8)-(COUNTIF(D24:AH24,\"Д,\")*8)-(COUNTIF(D24:AH24,\"К\")*8),\"-\")","v":167},0,"",null,null,null,null,null,null,0,24,0,0,8,0]
[{"$f":"IF($C25=\"\",\"\",MAX($A$13:A24)+1)","v":13},"Иванов",766,null,null,null,null,null,null,null,null,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(C25>0,VLOOKUP($F$1,норма!$B$19:$G$30,4,FALSE)-(COUNTIF(D25:AH25,\"О\")*8)-(COUNTIF(D25:AH25,\"Э\")*8)-(COUNTIF(D25:AH25,\"Ж\")*8)-(COUNTIF(D25:AH25,\"Д,\")*8)-(COUNTIF(D25:AH25,\"К\")*8),\"-\")","v":167},0,"",null,null,null,null,null,null,0,24,0,0,8,0]
[{"$f":"IF($C26=\"\",\"\",MAX($A$13:A25)+1)","v":14},"Иванов",648,null,null,null,null,null,null,null,null,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(C26>0,VLOOKUP($F$1,норма!$B$19:$G$30,4,FALSE)-(COUNTIF(D26:AH26,\"О\")*8)-(COUNTIF(D26:AH26,\"Э\")*8)-(COUNTIF(D26:AH26,\"Ж\")*8)-(COUNTIF(D26:AH26,\"Д,\")*8)-(COUNTIF(D26:AH26,\"К\")*8),\"-\")","v":167},0,"",null,null,null,null,null,null,0,24,0,0,8,0]
[{"$f":"IF($C27=\"\",\"\",MAX($A$13:A26)+1)","v":15},"Иванов",618,null,null,null,null,null,null,null,null,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(C27>0,VLOOKUP($F$1,норма!$B$19:$G$30,4,FALSE)-(COUNTIF(D27:AH27,\"О\")*8)-(COUNTIF(D27:AH27,\"Э\")*8)-(COUNTIF(D27:AH27,\"Ж\")*8)-(COUNTIF(D27:AH27,\"Д,\")*8)-(COUNTIF(D27:AH27,\"К\")*8),\"-\")","v":167},0,"",null,null,null,null,null,null,0,24,0,0,8,0]
[{"$f":"IF($C28=\"\",\"\",MAX($A$13:A27)+1)","v":16},"Иванов",341,null,null,null,null,null,null,null,null,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(C28>0,VLOOKUP($F$1,норма!$B$19:$G$30,4,FALSE)-(COUNTIF(D28:AH28,\"О\")*8)-(COUNTIF(D28:AH28,\"Э\")*8)-(COUNTIF(D28:AH28,\"Ж\")*8)-(COUNTIF(D28:AH28,\"Д,\")*8)-(COUNTIF(D28:AH28,\"К\")*8),\"-\")","v":167},0,"",null,null,null,null,null,null,0,24,0,0,8,0]
[{"$f":"IF($C29=\"\",\"\",MAX($A$13:A28)+1)","v":17},"Иванов",583,null,null,null,null,null,null,null,null,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(C29>0,VLOOKUP($F$1,норма!$B$19:$G$30,4,FALSE)-(COUNTIF(D29:AH29,\"О\")*8)-(COUNTIF(D29:AH29,\"Э\")*8)-(COUNTIF(D29:AH29,\"Ж\")*8)-(COUNTIF(D29:AH29,\"Д,\")*8)-(COUNTIF(D29:AH29,\"К\")*8),\"-\")","v":167},0,"",null,null,null,null,null,null,0,24,0,0,8,0]
[{"$f":"IF($C30=\"\",\"\",MAX($A$13:A29)+1)","v":18},"Иванов",394,"8/6",null,"С","8/6",null,null,"С","8/6",null,"С","8/6",null,"С","8/6",null,"С","8/6",null,"С",null,null,"Д","С",null,null,"С",null,null,"Д","С",null,{"$f":"IF(C30>0,VLOOKUP($F$1,норма!$B$19:$G$30,4,FALSE)-(COUNTIF(D30:AH30,\"О\")*8)-(COUNTIF(D30:AH30,\"Э\")*8)-(COUNTIF(D30:AH30,\"Ж\")*8)-(COUNTIF(D30:AH30,\"Д,\")*8)-(COUNTIF(D30:AH30,\"К\")*8),\"-\")","v":167},216,49,null,null,null,null,null,null,9,24,216,2,8,16]
[{"$f":"IF($C31=\"\",\"\",MAX($A$13:A30)+1)","v":19},"Петрова",808,{"$f":"IFERROR(IF($G$2=D$10,VLOOKUP(D$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(D$10,2)>5,AND(ISNUMBER(D$10),ISNUMBER(MATCH(D$10,$U$2:$AE$2,)))),\"\",VLOOKUP(D$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=E$10,VLOOKUP(E$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(E$10,2)>5,AND(ISNUMBER(E$10),ISNUMBER(MATCH(E$10,$U$2:$AE$2,)))),\"\",VLOOKUP(E$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=F$10,VLOOKUP(F$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(F$10,2)>5,AND(ISNUMBER(F$10),ISNUMBER(MATCH(F$10,$U$2:$AE$2,)))),\"\",VLOOKUP(F$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=G$10,VLOOKUP(G$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(G$10,2)>5,AND(ISNUMBER(G$10),ISNUMBER(MATCH(G$10,$U$2:$AE$2,)))),\"\",VLOOKUP(G$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=H$10,VLOOKUP(H$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(H$10,2)>5,AND(ISNUMBER(H$10),ISNUMBER(MATCH(H$10,$U$2:$AE$2,)))),\"\",VLOOKUP(H$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=I$10,VLOOKUP(I$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(I$10,2)>5,AND(ISNUMBER(I$10),ISNUMBER(MATCH(I$10,$U$2:$AE$2,)))),\"\",VLOOKUP(I$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=J$10,VLOOKUP(J$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(J$10,2)>5,AND(ISNUMBER(J$10),ISNUMBER(MATCH(J$10,$U$2:$AE$2,)))),\"\",VLOOKUP(J$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=K$10,VLOOKUP(K$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(K$10,2)>5,AND(ISNUMBER(K$10),ISNUMBER(MATCH(K$10,$U$2:$AE$2,)))),\"\",VLOOKUP(K$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=L$10,VLOOKUP(L$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(L$10,2)>5,AND(ISNUMBER(L$10),ISNUMBER(MATCH(L$10,$U$2:$AE$2,)))),\"\",VLOOKUP(L$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=M$10,VLOOKUP(M$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(M$10,2)>5,AND(ISNUMBER(M$10),ISNUMBER(MATCH(M$10,$U$2:$AE$2,)))),\"\",VLOOKUP(M$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=N$10,VLOOKUP(N$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(N$10,2)>5,AND(ISNUMBER(N$10),ISNUMBER(MATCH(N$10,$U$2:$AE$2,)))),\"\",VLOOKUP(N$41,норма!$R$2:$T$8,3,))),\"\")","v":8},{"$f":"IFERROR(IF($G$2=O$10,VLOOKUP(O$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(O$10,2)>5,AND(ISNUMBER(O$10),ISNUMBER(MATCH(O$10,$U$2:$AE$2,)))),\"\",VLOOKUP(O$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=P$10,VLOOKUP(P$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(P$10,2)>5,AND(ISNUMBER(P$10),ISNUMBER(MATCH(P$10,$U$2:$AE$2,)))),\"\",VLOOKUP(P$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=Q$10,VLOOKUP(Q$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(Q$10,2)>5,AND(ISNUMBER(Q$10),ISNUMBER(MATCH(Q$10,$U$2:$AE$2,)))),\"\",VLOOKUP(Q$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=R$10,VLOOKUP(R$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(R$10,2)>5,AND(ISNUMBER(R$10),ISNUMBER(MATCH(R$10,$U$2:$AE$2,)))),\"\",VLOOKUP(R$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=S$10,VLOOKUP(S$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(S$10,2)>5,AND(ISNUMBER(S$10),ISNUMBER(MATCH(S$10,$U$2:$AE$2,)))),\"\",VLOOKUP(S$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=T$10,VLOOKUP(T$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(T$10,2)>5,AND(ISNUMBER(T$10),ISNUMBER(MATCH(T$10,$U$2:$AE$2,)))),\"\",VLOOKUP(T$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=U$10,VLOOKUP(U$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(U$10,2)>5,AND(ISNUMBER(U$10),ISNUMBER(MATCH(U$10,$U$2:$AE$2,)))),\"\",VLOOKUP(U$41,норма!$R$2:$T$8,3,))),\"\")","v":8},{"$f":"IFERROR(IF($G$2=V$10,VLOOKUP(V$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(V$10,2)>5,AND(ISNUMBER(V$10),ISNUMBER(MATCH(V$10,$U$2:$AE$2,)))),\"\",VLOOKUP(V$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=W$10,VLOOKUP(W$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(W$10,2)>5,AND(ISNUMBER(W$10),ISNUMBER(MATCH(W$10,$U$2:$AE$2,)))),\"\",VLOOKUP(W$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=X$10,VLOOKUP(X$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(X$10,2)>5,AND(ISNUMBER(X$10),ISNUMBER(MATCH(X$10,$U$2:$AE$2,)))),\"\",VLOOKUP(X$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=Y$10,VLOOKUP(Y$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(Y$10,2)>5,AND(ISNUMBER(Y$10),ISNUMBER(MATCH(Y$10,$U$2:$AE$2,)))),\"\",VLOOKUP(Y$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=Z$10,VLOOKUP(Z$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(Z$10,2)>5,AND(ISNUMBER(Z$10),ISNUMBER(MATCH(Z$10,$U$2:$AE$2,)))),\"\",VLOOKUP(Z$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=AA$10,VLOOKUP(AA$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AA$10,2)>5,AND(ISNUMBER(AA$10),ISNUMBER(MATCH(AA$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AA$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=AB$10,VLOOKUP(AB$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AB$10,2)>5,AND(ISNUMBER(AB$10),ISNUMBER(MATCH(AB$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AB$41,норма!$R$2:$T$8,3,))),\"\")","v":8},{"$f":"IFERROR(IF($G$2=AC$10,VLOOKUP(AC$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AC$10,2)>5,AND(ISNUMBER(AC$10),ISNUMBER(MATCH(AC$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AC$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=AD$10,VLOOKUP(AD$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AD$10,2)>5,AND(ISNUMBER(AD$10),ISNUMBER(MATCH(AD$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AD$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=AE$10,VLOOKUP(AE$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AE$10,2)>5,AND(ISNUMBER(AE$10),ISNUMBER(MATCH(AE$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AE$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=AF$10,VLOOKUP(AF$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AF$10,2)>5,AND(ISNUMBER(AF$10),ISNUMBER(MATCH(AF$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AF$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=AG$10,VLOOKUP(AG$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AG$10,2)>5,AND(ISNUMBER(AG$10),ISNUMBER(MATCH(AG$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AG$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=AH$10,VLOOKUP(AH$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AH$10,2)>5,AND(ISNUMBER(AH$10),ISNUMBER(MATCH(AH$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AH$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IF(C31>0,VLOOKUP($F$1,норма!$B$19:$G$30,6,FALSE)-(COUNTIF(D31:AH31,\"О\")*8)-(COUNTIF(D31:AH31,\"Э\")*8)-(COUNTIF(D31:AH31,\"Ж\")*8)-(COUNTIF(D31:AH31,\"Д,\")*8)-(COUNTIF(D31:AH31,\"К\")*8),\"-\")","v":150},{"$f":"SUMPRODUCT(--TEXT(MID(D31:AH31&IF(ISBLANK(D31:AH31),\"\",),1,SEARCH(\"/\",SUBSTITUTE(SUBSTITUTE(D31:AH31,\".\",\",\"),\"я\",)&\"0/\")-1),\"0;;0;\\0\"))","v":150},{"$f":"IF(AJ31>0,AJ31-AI31,\"\")","v":0},null,null,null,null,null,null,0,24,0,0,8,0]
[{"$f":"IF($C32=\"\",\"\",MAX($A$13:A31)+1)","v":20},"Сидорова",564,{"$f":"IFERROR(IF($G$2=D$10,VLOOKUP(D$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(D$10,2)>5,AND(ISNUMBER(D$10),ISNUMBER(MATCH(D$10,$U$2:$AE$2,)))),\"\",VLOOKUP(D$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=E$10,VLOOKUP(E$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(E$10,2)>5,AND(ISNUMBER(E$10),ISNUMBER(MATCH(E$10,$U$2:$AE$2,)))),\"\",VLOOKUP(E$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=F$10,VLOOKUP(F$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(F$10,2)>5,AND(ISNUMBER(F$10),ISNUMBER(MATCH(F$10,$U$2:$AE$2,)))),\"\",VLOOKUP(F$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=G$10,VLOOKUP(G$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(G$10,2)>5,AND(ISNUMBER(G$10),ISNUMBER(MATCH(G$10,$U$2:$AE$2,)))),\"\",VLOOKUP(G$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=H$10,VLOOKUP(H$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(H$10,2)>5,AND(ISNUMBER(H$10),ISNUMBER(MATCH(H$10,$U$2:$AE$2,)))),\"\",VLOOKUP(H$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=I$10,VLOOKUP(I$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(I$10,2)>5,AND(ISNUMBER(I$10),ISNUMBER(MATCH(I$10,$U$2:$AE$2,)))),\"\",VLOOKUP(I$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=J$10,VLOOKUP(J$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(J$10,2)>5,AND(ISNUMBER(J$10),ISNUMBER(MATCH(J$10,$U$2:$AE$2,)))),\"\",VLOOKUP(J$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=K$10,VLOOKUP(K$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(K$10,2)>5,AND(ISNUMBER(K$10),ISNUMBER(MATCH(K$10,$U$2:$AE$2,)))),\"\",VLOOKUP(K$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=L$10,VLOOKUP(L$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(L$10,2)>5,AND(ISNUMBER(L$10),ISNUMBER(MATCH(L$10,$U$2:$AE$2,)))),\"\",VLOOKUP(L$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=M$10,VLOOKUP(M$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(M$10,2)>5,AND(ISNUMBER(M$10),ISNUMBER(MATCH(M$10,$U$2:$AE$2,)))),\"\",VLOOKUP(M$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=N$10,VLOOKUP(N$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(N$10,2)>5,AND(ISNUMBER(N$10),ISNUMBER(MATCH(N$10,$U$2:$AE$2,)))),\"\",VLOOKUP(N$41,норма!$R$2:$T$8,3,))),\"\")","v":8},{"$f":"IFERROR(IF($G$2=O$10,VLOOKUP(O$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(O$10,2)>5,AND(ISNUMBER(O$10),ISNUMBER(MATCH(O$10,$U$2:$AE$2,)))),\"\",VLOOKUP(O$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=P$10,VLOOKUP(P$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(P$10,2)>5,AND(ISNUMBER(P$10),ISNUMBER(MATCH(P$10,$U$2:$AE$2,)))),\"\",VLOOKUP(P$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=Q$10,VLOOKUP(Q$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(Q$10,2)>5,AND(ISNUMBER(Q$10),ISNUMBER(MATCH(Q$10,$U$2:$AE$2,)))),\"\",VLOOKUP(Q$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=R$10,VLOOKUP(R$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(R$10,2)>5,AND(ISNUMBER(R$10),ISNUMBER(MATCH(R$10,$U$2:$AE$2,)))),\"\",VLOOKUP(R$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=S$10,VLOOKUP(S$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(S$10,2)>5,AND(ISNUMBER(S$10),ISNUMBER(MATCH(S$10,$U$2:$AE$2,)))),\"\",VLOOKUP(S$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=T$10,VLOOKUP(T$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(T$10,2)>5,AND(ISNUMBER(T$10),ISNUMBER(MATCH(T$10,$U$2:$AE$2,)))),\"\",VLOOKUP(T$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=U$10,VLOOKUP(U$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(U$10,2)>5,AND(ISNUMBER(U$10),ISNUMBER(MATCH(U$10,$U$2:$AE$2,)))),\"\",VLOOKUP(U$41,норма!$R$2:$T$8,3,))),\"\")","v":8},{"$f":"IFERROR(IF($G$2=V$10,VLOOKUP(V$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(V$10,2)>5,AND(ISNUMBER(V$10),ISNUMBER(MATCH(V$10,$U$2:$AE$2,)))),\"\",VLOOKUP(V$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=W$10,VLOOKUP(W$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(W$10,2)>5,AND(ISNUMBER(W$10),ISNUMBER(MATCH(W$10,$U$2:$AE$2,)))),\"\",VLOOKUP(W$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=X$10,VLOOKUP(X$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(X$10,2)>5,AND(ISNUMBER(X$10),ISNUMBER(MATCH(X$10,$U$2:$AE$2,)))),\"\",VLOOKUP(X$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=Y$10,VLOOKUP(Y$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(Y$10,2)>5,AND(ISNUMBER(Y$10),ISNUMBER(MATCH(Y$10,$U$2:$AE$2,)))),\"\",VLOOKUP(Y$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=Z$10,VLOOKUP(Z$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(Z$10,2)>5,AND(ISNUMBER(Z$10),ISNUMBER(MATCH(Z$10,$U$2:$AE$2,)))),\"\",VLOOKUP(Z$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=AA$10,VLOOKUP(AA$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AA$10,2)>5,AND(ISNUMBER(AA$10),ISNUMBER(MATCH(AA$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AA$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=AB$10,VLOOKUP(AB$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AB$10,2)>5,AND(ISNUMBER(AB$10),ISNUMBER(MATCH(AB$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AB$41,норма!$R$2:$T$8,3,))),\"\")","v":8},{"$f":"IFERROR(IF($G$2=AC$10,VLOOKUP(AC$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AC$10,2)>5,AND(ISNUMBER(AC$10),ISNUMBER(MATCH(AC$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AC$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=AD$10,VLOOKUP(AD$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AD$10,2)>5,AND(ISNUMBER(AD$10),ISNUMBER(MATCH(AD$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AD$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=AE$10,VLOOKUP(AE$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AE$10,2)>5,AND(ISNUMBER(AE$10),ISNUMBER(MATCH(AE$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AE$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=AF$10,VLOOKUP(AF$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AF$10,2)>5,AND(ISNUMBER(AF$10),ISNUMBER(MATCH(AF$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AF$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=AG$10,VLOOKUP(AG$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AG$10,2)>5,AND(ISNUMBER(AG$10),ISNUMBER(MATCH(AG$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AG$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=AH$10,VLOOKUP(AH$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AH$10,2)>5,AND(ISNUMBER(AH$10),ISNUMBER(MATCH(AH$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AH$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IF(C32>0,VLOOKUP($F$1,норма!$B$19:$G$30,6,FALSE)-(COUNTIF(D32:AH32,\"О\")*8)-(COUNTIF(D32:AH32,\"Э\")*8)-(COUNTIF(D32:AH32,\"Ж\")*8)-(COUNTIF(D32:AH32,\"Д,\")*8)-(COUNTIF(D32:AH32,\"К\")*8),\"-\")","v":150},{"$f":"SUMPRODUCT(--TEXT(MID(D32:AH32&IF(ISBLANK(D32:AH32),\"\",),1,SEARCH(\"/\",SUBSTITUTE(SUBSTITUTE(D32:AH32,\".\",\",\"),\"я\",)&\"0/\")-1),\"0;;0;\\0\"))","v":150},0,null,null,null,null,null,null,0,24,0,0,8,0]
[{"$f":"IF($C33=\"\",\"\",MAX($A$13:A32)+1)","v":21},"Пупкина",308,{"$f":"IFERROR(IF($G$2=D$10,VLOOKUP(D$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(D$10,2)>5,AND(ISNUMBER(D$10),ISNUMBER(MATCH(D$10,$U$2:$AE$2,)))),\"\",VLOOKUP(D$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=E$10,VLOOKUP(E$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(E$10,2)>5,AND(ISNUMBER(E$10),ISNUMBER(MATCH(E$10,$U$2:$AE$2,)))),\"\",VLOOKUP(E$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=F$10,VLOOKUP(F$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(F$10,2)>5,AND(ISNUMBER(F$10),ISNUMBER(MATCH(F$10,$U$2:$AE$2,)))),\"\",VLOOKUP(F$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=G$10,VLOOKUP(G$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(G$10,2)>5,AND(ISNUMBER(G$10),ISNUMBER(MATCH(G$10,$U$2:$AE$2,)))),\"\",VLOOKUP(G$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=H$10,VLOOKUP(H$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(H$10,2)>5,AND(ISNUMBER(H$10),ISNUMBER(MATCH(H$10,$U$2:$AE$2,)))),\"\",VLOOKUP(H$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=I$10,VLOOKUP(I$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(I$10,2)>5,AND(ISNUMBER(I$10),ISNUMBER(MATCH(I$10,$U$2:$AE$2,)))),\"\",VLOOKUP(I$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=J$10,VLOOKUP(J$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(J$10,2)>5,AND(ISNUMBER(J$10),ISNUMBER(MATCH(J$10,$U$2:$AE$2,)))),\"\",VLOOKUP(J$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=K$10,VLOOKUP(K$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(K$10,2)>5,AND(ISNUMBER(K$10),ISNUMBER(MATCH(K$10,$U$2:$AE$2,)))),\"\",VLOOKUP(K$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=L$10,VLOOKUP(L$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(L$10,2)>5,AND(ISNUMBER(L$10),ISNUMBER(MATCH(L$10,$U$2:$AE$2,)))),\"\",VLOOKUP(L$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=M$10,VLOOKUP(M$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(M$10,2)>5,AND(ISNUMBER(M$10),ISNUMBER(MATCH(M$10,$U$2:$AE$2,)))),\"\",VLOOKUP(M$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=N$10,VLOOKUP(N$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(N$10,2)>5,AND(ISNUMBER(N$10),ISNUMBER(MATCH(N$10,$U$2:$AE$2,)))),\"\",VLOOKUP(N$41,норма!$R$2:$T$8,3,))),\"\")","v":8},{"$f":"IFERROR(IF($G$2=O$10,VLOOKUP(O$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(O$10,2)>5,AND(ISNUMBER(O$10),ISNUMBER(MATCH(O$10,$U$2:$AE$2,)))),\"\",VLOOKUP(O$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=P$10,VLOOKUP(P$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(P$10,2)>5,AND(ISNUMBER(P$10),ISNUMBER(MATCH(P$10,$U$2:$AE$2,)))),\"\",VLOOKUP(P$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=Q$10,VLOOKUP(Q$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(Q$10,2)>5,AND(ISNUMBER(Q$10),ISNUMBER(MATCH(Q$10,$U$2:$AE$2,)))),\"\",VLOOKUP(Q$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=R$10,VLOOKUP(R$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(R$10,2)>5,AND(ISNUMBER(R$10),ISNUMBER(MATCH(R$10,$U$2:$AE$2,)))),\"\",VLOOKUP(R$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=S$10,VLOOKUP(S$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(S$10,2)>5,AND(ISNUMBER(S$10),ISNUMBER(MATCH(S$10,$U$2:$AE$2,)))),\"\",VLOOKUP(S$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=T$10,VLOOKUP(T$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(T$10,2)>5,AND(ISNUMBER(T$10),ISNUMBER(MATCH(T$10,$U$2:$AE$2,)))),\"\",VLOOKUP(T$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=U$10,VLOOKUP(U$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(U$10,2)>5,AND(ISNUMBER(U$10),ISNUMBER(MATCH(U$10,$U$2:$AE$2,)))),\"\",VLOOKUP(U$41,норма!$R$2:$T$8,3,))),\"\")","v":8},{"$f":"IFERROR(IF($G$2=V$10,VLOOKUP(V$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(V$10,2)>5,AND(ISNUMBER(V$10),ISNUMBER(MATCH(V$10,$U$2:$AE$2,)))),\"\",VLOOKUP(V$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=W$10,VLOOKUP(W$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(W$10,2)>5,AND(ISNUMBER(W$10),ISNUMBER(MATCH(W$10,$U$2:$AE$2,)))),\"\",VLOOKUP(W$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=X$10,VLOOKUP(X$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(X$10,2)>5,AND(ISNUMBER(X$10),ISNUMBER(MATCH(X$10,$U$2:$AE$2,)))),\"\",VLOOKUP(X$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=Y$10,VLOOKUP(Y$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(Y$10,2)>5,AND(ISNUMBER(Y$10),ISNUMBER(MATCH(Y$10,$U$2:$AE$2,)))),\"\",VLOOKUP(Y$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=Z$10,VLOOKUP(Z$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(Z$10,2)>5,AND(ISNUMBER(Z$10),ISNUMBER(MATCH(Z$10,$U$2:$AE$2,)))),\"\",VLOOKUP(Z$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=AA$10,VLOOKUP(AA$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AA$10,2)>5,AND(ISNUMBER(AA$10),ISNUMBER(MATCH(AA$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AA$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=AB$10,VLOOKUP(AB$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AB$10,2)>5,AND(ISNUMBER(AB$10),ISNUMBER(MATCH(AB$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AB$41,норма!$R$2:$T$8,3,))),\"\")","v":8},{"$f":"IFERROR(IF($G$2=AC$10,VLOOKUP(AC$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AC$10,2)>5,AND(ISNUMBER(AC$10),ISNUMBER(MATCH(AC$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AC$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=AD$10,VLOOKUP(AD$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AD$10,2)>5,AND(ISNUMBER(AD$10),ISNUMBER(MATCH(AD$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AD$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=AE$10,VLOOKUP(AE$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AE$10,2)>5,AND(ISNUMBER(AE$10),ISNUMBER(MATCH(AE$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AE$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=AF$10,VLOOKUP(AF$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AF$10,2)>5,AND(ISNUMBER(AF$10),ISNUMBER(MATCH(AF$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AF$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=AG$10,VLOOKUP(AG$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AG$10,2)>5,AND(ISNUMBER(AG$10),ISNUMBER(MATCH(AG$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AG$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=AH$10,VLOOKUP(AH$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AH$10,2)>5,AND(ISNUMBER(AH$10),ISNUMBER(MATCH(AH$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AH$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IF(C33>0,VLOOKUP($F$1,норма!$B$19:$G$30,6,FALSE)-(COUNTIF(D33:AH33,\"О\")*8)-(COUNTIF(D33:AH33,\"Э\")*8)-(COUNTIF(D33:AH33,\"Ж\")*8)-(COUNTIF(D33:AH33,\"Д,\")*8)-(COUNTIF(D33:AH33,\"К\")*8),\"-\")","v":150},{"$f":"SUMPRODUCT(--TEXT(MID(D33:AH33&IF(ISBLANK(D33:AH33),\"\",),1,SEARCH(\"/\",SUBSTITUTE(SUBSTITUTE(D33:AH33,\".\",\",\"),\"я\",)&\"0/\")-1),\"0;;0;\\0\"))","v":150},0,null,null,null,null,null,null,0,24,0,0,8,0]
[{"$f":"IF($C34=\"\",\"\",MAX($A$13:A33)+1)","v":""},null,null,{"$f":"IFERROR(IF($G$2=D$10,VLOOKUP(D$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(D$10,2)>5,AND(ISNUMBER(D$10),ISNUMBER(MATCH(D$10,$U$2:$AE$2,)))),\"\",VLOOKUP(D$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=E$10,VLOOKUP(E$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(E$10,2)>5,AND(ISNUMBER(E$10),ISNUMBER(MATCH(E$10,$U$2:$AE$2,)))),\"\",VLOOKUP(E$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=F$10,VLOOKUP(F$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(F$10,2)>5,AND(ISNUMBER(F$10),ISNUMBER(MATCH(F$10,$U$2:$AE$2,)))),\"\",VLOOKUP(F$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=G$10,VLOOKUP(G$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(G$10,2)>5,AND(ISNUMBER(G$10),ISNUMBER(MATCH(G$10,$U$2:$AE$2,)))),\"\",VLOOKUP(G$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=H$10,VLOOKUP(H$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(H$10,2)>5,AND(ISNUMBER(H$10),ISNUMBER(MATCH(H$10,$U$2:$AE$2,)))),\"\",VLOOKUP(H$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=I$10,VLOOKUP(I$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(I$10,2)>5,AND(ISNUMBER(I$10),ISNUMBER(MATCH(I$10,$U$2:$AE$2,)))),\"\",VLOOKUP(I$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=J$10,VLOOKUP(J$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(J$10,2)>5,AND(ISNUMBER(J$10),ISNUMBER(MATCH(J$10,$U$2:$AE$2,)))),\"\",VLOOKUP(J$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=K$10,VLOOKUP(K$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(K$10,2)>5,AND(ISNUMBER(K$10),ISNUMBER(MATCH(K$10,$U$2:$AE$2,)))),\"\",VLOOKUP(K$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=L$10,VLOOKUP(L$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(L$10,2)>5,AND(ISNUMBER(L$10),ISNUMBER(MATCH(L$10,$U$2:$AE$2,)))),\"\",VLOOKUP(L$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=M$10,VLOOKUP(M$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(M$10,2)>5,AND(ISNUMBER(M$10),ISNUMBER(MATCH(M$10,$U$2:$AE$2,)))),\"\",VLOOKUP(M$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=N$10,VLOOKUP(N$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(N$10,2)>5,AND(ISNUMBER(N$10),ISNUMBER(MATCH(N$10,$U$2:$AE$2,)))),\"\",VLOOKUP(N$41,норма!$R$2:$T$8,3,))),\"\")","v":8},{"$f":"IFERROR(IF($G$2=O$10,VLOOKUP(O$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(O$10,2)>5,AND(ISNUMBER(O$10),ISNUMBER(MATCH(O$10,$U$2:$AE$2,)))),\"\",VLOOKUP(O$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=P$10,VLOOKUP(P$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(P$10,2)>5,AND(ISNUMBER(P$10),ISNUMBER(MATCH(P$10,$U$2:$AE$2,)))),\"\",VLOOKUP(P$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=Q$10,VLOOKUP(Q$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(Q$10,2)>5,AND(ISNUMBER(Q$10),ISNUMBER(MATCH(Q$10,$U$2:$AE$2,)))),\"\",VLOOKUP(Q$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=R$10,VLOOKUP(R$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(R$10,2)>5,AND(ISNUMBER(R$10),ISNUMBER(MATCH(R$10,$U$2:$AE$2,)))),\"\",VLOOKUP(R$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=S$10,VLOOKUP(S$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(S$10,2)>5,AND(ISNUMBER(S$10),ISNUMBER(MATCH(S$10,$U$2:$AE$2,)))),\"\",VLOOKUP(S$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=T$10,VLOOKUP(T$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(T$10,2)>5,AND(ISNUMBER(T$10),ISNUMBER(MATCH(T$10,$U$2:$AE$2,)))),\"\",VLOOKUP(T$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=U$10,VLOOKUP(U$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(U$10,2)>5,AND(ISNUMBER(U$10),ISNUMBER(MATCH(U$10,$U$2:$AE$2,)))),\"\",VLOOKUP(U$41,норма!$R$2:$T$8,3,))),\"\")","v":8},{"$f":"IFERROR(IF($G$2=V$10,VLOOKUP(V$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(V$10,2)>5,AND(ISNUMBER(V$10),ISNUMBER(MATCH(V$10,$U$2:$AE$2,)))),\"\",VLOOKUP(V$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=W$10,VLOOKUP(W$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(W$10,2)>5,AND(ISNUMBER(W$10),ISNUMBER(MATCH(W$10,$U$2:$AE$2,)))),\"\",VLOOKUP(W$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=X$10,VLOOKUP(X$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(X$10,2)>5,AND(ISNUMBER(X$10),ISNUMBER(MATCH(X$10,$U$2:$AE$2,)))),\"\",VLOOKUP(X$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=Y$10,VLOOKUP(Y$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(Y$10,2)>5,AND(ISNUMBER(Y$10),ISNUMBER(MATCH(Y$10,$U$2:$AE$2,)))),\"\",VLOOKUP(Y$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=Z$10,VLOOKUP(Z$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(Z$10,2)>5,AND(ISNUMBER(Z$10),ISNUMBER(MATCH(Z$10,$U$2:$AE$2,)))),\"\",VLOOKUP(Z$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=AA$10,VLOOKUP(AA$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AA$10,2)>5,AND(ISNUMBER(AA$10),ISNUMBER(MATCH(AA$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AA$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=AB$10,VLOOKUP(AB$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AB$10,2)>5,AND(ISNUMBER(AB$10),ISNUMBER(MATCH(AB$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AB$41,норма!$R$2:$T$8,3,))),\"\")","v":8},{"$f":"IFERROR(IF($G$2=AC$10,VLOOKUP(AC$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AC$10,2)>5,AND(ISNUMBER(AC$10),ISNUMBER(MATCH(AC$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AC$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=AD$10,VLOOKUP(AD$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AD$10,2)>5,AND(ISNUMBER(AD$10),ISNUMBER(MATCH(AD$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AD$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=AE$10,VLOOKUP(AE$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AE$10,2)>5,AND(ISNUMBER(AE$10),ISNUMBER(MATCH(AE$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AE$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=AF$10,VLOOKUP(AF$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AF$10,2)>5,AND(ISNUMBER(AF$10),ISNUMBER(MATCH(AF$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AF$41,норма!$R$2:$T$8,3,))),\"\")","v":7},{"$f":"IFERROR(IF($G$2=AG$10,VLOOKUP(AG$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AG$10,2)>5,AND(ISNUMBER(AG$10),ISNUMBER(MATCH(AG$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AG$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IFERROR(IF($G$2=AH$10,VLOOKUP(AH$41,норма!$X$3:$AA$11,4,),IF(OR(WEEKDAY(AH$10,2)>5,AND(ISNUMBER(AH$10),ISNUMBER(MATCH(AH$10,$U$2:$AE$2,)))),\"\",VLOOKUP(AH$41,норма!$R$2:$T$8,3,))),\"\")","v":""},{"$f":"IF(C34>0,VLOOKUP($F$1,норма!$B$19:$G$30,4,FALSE)-(COUNTIF(D34:AH34,\"О\")*8)-(COUNTIF(D34:AH34,\"Э\")*8)-(COUNTIF(D34:AH34,\"Ж\")*8)-(COUNTIF(D34:AH34,\"Д,\")*8)-(COUNTIF(D34:AH34,\"К\")*8),\"-\")","v":"-"},{"$f":"SUMPRODUCT(--TEXT(MID(D34:AH34&IF(ISBLANK(D34:AH34),\"\",),1,SEARCH(\"/\",SUBSTITUTE(SUBSTITUTE(D34:AH34,\".\",\",\"),\"я\",)&\"0/\")-1),\"0;;0;\\0\"))","v":150},{"$f":"IF(AJ34<0,\"\",AJ34-AI34)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,0,24,0,0,8,0]
[{"$f":"IF($C35=\"\",\"\",MAX($A$13:A34)+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C35>0,VLOOKUP($F$1,норма!$B$19:$G$30,4,FALSE)-(COUNTIF(D35:AH35,\"О\")*8)-(COUNTIF(D35:AH35,\"Э\")*8)-(COUNTIF(D35:AH35,\"Ж\")*8)-(COUNTIF(D35:AH35,\"Д,\")*8)-(COUNTIF(D35:AH35,\"К\")*8),\"-\")","v":"-"},0,{"$error":"#VALUE!"},null,null,null,null,null,null,0,24,0,0,8,0]
[{"$f":"IF($C36=\"\",\"\",MAX($A$13:A35)+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C36>0,VLOOKUP($F$1,норма!$B$19:$G$30,4,FALSE)-(COUNTIF(D36:AH36,\"О\")*8)-(COUNTIF(D36:AH36,\"Э\")*8)-(COUNTIF(D36:AH36,\"Ж\")*8)-(COUNTIF(D36:AH36,\"Д,\")*8)-(COUNTIF(D36:AH36,\"К\")*8),\"-\")","v":"-"},0,{"$error":"#VALUE!"},null,null,null,null,null,null,0,24,0,0,8,0]
["В-вечерняя",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Инженер по труду",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,24,0,0,8,0]
["Н-ночная",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Табельщик"]
[]
[]
[null,null,null,{"$f":"IFERROR(WEEKDAY(D12,2),\"\")","v":5},{"$f":"IFERROR(WEEKDAY(E12,2),\"\")","v":6},7,1,2,3,4,5,6,7,1,2,3,4,5,6,7,1,2,3,4,5,6,7,1,2,3,4,5,6,""]

{"sheet":"норма","index":1,"n_rows":30,"n_cols":37,"rows_kept":30,"cut":false,"hidden":false,"merged":[[11,1,13,1],[0,17,0,19],[0,21,0,26],[0,31,0,36],[27,0,29,0],[16,1,16,6],[17,3,17,4],[17,5,17,6],[18,0,20,0],[21,0,23,0],[24,0,26,0],[0,1,0,11],[1,3,1,11],[1,13,13,14],[2,1,4,1],[5,1,7,1],[8,1,10,1]]}
[2024,"Заполняется раз в год",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"обычный",null,null,null,"предпраздничные и после",null,null,null,null,null,null,"Праздники",null,null,"копировать в значения"]
[null,null,null,"Праздничные",null,null,null,null,null,null,null,null,"Предпраздничные","тут нужно заполнять ТОЛЬКО праздники, которые НЕ в выходные дни.\n",null,"раб вых день",null,1,"Пн",8,null,"дата","мес","дн","д","дн","ч",null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC1)),\"\")","v":"2024-01-01"},null,null,"2024-01-09",{"$f":"WEEKDAY(AF2,2)","v":"1900-01-02"},{"$f":"TEXT(AF2,\"М\")","v":"1"},{"$f":"TEXT(AF2,\"Д\")","v":"9"},{"$f":"TEXT(AF2,\"ДДД\")","v":"Вт"},8]
[null,"1 квартал","январь",1,2,3,4,5,8,null,null,null,null,null,null,null,null,2,"Вт",7,null,"2024-01-09",1,2,9,"Вт",8,null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC2)),\"\")","v":"2024-01-02"},null,null,"2024-02-22",{"$f":"WEEKDAY(AF3,2)","v":"1900-01-04"},{"$f":"TEXT(AF3,\"М\")","v":"2"},{"$f":"TEXT(AF3,\"Д\")","v":"22"},{"$f":"TEXT(AF3,\"ДДД\")","v":"Чт"},6]
[null,null,"февраль",23,null,null,null,null,null,null,null,null,22,null,null,null,null,3,"Ср",7,null,"2024-02-22",2,4,22,"Чт",6,null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC3)),\"\")","v":"2024-01-03"},null,null,"2024-03-07","1900-01-04","3","7","Чт",6]
[null,null,"март",8,null,null,null,null,null,null,null,null,7,null,null,null,null,4,"Чт",7,null,"2024-03-07",3,4,7,"Чт",6,null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC4)),\"\")","v":"2024-01-04"},null,null,"2024-04-27","1900-01-06","4","27","Сб",7]
[null,"2 квартал","апрель",29,30,null,null,null,null,null,null,null,null,null,null,27,null,5,"Пт",7,null,"2024-04-27",4,6,27,"Сб",7,null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC5)),\"\")","v":"2024-01-05"},null,null,"2024-05-08","1900-01-03","5","8","Ср",6]
[null,null,"май",1,9,10,null,null,null,null,null,null,8,null,null,null,null,6,"Сб",0,null,"2024-05-08",5,3,8,"Ср",6,null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC6)),\"\")","v":"2024-01-08"},null,null,"2024-06-11","1900-01-02","6","11","Вт",6]
[null,null,"июнь",12,null,null,null,null,null,null,null,null,11,null,null,null,null,7,"Вс",0,null,"2024-06-11",6,2,11,"Вт",6,null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC7)),\"\")","v":"2024-02-23"},null,null,"2024-11-02","1900-01-06","11","2","Сб",6]
[null,"3 квартал","июль",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-11-02",11,6,2,"Сб",6,null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC8)),\"\")","v":"2024-03-08"},null,null,"2024-11-05","1900-01-02","11",{"$f":"TEXT(AF9,\"Д\")","v":"5"},"Вт",8]
[null,null,"август",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-11-05",11,2,5,"Вт",8,null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC9)),\"\")","v":"2024-04-29"},null,null,"2024-12-28","1900-01-06","12","28","Сб",7]
[null,null,"сентябрь",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-12-28",12,6,28,"Сб",7,null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC10)),\"\")","v":"2024-04-30"}]
[null,"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,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC11)),\"\")","v":"2024-05-01"}]
[null,null,"ноябрь",4,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC12)),\"\")","v":"2024-05-09"}]
[null,null,"декабрь",30,31,null,null,null,null,null,null,null,null,null,null,28,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC13)),\"\")","v":"2024-05-10"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC14)),\"\")","v":"2024-06-12"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC15)),\"\")","v":"2024-11-04"}]
[null,"Производственный календарь на 2024г. при 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,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC16)),\"\")","v":"2024-12-30"}]
[null,null,null,"муж.гр",null,"жен.гр",null,null,null,null,null,null,null,null,null,"нач","кон",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC17)),\"\")","v":"2024-12-31"}]
["1 квартал",1,"Январь",17,136,{"$f":"D19","v":17},123,null,null,null,null,1,"январь","января","01",9,31,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC18)),\"\")","v":""}]
[null,2,"Февраль",20,159,{"$f":"D20","v":20},143,null,null,null,null,2,"февраль","февраля","02",1,29,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC19)),\"\")","v":""}]
[null,3,"Март",20,159,{"$f":"D21","v":20},143,null,null,null,null,3,"март","марта","03",1,29,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC20)),\"\")","v":""}]
["2 квартал",4,"Апрель",21,168,{"$f":"D22","v":21},151,null,null,null,null,4,"апрель","апреля","04",1,27,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC21)),\"\")","v":""}]
[null,5,"Май",20,159,{"$f":"D23","v":20},143,null,null,null,null,5,"май","мая","05",2,31,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC22)),\"\")","v":""}]
[null,6,"Июнь",19,151,{"$f":"D24","v":19},136,null,null,null,null,6,"июнь","июня","06",3,28,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC23)),\"\")","v":""}]
["3 квартал",7,"Июль",23,184,23,166,null,null,null,null,7,"июль","июля","07",1,31,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(IF(D$3:L$14,--(D$3:L$14&\"/\"&C$3:C$14&\"/\"&A$1)),ROW(AC24)),\"\")","v":""}]
[null,8,"Август",22,176,22,158,null,null,null,null,8,"август","августа","08",1,30]
[null,9,"Сентябрь",21,168,21,152,null,null,null,null,9,"сентябрь","сентября","09",2,30]
["4 квартал",10,"Октябрь",23,184,23,165,null,null,null,null,10,"октябрь","октября","10",1,31]
[null,11,"Ноябрь",21,167,21,150,null,null,null,null,11,"ноябрь","ноября","11",1,29]
[null,12,"Декабрь",21,168,21,151,null,null,null,null,12,"декабрь","декабря","12",2,28]