{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист1","Иванов"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":15,"n_cols":19,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,18,9,18],[3,17,4,18],[10,17,11,18],[5,8,9,8],[3,7,3,9],[11,8,11,10],[12,8,12,10],[13,8,13,10],[14,8,14,10],[5,14,9,14],[3,13,4,14],[10,13,11,14]]}
[]
[]
[]
[null,null,null,null,null,null,null,"Скрытие не нужных дней",null,null,null,null,null,"Выбор месяца",null,null,null,"Выбор года"]
[]
[null,null,null,null,null,null,null,null,{"$f":"MOD(DAY(DATE(S6,O6,31)),31)","v":0},null,null,null,null,null,10,null,null,null,2021]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($O$6=1,\"Январь\",IF($O$6=2,\"Февраль\",IF($O$6=3,\"Март\",IF($O$6=4,\"Апрель\",IF($O$6=5,\"Май\",IF($O$6=6,\"Июнь\",IF($O$6=7,\"Июль\",IF($O$6=8,\"Август\",IF($O$6=9,\"Сентябрь\",IF($O$6=10,\"Октябрь\",IF($O$6=11,\"Ноябрь\",IF($O$6=12,\"Декабрь\"))))))))))))","v":"Октябрь"}]
[null,null,null,null,null,null,null,0,"Возвращает все дни"]
[null,null,null,null,null,null,null,1,"Убирает 31 день"]
[null,null,null,null,null,null,null,2,"Убирает 30 и 31 день"]
[null,null,null,null,null,null,null,3,"Убирает 29, 30 и 31 день"]

