User Defined Excel Function for text categorisation
€30-250 EUR
Completed
Posted over 8 years ago
€30-250 EUR
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
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
5.0 (777 reviews)
8.6
8.6
45 freelancers are bidding on average €104 EUR for this job
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 details.
I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including creating user-defined functions through vba coding (macro), all achieved with 5/5 rating.
Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too...
I am ready to prepare a template for you to check, once you five me a reply...regards.
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 than 1 day. Also feel free to discuss in French if you want. Thanks
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 help You with this project.
If You need somebody who can manage really difficult thing, I am right person, I am not guy who use recorded or stolen scripts, i have good background in VBA, and all my scripts work with 100% accuracy and performance.
Hope for Your respond,
Regards,
Vlad.
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
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
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 regards
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 - Gaza. The attached image is screen shot for Add-in for Excel to integrate Excel with another application called MetaTrader4 to allow the users to trade from within Excel. This project is complicated and deal with many technologies and fields like calling underlying layer for communications and graphics to have dynamic charts and link to MS Access to store the actions by the user and finally controlling MetaTrader from Excel.
I am ready to discuss and doing your project.
Regards,
Eyad
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.
Waiting for your positive response.
Thanks.
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 with me, to test pilot solutions if necessary in order to achieve an optimal final solution.
Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees.
I have great experience in any kind of data manipulation with Excel/VBA. I can start working on the project immediately and complete the job within some hours.
Regards
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 word1 and the secondary word2 in order to have the ability to use it by calling the function by iteration (i, j)
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
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 Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura