{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Данные","Предлоги"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":14,"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":"Данные","index":0,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,2,0,4],[0,6,0,8]]}
[null,null,"Так Было (неправильный перенос)",null,null,null,"Так Сейчас (правильный перенос)"]
[20,null,"1 Часть Текста\n(здесь старая формула)","Оставшаяся часть Текста","Осталось символов в ст. \"C\"",null,"1 Часть Текста\n (здесь исправленная формула)","Оставшаяся часть Текста","Осталось символов в ст. \"G\""]
["когда надо делать то на мотоцикл",null,{"$f":"IF(IFERROR(VLOOKUP(SUBSTITUTE(MID(RIGHT(\" \"&SUBSTITUTE(TRIM(MID(TRIM(IFERROR(LEFT(A3,FIND(\"/\",SUBSTITUTE(MID(A3,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A3,1,A$2+1),\" \",\"\"))))),LEFT(A3,A$2+1))),1,120)),\" \",REPT(\" \",999)),999*1),1,999),\" \",\"\"),Предлоги!A$1:A$150,1,0),\"\")<>\"\",insTxt(MID(TRIM(IFERROR(LEFT(A3,FIND(\"/\",SUBSTITUTE(MID(A3,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A3,1,A$2+1),\" \",\"\"))))),LEFT(A3,A$2+1))),1,120)),MID(TRIM(IFERROR(LEFT(A3,FIND(\"/\",SUBSTITUTE(MID(A3,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A3,1,A$2+1),\" \",\"\"))))),LEFT(A3,A$2+1))),1,120))","v":"когда надо делать то"},{"$f":"TRIM(RIGHT(TRIM(A3),LEN(TRIM(A3))-LEN(C3)))","v":"на мотоцикл"},{"$f":"$A$2-LEN(C3)","v":0},null,{"$f":"IF(IFERROR(LOOKUP(2,1/EXACT(Предлоги!A$1:A$1500,SUBSTITUTE(MID(RIGHT(\" \"&SUBSTITUTE(TRIM(TRIM(IFERROR(LEFT(A3,FIND(\"/\",SUBSTITUTE(MID(A3,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A3,1,A$2+1),\" \",\"\"))))),LEFT(A3,A$2+1)))),\" \",REPT(\" \",999)),999*1),1,999),\" \",\"\")),Предлоги!A$1:A$1500),\"\")<>\"\",insTxt(TRIM(IFERROR(LEFT(A3,FIND(\"/\",SUBSTITUTE(MID(A3,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A3,1,A$2+1),\" \",\"\"))))),LEFT(A3,A$2+1)))),TRIM(IFERROR(LEFT(A3,FIND(\"/\",SUBSTITUTE(MID(A3,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A3,1,A$2+1),\" \",\"\"))))),LEFT(A3,A$2+1))))","v":"когда надо делать"},{"$f":"TRIM(RIGHT(TRIM(A3),LEN(TRIM(A3))-LEN(G3)))","v":"то на мотоцикл"},{"$f":"$A$2-LEN(G3)","v":3}]
["когда надо делать ТО на мотоцикл",null,{"$f":"IF(IFERROR(VLOOKUP(SUBSTITUTE(MID(RIGHT(\" \"&SUBSTITUTE(TRIM(MID(TRIM(IFERROR(LEFT(A4,FIND(\"/\",SUBSTITUTE(MID(A4,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A4,1,A$2+1),\" \",\"\"))))),LEFT(A4,A$2+1))),1,120)),\" \",REPT(\" \",999)),999*1),1,999),\" \",\"\"),Предлоги!A$1:A$150,1,0),\"\")<>\"\",insTxt(MID(TRIM(IFERROR(LEFT(A4,FIND(\"/\",SUBSTITUTE(MID(A4,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A4,1,A$2+1),\" \",\"\"))))),LEFT(A4,A$2+1))),1,120)),MID(TRIM(IFERROR(LEFT(A4,FIND(\"/\",SUBSTITUTE(MID(A4,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A4,1,A$2+1),\" \",\"\"))))),LEFT(A4,A$2+1))),1,120))","v":"когда надо делать ТО"},{"$f":"TRIM(RIGHT(TRIM(A4),LEN(TRIM(A4))-LEN(C4)))","v":"на мотоцикл"},0,null,{"$f":"IF(IFERROR(LOOKUP(2,1/EXACT(Предлоги!A$1:A$1500,SUBSTITUTE(MID(RIGHT(\" \"&SUBSTITUTE(TRIM(TRIM(IFERROR(LEFT(A4,FIND(\"/\",SUBSTITUTE(MID(A4,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A4,1,A$2+1),\" \",\"\"))))),LEFT(A4,A$2+1)))),\" \",REPT(\" \",999)),999*1),1,999),\" \",\"\")),Предлоги!A$1:A$1500),\"\")<>\"\",insTxt(TRIM(IFERROR(LEFT(A4,FIND(\"/\",SUBSTITUTE(MID(A4,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A4,1,A$2+1),\" \",\"\"))))),LEFT(A4,A$2+1)))),TRIM(IFERROR(LEFT(A4,FIND(\"/\",SUBSTITUTE(MID(A4,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A4,1,A$2+1),\" \",\"\"))))),LEFT(A4,A$2+1))))","v":"когда надо делать ТО"},{"$f":"TRIM(RIGHT(TRIM(A4),LEN(TRIM(A4))-LEN(G4)))","v":"на мотоцикл"},0]
["установка нового по компам",null,{"$f":"IF(IFERROR(VLOOKUP(SUBSTITUTE(MID(RIGHT(\" \"&SUBSTITUTE(TRIM(MID(TRIM(IFERROR(LEFT(A5,FIND(\"/\",SUBSTITUTE(MID(A5,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A5,1,A$2+1),\" \",\"\"))))),LEFT(A5,A$2+1))),1,120)),\" \",REPT(\" \",999)),999*1),1,999),\" \",\"\"),Предлоги!A$1:A$150,1,0),\"\")<>\"\",insTxt(MID(TRIM(IFERROR(LEFT(A5,FIND(\"/\",SUBSTITUTE(MID(A5,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A5,1,A$2+1),\" \",\"\"))))),LEFT(A5,A$2+1))),1,120)),MID(TRIM(IFERROR(LEFT(A5,FIND(\"/\",SUBSTITUTE(MID(A5,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A5,1,A$2+1),\" \",\"\"))))),LEFT(A5,A$2+1))),1,120))","v":"установка нового"},"по компам",4,null,{"$f":"IF(IFERROR(LOOKUP(2,1/EXACT(Предлоги!A$1:A$1500,SUBSTITUTE(MID(RIGHT(\" \"&SUBSTITUTE(TRIM(TRIM(IFERROR(LEFT(A5,FIND(\"/\",SUBSTITUTE(MID(A5,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A5,1,A$2+1),\" \",\"\"))))),LEFT(A5,A$2+1)))),\" \",REPT(\" \",999)),999*1),1,999),\" \",\"\")),Предлоги!A$1:A$1500),\"\")<>\"\",insTxt(TRIM(IFERROR(LEFT(A5,FIND(\"/\",SUBSTITUTE(MID(A5,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A5,1,A$2+1),\" \",\"\"))))),LEFT(A5,A$2+1)))),TRIM(IFERROR(LEFT(A5,FIND(\"/\",SUBSTITUTE(MID(A5,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A5,1,A$2+1),\" \",\"\"))))),LEFT(A5,A$2+1))))","v":"установка нового"},"по компам",4]
["установка нового ПО компа",null,{"$f":"IF(IFERROR(VLOOKUP(SUBSTITUTE(MID(RIGHT(\" \"&SUBSTITUTE(TRIM(MID(TRIM(IFERROR(LEFT(A6,FIND(\"/\",SUBSTITUTE(MID(A6,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A6,1,A$2+1),\" \",\"\"))))),LEFT(A6,A$2+1))),1,120)),\" \",REPT(\" \",999)),999*1),1,999),\" \",\"\"),Предлоги!A$1:A$150,1,0),\"\")<>\"\",insTxt(MID(TRIM(IFERROR(LEFT(A6,FIND(\"/\",SUBSTITUTE(MID(A6,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A6,1,A$2+1),\" \",\"\"))))),LEFT(A6,A$2+1))),1,120)),MID(TRIM(IFERROR(LEFT(A6,FIND(\"/\",SUBSTITUTE(MID(A6,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A6,1,A$2+1),\" \",\"\"))))),LEFT(A6,A$2+1))),1,120))","v":"установка нового"},"ПО компа",4,null,{"$f":"IF(IFERROR(LOOKUP(2,1/EXACT(Предлоги!A$1:A$1500,SUBSTITUTE(MID(RIGHT(\" \"&SUBSTITUTE(TRIM(TRIM(IFERROR(LEFT(A6,FIND(\"/\",SUBSTITUTE(MID(A6,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A6,1,A$2+1),\" \",\"\"))))),LEFT(A6,A$2+1)))),\" \",REPT(\" \",999)),999*1),1,999),\" \",\"\")),Предлоги!A$1:A$1500),\"\")<>\"\",insTxt(TRIM(IFERROR(LEFT(A6,FIND(\"/\",SUBSTITUTE(MID(A6,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A6,1,A$2+1),\" \",\"\"))))),LEFT(A6,A$2+1)))),TRIM(IFERROR(LEFT(A6,FIND(\"/\",SUBSTITUTE(MID(A6,1,A$2+1),\" \",\"/\",A$2+1-LEN(SUBSTITUTE(MID(A6,1,A$2+1),\" \",\"\"))))),LEFT(A6,A$2+1))))","v":"установка нового ПО"},"компа",1]

