Find Jobs
Hire Freelancers

Excel Macro to Clean Company Names

£10-15 GBP / hour

Status
Publicerad över fem år sedan

£10-15 GBP / hour

We are looking for someone to aid with cleaning company names in a database that contains approximately 45,000 unique company names. We have identified several rules that we would like to be able to apply to the work. To provide some context, we would be looking for someone to help clean up our marketing database. At present we have carried out any company name standardisation by a large vlookup table. Any new raw names are first checked against this to see if we have come across them previously. If not, we then try to apply fuzzy logic to assign them to previously identified company names. Thirdly, if we still cannot identify them, we will highlight the blanks, sort the company names a-z and assign them manually. One of the major problems we have identified is the lack of pre-assigned rules and several different people undertaking the cleaning process. Consequently, people have applied their own logic to the cleaning process, meaning that we often have been left with multiple derivatives of the same company name – this will have a negative impact on our marketing processes. We have identified this as a suitable time to try and undertake a major clean on the database and the process by which we assign the company names. At present, we are finding it difficult to identify whether there is any automated process (such as a macro) which we could utilise to minimise the amount of manual work within the team. Therefore, we'd like to freelance the problem to see if this is possible. Attached are the rules we are looking to apply to the database, if this is possible. All company names would have to be identical to the point where a vlookup table would work.
Project ID: 18008457

Om projektet

