{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1 (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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 (2)","index":0,"n_rows":32,"n_cols":22,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Kv","Admr","Lesb","Rel","Fz","Aktm","Mkim","Eksp","Sknr","КВ"]
[699,217,0,0,0,99,50,2,25,{"$f":"A2","v":699},{"$f":"IF(AND(J2<>0,J2<>\"\"),CONCATENATE(K1,\", \",J2),K1)","v":", 699"},{"$f":"IF(ISNUMBER(J2),CONCATENATE(J2,\" (\",I2,\",\",I3,\",\",I4,\",\",I5,\",\",I5,\")\"),\"\")","v":"699 (25,26,28,30,30)"},null,"до  КВ 700-го 'sknr' добавлял сам, формулой не получается",null,null,null,null,{"$f":"IF(J2=\"\",\"\",J2& \" (\"& СцЕсли($A$2:$A$21,J2,$I$2:$I$21,\".\") & \")\")","v":"699 (25.26.28.30)"},null,{"$f":"IF(A3=A2,I2&\".\"&U3, I2)","v":"25.26.28.30"},{"$f":"IF(A3=\"\",MID(IFERROR(VLOOKUP(A1,$A$1:V1,22,0),\"\"),3,9^9),IF(A2=A1,\"\",IFERROR(VLOOKUP(A1,$A$1:V1,22,0),\"\")&\"; \"&A2&\" (\"&U2&\")\"))","v":"; 699 (25.26.28.30)"}]
[699,217,0,0,0,99,50,2,26,{"$f":"IF(A2=A3,\"\",A3)","v":""},", 699",{"$f":"IF(ISNUMBER(J3),CONCATENATE(J3,\" (\",I3,\",\",I4,\",\",I5,\",\",I6,\",\",I6,\")\"),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(J3=\"\",\"\",J3& \" (\"& СцЕсли($A$2:$A$21,J3,$I$2:$I$21,\".\") & \")\")","v":""},null,{"$f":"IF(A4=A3,I3&\".\"&U4, I3)","v":"26.28.30"},{"$f":"IF(A4=\"\",MID(IFERROR(VLOOKUP(A2,$A$1:V2,22,0),\"\"),3,9^9),IF(A3=A2,\"\",IFERROR(VLOOKUP(A2,$A$1:V2,22,0),\"\")&\"; \"&A3&\" (\"&U3&\")\"))","v":""}]
[699,217,0,0,0,99,50,2,28,"",", 699","",null,null,null,null,null,null,{"$f":"IF(J4=\"\",\"\",J4& \" (\"& СцЕсли($A$2:$A$21,J4,$I$2:$I$21,\".\") & \")\")","v":""},null,"28.30",{"$f":"IF(A5=\"\",MID(IFERROR(VLOOKUP(A3,$A$1:V3,22,0),\"\"),3,9^9),IF(A4=A3,\"\",IFERROR(VLOOKUP(A3,$A$1:V3,22,0),\"\")&\"; \"&A4&\" (\"&U4&\")\"))","v":""}]
[699,217,0,0,0,99,50,2,30,"",", 699","",null,null,null,null,null,null,{"$f":"IF(J5=\"\",\"\",J5& \" (\"& СцЕсли($A$2:$A$21,J5,$I$2:$I$21,\".\") & \")\")","v":""},null,30,{"$f":"IF(A6=\"\",MID(IFERROR(VLOOKUP(A4,$A$1:V4,22,0),\"\"),3,9^9),IF(A5=A4,\"\",IFERROR(VLOOKUP(A4,$A$1:V4,22,0),\"\")&\"; \"&A5&\" (\"&U5&\")\"))","v":""}]
[700,217,0,0,0,99,50,2,35,700,", 699, 700",{"$f":"IF(ISNUMBER(J6),CONCATENATE(J6,\" (\",I6,\",\",I7,\",\",I8,\",\",I9,\",\",I9,\")\"),\"\")","v":"700 (35,38,39,40,40)"},null,"…….как ???",null,null,null,null,{"$f":"IF(J6=\"\",\"\",J6& \" (\"& СцЕсли($A$2:$A$21,J6,$I$2:$I$21,\".\") & \")\")","v":"700 (35.38.39.40.41.42.43.44.45.46.47.48.49.50)"},null,"35.38.39.40.41.42.43.44.45.46.47.48.49.50",{"$f":"IF(A7=\"\",MID(IFERROR(VLOOKUP(A5,$A$1:V5,22,0),\"\"),3,9^9),IF(A6=A5,\"\",IFERROR(VLOOKUP(A5,$A$1:V5,22,0),\"\")&\"; \"&A6&\" (\"&U6&\")\"))","v":"; 699 (25.26.28.30); 700 (35.38.39.40.41.42.43.44.45.46.47.48.49.50)"}]
[700,217,0,0,0,99,50,2,38,"",", 699, 700",{"$f":"IF(ISNUMBER(J7),CONCATENATE(J7,\" (\",I7,\",\",I8,\",\",I9,\",\",I10,\",\",I10,\")\"),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(J7=\"\",\"\",J7& \" (\"& СцЕсли($A$2:$A$21,J7,$I$2:$I$21,\".\") & \")\")","v":""},null,"38.39.40.41.42.43.44.45.46.47.48.49.50",{"$f":"IF(A8=\"\",MID(IFERROR(VLOOKUP(A6,$A$1:V6,22,0),\"\"),3,9^9),IF(A7=A6,\"\",IFERROR(VLOOKUP(A6,$A$1:V6,22,0),\"\")&\"; \"&A7&\" (\"&U7&\")\"))","v":""}]
[700,217,0,0,0,99,50,2,39,"",", 699, 700",{"$f":"IF(ISNUMBER(J8),CONCATENATE(J8,\" (\",I8,\",\",I9,\",\",I10,\",\",I11,\",\",I11,\")\"),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(J8=\"\",\"\",J8& \" (\"& СцЕсли($A$2:$A$21,J8,$I$2:$I$21,\".\") & \")\")","v":""},null,"39.40.41.42.43.44.45.46.47.48.49.50",{"$f":"IF(A9=\"\",MID(IFERROR(VLOOKUP(A7,$A$1:V7,22,0),\"\"),3,9^9),IF(A8=A7,\"\",IFERROR(VLOOKUP(A7,$A$1:V7,22,0),\"\")&\"; \"&A8&\" (\"&U8&\")\"))","v":""}]
[700,217,0,0,0,99,50,2,40,"",", 699, 700",null,null,null,null,null,null,null,{"$f":"IF(J9=\"\",\"\",J9& \" (\"& СцЕсли($A$2:$A$21,J9,$I$2:$I$21,\".\") & \")\")","v":""},null,"40.41.42.43.44.45.46.47.48.49.50",{"$f":"IF(A10=\"\",MID(IFERROR(VLOOKUP(A8,$A$1:V8,22,0),\"\"),3,9^9),IF(A9=A8,\"\",IFERROR(VLOOKUP(A8,$A$1:V8,22,0),\"\")&\"; \"&A9&\" (\"&U9&\")\"))","v":""}]
[700,217,0,0,0,99,50,2,41,"",", 699, 700",null,null,null,null,null,null,null,{"$f":"IF(J10=\"\",\"\",J10& \" (\"& СцЕсли($A$2:$A$21,J10,$I$2:$I$21,\".\") & \")\")","v":""},null,"41.42.43.44.45.46.47.48.49.50",{"$f":"IF(A11=\"\",MID(IFERROR(VLOOKUP(A9,$A$1:V9,22,0),\"\"),3,9^9),IF(A10=A9,\"\",IFERROR(VLOOKUP(A9,$A$1:V9,22,0),\"\")&\"; \"&A10&\" (\"&U10&\")\"))","v":""}]
[700,217,0,0,0,99,50,2,42,"",", 699, 700",null,null,"табличные данные экспортируются из txt файла",null,null,null,null,{"$f":"IF(J11=\"\",\"\",J11& \" (\"& СцЕсли($A$2:$A$21,J11,$I$2:$I$21,\".\") & \")\")","v":""},null,"42.43.44.45.46.47.48.49.50",{"$f":"IF(A12=\"\",MID(IFERROR(VLOOKUP(A10,$A$1:V10,22,0),\"\"),3,9^9),IF(A11=A10,\"\",IFERROR(VLOOKUP(A10,$A$1:V10,22,0),\"\")&\"; \"&A11&\" (\"&U11&\")\"))","v":""}]
[700,217,0,0,0,99,50,2,43,"",", 699, 700",null,null,null,null,null,null,null,{"$f":"IF(J12=\"\",\"\",J12& \" (\"& СцЕсли($A$2:$A$21,J12,$I$2:$I$21,\".\") & \")\")","v":""},null,"43.44.45.46.47.48.49.50",{"$f":"IF(A13=\"\",MID(IFERROR(VLOOKUP(A11,$A$1:V11,22,0),\"\"),3,9^9),IF(A12=A11,\"\",IFERROR(VLOOKUP(A11,$A$1:V11,22,0),\"\")&\"; \"&A12&\" (\"&U12&\")\"))","v":""}]
[700,217,0,0,0,99,50,2,44,"",", 699, 700",null,null,null,null,null,null,null,{"$f":"IF(J13=\"\",\"\",J13& \" (\"& СцЕсли($A$2:$A$21,J13,$I$2:$I$21,\".\") & \")\")","v":""},null,"44.45.46.47.48.49.50",{"$f":"IF(A14=\"\",MID(IFERROR(VLOOKUP(A12,$A$1:V12,22,0),\"\"),3,9^9),IF(A13=A12,\"\",IFERROR(VLOOKUP(A12,$A$1:V12,22,0),\"\")&\"; \"&A13&\" (\"&U13&\")\"))","v":""}]
[700,217,0,0,0,99,50,2,45,"",", 699, 700",null,null,null,null,null,null,null,{"$f":"IF(J14=\"\",\"\",J14& \" (\"& СцЕсли($A$2:$A$21,J14,$I$2:$I$21,\".\") & \")\")","v":""},null,"45.46.47.48.49.50",{"$f":"IF(A15=\"\",MID(IFERROR(VLOOKUP(A13,$A$1:V13,22,0),\"\"),3,9^9),IF(A14=A13,\"\",IFERROR(VLOOKUP(A13,$A$1:V13,22,0),\"\")&\"; \"&A14&\" (\"&U14&\")\"))","v":""}]
[700,217,0,0,0,99,50,2,46,"",", 699, 700",null,null,null,null,null,null,null,{"$f":"IF(J15=\"\",\"\",J15& \" (\"& СцЕсли($A$2:$A$21,J15,$I$2:$I$21,\".\") & \")\")","v":""},null,"46.47.48.49.50",{"$f":"IF(A16=\"\",MID(IFERROR(VLOOKUP(A14,$A$1:V14,22,0),\"\"),3,9^9),IF(A15=A14,\"\",IFERROR(VLOOKUP(A14,$A$1:V14,22,0),\"\")&\"; \"&A15&\" (\"&U15&\")\"))","v":""}]
[700,217,0,0,0,99,50,2,47,"",", 699, 700",null,null,null,null,null,null,null,{"$f":"IF(J16=\"\",\"\",J16& \" (\"& СцЕсли($A$2:$A$21,J16,$I$2:$I$21,\".\") & \")\")","v":""},null,"47.48.49.50",{"$f":"IF(A17=\"\",MID(IFERROR(VLOOKUP(A15,$A$1:V15,22,0),\"\"),3,9^9),IF(A16=A15,\"\",IFERROR(VLOOKUP(A15,$A$1:V15,22,0),\"\")&\"; \"&A16&\" (\"&U16&\")\"))","v":""}]
[700,217,0,0,0,99,50,2,48,"",", 699, 700",null,null,null,null,null,null,null,{"$f":"IF(J17=\"\",\"\",J17& \" (\"& СцЕсли($A$2:$A$21,J17,$I$2:$I$21,\".\") & \")\")","v":""},null,"48.49.50",{"$f":"IF(A18=\"\",MID(IFERROR(VLOOKUP(A16,$A$1:V16,22,0),\"\"),3,9^9),IF(A17=A16,\"\",IFERROR(VLOOKUP(A16,$A$1:V16,22,0),\"\")&\"; \"&A17&\" (\"&U17&\")\"))","v":""}]
[700,217,0,0,0,99,50,2,49,"",", 699, 700",null,null,null,null,null,null,null,{"$f":"IF(J18=\"\",\"\",J18& \" (\"& СцЕсли($A$2:$A$21,J18,$I$2:$I$21,\".\") & \")\")","v":""},null,"49.50",{"$f":"IF(A19=\"\",MID(IFERROR(VLOOKUP(A17,$A$1:V17,22,0),\"\"),3,9^9),IF(A18=A17,\"\",IFERROR(VLOOKUP(A17,$A$1:V17,22,0),\"\")&\"; \"&A18&\" (\"&U18&\")\"))","v":""}]
[700,217,0,0,0,99,50,2,50,"",", 699, 700",null,null,null,null,null,null,null,{"$f":"IF(J19=\"\",\"\",J19& \" (\"& СцЕсли($A$2:$A$21,J19,$I$2:$I$21,\".\") & \")\")","v":""},null,50,{"$f":"IF(A20=\"\",MID(IFERROR(VLOOKUP(A18,$A$1:V18,22,0),\"\"),3,9^9),IF(A19=A18,\"\",IFERROR(VLOOKUP(A18,$A$1:V18,22,0),\"\")&\"; \"&A19&\" (\"&U19&\")\"))","v":""}]
[701,217,0,0,0,99,50,2,36,701,", 699, 700, 701",null,null,null,null,null,null,null,{"$f":"IF(J20=\"\",\"\",J20& \" (\"& СцЕсли($A$2:$A$21,J20,$I$2:$I$21,\".\") & \")\")","v":"701 (36.37)"},null,"36.37",{"$f":"IF(A21=\"\",MID(IFERROR(VLOOKUP(A19,$A$1:V19,22,0),\"\"),3,9^9),IF(A20=A19,\"\",IFERROR(VLOOKUP(A19,$A$1:V19,22,0),\"\")&\"; \"&A20&\" (\"&U20&\")\"))","v":"; 699 (25.26.28.30); 700 (35.38.39.40.41.42.43.44.45.46.47.48.49.50); 701 (36.37)"}]
[701,217,0,0,0,99,50,2,37,"",", 699, 700, 701",null,null,null,null,null,null,null,{"$f":"IF(J21=\"\",\"\",J21& \" (\"& СцЕсли($A$2:$A$21,J21,$I$2:$I$21,\".\") & \")\")","v":""},null,37,{"$f":"IF(A22=\"\",MID(IFERROR(VLOOKUP(A20,$A$1:V20,22,0),\"\"),3,9^9),IF(A21=A20,\"\",IFERROR(VLOOKUP(A20,$A$1:V20,22,0),\"\")&\"; \"&A21&\" (\"&U21&\")\"))","v":"699 (25.26.28.30); 700 (35.38.39.40.41.42.43.44.45.46.47.48.49.50); 701 (36.37)"}]
[null,null,null,null,null,null,null,null,null,{"$f":"COUNT(J2:J21)","v":3}]
["объект расположен в kv №",null,null,{"$f":"MID(K21,2,J22*5+1)","v":" 699, 700, 701"}]
[]
["объект расположен в kv (sknr,);",null,null,"699 (25.26.28.30); 700(35.38.39.40.41.42.43.44.45.46.47.48.49.50); 701(…… и т.д.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"СцЕсли(S2:S21,\"<>\",S2:S21,\"; \")","v":"699 (25.26.28.30); 700 (35.38.39.40.41.42.43.44.45.46.47.48.49.50); 701 (36.37)"}]
[]
[]
[]
[]
[]
[]
[null,null,"желаемый результат"]