Kapalı

Levenshtein Distance / Trigram Formula Excel VBA Tool

I need to be able to run the levenshtein distance algorithm (or trigram formula if that's better) comparing two sets of data from within a single excel. I believe this is doable via VBA and have included a link to a site that provides the VBA code.

[url removed, login to view]

The inputs would each consist of a few data fields (columns) and potentially hundreds or thousands of values (rows). The fields being compared are names and dates with potentially differing formats. For example, data set 1 might show Michael Jason Fox, 2/6/2017, Smith, 6/22/1988, while data set 2 might show Mike J Fox, 02/06/17, SMITH B, 6/22/88. I'm thinking the most efficient way to prep the data sets to be run through the formula would be to format the values and concatenate them. I think we need to concatenate them because the records from each set that might be very similar or identical likely won't be in the same row.

I have a limited understanding of the programming behind this. I need to be able to compare 2 sets of data with similar fields and identify when a value from set A is missing from set B. There might be values in set B with similar values, i.e. a name match but the date is one or 2 or 5 days off. I need to be able to identify when the value is set B is identical or similar for the names and for the second date in the string, but differs slightly for the first date in the string vs. there is no record in set B that is similar to set A because there's no similar name match at all vs. theres a similar name match but the second date match isnt similar at all.

Beceriler: Veri İşleme, Excel, VB.NET, Visual Basic, Uygulamalar için Visual Basic

Daha fazlasını gör: how munch of a promoters bond do i need to run shows in vermont, rolling return formula excel vba function, rolling formula excel vba, excel vba calculate time distance, distance calculator formula excel, excel vba quote tool, excel mileage distance formula, excel vba formula, distance formula excel, distance calculator excel formula, chart tool excel vba, vba write formula excel vba, betting formula excel vba, function erlang traffic formula excel vba, excel vba codes tool bar, excel vba paste formula macro, excel vba tool reference, rank excel vba formula

İşveren Hakkında:
( 0 değerlendirme ) United States

Proje NO: #15776850

Bu iş için 21 freelancer ortalamada $360 teklif veriyor

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(42 Değerlendirme)
8.1
in %bids___i_period_sub_35% gün içinde350%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(262 Değerlendirme)
7.7
schoudhary1553

Greeting, I have understood your Trigram Formula Excel VBA Tool task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 years of experien Daha Fazla

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(230 Değerlendirme)
7.3
aarifakhtar

Hi: Based on the review of project specification, I understand that you are looking to achieve fuzzy match between two data sets. Each data set contains two fields: Name and DOB. Relevant Skills and Experience Leve Daha Fazla

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(158 Değerlendirme)
6.9
kolosibalint

Hi, I think using Levenstein dist can be a useful method in this but not after concatenating with dates. I would rather generate a new method that classifies pairs based on the level of similarities Relevant Skills a Daha Fazla

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(90 Değerlendirme)
6.2
avinav606lx

Hi there, I am expert in Excel VBA with over 5+ years of experience. Ping me to discuss more about the project. Thanks Aman

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(154 Değerlendirme)
6.5
abhinovpankaj

I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Relevant Skills and Experience -- VBA and Excel,Word,Office Applications -- Expert on C# Daha Fazla

in %bids___i_period_sub_35% gün içinde333%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(57 Değerlendirme)
5.7
Grunty

I like working on this kind of fuzzy matching algorithms. However as universal a tool as Levenshtein is, I'd rather try and take advantage of knowing the actual data types to design a specific method. Relevant Skills Daha Fazla

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(35 Değerlendirme)
5.5
The24CarrotsInc

Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc Relevant Skills an Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(57 Değerlendirme)
5.4
bassamhameed

hi sir how r u sir i am expert in expert in excel kindly pm me further details will love to work for you thanks a lot waiting positively Relevant Skills and Experience excel programming Proposed Milestones $250 USD - Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(15 Değerlendirme)
4.9
dvcontact

Hi, Reading your project description about comparing two sets of data from within a sheet with VBA makes me feel like you have me in mind when creating the project. I have all it takes to deliver. Relevant Skills and Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(16 Değerlendirme)
4.6
mikhailkozalski

hello if you hire me, i will finished your project perfectly. Relevant Skills and Experience Data Processing, Excel, VB.NET, Visual Basic, Visual Basic for Apps Proposed Milestones $144 USD - fee $300 USD - 1

in %bids___i_period_sub_35% gün içinde444%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)
3.6
JackieXu

. Relevant Skills and Experience Microsoft excel, excel VBA, web scrape, data analyst, graphic design and so on Proposed Milestones $250 USD - .

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(16 Değerlendirme)
4.2
DataDKR

Is it possible to provide the data to me directly and let me adapt whatever algorithms prove useful for matching your data? That would be the approach I'd prefer. Relevant Skills and Experience I am familiar with this Daha Fazla

in %bids___i_period_sub_35% gün içinde333%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)
2.7
bturner7

--------------------------Professional Excel VBA Expert! Best Result in Time!---------------------- Relevant Skills and Experience Dear sir. I read your project description very carefully. I've really rich experience Daha Fazla

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
elwagner3000

Hello, I have the knowledge as well as the resources to work your project. Stay tuned, I'm still working on this proposal.

in %bids___i_period_sub_35% gün içinde340%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
Shohidullahpk

Dear, I am shohidullah very interest about your [url removed, login to view] u sir

in %bids___i_period_sub_35% gün içinde266%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
VladislavS6

I can make a tool to check the result test via excel VBA or Python, which will be linked to data in the .xlsx file Cheers! Stay tuned, I'm still working on this proposal.

in %bids___i_period_sub_35% gün içinde333%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
jeffersonroth

Many thousands of hours and tons of projects developing tools using VBA + Excel. Main areas: statistics, web automation, APIs consuming, data validation, Dashboards, Reports... Stay tuned, I'm still working on this p Daha Fazla

in %bids___i_period_sub_35% gün içinde560%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0