User Defined Excel Function for text categorisation

Completed Posted Nov 26, 2015 Paid on delivery
Completed Paid on delivery

We want to build a user defined function for text categorisation that does the following:

- Looks into a text string,

- Finds the presence of words in the text tring

- Words to be found are among a Data base of words,

- Each word of the list is associated to other words

- The function returns 1) The word(s) found in the texted string 2) the associated word(s)

Example:

Text string: "Alice runs in the woods and falls into a hole"

Word Data Base:

(...)

Alice: story, rabit, disney...

Wood: nature, trees...

(...)

Function(TextString, Word1) = Alice

Function(TextString, Word2) = Wood

Function(TextString, Word1, Associated1)=story

Function(TextString, Word1, Associated2)=rabit

Function(TextString, Word2, Associated1)=nature

Function(TextString, Word x, Associated y) = z

!!Specials:

- The list of words and associated words have to be inputable in colums (i.e the dictionnary is in a excel sheet, not hard coded in the function)

- The function should be more effective and less calculation consuming than the use of sheet unsing multiple search() functions on each word

Excel Visual Basic

Project ID: #8976739

About the project

45 proposals Remote project Active Dec 1, 2015

Awarded to:

jaylancer43

Hello Sir, Thanks for the prospect project and I would like to work on the same. I believe have placed a justified bid on the same. As you know well, you can pay me only when your job is 100% done. Thanks, Jay

€60 EUR in 3 days
(777 Reviews)
8.6

45 freelancers are bidding on average €104 for this job

seaanddream

Hi, my name is Sevinc. I read your excel function project descriptions carefully before bidding. I checked your requirements, and I got what you need. I am ready to go ahead as soon as we can clarify further project More

€75 EUR in 3 days
(288 Reviews)
7.9
Khurramz

Hi! Do you want the function in excel ? If yes, I can start working right now to finish it ASAP. Regards

€30 EUR in 1 day
(373 Reviews)
7.5
bouslimi1979

Hi, I ll code these function in an Excel VBA macro. I need just a sample file. And yes the words will be in the workbook not hard coded. So the macro will work for any number of words. I can start and finish in less th More

€55 EUR in 3 days
(292 Reviews)
7.7
Vlzinch

Hello! I work with VBA for last 5 years and have created hundreds of different scripts, including different data analitycs tools,DashBoards and Userforms. Just send me your requirements and i will be happy to hel More

€95 EUR in 3 days
(67 Reviews)
7.4
prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sincerely Prameswara

€30 EUR in 1 day
(380 Reviews)
7.3
khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India

€150 EUR in 3 days
(276 Reviews)
7.1
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regard More

€66 EUR in 3 days
(267 Reviews)
7.1
zebracaro

I can do it for you quickly and exactly

€70 EUR in 2 days
(127 Reviews)
7.1
someka

I can build the custom function for your VBA need. Just drop me a message and we start asap.. Thanks...........

€210 EUR in 3 days
(142 Reviews)
7.1
esalem

Hi, I am VB and GIS developer and well versed in Excel and programming of Excel using VBA or even developing Add-in for Excel using VSTO of .NET. I gave also courses in Excel for UN employees here in Palestine - Gaz More

€473 EUR in 7 days
(23 Reviews)
6.9
aarifakhtar

Hi: Please note that over 90% of my completed projects are related to Excel. Moreover, I have 100% completion rate and 5-star feedback on projects.

€34 EUR in 1 day
(170 Reviews)
7.0
svet63

A proposal has not yet been provided

€250 EUR in 5 days
(80 Reviews)
6.7
katilinas

Hi! I am a new freelancer specializing in Excel, I want to earn a good reputation with you!

€88 EUR in 5 days
(120 Reviews)
6.5
gokulanand

Hello I can get you this task implemented using Excel VBA in the next 12 to 24 hours. Do let me know if you are interested. Thanks

€50 EUR in 0 days
(113 Reviews)
6.1
macroPOL

Nie złożono jeszcze oferty.

€100 EUR in 3 days
(97 Reviews)
6.1
dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 260 projects. Please look at the feedback left by my employers to know more about my work. Wai More

€100 EUR in 15 days
(120 Reviews)
6.3
nagybatonyi

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details More

€30 EUR in 1 day
(63 Reviews)
5.7
ricardoba13

I may code the function in order to return an array where you can choose the main word and the secondary ones just using something like =YourFunction (TextString, MainWords, Secondary) (1,2) that will return the main w More

€111 EUR in 2 days
(19 Reviews)
5.7
jawadaman

Hi I am interested in this project. I am an experienced VBA developer. I can do this job for you. If interested in hiring me then please let me know so that we can discuss it further. Thanks Regards Jawad

€55 EUR in 3 days
(51 Reviews)
5.3
zu02

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Acc More

€155 EUR in 3 days
(32 Reviews)
5.8