Create Excel macro that searches a large amount of data using Binary Tree structure (read fully)

Chiuso Pubblicato 4 anni fa Pagato alla consegna
Chiuso Pagato alla consegna

We have a few functions that leverage large sets of data (11,000 locations being the largest).

String searches WILL NOT WORK and will be too slow. You must put all locations into a binary tree or similar structure for it to be efficient enough for the functions to work. If you have not implemented a binary tree or are not proficient in optimizing code: DO NOT BID.

Here are the details.

Implement excel functions to clean a company name and extract information from a company name. Functions are simple. The logic will use lists of keywords we provide

Conversion includes

General format

-Collapse initials

-Remove punctuation

-Remove leading, trailing and extra spaces

Suffixes

-Remove unless without suffix, company is only 1 word. We will provide a list of suffixes that is expected to be added to. (example: inc, llc, corp, group, systems). Final list will be hundreds long to plan code efficiency for it

NoteWords

-Remove NoteWords: NotesWords are text that appears after key words. Example: Skype (acquired by Microsoft). “acquired by” is a key word. “Acquired by Microsoft” would be removed. The list of key words list will be hundreds long to plan code efficiency for it. (formerly, acquired by, division of, etc)

Locations

-We have a list of locations, that should be removed from the company name. Location should be removed if in parenthesis or following a delimiter (example: Fun Systems - Los Angeles would be “Fun Systems”. The list of location will be thousands long so plan code efficiency for it.

Acronym

-Compare words in company name and remove acronym. There will be a list of “skip” words that are not considered part of Acronym (of, the, a, for, etc). Example: "National Association of Developers (NAD)" would become "National Association of Developers"

The Main Function will be called CompanyCommon()

In addition, we need functions that can extract the above information using the same code base.

GetNoteWord()

GetLocation()

GetAcronym()

See screenshot for before/after examples. We will provide lists of Suffixes, NoteWords, and Locations to the winning bidder.

To show us that you have GREAT attention to detail and that you read this posting. Put the name of your favorite animal as the first word in your bid

When this is done, we want to convert the functions to also use in Google sheets, let us know if you can also do that.

Good luck

Excel Visual Basic Architettura Software Excel Macros

Rif. progetto: #23972040

Info sul progetto

10 proposte Progetto a distanza Attivo 4 anni fa

10 freelance hanno fatto un'offerta media di $53 per questo lavoro

schoudhary1553

Hello, I can help you with your project - Create Excel macro that searches a large amount of data using Binary Tree structure I have gone through your job posting and become very much interested to work with you. I a Altro

$180 USD in 3 giorni
(372 valutazioni)
8.0
satishtl

DOG Hi, Went through the description, simulating binary tree for searches. - Cleaning up of company names using the conversion logic provided, suffixes and keywords replacment. - Will also look at the existing functio Altro

$30 USD in 5 giorni
(52 valutazioni)
6.0
IshaqKN

Hi there, Yes! Let me handle your task using Python. I'm expert in data processing and regex. Have strong command over excel in Python. Code will not take longer to complete the process. I'll deliver standalone CLI a Altro

$30 USD in 2 giorni
(20 valutazioni)
4.3
DRG1990

Hello I am expert in Excel and Excel macro, Excel VBA. So I am confident in and I am interested in your project. If you choose me, I will best my best for you. Best Regards

$20 USD in 1 giorno
(5 valutazioni)
3.9
efedriko1234

Hello from Australia. Honest and reliable company delivering on-time and at a low cost. Why us? 1) Same or lower prices than individual developers. 2) Quality service and great communication skills 3) Large pool of hu Altro

$30 USD in 7 giorni
(3 valutazioni)
2.6
jbayton2492

Elephant. Hello there I can help you with your project but I would like to recommend using another tool whith would be better, faster and can give you an input to work with the results in any platform. Let me know if Altro

$40 USD in 5 giorni
(3 valutazioni)
2.4
dvdalon

camel Well, realistically, the number of things you need to have done cannot be accomplished profitably for your $30 upper limit. If you supply the source file, or at least a subset of it, I will take a look and estima Altro

$100 USD in 14 giorni
(2 valutazioni)
2.1
themuntaha

Dear employer! I am computer system engineer and have expertise in MS excel as well. I aim to provide you satisfactory results based on your requirements. Please message me for further details. Thanks

$50 USD in 3 giorni
(2 valutazioni)
2.1
majeeddarakhshan

I will do my best Relevant Skills and Experience Data processing expert

$23 USD in 1 giorno
(0 valutazioni)
0.0
sandramhla

Horse. Sure I can implement binary search using VBA. Not sure if this can be translated to google sheets but I can check that (to be honest, I never developed in google sheets and I wasn't aware it was possible). I re Altro

$25 USD in 7 giorni
(0 valutazioni)
0.0