{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Элементарно","Посложнее","Все возможности","Словарь","Частота"],"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":"Элементарно","index":0,"n_rows":6,"n_cols":20,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,13,0,17],[0,5,0,9]]}
["Имеем","Сопоставляем","Должно быть","Словарь",null,"Поиск макросом наиболее схожих значений",null,null,null,null,null,"Цифрры в строке поиска",null,"Цифры в найденных вариантах",null,null,null,null,null,"Результат"]
["Москва ул Вавилова 7 ",{"$f":"FS_GetClosestWord(A2,$D$2:$D$8)","v":"Москва ул Вавилова 27"},"Москва ул Вавилова 9","Москва ул Вавилова 27",null,{"$f":"FS_GetClosestWord($A2,$D$2:$D$8,COLUMN(A1),,1)","v":"Москва ул Вавилова 27"},{"$f":"FS_GetClosestWord($A2,$D$2:$D$8,COLUMN(B1),,1)","v":"Москва ул Вавилова 9"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"MAX(IFERROR(--MID(A2,ROW($1:$999),ROW($1:$999)),0))","v":7},null,{"$f":"MAX(IFERROR(--MID(F2,ROW($1:$999),ROW($1:$999)),0))","v":27},{"$f":"MAX(IFERROR(--MID(G2,ROW($1:$999),ROW($1:$999)),0))","v":9},{"$f":"MAX(IFERROR(--MID(H2,ROW($1:$999),ROW($1:$999)),0))","v":0},{"$f":"MAX(IFERROR(--MID(I2,ROW($1:$999),ROW($1:$999)),0))","v":0},{"$f":"MAX(IFERROR(--MID(J2,ROW($1:$999),ROW($1:$999)),0))","v":0},null,{"$f":"INDEX(F2:J2,1,MIN(IF((MIN(ABS(N2:R2-L2))=ABS(N2:R2-L2)),COLUMN(A3:E3),999)))","v":"Москва ул Вавилова 9"}]
["Пятерочка Астраханская Астрахань ул Звездная д 57",{"$f":"FS_GetClosestWord(A3,$D$2:$D$8)","v":"Пятерочка Астраханская Астрахань ул Звездная д 5"},"Пятерочка Астраханская Астрахань ул Звездная д 53","ул Вавилова 7",null,{"$f":"FS_GetClosestWord($A3,$D$2:$D$8,COLUMN(A2),,1)","v":"Пятерочка Астраханская Астрахань ул Звездная д 5"},{"$f":"FS_GetClosestWord($A3,$D$2:$D$8,COLUMN(B2),,1)","v":"Пятерочка Астраханская Астрахань ул Звездная д 53"},{"$f":"FS_GetClosestWord($A3,$D$2:$D$8,COLUMN(C2),,1)","v":{"$error":"#N/A"}},{"$f":"FS_GetClosestWord($A3,$D$2:$D$8,COLUMN(D2),,1)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"MAX(IFERROR(--MID(A3,ROW($1:$999),ROW($1:$999)),0))","v":57},null,{"$f":"MAX(IFERROR(--MID(F3,ROW($1:$999),ROW($1:$999)),0))","v":5},{"$f":"MAX(IFERROR(--MID(G3,ROW($1:$999),ROW($1:$999)),0))","v":53},{"$f":"MAX(IFERROR(--MID(H3,ROW($1:$999),ROW($1:$999)),0))","v":0},{"$f":"MAX(IFERROR(--MID(I3,ROW($1:$999),ROW($1:$999)),0))","v":0},{"$f":"MAX(IFERROR(--MID(J3,ROW($1:$999),ROW($1:$999)),0))","v":0},null,{"$f":"INDEX(F3:J3,1,MIN(IF((MIN(ABS(N3:R3-L3))=ABS(N3:R3-L3)),COLUMN(A4:E4),999)))","v":"Пятерочка Астраханская Астрахань ул Звездная д 53"}]
[null,null,null,"Москва ул Вавилова 9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(F4:J4,1,MIN(IF((MIN(ABS(N4:R4-L4))=ABS(N4:R4-L4)),COLUMN(A5:E5),999)))","v":0}]
[null,null,null,"Пятерочка Астраханская Астрахань ул Звездная д 53"]
[null,null,null,"Пятерочка Астраханская Астрахань ул Звездная д 5"]

{"sheet":"Посложнее","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Ищем","Вариант 1","Вариант 2","Вариант 3"]
["Пятерочка Астраханская Астрахань ул Звездная д 57",{"$f":"IFERROR(FS_GetClosestWord($A2,TestSmart[],COLUMN()-1,3,1),\"\")","v":"Пятерочка Астраханская Астрахань ул Звездная д 5"},{"$f":"IFERROR(FS_GetClosestWord($A2,TestSmart[],COLUMN()-1,3,1),\"\")","v":"Пятерочка Астраханская Астрахань ул Звездная д 53"},{"$f":"IFERROR(FS_GetClosestWord($A2,TestSmart[],COLUMN()-1,3,1),\"\")","v":""}]
["Москва ул.Вавилова 7 Пятерочка",{"$f":"IFERROR(FS_GetClosestWord($A3,TestSmart[],COLUMN()-1,3,1),\"\")","v":"Москва ул.Вавилова 7 Дикси"},{"$f":"IFERROR(FS_GetClosestWord($A3,TestSmart[],COLUMN()-1,3,1),\"\")","v":""},{"$f":"IFERROR(FS_GetClosestWord($A3,TestSmart[],COLUMN()-1,3,1),\"\")","v":""}]
[null,{"$f":"IFERROR(FS_GetClosestWord($A4,TestSmart[],COLUMN()-1,3,1),\"\")","v":""},{"$f":"IFERROR(FS_GetClosestWord($A4,TestSmart[],COLUMN()-1,3,1),\"\")","v":""},{"$f":"IFERROR(FS_GetClosestWord($A4,TestSmart[],COLUMN()-1,3,1),\"\")","v":""}]
[null,{"$f":"IFERROR(FS_GetClosestWord($A5,TestSmart[],COLUMN()-1,3,1),\"\")","v":""},{"$f":"IFERROR(FS_GetClosestWord($A5,TestSmart[],COLUMN()-1,3,1),\"\")","v":""},{"$f":"IFERROR(FS_GetClosestWord($A5,TestSmart[],COLUMN()-1,3,1),\"\")","v":""}]
[null,{"$f":"IFERROR(FS_GetClosestWord($A6,TestSmart[],COLUMN()-1,3,1),\"\")","v":""},{"$f":"IFERROR(FS_GetClosestWord($A6,TestSmart[],COLUMN()-1,3,1),\"\")","v":""},{"$f":"IFERROR(FS_GetClosestWord($A6,TestSmart[],COLUMN()-1,3,1),\"\")","v":""}]
[null,{"$f":"IFERROR(FS_GetClosestWord($A7,TestSmart[],COLUMN()-1,3,1),\"\")","v":""},{"$f":"IFERROR(FS_GetClosestWord($A7,TestSmart[],COLUMN()-1,3,1),\"\")","v":""},{"$f":"IFERROR(FS_GetClosestWord($A7,TestSmart[],COLUMN()-1,3,1),\"\")","v":""}]

{"sheet":"Все возможности","index":2,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Ищем","№ варианта","Слово","Комбинация","Слепок","Критерий"]
["деньги","Вариант 1",{"$f":"IFERROR(FS_GetClosestWord($A$2,TestSmart[],ROW()-1,3,1,COLUMN()-2),\"\")","v":""},{"$f":"IFERROR(FS_GetClosestWord($A$2,TestSmart[],ROW()-1,3,1,COLUMN()-2),\"\")","v":""},{"$f":"IFERROR(FS_GetClosestWord($A$2,TestSmart[],ROW()-1,3,1,COLUMN()-2),\"\")","v":""},{"$f":"IFERROR(FS_GetClosestWord($A$2,TestSmart[],ROW()-1,3,1,COLUMN()-2),\"\")","v":""}]
[null,"Вариант 2",{"$f":"IFERROR(FS_GetClosestWord($A$2,TestSmart[],ROW()-1,3,1,COLUMN()-2),\"\")","v":""},{"$f":"IFERROR(FS_GetClosestWord($A$2,TestSmart[],ROW()-1,3,1,COLUMN()-2),\"\")","v":""},{"$f":"IFERROR(FS_GetClosestWord($A$2,TestSmart[],ROW()-1,3,1,COLUMN()-2),\"\")","v":""},{"$f":"IFERROR(FS_GetClosestWord($A$2,TestSmart[],ROW()-1,3,1,COLUMN()-2),\"\")","v":""}]
[null,"Вариант 3",{"$f":"IFERROR(FS_GetClosestWord($A$2,TestSmart[],ROW()-1,3,1,COLUMN()-2),\"\")","v":""},{"$f":"IFERROR(FS_GetClosestWord($A$2,TestSmart[],ROW()-1,3,1,COLUMN()-2),\"\")","v":""},{"$f":"IFERROR(FS_GetClosestWord($A$2,TestSmart[],ROW()-1,3,1,COLUMN()-2),\"\")","v":""},{"$f":"IFERROR(FS_GetClosestWord($A$2,TestSmart[],ROW()-1,3,1,COLUMN()-2),\"\")","v":""}]

{"sheet":"Словарь","index":3,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Словарь"]
["Москва ул.Вавилова 27 Пятерочка"]
["Москва ул.Вавилова 9 Пятерочка"]
["Москва ул.Вавилова 7 Дикси"]
["Пятерочка Астраханская Астрахань ул Звездная д 53"]
["Пятерочка Астраханская Астрахань ул Звездная д 5"]

{"sheet":"Частота","index":4,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["Разряд","Русские символы","Коды","Английские символы","Коды","Цифры","Коды","Число",null,null,null,"Коды","Разряд"]
[0,"О",{"$f":"CODE(B2)","v":206},"E ",{"$f":"CODE(D2)","v":69},null,null,{"$f":"2^A2","v":1},null,null,null,48,16,{"$f":"\"CastRef(\"&L2&\")=\"&M2","v":"CastRef(48)=16"}]
[1,"А",192,"T ",{"$f":"CODE(D3)","v":84},null,null,2,null,null,null,49,32,{"$f":"\"CastRef(\"&L3&\")=\"&M3","v":"CastRef(49)=32"}]
[2,"Е",197,"A ",65,null,null,4,null,null,null,50,64,"CastRef(50)=64"]
[3,"И",200,"O ",79,null,null,8,null,null,null,51,128,"CastRef(51)=128"]
[4,"Н",205,"I ",73,0,{"$f":"CODE(F6)","v":48},16,null,null,null,52,256,"CastRef(52)=256"]
[5,"Т",210,"N ",78,1,{"$f":"CODE(F7)","v":49},{"$f":"2^A7","v":32},null,null,null,53,512,"CastRef(53)=512"]
[6,"Р",208,"S ",83,2,50,64,null,null,null,54,1024,"CastRef(54)=1024"]
[7,"С",209,"H ",72,3,51,128,null,null,null,55,2048,"CastRef(55)=2048"]
[8,"Л",203,"R ",82,4,52,256,null,null,null,56,4096,"CastRef(56)=4096"]
[9,"В",194,"D ",68,5,53,512,null,null,null,57,8192,"CastRef(57)=8192"]
[10,"К",202,"L ",76,6,54,1024,null,null,null,65,4,"CastRef(65)=4"]
[11,"П",207,"C ",67,7,55,2048,null,null,null,66,524288,"CastRef(66)=524288"]
[12,"М",204,"U ",85,8,56,4096,null,null,null,67,2048,"CastRef(67)=2048"]
[13,"У",211,"M ",77,9,57,8192,null,null,null,68,512,"CastRef(68)=512"]
[14,"Д",196,"W ",87,null,null,16384,null,null,null,69,1,"CastRef(69)=1"]
[15,"Я",223,"F ",70,null,null,32768,null,null,null,70,32768,"CastRef(70)=32768"]
[16,"Ы",219,"G ",71,null,null,65536,null,null,null,71,65536,"CastRef(71)=65536"]
[17,"Ь",220,"Y ",89,null,null,131072,null,null,null,72,128,"CastRef(72)=128"]
[18,"З",199,"P ",80,null,null,262144,null,null,null,73,16,"CastRef(73)=16"]
[19,"Б",193,"B ",66,null,null,524288,null,null,null,74,8388608,"CastRef(74)=8388608"]
[20,"Г",195,"V ",86,null,null,1048576,null,null,null,75,2097152,"CastRef(75)=2097152"]
[21,"Й",201,"K ",75,null,null,2097152,null,null,null,76,1024,"CastRef(76)=1024"]
[22,"Ч",215,"X ",88,null,null,4194304,null,null,null,77,8192,"CastRef(77)=8192"]
[23,"Ю",222,"J ",74,null,null,8388608,null,null,null,78,32,"CastRef(78)=32"]
[24,"Х",213,"Z ",90,null,null,16777216,null,null,null,79,8,"CastRef(79)=8"]
[25,"Ж",198,"Q",81,null,null,33554432,null,null,null,80,262144,"CastRef(80)=262144"]
[26,"Ш",216,"Ё",168,null,null,67108864,null,null,null,81,33554432,"CastRef(81)=33554432"]
[27,"Ц",214,null,null,null,null,134217728,null,null,null,82,256,"CastRef(82)=256"]
[28,"Щ",217,null,null,null,null,268435456,null,null,null,83,64,"CastRef(83)=64"]
[29,"Ф",212,null,null,null,null,536870912,null,null,null,84,2,"CastRef(84)=2"]
[30,"Э",221,"Ъ",{"$f":"CODE(D32)","v":218},null,null,1073741824,null,null,null,85,4096,"CastRef(85)=4096"]
[null,null,null,null,null,null,null,null,null,null,null,86,1048576,"CastRef(86)=1048576"]
[null,null,null,null,null,null,null,null,null,null,null,87,16384,"CastRef(87)=16384"]
[null,null,null,null,null,null,null,null,null,null,null,88,4194304,"CastRef(88)=4194304"]
[null,null,null,null,null,null,null,null,null,null,null,89,131072,"CastRef(89)=131072"]
[null,null,null,null,null,null,null,null,null,null,null,90,16777216,"CastRef(90)=16777216"]
[null,null,null,null,null,null,null,null,null,null,null,168,67108864,"CastRef(168)=67108864"]
[null,null,null,null,null,null,null,null,null,null,null,192,2,"CastRef(192)=2"]
[null,null,null,null,null,null,null,null,null,null,null,193,524288,"CastRef(193)=524288"]
[null,null,null,null,null,null,null,null,null,null,null,194,512,"CastRef(194)=512"]
[null,null,null,null,null,null,null,null,null,null,null,195,1048576,"CastRef(195)=1048576"]
[null,null,null,null,null,null,null,null,null,null,null,196,16384,"CastRef(196)=16384"]
[null,null,null,null,null,null,null,null,null,null,null,197,4,"CastRef(197)=4"]
[null,null,null,null,null,null,null,null,null,null,null,198,33554432,"CastRef(198)=33554432"]
[null,null,null,null,null,null,null,null,null,null,null,199,262144,"CastRef(199)=262144"]
[null,null,null,null,null,null,null,null,null,null,null,200,8,"CastRef(200)=8"]
[null,null,null,null,null,null,null,null,null,null,null,201,2097152,"CastRef(201)=2097152"]
[null,null,null,null,null,null,null,null,null,null,null,202,1024,"CastRef(202)=1024"]
[null,null,null,null,null,null,null,null,null,null,null,203,256,"CastRef(203)=256"]
[null,null,null,null,null,null,null,null,null,null,null,204,4096,"CastRef(204)=4096"]
[null,null,null,null,null,null,null,null,null,null,null,205,16,"CastRef(205)=16"]
[null,null,null,null,null,null,null,null,null,null,null,206,1,"CastRef(206)=1"]
[null,null,null,null,null,null,null,null,null,null,null,207,2048,"CastRef(207)=2048"]
[null,null,null,null,null,null,null,null,null,null,null,208,64,"CastRef(208)=64"]
[null,null,null,null,null,null,null,null,null,null,null,209,128,"CastRef(209)=128"]
[null,null,null,null,null,null,null,null,null,null,null,210,32,"CastRef(210)=32"]
[null,null,null,null,null,null,null,null,null,null,null,211,8192,"CastRef(211)=8192"]
[null,null,null,null,null,null,null,null,null,null,null,212,536870912,"CastRef(212)=536870912"]
[null,null,null,null,null,null,null,null,null,null,null,213,16777216,"CastRef(213)=16777216"]
[null,null,null,null,null,null,null,null,null,null,null,214,134217728,"CastRef(214)=134217728"]
[null,null,null,null,null,null,null,null,null,null,null,215,4194304,"CastRef(215)=4194304"]
[null,null,null,null,null,null,null,null,null,null,null,216,67108864,"CastRef(216)=67108864"]
[null,null,null,null,null,null,null,null,null,null,null,217,268435456,"CastRef(217)=268435456"]
[null,null,null,null,null,null,null,null,null,null,null,218,1073741824,"CastRef(218)=1073741824"]
[null,null,null,null,null,null,null,null,null,null,null,219,65536,"CastRef(219)=65536"]
[null,null,null,null,null,null,null,null,null,null,null,220,131072,{"$f":"\"CastRef(\"&L67&\")=\"&M67","v":"CastRef(220)=131072"}]
[null,null,null,null,null,null,null,null,null,null,null,221,1073741824,{"$f":"\"CastRef(\"&L68&\")=\"&M68","v":"CastRef(221)=1073741824"}]
[null,null,null,null,null,null,null,null,null,null,null,222,8388608,{"$f":"\"CastRef(\"&L69&\")=\"&M69","v":"CastRef(222)=8388608"}]
[null,null,null,null,null,null,null,null,null,null,null,223,32768,{"$f":"\"CastRef(\"&L70&\")=\"&M70","v":"CastRef(223)=32768"}]