{"sheet":"Предлоги","index":1,"n_rows":372,"n_cols":1,"rows_kept":372,"cut":false,"hidden":false,"merged":[]}
["без"]
["благодаря"]
["близ"]
["будто"]
["ввиду"]
["вдоль"]
["вместо"]
["возле"]
["вокруг"]
["вопреки"]
["вследствие"]
["дабы"]
["едва"]
["ежели"]
["зато"]
["ибо"]
["из-под"]
["коли"]
["коль"]
["кроме"]
["либо"]
["лишь"]
["между"]
["над"]
["накануне"]
["однако"]
["около"]
["оттого"]
["перед"]
["под"]
["пока"]
["поперек"]
["после"]
["потому"]
["про"]
["против"]
["пусть"]
["ради"]
["словно"]
["со"]
["согласно"]
["среди"]
["точно"]
["хоть"]
["хотя"]
["через"]
["а"]
["бы"]
["в"]
["во"]
["да"]
["для"]
["до"]
["если"]
["же"]
["за"]
["и"]
["из"]
["из-за"]
["или"]
["к"]
["как"]
["кем"]
["когда"]
["кого"]
["кому"]
["кто"]
["на"]
["но"]
["о"]
["от"]
["по"]
["при"]
["с"]
["так"]
["тем"]
["того"]
["только"]
["у"]
["чего"]
["чем"]
["чему"]
["что"]
["чтобы"]
["a"]
["about"]
["all"]
["am"]
["an"]
["and"]
["any"]
["are"]
["as"]
["at"]
["be"]
["been"]
["but"]
["by"]
["can"]
["could"]
["do"]
["for"]
["from"]
["has"]
["have"]
["i"]
["if"]
["in"]
["is"]
["it"]
["me"]
["my"]
["no"]
["not"]
["of"]
["on"]
["one"]
["or"]
["so"]
["that"]
["the"]
["them"]
["there"]
["they"]
["this"]
["to"]
["was"]
["we"]
["what"]
["which"]
["will"]
["with"]
["would"]
["you"]
["будем"]
["будет"]
["будете"]
["будешь"]
["буду"]
["будут"]
["будучи"]
["будь"]
["будьте"]
["был"]
["была"]
["были"]
["было"]
["быть"]
["вам"]
["вами"]
["вас"]
["весь"]
["вот"]
["все"]
["всё"]
["всего"]
["всей"]
["всем"]
["всём"]
["всеми"]
["всему"]
["всех"]
["всею"]
["всея"]
["всю"]
["вся"]
["вы"]
["его"]
["едим"]
["едят"]
["ее"]
["её"]
["ей"]
["ел"]
["ела"]
["ем"]
["ему"]
["емъ"]
["ест"]
["есть"]
["ешь"]
["еще"]
["ещё"]
["ею"]
["им"]
["ими"]
["имъ"]
["их"]
["ко"]
["ком"]
["комья"]
["которая"]
["которого"]
["которое"]
["которой"]
["котором"]
["которому"]
["которою"]
["которую"]
["которые"]
["который"]
["которым"]
["которыми"]
["которых"]
["меня"]
["мне"]
["мной"]
["мною"]
["мог"]
["моги"]
["могите"]
["могла"]
["могли"]
["могло"]
["могу"]
["могут"]
["мое"]
["моё"]
["моего"]
["моей"]
["моем"]
["моём"]
["моему"]
["моею"]
["можем"]
["может"]
["можете"]
["можешь"]
["мои"]
["мой"]
["моим"]
["моими"]
["моих"]
["мочь"]
["мою"]
["моя"]
["мы"]
["нам"]
["нами"]
["нас"]
["наса"]
["наш"]
["наша"]
["наше"]
["нашего"]
["нашей"]
["нашем"]
["нашему"]
["нашею"]
["наши"]
["нашим"]
["нашими"]
["наших"]
["нашу"]
["не"]
["него"]
["нее"]
["неё"]
["ней"]
["нем"]
["нём"]
["нему"]
["нет"]
["нею"]
["ним"]
["ними"]
["них"]
["об"]
["один"]
["одна"]
["одни"]
["одним"]
["одними"]
["одних"]
["одно"]
["одного"]
["одной"]
["одном"]
["одному"]
["одною"]
["одну"]
["он"]
["она"]
["оне"]
["они"]
["оно"]
["сам"]
["сама"]
["сами"]
["самим"]
["самими"]
["самих"]
["само"]
["самого"]
["самом"]
["самому"]
["саму"]
["свое"]
["своё"]
["своего"]
["своей"]
["своем"]
["своём"]
["своему"]
["своею"]
["свои"]
["свой"]
["своим"]
["своими"]
["своих"]
["свою"]
["своя"]
["себе"]
["себя"]
["собой"]
["собою"]
["та"]
["такая"]
["такие"]
["таким"]
["такими"]
["таких"]
["такого"]
["такое"]
["такой"]
["таком"]
["такому"]
["такою"]
["такую"]
["те"]
["тебе"]
["тебя"]
["теми"]
["тех"]
["то"]
["тобой"]
["тобою"]
["той"]
["том"]
["томах"]
["тому"]
["тот"]
["тою"]
["ту"]
["ты"]
["уже"]
["чём"]
["эта"]
["эти"]
["этим"]
["этими"]
["этих"]
["это"]
["этого"]
["этой"]
["этом"]
["этому"]
["этот"]
["этою"]
["эту"]
["я"]
["мені"]
["наші"]
["нашої"]
["нашій"]
["нашою"]
["нашім"]
["ті"]
["тієї"]
["тією"]
["тії"]
["теє"]