Data Model: Create new columns based on comparison of free text field to lists of values.

$30-250 USD

已关闭

已发布

超过 3 年前

$30-250 USD

货到付款

In the attached Data Model: Sheet 1, “Harvest”, consists of 7,000+ time entries and includes a free-text Notes field. This sheet is updated weekly. Sheet 2, “Lawyers” contains a list of 800 names in “LastName, FirstName” format Sheet 3, “IPGs,” contains a list of 49 practice groups in “full name” and “acronym“ columns. I need a formula to create columns for “Lawyers” and “IPGs” in the Harvest sheet so that I can add these two sheets to my data model The formula for the IPG column will scan the Notes field against the “acronym” column of the IPG sheet. If it finds a string match in the notes it will enter the “full name” of the respective IPG in the cell. Similarly, the formula for the Lawyers column will scan the Notes field against the name column of the Lawyers sheet. If it finds a string match in the notes it will enter the name of the respective Lawyer in the cell. The IPGs and Lawyers sheets would then be added to the data model , and relationships would be established between these sheets and the new fields in the Harvest sheet Ideally these formulas would be done as data transformations in Power Query, so they would be automatically applied to my data model when the Harvest sheet is updated. If that’s not feasible I am OK with entering them manually in the updated Harvest sheet before it is brought into the data model.

Excel

Data Analytics

项目 ID: 28347829

关于此项目

18提案

远程项目

活跃3 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

18威客以平均价$128 USD来参与此工作竞价

@schoudhary1553

Hi, Greetings! ✅checked your project details: Data Model: Create new columns based on comparison of free text field to lists of values. ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast

$220 USD 在4天之内

4.9

(374条评论)

8.1

@Devrits

Hi Hiring manager I am IT professional with 23 years of experience implementing software solutions for clients prior to becoming a freelancer. In my career I have worked in all phases of the software development life cycle (SDLC). I'm a problem solver with good communication skills. I have worked with clients at all levels. I bring this wealth of experience to my clients to effectively and efficiently deliver spreadsheet-based solutions to improve their business processes and save them time. Areas of proficiency and experience: - Complex Formulas (including Array Functions) - Advanced Lookup (including lookup on multiple values/fields) - Dashboards and Data Visualization - Power Query / Data Transformation and Loading - Complex Conditional Formatting - Performance Tuning - Data Validation - Tables and Pivot Tables - Charts - VBA/Macros - User Forms / Input Parameters - Helper Columns Notable Projects: - Automated payroll processing - Dashboards of varying complexity - Data analysis and survey charting - Stock Market Portfolio/Trade tracking (including equities, options, and futures) - Fulfillment/Sales/Inventory (e.g. amazon) - Modeling - Monte Carlo Simulation - Estimation/Invoices Thanks

$250 USD 在5天之内

4.9

(61条评论)

6.1

@WycOj

Data Model: Create new columns based on comparison of free text field to lists of values. EXPERT IN EXCEL Dear client, I can help you with your project of data entry in excel, VBA, excel macros, VB, building an excel file, excel dashboard, pivot tables, charts, v lookup, word, excel database, and Microsoft office at large

$30 USD 在1天之内

5.0

(22条评论)

4.3

@realtechsl

Hi, I have Expertise in data analysis and data modeling. with over 7 years of experience in advance excel i can do the required as per the description. I have downloaded the file as checked it thoroughly Regards

$30 USD 在7天之内

5.0

(7条评论)

3.5

@mumarsami

I am senior IT professional with over 15 years of experience with databases and data warehouses. As per your project description I have all the required skills and experience. If you hire me I will be able to do all your assigned tasks as per your expectations. In case of any concerns please feel free to discuss. Regards

$250 USD 在7天之内

4.6

(1条评论)

2.6

@chnsci

Greetings, I think here you are looking for someone to create new columns based on comparison of free text field to lists of values. I have seen the attached file and understood your project description. I am an expert in Data Entry, Excel, Word, Web Search, and I am interested in your project. I am confident that I can do this with 100% accuracy and ready to start now! But I want to know more about your project. So, can we discuss more? Regards.