{"sheet":"Иванов","index":1,"n_rows":13,"n_cols":39,"rows_kept":13,"cut":false,"hidden":false,"merged":[[4,38,7,38],[0,0,0,1],[1,2,2,2],[1,0,1,1],[0,2,0,21],[0,22,0,29],[12,12,12,23],[9,0,9,1],[10,0,10,1],[10,35,10,36],[0,35,0,36],[1,3,2,3],[1,35,1,36],[0,30,0,34]]}
["Социальный работник                               ",null,"График работы социального работника ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Лист1!$O$6=1,\"Январь\",IF(Лист1!$O$6=2,\"Февраль\",IF(Лист1!$O$6=3,\"Март\",IF(Лист1!$O$6=4,\"Апрель\",IF(Лист1!$O$6=5,\"Май\",IF(Лист1!$O$6=6,\"Июнь\",IF(Лист1!$O$6=7,\"Июль\",IF(Лист1!$O$6=8,\"Август\",IF(Лист1!$O$6=9,\"Сентябрь\",IF(Лист1!$O$6=10,\"Октябрь\",IF(Лист1!$O$6=11,\"Ноябрь\",IF(Лист1!$O$6=12,\"Декабрь\"))))))))))))","v":"Октябрь"},null,null,null,null,null,null,null,{"$f":"Лист1!S6","v":2021}]
[null,null,"время ","период",{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(A1))","v":"2021-10-01"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(B1))","v":"2021-10-02"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(C1))","v":"2021-10-03"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(D1))","v":"2021-10-04"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(E1))","v":"2021-10-05"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(F1))","v":"2021-10-06"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(G1))","v":"2021-10-07"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(H1))","v":"2021-10-08"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(I1))","v":"2021-10-09"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(J1))","v":"2021-10-10"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(K1))","v":"2021-10-11"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(L1))","v":"2021-10-12"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(M1))","v":"2021-10-13"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(N1))","v":"2021-10-14"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(O1))","v":"2021-10-15"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(P1))","v":"2021-10-16"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(Q1))","v":"2021-10-17"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(R1))","v":"2021-10-18"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(S1))","v":"2021-10-19"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(T1))","v":"2021-10-20"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(U1))","v":"2021-10-21"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(V1))","v":"2021-10-22"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(W1))","v":"2021-10-23"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(X1))","v":"2021-10-24"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(Y1))","v":"2021-10-25"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(Z1))","v":"2021-10-26"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(AA1))","v":"2021-10-27"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(AB1))","v":"2021-10-28"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(AC1))","v":"2021-10-29"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(AD1))","v":"2021-10-30"},{"$f":"DATE(Лист1!$S6,Лист1!$O6,COLUMN(AE1))","v":"2021-10-31"},null,null,null,"Всего"]
["Дни посещений","Услуги",null,null,{"$f":"TEXT(E2,\"ддд\")","v":"Пт"},{"$f":"TEXT(F2,\"ддд\")","v":"Сб"},"Вс","Пн","Вт","Ср","Чт",{"$f":"TEXT(L2,\"ддд\")","v":"Пт"},"Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","минут","услуг",null,"услуг"]
["Иванов","1 группа",null,{"$f":"COUNTA(E4:AI4)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(--SUBSTITUTE(D4,\" р/д\",),1)","v":0}]
["пн,вт,ср,чт,пт","Приготовление пищи",10,"3 р/д",{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(E$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(E$3,\" \"&$A5)-2,4)=COUNTIF($E$3:E$3,E$3)&\" \"&E$3,ISNUMBER(SEARCH(E$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:E4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(F$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(F$3,\" \"&$A5)-2,4)=COUNTIF($E$3:F$3,F$3)&\" \"&F$3,ISNUMBER(SEARCH(F$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:F4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(G$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(G$3,\" \"&$A5)-2,4)=COUNTIF($E$3:G$3,G$3)&\" \"&G$3,ISNUMBER(SEARCH(G$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:G4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(H$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(H$3,\" \"&$A5)-2,4)=COUNTIF($E$3:H$3,H$3)&\" \"&H$3,ISNUMBER(SEARCH(H$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:H4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(I$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(I$3,\" \"&$A5)-2,4)=COUNTIF($E$3:I$3,I$3)&\" \"&I$3,ISNUMBER(SEARCH(I$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:I4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(J$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(J$3,\" \"&$A5)-2,4)=COUNTIF($E$3:J$3,J$3)&\" \"&J$3,ISNUMBER(SEARCH(J$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:J4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(K$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(K$3,\" \"&$A5)-2,4)=COUNTIF($E$3:K$3,K$3)&\" \"&K$3,ISNUMBER(SEARCH(K$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:K4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(L$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(L$3,\" \"&$A5)-2,4)=COUNTIF($E$3:L$3,L$3)&\" \"&L$3,ISNUMBER(SEARCH(L$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:L4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(M$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(M$3,\" \"&$A5)-2,4)=COUNTIF($E$3:M$3,M$3)&\" \"&M$3,ISNUMBER(SEARCH(M$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:M4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(N$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(N$3,\" \"&$A5)-2,4)=COUNTIF($E$3:N$3,N$3)&\" \"&N$3,ISNUMBER(SEARCH(N$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:N4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(O$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(O$3,\" \"&$A5)-2,4)=COUNTIF($E$3:O$3,O$3)&\" \"&O$3,ISNUMBER(SEARCH(O$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:O4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(P$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(P$3,\" \"&$A5)-2,4)=COUNTIF($E$3:P$3,P$3)&\" \"&P$3,ISNUMBER(SEARCH(P$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:P4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(Q$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(Q$3,\" \"&$A5)-2,4)=COUNTIF($E$3:Q$3,Q$3)&\" \"&Q$3,ISNUMBER(SEARCH(Q$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:Q4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(R$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(R$3,\" \"&$A5)-2,4)=COUNTIF($E$3:R$3,R$3)&\" \"&R$3,ISNUMBER(SEARCH(R$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:R4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(S$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(S$3,\" \"&$A5)-2,4)=COUNTIF($E$3:S$3,S$3)&\" \"&S$3,ISNUMBER(SEARCH(S$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:S4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(T$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(T$3,\" \"&$A5)-2,4)=COUNTIF($E$3:T$3,T$3)&\" \"&T$3,ISNUMBER(SEARCH(T$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:T4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(U$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(U$3,\" \"&$A5)-2,4)=COUNTIF($E$3:U$3,U$3)&\" \"&U$3,ISNUMBER(SEARCH(U$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:U4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(V$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(V$3,\" \"&$A5)-2,4)=COUNTIF($E$3:V$3,V$3)&\" \"&V$3,ISNUMBER(SEARCH(V$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:V4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(W$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(W$3,\" \"&$A5)-2,4)=COUNTIF($E$3:W$3,W$3)&\" \"&W$3,ISNUMBER(SEARCH(W$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:W4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(X$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(X$3,\" \"&$A5)-2,4)=COUNTIF($E$3:X$3,X$3)&\" \"&X$3,ISNUMBER(SEARCH(X$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:X4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(Y$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(Y$3,\" \"&$A5)-2,4)=COUNTIF($E$3:Y$3,Y$3)&\" \"&Y$3,ISNUMBER(SEARCH(Y$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:Y4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(Z$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(Z$3,\" \"&$A5)-2,4)=COUNTIF($E$3:Z$3,Z$3)&\" \"&Z$3,ISNUMBER(SEARCH(Z$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:Z4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(AA$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(AA$3,\" \"&$A5)-2,4)=COUNTIF($E$3:AA$3,AA$3)&\" \"&AA$3,ISNUMBER(SEARCH(AA$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:AA4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(AB$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(AB$3,\" \"&$A5)-2,4)=COUNTIF($E$3:AB$3,AB$3)&\" \"&AB$3,ISNUMBER(SEARCH(AB$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:AB4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(AC$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(AC$3,\" \"&$A5)-2,4)=COUNTIF($E$3:AC$3,AC$3)&\" \"&AC$3,ISNUMBER(SEARCH(AC$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:AC4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(AD$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(AD$3,\" \"&$A5)-2,4)=COUNTIF($E$3:AD$3,AD$3)&\" \"&AD$3,ISNUMBER(SEARCH(AD$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:AD4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(AE$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(AE$3,\" \"&$A5)-2,4)=COUNTIF($E$3:AE$3,AE$3)&\" \"&AE$3,ISNUMBER(SEARCH(AE$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:AE4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(AF$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(AF$3,\" \"&$A5)-2,4)=COUNTIF($E$3:AF$3,AF$3)&\" \"&AF$3,ISNUMBER(SEARCH(AF$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:AF4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(AG$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(AG$3,\" \"&$A5)-2,4)=COUNTIF($E$3:AG$3,AG$3)&\" \"&AG$3,ISNUMBER(SEARCH(AG$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:AG4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(AH$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(AH$3,\" \"&$A5)-2,4)=COUNTIF($E$3:AH$3,AH$3)&\" \"&AH$3,ISNUMBER(SEARCH(AH$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:AH4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A5,SEARCH(AI$3,\" \"&$A5)-2,1)),MID(\" \"&$A5,SEARCH(AI$3,\" \"&$A5)-2,4)=COUNTIF($E$3:AI$3,AI$3)&\" \"&AI$3,ISNUMBER(SEARCH(AI$3,$A5))),IF(VLOOKUP(9E+307,$D$4:$D4,1)*(VLOOKUP(9E+307,$D$4:AI4,COLUMN()-3)<>\"\"),$C5*$AL5&\"\",$C5*$AL5),\"\")","v":""},{"$f":"SUM(E5:INDEX(E5:AI5,31-Лист1!$I$6))","v":630},{"$f":"COUNT(E5:INDEX(E5:AI5,31-Лист1!$I$6))*AL5","v":63},{"$f":"IFERROR(--SUBSTITUTE(D5,\" р/д\",),1)","v":3},{"$f":"SUM(AK5:AK8)","v":131}]
["пн,вт,ср,чт,пт","Смена памперса",15,"2 р/д",{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(E$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(E$3,\" \"&$A6)-2,4)=COUNTIF($E$3:E$3,E$3)&\" \"&E$3,ISNUMBER(SEARCH(E$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:E5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(F$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(F$3,\" \"&$A6)-2,4)=COUNTIF($E$3:F$3,F$3)&\" \"&F$3,ISNUMBER(SEARCH(F$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:F5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(G$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(G$3,\" \"&$A6)-2,4)=COUNTIF($E$3:G$3,G$3)&\" \"&G$3,ISNUMBER(SEARCH(G$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:G5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(H$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(H$3,\" \"&$A6)-2,4)=COUNTIF($E$3:H$3,H$3)&\" \"&H$3,ISNUMBER(SEARCH(H$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:H5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(I$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(I$3,\" \"&$A6)-2,4)=COUNTIF($E$3:I$3,I$3)&\" \"&I$3,ISNUMBER(SEARCH(I$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:I5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(J$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(J$3,\" \"&$A6)-2,4)=COUNTIF($E$3:J$3,J$3)&\" \"&J$3,ISNUMBER(SEARCH(J$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:J5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(K$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(K$3,\" \"&$A6)-2,4)=COUNTIF($E$3:K$3,K$3)&\" \"&K$3,ISNUMBER(SEARCH(K$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:K5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(L$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(L$3,\" \"&$A6)-2,4)=COUNTIF($E$3:L$3,L$3)&\" \"&L$3,ISNUMBER(SEARCH(L$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:L5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(M$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(M$3,\" \"&$A6)-2,4)=COUNTIF($E$3:M$3,M$3)&\" \"&M$3,ISNUMBER(SEARCH(M$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:M5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(N$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(N$3,\" \"&$A6)-2,4)=COUNTIF($E$3:N$3,N$3)&\" \"&N$3,ISNUMBER(SEARCH(N$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:N5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(O$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(O$3,\" \"&$A6)-2,4)=COUNTIF($E$3:O$3,O$3)&\" \"&O$3,ISNUMBER(SEARCH(O$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:O5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(P$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(P$3,\" \"&$A6)-2,4)=COUNTIF($E$3:P$3,P$3)&\" \"&P$3,ISNUMBER(SEARCH(P$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:P5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(Q$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(Q$3,\" \"&$A6)-2,4)=COUNTIF($E$3:Q$3,Q$3)&\" \"&Q$3,ISNUMBER(SEARCH(Q$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:Q5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(R$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(R$3,\" \"&$A6)-2,4)=COUNTIF($E$3:R$3,R$3)&\" \"&R$3,ISNUMBER(SEARCH(R$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:R5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(S$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(S$3,\" \"&$A6)-2,4)=COUNTIF($E$3:S$3,S$3)&\" \"&S$3,ISNUMBER(SEARCH(S$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:S5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(T$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(T$3,\" \"&$A6)-2,4)=COUNTIF($E$3:T$3,T$3)&\" \"&T$3,ISNUMBER(SEARCH(T$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:T5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(U$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(U$3,\" \"&$A6)-2,4)=COUNTIF($E$3:U$3,U$3)&\" \"&U$3,ISNUMBER(SEARCH(U$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:U5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(V$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(V$3,\" \"&$A6)-2,4)=COUNTIF($E$3:V$3,V$3)&\" \"&V$3,ISNUMBER(SEARCH(V$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:V5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(W$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(W$3,\" \"&$A6)-2,4)=COUNTIF($E$3:W$3,W$3)&\" \"&W$3,ISNUMBER(SEARCH(W$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:W5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(X$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(X$3,\" \"&$A6)-2,4)=COUNTIF($E$3:X$3,X$3)&\" \"&X$3,ISNUMBER(SEARCH(X$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:X5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(Y$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(Y$3,\" \"&$A6)-2,4)=COUNTIF($E$3:Y$3,Y$3)&\" \"&Y$3,ISNUMBER(SEARCH(Y$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:Y5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(Z$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(Z$3,\" \"&$A6)-2,4)=COUNTIF($E$3:Z$3,Z$3)&\" \"&Z$3,ISNUMBER(SEARCH(Z$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:Z5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(AA$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(AA$3,\" \"&$A6)-2,4)=COUNTIF($E$3:AA$3,AA$3)&\" \"&AA$3,ISNUMBER(SEARCH(AA$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:AA5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(AB$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(AB$3,\" \"&$A6)-2,4)=COUNTIF($E$3:AB$3,AB$3)&\" \"&AB$3,ISNUMBER(SEARCH(AB$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:AB5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(AC$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(AC$3,\" \"&$A6)-2,4)=COUNTIF($E$3:AC$3,AC$3)&\" \"&AC$3,ISNUMBER(SEARCH(AC$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:AC5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(AD$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(AD$3,\" \"&$A6)-2,4)=COUNTIF($E$3:AD$3,AD$3)&\" \"&AD$3,ISNUMBER(SEARCH(AD$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:AD5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(AE$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(AE$3,\" \"&$A6)-2,4)=COUNTIF($E$3:AE$3,AE$3)&\" \"&AE$3,ISNUMBER(SEARCH(AE$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:AE5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(AF$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(AF$3,\" \"&$A6)-2,4)=COUNTIF($E$3:AF$3,AF$3)&\" \"&AF$3,ISNUMBER(SEARCH(AF$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:AF5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(AG$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(AG$3,\" \"&$A6)-2,4)=COUNTIF($E$3:AG$3,AG$3)&\" \"&AG$3,ISNUMBER(SEARCH(AG$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:AG5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":30},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(AH$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(AH$3,\" \"&$A6)-2,4)=COUNTIF($E$3:AH$3,AH$3)&\" \"&AH$3,ISNUMBER(SEARCH(AH$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:AH5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A6,SEARCH(AI$3,\" \"&$A6)-2,1)),MID(\" \"&$A6,SEARCH(AI$3,\" \"&$A6)-2,4)=COUNTIF($E$3:AI$3,AI$3)&\" \"&AI$3,ISNUMBER(SEARCH(AI$3,$A6))),IF(VLOOKUP(9E+307,$D$4:$D5,1)*(VLOOKUP(9E+307,$D$4:AI5,COLUMN()-3)<>\"\"),$C6*$AL6&\"\",$C6*$AL6),\"\")","v":""},{"$f":"SUM(E6:INDEX(E6:AI6,31-Лист1!$I$6))","v":630},{"$f":"COUNT(E6:INDEX(E6:AI6,31-Лист1!$I$6))*AL6","v":42},{"$f":"IFERROR(--SUBSTITUTE(D6,\" р/д\",),1)","v":2}]
["пн,ср,пт","Топка печи",20,"2 р/д",{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(E$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(E$3,\" \"&$A7)-2,4)=COUNTIF($E$3:E$3,E$3)&\" \"&E$3,ISNUMBER(SEARCH(E$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:E6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":40},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(F$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(F$3,\" \"&$A7)-2,4)=COUNTIF($E$3:F$3,F$3)&\" \"&F$3,ISNUMBER(SEARCH(F$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:F6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(G$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(G$3,\" \"&$A7)-2,4)=COUNTIF($E$3:G$3,G$3)&\" \"&G$3,ISNUMBER(SEARCH(G$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:G6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(H$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(H$3,\" \"&$A7)-2,4)=COUNTIF($E$3:H$3,H$3)&\" \"&H$3,ISNUMBER(SEARCH(H$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:H6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":40},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(I$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(I$3,\" \"&$A7)-2,4)=COUNTIF($E$3:I$3,I$3)&\" \"&I$3,ISNUMBER(SEARCH(I$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:I6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(J$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(J$3,\" \"&$A7)-2,4)=COUNTIF($E$3:J$3,J$3)&\" \"&J$3,ISNUMBER(SEARCH(J$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:J6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":40},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(K$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(K$3,\" \"&$A7)-2,4)=COUNTIF($E$3:K$3,K$3)&\" \"&K$3,ISNUMBER(SEARCH(K$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:K6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(L$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(L$3,\" \"&$A7)-2,4)=COUNTIF($E$3:L$3,L$3)&\" \"&L$3,ISNUMBER(SEARCH(L$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:L6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":40},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(M$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(M$3,\" \"&$A7)-2,4)=COUNTIF($E$3:M$3,M$3)&\" \"&M$3,ISNUMBER(SEARCH(M$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:M6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(N$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(N$3,\" \"&$A7)-2,4)=COUNTIF($E$3:N$3,N$3)&\" \"&N$3,ISNUMBER(SEARCH(N$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:N6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(O$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(O$3,\" \"&$A7)-2,4)=COUNTIF($E$3:O$3,O$3)&\" \"&O$3,ISNUMBER(SEARCH(O$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:O6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":40},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(P$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(P$3,\" \"&$A7)-2,4)=COUNTIF($E$3:P$3,P$3)&\" \"&P$3,ISNUMBER(SEARCH(P$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:P6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(Q$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(Q$3,\" \"&$A7)-2,4)=COUNTIF($E$3:Q$3,Q$3)&\" \"&Q$3,ISNUMBER(SEARCH(Q$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:Q6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":40},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(R$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(R$3,\" \"&$A7)-2,4)=COUNTIF($E$3:R$3,R$3)&\" \"&R$3,ISNUMBER(SEARCH(R$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:R6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(S$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(S$3,\" \"&$A7)-2,4)=COUNTIF($E$3:S$3,S$3)&\" \"&S$3,ISNUMBER(SEARCH(S$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:S6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":40},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(T$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(T$3,\" \"&$A7)-2,4)=COUNTIF($E$3:T$3,T$3)&\" \"&T$3,ISNUMBER(SEARCH(T$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:T6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(U$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(U$3,\" \"&$A7)-2,4)=COUNTIF($E$3:U$3,U$3)&\" \"&U$3,ISNUMBER(SEARCH(U$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:U6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(V$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(V$3,\" \"&$A7)-2,4)=COUNTIF($E$3:V$3,V$3)&\" \"&V$3,ISNUMBER(SEARCH(V$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:V6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":40},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(W$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(W$3,\" \"&$A7)-2,4)=COUNTIF($E$3:W$3,W$3)&\" \"&W$3,ISNUMBER(SEARCH(W$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:W6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(X$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(X$3,\" \"&$A7)-2,4)=COUNTIF($E$3:X$3,X$3)&\" \"&X$3,ISNUMBER(SEARCH(X$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:X6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":40},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(Y$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(Y$3,\" \"&$A7)-2,4)=COUNTIF($E$3:Y$3,Y$3)&\" \"&Y$3,ISNUMBER(SEARCH(Y$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:Y6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(Z$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(Z$3,\" \"&$A7)-2,4)=COUNTIF($E$3:Z$3,Z$3)&\" \"&Z$3,ISNUMBER(SEARCH(Z$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:Z6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":40},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(AA$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(AA$3,\" \"&$A7)-2,4)=COUNTIF($E$3:AA$3,AA$3)&\" \"&AA$3,ISNUMBER(SEARCH(AA$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:AA6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(AB$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(AB$3,\" \"&$A7)-2,4)=COUNTIF($E$3:AB$3,AB$3)&\" \"&AB$3,ISNUMBER(SEARCH(AB$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:AB6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(AC$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(AC$3,\" \"&$A7)-2,4)=COUNTIF($E$3:AC$3,AC$3)&\" \"&AC$3,ISNUMBER(SEARCH(AC$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:AC6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":40},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(AD$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(AD$3,\" \"&$A7)-2,4)=COUNTIF($E$3:AD$3,AD$3)&\" \"&AD$3,ISNUMBER(SEARCH(AD$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:AD6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(AE$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(AE$3,\" \"&$A7)-2,4)=COUNTIF($E$3:AE$3,AE$3)&\" \"&AE$3,ISNUMBER(SEARCH(AE$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:AE6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":40},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(AF$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(AF$3,\" \"&$A7)-2,4)=COUNTIF($E$3:AF$3,AF$3)&\" \"&AF$3,ISNUMBER(SEARCH(AF$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:AF6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(AG$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(AG$3,\" \"&$A7)-2,4)=COUNTIF($E$3:AG$3,AG$3)&\" \"&AG$3,ISNUMBER(SEARCH(AG$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:AG6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":40},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(AH$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(AH$3,\" \"&$A7)-2,4)=COUNTIF($E$3:AH$3,AH$3)&\" \"&AH$3,ISNUMBER(SEARCH(AH$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:AH6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A7,SEARCH(AI$3,\" \"&$A7)-2,1)),MID(\" \"&$A7,SEARCH(AI$3,\" \"&$A7)-2,4)=COUNTIF($E$3:AI$3,AI$3)&\" \"&AI$3,ISNUMBER(SEARCH(AI$3,$A7))),IF(VLOOKUP(9E+307,$D$4:$D6,1)*(VLOOKUP(9E+307,$D$4:AI6,COLUMN()-3)<>\"\"),$C7*$AL7&\"\",$C7*$AL7),\"\")","v":""},{"$f":"SUM(E7:INDEX(E7:AI7,31-Лист1!$I$6))","v":520},{"$f":"COUNT(E7:INDEX(E7:AI7,31-Лист1!$I$6))*AL7","v":26},2]
[null,null,null,null,{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(E$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(E$3,\" \"&$A8)-2,4)=COUNTIF($E$3:E$3,E$3)&\" \"&E$3,ISNUMBER(SEARCH(E$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:E7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(F$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(F$3,\" \"&$A8)-2,4)=COUNTIF($E$3:F$3,F$3)&\" \"&F$3,ISNUMBER(SEARCH(F$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:F7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(G$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(G$3,\" \"&$A8)-2,4)=COUNTIF($E$3:G$3,G$3)&\" \"&G$3,ISNUMBER(SEARCH(G$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:G7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(H$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(H$3,\" \"&$A8)-2,4)=COUNTIF($E$3:H$3,H$3)&\" \"&H$3,ISNUMBER(SEARCH(H$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:H7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(I$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(I$3,\" \"&$A8)-2,4)=COUNTIF($E$3:I$3,I$3)&\" \"&I$3,ISNUMBER(SEARCH(I$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:I7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(J$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(J$3,\" \"&$A8)-2,4)=COUNTIF($E$3:J$3,J$3)&\" \"&J$3,ISNUMBER(SEARCH(J$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:J7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(K$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(K$3,\" \"&$A8)-2,4)=COUNTIF($E$3:K$3,K$3)&\" \"&K$3,ISNUMBER(SEARCH(K$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:K7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(L$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(L$3,\" \"&$A8)-2,4)=COUNTIF($E$3:L$3,L$3)&\" \"&L$3,ISNUMBER(SEARCH(L$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:L7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(M$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(M$3,\" \"&$A8)-2,4)=COUNTIF($E$3:M$3,M$3)&\" \"&M$3,ISNUMBER(SEARCH(M$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:M7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(N$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(N$3,\" \"&$A8)-2,4)=COUNTIF($E$3:N$3,N$3)&\" \"&N$3,ISNUMBER(SEARCH(N$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:N7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(O$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(O$3,\" \"&$A8)-2,4)=COUNTIF($E$3:O$3,O$3)&\" \"&O$3,ISNUMBER(SEARCH(O$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:O7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(P$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(P$3,\" \"&$A8)-2,4)=COUNTIF($E$3:P$3,P$3)&\" \"&P$3,ISNUMBER(SEARCH(P$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:P7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(Q$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(Q$3,\" \"&$A8)-2,4)=COUNTIF($E$3:Q$3,Q$3)&\" \"&Q$3,ISNUMBER(SEARCH(Q$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:Q7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(R$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(R$3,\" \"&$A8)-2,4)=COUNTIF($E$3:R$3,R$3)&\" \"&R$3,ISNUMBER(SEARCH(R$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:R7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(S$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(S$3,\" \"&$A8)-2,4)=COUNTIF($E$3:S$3,S$3)&\" \"&S$3,ISNUMBER(SEARCH(S$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:S7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(T$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(T$3,\" \"&$A8)-2,4)=COUNTIF($E$3:T$3,T$3)&\" \"&T$3,ISNUMBER(SEARCH(T$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:T7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(U$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(U$3,\" \"&$A8)-2,4)=COUNTIF($E$3:U$3,U$3)&\" \"&U$3,ISNUMBER(SEARCH(U$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:U7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(V$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(V$3,\" \"&$A8)-2,4)=COUNTIF($E$3:V$3,V$3)&\" \"&V$3,ISNUMBER(SEARCH(V$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:V7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(W$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(W$3,\" \"&$A8)-2,4)=COUNTIF($E$3:W$3,W$3)&\" \"&W$3,ISNUMBER(SEARCH(W$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:W7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(X$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(X$3,\" \"&$A8)-2,4)=COUNTIF($E$3:X$3,X$3)&\" \"&X$3,ISNUMBER(SEARCH(X$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:X7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(Y$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(Y$3,\" \"&$A8)-2,4)=COUNTIF($E$3:Y$3,Y$3)&\" \"&Y$3,ISNUMBER(SEARCH(Y$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:Y7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(Z$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(Z$3,\" \"&$A8)-2,4)=COUNTIF($E$3:Z$3,Z$3)&\" \"&Z$3,ISNUMBER(SEARCH(Z$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:Z7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(AA$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(AA$3,\" \"&$A8)-2,4)=COUNTIF($E$3:AA$3,AA$3)&\" \"&AA$3,ISNUMBER(SEARCH(AA$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:AA7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(AB$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(AB$3,\" \"&$A8)-2,4)=COUNTIF($E$3:AB$3,AB$3)&\" \"&AB$3,ISNUMBER(SEARCH(AB$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:AB7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(AC$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(AC$3,\" \"&$A8)-2,4)=COUNTIF($E$3:AC$3,AC$3)&\" \"&AC$3,ISNUMBER(SEARCH(AC$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:AC7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(AD$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(AD$3,\" \"&$A8)-2,4)=COUNTIF($E$3:AD$3,AD$3)&\" \"&AD$3,ISNUMBER(SEARCH(AD$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:AD7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(AE$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(AE$3,\" \"&$A8)-2,4)=COUNTIF($E$3:AE$3,AE$3)&\" \"&AE$3,ISNUMBER(SEARCH(AE$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:AE7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(AF$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(AF$3,\" \"&$A8)-2,4)=COUNTIF($E$3:AF$3,AF$3)&\" \"&AF$3,ISNUMBER(SEARCH(AF$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:AF7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(AG$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(AG$3,\" \"&$A8)-2,4)=COUNTIF($E$3:AG$3,AG$3)&\" \"&AG$3,ISNUMBER(SEARCH(AG$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:AG7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(AH$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(AH$3,\" \"&$A8)-2,4)=COUNTIF($E$3:AH$3,AH$3)&\" \"&AH$3,ISNUMBER(SEARCH(AH$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:AH7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"IF(IF(ISNUMBER(-MID(\" \"&$A8,SEARCH(AI$3,\" \"&$A8)-2,1)),MID(\" \"&$A8,SEARCH(AI$3,\" \"&$A8)-2,4)=COUNTIF($E$3:AI$3,AI$3)&\" \"&AI$3,ISNUMBER(SEARCH(AI$3,$A8))),IF(VLOOKUP(9E+307,$D$4:$D7,1)*(VLOOKUP(9E+307,$D$4:AI7,COLUMN()-3)<>\"\"),$C8*$AL8&\"\",$C8*$AL8),\"\")","v":""},{"$f":"SUM(E8:INDEX(E8:AI8,31-Лист1!$I$6))","v":0},{"$f":"COUNT(E8:INDEX(E8:AI8,31-Лист1!$I$6))*AL8","v":0},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,1]
["Всего затрачено времени (мин)",null,null,null,{"$f":"SUM(E5:E7)","v":100},0,0,100,60,100,60,100,0,0,100,60,100,60,100,0,0,100,60,100,60,100,0,0,100,60,100,60,100,0,0,1780,131,1]
["Всего затрачено времени (час)",null,null,null,{"$f":"E10/1440","v":"01:40:00"},{"$f":"F10/1440","v":"00:00:00"},"00:00:00","01:40:00","01:00:00","01:40:00","01:00:00","01:40:00","00:00:00","00:00:00","01:40:00","01:00:00","01:40:00","01:00:00","01:40:00","00:00:00","00:00:00","01:40:00","01:00:00","01:40:00","01:00:00","01:40:00","00:00:00","00:00:00","01:40:00","01:00:00","01:40:00","01:00:00","01:40:00","00:00:00","00:00:00",{"$f":"SUM(E11:AI11)","v":1.2361111111111112},null,1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Социальный работник    ______________      "]