{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"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","index":0,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,4,2,13]]}
[null,"Было:",null,"Должно получиться так:"]
[]
[null,"Расположение участка",null,"Наименование участкового лесничества","Номера занимаемых кварталов"]
[null,"Хоэнское лесничество кв.№ 40, 41-45, 49-52",null,"Хоэнское лесничество",40,41,42,43,44,45,49,50,51,52]
[null,"Александровское уч. лес-во кв № 1-5, 10-12",null,"Александровское уч. лес-во",1,2,3,4,5,10,11,12]
[null,"Агневское лесничество в кварталах №№ 60-62,137-139",null,"Агневское лесничество",60,61,62,137,138,139]
[]
[null,null,null,"Наименование участкового лесничества"]
[null,"Помогите автоматизировать перевод текста по столбцам, содержащий численные интервалы кварталов.",null,"Хоэнское лесничество",{"$f":"Substring(ExpandListA(SubstringRev($B4,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"40"},{"$f":"Substring(ExpandListA(SubstringRev($B4,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"41"},{"$f":"Substring(ExpandListA(SubstringRev($B4,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"42"},{"$f":"Substring(ExpandListA(SubstringRev($B4,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"43"},{"$f":"Substring(ExpandListA(SubstringRev($B4,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"44"},{"$f":"Substring(ExpandListA(SubstringRev($B4,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"45"},{"$f":"Substring(ExpandListA(SubstringRev($B4,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"49"},{"$f":"Substring(ExpandListA(SubstringRev($B4,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"50"},{"$f":"Substring(ExpandListA(SubstringRev($B4,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"51"},{"$f":"Substring(ExpandListA(SubstringRev($B4,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"52"}]
[null,null,null,"Александровское уч. лес-во",{"$f":"Substring(ExpandListA(SubstringRev($B5,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"1"},{"$f":"Substring(ExpandListA(SubstringRev($B5,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"2"},{"$f":"Substring(ExpandListA(SubstringRev($B5,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"3"},{"$f":"Substring(ExpandListA(SubstringRev($B5,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"4"},{"$f":"Substring(ExpandListA(SubstringRev($B5,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"5"},{"$f":"Substring(ExpandListA(SubstringRev($B5,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"10"},{"$f":"Substring(ExpandListA(SubstringRev($B5,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"11"},{"$f":"Substring(ExpandListA(SubstringRev($B5,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"12"},{"$f":"Substring(ExpandListA(SubstringRev($B5,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":""},{"$f":"Substring(ExpandListA(SubstringRev($B5,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":""}]
[null,null,null,"Агневское лесничество",{"$f":"Substring(ExpandListA(SubstringRev($B6,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"60"},{"$f":"Substring(ExpandListA(SubstringRev($B6,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"61"},{"$f":"Substring(ExpandListA(SubstringRev($B6,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"62"},{"$f":"Substring(ExpandListA(SubstringRev($B6,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"137"},{"$f":"Substring(ExpandListA(SubstringRev($B6,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"138"},{"$f":"Substring(ExpandListA(SubstringRev($B6,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":"139"},{"$f":"Substring(ExpandListA(SubstringRev($B6,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":""},{"$f":"Substring(ExpandListA(SubstringRev($B6,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":""},{"$f":"Substring(ExpandListA(SubstringRev($B6,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":""},{"$f":"Substring(ExpandListA(SubstringRev($B6,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":""}]
[null,null,null,null,{"$f":"Substring(ExpandListA(SubstringRev($B7,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":""},{"$f":"Substring(ExpandListA(SubstringRev($B7,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":""},{"$f":"Substring(ExpandListA(SubstringRev($B7,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":""},{"$f":"Substring(ExpandListA(SubstringRev($B7,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":""},{"$f":"Substring(ExpandListA(SubstringRev($B7,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":""},{"$f":"Substring(ExpandListA(SubstringRev($B7,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":""},{"$f":"Substring(ExpandListA(SubstringRev($B7,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":""},{"$f":"Substring(ExpandListA(SubstringRev($B7,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":""},{"$f":"Substring(ExpandListA(SubstringRev($B7,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":""},{"$f":"Substring(ExpandListA(SubstringRev($B7,\"№\",1),\",\",\"-\",,,,\",\"),\",\",COLUMN()-4,COLUMN()-4)","v":""}]