{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Рис. 1","Рис. 2","Рис. 3","Рис. 4"],"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":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Abbott",null,null,"Official List"]
["Abbott Laboratories",null,null,"Abbott Laboratories"]
["Abbott Labs",null,null,"Associated Grocers"]
["A/G Kansas",null,null,"General Motors"]
["A/G Nebraska",null,null,"IBM"]
["Associated Grocers / Kansas",null,null,"Wal*Mart"]
["Associated Grocers / Nebraska"]
["General Motors"]
["GM"]
["GM Lordstown"]
["I B M"]
["IBM"]
["International Business Machines"]
["Wal*Mart"]
["WalMart"]
["Wal-Mart"]

{"sheet":"Рис. 2","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Строка 1","Строка 2","FuzzyPercent"]
["Ask MrExcel.com","MrExcel.com Consulting",{"$f":"fuzzyPercent(A2,B2,1)","v":0.73333334922790527}]
["MrExcel.com Consulting","Ask MrExcel.com",{"$f":"fuzzyPercent(A3,B3,1)","v":0.5}]
["I B M","IBM Corporation",0.40000000596046448]
["IBM Corporation","I B M",0.20000000298023224]
["A. Schulman","A Schulman",0.90909093618392944]
["A Schulman","A. Schulman",1]
["Elvis","lives",0.60000002384185791]

{"sheet":"Рис. 3","index":2,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Abbott Laboratories","Associated Grocers","General Motors","IBM","Wal*Mart"]
["Abbott Laboratories",{"$f":"fuzzyPercent($A2,B$1,1)","v":0.89473682641983032},{"$f":"fuzzyPercent($A2,C$1,1)","v":0.3684210479259491},{"$f":"fuzzyPercent($A2,D$1,1)","v":0.31578946113586426},5.2631579339504242E-2,0.21052631735801697]
["Abbott Labs",0.81818181276321411,0.45454546809196472,0.36363637447357178,9.0909093618392944E-2,0.18181818723678589]
["A/G Kansas",0.40000000596046448,0.40000000596046448,0.30000001192092896,0,0.10000000149011612]
["A/G Nebraska",0.3333333432674408,0.4166666567325592,0.4166666567325592,8.3333335816860199E-2,0.1666666716337204]
["Associated Grocers / Kansas",0.18518517911434174,0.62962961196899414,0.18518517911434174,3.7037037312984467E-2,7.4074074625968933E-2]
["Associated Grocers / Nebraska",0.17241379618644714,0.58620691299438477,0.17241379618644714,6.8965516984462738E-2,6.8965516984462738E-2]
["General Motors",0.5,0.3571428656578064,1,7.1428574621677399E-2,0.28571429848670959]
["GM",0,0.5,1,0.5,0.5]
["GM Lordstown",0.4166666567325592,0.3333333432674408,0.4166666567325592,8.3333335816860199E-2,0.25]
["I B M",0.40000000596046448,0.40000000596046448,0.40000000596046448,0.60000002384185791,0.20000000298023224]
["IBM",0.3333333432674408,0.3333333432674408,0.3333333432674408,1,0.3333333432674408]
["International Business Machines",0.16129031777381897,0.19354838132858276,0.19354838132858276,9.6774190664291382E-2,0.12903225421905518]
["Wal*Mart",{"$f":"fuzzyPercent($A14,B$1,1)","v":0.625},0.25,0.5,0.25,{"$f":"fuzzyPercent($A14,F$1,1)","v":0.875}]
["WalMart",0.71428573131561279,0.28571429848670959,0.57142859697341919,0.1428571492433548,{"$f":"fuzzyPercent($A15,F$1,1)","v":1}]
["Wal-Mart",0.625,0.25,0.5,0.125,0.875]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"ваа"]