$110 USD 在4天之内

5.0

(4条评论)

2.3

@globalgo

Hi, How are you today? Thank you for posting this project, and I'm very happy to bid your project. I've read carefully your project details. I have rich experiences related with your project.... Your satisfaction with the project is my top priority! If you give me a chance to work with you, then I will do my best to reach your requirements. I'm waiting for your kind response. Please send msg over chat. Let's go. I will do my best for you. Best Regards.

$100 USD 在3天之内

4.7

(6条评论)

2.2

@technonazmul

Hi, I have read your job description and I think I am a perfect fit for your project. I can provide you with the best results in no time. Inbox me to discuss further it. Kind Regards Nazmul

$140 USD 在7天之内

0.0

(0条评论)

0.0

@ABVConsulting

Hey there! I'd like to express my interest in your project requiring some modifications to your existing Excel worksheet. Thanks for providing clear, detailed instructions on your requirements, as well as providing us with your existing worksheet. Consequently, I was actually already able to complete the work you've requested. Please don't hesitate to reach out if you are interested in my proposal, as I would love the opportunity to chat further about this. Thanks for your time! Alex

$45 USD 在1天之内

0.0

(0条评论)

0.0

@chetankharpuse

Hello, I have completely understood your post where in excel sheet you want to make some formulas similarly in IPG column & Lawyer columns and also you want relationships between these sheets and the new fields in the Harvest field. I am very much confident to reach your expectations & give you 100% result. I'm ready to start right now and if you need any samples let me know. I am waiting for your quick positive reply.

$40 USD 在2天之内

0.0

(0条评论)

0.0

@suvamsarkar0707

Hallo sir, I am Suvam Sarkar, I read that project very carefully. If you want to see who have a best project experience in this field be sure to contact me. And this is my fast project I will give my best to get fast review of my fast project. Thank You.

$100 USD 在3天之内

0.0

(0条评论)

0.0

@shahadath16

Dear sir, Greeting, Old account has been closed new account start work. I'm so interested in your project. Already our team finished many similar projects. Give me chance send sample for you. The work will be absolutely perfect and sound which can able to make you 100% satisfactory. Sincerely sumon

$140 USD 在7天之内

0.0

(0条评论)

0.0

@Dmasyithah95

Handle the staff including manage related to staff which is, handle human resource task as a handle staff card, recorded sick leave of staff. I also manage staff allowance, create every official letter that required from manager and also do every task company including filing, handle every license company and etc related to administration management.

$140 USD 在7天之内

0.0

(0条评论)

0.0

@AlomdaElmasry

Hi There, Thanks for your posting. I read your posting carefully. I have full experiences in Excel, Data Entry, Data Processing. Data Analytics and Web Scraping. I am here at your service. Feel free to Contact me anytime to discuss our project. Thank you! Have a good day, Emad Tolba

$125 USD 在4天之内

0.0

(0条评论)

0.0

@farzana0

I read your project. It is very simple work. I interest in your work. I want to get the job done. I can complete your project on time and within your budget. I have Experience in Excel, Word . I can type 100 words per minute which should be considered as a huge achievement. This skill is also helpful for Data Entry because in this field a data entry operator has to deal with a large amount of data including alphanumeric data also. I would like to mention some of my skills that will be also helpful for your project.

$30 USD 在1天之内

0.0

(0条评论)

0.0

@syedekhlas

Hello sir, I read your project that I possess the necessary skills and experience. You are seeking and would make a valuable addition to add this model in your company. I have the required background, related concept to perform this role. Let me know to hear from you soon to do this job. I am also trying to develop your project depending on the attached data sheets.

$140 USD 在7天之内

0.0

(0条评论)

0.0

@richardlenny

Hi sir, May i have more details on the job? I like to know how many hour/weeks/months are you looking to hire and what industry is your business. Nonetheless, i believe my english proficiency and experience will allow me to finish this job at the right time. I can assure you that i can give you a perfect work. Dont hesistate to contact me. Thank you, Lenny richard

$140 USD 在7天之内