40 anbud
Distansprojekt
Senaste aktivitet fem år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
Tilldelad till:
Använd avatar
Hello! My name is Paris and just had the chance to read your project's brief. I was very excited that you mention Microsoft Excel because this is my favorite field and MS Excel projects are among the tasks I work with regularly and know exactly how to handle them. You mention that you need somebody to apply VBA code that will clean up your records in an effective and consistent way. I'm a very experienced and skilled MS Office developer as you can easily check for yourself. You're welcome to visit my personal page on this platform and get an idea of who I am and what services I deliver to my clients. I'm looking forward to hearing from you. Sincerely, Paris Pallas
£15 GBP Om 3 dagar
4,9 (159 omdömen)
6,8
6,8
40 frilansar lägger i genomsnitt anbud på £13 GBP/timme för detta uppdrag
Använd avatar
This is Vibrant Webtech and I was glad to see that you're looking for help for project Excel Macro to Clean Company Names. I've delivered more than 400 + projects in the last 5 years and this makes me very confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon.I have more than 5 year of experience in Data Processing, Excel, Excel Macros, Excel VBA. Please ping me for more discussion.
£15 GBP Om 40 dagar
4,9 (288 omdömen)
7,7
7,7
Använd avatar
Hi there, I can create excel macro to clean company names. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
£10 GBP Om 40 dagar
4,9 (296 omdömen)
7,7
7,7
Använd avatar
"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. "
£20 GBP Om 40 dagar
4,9 (178 omdömen)
6,6
6,6
Använd avatar
Dear client I would like to discuss with you about your requirements. Kindly contact me for further details and discussion. Roy
£16 GBP Om 20 dagar
4,9 (283 omdömen)
6,6
6,6
Använd avatar
Hello, I have read and understood what has to be done in this task. I have sound experience in performing such kind of work as I have done lot of project of similar kind in the past. I think I can assist you in getting this task done with more focus on quality and getting it delivered on time. Hoping to serve you in the best possible manner and completing it to your level of satisfaction. Looking forward to work for you. Hope to hear from you. Have a nice day. Regards, Nidhi
£13 GBP Om 40 dagar
4,8 (93 omdömen)
6,0
6,0
Använd avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Sure. Willing to take up your project. Thank you, Regards.
£15 GBP Om 20 dagar
5,0 (68 omdömen)
5,9
5,9
Använd avatar
Completed numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. You can refer my freelancer profile for reviews and completed tasks: https://www.freelancer.com/u/kevivu.htm Out of my 75 projects, almost 70+ are complex VB/VBA/.Net/Webscrapping projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex Webscrapping (Amazon / Aliexpress / eBay), VBA projects, viz converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc.
£10 GBP Om 3 dagar
4,8 (70 omdömen)
5,7
5,7
Använd avatar
Hello, I can assist you in best way, I have good experience in many type of jobs. I am good in internet research and spreadsheet task. Would like to do some samples to gain your confidence. Let's initiate chat and discuss together. Best Regards, Prakash
£10 GBP Om 40 dagar
4,8 (38 omdömen)
5,0
5,0
Använd avatar
Hi - I am an IT professional with 2 decades of experience. I have 2 patents in US. As far as excel is concerned i am quite well versed with the technology which i have mastered over 2 decades. I can handle simple excel with formulas to complex power pivots with macros with ease. Having worked for customers like Apple, Microsoft, Boeing, TI for most part of my career I am quite seasoned with professionalism and specificity in term of solutions. Give the task to me and rest assured that you are in safe hands.
£13 GBP Om 40 dagar
4,9 (24 omdömen)
4,6
4,6
Använd avatar
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of cleaning the database and manipulating strings. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra
£10 GBP Om 40 dagar
4,8 (49 omdömen)
4,8
4,8
Använd avatar
Greetings for the Day!!! I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details .Thank you :)
£16 GBP Om 40 dagar
5,0 (51 omdömen)
4,7
4,7
Använd avatar
"Hello Dear, Happy to inform you that I'm an efficient Web Researcher and Data Entry Worker. I've reviewed you project current project. I am able to visit the Organization’s website and research them. After all that put the required information (including email) into Excel file. I have already successfully completed some research and email lists collection projects. I’ve strong portfolio. If you consider me for this project, I will try my level best to complete your task within our committed deadline. I look forward to hearing from you about the project. Regards "
£11 GBP Om 40 dagar
4,9 (17 omdömen)
3,9
3,9
Använd avatar
Hi, I am an Excel Expert with very good knowledge of VBA. I can do this task. Please come on chat for more details. Thank you Awaiting your response.
£11 GBP Om 40 dagar
4,4 (38 omdömen)
4,4
4,4
Använd avatar
Hi, I think you just found the right candidate here! I will make sure to deliver the best as per your Requirements. I am an experienced content writer, web researcher, web scraper, internet marketer, Link builder and data entry operator have enough experience to deliver you the best.
£10 GBP Om 40 dagar
4,1 (16 omdömen)
4,3
4,3
Använd avatar
Dear sir/madam - Thanks for posting the project and also posting the details to such a low level, appreciate it very much. Please see my responses below with comments or questions, please note that they are marked with [RF] " We are looking for someone to aid with cleaning company names... [RF] - Understood. To provide some context... [RF] - Understood. At present we have carried out... [RF] - Question: Is it possible to send a cross-section of the existing file as a sample to help understand this better? One of the major problems... [RF] - Once macros is applied and certain columns of fields are locked, different people impacting the data should reduce. " I also went through the rules list document, and there are some upfront questions or my understanding on them. " 1) Company Name Abbreviations (RF: can be done with a database 2) Large Companies with Multiple Sub-Divisions (RF: Question - Does this mean a single company can have two names with sub-divisions, and both are treated as unique company?) 3) Raw Company Names which include their country (RF: Understood and can be managed with a database) 4) Removal of additives at the end of company names (RF: Understood) 5) Keep all numbers and change all written out numbers into text (RF: Understood) 6) Change all erroneous characters to the standard alphabet. (RF: Understood) 7) Delete all illegible company names (RF: Understood) " Please let me know if any questions for me. Looking forward. Regards RF
£16 GBP Om 40 dagar
5,0 (10 omdömen)
3,2
3,2
Använd avatar
Hi,I have read your requirements of Excel Macro to Clean Company Names and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude.I am very keen to discuss further. You can reach me at any time on online . I have also a few clarifying questions on the project.I’m an Expert, Honest, Sincere, Quick learner and Responsible worker as I’m taking my work like my Responsibility. kind regards.
£12 GBP Om 41 dagar
5,0 (4 omdömen)
3,0
3,0
Använd avatar
y name is Esteban, I'm an industrial engineer and Excel/VBA Expert. I'm new freelance,You can see some of my experiences in my profile. I could also help in economic analysis and evaluations, based on regression studies and statistical estimates. I would love to help you in your project and that you can help me earn more points!! It must be done with macros, because the formulas take up a lot of memory and will make a slow and inefficient process
£10 GBP Om 40 dagar
5,0 (6 omdömen)
2,5
2,5
Använd avatar
I have a good experience in VBA Automation and Excel formulas. I can also do dashboarding and problem solving using excel. I have also worked with marketing for lead generation using web scraping.
£11 GBP Om 40 dagar
4,8 (2 omdömen)
2,6
2,6
Använd avatar
Hi, nice to meet you. I have read your description. I would like to have conversation with chat to get more about your project. Thanks.
£10 GBP Om 40 dagar
5,0 (2 omdömen)
1,7
1,7
Använd avatar
Very interesting job, I can do it! I would need to see the data base or part of it to estimate working time required. Some human validation would be required since we don't have full replacement rules. This could be performed by a list of outliers which don't clearly fall into replacement rules but are closely related. i.e. country name replacement could be done if names are not preceded by a preposition and considering as outliers when names are first word of the company (such as "America National Bank") and if some companies were registered with country name first. This was an example to illustrate the need for outlier checking and a basic country processing rule. I would also provide a log of modifications with original data base and changes performed if any. This would serve for debugging and for you to perform spot checks. As for applying Fuzzy Logic, some other AI as Neural Networks, would be applied only if conventional programming can't do the task. Also these algorithms would probably need to be coded in Python. I'm an engineer with advanced working knowledge and experience in Excel VBA and VBA interaction between different software (Word, Excel, PowerPoint, access, AutoCAD etc.). Proficient coder in VB.Net, C#, Python, VB6. Communication won't be an issue because I was raised in USA (Charlottesville Virginia) so English is my second mother tongue and I have IELTS certification with global score of 7,5 over 9.
£15 GBP Om 40 dagar
5,0 (1 omdöme)
1,4
1,4

Om kunden

Flagga för UNITED KINGDOM
Bournemouth, United Kingdom
0,0
0
Verifierad betalningsmetod
Medlem sedan okt. 22, 2018

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.