{"sheet":"Рис. 4","index":3,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"Наилучшее совпадение","Второе","Третье",null,"Официальные названия"]
["Abbott Laboratories",{"$f":"FuzzyVLOOKUP($A2,$F$2:$F$6,1,0.3,COLUMN(A2),1)","v":"Abbott Laboratories"},{"$f":"FuzzyVLOOKUP($A2,$F$2:$F$6,1,0.3,COLUMN(B2),1)","v":"Associated Grocers"},{"$f":"FuzzyVLOOKUP($A2,$F$2:$F$6,1,0.3,COLUMN(C2),1)","v":"General Motors"},null,"Abbott Laboratories"]
["Abbott Labs",{"$f":"FuzzyVLOOKUP($A3,$F$2:$F$6,1,0.3,COLUMN(A3),1)","v":"Abbott Laboratories"},{"$f":"FuzzyVLOOKUP($A3,$F$2:$F$6,1,0.3,COLUMN(B3),1)","v":"Associated Grocers"},{"$f":"FuzzyVLOOKUP($A3,$F$2:$F$6,1,0.3,COLUMN(C3),1)","v":"General Motors"},null,"Associated Grocers"]
["A/G Kansas",{"$f":"FuzzyVLOOKUP($A4,$F$2:$F$6,1,0.3,COLUMN(A4),1)","v":"Abbott Laboratories"},{"$f":"FuzzyVLOOKUP($A4,$F$2:$F$6,1,0.3,COLUMN(B4),1)","v":"Associated Grocers"},{"$f":"FuzzyVLOOKUP($A4,$F$2:$F$6,1,0.3,COLUMN(C4),1)","v":"General Motors"},null,"General Motors"]
["A/G Nebraska",{"$f":"FuzzyVLOOKUP($A5,$F$2:$F$6,1,0.3,COLUMN(A5),1)","v":"Associated Grocers"},{"$f":"FuzzyVLOOKUP($A5,$F$2:$F$6,1,0.3,COLUMN(B5),1)","v":"General Motors"},{"$f":"FuzzyVLOOKUP($A5,$F$2:$F$6,1,0.3,COLUMN(C5),1)","v":"Abbott Laboratories"},null,"IBM"]
["Associated Grocers / Kansas",{"$f":"FuzzyVLOOKUP($A6,$F$2:$F$6,1,0.3,COLUMN(A6),1)","v":"Associated Grocers"},{"$f":"FuzzyVLOOKUP($A6,$F$2:$F$6,1,0.3,COLUMN(B6),1)","v":{"$error":"#N/A"}},{"$f":"FuzzyVLOOKUP($A6,$F$2:$F$6,1,0.3,COLUMN(C6),1)","v":{"$error":"#N/A"}},null,"Wal*Mart"]
["Associated Grocers / Nebraska",{"$f":"FuzzyVLOOKUP($A7,$F$2:$F$6,1,0.3,COLUMN(A7),1)","v":"Associated Grocers"},{"$f":"FuzzyVLOOKUP($A7,$F$2:$F$6,1,0.3,COLUMN(B7),1)","v":{"$error":"#N/A"}},{"$f":"FuzzyVLOOKUP($A7,$F$2:$F$6,1,0.3,COLUMN(C7),1)","v":{"$error":"#N/A"}}]
["General Motors",{"$f":"FuzzyVLOOKUP($A8,$F$2:$F$6,1,0.3,COLUMN(A8),1)","v":"General Motors"},{"$f":"FuzzyVLOOKUP($A8,$F$2:$F$6,1,0.3,COLUMN(B8),1)","v":"Abbott Laboratories"},{"$f":"FuzzyVLOOKUP($A8,$F$2:$F$6,1,0.3,COLUMN(C8),1)","v":"Associated Grocers"}]
["GM",{"$f":"FuzzyVLOOKUP($A9,$F$2:$F$6,1,0.3,COLUMN(A9),1)","v":"General Motors"},{"$f":"FuzzyVLOOKUP($A9,$F$2:$F$6,1,0.3,COLUMN(B9),1)","v":"Associated Grocers"},{"$f":"FuzzyVLOOKUP($A9,$F$2:$F$6,1,0.3,COLUMN(C9),1)","v":"IBM"}]
["GM Lordstown",{"$f":"FuzzyVLOOKUP($A10,$F$2:$F$6,1,0.3,COLUMN(A10),1)","v":"Abbott Laboratories"},{"$f":"FuzzyVLOOKUP($A10,$F$2:$F$6,1,0.3,COLUMN(B10),1)","v":"General Motors"},{"$f":"FuzzyVLOOKUP($A10,$F$2:$F$6,1,0.3,COLUMN(C10),1)","v":"Associated Grocers"}]
["I B M",{"$f":"FuzzyVLOOKUP($A11,$F$2:$F$6,1,0.3,COLUMN(A11),1)","v":"IBM"},{"$f":"FuzzyVLOOKUP($A11,$F$2:$F$6,1,0.3,COLUMN(B11),1)","v":"Abbott Laboratories"},{"$f":"FuzzyVLOOKUP($A11,$F$2:$F$6,1,0.3,COLUMN(C11),1)","v":"Associated Grocers"}]
["IBM",{"$f":"FuzzyVLOOKUP($A12,$F$2:$F$6,1,0.3,COLUMN(A12),1)","v":"IBM"},{"$f":"FuzzyVLOOKUP($A12,$F$2:$F$6,1,0.3,COLUMN(B12),1)","v":"Abbott Laboratories"},{"$f":"FuzzyVLOOKUP($A12,$F$2:$F$6,1,0.3,COLUMN(C12),1)","v":"Associated Grocers"}]
["International Business Machines",{"$f":"FuzzyVLOOKUP($A13,$F$2:$F$6,1,0.3,COLUMN(A13),1)","v":{"$error":"#N/A"}},{"$f":"FuzzyVLOOKUP($A13,$F$2:$F$6,1,0.3,COLUMN(B13),1)","v":{"$error":"#N/A"}},{"$f":"FuzzyVLOOKUP($A13,$F$2:$F$6,1,0.3,COLUMN(C13),1)","v":{"$error":"#N/A"}}]
["Wal*Mart",{"$f":"FuzzyVLOOKUP($A14,$F$2:$F$6,1,0.3,COLUMN(A14),1)","v":"Wal*Mart"},{"$f":"FuzzyVLOOKUP($A14,$F$2:$F$6,1,0.3,COLUMN(B14),1)","v":"Abbott Laboratories"},{"$f":"FuzzyVLOOKUP($A14,$F$2:$F$6,1,0.3,COLUMN(C14),1)","v":"General Motors"}]
["WalMart",{"$f":"FuzzyVLOOKUP($A15,$F$2:$F$6,1,0.3,COLUMN(A15),1)","v":"Wal*Mart"},{"$f":"FuzzyVLOOKUP($A15,$F$2:$F$6,1,0.3,COLUMN(B15),1)","v":"Abbott Laboratories"},{"$f":"FuzzyVLOOKUP($A15,$F$2:$F$6,1,0.3,COLUMN(C15),1)","v":"General Motors"}]
["Wal-Mart",{"$f":"FuzzyVLOOKUP($A16,$F$2:$F$6,1,0.3,COLUMN(A16),1)","v":"Wal*Mart"},{"$f":"FuzzyVLOOKUP($A16,$F$2:$F$6,1,0.3,COLUMN(B16),1)","v":"Abbott Laboratories"},{"$f":"FuzzyVLOOKUP($A16,$F$2:$F$6,1,0.3,COLUMN(C16),1)","v":"General Motors"}]
[]
["Параметры FuzzyVLookup"]
["LookupValue := Entry to be looked up"]
["TableArray := Lookup Range"]
["IndexNum := Zero to return row number, >0 to return specified column (as in VLookup)"]
["NFPercent := If the %age match is less than this, return #N/A"]
["Rank := Return the 'n'th highest match. Default 1"]
["Algorithm := Must be 1, 2 or 3. 1 = 'Forward scan only', '2' = Match on pairs then triplets then quads etc, '3' = match on both"]
["источник"]